Closed

UBUNTU 16.04 - OPENVPN 4.3 Server MYSQL AUTH Plugin

Hello, i need a Plugin for Ubuntu [url removed, login to view] - 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}}'

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

See more: erstellen eines pflichtenhefts, erstellen eines online stores, ubuntu mail server mysql, sql server mysql transfer, smartfox server mysql, configure asterisk server mysql, openvpn getting windows server, flash games converter softwares, replicacion sql server mysql, database softwares, softwares taurusweb, bluetooth softwares, softwares increase youtube videos, search crack softwares, yellow pages softwares, logo softwares, linux virtual server mysql, simple softwares, open source softwares, tax softwares including lacerete, transfer sql server mysql

About the Employer:
( 0 reviews ) Otzberg, Germany

Project ID: #14828130

15 freelancers are bidding on average €141 for this job

bestit4u

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)
6.0
ownmyserver

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)
4.7
neosaransh

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)
4.3
€155 EUR in 3 days
(14 Reviews)
4.4
kirillshilov

think i can help you. .

€155 EUR in 3 days
(24 Reviews)
4.5
talhamq

A proposal has not yet been provided

€39 EUR in 0 days
(23 Reviews)
3.9
MetaoriginLab

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)
3.5
victory1989

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)
3.4
cjconstante

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)
2.5
isparrowsolution

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)
2.0
usmanhassan123

i am a software engineer.

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

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)
0.0
mvfpseg

A proposal has not yet been provided

€30 EUR in 3 days
(0 Reviews)
0.0
cymbaltech

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)
0.0