Prev Previous Post   Next Post Next
  #11  
Old 19th March 2010, 16:47
fooboo fooboo is offline
Member
 
Join Date: Sep 2009
Posts: 49
Thanks: 1
Thanked 1 Time in 1 Post
Default

I've worked out that I can connect to mysql using 'localhost' but not '127.0.0.1' so I'm guessing somewhere ISPConfig is configured to use 127.0.0.1 instead of localhost.
I either need to get mysql to consider 127.0.0.1 to be local host or find the setting in ispconfig and change it to localhost...I don't know how to do either.

netstat -tap gave me the following:

Code:
Active Internet connections (servers and established)
Proto Recv-Q Send-Q Local Address               Foreign Address             State       PID/Program name
tcp        0      0 *:806                       *:*                         LISTEN      1896/rpc.statd
tcp        0      0 localhost.localdomain:10024 *:*                         LISTEN      2403/amavisd (maste
tcp        0      0 localhost.localdomain:10025 *:*                         LISTEN      2494/master
tcp        0      0 mail.<my_domain>.net:mysql      *:*                         LISTEN      2323/mysqld
tcp        0      0 localhost.local:dyna-access *:*                         LISTEN      2233/clamd
tcp        0      0 *:sunrpc                    *:*                         LISTEN      1846/portmap
tcp        0      0 *:ftp                       *:*                         LISTEN      2547/pure-ftpd (SER
tcp        0      0 mail.<my_domain>.net:domain     *:*                         LISTEN      2359/mydns
tcp        0      0 localhost.localdomai:domain *:*                         LISTEN      2359/mydns
tcp        0      0 localhost.localdomain:ipp   *:*                         LISTEN      2218/cupsd
tcp        0      0 *:smtp                      *:*                         LISTEN      2494/master
tcp       35      0 mail.<my_domain>.net:50932      relay.<pop_domain>.net:pop3        CLOSE_WAIT  13670/python
tcp       38      0 localhost.localdomain:smtp  localhost.localdomain:44673 CLOSE_WAIT  10228/smtpd
tcp        1      0 localhost.localdomain:smtp  localhost.localdomain:53057 CLOSE_WAIT  4882/smtpd
tcp       38      0 localhost.localdomain:smtp  localhost.localdomain:42337 CLOSE_WAIT  15193/smtpd
tcp        1      0 mail.<my_domain>.net:smtp       mail-1.<smtp_domain>.net:50196   CLOSE_WAIT  8613/smtpd
tcp       35      0 mail.<my_domain>.net:60542      pop.<pop_domain>.net:pop3         CLOSE_WAIT  16284/python
tcp       38      0 localhost.localdomain:smtp  localhost.localdomain:37955 CLOSE_WAIT  14424/smtpd
tcp        0      0 localhost.localdomain:smtp  localhost.localdomain:52259 ESTABLISHED 12879/smtpd
tcp        0      0 localhost.localdomain:smtp  localhost.localdomain:44708 ESTABLISHED 16331/smtpd
tcp        1      0 localhost.localdomain:smtp  localhost.localdomain:43972 CLOSE_WAIT  6314/smtpd
tcp        1      0 localhost.localdomain:smtp  localhost.localdomain:59204 CLOSE_WAIT  10467/smtpd
tcp        0      0 localhost.localdomain:smtp  localhost.localdomain:40901 ESTABLISHED 13284/smtpd
tcp        1      0 mail.<my_domain>.net:smtp       mail-1.<smtp_domain>.net:15602   CLOSE_WAIT  13822/smtpd
tcp       35      0 mail.<my_domain>.net:33514      relay.<pop_domain>.net:pop3        CLOSE_WAIT  15843/python
tcp       35      0 mail.<my_domain>.net:58038      relay.<pop_domain>.net:pop3        CLOSE_WAIT  14091/python
tcp        1      0 localhost.localdomain:smtp  localhost.localdomain:53765 CLOSE_WAIT  8147/smtpd
tcp        1      0 localhost.localdomain:smtp  localhost.localdomain:44645 CLOSE_WAIT  8904/smtpd
tcp        1      0 localhost.localdomain:smtp  localhost.localdomain:49896 CLOSE_WAIT  7760/smtpd
tcp        1      0 mail.<my_domain>.net:smtp       mail-1.<smtp_domain>.net:41727   CLOSE_WAIT  3946/smtpd
tcp        1      0 localhost.localdomain:smtp  localhost.localdomain:34345 CLOSE_WAIT  9682/smtpd
tcp        0      0 localhost.localdomain:smtp  localhost.localdomain:37130 ESTABLISHED 15463/smtpd
tcp       35      0 mail.<my_domain>.net:36115      relay.<pop_domain>.net:pop3        CLOSE_WAIT  12007/python
tcp        1      0 localhost.localdomain:smtp  localhost.localdomain:56267 CLOSE_WAIT  9275/smtpd
tcp        1      0 localhost.localdomain:smtp  localhost.localdomain:33035 CLOSE_WAIT  10852/smtpd
tcp        0      0 localhost.localdomain:smtp  localhost.localdomain:46091 ESTABLISHED 12450/smtpd
tcp       35      0 mail.<my_domain>.net:43972      relay.<pop_domain>.net:pop3        CLOSE_WAIT  16760/python
tcp        1      0 mail.<my_domain>.net:smtp       mail-1.<smtp_domain>.net:55867   CLOSE_WAIT  11635/smtpd
tcp       38      0 localhost.localdomain:smtp  localhost.localdomain:37773 CLOSE_WAIT  5715/smtpd
tcp       38      0 localhost.localdomain:smtp  localhost.localdomain:53069 CLOSE_WAIT  5101/smtpd
tcp       35      0 mail.<my_domain>.net:35335      relay.<pop_domain>.net:pop3        CLOSE_WAIT  14968/python
tcp        1      0 mail.<my_domain>.net:smtp       mail-1.<smtp_domain>.net:32856   CLOSE_WAIT  5716/smtpd
tcp        1      0 localhost.localdomain:smtp  localhost.localdomain:57743 CLOSE_WAIT  4196/smtpd
tcp        0      0 localhost.localdomain:smtp  localhost.localdomain:43887 ESTABLISHED 12050/smtpd
tcp        0      0 localhost.localdomain:smtp  localhost.localdomain:45936 ESTABLISHED 14578/smtpd
tcp        1      0 localhost.localdomain:smtp  localhost.localdomain:38641 CLOSE_WAIT  4546/smtpd
tcp        1      0 mail.<my_domain>.net:smtp       mail-ww0-f54.google.c:41119 CLOSE_WAIT  13335/smtpd
tcp       35      0 mail.<my_domain>.net:56261      pop.<pop_domain>.net:pop3         CLOSE_WAIT  13241/python
tcp        0      0 localhost.localdomain:smtp  localhost.localdomain:53428 ESTABLISHED 16807/smtpd
tcp        1      0 localhost.localdomain:smtp  localhost.localdomain:44661 CLOSE_WAIT  10059/smtpd
tcp        1      0 localhost.localdomain:smtp  localhost.localdomain:53301 CLOSE_WAIT  11264/smtpd
tcp        1      0 localhost.localdomain:smtp  localhost.localdomain:55478 CLOSE_WAIT  3534/smtpd
tcp        0      0 localhost.localdomain:smtp  localhost.localdomain:45526 ESTABLISHED 13716/smtpd
tcp        1      0 localhost.localdomain:smtp  localhost.localdomain:54038 CLOSE_WAIT  7032/smtpd
tcp       35      0 mail.<my_domain>.net:36914      relay.<pop_domain>.net:pop3        CLOSE_WAIT  12408/python
tcp        1      0 localhost.localdomain:smtp  localhost.localdomain:37911 CLOSE_WAIT  7408/smtpd
tcp        0      0 localhost.localdomain:smtp  localhost.localdomain:37943 ESTABLISHED 14133/smtpd
tcp        0      0 localhost.localdomain:smtp  localhost.localdomain:42327 ESTABLISHED 15010/smtpd
tcp        1      0 localhost.localdomain:smtp  localhost.localdomain:53977 CLOSE_WAIT  3871/smtpd
tcp       35      0 mail.<my_domain>.net:48848      relay.<pop_domain>.net:pop3        CLOSE_WAIT  15422/python
tcp        1      0 localhost.localdomain:smtp  localhost.localdomain:53177 CLOSE_WAIT  11652/smtpd
tcp        1      0 localhost.localdomain:smtp  localhost.localdomain:50713 CLOSE_WAIT  3177/smtpd
tcp        1      0 localhost.localdomain:smtp  localhost.localdomain:59994 CLOSE_WAIT  5961/smtpd
tcp       38      0 localhost.localdomain:smtp  localhost.localdomain:56283 CLOSE_WAIT  9517/smtpd
tcp        0      0 localhost.localdomain:smtp  localhost.localdomain:36060 ESTABLISHED 15898/smtpd
tcp       35      0 mail.<my_domain>.net:45773      pop.<pop_domain>.net:pop3         CLOSE_WAIT  14536/python
tcp        1      0 localhost.localdomain:smtp  localhost.localdomain:46301 CLOSE_WAIT  5242/smtpd
tcp       35      0 mail.<my_domain>.net:47564      relay.<pop_domain>.net:pop3        CLOSE_WAIT  12832/python
tcp        1      0 localhost.localdomain:smtp  localhost.localdomain:48254 CLOSE_WAIT  6686/smtpd
tcp        1      0 localhost.localdomain:smtp  localhost.localdomain:50623 CLOSE_WAIT  8512/smtpd
tcp        1      0 localhost.localdomain:smtp  localhost.localdomain:37759 CLOSE_WAIT  5584/smtpd
tcp        0      0 *:imaps                     *:*                         LISTEN      2421/couriertcpd
tcp        0      0 *:pop3s                     *:*                         LISTEN      2433/couriertcpd
tcp        0      0 *:pop3                      *:*                         LISTEN      2427/couriertcpd
tcp        0      0 *:imap                      *:*                         LISTEN      2414/couriertcpd
tcp        0      0 *:webcache                  *:*                         LISTEN      2528/httpd
tcp        0      0 *:http                      *:*                         LISTEN      2528/httpd
tcp        0      0 *:ftp                       *:*                         LISTEN      2547/pure-ftpd (SER
tcp        0      0 localhost6.localdoma:domain *:*                         LISTEN      2359/mydns
tcp        0      0 *:ssh                       *:*                         LISTEN      2203/sshd
tcp        0      0 *:https                     *:*                         LISTEN      2528/httpd
tcp        0      0 mail.<my_domain>.net:imap       host<my_IP>:mediacntrlnfsd ESTABLISHED 3058/imapd
tcp        0      0 localhost.localdomain:40901 localhost.localdomain:smtp  ESTABLISHED 13304/o2JEt7wr01330
tcp        0      0 localhost.localdomain:45526 localhost.localdomain:smtp  ESTABLISHED 13732/o2JF06fc01373
tcp        0      0 localhost.localdomain:37130 localhost.localdomain:smtp  ESTABLISHED 15483/o2JFK6nT01548
tcp        0      0 localhost.localdomain:53428 localhost.localdomain:smtp  ESTABLISHED 16823/o2JFZ6vw01682
tcp        0      0 localhost.localdomain:45936 localhost.localdomain:smtp  ESTABLISHED 14598/o2JFA5do01459
tcp        0      0 localhost.localdomain:46091 localhost.localdomain:smtp  ESTABLISHED 12470/o2JEj5Wu01247
tcp        0      0 localhost.localdomain:37943 localhost.localdomain:smtp  ESTABLISHED 14153/o2JF56BN01415
tcp        0   2496 mail.<my_domain>.net:ssh        host<my_IP>.in-a:4617 ESTABLISHED 16552/1
tcp        0      0 localhost.localdomain:43887 localhost.localdomain:smtp  ESTABLISHED 12071/o2JEe7Y401207
tcp        0      0 localhost.localdomain:36060 localhost.localdomain:smtp  ESTABLISHED 15918/o2JFP6h901591
tcp        0      0 localhost.localdomain:52259 localhost.localdomain:smtp  ESTABLISHED 12899/o2JEoAVb01289
tcp        0      0 localhost.localdomain:44708 localhost.localdomain:smtp  ESTABLISHED 16347/o2JFU59M01634
tcp        0      0 mail.<my_domain>.net:ssh        host<my_IP>:cvspserver ESTABLISHED 3323/0
tcp        0      0 localhost.localdomain:42327 localhost.localdomain:smtp  ESTABLISHED 15030/o2JFF6kl01503
Reply With Quote
Sponsored Links
 

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
Troubleshooting FTP bswinnerton Installation/Configuration 4 10th October 2008 19:34
proFTPd passive mode problems bisbell Server Operation 8 6th August 2008 21:12
Question about Virtual Hosting With Proftpd And MySQL (Incl. Quota) On Debian Etch ikkem HOWTO-Related Questions 30 26th February 2008 19:38
Mail server attack princebenin Server Operation 1 19th November 2007 14:02
Website users? ctroyp General 25 6th January 2006 18:02


All times are GMT +2. The time now is 14:27.


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