Conquest with MySQL Server 8.4 - Authentication Protocol

Hi,

can you try using newer interface DLLs instead of libmysql64.dll. You need quiite a few I think, taken from you mysql/bin folder. Some trial and error is needed.

good luck,

Marcel

Great!

Marce;

Hi

Before installing the conquest,

1) I rename the libmysql64.dll with libmysql.dll by replace the file from Mysql 8.0 lib folder. But got the error

2) Let the libmysql64.dll there and copy the libmysql.dll file but again got the error.

3) Let the libmysql64.dll there and copy the libmysql.dll file and also replace the same lib file in install32 and install 64 folders but again got the error.

Server log

------------------ Start (ODBC) data source update or creation --------------------
waiting ..
waiting ..
waiting ..
waiting ..
waiting ..
waiting ..
waiting ..
waiting ..
[CONQUESTSRV1] ***Cannot connect to MySQL on port 3306
[CONQUESTSRV1] ***MySQL Error message: Client does not support authentication protocol requested by server; consider upgrading MySQL client
[CONQUESTSRV1] ----------------------------------
------------------- End data source update or creation --------------------

Can somebody guide me in this regard.

Steve

Hi,

I just installed mariadb (MariaDB 10.4.32-MariaDB) as part of XAMPP and for me it works fne with the libmysql64.dll that is distributed with the current conquest. User root, no password. Why do you need to replace the interface DLL?

In any case, if you replace the DLL it must be called or renamed to libmysql64.dll for a 64 bits version of Conquest.

Marcel

Thanks for prompt response. I installed Mysql database only but no via Xampp. After extracting the pacs setup there is no dll file so I just run the exe file choose myself database driver. Enter pacs ae and port save and close the application. I copy paste the dll and lib file from myself 8.0.4 library folder to pacs root directory and then run the application and try to create the database and also delete the dll and paste from myself database and rename it but still got the same error.

Can you guide the setups that I am performing wrong

I expected the DLL file to be copied when installing conquest. But apparently its not. The file lives in folder install64, just copy it one level up to the folder with dgate64.exe

Marcel

I copied both dll and lib files during the installation process as I me turned above in install 32 as well as Install64 and root directory where conquest.exe sits but still same error

This is only file that needs to added besides dgate64.exe to use mysql is shown here. Folder Install32 is only for 32 bits installation and should not be used.

Ah,

I now see that file file works, but mysql does not accept it "MySQL Error message: Client does not support authentication protocol requested by server; consider upgrading MySQL client". Let me browse around.

Marcel

Please correct me if i am wrong, only at this location file need to be placed??

And after running the setup, choosing driver and saving the basic AE and port details , I replace file here and then move to database tab or just close the setup replace file and continue

Yes, you do need to copy libmysql.dll from your mysql folder as libmysql64.dll in your conquest folder. I am not aware it needs further files, but it may.

Quote from marcelvanherk

Yes, you do need to copy libmysql.dll from your mysql folder as libmysql64.dll in your conquest folder. I am not aware it needs further files, but it may.

One last clarification, conquest folder only or in install64 folder only or in both. As as per your last comments only in Install64.

Then what about libmysql64.dll that was generated as a result of setup. Will that automatically be updated from install64 folder 🤔

I just downloaded mysql 8.044. I will try it out myself.

Marcel

Thanks Marcel. Appreciate iate your efforts and waiting for your response

What did you use?

Yes first option....

If you chose the second option, then installation is fine.

Ok,

I chose the second option: Then the old DLL (from 2013) works fine.

If I remove it and copy C:\Program Files\MySQL\MySQL Router 8.0\lib\libmysql.dll to my conquest folder as is - this also works fine. Other users reported that with the official dll it can use the new login method. Do you know how I can change the login method easily?

Marcel

Found it - changing now.