Mailing List Archive

Several backends and passwords
Hi,

I have several backends on several computers with Debian.

I wrote a little script to change password in ~/mythtv/config.xml each time I
use another backend.

But it would be simpler to have the same password everywhere.

Can I change password manually in /etc/mythtv/config.xml and then in ~/mythtv/
config.xml ?

Or is it better tu run "dpkg-reconfigure mythtv-database" and/or
"pkg-reconfigure mythtv-common" ?

Or is there a better way I ignore ?

Thanks for help

Klaus
_______________________________________________
mythtv-users mailing list
mythtv-users@mythtv.org
http://lists.mythtv.org/mailman/listinfo/mythtv-users
http://wiki.mythtv.org/Mailing_List_etiquette
MythTV Forums: https://forum.mythtv.org
Re: Several backends and passwords [ In reply to ]
On Sun, 13 May 2018 15:48:32 +0200, you wrote:

>Hi,
>
>I have several backends on several computers with Debian.
>
>I wrote a little script to change password in ~/mythtv/config.xml each time I
>use another backend.
>
>But it would be simpler to have the same password everywhere.
>
>Can I change password manually in /etc/mythtv/config.xml and then in ~/mythtv/
>config.xml ?
>
>Or is it better tu run "dpkg-reconfigure mythtv-database" and/or
>"pkg-reconfigure mythtv-common" ?
>
>Or is there a better way I ignore ?
>
>Thanks for help
>
>Klaus

You can change the password of a user in the database:

https://mariadb.com/kb/en/library/set-password

From root if you run "mysql" then these commands, you will see the
list of users:

use mysql;
select user,host from user;

This is what I get:

MariaDB [mysql]> select user,host from user;
+--------+---------------------+
| user | host |
+--------+---------------------+
| mythtv | % |
| root | localhost |
| root | savaidhg.jsw.gen.nz |
+--------+---------------------+
3 rows in set (0.00 sec)

So I have three users:

'mythtv'@'%'
'root'@'localhost'
'root'@'savaidhg.jsw.gen.nz'

To change the password for the mythtv user to 'new password', the
command would be:

set password for 'mythtv'@'%' = PASSWORD('new password');

If you want to see what access a user has to the database, use the
show grants command:

MariaDB [mysql]> show grants for mythtv@'%';
+-------------------------------------------------------------------------------------------------------+
| Grants for mythtv@% |
+-------------------------------------------------------------------------------------------------------+
| GRANT USAGE ON *.* TO 'mythtv'@'%' IDENTIFIED BY PASSWORD 'XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX' |
| GRANT ALL PRIVILEGES ON `mythconverg`.* TO 'mythtv'@'%' |
+-------------------------------------------------------------------------------------------------------+
2 rows in set (0.00 sec)
_______________________________________________
mythtv-users mailing list
mythtv-users@mythtv.org
http://lists.mythtv.org/mailman/listinfo/mythtv-users
http://wiki.mythtv.org/Mailing_List_etiquette
MythTV Forums: https://forum.mythtv.org
Re: Several backends and passwords [ In reply to ]
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.
> >
> >I wrote a little script to change password in ~/mythtv/config.xml each time
> >I use another backend.
> >
> >But it would be simpler to have the same password everywhere.
> >
> >Can I change password manually in /etc/mythtv/config.xml and then in
> >~/mythtv/ config.xml ?
> >
> >Or is it better tu run "dpkg-reconfigure mythtv-database" and/or
> >"pkg-reconfigure mythtv-common" ?
> >
> >Or is there a better way I ignore ?
> >
> >Thanks for help
> >
> >Klaus
>
> You can change the password of a user in the database:
>
> https://mariadb.com/kb/en/library/set-password
>
> From root if you run "mysql" then these commands, you will see the
> list of users:
>
> use mysql;
> select user,host from user;
>
> This is what I get:
>
> MariaDB [mysql]> select user,host from user;
> +--------+---------------------+
>
> | user | host |
>
> +--------+---------------------+
>
> | mythtv | % |
> | root | localhost |
> | root | savaidhg.jsw.gen.nz |
>
> +--------+---------------------+
> 3 rows in set (0.00 sec)
>
> So I have three users:
>
> 'mythtv'@'%'
> 'root'@'localhost'
> 'root'@'savaidhg.jsw.gen.nz'


I get:

