From: Eje Gustafsson (Macahan_at_fament.com)
Date: Mon 03 Mar 2003 - 17:26:42 GMT
>> 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
LMS> Are you sure you are only trying to bind to the vserver ip address and not
LMS> 0.0.0.0? take a look at my.cnf (i think that is the name of the mysqld
LMS> configuration file)
I thought about that so I explicitly tried to both start it using
--bind-ip=x.x.x.x
as well as type in bind-ip=x.x.x.x in my.cnf neither did matter.
However I did replicate this problem on my laptop that is also running
RedHat 8.0 and it is a RedHat 8 problem so nothing with vserver. I
have a RedHat 7.0 installed vserver on that same vmaster and using
MySQL 3.23.54a on that vserver and it works beautifully.
I had even tried to stop all vservers but a single one that ran the
mysql service (the master does not run anything but sshd (bound to the
main ip of the vmaster, sendmail(bound to localhost) and something
that is bound to udp port 706 (?) that is all services running that
accepts or listen for ip connections)
>>
>> 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.
LMS> This is actually normal...since i think the httpd will connect via the
LMS> file socket! /tmp/.sock.tmp? (or something like that also..heheh...)
LMS> Im sorry i didnt have time to check if those are the real *exact*
LMS> 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]
LMS> Regards,
LMS> +-----------------------------------------
LMS> | Luís Miguel Silva
LMS> | Network Administrator@ ISPGaya.pt
LMS> | Rua António Rodrigues da Rocha, 291/341
LMS> | Sto. Ovídio • 4400-025 V. N. de Gaia
LMS> | Portugal
LMS> | T: +351 22 3745730/3/5 F: +351 22 3745738
LMS> | G: +351 93 6371253 E: lms_at_ispgaya.pt
LMS> | H: http://lms.ispgaya.pt/
LMS> +-----------------------------------------
LMS> ---
LMS> [This E-mail scanned for viruses by Declude Virus]
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
eBay UserID : macahan
- Your Full Time Professionals -
---
[This E-mail scanned for viruses by Declude Virus]