For Me.Rao maria_Connect

[Maurizio]

Hello Mr. Rao,
I hope this message finds you well.
I am currently encountering an issue with maria_Connect when attempting to establish a connection to a MySQL 8.0.39 server, which has the default caching_sha2_password authentication plugin enabled. Given that the mysql_native_password plugin will be deprecated starting with MySQL 8.4, I have updated the MySQL connector to version 8.0. While the ADO connection is functioning properly, maria_Connect is not connecting with the FWH DLLs.
Could you please assist me in resolving this issue?
Thank you for your time and support.
Best regards,
Maurizio
www.nipeservice.com

[nageswaragunupudi]

We will check this and get back soon.

[nageswaragunupudi]

I have updated the MySQL connector to version 8.0.

One of our FWH demo servers is of Version 8.0.29.
This is connecting without any problem.

Please copy this program to fwh\samples folder and build and run with buildh.bat or buildx.bat

Code: Select all  Expand view  RUN

#include "fivewin.ch"

function Main()

   local oCn

   oCn   := MsgRun( "Connecting", "MYSQL", ;
            { || maria_Connect( "209.250.245.152,fwh,fwhuser,FiveTech@2022", .t. ) } )

   if oCn == nil
      ? "Not connected"
   else
      ? oCn:cServerInfo  // --> "8.0.29-0"
      ? oCn:authentication_policy
      oCn:Close()
   endif

return nil

So, there should be no problem in connecting to a Server with version 8.0 with present DLLs in fwh\samples folder.
This test is with 8.0.29 but not with 8.0.39.

We will be working on "caching_sha2_password authentication" and get back to you soon.

[Maurizio]

Thanks Rao, I really appreciate your work.
I await your verification.

Maurizio

[Maurizio]

Hello Mr. Rao,

I would like to clarify that the issue arises specifically when the “caching_sha2_password” authentication plugin is activated on the server.
If I create a "weaker" user using the “mysql_native_password” authentication plugin, the connection works without issues.
However, the core problem remains: “maria_Connect” is currently not compatible with the “caching_sha2_password” plugin, which is MySQL's default starting from version 8.0.

Thank you again for your support.

Best regards Maurizio

[Otto]

Dear Maurizio,
Have you linked OpenSSL to handle the SHA-2 encryption?
Best regards,
Otto

[Maurizio]

Dear Otto,
Thanks for the advice.
I think the problem is in libmariadb.dll that needs to be updated with new versions of Mysql.
Is that so Rao?

Maurizio