From: danw <danw>
Date: Wed, 17 Sep 1997 16:59:52 +0000 (+0000)
Subject: Fix a bug where having USER:foo and KERBEROS:foo@ATHENA.MIT.EDU on the same
X-Git-Url: http://andersk.mit.edu/gitweb/moira.git/commitdiff_plain/2a467737f7969cbd00dbc489b991e9b520d29852?hp=8e023d2aa797ad48d189596f3f35ef1117329684

Fix a bug where having USER:foo and KERBEROS:foo@ATHENA.MIT.EDU on the same
ACL would cause internal errors and `permission denied' to the user.
---

diff --git a/server/qrtn.pc b/server/qrtn.pc
index c5fc6765..0f1a8b89 100644
--- a/server/qrtn.pc
+++ b/server/qrtn.pc
@@ -577,7 +577,8 @@ int find_member(list_type, list_id, cl)
     flag = 0;
     users_id = cl->users_id;
     client_id = -cl->client_id;
-    EXEC SQL SELECT member_id INTO :flag FROM imembers WHERE list_id = :list_id
+    EXEC SQL SELECT COUNT(member_id) INTO :flag FROM imembers
+	WHERE list_id = :list_id
 	AND ( ( member_type = 'USER' AND member_id = :users_id )
 	      OR (member_type = 'KERBEROS' AND member_id = :client_id ) );
     if (sqlca.sqlcode == 0)