--- mouss <[EMAIL PROTECTED]> wrote: > Stephen Liu a écrit : > > - > > > > 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] > > > > one of your virtual_alias_maps is wrong. run the following command. > > # postmap -q [EMAIL PROTECTED] > mysql:/etc/postfix/mysql-virtual_forwardings.cf
# postmap -q [EMAIL PROTECTED] mysql:/etc/postfix/mysql-virtual_forwardings.cf postmap: warning: mysql query failed: Unknown column 'destination' in 'field list' > If it succeeds (I doubt it), then run postmap one the other virtual > alias map: > # postmap -q [EMAIL PROTECTED] > mysql:/etc/postfix/mysql-virtual_email2email.cf # postmap -q [EMAIL PROTECTED] mysql:/etc/postfix/mysql-virtual_email2email.cf [EMAIL PROTECTED] > One of these files use a "destination" field, but your mysql table > doesn't have such a field. > > If you don't find the problem, show the content of these .cf files. > and please don't change the names and config in the middle. we can't > help you debug 1001 configurations (your original post contained: > mysql-virtual-mailbox-maps.cf....). # cat /etc/postfix/mysql-virtual_forwardings.cf user = mail_admin password = mypass dbname = mail table = forwardings select_field = destination where_field = source hosts = 127.0.0.1 # cat /etc/postfix/mysql-virtual_email2email.cf user = mail_admin password = mypass dbname = mail table = users select_field = email where_field = email hosts = 127.0.0.1 > > [snip] > > mydestination = xen6.satimis.com, satimis.com, localhost, > > localhost.localdomain > > > > you are listing satimis.com in mydestination and in > virtual_mailbox_domains. a domain must not be listed in multiple > classes. If the domain is supposed to be a virtual mailbox domain, > remove it from mydestination. Read > http://www.postfix.org/ADDRESS_CLASS_README.html > for more infos. Removed. Thanks. I just added it there to see whether it helps. > > [snip] > > virtual_alias_maps = > > proxy:mysql:/etc/postfix/mysql-virtual_forwardings.cf, > > mysql:/etc/postfix/mysql-virtual_email2email.cf > > why not also use "proxy:" for the second file as well? Add "proxy:" virtual_alias_maps = proxy:mysql:/etc/postfix/mysql-virtual_forwardings.cf, proxy:mysql:/etc/postfix/mysql-virtual_email2email.cf (one line) B.R. Stephen L Send instant messages to your online friends http://uk.messenger.yahoo.com
