UBUNTU 16.04 - OPENVPN 4.3 Server MYSQL AUTH Plugin
€30-250 EUR
Paid on delivery
Hello, i need a Plugin for Ubuntu 16.04 - OpenVPN 4.3 Server Plugin who can select a userdatabase from a remote mysql server when the user exist it should check the secured pw then when its ok it should auth the connection otherwise it should close the openvpn and mysql connection.
When the connection user details are right it should update the mysql databse and change the user_online=0 to user_online=1.
When the user close the connection it should change the user_online to 0 and close the mysql connection.
the plugin should work so that i can change the mysql host/user/pw/db/table in a config file and the sql commands like:
hostname 1.1.1.1.1
login user
passw pass
db db
port 3306
debug_sql on
default_pf_rules_clients accept
default_pf_rules_subnets drop
auth_user_pass_verify_query SELECT username FROM user WHERE username='{{escaped_username}}' AND password='{{escaped_password}}'
auth_user_pass_verify_user_access_query SELECT username FROM user WHERE user_enable=1 AND user_online<4 AND username='{{escaped_username}}'
client_connect_query UPDATE user SET user_online=1 WHERE username='{{escaped_username}}'
client_disconnect_query UPDATE user SET user_online=0 WHERE username='{{escaped_username}}'
Project ID: #14828130
About the project
12 freelancers are bidding on average €130 for this job
Hi. I am a system/network administrator security focused. I have configured several vpn services. I can do the configuration your asking about openvpn/MySQL. I can start immediately.
Got an excellent team and my team has 7 Years of experience into C/c++ & Open CV. Can Very well Execute this project as we have already done something of this sort pk
Over 10+ yeas of experience on Linux, Networking and Virtualization. will provide complete documentaion/know how along with VPN configurations.
