Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

Ambari is not connecting to the right DB

Solved Go to solution
Highlighted

Re: Ambari is not connecting to the right DB

Mentor

@rbalam your Ambari installation looks good exit code 0 ,but am puzzled . can you copy and paste in here your mysql setup for ambari steps?

Re: Ambari is not connecting to the right DB

Contributor

@Geoffrey Shelton Okot

please see the attached screen shot of my MySQL setup for ambari


set-up.png
Highlighted

Re: Ambari is not connecting to the right DB

Contributor

i created the db using

SOURCE /tmp/Ambari-DDL-MySQL-CREATE.sql on the remote mySQL DB but I didnt install mysql-connector-java using yum because that server doesnt have internet connectivity. So I copied the

mysql-connector-java-5.1.17.jar file from another cluster which is working. I also checked the symlink to see if it is pointing to the right mysql jar ..

I dont have mysql client on the local ambari host to test the connectivity but i was able to check the connection on the port 3066

FALBDCDQ0001V:~#nc -tz FALBDCDQ0007V 3306 Connection to FALBDCDQ0007V 3306 port [tcp/mysql] succeeded!

Highlighted

Re: Ambari is not connecting to the right DB

Mentor

@rbalam just FYI, mysql-connector-java-5.1.17 is old, we recommend using at least 5.1.29, even better if higher.

Highlighted

Re: Ambari is not connecting to the right DB

Mentor

@rbalam so do you have the mysql-connector-java on the Ambari server ? If not copy it please.

Don't have an account?
Coming from Hortonworks? Activate your account here