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:[EMAIL PROTECTED] > -- > 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: [EMAIL PROTECTED] | H: http://lms.ispgaya.pt/ +-----------------------------------------
