perlquestion
ibm1620
Dear Monks,
<p>
Having trouble connecting to a mySQL database using SSL. I've checked with the DBAs and all the certs are in place. The problem appears to be the version of Perl (or the CPAN modules). I maintain my own Perl installation using perlbrew, so that I can freely add CPAN modules without involving the systems people.
<p>
The system Perl works:
<p>
<code>
#!/usr/bin/perl
use warnings;
use strict;
use DBI;
my $user = 'charrison';
my $pass = '********';
my $conn = 'DBI:mysql:database=dwcontact;host=192.168.200.39;port=3402;mysql_ssl=1';
my $dbh = DBI->connect($conn, $user, $pass);
</code>
<p>
Mine doesn't:
<p>
<code>
#!/usr/bin/env perl
use warnings;
use strict;
use DBI;
my $user = 'charrison';
my $pass = '********';
my $conn = 'DBI:mysql:database=dwcontact;host=192.168.200.39;port=3402;mysql_ssl=1';
my $dbh = DBI->connect($conn, $user, $pass);
</code>
<p>
(Only the first line is different.)
<p>
System has perl v5.16.3. My installation runs perl v5.22.4. The error I get is:
<p><code>
DBI connect('database=dwcontact;host=192.168.200.39;port=3402;mysql_ssl=1','charrison',...) failed: SSL connection error: self signed certificate in certificate chain at ...
</code>
Any thoughts on what's missing from my installation?