question Re: Able to find the database server and database, but logon request was rejected. in Support Questions

Able to find the database server and database, but logon request was rejected.

nitinz — Fri, 16 Sep 2022 13:39:36 GMT

I am trying to point out Cloudera Manager to an external PostgresSQL database.

The external database is running and able to connect to the database (command line)

Created all required database by following https://www.cloudera.com/documentation/enterprise/latest/topics/cm_ig_extrnl_pstgrs.html#cmig_topic_5_6

Below is the error I thrown at me when I am trying to setup Activity Monitor and Reports Manager

Logon denied for user/password. Able to find the database server and database, but logon request was rejected.

This is what I found in logs

2018-08-31 12:25:19,729 INFO CommandPusher:com.cloudera.cmf.model.DbCommand: Command 64(AmonTestDatabaseConnection) has completed. finalstate:FINISHED, success:false, msg:Logon denied for user/password. Able to find the database server and database, but logon request was rejected.

Please help me out in this.

Thanks

Re: Able to find the database server and database, but logon request was rejected.

nitinz — Fri, 31 Aug 2018 17:36:23 GMT

I am running cloudera-manager-daemons.x86_64 5.12.2-1.cm5122 and cloudera-manager-server.x86_64 5.12.2-1.cm5122

Re: Able to find the database server and database, but logon request was rejected.

bgooley — Fri, 31 Aug 2018 17:37:50 GMT

@nitinz

The error means that the password you entered does not match the password for the database. At least that was the return code from the attempted DB operation inside Cloudera Manager.

You should verify you can authenticate outside Cloudera Manager (with psql) for instance with the same connection information.

Re: Able to find the database server and database, but logon request was rejected.

nitinz — Fri, 31 Aug 2018 17:45:44 GMT

@bgooley

Thanks for the quick reply. I am able to login to the Postgres with the same password and also changed db.mgmt.properties still I have the same error

Am I missing something?

com.cloudera.cmf.ACTIVITYMONITOR.db.type=postgresql
com.cloudera.cmf.ACTIVITYMONITOR.db.host=postgresqlhostname:7432
com.cloudera.cmf.ACTIVITYMONITOR.db.name=amon
com.cloudera.cmf.ACTIVITYMONITOR.db.user=amon
com.cloudera.cmf.ACTIVITYMONITOR.db.password=amon_password
com.cloudera.cmf.REPORTSMANAGER.db.type=postgresql
com.cloudera.cmf.REPORTSMANAGER.db.host=postgresqlhostname:7432
com.cloudera.cmf.REPORTSMANAGER.db.name=rman
com.cloudera.cmf.REPORTSMANAGER.db.user=rman
com.cloudera.cmf.REPORTSMANAGER.db.password=rman_password
com.cloudera.cmf.NAVIGATOR.db.type=postgresql
com.cloudera.cmf.NAVIGATOR.db.host=postgresqlhostname:7432
com.cloudera.cmf.NAVIGATOR.db.name=nav
com.cloudera.cmf.NAVIGATOR.db.user=nav
com.cloudera.cmf.NAVIGATOR.db.password=nav_password
com.cloudera.cmf.NAVIGATORMETASERVER.db.type=postgresql
com.cloudera.cmf.NAVIGATORMETASERVER.db.host=postgresqlhostname:7432
com.cloudera.cmf.NAVIGATORMETASERVER.db.name=navms
com.cloudera.cmf.NAVIGATORMETASERVER.db.user=navms
com.cloudera.cmf.NAVIGATORMETASERVER.db.password=navms_password

Re: Able to find the database server and database, but logon request was rejected.

nitinz — Fri, 31 Aug 2018 17:52:36 GMT

@bgooley

I am able to login to the Postgres with the same credentials. I also updated the password in db.mgmt.properties.

Still, I have the same error.

Am I missing something?

Re: Able to find the database server and database, but logon request was rejected.

bgooley — Fri, 31 Aug 2018 18:09:11 GMT

hmmm... db.mgmt.properties does not apply. That is only for the embedded postgres DB.

Were you using that before and are switching to a new DB?

If you have a "/etc/cloudera-scm-server/db.mgmt.properties" file, then that means you have installed the embedded db.

Can you give us more of the history of this cluster and what you are looking to do?

Re: Able to find the database server and database, but logon request was rejected.

nitinz — Fri, 31 Aug 2018 18:17:14 GMT

@bgooley

I am still in the building stage of the cluster.

I installed the server and daemons. It is completely in the starting stages of the build process.

I just did the yum install after the pre-requisites.

Re: Able to find the database server and database, but logon request was rejected.

nitinz — Fri, 31 Aug 2018 18:20:59 GMT

@bgooley

I followed the following link to set up the database

https://www.cloudera.com/documentation/enterprise/latest/topics/prepare_cm_database.html#concept_i2r_m3m_hn

It gave me success.

Other than that is there any other way to see the connection with the database is successful.

