mainNSS MySQL - Support: sr #103602, a group for each user select...

 
 

sr #103602: a group for each user select statement....

Submitter:  None
Submitted:  Wed 24 Nov 2004 12:43:33 PM UTC
   
 
Category:  None Priority:  3 - Low
Severity:  1 - Wish Status:  Invalid
Privacy:  Public Assigned to:  gmorin
Originator Email:  -email is unavailable- Open/Closed:  Closed
Operating System:  None
* Mandatory Fields

Add a New Comment Rich Markup
   

Mon 21 Feb 2005 11:25:48 PM UTC, comment #1: 

Unfortunately, there is nothing you can do about that. The list is pulled because it is how id uses the NSS API... If you play with the where clause, you WILL break other apps.

Guillaume Morin <gmorin>
Group administrator
Wed 24 Nov 2004 12:43:33 PM UTC, original submission:  

Hello,

It's not really a bug as I seem to have a 'workaround', although this does give an error message.

OK I have a group for each user so in total I have 1000+ groups, if I leave the default config in place (i.e. SQL) then everytime  'id user' it pulls the list of 1000+ groups, obviously I don't want this so I was trying to add to the group where clause a 'only for this user' clause.

It seems to have worked but it reports an unknown table error.

nss-mysql.conf
groups.where_clause = groups.status = 'A' and groups.gid = user.gid;

Nov xx xx:xx:xx admin nss-mysql[6658]: setent(1): mysql_query failed: Unknown table 'user' in where clause

id lala
uid=1003(lala) gid=1003(lala) groups=1003(lala)

So it still gets the group information but it doesn't get a list of 1000+ groups.


Anonymous

 

(Note: upload size limit is set to 16384 kB, after insertion of the required escape characters.)

Attach Files:
   
   
Comment:
   

No files currently attached

 

Depends on the following items: None found

Items that depend on this one: None found

 

CC list is empty

 

There are 0 votes so far. Votes easily highlight which items people would like to see resolved in priority, independently of the priority of the item set by tracker managers.

Only logged-in users can vote.

 

Follow 4 latest changes.

Date Changed by Updated Field Previous Value => Replaced by
2005-02-21 gmorin Priority5 - Normal 3 - Low
    StatusNone Invalid
    Assigned toNone gmorin
    Open/ClosedOpen Closed

Back to the top

Powered by Savane 3.13-02a9.
Corresponding source code