Session could not be unserialized
Hello,
I had this error in logs when I tried to browse the sessions in manager page :
"Session could not be unserialized at /usr/share/perl5/vendor_perl/Apache/Session/Serialize/Storable.pm line 28."
This error involved a 500 error code. I troobleshooted the problem when I deleted all values (90 rows) in the sessions table in MySQL database.
What means this error ? And How can I avoid this problem in the future ?
This is How I configure the database MySQL in the lemonldap-ng.ini :
globalStorage = Apache::Session::Browseable::MySQL
globalStorageOptions = {
'DataSource' => 'dbi:mysql:lemonldapng:127.0.0.1',
'UserName' => 'XXXXXXXX',
'Password' => 'XXXXXXXX',
'LockDataSource' => 'dbi:mysql:lemonldapng:127.0.0.1',
'LockUserName' => 'XXXXXXXX',
'LockPassword' => 'XXXXXXXX',
'Index' => 'ipAddr'
}
The creation session table
CREATE TABLE sessions
(
id
char(32) NOT NULL,
a_session
blob,
ipAddr
varchar(15) DEFAULT NULL,
PRIMARY KEY (id
),
KEY ipAddr
(ipAddr
)
) ENGINE=MyISAM DEFAULT CHARSET=latin1
Thanks for you help