Hi, I am using postfix 2.0.0.1 and cyrus 2.1.11 +mysql to auth
my mails are not being delivered, the postfix logs show error, (data format error. Command output: sarwaransari.ns3.indiaaccess.com: Mailbox does not exist) can somebody please tell me is it a postfix config problem or cyrus's. and if possible the solution <grin> I have been at this problem for days, tried various options. Postfix logs ------------ Jan 10 16:58:41 ns3 postfix/smtpd[1912]: connect from unknown[192.168.0.99] Jan 10 16:58:42 ns3 postfix/smtpd[1912]: 03AF8337E2: client=unknown[192.168.0.99] Jan 10 16:58:42 ns3 postfix/smtpd[1912]: warning: the "check_relay_domains" restriction is going away; use "reject_unauth_destination" instead Jan 10 16:58:42 ns3 postfix/cleanup[1913]: 03AF8337E2: message-id=<011a01c2b89b$b8f1a100$6300a8c0@ntcomputer> Jan 10 16:58:42 ns3 postfix/qmgr[1906]: 03AF8337E2: from=<[EMAIL PROTECTED]>, size=1013, nrcpt=1 (queue active) Jan 10 16:58:42 ns3 postfix/local[1919]: maps_append: mysql:/etc/postfix/mysql-virtual.cf Jan 10 16:58:42 ns3 postfix/local[1919]: mysqlname_parse(): set username to 'mail' Jan 10 16:58:42 ns3 postfix/local[1919]: mysqlname_parse(): set password to 'xxxxx' Jan 10 16:58:42 ns3 postfix/local[1919]: mysqlname_parse(): set database name to 'mail' Jan 10 16:58:42 ns3 postfix/local[1919]: mysqlname_parse(): set table name to 'virtual' Jan 10 16:58:42 ns3 postfix/local[1919]: mysqlname_parse(): set select_field to 'dest' Jan 10 16:58:42 ns3 postfix/local[1919]: mysqlname_parse(): set where_field to 'alias' Jan 10 16:58:42 ns3 postfix/local[1919]: mysqlname_parse(): set additional_conditions to 'and status = '1'' Jan 10 16:58:42 ns3 postfix/local[1919]: mysqlname_parse(): adding host 'localhost' to list of mysql server hosts Jan 10 16:58:42 ns3 postfix/local[1919]: dict_open: mysql:/etc/postfix/mysql-virtual.cf Jan 10 16:58:42 ns3 postfix/local[1919]: mysqlname_parse(): set username to 'mail' Jan 10 16:58:42 ns3 postfix/local[1919]: mysqlname_parse(): set password to 'xxxxx' Jan 10 16:58:42 ns3 postfix/local[1919]: mysqlname_parse(): set database name to 'mail' Jan 10 16:58:42 ns3 postfix/local[1919]: mysqlname_parse(): set table name to 'domain' Jan 10 16:58:42 ns3 postfix/local[1919]: mysqlname_parse(): set select_field to 'domain_name' Jan 10 16:58:42 ns3 postfix/local[1919]: mysqlname_parse(): set where_field to 'domain_name' Jan 10 16:58:42 ns3 postfix/local[1919]: mysqlname_parse(): set additional_conditions to '' Jan 10 16:58:42 ns3 postfix/local[1919]: mysqlname_parse(): adding host 'localhost' to list of mysql server hosts Jan 10 16:58:42 ns3 postfix/local[1919]: dict_open: mysql:/etc/postfix/mysql-mydestination.cf Jan 10 16:58:42 ns3 postfix/local[1919]: set_eugid: euid 33333 egid 33333 Jan 10 16:58:42 ns3 postfix/local[1919]: name_mask: alias Jan 10 16:58:42 ns3 postfix/local[1919]: name_mask: forward Jan 10 16:58:42 ns3 postfix/local[1919]: name_mask: alias Jan 10 16:58:42 ns3 postfix/local[1919]: name_mask: forward Jan 10 16:58:42 ns3 postfix/local[1919]: name_mask: canonical Jan 10 16:58:42 ns3 postfix/local[1919]: name_mask: virtual Jan 10 16:58:42 ns3 postfix/local[1919]: name_mask: command Jan 10 16:58:42 ns3 postfix/local[1919]: name_mask: file Jan 10 16:58:42 ns3 postfix/local[1919]: name_mask: forward Jan 10 16:58:42 ns3 postfix/local[1919]: name_mask: fcntl Jan 10 16:58:42 ns3 postfix/local[1919]: name_mask: dotlock Jan 10 16:58:42 ns3 postfix/local[1919]: watchdog_create: 0x8088b20 18000 Jan 10 16:58:42 ns3 postfix/local[1919]: watchdog_stop: 0x8088b20 Jan 10 16:58:42 ns3 postfix/local[1919]: watchdog_start: 0x8088b20 Jan 10 16:58:42 ns3 postfix/local[1919]: connection established Jan 10 16:58:42 ns3 postfix/local[1919]: master_notify: status 0 Jan 10 16:58:42 ns3 postfix/local[1919]: deliver_request_initial: send initial status Jan 10 16:58:42 ns3 postfix/local[1919]: send attr status = 0 Jan 10 16:58:42 ns3 postfix/local[1919]: local socket: wanted attribute: flags Jan 10 16:58:42 ns3 postfix/local[1919]: input attribute name: flags Jan 10 16:58:42 ns3 postfix/local[1919]: input attribute value: 3 Jan 10 16:58:42 ns3 postfix/local[1919]: local socket: wanted attribute: queue_name Jan 10 16:58:42 ns3 postfix/local[1919]: input attribute name: queue_name Jan 10 16:58:42 ns3 postfix/local[1919]: input attribute value: active Jan 10 16:58:42 ns3 postfix/local[1919]: local socket: wanted attribute: queue_id Jan 10 16:58:42 ns3 postfix/local[1919]: input attribute name: queue_id Jan 10 16:58:42 ns3 postfix/local[1919]: input attribute value: 03AF8337E2 Jan 10 16:58:42 ns3 postfix/local[1919]: local socket: wanted attribute: offset Jan 10 16:58:42 ns3 postfix/local[1919]: input attribute name: offset Jan 10 16:58:42 ns3 postfix/local[1919]: input attribute value: 329 Jan 10 16:58:42 ns3 postfix/local[1919]: local socket: wanted attribute: size Jan 10 16:58:42 ns3 postfix/local[1919]: input attribute name: size Jan 10 16:58:42 ns3 postfix/local[1919]: input attribute value: 1013 Jan 10 16:58:42 ns3 postfix/local[1919]: local socket: wanted attribute: nexthop Jan 10 16:58:42 ns3 postfix/local[1919]: input attribute name: nexthop Jan 10 16:58:42 ns3 postfix/local[1919]: input attribute value: ns3.indiaaccess.com Jan 10 16:58:42 ns3 postfix/local[1919]: local socket: wanted attribute: encoding Jan 10 16:58:42 ns3 postfix/local[1919]: input attribute name: encoding Jan 10 16:58:42 ns3 postfix/local[1919]: input attribute value: (end) Jan 10 16:58:42 ns3 postfix/local[1919]: local socket: wanted attribute: sender Jan 10 16:58:42 ns3 postfix/local[1919]: input attribute name: sender Jan 10 16:58:42 ns3 postfix/local[1919]: input attribute value: [EMAIL PROTECTED] Jan 10 16:58:42 ns3 postfix/local[1919]: local socket: wanted attribute: errors-to Jan 10 16:58:42 ns3 postfix/local[1919]: input attribute name: errors-to Jan 10 16:58:42 ns3 postfix/local[1919]: input attribute value: [EMAIL PROTECTED] Jan 10 16:58:42 ns3 postfix/local[1919]: local socket: wanted attribute: return-receipt Jan 10 16:58:42 ns3 postfix/local[1919]: input attribute name: return-receipt Jan 10 16:58:42 ns3 postfix/local[1919]: input attribute value: (end) Jan 10 16:58:42 ns3 postfix/local[1919]: local socket: wanted attribute: time Jan 10 16:58:42 ns3 postfix/local[1919]: input attribute name: time Jan 10 16:58:42 ns3 postfix/local[1919]: input attribute value: 1042198122 Jan 10 16:58:42 ns3 postfix/local[1919]: local socket: wanted attribute: offset Jan 10 16:58:42 ns3 postfix/local[1919]: input attribute name: offset Jan 10 16:58:42 ns3 postfix/local[1919]: input attribute value: 258 Jan 10 16:58:42 ns3 postfix/local[1919]: local socket: wanted attribute: original_recipient Jan 10 16:58:42 ns3 postfix/local[1919]: input attribute name: original_recipient Jan 10 16:58:42 ns3 postfix/local[1919]: input attribute value: [EMAIL PROTECTED] Jan 10 16:58:42 ns3 postfix/local[1919]: local socket: wanted attribute: recipient Jan 10 16:58:42 ns3 postfix/local[1919]: input attribute name: recipient Jan 10 16:58:42 ns3 postfix/local[1919]: input attribute value: [EMAIL PROTECTED] Jan 10 16:58:42 ns3 postfix/local[1919]: local socket: wanted attribute: offset Jan 10 16:58:42 ns3 postfix/local[1919]: input attribute name: offset Jan 10 16:58:42 ns3 postfix/local[1919]: input attribute value: 0 Jan 10 16:58:42 ns3 postfix/local[1919]: deliver_request_get: file active/0/03AF8337E2 Jan 10 16:58:42 ns3 postfix/local[1919]: local_deliver: 03AF8337E2 from [EMAIL PROTECTED] Jan 10 16:58:42 ns3 postfix/local[1919]: local_deliver[0]: reset owner attr Jan 10 16:58:42 ns3 postfix/local[1919]: local_deliver[0]: reset user_attr Jan 10 16:58:42 ns3 postfix/local[1919]: deliver_recipient[1]: local recip [EMAIL PROTECTED] exten deliver exp_from Jan 10 16:58:42 ns3 postfix/local[1919]: been_here: recipient 1 [EMAIL PROTECTED]: 0 Jan 10 16:58:42 ns3 postfix/local[1919]: level: 0 Jan 10 16:58:42 ns3 postfix/local[1919]: path: active/0/03AF8337E2 Jan 10 16:58:42 ns3 postfix/local[1919]: fp: 0x808b538 Jan 10 16:58:42 ns3 postfix/local[1919]: queue_name: active Jan 10 16:58:42 ns3 postfix/local[1919]: queue_id: 03AF8337E2 Jan 10 16:58:42 ns3 postfix/local[1919]: offset: 329 Jan 10 16:58:42 ns3 postfix/local[1919]: sender: [EMAIL PROTECTED] Jan 10 16:58:42 ns3 postfix/local[1919]: recipient: [EMAIL PROTECTED] Jan 10 16:58:42 ns3 postfix/local[1919]: domain: ns3.indiaaccess.com Jan 10 16:58:42 ns3 postfix/local[1919]: local: sarwaransari.ns3.indiaaccess.com Jan 10 16:58:42 ns3 postfix/local[1919]: user: sarwaransari.ns3.indiaaccess.com Jan 10 16:58:42 ns3 postfix/local[1919]: extension: null Jan 10 16:58:42 ns3 postfix/local[1919]: unmatched: null Jan 10 16:58:42 ns3 postfix/local[1919]: owner: null Jan 10 16:58:42 ns3 postfix/local[1919]: delivered: [EMAIL PROTECTED] Jan 10 16:58:42 ns3 postfix/local[1919]: relay: local Jan 10 16:58:42 ns3 postfix/local[1919]: exp_type: 0 Jan 10 16:58:42 ns3 postfix/local[1919]: exp_from: null Jan 10 16:58:42 ns3 postfix/local[1919]: deliver_switch[2]: local sarwaransari.ns3.indiaaccess.com recip [EMAIL PROTECTED] exten deliver [EMAIL PROTECTED] exp_from Jan 10 16:58:42 ns3 postfix/local[1919]: deliver_alias[3]: local sarwaransari.ns3.indiaaccess.com recip [EMAIL PROTECTED] exten deliver [EMAIL PROTECTED] exp_from Jan 10 16:58:42 ns3 postfix/local[1919]: dict_mysql_lookup using sql query: select dest from virtual where alias = 'sarwaransari.ns3.indiaaccess.com' and status = '1' Jan 10 16:58:42 ns3 postfix/local[1919]: dict_mysql: attempting to connect to host localhost Jan 10 16:58:42 ns3 postfix/local[1919]: dict_mysql: successful connection to host localhost Jan 10 16:58:42 ns3 postfix/local[1919]: dict_mysql: successful query from host localhost Jan 10 16:58:42 ns3 postfix/local[1919]: dict_mysql_lookup: retrieved 0 rows Jan 10 16:58:42 ns3 postfix/local[1919]: deliver_alias: mysql:/etc/postfix/mysql-virtual.cf: sarwaransari.ns3.indiaaccess.com not found Jan 10 16:58:42 ns3 postfix/local[1919]: deliver_dotforward[3]: local sarwaransari.ns3.indiaaccess.com recip [EMAIL PROTECTED] exten deliver [EMAIL PROTECTED] exp_from Jan 10 16:58:42 ns3 postfix/local[1919]: deliver_mailbox[3]: local sarwaransari.ns3.indiaaccess.com recip [EMAIL PROTECTED] exten deliver [EMAIL PROTECTED] exp_from Jan 10 16:58:42 ns3 postfix/local[1919]: been_here: mailbox sarwaransari.ns3.indiaaccess.com: 0 Jan 10 16:58:42 ns3 postfix/local[1919]: connect to subsystem private/cyrus Jan 10 16:58:42 ns3 postfix/local[1919]: private/cyrus socket: wanted attribute: status Jan 10 16:58:42 ns3 postfix/local[1919]: input attribute name: status Jan 10 16:58:42 ns3 postfix/local[1919]: input attribute value: 0 Jan 10 16:58:42 ns3 postfix/local[1919]: private/cyrus socket: wanted attribute: (list terminator) Jan 10 16:58:42 ns3 postfix/local[1919]: input attribute name: (end) Jan 10 16:58:42 ns3 postfix/local[1919]: send attr flags = 3 Jan 10 16:58:42 ns3 postfix/local[1919]: send attr queue_name = active Jan 10 16:58:42 ns3 postfix/local[1919]: send attr queue_id = 03AF8337E2 Jan 10 16:58:42 ns3 postfix/local[1919]: send attr offset = 329 Jan 10 16:58:42 ns3 postfix/local[1919]: send attr size = 1013 Jan 10 16:58:42 ns3 postfix/local[1919]: send attr nexthop = ns3.indiaaccess.com Jan 10 16:58:42 ns3 postfix/local[1919]: send attr encoding = Jan 10 16:58:42 ns3 postfix/local[1919]: send attr sender = [EMAIL PROTECTED] Jan 10 16:58:42 ns3 postfix/local[1919]: send attr errors-to = [EMAIL PROTECTED] Jan 10 16:58:42 ns3 postfix/local[1919]: send attr return-receipt = Jan 10 16:58:42 ns3 postfix/local[1919]: send attr time = 1042198122 Jan 10 16:58:42 ns3 postfix/local[1919]: send attr offset = 4294967295 Jan 10 16:58:42 ns3 postfix/local[1919]: send attr original_recipient = [EMAIL PROTECTED] Jan 10 16:58:42 ns3 postfix/local[1919]: send attr recipient = [EMAIL PROTECTED] Jan 10 16:58:42 ns3 postfix/local[1919]: send attr offset = 0 Jan 10 16:58:42 ns3 postfix/local[1919]: private/cyrus socket: wanted attribute: reason Jan 10 16:58:42 ns3 postfix/smtpd[1912]: disconnect from unknown[192.168.0.99] Jan 10 16:58:42 ns3 postfix/pipe[1921]: 03AF8337E2: to=<[EMAIL PROTECTED]>, orig_to=<[EMAIL PROTECTED]>, relay=cyrus, delay=0, status=bounced (data format error. Command output: sarwaransari.ns3.indiaaccess.com: Mailbox does not exist ) Jan 10 16:58:42 ns3 postfix/local[1919]: input attribute name: reason Jan 10 16:58:42 ns3 postfix/local[1919]: input attribute value: (end) Jan 10 16:58:42 ns3 postfix/local[1919]: private/cyrus socket: wanted attribute: status Jan 10 16:58:42 ns3 postfix/local[1919]: input attribute name: status Jan 10 16:58:42 ns3 postfix/local[1919]: input attribute value: 0 Jan 10 16:58:42 ns3 postfix/local[1919]: private/cyrus socket: wanted attribute: (list terminator) Jan 10 16:58:42 ns3 postfix/local[1919]: input attribute name: (end) Jan 10 16:58:42 ns3 postfix/local[1919]: deliver_request_final: send: "" 0 Jan 10 16:58:42 ns3 postfix/local[1919]: send attr reason = Jan 10 16:58:42 ns3 postfix/local[1919]: send attr status = 0 Jan 10 16:58:42 ns3 postfix/local[1919]: master_notify: status 1 Jan 10 16:58:42 ns3 postfix/local[1919]: connection closed Jan 10 16:58:42 ns3 postfix/local[1919]: watchdog_stop: 0x8088b20 postconf -n ------------ alias_maps = mysql:/etc/postfix/mysql-virtual.cf broken_sasl_auth_clients = yes command_directory = /usr/sbin config_directory = /etc/postfix daemon_directory = /usr/libexec/postfix debug_peer_level = 2 inet_interfaces = all local_recipient_maps = mysql:/etc/postfix/mysql-canonical.cf mail_owner = postfix mailbox_transport = cyrus mailq_path = /usr/bin/mailq manpage_directory = /usr/local/man mydestination = ns3.indiaaccess.com, mysql:/etc/postfix/mysql-mydestination.cf myhostname = ns3.indiaaccess.com mynetworks = 192.168.0.0/24, 127.0.0.0/8 newaliases_path = /usr/bin/newaliases queue_directory = /var/spool/postfix readme_directory = no sample_directory = /etc/postfix sender_canonical_maps = mysql:/etc/postfix/mysql-canonical.cf sendmail_path = /usr/sbin/sendmail setgid_group = postdrop smtpd_recipient_restrictions = permit_sasl_authenticated, check_relay_domains smtpd_sasl_auth_enable = yes smtpd_sasl_local_domain = smtpd_sasl_security_options = noanonymous soft_bounce = yes unknown_local_recipient_reject_code = 450 virtual_alias_maps = mysql:/etc/postfix/mysql-virtual.cf Cyrus ------ ns3.indiaaccess.com> ver name : Cyrus IMAPD version : v2.1.11 2002/12/04 14:53:12 vendor : Project Cyrus support-url: http://asg.web.cmu.edu/cyrus os : Linux os-version : 2.4.7-10 environment: Cyrus SASL 2.1.10 Sleepycat Software: Berkeley DB 4.0.14: (November 18, 2001) OpenSSL 0.9.6b [engine] 9 Jul 2001 CMU Sieve 2.2 TCP Wrappers mmap = shared lock = fcntl nonblock = fcntl auth = unix idle = poll mboxlist.db = db3 subs.db = flat seen.db = flat duplicate.db = db3-nosync tls.db = db3-nosync Regards Sarwar Ansari Indiaaccess
