Hello

I'm using dovecot with virtual accounts stored in a postgreSQL db.

I use in the dovecot.conf:

auth_userdb = pgsql /usr/local/etc/dovecot-pgsql-user.conf

(and same for pass).

In the file dovecot-pgsql-user.conf, I use: connect = host=127.0.0.1 dbname=vmail user=lecteur password=lire user_query = SELECT '/var/spool/vhosts/'||nom_domaine||'/'||nom_boite AS mail,5000 AS uid, 5000 AS gid FROM boites WHERE email = '%u'

It doesn't work.

If I write: connect = dbname=vmail user=lecteur user_query = SELECT '/var/spool/vhosts/'||nom_domaine||'/'||nom_boite AS mail,5000 AS uid, 5000 AS gid FROM boites WHERE email = '%u'

It works.

Of course the query with psql works: psql -U lecteur -h 127.0.0.1 vmail -c "SELECT '/var/spool/vhosts/'||nom_domaine||'/'||nom_boite AS mail,5000 AS uid, 5000 AS gid FROM boites WHERE email = '%u' " with the password 'lire'

My question: do I make something wrong? I want to use the network, because in future, dovecot will not be on the same host than postgreSQL.

Thanks

Etes vous un consom'Acteur ? Toutes les saveurs équitables sont sur http://www.epicerie-equitable.com