perl-embperl mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Jeremy Brooks <jbroo...@austin.rr.com>
Subject Re: only _session_id appears in sessions table
Date Sat, 15 May 2004 00:55:49 GMT
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;
> -]
> 
> <html>
> <body>
> time: [+$udat{time}+]
> <br/>
> id: [+$udat{_session_id}+]
> </body>
> </html>
> 
> 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
> 
> <Location /univista>
>   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
> </Location>
> 
> 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


Mime
View raw message