You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@ambari.apache.org by "Thakrar, Jayesh" <jt...@conversantmedia.com> on 2015/09/22 22:58:13 UTC
Need help with moving from local/embedded to a remote PostgreSQL
database
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.
RE: Need help with moving from local/embedded to a remote
PostgreSQL database
Posted by "Thakrar, Jayesh" <jt...@conversantmedia.com>.
Thanks a lot Olivier - that worked!
From: Olivier Renault [mailto:orenault@hortonworks.com]
Sent: Wednesday, September 23, 2015 1:51 AM
To: user@ambari.apache.org
Subject: Re: Need help with moving from local/embedded to a remote PostgreSQL database
You need to re run ambari-server setup
Thanks,
Olivier
On Tue, Sep 22, 2015 at 1:58 PM -0700, "Thakrar, Jayesh" <jt...@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.
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.
Re: Need help with moving from local/embedded to a remote
PostgreSQL database
Posted by Olivier Renault <or...@hortonworks.com>.
You need to re run ambari-server setup
Thanks,
Olivier
On Tue, Sep 22, 2015 at 1:58 PM -0700, "Thakrar, Jayesh" <jt...@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.