[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!
Scam Warning
User avatar
naderman
Consultant
Consultant
Posts: 3735
Joined: Fri Aug 01, 2003 10:06 pm
Location: Berlin, Germany
Name: Nils Adermann
Contact:

Re: [ALPHA] Sphinx for phpBB

Post by naderman » Fri Mar 07, 2008 11:46 am

This is really just a plugin so sphinx will always have to be installed. Either you can do that on your server yourself or you get your hoster to do so. Or you compile it locally and upload it afterwards, this requires you to have the same version of libraries as the hoster though and can be a little tedious.
I appreciate gifts from my Amazon wishlist.
naderman.de twitter: @naderman

roobarb
Registered User
Posts: 48
Joined: Tue Feb 26, 2008 12:37 am
Location: Essex
Contact:

Re: [ALPHA] Sphinx for phpBB

Post by roobarb » Fri Mar 07, 2008 12:21 pm

naderman wrote:This is really just a plugin so sphinx will always have to be installed. Either you can do that on your server yourself or you get your hoster to do so. Or you compile it locally and upload it afterwards, this requires you to have the same version of libraries as the hoster though and can be a little tedious.
Do we know which libraries? I'd have to write a perl script to get that information out of the web environment.

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

Re: [ALPHA] Sphinx for phpBB

Post by naderman » Fri Mar 07, 2008 1:21 pm

Just check what sphinx requires.
I appreciate gifts from my Amazon wishlist.
naderman.de twitter: @naderman

roobarb
Registered User
Posts: 48
Joined: Tue Feb 26, 2008 12:37 am
Location: Essex
Contact:

Re: [ALPHA] Sphinx for phpBB

Post by roobarb » Fri Mar 07, 2008 1:23 pm

AWESOME!! My ISP said they allow it. But there is no ssh access, so, hmmmmm if they don't install it generally then i'd have to install it to my web environment with --prefix.

I have written a webshell though (perl script), wonder if I can allow make through that.....

edit: compiled it on a local linux box, uploading it now...

roobarb
Registered User
Posts: 48
Joined: Tue Feb 26, 2008 12:37 am
Location: Essex
Contact:

Re: [ALPHA] Sphinx for phpBB

Post by roobarb » Fri Mar 07, 2008 5:57 pm

hmm.

I upload the binaries and the directory tree, chmod it all to 777 and get the error, chgrp it to webserver and phpBB3 complains "{full path}/sphinx/bin/sphinx/bin/indexer is not executable for the webserver"

ls -la

drwxrwxrwx 2 38671 38671 4096 Mar 7 13:30 .
drwxrwxrwx 5 38671 38671 4096 Mar 7 13:30 ..
-rwxrwxrwx 1 38671 38671 4059001 Mar 7 13:30 indexer
-rwxrwxrwx 1 38671 38671 3914533 Mar 7 13:30 search
-rwxrwxrwx 1 38671 38671 4627348 Mar 7 13:30 searchd
-rwxrwxrwx 1 38671 38671 3796863 Mar 7 13:30 spelldump

any ideas?

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

Re: [ALPHA] Sphinx for phpBB

Post by naderman » Fri Mar 07, 2008 6:53 pm

It should actually give a different error message for that but are you sure you have exec() enabled? Oh and are you sure that sphinx/bin/sphinx/bin is right?
I appreciate gifts from my Amazon wishlist.
naderman.de twitter: @naderman

roobarb
Registered User
Posts: 48
Joined: Tue Feb 26, 2008 12:37 am
Location: Essex
Contact:

Re: [ALPHA] Sphinx for phpBB

Post by roobarb » Fri Mar 07, 2008 7:11 pm

naderman wrote:It should actually give a different error message for that but are you sure you have exec() enabled? Oh and are you sure that sphinx/bin/sphinx/bin is right?
yes the path is correct. In the web environment, I can call tar and zip, does this mean exec() is enabled?

if i can get this sorted, I'll be well chuffed :D

oh you mean is NOEXEC set on the filesystem like you can in openbsd? I doubt it, because I can execute perl scripts there.

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

Re: [ALPHA] Sphinx for phpBB

Post by naderman » Fri Mar 07, 2008 9:46 pm

What I meant is that some hosters disable the PHP function called exec() which is used to execute those files.
I appreciate gifts from my Amazon wishlist.
naderman.de twitter: @naderman

roobarb
Registered User
Posts: 48
Joined: Tue Feb 26, 2008 12:37 am
Location: Essex
Contact:

Re: [ALPHA] Sphinx for phpBB

Post by roobarb » Fri Mar 07, 2008 10:13 pm

naderman wrote:What I meant is that some hosters disable the PHP function called exec() which is used to execute those files.
So will there be a line in phpinfo that literally says exec() if it is enabled? Or will it be called something else? What am I looking for? or how do i test for exec()?

Sorry for all the qs :oops:

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

Re: [ALPHA] Sphinx for phpBB

Post by naderman » Fri Mar 07, 2008 10:24 pm

Ask your hoster or write a script that uses a the function and see whether it works.
I appreciate gifts from my Amazon wishlist.
naderman.de twitter: @naderman

roobarb
Registered User
Posts: 48
Joined: Tue Feb 26, 2008 12:37 am
Location: Essex
Contact:

Re: [ALPHA] Sphinx for phpBB

Post by roobarb » Fri Mar 07, 2008 10:53 pm

naderman wrote:Ask your hoster or write a script that uses a the function and see whether it works.
Sorry for appearing thick. I'm a newbie to php but perl I know better. Anyway, exec() works in php.

echo exec('whoami'); returns "nobody"

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

Re: [ALPHA] Sphinx for phpBB

Post by naderman » Sun Mar 09, 2008 1:49 pm

Well then I have no idea either. But apparently it's not possible to execute sphinx for the webserver. Btw. this plugin requires 0.9.7 and does not work with the 0.9.8 betas/RCs
I appreciate gifts from my Amazon wishlist.
naderman.de twitter: @naderman

roobarb
Registered User
Posts: 48
Joined: Tue Feb 26, 2008 12:37 am
Location: Essex
Contact:

Re: [ALPHA] Sphinx for phpBB

Post by roobarb » Sun Mar 09, 2008 2:24 pm

naderman wrote:Well then I have no idea either. But apparently it's not possible to execute sphinx for the webserver. Btw. this plugin requires 0.9.7 and does not work with the 0.9.8 betas/RCs
OOps I was using the latest one :oops: Ok, I'll try again. I wonder if I can compile on the webserver within my perl shell, certainly it can see 'make'. Thanks for your patience. I'll try with 0.9.7 (rinse, repeat :lol: )

yais
Registered User
Posts: 306
Joined: Sun Jun 17, 2007 12:45 pm

Re: [ALPHA] Sphinx for phpBB

Post by yais » Sun Mar 09, 2008 3:01 pm

Can you quickly outline the advatage of using this over the normal phpbb3 search.

Thanks

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

Re: [ALPHA] Sphinx for phpBB

Post by naderman » Sun Mar 09, 2008 11:26 pm

It scales a lot better which allows really big sites to use it which have problems to use 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 and generally has a lot more features.
I appreciate gifts from my Amazon wishlist.
naderman.de twitter: @naderman

Locked

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