- Plesk for Linux
Attempt to access PostgreSQL database using network connection to
CONFIG_TEXT: psql: FATAL: Ident authentication failed for user "pgdb1_user1"
Plesk websites installed with Ruby application show the following error:
CONFIG_TEXT: 500 Internal Server Error
If you are the administrator of this website, then please read this web application's log file and/or the web server's log file to find out what went wrong.
PostgreSQL is configured to authenticate network connections using ident service, which is deprecated.
Connect to the server via SSH.
Change authentication configuration of host type from ident to password in
/var/lib/pgsql/data/pg_hba.confon RedHat-based systems
/var/lib/postgresql/9.1/main/pg_hba.confon Debian-based systems
CONFIG_TEXT: host all all 127.0.0.1/32 ident
host all all ::1/128 ident
CONFIG_TEXT: host all all 127.0.0.1/32 password
host all all ::1/128 password
(Optional step) Create new line in same format for any external host:
CONFIG_TEXT: host all all 203.0.113.2/32 password
Restart PostgreSQL service to apply changes:
# service postgresql restart