[Cgi-session-user] unsubscribe

SourceForge Headquarters 1320 Columbia Street Suite 310 San Diego, CA 92101 +1 (858) 422-6466

On Tue, Oct 26, 2010 at 6:04 AM, <
cgi...@li...> wrote:

> Send Cgi-session-user mailing list submissions to
>        cgi...@li...
>
> To subscribe or unsubscribe via the World Wide Web, visit
>        https://lists.sourceforge.net/lists/listinfo/cgi-session-user
> or, via email, send a message with subject or body 'help' to
>        cgi...@li...
>
> You can reach the person managing the list at
>        cgi...@li...
>
> When replying, please edit your Subject line so it is more specific
> than "Re: Contents of Cgi-session-user digest..."
>
>
> Today's Topics:
>
>   1. new CGI::Session user questions (Seven Reeds)
>   2. Re: new CGI::Session user questions (Cees Hek)
>
>
> ----------------------------------------------------------------------
>
> Message: 1
> Date: Mon, 25 Oct 2010 13:41:49 -0500
> From: Seven Reeds <sev...@gm...>
> Subject: [Cgi-session-user] new CGI::Session user questions
> To: cgi...@li...
> Message-ID:
>        <AAN...@ma...<AANLkTinacGiFfz6ru_F_RoqFvVch3%2BS...@ma...>
> >
> Content-Type: text/plain; charset=ISO-8859-1
>
> Hi,
>
> I am running CGI::Session version 4.42 on a redhat linux box rhel 5.5
> with Apache2.x.
>
> I am trying the following:
>
> ? ? ? ?$SESSION = new CGI::Session("driver:MySQL",
> ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ?$CGI || $loginSessionID, {
> ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ?TableName ? =>'sessions',
> ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ?IdColName ? =>'id',
> ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ?DataColName =>'data',
> ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ?Handle ? ? ?=>$DBH,
> ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ?}) ||
> ? ? ? ? ? ?die CGI::Session->errstr() . "\n";
>
> but when I run the script I get:
>
> (in cleanup) Can't connect to data source '' because I can't work out
> what driver to use (it doesn't seem to contain a 'dbi:driver:' prefix
> and the DBI_DRIVER env var is not set) at
> /usr/lib/perl5/site_perl/5.8.8/CGI/Session/Driver/DBI.pm line 26
>
> I have tried:
>
> ? ? ? ?$SESSION = new CGI::Session("driver:MySQL",
> ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ?$CGI || $loginSessionID, {
> ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ?DataSource
> ?=>'dbi:mysql:project_db',
> ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ?TableName ? =>'sessions',
> ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ?IdColName ? =>'id',
> ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ?DataColName =>'data',
> ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ?Handle ? ? ?=>$DBH,
> ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ?}) ||
> ? ? ? ? ? ?die CGI::Session->errstr() . "\n";
>
> but adding the data source almost defeats the purpose of the "Handle"
> element. ?When I run it I get:
>
> (in cleanup) Can't call method "FETCH" on an undefined value at
> /usr/lib64/perl5/site_perl/5.8.8/x86_64-linux-thread-multi/DBI.pm line
> 668 during global destruction.
>
> ideas?
>
> s.r.
>
>
>
> ------------------------------
>
> Message: 2
> Date: Tue, 26 Oct 2010 10:32:50 +1100
> From: Cees Hek <ce...@gm...>
> Subject: Re: [Cgi-session-user] new CGI::Session user questions
> To: Seven Reeds <sev...@gm...>
> Cc: cgi...@li...
> Message-ID:
>        <AAN...@ma...<AANLkTinyDHTkQibhA3XgAr29sJ3nN_GpHNDOej%2B...@ma...>
> >
> Content-Type: text/plain; charset=ISO-8859-1
>
> What might be happening is that your database handle is 'cleaned up'
> before the session object, so by the time the session is flushing, the
> database handle has already been disconnected.  Notice that this is
> all happening during global destruction, so you need to ensure that
> your session goes out of scope before the database handle does.
>
> What is usually safer to do is to explicitly 'flush' your session at
> the end of your code.
>
> Cheers,
>
> Cees
>
> On Tue, Oct 26, 2010 at 5:41 AM, Seven Reeds <sev...@gm...>
> wrote:
> > Hi,
> >
> > I am running CGI::Session version 4.42 on a redhat linux box rhel 5.5
> > with Apache2.x.
> >
> > I am trying the following:
> >
> > ? ? ? ?$SESSION = new CGI::Session("driver:MySQL",
> > ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ?$CGI || $loginSessionID, {
> > ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ?TableName ? =>'sessions',
> > ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ?IdColName ? =>'id',
> > ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ?DataColName =>'data',
> > ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ?Handle ? ? ?=>$DBH,
> > ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ?}) ||
> > ? ? ? ? ? ?die CGI::Session->errstr() . "\n";
> >
> > but when I run the script I get:
> >
> > (in cleanup) Can't connect to data source '' because I can't work out
> > what driver to use (it doesn't seem to contain a 'dbi:driver:' prefix
> > and the DBI_DRIVER env var is not set) at
> > /usr/lib/perl5/site_perl/5.8.8/CGI/Session/Driver/DBI.pm line 26
> >
> > I have tried:
> >
> > ? ? ? ?$SESSION = new CGI::Session("driver:MySQL",
> > ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ?$CGI || $loginSessionID, {
> > ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ?DataSource
> ?=>'dbi:mysql:project_db',
> > ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ?TableName ? =>'sessions',
> > ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ?IdColName ? =>'id',
> > ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ?DataColName =>'data',
> > ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ?Handle ? ? ?=>$DBH,
> > ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ?}) ||
> > ? ? ? ? ? ?die CGI::Session->errstr() . "\n";
> >
> > but adding the data source almost defeats the purpose of the "Handle"
> > element. ?When I run it I get:
> >
> > (in cleanup) Can't call method "FETCH" on an undefined value at
> > /usr/lib64/perl5/site_perl/5.8.8/x86_64-linux-thread-multi/DBI.pm line
> > 668 during global destruction.
> >
> > ideas?
> >
> > s.r.
> >
> >
> ------------------------------------------------------------------------------
> > Nokia and AT&T present the 2010 Calling All Innovators-North America
> contest
> > Create new apps & games for the Nokia N8 for consumers in ?U.S. and
> Canada
> > $10 million total in prizes - $4M cash, 500 devices, nearly $6M in
> marketing
> > Develop with Nokia Qt SDK, Web Runtime, or Java and Publish to Ovi Store
> > http://p.sf.net/sfu/nokia-dev2dev
> > _______________________________________________
> > Cgi-session-user mailing list
> > Cgi...@li...
> > https://lists.sourceforge.net/lists/listinfo/cgi-session-user
> >
>
>
>
> ------------------------------
>
>
> ------------------------------------------------------------------------------
> Nokia and AT&T present the 2010 Calling All Innovators-North America
> contest
> Create new apps & games for the Nokia N8 for consumers in  U.S. and Canada
> $10 million total in prizes - $4M cash, 500 devices, nearly $6M in
> marketing
> Develop with Nokia Qt SDK, Web Runtime, or Java and Publish to Ovi Store
> http://p.sf.net/sfu/nokia-dev2dev
>
> ------------------------------
>
> _______________________________________________
> Cgi-session-user mailing list
> Cgi...@li...
> https://lists.sourceforge.net/lists/listinfo/cgi-session-user
>
>
> End of Cgi-session-user Digest, Vol 34, Issue 1
> ***********************************************
>


-- 
Devin Austin
http://www.codedright.net
9702906669 - Cell