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 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
Re: Support for Cassandra CQL database lookup table
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.
Re: Support for Cassandra CQL database lookup table
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