Spam Filter ISP Forums : ToDomain and FromDomain in the Qurantine https://www.logsat.com/spamfilter/forums/ Sun, 12 Jul 2026 20:42:49 +0000 Fri, 30 Jun 2006 04:12:57 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 11.04 360 https://www.logsat.com/spamfilter/forums/RSS_post_feed.asp?TID=5659 <![CDATA[Spam Filter ISP Forums]]> https://www.logsat.com/spamfilter/forums/forum_images/web_wiz_forums.png https://www.logsat.com/spamfilter/forums/ <![CDATA[ToDomain and FromDomain in the Qurantine : Hi,Silly me.I never did &#034;use...]]> https://www.logsat.com/spamfilter/forums/forum_posts.asp?TID=5659&PID=8426&title=todomain-and-fromdomain-in-the-qurantine#8426 Author: ImInAfrica
Subject: 5659
Posted: 30 June 2006 at 4:12am

Hi,
Silly me.
I never did "use spamfilter;"

seems to be working ok now.
Thanks.

Amir
]]> Fri, 30 Jun 2006 04:12:57 +0000 https://www.logsat.com/spamfilter/forums/forum_posts.asp?TID=5659&PID=8426&title=todomain-and-fromdomain-in-the-qurantine#8426 <![CDATA[ToDomain and FromDomain in the Qurantine : Amir,Can you access the MySQL&#039;s...]]> https://www.logsat.com/spamfilter/forums/forum_posts.asp?TID=5659&PID=8421&title=todomain-and-fromdomain-in-the-qurantine#8421 Author: LogSat
Subject: 5659
Posted: 29 June 2006 at 11:00pm

Amir,

Can you access the MySQL's command line interface (use the "mysql" command from a DOS/terminal), and type:

use SpamFilter;

desc tblQuarantine;

show Triggers FROM SpamFilter \G;

and let us know what the output is so we can see the table and trigger structures?
]]> Thu, 29 Jun 2006 23:00:33 +0000 https://www.logsat.com/spamfilter/forums/forum_posts.asp?TID=5659&PID=8421&title=todomain-and-fromdomain-in-the-qurantine#8421 <![CDATA[ToDomain and FromDomain in the Qurantine : Hi,I have tried to run the 3 sql...]]> https://www.logsat.com/spamfilter/forums/forum_posts.asp?TID=5659&PID=8410&title=todomain-and-fromdomain-in-the-qurantine#8410 Author: ImInAfrica
Subject: 5659
Posted: 29 June 2006 at 2:24pm

Hi,
I have tried to run the 3 sql statements in Roberto's post.
the first 2 run fine and create the fields and the indexes.
The third command executes correctly, but then i get this error in the log:
06/29/06 15:56:16:656 -- (7808) Error occurred during TAddToQuarantineThread when accessing the quarantine database: [MySQL][ODBC 3.51 Driver][mysqld-5.0.22-community-nt]Unknown column '@' in 'field list' ( 83 84 85 86 86a 86b 86c 87 88 89 90 91 92 93 94)

Can anyone shed some light on this?

Thanks
Amir
]]> Thu, 29 Jun 2006 14:24:43 +0000 https://www.logsat.com/spamfilter/forums/forum_posts.asp?TID=5659&PID=8410&title=todomain-and-fromdomain-in-the-qurantine#8410 <![CDATA[ToDomain and FromDomain in the Qurantine : Thankyou so much. It works great. ...]]> https://www.logsat.com/spamfilter/forums/forum_posts.asp?TID=5659&PID=8252&title=todomain-and-fromdomain-in-the-qurantine#8252 Author: atifghaffar
Subject: 5659
Posted: 14 June 2006 at 7:45pm

Thankyou so much. It works great.]]> Wed, 14 Jun 2006 19:45:39 +0000 https://www.logsat.com/spamfilter/forums/forum_posts.asp?TID=5659&PID=8252&title=todomain-and-fromdomain-in-the-qurantine#8252 <![CDATA[ToDomain and FromDomain in the Qurantine : mmm, nice. ]]> https://www.logsat.com/spamfilter/forums/forum_posts.asp?TID=5659&PID=8232&title=todomain-and-fromdomain-in-the-qurantine#8232 Author: sgeorge
Subject: 5659
Posted: 13 June 2006 at 4:51pm

mmm, nice.  ]]> Tue, 13 Jun 2006 16:51:36 +0000 https://www.logsat.com/spamfilter/forums/forum_posts.asp?TID=5659&PID=8232&title=todomain-and-fromdomain-in-the-qurantine#8232 <![CDATA[ToDomain and FromDomain in the Qurantine : Atif,Another solution can be implemented...]]> https://www.logsat.com/spamfilter/forums/forum_posts.asp?TID=5659&PID=8231&title=todomain-and-fromdomain-in-the-qurantine#8231 Author: LogSat
Subject: 5659
Posted: 13 June 2006 at 4:33pm

