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

[Ian Evans]

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?
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.mythtv.org/pipermail/mythtv-users/attachments/20151214/85212d85/attachment.html>