postfix + cyrus + mysql; Mailbox does not exist

Sarwar Ansari sarwar at indiaaccess.com
Fri Jan 10 09:18:01 EST 2003 

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 at ntcomputer>
Jan 10 16:58:42 ns3 postfix/qmgr[1906]: 03AF8337E2:
from=<webmaster at indiaaccess.com>, 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:
webmaster at indiaaccess.com
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:
webmaster at indiaaccess.com
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:
sarwaransari at ns3.indiaaccess.com
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:
sarwaransari.ns3.indiaaccess.com at ns3.indiaaccess.com
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
webmaster at indiaaccess.com
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 sarwaransari.ns3.indiaaccess.com at ns3.indiaaccess.com exten
deliver  exp_from
Jan 10 16:58:42 ns3 postfix/local[1919]: been_here: recipient 1
sarwaransari.ns3.indiaaccess.com at ns3.indiaaccess.com: 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:
webmaster at indiaaccess.com
Jan 10 16:58:42 ns3 postfix/local[1919]: recipient:
sarwaransari.ns3.indiaaccess.com at ns3.indiaaccess.com
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:
sarwaransari.ns3.indiaaccess.com at ns3.indiaaccess.com
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
sarwaransari.ns3.indiaaccess.com at ns3.indiaaccess.com exten  deliver
sarwaransari.ns3.indiaaccess.com at ns3.indiaaccess.com exp_from
Jan 10 16:58:42 ns3 postfix/local[1919]: deliver_alias[3]: local
sarwaransari.ns3.indiaaccess.com recip
sarwaransari.ns3.indiaaccess.com at ns3.indiaaccess.com exten  deliver
sarwaransari.ns3.indiaaccess.com at ns3.indiaaccess.com 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
sarwaransari.ns3.indiaaccess.com at ns3.indiaaccess.com exten  deliver
sarwaransari.ns3.indiaaccess.com at ns3.indiaaccess.com exp_from
Jan 10 16:58:42 ns3 postfix/local[1919]: deliver_mailbox[3]: local
sarwaransari.ns3.indiaaccess.com recip
sarwaransari.ns3.indiaaccess.com at ns3.indiaaccess.com exten  deliver
sarwaransari.ns3.indiaaccess.com at ns3.indiaaccess.com 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 =
webmaster at indiaaccess.com
Jan 10 16:58:42 ns3 postfix/local[1919]: send attr errors-to =
webmaster at indiaaccess.com
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 =
sarwaransari at ns3.indiaaccess.com
Jan 10 16:58:42 ns3 postfix/local[1919]: send attr recipient =
sarwaransari.ns3.indiaaccess.com at ns3.indiaaccess.com
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=<sarwaransari.ns3.indiaaccess.com at ns3.indiaaccess.com>,
orig_to=<sarwaransari at ns3.indiaaccess.com>, 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

More information about the Info-cyrus mailing list