Print Page | Close Window

VistaDB support in the future?

Printed From: LogSat Software
Category: Spam Filter ISP
Forum Name: Spam Filter ISP Support
Forum Description: General support for Spam Filter ISP
URL: http://www.logsat.com/spamfilter/forums/forum_posts.asp?TID=5630
Printed Date: 19 October 2017 at 3:52pm


Topic: VistaDB support in the future?
Posted By: gcpeters
Subject: VistaDB support in the future?
Date Posted: 30 May 2006 at 12:58am

I've been testing the SpamFilter software on an internal basis using SQL Server as the quarantine database engine.  I'm looking at suggesting this product to one of my clients and I developed some software for.  We're currently using VistaDB in their .NET applications because of the cost / licensing / ease of deployment, etc...

I know that this is not one of the supported database, but I gave it a try and I ported the SQL Server schema to VistaDB using their data migration tool.  I'm using an OLEDB provider that is supplied by VistaDB.  I have it working with Spam Filter with a couple of exceptions.  Complaints that a non-nullable column cannot be updated to null when a message arrives.  The only non-nullable field is the primary key which is auto incrementing.  Any suggestions?

Since this isn't a supported DB, I understand if you might not be able to help much on it.  I was wondering if you would consider supporting VistaDB in the future.  It's a really nice database engine.

Thanks,

George



-------------
George Peters
george.peters@aqware.com



Replies:
Posted By: LogSat
Date Posted: 31 May 2006 at 10:42pm
George,

We don't have any plans so far to support that platform. If however you can post the full errors you are seing in the logs we may be able to find a workaround for you tor try.


-------------
Roberto Franceschetti

http://www.logsat.com" rel="nofollow - LogSat Software

http://www.logsat.com/sfi-spam-filter.asp" rel="nofollow - Spam Filter ISP


Posted By: gcpeters
Date Posted: 31 May 2006 at 11:54pm

Thanks for the response.  I had 3 errors originally, but have since resolved one of them by manually updating the database.  I think that if I remove one of these entries and the system attempts to add it back, it'll generate an error again.

05/30/06 00:02:01:593 -- Adding default Reject Codes: Domain is in local blacklist file
05/30/06 00:02:01:609 -- Error updading/checking tblRejectCodes - Non-nullable column cannot be updated to Null
05/30/06 00:02:01:625 -- Adding default Reject Codes: EmailFrom is in local blacklist file
05/30/06 00:02:01:640 -- Error updading/checking tblRejectCodes - Non-nullable column cannot be updated to Null
05/30/06 00:02:01:656 -- Adding default Reject Codes: Reverse DNS not found
05/30/06 00:02:01:671 -- Error updading/checking tblRejectCodes - Non-nullable column cannot be updated to Null
05/30/06 00:02:01:687 -- Adding default Reject Codes: Empty Mail From

The other two that I see in the logs are related to the quarantine table.  I notice that tblMsgs has nothing in it and nor does the tblQuarantine.  I assume the later has something to do with the following error(s).

Error that appears throughout the log:

05/31/06 23:24:25:904 -- (304) Blacklist cache - starting cleanup
05/31/06 23:24:25:904 -- (2576) Exception occurred during TDeleteExpiredQuarantineThread.Execute: Error code: 573 Syntax Error:   syntax error at line : 1, Column: 7, token: DISTINCTROW Error code: 610 OpenSQL:  Error:573
Syntax Error:   syntax error at line : 1, Column: 7, token: DISTINCTROW
05/31/06 23:24:25:920 -- (1696) TBayesianThread - Begin LoadFromFile for corpus.db (db.dat)

Error that appears when an item is being quarantined:

05/30/06 03:25:55:092 -- (4004) - Reverse DNS not found -
05/30/06 03:25:55:092 -- (4004) 203.177.239.248 - Mail from: mailto:tknopp@mccauley.textron.com - tknopp@mccauley.textron.com To: mailto:george.peters@daytasystems.com - george.peters@daytasystems.com will be rejected
05/30/06 03:26:07:951 -- (4004) Error occurred during RECEIVEMESSAGE when accessing the quarantine database: Non-nullable column cannot be updated to Null ( 1 2 2b 3 3a 4 5 6 7 8 9 11 12 13 15 16 17 18 19 29 30 31 32 33 54 55 56 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91)
05/30/06 03:26:07:967 -- (4004) EMail from mailto:tknopp@mccauley.textron.com - tknopp@mccauley.textron.com to mailto:george.peters@daytasystems.com - george.peters@daytasystems.com was received and quarantined. Size: 1 KB, 1024 bytes
05/30/06 03:26:08:014 -- (2560) Time to add Msg to Bayes corpus:0

Thanks for any suggestions that you might have to offer.  I'm using an OLEDB connection:

Provider=VistaDBOLEDB20.VistaDBOLEDB;Database Name="C:\Program Files\SpamFilter\Database\SpamFilter.vdb".

Of course, without the database engine, it would be difficult for you to do anything.  The engine consists of 1 db file and for the OleDB, just 2 supporting DLLs.  Deploying with .NET requires no additional DLL.  That's one of the features I liked about this DB engine, very small footprint and easy to deploy/backup.  Supports encryption, etc.

I have a feeling it's related to the identiy column.  I have used this engine before in a C# project that could toggle between SQL Server and VistaDB.  I've never run into a problem with the identity value, then again I wasn't doing anything special.

Thanks again,

George

 



-------------
George Peters
george.peters@aqware.com


Posted By: Energy Recruit
Date Posted: 18 November 2008 at 4:28am

Of course, without the database engine, it would be difficult for you to do anything.  The engine consists of 1 db file and for the OleDB, just 2 supporting DLLs.  Deploying with .NET requires no additional DLL.  That's one of the features I liked about this DB engine, very small footprint and easy to deploy/backup.  Supports encryption, etc.

I have a feeling it's related to the identiy column.  I have used this engine before in a C# project that could toggle between SQL Server and VistaDB.  I've never run into a problem with the identity value, then again I wasn't doing anything special.





Print Page | Close Window