[mythtv-users] Is it possible to move the MySQL directories or: Mydoesn't Mythbackend start anymore?
Steve Daniels
steve.p.daniels at googlemail.com
Sat Jul 29 12:30:53 UTC 2006
> -----Original Message-----
> From: mythtv-users-bounces at mythtv.org [mailto:mythtv-users-
> bounces at mythtv.org] On Behalf Of Gert-Jan Bilt, van de
> Sent: 29 July 2006 12:13
> To: mythtv-users at mythtv.org
> Subject: [mythtv-users] Is it possible to move the MySQL directories or:
> Mydoesn't Mythbackend start anymore?
>
> All,
>
> I was forced to move my MySQL base directory from /var/lib/mysql to
> /opt/data/mysql on a Linux box. After changing the /etc/my.cnf and the
> /etc/init.d/mysqld files to reflect this change of directories I can log
> into the MySQL server like before.
>
> However, mythbackend can not!
>
> The error message I get is the following:
> QMYSQL3: Unable to connect
> Database error was:
> Can't connect to local MySQL server through socket
> '/var/lib/mysql/mysql.sock' (2)
>
> Which obviously is true, since this directory and this file no longer
> exists.
>
> My question: Why can I log into the mysql database without any problem if
> I do it manually with the mythtv user, but why can mythbackend not log in.
Because it appears mythbackend uses sockets when connecting to a mysql db on
a local machine. You could try specifying
> Does mythbackend have some sort of hardcoded reference to this
> /var/lib/mysql/mysql.sock file?
>
> Anybody know?
>
> GJ
Don't know/can't remember about that but you could try symlinking so
/var/lib/mysql/mysql.sock actually points to /opt/data/mysql/mysql.sock
HTH
Steve Daniels
--
No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.1.394 / Virus Database: 268.10.5/403 - Release Date: 28/07/2006
More information about the mythtv-users
mailing list