anonymous user

Forums   Register   Login   Forgot your login/password?   Search

Cannot install SphinxSE on Mysql 5.1

Common forum | 1 | 2 | 3 | 4 | 5 | ... | 519 | 520 | 521 | 522 | next »» | Create new thread

newty

Name: newty
Posts: 3

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
Posts: 3

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
Posts: 3

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
Posts: 2

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
Posts: 3

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 | ... | 519 | 520 | 521 | 522 | next »» | Create new thread