Suljettu

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

Taidot: C-ohjelmointi, C++ -ohjelmointi, MySQL, tietojärjestelmäarkkitehtuuri, Ubuntu

Näytä lisää: 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

Projektin tunnus: #14828130

15 freelanceria on tarjonnut keskimäärin 141 € tähän työhön

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 Lisää

155 € EUR 3 päivässä
(33 arvostelua)
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 Lisää

123 € EUR 3 päivässä
(34 arvostelua)
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 Lisää

50 € EUR 0 päivässä
(25 arvostelua)
4.3
155 € EUR 3 päivässä
(14 arvostelua)
4.4
kirillshilov

think i can help you. .

155 € EUR 3 päivässä
(24 arvostelua)
4.5
talhamq

A proposal has not yet been provided

39 € EUR 0 päivässä
(23 arvostelua)
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 3 päivässä
(2 arvostelua)
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 3 päivässä
(6 arvostelua)
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 2 päivässä
(2 arvostelua)
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 Lisää

150 € EUR 10 päivässä
(2 arvostelua)
2.0
usmanhassan123

i am a software engineer.

220 € EUR 1 päivässä
(0 arvostelua)
0.0
155 € EUR 3 päivässä
(0 arvostelua)
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:/ Lisää

122 € EUR 3 päivässä
(0 arvostelua)
0.0
mvfpseg

A proposal has not yet been provided

30 € EUR 3 päivässä
(0 arvostelua)
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 4 päivässä
(0 arvostelua)
0.0