Page 5 of 20

Re: [ALPHA] Sphinx for phpBB

Posted: Mon Apr 07, 2008 10:34 am
by naderman
Ah alright, I'll look into that, thanks.

Re: [ALPHA] Sphinx for phpBB

Posted: Fri Apr 25, 2008 10:20 pm
by yais
I dont quite understand exactly how to install and integrate sphinx with phpbb3.

Can anyone explain?

thanks

Re: [ALPHA] Sphinx for phpBB

Posted: Sat Apr 26, 2008 2:58 am
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.

Re: [ALPHA] Sphinx for phpBB

Posted: Fri May 16, 2008 9:03 am
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?

Re: [ALPHA] Sphinx for phpBB

Posted: Fri May 16, 2008 9:17 am
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.

Re: [ALPHA] Sphinx for phpBB

Posted: Thu Sep 04, 2008 12:12 pm
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

Re: [ALPHA] Sphinx for phpBB

Posted: Sat Nov 01, 2008 9:10 pm
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.

Re: [Beta] Sphinx for phpBB 1.0.beta1

Posted: Mon Nov 03, 2008 10:31 pm
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/

Re: [Beta] Sphinx for phpBB 1.0.beta1

Posted: Tue Nov 04, 2008 8:54 pm
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.

Re: [Beta] Sphinx for phpBB 1.0.beta1

Posted: Wed Nov 05, 2008 7:19 pm
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.

Re: [Beta] Sphinx for phpBB 1.0.beta1

Posted: Wed Nov 05, 2008 7:26 pm
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.

Re: [Beta] Sphinx for phpBB 1.0.beta1

Posted: Wed Nov 05, 2008 8:08 pm
by GoBieN
What would be the advantage of this plugin over the normal search system ?

Re: [Beta] Sphinx for phpBB 1.0.beta1

Posted: Wed Nov 05, 2008 9:25 pm
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.

Re: [Beta] Sphinx for phpBB 1.0.beta1

Posted: Wed Nov 05, 2008 9:26 pm
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?

Re: [Beta] Sphinx for phpBB 1.0.beta1

Posted: Wed Nov 05, 2008 9:26 pm
by geeheeb
And once again, thank your for your work. This does look very promising!