- Plesk for Linux
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.
Attempt to access PostgreSQL database using network connection to
CONFIG_TEXT: psql: FATAL: Ident authentication failed for user "pgdb1_user1"
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 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