From b87cdedd024ab267ce20f2eebaad5ad24c201de6 Mon Sep 17 00:00:00 2001 From: "Jean-Marc Pigeon (Delson)" Date: Fri, 15 Aug 2025 10:25:25 -0400 Subject: [PATCH] Adding aliases table --- lib/lvleml.c | 5 ++++- sql/mailleur.sql | 10 ++++++++++ 2 files changed, 14 insertions(+), 1 deletion(-) diff --git a/lib/lvleml.c b/lib/lvleml.c index 7824c28..c8f6a59 100644 --- a/lib/lvleml.c +++ b/lib/lvleml.c @@ -1346,8 +1346,10 @@ static _Bool dohelo(CONTYP *contact,char *parameter) _Bool done; -if ((done=isgoodfqdn(contact,parameter))==false) +if ((done=isgoodfqdn(contact,parameter))==false) { (void) eml_transmit(contact,true,"%d 5.5.4 %s.",BADPAR,DETAIL); + (void) setterminator(contact,"HELO parameter missing"); + } else (void) linkready(contact,false); return done; @@ -1397,6 +1399,7 @@ while (proceed==true) { case 0 : //Do we have a parameter if ((done=isgoodfqdn(contact,parameter))==false) { (void) eml_transmit(contact,true,"%d 5.5.4 %s.",BADPAR,DETAIL); + (void) setterminator(contact,"EHLO parameter missing"); phase=999; //Trouble trouble } break; diff --git a/sql/mailleur.sql b/sql/mailleur.sql index f0a21cb..32aebca 100644 --- a/sql/mailleur.sql +++ b/sql/mailleur.sql @@ -124,6 +124,7 @@ INSERT INTO remotes (remoteip,credit,lastscan) \ CREATE TABLE events ( creation DBTIMESTAMP //record creation DFLT NOW(), + serial AUTOSERIAL, //record unique number sessid TEXTUNIQUE, //Session id start INTEGER, //Event log starting point stop INTEGER //Event log ending point @@ -131,6 +132,15 @@ CREATE TABLE events ( CREATE INDEX event_id_ndx ON events(sessid); CREATE INDEX event_date_ndx ON events(creation); + +//defining table about email aliases +//list of aliases related to ONE email +CREATE TABLE aliases ( + email TEXT, //Email address + alias TEXT //One aliases + ); +CREATE INDEX aliases_id_ndx ON aliases(email); + //-------------------------------------------------------------- //Defining TRIGGER fonctions according database type //-------------------------------------------------------------- -- 2.47.3