[dancer-users] Dancer::Plugin::Database socket:?

[Sam Batschelet]

On Jan 22, 2013, at 7:22 AM, David Precious wrote:

> On Tue, 22 Jan 2013 06:51:15 -0500
> Sam Batschelet <sbatschelet at mac.com> wrote:
> 
>> Hello I have a development environment which creates individual
>> instances of mysql for each development "camp".  To connect to these
>> instances I declare typical connection information but I don't see
>> how to set the option to set non standard socket location
>> 'mysql_socket' for the plugin.  Is there a trick for this, future
>> support?
> 
> You can craft your own DSN and provide it as the DSN parameter, for
> instance:
> 
> plugins:
>  Database:
>    foo:
>      dsn: "DBI:mysql:database=dbname;mysql_socket=/var/run/mysql-foo"
>    bar:
>      dsn: "DBI:mysql:database=dbname;mysql_socket=/var/run/mysql-bar"
> 
> That should work, I believe.
> 

Yes that is great and solves my problem thank you.