connect = host=127.0.0.1 user=mail password=thecorrectpass dbname=mail map { pattern = shared/expire/$user/$mailbox table = mail.expires value_field = expire_stamp
fields { username = $user mailbox = $mailbox } }
dovecot: auth: Error: mysql: Query failed, retrying: Table 'mail.users' doesn't exist 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.
Jerrale G rrale G. SC Senior Admin