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.
-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.
-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.
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.