
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@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@net.ethz.ch Website: http://www.net.ethz.ch