Sphinx Search

[orban]

search can be called by anyone with server access on the command line

so he gets access to all your indexes and thus to all your posts

so if you have a designer ssh access to upload stuff he can basically read your private forums

[ubuntu-geek]

Originally Posted by orban

search can be called by anyone with server access on the command line

so he gets access to all your indexes and thus to all your posts

so if you have a designer ssh access to upload stuff he can basically read your private forums

True.. Not an issue for us..

[orban]

Neither here, I'm the only with access.

[mute]

Originally Posted by mute

Just an FYI, make sure you limit access to that search on your dev boxes if you don't potentially want people searching for info in your private forums

I guess now we just get to wait patiently for 0.9.7 to come out...

Oh, I thought at this point the search wasn't excluding forums users don't have permissions to view

[orban]

They aren't, but all posts/threads are filtered again on the results page.

[kmike]

Attached is the patch for Sphinx 0.9.5 which adds two more group columns.
You'll have to have something like this in your sphinx.conf:

       sql_query=SELECT postid,  \
             pagetext, post.title, forumid, \
             IF(post.userid=0,99999999,post.userid) AS userid, \
             post.threadid AS threadid, post.dateline AS dateline \
         FROM post
.....

        sql_group_column        = forumid
        sql_group2_column       = userid
        sql_group3_column       = threadid
        sql_date_column         = dateline

The part with IF(post.userid=0) is needed because Sphinx doesn't like zero column values (you'll have them if a board has some posts by the guests or deleted users), so we replace them with an arbitrary high number (99999999) which is guaranteed not to happen in the real data.

sphinxapi.php supports two more grouping functions: SetGroup2(array) and SetGroup3(array).
So search.php will have to call $sphinx->SetGroups2($userids) when searching by user(s), where $userids is an array containing their userid's.
And similarly, $sphinx->SetGroups3(array($searchthreadid)) will be called when searching in a thread.

[orban]

Thank you. Gonna try this out

[ubuntu-geek]

Originally Posted by orban

Thank you. Gonna try this out

Curious to see how this works out..

[TECK]

Thanks Orban (and others) for this solution.
0.9.6 is out, it fixes the following issues:
- added support for empty indexes (solves the previous issues we had with indexes)
- added support for multiple sql_query_pre/post/post_index
- fixed timestamp ranges filter in "match any" mode
- fixed configure issues with --without-mysql and --with-pgsql options
- fixed building on Solaris 9

[orban]

Yes, but the patch for more than one group won't work for this...

I'm trying to get a snapshot of 0.9.7....