Mailing List Archive

On Thu, Mar 4, 2021 at 7:37 PM Tony Guadagno <tonyg@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

On Thu, Mar 4, 2021 at 7:37 PM Tony Guadagno <tonyg@guadagno.org<mailto:tonyg@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 |
+-------------------+-----------------+-----------------+

On 3/4/21 3:03 PM, Tony Guadagno wrote:
>
> On Thu, Mar 4, 2021 at 7:37 PM Tony Guadagno <tonyg@guadagno.org
> <mailto:tonyg@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

On 3/4/21 3:03 PM, Tony Guadagno wrote:
On Thu, Mar 4, 2021 at 7:37 PM Tony Guadagno <tonyg@guadagno.org<mailto:tonyg@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



Peter, Perfect! That did the trick…thanks !!!! btw, I think restarting apache2 was also required.