How to store multiple clients credentials in mysql database?
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 2 months ago
- Category set to configuration
- Status changed from New to Feedback
- Priority changed from High to Normal
#2 Updated by sahibzada fahad 2 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 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 2 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.