Moodle installation error
Linode
Linode Staff
Hello,
I am using PostgreSQL and I can't connect with Moodle. I have been testing this with PgAdmin3 but I am still unable to connect with the database.
Here is the error message I'm receiving:
Moodle installation
Warning: pgconnect(): Unable to connect to PostgreSQL server: FATAL: password authentication failed for user "xxxx" FATAL: password authentication failed for user "xxxx" in /var/www/html/moodle/lib/dml/pgsqlnativemoodledatabase.php on line 176
PgAdmin3
469/5000
23:21:41: Error: Error connecting to the server: could not connect to the server: Connection refused
Is the server running on the server "xxxx" (xxx.xxx.xxx.xx) and accepting
TCP / IP connections on port 5432?
could not connect to the server: The network is inaccessible
Is the server running on the server "xxxx" (xxxx:xxxx::xxxx:xxxx: xxxx:xxxx) and accepting
TCP / IP connections on port 5432?
1 Reply
Hello,
So it looks like you're receiving a couple different errors here. The first is the password authentication error you're getting and the second is the connection error you're getting.
For the password error you'll want to check your pg_hba.conf file to ensure that it is configured correct. Here's some more info on that:
https://www.postgresql.org/docs/9.3/static/auth-methods.html
https://askubuntu.com/questions/413585/postgres-password-authentication-fails
As far as the connection errors- you'll want to check your firewall rules to ensure that your server is accepting connections on port 5432.
Regards,
Brittany
Trust & Safety Team