ich habe ein Problem beim anmelden nach dem OTRS Update.
Momentan betreiben wir OTRS 3.1.9 über einen Windows 2008R2-Server.
Laut den Release-Notes muss ich ja erst auf 3.2.0 updaten, und dann kann ich erst auf 3.2.6...
Folgende Version habe ich genutzt:
otrs-3.2.0.rc1-win-installer-2.4.5
Ich erkläre euch eben folgende Vorgehensweise:
1. Apache beenden
a. Config / var / Dump Datenbank gesichert
2. OTRS deinstalliert
3. Neue Version installiert (otrs-3.2.0.rc1-win-installer-2.4.5)
4. Sicherungen zurückkopiert
5. otrs.CheckModules.pl
Code: Select all
D:\OTRS\OTRS\bin>perl otrs.checkmodules.pl
Can't locate Win32/Console/ANSI.pm in @INC (@INC contains: D:/OTRS/OTRS/Custom D
:/OTRS/OTRS/Kernel/cpan-lib D:/OTRS/OTRS D:/OTRS/StrawberryPerl/perl/site/lib D:
/OTRS/StrawberryPerl/perl/vendor/lib D:/OTRS/StrawberryPerl/perl/lib .) at D:/OT
RS/StrawberryPerl/perl/lib/if.pm line 13.
BEGIN failed--compilation aborted at otrs.checkmodules.pl line 35.
7. Datenbank otrs angelegt (create Database otrs ....)
8. Berechtigungen auf "root" und "otrs" gesetzt und mit PW "hot" geschützt
Code: Select all
mysql> GRANT ALL PRIVILEGES ON otrs.* TO root@'localhost' IDENTIFIED BY 'hot';
Query OK, 0 rows affected (0.00 sec)
mysql> GRANT ALL PRIVILEGES ON otrs.* TO otrs@'localhost' IDENTIFIED BY 'hot';
Query OK, 0 rows affected (0.00 sec)
Code: Select all
mysql –uroot –p otrs < D:/Backup/otrs_dump.sql (PW: hot)
Code: Select all
mysql –uotrs -p otrs < DBUpdate-to-3.2.mysql.sql
D:\OTRS\OTRS\scripts>mysql -uotrs -p otrs < DBUpdate-to-3.2.mysql.sql
Enter password: ***
ERROR 1091 (42000) at line 25: Can't DROP 'article_flag_create_by'; check that c
olumn/key exists
Code: Select all
D:\OTRS\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!
Subroutine Load redefined at D:/OTRS/OTRS/Kernel/Config/Files/ZZZAuto.pm line 5.
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!
Subroutine Load redefined at D:/OTRS/OTRS/Kernel/Config/Files/ZZZAAuto.pm line 5
.
Subroutine Load redefined at D:/OTRS/OTRS/Kernel/Config/Files/ZZZAuto.pm line 5.
done.
Migration completed!
13. OTRS Agent Interface gestartet
14. Anmeldung mit meinem normalen Ticketsystem-User und was kommt?
Code: Select all
Session ungültig. Bitte neu anmelden!


