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