#45050: Sphinx with Percona -----------------------+-------------------------------- Reporter: gulios@… | Owner: macports-tickets@… Type: defect | Status: new Priority: Normal | Milestone: Component: ports | Version: 2.3.1 Resolution: | Keywords: Port: | -----------------------+-------------------------------- Description changed by mf2k@…: Old description:

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?

New description: 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? -- -- Ticket URL: <https://trac.macports.org/ticket/45050#comment:1> MacPorts <http://www.macports.org/> Ports system for OS X

#45050: Sphinx with Percona -----------------------+-------------------------------- Reporter: gulios@… | Owner: macports-tickets@… Type: defect | Status: new Priority: Normal | Milestone: Component: ports | Version: 2.3.1 Resolution: | Keywords: Port: sphinx | -----------------------+-------------------------------- Comment (by ryandesign@…): The error is "ld: library not found for -lmysqlclient". Indeed, the percona port does not seem to provide libmysqlclient. -- Ticket URL: <https://trac.macports.org/ticket/45050#comment:4> MacPorts <http://www.macports.org/> Ports system for OS X

#45050: Sphinx with Percona -----------------------+-------------------------------- Reporter: gulios@… | Owner: macports-tickets@… Type: defect | Status: new Priority: Normal | Milestone: Component: ports | Version: 2.3.1 Resolution: | Keywords: Port: sphinx | -----------------------+-------------------------------- Comment (by gulios@…): Great, waiting for patch, thx -- Ticket URL: <https://trac.macports.org/ticket/45050#comment:6> MacPorts <http://www.macports.org/> Ports system for OS X

#45050: Sphinx with Percona -----------------------+-------------------------------- Reporter: gulios@… | Owner: macports-tickets@… Type: defect | Status: new Priority: Normal | Milestone: Component: ports | Version: 2.3.1 Resolution: | Keywords: Port: sphinx | -----------------------+-------------------------------- Comment (by pixilla@…): 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. -- Ticket URL: <https://trac.macports.org/ticket/45050#comment:8> MacPorts <http://www.macports.org/> Ports system for OS X

#45050: Sphinx with Percona -----------------------+-------------------------------- Reporter: gulios@… | Owner: macports-tickets@… Type: defect | Status: new Priority: Normal | Milestone: Component: ports | Version: 2.3.1 Resolution: | Keywords: Port: sphinx | -----------------------+-------------------------------- Comment (by gulios@…): ok, sphinx @2.2.4_0+percona (active) so it looks ok, thank you. Can you add plugin for percona too? -- Ticket URL: <https://trac.macports.org/ticket/45050#comment:10> MacPorts <http://www.macports.org/> Ports system for OS X

#45050: Sphinx with Percona -----------------------+-------------------------------- Reporter: gulios@… | Owner: macports-tickets@… Type: defect | Status: new Priority: Normal | Milestone: Component: ports | Version: 2.3.1 Resolution: | Keywords: Port: sphinx | -----------------------+-------------------------------- Comment (by gulios@…): Replying to [comment:11 pixilla@…]:

Replying to [comment:10 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? -- Ticket URL: <https://trac.macports.org/ticket/45050#comment:12> MacPorts <http://www.macports.org/> Ports system for OS X

#45050: Sphinx with Percona -----------------------+-------------------------------- Reporter: gulios@… | Owner: macports-tickets@… Type: defect | Status: closed Priority: Normal | Milestone: Component: ports | Version: 2.3.1 Resolution: fixed | Keywords: Port: sphinx | -----------------------+-------------------------------- Changes (by pixilla@…): * status: new => closed * resolution: => fixed Comment: See r125614 -- Ticket URL: <https://trac.macports.org/ticket/45050#comment:14> MacPorts <http://www.macports.org/> Ports system for OS X