Register Members List Search Today's Posts Mark Forums Read

Reply
 
Thread Tools
  #721  
Old 21 Oct 2009, 15:54
UK Jimbo's Avatar
UK Jimbo UK Jimbo is offline
 
Join Date: Sep 2002
Originally Posted by Raun View Post
If I were to install it on both DBs would that work the same as copying the indexes?
There are two separate parts of using Sphinx.
  • Indexing (building up your index of data from the database)
  • Serving results with searchd

If you were able to serve results from either of the two machines then you'd be able to balance some of the load and also handle a failure of one of the instances.

To save processing time it should be quicker to index on one of the two machines and then copy the indexes across. The alternative is to have each of the machines create their own index which will use more processing power.
__________________
administrator: visordown.com
Reply With Quote
  #722  
Old 21 Oct 2009, 16:33
Raun Raun is offline
 
Join Date: Mar 2009
Sorry for all the noob questions but I am a little new to this.

Once sphinx is installed on the DB and the config is setup how is it hooked into vb to serve the results there? Is that built into the config somewhere? Do I need to install anything else to get the results served?
Reply With Quote
  #723  
Old 29 Oct 2009, 22:46
abuthabit abuthabit is offline
 
Join Date: Jul 2006
Hello

sphinx installed in our forums and it works fine.. but when you type something that it's not included in the index for example " jkbljkhbjk" We got error as below

FireFox:
Content Encoding Error

The page you are trying to view cannot be shown because it uses an invalid or unsupported form of compression.
* Please contact the website owners to inform them of this problem.

Safari

Safari can’t open the page.
Safari can’t open the page “http://www.****.com/ee/search.php?do=process”. The error is: “cannot decode raw data”

IE8
IE can't display this webpage

No errors in the log: lightty .. Mysql .. sphinx logs

sphinx/query.log :
[Fri Oct 30 01:36:31.808 2009] 0.000 sec [all/0/attr- 0 (0,500)] [threadtitles] jkbljkhbjk

Installation guide from the following post
http://www.vbulletin.org/forum/showp...postcount=3877

How could I fix this issue?

Last edited by abuthabit; 29 Oct 2009 at 23:03.
Reply With Quote
  #724  
Old 30 Oct 2009, 07:49
profanitytalker's Avatar
profanitytalker profanitytalker is offline
 
Join Date: Nov 2006
Can someone send me their edited search.php file? Mine won't work. I get confused by the last line of the edit...


Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.

Where do I add the "#"?
Reply With Quote
  #725  
Old 31 Oct 2009, 10:35
abuthabit abuthabit is offline
 
Join Date: Jul 2006
Originally Posted by profanitytalker View Post
Can someone send me their edited search.php file? Mine won't work. I get confused by the last line of the edit...


Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.

Where do I add the "#"?
This line:
unset($datecut);

add # before unset in the same line

so it should be like this

#unset($datecut);
Reply With Quote
  #726  
Old 13 Nov 2009, 22:53
cobaku cobaku is offline
 
Join Date: Oct 2005
This thing is too hard to set up. I have failed on my 10th try again.

ssh search works just fine

but search.php rejects to paste results to web !
i am guessing search_sphinx.php does not work on 3.8.4 which is my only guess

Anyone tried the new method on post #1 on 3.8.4 ? send search_sphinx.php pls.

Vbulletin Sphinx plugin is sold for 2000$
Reply With Quote
  #727  
Old 05 Dec 2009, 15:26
ATForums ATForums is offline
 
Join Date: Oct 2009
Hi,

Using this with great success - trying to allow 3 char words. I have changed sphinx to include 3 chars ("wii") and results are returned from the CLI, so Sphinx seems OK.

But, in VB, I always get a no results message when I search for "wii" - I changed the min search size in VB Options to 3, but it doesn't help.

Any ideas?

John

--------------- Added 05 Dec 2009 at 16:01 ---------------

Originally Posted by ATForums View Post
Hi,

Using this with great success - trying to allow 3 char words. I have changed sphinx to include 3 chars ("wii") and results are returned from the CLI, so Sphinx seems OK.

But, in VB, I always get a no results message when I search for "wii" - I changed the min search size in VB Options to 3, but it doesn't help.

Any ideas?

John
Err...stupid me....I needed to restart searchd....did that and now all is well...

