anonymous user
Forums Register Login Forgot your login/password? Search
Cannot install SphinxSE on Mysql 5.1
Common forum | 1 | 2 | 3 | 4 | 5 | ... | 449 | 450 | 451 | 452 | next »» | Create new thread
|
newty
Name: newty |
2010-01-02 21:32:59
| reply! Hi, Hope you can bare with a little newbie who is lost in patchville! I would love to install this software, but for 2 days I finally managed to compile the .so. Now I try to use it and it comes up with the following error. mysql> INSTALL PLUGIN sphinx SONAME 'sphinx.so'; ERROR 1127 (HY000): Can't find symbol '_mysql_plugin_interface_version_' in library I am using: Mysql 5.1.37 and sphinx 0.9.9 and trying to install sphinx as a mysql plugin I have also been using this tutorial which doesnt seem to work when I follow it step by step. - http://www.v-nessa.net/2007/07/21/installing-sphinx-for-mysql-51 there are also 3 other similar tutorials I have used to no avail. Im also confused about some things: 1) Should I configure/make, install the actual sphinx software that comes in the tar , as well as configure/make mysql? 2) Is there a specific mysql version to use to compile the sphinx.so plugin? I see 5.1.12 is suggested here and there is a patch for it? Is there a patch for mysql 5.1.37? 3) Do I actually need to use the 5.0.37.diff file to patch mysql? it doesnt seem the same version as 5.1.37? Also how should I run the patch on the diff file? some people say run it in mysql source dir, others say run in the sphinx dir... confused... Any help will go into my "save the hair" fund. Cheers in advance for any replies. |
|
newty
Name: newty |
to: newty, 2010-01-02 21:51:10
| reply! Just wanted to update my post with a few errors ive been getting to give some context Here is what happens at the end when I make mysql-5.1.37 make[2]: Leaving directory `/Downloads/mysql-5.1.37/server-tools/instance-manager' make[1]: Leaving directory `/Downloads/mysql-5.1.37/server-tools' Making all in win make[1]: Entering directory `/Downloads/mysql-5.1.37/win' make[1]: Nothing to be done for `all'. make[1]: Leaving directory `/Downloads/mysql-5.1.37/win' Even with this error, I have been able to create the sphinx.so shared object. I am wondering why it is also sphinx.so, when all the tutorials I have seen are for ha_sphinx.so, am I doing something wrong here? Also, sometimes the sphinx.so file isnt created, i get sphinx.la etc. This is usually when I havent used the patch file e.g. patch < p1 sphinx.5.0.37.diff Im really confused and would really appreciate someone to point me in the right direction :) |
|
newty
Name: newty |
to: newty, 2010-01-02 21:55:23
| reply! PS The only info I can find about my error is here: 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. http://209.85.229.132/search?q...sion_&cd=9&hl=en&ct=clnk&gl=uk It seems that this is not the error I am witnessing though, because in my make.log-DMYSQL_DYNAMIC_PLUGIN option is enabled. |
|
atyu30
Name: atyu30 |
to: newty, 2010-02-27 16:31:42
| reply! > PS > > The only info I can find about my error is here: > > 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. > > http://209.85.229.132/search?q...sion_&cd=9&hl=en&ct=clnk&gl=uk > > It seems that this is not the error I am witnessing though, because in my > make.log-DMYSQL_DYNAMIC_PLUGIN option is enabled. OS: Red Hat Enterprise Linux Server release 5.4 (Tikanga) x64 sphinx: sphinx-0.9.9.tar.gz Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 1 Server version: 5.1.30-community-log MySQL Community Server (GPL) Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql> INSTALL PLUGIN sphinx SONAME 'ha_sphinx_la-ha_sphinx.o'; ERROR 1126 (HY000): Can't open shared library '/var/lib/mysql/plugins/ha_sphinx_la-ha_sphinx.o' (errno: 2 only ET_DYN and ET_EXEC can be loaded) mysql> INSTALL PLUGIN sphinx SONAME 'sphinx.so.0.0.0'; ERROR 1127 (HY000): Can't find symbol '_mysql_plugin_interface_version_' in library mysql> |
|
fagzal
Name: Fagyal Csongor |
to: atyu30, 2010-12-09 16:40:50
| reply! I'm having the same problem on Fedora 12, 2.6.32.16-141.fc12.i686.PAE. I have downloaded Mysql 5.1.47, latest trunk, and according to the docs, copied mysqlse to the mysql source tree, then run ./configure --with-plugins=sphinx In .../storage/sphinx/.libs I got: sphinx.a sphinx.la sphinx.lai sphinx.so sphinx.so.0 sphinx.so.0.0.0 sphinx_la-snippets_udf.o I copied them to /var/lib/mysql/plugins, configures my.cnf, restarted the mysql server, then issued: mysql> INSTALL PLUGIN sphinx SONAME 'sphinx.so'; And got: ERROR 1127 (HY000): Can't find symbol '_mysql_plugin_interface_version_' in library I see the same error at various forums, but without answers. A few pages mention setting -DMYSQL_DYNAMIC_PLUGIN, e.g. here: http://dev.mysql.com/tech-resources/articles/mysql_i_s_plugins_part1-2.html I tried to set that using export CCFLAGS=-DMYSQL_DYNAMIC_PLUGIN (and during compilation it looks like the compiler is using it), and recompile, but the same happens... See these threads, too: http://www.sphinxsearch.com/forum/view.html?id=5467 http://developerquestion.com/m...interface_version_-in-library/ |
Common forum | 1 | 2 | 3 | 4 | 5 | ... | 449 | 450 | 451 | 452 | next »» | Create new thread