[Dovecot] Dovecot cannot connect to PostgreSQL server
Chris Vaas
chrisvaas at gmail.com
Sat Apr 26 16:06:00 UTC 2014
I am currently facing the following log output:
Apr 26 16:40:28 h2290750 dovecot: auth: Error: pgsql(localhost): Connect
failed to database mail: could not connect to server: Permission denied
Apr 26 16:40:28 h2290750 dovecot: auth: Error: #011Is the server running on
host "localhost" (::1) and accepting
Apr 26 16:40:28 h2290750 dovecot: auth: Error: #011TCP/IP connections on
port 5432?
I have double checked the database. It is listening correctly and I can
connect to it via
psql -U mailreader mail
I provided all necessary information to dovecot via this configuration
snippet:
driver = pgsql
connect = host=localhost dbname=mail user=mailreader password=secret
default_pass_scheme = SHA512
password_query = SELECT email as user, password,
'maildir:/home/mail'||maildir as userdb_mail FROM users WHERE email = '%u'
How can I debug this situation?
Cheers
Chris
More information about the dovecot
mailing list