Netbeam
asked on
Need Help installing MySQL JDBC Driver on CentOS VM
I have a new test installation running SolarWinds WebHelpDesk as a virtual machine under VMware ESXi 5.1. I found this download on the SolarWinds site as "WHD-vSphere-12.0.1.25"
The installation allows one to choose between a built-in PostGre SQL database, or to use an external MySql database. I want to use the latter.
I have this database set up and hosted online at 1and1. When I try to connect to is from my WebHelpDesk, I get this error. "Unable to connect to database."
The solution, as you will read in the link above, is to install a MySQL JDBC Driver. If this were Windows or OSX, I'd be fine. But this virtual machine is running CentOS. I have access to the BASH command line, but the last time I used BASH was in college. So....
Who can help me install this driver via bash command line?
The installation allows one to choose between a built-in PostGre SQL database, or to use an external MySql database. I want to use the latter.
I have this database set up and hosted online at 1and1. When I try to connect to is from my WebHelpDesk, I get this error. "Unable to connect to database."
The solution, as you will read in the link above, is to install a MySQL JDBC Driver. If this were Windows or OSX, I'd be fine. But this virtual machine is running CentOS. I have access to the BASH command line, but the last time I used BASH was in college. So....
Who can help me install this driver via bash command line?
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Inside the gZip, inside the Tar, inside a few folders, I find a file called "mysql-connector-java-5.0. 8-bin.jar" This is the only bin.jar in the archive.
I'm assuming this is the only file I'd need to copy? There are other files you can see for yourself in the archive but it looks like the majority (10/12MB) of the archive is source file, which I won't be using hopefully - or will I need to copy the entire archive to the CentOS machine?
I'm assuming this is the only file I'd need to copy? There are other files you can see for yourself in the archive but it looks like the majority (10/12MB) of the archive is source file, which I won't be using hopefully - or will I need to copy the entire archive to the CentOS machine?
You can download it inside Centos with 'wget' -
wget http://dev.mysql.com/get/Downloads/Connector-J/mysql-connector-java-5.0.8.tar.gz
tar zxvf mysql-connector-java-5.0.8.tar.gz
cd mysql-connector-java-5.0.8
cp mysql-connector-java-5.0.8-bin.jar /usr/local/webhelpdesk/bin/jre/lib/ext
Afterward, use the cp command to copy the jar file only (The others are ReadMe, legal documents and generally necessary) to SolarWinds specified directory and restart Web Help Desk.
ASKER
Excellent! Getting there! I've successfully downloaded and un-archived the jar file. It now sits in the root directory and my command prompt says:
I ran "cd /" and found the file structure I was looking for. I navigated to the directory /usr/local/webhelpdesk/bin /jre/lib/e xt/ and tried the wget command again.
Now, it says "cannot write to mysql-connector-java-5.0.8 -bin.jar, permission denied."
Do I need to elevate my command prompt or something?
[admin@localhost ~]$
I can ls or dir and I can see my download. But I think ~ must be the temp file? There was no files or structure there.I ran "cd /" and found the file structure I was looking for. I navigated to the directory /usr/local/webhelpdesk/bin
Now, it says "cannot write to mysql-connector-java-5.0.8
Do I need to elevate my command prompt or something?
Yes you would need to change to root. Try and enter the root password -
su -
ASKER
For future reference, the full URL of today's download is:
http://dev.mysql.com/get/Downloads/Connector-J/mysql-connector-java-5.0.8.tar.gz