[mythtv-users] Upgraded the Ubuntu 11.10 and not Myth can't connect to MySQL
Damian
myth at surr.co.uk
Tue Nov 8 00:08:44 UTC 2011
On 06/11/2011 17:54, mythtv-users-request at mythtv.org wrote:
> Date: Sun, 06 Nov 2011 17:07:49 +0000
> From: Robert Longbottom<rongblor at googlemail.com>
> Subject: Re: [mythtv-users] Upgraded the Ubuntu 11.10 and not Myth
> can't connect to MySQL
> To:mythtv-users at mythtv.org
> Message-ID:<4EB6BEE5.4030807 at googlemail.com>
> Content-Type: text/plain; charset=ISO-8859-1; format=flowed
>
> On 06/11/2011 14:01, Damian wrote:
>> > On 05/11/2011 21:24,mythtv-users-request at mythtv.org wrote:
> <snip>
>> > Thanks for talking me though this. Here's the latest, following your
>> > instructions:
>> >
>> > damian at MythBox:~$ ls -la /var/run/mysqld
>> > total 0
>> > drwxr-xr-x 2 mysql root 40 2011-11-05 11:04 .
>> > drwxr-xr-x 26 root root 1000 2011-11-05 11:04 ..
>> >
>> > damian at MythBox:~$ cd /var/run
>> > damian at MythBox:/var/run$ sudo chown -R mysql:mysql mysqld
>> >
>> > damian at MythBox:/var/run$ ls -la /var/run/mysqld
>> > total 0
>> > drwxr-xr-x 2 mysql mysql 40 2011-11-05 11:04 .
>> > drwxr-xr-x 26 root root 1000 2011-11-05 11:04 ..
>> >
> <snip>
>
>> > damian at MythBox:/var/log/mysql$ sudo service mysql start
>> > mysql start/running
>> >
>> > damian at MythBox:/var/log/mysql$ ps ax |grep -i mysql
>> > 30457 pts/1 S+ 0:00 grep -i mysql
>> >
>> > damian at MythBox:/var/log/mysql$ cat/var/log/mysql/*.err /var/log/mysql/*.log
>> > cat:/var/log/mysql/*.err: No such file or directory
>> > 111106 13:42:33 [Note] Plugin 'FEDERATED' is disabled.
>> > 111106 13:42:33 InnoDB: Initializing buffer pool, size = 8.0M
>> > 111106 13:42:33 InnoDB: Completed initialization of buffer pool
>> > 111106 13:42:33 InnoDB: Started; log sequence number 0 20263543
>> > 111106 13:42:33 [ERROR] Can't start server : Bind on unix socket:
>> > Permission denied
>> > 111106 13:42:33 [ERROR] Do you already have another mysqld server
>> > running on socket: /var/run/mysqld/mysqld.sock ?
>> > 111106 13:42:33 [ERROR] Aborting
> Here is the (first) problem - looks like the mysql user can't write to
> /var/run/mysqld/, which is odd, because based on what you did above I
> would have thought it should be able to.
>
> I think I'd grant everyone access to write to /var/run/mysqld by running
>
> chmod o+w /var/run/mysql
>
> Delete the log file again. Start the service and see what happens. If
> it works, see what files are created in /var/run/mysqld and who owns
> them. Then fix up the permissions so that you don't need to give global
> write access.
>
> It looks like your filesystem permissions have been messed up somehow.
>
Thanks for the post Robert (and sorry for my messing up the subject
hearer for a couple of post everyone).
Here's where the last bit of help got me:
damian at MythBox:~$ sudo service mysql start
mysql start/running
damian at MythBox:~$ ls -la /var/run/mysqld
total 0
drwxr-xr-x 2 mysql root 40 2011-11-07 20:45 .
drwxr-xr-x 26 root root 1000 2011-11-07 20:46 ..
damian at MythBox:~$ sudo chmod o+w /var/run/mysqld
damian at MythBox:~$ ls -la /var/run/mysqld
total 0
drwxr-xrwx 2 mysql root 40 2011-11-07 20:45 .
drwxr-xr-x 26 root root 1000 2011-11-07 20:46 ..
damian at MythBox:~$ cd /var/log/mysql
damian at MythBox:/var/log/mysql$ ls
error.log
damian at MythBox:/var/log/mysql$ sudo rm *.l*
damian at MythBox:/var/log/mysql$ ls
damian at MythBox:/var/log/mysql$ ls -la /var/log/mysql
total 8
drwxr-s--- 2 mysql adm 4096 2011-11-07 20:50 .
drwxr-xr-x 22 root root 4096 2011-11-07 20:45 ..
damian at MythBox:/var/log/mysql$ sudo service mysql restart
This seemed to hang for a long time, so I aborted and tried again:
^C
damian at MythBox:/var/log/mysql$ sudo service mysql stop
mysql stop/waiting
damian at MythBox:/var/log/mysql$ sudo service mysql start
This again just left a blinking cursor, so I opened up another terminal
and did the following:
damian at MythBox:~$ cd /var/log/mysql
damian at MythBox:/var/log/mysql$ ls
error.log
damian at MythBox:/var/log/mysql$ ps ax |grep -i mysql
3411 pts/1 S+ 0:00 sudo service mysql start
3412 pts/1 S+ 0:00 start mysql
3985 pts/2 S+ 0:00 grep -i mysql
damian at MythBox:/var/log/mysql$ cat /var/log/mysql/*.log
111107 20:51:09 [Note] Plugin 'FEDERATED' is disabled.
111107 20:51:09 InnoDB: Initializing buffer pool, size = 8.0M
111107 20:51:09 InnoDB: Completed initialization of buffer pool
111107 20:51:10 InnoDB: Started; log sequence number 0 20263543
111107 20:51:10 [ERROR] Can't start server : Bind on unix socket:
Permission denied
111107 20:51:10 [ERROR] Do you already have another mysqld server
running on socket: /var/run/mysqld/mysqld.sock ?
111107 20:51:10 [ERROR] Aborting
111107 20:51:10 InnoDB: Starting shutdown...
111107 20:51:15 InnoDB: Shutdown completed; log sequence number 0 20263543
111107 20:51:15 [Note] /usr/sbin/mysqld: Shutdown complete
111107 20:51:40 [Note] Plugin 'FEDERATED' is disabled.
111107 20:51:40 InnoDB: Initializing buffer pool, size = 8.0M
111107 20:51:40 InnoDB: Completed initialization of buffer pool
111107 20:51:40 InnoDB: Started; log sequence number 0 20263543
111107 20:51:40 [ERROR] Can't start server : Bind on unix socket:
Permission denied
111107 20:51:40 [ERROR] Do you already have another mysqld server
running on socket: /var/run/mysqld/mysqld.sock ?
111107 20:51:40 [ERROR] Aborting
111107 20:51:40 InnoDB: Starting shutdown...
111107 20:51:45 InnoDB: Shutdown completed; log sequence number 0 20263543
111107 20:51:45 [Note] /usr/sbin/mysqld: Shutdown complete
etc etc ....
Any clue for where to go next??
Damian
More information about the mythtv-users
mailing list