Take the 2-minute tour ×
Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

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.

share|improve this question

2 Answers 2

Please find the answer from sphinx plugin compiling issue. The solution is to remove --with-plugins=sphinx option when running configure, the option is used to build static library to mysql binary.

share|improve this answer
up vote 0 down vote accepted

I finally had to just recompile MySQL entirely rather than install it as a plugin. This involved a number of gotchas in and of itself, too. But save yourself the headache of trying to recreate the same compile conditions for Sphinx that you used for MySQL and just recompile all at once following the Sphinx documentation to the letter.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.