Hi Evan,
I am getting the same error and I searched all over for last 10 days and
simply cant get it to work. I am just using and EC2 instance with RDS.
I connect to RDS via EC2 security group on port 3306 to Index.
I was able to Index it once and the search is working with the index that
was created few weeks again.
When ever Is run indexer --rotate --all is get below error
I will really appreciate the help
best
Harjeet
indexer: relocation error: indexer: symbol mysql_init, version
libmysqlclient_18 not defined in file libmysqlclient.so.18 with link time
reference
On Wednesday, March 28, 2018 at 2:33:02 PM UTC-4, Evan Shabsove wrote:
>
> Okay great!
>
> I managed to get it all working! I can't believe it ahaha thanks for
> everyone's help!
>
> On Wednesday, March 28, 2018 at 11:46:34 AM UTC-4, Walter Davis wrote:
>>
>> Port and PID have literally nothing to do with one another. Sphinx uses
>> port 9312 by default, and you can configure it otherwise using the --port
>> flag when you start searchd.
>>
>> Walter
>>
>> > On Mar 28, 2018, at 11:36 AM, Evan Shabsove
>> wrote:
>> >
>> > So I have set up a separate server with my app's code running sphinx
>> and have ran all the ts rake tasks.
>> >
>> > When configuring sphinx in my thinking_sphinx.yml file what address
>> should I use? Currently I just have it pointing to the public IP of the
>> server, but I would imagine I need to point it at the searchd client PID
>> correct? Something like MY_IP:31096?
>> >
>> > Also what port should I open on my server? Should it be port 31096?
>> >
>> > Thanks,
>> > Evan
>> >
>> > On Wednesday, March 21, 2018 at 8:47:46 PM UTC-4, Pat Allan wrote:
>> > No worries about asking the questions :)
>> >
>> > And yes, that thread contains the right advice - you want to deploy a
>> copy of your app to the Sphinx server, and have the address setting
>> configured with the appropriate IP/host. That server is where you’ll run
>> all the TS rake tasks, and it’s where the Sphinx daemon is and the index
>> files. Each of your app servers then make a request to this Sphinx server.
>> >
>> > If that’s not clear or if you have further questions, do ask :)
>> >
>> > —
>> > Pat
>> >
>> >> On 22 Mar 2018, at 5:59 am, Evan Shabsove
>> wrote:
>> >>
>> >> I think you addressed the same problem in this thread as well
>> https://github.com/pat/thinking-sphinx/issues/1005
>> >>
>> >> Sorry if this comes up a lot, I bet you get these kind of questions
>> all the time.
>> >>
>> >> On Wednesday, March 21, 2018 at 2:46:18 PM UTC-4, Evan Shabsove wrote:
>> >> Hey Pat, sorry I know this post was forever ago now but I was never
>> quite able to figure out a solution for this, currently we just turned
>> searching off on our app but that's far from desirable.
>> >>
>> >> I'm fairly new to the world of dev-ops so I don't think I was asking
>> the right question in my first message. Originally I was trying to install
>> Thinking Sphinx on every new instance launched by Elastic Beanstalk, but
>> this would be a poor way of doing it, correct? Because then every new
>> instance has different indexes?
>> >>
>> >> What I want to do now is set up a server that runs the Sphinx client,
>> and our app makes search requests to this server. This way searching is not
>> tied to the auto scaling environment.
>> >>
>> >> I guess my questions are is this possible? And if yes how can I tell
>> my rails app to point to this new server?
>> >>
>> >> Thanks for the help!
>> >> Evan
>> >>
>> >> On Friday, January 5, 2018 at 10:07:02 AM UTC-5, Evan Shabsove wrote:
>> >> Hmm okay, I'll try to get the client libraries installed, I'm a bit
>> new to yum as well so this process has been a bit of a challenge ahaha.
>> I'll give it a shot and let you know if that gets everything working,
>> thanks!
>> >>
>> >> On Wednesday, January 3, 2018 at 9:27:30 PM UTC-5, Pat Allan wrote:
>> >> Hi Evan,
>> >>
>> >> I think you’re right about it being a dependency issue. Sphinx will
>> require mysql-related dependencies - you don’t need a MySQL server running,
>> but you will need client libraries installed. I’m not across yum, so I’m
>> not sure what’s ideal. Also, it’s worth noting that you may need to
>> reinstall Sphinx after the mysql dependencies, to ensure it picks up on
>> them correctly.
>> >>
>> >> Do let us know if you find a solution!
>> >>
>> >> —
>> >> Pat
>> >>
>> >>> On 4 Jan 2018, at 8:29 am, Evan Shabsove
>> wrote:
>> >>>
>> >>> Hey everyone,
>> >>>
>> >>> I've been trying to set up sphinx on an elastic beanstalk instance. I
>> currently have searchd running, but when I try to run the command
>> >>>
>> >>> RAILS_ENV=production bundle exec rake ts:index
>> >>>
>> >>> I get an error of
>> >>>
>> >>> using config file '/var/app/ondeck/config/production.sphinx.conf'...
>> >>> WARNING: key 'enable_star' was permanently removed from Sphinx
>> configuration. Refer to
