Spam Filter ISP Support Forum

  New Posts New Posts RSS Feed - Other databases?
  FAQ FAQ  Forum Search   Register Register  Login Login

Other databases?

 Post Reply Post Reply
Author
JoeE View Drop Down
Guest Group
Guest Group
Post Options Post Options   Thanks (0) Thanks(0)   Quote JoeE Quote  Post ReplyReply Direct Link To This Post Topic: Other databases?
    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

Back to Top
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 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

Back to Top
JoeE View Drop Down
Guest Group
Guest Group
Post Options Post Options   Thanks (0) Thanks(0)   Quote JoeE Quote  Post ReplyReply Direct Link To This Post Posted: 09 July 2003 at 7:27pm

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

Regards

- JoeE

Back to Top
JoeE View Drop Down
Guest Group
Guest Group
Post Options Post Options   Thanks (0) Thanks(0)   Quote JoeE Quote  Post ReplyReply Direct Link To This Post 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

Back to Top
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 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

Back to Top
JoeE View Drop Down
Guest Group
Guest Group
Post Options Post Options   Thanks (0) Thanks(0)   Quote JoeE Quote  Post ReplyReply Direct Link To This Post 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?

Back to Top
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 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

Back to Top
 Post Reply Post Reply
  Share Topic   

Forum Jump Forum Permissions View Drop Down



This page was generated in 0.108 seconds.