Sphinx Search mysql client on production server

[senthil kumar]

I want to connect to SphinxQL on my production server to execute sphinx queries on mysql database, Please note I ran the following commands in the production server terminal(Ubuntu 10.04) by connecting to it remotely. mysql -h 127.0.0.1 -P 9312 mysql -h 127.0.0.1 -P 9306 mysql -h <<my_production_ip_address>> -P 9312 mysql -h <<my_production_ip_address>> -P 9306 Tried changing the bind_address in /etc/mysql/my.cnf to my_production_ip_address. I want to run a sphinx query on my production server for debugging. Please help. Thanks.

[Pat Allan]

Hi Senthil

This is not what SphinxQL is for - SphinxQL is another protocol, based on MySQL's own protocol, for querying Sphinx itself. While the current versions of Thinking Sphinx do not use it, the rewrite I've been slowly working on does (it's the edge branch on GitHub, if anyone wants to play with it, read the README first).

If you want to use SphinxQL yourself, you'll need to add another 'listen' setting to your generated Sphinx configuration file - probably something like this:
listen = 127.0.0.1:9306:mysql41

This doesn't replace the existing listen statement (as that's what current versions of Thinking Sphinx will require), but you can have both the old and new-style protocols running at the same time.

Hope this helps.

--
Pat

> --
> You received this message because you are subscribed to the Google Groups "Thinking Sphinx" group.
> To view this discussion on the web visit https://groups.google.com/d/msg/thinking-sphinx/-/BV9s6cQyk6QJ.
> To post to this group, send email to thinkin...@googlegroups.com.
> To unsubscribe from this group, send email to thinking-sphi...@googlegroups.com.
> For more options, visit this group at http://groups.google.com/group/thinking-sphinx?hl=en.

[senthil kumar]

Hi Pat,

Thanks for your reply.

Adding another listen worked perfectly. Thank you so much. 

You know what, my whole business runs out of "THINKING SPHINX". Thank you so much for your work.

Thanks.

[Pat Allan]

Great to hear :)

Now remember, any time you run ts:index or ts:rebuild, it's going to overwrite that configuration file - so either get used to modifying it yourself (if this is just an occasional thing), or use ts:reindex instead (and "ts:stop ts:reindex ts:start" as a ts:rebuild replacement).

--
Pat

> --
> You received this message because you are subscribed to the Google Groups "Thinking Sphinx" group.

> To view this discussion on the web visit https://groups.google.com/d/msg/thinking-sphinx/-/FvxiwPQA2C0J.