Sphinxsearch doesn't start: "Error: SQLSTATE[HY000] [2002]"

Hi, Janos

Following your yesterday suggestion, I have allocated a new installation for testing the master build (trying to avoid previous bug commented yesterday).

After a fresh installation of Ubuntu 16.04 LTS Server flavour, I have installed the yesterday master:

piler -version 1.2.0-master build 945

Now, when I try to start the GUI, I obtain the error: Error: SQLSTATE[HY000] [2002] Connection refused on database: sphinx

The sphinxsearch service is not started (Had to be or Piler starts it???). But, if I try to start manually, I get: $ sudo /etc/init.d/sphinxsearch start To enable sphinxsearch, edit /etc/default/sphinxsearch and set START=yes (the installation instruction suggest to keep it in START=no).

If I try to force it, changing the parameter, I get

sudo /etc/init.d/sphinxsearch start Starting sphinxsearch: Sphinx 2.2.9-id64-release (rel22-r5006) Copyright (c) 2001-2015, Andrew Aksyonoff Copyright (c) 2008-2015, Sphinx Technologies Inc (http://sphinxsearch.com)

using config file '/etc/sphinxsearch/sphinx.conf'...

FATAL: failed to create pid file '/var/run/piler/searchd.pid': No such file or directory ERROR.

If I create the dir and grants the rights, I get this $ sudo mkdir /var/run/piler $ sudo chmod 777 /var/run/piler $ sudo /etc/init.d/sphinxsearch start Starting sphinxsearch: Sphinx 2.2.9-id64-release (rel22-r5006) Copyright (c) 2001-2015, Andrew Aksyonoff Copyright (c) 2008-2015, Sphinx Technologies Inc (http://sphinxsearch.com)

using config file '/etc/sphinxsearch/sphinx.conf'... listening on 127.0.0.1:9312 listening on 127.0.0.1:9306 precaching index 'main1' WARNING: rotating index 'main1': rename '/var/piler/sphinx/main1.sph' to '/var/piler/sphinx/main1.old.sph' failed: Permission denied

It's obvious I'm doing something wrong with sphinxsearch, but I don't know if it's a configuration problem, or a problem with make postinstallation

Comments (2)