[mythtv-users] mythtv v29 can't connect remote frontend

[Jim Abernathy]

On 01/08/2018 08:08 PM, Jim Abernathy wrote:
>
> On 01/08/2018 07:51 PM, Bill Meek wrote:
>> On 01/08/2018 06:40 PM, Jim Abernathy wrote:
>>
>> ...
>>
>>> In my mythtv v29 installed mariadb and put a file called mythtv.cnf in
>>> /etc/mysql/conf.d.  That file only had:
>>> [mysqld]
>>> #bind-address=::
>>> max_connections=100
>> Right, mariadb is a bit different. Edit the file above and uncomment
>> the bind-address line.
>>
>> Or, if you want to follow things you'll see the 2 includes
>> below and that's the order they're read. You have to read
>> each file in each directory to really see what's happening.
>>
>> cat /etc/mysql/my.cnf
>>
>> ...
>>
>> # Import all .cnf files from configuration directory
>> !includedir /etc/mysql/conf.d/.
>> !includedir /etc/mysql/mariadb.conf.d/
>>
>> cat /etc/mysql/mariadb.conf.d/mythtv.cnf
>> [mysqld]
>> bind-address=::
>> max_connections = 100
>> table_open_cache = 128
>>
> so I made my mythtv.cnf have the bind-address=:: and restarted mysql.
> but no change.  I even uninstalled mythtv-frontend and reinstalled.
>
> I think it can't build the config.xml files because it can't open the
> database for the mythtv BE it found via  UPNP.  seems that's what it's
> saying the --verbose console
>
> Jim A
some of the log
2018-01-08 20:15:04.948759 E  [DBManager0] Unable to connect to database!
2018-01-08 20:15:04.948770 E  Driver error was [1/2003]:
QMYSQL: Unable to connect
Database error was:
Can't connect to MySQL server on '192.168.0.250' (111)

2018-01-08 20:15:04.957303 E  MythFontProperties: Failed to load 'Droid 
Sans', got 'DejaVu Sans' instead
             Location: 
/usr/share/mythtv/themes/MythCenter-wide/keyboard/keyboard.xml @ 7
             Name: 'key'    Type: 'fontdef'
2018-01-08 20:15:04.996621 N  Loading definitions from: 
/usr/share/mythtv/themes/default/keyboard/en_us.xml
2018-01-08 20:15:17.342719 I  Start up testing connections. DB 
192.168.0.250, BE , attempt 0, status dbAwake
2018-01-08 20:15:18.344088 I  Start up testing connections. DB 
192.168.0.250, BE , attempt 1, status dbAwake
2018-01-08 20:15:23.439495 I  Start up testing connections. DB 
192.168.0.250, BE , attempt 2, status dbAwake
2018-01-08 20:15:25.950128 I  Start up failure. host 192.168.0.250, 
status dbAwakeFail
2018-01-08 20:15:25.950146 A  Cannot login to database
2018-01-08 20:15:25.950153 E  Error: Cannot login to database
2018-01-08 20:15:25.951272 I  Putting up the UPnP backend chooser
2018-01-08 20:15:28.648077 I  Start up testing connections. DB 
192.168.0.250, BE , attempt 0, status dbAwake
2018-01-08 20:15:29.659073 I  Start up testing connections. DB 
192.168.0.250, BE , attempt 1, status dbAwake
2018-01-08 20:15:34.794192 I  Start up failure. host 192.168.0.250, 
status dbAwakeFail
2018-01-08 20:15:34.794216 A  Cannot login to database

> _______________________________________________
> 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