[mythtv-users] Can not connect to database after upgrading to Debian Bookworm

[Bill Meek]

On Saturday 28 October 2023 10:11:06 PM (-05:00), Stephen Worthington 
wrote:


...


 > If MariaDB is listening properly, my guess would be that the problem

 > is that MariaDB has been upgraded and some new option is causing

 > problems. The sort of thing that comes to mind is the method used to

 > encrypt the login data. If it is now set to a method that MythTV does

 > not support, that could cause this problem. To see the method being

 > used, run this:

 >



FYI.


I've tried using caching_sha2_password on my MySQL server (so far):


SELECT Host,User,plugin FROM user WHERE User='mythtv';


I didn't print the authentication_string because it messes up the output, 
but
this is working on my production backend:


+-----------+--------+-----------------------+
| Host      | User   | plugin                |
+-----------+--------+-----------------------+
| %         | mythtv | caching_sha2_password |
| localhost | mythtv | caching_sha2_password |
+-----------+--------+-----------------------+


The "Note" right at the beginning here:


   
https://dev.mysql.com/doc/refman/8.0/en/native-pluggable-authentication.html



says:


    As of MySQL 8.0.34, the mysql_native_password authentication plugin is 
deprecated and subject to removal in a future version of MySQL.


I haven't tried MariaDB yes.


-- 
Bill
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.mythtv.org/pipermail/mythtv-users/attachments/20231029/51f8d4c3/attachment.htm>