Hi,
On 1. Mar 2018, at 11:52 , Adrian Schröter <adrian@suse.de> wrote:
How to make internal search work?
In the logs I see:
[...] Can't connect to MySQL server on '127.0.0.1' (111 "Connection refused") [...]
this is usually not the real MySQL server, but the searchd which offers also a mysql interface ...
And the crash is usually caused by a not running searchd.
In your version it should have been started by clockworkd. try to run in manually by running
rake.ruby2.X ts:index ts:start
as the right user (www?).
The most popular reason why searchd is not starting is some left over file with wrong ownership. So I would
rm -rf /srv/www/obs/api/tmp/binlog /srv/www/obs/api/log/production.searchd.log /srv/www/obs/api/log/production.searchd.query.log /srv/www/obs/api/log/production.sphinx.pid
before.
That was a good hint. binlog was indeed not owned by wwwrun. Found the clean-restart method of the obsapidelayed init-script and after that, it works. I wonder why, since that is a fresh 2.8 installation, but the following fixed it: # /etc/init.d/obsapidelayed clean-restart redirecting to systemctl stop obsapidelayed.service /usr/lib64/ruby/gems/2.4.0/gems/activesupport-5.0.1/lib/active_support/xml_mini.rb:51: warning: constant ::Fixnum is deprecated /usr/lib64/ruby/gems/2.4.0/gems/activesupport-5.0.1/lib/active_support/xml_mini.rb:52: warning: constant ::Bignum is deprecated /usr/lib64/ruby/gems/2.4.0/gems/activejob-5.0.1/lib/active_job/arguments.rb:38: warning: constant ::Fixnum is deprecated /usr/lib64/ruby/gems/2.4.0/gems/activejob-5.0.1/lib/active_job/arguments.rb:38: warning: constant ::Bignum is deprecated /usr/lib64/ruby/gems/2.4.0/gems/activesupport-5.0.1/lib/active_support/core_ext/numeric/conversions.rb:138: warning: constant ::Fixnum is deprecated Generating configuration to /srv/www/obs/api/config/production.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 '/srv/www/obs/api/config/production.sphinx.conf'... WARNING: key 'max_matches' was permanently removed from Sphinx configuration. Refer to documentation for details. indexing index 'package_core'... collected 25401 docs, 1.3 MB collected 21 attr values sorted 0.0 Mvalues, 100.0% done sorted 0.2 Mhits, 100.0% done total 25401 docs, 1291159 bytes total 1.661 sec, 777046 bytes/sec, 15286.85 docs/sec indexing index 'project_core'... collected 1506 docs, 0.1 MB collected 21 attr values sorted 0.0 Mvalues, 100.0% done sorted 0.0 Mhits, 100.0% done total 1506 docs, 67107 bytes total 0.899 sec, 74608 bytes/sec, 1674.34 docs/sec skipping non-plain index 'package'... skipping non-plain index 'project'... total 26937 reads, 0.014 sec, 0.1 kb/call avg, 0.0 msec/call avg total 28 writes, 0.007 sec, 175.1 kb/call avg, 0.2 msec/call avg redirecting to systemctl start obsapidelayed.service -- kind regards, Carsten Hoeger Professional Services Email: carsten.hoeger@open-xchange.com ------------------------------------------------------------------------------ Open-Xchange AG, Rollnerstr. 14, 90408 Nuremberg, District Court Nuremberg HRB 24738 Managing Board: Rafael Laguna de la Vera, Carsten Dirks, Michael Knapstein, Stephan Martin Chairman of the Board: Richard Seibt European Office: Open-Xchange GmbH, Olper Huette 5f, D-57462 Olpe, Germany, District Court Siegen, HRB 8718 Managing Director: Frank Hoberg US Office: Open-Xchange. Inc., 530 Lytton Avenue, Palo Alto, CA 94301, USA ------------------------------------------------------------------------------