Arch Linux

xiainx

Member

Registered: 2010-06-12

Posts: 13

MySQL Installation Problem

Hi there,
I'm trying to setup my turbogears project on my Arch server (currently hosted on my Ubuntu server), but I'm having difficulty getting MySQL to play nicely. I've got it installed, but when I try to start the daemon, it fails. Let me know what other information you need. (Arch linux x86_64).

urist

Member

Registered: 2009-02-22

Posts: 248

Re: MySQL Installation Problem

What happens if you remove the redirect to /dev/null in /etc/rc.d/mysqld?

xiainx

Member

Registered: 2010-06-12

Posts: 13

Re: MySQL Installation Problem

What happens if you remove the redirect to /dev/null in /etc/rc.d/mysqld?

Maybe you can tell me how to do that?

urist

Member

Registered: 2009-02-22

Posts: 248

Re: MySQL Installation Problem

How do you start MySQL? If you do

sudo /etc/rc.d/mysqld start

or something similar, just edit the file (as root) in your favorite text editor. It's a shell script, not an executable.

Under the "start" branch of the case statement, I see

[ ! -d /var/run/mysqld ] && install -d -g mysql -o mysql /var/run/mysqld &>/dev/null

Just remove "&>/dev/null" and you get to see all the nifty messages.

xiainx

Member

Registered: 2010-06-12

Posts: 13

Re: MySQL Installation Problem

Alright, all I learned from this was that the daemon was logging to some file, which I took a look inside, and found....

101006 18:52:26 mysqld_safe mysqld from pid file /var/lib/mysql/tower.pid ended
101006 18:53:26 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
101006 18:53:26 [Note] Plugin 'FEDERATED' is disabled.
101006 18:53:26 [Note] Plugin 'ndbcluster' is disabled.
101006 18:53:26  InnoDB: Started; log sequence number 0 44233
101006 18:53:26 [ERROR] Can't start server : Bind on unix socket: Permission denied
101006 18:53:26 [ERROR] Do you already have another mysqld server running on socket: /var/run/mysqld/mysqld.sock ?
101006 18:53:26 [ERROR] Aborting

101006 18:53:26  InnoDB: Starting shutdown...
101006 18:53:31  InnoDB: Shutdown completed; log sequence number 0 44233
101006 18:53:31 [Note] /usr/sbin/mysqld: Shutdown complete

101006 18:53:31 mysqld_safe mysqld from pid file /var/lib/mysql/tower.pid ended

Obviously I'm not running another mysqld. The owner/group of /var/lib/mysql is mysql:mysql and root has permission 7. Any ideas/suggestions???

xiainx

Member

Registered: 2010-06-12

Posts: 13

Re: MySQL Installation Problem

It seems my filesystem is corrupted, so the daemon couldn't read/write to /var/run (an ls revealed some strange things going on with that directory).
I will have to reinstall on the server when I get home and take a closer look, the machine was having some issues with its bus a few months ago.