No Login after OTRS Update / !!! HILFE !!

asxo · Post by **asxo** » 15 Apr 2013, 14:04

Hallo zusammen,

nachdem ich unser System von 3.1.5 auf 3.2.2 upgedatet habe, kann ich mich im Admin Bereich nicht mehr anmelden

D:\RT_West\OTRS\scripts>mysql -uroot otrs < DBUpdate-to-3.2.mysql.sql
INFO: Foreign key constraint FK_article_flag_article_id_id does not exist, skipp
ing.
INFO: Foreign key constraint FK_article_flag_article_id_id does not exist, skipp
ing.
INFO: Foreign key constraint FK_article_flag_create_by_id does not exist, skippi
ng.
INFO: Foreign key constraint FK_article_flag_create_by_id does not exist, skippi
ng.
ERROR 1091 (42000) at line 37: Can't DROP 'article_flag_create_by'; check that c
olumn/key exists

D:\RT_West\OTRS\scripts>perl DBUpdate-to-3.2.pl

Migration started...

Step 1 of 9: Refresh configuration cache...
If you see warnings about 'Subroutine Load redefined', that's fine, no need to w
orry!
done.

Step 2 of 9: Check framework version... done.

Step 3 of 9: Cleanup UserPreferences... done.

Step 4 of 9: Updating toolbar configuration... done.

Step 5 of 9: Updating AgentTicketZoom window configuration... done.

Step 6 of 9: Dropping obsolete columns from article_search... Check if columns e
xist.
Columns found, drop them.
ALTER TABLE article_search DROP a_freetext1
ALTER TABLE article_search DROP a_freetext2
ALTER TABLE article_search DROP a_freetext3
ALTER TABLE article_search DROP a_freekey1
ALTER TABLE article_search DROP a_freekey2
ALTER TABLE article_search DROP a_freekey3
done.

Step 7 of 9: Migration cache backend configuration... done.

Step 8 of 9: Clean up the cache... done.

Step 9 of 9: Refresh configuration cache another time...
If you see warnings about 'Subroutine Load redefined', that's fine, no need to w
orry!
done.

LOG:

[Mon Apr 15 13:56:38 2013][Notice][Kernel::System::AuthSession::DB::CheckSessionID] SessionID: '1015b9ae8136e6253e025e48b62cd22cd6' is invalid!!!

asxo · Post by **asxo** » 17 Apr 2013, 10:21

Niemand eine Idee warum ich mich nach dem Update nicht mehr anmelden kann???

Hazet · Post by **Hazet** » 17 Apr 2013, 11:00

Nur ein Versuch:

$OTRS_HOME/bin/DeleteSessionIDs.pl

asxo · Post by **asxo** » 19 Apr 2013, 10:18

Leider nein

Noch jemand eine Idee?

Habe auch schon das PW resettet, aber auch das bringt nichts.

jojo · Post by **jojo** » 19 Apr 2013, 10:22

ich schlage vor das Update nochmal durchzuführen. Und genauestens die UPGRADING Datei einzuhalten.

Aktuell ist die 3.2.5

asxo · Post by **asxo** » 19 Apr 2013, 11:18

Moin jojo,
hab ich schon 2 x gemacht, aber ich mache es gerne ein drittel mal.

Verbesser mich, wenn der Updatepfad nicht stimmt:

1. DB der aktuellen Version sichern
-> mysqldump -uroot otrs > otrs_dump.sql

2. Deinstallation der aktuellen OTRS Version

3. Installation der neuen 3.2.x OTRS Version
-> Nach installation, kopieren der alten Config.pm Datei ins neue Verzeichnis

4. DB neu anlegen:
-> CREATE DATABASE otrs CHARACTER SET utf8;
-> mysql -uroot -e "GRANT all ON otrs.* TO 'otrs'@'localhost' IDENTIFIED BY 'hot'" && mysql -uroot -e "FLUSH PRIVILEGES"

5. Rückspielung der DB
-> mysql -uroot otrs < otrs_dump.sql

6. Versionen per Scrips anpassen
-> mysql -uroot otrs < DBUpdate-to-3.2.mysql.sql
-> perl DBUpdate-to-3.2.pl

-> shell> bin/otrs.RebuildConfig.pl
-> shell> bin/otrs.DeleteCache.pl

