Hello,
after upgrade to 3.2.1 we cannot open CustomerFrontend anymore. We are using HTTPBasicAuth for CustomerLogin an receiving "Invalid SessionID" Error when opening CustomerFrontend.
In the logs the following error shows up:
[Error][Kernel::System::AuthSession::DB::CreateSessionID][Line:333]: Incorrect string value: '\x80\x02\x00\x00\x00\x08...' for column 'data_value' at row 1, SQL: 'INSERT INTO sessions (session_id, data_key, data_value, serialized) VALUES (?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?)'
[Notice][Kernel::System::AuthSession::DB::CheckSessionID] SessionID: '10fdf38ab40191c84e88804cfefeabac83' is invalid!!!
It seems to me, that this is an database related error. We're running opensuse and MySQL.
Any suggestions?
Thank you!
Invalid SessionID after Upgrade to 3.2.1
Moderator: crythias
Re: Invalid SessionID after Upgrade to 3.2.1
Hi!
We encountered the same problem. The problem is indeed in the DB. Table 'sessions' doesn't have required fields. I think that DB migrate script doesn't work properly.
To fix this you should exec this SQL (taken from otrs/scripts/database/otrs-schema.mysql.sql)
We encountered the same problem. The problem is indeed in the DB. Table 'sessions' doesn't have required fields. I think that DB migrate script doesn't work properly.
To fix this you should exec this SQL (taken from otrs/scripts/database/otrs-schema.mysql.sql)
Code: Select all
CREATE TABLE sessions (
id BIGINT NOT NULL AUTO_INCREMENT,
session_id VARCHAR (100) NOT NULL,
data_key VARCHAR (100) NOT NULL,
data_value TEXT NULL,
serialized SMALLINT NOT NULL,
PRIMARY KEY(id),
INDEX sessions_data_key (data_key),
INDEX sessions_session_id_data_key (session_id, data_key)
);
Re: Invalid SessionID after Upgrade to 3.2.1
After upgrading from OTRS 3.1.x to OTRS 3.2.2 Agent logins work but the Customer Frontend doesn't allow session creation anymore:
However, the session table looks fine:
When enabling the MySQL query log, the session creation query seems to contain non-escaped characters:
For the full query, see the file query.txt attached.
Code: Select all
[Thu Feb 21 11:31:16 2013][Error][Kernel::System::AuthSession::DB::CreateSessionID][333] Incorrect string value: '\x80\x00\x00\x00\x08C...' for column 'data_value' at row 1, SQL: 'INSERT INTO sessions (session_id, data_key, data_value, serialized) VALUES (?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?)'
Code: Select all
CREATE TABLE sessions (
id BIGINT NOT NULL AUTO_INCREMENT,
session_id VARCHAR (100) NOT NULL,
data_key VARCHAR (100) NOT NULL,
data_value TEXT NULL,
serialized SMALLINT NOT NULL,
PRIMARY KEY(id),
INDEX sessions_data_key (data_key),
INDEX sessions_session_id_data_key (session_id, data_key)
);
You do not have the required permissions to view the files attached to this post.
Re: Invalid SessionID after Upgrade to 3.2.1
The issue is fixed by executing the following query on the OTRS database in effect changing the data_value text encoding to binary (it basically behaves as a blob field then).
Code: Select all
ALTER TABLE sessions MODIFY data_value TEXT CHARACTER SET binary;
Re: Invalid SessionID after Upgrade to 3.2.1
i share the same problem
i can't login normally, the system said "Session invalid. Please log in again. " why's that?
how can i fix it?
Thanks!!
i can't login normally, the system said "Session invalid. Please log in again. " why's that?
how can i fix it?
Thanks!!
OTRS Version: 3.1.9
OS: windows 2003
ITSM 3.1.6
MySQL 5.xxx
OS: windows 2003
ITSM 3.1.6
MySQL 5.xxx