Error in Connecting via SphinxSE

Hello,
I installed MariaDB 11.2.0 and enabled SphinxSE in MariaDB. While connecting via sphinxQL it working fine but not through SphinxSE. It produces an exception “Unable to connect to foreign data source: failed to receive searchd version”.
I did the following:
# Disabled SEstatus
# Checked the 9312 port via telnet and it shows connected successfully
# Searchd working
# Firewall not running

Searchd Status:

Manticore 6.0.5 2a6ea8f78@230801 dev (columnar 2.0.5 f8c5f1f@230802) (secondary 2.0.5 f8c5f1f@230802)
Copyright (c) 2001-2016, Andrew Aksyonoff
Copyright (c) 2008-2016, Sphinx Technologies Inc (http://sphinxsearch.com)
Copyright (c) 2017-2023, Manticore Software LTD (https://manticoresearch.com)

SphinxSE table creation:

CREATE TABLE SPHINX_BY_YEAR (
id bigint(10) unsigned NOT NULL,
weight int(11) NOT NULL,
QUERY longtext NOT NULL,
_sph_count int(11) DEFAULT NULL,
_sph_groupby int(11) DEFAULT NULL,
KEY QUERY (QUERY(1024))
) ENGINE=SPHINX DEFAULT CHARSET=utf8mb4 CONNECTION=‘sphinx://localhost:9312/test’;

Telnet:

[root@dsf89nndfsl9k ~]# telnet localhost 9312
Trying 127.0.0.1…
Connected to localhost.
Escape character is ‘^]’.
^CConnection closed by foreign host.

Searchd config

indexer
{
mem_limit = 1024M
}
searchd
{
listen = localhost:9312
listen = localhost:9306:mysql
listen = localhost:9308:http
mysql_version_string=11.2.0
log = /disk2/manticoresearch/log/searchd.log
query_log = /disk2/manticoresearch/log/query.log
pid_file = /disk2/manticoresearch/log/searchd.pid
query_log_format = sphinxql
seamless_rotate = 1
unlink_old = 1
max_filters = 256
max_filter_values = 1000000
watchdog = 1
threads=10
}

I can only guess that searchd is no longer returning a version number compatible with SphinxSE. Which is quite old now, it wouldn’t know about v6 etc.

Can only suggest running one of the other API clients

to see if the can connect and what version of searchd they report. eg use the Status method in PHP with sphinxapi.php

Thank you for the reply.
I uninstalled the manticore and tried to compile/build from Archive. Also I made changes in sphinxapi.api (To identify the version mismatch) which you mentioned . Now I can’t able to build which shows some error. Below are the full output , while running the “cmake …” command.

cmake …
– WRITEB is not set, bundle will NOT be modified…
– Looking for pthread.h
– Looking for pthread.h - found
– Performing Test CMAKE_HAVE_LIBC_PTHREAD
– Performing Test CMAKE_HAVE_LIBC_PTHREAD - Failed
– Looking for pthread_create in pthreads
– Looking for pthread_create in pthreads - not found
– Looking for pthread_create in pthread
– Looking for pthread_create in pthread - found
– Found Threads: TRUE
– Could NOT find Boost (missing: context) (found suitable version “1.66.0”, minimum required is “1.61.0”)
– Try from previous run /opt/manticoresearch-3.6.0/build/boost-context-build
– Could NOT find Boost (missing: Boost_INCLUDE_DIR context) (found suitable version “1.66.0”, minimum required is “1.61.0”)
– Try pre-built full boost from artifacts /opt/cache/boost-linux-x86_64
– Could NOT find Boost (missing: Boost_INCLUDE_DIR context) (found suitable version “1.66.0”, minimum required is “1.61.0”)
– Try pre-built boost from artifacts /opt/cache/boost-context-linux-x86_64
– Could NOT find Boost (missing: Boost_INCLUDE_DIR context) (found suitable version “1.66.0”, minimum required is “1.61.0”)
CMake Deprecation Warning at CMakeLists.txt:1 (cmake_minimum_required):
** Compatibility with CMake < 2.8.12 will be removed from a future version of**
** CMake.**

** Update the VERSION argument value or use a … suffix to tell**
** CMake that the project does not need compatibility with older versions.**

CMake Warning (dev) at /usr/share/cmake/Modules/ExternalProject.cmake:2218 (message):
** Policy CMP0114 is not set: ExternalProject step targets fully adopt their**
** steps. Run “cmake --help-policy CMP0114” for policy details. Use the**
** cmake_policy command to set the policy and suppress this warning.**

** ExternalProject target ‘boost-context’ would depend on the targets for**
** step(s) ‘download;install’ under policy CMP0114, but this is being left out**
** for compatibility since the policy is not set.**
Call Stack (most recent call first):
** CMakeLists.txt:17 (ExternalProject_Add_StepTargets)**
This warning is for project developers. Use -Wno-dev to suppress it.

– Configuring done
– Generating done
– Build files have been written to: /opt/manticoresearch-3.6.0/build/boost-context-download
– Download boost /opt/manticoresearch-3.6.0/build/boost-context-download
[ 50%] Performing download step (download, verify and extract) for ‘boost-context’
– verifying file…
** file=‘/opt/manticoresearch-3.6.0/build/boost-context-download/boost-context-prefix/src/boost_1_72_0.tar.gz’**
– MD5 hash of
** /opt/manticoresearch-3.6.0/build/boost-context-download/boost-context-prefix/src/boost_1_72_0.tar.gz**
** does not match expected value**
** expected: ‘e2b0b1eac302880461bcbef097171758’**
** actual: ‘d41d8cd98f00b204e9800998ecf8427e’**
– File already exists but hash mismatch. Removing…
– Downloading…
** dst=‘/opt/manticoresearch-3.6.0/build/boost-context-download/boost-context-prefix/src/boost_1_72_0.tar.gz’**
** timeout=‘none’**
** inactivity timeout=‘none’**
– Using src=‘https://dl.bintray.com/boostorg/release/1.72.0/source/boost_1_72_0.tar.gz
CMake Error at boost-context-download/boost-context-prefix/src/boost-context-stamp/download-boost-context.cmake:170 (message):
** Each download failed!**

** error: downloading ‘https://dl.bintray.com/boostorg/release/1.72.0/source/boost_1_72_0.tar.gz’ failed**
** status_code: 22**
** status_string: “HTTP response code said error”**
** log:**
** — LOG BEGIN —**
** Trying 54.159.245.223…**

** TCP_NODELAY set**

** Connected to dl.bintray.com (54.159.245.223) port 443 (#0)**

** ALPN, offering http/1.1**

** successfully set certificate verify locations:**

** CAfile: /etc/pki/tls/certs/ca-bundle.crt**
** CApath: none**

** [5 bytes data]**

** TLSv1.3 (OUT), TLS handshake, Client hello (1):**

** [512 bytes data]**

** [5 bytes data]**

** TLSv1.3 (IN), TLS handshake, Server hello (2):**

** [112 bytes data]**

** [5 bytes data]**

** TLSv1.2 (IN), TLS handshake, Certificate (11):**

** [4394 bytes data]**

** [5 bytes data]**

** TLSv1.2 (IN), TLS handshake, Server key exchange (12):**

** [300 bytes data]**

** [5 bytes data]**

** TLSv1.2 (IN), TLS handshake, Server finished (14):**

** [4 bytes data]**

** [5 bytes data]**

** TLSv1.2 (OUT), TLS handshake, Client key exchange (16):**

** [37 bytes data]**

** [5 bytes data]**

** TLSv1.2 (OUT), TLS change cipher, Change cipher spec (1):**

** [1 bytes data]**

** [5 bytes data]**

** TLSv1.2 (OUT), TLS handshake, Finished (20):**

** [16 bytes data]**

** [5 bytes data]**

** [5 bytes data]**

** TLSv1.2 (IN), TLS handshake, Finished (20):**

** [16 bytes data]**

** SSL connection using TLSv1.2 / ECDHE-RSA-AES256-GCM-SHA384**

** ALPN, server accepted to use http/1.1**

** Server certificate:**

** subject: CN=.bintray.com**
** start date: Nov 14 00:00:00 2022 GMT**
** expire date: Nov 9 23:59:59 2023 GMT**
** subjectAltName: host “dl.bintray.com” matched cert’s "
.bintray.com"**
** issuer: C=US; O=DigiCert, Inc.; CN=GeoTrust Global TLS RSA4096 SHA256 2022 CA1**
** SSL certificate verify ok.**

** [5 bytes data]**

** GET /boostorg/release/1.72.0/source/boost_1_72_0.tar.gz HTTP/1.1**

** Host: dl.bintray.com**

** User-Agent: curl/7.61.1**

** Accept: /**

** [5 bytes data]**

** The requested URL returned error: 404 Not Found**

** Closing connection 0**

** [5 bytes data]**

** TLSv1.2 (OUT), TLS alert, close notify (256):**

** [2 bytes data]**

** — LOG END —**

gmake[3]: *** [CMakeFiles/boost-context-download.dir/build.make:74: boost-context-prefix/src/boost-context-stamp/boost-context-download] Error 1
gmake[2]: *** [CMakeFiles/Makefile2:137: CMakeFiles/boost-context-download.dir/all] Error 2
gmake[1]: *** [CMakeFiles/Makefile2:144: CMakeFiles/boost-context-download.dir/rule] Error 2
gmake: *** [Makefile:150: boost-context-download] Error 2
CMake Error at cmake/GetBoostContext.cmake:79 (message):
** Download step for boost-context failed**
Call Stack (most recent call first):
** cmake/GetBoostContext.cmake:266 (download_boost)**
** CMakeLists.txt:128 (include)**

– Configuring incomplete, errors occurred!
See also “/opt/manticoresearch-3.6.0/build/CMakeFiles/CMakeOutput.log”.
See also “/opt/manticoresearch-3.6.0/build/CMakeFiles/CMakeError.log”.

Hello,
I just changed “listen = localhost:9312” to “listen = localhost:9312:sphinx” in my searchd settings and now SphinxSE connected and working fine. Hope this will help others.