-----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
[EMAIL PROTECTED] 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-----
_______________________________________________
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
