View Single Post
  #5  
Old 6th June 2010, 11:50
freesqrt freesqrt is offline
Member
 
Join Date: Dec 2007
Posts: 82
Thanks: 7
Thanked 1 Time in 1 Post
Default

Hey Claucian,

yes you were right. there is some misconfig in mysql parameters in postfix.

I have uninstall/reinstall ISPConfig several times. however I change the database name during the installation process, the "dbname" in files mysql-virtual_relaydomains.cf and mysql-virtual_domains.cf are remained "dbispconfig" !!!!!

when a user try to send a mail following log has been generate:

#############################
Jun 6 14:15:47 mx1 dovecot: imap-login: Login: user=<web1_ahb>, method=PLAIN, rip=::ffff:127.0.0.1, lip=::ffff:127.0.0.1, secured
Jun 6 14:15:47 mx1 sendmail[10060]: o569jlha010060: Authentication-Warning: mx1.domainclf.com: admispconfig set sender to ahb@domainclf.com using -f
Jun 6 14:15:47 mx1 sendmail[10060]: o569jlha010060: from=ahb@domainclf.com, size=339, class=0, nrcpts=1, msgid=<4b342ab181545cf6029c092573407fee@localhost> , relay=admispconfig@localhost
Jun 6 14:15:47 mx1 postfix/smtpd[10061]: connect from mx1.domainclf.com[127.0.0.1]
Jun 6 14:15:47 mx1 postfix/smtpd[10061]: setting up TLS connection from mx1.domainclf.com[127.0.0.1]
Jun 6 14:15:47 mx1 sendmail[10060]: STARTTLS=client, relay=[127.0.0.1], version=TLSv1/SSLv3, verify=FAIL, cipher=DHE-RSA-AES256-SHA, bits=256/256
Jun 6 14:15:47 mx1 postfix/smtpd[10061]: Anonymous TLS connection established from mx1.domainclf.com[127.0.0.1]: TLSv1 with cipher DHE-RSA-AES256-SHA (256/256 bits)
Jun 6 14:16:07 mx1 postfix/proxymap[10062]: warning: connect to mysql server 127.0.0.1: Access denied for user 'ispconfig'@'localhost' to database 'dbispconfig'
Jun 6 14:16:07 mx1 postfix/proxymap[10062]: warning: mysql query failed: Table 'db_ispconfig.mail_domain' doesn't exist
Jun 6 14:16:07 mx1 postfix/trivial-rewrite[10075]: fatal: proxy:mysql:/etc/postfix/mysql-virtual_domains.cf(0,lock|fold_fix): table lookup problem
Jun 6 14:16:08 mx1 postfix/smtpd[10061]: warning: problem talking to service rewrite: Connection reset by peer
Jun 6 14:16:08 mx1 postfix/qmgr[10019]: warning: problem talking to service rewrite: Success
Jun 6 14:16:08 mx1 postfix/master[10016]: warning: process /usr/libexec/postfix/trivial-rewrite pid 10075 exit status 1
Jun 6 14:16:08 mx1 postfix/master[10016]: warning: /usr/libexec/postfix/trivial-rewrite: bad command startup -- throttling

Jun 6 14:17:08 mx1 postfix/proxymap[10062]: warning: connect to mysql server 127.0.0.1: Access denied for user 'ispconfig'@'localhost' to database 'dbispconfig'
Jun 6 14:17:08 mx1 postfix/proxymap[10062]: warning: mysql query failed: Table 'db_ispconfig.mail_domain' doesn't exist
Jun 6 14:17:08 mx1 postfix/trivial-rewrite[10107]: fatal: proxy:mysql:/etc/postfix/mysql-virtual_domains.cf(0,lock|fold_fix): table lookup problem
Jun 6 14:17:09 mx1 postfix/qmgr[10019]: warning: problem talking to service rewrite: Success
Jun 6 14:17:09 mx1 postfix/smtpd[10061]: warning: problem talking to service rewrite: Connection reset by peer
Jun 6 14:17:09 mx1 postfix/master[10016]: warning: process /usr/libexec/postfix/trivial-rewrite pid 10107 exit status 1
Jun 6 14:17:09 mx1 postfix/master[10016]: warning: /usr/libexec/postfix/trivial-rewrite: bad command startup -- throttling

#############################

the problem is there is no "mail_domain" table in db_ispconfig!!!!!!

what you think about this misconfig?
Thankyou,
__________________
freesqrt
Reply With Quote