[mythtv-users] mythweb not working after .31 upgrade

[Peter Bennett]

On 3/4/21 3:03 PM, Tony Guadagno wrote:
>
> On Thu, Mar 4, 2021 at 7:37 PM Tony Guadagno <tonyg at guadagno.org 
> <mailto:tonyg at guadagno.org>> wrote:
>
>     Hi
>
>     I recently upgraded from .29 to .31fixes and ubuntu from 18 to 20
>     and all is working quite well, with one exception. MythWeb is
>     throwing this:
>
>     |Fatal Error|
>
>     ||
>
>     |!!NoTrans: The server requested authentication method unknown to
>     the client [#2054]|
>
>     I did some googling and found these, but the fixes did not work
>     for me. https://bobcares.com/blog/mysql-the-ser ... he-client/
>     <https://bobcares.com/blog/mysql-the-server-requested-authentication-method-unknown-to-the-client/>
>
>     Can anyone give me a clue on how to fix this?
>
>     thanks in advance!
>
>     Tony
>
> Please explain your setup:
>
> Do you use a combined MythTV Frontend/Backend?
>
> Is the MythTV Backend configured for multiple Frontends?
>
> Please report the output of
>
> mysql --user=mythtv --password --host=localhost --execute="SELECT * 
> FROM settings WHERE value LIKE 'BackendServer%' OR value LIKE 
> 'MasterServer%' ORDER BY value" mythconverg
>
> The password is stored in $HOME/.mythtv/config.xml
>
> Roland
>
> Roland, I have a separate frontend and backend.  I also use 
> leanfrontend but only one myth frontend
>
> mysql --user=mythtv --password --host=localhost --execute="SELECT * 
> FROM settings WHERE value LIKE 'BackendServer%' OR value LIKE 
> 'MasterServer%' ORDER BY value" mythconverg
>
> Enter password:
>
> +-------------------+-----------------+-----------------+
>
> | value             | data            | hostname        |
>
> +-------------------+-----------------+-----------------+
>
> | BackendServerAddr | 192.168.168.13  | homemythbackend |
>
> | BackendServerIP   | 192.168.168.13  | homemythbackend |
>
> | BackendServerIP6  | ::1             | homemythbackend |
>
> | BackendServerPort | 6543            | homemythbackend |
>
> | MasterServerIP    | 192.168.168.13  | NULL            |
>
> | MasterServerName  | HomeMythBackend | NULL            |
>
> | MasterServerPort  | 6543            | NULL            |
>
> +-------------------+-----------------+-----------------+
>
>
> _______________________________________________

Try adding this line

default_authentication_plugin=mysql_native_password

to your /etc/mysql/mysql.conf.d/mysqld.cnf file

and restart MySQL

Peter


-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.mythtv.org/pipermail/mythtv-users/attachments/20210304/2bc39678/attachment.htm>