MariaDB [mysql]> select user,host from user;
+------------+-----------+
| user | host |
+------------+-----------+
| klaus | % |
| mythtv | % |
| stephen | % |
| mythtv | localhost |
| phpmyadmin | localhost |
| root | localhost |
+------------+-----------+
6 rows in set (0.00 sec)

I suppose I should delete some users. Wich ones and how ?


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

Works, thank you

Klaus


_______________________________________________
mythtv-users mailing list
mythtv-users@mythtv.org
http://lists.mythtv.org/mailman/listinfo/mythtv-users
http://wiki.mythtv.org/Mailing_List_etiquette
MythTV Forums: https://forum.mythtv.org
Re: Several backends and passwords [ In reply to ]
On Mon, 14 May 2018 10:19:14 +0200, you wrote:

>> You can change the password of a user in the database:
>>
>> https://mariadb.com/kb/en/library/set-password
>>
>> From root if you run "mysql" then these commands, you will see the
>> list of users:
>>
>> use mysql;
>> select user,host from user;
>>
>> This is what I get:
>>
>> MariaDB [mysql]> select user,host from user;
>> +--------+---------------------+
>>
>> | user | host |
>>
>> +--------+---------------------+
>>
>> | mythtv | % |
>> | root | localhost |
>> | root | savaidhg.jsw.gen.nz |
>>
>> +--------+---------------------+
>> 3 rows in set (0.00 sec)
>>
>> So I have three users:
>>
>> 'mythtv'@'%'
>> 'root'@'localhost'
>> 'root'@'savaidhg.jsw.gen.nz'
>
>
>I get:
>
>MariaDB [mysql]> select user,host from user;
>+------------+-----------+
>| user | host |
>+------------+-----------+
>| klaus | % |
>| mythtv | % |
>| stephen | % |
>| mythtv | localhost |
>| phpmyadmin | localhost |
>| root | localhost |
>+------------+-----------+
>6 rows in set (0.00 sec)
>
>I suppose I should delete some users. Wich ones and how ?

The only one that likely needs deleting there is me. The others all
look as though they are needed or useful.

The DROP USER command is documented here:

https://mariadb.com/kb/en/library/drop-user/

So to delete me, you would do:

drop user 'stephen'@'%';


>> To change the password for the mythtv user to 'new password', the
>> command would be:
>>
>> set password for 'mythtv'@'%' = PASSWORD('new password');
>
>Works, thank you
>
>Klaus
_______________________________________________
mythtv-users mailing list
mythtv-users@mythtv.org
http://lists.mythtv.org/mailman/listinfo/mythtv-users
http://wiki.mythtv.org/Mailing_List_etiquette
MythTV Forums: https://forum.mythtv.org
Re: Several backends and passwords [ In reply to ]
Le lundi 14 mai 2018, 10:49:08 CEST Stephen Worthington a ?crit :
> On Mon, 14 May 2018 10:19:14 +0200, you wrote:
> >> You can change the password of a user in the database:
> >>
> >> https://mariadb.com/kb/en/library/set-password
> >>
> >> From root if you run "mysql" then these commands, you will see the
> >> list of users:
> >>
> >> use mysql;
> >> select user,host from user;
> >>
> >> This is what I get:
> >>
> >> MariaDB [mysql]> select user,host from user;
> >> +--------+---------------------+
> >>
> >> | user | host |
> >>
> >> +--------+---------------------+
> >>
> >> | mythtv | % |
> >> | root | localhost |
> >> | root | savaidhg.jsw.gen.nz |
> >>
> >> +--------+---------------------+
> >> 3 rows in set (0.00 sec)
> >>
> >> So I have three users:
> >>
> >> 'mythtv'@'%'
> >> 'root'@'localhost'
> >> 'root'@'savaidhg.jsw.gen.nz'
> >
> >I get:
> >
> >MariaDB [mysql]> select user,host from user;
> >+------------+-----------+
> >
> >| user | host |
> >
> >+------------+-----------+
> >
> >| klaus | % |
> >| mythtv | % |
> >| stephen | % |
> >| mythtv | localhost |
> >| phpmyadmin | localhost |
> >| root | localhost |
> >
> >+------------+-----------+
> >6 rows in set (0.00 sec)
> >
> >I suppose I should delete some users. Wich ones and how ?
>
> The only one that likely needs deleting there is me. The others all
> look as though they are needed or useful.
>
> The DROP USER command is documented here:
>
> https://mariadb.com/kb/en/library/drop-user/
>
> So to delete me, you would do:
>
> drop user 'stephen'@'%';


