Sphinx Errors

[Jason P. Messenger]

Getting the following error when trying to access the web site for Piler.

Error: SQLSTATE[HY000] [2003] Can't connect to MySQL server on '127.0.0.1' (13) on database: sphinx

Also seeing the following when starting searchd

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 '/usr/local/etc/piler/sphinx.conf'... listening on 127.0.0.1:9312 listening on 127.0.0.1:9306 precaching index 'main1' precaching index 'main2' precaching index 'main3' precaching index 'main4' precaching index 'dailydelta1' precaching index 'delta1' precaching index 'tag1' precaching index 'note1' precaching index 'att1' WARNING: index 'att1': preload: failed to open /var/piler/sphinx/att1.sph: No such file or directory; NOT SERVING precached 9 indexes in 0.046 sec

[Janos SUTO]

Stop searchd, then run as user piler:

indexer --config /usr/local/etc/piler/sphinx.conf att1

Then start searchd, and check if the problem persists.

[Jason P. Messenger]

Still gives me the same error "FATAL: failed to open /var/piler/sphinx/att1.spl: No such file or directory, will not index. Try --rotate option."

[Janos SUTO]

I don't understand. You created the attachment index files. Then it still complains that no such file. What gives?

[Jason P. Messenger]

Dummy me didn't realize that it was looking in the wrong path. Corrected that, so now no errors when starting searchd, but still getting the following when going to the web page for Piler.

Error: SQLSTATE[HY000] [2003] Can't connect to MySQL server on '127.0.0.1' (13) on database: sphinx

[Janos SUTO]

Then just start searchd.

[Jason P. Messenger]

searchd IS started.

ps -auxww | grep searchd root 6588 0.0 0.0 112648 960 pts/0 S+ 08:58 0:00 grep --color=auto searchd piler 18897 0.0 0.0 94140 1368 ? S Jun20 0:00 searchd --config /usr/local/etc/piler/sphinx.conf piler 18898 0.1 2.2 195172 42352 ? Sl Jun20 1:32 searchd --config /usr/local/etc/piler/sphinx.conf

[Janos SUTO]

Still, the gui just can't reach 127.0.0.1:9306. Do you have selinux?

[Jason P. Messenger]

It would appear so.

[Jason P. Messenger]

fixed the rules fo selinux, and now works. Thanks for thinking of that.

[Jason P. Messenger]

Fixed.