MySQL Community Server 5.1.54 on openSUSE 11.1 (SLES 11 sp1) Error 2003
/var/lib/mysql.sock

Yesterday MySQL stopped working on my server. I can't connect remotely,
at the command line or locally.

I've tried using localhost which returns the error can't create
/var/lib/mysql/mysql.sock

I've tried using 127.0.0.1 which returns the error 2003 (Can't connect
to MySQL server on 127.0.0.1 (111)

I've tried installing MySQL 5.0.67 and removing MySQL Community Server.
I've also tried updating to 5.1.30 and no matter what I do I can't
establish a connection.

When I check restart the server (sudo /etc/init.d/mysql restart) The
server shuts down and restarts but gives the error that
/var/lib/mysql/mysql.sock could not be created in 30 seconds.

Any help would be appreciated. Where do I go from here? This is a
server at my college and I'm just taking over as admin for the box. The
/etc/my.cnf is correct and has the socket = /var/lib/mysql/mysql.sock

/
Code:
--------------------
var/lib/mysql$ ls -lhd /var/lib/mysql
drwxr-xr-x 23 mysql mysql 4.0K 2011-09-23 10:55 /var/lib/mysql
--------------------



Code:
--------------------
/var/lib/mysql$ sudo /etc/init.d/mysql start
Will update MySQL now, if you encounter any problems, please read following file:
/usr/share/doc/packages/mysql-community-server/README.SuSE
Log files inconsistency, please merge following files manually:
/var/lib/mysql/mysqld.log
/var/log/mysqld.log
Running protected MySQL...
error: /var/tmp/mysql-protected.JiUX4s/mysql.sock file didn't appeared...
Try checking "/var/log/mysql/mysqld-upgrade-run.log"...
failed
--------------------


This started after I updated the broken repo
http://download.opensuse.org/reposit...openSUSE_11.1/ to 'Index of
/repositories/server:/database:/UNSTABLE/SLE_11_SP1'
(http://download.opensuse.org/reposit...LE/SLE_11_SP1/)


At which point I tried changing from MySQL 5.0.67 to MySQL Community
Server 5.1.54 to see if that would fix the 2003 error. I did check the
log files and the shared library files are erring out with No such file
or directory.


Code:
--------------------

110922 19:21:01 [ERROR] Can't open shared library '/usr/lib/mysql/plugin/ha_example.so' (errno: 0 cannot open shared object file: No such file or directory)
110922 19:21:01 [Warning] Couldn't load plugin named 'EXAMPLE' with soname 'ha_example.so'.
110922 19:21:01 [ERROR] /usr/sbin/mysqld: unknown option '--skip-federated'
110922 19:21:01 [ERROR] Aborting

--------------------


Thanks again for any assistance the forum members can lend.


--
jsw1130
------------------------------------------------------------------------
jsw1130's Profile: http://forums.novell.com/member.php?userid=117176
View this thread: http://forums.novell.com/showthread.php?t=445307