I couldn’t find the patch Jesse referred me to yesterday so I’m using the
following one. Ideally DBIx::SearchBuilder::Handle should be modified to allow
arbitrary DSN attributes to be specified on the DBI->connect, but I wasn’t up
for that. If applying this to the rt3 distribution you must re-run autoconf.
diff -urN rt-3-0-0.orig/configure.ac rt-3-0-0.new/configure.ac
— rt-3-0-0.orig/configure.ac 2003-03-24 16:38:40.000000000 +0000
+++ rt-3-0-0.new/configure.ac 2003-04-03 12:30:58.000000000 +0100
@@ -115,6 +115,14 @@
DB_DATABASE=rt3)
AC_SUBST(DB_DATABASE)
+dnl DB_DSN_ATTRS
+AC_ARG_WITH(db-dsn-attrs,
-
AC_HELP_STRING([--with-db-dsn-attrs=DSNATTRS], -
[Additional DBI DSN attributes (default: none)]), -
DB_DSN_ATTRS=$withval, -
DB_DSN_ATTRS=)
+AC_SUBST(DB_DSN_ATTRS)
dnl DB_RT_USER
AC_ARG_WITH(db-rt-user,
AC_HELP_STRING([–with-db-rt-user=DBUSER],
diff -urN rt-3-0-0.orig/etc/RT_Config.pm.in rt-3-0-0.new/etc/RT_Config.pm.in
— rt-3-0-0.orig/etc/RT_Config.pm.in 2003-03-24 16:38:40.000000000 +0000
+++ rt-3-0-0.new/etc/RT_Config.pm.in 2003-04-03 12:08:15.000000000 +0100
@@ -74,6 +74,10 @@
set DatabaseRequireSSL to 1 to turn on SSL communication
Set($DatabaseRequireSSL , undef);
+# You can set optional database-specific DSN attributes here
+# e.g. mysql_read_default_file=/etc/my.cnf
+Set($DatabaseDSNAttrs , ‘@DB_DSN_ATTRS@’);
}}}
{{{ Incoming mail gateway configuration
diff -urN rt-3-0-0.orig/lib/RT/Handle.pm rt-3-0-0.new/lib/RT/Handle.pm
— rt-3-0-0.orig/lib/RT/Handle.pm 2003-03-24 16:38:40.000000000 +0000
+++ rt-3-0-0.new/lib/RT/Handle.pm 2003-04-03 12:22:42.000000000 +0100
@@ -88,8 +88,9 @@
Driver => $RT::DatabaseType,
RequireSSL => $RT::DatabaseRequireSSL,
);
- if (defined $RT::DatabaseDSNAttrs && $RT::DatabaseDSNAttrs) {
-
$self->{'dsn'} .= ";$RT::DatabaseDSNAttrs"; - }
}
1;
Ian Grant, Computer Lab., William Gates Building, JJ Thomson Ave., Cambridge
Phone: +44 1223 334420