From 864e96cfa492904f2b9da30103a7b5c056d27f84 Mon Sep 17 00:00:00 2001 From: "Jean-Marc Pigeon (Delson)" Date: Sat, 12 Jul 2025 09:54:41 -0400 Subject: [PATCH] Working to define remotes table contents --- conf/blacklister.conf | 8 ++++++++ conf/mailleur.conf | 1 + conf/mailleur.conf.dvl | 2 ++ sql/datatest.sql | 10 +++++++--- sql/mailleur.sql | 8 +++++--- 5 files changed, 23 insertions(+), 6 deletions(-) create mode 100644 conf/blacklister.conf diff --git a/conf/blacklister.conf b/conf/blacklister.conf new file mode 100644 index 0000000..a8b737e --- /dev/null +++ b/conf/blacklister.conf @@ -0,0 +1,8 @@ +#dnsbl.sorbs.net +t1.dnsbl.net.au +#checked 2025-07-12 by preference order +bl.spamcop.net +b.barracudacentral.org +bl.blocklist.de +ips.backscatterer.org +dnsbl.dronebl.org diff --git a/conf/mailleur.conf b/conf/mailleur.conf index 54406b8..c5e6a33 100644 --- a/conf/mailleur.conf +++ b/conf/mailleur.conf @@ -51,3 +51,4 @@ DB_LANG="UTF-8" #Dovecot storage directory DOV_MAILDIR="/var/spool/mailleur/mails" #------------------------------------------------ +BLACKLIST=/etc/mailleur/blacklister.conf diff --git a/conf/mailleur.conf.dvl b/conf/mailleur.conf.dvl index 43ca12d..466ec80 100644 --- a/conf/mailleur.conf.dvl +++ b/conf/mailleur.conf.dvl @@ -54,3 +54,5 @@ DB_PORT=3306 DOV_MAILDIR="/var/spool/mailleur/mails" #------------------------------------------------ SMTPPORTS="|127.127.10.25|1025|5,smtps|127.127.10.26|1465|3,smtp|127.127.10.26|1587|2" +#------------------------------------------------ +BLACKLIST=/home/jmp/safe-mailleur/mailleur/conf/blacklister.conf diff --git a/sql/datatest.sql b/sql/datatest.sql index 3c13cf8..9e74672 100644 --- a/sql/datatest.sql +++ b/sql/datatest.sql @@ -34,13 +34,17 @@ INSERT INTO remotes (remoteip,credit,status) \ //--------------------------------------------------------------- //selected IP from 'known' spammer INSERT INTO remotes (remoteip) \ - values ('216.246.113.145'); + values ('27.151.45.98'); +INSERT INTO remotes (remoteip) \ + values ('91.199.160.44'); +INSERT INTO remotes (remoteip) \ + values ('122.175.193.134'); INSERT INTO remotes (remoteip) \ values ('176.53.146.143'); INSERT INTO remotes (remoteip) \ - values ('27.151.45.98'); + values ('209.85.218.68'); INSERT INTO remotes (remoteip) \ - values ('91.199.160.44'); + values ('216.246.113.145'); //selected IP from from 'clean' server INSERT INTO remotes (remoteip) \ diff --git a/sql/mailleur.sql b/sql/mailleur.sql index c67489c..5de459c 100644 --- a/sql/mailleur.sql +++ b/sql/mailleur.sql @@ -106,12 +106,14 @@ CREATE TABLE remotes ( DFLT NOW(), lastupdate DBTIMESTAMP //record creation DFLT NOW(), - links INTEGER - DFLT 1, //how many time the remote connected credit INTEGER //Remote IP current credit (-100..+100) DFLT -100, status TEXT //'toscan','inscan','valide' - DFLT 'toscan' + DFLT 'toscan', + listed TEXT //explaination obout black listing + DFLT NULL, + links INTEGER + DFLT 1 //how many time the remote connected ); CREATE INDEX remotes_ndx ON remotes (INS(status)); INSERT INTO remotes (remoteip,credit,status) \ -- 2.47.3