Return-Path: Delivered-To: apmail-perl-embperl-archive@www.apache.org Received: (qmail 36144 invoked from network); 15 May 2004 00:46:23 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (209.237.227.199) by minotaur-2.apache.org with SMTP; 15 May 2004 00:46:23 -0000 Received: (qmail 43215 invoked by uid 500); 15 May 2004 00:46:48 -0000 Delivered-To: apmail-perl-embperl-archive@perl.apache.org Received: (qmail 43166 invoked by uid 500); 15 May 2004 00:46:47 -0000 Mailing-List: contact embperl-help@perl.apache.org; run by ezmlm Precedence: bulk list-help: list-unsubscribe: list-post: Delivered-To: mailing list embperl@perl.apache.org Received: (qmail 43138 invoked by uid 98); 15 May 2004 00:46:47 -0000 Received: from jbrooks4@austin.rr.com by hermes.apache.org by uid 82 with qmail-scanner-1.20 (clamuko: 0.70. Clear:RC:0(65.16.122.194):. Processed in 0.088728 secs); 15 May 2004 00:46:47 -0000 X-Qmail-Scanner-Mail-From: jbrooks4@austin.rr.com via hermes.apache.org X-Qmail-Scanner: 1.20 (Clear:RC:0(65.16.122.194):. Processed in 0.088728 secs) Received: from unknown (HELO willow.mobile-o.com) (65.16.122.194) by hermes.apache.org with SMTP; 15 May 2004 00:46:47 -0000 Received: from localhost (localhost.localdomain [127.0.0.1]) by willow.mobile-o.com (8.12.8/8.12.8) with ESMTP id i4F0tndP028129 for ; Fri, 14 May 2004 19:55:50 -0500 Subject: Re: only _session_id appears in sessions table From: Jeremy Brooks To: embperl@perl.apache.org In-Reply-To: <1084572007.27198.27.camel@willow.mobile-o.com> References: <1084572007.27198.27.camel@willow.mobile-o.com> Content-Type: text/plain Message-Id: <1084582549.27203.46.camel@willow.mobile-o.com> Mime-Version: 1.0 X-Mailer: Ximian Evolution 1.4.5 Date: Fri, 14 May 2004 19:55:49 -0500 Content-Transfer-Encoding: 7bit X-Spam-Rating: hermes.apache.org 1.6.2 0/1000/N X-Spam-Rating: minotaur-2.apache.org 1.6.2 0/1000/N Well, I think I figured out my "problem". Everything's working fine, I just can't see the column values in state.session because they're encoded(serialized). Sorry for the post. -Jeremy On Fri, 2004-05-14 at 17:00, Jeremy Brooks wrote: > embperl wizards, > > I've read the docs for sessions, embperl, README.v2, and spent days > looking through old posts. Maybe I'm missing something obvious... > I think I'm having problems with session manipulation using MySQL and > %udat/SessionX. I'm using a simple test epl file: > > [- > $udat{'time'} = time; > -] > > > > time: [+$udat{time}+] >
> id: [+$udat{_session_id}+] > > > > When I request this file, my browser gets a cookie and > a record gets created in state.sessions but only the 'id' column ( > $udat{_session_id} ) gets inserted into the record. The time column > always has a NULL value in the record. The id matches that of the > cookie. I've added session debug output to the embperl log and I see > SES: entries indicating that the user data has > changed on every request, yet nothing but the id appears in the session > record. > [- $udat{time} = time; -] is at the top of the file and ensures that the > session gets updated at every request. I get no errors at all. Does > anyone have an idea as to why $udat{time} is not getting inserted into > state.sessions? I've included info about the sessions table and the > system/software. > > > thanks in advance, > Jeremy Brooks > > > state.sessions: > > +-----------+-------------+------+-----+---------+-------+ > | Field | Type | Null | Key | Default | Extra | > +-----------+-------------+------+-----+---------+-------+ > | id | varchar(32) | | PRI | | | > | a_session | text | YES | | NULL | | > | un | blob | YES | | NULL | | > | cid | blob | YES | | NULL | | > | time | varchar(10) | YES | | NULL | | > +-----------+-------------+------+-----+---------+-------+ > > > System config: > > RedHat 9.0 > 1. Perl 5.8.0 > 2. Apache 2.0.49 compiled from source: > ./configure --prefix=/usr/local/apache2.0.49 --enable-rewrite=yes > --with-mpm=prefork > 3. mod_perl-1.99_13 compiled from source: > perl Makefile.PL MP_INST_APACHE2=1 > MP_AP_PREFIX=/usr/local/apache2.0.49 > 4. Embperl-2.0b10 compiled from source: > perl Makefile.PL > Apache headers from /usr/local/apache2.0.49 > no XALAN > 5. CGI.pm-3.0.5 > 6. DBI-1.42 > 7. Apache-SessionX-2.00b5 (no default session type or params in > Makefile.pl) > 8. mysql-standard-4.0.18-pc-linux-i686 > 9. DBD-mysql-2.9003 > 10. Apache-Session-1.6 > > > httpd.conf: > > ########### MOD_PERL ############ > LoadModule perl_module modules/mod_perl.so > PerlModule Apache2 > PerlSwitches -T > > ########### Embperl related stuff ########## > LoadModule embperl_module > /usr/lib/perl5/site_perl/5.8.0/i386-linux-thread-multi/auto/Embperl/Embperl.so > Embperl_UseEnv on > > > EMBPERL_DEBUG 2360084 > EMBPERL_LOG /usr/local/apache2.0.49/logs/embperl.log > Embperl_AppName 'myapp' > PerlSetEnv DBI_DSN "DBI:mysql:state:localhost" > Embperl_Object_Base index.epl > Embperl_UriMatch "\.htm.?|\.epl$" > EMBPERL_SESSION_CLASSES "MySQL Semaphore" > EMBPERL_SESSION_ARGS "Datasource=dbi::mysql::session UserName=sessions > Password=blahblah" > SetHandler perl-script > PerlHandler Embperl::Object > Options ExecCGI > > > AddType text/html .epl > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: embperl-unsubscribe@perl.apache.org > For additional commands, e-mail: embperl-help@perl.apache.org > --------------------------------------------------------------------- To unsubscribe, e-mail: embperl-unsubscribe@perl.apache.org For additional commands, e-mail: embperl-help@perl.apache.org