Print Page | Close Window

Other databases?

Printed From: LogSat Software
Category: Spam Filter ISP
Forum Name: Spam Filter ISP Support
Forum Description: General support for Spam Filter ISP
URL: https://www.logsat.com/spamfilter/forums/forum_posts.asp?TID=1298
Printed Date: 14 March 2025 at 6:50am


Topic: Other databases?
Posted By: Guests
Subject: Other databases?
Date Posted: 09 July 2003 at 8:07am

Hi,

I've a setup where I do not have any of the enlisted databases, but I have PostgreSQL. Anyone already tried it with that one? Or isn't it possible?

Regards

- JoeE


Replies:
Posted By: LogSat
Date Posted: 09 July 2003 at 4:19pm

Joe,

SpamFilter can create the necessary database tables for the database platforms it supports. This step is pretty platform-specific. However once the database tables are in place, communication with the database is done in a very simple and standard (compatible) way.

We have not tested SpamFilter against a PostgreSQL database yet, but if you are able to create the various tables there are good chances it will work.

Roberto Franceschetti
LogSat Software

Posted By: Guests
Date Posted: 09 July 2003 at 7:27pm

Thank you for that clarification, I'll give it a try.

Regards

- JoeE

Posted By: Guests
Date Posted: 14 July 2003 at 7:28am

Alright, I could create the tables and also was able to setup the ODBC driver. The connection to the database is working. But not all fields are loaded with data.

Can I verify somehow what data is sent to the database (the actual SQL commands would be very usefull).

Thank you

- JoeE

Posted By: LogSat
Date Posted: 14 July 2003 at 5:36pm

Joe,

SpamFilter uses ADO commands to read/write to the database. ADO in turns converts them to actual SQL statements for that database. We do not issue SQL queries directly. Most drivers/platforms allow to do SQL tracing to see exactly what commands are being received.

The most likely cause of problems could be the presence of non-working auto-increment fields in the database tables, and the ability of the ODBC or OLEDB driver to be able to retrieve the value of an autoincrement field for a newly inserted record.

Roberto F.
LogSat Software

Posted By: Guests
Date Posted: 17 July 2003 at 10:33am

I was able to create the tables on a PostgreSQL server and after making the tablenames exactly (upper/lower case seemed to matter) what the spamfilter service wanted. It seems to work but only partialy, the sequences are generated no problem and the tblQuarantine table gets filled also the tblMsgs. However some fields in tblQuarantine are not loaded with information (MsgID, Reject, Deliver etc).

Any suggestions?

Posted By: LogSat
Date Posted: 21 July 2003 at 4:23pm

Joe,

The missing data may be because the PostgreSQL odbc driver is not returning all the necessary data back to SpamFilter.

PostgreSQL is not a supported DB platform yet, we'll try to add support for it by the end of the summer.

Roberto Franceschetti
LogSat Software


Print Page | Close Window