On 8/26/07 11:44 PM, Kurt Hansen wrote:
> Would it be sufficient to add the following ssl parameters to my
> Rose::DB module? I realize I may
> need to do some work to configure DBD::mysql to support ssl connections,
> but if DBD::mysql configured properly, will Rose::DB send the parameters
> properly?
> 
>     __PACKAGE__->register_db(
>       domain   => 'pax',
>       type     => 'transaction',
>       driver   => 'mysql',
>       database => 'dbname',
>       host     => '192.168.2.18',
>       username => 'USERNAME',
>       password => 'PASSWORD',
> 
>       #ssl parameters:
>       mysql_ssl => 1,
>       mysql_ssl_client_key => 'KEYFILE',
>       mysql_ssl_client_cert => 'CERTFILE',
>       mysql_ssl_ca_file => 'CAFILE',
>       #end ssl parameters
>      );

Assuming those are connection options for DBD::mysql, try Rose::DB's
connect_options method:

http://search.cpan.org/dist/Rose-DB/lib/Rose/DB.pm#connect_options

     __PACKAGE__->register_db(
        ...
        connect_options =>
        {
          mysql_ssl => 1,
          mysql_ssl_client_key => 'KEYFILE',
          mysql_ssl_client_cert => 'CERTFILE',
          mysql_ssl_ca_file => 'CAFILE',
        },
      );

If those values need to be inlined into the DSN, then Rose::DB will need to
be changed to support them.

-John



-------------------------------------------------------------------------
This SF.net email is sponsored by: Splunk Inc.
Still grepping through log files to find problems?  Stop.
Now Search log events and configuration files using AJAX and a browser.
Download your FREE copy of Splunk now >>  http://get.splunk.com/
_______________________________________________
Rose-db-object mailing list
Rose-db-object@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/rose-db-object

Reply via email to