Can't connect to MySQL server on '127.0.0.1' (111)
I have been using my local dictionary for years, accessing from web browser, pointing to http://localhost:9000/ Probably my fault, since i have been tinkering a little with my settings. As i try to connect, i get Can't connect to MySQL server on '127.0.0.1' (111) Any ideas, what to check? I am using linux/opensuse 11.4 Thank you p -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: Can't connect to MySQL server on '127.0.0.1' (111)
Did you make any change in the my.cnf? What does netstat --numeric-hosts --notrim --programs -u -t say? What is the content of your my.cnf? Am 02.04.2011 17:10, schrieb xPol: I have been using my local dictionary for years, accessing from web browser, pointing to http://localhost:9000/ Probably my fault, since i have been tinkering a little with my settings. As i try to connect, i get Can't connect to MySQL server on '127.0.0.1' (111) Any ideas, what to check? I am using linux/opensuse 11.4 signature.asc Description: OpenPGP digital signature
Re: Can't connect to MySQL server on '127.0.0.1' (111)
I think you'll need to give us a bit more to go on. I presume this is a web based app? What have you changed? Has the MySQL daemon stopped? What have you changed? On Sat, Apr 2, 2011 at 4:10 PM, xPol xtek...@gmail.com wrote: I have been using my local dictionary for years, accessing from web browser, pointing to http://localhost:9000/ Probably my fault, since i have been tinkering a little with my settings. As i try to connect, i get Can't connect to MySQL server on '127.0.0.1' (111) Any ideas, what to check? I am using linux/opensuse 11.4 Thank you p -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=eroomy...@gmail.com
Re: Can't connect to MySQL server on '127.0.0.1' (111)
Andrew Moore wrote: I think you'll need to give us a bit more to go on. I presume this is a web based app? yes What have you changed? Has the MySQL daemon stopped? What have you changed? from 'ps' i get 3545 0.0 0.1 194816 3292 ?Sl 13:58 0:08 /usr/sbin/mysqld -- defaults-file=/home/xpol/.local/share/akonadi//mysql.conf -- datadir=/home/xpol/.local/share/akonadi/db_data/ -- socket=/home/xpol/.local/share/akonadi/socket-ambi.site/mysql.socket So the demon appears to be running I do not think mysql conf files have been changed by me thank you --p -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: Can't connect to MySQL server on '127.0.0.1' (111)
Reindl Harald wrote: Did you make any change in the my.cnf? What does netstat --numeric-hosts --notrim --programs -u -t say? What is the content of your my.cnf? Here incluede thank you p -- (xpol) % netstat --numeric-hosts --notrim --programs -u -t ~ (17:32-Sat 2) (Not all processes could be identified, non-owned process info will not be shown, you would have to be root to see it all.) Active Internet connections (w/o servers) Proto Recv-Q Send-Q Local Address Foreign Address State PID/Program name tcp0 0 10.121.243.241:3831574.125.77.109:smtp TIME_WAIT - tcp0 0 127.0.0.1:50793 127.0.0.1:48856 ESTABLISHED 6752/npviewer.bin tcp0 0 127.0.0.1:57336 127.0.0.1:48856 ESTABLISHED 6752/npviewer.bin tcp0 0 10.121.243.241:5392474.125.232.152:https ESTABLISHED 6252/firefox tcp0 0 10.121.243.241:5392574.125.232.152:https ESTABLISHED 6252/firefox tcp0 0 10.121.243.241:5389474.125.232.152:https ESTABLISHED 6252/firefox tcp0 0 10.121.243.241:35673209.85.227.189:https ESTABLISHED 6252/firefox tcp0 0 10.121.243.241:35672209.85.227.189:https ESTABLISHED 6252/firefox tcp0 0 10.121.243.241:48554209.85.149.105:www-http ESTABLISHED 6252/firefox tcp0 0 10.121.243.241:35666209.85.227.189:https TIME_WAIT - tcp0 0 10.121.243.241:35667209.85.227.189:https TIME_WAIT - tcp0 0 10.121.243.241:5392674.125.232.152:https ESTABLISHED 6252/firefox tcp0 0 127.0.0.1:52722 127.0.0.1:48856 ESTABLISHED 6752/npviewer.bin tcp0 0 127.0.0.1:48856 127.0.0.1:52722 ESTABLISHED 6767/GoogleTalkPlug tcp0 0 127.0.0.1:48856 127.0.0.1:50793 ESTABLISHED 6767/GoogleTalkPlug tcp0 0 127.0.0.1:48856 127.0.0.1:57336 ESTABLISHED 6767/GoogleTalkPlug tcp0 0 10.121.243.241:5432480.91.229.10:nntp ESTABLISHED 11402/knodeo10783.s --- (xpol) % cat /mnt/etc/my.cnf | grep -v ^# ~ (17:34-Sat 2) [client] port= 3306 socket = /var/run/mysql/mysql.sock [mysqld] port= 3306 socket = /var/run/mysql/mysql.sock datadir = /var/lib/mysql skip-locking key_buffer_size = 16M max_allowed_packet = 1M table_open_cache = 64 sort_buffer_size = 512K net_buffer_length = 8K read_buffer_size = 256K read_rnd_buffer_size = 512K myisam_sort_buffer_size = 8M log-bin=mysql-bin binlog_format=mixed server-id = 1 [safe_mysqld] log-error = /var/log/mysql/mysqld.log socket = /var/run/mysql/mysql.sock !include_dir /etc/mysql [mysqldump] socket = /var/run/mysql/mysql.sock quick max_allowed_packet = 16M [mysql] no-auto-rehash [myisamchk] key_buffer_size = 20M sort_buffer_size = 20M read_buffer = 2M write_buffer = 2M [mysqlhotcopy] interactive-timeout [mysqld_multi] mysqld = /usr/bin/mysqld_safe mysqladmin = /usr/bin/mysqladmin log= /var/log/mysqld_multi.log - -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: Can't connect to MySQL server on '127.0.0.1' (111)
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 /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 i would assume something like skip-networking in your config if connection fails anyways this mysql-config ma contain some includes because the line !include_dir /etc/mysql Am 02.04.2011 17:36, schrieb xPol: Reindl Harald wrote: Did you make any change in the my.cnf? What does netstat --numeric-hosts --notrim --programs -u -t say? What is the content of your my.cnf? Here incluede thank you p -- (xpol) % netstat --numeric-hosts --notrim --programs -u -t ~ (17:32-Sat 2) (Not all processes could be identified, non-owned process info will not be shown, you would have to be root to see it all.) Active Internet connections (w/o servers) Proto Recv-Q Send-Q Local Address Foreign Address State PID/Program name tcp0 0 10.121.243.241:3831574.125.77.109:smtp TIME_WAIT - tcp0 0 127.0.0.1:50793 127.0.0.1:48856 ESTABLISHED 6752/npviewer.bin tcp0 0 127.0.0.1:57336 127.0.0.1:48856 ESTABLISHED 6752/npviewer.bin tcp0 0 10.121.243.241:5392474.125.232.152:https ESTABLISHED 6252/firefox tcp0 0 10.121.243.241:5392574.125.232.152:https ESTABLISHED 6252/firefox tcp0 0 10.121.243.241:5389474.125.232.152:https ESTABLISHED 6252/firefox tcp0 0 10.121.243.241:35673209.85.227.189:https ESTABLISHED 6252/firefox tcp0 0 10.121.243.241:35672209.85.227.189:https ESTABLISHED 6252/firefox tcp0 0 10.121.243.241:48554209.85.149.105:www-http ESTABLISHED 6252/firefox tcp0 0 10.121.243.241:35666209.85.227.189:https TIME_WAIT - tcp0 0 10.121.243.241:35667209.85.227.189:https TIME_WAIT - tcp0 0 10.121.243.241:5392674.125.232.152:https ESTABLISHED 6252/firefox tcp0 0 127.0.0.1:52722 127.0.0.1:48856 ESTABLISHED 6752/npviewer.bin tcp0 0 127.0.0.1:48856 127.0.0.1:52722 ESTABLISHED 6767/GoogleTalkPlug tcp0 0 127.0.0.1:48856 127.0.0.1:50793 ESTABLISHED 6767/GoogleTalkPlug tcp0 0 127.0.0.1:48856 127.0.0.1:57336 ESTABLISHED 6767/GoogleTalkPlug tcp0 0 10.121.243.241:5432480.91.229.10:nntp ESTABLISHED 11402/knodeo10783.s --- (xpol) % cat /mnt/etc/my.cnf | grep -v ^# ~ (17:34-Sat 2) [client] port= 3306 socket = /var/run/mysql/mysql.sock [mysqld] port= 3306 socket = /var/run/mysql/mysql.sock datadir = /var/lib/mysql skip-locking key_buffer_size = 16M max_allowed_packet = 1M table_open_cache = 64 sort_buffer_size = 512K net_buffer_length = 8K read_buffer_size = 256K read_rnd_buffer_size = 512K myisam_sort_buffer_size = 8M log-bin=mysql-bin binlog_format=mixed server-id = 1 [safe_mysqld] log-error = /var/log/mysql/mysqld.log socket = /var/run/mysql/mysql.sock !include_dir /etc/mysql [mysqldump] socket = /var/run/mysql/mysql.sock quick max_allowed_packet = 16M [mysql] no-auto-rehash [myisamchk] key_buffer_size = 20M sort_buffer_size = 20M read_buffer = 2M write_buffer = 2M [mysqlhotcopy] interactive-timeout [mysqld_multi] mysqld = /usr/bin/mysqld_safe mysqladmin = /usr/bin/mysqladmin log= /var/log/mysqld_multi.log - -- 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/ signature.asc Description: OpenPGP digital signature
Re: Can't connect to MySQL server on '127.0.0.1' (111)
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
tcp0 0 10.121.243.241:6057774.125.232.149:https
ESTABLISHED 6252/firefox
tcp0 0 10.121.243.241:5420774.125.232.114:www-http
ESTABLISHED 6252/firefox
tcp0 0 10.121.243.241:4954585.86.166.196:7168
TIME_WAIT -
tcp0 0 10.121.243.241:5317374.125.232.150:https
TIME_WAIT -
tcp0 0 127.0.0.1:50793 127.0.0.1:48856
ESTABLISHED 6752/npviewer.bin
tcp0 0 127.0.0.1:57336 127.0.0.1:48856
ESTABLISHED 6752/npviewer.bin
tcp0 0 10.121.243.241:39556209.85.227.189:https
ESTABLISHED 6252/firefox
tcp0 0 10.121.243.241:6057674.125.232.149:https
ESTABLISHED 6252/firefox
tcp0 0 10.121.243.241:39551209.85.227.189:https
TIME_WAIT -
tcp0 0 10.121.243.241:4108983.233.30.55:ipsec-nat-t
TIME_WAIT -
tcp0 0 10.121.243.241:39550209.85.227.189:https
TIME_WAIT -
tcp0 0 10.121.243.241:5275883.51.48.124:44909
TIME_WAIT -
tcp0 0 127.0.0.1:52722 127.0.0.1:48856
ESTABLISHED 6752/npviewer.bin
tcp0 0 127.0.0.1:48856 127.0.0.1:52722
ESTABLISHED 6767/GoogleTalkPlug
tcp0 0 10.121.243.241:39555209.85.227.189:https
ESTABLISHED 6252/firefox
tcp0 0 10.121.243.241:3536582.56.169.37:19907
TIME_WAIT -
tcp0 0 10.121.243.241:5728380.91.229.10:nntp
ESTABLISHED 12106/knodec10783.s
tcp0 0 10.121.243.241:4455274.125.232.150:https
ESTABLISHED 6252/firefox
tcp0 0 127.0.0.1:48856 127.0.0.1:50793
ESTABLISHED 6767/GoogleTalkPlug
tcp0 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
-
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: Can't connect to MySQL server on '127.0.0.1' (111)
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
tcp0 0 10.121.243.241:6057774.125.232.149:https
ESTABLISHED 6252/firefox
tcp0 0 10.121.243.241:5420774.125.232.114:www-http
ESTABLISHED 6252/firefox
tcp0 0 10.121.243.241:4954585.86.166.196:7168
TIME_WAIT -
tcp0 0 10.121.243.241:5317374.125.232.150:https
TIME_WAIT -
tcp0 0 127.0.0.1:50793 127.0.0.1:48856
ESTABLISHED 6752/npviewer.bin
tcp0 0 127.0.0.1:57336 127.0.0.1:48856
ESTABLISHED 6752/npviewer.bin
tcp0 0 10.121.243.241:39556209.85.227.189:https
ESTABLISHED 6252/firefox
tcp0 0 10.121.243.241:6057674.125.232.149:https
ESTABLISHED 6252/firefox
tcp0 0 10.121.243.241:39551209.85.227.189:https
TIME_WAIT -
tcp0 0 10.121.243.241:4108983.233.30.55:ipsec-nat-t
TIME_WAIT -
tcp0 0 10.121.243.241:39550209.85.227.189:https
TIME_WAIT -
tcp0 0 10.121.243.241:5275883.51.48.124:44909
TIME_WAIT -
tcp0 0 127.0.0.1:52722 127.0.0.1:48856
ESTABLISHED 6752/npviewer.bin
tcp0 0 127.0.0.1:48856 127.0.0.1:52722
ESTABLISHED 6767/GoogleTalkPlug
tcp0 0 10.121.243.241:39555209.85.227.189:https
ESTABLISHED 6252/firefox
tcp0 0 10.121.243.241:3536582.56.169.37:19907
TIME_WAIT -
tcp0 0 10.121.243.241:5728380.91.229.10:nntp
ESTABLISHED 12106/knodec10783.s
tcp0 0 10.121.243.241:4455274.125.232.150:https
ESTABLISHED 6252/firefox
tcp0 0 127.0.0.1:48856 127.0.0.1:50793
ESTABLISHED 6767/GoogleTalkPlug
tcp0 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'} = '';
Re: Can't connect to MySQL server on '127.0.0.1' (111)
Reindl Harald wrote: Please netstat --numeric-hosts --notrim --programs -u -t -l In my first answer i forgot the -l i will check according to your suggstions If i find still in troubles, i will let you know thank you ---p -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
