Đã Đóng

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

Kỹ năng: Lập trình C, Lập trình C++, MySQL, Kiến trúc phần mềm, Ubuntu

Xem thêm: 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

Về Bên Thuê:
( 0 nhận xét ) Otzberg, Germany

Mã Dự Án: #14828130

15 freelancer đang chào giá trung bình €141 cho công việc này

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 Thêm

€155 EUR trong 3 ngày
(33 Đánh Giá)
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 Thêm

€123 EUR trong 3 ngày
(34 Đánh Giá)
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 Thêm

€50 EUR trong 0 ngày
(25 Đánh Giá)
4.3
€155 EUR trong 3 ngày
(14 Đánh Giá)
4.4
kirillshilov

think i can help you. .

€155 EUR trong 3 ngày
(24 Đánh Giá)
4.5
talhamq

A proposal has not yet been provided

€39 EUR trong 0 ngày
(23 Đánh Giá)
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 trong 3 ngày
(2 Đánh Giá)
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 trong 3 ngày
(6 Đánh Giá)
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 trong 2 ngày
(2 Đánh Giá)
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 Thêm

€150 EUR trong 10 ngày
(2 Đánh Giá)
2.0
usmanhassan123

i am a software engineer.

€220 EUR trong 1 ngày
(0 Đánh Giá)
0.0
€155 EUR trong 3 ngày
(0 Đánh Giá)
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:/ Thêm

€122 EUR trong 3 ngày
(0 Đánh Giá)
0.0
mvfpseg

A proposal has not yet been provided

€30 EUR trong 3 ngày
(0 Đánh Giá)
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 trong 4 ngày
(0 Đánh Giá)
0.0