Displaying 1 result from an estimated 1 matches for "pg_password".
2008 Sep 21
3
dovecot imap auth fails to reconnect pgsql backend
...client:
path: /var/spool/postfix/private/auth
mode: 432
user: postfix
group: postfix
plugin:
quota: maildir
grep -v '^ *\(#.*\)\?$' /etc/dovecot-sql.conf
driver = pgsql
connect = host=<pg_server_ip> dbname=<pg_dbname> user=<pg_user>
password=<pg_password>
default_pass_scheme = PLAIN
password_query = SELECT jm || '@%d' as user, password FROM usera where
jm = '%n' and forbid = 'N' and ( '%d' = 'our.domain1' or '%d' =
'our.domain2' )
Can someone shed a light on this?
Thanks!
Regards,...