Restart der OTRS Jobs

FINISH!

jojo · Post by **jojo** » 19 Apr 2013, 11:28

das sollte eigentlich klappen...

Bitte beschreibe den Fehler nochmal näher. Kannst Du Dich gar nicht anmelden? Dann steht auch definitiv was im Log (Apache und/oder OTRS Log)

asxo · Post by **asxo** » 19 Apr 2013, 12:11

Im Adminpannel steht: (egal welcher Benutzer)

Session ungültig. Bitte neu anmelden.
--------------
->otrs.log<-
--------------

[Fri Apr 19 11:44:41 2013][Error][Kernel::System::AuthSession::DB::CreateSessionID][333] Unknown column 'data_key' in 'field list', SQL: 'INSERT INTO sessions (session_id, data_key, data_value, serialized) VALUES (?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?)'
[Fri Apr 19 11:44:41 2013][Error][Kernel::System::AuthSession::DB::GetSessionIDData][164] Unknown column 'id' in 'field list', SQL: '
SELECT id, data_key, data_value, serialized
FROM sessions
WHERE session_id = ?
ORDER BY id ASC'
[Fri Apr 19 11:44:41 2013][Notice][Kernel::System::AuthSession::DB::CheckSessionID] SessionID: '10c92e6d0659354d67bde4b154483d9e25' is invalid!!!

->error.log Apache<---
------

10.49.51.126 - - [15/Apr/2013:13:53:31 +0200] "GET /otrs-web/skins/Customer/default/css-cache/CommonCSS_37c8e905f5c90a7742ad2767a29b4c34.css HTTP/1.1" 200 32996
10.49.51.126 - - [15/Apr/2013:13:53:31 +0200] "GET /otrs-web/js/js-cache/ModuleJS_f8dff54f80dbc43d25da4b79b5a662f1.js HTTP/1.1" 200 2348
10.49.51.126 - - [15/Apr/2013:13:53:31 +0200] "GET /otrs-web/js/js-cache/CommonJS_f5ab82f1110616f808d0be15b86cf93c.js HTTP/1.1" 200 314770
10.49.51.126 - - [15/Apr/2013:13:54:27 +0200] "POST /otrs/index.pl HTTP/1.1" 302 102
10.49.51.126 - - [15/Apr/2013:13:54:27 +0200] "GET /otrs/index.pl?;;;;&OTRSAgentInterface=10ebf972cae9f2d431ea2b6faae8e94138 HTTP/1.1" 200 10843
10.49.51.126 - - [15/Apr/2013:13:54:29 +0200] "GET /otrs-web/skins/Agent/default/css-cache/CommonCSS_b63ce6e86444542ca06a7ce31b90f50d.css HTTP/1.1" 200 86755
10.49.51.126 - - [15/Apr/2013:13:54:29 +0200] "GET /otrs-web/skins/Agent/default/css-cache/CommonCSS_b63ce6e86444542ca06a7ce31b90f50d.css HTTP/1.1" 200 86755
10.49.51.126 - - [15/Apr/2013:13:54:29 +0200] "GET /otrs-web/js/js-cache/ModuleJS_4f992dab9380aec856b1364e5a9f6df4.js HTTP/1.1" 200 685
10.49.51.126 - - [15/Apr/2013:13:54:29 +0200] "GET /otrs-web/js/js-cache/CommonJS_2e746091161cee3e31de01e73684bb91.js HTTP/1.1" 200 339908
10.49.51.126 - - [15/Apr/2013:13:54:36 +0200] "POST /otrs/index.pl HTTP/1.1" 302 103
10.49.51.126 - - [15/Apr/2013:13:54:36 +0200] "GET /otrs/index.pl?;;;;;&OTRSAgentInterface=106ecb4bda1d5900da9df2e2b4d28088fe HTTP/1.1" 200 10844
10.49.51.126 - - [15/Apr/2013:13:54:49 +0200] "GET /otrs/index.pl HTTP/1.1" 200 10732
10.49.51.126 - - [15/Apr/2013:13:54:57 +0200] "POST /otrs/index.pl HTTP/1.1" 302 98
10.49.51.126 - - [15/Apr/2013:13:54:57 +0200] "GET /otrs/index.pl?OTRSAgentInterface=10e58821f6659702dcb54f0bcf9e7f6b23 HTTP/1.1" 200 10839
10.49.51.126 - - [15/Apr/2013:13:55:38 +0200] "POST /otrs/index.pl HTTP/1.1" 302 99
10.49.51.126 - - [15/Apr/2013:13:55:38 +0200] "GET /otrs/index.pl?;&OTRSAgentInterface=101ace6b8c721d5c8d993327fecd106624 HTTP/1.1" 200 10840
10.49.51.126 - - [15/Apr/2013:13:56:35 +0200] "POST /otrs/index.pl HTTP/1.1" 302 100
10.49.51.126 - - [15/Apr/2013:13:56:38 +0200] "GET /otrs/index.pl?;;&OTRSAgentInterface=1015b9ae8136e6253e025e48b62cd22cd6 HTTP/1.1" 200 10841
10.49.51.126 - - [15/Apr/2013:13:56:39 +0200] "GET /otrs-web/skins/Agent/default/css-cache/CommonCSS_0db960086d5986d71080438cd3aa2c01.css HTTP/1.1" 200 86755
10.49.51.126 - - [15/Apr/2013:13:56:39 +0200] "GET /otrs-web/skins/Agent/default/css-cache/CommonCSS_0db960086d5986d71080438cd3aa2c01.css HTTP/1.1" 200 86755
10.49.51.126 - - [15/Apr/2013:13:56:39 +0200] "GET /otrs-web/js/js-cache/ModuleJS_e732f8c7313aafcebd3433b17fe5d072.js HTTP/1.1" 200 685
10.49.51.126 - - [15/Apr/2013:13:56:39 +0200] "GET /otrs-web/js/js-cache/CommonJS_79b58a3b6d0ecad6d110685f94325342.js HTTP/1.1" 200 339908
10.49.51.126 - - [19/Apr/2013:11:43:10 +0200] "GET /otrs/index.pl HTTP/1.1" 200 10732
10.49.51.126 - - [19/Apr/2013:11:43:41 +0200] "POST /otrs/index.pl HTTP/1.1" 302 98
10.49.51.126 - - [19/Apr/2013:11:43:49 +0200] "GET /otrs/index.pl?OTRSAgentInterface=109c464ec374adc4af82f127034ec3a89e HTTP/1.1" 200 10839
10.49.51.126 - - [19/Apr/2013:11:44:36 +0200] "POST /otrs/index.pl HTTP/1.1" 200 10798
10.49.51.126 - - [19/Apr/2013:11:44:40 +0200] "POST /otrs/index.pl HTTP/1.1" 302 99
10.49.51.126 - - [19/Apr/2013:11:44:41 +0200] "GET /otrs/index.pl?;&OTRSAgentInterface=10c92e6d0659354d67bde4b154483d9e25 HTTP/1.1" 200 10840

