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] > <mailto:[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 > >> <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 > >>> <https://groups.google.com/group/thinking-sphinx>. > >>> For more options, visit https://groups.google.com/d/optout > >>> <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 > >> <https://groups.google.com/group/thinking-sphinx>. > >> For more options, visit https://groups.google.com/d/optout > >> <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 > > <https://groups.google.com/group/thinking-sphinx>. > > For more options, visit https://groups.google.com/d/optout > > <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] > <mailto:[email protected]>. > To post to this group, send email to [email protected] > <mailto:[email protected]>. > Visit this group at https://groups.google.com/group/thinking-sphinx > <https://groups.google.com/group/thinking-sphinx>. > For more options, visit https://groups.google.com/d/optout > <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.
signature.asc
Description: Message signed with OpenPGP
