-----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
[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/AwUBRhaMAK0bf1iNr4mCEQIOTwCgiTXcEZn1dX8CiGK/mPysQcfYMJgAoK/w
4qjh4nFyJ2ZuzanzUu36KaG8
=Pby1
-----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
