ERROR: unknown key name

[Bob]

Version 1.3.9, build 998

Fresh install.

Debian Buster.

When I run: indexer --all --config /usr/local/etc/piler/sphinx.conf I get these errors:

using config file '/usr/local/etc/piler/sphinx.conf'...
ERROR: unknown key name 'sql_query_kbatch' in /usr/local/etc/piler/sphinx.conf line 26 col 20.
ERROR: unknown key name 'sql_query_kbatch' in /usr/local/etc/piler/sphinx.conf line 26 col 1.
FATAL: failed to parse config file '/usr/local/etc/piler/sphinx.conf'

Any ideas what’s causing this?

[Janos SUTO]

My best bet is that the sphinx version installed doesn’t match the sphinx version specified in /usr/local/etc/piler/sphinx.conf

[Bob]

Ok, that fixed it. But now I have this:

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

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'...
indexing index 'main1'...
FATAL: failed to open @LOCALSTATEDIR@/piler/sphinx/main1.spl: No such file or directory, will not index. Try --rotate option.

[Janos SUTO]

It seems that the installation is not correct as you have the placeholder @LOCALSTATEDIR@ instead of its value, “/var:.. Did you run “make postinstall”?

[Bob]

I was trying to use the manual method.

[Bob]

Ok, got past running indexer. On the manual post install page you make reference to config.php. I see a config.php.in in the source folder but where is config.php installed?

[Janos SUTO]

In the document root of the gui. Normally it should be in /var/piler/www dir.

[Bob]

I think I have everything configured but when I go to the web site I get this:

Error: SQLSTATE[HY000] [2002] Connection refused on database: sphinx

I can turn on /etc/rc.piler but when I try to turn on /etc/rc.searchd I get errors because the /var/piler/sphinx directory is empty. What do I need to do to get the files in there?

[Janos SUTO]

Initialize it with indexer --all … as you wrote above.

[Bob]

Ok, have got it indexed. I’m a little confused with having a smarthost. If I configure localhost as the smarthost on port 25, hos does piler receive messages from my primary mail server?

[Janos SUTO]

The smarthost comes into play when you want to restore an email. Then the gui sends the mail to the smarthost, let it deliver the mail.

Piler on the other hand receives an email from your mail server directly via smtp.

[Bob]

But in the post install doc you suggest that smarthost could be the localhost (where piler is installed?) and on port 25 or a higher port. If I configure the mail server on localhost to use port 25 then what will piler listen on?

[Janos SUTO]

The piler-smtp binds to port 25 on all interfaces. But you can fix it by setting listen_addr and listen_port parameters, so you may put an MTA, eg. postfix to 127.0.0.1/25.

[Bob]

When I login to the web site, I get an error, “This Site Can’t be Reached” and the address is: http://hostname/index.php?route=health/health but if I click the browser back arrow the site loads with the correct url.

[Janos SUTO]

Fix the SITE_URL parameter in config-site.php

[Bob]

I tried make and make install in the systemd directory but there is nothing in /etc/systemd/systm/ . Is there a recommended way to setup systemd on Debian Buster?

[Janos SUTO]

If /etc/systemd/system/ doesn’t exist on buster, then try in /lib/systemd/system or wherever those files are.

[Janos SUTO]

Anyway, hopefully the original issue is solved by now.

[Евгений Аюпов]

Bob, what you write to /usr/local/etc/piler/sphinx.conf to fix this error?
I have sphinx version

Initializing sphinx indices... Sphinx 2.2.11-id64-release (95ae9a6)
Copyright (c) 2001-2016, Andrew Aksyonoff
Copyright (c) 2008-2016, Sphinx Technologies Inc (http://sphinxsearch.com))