[mythtv-users] Database access problems

[John Pilkington]

I have spent the past few days away from home with internet access via a 
wifi hotspot that comes and goes unpredictably.  The laptop has kubuntu 
16.04 and MythTV master from the ppa, updated in July and last weekend. 
It has a crossover local-link ethernet cable to the tv, and DLNA 
playback had been working fine.   That needs a non-127.0.0.1 backend 
address; the tv shows a manually entered DNS address of 169.254.51 .44 
and the laptop 'details' shows 169.254.51.44

Then I noticed that calls to 'mythcommflag --rebuild' and 'mythutil 
--clearbookmarks' were hanging, saying that they could not access the 
DB.  Since then I have been trying to get back to normal and may well 
have created other problems.  The laptop is running again, and the 
commflag and util commands, but no big-screen playback.

{{{

mythbackend

2019-09-19 20:27:05.654103 A  Cannot find default UPnP backend
2019-09-19 20:27:05.654228 I  Start up testing connections. DB 
127.0.0.1, BE , attempt 0, status start, Delay: 2000

mythfrontend.real

2019-09-19 20:27:34.804034 I  UPNP Search up to 1 secs
2019-09-19 20:27:36.039075 I  Start up testing connections. DB 
127.0.0.1, BE , attempt 0, status start, Delay: 2000
2019-09-19 20:27:37.589215 N  Setting QT default locale to en_GB

$ mysql  -umythtv -pXXX -h localhost mythconverg
mysql: [Warning] Using a password on the command line interface can be 
insecure.
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 48
Server version: 5.7.27-0ubuntu0.16.04.1 (Ubuntu)

Copyright (c) 2000, 2019, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input 
statement.

mysql> show grants ;
+---------------------------------------------------------+
| Grants for mythtv@%                                     |
+---------------------------------------------------------+
| GRANT USAGE ON *.* TO 'mythtv'@'%'                      |
| GRANT ALL PRIVILEGES ON `mythconverg`.* TO 'mythtv'@'%' |
+---------------------------------------------------------+
2 rows in set (0.00 sec)

mysql> show grants for  'mythtv'@'%' ;
+---------------------------------------------------------+
| Grants for mythtv@%                                     |
+---------------------------------------------------------+
| GRANT USAGE ON *.* TO 'mythtv'@'%'                      |
| GRANT ALL PRIVILEGES ON `mythconverg`.* TO 'mythtv'@'%' |
+---------------------------------------------------------+
2 rows in set (0.00 sec)

mysql> show grants for  'mythtv'@'localhost' ;
ERROR 1141 (42000): There is no such grant defined for user 'mythtv' on 
host 'localhost'
mysql> show grants for  'mythtv'@'127.0.0.1' ;
ERROR 1141 (42000): There is no such grant defined for user 'mythtv' on 
host '127.0.0.1'
mysql> show grants for  'mythtv'@'169.254.51.44' ;
ERROR 1141 (42000): There is no such grant defined for user 'mythtv' on 
host '169.254.51.44'
mysql>

  }}}

Suggestions hoped for - but feedback is likely to be delayed.

Thanks,

John P