Hilft dir das??

jojo · Post by **jojo** » 19 Apr 2013, 12:26

irgendwas hat beim Update nicht geklappt. Es fehlt eine Spalte

asxo · Post by **asxo** » 19 Apr 2013, 12:32

Ich versuche mal die Version 3.2.5 einzuspielen und melde mich.

asxo · Post by **asxo** » 19 Apr 2013, 16:27

So nach dem Update auf 3.2.5 nun folgenes:

Meldung beim Update (mysql -uroot otrs < DBUpdate-to-3.0.mysql.sql)

INFO: Foreign key constraint FK_article_flag_article_id_id does not exist, skipp
ing.
INFO: Foreign key constraint FK_article_flag_article_id_id does not exist, skipp
ing.
INFO: Foreign key constraint FK_article_flag_create_by_id does not exist, skippi
ng.
INFO: Foreign key constraint FK_article_flag_create_by_id does not exist, skippi
ng.
ERROR 1091 (42000) at line 37: Can't DROP 'article_flag_create_by'; check that c
olumn/key exists

otrs.LOG

[Fri Apr 19 14:40:31 2013][Error][Kernel::System::DB::new][224] Access denied for user 'otrs'@'localhost' (using password: YES)
[Fri Apr 19 14:45:01 2013][Error][Kernel::System::DB::new][224] Access denied for user 'otrs'@'localhost' (using password: YES)
[Fri Apr 19 14:50:01 2013][Error][Kernel::System::PID::PIDGet][181] Table 'otrs.process_id' doesn't exist, SQL: 'SELECT process_name, process_id, process_host, process_create, process_change FROM process_id WHERE process_name = ? LIMIT 1'
[Fri Apr 19 14:50:01 2013][Error][Kernel::System::PID::PIDDelete][223] Table 'otrs.process_id' doesn't exist, SQL: 'DELETE FROM process_id WHERE process_name = ? AND process_host = ?'
[Fri Apr 19 14:50:01 2013][Error][Kernel::System::PID::PIDCreate][151] Table 'otrs.process_id' doesn't exist, SQL: 'INSERT INTO process_id (process_name, process_id, process_host, process_create, process_change) VALUES (?, ?, ?, ?, ?)'
[Fri Apr 19 14:55:14 2013][Error][Kernel::System::AuthSession::DB::GetExpiredSessionIDs][422] Table 'otrs.sessions' doesn't exist, SQL: '
SELECT session_id, data_key, data_value
FROM sessions
WHERE data_key = 'UserSessionStart'
OR data_key = 'UserLastRequest'
ORDER BY id ASC'
[Fri Apr 19 15:00:23 2013][Error][Kernel::System::PID::PIDGet][181] Table 'otrs.process_id' doesn't exist, SQL: 'SELECT process_name, process_id, process_host, process_create, process_change FROM process_id WHERE process_name = ? LIMIT 1'
[Fri Apr 19 15:00:23 2013][Error][Kernel::System::PID::PIDDelete][223] Table 'otrs.process_id' doesn't exist, SQL: 'DELETE FROM process_id WHERE process_name = ? AND process_host = ?'
[Fri Apr 19 15:00:23 2013][Error][Kernel::System::PID::PIDCreate][151] Table 'otrs.process_id' doesn't exist, SQL: 'INSERT INTO process_id (process_name, process_id, process_host, process_create, process_change) VALUES (?, ?, ?, ?, ?)'
[Fri Apr 19 15:10:23 2013][Error][Kernel::System::PID::PIDGet][181] Table 'otrs.process_id' doesn't exist, SQL: 'SELECT process_name, process_id, process_host, process_create, process_change FROM process_id WHERE process_name = ? LIMIT 1'
[Fri Apr 19 15:10:23 2013][Error][Kernel::System::PID::PIDDelete][223] Table 'otrs.process_id' doesn't exist, SQL: 'DELETE FROM process_id WHERE process_name = ? AND process_host = ?'
[Fri Apr 19 15:10:23 2013][Error][Kernel::System::PID::PIDCreate][151] Table 'otrs.process_id' doesn't exist, SQL: 'INSERT INTO process_id (process_name, process_id, process_host, process_create, process_change) VALUES (?, ?, ?, ?, ?)'
[Fri Apr 19 15:20:31 2013][Error][Kernel::System::PID::PIDGet][181] Table 'otrs.process_id' doesn't exist, SQL: 'SELECT process_name, process_id, process_host, process_create, process_change FROM process_id WHERE process_name = ? LIMIT 1'
[Fri Apr 19 15:20:31 2013][Error][Kernel::System::PID::PIDDelete][223] Table 'otrs.process_id' doesn't exist, SQL: 'DELETE FROM process_id WHERE process_name = ? AND process_host = ?'
[Fri Apr 19 15:20:31 2013][Error][Kernel::System::PID::PIDCreate][151] Table 'otrs.process_id' doesn't exist, SQL: 'INSERT INTO process_id (process_name, process_id, process_host, process_create, process_change) VALUES (?, ?, ?, ?, ?)'
[Fri Apr 19 15:30:19 2013][Error][Kernel::System::PID::PIDGet][181] Table 'otrs.process_id' doesn't exist, SQL: 'SELECT process_name, process_id, process_host, process_create, process_change FROM process_id WHERE process_name = ? LIMIT 1'
[Fri Apr 19 15:30:19 2013][Error][Kernel::System::PID::PIDDelete][223] Table 'otrs.process_id' doesn't exist, SQL: 'DELETE FROM process_id WHERE process_name = ? AND process_host = ?'
[Fri Apr 19 15:30:19 2013][Error][Kernel::System::PID::PIDCreate][151] Table 'otrs.process_id' doesn't exist, SQL: 'INSERT INTO process_id (process_name, process_id, process_host, process_create, process_change) VALUES (?, ?, ?, ?, ?)'
[Fri Apr 19 15:40:22 2013][Error][Kernel::System::PID::PIDGet][181] Table 'otrs.process_id' doesn't exist, SQL: 'SELECT process_name, process_id, process_host, process_create, process_change FROM process_id WHERE process_name = ? LIMIT 1'
[Fri Apr 19 15:40:22 2013][Error][Kernel::System::PID::PIDDelete][223] Table 'otrs.process_id' doesn't exist, SQL: 'DELETE FROM process_id WHERE process_name = ? AND process_host = ?'
[Fri Apr 19 15:40:22 2013][Error][Kernel::System::PID::PIDCreate][151] Table 'otrs.process_id' doesn't exist, SQL: 'INSERT INTO process_id (process_name, process_id, process_host, process_create, process_change) VALUES (?, ?, ?, ?, ?)'
[Fri Apr 19 15:50:34 2013][Error][Kernel::System::PID::PIDGet][181] Table 'otrs.process_id' doesn't exist, SQL: 'SELECT process_name, process_id, process_host, process_create, process_change FROM process_id WHERE process_name = ? LIMIT 1'
[Fri Apr 19 15:50:34 2013][Error][Kernel::System::PID::PIDDelete][223] Table 'otrs.process_id' doesn't exist, SQL: 'DELETE FROM process_id WHERE process_name = ? AND process_host = ?'
[Fri Apr 19 15:50:34 2013][Error][Kernel::System::PID::PIDCreate][151] Table 'otrs.process_id' doesn't exist, SQL: 'INSERT INTO process_id (process_name, process_id, process_host, process_create, process_change) VALUES (?, ?, ?, ?, ?)'
[Fri Apr 19 16:03:15 2013][Error][main::_AutoStop][685] NOTICE: otrs.Shceduler4win.pl is registered on the DB, but the registry has not been updated in 1454725 seconds!. The register will be deleted so Scheduler can start again without forcing
[Fri Apr 19 16:03:15 2013][Notice][Kernel::System::PID::PIDCreate] Removed PID (otrs.Scheduler/w3duibo05.ger.win.int.kn/7612, because 1 hour old!
[Fri Apr 19 16:03:16 2013][Notice][main::_Start] Scheduler Service is starting...!
[Fri Apr 19 16:03:17 2013][Notice][main::_Start] Scheduler Service start! PID 7612
[Fri Apr 19 16:04:46 2013][Notice][Kernel::System::Auth::DB::Auth] User: andreas.seelen authentication ok (REMOTE_ADDR: 10.49.51.126).
[Fri Apr 19 16:04:46 2013][Error][Kernel::System::AuthSession::DB::CreateSessionID][226] Unknown column 'data_key' in 'field list', SQL: '
SELECT session_id, data_key, data_value
FROM sessions
WHERE data_key = 'UserType'
OR data_key = 'UserLastRequest'
ORDER BY id ASC'
[Fri Apr 19 16:04:46 2013][Error][Kernel::System::AuthSession::DB::CreateSessionID][328] Unknown column 'data_key' in 'field list', SQL: 'INSERT INTO sessions (session_id, data_key, data_value, serialized) VALUES (?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?)'
[Fri Apr 19 16:04:47 2013][Error][Kernel::System::AuthSession::DB::GetSessionIDData][159] Unknown column 'id' in 'field list', SQL: '
SELECT id, data_key, data_value, serialized
FROM sessions
WHERE session_id = ?
ORDER BY id ASC'
[Fri Apr 19 16:04:47 2013][Notice][Kernel::System::AuthSession::DB::CheckSessionID] SessionID: '103bc0a5d9006185d020e6b38ca935dd52' is invalid!!!
[Fri Apr 19 16:09:03 2013][Notice][Kernel::System::Auth::DB::Auth] User: ohne authentication ok (REMOTE_ADDR: 10.49.51.126).
[Fri Apr 19 16:09:03 2013][Error][Kernel::System::AuthSession::DB::CreateSessionID][226] Unknown column 'data_key' in 'field list', SQL: '
SELECT session_id, data_key, data_value
FROM sessions
WHERE data_key = 'UserType'
OR data_key = 'UserLastRequest'
ORDER BY id ASC'
[Fri Apr 19 16:09:03 2013][Error][Kernel::System::AuthSession::DB::CreateSessionID][328] Unknown column 'data_key' in 'field list', SQL: 'INSERT INTO sessions (session_id, data_key, data_value, serialized) VALUES (?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?)'
[Fri Apr 19 16:09:03 2013][Error][Kernel::System::AuthSession::DB::GetSessionIDData][159] Unknown column 'id' in 'field list', SQL: '
SELECT id, data_key, data_value, serialized
FROM sessions
WHERE session_id = ?
ORDER BY id ASC'
[Fri Apr 19 16:09:03 2013][Notice][Kernel::System::AuthSession::DB::CheckSessionID] SessionID: '108d1dab788889f7da528991e7909f9a52' is invalid!!!
[Fri Apr 19 16:10:01 2013][Error][Kernel::System::DynamicField::DynamicFieldGet][280] Unknown column 'internal_field' in 'field list', SQL: 'SELECT id, internal_field, name, label, field_order, field_type, object_type, config, valid_id, create_time, change_time FROM dynamic_field WHERE id = ?'
[Fri Apr 19 16:10:01 2013][Error][Kernel::System::DynamicField::DynamicFieldGet][280] Unknown column 'internal_field' in 'field list', SQL: 'SELECT id, internal_field, name, label, field_order, field_type, object_type, config, valid_id, create_time, change_time FROM dynamic_field WHERE id = ?'
[Fri Apr 19 16:10:01 2013][Error][Kernel::System::DynamicField::DynamicFieldGet][280] Unknown column 'internal_field' in 'field list', SQL: 'SELECT id, internal_field, name, label, field_order, field_type, object_type, config, valid_id, create_time, change_time FROM dynamic_field WHERE id = ?'
[Fri Apr 19 16:10:01 2013][Error][Kernel::System::DynamicField::DynamicFieldGet][280] Unknown column 'internal_field' in 'field list', SQL: 'SELECT id, internal_field, name, label, field_order, field_type, object_type, config, valid_id, create_time, change_time FROM dynamic_field WHERE id = ?'
[Fri Apr 19 16:10:01 2013][Error][Kernel::System::DynamicField::DynamicFieldGet][280] Unknown column 'internal_field' in 'field list', SQL: 'SELECT id, internal_field, name, label, field_order, field_type, object_type, config, valid_id, create_time, change_time FROM dynamic_field WHERE id = ?'
[Fri Apr 19 16:10:01 2013][Error][Kernel::System::DynamicField::DynamicFieldGet][280] Unknown column 'internal_field' in 'field list', SQL: 'SELECT id, internal_field, name, label, field_order, field_type, object_type, config, valid_id, create_time, change_time FROM dynamic_field WHERE id = ?'
[Fri Apr 19 16:10:01 2013][Error][Kernel::System::DynamicField::DynamicFieldGet][280] Unknown column 'internal_field' in 'field list', SQL: 'SELECT id, internal_field, name, label, field_order, field_type, object_type, config, valid_id, create_time, change_time FROM dynamic_field WHERE id = ?'
[Fri Apr 19 16:10:01 2013][Error][Kernel::System::DynamicField::DynamicFieldGet][280] Unknown column 'internal_field' in 'field list', SQL: 'SELECT id, internal_field, name, label, field_order, field_type, object_type, config, valid_id, create_time, change_time FROM dynamic_field WHERE id = ?'
[Fri Apr 19 16:10:01 2013][Error][Kernel::System::DynamicField::DynamicFieldGet][280] Unknown column 'internal_field' in 'field list', SQL: 'SELECT id, internal_field, name, label, field_order, field_type, object_type, config, valid_id, create_time, change_time FROM dynamic_field WHERE id = ?'
[Fri Apr 19 16:10:01 2013][Error][Kernel::System::DynamicField::DynamicFieldGet][280] Unknown column 'internal_field' in 'field list', SQL: 'SELECT id, internal_field, name, label, field_order, field_type, object_type, config, valid_id, create_time, change_time FROM dynamic_field WHERE id = ?'
[Fri Apr 19 16:10:01 2013][Error][Kernel::System::DynamicField::DynamicFieldGet][280] Unknown column 'internal_field' in 'field list', SQL: 'SELECT id, internal_field, name, label, field_order, field_type, object_type, config, valid_id, create_time, change_time FROM dynamic_field WHERE id = ?'
[Fri Apr 19 16:10:01 2013][Error][Kernel::System::DynamicField::DynamicFieldGet][280] Unknown column 'internal_field' in 'field list', SQL: 'SELECT id, internal_field, name, label, field_order, field_type, object_type, config, valid_id, create_time, change_time FROM dynamic_field WHERE id = ?'
[Fri Apr 19 16:10:01 2013][Error][Kernel::System::DynamicField::DynamicFieldGet][280] Unknown column 'internal_field' in 'field list', SQL: 'SELECT id, internal_field, name, label, field_order, field_type, object_type, config, valid_id, create_time, change_time FROM dynamic_field WHERE id = ?'
[Fri Apr 19 16:10:01 2013][Error][Kernel::System::DynamicField::DynamicFieldGet][280] Unknown column 'internal_field' in 'field list', SQL: 'SELECT id, internal_field, name, label, field_order, field_type, object_type, config, valid_id, create_time, change_time FROM dynamic_field WHERE id = ?'
[Fri Apr 19 16:10:01 2013][Error][Kernel::System::DynamicField::DynamicFieldGet][280] Unknown column 'internal_field' in 'field list', SQL: 'SELECT id, internal_field, name, label, field_order, field_type, object_type, config, valid_id, create_time, change_time FROM dynamic_field WHERE id = ?'
[Fri Apr 19 16:10:01 2013][Error][Kernel::System::DynamicField::DynamicFieldGet][280] Unknown column 'internal_field' in 'field list', SQL: 'SELECT id, internal_field, name, label, field_order, field_type, object_type, config, valid_id, create_time, change_time FROM dynamic_field WHERE id = ?'

Vielleicht noch folgendes als Info:
Auf dem System ist ITSM installiert, welches ich auch mit updaten wollte. Das mache ich doch dann auch erst, sobald ich mich im Adminbereich anmelden kann, oder schon vorher??

Danke für eure Hilfe!

asxo

jojo · Post by **jojo** » 19 Apr 2013, 16:30

aus Irgendeinem Grund ist Deine Datenbank nicht upgedated worden

probier es mal mit:

Code: Select all

mysql -uroot otrs

anschliessend via

Code: Select all

source /pfad/zum/upgrade-SQL.file

das script ausführen

asxo · Post by **asxo** » 19 Apr 2013, 17:22

Ergebnis:

mysql> source D:\rt_west\otrs\scripts\dbupdate-to-3.2.mysql.sql
ERROR 1091 (42000): Can't DROP 'group_read'; check that column/key exists
ERROR 1091 (42000): Can't DROP 'group_write'; check that column/key exists
ERROR 1091 (42000): Can't DROP 'other_read'; check that column/key exists
ERROR 1091 (42000): Can't DROP 'other_write'; check that column/key exists
ERROR 1091 (42000): Can't DROP 'ticket_answered'; check that column/key exists
ERROR 1091 (42000): Can't DROP 'ticket_answered'; check that column/key exists
Query OK, 0 rows affected (0.14 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)
Statement prepared

+-------------------------------------------------------------------------------
-------+
| INFO: Foreign key constraint FK_article_flag_article_id_id does not exist, ski
pping. |
+-------------------------------------------------------------------------------
-------+
| INFO: Foreign key constraint FK_article_flag_article_id_id does not exist, ski
pping. |
+-------------------------------------------------------------------------------
-------+
1 row in set (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.02 sec)
Statement prepared

+-------------------------------------------------------------------------------
------+
| INFO: Foreign key constraint FK_article_flag_create_by_id does not exist, skip
ping. |
+-------------------------------------------------------------------------------
------+
| INFO: Foreign key constraint FK_article_flag_create_by_id does not exist, skip
ping. |
+-------------------------------------------------------------------------------
------+
1 row in set (0.00 sec)

ERROR 1091 (42000): Can't DROP 'article_flag_create_by'; check that column/key e
xists
Query OK, 219956 rows affected (0.95 sec)
Records: 219956 Duplicates: 0 Warnings: 0

Query OK, 219956 rows affected (1.20 sec)
Records: 219956 Duplicates: 0 Warnings: 0

Query OK, 219956 rows affected (0.72 sec)
Records: 219956 Duplicates: 0 Warnings: 0

Query OK, 35265 rows affected (2.55 sec)
Records: 35265 Duplicates: 0 Warnings: 0

Query OK, 35265 rows affected (2.27 sec)
Records: 35265 Duplicates: 0 Warnings: 0

Query OK, 35265 rows affected (2.19 sec)
Records: 35265 Duplicates: 0 Warnings: 0

Query OK, 0 rows affected (0.02 sec)

Query OK, 0 rows affected (0.05 sec)

Query OK, 0 rows affected (0.02 sec)

Query OK, 0 rows affected (0.02 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.01 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 47 rows affected (0.11 sec)
Records: 47 Duplicates: 0 Warnings: 0

Query OK, 47 rows affected (0.14 sec)
Rows matched: 47 Changed: 47 Warnings: 0

Query OK, 47 rows affected (0.05 sec)
Records: 47 Duplicates: 0 Warnings: 0

Query OK, 1 row affected (0.00 sec)

Query OK, 1 row affected (0.00 sec)

Query OK, 0 rows affected (0.09 sec)

Query OK, 0 rows affected (0.02 sec)

Query OK, 0 rows affected (0.03 sec)
Records: 0 Duplicates: 0 Warnings: 0

Query OK, 0 rows affected (0.03 sec)
Records: 0 Duplicates: 0 Warnings: 0

Query OK, 0 rows affected (0.02 sec)
Records: 0 Duplicates: 0 Warnings: 0

Query OK, 0 rows affected (0.01 sec)
Records: 0 Duplicates: 0 Warnings: 0

Query OK, 0 rows affected (0.02 sec)
Records: 0 Duplicates: 0 Warnings: 0

Query OK, 0 rows affected (0.02 sec)
Records: 0 Duplicates: 0 Warnings: 0

Query OK, 0 rows affected (0.01 sec)
Records: 0 Duplicates: 0 Warnings: 0

Query OK, 0 rows affected (0.02 sec)
Records: 0 Duplicates: 0 Warnings: 0

Query OK, 0 rows affected (0.02 sec)
Records: 0 Duplicates: 0 Warnings: 0

Query OK, 0 rows affected (0.01 sec)
Records: 0 Duplicates: 0 Warnings: 0

mysql>

asxo · Post by **asxo** » 20 Apr 2013, 09:07

Moin,

also erstmal die gute Nachricht, es scheint funktioniert zu haben, werde das jetzt nochmal komplett durchspielen und mich dann melden.

Aber ich bekomme noch eine Meldung beim Start der OTRS Job´s.

The MySQL service was started successfully.

Can't locate Path/Class.pm in @INC (@INC contains: D:/RT_West/StrawberryPerl/per
l/site/lib D:/RT_West/StrawberryPerl/perl/vendor/lib D:/RT_West/StrawberryPerl/p
erl/lib .) at D:\RT_West\OTRS\bin\otrs.Cron4Win32.pl line 27.
BEGIN failed--compilation aborted at D:\RT_West\OTRS\bin\otrs.Cron4Win32.pl line
27.

The Cron Service (CRONw) service was started successfully.

Thks
asxo

Znuny Open Source Ticketsystem

No Login after OTRS Update / !!! HILFE !!

No Login after OTRS Update / !!! HILFE !!

Re: No Login after OTRS Update / !!! HILFE !!

Re: No Login after OTRS Update / !!! HILFE !!

Re: No Login after OTRS Update / !!! HILFE !!

Re: No Login after OTRS Update / !!! HILFE !!

Re: No Login after OTRS Update / !!! HILFE !!

Re: No Login after OTRS Update / !!! HILFE !!

Re: No Login after OTRS Update / !!! HILFE !!

Re: No Login after OTRS Update / !!! HILFE !!

Re: No Login after OTRS Update / !!! HILFE !!

Re: No Login after OTRS Update / !!! HILFE !!

Re: No Login after OTRS Update / !!! HILFE !!

Re: No Login after OTRS Update / !!! HILFE !!

Re: No Login after OTRS Update / !!! HILFE !!