I initially installed with the embedded database. Now I want to move away from the local DB to a DBA managed database on a different server.
I got the database created and obtained user credentials for the remote database. Then I shutdown Ambari server, exported and imported the database using pg_dump/psql. Next I changed the jdbc details in /etc/ambari/conf/ambari.properties as follows: Old information - local database configuration server.jdbc.database=postgres server.jdbc.database_name=ambari server.jdbc.postgres.schema=ambari server.jdbc.user.name=ambari server.jdbc.user.passwd=/etc/ambari-server/conf/password.dat New information - remote database configuration server.jdbc.database=postgres server.jdbc.database_name=ambari server.jdbc.driver=org.postgresql.Driver server.jdbc.hostname=dtord01dpt01d.dc.dotomi.net server.jdbc.port=5432 server.jdbc.postgres.schema=ambari server.jdbc.rca.driver=org.postgresql.Driver server.jdbc.rca.url=jdbc:postgresql://dtord01dpt01d.dc.dotomi.net:5432/ambari server.jdbc.rca.user.name=ambari server.jdbc.rca.user.passwd=/etc/ambari-server/conf/password.dat server.jdbc.url=jdbc:postgresql://dtord01dpt01d.dc.dotomi.net:5432/ambari server.jdbc.user.name=ambari server.jdbc.user.passwd=/etc/ambari-server/conf/password.dat server.jdbc.driver=org.postgresql.Driver server.jdbc.hostname=dtord01dpt01d.dc.dotomi.net server.jdbc.port=5432 I also updated the password file as follows "echo -n <password> > /etc/ambari-server/conf/password.dat" Next when I try to startup Ambari server, I get a password error as shown below. Any idea what am I doing wrong? [root@dtord01hdp0101d conf]# service ambari-server start Using python /usr/bin/python2.6 Starting ambari-server Ambari Server running with administrator privileges. Organizing resource files at /var/lib/ambari-server/resources... Server PID at: /var/run/ambari-server/ambari-server.pid Server out at: /var/log/ambari-server/ambari-server.out Server log at: /var/log/ambari-server/ambari-server.log Waiting for server start.................... ERROR: Exiting with exit code -1. REASON: Ambari Server java process died with exitcode 255. Check /var/log/ambari-server/ambari-server.out for more information. [root@dtord01hdp0101d conf]# cat /var/log/ambari-server/ambari-server.out [EL Warning]: metadata: 2015-09-22 20:49:53.641--ServerSession(1609509548)--The reference column name [resource_type_id] mapped on the element [field permissions] does not correspond to a valid id or basic field/column on the mapping reference. Will use referenced column name as provided. [EL Info]: 2015-09-22 20:49:55.235--ServerSession(1609509548)--EclipseLink, version: Eclipse Persistence Services - 2.5.2.v20140319-9ad6abd [EL Severe]: ejb: 2015-09-22 20:49:55.252--ServerSession(1609509548)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.5.2.v20140319-9ad6abd): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: org.postgresql.util.PSQLException: FATAL: password authentication failed for user "ambari" Error Code: 0 Any idea what am I missing or doing wrong? Thanks Jayesh This email and any files included with it may contain privileged, proprietary and/or confidential information that is for the sole use of the intended recipient(s). Any disclosure, copying, distribution, posting, or use of the information contained in or attached to this email is prohibited unless permitted by the sender. If you have received this email in error, please immediately notify the sender via return email, telephone, or fax and destroy this original transmission and its included files without reading or saving it in any manner. Thank you.