From: Luís Miguel Silva (lms_at_ispgaya.pt)
Date: Mon 03 Mar 2003 - 12:29:50 GMT
Hello,
> This has me baffeled. Running 2.4.19ctx-15. and mysql version: 3.23.54
> When I try to connect to mysql that is running on a vserver I get at
> first the following error on the client side
>
> Enter password:
> ERROR 2013: Lost connection to MySQL server during query
This is weird...BUT...
>
> This comes almost instantly.
> If I do this one or two times it finally "hangs" and I can read the
> following in the log on the vserver that is running the mysql server I
> want to talk to
>
> Number of processes running now: 2
> 030302 17:17:11 mysqld restarted
> 030302 17:17:11 Can't start server: Bind on TCP/IP port: Address
> already in use 030302 17:17:11 Do you already have another mysqld
> server running on port: 3306
> ?
> 030302 17:17:11 Aborting
Are you sure you are only trying to bind to the vserver ip address and not
0.0.0.0? take a look at my.cnf (i think that is the name of the mysqld
configuration file)
>
> 030302 17:17:11 /usr/libexec/mysqld: Shutdown Complete
>
> 030302 17:17:11 mysqld ended
>
> Now I have to manually kill
> /usr/libexec/mysqld --defaults-file=/etc/my.cnf --bas
> with a -TERM
>
> Then do a "service mysqld start"
>
> 030302 17:22:15 mysqld started
> /usr/libexec/mysqld: ready for connections
>
> If I don't kill it and I attempt a restart or start then I will get a
> fail to shutdown and the "started" process will not function and I will
> not be able to connect from localhost until I do this.
>
> I can connect to the mysql server from CLI and from the local httpd
> service (module_php4) without any problem.
This is actually normal...since i think the httpd will connect via the
file socket! /tmp/.sock.tmp? (or something like that also..heheh...)
Im sorry i didnt have time to check if those are the real *exact*
filenames! :o/
>
> I'm stomped (few things get me stomped) anyone have any ideas or
> suggestions what might be wrong ?
> This is happening both with php and mysql client from 2 other linux
> boxes as well as a Windows system.
>
> Best regards,
> Eje Gustafsson mailto:MacAhan_at_fament.com
> --
> The Family Entertainment Network http://www.fament.com
> Phone : 620-231-7777 Fax : 620-231-4066
> - Your Full Time Professionals -
> eBay UserID : macahan
>
> ---
> [This E-mail scanned for viruses by Declude Virus]
Regards,
+-----------------------------------------
| Luís Miguel Silva
| Network Administrator@ ISPGaya.pt
| Rua António Rodrigues da Rocha, 291/341
| Sto. Ovídio • 4400-025 V. N. de Gaia
| Portugal
| T: +351 22 3745730/3/5 F: +351 22 3745738
| G: +351 93 6371253 E: lms_at_ispgaya.pt
| H: http://lms.ispgaya.pt/
+-----------------------------------------