Atif,

Another solution can be implemented using a database trigger that will updated those fields for you on the fly each time a new record is added.

Please execute the following script on MySQL (We tested it using Query Browser v1.1). It will (1) add the two extra fields to the database, (2) create indexes for them, and (3) create a trigger that will automatically populate those fields every time a new record is entered.



ALTER TABLE `spamfilter`.`tblquarantine` ADD COLUMN `ToDomain` VARCHAR(100) AFTER `ServerID`,
  ADD COLUMN `FromDomain` VARCHAR(100) AFTER `ToDomain`;
 
ALTER TABLE `spamfilter`.`tblquarantine` MODIFY COLUMN `ToDomain` VARCHAR(100),
  MODIFY COLUMN `FromDomain` VARCHAR(100),
  ADD INDEX `ToDomain`(`ToDomain`),
  ADD INDEX `FromDomain`(`FromDomain`);
 
DROP TRIGGER trAddExtraData;
DELIMITER //
CREATE TRIGGER trAddExtraData
BEFORE INSERT ON tblQuarantine
  FOR EACH ROW BEGIN
    SET  NEW.ToDomain = MID(NEW.EmailTo, POSITION("@" IN NEW.EmailTO)+1, LENGTH(NEW.EMailTo));
    SET  NEW.FromDomain = MID(NEW.EmailFrom, POSITION("@" IN NEW.EmailFrom)+1, LENGTH(NEW.EMailFrom));
  END;
//
DELIMITER;



 ]]> Tue, 13 Jun 2006 16:33:13 +0000 https://www.logsat.com/spamfilter/forums/forum_posts.asp?TID=5659&PID=8231&title=todomain-and-fromdomain-in-the-qurantine#8231 <![CDATA[ToDomain and FromDomain in the Qurantine : Hi Atif,It sounds like what would...]]> https://www.logsat.com/spamfilter/forums/forum_posts.asp?TID=5659&PID=8224&title=todomain-and-fromdomain-in-the-qurantine#8224 Author: sgeorge
Subject: 5659
Posted: 13 June 2006 at 12:32pm

Hi Atif,

It sounds like what would be ideal for you would be to have an indexed view of your tblQuarantine table - one where whole domain names could be derived as new columns based on the EmailFrom and EmailTo columns, but indexed, so that the domains aren't derived every time you pull up the view.

This seems easy in SQL 2000:
http://www.sqlteam.com/item.asp?ItemID=1015

But it seems that for MySql, like you said, doing a full-text search is the way to go.  I found other people out there who were frustrated by MySql interpreting the hyphen character as a word-seperator, and hence, not interpreting your seach for some-domain.com as a single word.

But I happened upon this comment responding to someone who was trying to search for "kk-4835":
http://archives.neohapsis.com/archives/mysql/2003-q4/2803.ht ml

The only way to search for kk-4835 is to do the search
in Boolean mode and put things in quotes -> “kk-4835”
So your query would look like this:
> SELECT * FROM ms_items
> where MATCH (it_mnfgID, it_title, it_descrip)
> AGAINST ('”kk-4835”' IN BOOLEAN MODE )


Good luck!

Stephen
]]> Tue, 13 Jun 2006 12:32:29 +0000 https://www.logsat.com/spamfilter/forums/forum_posts.asp?TID=5659&PID=8224&title=todomain-and-fromdomain-in-the-qurantine#8224 <![CDATA[ToDomain and FromDomain in the Qurantine : Hi all,I have made a feature request...]]> https://www.logsat.com/spamfilter/forums/forum_posts.asp?TID=5659&PID=8210&title=todomain-and-fromdomain-in-the-qurantine#8210 Author: atifghaffar
Subject: 5659
Posted: 12 June 2006 at 1:01pm

Hi all,

I have made a feature request to add FromDomain and ToDomain in the Quarantine database.

This makes it easy to make reports based on Domain name and for ISPs to let their customer manage all the Domain's blocked email.

The Quarantine database I have is quiet large to search with substrings etc.

I also tried the full-text index on mysql but the full text search syntax does not like some characters used in the domain names: such as "-"

match (EmailFrom) against "some-domain.com"
would match everything where there is "some", ".com" and no "-domain".

I have added the ToDomain and  FromDomain fields and Indexex in the tblQuarantine and am now periodically filling them up with a perl script.

Anyone knows how to achieve this without having the ToDomain, FromDomain fields?



]]> Mon, 12 Jun 2006 13:01:25 +0000 https://www.logsat.com/spamfilter/forums/forum_posts.asp?TID=5659&PID=8210&title=todomain-and-fromdomain-in-the-qurantine#8210