[mythtv-users] One step forward, two steps back - Frontends not woring properly

[Vincent McIntyre]

On Fri, Apr 29, 2016 at 11:23:40PM +0100, Damian Surr wrote:
...deletia...
> I just remembered something else that happened earlier .. in case it's
> relevant.
> 
> While running some updates, the myth backend update seemed to want me to
> configure mysql for a user called 'debian-sys-maint'. I've never had to
> configue any mysql users other than 'root' and 'mythtv' before, so this
> threw me. I tried to just skip it, but if I log into mysql as root and run
> "SELECT User FROM mysql.user;" (which is a command that I don't understand
> in the slightest, I just found it online to list users), then
> 'debian-sys-maint' makes an appearance ...
> 
> mysql> SELECT User FROM mysql.user;
> +------------------+
> | User             |
> +------------------+
> | mythtv           |
> | debian-sys-maint |
> | mysql.sys        |
> | root             |
> +------------------+
> 4 rows in set (0.00 sec)
> 
> Could this have messed things up?
> 

debian-sys-maint is a user that the debian mysql package sets up
to run certain automated tasks. It has roughly the same powers as
the database 'root' user. So I don't think it is a problem that it
exists but I am a bit nonplussed as to why you should have had to
do anything to configure mysql for that user.
This makes mw wonder if you have another config problem that might
be triggering 'expert' questions about things like debian-sys-maint.

> Should I try something like:
> 
> sudo dpkg-reconfigure mythtv-database
> sudo dpkg-reconfigure mythtv-common
> 
> or could that break things more?
> 
> or should i be trying to delete that user out of mysql? (i have no
> idea how to do that .. i could probalby do it if i install
> phpmyadmin).
 
I don't think you need to do that. At this point I think it would be
wise to run the mysql backup script that mythtv provides.
  /usr/bin/perl /usr/share/mythtv/mythconverg_backup.pl

If my speculation above is correct It might be worth reinstalling mysql
rather than reconfiguring eythtv-database.
But I'd wait for advice from more knowledgeable folk thank me on that.

Vince