[rt-users] Finding mysql SSL certificates

[Mike Friedman]

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

How do I tell RT's mysql interface where to find my mysql SSL 
certificates?.

For the first time ever, I'm going to have my RT database on a remote 
server and I want to use SSL.  I can see from the mysql manual how to 
configure the certs and point to them in my.cnf.  But now I'm told by our 
db guy that a perl interface to mysql may not make use of my.cnf and, even 
if it does, how will it find that file?

In http://search.cpan.org/~capttofu/DBD-mysql-4.004/lib/DBD/mysql.pm, it 
says the following:

   ===================================================================
   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)
   ===================================================================

Does this mean I must do something to the RT code to accomplish what I 
want?  I see nothing in RT_Config about db certs, so there must be some 
other way to tell RT's mysql interface how to use them.  Is there anything 
in DBIx::SearchBuilder that would deal with this SSL issue?

I'm sure I'm overlooking something obvious.

BTW:  my my.cnf file is not in a standard place.  It must be in my own 
home directory because I'm running on a virtual private server where 
everything must be in my home directory.

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/AwUBRhQiX60bf1iNr4mCEQIU4gCeOY90ZCMy78R2C1vUcE/QlmVJOboAoLXm
YoGvCKtz45ZHo4cTf5hfOyrV
=yWdM
-----END PGP SIGNATURE-----