how to make linux openvpn server do its authentication from username and password stored in mysql database

Posted April 25, 2019 1.3k views
MySQLVPNUbuntu 18.04

Would like to set up a vpn server that would authenticate its users from credentials stored in a database and if possible update the database after authentication. Been researching on this concept but have not found anything reasonable. Thank you

These answers are provided by our Community. If you find them useful, show some love by clicking the heart. If you run into issues leave a comment, or add your own answer to help others.

1 answer

You’d have to write your own auth script and then include the directives in your config file:

script-security 3
auth-user-pass-verify <script> env

Then script would have to make use of the environment variables username and password and do a MYSQL lookup and return a 0/1 exit code based on the success of this lookup.


edited by MattIPv4
Submit an Answer