Beefy Boxes and Bandwidth Generously Provided by pair Networks
There's more than one way to do things
 
PerlMonks  

Re^2: Problem connecting with SSL to mySQL database

by ibm1620 (Monk)
on Apr 11, 2019 at 00:05 UTC ( #1232430=note: print w/replies, xml ) Need Help??


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

    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.
      Hmm..

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

        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.

Log In?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://1232430]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others surveying the Monastery: (8)
As of 2020-11-24 21:37 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found

    Notices?