[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!
Suggested Hosts
Locked
tiby
Registered User
Posts: 46
Joined: Mon Oct 20, 2008 6:11 am
Contact:

Re: [Beta] Sphinx search for phpBB 1.0.beta2

Post by tiby »

anyone knows how to configure the settings?
i entered the forum name, and when i creat index, the error is showing as following

Code: Select all

[phpBB Debug] PHP Notice: in file /includes/search/fulltext_sphinx.php on line 1010: opendir(forum.udonno.com/): failed to open dir: No such file or directory
[phpBB Debug] PHP Notice: in file /includes/search/fulltext_sphinx.php on line 1011: readdir(): supplied argument is not a valid Directory resource
[phpBB Debug] PHP Notice: in file /includes/search/fulltext_sphinx.php on line 1018: closedir(): supplied argument is not a valid Directory resource
please help me out

thanks in advance
tiby
Registered User
Posts: 46
Joined: Mon Oct 20, 2008 6:11 am
Contact:

Re: [Beta] Sphinx search for phpBB 1.0.beta2

Post by tiby »

where is the indexer and searchd ?

Code: Select all

Path to executables directory:
If this path could not be determined automatically you have to enter the path to the directory in which the sphinx executables indexer and searchd reside.
User avatar
oddfish
Registered User
Posts: 839
Joined: Mon Mar 19, 2007 8:45 pm
Location: Testing 3.1
Contact:

Re: [Beta] Sphinx search for phpBB 1.0.beta2

Post by oddfish »

Currently only the combination of Linux, MySQL and Sphinx 0.9.8 or 0.9.8.1 is supported - just to make sure you know that with this beta2 release.

The path will vary but generally when installing sphinx yourself on your server it'll be set up in something like /usr/local/bin/ .

If you have asked your host to set up Sphinx 0.9.8.1 for you, then they'll know the path for you to enter.
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
NetRoll
Registered User
Posts: 5
Joined: Sun Sep 19, 2004 3:31 pm

Re: [Beta] Sphinx search for phpBB 1.0.beta2

Post by NetRoll »

Hi,

I tried this mod on 3.0.4 and when I go to ACP > General and then Search settings, I only get a blank page. Nothing shows up.

I have CentOS 5.2, sphinx 0.9.8 (latest available), phpBB 3.0.4, php 5.1.6, MySQL 5.0.45.

I tryed putting a die('test') at the end of includes/search/fulltext_sphinx.php and the test shows on the page, so this file loads correctly.

Anything I am missing?
User avatar
Highway of Life
Former Team Member
Posts: 6048
Joined: Wed Feb 02, 2005 5:41 pm
Location: Bend, OR
Name: David Lewis
Contact:

Re: [Beta] Sphinx search for phpBB 1.0.beta2

Post by Highway of Life »

Did you check your PHP error log?
NetRoll
Registered User
Posts: 5
Joined: Sun Sep 19, 2004 3:31 pm

Re: [Beta] Sphinx search for phpBB 1.0.beta2

Post by NetRoll »

No errors shown in the ACP :/
User avatar
Highway of Life
Former Team Member
Posts: 6048
Joined: Wed Feb 02, 2005 5:41 pm
Location: Bend, OR
Name: David Lewis
Contact:

Re: [Beta] Sphinx search for phpBB 1.0.beta2

Post by Highway of Life »

I didn’t say the ACP. ;)
The PHP error log is what you need to look at.
NetRoll
Registered User
Posts: 5
Joined: Sun Sep 19, 2004 3:31 pm

Re: [Beta] Sphinx search for phpBB 1.0.beta2

Post by NetRoll »

No, nothing there either.
wout000
Registered User
Posts: 21
Joined: Wed Aug 06, 2003 11:30 am
Location: Belgium
Contact:

Re: [Beta] Sphinx search for phpBB 1.0.beta2

Post by wout000 »

error: The file /usr/local/bin/indexer is not executable for the webserver.

