Can't connect to MySQL

[xPol]

Why are you using a perl script ? Instead try with the script provided in

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

[Bogdan Cristea]

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
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.

[xPol]

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,
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 >/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 >/dev/null
| 2>&1 &
`----

[xPol]

Post by xPol
% sudo /etc/rc.d/mysql start
Starting service MySQL

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
-----

[Bogdan Cristea]

Post by xPol
% 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]

Post by xPol

Post by xPol
% sudo /etc/rc.d/mysql start
Starting service MySQL

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
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.
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

[phanisvara das]

Post by 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/