locked Re: MYSQL Connection Error: Client does not support authentication protocol requested by server; consider upgrading MySQL client


chas cartmel
 

Mike,

On a totally separate issue outside of amateur radio I am also getting this error message (or similar). I will try your solution when I get back to my application.


73 Charlie

G4EST

www.g4est.me.uk

 

 

 

From: Support@HamApps.groups.io [mailto:Support@HamApps.groups.io] On Behalf Of Michael Black via Groups.Io
Sent: 14 February 2020 13:27
To: support@hamapps.groups.io; Support@HamApps.groups.io
Subject: Re: [HamApps] MYSQL Connection Error: Client does not support authentication protocol requested by server; consider upgrading MySQL client

 

You may need the SSL libraries.  Install the Win32 Lite package from here (not the Win64 which is for 64-bit executables).

 

 

de MIke W9MDB

 

Win32/Win64 OpenSSL Installer for Windows - Shining Light Productions

 

 

 

 

 

 

On Friday, February 14, 2020, 02:36:00 AM CST, HamApps Support (VK3AMA) <vk3ama.ham.apps@...> wrote:

 

 

On 14/02/2020 5:34 pm, Jbammi via Groups.Io wrote:

JTAlert 2.15.10
MySQL 8 (8.0.19 64 bit) on Win 10
Log4OM V2 (2.3.0.0)
WSJT-X v2.1.2

In Setting, i choose log4omV2 for logging with MySQL, the UDP setup and control port are fine, because QSOs are getting logged correctly in log4om v2

However i enter the credentials for MySQL (double and triple checked), and on hitting Test Connection I always get the following error


Test MySQL Server Connection : FAIL

ERROR : Client does not support authentication protocol requested by server; consider upgrading MySQL client

At the end of a QSO whilst logging it gives me  the QSO Log Failed dialog with:
LOG4OM V2 MySQL Unable to confirm QSO logged

Obviously because it is unable to connect to MySql.

Happy to help track this down.

73 de k1jbd
bammi


Bammi,

In all honesty, I didn't test the JTAlert Log4OMV2 MySQL code against an SSL enabled MySQL server (I need to set one up).

The problem may be in the MySQL code library being used by JTAlert, the connection string used, or the libmysql.dll client file.

I did upgrade the libmysql.dll file (v6.1.10) as part of the Log4OM2 support in JTAlert but that caused problems for JTAlert uses with out-dated or broken VC runtime libraries so I downgraded to the much older file (v5.1.37) used by JTAlert for many years. It may be simply that the libmysql.dll file doesn't support SSL connections.

I have sent you a direct email with a link to a more recent libmysql.dll file. Try replacing the file installed by JTAlert with the new file and let me know if that works (I am not hopeful however).

de Laurie VK3AMA


This email has been scanned by BullGuard antivirus protection.
For more info visit www.bullguard.com

Join Support@HamApps.groups.io to automatically receive all group messages.