View Single Post
  #10  
Old 2nd July 2009, 22:37
digitalage digitalage is offline
Junior Member
 
Join Date: Jun 2009
Posts: 17
Thanks: 0
Thanked 0 Times in 0 Posts
Default

I changed that and the issue is still there. During my research in logs, I found some lines which might or might not be related to this issue. I took them before the last change - you can see the date:

Code:
Jun 30 18:15:07 postfix/pickup[7303]: F0157A3551: uid=0 from=<root>
Jun 30 18:15:13 postfix/master[4812]: warning: service "smtp" (25) has reached its process limit "100": new clients may experience noticeable delays
Jun 30 18:15:13 postfix/master[4812]: warning: to avoid this condition, increase the process count in master.cf or reduce the service time per client
Jun 30 18:15:13 postfix/master[4812]: warning: see http://www.postfix.org/STRESS_README.html for examples of stress-adapting configuration settings
...
Jul  1 09:27:32 209-145-MZA-enternet postfix/smtpd[7724]: fatal: watchdog timeout
Jul  1 09:27:33 postfix/master[4812]: warning: process /usr/lib/postfix/smtpd pid 7724 exit status 1
Jul  1 09:27:33 postfix/master[4812]: warning: /usr/lib/postfix/smtpd: bad command startup -- throttling
...
Jul  1 11:02:12 postfix/trivial-rewrite[4191]: fatal: proxy:mysql:/etc/postfix/mysql-virtual_domains.cf(0,lock|fold_fix): table lookup problem
Jul  1 11:02:13 postfix/qmgr[4068]: warning: problem talking to service rewrite: Success
Jul  1 11:02:13 postfix/master[3306]: warning: process /usr/lib/postfix/trivial-rewrite pid 4191 exit status 1
Jul  1 11:02:13 postfix/master[3306]: warning: /usr/lib/postfix/trivial-rewrite: bad command startup -- throttling
Jul  1 11:02:35 postfix/qmgr[4068]: fatal: watchdog timeout
Jul  1 11:02:36 postfix/master[3306]: warning: process /usr/lib/postfix/qmgr pid 4068 exit status 1
Jul  1 11:02:36 postfix/master[3306]: warning: /usr/lib/postfix/qmgr: bad command startup -- throttling

I checked the config using the following commands:
# cat /etc/postfix/mysql-virtual_domains.cf
Code:
user = mail_admin
password = xxx
dbname = mail
query = SELECT domain AS virtual FROM domains WHERE domain='%s'
hosts = 127.0.0.1
# cat /etc/postfix/mysql-virtual_* | grep user
Code:
user = mail_admin
user = mail_admin
query = SELECT email FROM users WHERE email='%s'
user = mail_admin
user = mail_admin
query = SELECT CONCAT(SUBSTRING_INDEX(email,'@',-1),'/',SUBSTRING_INDEX(email,'@',1),'/') FROM users WHERE email='%s'
user = mail_admin
query = SELECT quota FROM users WHERE email='%s'
user = mail_admin
# cat /etc/postfix/mysql-virtual_* | grep dbname
Code:
dbname = mail
dbname = mail
dbname = mail
dbname = mail
dbname = mail
dbname = mail
# cat /etc/postfix/mysql-virtual_* | grep query
Code:
query = SELECT domain AS virtual FROM domains WHERE domain='%s'
query = SELECT email FROM users WHERE email='%s'
query = SELECT destination FROM forwardings WHERE source='%s'
query = SELECT CONCAT(SUBSTRING_INDEX(email,'@',-1),'/',SUBSTRING_INDEX(email,'@',1),'/') FROM users WHERE email='%s'
query = SELECT quota FROM users WHERE email='%s'
query = SELECT transport FROM transport WHERE domain='%s'
# cat /etc/postfix/mysql-virtual_* | grep hosts
Code:
hosts = 127.0.0.1
hosts = 127.0.0.1
hosts = 127.0.0.1
hosts = 127.0.0.1
hosts = 127.0.0.1
hosts = 127.0.0.1
Everything looks good. However, if I look at my logs, I see lines that I don't know to "translate". Particularly, these:
Code:
Jul  2 23:29:24 postfix/proxymap[3859]: warning: connect to mysql server 127.0.0.1: Lost connection to MySQL server at 'reading initial communication packet', system error: 0
and
Code:
Jul  2 23:29:24 postfix/trivial-rewrite[3923]: fatal: proxy:mysql:/etc/postfix/mysql-virtual_domains.cf(0,lock|fold_fix): table lookup problem
I don't know what is proxymap and proxy:mysql. Are you kind to explain me (maybe it's useful for others too), like to a novice, how the system works? How is the email received by the server and what is its way to the mailbox, in this particular setup?
Reply With Quote