Extension talk:SphinxSearch/2018

The talk page now uses liquid threads, all open messages prior to liquid threads have been converted into a talk subpage and can be found here.
It is recommended to use SphinxSearch 0.8.5 and a recent stable release of Sphinx 2.1. Please bear in mind that this extension only handles the communication between MediaWiki and Sphinx and any specific issues related to the search feature (character sets, ability to search with *, search categories, minimum length on search terms etc.) are handled in Sphinx (see sphinx.conf file) and those questions should be redirected to the Sphinx forum.
The development on this extension is done on a voluntary basis and while this forum provides a platform to share experiences and solutions, it is up to its community members to fill in suggestions.

Help

When seeking help and/or support, you might want to consider to mention your system environment (SphinxSearch Extension version, Sphinx version, MW version etc.) otherwise it might be difficult for people to make appropriate recommendations.

For Windows users and related issues see here, for Linux users and related issues see here, and some advice on how to configure a SQLite setup see here.


PHP 4 constructor deprecation warnings

The following discussion is closed. Please do not modify it. Subsequent comments should be made on the appropriate discussion page. No further edits should be made to this discussion.


If you use PHP7 you might get a warning about deprecated class constructors. The simplest thing to do here is to rename the existing constructor to __construct() and create a new stub function with the old constructor name. The stub function points to the new constructor, so it'll work in both PHP 4, 5 and 7. See example below.

// PHP 4 Constructor

     function SphinxClient () {

               self::__construct();

       }

// PHP 7 Constructor

       function __construct () {

// Original constructor code goes here...

} Mg169706 (talk) 15:59, 16 January 2018 (UTC)

The discussion above is closed. Please do not modify it. No further edits should be made to this discussion.

How to use Sphinx and Flow together?

After use the Flow to replace the NS_UserTalk,find that talk-page could not searched by Sphinx。

How to use Sphinx and Flow together? Xk casper (talk) 02:43, 23 April 2018 (UTC)

debian 9 notes

these are notes after spending hours to get sphinx working on debian 9. they may not be complete .

using stretch package I could not get sphinx to stay running.

however using a jessie deb it works fine.

see https://bugs.debian.org/cgi-bin/bugreport.cgi?bug=861262 https://bugs.debian.org/cgi-bin/bugreport.cgi?bug=788284

also after i had to do these.

chown  -R  sphinxsearch /var/log/sphinx

and in /etc/init.d/sphinxsearch



PIDFILE=/var/log/sphinx/searchd.pid


in our case /etc/sphinxsearch/sphinx.conf did not have a PIDFILE specified . could be that years ago it just worked using the one under /var/log/sphinxsearch . RobFantini (talk) 13:54, 23 September 2018 (UTC)

then had to fix systemd :
problem:
Setting up sphinxsearch (2.2.11-release-1~jessie) ...
Do not forget to reindex all indexes by running: indexer --all
Job for sphinxsearch.service failed because a timeout was exceeded.
See "systemctl status sphinxsearch.service" and "journalctl -xe" for details.
invoke-rc.d: initscript sphinxsearch, action "start" failed.
● sphinxsearch.service - SphinxSearch Search Engine
  Loaded: loaded (/lib/systemd/system/sphinxsearch.service; enabled; vendor preset: enabled)
  Active: failed (Result: timeout) since Sat 2018-10-13 08:53:09 EDT; 6ms ago
  Process: 17708 ExecStart=/usr/bin/searchd --config /etc/sphinxsearch/sphinx.conf (code=exited, status=0/SUCCESS)
  Process: 17706 ExecStartPre=/bin/chown sphinxsearch.sphinxsearch /var/run/sphinxsearch (code=exited, status=0/SUCCESS)
  Process: 17704 ExecStartPre=/bin/mkdir -p /var/run/sphinxsearch (code=exited, status=0/SUCCESS)
   Tasks: 8 (limit: 4915)
  CGroup: /system.slice/sphinxsearch.service
          ├─905 /usr/bin/searchd --config /etc/sphinxsearch/sphinx.conf
          └─908 /usr/bin/searchd --config /etc/sphinxsearch/sphinx.conf
