List:General Discussion« Previous MessageNext Message »
From:xPol Date:April 2 2011 4:21pm
Subject:Re: Can't connect to MySQL server on '127.0.0.1' (111)
View as plain text  
Reindl Harald wrote:

> please do not only post outputs, read them and try to understand
> before press send - "not all processes could be identified, non-owned
> process info will not be shown, you would have to be root to see it all."
> in the ouptput says that all afterwards is useless
> 
> "netstat --numeric-hosts --notrim --programs -u -t -l" as ROOT on the
> machine where mysql is running! alterante: "telnet 127.0.0.1 3306"

sorry, i have re-enterd the command as root - here incuded

> 
> "/mnt/etc/my.cnf" is really your active mysql-config?
> normally "/etc/my.cnf" is used, even if /etc/ is a own
> disk/partition you should never mount it as /mnt/etc/
> and managing with symlinks - mount it directly to /etc
> 

you're right, /mnt/etc/my.cnf is not my ususm cnf file I hd mounnted that 
file system to compare with /etc/my.cnf
They are the same, however. 

Here included also /etc/mysqlaccess.conf

> i would assume something like "skip-networking" in your
> config if connection fails

it is there, but commented out:
/etc/my.cnf:#skip-networking

> 
> anyways this mysql-config ma contain some includes
> because the line "!include_dir /etc/mysql"
> 
/
That dir contains: /etc/mysql/default_plugins.cnf 
its contents is here included

 thank you
 ----p

1----- 
% ° netstat --numeric-hosts --notrim --programs -u -t                             
~ (18:09-Sat  2) 
Active Internet connections (w/o servers)
Proto Recv-Q Send-Q Local Address           Foreign Address         State       
PID/Program name   
tcp        0      0 10.121.243.241:60577    74.125.232.149:https    
ESTABLISHED 6252/firefox        
tcp        0      0 10.121.243.241:54207    74.125.232.114:www-http 
ESTABLISHED 6252/firefox        
tcp        0      0 10.121.243.241:49545    85.86.166.196:7168      
TIME_WAIT   -                   
tcp        0      0 10.121.243.241:53173    74.125.232.150:https    
TIME_WAIT   -                   
tcp        0      0 127.0.0.1:50793         127.0.0.1:48856         
ESTABLISHED 6752/npviewer.bin   
tcp        0      0 127.0.0.1:57336         127.0.0.1:48856         
ESTABLISHED 6752/npviewer.bin   
tcp        0      0 10.121.243.241:39556    209.85.227.189:https    
ESTABLISHED 6252/firefox        
tcp        0      0 10.121.243.241:60576    74.125.232.149:https    
ESTABLISHED 6252/firefox        
tcp        0      0 10.121.243.241:39551    209.85.227.189:https    
TIME_WAIT   -                   
tcp        0      0 10.121.243.241:41089    83.233.30.55:ipsec-nat-t 
TIME_WAIT   -                   
tcp        0      0 10.121.243.241:39550    209.85.227.189:https    
TIME_WAIT   -                   
tcp        0      0 10.121.243.241:52758    83.51.48.124:44909      
TIME_WAIT   -                   
tcp        0      0 127.0.0.1:52722         127.0.0.1:48856         
ESTABLISHED 6752/npviewer.bin   
tcp        0      0 127.0.0.1:48856         127.0.0.1:52722         
ESTABLISHED 6767/GoogleTalkPlug 
tcp        0      0 10.121.243.241:39555    209.85.227.189:https    
ESTABLISHED 6252/firefox        
tcp        0      0 10.121.243.241:35365    82.56.169.37:19907      
TIME_WAIT   -                   
tcp        0      0 10.121.243.241:57283    80.91.229.10:nntp       
ESTABLISHED 12106/knodec10783.s 
tcp        0      0 10.121.243.241:44552    74.125.232.150:https    
ESTABLISHED 6252/firefox        
tcp        0      0 127.0.0.1:48856         127.0.0.1:50793         
ESTABLISHED 6767/GoogleTalkPlug 
tcp        0      0 127.0.0.1:48856         127.0.0.1:57336         
ESTABLISHED 6767/GoogleTalkPlug 

2 ----
(xpol) %  ° cat /etc/mysqlaccess.conf | grep -v "^#"                                  
  
~ (18:20-Sat  2) 


  #$Param{'host'}     = '';
  $Param{'user'}     = 'nobody';
  $Param{'db'}       = 'test';
  $Param{'password'} = 'foobar';
  $Param{'debug'}    = 0;

if ($CMD) {
  $Param{'superuser'} = 'root';
  $Param{'rhost'}     = 'localhost';
  $Param{'spassword'} = '';
  $Param{'brief'}     = 1;
}

if ($CGI) {
  $Param{'superuser'}  = 'root';
  $Param{'rhost'}      = 'localhost';
  $Param{'spassword'}  = '';
  $Param{'table'}      = 1;
}

1;  #to make require happy

3------
(xpol) % ° cat   /etc/mysql/default_plugins.cnf                                       
  
~ (18:20-Sat  2) 
[server]
plugin-load=blackhole=ha_blackhole.so
plugin-load=federated=ha_federated.so
plugin-load=archive=ha_archive.so

-----

Thread
Can't connect to MySQL server on '127.0.0.1' (111)xPol2 Apr
  • Re: Can't connect to MySQL server on '127.0.0.1' (111)Reindl Harald2 Apr
  • Re: Can't connect to MySQL server on '127.0.0.1' (111)Andrew Moore2 Apr
  • Re: Can't connect to MySQL server on '127.0.0.1' (111)xPol2 Apr
  • Re: Can't connect to MySQL server on '127.0.0.1' (111)xPol2 Apr
    • Re: Can't connect to MySQL server on '127.0.0.1' (111)Reindl Harald2 Apr
  • Re: Can't connect to MySQL server on '127.0.0.1' (111)xPol2 Apr
    • Re: Can't connect to MySQL server on '127.0.0.1' (111)Reindl Harald2 Apr
  • Re: Can't connect to MySQL server on '127.0.0.1' (111)xPol2 Apr