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

[Anthony Giggins]

On 9 January 2018 at 11:17, Jim Abernathy <jfabernathy at outlook.com> wrote:

>
>
> 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
>
>
Perhaps mysql permissions? you can test from your frontend

mysql -h192.168.0.250 -umythtv -p<YourPassword>

if you need to add permissions check out the below

https://www.mythtv.org/wiki/Database_Setup#Modifying_access_to_the_MySQL_database_for_multiple_systems

Cheers,

Anthony
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.mythtv.org/pipermail/mythtv-users/attachments/20180109/a282f9b3/attachment.html>