I set the config and data folder in the settings (created 2 folders that are writable) and told phpbb to use sphinx and then got the above error
wout000
Registered User
Posts: 21
Joined: Wed Aug 06, 2003 11:30 am
Location: Belgium
Contact:

Re: [Beta] Sphinx search for phpBB 1.0.beta2

Post by wout000 »

bumpery bump bump
camelreef
Registered User
Posts: 3
Joined: Tue Aug 17, 2004 3:43 am

Re: [Beta] Sphinx search for phpBB 1.0.beta2

Post by camelreef »

Hello,

phpBB 3.0.4
SEO MOD
1.5M posts, 220k threads, 40k users
Sphinxsearch 0.9.8.1
MOD 1.0beta2
256 MB RAM given to the search in MCP

There are regular occasions when a search returns no result. Going back and running the search right after gives all the proper results.

It looks like searchd is restarted very often.

searchd-startup.log

Code: Select all

[Sun Mar 22 20:01:54.974 2009] [14497] using config file '/mnt/sdb/var/local/sphinx/config/sphinx.conf'...
[Sun Mar 22 20:01:54.975 2009] [14497] creating server socket on 127.0.0.1:3312
[Sun Mar 22 20:03:20.994 2009] [14590] using config file '/mnt/sdb/var/local/sphinx/config/sphinx.conf'...
[Sun Mar 22 20:03:20.995 2009] [14590] creating server socket on 127.0.0.1:3312
[Sun Mar 22 20:08:35.704 2009] [15835] using config file '/mnt/sdb/var/local/sphinx/config/sphinx.conf'...
[Sun Mar 22 20:08:35.705 2009] [15835] creating server socket on 127.0.0.1:3312
[Sun Mar 22 20:15:31.708 2009] [18028] using config file '/mnt/sdb/var/local/sphinx/config/sphinx.conf'...
[Sun Mar 22 20:15:31.709 2009] [18028] creating server socket on 127.0.0.1:3312
[Sun Mar 22 20:18:01.787 2009] [18252] using config file '/mnt/sdb/var/local/sphinx/config/sphinx.conf'...
[Sun Mar 22 20:18:01.788 2009] [18252] creating server socket on 127.0.0.1:3312
[Sun Mar 22 20:33:17.061 2009] [22318] using config file '/mnt/sdb/var/local/sphinx/config/sphinx.conf'...
[Sun Mar 22 20:33:17.062 2009] [22318] creating server socket on 127.0.0.1:3312
[Sun Mar 22 20:36:38.250 2009] [23522] using config file '/mnt/sdb/var/local/sphinx/config/sphinx.conf'...
[Sun Mar 22 20:36:38.251 2009] [23522] creating server socket on 127.0.0.1:3312
[Sun Mar 22 20:48:34.366 2009] [26232] using config file '/mnt/sdb/var/local/sphinx/config/sphinx.conf'...
[Sun Mar 22 20:48:34.367 2009] [26232] creating server socket on 127.0.0.1:3312
[Sun Mar 22 20:53:50.411 2009] [27579] using config file '/mnt/sdb/var/local/sphinx/config/sphinx.conf'...
[Sun Mar 22 20:53:50.435 2009] [27579] creating server socket on 127.0.0.1:3312
[Sun Mar 22 21:24:50.671 2009] [ 2706] using config file '/mnt/sdb/var/local/sphinx/config/sphinx.conf'...
[Sun Mar 22 21:24:50.672 2009] [ 2706] creating server socket on 127.0.0.1:3312
[Sun Mar 22 21:24:55.932 2009] [ 2721] using config file '/mnt/sdb/var/local/sphinx/config/sphinx.conf'...
[Sun Mar 22 21:24:55.932 2009] [ 2721] creating server socket on 127.0.0.1:3312
[Sun Mar 22 21:33:29.799 2009] [ 5096] using config file '/mnt/sdb/var/local/sphinx/config/sphinx.conf'...
[Sun Mar 22 21:33:29.800 2009] [ 5096] creating server socket on 127.0.0.1:3312
[Sun Mar 22 21:35:35.545 2009] [ 6210] using config file '/mnt/sdb/var/local/sphinx/config/sphinx.conf'...
[Sun Mar 22 21:35:35.546 2009] [ 6210] creating server socket on 127.0.0.1:3312
[Sun Mar 22 21:37:17.511 2009] [ 6327] using config file '/mnt/sdb/var/local/sphinx/config/sphinx.conf'...
[Sun Mar 22 21:37:17.512 2009] [ 6327] creating server socket on 127.0.0.1:3312
[Sun Mar 22 21:40:47.531 2009] [ 7566] using config file '/mnt/sdb/var/local/sphinx/config/sphinx.conf'...
[Sun Mar 22 21:40:47.531 2009] [ 7566] creating server socket on 127.0.0.1:3312
[Sun Mar 22 21:43:19.361 2009] [ 7750] using config file '/mnt/sdb/var/local/sphinx/config/sphinx.conf'...
[Sun Mar 22 21:43:19.362 2009] [ 7750] creating server socket on 127.0.0.1:3312
[Sun Mar 22 21:44:29.405 2009] [ 7813] using config file '/mnt/sdb/var/local/sphinx/config/sphinx.conf'...
[Sun Mar 22 21:44:29.406 2009] [ 7813] creating server socket on 127.0.0.1:3312
[Sun Mar 22 21:44:37.129 2009] [ 7838] using config file '/mnt/sdb/var/local/sphinx/config/sphinx.conf'...
[Sun Mar 22 21:44:37.129 2009] [ 7838] creating server socket on 127.0.0.1:3312
[Sun Mar 22 21:59:45.239 2009] [11418] using config file '/mnt/sdb/var/local/sphinx/config/sphinx.conf'...
[Sun Mar 22 21:59:45.266 2009] [11418] creating server socket on 127.0.0.1:3312
[Sun Mar 22 22:05:32.245 2009] [13713] using config file '/mnt/sdb/var/local/sphinx/config/sphinx.conf'...
[Sun Mar 22 22:05:32.245 2009] [13713] creating server socket on 127.0.0.1:3312
[Sun Mar 22 22:06:01.350 2009] [13748] using config file '/mnt/sdb/var/local/sphinx/config/sphinx.conf'...
[Sun Mar 22 22:06:01.350 2009] [13748] creating server socket on 127.0.0.1:3312
[Sun Mar 22 22:06:46.676 2009] [13819] using config file '/mnt/sdb/var/local/sphinx/config/sphinx.conf'...
[Sun Mar 22 22:06:46.677 2009] [13819] creating server socket on 127.0.0.1:3312
[Sun Mar 22 22:09:25.638 2009] [13998] using config file '/mnt/sdb/var/local/sphinx/config/sphinx.conf'...
[Sun Mar 22 22:09:25.639 2009] [13998] creating server socket on 127.0.0.1:3312
[Sun Mar 22 22:11:14.017 2009] [15008] using config file '/mnt/sdb/var/local/sphinx/config/sphinx.conf'...
[Sun Mar 22 22:11:14.018 2009] [15008] creating server socket on 127.0.0.1:3312
[Sun Mar 22 22:11:56.504 2009] [15067] using config file '/mnt/sdb/var/local/sphinx/config/sphinx.conf'...
[Sun Mar 22 22:11:56.505 2009] [15067] creating server socket on 127.0.0.1:3312
[Sun Mar 22 22:13:44.192 2009] [15243] using config file '/mnt/sdb/var/local/sphinx/config/sphinx.conf'...
[Sun Mar 22 22:13:44.193 2009] [15243] creating server socket on 127.0.0.1:3312
searchd.log

