[mythtv-users] Several backends and passwords

[Klaus Becker]

Le lundi 21 mai 2018 10:47:48 CEST, vous avez écrit :
> On 21/05/18 09:02, Klaus Becker wrote:
> > 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
> > .....
> 
> You are using an OS that uses systemd. If you do not use the 'systemctl'
> functions then the results cannot be guaranteed. You should *not* be
> calling the /etc/init.d functions directly as this will bypass many of the
> checks and queueing functions that systemd uses to ensure correct
> operation.


Ok, I tried:

# systemctl start mythtv-backend

# systemctl status mythtv-backend
● mythtv-backend.service
   Loaded: loaded (/etc/systemd/system/mythtv-backend.service; enabled; vendor 
preset: enabled)
   Active: active (running) since Mon 2018-05-21 11:34:44 CEST; 4s ago
 Main PID: 13167 (mythbackend)
    Tasks: 6 (limit: 4915)
   Memory: 25.1M
   CGroup: /system.slice/mythtv-backend.service
           └─13167 /usr/bin/mythbackend --quiet --syslog local7

mai 21 11:34:44 1stein mythbackend[13167]: mythbackend[13167]: I CoreContext 
mythcorecontext.cpp:271 (Init) Assumed character
mai 21 11:34:44 1stein mythbackend[13167]: mythbackend[13167]: N CoreContext 
mythcontext.cpp:599 (LoadDatabaseSettings) Empty
mai 21 11:34:44 1stein mythbackend[13167]: mythbackend[13167]: I CoreContext 
mythcontext.cpp:607 (LoadDatabaseSettings) Using
mai 21 11:34:44 1stein mythbackend[13167]: mythbackend[13167]: I CoreContext 
mythcontext.cpp:852 (TestDBconnection) Start up 
mai 21 11:34:44 1stein mythbackend[13167]: mythbackend[13167]: I LogForward 
loggingserver.cpp:302 (SyslogLogger) Added syslog
mai 21 11:34:45 1stein mythbackend[13167]: mythbackend[13167]: E CoreContext 
mythdbcon.cpp:242 (OpenDatabase) [DBManager0] Un
mai 21 11:34:45 1stein mythbackend[13167]: mythbackend[13167]: E CoreContext 
mythdbcon.cpp:243 (OpenDatabase) Driver error wa
                                           QMYSQL: Unable to connect
                                           Database error was:
                                           Access denied for user 
'mythtv'@'localhost' (using password: YES)
mai 21 11:34:46 1stein mythbackend[13167]: mythbackend[13167]: I CoreContext 
mythcontext.cpp:852 (TestDBconnection) Start up 
mai 21 11:34:46 1stein mythbackend[13167]: mythbackend[13167]: E CoreContext 
mythdbcon.cpp:242 (OpenDatabase) [DBManager1] Un
mai 21 11:34:46 1stein mythbackend[13167]: mythbackend[13167]: E CoreContext 
mythdbcon.cpp:243 (OpenDatabase) Driver error wa
                                           QMYSQL: Unable to connect
                                           Database error was:
                                           Access denied for user 
'mythtv'@'localhost' (using password: YES)