Go Back   HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials > Linux Forums > Installation/Configuration

Do you like HowtoForge? Please consider supporting us by becoming a subscriber.
Reply
 
Thread Tools Display Modes
  #91  
Old 8th January 2011, 15:15
kmullen kmullen is offline
Member
 
Join Date: Oct 2007
Posts: 33
Thanks: 0
Thanked 0 Times in 0 Posts
Default mail.err log

This is the mail.err log:

Jan 7 16:47:34 ISPCONFIG authdaemond: failed to connect to mysql server (server=localhost, userid=ispconfig): Can't connect to local MySQL server through s$
Jan 7 16:47:34 ISPCONFIG pop3d: authentication error: Input/output error
Jan 7 16:47:38 ISPCONFIG authdaemond: failed to connect to mysql server (server=localhost, userid=ispconfig): Can't connect to local MySQL server through s$
Jan 7 16:47:38 ISPCONFIG pop3d: authentication error: Input/output error
Jan 7 16:48:04 ISPCONFIG authdaemond: failed to connect to mysql server (server=localhost, userid=ispconfig): Can't connect to local MySQL server through s$
Jan 7 16:48:04 ISPCONFIG pop3d: authentication error: Input/output error
Jan 7 16:49:27 ISPCONFIG authdaemond: failed to connect to mysql server (server=localhost, userid=ispconfig): Can't connect to local MySQL server through s$
Jan 7 16:49:27 ISPCONFIG pop3d: authentication error: Input/output error
Jan 7 16:50:02 ISPCONFIG amavis[1031]: (01031-01) (!!)TROUBLE in process_request: connect_to_sql: unable to connect to any dataset at (eval 115) line 241, $
Jan 7 16:50:02 ISPCONFIG postfix/smtp[2377]: fatal: mysql:/etc/postfix/mysql-virtual_relaydomains.cf(0,lock|fold_fix): table lookup problem
Jan 7 16:50:03 ISPCONFIG postfix/error[2380]: fatal: mysql:/etc/postfix/mysql-virtual_relaydomains.cf(0,lock|fold_fix): table lookup problem
Jan 7 16:50:04 ISPCONFIG postfix/qmgr[1723]: fatal: mysql:/etc/postfix/mysql-virtual_relaydomains.cf(0,lock|fold_fix): table lookup problem
Jan 7 17:01:44 ISPCONFIG postfix/smtp[2884]: fatal: mysql:/etc/postfix/mysql-virtual_relaydomains.cf(0,lock|fold_fix): table lookup problem
Jan 7 17:01:45 ISPCONFIG postfix/error[2923]: fatal: mysql:/etc/postfix/mysql-virtual_relaydomains.cf(0,lock|fold_fix): table lookup problem
Jan 7 17:01:46 ISPCONFIG postfix/qmgr[2444]: fatal: mysql:/etc/postfix/mysql-virtual_relaydomains.cf(0,lock|fold_fix): table lookup problem
Jan 7 17:03:25 ISPCONFIG authdaemond: failed to connect to mysql server (server=localhost, userid=ispconfig): Can't connect to local MySQL server through s$
Jan 7 17:03:25 ISPCONFIG pop3d: authentication error: Input/output error
Jan 7 17:03:50 ISPCONFIG authdaemond: failed to connect to mysql server (server=localhost, userid=ispconfig): Can't connect to local MySQL server through s$
Jan 7 17:03:50 ISPCONFIG pop3d: authentication error: Input/output error
Jan 7 17:03:52 ISPCONFIG authdaemond: failed to connect to mysql server (server=localhost, userid=ispconfig): Can't connect to local MySQL server through s$
Jan 7 17:03:52 ISPCONFIG pop3d: authentication error: Input/output error
Jan 7 17:03:53 ISPCONFIG authdaemond: failed to connect to mysql server (server=localhost, userid=ispconfig): Can't connect to local MySQL server through s$
Jan 7 17:03:53 ISPCONFIG pop3d: authentication error: Input/output error
Jan 7 17:03:56 ISPCONFIG authdaemond: failed to connect to mysql server (server=localhost, userid=ispconfig): Can't connect to local MySQL server through s$
Jan 7 17:03:56 ISPCONFIG pop3d: authentication error: Input/output error
Jan 7 17:08:19 ISPCONFIG authdaemond: failed to connect to mysql server (server=localhost, userid=ispconfig): Can't connect to local MySQL server through s$
Jan 7 17:08:19 ISPCONFIG pop3d: authentication error: Input/output error
Jan 7 17:37:55 ISPCONFIG postfix/trivial-rewrite[2867]: fatal: proxy:mysql:/etc/postfix/mysql-virtual_domains.cf(0,lock|fold_fix): table lookup problem
Jan 7 17:37:57 ISPCONFIG postfix/trivial-rewrite[3538]: fatal: proxy:mysql:/etc/postfix/mysql-virtual_domains.cf(0,lock|fold_fix): table lookup problem
Reply With Quote
Sponsored Links
  #92  
