Как и где подключить и настроить файл wordforms.txt поиска sphinx?

Question

[monyavitevna]

Добрый днь. Помогите пожалуйста разобраться и подскажите, как и где подключить и настроить файл wordforms.txt поиска sphinx ?

Answer 1

[Пума Тайланд]

в разделе индекса, это же есть даже в дефолтном конфиге

Comments

[monyavitevna]

Нет этого в дефолтном конфиге.

[monyavitevna]

в индексе подключен:

index default
{
	# Main settings
	type			= rt
	path			= /var/lib/sphinx/default/index
	wordforms 		= /var/lib/sphinx/data/wordforms.txt
.....
}

Сам файл находится в папке /var/lib/sphinx/data/wordforms.txt
Содержание файла:
найк > nike
тшлу > nike

Не работают запросы указанные в файле. Нужно ли делать рестарт поиска? Если да, то как?

[Пума Тайланд]

monyavitevna: во первых путь до файла не верный да надо сервис название сервиса рестарт

[monyavitevna]

Почему путь неверный? как верно?

[Пума Тайланд]

monyavitevna: кажется вы поправили путь в комментарии, значит просто перезагружайте

[monyavitevna]

При перезапуске, вот что пишет:
# service searchd restart
Redirecting to /bin/systemctl restart searchd.service

И все.

Что это значит.

[Пума Тайланд]

monyavitevna: значит у вас systemd стоит

[monyavitevna]

Как тогда будет выглядеть перезапуск поиска?

[Пума Тайланд]

monyavitevna: ну если не знаете то просто ребутните сервер

[monyavitevna]

Сделала рестарт поиска. Но на сайте так и не ищет запросы с файла.

[Пума Тайланд]

monyavitevna: ну посмотрите логи и ищет ли основной запрос.

[monyavitevna]

если б я еще там что-то понимала )))

[Mon Apr 10 10:00:37.922 2017] [937] rt: index default: ramchunk saved ok (mode=periodic, last TID=132852, current TID=132854, ram=4.621 Mb, time delta=232948 sec, took=0.043 sec)
[Mon Apr 10 11:22:01.127 2017] [937] rt: index default: ramchunk saved ok (mode=periodic, last TID=132854, current TID=133204, ram=0.538 Mb, time delta=4883 sec, took=0.007 sec)
[Mon Apr 10 12:22:02.216 2017] [937] rt: index default: ramchunk saved ok (mode=periodic, last TID=133204, current TID=147691, ram=4.513 Mb, time delta=3601 sec, took=0.028 sec)
[Mon Apr 10 13:22:03.082 2017] [937] rt: index default: ramchunk saved ok (mode=periodic, last TID=147691, current TID=151117, ram=5.725 Mb, time delta=3600 sec, took=0.036 sec)
[Mon Apr 10 14:22:04.052 2017] [937] rt: index default: ramchunk saved ok (mode=periodic, last TID=151117, current TID=151497, ram=5.740 Mb, time delta=3600 sec, took=0.030 sec)
[Mon Apr 10 15:22:05.141 2017] [937] rt: index default: ramchunk saved ok (mode=periodic, last TID=151497, current TID=151501, ram=5.785 Mb, time delta=3601 sec, took=0.032 sec)
[Mon Apr 10 16:22:06.140 2017] [937] rt: index default: ramchunk saved ok (mode=periodic, last TID=151501, current TID=166314, ram=4.508 Mb, time delta=3600 sec, took=0.023 sec)
[Tue Apr 11 10:12:35.197 2017] [937] rt: index default: ramchunk saved ok (mode=periodic, last TID=166314, current TID=166316, ram=4.510 Mb, time delta=64229 sec, took=0.051 sec)
[Tue Apr 11 11:12:36.418 2017] [937] rt: index default: ramchunk saved ok (mode=periodic, last TID=166316, current TID=181145, ram=4.510 Mb, time delta=3601 sec, took=0.017 sec)
[Tue Apr 11 11:36:47.807 2017] [871] watchdog: main process 872 killed cleanly with SIGKILL, shutting down
[Tue Apr 11 11:36:47.840 2017] [11999] watchdog: main process 12000 forked ok
[Tue Apr 11 11:36:47.841 2017] [12000] listening on all interfaces, port=9312
[Tue Apr 11 11:36:47.841 2017] [12000] listening on all interfaces, port=9306
[Tue Apr 11 11:36:47.841 2017] [12000] WARNING: WARNING: index 'default': prefix_fields and infix_fields has no effect with dict=keywords, ignoring

