UBUNTU 16.04 - OPENVPN 4.3 Server MYSQL AUTH Plugin -- 2

Kapalı İlan edilme: 6 yıl önce Teslim sırasında ödenir
Kapalı Teslim sırasında ödenir

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

C Programlama C++ Programlama MySQL Yazılım Mimarisi Ubuntu

Proje NO: #14939384

Proje hakkında

11 teklif Uzak proje Aktif 6 yıl önce

Bu iş için 11 freelancer ortalamada €381 teklif veriyor

zainy01

Hi! I've seen your requirements and tons of experience in developing/customizing wp plugin and themes, I'm top expert in in developing/customizing wp widgets and plugins such as storelocator, sliders with backend manag Daha Fazla

€700 EUR in 10 gün içinde
(40 Değerlendirme)
7.0
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 Daha Fazla

€333 EUR in 3 gün içinde
(46 Değerlendirme)
6.2
vietdevteam

I have read your project. I'm sure i can help you to do it. I have 7 years of experience in Web Development, System & Network Administrator and Security Researcher. Choose me then you will work with a Professiona Daha Fazla

€250 EUR in 5 gün içinde
(38 Değerlendirme)
5.6
talhamq

A proposal has not yet been provided

€251 EUR in 0 gün içinde
(28 Değerlendirme)
4.1
cjconstante

Hi. I am a system administrator security focused with several openvpn implementations for government and private companies. Even yestarday i configured something as you need. I can provide you a solution for your requ Daha Fazla

€260 EUR in 2 gün içinde
(6 Değerlendirme)
3.6
JamesQuiroz

Hi James here, I hope you will consider me for your project. I will assure you a quality end product at a competitive price. I know you will be swamped with bids so thank you for the time. Hoping to hear from you soon Daha Fazla

€555 EUR in 5 gün içinde
(0 Değerlendirme)
0.0
ticpavlin82

Hi! I am very experience Linux system administrator, with 15+ years of experiences, but please check out my profile for more about me. I can provide you with set of scripts/config files for OpenVPN authenticatio Daha Fazla

€555 EUR in 5 gün içinde
(0 Değerlendirme)
0.0
ichthyocentaurs

Hello! Very interesting project for me! I will be extremely happy if I have the opportunity to implement it! Your project implies the C plugin, but I also should note, that the same task can be accomplished with scr Daha Fazla

€275 EUR in 10 gün içinde
(0 Değerlendirme)
0.0