Thanks Pat, I think it was complied using MySQL 5.6 about 3 months ago and after running server upgrades it stopped indexing although search still works but new index is not being created.
I copied the files from older server to new one and may have installed it using postgres libraries. That might be an issue. I will try to dig deeper. Thanks for your help. Harjeet Singh from Mobile Device Please excuse brevity and typos On Sun, Aug 26, 2018, 20:32 Pat Allan <[email protected]> wrote: > Hi Harjeet, > > It looks like your installation of Sphinx has broken - it was apparently > compiled with a version of the MySQL client libraries that is no longer > present. Do you have any version of the MySQL client libraries installed? > And how have you installed Sphinx? > > Cheers > > — > Pat > > On 27 Aug 2018, at 6:23 am, Harjeet Singh <[email protected]> > wrote: > > 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 <[email protected]> >>> 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 <[email protected]> >>> 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 <[email protected]> >>> 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 [email protected]. >>> >>> To post to this group, send email to [email protected]. >>> >>> 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 [email protected]. >>> >> To post to this group, send email to [email protected]. >>> >> 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 [email protected]. >>> > To post to this group, send email to [email protected]. >>> > 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 [email protected]. > To post to this group, send email to [email protected]. > 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 [email protected]. > To post to this group, send email to [email protected]. > 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 [email protected]. To post to this group, send email to [email protected]. Visit this group at https://groups.google.com/group/thinking-sphinx. For more options, visit https://groups.google.com/d/optout.
