UBUNTU 16.04 - OPENVPN 4.3 Server MYSQL AUTH Plugin -- 2
€250-750 EUR
ชำระเงินเมื่อจัดส่ง
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}}'
หมายเลขโปรเจค: #14939384
เกี่ยวกับโปรเจกต์
freelancer 11 คน กำลังเสนอราคาในงานนี้ โดยมีราคาเฉลี่ยอยู่ที่ €381
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 เพิ่มเติม
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 เพิ่มเติม
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 เพิ่มเติม
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 เพิ่มเติม
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 เพิ่มเติม