我一直在关注workaround.org上的ISPMail教程(2.9 Wheezy版本),到目前为止一切都运行良好.当我到达“测试电子邮件传递”步骤时,我在/var/log/mail.log的输出日志中发现了有关查询的错误.
May 14 06:48:59 mail postfix/pickup[17704]: EA4AD240A98: uid=0 from=
May 14 06:48:59 mail postfix/cleanup[17776]: EA4AD240A98: message-id=<20140514064859.EA4AD240A98@mail.domain.com>
May 14 06:48:59 mail postfix/qmgr[17706]: EA4AD240A98: from=, size=429, nrcpt=1 (queue active)
May 14 06:49:00 mail dovecot: auth-worker(17782): mysql(127.0.0.1): Connected to database mailserver
May 14 06:49:00 mail dovecot: auth-worker(17782): Warning: mysql: Query failed, retrying: Table 'mailserver.users' doesn't exist
May 14 06:49:00 mail dovecot: auth-worker(17782): Error: sql(john@example.org): User query failed: Table 'mailserver.users' doesn't exist (using built-in default user_query: SELECT home, uid, gid FROM users WHERE username = '%n' AND domain = '%d')
May 14 06:49:00 mail dovecot: lda(john@example.org): msgid=<20140514064859.EA4AD240A98@mail.domain.com>: saved mail to INBOX
May 14 06:49:00 mail postfix/pipe[17780]: EA4AD240A98: to=, relay=dovecot, delay=0.09, delays=0.03/0.01/0/0.06, dsn=2.0.0, status=sent (delivered via dovecot service)
May 14 06:49:00 mail postfix/qmgr[17706]: EA4AD240A98: removed
我发现这很有意思,它没有找到数据库,所以我回过头来检查我触摸的每个文件涉及数据库(包括后缀cf文件),一切都是正确的,所以我对这一点感到困惑,但奇怪的是足够好看,电子邮件仍然可以在/var/vmail/domain.com/中找到正确的目的地.
我应该担心这个还是我错过了什么?因为它是来自dovecot的消息,所以我将在这里包含来自dovecot-sql.conf.ext的查询
driver = mysql
connect = host=127.0.0.1 dbname=mailserver user=blocked password=***REMOVED***
default_pass_scheme = PLAIN-MD5
password_query = SELECT email as user, password FROM virtual_users WHERE email='%u';