UBUNTU 16.04 - OPENVPN 4.3 Server MYSQL AUTH Plugin

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:


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}}'

Skills: C Programming, C++ Programming, MySQL, Software Architecture, Ubuntu

See more: connect to openvpn ubuntu, ubuntu openvpn server, ubuntu openvpn client gui, ubuntu 16.04 openvpn client gui, ubuntu 16.04 openvpn client, ubuntu 16.04 vpn, ubuntu openvpn client, ubuntu vpn client, ubuntu 16.04, build ubuntu 14.04.05 LTS server , Erstellen eines Pflichtenhefts, freelancer on ubuntu 16.04, erstellen eines online stores, ubuntu server mail server mysql, ubuntu mail server mysql, flash media server mysql authentication, sql server mysql transfer, smartfox server mysql, configure asterisk server mysql, openvpn getting windows server

About the Employer:
( 0 reviews ) Otzberg, Germany

Project ID: #14828130

15 freelancers are bidding on average €141 for this job


Hi I am very,very interested in your project I have 6 years of development experience such this projects. I am a highly skilled developer in C, C++, C#, Python, Java, Perl, NodeJS, Reverse Engineering etc. Also I ha More

€155 EUR in 3 days
(33 Reviews)

Dear Client, Thank you for allowing us to place a bid on your project. I have gone through your requirements and can fulfill the same. I found this quite interesting so, I consider myself as a good fit for all the More

€123 EUR in 3 days
(34 Reviews)

Hello, Greetings. Hope you are doing well. I am expertise in cloud solution of AWS, Openstack, Rackspace, Google Cloud, Azure etc. I work as cloud solution architect. I am experienced in server migration with Linux ser More

€50 EUR in 0 days
(25 Reviews)
€155 EUR in 3 days
(14 Reviews)

think i can help you. .

€155 EUR in 3 days
(24 Reviews)

A proposal has not yet been provided

€39 EUR in 0 days
(23 Reviews)

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

€266 EUR in 3 days
(2 Reviews)

i have a lot of experiences about openvpn + mysql setting. welcom u ping me i am very talented. i will wait u 24hrs.

€250 EUR in 3 days
(6 Reviews)

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.

€130 EUR in 2 days
(2 Reviews)

Hello hiring manager I read your details and I understand is that you need plugin for Ubuntu 16.04 - OpenVPN 4.3. We are expert in C Programming, C# Programming C++ Programming, Ubuntu, Machine Learning, Software More

€150 EUR in 10 days
(2 Reviews)

i am a software engineer.

€220 EUR in 1 day
(0 Reviews)
€155 EUR in 3 days
(0 Reviews)

Hello, I am a Linux expert, works with kernel module development, OS optimization, admin, web and database design, on Linux based systems. I am willing to assist you in the best way I can. my profile: https:/ More

€122 EUR in 3 days
(0 Reviews)

A proposal has not yet been provided

€30 EUR in 3 days
(0 Reviews)

Over 10+ yeas of experience on Linux, Networking and Virtualization. will provide complete documentaion/know how along with VPN configurations.

€120 EUR in 4 days
(0 Reviews)