Spam Filter ISP Support Forum

  New Posts New Posts RSS Feed - Quarantine Database
  FAQ FAQ  Forum Search   Register Register  Login Login

Quarantine Database

 Post Reply Post Reply
Author
burdsjm View Drop Down
Newbie
Newbie


Joined: 21 February 2005
Location: United States
Status: Offline
Points: 12
Post Options Post Options   Thanks (0) Thanks(0)   Quote burdsjm Quote  Post ReplyReply Direct Link To This Post Topic: Quarantine Database
    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
Back to Top
burdsjm View Drop Down
Newbie
Newbie


Joined: 21 February 2005
Location: United States
Status: Offline
Points: 12
Post Options Post Options   Thanks (0) Thanks(0)   Quote burdsjm Quote  Post ReplyReply Direct Link To This Post 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
Back to Top
burdsjm View Drop Down
Newbie
Newbie


Joined: 21 February 2005
Location: United States
Status: Offline
Points: 12
Post Options Post Options   Thanks (0) Thanks(0)   Quote burdsjm Quote  Post ReplyReply Direct Link To This Post 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
Back to Top
burdsjm View Drop Down
Newbie
Newbie


Joined: 21 February 2005
Location: United States
Status: Offline
Points: 12
Post Options Post Options   Thanks (0) Thanks(0)   Quote burdsjm Quote  Post ReplyReply Direct Link To This Post 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
Back to Top
Desperado View Drop Down
Senior Member
Senior Member
Avatar

Joined: 27 January 2005
Location: United States
Status: Offline
Points: 1143
Post Options Post Options   Thanks (0) Thanks(0)   Quote Desperado Quote  Post ReplyReply Direct Link To This Post 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

Back to Top
burdsjm View Drop Down
Newbie
Newbie


Joined: 21 February 2005
Location: United States
Status: Offline
Points: 12
Post Options Post Options   Thanks (0) Thanks(0)   Quote burdsjm Quote  Post ReplyReply Direct Link To This Post Posted: 28 March 2005 at 5:59pm
That was it no more errors. 

Thanks alot Desperado.
Jason
Back to Top
LogSat View Drop Down
Admin Group
Admin Group
Avatar

Joined: 25 January 2005
Location: United States
Status: Offline
Points: 4065
Post Options Post Options   Thanks (0) Thanks(0)   Quote LogSat Quote  Post ReplyReply Direct Link To This Post 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

LogSat Software

Spam Filter ISP
Back to Top
 Post Reply Post Reply
  Share Topic   

Forum Jump Forum Permissions View Drop Down



This page was generated in 0.078 seconds.