Unable to scan my MySQL 8.4.6 Database

[shatshen]

Hi,

I'm unable to do any scanning for my MySQL 8.4.6 server database that is my VM from my HammerDB that is located in my Windows desktop

Help please... I've tried to put in the libmysql.dll inside my HammerDB folder but it couldnt do any library check for mysql either.

[sm-shaw]

Issue moved to discussion Q&A

[sm-shaw]

Hi, the section in the documentation is here https://www.hammerdb.com/docs/ch01s10.html
On Windows you need the libmysql.dll file from MySQL 8.4.X for Windows and the directory where this is installed needs to be set in the PATH environment variable. Then librarycheck will verify it is found.
Putting libmysql.dll in the HammerDB home directory will not work as the libraries are extracted into the TEMP location. The important steps are using the right library (it was built with 8.4.4) and adding this location to the PATH environment variable.

[shatshen]

I tried to reinstall with the MSI file and restart my PC afterwards and still get the same error

[sm-shaw]

I will try and reproduce on my side.

[sm-shaw]

there is the same issue here: #821

[sm-shaw]

OK - please try these commands to check:
It looks like the bin directory also now needs to go in the path as it is needs to find libssl-3-x64 and libcrypto-3-x64

set PATH=C:\Program Files\MySQL\MySQL Server 8.4\bin;C:\Program Files\MySQL\MySQL Server 8.4\lib;%PATH%
where libssl-3-x64.dll
where libcrypto-3-x64.dll
where libmysql.dll

Then run hammerdbcli and librarycheck to check.
I'm not entirely sure what has changed here - nothing changed on the HammerDB side and Microsoft have been pushing security updates but there is no definitive connection. Nevertheless it looks like it is failing because it can't find libssl-3-x64.dll and libcrypto-3-x64.dll as these are dependencies and are in the MySQL bin directory. Please try it.

[sm-shaw]

Also once it works you will see a directory in your TEMP location starting TCL... where the actual libraries are extracted to:

[sm-shaw]

I've checked adding bin to the environment variables as well as lib should fix the issue by finding the ssl and crypto libraries:

[shatshen]

You are right, it works now. Thank you so much

[sm-shaw]

Great so it used to be only libmysql.dll was needed, but now that has a dependency on libssl-3-x64.dll and libcrypto-3-x64.dll that are in the bin directory. This is probably a change on the MySQL side.