From mboxrd@z Thu Jan 1 00:00:00 1970 Return-Path: Received: from us-smtp-1.mimecast.com (us-smtp-delivery-1.mimecast.com [205.139.110.120]) by sourceware.org (Postfix) with ESMTP id A3F113851C22 for ; Thu, 4 Jun 2020 21:07:04 +0000 (GMT) DMARC-Filter: OpenDMARC Filter v1.3.2 sourceware.org A3F113851C22 Received: from mail-qt1-f197.google.com (mail-qt1-f197.google.com [209.85.160.197]) (Using TLS) by relay.mimecast.com with ESMTP id us-mta-298-dv7kLjNPOs247DiXke2bhQ-1; Thu, 04 Jun 2020 17:07:03 -0400 X-MC-Unique: dv7kLjNPOs247DiXke2bhQ-1 Received: by mail-qt1-f197.google.com with SMTP id y7so6289863qti.8 for ; Thu, 04 Jun 2020 14:07:02 -0700 (PDT) X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:to:from:subject:organization:message-id:date :user-agent:mime-version:content-language:content-transfer-encoding; bh=lcoz/SvxdqW587NHqvy+vvucpEMJmSbrCgP6X4Tqw6s=; b=n1C9Tc0SlDbahl/vNDMLTfWskCmn1TOdsp8JwRORsL7Vekfh5a6Oy0A++1cEUdHiek jfwi2duT/prifl9SnEGQnKSiok7g/ThaQLwo7S9+p0vJA4utBxpqiTdXIRPMnYRc2AyP r9snLuu3FmhGExrpHshn/sm6F4/afRCPcMgyydfHNqnLju8GkL/m4xhlcO1nahZ8N7Wm 7Uh79RITAo7k3pMgY0TOyMyHtCbb54g4UQd0YLPDMfTNwAfDD0mLutRJLqC7GeRgm7dI 0iQMh0hvTKgWR6Qp+Dx6T4cofKMaQdyA0uP9O9ggs30FY7CD7fPDT0M6aC6y+RonzDCg Soew== X-Gm-Message-State: AOAM532DyxgGJAB5jBwwEsYVnRDofPnL8cLfzE+ezbXpPN1dsM319NWJ 4ntE4XUrBihmmf5UI5QvL1+5Mb6nVbSEtaYZn+GMYeEOgiKr0MF/rLQeKq+xpD6xr/1L4N/75nP bL3rT59ojQ9QLstCxSXw= X-Received: by 2002:ad4:510c:: with SMTP id g12mr6773216qvp.231.1591304822229; Thu, 04 Jun 2020 14:07:02 -0700 (PDT) X-Google-Smtp-Source: ABdhPJxL1y1tIHr4RF0+Noi7GXZQjrltD6ybh6jAmc560yLZ6hW/Fxt5PHcS+xa6zbfCuW8Sa3gNYQ== X-Received: by 2002:ad4:510c:: with SMTP id g12mr6773175qvp.231.1591304821719; Thu, 04 Jun 2020 14:07:01 -0700 (PDT) Received: from [192.168.1.4] (198-84-170-103.cpe.teksavvy.com. [198.84.170.103]) by smtp.gmail.com with ESMTPSA id d78sm5249468qkg.106.2020.06.04.14.07.00 (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128); Thu, 04 Jun 2020 14:07:01 -0700 (PDT) To: Overseers mailing list , Siddhesh Poyarekar From: Carlos O'Donell Subject: Cleaned out spam accounts from Patchwork / Django. Organization: Red Hat Message-ID: Date: Thu, 4 Jun 2020 17:06:59 -0400 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:68.0) Gecko/20100101 Thunderbird/68.7.0 MIME-Version: 1.0 Content-Language: en-US X-Mimecast-Spam-Score: 0 X-Mimecast-Originator: redhat.com Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit X-Spam-Status: No, score=-7.9 required=5.0 tests=BAYES_00, DKIMWL_WL_HIGH, DKIM_SIGNED, DKIM_VALID, DKIM_VALID_AU, DKIM_VALID_EF, RCVD_IN_DNSWL_NONE, RCVD_IN_MSPIKE_H4, RCVD_IN_MSPIKE_WL, SPF_HELO_NONE, SPF_PASS, TXREP autolearn=ham autolearn_force=no version=3.4.2 X-Spam-Checker-Version: SpamAssassin 3.4.2 (2018-09-13) on server2.sourceware.org X-BeenThere: overseers@sourceware.org X-Mailman-Version: 2.1.29 Precedence: list List-Id: Overseers mailing list List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Thu, 04 Jun 2020 21:07:06 -0000 Siddhesh, FYI. We had 36,000+ django accounts because of spammers creating patchwork accounts over the years, but then not doing anything with them. I have purged the accounts with "is_active==false" which means they created accounts and then never verified them with the post-registration confirmation. We are down to 261 *real* accounts. The reason I did this is that two people have already reached out to me to "unlink" old emails from their patchwork account. When you "unlink" an email you have to confirm the unlinking by responding from that email. This is dumb because you often have lost control of that old email by leaving your previous employer so most often the "unlink" has to be done by the admin interface and to do that you have to click a dropdown box populated with all user names and select "----------" to unlink the patchwork person from the associated django account (Home>Patcwork>People). On Firefox clicking a dropdown populated with 36,000+ entries completely hangs firefox forever. If spammers get to be a problem we'll need a cron job to purge is_active==false accounts that are older than a certain date and do it with python to interface to django to do the admin action. I'm not sure how to script this, but I just wanted to tell you what I just did, why, and that it's a problem. -- Cheers, Carlos.