[Top][All Lists]

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

[Nss-mysql-devel] [support #103602] a group for each user select stateme

From: anonymous
Subject: [Nss-mysql-devel] [support #103602] a group for each user select statement....
Date: Wed, 24 Nov 2004 07:49:50 -0500
User-agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.6) Gecko/20040206 Firefox/0.8

This mail is an automated notification from the support tracker
 of the project: NSS MySQL.

[support #103602] Full Item Snapshot:

URL: <http://savannah.nongnu.org/support/?func=detailitem&item_id=103602>
Project: NSS MySQL
Submitted by: 0
On: Wed 11/24/2004 at 12:43

Category:  None
Priority:  5 - Normal
Severity:  1 - None
Resolution:  None
Privacy:  Public
Assigned to:  None
Originator Email:  address@hidden
Status:  Open

Summary:  a group for each user select statement....

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.

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+ 

For detailed info, follow this link:

  Message sent via/by Savannah

reply via email to

[Prev in Thread] Current Thread [Next in Thread]