Code: Select all

[Sun Mar 22 12:03:38.263 2009] [27569] accepting connections
[Sun Mar 22 12:43:17.237 2009] [ 3883] accepting connections
[Sun Mar 22 13:00:04.137 2009] [ 7759] accepting connections
[Sun Mar 22 13:23:34.419 2009] [13120] accepting connections
[Sun Mar 22 13:32:23.061 2009] [16046] accepting connections
[Sun Mar 22 13:37:17.553 2009] [17251] accepting connections
[Sun Mar 22 13:51:30.245 2009] [20775] accepting connections
[Sun Mar 22 14:18:16.746 2009] [27095] accepting connections
[Sun Mar 22 14:21:09.784 2009] [28337] accepting connections
[Sun Mar 22 14:22:47.639 2009] [28435] accepting connections
[Sun Mar 22 14:40:05.323 2009] [  485] accepting connections
[Sun Mar 22 15:02:02.801 2009] [ 5943] accepting connections
[Sun Mar 22 15:39:07.803 2009] [14144] accepting connections
[Sun Mar 22 15:47:15.967 2009] [16381] accepting connections
[Sun Mar 22 15:59:43.397 2009] [18836] accepting connections
[Sun Mar 22 16:09:39.217 2009] [21553] accepting connections
[Sun Mar 22 16:33:59.483 2009] [27461] accepting connections
[Sun Mar 22 16:44:08.958 2009] [29971] accepting connections
[Sun Mar 22 16:51:14.227 2009] [32336] accepting connections
[Sun Mar 22 16:53:22.442 2009] [32496] accepting connections
[Sun Mar 22 16:57:29.095 2009] [ 1197] accepting connections
[Sun Mar 22 17:23:27.853 2009] [ 7350] accepting connections
[Sun Mar 22 17:30:48.004 2009] [ 9690] accepting connections
[Sun Mar 22 17:37:13.077 2009] [10924] accepting connections
[Sun Mar 22 17:37:42.230 2009] [10950] accepting connections
[Sun Mar 22 17:52:16.506 2009] [14428] accepting connections
[Sun Mar 22 17:53:21.638 2009] [14515] accepting connections
[Sun Mar 22 18:00:29.562 2009] [16734] accepting connections
[Sun Mar 22 18:04:28.785 2009] [16957] accepting connections
[Sun Mar 22 18:29:13.781 2009] [22957] accepting connections
[Sun Mar 22 18:39:54.807 2009] [25580] accepting connections
[Sun Mar 22 18:55:48.452 2009] [30318] accepting connections
[Sun Mar 22 19:26:58.474 2009] [ 5326] accepting connections
[Sun Mar 22 19:36:10.766 2009] [ 7790] accepting connections
[Sun Mar 22 19:47:07.326 2009] [10389] accepting connections
[Sun Mar 22 19:57:25.532 2009] [13071] accepting connections
[Sun Mar 22 19:59:53.367 2009] [13367] accepting connections
[Sun Mar 22 20:01:55.251 2009] [14500] accepting connections
[Sun Mar 22 20:03:21.297 2009] [14591] accepting connections
[Sun Mar 22 20:08:36.019 2009] [15838] accepting connections
[Sun Mar 22 20:15:31.967 2009] [18029] accepting connections
[Sun Mar 22 20:18:02.126 2009] [18255] accepting connections
[Sun Mar 22 20:48:34.656 2009] [26233] accepting connections
[Sun Mar 22 20:53:50.764 2009] [27580] accepting connections
[Sun Mar 22 21:24:56.242 2009] [ 2724] accepting connections
[Sun Mar 22 21:35:35.838 2009] [ 6211] accepting connections
[Sun Mar 22 21:37:17.799 2009] [ 6328] accepting connections
[Sun Mar 22 21:40:47.790 2009] [ 7568] accepting connections
[Sun Mar 22 21:43:19.647 2009] [ 7751] accepting connections
[Sun Mar 22 21:44:37.425 2009] [ 7839] accepting connections
[Sun Mar 22 21:59:45.567 2009] [11419] accepting connections
[Sun Mar 22 22:11:56.770 2009] [15068] accepting connections
[Sun Mar 22 22:14:50.875 2009] [15347] accepting connections
Is it an expected behavior, or is there something I can do to help it?

