From: giovanni Scudeller on
I have this problem. I have a postfix server configured Virtal user on
mysql. When I send a mail to a virtual user arrives, if I send to an alias I
find it but try to deliver it to mailboxes that goodwill does not exist.
thanks for help ....

debug mail

Dec 2 00:01:42 relay postfix/smtpd[10583]: >>> CHECKING RECIPIENT MAPS <<<
Dec 2 00:01:42 relay postfix/smtpd[10583]: ctable_locate: move existing
entry key dragoni1(a)stnet.it
Dec 2 00:01:42 relay postfix/smtpd[10583]: dict_mysql_get_active:
attempting to connect to host 127.0.0.1
Dec 2 00:01:42 relay postfix/smtpd[10583]: dict_mysql: successful
connection to host 127.0.0.1
Dec 2 00:01:42 relay postfix/smtpd[10583]: dict_mysql: successful query
from host 127.0.0.1
Dec 2 00:01:42 relay postfix/smtpd[10583]: dict_mysql_lookup: retrieved 1
rows
Dec 2 00:01:42 relay postfix/smtpd[10583]: maps_find:
recipient_canonical_maps: mysql:/etc/postfix/maps/
mysql_virtual_alias_maps.cf(0,lock|fold_fix):
user1(a)stnet.it<dragoni1(a)stnet.it>=
user(a)stnet.it <adragoni(a)tim.eu.blackberry.com>
Dec 2 00:01:42 relay postfix/smtpd[10583]: mail_addr_find:
user1(a)stnet.it<dragoni1(a)stnet.it>->
adragoni(a)user.stnet.it <adragoni(a)tim.eu.blackberry.com>
Dec 2 00:01:42 relay postfix/smtpd[10583]: smtpd_check_rewrite: trying:
permit_inet_interfaces
Dec 2 00:01:42 relay postfix/smtpd[10583]: permit_inet_interfaces:
81-174-23-207.dynamic.ngi.it 81.174.23.207
Dec 2 00:01:42 relay postfix/smtpd[10583]: before input_transp_cleanup:
cleanup flags = enable_header_body_filter enable_automatic_bcc
enable_address_mapping enable_milters
Dec 2 00:01:42 relay postfix/smtpd[10583]: after input_transp_cleanup:
cleanup flags = enable_header_body_filter
Dec 2 00:01:42 relay postfix/smtpd[10583]: connect to subsystem
public/cleanup
Dec 2 00:01:42 relay postfix/smtpd[10583]: public/cleanup socket: wanted
attribute: queue_id
Dec 2 00:01:42 relay postfix/smtpd[10583]: input attribute name: queue_id
Dec 2 00:01:42 relay postfix/smtpd[10583]: input attribute value: 445FC7FB2
Dec 2 00:01:42 relay postfix/smtpd[10583]: public/cleanup socket: wanted
attribute: (list terminator)
Dec 2 00:01:42 relay postfix/smtpd[10583]: input attribute name: (end)
Dec 2 00:01:42 relay postfix/smtpd[10583]: send attr flags = 130
Dec 2 00:01:42 relay postfix/smtpd[10583]: 445FC7FB2: client=
81-174-23-207.dynamic.ngi.it[81.174.23.207], sasl_method=PLAIN,
sasl_username=sender(a)stnet.it <giovanni(a)stnet.it>
Dec 2 00:01:42 relay postfix/smtpd[10583]: >
81-174-23-207.dynamic.ngi.it[81.174.23.207]:
250 2.1.5 Ok
Dec 2 00:01:42 relay postfix/smtpd[10583]: <
81-174-23-207.dynamic.ngi.it[81.174.23.207]:
DATA
Dec 2 00:01:42 relay postfix/smtpd[10583]: >
81-174-23-207.dynamic.ngi.it[81.174.23.207]:
354 End data with <CR><LF>.<CR><LF>
Dec 2 00:01:42 relay postfix/cleanup[10588]: 445FC7FB2: message-id=<
4B159FED.3040600(a)stnet.it>
Dec 2 00:01:42 relay postfix/qmgr[10581]: 445FC7FB2: from=<sender(a)stnet.it>,
size=536, nrcpt=1 (queue active)
Dec 2 00:01:42 relay postfix/smtpd[10583]: public/cleanup socket: wanted
attribute: status
Dec 2 00:01:42 relay postfix/smtpd[10583]: input attribute name: status
Dec 2 00:01:42 relay postfix/smtpd[10583]: input attribute value: 0
Dec 2 00:01:42 relay postfix/smtpd[10583]: public/cleanup socket: wanted
attribute: reason
Dec 2 00:01:42 relay postfix/smtpd[10583]: input attribute name: reason
Dec 2 00:01:42 relay postfix/smtpd[10583]: input attribute value: (end)
Dec 2 00:01:42 relay postfix/smtpd[10583]: >
81-174-23-207.dynamic.ngi.it[81.174.23.207]:
250 2.0.0 Ok: queued as 445FC7FB2
Dec 2 00:01:42 relay postfix/virtual[10589]: 445FC7FB2: to=<user1(a)stnet.it>,
relay=virtual, delay=0.27, delays=0.23/0.01/0/0.03, dsn=5.1.1,
status=bounced (unknown user: "user1(a)stnet.it")
From: Magnus =?iso-8859-1?Q?B=E4ck?= on
On Thursday, December 03, 2009 at 10:40 CET,
giovanni Scudeller <giovanniscudeller(a)gmail.com> wrote:

> I have this problem. I have a postfix server configured Virtal user on
> mysql. When I send a mail to a virtual user arrives, if I send to an
> alias I find it but try to deliver it to mailboxes that goodwill does
> not exist. thanks for help ....

[...]

> Dec 2 00:01:42 relay postfix/virtual[10589]: 445FC7FB2: to=<user1(a)stnet.it>,
> relay=virtual, delay=0.27, delays=0.23/0.01/0/0.03, dsn=5.1.1,
> status=bounced (unknown user: "user1(a)stnet.it")

Turn of verbose logging and post "postconf -n" output.

--
Magnus B�ck
magnus(a)dsek.lth.se