[Beta] Sphinx search for phpBB 1.0.beta2

naderman · 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.

roobarb · 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.

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

Just check what sphinx requires.

roobarb · 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 · 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?

naderman · 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?

roobarb · 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

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

naderman · 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.

roobarb · 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

naderman · 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.

roobarb · 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"

naderman · 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

roobarb · 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

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

)

yais · 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

naderman · 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.

advertisements