question Re: Ambari is not connecting to the right DB in Archives of Support Questions (Read Only)

Ambari is not connecting to the right DB

rbalam — Thu, 04 Feb 2016 02:25:52 GMT

I am trying to install a new cluster and in the process i configured ambari to talk to a remote mysql db running on a different machine in the cluster. However when I try to start the ambari, it is failing to start because it is trying to connect to the local db which doesnt exisits. I checked ambari.properties file to see if i have the correct hostname for the remote mysql db. The properties file looks fine.

Is there any other place i need to check to see if it has the correct remote db hostname configured? Please advise

Re: Ambari is not connecting to the right DB

aervits — Thu, 04 Feb 2016 02:27:01 GMT

re-run ambari server setup so that you can enter your remote db information. @rbalam

ambari-server stop

ambari-server reset

ambari-server setup

Re: Ambari is not connecting to the right DB

rbalam — Thu, 04 Feb 2016 03:11:55 GMT

I am not able to reset ambari as it is saying i need to use DDL scripts for the remote DB host. Could you tell me how i can use Ambari-DDL-MySQL-DROP.sql to remove everything from mysql server and then use Ambari-DDL-MySQL-CREATE.sql to recreate the schema? There are other Databases running on the same mysql host, so i want to be careful not to delete any other tables.

Re: Ambari is not connecting to the right DB

nsabharwal — Thu, 04 Feb 2016 03:13:41 GMT

@rbalam

Please see this http://docs.hortonworks.com/HDPDocuments/Ambari-2.2.0.0/bk_ambari_reference_guide/content/_using_ambari_with_mysql.html

You can drop the database as normal mysql statement and run the above scripts mentioned in the doc

Re: Ambari is not connecting to the right DB

rbalam — Thu, 04 Feb 2016 03:18:50 GMT

I tried to do that but here is what I saw on the console .. please see the attached for error message

Re: Ambari is not connecting to the right DB

nsabharwal — Thu, 04 Feb 2016 03:27:30 GMT

@rbalam I see the error. Whats the OS ? See this thread

Re: Ambari is not connecting to the right DB

nsabharwal — Thu, 04 Feb 2016 03:28:12 GMT

@rbalam Did you run drop database ambari_database; ?

Re: Ambari is not connecting to the right DB

nsabharwal — Thu, 04 Feb 2016 03:36:30 GMT

@rbalam I dont see the error details. DId you attach log?

Re: Ambari is not connecting to the right DB

nsabharwal — Thu, 04 Feb 2016 03:38:22 GMT

@rbalam

Do this...

drop database ambari;

CREATE DATABASE ambari;

USE ambari;

SOURCE /var/lib/ambari-server/resources/Ambari-DDL-MySQL-CREATE.sql;

Re: Ambari is not connecting to the right DB

rbalam — Thu, 04 Feb 2016 03:43:32 GMT

i did all that and i ran ambari-setup once again and i gave the remote MySQL DB information by choosing option 3 for MySQL and tried to restart but it failed to restart again with the following error message .. which means it is trying to talk to a DB on the local host which doesn't exisits .. the remote mysql is running on FALBDCDQ0007V host ..

Exception in thread "main" com.google.inject.CreationException: Guice creation errors: 1) Error injecting constructor, java.lang.RuntimeException: java.sql.SQLException: Access denied for user 'ambari'@'FALBDCDQ0001V.farmersinsurance.com' (using password: YES) at org.apache.ambari.server.orm.DBAccessorImpl.<init>(DBAccessorImpl.java:77) while locating org.apache.ambari.server.orm.DBAccessorImpl while locating org.apache.ambari.server.orm.DBAccessor for field at org.apache.ambari.server.orm.dao.DaoUtils.dbAccessor(DaoUtils.java:36) at org.apache.ambari.server.orm.dao.DaoUtils.class(DaoUtils.java:36) while locating org.apache.ambari.server.orm.dao.DaoUtils for field at org.apache.ambari.server.orm.dao.TopologyRequestDAO.daoUtils(TopologyRequestDAO.java:31) at org.apache.ambari.server.orm.dao.TopologyRequestDAO.class(TopologyRequestDAO.java:31) while locating org.apache.ambari.server.orm.dao.TopologyRequestDAO for field at org.apache.ambari.server.topology.PersistedStateImpl.topologyRequestDAO(PersistedStateImpl.java:56) Caused by: java.lang.RuntimeException: java.sql.SQLException: Access denied for user 'ambari'@'FALBDCDQ0001V.farmersinsurance.com' (using password: YES) at org.apache.ambari.server.orm.DBAccessorImpl.<init>(DBAccessorImpl.java:103) at org.apache.ambari.server.orm.DBAccessorImpl$$FastClassByGuice$$86dbc63e.newInstance(<generated>) at com.google.inject.internal.cglib.reflect.$FastConstructor.newInstance(FastConstructor.java:40) at com.google.inject.internal.DefaultConstructionProxyFactory$1.newInstance(DefaultConstructionProxyFactory.java:60) at com.google.inject.internal.ConstructorInjector.construct(ConstructorInjector.java:85) at com.google.inject.internal.ConstructorBindingImpl$Factory.get(ConstructorBindingImpl.java:254) at com.google.inject.internal.FactoryProxy.get(FactoryProxy.java:54) at com.google.inject.internal.SingleFieldInjector.inject(SingleFieldInjector.java:53) at com.google.inject.internal.MembersInjectorImpl.injectMembers(MembersInjectorImpl.java:110) at com.google.inject.internal.ConstructorInjector.construct(ConstructorInjector.java:94)

