On 6/22/07, Matt S Trout <[EMAIL PROTECTED]> wrote:
On Fri, Jun 22, 2007 at 10:30:24AM -0400, John Goulah wrote:
> On 6/22/07, Tim Bunce <[EMAIL PROTECTED]> wrote:
> >
> >On Thu, Jun 21, 2007 at 05:56:57PM -0400, John Goulah wrote:
> >> On 6/21/07, Adam Bartosik <[EMAIL PROTECTED]> wrote:
> >>
> >> > I would recommend for now explicitly setting
> >"mysql_auto_reconnect =>
> >> > 0" in your connect_info options hashref and seeing if this
clears
> >up
> >> > your problem.
> >>
> >> Yes, setting
> >> mysql_auto_reconnect => 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=mydb'
> - '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=mydb'
- 'user'
- 'pass'
- AutoCommit: 1
mysql_auto_reconnect: 0
_______________________________________________
List: http://lists.rawmode.org/cgi-bin/mailman/listinfo/dbix-class
Wiki: http://dbix-class.shadowcatsystems.co.uk/
IRC: irc.perl.org#dbix-class
SVN: http://dev.catalyst.perl.org/repos/bast/trunk/DBIx-Class/
Searchable Archive: http://www.mail-archive.com/[email protected]/
