Spam Filter ISP Support Forum

  New Posts New Posts RSS Feed - VistaDB support in the future?
  FAQ FAQ  Forum Search   Register Register  Login Login

VistaDB support in the future?

 Post Reply Post Reply
Author
gcpeters View Drop Down
Newbie
Newbie
Avatar

Joined: 24 April 2006
Location: United States
Status: Offline
Points: 4
Post Options Post Options   Thanks (0) Thanks(0)   Quote gcpeters Quote  Post ReplyReply Direct Link To This Post Topic: VistaDB support in the future?
    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
Back to Top
LogSat View Drop Down
Admin Group
Admin Group
Avatar

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

LogSat Software

Spam Filter ISP
Back to Top
gcpeters View Drop Down
Newbie
Newbie
Avatar

Joined: 24 April 2006
Location: United States
Status: Offline
Points: 4
Post Options Post Options   Thanks (0) Thanks(0)   Quote gcpeters Quote  Post ReplyReply Direct Link To This Post 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: tknopp@mccauley.textron.com To: 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 tknopp@mccauley.textron.com to 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
Back to Top
Energy Recruit View Drop Down
Newbie
Newbie


Joined: 18 November 2008
Status: Offline
Points: 1
Post Options Post Options   Thanks (0) Thanks(0)   Quote Energy Recruit Quote  Post ReplyReply Direct Link To This Post 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.


Back to Top
 Post Reply Post Reply
  Share Topic   

Forum Jump Forum Permissions View Drop Down



This page was generated in 0.063 seconds.