Monday 3 December 2012

FATAL: no pg hba.conf entry for host "::1", user "xxx", database "xxxx"



While checking pgsql log I've found the below error.

 FATAL: no pg_hba.conf entry for host "::1", user "cullyb_mahara", database "cullyb_mahara", SSL off

The reason is why we got the above error is postgresql only allows 127.0.0.1 to connect to its database as per pg_hba.conf

 host all all 127.0.0.1 255.255.255.255 md5

You need to update the config.php file with 127.0.0.1 in place of dbhost.

 grep dbhost config.php
 $cfg->dbhost   = '127.0.0.1';