[rt-users] Finding mysql SSL certificates

[Mike Friedman]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Normally I would wait longer than a couple of days for a reply before 
reposting a question to this list, so I apologize for seeming impatient. 
But I find it hard to believe that running RT against a remote mysql db 
using SSL is such an uncommon thing for people to do.  So, surely many 
others already know the answer to my question.

When I consult the list archives, the RT wiki and google in general, all I 
find about SSL and RT relates to the use of SSL with Apache and the web 
interface.  But I'm interested in the *mysql* SSL interface.  From what I 
can tell thus far, perl DBI/DBD code doesn't honor the mysql my.cnf config 
file by default, so one must insert perl code(*) to cause it to do so. How 
else can I inform the mysql client where to find the mysql server SSL 
certificate?

(*) According to the CPAN docs for DBD::mysql:

   mysql_read_default_group

   These options can be used to read a config file like /etc/my.cnf
   or ~/.my.cnf. By default MySQL's C client library doesn't use any
   config files unlike the client programs (mysql, mysqladmin, ...)
   that do, but outside of the C client library. Thus you need to
   explicitly request reading a config file, as in

     $dsn = "DBI:mysql:test;mysql_read_default_file=/home/joe/my.cnf";
     $dbh = DBI->connect($dsn, $user, $password)

Do I need to add code like the first line above somewhere in RT?  If so, 
where?  Or are there some values that can be put into RT_SiteConfig.pm 
that I don't know about?  This is all in reference to RT 3.6.3.

I hope someone can help.

Thanks.

Mike

_________________________________________________________________________
Mike Friedman                        Information Services & Technology
mikef at ack.Berkeley.EDU               2484 Shattuck Avenue
1-510-642-1410                       University of California at Berkeley
http://socrates.berkeley.edu/~mikef  http://ist.berkeley.edu
_________________________________________________________________________

-----BEGIN PGP SIGNATURE-----
Version: PGP 6.5.8

iQA/AwUBRhaMAK0bf1iNr4mCEQIOTwCgiTXcEZn1dX8CiGK/mPysQcfYMJgAoK/w
4qjh4nFyJ2ZuzanzUu36KaG8
=Pby1
-----END PGP SIGNATURE-----