Register Members List Search Today's Posts Mark Forums Read

Reply
 
Thread Tools
  #31  
Old 02 Oct 2006, 21:17
orban orban is offline
 
Join Date: Jan 2005
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
Reply With Quote
  #32  
Old 02 Oct 2006, 22:27
ubuntu-geek ubuntu-geek is offline
 
Join Date: Oct 2004
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..
Reply With Quote
  #33  
Old 02 Oct 2006, 22:29
orban orban is offline
 
Join Date: Jan 2005
Neither here, I'm the only with access.
Reply With Quote
  #34  
Old 03 Oct 2006, 00:35
mute mute is offline
 
Join Date: Dec 2002
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
Reply With Quote
  #35  
Old 03 Oct 2006, 00:37
orban orban is offline
 
Join Date: Jan 2005
They aren't, but all posts/threads are filtered again on the results page.

Last edited by orban; 03 Oct 2006 at 00:41.
Reply With Quote
  #36  
Old 03 Oct 2006, 12:58
kmike kmike is offline
 
Join Date: Oct 2002
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:

Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.

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.
Attached Files
File Type: txt sphinx-three.patch.txt (25.0 KB, 43 views)
Reply With Quote
  #37  
Old 03 Oct 2006, 13:20
orban orban is offline
 
Join Date: Jan 2005
Thank you. Gonna try this out
Reply With Quote
  #38  
Old 03 Oct 2006, 14:10
ubuntu-geek ubuntu-geek is offline
 
Join Date: Oct 2004
Originally Posted by orban
Thank you. Gonna try this out
Curious to see how this works out..
Reply With Quote
  #39  
Old 03 Oct 2006, 15:29
TECK's Avatar
TECK TECK is offline
 
Join Date: Dec 2001
Real name: Floren Munteanu
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
Reply With Quote
  #40  
Old 03 Oct 2006, 15:32
orban orban is offline
 
Join Date: Jan 2005
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....
Reply With Quote
  #41  
Old 03 Oct 2006, 16:00
kmike kmike is offline
 
Join Date: Oct 2002
Unfortunately, 0.9.7-dev is still too buggy to be used in production.
Reply With Quote
  #42  
Old 03 Oct 2006, 21:01
mute mute is offline
 
Join Date: Dec 2002
Originally Posted by kmike
Unfortunately, 0.9.7-dev is still too buggy to be used in production.
What kind of bugs are you running into?
Reply With Quote
  #43  
Old 04 Oct 2006, 06:39
kmike kmike is offline
 
Join Date: Oct 2002
Originally Posted by orban
The groupid has to be <4096...?! I'm sure you have more than 4096 users...
Where did you get that number? We have much more than 4096 members and everything is working fine.
*edit* Ah, found it. You're mistaken - 4096 is the limit on a number of groupid's listed in one request. A groupid is an unsigned 32bit integer AFAIK, so the limit of 4GB should be enough for everybody (the famous last words)

Originally Posted by mute
What kind of bugs are you running into?
Frequent crashes when searching.

Last edited by kmike; 04 Oct 2006 at 06:49. Reason: Automerged Doublepost
Reply With Quote
  #44  
Old 05 Oct 2006, 05:02
TECK's Avatar
TECK TECK is offline
 
Join Date: Dec 2001
Real name: Floren Munteanu
Go ahead and post it.
Thanks Orban.
Reply With Quote
  #45  
Old 05 Oct 2006, 05:08
mute mute is offline
 
Join Date: Dec 2002
Indeed, conf, patch and search would be fantastic
Reply With Quote
Reply



Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off


New To Site? Need Help?

All times are GMT. The time now is 05:39.

Layout Options | Width: Wide Color: