[Dovecot] Table mail.users doesn't exist (using built-in default iterate_query: SELECT username, domain FROM users)

[Jerrale G]

  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