Oct 13 08:51:39 wiki searchd[17708]: Copyright (c) 2008-2016, Sphinx Technologies Inc (http://sphinxsearch.com)
Oct 13 08:51:39 wiki searchd[17708]: FATAL: failed to lock pid file '/var/log/sphinx/searchd.pid': Resource temporarily unavai…running?)
Oct 13 08:51:39 wiki searchd[17708]: Sphinx 2.2.11-id64-release (95ae9a6)
Oct 13 08:51:39 wiki searchd[17708]: Copyright (c) 2001-2016, Andrew Aksyonoff
Oct 13 08:51:39 wiki searchd[17708]: Copyright (c) 2008-2016, Sphinx Technologies Inc (http://sphinxsearch.com)
Oct 13 08:51:39 wiki systemd[1]: sphinxsearch.service: PID file /var/run/sphinxsearch/searchd.pid not readable (yet?) after s… directory
Oct 13 08:53:09 wiki systemd[1]: sphinxsearch.service: Start operation timed out. Terminating.
Oct 13 08:53:09 wiki systemd[1]: Failed to start SphinxSearch Search Engine.
Oct 13 08:53:09 wiki systemd[1]: sphinxsearch.service: Unit entered failed state.
Oct 13 08:53:09 wiki systemd[1]: sphinxsearch.service: Failed with result 'timeout'.
Hint: Some lines were ellipsized, use -l to show in full.
dpkg: error processing package sphinxsearch (--configure):
subprocess installed post-installation script returned error exit status 1
Errors were encountered while processing:
sphinxsearch
E: Sub-process /usr/bin/dpkg returned an error code (1)
chmod 777  /var/run/sphinxsearch/   
  1. did not fix.
updatedb
  1. locate searchd.pid
/var/log/sphinx/searchd.pid
    1. So ....
vi /lib/systemd/system/sphinxsearch.service
  1. change this:
PIDFile=/var/log/sphinx/searchd.pid
    1. rebooted then
# systemctl status sphinxsearch
● sphinxsearch.service - SphinxSearch Search Engine
  Loaded: loaded (/lib/systemd/system/sphinxsearch.service; enabled; vendor preset: enabled)
  Active: active (running) since Sat 2018-10-13 09:20:30 EDT; 1min 31s ago
  Process: 828 ExecStart=/usr/bin/searchd --config /etc/sphinxsearch/sphinx.conf (code=exited, status=0/SUCCESS)
  Process: 824 ExecStartPre=/bin/chown sphinxsearch.sphinxsearch /var/run/sphinxsearch (code=exited, status=0/SUCCESS)
  Process: 819 ExecStartPre=/bin/mkdir -p /var/run/sphinxsearch (code=exited, status=0/SUCCESS)
Main PID: 855 (searchd)
   Tasks: 8 (limit: 4915)
  CGroup: /system.slice/sphinxsearch.service
          ├─854 /usr/bin/searchd --config /etc/sphinxsearch/sphinx.conf
          └─855 /usr/bin/searchd --config /etc/sphinxsearch/sphinx.conf
Oct 13 09:20:30 wiki searchd[828]: Copyright (c) 2001-2016, Andrew Aksyonoff
Oct 13 09:20:30 wiki searchd[828]: Copyright (c) 2008-2016, Sphinx Technologies Inc (http://sphinxsearch.com)
Oct 13 09:20:30 wiki searchd[828]: listening on all interfaces, port=9312
Oct 13 09:20:30 wiki searchd[828]: Sphinx 2.2.11-id64-release (95ae9a6)
Oct 13 09:20:30 wiki searchd[828]: Copyright (c) 2001-2016, Andrew Aksyonoff
Oct 13 09:20:30 wiki searchd[828]: Copyright (c) 2008-2016, Sphinx Technologies Inc (http://sphinxsearch.com)
Oct 13 09:20:30 wiki searchd[828]: precaching index 'wiki_main'
Oct 13 09:20:30 wiki searchd[828]: [249B blob data]
Oct 13 09:20:30 wiki systemd[1]: sphinxsearch.service: Supervising process 855 which is not our child. We'll most likely not notice when
Oct 13 09:20:30 wiki systemd[1]: Started SphinxSearch Search Engine.
RobFantini (talk) 13:24, 13 October 2018 (UTC)

key 'sql_query_info' was permanently removed from Sphinx configuration. Refer to documentation for details.

The following discussion is closed. Please do not modify it. Subsequent comments should be made on the appropriate discussion page. No further edits should be made to this discussion.


The version of sphinx have been changed after using “yum update”.

The new version maybe not support "sql_query_info".

WARNING infomation like this:

using config file '/usr/local/sphinx--with-mysql/etc/sphinx.conf'...WARNING: key 'sql_query_info' was permanently removed from Sphinx configuration. Refer to documentation for details.

WARNING: key 'enable_star' was permanently removed from Sphinx configuration. Refer to documentation for details.

WARNING: key 'charset_type' was permanently removed from Sphinx configuration. Refer to documentation for details.

WARNING: key 'max_matches' was permanently removed from Sphinx configuration. Refer to documentation for details.

Anyone can tell me how to fix it ? Xk casper (talk) 07:09, 20 December 2018 (UTC)

These keys have been removed from the sample config file today, so new installations will not have this issue. For any current installation, edit your sphing.conf file and remove all lines that have those four strings. Svemir Brkic (talk) 22:59, 15 September 2019 (UTC)
The discussion above is closed. Please do not modify it. No further edits should be made to this discussion.