Re: Able to find the database server and database, but logon request was rejected.

bgooley — Fri, 31 Aug 2018 18:45:00 GMT

@nitinz,

What we need to know is at what step this is failing.

Can you take screen shots to help?

prepare db is only for Cloudera Manager and the error you showed was for AmonTestDatabaseConnection.

that implies that you connected to CM and started the wizard to create the cluster.

It is very important when looking for help to present the context for your questions/problems so we can understand clearly what the situation is.

That said, I am worried you are running into problems because you installed:

cloudera-manager-server-db-2

Please run "rpm -qa |grep cloudera" on your Cloudera Manager host and post the output.

Before we get too far, we need to be sure that you are not trying to use an external db when the embedded db is configured for use.

Re: Able to find the database server and database, but logon request was rejected.

nitinz — Fri, 31 Aug 2018 19:08:12 GMT

@bgooley

Thanks for the explanation, I may have misread your previous post.

I am attaching the screenshot

~]$ rpm -qa |grep cloudera
cloudera-manager-server-5.12.2-1.cm5122.p0.12.el7.x86_64
cloudera-manager-daemons-5.12.2-1.cm5122.p0.12.el7.x86_64

Re: Able to find the database server and database, but logon request was rejected.

bgooley — Fri, 31 Aug 2018 23:01:00 GMT

@nitinz,

Hi,

If you don't have the cloudera-manager-server-db-2 package, how do you have the db.mgmt.properties file?

Did you remove it at some point?

In any case, a couple things:

(1)

You don't need Activity Monitor role unless you are using MapReduce1. You can not use that role.

(2)

It appears you have not entered hostname and port in the Database Setup

(3)

If you do have a /etc/cloudera-scm-server/db.mgmt.properties, please remove it from that directory. It is possible that its presence is causing problems for the connection test as you should not have db.mgmt.properties if you are not using the embedded database. All database configurations except for Cloudera Manager's are stored in Cloudera Manager's database, not in flat files.

Re: Able to find the database server and database, but logon request was rejected.

HKG — Fri, 07 Feb 2020 14:21:19 GMT

I am facing the same issue connection with Hue.per your instructions i have removed the db.properties and cloudera manager does not start at all..

-- Subject: Unit cloudera-scm-server.service has finished shutting down
-- Defined-By: systemd
-- Support: http://lists.freedesktop.org/mailman/listinfo/systemd-devel
--
-- Unit cloudera-scm-server.service has finished shutting down.
Feb 07 14:17:28 fsgbu-phx-10 systemd[1]: start request repeated too quickly for cloudera-scm-server.service
Feb 07 14:17:28 fsgbu-phx-10 systemd[1]: Failed to start Cloudera CM Server Service.
-- Subject: Unit cloudera-scm-server.service has failed
-- Defined-By: systemd
-- Support: http://lists.freedesktop.org/mailman/listinfo/systemd-devel
--
-- Unit cloudera-scm-server.service has failed.
--

Re: Able to find the database server and database, but logon request was rejected.

lwang — Fri, 07 Feb 2020 17:58:53 GMT

Hi @HKG ,

We are sorry to hear you are having some trouble. Can you open a new thread and provide us with some background of what you are trying to do and what is happening. If you can give us some screen shots that would help make sure we understand what you are seeing.

Also, I noticed you mentioned you deleted db.properties instead of db.mgmt.properties which was mentioned in old threads. db.properties is the configuration file needed for Cloudera Manager database details. That file should not be deleted. Do you have a backup of the file? If so, please restore the file and set the permission to be:

-rw------- 1 cloudera-scm cloudera-scm

Then try to restart CM server again.

Hope this helps. If not, please open a new thread and provide more information.

Thanks!

Re: Able to find the database server and database, but logon request was rejected.

bgooley — Fri, 07 Feb 2020 18:36:36 GMT

Hi @HKG , It seems you may have deleted the wrong file.

In my instructions I suggested trying to remove /etc/cloudera-scm-server/db.mgmt.properties

However, you deleted: db.properties

"db.properties" contains configuration information for Cloudera Manager's connection to the backing SQL database, so CM won't start without it.

db.mgmt.properties is not going to influence Hue connections as the Hue DB configuration. Please restore the db.properties file so CM can start. After that, open a new thread with "Hue" and "Cloudera Manager" labels, include a screen shot of the problem as you observe it, and we should be able to help out.

Cheers,

Ben

Re: Able to find the database server and database, but logon request was rejected.

Mavrick — Sat, 14 Nov 2020 22:20:38 GMT

Hello,

I had the same issue and this is your /var/lib/pgsql/data/pg_hba.conf

By default, PostgreSQL accepts connections only from the localhost. It refuses remote connections. This is controlled by applying an access control rule that allows a user to log in from an IP address after providing a valid password (the md5 keyword). To accept a remote connection, add :

host all all 0.0.0.0/0 md5

Maybe you should restrict as you wish.

Regards