Print Page | Close Window

WL_AutoWhiteListForceDelivery.txt not refreshed

Printed From: LogSat Software
Category: Spam Filter ISP
Forum Name: Spam Filter ISP Support
Forum Description: General support for Spam Filter ISP
URL: https://www.logsat.com/spamfilter/forums/forum_posts.asp?TID=6624
Printed Date: 05 February 2025 at 5:55pm


Topic: WL_AutoWhiteListForceDelivery.txt not refreshed
Posted By: rudaf
Subject: WL_AutoWhiteListForceDelivery.txt not refreshed
Date Posted: 05 March 2009 at 1:24pm
SFE 4.0.1.785
SQL SERVER 2000 STD
OS WIN 2KSVR SP4
 
1) We have updated data in tblwl_autowhitelistforcedelivery removing all mailto:USER@DOMAIN|USER@DOMAIN - USER@DOMAIN|USER@DOMAIN rule in order to avoid domain spoofing (see my last post on this matter)
 
2) users keep on receiving spoofing account spam messages
 
3) we have noted that in "SpamFilter\domains" directory, WL_AutoWhiteListForceDelivery.txt is older then db updating and keeps on mantaining mailto:USER@DOMAIN%7CUSER@DOMAIN - USER@DOMAIN|USER@DOMAIN rule despite related db rule deletion
 
4) log reporting "Exception occurred during ChecktblReloadTableInfo: String or binary data would be truncated" (does it matter?)
 
Any idea?
 
 


Replies:
Posted By: LogSat
Date Posted: 05 March 2009 at 9:51pm
rudaf,

That log error should not be occurring, and it may be the culprit. Could you please zip and email us your SpamFilter's activity logfile for the day above so we can take a look? If the zip is over 7MB in size, please use our FTP site - I'll send the login via PM

-------------
Roberto Franceschetti

http://www.logsat.com" rel="nofollow - LogSat Software

http://www.logsat.com/sfi-spam-filter.asp" rel="nofollow - Spam Filter ISP

Posted By: LogSat
Date Posted: 08 March 2009 at 8:40pm
rudaf,


We received your logfile, but it only contains 15 minutes worth of entries, so we're unable to see if there are any other issues that can be contributing to the error you reported.


Can you please upload to the ftp site a zip containing the activity logfile for the entire day? From the errors we do see, there could be an issue with the contents of the tblReloadTableInfo table in SpamFilter's database. Are you able to export the contents of that table to a text file so we can try to see what could be wrong?

-------------
Roberto Franceschetti

http://www.logsat.com" rel="nofollow - LogSat Software

http://www.logsat.com/sfi-spam-filter.asp" rel="nofollow - Spam Filter ISP

Posted By: rudaf
Date Posted: 09 March 2009 at 9:50am

Log + Excel with tblreloadtableinfo data is being upload to your ftp

regards

Posted By: LogSat
Date Posted: 09 March 2009 at 7:52pm
rudaf,

We may have found the issue. Can you please try editing the table "tblReloadTableInfo" in SpamFilter's database, and increasing the "TableName" field size from a varchar(45) to varchar(65)?

It seems as if the size of the ID field in one of your tables has exceeded the maximum size we allocated for it, and the above increase will adjust for it.

-------------
Roberto Franceschetti

http://www.logsat.com" rel="nofollow - LogSat Software

http://www.logsat.com/sfi-spam-filter.asp" rel="nofollow - Spam Filter ISP


Print Page | Close Window