Mark H. Posted August 8, 2009 Posted August 8, 2009 I'm seeing something that I believe relates to the changes made in search, and are now reflected in the Sphinx config file. The search_delta files in the generated config file for 3.0.2 have different names from those in v3.0.1, and that's not being reflected in the docs page. You're listing "forums_search_delta" as one index in the above example docs linked by pollywogs or attached by Matt, but v3.0.2 doesn't use any index by that name. We need an updated list of the index names to use. EDIT: After looking at the conf file, it appears the "forums_search_delta" has been dropped, and these two are now used: forums_search_posts_delta forums_search_topics_delta I'm adjusting my cron jobs....
pollywogs Posted August 8, 2009 Posted August 8, 2009 So seems like there is no such index, therefore it isn't working. Also I tried changing my sql_port to 3312 in my data source definitions, but no luck with that either. It appears as if somewhere those indexes weren't created, but the forums are looking for them while searching.root@server:~# /usr/local/bin/indexer --config /var/www/domain/forums/sphi nx.conf core_search_delta members_search_delta forums_search_posts_delta forums _search_topics_delta --rotate Sphinx 0.9.8.1-release (r1533) Copyright © 2001-2008, Andrew Aksyonoff using config file '/var/www/domain/forums/sphinx.conf'... indexing index 'core_search_delta'... collected 0 docs, 0.0 MB total 0 docs, 0 bytes total 0.010 sec, 0.00 bytes/sec, 0.00 docs/sec indexing index 'members_search_delta'... collected 335 docs, 0.0 MB collected 0 attr values sorted 0.0 Mvalues, 100.0% done sorted 0.0 Mhits, 100.0% done total 335 docs, 12315 bytes total 0.010 sec, 1231500.00 bytes/sec, 33500.00 docs/sec WARNING: no such index 'forums_search_posts_delta', skipping. WARNING: no such index 'forums_search_topics_delta', skipping. rotating indices: succesfully sent SIGHUP to searchd (pid=10001). root@server:~#
Mark H. Posted August 8, 2009 Posted August 8, 2009 You added those two new index names to the CRON job, didn't you? I did that earlier and it works great now. Assuming you have Blog, Downloads, and Gallery installed, this would be the new list for the cron job: core_search_delta forums_search_posts_delta forums_search_topics_delta members_search_delta downloads_search_delta gallery_search_delta calendar_search_delta blog_search_delta If Board only, this should be the list: core_search_delta forums_search_posts_delta forums_search_topics_delta members_search_delta calendar_search_delta
pollywogs Posted August 8, 2009 Posted August 8, 2009 But it can't do anything if there are no indexes on the server <_<
Mark H. Posted August 8, 2009 Posted August 8, 2009 To create the indexes, you have to run the second cron job manually from an SSH commandline: /usr/local/bin/indexer --config /path/to/sphinx.conf --all --rotate Adjust your path as necessary, but when you run that the indexes are created if they don't exist.
.om Posted August 8, 2009 Posted August 8, 2009 I am getting a "No results found for" error after running [root@server1 ~]# /usr/local/bin/indexer --config /usr/sphinx-0.9.8.1/sphinx.con f --all --rotate Sphinx 0.9.8.1-release (r1533) Copyright © 2001-2008, Andrew Aksyonoff using config file '/usr/sphinx-0.9.8.1/sphinx.conf'... indexing index 'core_search_main'... collected 29 docs, 0.1 MB sorted 0.0 Mhits, 100.0% done total 29 docs, 65460 bytes total 0.019 sec, 3398224.70 bytes/sec, 1505.48 docs/sec indexing index 'core_search_delta'... collected 0 docs, 0.0 MB total 0 docs, 0 bytes total 0.010 sec, 0.00 bytes/sec, 0.00 docs/sec indexing index 'members_search_main'... collected 33892 docs, 1.3 MB collected 0 attr values sorted 0.1 Mvalues, 100.0% done sorted 0.2 Mhits, 100.0% done total 33892 docs, 1326918 bytes total 4.247 sec, 312413.24 bytes/sec, 7979.63 docs/sec indexing index 'members_search_delta'... collected 0 docs, 0.0 MB collected 0 attr values sorted 0.0 Mvalues, nan% done total 0 docs, 0 bytes total 0.010 sec, 0.00 bytes/sec, 0.00 docs/sec indexing index 'forums_search_posts_main'... collected 437053 docs, 337.0 MB collected 0 attr values sorted 3.7 Mvalues, 100.0% done sorted 49.7 Mhits, 100.0% done total 437053 docs, 336978309 bytes total 86.139 sec, 3912011.83 bytes/sec, 5073.79 docs/sec indexing index 'forums_search_posts_delta'... collected 1 docs, 0.0 MB collected 0 attr values sorted 0.0 Mvalues, 100.0% done sorted 0.0 Mhits, 100.0% done total 1 docs, 391 bytes total 0.010 sec, 39100.00 bytes/sec, 100.00 docs/sec indexing index 'forums_search_topics_main'... collected 112870 docs, 4.2 MB collected 0 attr values sorted 1.1 Mvalues, 100.0% done sorted 0.7 Mhits, 100.0% done total 112870 docs, 4235996 bytes total 9.667 sec, 438171.84 bytes/sec, 11675.28 docs/sec indexing index 'forums_search_topics_delta'... collected 0 docs, 0.0 MB collected 0 attr values sorted 0.0 Mvalues, nan% done total 0 docs, 0 bytes total 0.010 sec, 0.00 bytes/sec, 0.00 docs/sec indexing index 'calendar_search_main'... collected 2 docs, 0.0 MB collected 0 attr values sorted 0.0 Mvalues, 100.0% done sorted 0.0 Mhits, 100.0% done total 2 docs, 132 bytes total 0.010 sec, 13200.00 bytes/sec, 200.00 docs/sec indexing index 'calendar_search_delta'... collected 0 docs, 0.0 MB collected 0 attr values sorted 0.0 Mvalues, nan% done total 0 docs, 0 bytes total 0.010 sec, 0.00 bytes/sec, 0.00 docs/sec indexing index 'downloads_search_main'... collected 422 docs, 0.2 MB collected 0 attr values sorted 0.0 Mvalues, 100.0% done sorted 0.0 Mhits, 100.0% done total 422 docs, 178070 bytes total 0.047 sec, 3804528.51 bytes/sec, 9016.18 docs/sec indexing index 'downloads_search_delta'... collected 0 docs, 0.0 MB collected 0 attr values sorted 0.0 Mvalues, nan% done total 0 docs, 0 bytes total 0.010 sec, 0.00 bytes/sec, 0.00 docs/sec rotating indices: succesfully sent SIGHUP to searchd (pid=31094).
pollywogs Posted August 8, 2009 Posted August 8, 2009 Okay I finally figured out the problem. I made my sphinx.conf file WHILE upgrading, and apparently it still grabbed the 3.0.1 file :( Now I ran killall searchd and started over, utilizing the changes you have specified. All is well now, thanks for the assistance! ;) EDIT @ .om: You have you killall searchd, then run: ...after uploading the new sphinx.conf of course :P and don't forget to update your crontab too!/usr/local/bin/indexer --config /path/to/sphinx.conf --all then: /usr/local/bin/searchd --config /path/to/sphinx.conf
.om Posted August 8, 2009 Posted August 8, 2009 damn...someone shoot me...I did update with the new sphinx.conf file...but forgot to re launch it....darn! hmm I am getting this error[root@server1 usr]# /usr/local/bin/indexer --config /usr/sphinx-0.9.8.1/sphinx.conf forums_search_posts_delta --rotate Sphinx 0.9.8.1-release (r1533) Copyright © 2001-2008, Andrew Aksyonoff using config file '/usr/sphinx-0.9.8.1/sphinx.conf'... indexing index 'forums_search_posts_delta'... collected 0 docs, 0.0 MB collected 0 attr values sorted 0.0 Mvalues, nan% done total 0 docs, 0 bytes total 0.010 sec, 0.00 bytes/sec, 0.00 docs/sec rotating indices: succesfully sent SIGHUP to searchd (pid=17785). [root@server1 usr]# killall searchd [root@server1 usr]# /usr/local/bin/searchd --config /usr/sphinx-0.9.8.1/sphinx.conf Sphinx 0.9.8.1-release (r1533) Copyright © 2001-2008, Andrew Aksyonoff using config file '/usr/sphinx-0.9.8.1/sphinx.conf'... creating server socket on 127.0.0.1:3312 WARNING: index 'forums_search_posts_main': preload: failed to open /var/sphinx/forums_search_posts_main.sph: No such file or directory; NOT SERVING
Mark H. Posted August 8, 2009 Posted August 8, 2009 I believe you have an error in this line: /usr/local/bin/indexer --config /usr/sphinx-0.9.8.1/sphinx.conf forums_search_posts_delta --rotate It should be: /usr/local/bin/indexer --config /usr/sphinx-0.9.8.1/sphinx.conf --all --rotate Run the above line first, then run this command: /usr/local/bin/indexer --config /usr/sphinx-0.9.8.1/sphinx.conf core_search_delta forums_search_posts_delta forums_search_topics_delta members_search_delta downloads_search_delta gallery_search_delta calendar_search_delta blog_search_delta --rotate *OR*, if you don't have Blog, Gallery, and Download, run this line instead: /usr/local/bin/indexer --config /usr/sphinx-0.9.8.1/sphinx.conf core_search_delta forums_search_posts_delta forums_search_topics_delta members_search_delta calendar_search_delta --rotate Then, the two cron jobs you'd need to add would be: First: 0 3 * * * /usr/local/bin/indexer --config /usr/sphinx-0.9.8.1/sphinx.conf --all --rotate > /dev/null 2>&1 Second: */15 * * * * /usr/local/bin/indexer --config /usr/sphinx-0.9.8.1/sphinx.conf core_search_delta forums_search_posts_delta forums_search_topics_delta members_search_delta downloads_search_delta gallery_search_delta calendar_search_delta blog_search_delta --rotate > /dev/null 2>&1 *OR* if no Blog, Gallery, Downloads: */15 * * * * /usr/local/bin/indexer --config /usr/sphinx-0.9.8.1/sphinx.conf core_search_delta forums_search_posts_delta forums_search_topics_delta members_search_delta calendar_search_delta --rotate > /dev/null 2>&1 Hope that gets you going....
.om Posted August 8, 2009 Posted August 8, 2009 well this is my log...the search results still show "No results found for". Do I need to reinstall sphinx all over again? Doesnt simply chaning the sphinx.conf and re launch the search daemon suffix the issue at hand?[root@server1 ~]# /usr/local/bin/indexer --config /usr/sphinx-0.9.8.1/sphinx.con f --all --rotate Sphinx 0.9.8.1-release (r1533) Copyright © 2001-2008, Andrew Aksyonoff using config file '/usr/sphinx-0.9.8.1/sphinx.conf'... indexing index 'core_search_main'... collected 29 docs, 0.1 MB sorted 0.0 Mhits, 100.0% done total 29 docs, 65460 bytes total 0.030 sec, 2152793.74 bytes/sec, 953.73 docs/sec indexing index 'core_search_delta'... collected 0 docs, 0.0 MB total 0 docs, 0 bytes total 0.010 sec, 0.00 bytes/sec, 0.00 docs/sec indexing index 'members_search_main'... collected 33895 docs, 1.3 MB collected 0 attr values sorted 0.1 Mvalues, 100.0% done sorted 0.2 Mhits, 100.0% done total 33895 docs, 1327025 bytes total 4.727 sec, 280747.03 bytes/sec, 7170.87 docs/sec indexing index 'members_search_delta'... collected 0 docs, 0.0 MB collected 0 attr values sorted 0.0 Mvalues, nan% done total 0 docs, 0 bytes total 0.010 sec, 0.00 bytes/sec, 0.00 docs/sec indexing index 'forums_search_posts_main'... collected 437108 docs, 337.0 MB collected 0 attr values sorted 3.7 Mvalues, 100.0% done sorted 49.7 Mhits, 100.0% done total 437108 docs, 337042072 bytes total 95.126 sec, 3543119.69 bytes/sec, 4595.05 docs/sec indexing index 'forums_search_posts_delta'... collected 0 docs, 0.0 MB collected 0 attr values sorted 0.0 Mvalues, nan% done total 0 docs, 0 bytes total 0.010 sec, 0.00 bytes/sec, 0.00 docs/sec indexing index 'forums_search_topics_main'... collected 112908 docs, 4.2 MB collected 0 attr values sorted 1.1 Mvalues, 100.0% done sorted 0.7 Mhits, 100.0% done total 112908 docs, 4237453 bytes total 8.334 sec, 508461.56 bytes/sec, 13548.09 docs/sec indexing index 'forums_search_topics_delta'... collected 0 docs, 0.0 MB collected 0 attr values sorted 0.0 Mvalues, nan% done total 0 docs, 0 bytes total 0.010 sec, 0.00 bytes/sec, 0.00 docs/sec indexing index 'calendar_search_main'... collected 2 docs, 0.0 MB collected 0 attr values sorted 0.0 Mvalues, 100.0% done sorted 0.0 Mhits, 100.0% done total 2 docs, 132 bytes total 0.010 sec, 13200.00 bytes/sec, 200.00 docs/sec indexing index 'calendar_search_delta'... collected 0 docs, 0.0 MB collected 0 attr values sorted 0.0 Mvalues, nan% done total 0 docs, 0 bytes total 0.010 sec, 0.00 bytes/sec, 0.00 docs/sec indexing index 'downloads_search_main'... collected 422 docs, 0.2 MB collected 0 attr values sorted 0.0 Mvalues, 100.0% done sorted 0.0 Mhits, 100.0% done total 422 docs, 178070 bytes total 0.045 sec, 3920174.41 bytes/sec, 9290.24 docs/sec indexing index 'downloads_search_delta'... collected 0 docs, 0.0 MB collected 0 attr values sorted 0.0 Mvalues, nan% done total 0 docs, 0 bytes total 0.010 sec, 0.00 bytes/sec, 0.00 docs/sec rotating indices: succesfully sent SIGHUP to searchd (pid=18545). [root@server1 ~]# /usr/local/bin/indexer --config /usr/sphinx-0.9.8.1/sphinx.conf core_search_delta forums_search_posts_delta forums_search_topics_delta members_search_delta calendar_search_delta --rotate Sphinx 0.9.8.1-release (r1533) Copyright © 2001-2008, Andrew Aksyonoff using config file '/usr/sphinx-0.9.8.1/sphinx.conf'... indexing index 'core_search_delta'... collected 0 docs, 0.0 MB total 0 docs, 0 bytes total 0.010 sec, 0.00 bytes/sec, 0.00 docs/sec indexing index 'forums_search_posts_delta'... collected 0 docs, 0.0 MB collected 0 attr values sorted 0.0 Mvalues, nan% done total 0 docs, 0 bytes total 0.010 sec, 0.00 bytes/sec, 0.00 docs/sec indexing index 'forums_search_topics_delta'... collected 0 docs, 0.0 MB collected 0 attr values sorted 0.0 Mvalues, nan% done total 0 docs, 0 bytes total 0.010 sec, 0.00 bytes/sec, 0.00 docs/sec indexing index 'members_search_delta'... collected 0 docs, 0.0 MB collected 0 attr values sorted 0.0 Mvalues, nan% done total 0 docs, 0 bytes total 0.010 sec, 0.00 bytes/sec, 0.00 docs/sec indexing index 'calendar_search_delta'... collected 0 docs, 0.0 MB collected 0 attr values sorted 0.0 Mvalues, nan% done total 0 docs, 0 bytes total 0.010 sec, 0.00 bytes/sec, 0.00 docs/sec rotating indices: succesfully sent SIGHUP to searchd (pid=18545).
Mark H. Posted August 8, 2009 Posted August 8, 2009 Yes, editing the sphinx.conf file to make sure the ports are correct, then manually running both commands in the listed order, *should* be all you need to do. That's what worked for me. Your logs indicate no errors. But they also indicate that the routine found *NO* data to process. Odd.... At this point, I'd open a Support ticket if I were you. EDIT: I just noticed your first command. It looks garbled. It should be: /usr/local/bin/indexer --config /usr/sphinx-0.9.8.1/sphinx.conf --all --rotate THEN run: /usr/local/bin/indexer --config /usr/sphinx-0.9.8.1/sphinx.conf core_search_delta forums_search_posts_delta forums_search_topics_delta members_search_delta calendar_search_delta --rotate
.om Posted August 9, 2009 Posted August 9, 2009 hmmm did what you said...but somehow I am left at the same spot.[root@server1 ~]# /usr/local/bin/indexer --config /usr/sphinx-0.9.8.1/sphinx.conf --all --rotate Sphinx 0.9.8.1-release (r1533) Copyright © 2001-2008, Andrew Aksyonoff using config file '/usr/sphinx-0.9.8.1/sphinx.conf'... indexing index 'core_search_main'... collected 29 docs, 0.1 MB sorted 0.0 Mhits, 100.0% done total 29 docs, 65460 bytes total 0.019 sec, 3520301.02 bytes/sec, 1559.56 docs/sec indexing index 'core_search_delta'... collected 0 docs, 0.0 MB total 0 docs, 0 bytes total 0.010 sec, 0.00 bytes/sec, 0.00 docs/sec indexing index 'members_search_main'... collected 33903 docs, 1.3 MB collected 0 attr values sorted 0.1 Mvalues, 100.0% done sorted 0.2 Mhits, 100.0% done total 33903 docs, 1327360 bytes total 4.954 sec, 267958.76 bytes/sec, 6844.12 docs/sec indexing index 'members_search_delta'... collected 0 docs, 0.0 MB collected 0 attr values sorted 0.0 Mvalues, nan% done total 0 docs, 0 bytes total 0.010 sec, 0.00 bytes/sec, 0.00 docs/sec indexing index 'forums_search_posts_main'... collected 437258 docs, 337.2 MB collected 0 attr values sorted 3.7 Mvalues, 100.0% done sorted 49.8 Mhits, 100.0% done total 437258 docs, 337175013 bytes total 81.729 sec, 4125540.74 bytes/sec, 5350.12 docs/sec indexing index 'forums_search_posts_delta'... collected 0 docs, 0.0 MB collected 0 attr values sorted 0.0 Mvalues, nan% done total 0 docs, 0 bytes total 0.010 sec, 0.00 bytes/sec, 0.00 docs/sec indexing index 'forums_search_topics_main'... collected 113018 docs, 4.2 MB collected 0 attr values sorted 1.1 Mvalues, 100.0% done sorted 0.7 Mhits, 100.0% done total 113018 docs, 4242924 bytes total 9.865 sec, 430083.90 bytes/sec, 11456.07 docs/sec indexing index 'forums_search_topics_delta'... collected 0 docs, 0.0 MB collected 0 attr values sorted 0.0 Mvalues, nan% done total 0 docs, 0 bytes total 0.010 sec, 0.00 bytes/sec, 0.00 docs/sec indexing index 'calendar_search_main'... collected 2 docs, 0.0 MB collected 0 attr values sorted 0.0 Mvalues, 100.0% done sorted 0.0 Mhits, 100.0% done total 2 docs, 132 bytes total 0.010 sec, 13200.00 bytes/sec, 200.00 docs/sec indexing index 'calendar_search_delta'... collected 0 docs, 0.0 MB collected 0 attr values sorted 0.0 Mvalues, nan% done total 0 docs, 0 bytes total 0.010 sec, 0.00 bytes/sec, 0.00 docs/sec indexing index 'downloads_search_main'... collected 422 docs, 0.2 MB collected 0 attr values sorted 0.0 Mvalues, 100.0% done sorted 0.0 Mhits, 100.0% done total 422 docs, 178079 bytes total 0.045 sec, 3931019.11 bytes/sec, 9315.47 docs/sec indexing index 'downloads_search_delta'... collected 0 docs, 0.0 MB collected 0 attr values sorted 0.0 Mvalues, nan% done total 0 docs, 0 bytes total 0.010 sec, 0.00 bytes/sec, 0.00 docs/sec rotating indices: succesfully sent SIGHUP to searchd (pid=18545). [root@server1 ~]# /usr/local/bin/indexer --config /usr/sphinx-0.9.8.1/sphinx.conf core_search_delta forums_search_posts_delta forums_search_topics_delta members_search_delta calendar_search_delta --rotate Sphinx 0.9.8.1-release (r1533) Copyright © 2001-2008, Andrew Aksyonoff using config file '/usr/sphinx-0.9.8.1/sphinx.conf'... indexing index 'core_search_delta'... collected 0 docs, 0.0 MB total 0 docs, 0 bytes total 0.010 sec, 0.00 bytes/sec, 0.00 docs/sec indexing index 'forums_search_posts_delta'... collected 0 docs, 0.0 MB collected 0 attr values sorted 0.0 Mvalues, nan% done total 0 docs, 0 bytes total 0.010 sec, 0.00 bytes/sec, 0.00 docs/sec indexing index 'forums_search_topics_delta'... collected 0 docs, 0.0 MB collected 0 attr values sorted 0.0 Mvalues, nan% done total 0 docs, 0 bytes total 0.010 sec, 0.00 bytes/sec, 0.00 docs/sec indexing index 'members_search_delta'... collected 0 docs, 0.0 MB collected 0 attr values sorted 0.0 Mvalues, nan% done total 0 docs, 0 bytes total 0.010 sec, 0.00 bytes/sec, 0.00 docs/sec indexing index 'calendar_search_delta'... collected 0 docs, 0.0 MB collected 0 attr values sorted 0.0 Mvalues, nan% done total 0 docs, 0 bytes total 0.010 sec, 0.00 bytes/sec, 0.00 docs/sec rotating indices: succesfully sent SIGHUP to searchd (pid=18545).
Mark H. Posted August 9, 2009 Posted August 9, 2009 Well, I'm out of ideas then. About all I can think of at this point, is a permissions issue. The user account calling the Sphinx processes *DOES* have rights to /user/local/bin and /usr/sphinx-0.9.8.1/, correct?? If so, then definitely time for a Support ticket. Without seeing your actual data and layout myself, I can't think of anything more than that. My setup is different than yours, as far as directories for the config files and Sphinx indexer, but the mechanics of it are identical.
bfarber Posted August 10, 2009 Posted August 10, 2009 For those wondering, the resources article is slightly out of date now that 3.0.2 was released. In 3.0.1 we had forums_search_main and forums_search_delta, but in doing so there was no way to search just posts or just topics, so the index had to be split into 2 (4, once you factor in the deltas). I will update the resource article as soon as I get a chance. @.om - Sphinx is finding your topics and posts (the first command gives this): [code]indexing index 'forums_search_posts_main'... collected 437258 docs, 337.2 MB collected 0 attr values sorted 3.7 Mvalues, 100.0% done sorted 49.8 Mhits, 100.0% done total 437258 docs, 337175013 bytes total 81.729 sec, 4125540.74 bytes/sec, 5350.12 docs/sec ... indexing index 'forums_search_topics_main'... collected 113018 docs, 4.2 MB collected 0 attr values sorted 1.1 Mvalues, 100.0% done sorted 0.7 Mhits, 100.0% done total 113018 docs, 4242924 bytes total 9.865 sec, 430083.90 bytes/sec, 11456.07 docs/sec[/code] When you just ran the main process, there will be nothing in the delta (since all the topics and posts are already indexed). Did you try to run a search afterwards? You should probably submit a ticket if you're getting no results at that point.
AtariAge Posted August 13, 2009 Posted August 13, 2009 I'd like to setup Sphinx on my 3.0.2 test forum to make sure it works properly before I migrate from 2.3.6. Can anyone tell me what I need to do differently from [url=http://resources.invisionpower.com/index.php?appcomponent=cms&module=articles&article=7813]this article[/url] so I can get it up and running without pulling my hair out? I'm running Sphinx on 2.3.6 now, so I am pretty familiar with it already. Thanks, ..Al
Nimdock Posted August 13, 2009 Posted August 13, 2009 [quote name='AtariAge' date='13 August 2009 - 07:22 PM' timestamp='1250205755' post='1843436'] I'd like to setup Sphinx on my 3.0.2 test forum to make sure it works properly before I migrate from 2.3.6. Can anyone tell me what I need to do differently from [url=http://resources.invisionpower.com/index.php?appcomponent=cms&module=articles&article=7813]this article[/url] so I can get it up and running without pulling my hair out? I'm running Sphinx on 2.3.6 now, so I am pretty familiar with it already. Thanks, ..Al [/quote] I also would like to know this.
Mark H. Posted August 14, 2009 Posted August 14, 2009 There's at least one change to that article that hasn't been updated yet. Brandon's been just a little busy lately. Everywhere it says to use [i]forums_search_delta[/i], you have to remove that, and replace it with *TWO* new names: [i]forums_search_posts_delta[/i] and [i]forums_search_topics_delta[/i]. Once I did this with my install, it worked perfectly.
AtariAge Posted August 14, 2009 Posted August 14, 2009 [quote name='RainbowViper' date='13 August 2009 - 10:55 PM' timestamp='1250222116' post='1843505'] There's at least one change to that article that hasn't been updated. Anywhere it says to use "forums_search_delta", you have to remove that, and replace it with *two* new names, "forums_search_posts_delta" and "forums_search_topics_delta". [/quote] Thanks, I'll try that tomorrow and see how I make out. When you say "at least one change", are there changes other than the search and replace you described here? ..Al
Mark H. Posted August 14, 2009 Posted August 14, 2009 Not that I've found. I added that as a caveat more than anything else. It's worked great so far, though it's only been used on test installs. And I did a Sphinx install in a shared configuration for multiple Domains (which DOES work fine) on my dedi , so my configuration, paths, and filenames are a bit different than typical I think.
AtariAge Posted August 14, 2009 Posted August 14, 2009 [quote name='RainbowViper' date='13 August 2009 - 11:04 PM' timestamp='1250222699' post='1843510'] Not that I've found. I added that as a caveat more than anything else. It's worked great so far, though it's only been used on test installs. [/quote] That's good to hear, thanks. [quote]And I did a Sphinx install in a shared configuration for multiple Domains (which DOES work fine) on my dedi , so my configuration, paths, and filenames are a bit different than typical I think. [/quote] That is what I'll be doing--I have my test forum hidden away on another domain (atariage.org instead of atariage.com), but on the same dedicated server. ..Al
Mark H. Posted August 14, 2009 Posted August 14, 2009 OK, good. Just remember you have to launch the searchd process for each domain using it, and use different ports for each install as well. Took a bit of head-scratching before I got that part just right.
ᴡᴅツ Posted August 14, 2009 Posted August 14, 2009 Do you notice a difference with Sphinx on the front-end besides a performance boost such as visuals? Is one of the opportunities this offers is to search 3 letter words?
bfarber Posted August 14, 2009 Posted August 14, 2009 [quote name='AtariAge' date='13 August 2009 - 07:22 PM' timestamp='1250205755' post='1843436'] I'd like to setup Sphinx on my 3.0.2 test forum to make sure it works properly before I migrate from 2.3.6. Can anyone tell me what I need to do differently from [url=http://resources.invisionpower.com/index.php?appcomponent=cms&module=articles&article=7813]this article[/url] so I can get it up and running without pulling my hair out? I'm running Sphinx on 2.3.6 now, so I am pretty familiar with it already. Thanks, ..Al [/quote] I've updated the article now. The change RainbowViper pointed out is the only change you need to note (I clarified the part about the "delta" index rebuilding slightly, but it doesn't change the actual steps for installation). [quote name='Archon Neo' date='14 August 2009 - 05:05 AM' timestamp='1250240719' post='1843558'] Do you notice a difference with Sphinx on the front-end besides a performance boost such as visuals? Is one of the opportunities this offers is to search 3 letter words? [/quote] By default it supports 3 letter searches, yes. You can alter the configuration file to set it however you want (i.e. allow 2 character searches, for example). For the most part, use of Sphinx vs MySQL should be fully transparent to the end user.
AtariAge Posted August 14, 2009 Posted August 14, 2009 [quote name='bfarber' date='14 August 2009 - 09:52 AM' timestamp='1250261525' post='1843656'] I've updated the article now. The change RainbowViper pointed out is the only change you need to note (I clarified the part about the "delta" index rebuilding slightly, but it doesn't change the actual steps for installation).[/quote] Thanks! Going to set this up shortly. [quote]By default it supports 3 letter searches, yes. You can alter the configuration file to set it however you want (i.e. allow 2 character searches, for example). For the most part, use of Sphinx vs MySQL should be fully transparent to the end user. [/quote] I'm running two character searches on my 2.3.6 forum, which has been very helpful. We actually have several relevant search terms that would otherwise be difficult to search for ("Qb" - Atari 2600 homebrew game, "ST" as in "Atari ST", and so forth..) I really wish you guys would install Sphinx here and enable three character searches, as it's really difficult to search for some terms here (such as "GDK"). ..Al
Mark H. Posted August 14, 2009 Posted August 14, 2009 @Archon Neo: Sphinx allows a very busy Forum to offload its searches, which can make a huge difference *if* your members are using the search feature a lot. @Atari Age: Quite right, a number of our favorite acronyms are only two letters. I set it for 2-character searches as well.
Recommended Posts
Archived
This topic is now archived and is closed to further replies.