Beefy Boxes and Bandwidth Generously Provided by pair Networks
Don't ask to ask, just ask

Re: Problem connecting with SSL to mySQL database

by clueless newbie (Deacon)
on Apr 10, 2019 at 23:46 UTC ( #1232429=note: print w/replies, xml ) Need Help??

in reply to Problem connecting with SSL to mySQL database

DBD::mysql says:

When enabling mysql_SSL there are other ssl option that should also be enabled at least mysql_ssl_ca_file or mysql_ssl_ca_path.

  • Comment on Re: Problem connecting with SSL to mySQL database

Replies are listed 'Best First'.
Re^2: Problem connecting with SSL to mySQL database
by ibm1620 (Monk) on Apr 11, 2019 at 00:05 UTC
    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.
      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=;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.



      -- Yeah, I'm a Delt.

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

Log In?

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

How do I use this? | Other CB clients
Other Users?
Others cooling their heels in the Monastery: (5)
As of 2021-03-01 17:17 GMT
Find Nodes?
    Voting Booth?
    My favorite kind of desktop background is:

    Results (15 votes). Check out past polls.