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

Reply via email to