Issue #2918

How to store multiple clients credentials in mysql database?

Added by sahibzada fahad 6 months ago. Updated 3 months ago.

Affected version:
No change required


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.


#1 Updated by Tobias Brunner 6 months 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 6 months 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 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

#3 Updated by Tobias Brunner 6 months 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.

#4 Updated by Tobias Brunner 3 months ago

  • Status changed from Feedback to Closed
  • Assignee set to Tobias Brunner
  • Resolution set to No change required

Also available in: Atom PDF