Old 9th January 2011, 19:51
falko falko is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 41,701
Thanks: 1,900
Thanked 2,741 Times in 2,575 Posts
Default

What's the output of
Code:
netstat -tap
?
__________________
Falko
--
Download the ISPConfig 3 Manual! | Check out the ISPConfig 3 Billing Module!

FB: http://www.facebook.com/howtoforge

nginx-Webhosting: Timme Hosting | Follow me on:
Reply With Quote
  #93  
Old 9th January 2011, 20:06
kmullen kmullen is offline
Member
 
Join Date: Oct 2007
Posts: 33
Thanks: 0
Thanked 0 Times in 0 Posts
Default Netstat results

root@ISPCONFIG:/# 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.localdo:10024 *:* LISTEN 962/amavisd (master
tcp 0 0 localhost.localdo:10025 *:* LISTEN 12356/master
tcp 0 0 *:mysql *:* LISTEN 3544/mysqld
tcp 0 0 *:submission *:* LISTEN 12356/master
tcp 0 0 localhost.localdo:spamd *:* LISTEN 974/spamd.pid
tcp 0 0 *:http-alt *:* LISTEN 1744/apache2
tcp 0 0 *:www *:* LISTEN 1744/apache2
tcp 0 0 *:ssmtp *:* LISTEN 12356/master
tcp 0 0 *:tproxy *:* LISTEN 1744/apache2
tcp 0 0 *:2323 *:* LISTEN 9173/sshd
Reply With Quote
  #94  
Old 9th January 2011, 20:28
kmullen kmullen is offline
Member
 
Join Date: Oct 2007
Posts: 33
Thanks: 0
Thanked 0 Times in 0 Posts
Default Here is the total output

