Find Jobs
Hire Freelancers

Need openvpn-install.sh bash script modification

$10-60 USD

In Progress
Posted almost 6 years ago

$10-60 USD

Paid on delivery
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.
Project ID: 17354805

About the project

4 proposals
Remote project
Active 6 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
4 freelancers are bidding on average $76 USD for this job
User Avatar
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
$39 USD in 15 days
5.0 (2 reviews)
2.1
2.1

About the client

Flag of UNITED STATES
Prescott, United States
5.0
41
Payment method verified
Member since Jun 5, 2016

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.