Re^2: 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]
Re^4: Problem connecting with SSL to mySQL database by ibm1620 (Hermit) on Apr 11, 2019 at 13:39 UTC
Hmm.. $conn's just a string, in either case. (Dumper confirms this.)	[reply]
Re^5: Problem connecting with SSL to mySQL database by dorko (Prior) on Apr 11, 2019 at 16:33 UTC
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]


Pathologically Eclectic Rubbish Lister
	PerlMonks