I am tempted to say that the temporary empty results are linked to the restarts.

Thanks for any help,

Nico
Letus2001
Registered User
Posts: 22
Joined: Thu Nov 04, 2004 8:22 pm

Re: [Beta] Sphinx search for phpBB 1.0.beta2

Post by Letus2001 »

hi,
I have two questions :

1] I run phpbb 3.0.0 site, took over from previous owner, and have no idea how to install this mod ? I used to work with phpbb 2.0 site, where the installation was done manually using "step by step" instruction, but here I see some option to install automaticly ? Never used it, so im bit scared to do it :) Will it affect the existing search page, or will it only install and let me turn it ON/OFF ?

2] i use sphinx on my other websites, as this is a great and powerfull search engine, so i dont want to use the "predefined" sphinx.conf from this mod, instead i want to add necessary indexes to my existing sphinx.conf. Any idea, what should I disable in this mod to stop it from creating sphinx.conf file and running it schedule? our site is huge, and indexing takes like 30 minutes at least, i want to do it just once a day during late nite time, not sure if its "schedulable" with this mod. On my other sites, im using cron to run the indexer.

Thank you.
Letus2001
Registered User
Posts: 22
Joined: Thu Nov 04, 2004 8:22 pm

Re: [Beta] Sphinx search for phpBB 1.0.beta2

