postfix给本地域发信收不到[已解决]

I-like

tail-f /var/log/maillog
warning: mysql query failed: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''1'' at line 1

看起来是mysql有问题。
但让我检查的这个use near ''1'' at line 1是在哪儿？

[ 本帖最后由 I-like 于 2008-8-7 16:04 编辑 ]

ruochen

多给点信息吧

I-like

Aug  7 14:49:29 Security postfix/qmgr[7271]: 7CD74F0052: from=<like2@test.net>, size=547, nrcpt=1 (queue active)
Aug  7 14:49:29 Security postfix/virtual[10448]: warning: mysql query failed: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''1'' at line 1
Aug  7 14:49:29 Security postfix/virtual[10448]: warning: table virtual_mailbox_maps: lookup like3@test.net: Success
Aug  7 14:49:29 Security postfix/virtual[10448]: 7CD74F0052: to=<like3@test.net>, relay=virtual, delay=76175, delays=76175/0.02/0/0.01, dsn=4.3.5, status=deferred (mail system configuration error)


就这些了

[ 本帖最后由 I-like 于 2008-8-7 15:34 编辑 ]

ruochen

[root@mail ~]# more /etc/postfix/mysql/mysql_virtual_sender_maps.cf
user = extmail
password = extmail
hosts = localhost
dbname = extmail
table = mailbox
select_field = username
where_field = username
additional_conditions = AND active = '1'


是不是这个文件配置的不对
从日志来看是验证sender的时候,mysql出现错误

ruochen

[root@mail ~]# more /etc/postfix/mysql/mysql_virtual_mailbox_maps.cf
user = extmail
password = extmail
hosts = localhost
dbname = extmail
table = mailbox
select_field = maildir
where_field = username
additional_conditions = AND active = '1'

也有可能是这个文件
还有检查下你的数据库里面的相关的表
是不是有active这个字段

I-like

还是报同样错。
main.cf
####################Virtual Mailbox Settings####################
virtual_mailbox_base = /data/mailbox
virtual_mailbox_maps = mysql:/etc/postfix/mysql_virtual_mailbox_maps.cf
virtual_mailbox_domains = mysql:/etc/postfix/mysql_virtual_domains_maps.cf
virtual_alias_domains =
virtual_alias_maps = mysql:/etc/postfix/mysql_virtual_alias_maps.cf
virtual_sender_maps = mysql:/etc/postfix/mysql_virtual_sender_maps.cf
virtual_uid_maps = static:2525
virtual_gid_maps = static:2525
virtual_transport = virtual
maildrop_destination_recipient_limit = 1
maildrop_destination_concurrency_limit = 1

I-like

行了，发现了问题
少了一个=号
是我不仔细。
骚扰了大家！抱歉