[mythtv-users] Backend not connecting to database after reboot

Thomas Mashos thomas at mashos.com
Tue Dec 15 02:02:42 UTC 2015


/var/log/apt/history.log

On Mon, Dec 14, 2015, 5:42 PM Ian Evans <dheianevans at gmail.com> wrote:

> On Mon, Dec 14, 2015 at 4:32 PM, Thomas Mashos <thomas at mashos.com> wrote:
>
>> On Mon, Dec 14, 2015 at 1:10 PM Ian Evans <dheianevans at gmail.com> wrote:
>>
>
>>> On Dec 14, 2015 2:19 PM, "Thomas Mashos" <thomas at mashos.com> wrote:
>>> >
>>> >
>>> >
>>> > On Mon, Dec 14, 2015 at 9:06 AM Ian Evans <dheianevans at gmail.com>
>>> wrote:
>>>
>>> >>
>>> >> So mysql's running but were not getting a connection. Never seen this
>>> happen in a reboot before. What should I be checking next?
>>> >>
>>> >>
>>> >
>>>
>>> > What distro are you running?
>>> >
>>> > The issue is that your mssql server is only listening on 127.0.0.1 and
>>> your backend is trying to connect to it on 192.168.1.145. You need to
>>> either tell your backend to connect to 127.0.0.1 (assuming both are on the
>>> same box) or tell mysql to listen on the other interface (or all
>>> interfaces).
>>> > --
>>>
>>> Running Mythbuntu. I looked and yes the my.cnf was binding to 127.0.0.1
>>> which is weird because I have ALWAYS had the frontend config set to the
>>> boxes IP address since 2011. Anything in the upgrade that could have
>>> changed it?
>>>
>> We don't change my.cnf, we actually change a file in
>>> /etc/mysql/conf.d/mythtv.cnf. What does it say in there? Did you get any
>>> mysql updates at the same time?
>>>
>>>
> the mythtv.cnf:
>
> [mysqld]
> #bind-address=0.0.0.0
> max_connections=250
>
> Can't remember if there were mysql updates. Is there a log that shows the
> last update in Ubuntu?
>
> _______________________________________________
> mythtv-users mailing list
> mythtv-users at mythtv.org
> http://lists.mythtv.org/mailman/listinfo/mythtv-users
> http://wiki.mythtv.org/Mailing_List_etiquette
> MythTV Forums: https://forum.mythtv.org
>
-- 
Thomas Mashos
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.mythtv.org/pipermail/mythtv-users/attachments/20151215/4563ef3c/attachment.html>


More information about the mythtv-users mailing list