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 <evan.s...@swtchev.com> >> 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 <evan.s...@swtchev.com> >> 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 <evan.s...@swtchev.com> >> 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 documentation for details. >> >>> WARNING: key 'enable_star' was permanently removed from Sphinx >> configuration. Refer to documentation for details. >> >>> indexing index 'custom_field_value_core'... >> >>> indexer: relocation error: indexer: symbol mysql_init, version >> libmysqlclient_18 not defined in file libmysqlclient.so.18 with link time >> reference >> >>> >> >>> When I try to make a search query on the website I get an error of >> >>> >> >>> "free":"no enabled local indexes to search >> >>> >> >>> >> >>> I think the main issue is the "indexer: relocation error" but I'm not >> completely sure. I see that the app uses enable_star which has been removed >> but I don't think this is what's causing the problem. >> >>> >> >>> I'm guessing that I need to yum install a dependency that I'm missing >> but I don't know what, if anyone could point me in the right direction that >> would be very much appreciated! >> >>> >> >>> Thanks! >> >>> >> >>> -- >> >>> 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 thinking-sphi...@googlegroups.com. >> >>> To post to this group, send email to thinkin...@googlegroups.com. >> >>> Visit this group at https://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 thinking-sphi...@googlegroups.com. >> >> To post to this group, send email to thinkin...@googlegroups.com. >> >> Visit this group at https://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 thinking-sphi...@googlegroups.com. >> > To post to this group, send email to thinkin...@googlegroups.com. >> > Visit this group at https://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 thinking-sphinx+unsubscr...@googlegroups.com. To post to this group, send email to thinking-sphinx@googlegroups.com. Visit this group at https://groups.google.com/group/thinking-sphinx. For more options, visit https://groups.google.com/d/optout.
