[mythtv-users] mythfilldatabase fails on mariadb

[Darwin O'Connor]

On Mon, Nov 3, 2014 at 5:23 PM, <mythtv-users-request at mythtv.org> wrote:

> Date: Mon, 3 Nov 2014 14:01:31 -0400
> From: Craig Treleaven <ctreleaven at cogeco.ca>
> Subject: Re: [mythtv-users] mythfilldatabase fails on mariadb
>
> At 12:15 PM -0500 11/3/14, Darwin O'Connor wrote:
>
> >However I did have problems getting mythbackend to connect to
> >mariadb. It seems it was trying to connect to the mysql sock file
> >instead of the mariadb one and I couldn't find where that was
> >configured. I fixed it by changing the hostname in the config.xml
> >file to 10.0.0.10.
>
> Normally socket problems are because there is an /etc/my.cnf file
> that is overriding /opt/local/etc/mariadb/my.cnf .  If you have such,
> please either rename or remove it.
>
>
I had no /etc/my.cnf


> >I have switched the hostname back to localhost and the problems
> >connecting and the problem with mythfilldatabase seem to have
> >disappeared so far. Maybe the reboot fixed it.
>
> What did you change:  /opt/local/var/mythtvuser/.mythtv/config.xml ?
> This is the file used by the backend and its children (including
> mythfilldatabase when run automatically).
>
>
The first time I changed the host to 10.0.0.10 on both that one and
~darwin/.mythtv/config.xml. I have put it back to localhost at both places.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.mythtv.org/pipermail/mythtv-users/attachments/20141104/ee61b866/attachment.html>