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.
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 various databases such Mysql, Sybase, Oracle. I can build queries.
Proposed Milestones
$39 USD - Payment after delivery