[mythtv-users] Several backends and passwords

[Klaus Becker]

Le lundi 14 mai 2018 10:19:14 CEST, vous avez écrit :
> Le dimanche 13 mai 2018, 16:17:51 CEST Stephen Worthington a écrit :
> > On Sun, 13 May 2018 15:48:32 +0200, you wrote:
> > >Hi,
> > >
> > >I have several backends on several computers with Debian.
...

> > To change the password for the mythtv user to 'new password', the
> > command would be:
> > 
> > set password for 'mythtv'@'%' = PASSWORD('new password');


I have a new problem with my password.

On my main computer, I have Debian Sid and Debian stable. I use Sid, but 
sometimes I have some problems with it, and then I use Stretch. Both systems 
have the same /home/klaus.

I changed the password with the command above and it worked. But then I used 
Debian Stretch and here I changed password too. So I have the same password in 
both systems, in /etc/mythtv/config.xml and in /home/klaus/.mythtv/config.xml.

I was surprised to see that in Stretch, the frontend cannot connect to the 
database.

I could not resolve the problem, so I returned to Sid. But now, I have the 
same problem in Sid:

Frontend says:
2018-05-21 09:46:07.339259 E  WOL failed, unable to connect to database!
2018-05-21 09:46:07.339271 E  [DBManager1] Unable to connect to database!
2018-05-21 09:46:07.339283 E  Driver error was [1/1045]:
QMYSQL: Unable to connect
Database error was:
Access denied for user 'mythtv'@'localhost' (using password: YES)


I looked for the backend:

# /etc/init.d/mythtv-backend status
● mythtv-backend.service
   Loaded: loaded (/etc/systemd/system/mythtv-backend.service; enabled; vendor 
preset: enabled)
   Active: failed (Result: exit-code) since Mon 2018-05-21 09:31:29 CEST; 
25min ago
 Main PID: 3535 (code=exited, status=130)


# /etc/init.d/mythtv-backend start
[ ok ] Starting mythtv-backend (via systemctl): mythtv-backend.service.


# /etc/init.d/mythtv-backend status
● mythtv-backend.service
   Loaded: loaded (/etc/systemd/system/mythtv-backend.service; enabled; vendor 
preset: enabled)
   Active: active (running) since Mon 2018-05-21 09:57:59 CEST; 40s ago
 Main PID: 6171 (mythbackend)
    Tasks: 5 (limit: 4915)
   Memory: 30.8M
   CGroup: /system.slice/mythtv-backend.service
           └─6171 /usr/bin/mythbackend --quiet --syslog local7

mai 21 09:58:22 1stein mythbackend[6171]: mythbackend[6171]: E CoreContext 
mythdbcon.cpp:243 (OpenDatabase) Driver e…1/1045]:
                                          QMYSQL: Unable to connect
                                          Database error was:...
mai 21 09:58:27 1stein mythbackend[6171]: mythbackend[6171]: I CoreContext 
mythcontext.cpp:852 (TestDBconnection) St…bStarted
.....


I tried without success "# dpkg-reconfigure mythtv-database".


Cheers

Klaus