[Beta] Sphinx search for phpBB 1.0.beta2

A place for MOD Authors to post and receive feedback on MODs still in development. No MODs within this forum should be used within a live environment!
Ideas Centre
Locked
User avatar
naderman
Consultant
Consultant
Posts: 3736
Joined: Fri Aug 01, 2003 10:06 pm
Location: Berlin, Germany
Name: Nils Adermann
Contact:

Re: [ALPHA] Sphinx for phpBB

Post by naderman »

Ah alright, I'll look into that, thanks.
I appreciate gifts from my Amazon wishlist.
naderman.de twitter: @naderman
yais
Registered User
Posts: 306
Joined: Sun Jun 17, 2007 12:45 pm

Re: [ALPHA] Sphinx for phpBB

Post by yais »

I dont quite understand exactly how to install and integrate sphinx with phpbb3.

Can anyone explain?

thanks
xenador
Registered User
Posts: 89
Joined: Wed Nov 22, 2006 1:27 am

Re: [ALPHA] Sphinx for phpBB

Post by xenador »

from what it sounds like you have to have the sphinx installed on your server (generally compiled with apache etc...) then you have to allow it to index your board via an option in the acp, after that it should work. although this isn't even in its beta's yet...so for anything besides testing for development I probably wouldn't use it.
canadaka
Registered User
Posts: 88
Joined: Tue Apr 26, 2005 8:47 pm
Location: Vancouver, Canada
Contact:

Re: [ALPHA] Sphinx for phpBB

Post by canadaka »

this looks very interesting, I was reading about Sphinx so I did a search here and found this thread.

Some questions, if using Sphinx does that mean both the phpbb native search tables and the mysql fulltext indexs will remain empty?

Also will this mod care what platform Sphinx is running on? I run Windows Server/IIS, there is a Sphinx windows binary.

And finally, any updates on this progressing from alpha status?
Canada Kicks Ass
http://www.canadaka.net
User avatar
naderman
Consultant
Consultant
Posts: 3736
Joined: Fri Aug 01, 2003 10:06 pm
Location: Berlin, Germany
Name: Nils Adermann
Contact:

Re: [ALPHA] Sphinx for phpBB

Post by naderman »

canadaka wrote:Some questions, if using Sphinx does that mean both the phpbb native search tables and the mysql fulltext indexs will remain empty?
Yes
canadaka wrote:Also will this mod care what platform Sphinx is running on? I run Windows Server/IIS, there is a Sphinx windows binary.
I've only tested it on Linux myself. I'd be happy if you could try it on Windows and report problems on the bug tracker: http://code.phpbb.com/projects/11/issues
canadaka wrote:And finally, any updates on this progressing from alpha status?
It's on my todo list but I'm not currently able to give a date.
I appreciate gifts from my Amazon wishlist.
naderman.de twitter: @naderman
laric
Registered User
Posts: 5
Joined: Thu Sep 04, 2008 12:03 pm

Re: [ALPHA] Sphinx for phpBB

Post by laric »

Hello,

I'd like to revive a bit this thread... Are there any news ?

I'm running a pretty large forum (5 183 988 messages, 260 528 threads and about 100 000 users)
http://www.homecinema-fr.com/forum/

We are using phpbb since the early ages and had always strugle with the rather poor search/indexing tool.

