[Dovecot] Dovecot cannot connect to PostgreSQL server

[Reindl Harald]

first: don't reply off-list and don't top-post

Am 26.04.2014 18:26, schrieb Christian Vaas:
> How do I determine my postgresql socket location?
> 
> On Apr 26, 2014 6:17 PM, "Reindl Harald" <h.reindl at thelounge.net <mailto:h.reindl at thelounge.net>> wrote:
> 
>     Am 26.04.2014 18 <tel:26.04.2014%2018>: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"

why don't you know that? it's your machine and i don't use PostgreSQL at all
"updatedb; locate post | grep socket" may be a good start

just read the man page of your distribtion or use google
google: "name-of-your-distribution postgresql unix socket"

or simply try 127.0.0.1 which is as explained different to localhost
localhost is typically unix-socket and 127.0.0.1 TCP/IP, in any case
you have to make sure that the user is allowed

in case of mysql i can set different permissions for "user1 at localhost"
and "user1 at 127.0.0.1", most likely PostgeSQL supports that too

-------------- 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/c764575f/attachment.sig>