dovecot 不用mysql_Dovecot无法执行mysql查询

我一直在关注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';

  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值