Error connecting to Sphinx via the MySQL protocol

Sharetribe Go Community Edition
1

Hello, @rap1ds we are doing well in the catch in hand of the wonderful Sharetribe platform.
Our market place is working but we have some problem.

We create categories and sub category. When you click on a category, you get the error message below. Your help will we be a great contribution. Thank you.

We are on a VPS with Ubuntu 16.04 And Sharetribe 5.11.

Error connecting to Sphinx via the MySQL protocol. Error connecting
to Sphinx via the MySQL protocol. Can’t connect to MySQL server on
’127.0.0.1’ (111) - SELECT * FROM listing_core, listing_delta WHERE
community_id = 1 AND category_id IN (5, 28, 29, 30, 31, 32, 33, 34,
35, 36) AND sphinx_deleted = 0 ORDER BY sort_date DESC LIMIT 0, 24
OPTION field_weights=(title=10, category=8, description=3),
max_query_time=1000; SHOW META

2

did you install Sphinx?

are you sure Sphinx is running?
you can run Sphinx using following command from Github README https://github.com/sharetribe/sharetribe

Run Sphinx index:
   bundle exec rake ts:index

Start the Sphinx daemon:
   bundle exec rake ts:start
3

Hi @111

Thank you for your promte reaction. This was exactly the problem. I start sphinx and the problem was solved.

Only; every time I restart the server, I have to restart sphinx.
How sphinx set to start automatically when the server restarts?

1 Like
4

sorry I don’t know how to make Sphinx auto start when server restart.