From d6afa1e96d78b430765ee727a2d5381e709a2d30 Mon Sep 17 00:00:00 2001 From: Jean-Marc Pigeon Date: Fri, 19 Sep 2025 03:53:59 -0400 Subject: [PATCH] Improving data-feed file --- data-feed/feed005.tst | 6 +++--- data-feed/feed006.tst | 4 ++-- data-feed/feed12.tst | 1 + sql/datatest.sql | 48 ++++++++++++++++++++++--------------------- 4 files changed, 31 insertions(+), 28 deletions(-) diff --git a/data-feed/feed005.tst b/data-feed/feed005.tst index cbd80a1..4eac57e 100644 --- a/data-feed/feed005.tst +++ b/data-feed/feed005.tst @@ -2,12 +2,12 @@ T:(feed005) Email testing remote server credential C:CONNECT #==================================================== R:220 mailleur.example.com, ESMTP (cleartext) mailleur... -C:ORGN: 91.199.160.44 +C:ORGN: 213.209.157.107 R:220 mailleur.example.com, ESMTP (cleartext) mailleur... S:helo example.com -R:250 mailleur.example.com, link (cleartext) ready, your IP/FQDN=[91.199.160.44/s1340044.smartape-vps.com] +R:250 mailleur.example.com, link (cleartext) ready, your IP/FQDN=[213.209.157.107/No.Reverse] S:MAIL FROM: -R:556-4.5.7 Originator server IP [91.199.160.44] black listed... +R:556-4.5.7 Originator server IP [213.209.157.107] black listed... R:556 5.5.4 Closing connection R:Disconnected #------------------------------------------------------------------------- diff --git a/data-feed/feed006.tst b/data-feed/feed006.tst index 3c863d1..8da7b69 100644 --- a/data-feed/feed006.tst +++ b/data-feed/feed006.tst @@ -2,11 +2,11 @@ T:(feed006) Email testing BAD remote server credential in case of authentication C:CONNECT #==================================================== R:220 mailleur.example.com, ESMTP (cleartext) mailleur... -C:ORGN: 91.199.160.44 +C:ORGN: 213.209.157.107 R:220 mailleur.example.com, ESMTP (cleartext) mailleur... C:GOTLS S:EHLO example.com -R:250-mailleur.example.com, link (crypted) ready, your IP/FQDN=[91.199.160.44/s1340044.smartape-vps.com] +R:250-mailleur.example.com, link (crypted) ready, your IP/FQDN=[213.209.157.107/No.Reverse] R:250-AUTH PLAIN LOGIN DIGEST-MD5 R:250-SIZE 52428800 R:250-8BITMIME diff --git a/data-feed/feed12.tst b/data-feed/feed12.tst index c1345a8..2e3353f 100644 --- a/data-feed/feed12.tst +++ b/data-feed/feed12.tst @@ -1,5 +1,6 @@ #==================================================== T:(feed12) Trying to send Email while the domain is without MX +C:CONNECT R:220 mailleur.example.com, ESMTP (cleartext) mailleur... #==================================================== S:HELO example.com diff --git a/sql/datatest.sql b/sql/datatest.sql index 0fead17..4df35a7 100644 --- a/sql/datatest.sql +++ b/sql/datatest.sql @@ -37,36 +37,38 @@ INSERT INTO emails (email,password) \ //============================================================== //List of remote IP status +//good credit IP INSERT INTO remotes (remoteip,credit,lastscan) \ values ('127.127.0.25',10,now()); //--------------------------------------------------------------- -INSERT INTO remotes (remoteip) \ - values ('27.151.45.98'); -INSERT INTO remotes (remoteip) \ - values ('45.197.14.139'); -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 ('209.85.218.68'); -INSERT INTO remotes (remoteip) \ - values ('216.246.113.145'); -INSERT INTO remotes (remoteip) \ - values ('193.111.208.122'); +//low credit IP +INSERT INTO remotes (remoteip,credit,lastscan) \ + values ('27.151.45.98',-5,now()); +INSERT INTO remotes (remoteip,credit,lastscan) \ + values ('45.197.14.139',-5,now()); +INSERT INTO remotes (remoteip,credit,lastscan) \ + values ('213.209.157.107',-5,now()); +INSERT INTO remotes (remoteip,credit,lastscan) \ + values ('122.175.193.134',-5,now()); +INSERT INTO remotes (remoteip,credit,lastscan) \ + values ('176.53.146.143',-5,now()); +INSERT INTO remotes (remoteip,credit,lastscan) \ + values ('209.85.218.68',-5,now()); +INSERT INTO remotes (remoteip,credit,lastscan) \ + values ('216.246.113.145',-5,now()); +INSERT INTO remotes (remoteip,credit,lastscan) \ + values ('193.111.208.122',-5,now()); //============================================================== //selected IP from from 'clean' server -INSERT INTO remotes (remoteip) \ - values ('192.219.254.189'); -INSERT INTO remotes (remoteip) \ - values ('216.252.69.41'); +INSERT INTO remotes (remoteip,credit,lastscan) \ + values ('192.219.254.189',100,now()); +INSERT INTO remotes (remoteip,credit,lastscan) \ + values ('216.252.69.41',100,now()); -//selected IP with low credit -INSERT INTO remotes (remoteip,credit) \ - values ('127.127.127.127',-50); +//selected IP with with very low credit +INSERT INTO remotes (remoteip,credit,lastscan) \ + values ('127.127.127.127',-50,now()); //============================================================== //defining admin user -- 2.47.3