[otrs] Error after Update of OTRS v. 1.3.2 to v. 2.1.4
Beat Müller
mueller at net.ethz.ch
Wed Jan 3 21:07:35 GMT 2007
Hi,
I'm just trying to Update our OTRS installation from v. 1.3.2 to v.
2.1.4 on a RedHat EL 4 AS / Postgresql 7.4.13 test installation. The
update process seemed to run fine following the installation manual
of the current OTRS version and the hints from 'Upgrading - upgrading
OTRS' (I dumped the current db from our operational installation,
restored it into the test installation and ran 'DBUpdate-
to-2.1.postgresql.sql'.
Now I go to login page of OTRS I can give in my UID and PWD and Ican
login successfully into the system, but getting back the following
error message in my browser window:
Software error:
Can't insert session id! at ../..//Kernel/System/AuthSession/DB.pm
line 204.
For help, please send mail to the webmaster (root at localhost), giving
this error message and the time and date of the error.
A look in the Apache error log returns I bunch of error messages (see
below), which are not helping me to solve the problem. I also added
the output of the db update script to this email (see further below).
There are some error messages, but I guess they are the reason for
the malfunction of OTRS.
Any hints from somebody how this issue can be solved?
Many thanks
Beat Mueller
------------ Output of Apache error log -----------------------------
[Wed Jan 03 20:51:42 2007] [error] [client ] [Wed Jan 3 20:51:42
2007] index.pl: DBD::Pg::st execute failed: ERROR: relation
"role_user" does not exist, referer: http://pruefstand.ethz.ch/otrs/
index.pl
[Wed Jan 03 20:51:42 2007] [error] [client ] ERROR: OTRS-CGI-1 Perl:
5.8.5 OS: linux Time: Wed Jan 3 20:51:42 2007, referer: http://
pruefstand.ethz.ch/otrs/index.pl
[Wed Jan 03 20:51:42 2007] [error] [client ] , referer: http://
pruefstand.ethz.ch/otrs/index.pl
[Wed Jan 03 20:51:42 2007] [error] [client ] Message: ERROR:
relation "role_user" does not exist, referer: http://
pruefstand.ethz.ch/otrs/index.pl
[Wed Jan 03 20:51:42 2007] [error] [client ] , SQL: 'SELECT
ru.role_id, ru.user_id, r.name FROM role_user ru, roles r WHERE
r.valid_id IN ( 1 ) AND r.id = ru.role_id AND ru.user_id = 6',
referer: http://pruefstand.ethz.ch/otrs/index.pl
[Wed Jan 03 20:51:42 2007] [error] [client ] , referer: http://
pruefstand.ethz.ch/otrs/index.pl
[Wed Jan 03 20:51:42 2007] [error] [client ] Traceback (4318): ,
referer: http://pruefstand.ethz.ch/otrs/index.pl
[Wed Jan 03 20:51:42 2007] [error] [client ] Module:
Kernel::System::Group::GroupUserRoleMemberList (v1.40) Line: 1190,
referer: http://pruefstand.ethz.ch/otrs/index.pl
[Wed Jan 03 20:51:42 2007] [error] [client ] Module:
Kernel::System::Group::GroupMemberList (v1.40) Line: 498, referer:
http://pruefstand.ethz.ch/otrs/index.pl
[Wed Jan 03 20:51:42 2007] [error] [client ] Module:
Kernel::System::Web::InterfaceAgent::Run (v1.17) Line: 230, referer:
http://pruefstand.ethz.ch/otrs/index.pl
[Wed Jan 03 20:51:42 2007] [error] [client ] Module: /opt/otrs/bin/
cgi-bin/index.pl (v1.81) Line: 47, referer: http://pruefstand.ethz.ch/
otrs/index.pl
[Wed Jan 03 20:51:42 2007] [error] [client ] , referer: http://
pruefstand.ethz.ch/otrs/index.pl
[Wed Jan 03 20:51:42 2007] [error] [client ] [Wed Jan 3 20:51:42
2007] index.pl: DBD::Pg::st fetchrow_array failed: no statement
executing, referer: http://pruefstand.ethz.ch/otrs/index.pl
[Wed Jan 03 20:51:42 2007] [error] [client ] [Wed Jan 3 20:51:42
2007] index.pl: DBD::Pg::st execute failed: ERROR: relation
"role_user" does not exist, referer: http://pruefstand.ethz.ch/otrs/
index.pl
[Wed Jan 03 20:51:42 2007] [error] [client ] ERROR: OTRS-CGI-1 Perl:
5.8.5 OS: linux Time: Wed Jan 3 20:51:42 2007, referer: http://
pruefstand.ethz.ch/otrs/index.pl
[Wed Jan 03 20:51:42 2007] [error] [client ] , referer: http://
pruefstand.ethz.ch/otrs/index.pl
[Wed Jan 03 20:51:42 2007] [error] [client ] Message: ERROR:
relation "role_user" does not exist, referer: http://
pruefstand.ethz.ch/otrs/index.pl
[Wed Jan 03 20:51:42 2007] [error] [client ] , SQL: 'SELECT
ru.role_id, ru.user_id, r.name FROM role_user ru, roles r WHERE
r.valid_id IN ( 1 ) AND r.id = ru.role_id AND ru.user_id = 6',
referer: http://pruefstand.ethz.ch/otrs/index.pl
[Wed Jan 03 20:51:42 2007] [error] [client ] , referer: http://
pruefstand.ethz.ch/otrs/index.pl
[Wed Jan 03 20:51:42 2007] [error] [client ] Traceback (4318): ,
referer: http://pruefstand.ethz.ch/otrs/index.pl
[Wed Jan 03 20:51:42 2007] [error] [client ] Module:
Kernel::System::Group::GroupUserRoleMemberList (v1.40) Line: 1190,
referer: http://pruefstand.ethz.ch/otrs/index.pl
[Wed Jan 03 20:51:42 2007] [error] [client ] Module:
Kernel::System::Group::GroupMemberList (v1.40) Line: 498, referer:
http://pruefstand.ethz.ch/otrs/index.pl
[Wed Jan 03 20:51:42 2007] [error] [client ] Module:
Kernel::System::Web::InterfaceAgent::Run (v1.17) Line: 239, referer:
http://pruefstand.ethz.ch/otrs/index.pl
[Wed Jan 03 20:51:42 2007] [error] [client ] Module: /opt/otrs/bin/
cgi-bin/index.pl (v1.81) Line: 47, referer: http://pruefstand.ethz.ch/
otrs/index.pl
[Wed Jan 03 20:51:42 2007] [error] [client ] , referer: http://
pruefstand.ethz.ch/otrs/index.pl
[Wed Jan 03 20:51:42 2007] [error] [client ] [Wed Jan 3 20:51:42
2007] index.pl: DBD::Pg::st fetchrow_array failed: no statement
executing, referer: http://pruefstand.ethz.ch/otrs/index.pl
[Wed Jan 03 20:51:42 2007] [error] [client ] [Wed Jan 3 20:51:42
2007] index.pl: DBD::Pg::st execute failed: ERROR: relation
"sessions" does not exist, referer: http://pruefstand.ethz.ch/otrs/
index.pl
[Wed Jan 03 20:51:42 2007] [error] [client ] ERROR: OTRS-CGI-1 Perl:
5.8.5 OS: linux Time: Wed Jan 3 20:51:42 2007, referer: http://
pruefstand.ethz.ch/otrs/index.pl
[Wed Jan 03 20:51:42 2007] [error] [client ] , referer: http://
pruefstand.ethz.ch/otrs/index.pl
[Wed Jan 03 20:51:42 2007] [error] [client ] Message: ERROR:
relation "sessions" does not exist, referer: http://
pruefstand.ethz.ch/otrs/index.pl
[Wed Jan 03 20:51:42 2007] [error] [client ] , SQL: 'SELECT
session_id FROM sessions ', referer: http://pruefstand.ethz.ch/otrs/
index.pl
[Wed Jan 03 20:51:42 2007] [error] [client ] , referer: http://
pruefstand.ethz.ch/otrs/index.pl
[Wed Jan 03 20:51:42 2007] [error] [client ] Traceback (4318): ,
referer: http://pruefstand.ethz.ch/otrs/index.pl
[Wed Jan 03 20:51:42 2007] [error] [client ] Module:
Kernel::System::AuthSession::DB::GetAllSessionIDs (v1.23) Line: 272,
referer: http://pruefstand.ethz.ch/otrs/index.pl
[Wed Jan 03 20:51:42 2007] [error] [client ] Module:
Kernel::System::AuthSession::GetExpiredSessionIDs (v1.26) Line: 211,
referer: http://pruefstand.ethz.ch/otrs/index.pl
[Wed Jan 03 20:51:42 2007] [error] [client ] Module:
Kernel::System::AuthSession::CreateSessionID (v1.26) Line: 144,
referer: http://pruefstand.ethz.ch/otrs/index.pl
[Wed Jan 03 20:51:42 2007] [error] [client ] Module:
Kernel::System::Web::InterfaceAgent::Run (v1.17) Line: 248, referer:
http://pruefstand.ethz.ch/otrs/index.pl
[Wed Jan 03 20:51:42 2007] [error] [client ] Module: /opt/otrs/bin/
cgi-bin/index.pl (v1.81) Line: 47, referer: http://pruefstand.ethz.ch/
otrs/index.pl
[Wed Jan 03 20:51:42 2007] [error] [client ] , referer: http://
pruefstand.ethz.ch/otrs/index.pl
[Wed Jan 03 20:51:42 2007] [error] [client ] [Wed Jan 3 20:51:42
2007] index.pl: DBD::Pg::st fetchrow_array failed: no statement
executing, referer: http://pruefstand.ethz.ch/otrs/index.pl
[Wed Jan 03 20:51:42 2007] [error] [client ] [Wed Jan 3 20:51:42
2007] index.pl: DBD::Pg::db do failed: ERROR: relation "sessions"
does not exist, referer: http://pruefstand.ethz.ch/otrs/index.pl
[Wed Jan 03 20:51:42 2007] [error] [client ] ERROR: OTRS-CGI-1 Perl:
5.8.5 OS: linux Time: Wed Jan 3 20:51:42 2007, referer: http://
pruefstand.ethz.ch/otrs/index.pl
[Wed Jan 03 20:51:42 2007] [error] [client ] , referer: http://
pruefstand.ethz.ch/otrs/index.pl
[Wed Jan 03 20:51:42 2007] [error] [client ] Message: ERROR:
relation "sessions" does not exist, referer: http://
pruefstand.ethz.ch/otrs/index.pl
[Wed Jan 03 20:51:42 2007] [error] [client ] , SQL: 'INSERT INTO
sessions (session_id, session_value) VALUES
('107d4d03fffd21225b000b3235898c285', 'ValidID:MQ==:\\;UserIsGroup
[stats]:WWVz:\\;UserComment::\\;UserRefreshTime:MTU=:\
\;UserEmail:bXVlbGxlckBuZXQuZXRoei5jaA==:\\;UserTheme:U3RhbmRhcmQ=:\
\;UserID:Ng==:\\;UserType:VXNlcg==:\\;UserCreateNextMask::\
\;UserFirstname:QmVhdA==:\\;UserSendNewTicketNotification::\
\;_UserLogin:bXVlbGxlcg==:\\;UserPw:bXUzMnJTYlRVOFhMTQ==:\
\;UserSalutation:SGVyciBEci4=:\\;UserSpellDict:ZGV1dHNjaA==:\
\;UserIsGroupRo[admin]:WWVz:\\;UserLastname:TXVlbGxlcg==:\
\;UserLastRequest:MTE2Nzg1MzkwMg==:\\;UserIsGroup[users]:WWVz:\
\;UserSendLockTimeoutNotification::\\;UserIsGroup[admin]:WWVz:\
\;UserLogin:bXVlbGxlcg==:\\;UserSendFollowUpNotification::\
\;UserIsGroupRo[users]:WWVz:\\;UserLanguage:ZGU=:\\;UserIsGroupRo
[stats]:WWVz:\\;UserQueueViewShowTickets:MTU=:\\;_UserPw:MW9lbGE0:\
\;UserQueueView:VGlja2V0Vmlldw==:\\;UserSendMoveNotification::\
\;UserLastLogin:MTE2Nzg1MjMzNw==:\\;UserSessionStart:MTE2Nzg1MzkwMg==:
\\;UserRemoteAddr:MTI5LjEzMi4yNDAuMTk5:\
\;UserRemoteUserAgent:TW96aWxsYS81LjAgKE1hY2ludG9zaDsgVTsgUFBDIE1hYyBPUy
BYIE1hY2gtTzsgZW4tVVM7IHJ2OjEuNy4xMykgR2Vja28vMjAwNjA0MTQ=:\\;')',
referer: http://pruefstand.ethz.ch/otrs/index.pl
[Wed Jan 03 20:51:42 2007] [error] [client ] , referer: http://
pruefstand.ethz.ch/otrs/index.pl
[Wed Jan 03 20:51:42 2007] [error] [client ] Traceback (4318): ,
referer: http://pruefstand.ethz.ch/otrs/index.pl
[Wed Jan 03 20:51:42 2007] [error] [client ] Module:
Kernel::System::AuthSession::DB::CreateSessionID (v1.23) Line: 204,
referer: http://pruefstand.ethz.ch/otrs/index.pl
[Wed Jan 03 20:51:42 2007] [error] [client ] Module:
Kernel::System::AuthSession::CreateSessionID (v1.26) Line: 151,
referer: http://pruefstand.ethz.ch/otrs/index.pl
[Wed Jan 03 20:51:42 2007] [error] [client ] Module:
Kernel::System::Web::InterfaceAgent::Run (v1.17) Line: 248, referer:
http://pruefstand.ethz.ch/otrs/index.pl
[Wed Jan 03 20:51:42 2007] [error] [client ] Module: /opt/otrs/bin/
cgi-bin/index.pl (v1.81) Line: 47, referer: http://pruefstand.ethz.ch/
otrs/index.pl
[Wed Jan 03 20:51:42 2007] [error] [client ] , referer: http://
pruefstand.ethz.ch/otrs/index.pl
[Wed Jan 03 20:51:42 2007] [error] [client ] [Wed Jan 3 20:51:42
2007] index.pl: Can't insert session id! at ../..//Kernel/System/
AuthSession/DB.pm line 204., referer: http://pruefstand.ethz.ch/otrs/
index.pl
------------------------------------------------------------------------
------
------------ Output of DB-Update-Script (DBUpdate-
to-2.1.postgresql.sql) ------------------
ERROR: adding columns with defaults is not implemented
HINT: Add the column, then use ALTER TABLE SET DEFAULT.
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
INSERT 282715 1
INSERT 282716 1
INSERT 282717 1
ALTER TABLE
CREATE TABLE
CREATE INDEX
INSERT 282721 1
INSERT 282722 1
ERROR: relation "object_link" does not exist
CREATE TABLE
ERROR: relation "object_link_old" does not exist
ERROR: table "object_link_old" does not exist
NOTICE: CREATE TABLE will create implicit sequence
"faq_voting_id_seq" for "serial" column "faq_voting.id"
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index
"faq_voting_pkey" for table "faq_voting"
CREATE TABLE
ALTER TABLE
ALTER TABLE
UPDATE 1
UPDATE 1
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ERROR: relation "faq_attachment" does not exist
ERROR: relation "faq_attachment" does not exist
ERROR: relation "faq_attachment" does not exist
ERROR: relation "faq_attachment" does not exist
-------------------------------------------------------------------
------------------------------------------------------------------------
-------------------------------
Beat Mueller
Informatikkoordinator
NET - Network for Educational Technology
ETH Zentrum SOW G 17
Sonneggstrasse 63
CH-8092 Zuerich
Tel: +41-44-632-6160
Fax: +41-44-632-1134
EMail: mueller at net.ethz.ch
Website: http://www.net.ethz.ch
More information about the otrs
mailing list