[cgiapp] Re: CGI::Session::SQLite and CGI::Application

[Mark Stosberg <suppressed>]

On 2005-01-06, Jaldhar H. Vyas <suppressed> wrote:
>
> sub cgiapp_init
> {
>   my ($self) = @_;
>
>   $self->dbh_config('dbi:SQLite:dbname=/home/jaldhar/db', undef, undef,
>     { RaiseError => 1, }) or croak "Cannot connect to the database.";
>
>   $self->session_config(
>     CGI_SESSION_OPTIONS => [ 'driver:SQLite', $self->query,
>                              { Handle => $self->dbh } ],
>     COOKIE_PARAMS       => {
>                             -path    => $self->query->url(-absolute => 1),
>                             -expires => '+1y',
>                             -secure  => 1.
>                            },
>     SEND_COOKIE         => 1,
>   );
> }
>
> ...I don't seem to get a session cookie set.  In my web server logs, I see:
>
> DBD::SQLite::db do warning: attempt to prepare on inactive database
> handle(0) at dbdimp.c line 243 at /usr/share/perl5/CGI/Session/SQLite.pm line 28.
>
> Is this module incompatible with C::A::P::DBH?

Probably not. (as the author of that module). Go ahead and take a lot at
the source of ::DBI. It's very simple. 

It could be worth taking ::DBH out of the picture, just to help narrow
down where your problem is. 

    Mark

-- 
http://mark.stosberg.com/ 


---------------------------------------------------------------------
Web Archive:  http://www.mail-archive.com/suppressed/
              http://marc.theaimsgroup.com/?l=cgiapp&r=1&w=2
To unsubscribe, e-mail: suppressed
For additional commands, e-mail: suppressed