Displaying 1 result from an estimated 1 matches for "nom_domain".
Did you mean:
nom_domaine
2005 Sep 22
0
problem with postgreSQL connect=
...ts 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 boite...