History: Manticore Search

Manticore Search is an Open Source database that was created in 2017 as a continuation of Sphinx Search engine (Started in 2001). It is integrated with Tiki Wiki CMS Groupware and one of the components of WikiSuite. This is especially interesting for the Tiki Trackers database web app builder.

Status:

• Experimental in Tiki 25
• Will be stable in Tiki 26

You can check out benchmarks at: https://db-benchmarks.com/

How to install

It is normally this:

sudo apt-get install wikisuite-manticore

sudo apt-get install wikisuite-manticore

How to verify version

This confirms if it installed properly, but it doesn't mean it's running in the background (see next section)

root~# searchd -v
Manticore 6.0.2 89c7a5139@230210 (columnar 2.0.0 a7c703d@230130) (secondary 2.0.0 a7c703d@230130)
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)

xxxxxxxxxx

root~# searchd -v

Manticore 6.0.2 89c7a5139@230210 (columnar 2.0.0 a7c703d@230130) (secondary 2.0.0 a7c703d@230130)

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)

Start service at server reboot

For Manticore to be available for applications like Tiki Wiki CMS Groupware, you want to enable

sudo systemctl enable manticore

xxxxxxxxxx

sudo systemctl enable manticore

In some newer operating systems it can fail with error "Failed to enable unit: Unit ... is transient or generated.". In this can you can remove the generator and try again. It's unlikely you need the generator ever again after Manticore is installed.
In Debian-based operating systems run:

sudo rm /lib/systemd/system-generators/manticore-generator
sudo systemctl daemon-reload
sudo systemctl enable manticore

xxxxxxxxxx

sudo rm /lib/systemd/system-generators/manticore-generator

sudo systemctl daemon-reload

sudo systemctl enable manticore

For more detail, please see: https://manual.manticoresearch.com/Starting_the_server/Linux#Starting-and-stopping-using-systemd

To check if the Manticore service is set to run at boot

sudo systemctl is-enabled manticore

xxxxxxxxxx

sudo systemctl is-enabled manticore

Then reboot to test

sudo reboot

xxxxxxxxxx

sudo reboot

Indicate to Tiki to use Manticore Search

1. Pick Manticore as Unified search engine at tiki-admin.php?page=search
2. Rebuild index
   • Small sites, via GUI
   • Medium and large sites, via CLI php console.php index:rebuild --log
3. Enjoy!

SQLSTATE42000: Syntax error or access violation: 1064

If you get this error:

SQLSTATE[42000]: Syntax error or access violation: 1064 error adding index 'tiki_pref_en': file not found: '/home/example/tmp/manticore-stopwords-tiki_pref_en'

xxxxxxxxxx

SQLSTATE[42000]: Syntax error or access violation: 1064 error adding index 'tiki_pref_en': file not found: '/home/example/tmp/manticore-stopwords-tiki_pref_en'

The temporary workaround:
Virtualmin Virtual Server -> Services -> PHP-FPM Configuration -> Edit Configuration Manually
Old:

php_admin_value[sys_temp_dir] = /home/example/tmp

xxxxxxxxxx

php_admin_value[sys_temp_dir] = /home/example/tmp

New:

php_admin_value[sys_temp_dir] = /tmp

xxxxxxxxxx

php_admin_value[sys_temp_dir] = /tmp

Configuration file

On Debian 10 and 11, it is located at /etc/manticoresearch/manticore.conf

Advanced morphology

Lemmatization, stemming, word forms, etc.:

• https://manual.manticoresearch.com/Creating_an_index/NLP_and_tokenization/Morphology
• https://manual.manticoresearch.com/Creating_an_index/NLP_and_tokenization/Wordforms#Word-forms

Related links

• https://manticoresearch.com/about/
• https://dev.tiki.org/Manticore-Search
• https://gitlab.com/wikisuite/wikisuite-packages/-/tree/main/wikisuite-manticore/debian
• https://gitlab.com/tikiwiki/tiki/-/merge_requests/1805
• https://manticoresearch.com/blog/manticore-alternative-to-elasticsearch/
• https://roadmap.manticoresearch.com
• https://doc.tiki.org/Unified-Index-Comparison
• https://manticoresearch.com/blog/manticoresearch-buddy-challenges-and-solutions/