Upgraded to Snow Leopard and now TS configuration is broken

[Neil]

I just upgraded to Snow Leopard using the easy overwrite install
(rather than a clean-slate), and now Thinking Sphinx is struggling
with the config settings that used to work on Leopard 10.5.8. Does
anyone know how to fix this? I'm sure Sphinx is sat in exactly the
same place as it was before (using Macports, IIRC):

---------
rake ts:index
(in /Users/Neil/Sites/someapp)
sh: line 1: 94953 Trace/BPT trap indexer 2>&1
sh: line 1: 94956 Trace/BPT trap indexer 2>&1

Sphinx cannot be found on your system. You may need to configure the
following
settings in your config/sphinx.yml file:
* bin_path
* searchd_binary_name
* indexer_binary_name
---------

[Pat Allan]

Hi Neil

What happens if you call indexer on the command line? I'm guessing Sphinx needs to be reinstalled.

--
Pat

> --
> You received this message because you are subscribed to the Google Groups "Thinking Sphinx" group.
> To post to this group, send email to thinkin...@googlegroups.com.
> To unsubscribe from this group, send email to thinking-sphi...@googlegroups.com.
> For more options, visit this group at http://groups.google.com/group/thinking-sphinx?hl=en.
>

[Neil]

Hi Pat

$ indexer
dyld: Library not loaded: /usr/local/mysql/lib/libmysqlclient.15.dylib
Referenced from: /usr/local/bin/indexer
Reason: image not found
Trace/BPT trap

MySQL seems to be working just fine, though.

p.s. Long time no speak! You may remember helping me out over email a
couple of years back when I had some huge indexing times.

[Pat Allan]

Hi Neil

I hit this problem a while ago (back when I upgraded to Snow Leopard myself, I guess). The docs cover this situation:
http://freelancing-god.github.com/ts/en/installing_sphinx.html

In short, you should hopefully just need to run the following command - although I really don't feel this is a *smart* approach, but I couldn't find anything better.

sudo ln -s /usr/local/mysql/lib /usr/local/mysql/lib/mysql

And welcome back - hopefully those indexing times have been nice and fast since :)

--
Pat

[Neil]

I'm seeing:

$ sudo ln -s /usr/local/mysql/lib /usr/local/mysql/lib/mysql
ln: /usr/local/mysql/lib/mysql: No such file or directory
$ which mysql
/opt/local/bin/mysql

MySQL is installed via Macports. Do I need to adjust the first
argument in the symlink to use the /opt/local/bin/mysql? I can't see a
mysql/lib folder within /opt/local/bin (although I could definitely be
missing something!).

Thanks, yes, the indexing times are down!

[Pat Allan]

Ah yes, your symlink will definitely need to be different. I'm not exactly sure where it should point (I've never really used MacPorts - I used to compile by hand, these days I use Homebrew). Perhaps search around for libmysqlclient.*?

--
Pat

[Neil]

Thanks Pat. I've tracked down the files:

$ port contents mysql5 |grep libmysqlclient
/opt/local/lib/mysql5/mysql/libmysqlclient.16.dylib
/opt/local/lib/mysql5/mysql/libmysqlclient.a
/opt/local/lib/mysql5/mysql/libmysqlclient.dylib
/opt/local/lib/mysql5/mysql/libmysqlclient.la
/opt/local/lib/mysql5/mysql/libmysqlclient_r.16.dylib
/opt/local/lib/mysql5/mysql/libmysqlclient_r.a
/opt/local/lib/mysql5/mysql/libmysqlclient_r.dylib
/opt/local/lib/mysql5/mysql/libmysqlclient_r.la

Am I still symlinking 'mysql' or do I need to symlink
'libmysqlclient'?

[Pat Allan]

You'll want to symlink mysql - maybe something like:

sudo mkdir -p /usr/local/mysql/lib
sudo ln -s /opt/local/lib/mysql5/mysql /usr/local/mysql/lib/mysql

Hope this does the trick :)

--
Pat

[Neil]

Thanks Pat - unfortunately the symlink didn't do the trick, but I
installed Sphinx via Macports and it seems to have done the trick!

[Pat Allan]

Ah, good to know it's all sorted in the end :)

--
Pat