[Dovecot] Dovecot cannot connect to PostgreSQL server

[Reindl Harald]

Am 26.04.2014 18:06, schrieb Chris Vaas:
> 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?

try "host=/path/to/your/unix/socket" instead just only "localhost"
or switch to TCP with using 127.0.0.1 instead localhost

in case of mysqld this would be "host=/var/lib/mysql/mysql.sock"

-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 246 bytes
Desc: OpenPGP digital signature
URL: <http://dovecot.org/pipermail/dovecot/attachments/20140426/a216d949/attachment.sig>