MySql problems

mishmash · 27-06-2008, 12:41:40 AM

Following a Red Hat Linux server restart (which may well have enacted some updates) I am unable to start/restart mysql:

Quote:

/etc/init.d/mysql restart
MySQL PID file could not be found! [FAILED]
Starting MySQL................................... [FAILED]

Simply typing "mysql" gives me

Quote:

mysql
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111)

I've looked through various forums etc. and can't find an answer, I've edited /etc/my.cnf
to point to both mysql.sock files I can find on the machine, neither helps.

Any ideas?

Jeewhizz · 27-06-2008, 06:14:23 AM

What does the mysql error file say? It'll be somewhere like /var/lib/mysql/{hostname}.err

Where {hostname} is the hostname of the machine.

tifosi · 27-06-2008, 10:14:47 AM

looks like the mysql process that the pid - process ID file holds has died. In the past I've emptied - not removed that file. On rare ocassions I've had to create it as well.

Start and stop mysql to see if it's ok. It may have left tables in a crashed (unclosed correctly) state which need repairing - either through mysqlcheck or myisamchk (with mysql off).

If you use phpMyAdmin then that will have repair options.

I prefer myisamchk (if the db used myisam - default) but you need root/mysql permissions to run that.

S

mishmash · 27-06-2008, 12:56:30 PM

Thank you for the suggestions - the below is the results from trying them:

Quote:

Originally Posted by Jeewhizz

What does the mysql error file say?.

Quote:

Number of processes running now: 0
060902 12:20:31 mysqld restarted
060902 12:20:32 InnoDB: Database was not shut down normally!
InnoDB: Starting crash recovery.
InnoDB: Reading tablespace information from the .ibd files...
InnoDB: Restoring possible half-written data pages from the doublewrite
InnoDB: buffer...
060902 12:20:32 InnoDB: Starting log scan based on checkpoint at
InnoDB: log sequence number 0 1237811.
InnoDB: Doing recovery: scanned up to log sequence number 0 1237811
060902 12:20:32 InnoDB: Flushing modified pages from the buffer pool...
060902 12:20:32 InnoDB: Started; log sequence number 0 1237811
/usr/sbin/mysqld: ready for connections.
Version: '4.1.21-standard' socket: '/var/lib/mysql/mysql.sock' port: 3306 My$

A restart mysql attempt results in

Quote:

/usr/bin/mysqladmin: connect to server at 'localhost' failed error: 'Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111)' Check that mysqld is running and that the socket: '/var/lib/mysql/mysql.sock' exists! mysql has failed, please contact the sysadmin (result was "mysql has failed").

It could be a firewall problem?

I've run the following commands
service iptables stop
iptables --flush

Craig · 27-06-2008, 01:02:32 PM

Is this a cPanel machine? Do you have a "basedir=" entry in your /etc/my.cnf?

mishmash · 27-06-2008, 01:21:48 PM

Quote:

Originally Posted by Craig

Is this a cPanel machine? Do you have a "basedir=" entry in your /etc/my.cnf?

Yes, this is WHM/cPanel on Red Hat Linux

I do not have a basedir entry in /etc/my.cnf
There is no basedir either in /usr/local/cpanel/whostmgr/my.cnf

Craig · 27-06-2008, 01:28:45 PM

Ok.. Do you have a symlink in /tmp/ still for mysql.sock?

mishmash · 27-06-2008, 01:31:52 PM

Quote:

Originally Posted by Craig

Ok.. Do you have a symlink in /tmp/ still for mysql.sock?

In /tmp/

I have
mysql.sock@

In response to "locate mysql.sock" (recently having run updatedb) I have:
/var/lib/mysql/mysql.sock
/usr/local/lib/mysql.sock

mishmash · 27-06-2008, 01:39:32 PM

The result of running the command "ln -s /var/lib/mysql/mysql.sock /tmp/mysql.sock"
Was ln: `/tmp/mysql.sock': File exists

A restart attempt of mysql resulted in the same error as before.

This error was the same following the running of the command: "ln -s -f /var/lib/mysql/mysql.sock /tmp/mysql.sock

yesterday · 27-06-2008, 01:50:51 PM

are you starting mysql as the right user?

yesterday

27-06-2008, 06:14:23 AM	#2 (permalink)
Jeewhizz Join Date: May 2006 Posts: 1,192 No Classified Ratings Domain Trader Rating: (100% / 17)	What does the mysql error file say? It'll be somewhere like /var/lib/mysql/{hostname}.err Where {hostname} is the hostname of the machine. __________________ UK Web Design & Development Airport Car Parking \| Business Help & Advice \| Critical Illness Insurance \| Smoothie Recipes \| Baby Name Books

27-06-2008, 01:02:32 PM	#5 (permalink)
Craig Join Date: Sep 2004 Location: London, UK Posts: 175 No Classified Ratings Domain Trader Rating: (100% / 2)	Is this a cPanel machine? Do you have a "basedir=" entry in your /etc/my.cnf? __________________ Craig Robinson - UKDedicated LTD UK Dedicated Servers \|\| UK cPanel Hosting \|\| UK Reseller Hosting

27-06-2008, 01:28:45 PM	#7 (permalink)
Craig Join Date: Sep 2004 Location: London, UK Posts: 175 No Classified Ratings Domain Trader Rating: (100% / 2)	Ok.. Do you have a symlink in /tmp/ still for mysql.sock? __________________ Craig Robinson - UKDedicated LTD UK Dedicated Servers \|\| UK cPanel Hosting \|\| UK Reseller Hosting

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Domain Name Community	Replies	Last Post
Servage MySQL problems etc....	mat	Domain Name Registrars	8	07-10-2008 01:55:41 PM
1 mysql - 2 sites...	ratboy	Website Design	4	15-02-2008 01:17:46 PM
MySQL help	fish	Services Wanted	9	10-09-2007 10:59:49 AM
123-reg problems	goldman	General Board	2	07-05-2006 07:18:25 PM

27-06-2008, 10:14:47 AM	#3 (permalink)
tifosi Join Date: Oct 2004 Location: Lancashire Posts: 1,792 No Classified Ratings Domain Trader Rating: (100% / 7)	looks like the mysql process that the pid - process ID file holds has died. In the past I've emptied - not removed that file. On rare ocassions I've had to create it as well. Start and stop mysql to see if it's ok. It may have left tables in a crashed (unclosed correctly) state which need repairing - either through mysqlcheck or myisamchk (with mysql off). If you use phpMyAdmin then that will have repair options. I prefer myisamchk (if the db used myisam - default) but you need root/mysql permissions to run that. S

27-06-2008, 01:39:32 PM	#9 (permalink)
mishmash Join Date: Jan 2005 Posts: 160 No Classified Ratings Domain Trader Rating: (0% / 0)	The result of running the command "ln -s /var/lib/mysql/mysql.sock /tmp/mysql.sock" Was ln: `/tmp/mysql.sock': File exists A restart attempt of mysql resulted in the same error as before. This error was the same following the running of the command: "ln -s -f /var/lib/mysql/mysql.sock /tmp/mysql.sock

27-06-2008, 01:50:51 PM	#10 (permalink)
yesterday Join Date: Jul 2006 Posts: 607 No Classified Ratings Domain Trader Rating: (100% / 16)	are you starting mysql as the right user? yesterday