[465] in Moira
Last night's Moira/AFS error
daemon@ATHENA.MIT.EDU (Richard Basch)
Thu Oct 1 09:03:21 1992
Date: Thu, 1 Oct 92 09:02:24 -0400
To: dbadmin@MIT.EDU, bug-moira@MIT.EDU
From: "Richard Basch" <basch@MIT.EDU>
Sep 30 14:42:43 <14344> Couldn't add sthadani to system:college bowl: User or group doesn't exist
This one bothers me... Please notice the group name has a <SPACE> or
some other illegal character in it.
/moira/journal:
% sthadani@ATHENA.MIT.EDU mailmain Wed Sep 30 14:42:04 1992
add_member_to_list[2] "college bowl" "user" "sthadani"
* retrieve (l.name,l.list_id,l.gid) where l.name="college bowl"\g
|name |list_id |gid |
|-----------------------------------------------------|
|collegebowl | 21874| 27477|
|-----------------------------------------------------|
It looks like Ingres strips the spaces, which is why Moira didn't choke
on this, but of course, since the query succeeded, it interpreted the
real list name to be what the user passed. May I recommend that the
incremental procedures receive the list name as stored in the database,
rather than from the user's query.
In the meantime, I have corrected this skew between Moira and the AFS prdb.
-R
