perl-embperl mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Jeremy Brooks <jbroo...@austin.rr.com>
Subject only _session_id appears in sessions table
Date Fri, 14 May 2004 22:00:07 GMT

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


Mime
View raw message