If your server returns a Password authentication failed for user error when you try to access MySQL® resources, the most likely culprit is an invalid or missing PostgreSQL® user password.


Check the /root/.pgpass password file to confirm that the password exists in ::*:postgres:PASSWORD format.

if the password does not exist, you must edit the /var/lib/pgsql/data/pg_hba.conf file directly with the following steps:

Stop Tailwatch

Run the following commands to disable and stop Tailwatch:

touch /etc/tailwatchddisable
killall tailwatchd


Change the encryption to md5

Edit the /var/lib/pgsql/data/pg_hba.conf file and change md5 to trust



Restart PostgreSQL

Run the /scripts/restartsrv_postgresql restart command to restart PostgreSQL.

Change the PostgreSQL password

Change the PostgreSQL password with the following command, where new_pass represents the new password:

postgres=# alter user postgres with encrypted password =new_pass postgres=# \q

Change the encryption back to md5

Edit the /var/lib/pgsql/data/pg_hba.conf file and change trust back to md5

Remove the Tailwatch touch file and restart it

Run the following commands to remove the Tailwatch touch file and restart the service:

rm /etc/tailwatchddisable

Previously, the system stored passwords in the /var/lib/pgsql/.pgpass file.

If the /root/.pgpass file does not exist, the system copies the .pgpass file to the /root/.pgpass file.

Additional documentation