Ticket #92 (new enhancement)

Opened 2 years ago

Last modified 1 year ago

SQL Support shouldn't make any assumptions about the DBD back end

Reported by: Werner Assigned to: decoder
Priority: minor Milestone:
Component: Hash Database Version:
Keywords: Remove mysql dependency Cc:

Description

Version 3.5 has a nice SQL support, but insists using MySQL as a back end. FuzzyOCR should use the same mechanism as Spamassassin itself: i.e. remove the call require(DBD::MySQL), stop rebuilding the dsn connect string in a mysql-specific way and let the user choose his SQL-engine by defining the dsn in FuzzyOCR.cf, as DBI takes care about choosing the appropriate DBD driver.

This way the user can connect to Postgres, Oracle, Mysql, msql, whatever...

A definition in FuzzyOCR.cf might look like:

focr_sql_hash HASH focr_sql_safe SAFE focr_sql_user spamuser focr_sql_pass spampass focr_sql_dsn dbi:Oracle:spamassassin

would use the ORACLE driver.

Attachments

Change History

03.08.2007 10:23:42 changed by anonymous

15.08.2007 02:25:50 changed by anonymous

17.08.2007 18:41:51 changed by anonymous


Add/Change #92 (SQL Support shouldn't make any assumptions about the DBD back end)