[Catalyst] Various login problems

[Brandon Black]

On 12/27/06, Jesse Sheidlower <jester at panix.com> wrote:
> On Wed, Dec 27, 2006 at 10:34:25AM -0600, Brandon Black wrote:
> > On 12/27/06, Chisel Wright <chisel at herlpacker.co.uk> wrote:
> > >On Wed, Dec 27, 2006 at 10:35:27AM -0500, Jesse Sheidlower wrote:
> > >> Any suggestions what might be causing this, or where I should
> > >> start to try to figure it out? Keep in mind that I cannot seem
> > >> to force this to happen, so when it's OK, as it is now, I can't
> > >> get it started.
> > >
> > >This sounds a bit like the old "tell mysql not to be so annoying" flag -
> > >try setting the "mysql_auto_reconnect" option:
> > >
> > > http://search.cpan.org/dist/DBD-mysql/lib/DBD/mysql.pm#mysql_auto_reconnect
> > >
> > >I think you can pass/set it in the DSN string.
> > >
> >
> > Also, if you just used DBIx::Class instead of straight DBI, automatic
> > reconnect would be transparently handled for you on all databases.
> > mysql_auto_reconnect is MySQL-specific, doesn't work if AutoCommit is
> > off, and doesn't re-establish locks (whereas using your locks within a
> > txn_do via DBIx::Class should always Do The Right Thing).
>
> I _am_ just using DBIx::Class for this app. If this is
> supposed to be being handled for me, it's not doing a very
> good job....
>

Your first email indicates you're using
Catalyst::Plugin::Session::Store::DBI, which uses a DBI connection
directly, and does not use DBIx::Class.  The DBIx::Class equivalent is
Catalyst::Plugin::Session::Store::DBIC.

-- Brandon