[699] in Moira
NetProb ticket #1288, "blanche" allows me to add bogus list members which can't
daemon@ATHENA.MIT.EDU (cdemello@MIT.EDU)
Thu Feb 3 10:05:12 1994
From: cdemello@MIT.EDU
Date: Thu, 3 Feb 94 10:05:04 -0500
To: bug-moira@MIT.EDU
Cc:
>From jik@security.ov.com Tue Jan 25 11:33:13 1994
>Received: by gregor.MIT.EDU (5.57/4.7) id AA05416; Tue, 25 Jan 94 11:33:11 -05>00
>Received: from pad-thai.aktis.com by MIT.EDU with SMTP
> id AA11964; Tue, 25 Jan 94 11:33:04 EST
>Received: from gza-client1.aktis.com by pad-thai.aktis.com (8.6.4/) with ESMTP>
> id <LAA29472@pad-thai.aktis.com>; Tue, 25 Jan 1994 11:34:19 -0500
>Received: from localhost by gza-client1.aktis.com (8.6.4/4.7) id LAA21862; Tue>, 25 Jan 1994 11:34:17 -0500
>Date: Tue, 25 Jan 1994 11:34:17 -0500
>Message-Id: <199401251634.LAA21862@gza-client1.aktis.com>
>From: "Jonathan I. Kamens" <jik@security.ov.com>
>To: bugs@MIT.EDU
>Subject: "blanche" allows me to add bogus list members which can't be deleted
>Reply-To: news-answers-request@MIT.EDU
>Cc: news-answers-request@BLOOM-PICAYUNE.MIT.EDU
>
>Yesterday, one of the *.answers moderators accidentally did "blanche
>faq-maintainers -file
>/afs/sipb/project/periodic-postings/news.answers/faq-maintainers",
>rather than running the script which strips out comments and full
>names from the addresses in that file before feeding it to blanche.
>
>As a result, a bunch of bogus entries were added to the
>faq-maintainers list. After realizing the error, the moderator ran
>/afs/sipb/project/periodic-postings/news.answers/update-lists, which
>does the correct stripping, but it failed to restore the list to its
>correct status. The following errors were output by blanche:
>
>Deleting member STRING:# and he thinks it'll be fixed in a day or so.
>blanche: Unknown string while deleting member # and he thinks it'll be fixed> in a day or so. from faq-maintainers
>Deleting member STRING:# well as pointed out that it isn't fixed yet.
>blanche: Unknown string while deleting member # well as pointed out that it >isn't fixed yet. from faq-maintainers
>Deleting member STRING:# doesn't know what happened to him.
>blanche: Unknown string while deleting member # doesn't know what happened to >him. from faq-maintainers
>Deleting member STRING:darcy@druid.com (D'Arcy J.M. Cain)
>blanche: Unknown string while deleting member darcy@druid.com (D'Arcy J.M. Cai>n) from faq-maintainers
>Deleting member STRING:gerben@cs.vu.nl (Gerben 'P' Vos)
>blanche: Unknown string while deleting member gerben@cs.vu.nl (Gerben 'P' Vos)> from faq-maintainers
>
>Note that all of the problematic strings have apostrophes in them.
>
>I attempted to remove these strings with moira and then with mrtest,
>including trying various forms of quoting in mrtest, and I was unable
>to remove them. It appears that they simply cannot be removed without
>issuing SQL commands on the Moira database.
>
>This is, needless, to say, a Bad Thing.
>
> jik
>
