Displaying 3 results from an estimated 3 matches for "sqlmail".
Did you mean:
slmail
2012 Feb 13
6
Dovecot v2.2 plans
...nfiguration. There are mainly 3 config files I'm thinking about: dict-sql, passdb/userdb sql, passdb/userdb ldap. The dict-sql is something I think needs a bigger redesign (mentioned above in "Metadata" section), but the sql/ldap auth configs could be merged. One way could be:
sql_db sqlmails {
# most settings from dovecot-sql.conf.ext, except for queries
driver = mysql
connect = ...
}
ldap_db ldapmails {
# most settings from dovecot-ldap.conf.ext, except attributes/filters
}
passdb {
driver = sql
db = sqlmails
sql_query = select password from users where username = ...
2018 May 07
2
replicator: User listing returned failure
...n {
mail_replica = tcp:mx1 # use doveadm_port
}
As I can see nothing happens automatically.
But mx2:~# doveadm -D sync -u abuse at example.com -d -N -l 30 -U
successfully executed and getting mails from mx1.
dovecot-sql.conf.ext:
driver = mysql
connect = host=localhost dbname=vmail user=sqlmail
password=sqL_hidden033|TGPAS
default_pass_scheme = SHA512-CRYPT
password_query = SELECT id AS username, password, domain FROM users
WHERE id = '%n' AND domain = '%d' AND active = 'Y'
user_query = SELECT id AS username, uid, gid, home, concat('*:storage=',
quota, &...
2018 May 08
0
replicator: User listing returned failure
...;
>
> As I can see nothing happens automatically.
> But mx2:~# doveadm -D sync -u abuse at example.com -d -N -l 30 -U successfully executed and getting mails from mx1.
>
>
>
>
> dovecot-sql.conf.ext:
> driver = mysql
> connect = host=localhost dbname=vmail user=sqlmail password=sqL_hidden033|TGPAS
> default_pass_scheme = SHA512-CRYPT
> password_query = SELECT id AS username, password, domain FROM users WHERE id = '%n' AND domain = '%d' AND active = 'Y'
> user_query = SELECT id AS username, uid, gid, home, concat('*:storage=...