Displaying 1 result from an estimated 1 matches for "averysecretpass".
2007 Aug 15
1
Dovecot deliver + sieve + postfix virtual + mysql ?
...66
user = postfix
group = postfix
}
master {
path = /var/run/dovecot/auth-master
mode = 0600
user = vmail
group = vmail
}
}
}
dict {
}
plugin {
}
/etc/dovecot/dovecot-sql.conf:
driver = mysql
default_pass_scheme = PLAIN
connect = host=127.0.0.1 dbname=postfix user=postfix password=averysecretpass
password_query = SELECT password FROM mailbox WHERE username = '%u' AND active
= '1'
user_query = SELECT maildir, 65500 AS uid, 65500 AS gid FROM mailbox WHERE
username = '%u' AND active = '1'
the user_query gives:
mysql> SELECT maildir, 65500 AS uid, 65500 AS...