You are viewing a plain text version of this content. The canonical link for it is here.
Posted to embperl@perl.apache.org by c....@pobox.com on 2001/02/07 14:01:14 UTC
Sessions within embperl
I can't seem to get this to work? I can check both %udat and %mdat,
and I see the _session_id (they are different values), but if I assign
anything to the hash, it doesn't seem to go beyond the page I assign
it. I see information making it to the database, but only two rows in
the database for three variables worth of information?
Can anyone offer any enlightenment on how to use these?
--
C Wayne Huling <c....@pobox.com>
Re: Sessions within embperl
Posted by Michael Smith <mj...@iii.co.uk>.
Yup, the problem with DBD-Oracle was that AutoCommitting of blobs didn't
work. From Tim Bunce:
--
Ah, there are issues with BLOBS and AutoCommit.
Hack the source:
Near the top of post_execute_lobs():
D_imp_dbh_from_sth;
SV *dbh = DBIc_MY_H(imp_dbh);
And at the very bottom of the function:
if (DBIc_has(imp_dbh,DBIcf_AutoCommit))
dbd_db_commit(dbh, imp_dbh);
return 1;
Tim.
--
----- Original Message -----
From: "Gerald Richter" <ri...@ecos.de>
To: <c....@pobox.com>
Cc: "Embeded PERL ML" <em...@perl.apache.org>
Sent: Wednesday, February 07, 2001 2:46 PM
Subject: Re: Sessions within embperl
> >
> > Here is what I have:
> >
> > PerlSetEnv EMBPERL_SESSION_CLASSES "Oracle Null"
> > PerlSetEnv EMBPERL_SESSION_ARGS
> "DataSource=dbi:Oracle:host=oracle;sid=tsec UserName=user Password=passwd
> Commit=1"
> >
>
> Storeing sessions in Oracle was always a problem. Mike from iii reported
> that he had to patch DBD::Oracle for that to work correctly. You may
search
> the mailing list archive, for these mails. Since that's a problem between
> Apache::Session and DBD::Oracle, you may use the File store, until theses
> problems are sorted out.
>
> Gerald
>
>
> -------------------------------------------------------------
> Gerald Richter ecos electronic communication services gmbh
> Internetconnect * Webserver/-design/-datenbanken * Consulting
>
> Post: Tulpenstrasse 5 D-55276 Dienheim b. Mainz
> E-Mail: richter@ecos.de Voice: +49 6133 925131
> WWW: http://www.ecos.de Fax: +49 6133 925152
> -------------------------------------------------------------
>
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: embperl-unsubscribe@perl.apache.org
> For additional commands, e-mail: embperl-help@perl.apache.org
>
>
Re: Sessions within embperl
Posted by Gerald Richter <ri...@ecos.de>.
>
> Here is what I have:
>
> PerlSetEnv EMBPERL_SESSION_CLASSES "Oracle Null"
> PerlSetEnv EMBPERL_SESSION_ARGS
"DataSource=dbi:Oracle:host=oracle;sid=tsec UserName=user Password=passwd
Commit=1"
>
Storeing sessions in Oracle was always a problem. Mike from iii reported
that he had to patch DBD::Oracle for that to work correctly. You may search
the mailing list archive, for these mails. Since that's a problem between
Apache::Session and DBD::Oracle, you may use the File store, until theses
problems are sorted out.
Gerald
-------------------------------------------------------------
Gerald Richter ecos electronic communication services gmbh
Internetconnect * Webserver/-design/-datenbanken * Consulting
Post: Tulpenstrasse 5 D-55276 Dienheim b. Mainz
E-Mail: richter@ecos.de Voice: +49 6133 925131
WWW: http://www.ecos.de Fax: +49 6133 925152
-------------------------------------------------------------
Re: Sessions within embperl
Posted by Gerald Richter <ri...@ecos.de>.
>
> I can't seem to get this to work? I can check both %udat and %mdat,
> and I see the _session_id (they are different values), but if I assign
> anything to the hash, it doesn't seem to go beyond the page I assign
> it. I see information making it to the database, but only two rows in
> the database for three variables worth of information?
>
The database will only contain one record per session, regardless how much
variables you store there
> Can anyone offer any enlightenment on how to use these?
>
Which version of Embperl and Apache::Session ?
How do you have setup session management in your httpd.conf ?
Gerald
-------------------------------------------------------------
Gerald Richter ecos electronic communication services gmbh
Internetconnect * Webserver/-design/-datenbanken * Consulting
Post: Tulpenstrasse 5 D-55276 Dienheim b. Mainz
E-Mail: richter@ecos.de Voice: +49 6133 925131
WWW: http://www.ecos.de Fax: +49 6133 925152
-------------------------------------------------------------