root@ISPCONFIG:/# netstat -top
Active Internet connections (w/o servers)
Proto Recv-Q Send-Q Local Address Foreign Address State PID/Program name Timer
^C
root@ISPCONFIG:/# 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.localdo:10024 *:* LISTEN 962/amavisd (master
tcp 0 0 localhost.localdo:10025 *:* LISTEN 12356/master
tcp 0 0 *:mysql *:* LISTEN 3544/mysqld
tcp 0 0 *:submission *:* LISTEN 12356/master
tcp 0 0 localhost.localdo:spamd *:* LISTEN 974/spamd.pid
tcp 0 0 *:http-alt *:* LISTEN 1744/apache2
tcp 0 0 *:www *:* LISTEN 1744/apache2
tcp 0 0 *:ssmtp *:* LISTEN 12356/master
tcp 0 0 *:tproxy *:* LISTEN 1744/apache2
tcp 0 0 *:2323 *:* LISTEN 9173/sshd
tcp 0 0 192.168.15.130:domain *:* LISTEN 822/named
tcp 0 0 ISPCONFIG.practi:domain *:* LISTEN 822/named
tcp 0 0 localhost.locald:domain *:* LISTEN 822/named
tcp 0 0 *:smtp *:* LISTEN 12356/master
tcp 0 0 localhost.localdoma:953 *:* LISTEN 822/named
tcp 0 0 *:https *:* LISTEN 1744/apache2
tcp 0 0 localhost.localdo:53859 localhost.localdo:mysql TIME_WAIT -
tcp 0 0 localhost.localdo:mysql localhost.localdo:53870 ESTABLISHED 3544/mysqld
tcp 0 0 localhost.localdo:53866 localhost.localdo:mysql ESTABLISHED 11936/error
tcp 0 0 localhost.localdo:53862 localhost.localdo:mysql ESTABLISHED 11927/smtp
tcp 0 0 localhost.localdo:53868 localhost.localdo:mysql ESTABLISHED 11941/error
tcp 0 0 localhost.localdo:mysql localhost.localdo:36076 ESTABLISHED 3544/mysqld
tcp 0 0 localhost.localdo:53858 localhost.localdo:mysql TIME_WAIT -
tcp 0 0 localhost.localdo:mysql localhost.localdo:53867 ESTABLISHED 3544/mysqld
tcp 0 52 ISPCONFIG.practica:2323 206.109.239.51:2927 ESTABLISHED 11865/sshd: adminis
tcp 0 0 localhost.localdo:53867 localhost.localdo:mysql ESTABLISHED 11939/error
tcp 0 0 localhost.localdo:53870 localhost.localdo:mysql ESTABLISHED 11937/error
tcp 0 0 localhost.localdo:53865 localhost.localdo:mysql ESTABLISHED 11928/smtp
tcp 0 0 localhost.localdo:40483 localhost.localdo:mysql ESTABLISHED 29964/amavisd (ch10
tcp 0 0 localhost.localdo:mysql localhost.localdo:40483 ESTABLISHED 3544/mysqld
tcp 0 0 localhost.localdo:mysql localhost.localdo:53865 ESTABLISHED 3544/mysqld
tcp 0 0 localhost.localdo:mysql localhost.localdo:53869 ESTABLISHED 3544/mysqld
tcp 0 0 localhost.localdo:mysql localhost.localdo:53868 ESTABLISHED 3544/mysqld
tcp 0 0 localhost.localdo:53863 localhost.localdo:mysql ESTABLISHED 11926/smtp
tcp 0 0 localhost.localdo:36076 localhost.localdo:mysql ESTABLISHED 6209/amavisd (ch4-a
tcp 0 0 localhost.localdo:53869 localhost.localdo:mysql ESTABLISHED 11929/smtp
tcp 0 0 localhost.localdo:mysql localhost.localdo:53863 ESTABLISHED 3544/mysqld
tcp 0 0 localhost.localdo:mysql localhost.localdo:53862 ESTABLISHED 3544/mysqld
tcp 0 0 localhost.localdo:mysql localhost.localdo:53864 ESTABLISHED 3544/mysqld
tcp6 0 0 [::]:imaps [::]:* LISTEN 1521/couriertcpd
tcp6 0 0 [::]op3s [::]:* LISTEN 1555/couriertcpd
tcp6 0 0 [::]op3 [::]:* LISTEN 1535/couriertcpd
tcp6 0 0 [::]:imap2 [::]:* LISTEN 1501/couriertcpd
tcp6 0 0 [::]:2323 [::]:* LISTEN 9173/sshd
tcp6 0 0 [::]:domain [::]:* LISTEN 822/named
tcp6 0 0 localhost:953 [::]:* LISTEN 822/named
getnameinfo failed
tcp6 0 0 ISPCONFIG.practic:imap2 [UNKNOWN]:5102 ESTABLISHED 10854/couriertls
getnameinfo failed
tcp6 0 0 ISPCONFIG.practic:imap2 [UNKNOWN]:58873 ESTABLISHED 12146/imapd
getnameinfo failed
tcp6 0 0 ISPCONFIG.practic:imap2 [UNKNOWN]:61655 ESTABLISHED 9639/couriertls
getnameinfo failed
tcp6 0 0 ISPCONFIG.practic:imap2 [UNKNOWN]:57854 ESTABLISHED 2669/imapd
getnameinfo failed
tcp6 0 0 ISPCONFIG.practicaop3 [UNKNOWN]:64999 TIME_WAIT -
Reply With Quote
  #95  
Old 10th January 2011, 02:41
kmullen kmullen is offline
Member
 
Join Date: Oct 2007
Posts: 33
Thanks: 0
Thanked 0 Times in 0 Posts
Default

This might be the problem.

Jan 9 19:10:03 ISPCONFIG postfix/smtp[12717]: 9D04220682: to=, relay=none, delay=0.12, delays=0.07/0.02/0.04/0, dsn=5.4.4, status=bounced (Host or domain name not found. Name service error for name=ISPCONFIG.familymullen.org type=A: Host not found)

"familymullen.org" was the name assigned to the server when I installed ISPCONFIG at home.

I have checked the following files and the hostname is correct.
/etc/hostname, /etc/hosts

The domain, familymullen.org is not hosted on this server.
Reply With Quote
  #96  
Old 10th January 2011, 13:34
falko falko is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 41,701
Thanks: 1,900
Thanked 2,741 Times in 2,575 Posts
Default

Can you check if all your mysql*.cf files in the /etc/postfix/ directory use the line
Code:
hosts = 127.0.0.1
instead of
Code:
hosts = localhost
?
__________________
Falko
--
Download the ISPConfig 3 Manual! | Check out the ISPConfig 3 Billing Module!

FB: http://www.facebook.com/howtoforge

nginx-Webhosting: Timme Hosting | Follow me on:
Reply With Quote
  #97  
Old 10th January 2011, 14:16
kmullen kmullen is offline
Member
 
Join Date: Oct 2007
Posts: 33
Thanks: 0
Thanked 0 Times in 0 Posts
Default

All of the mysql*.cf files use the line:

Hosts = 127.0.0.1

Files checked:


root@ISPCONFIG:/# find -name mysql*.cf
./etc/postfix/mysql-virtual_mailboxes.cf
./etc/postfix/mysql-virtual_email2email.cf
./etc/postfix/mysql-virtual_domains.cf
./etc/postfix/mysql-virtual_relayrecipientmaps.cf
./etc/postfix/mysql-virtual_recipient.cf
./etc/postfix/mysql-virtual_relaydomains.cf
./etc/postfix/mysql-virtual_client.cf
./etc/postfix/mysql-virtual_transports.cf
./etc/postfix/mysql-virtual_forwardings.cf
./etc/postfix/mysql-virtual_sender.cf
Reply With Quote
  #98  
Old 11th January 2011, 14:13
falko falko is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 41,701
Thanks: 1,900
Thanked 2,741 Times in 2,575 Posts
Default

That's ok. Do you still have MySQL errors in your mail log?

Quote:
Jan 9 19:10:03 ISPCONFIG postfix/smtp[12717]: 9D04220682: to=, relay=none, delay=0.12, delays=0.07/0.02/0.04/0, dsn=5.4.4, status=bounced (Host or domain name not found. Name service error for name=ISPCONFIG.familymullen.org type=A: Host not found)
Please create an A record for ISPCONFIG.familymullen.org.
__________________
Falko
--
Download the ISPConfig 3 Manual! | Check out the ISPConfig 3 Billing Module!

FB: http://www.facebook.com/howtoforge

nginx-Webhosting: Timme Hosting | Follow me on:
Reply With Quote
  #99  
Old 11th January 2011, 14:46
kmullen kmullen is offline
Member
 
Join Date: Oct 2007
Posts: 33
Thanks: 0
Thanked 0 Times in 0 Posts
Default

I will do that but that domain is hosted on a different server at another location.
Reply With Quote
  #100  
Old 11th January 2011, 14:54
kmullen kmullen is offline
Member
 
Join Date: Oct 2007
Posts: 33
Thanks: 0
Thanked 0 Times in 0 Posts
 
Default

Still seeing this.

Jan 10 19:38:23 ISPCONFIG postfix/smtpd[22472]: warning: SASL authentication failure: cannot connect to saslauthd server: No such file or directory
Jan 10 19:38:23 ISPCONFIG postfix/smtpd[22472]: warning: wsip-70-167-114-111.sd.sd.cox.net[70.167.114.111]: SASL LOGIN authentication failed: generic failure
Jan 10 19:38:33 ISPCONFIG postfix/smtpd[22460]: warning: SASL authentication failure: cannot connect to saslauthd server: No such file or directory
Jan 10 19:38:33 ISPCONFIG postfix/smtpd[22460]: warning: wsip-70-167-114-111.sd.sd.cox.net[70.167.114.111]: SASL LOGIN authentication failed: generic failure

Not seeing SQL error in mail.err log
Reply With Quote
Reply

Bookmarks

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Relay access denied maxx Installation/Configuration 17 4th April 2011 12:34
Access denied in phpMyAdmin linuxfast General 1 21st September 2005 16:08
Access Denied on Port: 81 nandhu Installation/Configuration 2 10th August 2005 14:05


All times are GMT +2. The time now is 10:28.


Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2014, vBulletin Solutions, Inc.