[TriLUG] Need Help with mysql start up on opensuse 12.1

[Paul Boyle]

Hi,

The aged hardware on which I ran a apache2  and mysql finally died.  I got
a "new to me" PC and installed opensuse 12.1 on it.  My backups from my old
box were all good.  So, no problems recreating stuff.  I unpacked my mysql
back-up to the new /var/lib.mysql and tried getting my database going
again.  The problem from reading the error messages seems that the Unix
domain socket /var/lib/mysql/mysql.sock cannot be created.

Here is the output from systemctl:


xray:/etc # systemctl start mysql.service
Job failed. See system logs and 'systemctl status' for details.
xray:/etc # systemctl status mysql.service
mysql.service - LSB: Start the MySQL database server
          Loaded: loaded (/etc/init.d/mysql)
          Active: failed since Fri, 10 Feb 2012 10:03:06 -0500; 21s ago
         Process: 12276 ExecStart=/etc/init.d/mysql start (code=exited,
status=1/FAILURE)
          CGroup: name=systemd:/system/mysql.service


Going through /var/log/messages, I see this:
Feb 10 10:02:36 xray mysql[12276]: /etc/rc.status: line 54: /dev/stderr: No
such device or address
Feb 10 10:03:06 xray mysql[12276]: Starting service MySQL warning:
/var/lib/mysql/mysql.sock didn't appear within 30 seconds
Feb 10 10:03:06 xray mysql[12276]: chmod: cannot access
`/var/run/mysql/mysqld.pid': No such file or directory
Feb 10 10:03:06 xray mysql[12276]: ..failed
Feb 10 10:03:06 xray systemd[1]: mysql.service: control process exited,
code=exited status=1
Feb 10 10:03:06 xray systemd[1]: Unit mysql.service entered failed state.


This smells like a permissions problem to me.  /var/lib/mysql/ has the
following user/group ownership and permissions:
drwxr-xr-x 6 mysql   smolt   4096 Feb 10 10:02 mysql

For what it's worth I was able to get apache2 and sshd running via the
systemctl mechanism.  So, while I am new to this systemctl stuff, I could
make it work after read some online tutorials and the man page.

Anyway, I would appreciate suggestions for how to fix this.  Should I just
uninstall mysql, reinstall, get the database going, mysql server software
going and then add in my backed up data?

Thanks for any help.

Paul
-- 
Paul D. Boyle
Director, X-ray Structural Facility
Department of Chemistry - Box 8204
North Carolina State University
Raleigh, NC 27695-8204