Hello,

To use SSL on a connection to a MySQL-server from maildrop, I wrote a little patch to be able to do so.

It's a very small and probably very dirty hack, but since Courier-imap supports MYSQL_OPT, why not maildrop in sort of the same way ? :)

You can find it here (if attachment was screwed up): http://www.isp-data.org/patches/maildrop-1.6.3-mysql-ssl.patch

To use it: set 'connect_opt 2048' in your maildropmysql.config

Hope you enjoy it:)

-- WideXS http://www.widexs.nl Wouter de Jong System-Administrator Tel +31 (0)23 5698070 Fax +31 (0)23 5698099 Bijlmermeerstraat 62, 2131 HG HOOFDDORP, NL

diff -rNu maildrop-1.6.3/maildrop/mdmysql.c
maildrop-1.6.3-mysql-ssl/maildrop/mdmysql.c --- maildrop-1.6.3/maildrop/mdmysql.c Sat Oct 11 05:26:24 2003 +++ maildrop-1.6.3-mysql-ssl/maildrop/mdmysql.c Mon Dec 15 11:20:27 2003 @@ -27,7 +27,7 @@ #if MYSQL_VERSION_ID >= 32200 mysql_init(&mysql_buf); mysql=mysql_real_connect(&mysql_buf, cfg->hostname, cfg->dbuser, cfg->dbpw, - NULL, cfg->port, cfg->socket, 0); + NULL, cfg->port, cfg->socket, cfg->connect_opt); #else mysql=mysql_connect(&mysql_buf, server, userid, password); #endif diff -rNu maildrop-1.6.3/maildrop/mdmysqlconfig.c
maildrop-1.6.3-mysql-ssl/maildrop/mdmysqlconfig.c --- maildrop-1.6.3/maildrop/mdmysqlconfig.c Sat Oct 11 05:26:24 2003 +++ maildrop-1.6.3-mysql-ssl/maildrop/mdmysqlconfig.c Mon Dec 15 11:21:48 2003 @@ -33,6 +33,7 @@

cfg->port = MYSQL_DEFAULT_PORT; cfg->socket = NULL; + cfg->connect_opt = MYSQL_DEFAULT_CONNECT_OPT;

cfg->timeout = MYSQL_DEFAULT_TIMEOUT;

@@ -97,6 +98,8 @@

if ( !strcasecmp(var,"default_gidnumber") ) cfg->default_gidnumber = atoi(val); + if ( !strcasecmp(var,"connect_opt") ) + cfg->connect_opt = atoi(val); }

fclose(fp); diff -rNu maildrop-1.6.3/maildrop/mdmysqlconfig.h
maildrop-1.6.3-mysql-ssl/maildrop/mdmysqlconfig.h --- maildrop-1.6.3/maildrop/mdmysqlconfig.h Sat Oct 11 05:26:24 2003 +++ maildrop-1.6.3-mysql-ssl/maildrop/mdmysqlconfig.h Mon Dec 15 11:15:38 2003 @@ -16,6 +16,7 @@ #define MYSQL_DEFAULT_QUOTA_FIELD "quota" #define MYSQL_DEFAULT_WHERE_CLAUSE "" #define MYSQL_DEFAULT_TIMEOUT 5 +#define MYSQL_DEFAULT_CONNECT_OPT 0

typedef struct { char *hostname; @@ -36,6 +37,7 @@

int default_uidnumber; int default_gidnumber; + int connect_opt;

int timeout; } mdmysqlconfig;