[TriLUG] Need Help with mysql start up on opensuse 12.1
boyle at ncsu.edu
Fri Feb 10 10:10:41 EST 2012
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,
Going through /var/log/messages, I see this:
Feb 10 10:02:36 xray mysql: /etc/rc.status: line 54: /dev/stderr: No
such device or address
Feb 10 10:03:06 xray mysql: Starting service MySQL warning:
/var/lib/mysql/mysql.sock didn't appear within 30 seconds
Feb 10 10:03:06 xray mysql: chmod: cannot access
`/var/run/mysql/mysqld.pid': No such file or directory
Feb 10 10:03:06 xray mysql: ..failed
Feb 10 10:03:06 xray systemd: mysql.service: control process exited,
Feb 10 10:03:06 xray systemd: 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 D. Boyle
Director, X-ray Structural Facility
Department of Chemistry - Box 8204
North Carolina State University
Raleigh, NC 27695-8204
More information about the TriLUG