Thought all I had to do was rebuild indexes...

John

Last edited by ATForums; 05 Dec 2009 at 16:01. Reason: Auto-Merged DoublePost
Reply With Quote
  #728  
Old 10 Dec 2009, 20:23
RedWingFan's Avatar
RedWingFan RedWingFan is offline
 
Join Date: Oct 2004
Sphinx 0.9.9-Stable is now out. I just compiled it on our dedicated box, killed and restarted searchd, and am rebuilding the indexes. So far, so good! I will have to wait until next month to see what new parameters I can work with to optimize it further (I'm under the gun for a paying job right now...gotta take the money while I can!)
__________________
-= N =-
Reply With Quote
  #729  
Old 22 Dec 2009, 20:15
ivanp ivanp is offline
 
Join Date: Sep 2007
Is there any update for this plugin for vBulletin 4?
Reply With Quote
  #730  
Old 22 Dec 2009, 20:29
columbusgeek's Avatar
columbusgeek columbusgeek is offline
 
Join Date: Sep 2007
Is there any update for this plugin for vBulletin 4?
vB4 has been gold for less the 24 hours now. Are you serious?
Reply With Quote
  #731  
Old 29 Dec 2009, 19:19
kontrabass kontrabass is offline
 
Join Date: Feb 2002
I'm going to get some guys on this - VB4.0's search is way too slow for our forum of 5M posts. It'll take us some time though, we just started playing around with 4.0 in a test enviro. Floren's commercial sphinx solution (Searchlight) will have 4.0 support in the future as well.
Reply With Quote
  #732  
Old 29 Dec 2009, 19:48
RedWingFan's Avatar
RedWingFan RedWingFan is offline
 
Join Date: Oct 2004
We have close to 4.5 million posts, and even in our private test board with only around 170,000 posts, search drags. I can't see going back to MySQL fulltext search any time soon. (Plus, there are too many other issues with 4.0 that will keep us from upgrading for quite a few months.)
__________________
-= N =-
Reply With Quote
  #733  
Old 29 Dec 2009, 20:00
snakes1100 snakes1100 is offline
 
Join Date: Dec 2001
Real name: Anthony
Originally Posted by RedWingFan View Post
We have close to 4.5 million posts, and even in our private test board with only around 170,000 posts, search drags. I can't see going back to MySQL fulltext search any time soon. (Plus, there are too many other issues with 4.0 that will keep us from upgrading for quite a few months.)
I'd guess it's those Sheep wondering over from Novi & clogging your server up w/ wool!
Reply With Quote
  #734  
Old 29 Dec 2009, 21:24
RedWingFan's Avatar
RedWingFan RedWingFan is offline
 
Join Date: Oct 2004
Originally Posted by snakes1100 View Post
I'd guess it's those Sheep wondering over from Novi & clogging your server up w/ wool!
True dat!



--------------- Added 29 Dec 2009 at 21:32 ---------------

P.S. I'd blame the Steelers, actually--our server is in Pittsburgh. It's just the boneheaded server admin who lives near the Sheep...erm, Whalers, Dead Wings, etc.
__________________
-= N =-

Last edited by RedWingFan; 29 Dec 2009 at 21:32. Reason: Auto-Merged DoublePost
Reply With Quote
  #735  
Old 02 Jan 2010, 14:19
eoc_Jason's Avatar
eoc_Jason eoc_Jason is offline
 
Join Date: Dec 2001
Yeah, but for most of us Searchlight is not very affordable...

I'm still super pissed at Jelsoft for not having any sort of sphinx plug-in / switch for vB 4.0... From all the previous development talk I was led to believe they were going to implement it (finally)...

It's like they don't really care about the big boards... They are implementing all these other crazy features that maybe 0.2% of people *might* use, but not taking a hard look at the core of their product... *sigh*

I'm about to install vB 4.0 on my test server. At the very least I'm going to try and code sphinx for the basic search stuff. To standardize things I'm going to try and code it with the PECL::Sphinx library.
__________________
My Site: EXTREME Overclocking

Do not PM me with your iTrader problems or asking for the code. I will just delete your PM without reading it.
Reply With Quote
Reply



Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off


New To Site? Need Help?

All times are GMT. The time now is 06:01.

Layout Options | Width: Wide Color: