http://qs321.pair.com?node_id=1232430


in reply to Re: Problem connecting with SSL to mySQL database
in thread Problem connecting with SSL to mySQL database

Yes, I've tried unsuccessfully to supply them. I'm told they're only needed when something (the OS? Perl?) "doesn't know where the certs are located". But I think the key thing is, the connection string, minus those additional SSL options, works fine when I connect using our /usr/bin/perl installation - just not when I connect using my personal v22 installation.
  • Comment on Re^2: Problem connecting with SSL to mySQL database

Replies are listed 'Best First'.
Re^3: Problem connecting with SSL to mySQL database
by dorko (Prior) on Apr 11, 2019 at 00:30 UTC
    I think clueless newbie isn't as clueless s/he contends. Let's see if there is something enabled by default. Let's compare the two $conn data structures. Try something like this (untested):

    #!/shebang_goes_here
use warnings;
use strict;
use Data::Dumper;
use DBI;
my $user = 'charrison';
my $pass = '********';
my $conn = 'DBI:mysql:database=dwcontact;host=192.168.200.39;port=3402
+;mysql_ssl=1';
print Dumper ($conn);
my $dbh  = DBI->connect($conn, $user, $pass);

    [download]

    Perhaps mysql_ssl_ca_file or mysql_ssl_ca_path are getting defined in a way we don't understand.

    Cheers,

    Brent

    -- Yeah, I'm a Delt.
[reply]
[d/l]
[select]
      Hmm..

      $conn's just a string, in either case. (Dumper confirms this.)

[reply]
        You're absolutely right. Try Dumper-ing $dbh after the successful connection - there might be a setting in there for mysql_ssl_ca_file, mysql_ssl_ca_path or mysql_ssl_verify_server_cert.

        ("mysql_ssl_verify_server_cert = 0" sounds promising.)

        Cheers,

        Brent

        -- Yeah, I'm a Delt.
[reply]
[d/l]
[select]

In Section Seekers of Perl Wisdom