Re: Support for Cassandra CQL database lookup table

[Wietse Venema]

Viktor Dukhovni:
 On Thu, Feb 19, 2015 at 04:20:17PM -0600, List wrote:
 
  We would like to use the Cassandra database to persist the state of abusive
  IPs which we would block from connecting in one of the
  smtpd_xxx_restrictions clauses.  We have systems that exist in multiple data
  centers and Cassandra works really well for persisting data between them,
  but Postfix does not support Cassandra and specifically the CQL language as
  a lookup table.  Is this planned for any releases in the near future?
 
 There are at present no plans to add Cassandra support.  However

Someone wrote an ODBC driver for Postfix, and Cassandra appears to
have an ODBC driver. I haven't found time to intergrate ODBC into
Postfix, but it could be a way to hook Postfix up with Cassandra.

http://postfix.1071664.n5.nabble.com/Code-submission-Postfix-ODBC-support-td67418.html

This would also allow Postfix to integrate with other databases
including Oracle, DB2, etc. without custom Postfix drivers.

Wietse

Support for Cassandra CQL database lookup table

[List]

We would like to use the Cassandra database to persist the state of 
abusive IPs which we would block from connecting in one of the 
smtpd_xxx_restrictions clauses.  We have systems that exist in multiple 
data centers and Cassandra works really well for persisting data between 
them, but Postfix does not support Cassandra and specifically the CQL 
language as a lookup table.  Is this planned for any releases in the 
near future?

Re: Support for Cassandra CQL database lookup table

[li...@rhsoft.net]

Am 19.02.2015 um 23:20 schrieb List:

We would like to use the Cassandra database to persist the state of
abusive IPs which we would block from connecting in one of the
smtpd_xxx_restrictions clauses.  We have systems that exist in multiple
data centers and Cassandra works really well for persisting data between
them, but Postfix does not support Cassandra and specifically the CQL
language as a lookup table.  Is this planned for any releases in the
near future?


why don't you just feed http://www.corpit.ru/mjt/rbldnsd.html with that 
IP's and use it with reject_rbl_client? that scales much better 
because it is written and optimized for that task

Re: Support for Cassandra CQL database lookup table

[Viktor Dukhovni]

On Thu, Feb 19, 2015 at 04:20:17PM -0600, List wrote:

 We would like to use the Cassandra database to persist the state of abusive
 IPs which we would block from connecting in one of the
 smtpd_xxx_restrictions clauses.  We have systems that exist in multiple data
 centers and Cassandra works really well for persisting data between them,
 but Postfix does not support Cassandra and specifically the CQL language as
 a lookup table.  Is this planned for any releases in the near future?

There are at present no plans to add Cassandra support.  However
there is in 3.0.0 support for dynamic loading of table drivers.
So it becomes easier for O/S distributions to ship optional
addon table drivers for a slew of database types.

Of course someone still has to write a Cassandra driver.

-- 
Viktor.