Turns out the issue for this was some stupid behaviour in the Riddle gem
(clearing the address value), which is now fixed.
Adding the following to your Gemfile will get things working smoothly again:
gem 'riddle',
git: 'git://github.com/pat/riddle.git',
branch: 'develop',
ref: '0dfe38063c'
Any further issues, do let me know :)
--
Pat
On 23 Mar 2014, at 10:13 am, Garrett Dimon <[email protected]> wrote:
> We also noticed this error when using strace on the generate rake task. It
> seems odd that it's trying to connect to the right port for TS, but not using
> the address from the config file and rather using 127.0.0.1. I inspected
> "ThinkingSphinx::Configuration.instance" from the console and verified that
> it is picking up the correct IP address for our job server. So it seemed odd
> that it wasn't using that IP address to connect.
>
> connect(10, {sa_family=AF_INET, sin_port=htons(9306),
> sin_addr=inet_addr("127.0.0.1")}, 16) = -1 ECONNREFUSED (Connection refu
> sed)
> shutdown(10, 2 /* send and receive */) = -1 ENOTCONN (Transport endpoint is
> not connected)
> close(10) = 0
> rt_sigprocmask(SIG_SETMASK, [], NULL, 8) = 0
> rt_sigprocmask(SIG_SETMASK, [], NULL, 8) = 0
> rt_sigprocmask(SIG_SETMASK, [], NULL, 8) = 0
> rt_sigprocmask(SIG_SETMASK, [], NULL, 8) = 0
> rt_sigprocmask(SIG_SETMASK, [], NULL, 8) = 0
> rt_sigprocmask(SIG_SETMASK, [], NULL, 8) = 0
> rt_sigprocmask(SIG_SETMASK, [], NULL, 8) = 0
> write(2, "rake aborted!", 13rake aborted!) = 13
> write(2, "\n", 1
> ) = 1
> write(2, "Can't connect to MySQL server on"..., 50Can't connect to MySQL
> server on '127.0.0.1' (111)) = 50
>
>
> On Saturday, March 22, 2014 3:09:35 PM UTC-5, Garrett Dimon wrote:
> I've setup Thinking Sphinx 3.1.0 and Sphinx 2.1.6, but now when I try to
> generate the RT index, I'm seeing an error that it cannot connect to 127.0.0.1
>
> In our thinking_sphinx.yml, I've correctly configured the address for the
> production environment to our job server, but our DB server is separate.
>
> For context, in production, we have two app servers, one job server, and a
> server each for our master and slave DB.
>
> I'm guessing that the problem here is that it's trying to connect to the DB
> server for indexing but needs to know where it is. I would assume that it
> would get this from the database.yml, but it looks like it may not be.
>
> Are there any likely settings I've overlooked in configuring the remote
> indexing for this?
>
> Thanks,
> Garrett
>
> --
> You received this message because you are subscribed to the Google Groups
> "Thinking Sphinx" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to [email protected].
> To post to this group, send email to [email protected].
> Visit this group at http://groups.google.com/group/thinking-sphinx.
> For more options, visit https://groups.google.com/d/optout.
--
You received this message because you are subscribed to the Google Groups
"Thinking Sphinx" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To post to this group, send email to [email protected].
Visit this group at http://groups.google.com/group/thinking-sphinx.
For more options, visit https://groups.google.com/d/optout.
