Hi Pat and Wade, okay, thank you for your replies. I fear I am not a good enough coder to come up with a MS-SQL adapter for Thinking Sphinx...sorry :-(
But, as I am trying to find a workaround for my situation, I thought I could put the table I want TS to index on a MySQL server, and make a new connection in database.yml for this MySQL-Server. So I went ahead and did that. Then, in my model-to-be-indexed, I put "establish_connection :mysql_conn". Unfortunately, TS doesn't seem to pick this up, because when trying to index, I get the S1000 (0) [unixODBC][FreeTDS][SQL Server]Unable to connect to data source error. As there are no relationship defined on this model, I don't understand why this happens. Is there a better workaround? Thank you Toni On Jul 29, 10:44 am, Pat Allan <[email protected]> wrote: > Wade's absolutely correct - there's no support for SQL Server in > Thinking Sphinx yet. > > If you'd like to submit a patch, that'd be fantastic - and Wade's > suggestion for using the Postgres adapter as a starting point is a > good one. The adapters hold the unique database approaches to SQL > functions. > > Cheers > > -- > Pat > > On 29/07/2009, at 1:30 AM, Wade Winningham wrote: > > > > > > > I'm pretty sure ThinkingSphinx only works with MySQL and Postgres > > right now unless someone's written other adapters. > > > I've been intending to write one for SQL Server, but ran into an issue > > with SQL Server lacking a few functions MySQL has built-in and > > Postgres can easily include with stored functions. The main one being > > a comparable function for MySQL's GROUP_CONTACT function. > > > If you'd like to take a stab at writing an adapter for it, I think the > > Postgres adapter is actually a bit closer to what you'd need than the > > MySQL one. In the gem source for TS just look in the > > lib/thinking-sphinx/adapters directory. > > > -Wade Winningham > > > On Tue, Jul 28, 2009 at 10:48 AM, Tonkatsufan<[email protected]> > > wrote: > > >> Hi, > > >> I have a running Rails 2.3.2 application on a Ubuntu box connected to > >> a SQL-Server 2005 database via UnixODBC/FreeTDS. I set up my Rails' > >> database.yml accordingly and can read and write to all tables. Of > >> course, tsql and isql also work on my unix machine, so the connection > >> to the SQL-Server is working as it should. > > >> Now, I tried adding Thinking Sphinx for fulltext search to my Rails > >> app. Therefore, I compiled Sphinx 0.9.9-RC2 with unixodbc support. > > >> I set up the model with a define_index like described in the docs and > >> ran rake ts:in which produced the following error: > > >> (in /var/www/r_tools) > >> Generating Configuration to /var/www/r_tools/config/ > >> development.sphinx.conf > >> Sphinx 0.9.9-rc2 (r1785) > >> Copyright (c) 2001-2009, Andrew Aksyonoff > > >> using config file '/var/www/r_tools/config/ > >> development.sphinx.conf'... > >> FATAL: no indexes found in config file '/var/www/r_tools/config/ > >> development.sphinx.conf' > > >> here is the generated conf file: > > >> indexer > >> { > >> } > > >> searchd > >> { > >> listen = 127.0.0.1:3312 > >> log = /var/www/r_tools/log/searchd.log > >> query_log = /var/www/r_tools/log/searchd.query.log > >> pid_file = /var/www/r_tools/log/searchd.development.pid > >> } > > >> It seems Thinking Sphinx was not able to set up a configuration for > >> my > >> scenario. What do I need to do in order to make this work? > >> Apparently, > >> having a working connection in Rails / ActiveRecord does not mean TS > >> will also be able to use that connection for configuring. But where > >> and how do I set up Thinking Sphinx in a way that uses odbc ? > > >> Thank you for any help! > >> Toni --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Thinking Sphinx" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/thinking-sphinx?hl=en -~----------~----~----~----~------~----~------~--~---
