Project

General

Profile

Issue #2918

How to store multiple clients credentials in mysql database?

Added by sahibzada fahad 11 days ago. Updated 11 days ago.

Status:
Feedback
Priority:
Normal
Assignee:
-
Category:
configuration
Affected version:
5.7.2
Resolution:

Description

I have read mysql plugin documentation but it was very confusing, i want to store clients username and password in mysql database and authenticate from there.

History

#1 Updated by Tobias Brunner 11 days ago

  • Category set to configuration
  • Status changed from New to Feedback
  • Priority changed from High to Normal

What exactly confuses you? Did you read SQL and the table description? Did you have a look at the example scenarios? (The data.sql files for the latter can be found in the repository: source:testing/tests/sql)

#2 Updated by sahibzada fahad 11 days ago

I have username and password in ipsec.secrets file forexample
client1 : EAP "client1password"
client2 : EAP "client2password"

it is working fine when i connect client to the server.

When i add these usernames and password in mysql database in identities, shared_secrets and shared_secret_identity table it does not work and does not connect client to server.

but when i add domain for example ikev.whizpool.com in identities table and shared secrets then it allow client to connect to server.

now my question is how to store multiple clients username and passwords in mysql database which work for multiple usernames and passwords not only for ikev.whizpool.com

#3 Updated by Tobias Brunner 11 days ago

Read the documentation and do it as described (e.g. use the id2sql script to convert the usernames). If it doesn't work, read the logs etc. to find out what goes wrong and fix the database contents. If you incorrectly set up your database (e.g. didn't associate the right rows with each other) we really can't help you. You'll have to fix that yourself.

Also available in: Atom PDF