MySQL not starting

For discussion of topics specific to MythTV on OSX
Post Reply
Tripp
Newcomer
Posts: 2
Joined: Mon Nov 10, 2014 7:03 pm
United States of America

MySQL not starting

Post by Tripp »

I just downloaded and installed the latest version of the Mac MythTV which was supposed to contain everything I needed.

When trying to start, it says unable to connect to database on MySQL. It then gives me a pop up so long I can't see the whole message nor can I select the text. If someone can point me to the log file I could add that.

What I do see is it is unable to connect to MySQL server via socket: /opt/dvr/var/run/mariadb/mysqld.sock (2) and /var/run/lirc/lircd' eno No such file or directory

Please help. Want to use this with XBMC Gotham. My Mac is currently on 10.8.5.
Tripp
Newcomer
Posts: 2
Joined: Mon Nov 10, 2014 7:03 pm
United States of America

Re: MySQL not starting

Post by Tripp »

Ok, I figured out what I did wrong, I didn't see the instructions on creating the database at the bottom of Mac ports instructions. I've followed them but can't get the MySql service to start. When I try to start it, I get the following:

Code: Select all

HoMedia:~ Shannon$ mysqld start
141110 15:05:26 [Warning] Can't create test file /opt/dvr/var/db/mariadb/HoMedia.lower-test
mysqld: Can't change dir to '/opt/dvr/var/db/mariadb/' (Errcode: 13)
141110 15:05:26 [ERROR] Aborting

141110 15:05:26 [Note] mysqld: Shutdown complete
I think the new time zone tables didn't take possibly.
User avatar
pvr4me
Senior
Posts: 763
Joined: Fri Feb 07, 2014 7:25 pm
Location: near Toronto, Canada
Contact:
Canada

Re: MySQL not starting

Post by pvr4me »

Tripp wrote:Ok, I figured out what I did wrong, I didn't see the instructions on creating the database at the bottom of Mac ports instructions. I've followed them but can't get the MySql service to start. When I try to start it, I get the following:

Code: Select all

HoMedia:~ Shannon$ mysqld start
141110 15:05:26 [Warning] Can't create test file /opt/dvr/var/db/mariadb/HoMedia.lower-test
mysqld: Can't change dir to '/opt/dvr/var/db/mariadb/' (Errcode: 13)
141110 15:05:26 [ERROR] Aborting

141110 15:05:26 [Note] mysqld: Shutdown complete
I think the new time zone tables didn't take possibly.
'mysqld start' is not the right command. Please check the docs at:

http://www.mythtv.org/wiki/MacPorts#Database

It is hard to tell exactly what you have done.

Craig
(Could a mod move this to the OS X section, where it more properly belongs?)
Formerly the MacPorts guy.
Post Reply