[RussH]

Hiya,

a quick google for this error shows that it's related to not starting the sphinx daemon;

http://64.233.183.104/search?q=cache:WH ... =firefox-a

[cards]

NEVERMIND BELOW...I somehow got to this thread via google but ONLY saw the post with the question; didn't realize there was already a response with a solution.

I had a working 0.8.0 installation, but now I'm getting this same error when I try a resume search. Does anyone know the cause/fix for this?

Code: Select all

A fatal error has occurred.

Sphinx Error: Connection to localhost:3312 failed.

[cards]

Ok, I guess my problem is not solved. Here's what I'm seeing when I try to start searchd:

Code: Select all

root@litterbox:/# /etc/init.d/searchd start
Starting searchd
Sphinx 0.9.7
Copyright (c) 2001-2007, Andrew Aksyonoff

using config file '/var/www/cats/sphinx//etc/sphinx.conf'...
- loaded 587 stopwords from '/var/www/cats/lib/sphinx/STOPWORDS'
WARNING: index 'cats': lock file '/var/www/cats/lib/sphinx/index/cats.spl' exists - NOT SERVING
- loaded 587 stopwords from '/var/www/cats/lib/sphinx/STOPWORDS'
WARNING: index 'catsdelta': lock file '/var/www/cats/lib/sphinx/index/cats_delta.spl' exists - NOT SERVING
FATAL: no valid indexes to serve
shutdown complete

Any suggestions?

[cards]

Maybe I should just work on this longer before posting...but I keep finding out more without getting things working. I noticed the error saying the problem was that those two .spl files existed, so I renamed them and tried again. From the command line, it appeared that searchd had loaded successfully. When I tried a search in cats, here's the new error I get:

Code: Select all

A fatal error has occurred.

Sphinx Error: Searchd error: invalid index 'catsdelta' specified in request.

Did I make things better or worse by renaming the .spl files? Any advice on how to get this running?

[RussH]

Hey Cards,

looks like there's a lock file present from when sphinx ran previously - try stopping sphinx, deleting the two lock files and restarting the sphinx daemon...

ah-ha, you beat me to it!

Okay, the index name in sphinx.conf must be the same name as the table you are searching... so dependant upon which version of cats you're running you may have to edit it. Simplest way is to check that there's a catsdelta table in your database?

[cards]

Getting closer... Sorry for the large post, but here's a list of tables in my cats database. I do not see a "catsdelta" table. Which name do I need to be using in sphinx.conf?

Code: Select all

mysql> use cats
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed
mysql> show tables;
+-- ---------------------------------+
| Tables_in_cats                    |
+-----------------------------------+
| access_level                      |
| activity                          |
| activity_type                     |
| attachment                        |
| calendar_event                    |
| calendar_event_type               |
| candidate                         |
| candidate_joborder                |
| candidate_joborder_status         |
| candidate_joborder_status_history |
| candidate_jobordrer_status_type   |
| candidate_source                  |
| career_portal_settings            |
| career_portal_template            |
| career_portal_template_site       |
| company                           |
| company_department                |
| contact                           |
| dashboard_component               |
| data_item_type                    |
| eeo_ethnic_type                   |
| eeo_veteran_type                  |
| email_history                     |
| email_template                    |
| extra_field                       |
| extra_field_settings              |
| feedback                          |
| history                           |
| http_log                          |
| http_log_types                    |
| import                            |
| installtest                       |
| joborder                          |
| joborder_status                   |
| module_schema                     |
| mru                               |
| queue                             |
| saved_list                        |
| saved_list_entry                  |
| saved_search                      |
| settings                          |
| site                              |
| sph_counter                       |
| system                            |
| user                              |
| user_login                        |
| word_verification                 |
| xml_feed_submits                  |
| xml_feeds                         |
| zipcodes                          |
+-----------------------------------+
50 rows in set (0.00 sec)

mysql>

[alexukie]

Just wanted to update everyone - we have finally installed Sphinx:

NOW the search takes about half a second, comparing to 20-30 seconds.. so it is 60 times faster now..

We are happy campers

Alex

[RussH]

what was the problem?

[oneupweb]

I have installed Sphinx on my Windows server using Cygwin and get the same "Sphinx Error: Connection to localhost:3312 failed" error. The setup for a Windows machine does not seem to work very well following the instructions provided. Anyone have a fix for this type of error?

[RussH]

I have installed Sphinx on my Windows server using Cygwin and get the same "Sphinx Error: Connection to localhost:3312 failed" error. The setup for a Windows machine does not seem to work very well following the instructions provided. Anyone have a fix for this type of error?

Hiya,

did you use the package to install sphinx?
http://www.opencats.org/downloads/setup ... gTools.exe

Although I'm not terribly familiar with cygwin it sounds as though the sphinx daemon isn't running - try navigating to the directory where the binary is, and start it manually by typing ./searchd