Hope it helps. I am almost certain that a reboot would make this go away, but it would be good to fix this, because of critical systems.
Ter, 2007-01-23 às 09:07 +0100, Christian Hammers escreveu: > > On 2007-01-23 Luis Matos wrote: > .. > > now let's go for syslog: > > > > Jan 23 02:12:20 lar mysqld_safe[11436]: A mysqld process already exists > > > Jan 23 02:12:34 lar /etc/init.d/mysql[11601]: 1 processes alive and > > '/usr/bin/mysqladmin --defaults-file=/etc/mysql/debian.cnf ping' resulted > > in > > > Jan 23 02:12:34 lar /etc/init.d/mysql[11601]: ^G/usr/bin/mysqladmin: > > connect to server at 'lar.mec.ua.pt' failed Jan 23 02:12:34 > > Please check > a) if there is already one mysqld running - maybe a zombie process or /so. > After /etc/init.d/mysql stop the output of "ps cax | grep mysqld" should > be empty. lar:/home/lmatos# /etc/init.d/mysql stop Stopping MySQL database server: mysqld failed! lar:/home/lmatos# ps aux | grep mysqld root 10735 0.0 0.2 4140 1300 ? S Jan22 0:00 /bin/sh /usr/bin/mysqld_safe mysql 10772 0.0 3.9 129128 17648 ? Sl Jan22 0:00 /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --user=mysql --pid-file=/var/run/mysqld/mysqld.pid --skip-external-locking --port=3306 --socket=/var/run/mysqld/mysqld.sock root 10773 0.0 0.1 3204 552 ? S Jan22 0:00 logger -p daemon.err -t mysqld_safe -i -t mysqld root 12651 0.0 0.1 3348 748 pts/0 S+ 16:01 0:00 grep mysqld > > b) It tries to connect to lar.mec.ua.pt. It should IMHO rather use > "localhost". Do you have "127.0.0.1 localhost" in your /etc/hosts? > Or do you use a "[client]" section in > /root/.my.cnf, /etc/mysql/debian.cnf or similar > places, that could trouble mysqladmin here? > lar:/home/lmatos# cat ~/.my.cnf cat: /root/.my.cnf: Arquivo ou diretório não encontrado cat /etc/hosts hosts hosts.allow hosts.deny lar:/home/lmatos# cat /etc/hosts 127.0.0.1 localhost 127.0.1.1 lar.mec.ua.pt.mec.ua.pt lar.mec.ua.pt # The following lines are desirable for IPv6 capable hosts ::1 ip6-localhost ip6-loopback fe00::0 ip6-localnet ff00::0 ip6-mcastprefix ff02::1 ip6-allnodes ff02::2 ip6-allrouters ff02::3 ip6-allhosts there is mysqladmin installed, but not used. > c) are there any mysqld lines further up the syslog? > lar:/home/lmatos# cat /var/log/syslog | grep mysql Jan 23 15:20:05 lar mysqld_safe[12445]: A mysqld process already exists Jan 23 15:20:20 lar /etc/init.d/mysql[12610]: 1 processes alive and '/usr/bin/mysqladmin --defaults-file=/etc/mysql/debian.cnf ping' resulted in Jan 23 15:20:20 lar /etc/init.d/mysql[12610]: ^G/usr/bin/mysqladmin: connect to server at 'lar.mec.ua.pt' failed Jan 23 15:20:20 lar /etc/init.d/mysql[12610]: error: 'Lost connection to MySQL server during query' Jan 23 15:20:20 lar /etc/init.d/mysql[12610]: cat /etc/mysql/debian.cnf # Automatically generated for Debian scripts. DO NOT TOUCH! [client] host = lar.mec.ua.pt user = debian-sys-maint password = 8i373SGoGJHck1x0 socket = /var/run/mysqld/mysqld.sock [mysql_upgrade] user = debian-sys-maint password = 8i373SGoGJHck1x0 socket = /var/run/mysqld/mysqld.sock basedir = /usr here is a client section. I had not touched this. > bye, > > -christian- -- Best Regards, -- Luis Matos -- To UNSUBSCRIBE, email to [EMAIL PROTECTED] with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]
