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: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
