Other databases? |
Post Reply 
|
| Author | |
JoeE 
Guest Group 
|
 Post Options
 Thanks(0)
 Quote Reply
 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 |
|
 |
|
|
LogSat
Admin Group 
Joined: 25 January 2005 Location: United States Status: Offline Points: 4104 |
Post Options
Thanks(0)
Quote Reply
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 |
|
|
|
|
JoeE
Guest Group
|
Post Options
Thanks(0)
Quote Reply
Posted: 09 July 2003 at 7:27pm |
|
Thank you for that clarification, I'll give it a try. Regards - JoeE |
|
|
|
|
JoeE
Guest Group
|
Post Options
Thanks(0)
Quote Reply
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 |
|
|
|
|
LogSat
Admin Group
Joined: 25 January 2005 Location: United States Status: Offline Points: 4104 |
Post Options
Thanks(0)
Quote Reply
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. |
|
|
|
|
JoeE
Guest Group
|
Post Options
Thanks(0)
Quote Reply
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? |
|
|
|
|
LogSat
Admin Group
Joined: 25 January 2005 Location: United States Status: Offline Points: 4104 |
Post Options
Thanks(0)
Quote Reply
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 |
|
|
|
Topic Options|
Post Reply
|
|
Tweet
|
| Forum Jump | Forum Permissions You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum |
This page was generated in 0.129 seconds.