[Dovecot] Table mail.users doesn't exist (using built-in default iterate_query: SELECT username, domain FROM users)
jerralegayle at sheltoncomputers.com
Thu Aug 26 12:24:08 EEST 2010
connect = host=127.0.0.1 user=mail password=thecorrectpass dbname=mail
pattern = shared/expire/$user/$mailbox
table = mail.expires
value_field = expire_stamp
username = $user
mailbox = $mailbox
dovecot: auth: Error: mysql: Query failed, retrying: Table 'mail.users'
Aug 26 05:16:24 server1 dovecot: auth: Error: sql: Iterate query failed:
Table 'mail.users' doesn't exist (using built-in default iterate_query:
SELECT username, domain FROM users)
Why isn't the expire dict trying to use the defined working mysql auth
instead of using the built-in default?
The howto doesn't say how to override this, at wiki2.dovecot.org, and I
didn't know the expire dict wanted to lookup the mailbox table; I
thought it only wanted to lookup the expire table and use that soley for
deleting messages as all info needed was stored, in the expire table, by
the expire plugin on message delivery or copy.
SC Senior Admin
More information about the dovecot