[rt-users] Finding mysql SSL certificates

Mike Friedman mikef at ack.berkeley.edu
Fri Apr 6 14:05:48 EDT 2007

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 

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


   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.



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

Version: PGP 6.5.8


More information about the rt-users mailing list