Arch Linux

fastfret79

Member

Registered: 2009-09-05

Posts: 87

[SOLVED] mysql upgrade stops mythtv working

Just upgraded mysql and got the following message from pacman:

[2009-11-18 10:19] >> MySQL configuration file now is into /etc/mysql/ directory.
[2009-11-18 10:19] >> Remember to replace it with your old configuration file.
[2009-11-18 10:19] upgraded mysql (5.1.39-1 -> 5.1.40-1)

but where is my old configuration file? From Googleing I think the default is /etc/my.cnf but that file is not there. I don't remember editing a config file for mysql.

I tried running with the new default file at /etc/mysql/my.cnf but I keep getting access denied messages when running mythtv and it cannot connect to the database. I logged into mysql as root and made sure of the mythtv user password, made sure they had full privileges on the mythconverg database but still no change.

Any ideas what to try?

For now I have downgraded back to 5.1.39-1 and all's working ok.

Last edited by fastfret79 (2009-11-18 16:37:25)

ilpianista

Fellow developer

Registered: 2007-10-06

Posts: 568

Website

Re: [SOLVED] mysql upgrade stops mythtv working

Hi,
if you didn't change the old my.cnf, pacman doesn't save it.
Maybe mythtv needs a rebuild with the new MySQL, try rebuild it yourself or wait for an update.

fastfret79

Member

Registered: 2009-09-05

Posts: 87

Re: [SOLVED] mysql upgrade stops mythtv working

Well that explains why I couldn't find it! Looking now after downgrading it is at /etc/my.cnf, but the /etc/mysql/my.cnf has now been removed so I can't compare them at the moment.

Mythtv is the only reason I have mysql, but I don't think that mythtv has anything to do with it and I don't think rebuilding it will help. i.e. when running the following

mysql -u mythtv -p mythconverg

this works with 5.1.39-1 but with 5.1.40-1 it throws up the permission denied message.

I'm gonna digg around again later (when mythtv isn't recording anything!) to get to the bottom of this.

ilpianista

Fellow developer

Registered: 2007-10-06

Posts: 568

Website

Re: [SOLVED] mysql upgrade stops mythtv working

http://www.archlinux.org/news/473/

sock file path is changed. mythtv looks for mysql.sock in /tmp but with mysql-5.1.40-1 the file is in /var/run/mysql/ named mysqld.sock

fastfret79

Member

Registered: 2009-09-05

Posts: 87

Re: [SOLVED] mysql upgrade stops mythtv working

Yes - I've just seen the news item.

So I should be able to

ln -s /var/run/mysql/mysqld.sock /tmp/mysql.sock

until mythtv is updated?

Last edited by fastfret79 (2009-11-18 14:02:10)

augustob

Member

From: Florianópolis, Brazil

Registered: 2006-03-17

Posts: 135

Re: [SOLVED] mysql upgrade stops mythtv working

Yes - I've just seen the news item.

So I should be able to

ln -s /var/run/mysql/mysqld.sock /tmp/mysql.sock

until mythtv is updated?

I think that'd work, but it might be easier to just rollback from /var/cache/pacman/pkg/ and ignore mysql on /etc/pacman.conf. That's what I did, anyway.

fastfret79

Member

Registered: 2009-09-05

Posts: 87

Re: [SOLVED] mysql upgrade stops mythtv working

I'm marking as solved - I just changed the socket path in the new /etc/mysql/my.cnf back to /tmp/mysql.sock

I think this should be ok for me as I am only using mysql for mythtv so I shouldn't see any breakage anywhere else.