On Apr 17, 2007, at 4:15 PM, Mike Friedman wrote:
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
It looks like I may have to modify DBIx::SearchBuilder, in
particular 'Handle.pm'. This is in order to access my RT mysql
database via SSL.
It seems that the only way to get perl DBD::mysql to use SSL may be
to provide a hashref in the connect call, something like this:
DBI->connect($dsn, $user, $pass,
{
mysql_read_default_file => "fully/qualified/path/to/my.cnf"
}
);
the DBD::mysql manpage lists this syntax also
$dsn = "DBI:mysql:test;mysql_read_default_file=/home/joe/my.cnf";
If that works, you may be able to change RT::Handle::BuildDSN in
local/lib to do the right thing.
We'd also appreciate some sort of patch if that works.
Can I create a modified DBIx::Searchbuilder in my RT 'local/lib',
just as if I were modifying an RT 'lib' module, even though
DBIx::Searchbuilder is installed in 'site_perl' and not in the RT
tree?
RT runs with local/lib first in @INC, so that should work if needed.
Of course, it might be better to get a patch submitted and an
official release to support what you need.
-kevin
_______________________________________________
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
Community help: http://wiki.bestpractical.com
Commercial support: [EMAIL PROTECTED]
Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
Buy a copy at http://rtbook.bestpractical.com