--- mouss <[EMAIL PROTECTED]> wrote:
> Stephen Liu a écrit :
> > [snip]
> >
> > Sorry I don't have "mysql-virtual-mailbox-maps.cf" here.
> >
>
> - do 'postfix reload'
> - do a test and see if it still fails
> - after that, sow output of 'postconf -n'
reload postfix
1)
telnet localhost 25
.....
RCPT TO: [EMAIL PROTECTED]
451 4.3.0 <[EMAIL PROTECTED]>: Temporary lookup failure
# tail /var/log/mail.log
Oct 12 08:30:39 xen6 postfix/cleanup[1655]: 2D6803D810:
message-id=<[EMAIL PROTECTED]>
Oct 12 08:30:39 xen6 postfix/proxymap[1656]: warning: mysql query
failed: Unknown column 'destination' in 'field list'
Oct 12 08:30:39 xen6 postfix/cleanup[1655]: warning: 2D6803D810:
virtual_alias_maps map lookup problem for [EMAIL PROTECTED]
Oct 12 08:31:39 xen6 postfix/pickup[1653]: 2D6853D810: uid=0
from=<root>
Oct 12 08:31:39 xen6 postfix/cleanup[1655]: 2D6853D810:
message-id=<[EMAIL PROTECTED]>
Oct 12 08:31:39 xen6 postfix/cleanup[1655]: warning: 2D6853D810:
virtual_alias_maps map lookup problem for [EMAIL PROTECTED]
Oct 12 08:32:39 xen6 postfix/pickup[1653]: 4842B3D810: uid=0
from=<root>
Oct 12 08:32:39 xen6 postfix/cleanup[1655]: 4842B3D810:
message-id=<[EMAIL PROTECTED]>
Oct 12 08:32:39 xen6 postfix/proxymap[1656]: warning: mysql query
failed: Unknown column 'destination' in 'field list'
Oct 12 08:32:39 xen6 postfix/cleanup[1655]: warning: 4842B3D810:
virtual_alias_maps map lookup problem for [EMAIL PROTECTED]
# postconf -n
alias_database = hash:/etc/aliases
alias_maps = hash:/etc/aliases
append_dot_mydomain = no
biff = no
broken_sasl_auth_clients = yes
config_directory = /etc/postfix
inet_interfaces = all
mailbox_size_limit = 0
mydestination = xen6.satimis.com, satimis.com, localhost,
localhost.localdomain
myhostname = xen6.satimis.com
mynetworks = 127.0.0.0/8
myorigin = /etc/mailname
proxy_read_maps = $local_recipient_maps $mydestination
$virtual_alias_maps $virtual_alias_domains $virtual_mailbox_maps
$virtual_mailbox_domains $relay_recipient_maps $relay_domains
$canonical_maps $sender_canonical_maps $recipient_canonical_maps
$relocated_maps $transport_maps $mynetworks $virtual_mailbox_limit_maps
recipient_delimiter = +
relayhost =
smtp_tls_session_cache_database = btree:${queue_directory}/smtp_scache
smtpd_banner = $myhostname ESMTP $mail_name (Debian/GNU)
smtpd_recipient_restrictions = permit_mynetworks,
permit_sasl_authenticated, reject_unauth_destination
smtpd_sasl_auth_enable = yes
smtpd_tls_cert_file = /etc/postfix/smtpd.cert
smtpd_tls_key_file = /etc/postfix/smtpd.key
smtpd_tls_session_cache_database =
btree:${queue_directory}/smtpd_scache
smtpd_use_tls = yes
transport_maps = proxy:mysql:/etc/postfix/mysql-virtual_transports.cf
virtual_alias_domains =
virtual_alias_maps =
proxy:mysql:/etc/postfix/mysql-virtual_forwardings.cf,
mysql:/etc/postfix/mysql-virtual_email2email.cf
virtual_create_maildirsize = yes
virtual_gid_maps = static:5000
virtual_mailbox_base = /home/vmail
virtual_mailbox_domains =
proxy:mysql:/etc/postfix/mysql-virtual_domains.cf
virtual_mailbox_limit_maps =
proxy:mysql:/etc/postfix/mysql-virtual_mailbox_limit_maps.cf
virtual_mailbox_limit_override = yes
virtual_mailbox_maps =
proxy:mysql:/etc/postfix/mysql-virtual_mailboxes.cf
virtual_maildir_limit_message = "The user you are trying to reach is
over quota."
virtual_overquota_bounce = yes
virtual_uid_maps = static:5000
2)
Send a mail to [EMAIL PROTECTED]
Mail can't arrive.
# tail /var/log/mail.log
Oct 12 08:35:39 xen6 postfix/cleanup[1655]: warning: 4842F3D810:
virtual_alias_maps map lookup problem for [EMAIL PROTECTED]
Oct 12 08:36:22 xen6 postfix/smtpd[1661]: connect from
ti-out-0910.google.com[209.85.142.189]
Oct 12 08:36:22 xen6 postfix/trivial-rewrite[1657]: warning: do not
list domain satimis.com in BOTH mydestination and
virtual_mailbox_domains
Oct 12 08:36:22 xen6 postfix/proxymap[1656]: warning: mysql query
failed: Unknown column 'destination' in 'field list'
Oct 12 08:36:22 xen6 postfix/smtpd[1661]: NOQUEUE: reject: RCPT from
ti-out-0910.google.com[209.85.142.189]: 451 4.3.0
<[EMAIL PROTECTED]>: Temporary lookup failure;
from=<[EMAIL PROTECTED]> to=<[EMAIL PROTECTED]> proto=ESMTP
helo=<ti-out-0910.google.com>
Oct 12 08:36:22 xen6 postfix/cleanup[1655]: warning: CB03B3D810:
virtual_alias_maps map lookup problem for [EMAIL PROTECTED]
Oct 12 08:36:22 xen6 postfix/smtpd[1661]: disconnect from
ti-out-0910.google.com[209.85.142.189]
Oct 12 08:36:39 xen6 postfix/pickup[1653]: C9A593D810: uid=0
from=<root>
Oct 12 08:36:39 xen6 postfix/cleanup[1655]: C9A593D810:
message-id=<[EMAIL PROTECTED]>
Oct 12 08:36:39 xen6 postfix/cleanup[1655]: warning: C9A593D810:
virtual_alias_maps map lookup problem for [EMAIL PROTECTED]
> > # postmap -q [EMAIL PROTECTED]
> > mysql:/etc/postfix/mysql-virtual_mailboxes.cf
> > satimis.com/satimis/
> >
>
> so this seems to work. but the log suggests another map is being
> used.
> >
> >
> >>> [snip]
> >>> Oct 11 12:18:05 xen6 postfix/proxymap[1557]: warning: mysql query
> >>> failed: Unknown column 'destination' in 'field list'
> >>>
> >>>
> >> you have no field named "destination" in your mysql table, yet you
> >> are
> >> using it in your query.
> >>
> >
> >
> > Could you please explain in more detail.
>
>
> the query used has a "select ... destination ..." but your mysql
> table
> has no "destination" column.
Noted with thanks
B.R.
satimis
Send instant messages to your online friends http://uk.messenger.yahoo.com
