View Single Post
  #11  
Old 19th March 2010, 17: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