ambari-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Olivier Renault <orena...@hortonworks.com>
Subject Re: Need help with moving from local/embedded to a remote PostgreSQL database
Date Wed, 23 Sep 2015 06:50:36 GMT
You need to re run ambari-server setup

Thanks,
Olivier



On Tue, Sep 22, 2015 at 1:58 PM -0700, "Thakrar, Jayesh" <jthakrar@conversantmedia.com<mailto:jthakrar@conversantmedia.com>>
wrote:

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.

Mime
View raw message