[Israel.pm] Perl MySQL DBI with SSL - can't connect

Shmuel Fomberg shmuelfomberg at gmail.com
Tue Jan 24 17:49:49 PST 2012


Will someone educate me why you should connect your DB using SSL?
(assuming that you are on the same network, and not communicating across
the internet, of course)

Shmuel.

On Tue, Jan 24, 2012 at 11:27 PM, Felix Liberman
<felix.liberman at gmail.com>wrote:

> Hi All,
>
> I'm trying to re-configure my Perl application that communicates with
> MySQL server via DBI layer.
> Previous version worked perfectly without SSL, but now (for production
> mode) higher security measures required, so I switched to SSL.
> I run MySQL server with SSL support and even managed to connect via
> command-line interface (using standard mysql utility):
>
> {{{
> mysql> status
> --------------
> /{somepath}/bin/mysql  Ver 14.14 Distrib 5.5.20, for Linux (x86_64) using
>  EditLine wrapper
>
> Connection id:          34
> Current database:       sc_prj_cm
> Current user:           {someuser}@{somehost}
> SSL:                    Cipher in use is DHE-RSA-AES256-SHA
> Current pager:          less
> Using outfile:          ''
> Using delimiter:        ;
> Server version:         5.5.20-log Source distribution
> Protocol version:       10
> Connection:             {somehost} via TCP/IP
> }}}
>
> The DBD::mysql (rev 4.018) module was compiled with SSL enabled option,
> but client application fails:
>
> {{{
> DBI
> connect('database=sc_prj_cm;host={somehost};port=3306;mysql_ssl=1;mysql_ssl_ca_file=/{somepath}/ssl_certs/cacert.pem','{someuser}',...)
> failed: SSL connection error at {my source code}
> }}}
>
> Both connections (mysql command-line and Perl app)  used the same
> certificates on the same host.
>
> Googling around the keywords did not bring much info.
>
> Maybe the local community can help me?
>
>
> Thanks in advance,
> --
> ~Felix_ <http://felixl.coolpage.biz>
>
>
> _______________________________________________
> Perl mailing list
> Perl at perl.org.il
> http://mail.perl.org.il/mailman/listinfo/perl
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mail.perl.org.il/pipermail/perl/attachments/20120125/c11eeaf5/attachment.htm 


More information about the Perl mailing list