Invalid SessionID after Upgrade to 3.2.1

[mk_we]

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!

[unixoid]

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)

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)
);

[folderol]

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:

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 (?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?)'

However, the session table looks fine:

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)
);

When enabling the MySQL query log, the session creation query seems to contain non-escaped characters:

pasted-1361447083-509490.png

For the full query, see the file query.txt attached.

[folderol]

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;

[BrianYin]

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!!