postgresql - thinking_sphinx connection via MySQL -
ubuntu 14.04 installation, nginx, passenger , postgresql. following steps run:
sudo apt-get update && sudo apt-get upgrade -y sudo apt-get install mysql-server sudo mysql_secure_installation _for allowing localhost connection_ sudo apt-get install sphinxsearch gem file has
gem 'mysql2', '0.3.18', :platform => :ruby gem 'thinking-sphinx', '3.1.4' thinking_sphinx.yml specifies
mysql41: 9312 running:
rails_env=development bundle exec rake ts:rebuild proceeds correctly: total 112 writes, 0.079 sec, 485.0 kb/call avg, 0.7 msec/call avg started searchd (pid: 21644).
netstat -ltnp shows 1 searchd process
tcp 0 0 127.0.0.1:9312 0.0.0.0:* listen 21644/searchd so 1 concludes go... right? [nasty buzzer]
thinkingsphinx::connectionerror error connecting sphinx via mysql protocol. error connecting sphinx via mysql protocol. _nice... stated twice!_ can't connect mysql server on '127.0.0.1' (111) possible avenues non-connection:
- mysql-server root password not digested
- nginx somehow impeding connection
others? how verify/assert?
while sphinx implements mysql protocol querying, not pay attention authentication, thinking sphinx doesn't use fields either. i'm not sure if mysql_secure_installation right tool job - certainly, not if it's trying use authentication control access. if don't want allow external communication sphinx, can block port?
Comments
Post a Comment