[Tue Apr 11 11:36:47.844 2017] [12000] binlog: replaying log /var/lib/sphinx/binlog.001
[Tue Apr 11 11:36:47.844 2017] [12000] binlog: replay stats: 0 rows in 0 commits; 0 updates, 0 reconfigure; 0 indexes
[Tue Apr 11 11:36:47.844 2017] [12000] binlog: finished replaying /var/lib/sphinx/binlog.001; 0.0 MB in 0.000 sec
[Tue Apr 11 11:36:47.844 2017] [12000] binlog: finished replaying total 1 in 0.000 sec
[Tue Apr 11 11:36:47.844 2017] [12000] accepting connections
[Tue Apr 11 11:43:07.163 2017] [11999] watchdog: main process 12000 killed cleanly with SIGKILL, shutting down
[Tue Apr 11 11:43:07.198 2017] [12141] watchdog: main process 12142 forked ok
[Tue Apr 11 11:43:07.198 2017] [12142] listening on all interfaces, port=9312
[Tue Apr 11 11:43:07.198 2017] [12142] listening on all interfaces, port=9306
[Tue Apr 11 11:43:07.198 2017] [12142] WARNING: WARNING: index 'default': prefix_fields and infix_fields has no effect with dict=keywords, ignoring

[Tue Apr 11 11:43:07.201 2017] [12142] binlog: replaying log /var/lib/sphinx/binlog.001
[Tue Apr 11 11:43:07.201 2017] [12142] binlog: replay stats: 0 rows in 0 commits; 0 updates, 0 reconfigure; 0 indexes
[Tue Apr 11 11:43:07.201 2017] [12142] binlog: finished replaying /var/lib/sphinx/binlog.001; 0.0 MB in 0.000 sec
[Tue Apr 11 11:43:07.201 2017] [12142] binlog: replaying log /var/lib/sphinx/binlog.002
[Tue Apr 11 11:43:07.201 2017] [12142] binlog: replay stats: 0 rows in 0 commits; 0 updates, 0 reconfigure; 0 indexes
[Tue Apr 11 11:43:07.201 2017] [12142] binlog: finished replaying /var/lib/sphinx/binlog.002; 0.0 MB in 0.000 sec
[Tue Apr 11 11:43:07.201 2017] [12142] binlog: finished replaying total 2 in 0.000 sec
[Tue Apr 11 11:43:07.211 2017] [12142] accepting connections
[Tue Apr 11 12:00:05.236 2017] [12141] watchdog: main process 12142 killed cleanly with SIGKILL, shutting down
[Tue Apr 11 12:00:05.270 2017] [12451] watchdog: main process 12452 forked ok
[Tue Apr 11 12:00:05.271 2017] [12452] listening on all interfaces, port=9312
[Tue Apr 11 12:00:05.271 2017] [12452] listening on all interfaces, port=9306
[Tue Apr 11 12:00:05.271 2017] [12452] WARNING: WARNING: index 'default': prefix_fields and infix_fields has no effect with dict=keywords, ignoring

[Tue Apr 11 12:00:05.271 2017] [12452] binlog: replaying log /var/lib/sphinx/binlog.001
[Tue Apr 11 12:00:05.559 2017] [12452] binlog: index default: recovered from tid 181145 to tid 195960
[Tue Apr 11 12:00:05.559 2017] [12452] binlog: replay stats: 14815 rows in 14815 commits; 0 updates, 0 reconfigure; 1 indexes
[Tue Apr 11 12:00:05.559 2017] [12452] binlog: finished replaying /var/lib/sphinx/binlog.001; 7.3 MB in 0.287 sec
[Tue Apr 11 12:00:05.559 2017] [12452] binlog: finished replaying total 1 in 0.287 sec
[Tue Apr 11 12:00:05.559 2017] [12452] accepting connections
[Tue Apr 11 12:00:22.740 2017] [12451] watchdog: main process 12452 killed cleanly with SIGKILL, shutting down
[Tue Apr 11 12:00:22.773 2017] [12474] watchdog: main process 12475 forked ok
[Tue Apr 11 12:00:22.774 2017] [12475] listening on all interfaces, port=9312
[Tue Apr 11 12:00:22.774 2017] [12475] listening on all interfaces, port=9306
[Tue Apr 11 12:00:22.774 2017] [12475] WARNING: WARNING: index 'default': prefix_fields and infix_fields has no effect with dict=keywords, ignoring

