[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!
Anti-Spam Guide
User avatar
^[GS]^
Registered User
Posts: 274
Joined: Sun Aug 06, 2006 10:59 pm
Location: Argentina
Contact:

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

Post by ^[GS]^ » Mon Feb 21, 2011 1:40 pm

I use version 3.0.8 and I have 1 GB of DB. Will it work well?

User avatar
1234homie
Registered User
Posts: 439
Joined: Fri Sep 26, 2008 3:17 pm

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

Post by 1234homie » Mon Feb 21, 2011 6:02 pm

Any news about new version?

Fisch.666
Registered User
Posts: 219
Joined: Sat Jul 30, 2005 10:58 am

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

Post by Fisch.666 » Wed Apr 20, 2011 10:55 pm

Hi!

Since 0.9.9-rc2 Sphinx searchd daemon supports MySQL binary network protocol and can be accessed with regular MySQL API:

http://sphinxsearch.com/docs/manual-0.9.9.html#sphinxql

which performs better than the "old" SphinxAPI:

http://sphinxsearch.com/blog/2010/04/25 ... benchmark/

Any chances to get this included in this phpBB plugin? Thanks in advance for a reply.

User avatar
1234homie
Registered User
Posts: 439
Joined: Fri Sep 26, 2008 3:17 pm

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

Post by 1234homie » Mon Aug 01, 2011 11:49 pm

download not working 403 ;/

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

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

Post by naderman » Tue Aug 02, 2011 7:08 am

Yeah, at the moment you will have to use the git version. You can download a snapshot on github, too.
I appreciate gifts from my Amazon wishlist.
naderman.de twitter: @naderman

parsim
Registered User
Posts: 30
Joined: Fri Jan 15, 2010 10:29 pm

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

Post by parsim » Wed Sep 28, 2011 5:44 am

Just wanted to report that replacing 'localhost' in the below line:

Code: Select all

// we only support localhost for now
$this->sphinx->SetServer('localhost', (isset($config['fulltext_sphinx_port']) && $config['fulltext_sphinx_port']) ? (int) $config['fulltext_sphinx_port'] : 3312);
... with the IP addy of a Sphinx daemon running on a remote server seems to work perfectly.

Thanks very much for the plugin!

User avatar
aurquiel
Registered User
Posts: 243
Joined: Fri May 15, 2009 1:45 am

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

Post by aurquiel » Thu Sep 29, 2011 4:39 am

I have this error when i tried enter in the config search

Code: Select all

[phpBB Debug] PHP Warning: in file /includes/search/fulltext_sphinx.php on line 911: file_exists() [function.file-exists]: open_basedir restriction in effect. File(/usr/local/bin/indexer) is not within the allowed path(s): (/home/op0082t:/usr/lib/php:/usr/local/lib/php:/tmp)
[phpBB Debug] PHP Warning: in file /includes/search/fulltext_sphinx.php on line 915: file_exists() [function.file-exists]: open_basedir restriction in effect. File(/usr/bin/indexer) is not within the allowed path(s): (/home/op0082t:/usr/lib/php:/usr/local/lib/php:/tmp)
[phpBB Debug] PHP Warning: in file /adm/index.php on line 150: Cannot modify header information - headers already sent by (output started at /includes/functions.php:3777)
[phpBB Debug] PHP Warning: in file /adm/index.php on line 152: Cannot modify header information - headers already sent by (output started at /includes/functions.php:3777)
[phpBB Debug] PHP Warning: in file /adm/index.php on line 153: Cannot modify header information - headers already sent by (output started at /includes/functions.php:3777)
[phpBB Debug] PHP Warning: in file /adm/index.php on line 154: Cannot modify header information - headers already sent by (output started at /includes/functions.php:3777)

User avatar
Oyabun1
Former Team Member
Posts: 23162
Joined: Sun May 17, 2009 1:05 pm
Location: Australia
Name: Bill

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

Post by Oyabun1 » Thu Sep 29, 2011 6:25 am

A topic search shows this Post.
                      Support Request Template
3.0.x: Knowledge Base Styles Support MOD Requests
3.1.x: Knowledge BaseStyles SupportExtension Requests

User avatar
aurquiel
Registered User
Posts: 243
Joined: Fri May 15, 2009 1:45 am

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

Post by aurquiel » Thu Sep 29, 2011 11:38 pm

I am not acces to the file php.ini i have a paid hosting but i havent acces to the file

User avatar
Oyabun1
Former Team Member
Posts: 23162
Joined: Sun May 17, 2009 1:05 pm
Location: Australia
Name: Bill

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

Post by Oyabun1 » Mon Oct 03, 2011 4:06 am

Then you'll have to ask your host to do it.
                      Support Request Template
3.0.x: Knowledge Base Styles Support MOD Requests
3.1.x: Knowledge BaseStyles SupportExtension Requests

User avatar
nlcaldwell
Registered User
Posts: 72
Joined: Fri Dec 24, 2004 2:35 pm
Location: Washington, DC
Contact:

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

Post by nlcaldwell » Mon Jan 02, 2012 9:33 am

Just posting to say I've successfully installed this mod with the latest stable version of Sphinx (v. 2.0.3). Only needed to make two quick modifications in the sphinx.conf file.

For those who might try doing this in the future, the sphinx.conf file is created in the configuration directory that you specified after you've installed and activated this mod. The first change was on the fourth line of the sphinx.conf file where it says:
sql_host =
I specified that as 'localhost.' The second change was to correct a typo. Search for 'ß410' in the sphinx.conf file. Change it to '0410'.

And that's all I had to do. Have Sphinx 2.0.3 running on a MySQL 5.1 database, and on a phpBB 3.0.9 board with 800,000+ posts. Before this, I was using fulltext MySQL search, which was decent but it was taking 30+ seconds for a search to complete. Now, searches are pretty much instantaneous.

Thanks for the great mod!
Code is poetry.

Also, poetry is poetry.

User avatar
Muad''Dib
Registered User
Posts: 311
Joined: Tue Jun 12, 2007 6:20 pm
Contact:

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

Post by Muad''Dib » Sat Jan 07, 2012 5:36 am

Hey guys.. i was wondering if you could help me with setting up some cron jobs for starting sphinx and also possibly to update the indexes?

One small problem that i have with this plugin is that sometimes users (and myself) go to search and it cant because the "search server is unavailable" aka "search produced no results". From my understanding this has something to do with the indexing process or search killing itself.. im confused about that.


Thanks for the help!

User avatar
aurquiel
Registered User
Posts: 243
Joined: Fri May 15, 2009 1:45 am

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

Post by aurquiel » Tue Jan 24, 2012 9:28 pm

Where are the 3 paths directorys??

Help!!

I install the motor but when i tried search something not found reslut...

Fisch.666
Registered User
Posts: 219
Joined: Sat Jul 30, 2005 10:58 am

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

Post by Fisch.666 » Sat Jan 28, 2012 4:52 pm

Hey,

just want to say thanks for figvam's fork of this mod. Didn't noticed this until today. :o

Maybe someone add a notice for this fork and this two bugfixes:

http://www.phpbb.com/community/viewtopi ... #p12853523
http://www.phpbb.com/community/viewtopi ... #p12864709

in the first post? (or better merge figvams fork back to the main project and add the two fixes above to it)

Holger
Registered User
Posts: 1761
Joined: Tue Mar 12, 2002 3:54 pm
Location: Hannover

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

Post by Holger » Sun Jan 29, 2012 9:09 am

Does anyone have a running demo?

And: does this search support/use the phpBB-auth system (hidden forums, different access settings)?

Locked

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