MySQL error: Can't find symbol '_mysql_plugin_interface_version_' in library
- by Josh Smith
The boring, necessary details: I'm on Snow Leopard running MySQL locally.
I'm trying to install the Sphinx engine for MySQL like so:
mysql> install plugin sphinx soname 'sphinx.so';
ERROR 1127 (HY000): Can't find symbol '_mysql_plugin_interface_version_' in library
I've Googled everywhere and can't seem to find an actual solution to this problem. For example this issue on the Sphinx forums seems unresolved. Someone else also raised this issue with similar results.
The first post linked to an O'Reilly article which says:
There is a common problem that might occur at this point:
ERROR 1127 (HY000): Can't find symbol '_mysql_plugin_interface_version_' in library
If you see a message like this, it is likely that you forgot to include the -DMYSQL_DYNAMIC_PLUGIN option when compiling the plugin. Adding this option to the g++ compile line is required to create a dynamically loadable plug-in.
But the article ends on that point; I have no idea what this means or how to resolve the issue.