[Tue Apr 11 12:00:22.775 2017] [12475] binlog: replaying log /var/lib/sphinx/binlog.001
[Tue Apr 11 12:00:23.058 2017] [12475] binlog: index default: recovered from tid 181145 to tid 195960
[Tue Apr 11 12:00:23.058 2017] [12475] binlog: replay stats: 14815 rows in 14815 commits; 0 updates, 0 reconfigure; 1 indexes
[Tue Apr 11 12:00:23.058 2017] [12475] binlog: finished replaying /var/lib/sphinx/binlog.001; 7.3 MB in 0.283 sec
[Tue Apr 11 12:00:23.058 2017] [12475] binlog: replaying log /var/lib/sphinx/binlog.002
[Tue Apr 11 12:00:23.058 2017] [12475] binlog: replay stats: 0 rows in 0 commits; 0 updates, 0 reconfigure; 0 indexes
[Tue Apr 11 12:00:23.058 2017] [12475] binlog: finished replaying /var/lib/sphinx/binlog.002; 0.0 MB in 0.000 sec
[Tue Apr 11 12:00:23.058 2017] [12475] binlog: finished replaying total 2 in 0.283 sec
[Tue Apr 11 12:00:23.059 2017] [12475] accepting connections
[Tue Apr 11 12:04:19.542 2017] [12474] watchdog: main process 12475 killed cleanly with SIGKILL, shutting down
[Tue Apr 11 12:04:19.576 2017] [12569] watchdog: main process 12570 forked ok
[Tue Apr 11 12:04:19.577 2017] [12570] listening on all interfaces, port=9312
[Tue Apr 11 12:04:19.577 2017] [12570] listening on all interfaces, port=9306
[Tue Apr 11 12:04:19.577 2017] [12570] WARNING: WARNING: index 'default': prefix_fields and infix_fields has no effect with dict=keywords, ignoring

[Tue Apr 11 12:04:19.578 2017] [12570] binlog: replaying log /var/lib/sphinx/binlog.001
[Tue Apr 11 12:04:19.862 2017] [12570] binlog: index default: recovered from tid 181145 to tid 195960
[Tue Apr 11 12:04:19.862 2017] [12570] binlog: replay stats: 14815 rows in 14815 commits; 0 updates, 0 reconfigure; 1 indexes
[Tue Apr 11 12:04:19.862 2017] [12570] binlog: finished replaying /var/lib/sphinx/binlog.001; 7.3 MB in 0.283 sec
[Tue Apr 11 12:04:19.862 2017] [12570] binlog: replaying log /var/lib/sphinx/binlog.002
[Tue Apr 11 12:04:19.862 2017] [12570] binlog: replay stats: 0 rows in 0 commits; 0 updates, 0 reconfigure; 0 indexes
[Tue Apr 11 12:04:19.862 2017] [12570] binlog: finished replaying /var/lib/sphinx/binlog.002; 0.0 MB in 0.000 sec
[Tue Apr 11 12:04:19.862 2017] [12570] binlog: replaying log /var/lib/sphinx/binlog.003
[Tue Apr 11 12:04:19.862 2017] [12570] binlog: replay stats: 0 rows in 0 commits; 0 updates, 0 reconfigure; 0 indexes
[Tue Apr 11 12:04:19.862 2017] [12570] binlog: finished replaying /var/lib/sphinx/binlog.003; 0.0 MB in 0.000 sec
[Tue Apr 11 12:04:19.862 2017] [12570] binlog: finished replaying total 3 in 0.283 sec
[Tue Apr 11 12:04:19.862 2017] [12570] accepting connections
[Tue Apr 11 12:10:21.853 2017] [12569] watchdog: main process 12570 killed cleanly with SIGKILL, shutting down
[Tue Apr 11 12:10:21.887 2017] [12713] watchdog: main process 12714 forked ok
[Tue Apr 11 12:10:21.888 2017] [12714] listening on all interfaces, port=9312
[Tue Apr 11 12:10:21.888 2017] [12714] listening on all interfaces, port=9306
[Tue Apr 11 12:10:21.888 2017] [12714] WARNING: WARNING: index 'default': prefix_fields and infix_fields has no effect with dict=keywords, ignoring

