ERROR: unknown key name
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?
Comments (18)
-
repo owner -
reporter 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. -
repo owner It seems that the installation is not correct as you have the placeholder @LOCALSTATEDIR@ instead of its value, “/var:.. Did you run “make postinstall”?
-
reporter I was trying to use the manual method.
-
reporter 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?
-
repo owner In the document root of the gui. Normally it should be in /var/piler/www dir.
-
reporter 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?
-
repo owner Initialize it with indexer --all … as you wrote above.
-
reporter 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?
-
repo owner 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.
-
reporter 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?
-
repo owner 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.
-
reporter 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.
-
repo owner Fix the SITE_URL parameter in config-site.php
-
reporter 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?
-
repo owner If /etc/systemd/system/ doesn’t exist on buster, then try in /lib/systemd/system or wherever those files are.
-
repo owner - changed status to resolved
Anyway, hopefully the original issue is solved by now.
-
Account Deleted Bob, what you write to /usr/local/etc/piler/sphinx.conf to fix this error?
I have sphinx versionInitializing 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)) - Log in to comment
My best bet is that the sphinx version installed doesn’t match the sphinx version specified in /usr/local/etc/piler/sphinx.conf