Displaying 3 results from an estimated 3 matches for "sqlmails".
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
Hello.
I've tried to configure TCP replication to slave server. But I got some
errors...
mx1:~# dovecot --version
2.2.27 (c0f36b0)
From dovecot.log:
May 07 19:27:41 auth-worker(34348): Warning: mysql: Query failed,
retrying: Unknown column 'username' in 'field list'
May 07 19:27:41 auth-worker(34348): Debug: sql(*): SELECT username,
domain FROM users
May 07 19:27:41
2018 May 08
0
replicator: User listing returned failure
Hello Alexey,
> mx1:~# dovecot --version
> 2.2.27 (c0f36b0)
>
> From dovecot.log:
> May 07 19:27:41 auth-worker(34348): Warning: mysql: Query failed, retrying: Unknown column 'username' in 'field list'
> May 07 19:27:41 auth-worker(34348): Debug: sql(*): SELECT username, domain FROM users
> May 07 19:27:41 auth-worker(34348): Error: sql: Iterate query failed: