Send Copy To / Maildrop filter forwarding not working

[jluros]

I tried creating a new mailbox on one of the domains hosted on my server which is a catchall for the domain. Mail gets delivered to the user fine, but forwards are not, using either the "send copy to" option or a custom mail filter recipe in the form cc "!user@forwardrecipient.com"

Any thoughts?

[till]

Which tutorial did you use to install the server?

[jluros]

I had started with another tutorial, but then I used Perfect Server for Ubuntu 9.04:

http://www.howtoforge.com/perfect-se...04-ispconfig-3

While it's possible that there might be some legacy stuff in there from the initial tutorial I used, it's somewhat unlikely that is the culprit. The server has been working flawlessly for a year and a half.

I would appreciate any pointers as to how to diagnose the "send copy to" / mail filter issue.

[falko]

Are there any errors in your mail log (in the /var/log/ directory)?

[jluros]

I have plenty of errors in mail.err. The most common one (every few minutes) is of the form:

Jan 28 07:52:54 mail postfix/trivial-rewrite[2678]: fatal: proxy:mysql:/etc/postfix/mysql-virtual_domains.cf(0,lock|fold_fix): table lookup problem.

Sometimes I also get:

Jan 26 18:45:04 mail postfix/error[2958]: fatal: mysql:/etc/postfix/mysql-virtual_relaydomains.cf(0,lock|fold_fix): table lookup problem

I have my mysql connections turned pretty far down:

grep connection /etc/mysql/my.cnf:
max_user_connections=60
max_connections=100


Also, timeouts are low:

grep time /etc/mysql/my.cnf:
interactive_timeout=10
long_query_time = 2
wait_timeout=40
connect_timeout=30

This is because I'm on a slice/server with 256mb of ram.

[falko]

Are the MySQL details in /etc/postfix/mysql-virtual_domains.cf correct? Does your Postfix come with MySQL support? What's the output of

netstat -tap

?

I think you might have to allow more MySQL connections, and I recommend you use at least 512MB RAM for your server.

[jluros]

The details in /etc/postfix/mysql-virtual_domains.cf are correct.

netstat -tap:
Active Internet connections (servers and established)
Proto Recv-Q Send-Q Local Address Foreign Address State PID/Program name
tcp 0 0 localhost:10024 *:* LISTEN 7597/amavisd (maste
tcp 0 0 localhost:10025 *:* LISTEN 7810/master
tcp 0 0 localhost:mysql *:* LISTEN 6696/mysqld
tcp 0 0 localhost:11211 *:* LISTEN 5254/memcached
tcp 0 0 *:http-alt *:* LISTEN 11365/apache2
tcp 0 0 *:www *:* LISTEN 11365/apache2
tcp 0 0 *:30000 *:* LISTEN 4104/sshd
tcp 0 0 *:tproxy *:* LISTEN 11365/apache2
tcp 0 0 *:8082 *:* LISTEN 11365/apache2
tcp 0 0 10.176.164.138:domain *:* LISTEN 7979/mydns
tcp 0 0 mail.jasonluros.:domain *:* LISTEN 7979/mydns
tcp 0 0 localhost:domain *:* LISTEN 7979/mydns
tcp 0 0 *:ftp *:* LISTEN 5831/pure-ftpd (SER
tcp 0 0 *:smtp *:* LISTEN 7810/master
tcp 0 0 *:https *:* LISTEN 11365/apache2
tcp 0 240 mail.jasonluros.c:30000 adsl-76-242-31-16:44188 ESTABLISHED 26326/sshd: jluros
tcp 1 0 localhost:55750 localhost:mysql CLOSE_WAIT 25761/amavisd (ch19
tcp 0 0 mail.jasonluros.com:www 198.185.25.56:48312 TIME_WAIT -
tcp 0 0 mail.jasonluros.c:41622 mail2.countywebsit:smtp ESTABLISHED 26369/smtp
tcp 0 0 mail.jasonluros.c:47528 74.125.229.51:www TIME_WAIT -
tcp 0 0 localhost:mysql localhost:55763 TIME_WAIT -
tcp 1 0 localhost:36061 localhost:mysql CLOSE_WAIT 26246/amavisd (ch2-
tcp 0 0 mail.jasonluros.com:www 209.107.79.49:7951 FIN_WAIT2 -
tcp 0 0 mail.jasonluros.c:47529 74.125.229.51:www TIME_WAIT -
tcp 0 0 localhost:mysql localhost:55760 TIME_WAIT -
tcp6 0 0 [::]:imaps [::]:* LISTEN 5735/couriertcpd
tcp6 0 0 [::]op3s [::]:* LISTEN 5773/couriertcpd
tcp6 0 0 [::]op3 [::]:* LISTEN 5751/couriertcpd
tcp6 0 0 [::]:imap2 [::]:* LISTEN 5713/couriertcpd
tcp6 0 0 [::]:30000 [::]:* LISTEN 4104/sshd
tcp6 0 0 localhost:domain [::]:* LISTEN 7979/mydns
tcp6 0 0 [::]:ftp [::]:* LISTEN 5831/pure-ftpd (SER

[falko]

Do you use 127.0.0.1 or localhost in /etc/postfix/mysql-virtual_domains.cf?