[1126] in Moira

home help back first fref pref prev next nref lref last post

Something is amiss: moira logs SQL errors.

daemon@ATHENA.MIT.EDU (Marc Horowitz)
Sat Sep 27 21:59:47 1997

To: danw@MIT.EDU
Cc: bug-moira@MIT.EDU
From: Marc Horowitz <marc@cygnus.com>
Date: 27 Sep 1997 21:59:42 -0400

<1> opus:~> klist
Ticket file:    /tmp/tkt_marc_tf0
Principal:      marc@ATHENA.MIT.EDU

  Issued           Expires          Principal
Sep 27 21:29:11  Sep 28 07:29:11  krbtgt.ATHENA.MIT.EDU@ATHENA.MIT.EDU
Sep 27 21:29:12  Sep 28 07:29:12  rcmd.opus@ATHENA.MIT.EDU
Sep 27 21:29:12  Sep 28 07:29:12  afs.athena.mit.edu@ATHENA.MIT.EDU
Sep 27 21:29:35  Sep 28 07:29:35  afs.sipb.mit.edu@ATHENA.MIT.EDU
Sep 27 21:29:36  Sep 28 07:29:36  afs.net.mit.edu@ATHENA.MIT.EDU
Sep 27 21:29:45  Sep 28 07:29:45  olc.matisse@ATHENA.MIT.EDU
Sep 27 21:29:53  Sep 28 07:29:53  zephyr.zephyr@ATHENA.MIT.EDU
Sep 27 21:30:31  Sep 28 07:30:31  daemon.minos@ATHENA.MIT.EDU
Sep 27 21:52:51  Sep 28 07:32:51  moira.moira3@ATHENA.MIT.EDU
<2> opus:~> blanche -a jfmurphy sipb-staff
blanche: Insufficient permission to perform requested database access while adding member jfmurphy to sipb-staff
Exit 1

And at the moment I try the blanche, moira zephyrs:

    Class Moira.Moira
    from root <UNAUTH> on moira3.mit.edu at 21:55:55
    Moira server encountered DBMS ERROR 2112
    SQL-02112: PCC: SELECT..INTO returns too many rows

The list structure is like this.

<3> opus:~> blanche -i sipb-staff
List: sipb-staff
Description: SIPB people actively involved in stuff
Flags: active, private, and visible
sipb-staff is a maillist and is not a group
Owner: LIST sipb-acl
Last modified by yonah with blanche on 27-sep-1997 21:53:58
<4> opus:~> blanche -m sipb-acl | grep marc
marc
LIST:marc
<5> opus:~> blanche -m marc 
marc
KERBEROS:marc.extra@ATHENA.MIT.EDU
KERBEROS:marc.root@ATHENA.MIT.EDU
KERBEROS:marc@ATHENA.MIT.EDU
KERBEROS:marc@CYGNUS.COM

		Marc

home help back first fref pref prev next nref lref last post