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
