Solved

Need Help installing MySQL JDBC Driver on CentOS VM

Posted on 2014-01-20
9
841 Views
Last Modified: 2016-05-29
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?
0
Comment
Question by:Netbeam
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
  • 3
9 Comments
 

Assisted Solution

by:Netbeam
Netbeam earned 0 total points
ID: 39794643
You may find this reference at Thwack of help.
0
 
LVL 21

Accepted Solution

by:
Mazdajai earned 500 total points
ID: 39798189
You can download the binary on the following url:

http://dev.mysql.com/downloads/connector/j/5.0.html

After that you can extract and copy to the webhelpdesk directory -

tar zxvf mysql-connector-java-5.0.8.tar.gz
cp -Rv <mysql-connector-java-5.0.8> /usr/local/webhelpdesk/bin/jre/lib/ext

Open in new window

0
 

Author Comment

by:Netbeam
ID: 39798413
Thank you so much! It looks like we're on the right track here. I have a problem, though. I can download the binary on my windows machine, but then how do I get it over to the CentOS machine? Or can I download it on the CentOS machine via command line?

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
0
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 

Author Comment

by:Netbeam
ID: 39798441
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?
0
 
LVL 21

Expert Comment

by:Mazdajai
ID: 39798708
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

Open in new window

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

Author Comment

by:Netbeam
ID: 39798795
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:
[admin@localhost ~]$

Open in new window

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/jre/lib/ext/ 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?
0
 
LVL 21

Expert Comment

by:Mazdajai
ID: 39800269
Yes you would need to change to root. Try and enter the root password -  

su - 

Open in new window

0

Featured Post

Save the day with this special offer from ATEN!

Save 30% on the CV211 using promo code EXPERTS30 now through April 30th. The ATEN CV211 connects a laptop directly to any server allowing you instant access to perform data maintenance and local operations, for quick troubleshooting, updating, service and repair.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
ESXi 6  Hardware Acceleration Status 19 93
Add a date range function to PDF Generation 9 40
Esxi host upgrade 16 96
veeam restore 10 74
In this article, I will show you HOW TO: Suppress Configuration Issues and Warnings Alert displayed in Summary status for ESXi 6.5 after enabling SSH or ESXi Shell.
This article shows the steps required to install WordPress on Azure. Web Apps, Mobile Apps, API Apps, or Functions, in Azure all these run in an App Service plan. WordPress is no exception and requires an App Service Plan and Database to install
Teach the user how to edit .vmx files to add advanced configuration options Open vSphere Web Client: Edit Settings for a VM: Choose VM Options -> Advanced: Add Configuration Parameters:
This video shows you how easy it is to boot from ISO images for virtual machines with the ISO images stored on a local datastore on the ESXi host.

734 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question