From mboxrd@z Thu Jan  1 00:00:00 1970
Return-Path: <s.ivanov@proxmox.com>
Received: from firstgate.proxmox.com (firstgate.proxmox.com [212.224.123.68])
 (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits)
 key-exchange X25519 server-signature RSA-PSS (2048 bits))
 (No client certificate requested)
 by lists.proxmox.com (Postfix) with ESMTPS id 7BF9471B61
 for <pmg-devel@lists.proxmox.com>; Fri, 11 Jun 2021 17:55:01 +0200 (CEST)
Received: from firstgate.proxmox.com (localhost [127.0.0.1])
 by firstgate.proxmox.com (Proxmox) with ESMTP id 77D1815136
 for <pmg-devel@lists.proxmox.com>; Fri, 11 Jun 2021 17:55:01 +0200 (CEST)
Received: from proxmox-new.maurer-it.com (proxmox-new.maurer-it.com
 [94.136.29.106])
 (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits)
 key-exchange X25519 server-signature RSA-PSS (2048 bits))
 (No client certificate requested)
 by firstgate.proxmox.com (Proxmox) with ESMTPS id 0606315118
 for <pmg-devel@lists.proxmox.com>; Fri, 11 Jun 2021 17:54:59 +0200 (CEST)
Received: from proxmox-new.maurer-it.com (localhost.localdomain [127.0.0.1])
 by proxmox-new.maurer-it.com (Proxmox) with ESMTP id 9BB3942F7F
 for <pmg-devel@lists.proxmox.com>; Fri, 11 Jun 2021 17:54:59 +0200 (CEST)
From: Stoiko Ivanov <s.ivanov@proxmox.com>
To: pmg-devel@lists.proxmox.com
Date: Fri, 11 Jun 2021 17:54:45 +0200
Message-Id: <20210611155447.9162-1-s.ivanov@proxmox.com>
X-Mailer: git-send-email 2.20.1
MIME-Version: 1.0
Content-Transfer-Encoding: 8bit
X-SPAM-LEVEL: Spam detection results:  0
 AWL 0.902 Adjusted score from AWL reputation of From: address
 BAYES_00                 -1.9 Bayes spam probability is 0 to 1%
 KAM_DMARC_STATUS 0.01 Test Rule for DKIM or SPF Failure with Strict Alignment
 SPF_HELO_NONE           0.001 SPF: HELO does not publish an SPF Record
 SPF_PASS               -0.001 SPF: sender matches SPF record
 URIBL_BLOCKED 0.001 ADMINISTRATOR NOTICE: The query to URIBL was blocked. See
 http://wiki.apache.org/spamassassin/DnsBlocklists#dnsbl-block for more
 information. [cluster.pm, dbtools.pm]
Subject: [pmg-devel] [PATCH pmg-api 0/2] remove unused greylist table column
 and make test_gl more robust
X-BeenThere: pmg-devel@lists.proxmox.com
X-Mailman-Version: 2.1.29
Precedence: list
List-Id: Proxmox Mail Gateway development discussion
 <pmg-devel.lists.proxmox.com>
List-Unsubscribe: <https://lists.proxmox.com/cgi-bin/mailman/options/pmg-devel>, 
 <mailto:pmg-devel-request@lists.proxmox.com?subject=unsubscribe>
List-Archive: <http://lists.proxmox.com/pipermail/pmg-devel/>
List-Post: <mailto:pmg-devel@lists.proxmox.com>
List-Help: <mailto:pmg-devel-request@lists.proxmox.com?subject=help>
List-Subscribe: <https://lists.proxmox.com/cgi-bin/mailman/listinfo/pmg-devel>, 
 <mailto:pmg-devel-request@lists.proxmox.com?subject=subscribe>
X-List-Received-Date: Fri, 11 Jun 2021 15:55:01 -0000

These two patches are the result from some intial trials to build and test
PMG on debian bullseye

The first drops a deprecated database column, and since I consider changes
to the database schema somewhat sensitive I'd like another set of eyes
to look over the changes

the second patch addresses a timing issue in test_greylist.pl, which
causes the tests to fail, because the policy daemon is not accepting
connections early enough (at least on my test-container with bullseye)
One alternative would be to skip the greylist tests here which would
enables building as non-root user.

Stoiko Ivanov (2):
  greylisting: drop unneeded Host column form cgreylist table
  tests: greylist: retry connecting 3 times

 src/PMG/Cluster.pm         |  3 +--
 src/PMG/DBTools.pm         | 21 +++++++++++++++------
 src/bin/pmgpolicy          |  6 ++----
 src/tests/test_greylist.pl | 14 ++++++++++----
 4 files changed, 28 insertions(+), 16 deletions(-)

-- 
2.20.1