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

[Glenn Hennessee]

Hi Paul,
Under Ubuntu, mysql is both user and group and permissions are different
drwx------ 2 mysql mysql     4096 2011-10-16 16:01 mysql
Try changing the owner and permissions.
glenn

On Fri, Feb 10, 2012 at 10:10 AM, Paul Boyle <boyle at ncsu.edu> wrote:
> 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
> --
> This message was sent to: glenn.hennessee at gmail.com <glenn.hennessee at gmail.com>
> To unsubscribe, send a blank message to trilug-leave at trilug.org from that address.
> TriLUG mailing list : http://www.trilug.org/mailman/listinfo/trilug
> Unsubscribe or edit options on the web  : http://www.trilug.org/mailman/options/trilug/glenn.hennessee%40gmail.com
> TriLUG FAQ          : http://www.trilug.org/wiki/Frequently_Asked_Questions



-- 
Glenn