[MacPorts] #45136: Sphinx plugin for percona

[MacPorts]

#45136: Sphinx plugin for percona
------------------------------------+--------------------------------
  Reporter:  gulios@…               |      Owner:  macports-tickets@…
      Type:  request                |     Status:  new
  Priority:  Normal                 |  Milestone:
 Component:  ports                  |    Version:  2.3.1
Resolution:                         |   Keywords:
      Port:  percona-sphinx-plugin  |
------------------------------------+--------------------------------

Comment (by gulios@…):

 Hi,

 After a couple of months i have to back to this problem.
 I need Percona server >5.6 not mariaDB because of GTID functionality.

 There is no problem with installing "port install sphinx +percona"

 {{{
 --->  Installing sphinx @2.2.4_0+percona
 --->  Activating sphinx @2.2.4_0+percona
 --->  Cleaning sphinx
 --->  Updating database of binaries
 --->  Scanning binaries for linking errors
 --->  No broken files found.
 }}}

 but still if i want to install plugin to MySql "INSTALL PLUGIN sphinx
 SONAME 'ha_sphinx.so'; "

 {{{
 #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)
 }}}

 I need this plugin enabled for searching data from SQL side in tables like
 this:
 {{{
 CREATE TABLE `sphinx_example_table` (
   `id` bigint(20) unsigned NOT NULL,
   `example_column` varchar(3072) NOT NULL,
   KEY `query` (`query`(1024))
 ) ENGINE=SPHINX DEFAULT CHARSET=utf8;
 }}}


 I tried to copy file ha_sphinx.so from mariadb-10 and got
 {{{
 #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): Symbol not found:
 __ZN7handler11print_errorEim
   Referenced from: /opt/lo)
 }}}

 Can you help me with this?

 Thank you.

-- 
Ticket URL: <https://trac.macports.org/ticket/45136#comment:5>
MacPorts <https://www.macports.org/>
Ports system for OS X