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.
