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 On 07/07/2012, at 1:27 PM, senthil kumar wrote: > > > > 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. > > > -- > 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 [email protected]. > To unsubscribe from this group, send email to > [email protected]. > For more options, visit this group at > http://groups.google.com/group/thinking-sphinx?hl=en. -- You received this message because you are subscribed to the Google Groups "Thinking Sphinx" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/thinking-sphinx?hl=en.
