[Dbix-class] Class::Storage::DBI, connect_info/on_connect_do

[John Goulah]

On 6/22/07, Matt S Trout <dbix-class at trout.me.uk> wrote:
>
> On Fri, Jun 22, 2007 at 10:30:24AM -0400, John Goulah wrote:
> > On 6/22/07, Tim Bunce <Tim.Bunce at pobox.com> wrote:
> > >
> > >On Thu, Jun 21, 2007 at 05:56:57PM -0400, John Goulah wrote:
> > >>    On 6/21/07, Adam Bartosik <[1]adam.bartosik at hurra.com> wrote:
> > >>
> > >>      > I would recommend for now explicitly setting
> > >"mysql_auto_reconnect =3D>
> > >>      > 0" in your connect_info options hashref and seeing if this
> clears
> > >up
> > >>      > your problem.
> > >>
> > >>      Yes, setting
> > >>      mysql_auto_reconnect =3D> 0
> > >>      disables internal DBD handling of auto-reconnect and
> on_connect_do
> > >SQLs
> > >>      works.
> > >>
> > >>    I tried this setting and actually it prevented me from connecting
> at
> > >all.  I tried it out since I plan
> > >>    to run under mod_perl.   This is more of an FYI thing, but if
> anyone
> > >has ideas on why this would happen
> > >>    I'd love to hear it-
> > >
> > >It's hard to help without seeing the error message and, ideally, a
> small
> > >test case.
> > >
> > >Tim.
> >
> >
> >
> > Actually, sorry, this appears to be more of a Catalyst config issue (and
> > obviously this is the wrong list).
> >
> > If i define my settings with  "__PACKAGE__->config"  everything is fine.
> >
> > If I use a yaml file , like:
> >
> > Model::MyDB:
> >     schema_class: My::Schema
> >     connect_info:
> >          - 'dbi:mysql:dbname=3Dmydb'
> >          - 'user'
> >          - 'pass'
> >          - AutoCommit: 1
> >          - mysql_auto_reconnect: 0
> >
> >
> > I have to comment out either AutoCommit or mysql_auto_reconnect  for it
> to
> > work, so obviously I'm setting this up wrong when it comes to these
> > options.  Again I know this is the wrong list, so perhaps I'll go back
> to
> > the Catalyst list if no one has a quick answer.
>
> This is neither a DBIC nor a Catalyst issue.
>
> You've fucked up the YAML syntax.
>
> Might I recommend the YAML specification and/or the ysh command line tool.
>
> Or use a config format you understand - I personally tend to use either
> JSON
> or .conf (Config::General), both of which ConfigLoader natively supports.



Thanks for the pointers, I didn't know about ysh, and I didn't  mean to
infer that this was a Catalyst or DBIC issue as much as a problem with how
_I_ configured it.

If it helps anyone, here is the solution.

 Model::MyDB:
     schema_class: My::Schema
     connect_info:
          - 'dbi:mysql:dbname=3Dmydb'
          - 'user'
          - 'pass'
          - AutoCommit: 1
            mysql_auto_reconnect: 0
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.scsys.co.uk/pipermail/dbix-class/attachments/20070622/42c=
8e3a6/attachment.htm