Recipient address rejected: User unknown in virtual mailbox table
 

Hi guys,
I recently configured a postfix mail server with mysql backend,amavis and spamassassin with three domains.Everything works fine except that,mails for two of the virtual domains is not accepted by postfix.That the users do not exist in the virtual table, yet they are in the users table of mysql,alongside the users of the only virtual domain for whom mails are recieved.
Below is the bounced message that is sent,

Hi. This is the qmail-send program at linuxsolutions.co.ug.
I'm afraid I wasn't able to deliver your message to the following addresses.
This is a permanent error; I've given up. Sorry it didn't work out.

<linuxsols@dwd.go.ug>:
207.44.176.108 does not like recipient.
Remote host said: 550 <linuxsols@dwd.go.ug>: Recipient address rejected: User unknown in virtual mailbox table
Giving up on 207.44.176.108.

and here are my main.cf configs

readme_directory = no
myhostname = server.example.com
mynetworks = 127.0.0.0/8, x.x.x.x/24, x.x.x.x/24, x.x.x.x/24
mydestination = $myhostname, localhost, localhost.localdomain
virtual_alias_domains =
transport_maps = mysql:/etc/postfix/mysql-virtual_transports.cf
virtual_alias_maps = mysql:/etc/postfix/mysql-virtual_forwardings.cf, mysql:/etc/postfix/mysql-virtual_email2email.cf
virtual_gid_maps = static:5000
virtual_mailbox_base = /home/vmail
virtual_mailbox_domains = mysql:/etc/postfix/mysql-virtual_domains.cf
virtual_mailbox_limit = 512000000
virtual_mailbox_maps = mysql:/etc/postfix/mysql-virtual_mailboxes.cf
virtual_transport = virtual
virtual_uid_maps = static:5000
virtual_create_maildirsize = yes
virtual_mailbox_extended = yes
virtual_mailbox_limit_maps = mysql:/etc/postfix/mysql-virtual_mailbox_limit_maps.cf
virtual_mailbox_limit_override = yes
virtual_maildir_limit_message = "The user you are trying to reach is over quota"
virtual_overquota_bounce = yes
alias_maps = hash:/etc/aliases
#
#
strict_rfc821_envelopes = yes
disable_vrfy_command = yes
smtpd_helo_required = yes
smtpd_client_restrictions =
smtpd_helo_restrictions =
smtpd_sender_restrictions =
smtpd_recipient_restrictions = permit_mynetworks,
reject_unauth_destination,
reject_unknown_recipient_domain,
reject_unauth_pipelining,
reject_non_fqdn_recipient,
reject_invalid_hostname,
reject_unauth_pipelining,
reject_non_fqdn_sender,
reject_unknown_sender_domain,
reject_non_fqdn_recipient,
reject_unknown_recipient_domain,
reject_rbl_client bl.spamcop.net,
reject_rbl_client sbl.spamhaus.org,
reject_rbl_client cbl.abuseat.org,
reject_rbl_client list.dsbl.org
reject_rbl_client blackholes.easynet.nl,
reject_rbl_client proxies.blackholes.wirehub.net,
reject_rbl_client opm.blitzed.org,
reject_rbl_client dnsbl.njabl.org,
reject_rbl_client multihop.dsbl.org,
check_policy_service inet:127.0.0.1:10023,
permit
content_filter = amavis:[127.0.0.1]:10024
receive_override_options = no_address_mappings

And here is what I added to my master.cf,in addition to the normal config

amavis unix - - n - 2 smtp
-o smtp_data_done_timeout=1200
-o smtp_send_xforward_command=yes

127.0.0.1:10025 inet n - n - - smtpd
-o content_filter=
-o local_recipient_maps=
-o relay_recipient_maps=
-o smtpd_restriction_classes=
-o smtpd_client_restrictions=
-o smtpd_helo_restrictions=
-o smtpd_sender_restrictions=
-o smtpd_recipient_restrictions=permit_mynetworks,reject
-o mynetworks=127.0.0.0/8
-o strict_rfc821_envelopes=yes
-o receive_override_options=no_unknown_recipient_checks,no_header_body_checks
-o smtpd_bind_address=127.0.0.1