Hier zusätzlich noch den letzten Abschnitt aus der LOG
Code: Select all
[Thu May 16 19:30:00 2013][Error][Kernel::System::DB::new][227] Access denied for user 'otrs'@'localhost' (using password: YES)
[Thu May 16 19:30:00 2013][Error][Kernel::System::DB::new][227] Access denied for user 'otrs'@'localhost' (using password: YES)
[Thu May 16 19:35:01 2013][Error][Kernel::System::DB::new][227] Access denied for user 'otrs'@'localhost' (using password: YES)
[Thu May 16 19:40:01 2013][Error][Kernel::System::PID::PIDGet][184] 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'
[Thu May 16 19:40:01 2013][Error][Kernel::System::PID::PIDDelete][226] Table 'otrs.process_id' doesn't exist, SQL: 'DELETE FROM process_id WHERE process_name = ? AND process_host = ?'
[Thu May 16 19:40:01 2013][Error][Kernel::System::PID::PIDCreate][154] Table 'otrs.process_id' doesn't exist, SQL: 'INSERT INTO process_id (process_name, process_id, process_host, process_create, process_change) VALUES (?, ?, ?, ?, ?)'
[Thu May 16 20:20:04 2013][Notice][Kernel::System::PID::PIDCreate] Can't create PID PostMasterMailbox, because it's already running (TICKETSYSTEM-URL/2928)!
[Thu May 16 20:20:04 2013][Error][Kernel::System::DynamicField::DynamicFieldGet][285] 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 = ?'
[Thu May 16 20:20:04 2013][Error][Kernel::System::DynamicField::DynamicFieldGet][285] 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 = ?'
[Thu May 16 20:20:04 2013][Error][Kernel::System::DynamicField::DynamicFieldGet][285] 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 = ?'
[Thu May 16 20:20:04 2013][Error][Kernel::System::DynamicField::DynamicFieldGet][285] 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 = ?'
[Thu May 16 20:20:04 2013][Error][Kernel::System::DynamicField::DynamicFieldGet][285] 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 = ?'
[Thu May 16 20:20:04 2013][Error][Kernel::System::DynamicField::DynamicFieldGet][285] 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 = ?'
[Thu May 16 20:20:04 2013][Error][Kernel::System::DynamicField::DynamicFieldGet][285] 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 = ?'
[Thu May 16 20:20:04 2013][Error][Kernel::System::DynamicField::DynamicFieldGet][285] 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 = ?'
[Thu May 16 20:27:23 2013][Notice][Kernel::System::Auth::LDAP::Auth] User: MeinBenutzer(CN=…\, …,OU=2011,OU=…,OU=Unna,DC=…,DC=de) authentication ok (REMOTE_ADDR: 127.0.0.1).
[Thu May 16 20:27:23 2013][Error][Kernel::System::AuthSession::DB::CreateSessionID][231] 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'
[Thu May 16 20:27:23 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 (?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?)'
[Thu May 16 20:27:23 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'
[Thu May 16 20:27:23 2013][Notice][Kernel::System::AuthSession::DB::CheckSessionID] SessionID: '20807f3d20ab58234e24f939a781f7cfcd' is invalid!!!
[Thu May 16 20:30:01 2013][Notice][Kernel::System::PID::PIDCreate] Can't create PID PostMasterMailbox, because it's already running (TICKETSYSTEM-URL /2928)!
[Thu May 16 20:30:01 2013][Error][Kernel::System::DynamicField::DynamicFieldGet][285] 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 = ?'
[Thu May 16 20:30:01 2013][Error][Kernel::System::DynamicField::DynamicFieldGet][285] 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 = ?'
[Thu May 16 20:30:01 2013][Error][Kernel::System::DynamicField::DynamicFieldGet][285] 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 = ?'
[Thu May 16 20:30:01 2013][Error][Kernel::System::DynamicField::DynamicFieldGet][285] 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 = ?'
[Thu May 16 20:40:01 2013][Notice][Kernel::System::PID::PIDCreate] Can't create PID PostMasterMailbox, because it's already running (TICKETSYSTEM-URL /2928)!
[Thu May 16 20:45:01 2013][Notice][Kernel::System::User::GetUserData] Panic! No UserData for user id: '2'!!!
[Thu May 16 20:45:01 2013][Notice][Kernel::System::User::GetUserData] Panic! No UserData for user id: '33'!!!
[Thu May 16 20:45:01 2013][Notice][Kernel::System::User::GetUserData] Panic! No UserData for user id: '54'!!!
[Thu May 16 20:45:01 2013][Notice][Kernel::System::User::GetUserData] Panic! No UserData for user id: '57'!!!
[Thu May 16 20:45:01 2013][Error][Kernel::System::CustomerUser::LDAP::CustomerUserDataGet][762] 000004DC: LdapErr: DSID-0C0906E8, comment: In order to perform this operation a successful bind must be completed on the connection., data 0, v1db1
[Thu May 16 20:45:01 2013][Error][Kernel::System::CustomerUser::LDAP::CustomerUserDataGet][762] 000004DC: LdapErr: DSID-0C0906E8, comment: In order to perform this operation a successful bind must be completed on the connection., data 0, v1db1
[Thu May 16 20:45:02 2013][Notice][Kernel::System::Ticket::Article::SendAgentNotification] Sent agent 'PendingReminder' notification to 'it.support@ticketsystem'.
[Thu May 16 20:45:08 2013][Error][Kernel::System::CustomerUser::LDAP::CustomerUserDataGet][762] 000004DC: LdapErr: DSID-0C0906E8, comment: In order to perform this operation a successful bind must be completed on the connection., data 0, v1db1
[Thu May 16 20:45:08 2013][Notice][Kernel::System::Ticket::Article::SendAgentNotification] Sent agent 'PendingReminder' notification to 'meinBenutzer @....
[Thu May 16 20:45:08 2013][Error][Kernel::System::CustomerUser::LDAP::CustomerUserDataGet][762] 000004DC: LdapErr: DSID-0C0906E8, comment: In order to perform this operation a successful bind must be completed on the connection., data 0, v1db1
[Thu May 16 20:45:08 2013][Error][Kernel::System::CustomerUser::LDAP::CustomerUserDataGet][762] 000004DC: LdapErr: DSID-0C0906E8, comment: In order to perform this operation a successful bind must be completed on the connection., data 0, v1db1
[Thu May 16 20:55:01 2013][Error][Kernel::System::AuthSession::DB::GetExpiredSessionIDs][427] Unknown column 'data_key' in 'field list', SQL: '
SELECT session_id, data_key, data_value
FROM sessions
WHERE data_key = 'UserSessionStart'
OR data_key = 'UserLastRequest'
ORDER BY id ASC'
[Thu May 16 21:00:01 2013][Notice][Kernel::System::PID::PIDCreate] Can't create PID PostMasterMailbox, because it's already running (TICKETSYSTEM-URL /2928)!
Tipps / Tricks... Bin für jede Hilfe dankbar !!!

Bitte um Hilfe und vielen Dank im Voraus!
Liebe Grüße