Completed

Need [login to view URL] bash script modification

Must know MariaDB and fully understand the OpenVPN bash script, openvpn-install.sh.

Need to modify the script so that when we add/remove clients, that information is updated in a DB table.

Adding

-Look in the DB to see if that client ID already exists, if it does, prompt for new name

-If not exist, enter client ID, NAT IP assigned, date/time and maybe some other details.

Removing

-Look for matching client/id in DB and remove it from the table.

When the script ends, I I need to run one more command which is to copy the cert to another server. I already have that script so just need to know where/how to include this in the openvpn script so that it will run only when adding/removing clients.

Table: one_vpn_client

id auto increment

In order to automate this, I need to be able to enter the client id as a value.

Something like; [login to view URL] id

If id exists, return an error 'id exists' for example, otherwise, create it.

Skills: Linux, MySQL, OpenVPN, Shell Script

See more: i need someone to install paidtoclick script in my website, openvpn bash script automate certifictate generating, bash script install joomla, sql, openvpn bash script, bash script install openvpn, write bash script install teamviewer, joomla install bash script, bash script openvpn, install bash script ubuntu, bash script install automatically joomla, bash script install mail server, need someone install php script website, need someone install script, linux bash script insert_record sh, need freelancer install script website, mysql install bash script, script modification, install ppvchat script, need information add video script

About the Employer:
( 19 reviews ) Phoenix Area, United States

Project ID: #17354805

Awarded to:

vmuganga

just for rating.

$15 USD in 1 day
(1 Review)
0.0

7 freelancers are bidding on average $66 for this job

$100 USD in 2 days
(38 Reviews)
5.3
ikorolev

Hello I did similar tasks many times, you can look to one of my project [login to view URL] Stay tuned, I'm still working on this proposal.

$100 USD in 3 days
(5 Reviews)
3.8
$55 USD in 1 day
(1 Review)
1.9
mihajlomilenovic

Need to see the script, and infrastructure, then modify script as per requirements to do the stuff you want. Relevant Skills and Experience I am very proficient with all the technologies mentioned and can help you wit More

$40 USD in 10 days
(1 Review)
0.6
onedirecttech

Hi Sir I hope you are doing well. I am Kamal Mehta. Relevant Skills and Experience I have been working in bash shell scripting since 12 years now,. However, I have not worked in MariaDB you want but I have worked in v More

$39 USD in 15 days
(1 Review)
0.8
$111 USD in 10 days
(0 Reviews)
0.0