I have successfully compiled and added the Sphinx engine as well as this Alpha mod (I'm on a dedicated server, using Debian and MySQL 5.0.45)
I know it is alpha code, but both MySQL fulltext and native method were killing us.

So far it works pretty well, but requires quite some manual things (change the tidying, add merge or re-index, etc...)
BTW, the search and indexing are now flying on the forum :D

Any chance we can have an updated version (I get mine from SVN about a week ago) ?

--Patrice
User avatar
naderman
Consultant
Consultant
Posts: 3736
Joined: Fri Aug 01, 2003 10:06 pm
Location: Berlin, Germany
Name: Nils Adermann
Contact:

Re: [ALPHA] Sphinx for phpBB

Post by naderman »

I have finally updated this plugin to work with Sphinx 0.9.8. Sphinx 0.9.7 is no longer supported. A few bugs have been fixed and some parts (especially author search) should have become a lot faster. This version also has live updates on edit and post deletion.

I have released this as sphinx4phpbb 1.0.beta1. Please report back whether it works well for you!

If you have been using a previous version of the plugin from svn you can simply do an svn update. You should upgrade to Sphinx 0.9.8 first however. While you do that you should disable the Plugin (simply select fulltext native as the backend). You will also have to delete and recreate the Sphinx index for it to work properly afterwards.
I appreciate gifts from my Amazon wishlist.
naderman.de twitter: @naderman
yais
Registered User
Posts: 306
Joined: Sun Jun 17, 2007 12:45 pm

Re: [Beta] Sphinx for phpBB 1.0.beta1

Post by yais »

I have tried testing it locally, but PHP's exec function has been disabled. Does anyone know how to enable it. Can't find what to change in the php.ini file.

also, you got the url wrong in the first post. it is:

http://www.sphinxsearch.com/
User avatar
oddfish
Registered User
Posts: 839
Joined: Mon Mar 19, 2007 8:45 pm
Location: Testing 3.1
Contact:

Re: [Beta] Sphinx for phpBB 1.0.beta1

Post by oddfish »

thanks naderman.

Can you please sort the search to correctly return an author's First post of topics only (advanced search).

currently, it returns all first posts (topics) that the author has entered a reply in.

that appears to be the only difference I can find at this stage between sphinx and native/mysql.

cheers,
oddfish.
Country Flag User Edition Clickable Post Count Link

... another record broken without breaking any records ...
Testing phpBB3.1 dark style based on prosilver ... http://www.oddmods.net
User avatar
naderman
Consultant
Consultant
Posts: 3736
Joined: Fri Aug 01, 2003 10:06 pm
Location: Berlin, Germany
Name: Nils Adermann
Contact:

Re: [Beta] Sphinx for phpBB 1.0.beta1

Post by naderman »

I'm not sure I understood you correctly. However there have been some issues with sorting that I fixed now, I will release Beta2 with some fixes from phpbb.com if all goes well now.
I appreciate gifts from my Amazon wishlist.
naderman.de twitter: @naderman
User avatar
naderman
Consultant
Consultant
Posts: 3736
Joined: Fri Aug 01, 2003 10:06 pm
Location: Berlin, Germany
Name: Nils Adermann
Contact:

Re: [Beta] Sphinx for phpBB 1.0.beta1

Post by naderman »

yais wrote:I have tried testing it locally, but PHP's exec function has been disabled. Does anyone know how to enable it. Can't find what to change in the php.ini file.
Normally there should be a line saying something like

Code: Select all

disable_functions = [some comma seperated functions], exec, [more functions]
You need to remove exec from that list and it should work.
yais wrote:also, you got the url wrong in the first post. it is:

http://www.sphinxsearch.com/
Thanks, fixed that.
I appreciate gifts from my Amazon wishlist.
naderman.de twitter: @naderman
User avatar
GoBieN
Registered User
Posts: 546
Joined: Fri Mar 05, 2004 5:22 pm
Location: Belgium
Contact:

Re: [Beta] Sphinx for phpBB 1.0.beta1

Post by GoBieN »

What would be the advantage of this plugin over the normal search system ?
User avatar
naderman
Consultant
Consultant
Posts: 3736
Joined: Fri Aug 01, 2003 10:06 pm
Location: Berlin, Germany
Name: Nils Adermann
Contact:

Re: [Beta] Sphinx for phpBB 1.0.beta1

Post by naderman »

It scales a lot better which allows really big sites to use it which have problems using the built-in search and it has a superior querying syntax with additional features: http://sphinxsearch.com/doc.html#searching . It also supports stemming which gives better results as well as a couple of other features documented on the Sphinx website.
I appreciate gifts from my Amazon wishlist.
naderman.de twitter: @naderman
geeheeb
Registered User
Posts: 9
Joined: Fri Jan 04, 2008 7:36 pm

Re: [Beta] Sphinx for phpBB 1.0.beta1

Post by geeheeb »

Hey, thanks for this! I'm trying it out now, and it the indexer is going crazy slowing down my 256MB VPS. Will this settle down once the board is indexed? For a 300mb database I wonder how long this would take.

What about the sphinx.conf file? Should I change indexer's mem_limit to be less than the 512 its currently set at? Any other optimizations?
Last edited by geeheeb on Wed Nov 05, 2008 9:27 pm, edited 1 time in total.
geeheeb
Registered User
Posts: 9
Joined: Fri Jan 04, 2008 7:36 pm

Re: [Beta] Sphinx for phpBB 1.0.beta1

Post by geeheeb »

And once again, thank your for your work. This does look very promising!
Locked

Return to “[3.0.x] MODs in Development”

cron