Hi monks!
sub session_create
{
my ($obj, $dbh, $userid) = @_;
my $mydbh = $dbh;
unless($mydbh) { $mydbh = &libyn::DB::connect_to_db($obj); }
$CGI::Session::MySQL::TABLE_NAME = $libyn::Config::DbTables{sessions
+};
my $session = CGI::Session->new("driver:MySQL", $obj->{-cgi}, { Han
+dle => $mydbh }) or die "CGI::Session->new failed.";
$session->name('sessionId');
$session->expire('+1h');
$session->param('userId', $userid);
unless($dbh) { $mydbh->disconnect(); }
return $session;
}
I do not get an error but that database table does not get filled. The structure of the database table is
CREATE TABLE yn_sessions (
id varchar(32) NOT NULL default '',
a_session text NOT NULL,
userId bigint(20) default NULL,
UNIQUE KEY id (id)
) TYPE=MyISAM;
The doc of CGI::Session says that id has to be of type CHAR; i did create the table using CHAR in the first place and i tried changing it to CHAR later but it ain't working...
Can that be the problem?