Member Avatar for tanha

I came again across "" and found the library useful but I could not figured out how to install and use them on WAMP Server version 2.0 with MySQL version 5.1.36 on Windows 7.

I did followings steps but did not get the work done:

1. Created a directory named "plugin" in the path "C:\wamp\bin\mysql\mysql5.1.36" and copied the "lib_mysqludf_str.dll" file in the directory

2. Added the line 'plugin_dir=c:/wamp/bin/mysql/mysql5.1.36/plugin' within my.ini configuration file in the [mysqld] and [wampmysqld] section

3. Restarted the server and connected as root to mysql server using mysql database

4. Executed CREATE FUNCTION lib_mysqludf_str_info returns string SONAME'lib_mysqludf_str.dll';

Error: Can't Open Shared Library 'lib_mysqludf_str.dll'

Your support and feedback will be appreciated in advanced.

Thank you,

  • 1 Contributor
  • 1 Reply
  • 908 Views
  • 7 Hours Discussion Span
  • Latest Post Latest Post by tanha

Dani AI

Generated

As discovered, the lib_mysqludf-style libraries are native Windows DLLs, so the usual causes for a load failure are architecture or dependency mismatches rather than SQL syntax. The MySQL server expects a shared library built for the same platform and placed where it can be loaded, and a missing Visual C++ runtime will stop Windows from loading the DLL. (docs.huihoo.com)

Practical checklist (fast wins first):

  • Confirm the server’s plugin path and what the server was built for (for example with SHOW VARIABLES LIKE 'plugin_dir'; and SHOW VARIABLES LIKE 'version_compile_machine';), then verify the UDF DLL matches that bitness.
  • Inspect the UDF with a dependency tool (Dependency Walker or the modern Dependencies tool) to see which MSVC runtime or other DLLs are missing.
  • Install the official Visual C++ Redistributable that matches the UDF’s compiler (use the Microsoft installer rather than dropping a single DLL into System folders).
  • If the UDF depends on other third-party DLLs, put those beside the UDF or into the server BIN/plugin location (some installers require that), and ensure the Windows account running mysqld can read the files.
  • Check the MySQL error log and Windows Event Viewer for loader messages — they often include the missing-module name or errno that points to the cause. (github.com)

If a prebuilt binary still fails, rebuild the UDF with the same Visual Studio toolchain and target (Win32 vs x64) as your MySQL server. Treat third‑party UDF DLLs as native code — use trusted builds or compile locally — because they run inside the server process. For older WAMP/MySQL stacks, consider upgrading to a maintained MySQL/WAMP package to avoid toolchain and runtime mismatch headaches. (linuxtopia.org)

Member Avatar for tanha

I found the problem.

I had to install "msvcr100.dll"

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.