[Tue Apr 11 12:10:21.889 2017] [12714] binlog: replaying log /var/lib/sphinx/binlog.001
[Tue Apr 11 12:10:22.183 2017] [12714] binlog: index default: recovered from tid 195960 to tid 210775
[Tue Apr 11 12:10:22.183 2017] [12714] binlog: replay stats: 14815 rows in 14815 commits; 0 updates, 0 reconfigure; 1 indexes
[Tue Apr 11 12:10:22.183 2017] [12714] binlog: finished replaying /var/lib/sphinx/binlog.001; 7.3 MB in 0.293 sec
[Tue Apr 11 12:10:22.183 2017] [12714] binlog: finished replaying total 1 in 0.293 sec
[Tue Apr 11 12:10:22.183 2017] [12714] accepting connections
[Tue Apr 11 12:10:41.623 2017] [12713] watchdog: main process 12714 killed cleanly with SIGKILL, shutting down
[Tue Apr 11 12:10:41.657 2017] [12738] watchdog: main process 12739 forked ok
[Tue Apr 11 12:10:41.658 2017] [12739] listening on all interfaces, port=9312
[Tue Apr 11 12:10:41.658 2017] [12739] listening on all interfaces, port=9306
[Tue Apr 11 12:10:41.658 2017] [12739] WARNING: WARNING: index 'default': prefix_fields and infix_fields has no effect with dict=keywords, ignoring

[Tue Apr 11 12:10:41.658 2017] [12739] binlog: replaying log /var/lib/sphinx/binlog.001
[Tue Apr 11 12:10:41.942 2017] [12739] binlog: index default: recovered from tid 195960 to tid 210775
[Tue Apr 11 12:10:41.942 2017] [12739] binlog: replay stats: 14815 rows in 14815 commits; 0 updates, 0 reconfigure; 1 indexes
[Tue Apr 11 12:10:41.942 2017] [12739] binlog: finished replaying /var/lib/sphinx/binlog.001; 7.3 MB in 0.283 sec
[Tue Apr 11 12:10:41.942 2017] [12739] binlog: replaying log /var/lib/sphinx/binlog.002
[Tue Apr 11 12:10:41.942 2017] [12739] binlog: replay stats: 0 rows in 0 commits; 0 updates, 0 reconfigure; 0 indexes
[Tue Apr 11 12:10:41.942 2017] [12739] binlog: finished replaying /var/lib/sphinx/binlog.002; 0.0 MB in 0.000 sec
[Tue Apr 11 12:10:41.942 2017] [12739] binlog: finished replaying total 2 in 0.283 sec
[Tue Apr 11 12:10:41.956 2017] [12739] accepting connections
[Tue Apr 11 12:21:27.861 2017] [12738] watchdog: main process 12739 killed cleanly with SIGKILL, shutting down
[Tue Apr 11 12:21:27.895 2017] [12949] watchdog: main process 12950 forked ok
[Tue Apr 11 12:21:27.896 2017] [12950] listening on all interfaces, port=9312
[Tue Apr 11 12:21:27.896 2017] [12950] listening on all interfaces, port=9306
[Tue Apr 11 12:21:27.896 2017] [12950] WARNING: WARNING: index 'default': prefix_fields and infix_fields has no effect with dict=keywords, ignoring

[Tue Apr 11 12:21:27.897 2017] [12950] binlog: replaying log /var/lib/sphinx/binlog.001
[Tue Apr 11 12:21:28.184 2017] [12950] binlog: index default: recovered from tid 210775 to tid 225590
[Tue Apr 11 12:21:28.184 2017] [12950] binlog: replay stats: 14815 rows in 14815 commits; 0 updates, 0 reconfigure; 1 indexes
[Tue Apr 11 12:21:28.184 2017] [12950] binlog: finished replaying /var/lib/sphinx/binlog.001; 7.3 MB in 0.287 sec
[Tue Apr 11 12:21:28.184 2017] [12950] binlog: finished replaying total 1 in 0.287 sec
[Tue Apr 11 12:21:28.184 2017] [12950] accepting connections

[Пума Тайланд]

monyavitevna: Ну надо смотреть другой лог сфинкса
ну наймите того кто понимает

[monyavitevna]

[Tue Apr 11 12:25:13.318 2017] 0.000 sec 0.000 sec [ext2/2/ext 24 (0,5)] [default] @title НА*
[Tue Apr 11 12:25:13.630 2017] 0.000 sec 0.000 sec [ext2/2/ext 0 (0,5)] [default] @title НАЙ*
[Tue Apr 11 12:25:15.173 2017] 0.000 sec 0.000 sec [ext2/2/ext 0 (0,5)] [default] @title НАЙК*
[Tue Apr 11 12:25:15.739 2017] 0.000 sec 0.000 sec [ext2/1/ext 0 (0,500)] [default] найк
[Tue Apr 11 12:25:25.792 2017] 0.000 sec 0.000 sec [ext2/1/ext 0 (0,500)] [default] тшлу

Вот кусочек кода с логов запросов