[opensuse] Can't connect to MySQL
I have been using a local dictionary, until a few day ago, with no problems. The dictionary can be reached by a web browser pointing at http://localhost:9000. Recently, probably following the installation of a mysql-related package, my dictionary cannot be reached any more. Here is the message i get: Can't connect to MySQL server on '127.0.0.1' (111) I am using kde 4.4.4 opensuse 11.3 Any hints to solve my problem? thank you -----p -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org For additional commands, e-mail: opensuse+help@opensuse.org
On Sunday 26 December 2010 11:02:18 xPol wrote:
I have been using a local dictionary, until a few day ago, with no problems. The dictionary can be reached by a web browser pointing at http://localhost:9000.
Recently, probably following the installation of a mysql-related package, my dictionary cannot be reached any more. Here is the message i get: Can't connect to MySQL server on '127.0.0.1' (111
Try to start your MySQL server from Yast. If you still have problems, you could disable all repositories except the DVD and do an unconditional update on mysql -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org For additional commands, e-mail: opensuse+help@opensuse.org
Bogdan Cristea wrote:
Try to start your MySQL server from Yast. If you still have
problems, you I do not know how to do. By inspecting the yast options i have found that 'Local security configuration' is set 'custom settings'. I have switched to 'Home workstation' to check any relation with my issue. NOthing changes as far as mysql is concerned, but i have found that the 'Local security configuration' has not changed either: the 'Local security configuration' has been automatically set to 'custom settings'. Any ideas?
could disable all repositories except the DVD and do an unconditional update on mysql
mine is a network installation, so no dvd. What is the command to issue? thank you ---p -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org For additional commands, e-mail: opensuse+help@opensuse.org
On Sunday 26 December 2010 11:45:18 xPol wrote:
problems, you
I do not know how to do.
System -> System Services (Runlevels) and search in the list mysql, select it then press enable button. If you don't have a DVD disable all repos except the standard one -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org For additional commands, e-mail: opensuse+help@opensuse.org
Bogdan Cristea wrote:
On Sunday 26 December 2010 11:02:18 xPol wrote:
I have been using a local dictionary, until a few day ago, with no problems. The dictionary can be reached by a web browser pointing at http://localhost:9000.
Recently, probably following the installation of a mysql-related package, my dictionary cannot be reached any more. Here is the message i get: Can't connect to MySQL server on '127.0.0.1' (111
Try to start your MySQL server from Yast. If you still have problems, you could disable all repositories except the DVD and do an unconditional update on mysql
Thank you to your help, i have been able to disable all extra repositories and to to unconditional upgrade. Sadly, nothing has changed. The script starts and the dictionary layout is displayed in my web browser, but every query returns: Can't connect to MySQL server on '127.0.0.1' (111) Any hints? The script is perl script, here included. Thank you ---p ----,----[ /home/xpol/OP_Build05-autorun ] | #!/bin/sh | | #NOTE: if your filesystem is mounted with 'noexec' flag, run this file | #as | #sh autorun | #instead of | #./autorun | | #FOR UNIX-like platforms ONLY!! | #autorun script for starting Stunnix Perl Web Server locally and directing | #user's browser to the page on the site served by it. | # | #Copyright (c) 2004-2005 by Stunnix company - see http://www.stunnix.com | #for more details. | | cd `dirname $0` | | PERLLIB=$PERLLIB:`pwd`/perl/common-inc/ | export PERLLIB | | if [ `uname` = "Linux" ]; then | if uname -m | grep 86 >/dev/null ; then | if perl/linux-x86/perl -v >/dev/null 2>&1; then | exec nohup perl/linux-x86/perl site/stunnixwebsrv/starter.pl \ | site/stunnixwebsrv/startsite.pl $@ /dev/null 2>&1 & | exit 0 | fi | fi | fi | | #we are here because there is no prebuilt perl included for OS this | #script is running under. Let's hope packager #listed all modules in | #perl/fallback-inc and that system we are running on includes perl | PERLLIB=$PERLLIB:`pwd`/perl/fallback-inc/ | export PERLLIB | | exec nohup perl site/stunnixwebsrv/startsite.pl $@ /dev/null | 2>&1 & `---- -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org For additional commands, e-mail: opensuse+help@opensuse.org
On Sunday 02 January 2011 09:49:04 xPol wrote:
Thank you to your help, i have been able to disable all extra repositories and to to unconditional upgrade. Sadly, nothing has changed. The script starts and the dictionary layout is displayed in my web browser, but every query returns:
Can't connect to MySQL server on '127.0.0.1' (111)
Any hints? The script is perl script, here included.
Why are you using a perl script ? Instead try with the script provided in /etc/rc.d: /etc/rc.d/mysql start and report the errors, if any. -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org For additional commands, e-mail: opensuse+help@opensuse.org
Bogdan Cristea wrote:
Why are you using a perl script ? Instead try with the script provided in /etc/rc.d:
That perl script is provided by the company, together with their dictionary I would like to be able to force the script to print out any warnings or errors during execution
/etc/rc.d/mysql start
and report the errors, if any.
No errors, starting as root: % sudo /etc/rc.d/mysql start Starting service MySQL Thank you ---p -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org For additional commands, e-mail: opensuse+help@opensuse.org
On Sunday 02 January 2011 11:02:00 xPol wrote:
No errors, starting as root: % sudo /etc/rc.d/mysql start Starting service MySQL
Check if there is a mysql server listening on a port on your machine: nmap localhost you should see something like this .... 3306/tcp open mysql .... regards -- Bogdan Cristea http://sites.google.com/site/cristeab/ -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org For additional commands, e-mail: opensuse+help@opensuse.org
Bogdan Cristea wrote:
On Sunday 02 January 2011 11:02:00 xPol wrote:
No errors, starting as root: % sudo /etc/rc.d/mysql start Starting service MySQL
Check if there is a mysql server listening on a port on your machine: nmap localhost
Yes, mysql is at 3306/tcp Also noticed that 'Hostname localhost resolves to 2 IPs. Using 127.0.0.1' Is that an issue? In my /etc/hosts file i cannot see any double assignment. Here is what I have: 127.0.0.1 localhost.localdomain localhost # special IPv6 addresses (...) Here include the complee output from nmp thank you ----p ---- enc Starting Nmap 5.00 ( http://nmap.org ) at 2011-01-02 12:4 Here in6 CET Warning: Hostname localhost resolves to 2 IPs. Using 127.0.0.1. Interesting ports on localhost.localdomain (127.0.0.1): Not shown: 995 closed ports PORT STATE SERVICE 25/tcp open smtp 111/tcp open rpcbind 631/tcp open ipp 3306/tcp open mysql 9000/tcp open cslistener Nmap done: 1 IP address (1 host up) scanned in 0.29 seconds ----- -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org For additional commands, e-mail: opensuse+help@opensuse.org
On Sunday 02 January 2011 13:51:56 xPol wrote:
Bogdan Cristea wrote:
On Sunday 02 January 2011 11:02:00 xPol wrote:
No errors, starting as root: % sudo /etc/rc.d/mysql start
Starting service MySQL
Check if there is a mysql server listening on a port on your machine: nmap localhost
Yes, mysql is at 3306/tcp
Also noticed that 'Hostname localhost resolves to 2 IPs. Using 127.0.0.1' Is that an issue? In my /etc/hosts file i cannot see any double assignment. Here is what I have: 127.0.0.1 localhost.localdomain localhost # special IPv6 addresses (...)
Here include the complee output from nmp thank you ----p
---- enc Starting Nmap 5.00 ( http://nmap.org ) at 2011-01-02 12:4 Here in6 CET Warning: Hostname localhost resolves to 2 IPs. Using 127.0.0.1. Interesting ports on localhost.localdomain (127.0.0.1): Not shown: 995 closed ports PORT STATE SERVICE 25/tcp open smtp 111/tcp open rpcbind 631/tcp open ipp 3306/tcp open mysql 9000/tcp open cslistener
Nmap done: 1 IP address (1 host up) scanned in 0.29 seconds -----
It looks like your mysql server is running. You might try to connect to your server from the command line or with a web client. Search with Google in order to learn how to connect. regards -- Bogdan Cristea http://sites.google.com/site/cristeab/ -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org For additional commands, e-mail: opensuse+help@opensuse.org
On Sun, 02 Jan 2011 17:25:42 +0530, Bogdan Cristea
Search with Google in order to learn how to connect.
i find answers to most if not all questions re. mysql at their documentation, at http://dev.mysql.com/doc/refman/5.1/en/ -- phani. -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org For additional commands, e-mail: opensuse+help@opensuse.org
participants (3)
-
Bogdan Cristea -
phanisvara das -
xPol