Ok, done

Klaus


_______________________________________________
mythtv-users mailing list
mythtv-users@mythtv.org
http://lists.mythtv.org/mailman/listinfo/mythtv-users
http://wiki.mythtv.org/Mailing_List_etiquette
MythTV Forums: https://forum.mythtv.org
Re: Several backends and passwords [ In reply to ]
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


_______________________________________________
mythtv-users mailing list
mythtv-users@mythtv.org
http://lists.mythtv.org/mailman/listinfo/mythtv-users
http://wiki.mythtv.org/Mailing_List_etiquette
MythTV Forums: https://forum.mythtv.org
Re: Several backends and passwords [ In reply to ]
On 21/05/18 10:02, Klaus Becker wrote:
> I was surprised to see that in Stretch, the frontend cannot connect to the
> database.

Please check out the Debian Stretch release notes. Specifically [1]

[1]:
https://www.debian.org/releases/stable/amd64/release-notes/ch-whats-new.en.html#mariadb-replaces-mysql

I rather suspect that this may also affect the binary format of passwords.

HTH, Jan
_______________________________________________
mythtv-users mailing list
mythtv-users@mythtv.org
http://lists.mythtv.org/mailman/listinfo/mythtv-users
http://wiki.mythtv.org/Mailing_List_etiquette
MythTV Forums: https://forum.mythtv.org
Re: Several backends and passwords [ In reply to ]
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)


Klaus




_______________________________________________
mythtv-users mailing list
mythtv-users@mythtv.org
http://lists.mythtv.org/mailman/listinfo/mythtv-users
http://wiki.mythtv.org/Mailing_List_etiquette
MythTV Forums: https://forum.mythtv.org
Re: Several backends and passwords [ In reply to ]
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)



_______________________________________________
mythtv-users mailing list
mythtv-users@mythtv.org
http://lists.mythtv.org/mailman/listinfo/mythtv-users
http://wiki.mythtv.org/Mailing_List_etiquette
MythTV Forums: https://forum.mythtv.org
Re: Several backends and passwords [ In reply to ]
Le lundi 21 mai 2018, 10:30:00 CEST Jan Ceuleers a ?crit :
> On 21/05/18 10:02, Klaus Becker wrote:
> > I was surprised to see that in Stretch, the frontend cannot connect to the
> > database.
>
> Please check out the Debian Stretch release notes. Specifically [1]
>
> [1]:
> https://www.debian.org/releases/stable/amd64/release-notes/ch-whats-new.en.h
> tml#mariadb-replaces-mysql
>
> I rather suspect that this may also affect the binary format of passwords.
>
> HTH, Jan


Ok, but what can I do with this information ?

My problem is not yet resolved.

Klaus


_______________________________________________
mythtv-users mailing list
mythtv-users@mythtv.org
http://lists.mythtv.org/mailman/listinfo/mythtv-users
http://wiki.mythtv.org/Mailing_List_etiquette
MythTV Forums: https://forum.mythtv.org
Re: Several backends and passwords [ In reply to ]
On 22/05/18 13:06, Klaus Becker wrote:
> Ok, but what can I do with this information ?

I don't know Klaus. I gave you a lead for further investigation.

Because if my hunch is correct it is entirely normal that you cannot go
back to Jessie without restoring a database backup.

_______________________________________________
mythtv-users mailing list
mythtv-users@mythtv.org
http://lists.mythtv.org/mailman/listinfo/mythtv-users
http://wiki.mythtv.org/Mailing_List_etiquette
MythTV Forums: https://forum.mythtv.org
Re: Several backends and passwords [ In reply to ]
Le mardi 22 mai 2018, 19:43:01 CEST Jan Ceuleers a ?crit :
> On 22/05/18 13:06, Klaus Becker wrote:
> > Ok, but what can I do with this information ?
>
> I don't know Klaus. I gave you a lead for further investigation.
>
> Because if my hunch is correct it is entirely normal that you cannot go
> back to Jessie without restoring a database backup.


I use unstable.

So I have to reinstall mythtv and perhaps mysql/Mariadb ?

Stretch is not really important for me, I mainly want to use Mythtv in
unstable.

Klaus


_______________________________________________
mythtv-users mailing list
mythtv-users@mythtv.org
http://lists.mythtv.org/mailman/listinfo/mythtv-users
http://wiki.mythtv.org/Mailing_List_etiquette
MythTV Forums: https://forum.mythtv.org