Re: Ambari is not connecting to the right DB

nsabharwal — Thu, 04 Feb 2016 03:46:48 GMT

@rbalam You may want to remove customer name.

You need to follow the doc step by step. Missing the permsisions

CREATE USER '<AMBARIUSER>'@'%' IDENTIFIED BY '<AMBARIPASSWORD>';

GRANT ALL PRIVILEGES ON *.* TO '<AMBARIUSER>'@'%';

CREATE USER '<AMBARIUSER>'@'localhost' IDENTIFIED BY '<AMBARIPASSWORD>';

GRANT ALL PRIVILEGES ON *.* TO '<AMBARIUSER>'@'localhost';

CREATE USER '<AMBARIUSER>'@'<AMBARISERVERFQDN>' IDENTIFIED BY '<AMBARIPASSWORD>';

GRANT ALL PRIVILEGES ON *.* TO '<AMBARIUSER>'@'<AMBARISERVERFQDN>';

FLUSH PRIVILEGES;

Re: Ambari is not connecting to the right DB

Shelton — Thu, 04 Feb 2016 03:48:48 GMT

@rbalam

I have attached a document on how to install your Ambari server successfully you will not find any better document than this .Please enjoy and revert set-up-mysql-for-ambari.pdf

I forgot to include the syntax to connect remotely to MySQL server but it should be fine

The Ambari Server host needs the mysql-connector-java driver installed to be able to communicate with the database you will need to install it on the local and remote server

Re: Ambari is not connecting to the right DB

rbalam — Thu, 04 Feb 2016 03:49:20 GMT

Error message is attached

Re: Ambari is not connecting to the right DB

rbalam — Thu, 04 Feb 2016 04:07:56 GMT

@Geoffrey Shelton Okot

Thanks for sending the doc but I did the installation exactly the same way you have it on your document and everything went fine but when i start the server it is looking for the local mySQL db which doesnt exists .. I checked ambari.properties and everything points to the remote mySQL server but for some reason the ambari server is trying to connect to the local mysql host ..

Please note that i m doing the installation using a local repo as this cluster doesnt have internet connect .. Do you have a doc to remove ambari binaries and configuration from everywhere to start from the scratch?

Re: Ambari is not connecting to the right DB

nsabharwal — Thu, 04 Feb 2016 04:13:47 GMT

@rbalam

You are mixing couple of things here.

1) Cleanup https://community.hortonworks.com/content/idea/138/cleanup-scripts-to-remove-old-hdp-bits.html

2) ambari-server setup looks fine...as per the screenshot

whats the exact issue now?

Re: Ambari is not connecting to the right DB

rbalam — Thu, 04 Feb 2016 04:21:29 GMT

@Neeraj Sabharwal

as i stated in the begining, the problem is with the ambari server trying to connect to the local mysql host when i configured it to talk to remote MySQL host ..

Ambari Server setup ran fine .. but when i try to restart it is failing because it is trying to talk to the local db instead of remote mysql db ..

I removed ambari-server binaries from the host using "yum remove ambari-server" and re-installed it using "yum install ambari-server" and ran the set up once again to point it to remote mysql db but it is still trying to talk to the local db when i tried to start using "ambari-server start" command ..

Re: Ambari is not connecting to the right DB

Shelton — Thu, 04 Feb 2016 04:21:54 GMT

@rbalam

Try this steps to clean up your failed installation, just to make sure did you in th eeralier steps copy mysql-connector-java.jar to /usr/share/java/ directory to both servers ?

Re: Ambari is not connecting to the right DB

nsabharwal — Thu, 04 Feb 2016 04:24:03 GMT

@rbalam It failed because of permission issue

java.sql.SQLException: Access denied for user 'ambari'@'FALBDCDQ0001V.farmersinsurance.com' (using

run this as root user

grant all privileges on *.* to 'ambari'@'FALBDCDQ0001V.farmersinsurance.com' identified by 'password' ;

make sure you can connect

mysql -u ambari -ppassword -h host

Re: Ambari is not connecting to the right DB

Shelton — Thu, 04 Feb 2016 04:26:01 GMT

@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

rbalam — Thu, 04 Feb 2016 04:27:16 GMT

FALBDCDQ0001V is not the correct MySQL host .. it should talk to FALBDCDQ0007V where i have all the permissions set for ambari user ..