I tried loading the library libmysql.dll in various folders but i get the same error. Can anyone please help? Looks like the installation files wants the dll in a specific folder but dont know where it is.
When using MySQL 5.x as an Auditing Database for a SAP BusinessObjects Business Intelligence 4.1, following warning is seen on the Auditing page in Central Management Console (CMC) - "Warning: "No connection to Auditing Data Store from CMS xxx_nn.CentralManagementServer".The Event Viewer also shows following error:
"CMS startup: component auditdatabasesubsystem could not be loaded. Reason: Database access error. Reason Loading shared object failed. First tried to load library libmysql and failed because of error: [The specified module could not be found.]. Second tried to load library \SAP BusinessObjects Enterprise XI 4.0\win64_x64\libmysql.dll and failed because of error: [The specified module could not be found.]."
For all of the databases that HammerDB supports it is necessary to have a third-party client library installed that HammerDB can use to connect and interact with the database. This client library will also typically be installed with database server software. HammerDB does not statically link the 3rd party libraries to minimise executable size and provide flexibility in the third-party libraries used. For example if a bug is detected in a particular library then this can be upgraded without requiring the HammerDB libraries to be rebuilt. However as the client libraries are dynamically linked it is essential that the correct client libraries are already installed and environment variables set to ensure that HammerDB can find the correct libraries. Note that it is only necessary to load the libraries for the database that your are testing.
In the examples it can be seen that the libraries for all databases were found and loaded. The following table illustrates the first level library that HammerDB requires however there may be additional dependencies. Refer to the Test Matrix to determine which database versions HammerDB was built against. On Windows the Dependencies Utility can be used to determine the dependencies and on Linux the command ldd.
Child streams are not generated when the MySQL policy is triggered from master server. Running the nbmysql command directly from client machine is successful.
bphdb logs would loop and an * would be logged in the logs. It is waiting for the password to be entered.
bphdb could report "System cannot find the path Specified" or report issues with the MySQL library file by reporting "Failed to load the MySQL library: "...\libmysql.dll" : The specified module could not be found"
No evident errors are reported, bphdb standard out logfile shows that the agent is prompting for the Database password to be input.
Running the same nbpgsql command directly from a command prompt would successfully trigger the backup.
.out file created under bphdb log folder could report "System cannot find the path Specified" or report issues with the MySQL library file by reporting "Failed to load the MySQL library: "...\libmysql.dll" : The specified module could not be found"
Also, if you want to use the MySQL Client Library with mysqli, you need to make sure PHP can access the client library file. The MySQL Client Library is included as a file named libmysql.dll in the Windows PHP distribution. This file needs to be available in the Windows system's PATH environment variable, so that it can be successfully loaded. See the FAQ titled "How do I add my PHP directory to the PATH on Windows" for information on how to do this. Copying libmysql.dll to the Windows system directory (typically c:\Windows\system) also works, as the system directory is by default in the system's PATH. However, this practice is strongly discouraged.
If when starting the web server an error similar to the following occurs: "Unable to load dynamic library './php_mysqli.dll'", this is because php_mysqli.dll and/or libmysql.dll cannot be found by the system.
f5b9423551