List:General Discussion« Previous MessageNext Message »
From:Reindl Harald Date:April 2 2011 4:50pm
Subject:Re: Can't connect to MySQL server on '127.0.0.1' (111)
View as plain text  
Please "netstat --numeric-hosts --notrim --programs -u -t -l"
In my first answer i forgot the -l

Without we get active connections, but we want the listening
tcp-services where somewhere must by mysqld

the easiest test is however

> [harry@srv-rhsoft:~]$ telnet 127.0.0.1 3306
> Trying 127.0.0.1...
> Connected to 127.0.0.1.
> Escape character is '^]'.
> 5.5.10-log�K]qC7,t'��a4~Agb949^QXmysql_native_password

if there is no connection we should find out why
debug simply the web-app user on a local terminal
to get error messages with more details as "failed"

> [harry@srv-rhsoft:~]$ mysql -h 127.0.0.1 -u myuser -p
> Enter password:
> ERROR 1045 (28000): Access denied for user 'myuser'@'localhost' (using password: NO)

this example says more as "failed" bceause we see that connection
is possible but authentication fails


Am 02.04.2011 18:21, schrieb xPol:
> 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
> 
> -----
> 
> 

-- 

Mit besten Grüßen, Reindl Harald
the lounge interactive design GmbH
A-1060 Vienna, Hofmühlgasse 17
CTO / software-development / cms-solutions
p: +43 (1) 595 3999 33, m: +43 (676) 40 221 40
icq: 154546673, http://www.thelounge.net/


Attachment: [application/pgp-signature] OpenPGP digital signature signature.asc
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