Quarantine Database |
Post Reply 
|
| Author | |
burdsjm 
Newbie 
Joined: 21 February 2005 Location: United States Status: Offline Points: 12 |
 Post Options
 Thanks(0)
 Quote Reply
 Topic: Quarantine DatabasePosted: 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
|
|
 |
|
|
burdsjm
Newbie
Joined: 21 February 2005 Location: United States Status: Offline Points: 12 |
Post Options
Thanks(0)
Quote Reply
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
|
|
|
|
|
burdsjm
Newbie
Joined: 21 February 2005 Location: United States Status: Offline Points: 12 |
Post Options
Thanks(0)
Quote Reply
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
|
|
|
|
|
burdsjm
Newbie
Joined: 21 February 2005 Location: United States Status: Offline Points: 12 |
Post Options
Thanks(0)
Quote Reply
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
|
|
|
|
|
Desperado
Senior Member 
Joined: 27 January 2005 Location: United States Status: Offline Points: 1143 |
Post Options
Thanks(0)
Quote Reply
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 |
|
|
|
|
burdsjm
Newbie
Joined: 21 February 2005 Location: United States Status: Offline Points: 12 |
Post Options
Thanks(0)
Quote Reply
Posted: 28 March 2005 at 5:59pm |
|
That was it no more errors.
Thanks alot Desperado. |
|
|
Jason
|
|
|
|
|
LogSat
Admin Group 
Joined: 25 January 2005 Location: United States Status: Offline Points: 4104 |
Post Options
Thanks(0)
Quote Reply
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. |
|
|
|
Topic Options|
Post Reply
|
|
Tweet
|
| Forum Jump | Forum Permissions You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum |
This page was generated in 0.102 seconds.