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

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

Kemahiran: Pengaturcaraan C, Pengaturcaraan C++, MySQL, Kejuruteraan Perisian, Ubuntu

Lihat lagi: ubuntu 16.04, build ubuntu 14.04.05 LTS server , freelancer on ubuntu 16.04, vpn, 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, replicacion sql server mysql, reddot cms site server mysql, best transfer sql server mysql, linux virtual server mysql, transfer sql server mysql

Tentang Majikan:
( 0 ulasan ) Otzberg, Germany

ID Projek: #14939384

11 pekerja bebas membida secara purata €381 untuk pekerjaan ini


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 Lagi

€700 EUR dalam 10 hari
(40 Ulasan)
€250 EUR dalam 10 hari
(104 Ulasan)
€515 EUR dalam 10 hari
(27 Ulasan)

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 Lagi

€333 EUR dalam 3 hari
(46 Ulasan)

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 Lagi

€250 EUR dalam 5 hari
(38 Ulasan)

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 Lagi

€250 EUR dalam 3 hari
(27 Ulasan)

A proposal has not yet been provided

€251 EUR dalam 0 hari
(28 Ulasan)

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 Lagi

€260 EUR dalam 2 hari
(6 Ulasan)

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 Lagi

€555 EUR dalam 5 hari
(0 Ulasan)

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 Lagi

€555 EUR dalam 5 hari
(0 Ulasan)

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 Lagi

€275 EUR dalam 10 hari
(0 Ulasan)