[Beta] Sphinx search for phpBB 1.0.beta2

[naderman]

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]

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]

Just check what sphinx requires.

[roobarb]

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]

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]

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]

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]

What I meant is that some hosters disable the PHP function called exec() which is used to execute those files.

[roobarb]

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]

Ask your hoster or write a script that uses a the function and see whether it works.

[roobarb]

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]

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]

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]

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

Thanks

[naderman]

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.