[mythtv-users] Several backends and passwords
Klaus Becker
colonius at free.fr
Mon May 21 08:02:16 UTC 2018
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
More information about the mythtv-users
mailing list