Code: Select all
Sphinx Error: connection to 127.0.0.1:9312 failed (errno=111, msg=Connection refused)
Everything is standard, except for two language packs and a second style.
Code: Select all
Sphinx Error: connection to 127.0.0.1:9312 failed (errno=111, msg=Connection refused)
Code: Select all
netstat -nlp | grep searchd
netstat -nlp | grep 9312
Ignoring those won't cure the problem.
Code: Select all
/etc/sphinxsearch/sphinx.conf: line 1: source_phpbb_ID_main: No such file or directory
/etc/sphinxsearch/sphinx.conf: line 10: syntax error near unexpected token `('
/etc/sphinxsearch/sphinx.conf: line 10: ` sql_query_pre = UPDATE phpbb_sphinx SET max_doc_id = (SELECT MAX(post_id) FROM phpbb_posts) WHERE counter_id = 1 '
[2]- Exit 1 indexer --config /etc/sphinxsearch/sphinx.conf/ index_phpbb_ID_main >> /home/sphinx/log/indexer.log 2>&1
Code: Select all
FATAL: config file '/etc/sphinxsearch/sphinx.conf/' does not exist or is not readable
Sphinx 2.2.11-id64-release (95ae9a6)
Copyright (c) 2001-2016, Andrew Aksyonoff
Copyright (c) 2008-2016, Sphinx Technologies Inc (http://sphinxsearch.com)
using config file '/etc/sphinxsearch/sphinx.conf'...
indexing index 'index_phpbb_ID_delta'...
ERROR: index 'index_phpbb_ID_delta': sql_connect: Access denied for user 'xxx'@'%' to database 'xxx' (DSN=mysql://XXX:***@127.0.0.1:3306/xxx).
total 0 docs, 0 bytes
total 0.068 sec, 0 bytes/sec, 0.00 docs/sec
total 0 reads, 0.000 sec, 0.0 kb/call avg, 0.0 msec/call avg
total 0 writes, 0.000 sec, 0.0 kb/call avg, 0.0 msec/call avg
Sphinx 2.2.11-id64-release (95ae9a6)
Copyright (c) 2001-2016, Andrew Aksyonoff
Copyright (c) 2008-2016, Sphinx Technologies Inc (http://sphinxsearch.com)
using config file '/etc/sphinxsearch/sphinx.conf'...
indexing index 'index_phpbb_xxx_delta'...
ERROR: index 'index_phpbb_xxx_delta': sql_connect: Access denied for user xxx'@'%' to database 'xxx' (DSN=mysql://xxx:***@127.0.0.1:3306/xxx).
total 0 docs, 0 bytes
total 0.007 sec, 0 bytes/sec, 0.00 docs/sec
total 0 reads, 0.000 sec, 0.0 kb/call avg, 0.0 msec/call avg
total 0 writes, 0.000 sec, 0.0 kb/call avg, 0.0 msec/call avg
FATAL: config file '/etc/sphinxsearch/sphinx.conf/' does not exist or is not readable
FATAL: config file '/etc/sphinxsearch/sphinx.conf/' does not exist or is not readable
Code: Select all
[Fri Feb 22 16:07:12.100 2019] [14602] watchdog: main process 14604 exited cleanly (exit code 1), shutting down
[Fri Feb 22 16:11:31.698 2019] [15077] watchdog: main process 15078 forked ok
[Fri Feb 22 16:11:31.710 2019] [15078] WARNING: multiple addresses found for 'localhost', using the first one (ip=127.0.0.1)
[Fri Feb 22 16:11:31.711 2019] [15078] listening on 127.0.0.1:9312
[Fri Feb 22 16:11:31.713 2019] [15078] WARNING: index 'index_phpbb_xxx_main': preload: failed to open /home/sphinx/index_phpbb_xxx_main.sph: No such file or directory; NOT SERVING
[Fri Feb 22 16:11:31.714 2019] [15078] WARNING: index 'index_phpbb_xxx_delta': preload: failed to open /home/sphinx/index_phpbb_xxx_delta.sph: No such file or directory; NOT SERVING
[Fri Feb 22 16:11:31.714 2019] [15078] FATAL: no valid indexes to serve
[Fri Feb 22 16:11:31.721 2019] [15077] watchdog: main process 15078 exited cleanly (exit code 1), shutting down
Neither netstat returns anything and I tried first with localhost, restarting sphinxsearch everytime I modified the conf file.</Solidjeuh> wrote: ↑Thu Feb 21, 2019 2:38 pm Try 'localhost' instead of '127.0.0.1'.
Of try via SSHI also think this is not a phpBB problemCode: Select all
netstat -nlp | grep searchd netstat -nlp | grep 9312
And not using the mysql fulltext search also helps not overloading the server. I have 4 million messages now and I'd rather use phpBB Native Fulltext than mysql fulltext.
Code: Select all
/etc/sphinxsearch/sphinx.conf: line 1: source_phpbb_xxx_main: No such file or directory
/etc/sphinxsearch/sphinx.conf: line 11: syntax error near unexpected token `('
/etc/sphinxsearch/sphinx.conf: line 11: ` UPDATE phpbb_sphinx SET max_doc_id = (SELECT MAX(post_id) FROM phpbb_posts) WHERE counter_id = 1 '
Code: Select all
/etc/sphinxsearch/sphinx.conf: line 1: source_phpbb_xxx_main: No such file or directory
Code: Select all
indexer --config {CONFIG_PATH}/sphinx.conf index_phpbb_{SPHINX_ID}_main >> {DATA_PATH}/log/indexer.log 2>&1 &
Code: Select all
Sphinx Error: connection to 127.0.0.1:9312 failed (errno=111, msg=Connection refused)
I agree, and it just seconds the search index was ready.thecoalman wrote: ↑Sat Feb 23, 2019 10:29 amThe best place to research this is on sphinx's site. It was PITA setting this up when I did it but well worth it. Searches are almost instant and very little load.
The cause apparently was that the port searchd listens to was unmapped.thecoalman wrote: ↑Sat Feb 23, 2019 10:29 amOne cause of this is not enough RAM allocated. Sphinx will exit and needs to be restarted, if you get that message again check to see if it's running.Code: Select all
Sphinx Error: connection to 127.0.0.1:9312 failed (errno=111, msg=Connection refused)