COULD ANYONE BE KNOWING I DID WRONG?

More information:
When I send from one of the virtual domains on the same server,it gets delivered,but mails that come from without,are the ones which bounce.
Can some one please help?

Let's start by posting complete (from submission to delivery or rejection) postfix logs showing successful delivery to some address from the same server, and also logs showing unsuccessful delivery to the same address from the outside.

Example of a delivered mail:
postfix/virtual[13064]: 97A165B44E: to=<linuxsols@dwd.go.ug>, relay=virtual, delay=0.18, delays=0.12/0/0/0.06, dsn=2.0.0, status=sent (delivered to maildir)


Example of rejected mail:
<linuxsols@dwd.go.ug>:
207.44.176.108 does not like recipient.
Remote host said: 550 <linuxsols@dwd.go.ug>: Recipient address rejected: User unknown in virtual mailbox table
Giving up on 207.44.176.10

1. Please post complete logs, showing all stages of the delivery process, from submission to delivery or rejection.

2. The second log you posted is a rejection by a remote host. Was it from the postfix box? Make sure to post complete logs as in (1) above.

3. The IP address 207.44.176.10 resolves to a computer that does not seem to be running a mail server. What is the relationship between that address and your domain?

1. Please post complete logs, showing all stages of the delivery process, from submission to delivery or rejection.

