Quarantine Database
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=5111
Printed Date: 12 March 2025 at 7:48am
Topic: Quarantine Database
Posted By: burdsjm
Subject: Quarantine Database
Date Posted: 28 March 2005 at 11:15am
Just got the new beta software with the antivirus working. It's pretty smooth.
My next step with the software was to get a Quarantine
database running. I tried to follow the steps on the software and
it's doesn't seem to be working. I am using a NT 4.0 Server as an
OS.
Do I need to have MSAccess installed?
What do I need to put in the string box?
Thanks,
Jason
Carnegie-Stout Public Library
jburds@stout.dubuque.lib.ia.us
-------------
Jason
|
Replies:
Posted By: burdsjm
Date Posted: 28 March 2005 at 1:02pm
When I try to click on the 3 dots next the connection string or when I try to test DB connection the program crashes on me.
Dr. Watson for Window's NT error is SpamFilterSvc.e.exe
Exception: access violation (0xc0000005), Address: 0x004004e4
-------------
Jason
|
Posted By: burdsjm
Date Posted: 28 March 2005 at 3:07pm
Ok got it to take a string and build a database but now it crashes when I click on the Create/Check tables button on step 2
-------------
Jason
|
Posted By: burdsjm
Date Posted: 28 March 2005 at 5:36pm
Ok got it to go active but when I create the table information I get these errors.
================
please wait...
Found tblQuarantine
Found tblMsgs
Found tblRejectCodes
Found tblLogins
Found tblServers
Adding default Reject Codes...
Error working with tblRejectCodes - You have an error in your SQL
syntax; check the manual that corresponds to your MySQL server version
for the right syntax to use near '.`tblRejectCodes`
(`RejectID`,`RejectDesc`) VALUES (1,'Domain is in local blackl' at line
1
Error working with tblServers - You have an error in your SQL syntax;
check the manual that corresponds to your MySQL server version for the
right syntax to use near '.`tblServers` (`ServerName`) VALUES
('csplspam')' at line 1
Error updading/checking tblRejectCodes - You have an error in your SQL
syntax; check the manual that corresponds to your MySQL server version
for the right syntax to use near '.`tblRejectCodes`
(`RejectID`,`RejectDesc`) VALUES (1,'Domain is in local blackl' at line
1
Error updading/checking tblRejectCodes - You have an error in your SQL
syntax; check the manual that corresponds to your MySQL server version
for the right syntax to use near '.`tblRejectCodes`
(`RejectID`,`RejectDesc`) VALUES (2,'EmailFrom is in local bla' at line
1
Error updading/checking tblRejectCodes - You have an error in your SQL
syntax; check the manual that corresponds to your MySQL server version
for the right syntax to use near '.`tblRejectCodes`
(`RejectID`,`RejectDesc`) VALUES (3,'Reverse DNS not found')' at line 1
Error updading/checking tblRejectCodes - You have an error in your SQL
syntax; check the manual that corresponds to your MySQL server version
for the right syntax to use near '.`tblRejectCodes`
(`RejectID`,`RejectDesc`) VALUES (4,'Empty Mail From')' at line 1
Error updading/checking tblRejectCodes - You have an error in your SQL
syntax; check the manual that corresponds to your MySQL server version
for the right syntax to use near '.`tblRejectCodes`
(`RejectID`,`RejectDesc`) VALUES (5,'Mail From and Mail To are' at line
1
Error updading/checking tblRejectCodes - You have an error in your SQL
syntax; check the manual that corresponds to your MySQL server version
for the right syntax to use near '.`tblRejectCodes`
(`RejectID`,`RejectDesc`) VALUES (6,'Mail From and Mail To dom' at line
1
Error updading/checking tblRejectCodes - You have an error in your SQL
syntax; check the manual that corresponds to your MySQL server version
for the right syntax to use near '.`tblRejectCodes`
(`RejectID`,`RejectDesc`) VALUES (7,'Exceeded maximum number o' at line
1
Error updading/checking tblRejectCodes - You have an error in your SQL
syntax; check the manual that corresponds to your MySQL server version
for the right syntax to use near '.`tblRejectCodes`
(`RejectID`,`RejectDesc`) VALUES (8,'IP address is from a blac' at line
1
Error updading/checking tblRejectCodes - You have an error in your SQL
syntax; check the manual that corresponds to your MySQL server version
for the right syntax to use near '.`tblRejectCodes`
(`RejectID`,`RejectDesc`) VALUES (9,'EmailTO is in local black' at line
1
Error updading/checking tblRejectCodes - You have an error in your SQL
syntax; check the manual that corresponds to your MySQL server version
for the right syntax to use near '.`tblRejectCodes`
(`RejectID`,`RejectDesc`) VALUES (10,'EmailTO is not in Author' at line
1
Error updading/checking tblRejectCodes - You have an error in your SQL
syntax; check the manual that corresponds to your MySQL server version
for the right syntax to use near '.`tblRejectCodes`
(`RejectID`,`RejectDesc`) VALUES (11,'no relay allowed or % fo' at line
1
Error updading/checking tblRejectCodes - You have an error in your SQL
syntax; check the manual that corresponds to your MySQL server version
for the right syntax to use near '.`tblRejectCodes`
(`RejectID`,`RejectDesc`) VALUES (12,'IP found in MAPS search'' at line
1
Error updading/checking tblRejectCodes - You have an error in your SQL
syntax; check the manual that corresponds to your MySQL server version
for the right syntax to use near '.`tblRejectCodes`
(`RejectID`,`RejectDesc`) VALUES (13,'Keywords found in conten' at line
1
Error updading/checking tblRejectCodes - You have an error in your SQL
syntax; check the manual that corresponds to your MySQL server version
for the right syntax to use near '.`tblRejectCodes`
(`RejectID`,`RejectDesc`) VALUES (14,'Statistical filter match' at line
1
Error updading/checking tblRejectCodes - You have an error in your SQL
syntax; check the manual that corresponds to your MySQL server version
for the right syntax to use near '.`tblRejectCodes`
(`RejectID`,`RejectDesc`) VALUES (15,'SPF Sender Policy Framew' at line
1
Error updading/checking tblRejectCodes - You have an error in your SQL
syntax; check the manual that corresponds to your MySQL server version
for the right syntax to use near '.`tblRejectCodes`
(`RejectID`,`RejectDesc`) VALUES (16,'Invalid sender domain MX' at line
1
Error updading/checking tblRejectCodes - You have an error in your SQL
syntax; check the manual that corresponds to your MySQL server version
for the right syntax to use near '.`tblRejectCodes`
(`RejectID`,`RejectDesc`) VALUES (17,'Virus Found in email')' at line 1
Done.
Any ideas to point me in the right direction?
-------------
Jason
|
Posted By: Desperado
Date Posted: 28 March 2005 at 5:39pm
|
burdsjm,
Do you have the very latest mdac componant? I thing 2.8 is the latest.
Dan
-------------
The Desperado
Dan Seligmann.
Work: http://www.mags.net
Personal: http://www.desperado.com
|
Posted By: burdsjm
Date Posted: 28 March 2005 at 5:59pm
That was it no more errors.
Thanks alot Desperado.
-------------
Jason
|
Posted By: LogSat
Date Posted: 28 March 2005 at 6:02pm
Jason,
What database platform are you using (MS Access, Microsoft SQL Server,
MySQL or Oracle)? In all cases, the simplest way to setup the database
conneciton is to use a .UDL file to configure the database connection.
Sample .UDL files for all these platform are included in the
SpamFilter\database directory. Simply double-clicking on them from the
Windows Explorer should make a configuration dialog appear. If the
"Test Connection" button works successfully, then SpamFilter should
have no trouble connecting to the database.
Please note that with NT 4 is is strongly recommended to install the
latest MDAC (Microsoft Data Components) from www.microsoft.com/data, as
the older ones that are usually installed on NT4 servers have quite a
few bugs.
-------------
Roberto Franceschetti
http://www.logsat.com" rel="nofollow - LogSat Software
http://www.logsat.com/sfi-spam-filter.asp" rel="nofollow - Spam Filter ISP
|
|