Sphinx with Percona

[gulios@…]

Hi,

I've installed port percona and percona-server for database and it works fine. Next i tried to install Sphinx plugin ->INSTALL PLUGIN sphinx SONAME 'ha_sphinx.so'; and got error like:

#1126 - Can't open shared library '/opt/local/lib/percona/plugin/ha_sphinx.so' (errno: 2 dlopen(/opt/local/lib/percona/plugin/ha_sphinx.so, 2): image not found) 

so i tried to install port sphinx with no success.

port install sphinx +percona
--->  Computing dependencies for sphinx
--->  Fetching archive for sphinx
--->  Attempting to fetch sphinx-2.1.4_0+percona.darwin_13.x86_64.tbz2 from http://nue.de.packages.macports.org/macports/packages/sphinx
--->  Attempting to fetch sphinx-2.1.4_0+percona.darwin_13.x86_64.tbz2 from http://lil.fr.packages.macports.org/sphinx
--->  Attempting to fetch sphinx-2.1.4_0+percona.darwin_13.x86_64.tbz2 from http://mse.uk.packages.macports.org/sites/packages.macports.org/sphinx
--->  Fetching distfiles for sphinx
--->  Verifying checksums for sphinx
--->  Extracting sphinx
--->  Applying patches to sphinx
--->  Configuring sphinx
--->  Building sphinx
Error: org.macports.build for port sphinx returned: command execution failed
Please see the log file for port sphinx for details:
    /opt/local/var/macports/logs/_opt_local_var_macports_sources_rsync.macports.org_release_tarballs_ports_textproc_sphinx/sphinx/main.log
To report a bug, follow the instructions in the guide:
    http://guide.macports.org/#project.tickets
Error: Processing of port sphinx failed

Can you help me with this?

[gulios@…]

log file

[mf2k (Frank Schima)]

In the future, please use WikiFormatting and fill in the Port field.

[pixilla (Bradley Giesbrecht)]

Cc Me!

[ryandesign (Ryan Carsten Schmidt)]

The error is "ld: library not found for -lmysqlclient". Indeed, the percona port does not seem to provide libmysqlclient.

[pixilla (Bradley Giesbrecht)]

Replying to ryandesign@…:

The error is "ld: library not found for -lmysqlclient". Indeed, the percona port does not seem to provide libmysqlclient.

Percona has renamed libmysqlclient to libperconaclient.

A Sphinx patch is on the way.

[gulios@…]

Great, waiting for patch, thx

[gulios@…]

Ok, i've applied patch and installed: sphinx @2.1.4_0+percona (active)

but still there is no /opt/local/lib/percona/plugin/ha_sphinx.so', so i can't turn this plugin on.

Any suggestions ? Thank you.

[pixilla (Bradley Giesbrecht)]

gulios: The mysql sphinx plugin (located in mysqlse) is not installed as part of the sphinx install process. I believe configure option --with-myql option allows sphinx to store indexes in mysql. It is my understanding the mysqlse plugin allows mysql to use sphinx for full-text searches, is this what you want? If so, a port/subport for percona-sphinx-plugin will need to be created.

[pixilla (Bradley Giesbrecht)]

I committed some updates to the sphinx port in r125614. These changes do not yet include the plugin but should improve the sphinx port by creating data and log dirs and a conf as well as a launchd starupitem.

gulios: Would you be able to test these changes?

[gulios@…]

ok, sphinx @2.2.4_0+percona (active) so it looks ok, thank you. Can you add plugin for percona too?

[pixilla (Bradley Giesbrecht)]

Replying to gulios@…:

ok, sphinx @2.2.4_0+percona (active) so it looks ok, thank you. Can you add plugin for percona too?

I have looked into building the mysql sphinx plugin and the INSTALL file in the source says to copy the mysqlse directory to the mysql source and build mysql after some additional steps to add the sphinx storage engine to the mysql configure script. And this is for mysql 5.0 and 5.1, newer mysqls including percona and mariadb use cmake now.

gulios: would you be able to check with the sphinx devs to see if and how it is possible to build the mysql sphinx plugin for mysql 5.5+ derived mysql databases?

[gulios@…]

Replying to pixilla@…:

Replying to gulios@…:

ok, sphinx @2.2.4_0+percona (active) so it looks ok, thank you. Can you add plugin for percona too?

I have looked into building the mysql sphinx plugin and the INSTALL file in the source says to copy the mysqlse directory to the mysql source and build mysql after some additional steps to add the sphinx storage engine to the mysql configure script. And this is for mysql 5.0 and 5.1, newer mysqls including percona and mariadb use cmake now.

gulios: would you be able to check with the sphinx devs to see if and how it is possible to build the mysql sphinx plugin for mysql 5.5+ derived mysql databases?

i think no but before the moment i found port: percona-sphinxse-plugin but i can't install it(log in file). Maybe here you can find and fix something?

[gulios@…]

port: percona-sphinxse-plugin

[pixilla (Bradley Giesbrecht)]

Replying to gulios@…:

i think no but before the moment i found port: percona-sphinxse-plugin but i can't install it(log in file). Maybe here you can find and fix something?

Unfortunately, the inclusion of the sphinxse subports was my mistake and removed in r125650. I have found no good way to build the sphinx mysql plugin on newer versions of mysql.

I'm going to close this ticket because sphinx now builds with the +percona variant.

If you want to request a percona-sphinx-plugin port please open a new request ticket.

[pixilla (Bradley Giesbrecht)]

See r125614