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
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 Topic: Quarantine Database
    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
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
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: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
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 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 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
 Post Reply Post Reply
  Share Topic   

Forum Jump Forum Permissions View Drop Down



This page was generated in 0.062 seconds.