[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