LogSat Software

Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic

   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

Author	Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic
burdsjm Members Profile Send Private Message Find Members Posts Add to Buddy List Newbie Joined: 21 February 2005 Location: United States Status: Offline Points: 12	Post Options Post Reply Quote burdsjm Report Post Thanks(0) Quote Reply 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

burdsjm Members Profile Send Private Message Find Members Posts Add to Buddy List Newbie Joined: 21 February 2005 Location: United States Status: Offline Points: 12	Post Options Post Reply Quote burdsjm Report Post 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 Members Profile Send Private Message Find Members Posts Add to Buddy List Newbie Joined: 21 February 2005 Location: United States Status: Offline Points: 12	Post Options Post Reply Quote burdsjm Report Post 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 Members Profile Send Private Message Find Members Posts Add to Buddy List Newbie Joined: 21 February 2005 Location: United States Status: Offline Points: 12	Post Options Post Reply Quote burdsjm Report Post 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 Members Profile Send Private Message Find Members Posts Add to Buddy List Senior Member Joined: 27 January 2005 Location: United States Status: Offline Points: 1143	Post Options Post Reply Quote Desperado Report Post 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 Members Profile Send Private Message Find Members Posts Add to Buddy List Newbie Joined: 21 February 2005 Location: United States Status: Offline Points: 12	Post Options Post Reply Quote burdsjm Report Post Thanks(0) Quote Reply Posted: 28 March 2005 at 5:59pm
	That was it no more errors. Thanks alot Desperado.
	Jason

LogSat Members Profile Send Private Message Find Members Posts Add to Buddy List Admin Group Joined: 25 January 2005 Location: United States Status: Offline Points: 4104	Post Options Post Reply Quote LogSat Report Post 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.
	Roberto Franceschetti LogSat Software Spam Filter ISP

LogSat Software

Site Navigation[Skip]

Spam Filter ISP Support Forum

Quarantine Database