Post by Letus2001 »

well, i did some experiments, and here is the result :

to install this mod, you can use AUTOMOD plugin, which is downloadable via phpbb.com site, and which allows you to install modX mods ...

it will NOT install if you are using by default other than EN language, because it wont find language/YOURLANG files. Simply solution : copy and paste the EN subfolder in the plugin as for example DE subfolder, if you use german language, etc ... the text will be in english, but at least your installation and ACP will work :)

latest version of sphinx under SUSE enterprise linux doesnt have "indexer" and "searchd" binaries, but
"sphinx-indexer" and "sphinx-searchd", so this will be problem for this mod as well. Go to your /usr/bin directory (or where you have your sphinx binaries) and create symbolic links

ln -s sphinx-indexer indexer
ln -s sphinx-searchd searchd

to create the shortcuts named "indexer" and "searchd".

if you are already using sphinx with other applications, and you do not want to mess up with it, go to ACP and change PORT and PATH to config file of phpbb sphinx, so it doesnt collide with your existing sphinx settings.



so far, sphinx works on my site, with just one problem :)

as our site is plastic model kits focused site, I need to do a lot of searches for airplanes and tanks with "-" in its name : F-16, T-34, F-22 Raptor etc ... on my site, im using the EXTENDED type of sphinx search, and i convert the search from

F-16

to

"F-16"

using this, i just send it to the search and get results. But, with sphinx-phpbb, it doesnt work. With quotes or without them, same result. What can I do to pass the EXACT value that has been typed to search field, to sphinx search ? without any alterations, replacements, etc ? or is there any other way, how to make names like T-34 work in this mod ?

Thanks
Letus2001
Registered User
Posts: 22
Joined: Thu Nov 04, 2004 8:22 pm

Re: [Beta] Sphinx search for phpBB 1.0.beta2

Post by Letus2001 »

well, no advice ?

I also realised, that my previous statement is not correct - after i used phpbb Sphinx, my original Sphinx stop to work. It created the data files, but was unable to rotate them. I had to shutdown my original sphinx deamon, and start it to make it work again. So, I suggest you do NOT run these two together without some extended tests.
superj707
Registered User
Posts: 1136
Joined: Thu Feb 26, 2009 12:20 am

Re: [Beta] Sphinx search for phpBB 1.0.beta2

Post by superj707 »

saved
Locked

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