Aug 25 08:32:02 mail postfix/smtpd[18304]: disconnect from unknown[221.209.47.154]
Aug 25 08:32:03 mail postfix/smtpd[19074]: connect from web50305.mail.re2.yahoo.com[206.190.38.59]
Aug 25 08:32:23 mail postfix/smtpd[19092]: connect from mx2.utlonline.co.ug[81.199.21.116]
Aug 25 08:32:23 mail postfix/smtpd[18304]: connect from netserva.lfucg.com[199.165.138.12]
Aug 25 08:32:28 mail postfix/smtpd[18304]: NOQUEUE: reject: RCPT from netserva.lfucg.com[199.165.138.12]: 554 5.7.1 Service unavailable; Client host [199.165.138.12] blocked using bl.spamcop.net; Blocked - see http://www.spamcop.net/bl.shtml?199.165.138.12; from=<contact@slriv.com> to=<social-scientist@dwd.co.ug> proto=SMTP helo=<netserva.lfucg.com>
Aug 25 08:32:29 mail postfix/smtpd[18304]: disconnect from netserva.lfucg.com[199.165.138.12]
Aug 25 08:32:31 mail postfix/smtpd[19074]: warning: 59.38.190.206.opm.blitzed.org: RBL lookup error: Host or domain name not found. Name service error for name=59.38.190.206.opm.blitzed.org type=A: Host not found, try again
Aug 25 08:32:36 mail postfix/smtpd[19074]: A5A37592C5: client=web50305.mail.re2.yahoo.com[206.190.38.59]
Aug 25 08:32:38 mail postfix/cleanup[19101]: A5A37592C5: message-id=<241063.22857.qm@web50305.mail.re2.yahoo.com>
Aug 25 08:32:38 mail postfix/qmgr[28721]: A5A37592C5: from=<tomsleen.linux@yahoo.com>, size=3107, nrcpt=1 (queue active)
Aug 25 08:32:38 mail amavis[17002]: (17002-06) ESMTP::10024 /var/spool/amavis/amavis-20070825T074946-17002: <tomsleen.linux@yahoo.com> -> <byaruhanga@dwd.co.ug> Received: SIZE=3107 BODY=8BITMIME from mail.dwd.co.ug ([127.0.0.1]) by localhost (mail [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 17002-06 for <byaruhanga@dwd.co.ug>; Sat, 25 Aug 2007 08:32:38 +0300 (EAT)
Aug 25 08:32:38 mail amavis[17002]: (17002-06) Checking: <tomsleen.linux@yahoo.com> -> <byaruhanga@dwd.co.ug>
Aug 25 08:32:39 mail postfix/smtpd[19074]: disconnect from web50305.mail.re2.yahoo.com[206.190.38.59]
Aug 25 08:32:39 mail amavis[17002]: (17002-06) spam_scan: hits=0.001 tests=HTML_MESSAGE
Aug 25 08:32:39 mail amavis[17002]: (17002-06) FWD via SMTP: [127.0.0.1]:10025 <tomsleen.linux@yahoo.com> -> <byaruhanga@dwd.co.ug>
Aug 25 08:32:39 mail postfix/smtpd[19109]: connect from localhost[127.0.0.1]
Aug 25 08:32:39 mail postfix/smtpd[19109]: ED9225AF48: client=localhost[127.0.0.1]
Aug 25 08:32:40 mail postfix/cleanup[19101]: ED9225AF48: message-id=<241063.22857.qm@web50305.mail.re2.yahoo.com>
Aug 25 08:32:40 mail postfix/qmgr[28721]: ED9225AF48: from=<tomsleen.linux@yahoo.com>, size=3522, nrcpt=1 (queue active)
Aug 25 08:32:40 mail postfix/smtpd[19109]: disconnect from localhost[127.0.0.1]
Aug 25 08:32:40 mail amavis[17002]: (17002-06) Passed, <tomsleen.linux@yahoo.com> -> <byaruhanga@dwd.co.ug>, Message-ID: <241063.22857.qm@web50305.mail.re2.yahoo.com>, Hits: 0.001
Aug 25 08:32:40 mail amavis[17002]: (17002-06) TIMING [total 1386 ms] - SMTP EHLO: 1 (0%), SMTP pre-MAIL: 0 (0%), SMTP pre-DATA-flush: 1 (0%), SMTP DATA: 40 (3%), body hash: 0 (0%), lookup_sql: 1 (0%), mime_decode: 11 (1%), get-file-type: 15 (1%), get-file-type: 11 (1%), decompose_part: 2 (0%), decompose_part: 0 (0%), parts: 0 (0%), AV-scan-1: 1114 (80%), SA msg read: 2 (0%), SA parse: 3 (0%), SA check: 70 (5%), fwd-connect: 11 (1%), fwd-mail-from: 1 (0%), fwd-rcpt-to: 2 (0%), write-header: 2 (0%), fwd-data: 0 (0%), fwd-data-end: 93 (7%), fwd-rundown: 0 (0%), unlink-2-files: 3 (0%), rundown: 0 (0%)
Aug 25 08:32:40 mail postfix/smtp[19105]: A5A37592C5: to=<byaruhanga@dwd.co.ug>, relay=127.0.0.1[127.0.0.1]:10024, delay=36, delays=34/0.01/0/1.4, dsn=2.6.0, status=sent (250 2.6.0 Ok, id=17002-06, from MTA: 250 2.0.0 Ok: queued as ED9225AF48)
Aug 25 08:32:40 mail postfix/qmgr[28721]: A5A37592C5: removed
Aug 25 08:32:40 mail postfix/virtual[19112]: ED9225AF48: to=<byaruhanga@dwd.co.ug>, relay=virtual, delay=0.16, delays=0.1/0.01/0/0.06, dsn=2.0.0, status=sent (delivered to maildir)
Aug 25 08:32:40 mail postfix/qmgr[28721]: ED9225AF48: removed
Aug 25 08:32:45 mail postfix/smtpd[19092]: warning: 116.21.199.81.opm.blitzed.org: RBL lookup error: Host or domain name not found. Name service error for name=116.21.199.81.opm.blitzed.org type=A: Host not found, try again
Aug 25 08:32:46 mail postfix/smtpd[19092]: NOQUEUE: reject: RCPT from mx2.utlonline.co.ug[81.199.21.116]: 550 5.1.1 <ctor@dwd.co.ug>: Recipient address rejected: User unknown in virtual mailbox table; from=<nbyjeirox@kyit.net> to=<ctor@dwd.co.ug> proto=ESMTP helo=<mx.utlonline.co.ug>
Aug 25 08:32:46 mail dovecot: auth-worker(default): mysql: Connected to localhost (mail)
Aug 25 08:32:46 mail dovecot: imap-login: Login: user=<twinomujuni.wrmd@dwd.co.ug>, method=PLAIN, rip=127.0.0.1, lip=127.0.0.1, secured
Aug 25 08:32:46 mail dovecot: IMAP(twinomujuni.wrmd@dwd.co.ug): Effective uid=5000, gid=5000
Aug 25 08:32:46 mail dovecot: IMAP(twinomujuni.wrmd@dwd.co.ug): maildir: data=/home/vmail/dwd.co.ug/twinomujuni.wrmd
Aug 25 08:32:46 mail dovecot: IMAP(twinomujuni.wrmd@dwd.co.ug): maildir: root=/home/vmail/dwd.co.ug/twinomujuni.wrmd, index=/home/vmail/dwd.co.ug/twinomujuni.wrmd, control=, inbox=
Aug 25 08:32:46 mail dovecot: IMAP(twinomujuni.wrmd@dwd.co.ug): Disconnected: Logged out
Aug 25 08:32:46 mail dovecot: imap-login: Login: user=<twinomujuni.wrmd@dwd.co.ug>, method=PLAIN, rip=127.0.0.1, lip=127.0.0.1, secured
Aug 25 08:32:46 mail dovecot: IMAP(twinomujuni.wrmd@dwd.co.ug): Effective uid=5000, gid=5000
Aug 25 08:32:46 mail dovecot: IMAP(twinomujuni.wrmd@dwd.co.ug): maildir: data=/home/vmail/dwd.co.ug/twinomujuni.wrmd
Aug 25 08:32:46 mail dovecot: IMAP(twinomujuni.wrmd@dwd.co.ug): maildir: root=/home/vmail/dwd.co.ug/twinomujuni.wrmd, index=/home/vmail/dwd.co.ug/twinomujuni.wrmd, control=, inbox=
Aug 25 08:32:46 mail dovecot: IMAP(twinomujuni.wrmd@dwd.co.ug): Disconnected: Logged out
Aug 25 08:32:47 mail dovecot: imap-login: Login: user=<twinomujuni.wrmd@dwd.co.ug>, method=PLAIN, rip=127.0.0.1, lip=127.0.0.1, secured
Aug 25 08:32:47 mail dovecot: IMAP(twinomujuni.wrmd@dwd.co.ug): Effective uid=5000, gid=5000
Aug 25 08:32:47 mail dovecot: IMAP(twinomujuni.wrmd@dwd.co.ug): maildir: data=/home/vmail/dwd.co.ug/twinomujuni.wrmd
Aug 25 08:32:47 mail dovecot: IMAP(twinomujuni.wrmd@dwd.co.ug): maildir: root=/home/vmail/dwd.co.ug/twinomujuni.wrmd, index=/home/vmail/dwd.co.ug/twinomujuni.wrmd, control=, inbox=
Aug 25 08:32:47 mail dovecot: IMAP(twinomujuni.wrmd@dwd.co.ug): Disconnected: Logged out
Aug 25 08:32:48 mail postfix/smtpd[18304]: warning: 88.242.31.19: hostname dsl88.242-7955.ttnet.net.tr verification failed: Name or service not known
Aug 25 08:32:48 mail postfix/smtpd[18304]: connect from unknown[88.242.31.19]
Aug 25 08:32:55 mail postfix/smtpd[18304]: NOQUEUE: reject: RCPT from unknown[88.242.31.19]: 554 5.7.1 Service unavailable; Client host [88.242.31.19] blocked using bl.spamcop.net; Blocked - see http://www.spamcop.net/bl.shtml?88.242.31.19; from=<kxrxvvfnodnk@bramptonaudiology.com> to=<mukwaya.wrmd@dwd.co.ug> proto=ESMTP helo=<dsl88.242-7955.ttnet.net.tr>
Aug 25 08:32:55 mail postfix/smtpd[19092]: disconnect from mx2.utlonline.co.ug[81.199.21.116]
Aug 25 08:32:56 mail postfix/smtpd[18304]: lost connection after DATA from unknown[88.242.31.19]
Aug 25 08:32:56 mail postfix/smtpd[18304]: disconnect from unknown[88.242.31.19]

I had actually sent a mail to both byaruhanga@dwd.co.ug and ls@dwd.go.ug from my yahoo account.Mail for dwd.co.ug got delivered but dwd.go.ug never even log any rejection for the user though it sends a rejection mail back to my yahoo account with code 550.
The log below now shows mail sent from dwd.co.ug to dwd.go.ug

Aug 25 08:51:19 mail postfix/smtpd[19074]: connect from localhost[127.0.0.1]
Aug 25 08:51:19 mail postfix/smtpd[19074]: 5A6235B863: client=localhost[127.0.0.1]
Aug 25 08:51:19 mail postfix/cleanup[20122]: 5A6235B863: message-id=<59090.81.199.17.19.1188021079.squirrel@mail.dwd.co.ug>
Aug 25 08:51:19 mail postfix/qmgr[28721]: 5A6235B863: from=<linuxsols@dwd.co.ug>, size=732, nrcpt=1 (queue active)
Aug 25 08:51:19 mail postfix/smtpd[19074]: disconnect from localhost[127.0.0.1]
Aug 25 08:51:19 mail dovecot: imap-login: Login: user=<linuxsols@dwd.co.ug>, method=PLAIN, rip=127.0.0.1, lip=127.0.0.1, secured
Aug 25 08:51:19 mail amavis[18694]: (18694-05) ESMTP::10024 /var/spool/amavis/amavis-20070825T083411-18694: <linuxsols@dwd.co.ug> -> <ls@dwd.go.ug> Received: SIZE=732 BODY=8BITMIME from mail.dwd.co.ug ([127.0.0.1]) by localhost (mail [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 18694-05 for <ls@dwd.go.ug>; Sat, 25 Aug 2007 08:51:19 +0300 (EAT)
Aug 25 08:51:19 mail dovecot: IMAP(linuxsols@dwd.co.ug): Effective uid=5000, gid=5000
Aug 25 08:51:19 mail dovecot: IMAP(linuxsols@dwd.co.ug): maildir: data=/home/vmail/dwd.co.ug/linuxsols
Aug 25 08:51:19 mail dovecot: IMAP(linuxsols@dwd.co.ug): maildir: root=/home/vmail/dwd.co.ug/linuxsols, index=/home/vmail/dwd.co.ug/linuxsols, control=, inbox=
Aug 25 08:51:19 mail amavis[18694]: (18694-05) Checking: <linuxsols@dwd.co.ug> -> <ls@dwd.go.ug>
Aug 25 08:51:19 mail amavis[18694]: (18694-05) WARN: all primary virus scanners failed, considering backups
Aug 25 08:51:20 mail dovecot: IMAP(linuxsols@dwd.co.ug): Disconnected: Logged out
Aug 25 08:51:20 mail dovecot: imap-login: Login: user=<linuxsols@dwd.co.ug>, method=PLAIN, rip=127.0.0.1, lip=127.0.0.1, secured
Aug 25 08:51:20 mail dovecot: IMAP(linuxsols@dwd.co.ug): Effective uid=5000, gid=5000
Aug 25 08:51:20 mail dovecot: IMAP(linuxsols@dwd.co.ug): maildir: data=/home/vmail/dwd.co.ug/linuxsols
Aug 25 08:51:20 mail dovecot: IMAP(linuxsols@dwd.co.ug): maildir: root=/home/vmail/dwd.co.ug/linuxsols, index=/home/vmail/dwd.co.ug/linuxsols, control=, inbox=
Aug 25 08:51:20 mail amavis[18694]: (18694-05) spam_scan: hits=-98.461 tests=ALL_TRUSTED,TVD_SPACE_RATIO,USER_IN_WHITELIST
Aug 25 08:51:20 mail amavis[18694]: (18694-05) FWD via SMTP: [127.0.0.1]:10025 <linuxsols@dwd.co.ug> -> <ls@dwd.go.ug>
Aug 25 08:51:20 mail postfix/smtpd[20138]: connect from localhost[127.0.0.1]
Aug 25 08:51:20 mail postfix/smtpd[20138]: 6F0A25B8CD: client=localhost[127.0.0.1]
Aug 25 08:51:20 mail dovecot: IMAP(linuxsols@dwd.co.ug): Disconnected: Logged out
Aug 25 08:51:20 mail postfix/cleanup[20122]: 6F0A25B8CD: message-id=<59090.81.199.17.19.1188021079.squirrel@mail.dwd.co.ug>
Aug 25 08:51:20 mail postfix/qmgr[28721]: 6F0A25B8CD: from=<linuxsols@dwd.co.ug>, size=1131, nrcpt=1 (queue active)
Aug 25 08:51:20 mail postfix/smtpd[20138]: disconnect from localhost[127.0.0.1]
Aug 25 08:51:20 mail amavis[18694]: (18694-05) Passed, <linuxsols@dwd.co.ug> -> <ls@dwd.go.ug>, Message-ID: <59090.81.199.17.19.1188021079.squirrel@mail.dwd.co.ug>, Hits: -98.461
Aug 25 08:51:20 mail amavis[18694]: (18694-05) TIMING [total 1091 ms] - SMTP EHLO: 1 (0%), SMTP pre-MAIL: 0 (0%), SMTP pre-DATA-flush: 1 (0%), SMTP DATA: 39 (4%), body hash: 0 (0%), lookup_sql: 1 (0%), mime_decode: 7 (1%), get-file-type: 14 (1%), decompose_part: 2 (0%), parts: 0 (0%), AV-scan-1: 880 (81%), SA msg read: 2 (0%), SA parse: 3 (0%), SA check: 36 (3%), fwd-connect: 4 (0%), fwd-mail-from: 1 (0%), fwd-rcpt-to: 2 (0%), write-header: 2 (0%), fwd-data: 0 (0%), fwd-data-end: 92 (8%), fwd-rundown: 1 (0%), unlink-1-files: 3 (0%), rundown: 0 (0%)
Aug 25 08:51:20 mail postfix/smtp[20133]: 5A6235B863: to=<ls@dwd.go.ug>, relay=127.0.0.1[127.0.0.1]:10024, delay=1.2, delays=0.09/0/0/1.1, dsn=2.6.0, status=sent (250 2.6.0 Ok, id=18694-05, from MTA: 250 2.0.0 Ok: queued as 6F0A25B8CD)
Aug 25 08:51:20 mail postfix/qmgr[28721]: 5A6235B863: removed
Aug 25 08:51:28 mail dovecot: imap-login: Login: user=<twinomujuni.wrmd@dwd.co.ug>, method=PLAIN, rip=127.0.0.1, lip=127.0.0.1, secured
Aug 25 08:51:28 mail dovecot: IMAP(twinomujuni.wrmd@dwd.co.ug): Effective uid=5000, gid=5000
Aug 25 08:51:28 mail dovecot: IMAP(twinomujuni.wrmd@dwd.co.ug): maildir: data=/home/vmail/dwd.co.ug/twinomujuni.wrmd
Aug 25 08:51:28 mail dovecot: IMAP(twinomujuni.wrmd@dwd.co.ug): maildir: root=/home/vmail/dwd.co.ug/twinomujuni.wrmd, index=/home/vmail/dwd.co.ug/twinomujuni.wrmd, control=, inbox=
Aug 25 08:51:28 mail dovecot: IMAP(twinomujuni.wrmd@dwd.co.ug): Disconnected: Logged out
Aug 25 08:51:42 mail postfix/smtpd[19357]: warning: 170.221.39.59.opm.blitzed.org: RBL lookup error: Host or domain name not found. Name service error for name=170.221.39.59.opm.blitzed.org type=A: Host not found, try again
Aug 25 08:51:44 mail postfix/smtpd[19357]: NOQUEUE: reject: RCPT from unknown[59.39.221.170]: 450 4.7.1 <hhs@dwd.co.ug>: Recipient address rejected: Greylisted, see http://isg.ee.ethz.ch/tools/postgrey...wd.co.ug.html; from=<a-2-z@jersey.net> to=<hhs@dwd.co.ug> proto=ESMTP helo=<170.221.39.59.broad.dg.gd.dynamic.163data.com.cn>
Aug 25 08:51:45 mail postfix/smtpd[19385]: connect from mx2.utlonline.co.ug[81.199.21.116]



2. The second log you posted is a rejection by a remote host. Was it from the postfix box? Make sure to post complete logs as in (1) above.

It wasn't on the postfix box but from it

3. The IP address 207.44.176.10 resolves to a computer that does not seem to be running a mail server. What is the relationship between that address and your domain?

207.44.176.10 is the external IP of my router with NAT