I'm having the same issue with version 3.3.6 on Windows Server 2008R2, IIS7 connecting to SQL Server 2008R2.
I have the default user, I go to index.pl and log in and there is no error message, it just doesn't start the session properly.
Code: Select all
[Wed May 7 11:14:23 2014][Notice][Kernel::System::Auth::DB::Auth] User: root@localhost authentication ok (Method: sha256, REMOTE_ADDR: 127.0.0.1).
[Wed May 7 11:14:23 2014][Debug][Kernel::System::User::Preferences::DB::SetPreferences][61] DB.pm->Do (2) SQL: '
DELETE FROM user_preferences
WHERE user_id = ?
AND preferences_key = ?'
[Wed May 7 11:14:23 2014][Debug][Kernel::System::User::Preferences::DB::SetPreferences][70] DB.pm->Do (3) SQL: '
INSERT INTO user_preferences
(user_id, preferences_key, preferences_value)
VALUES (?, ?, ?)'
[Wed May 7 11:14:24 2014][Debug][Kernel::System::AuthSession::DB::CreateSessionID][309] DB.pm->Do (4) SQL: '
DELETE FROM sessions
WHERE session_id = ?'
[Wed May 7 11:14:24 2014][Debug][Kernel::System::AuthSession::DB::CreateSessionID][326] DB.pm->Do (5) SQL: 'INSERT INTO sessions (session_id, data_key, data_value, serialized) VALUES (?,?,?,?)'
[Wed May 7 11:14:24 2014][Debug][Kernel::System::AuthSession::DB::CreateSessionID][326] DB.pm->Do (6) SQL: 'INSERT INTO sessions (session_id, data_key, data_value, serialized) VALUES (?,?,?,?)'
[Wed May 7 11:14:24 2014][Debug][Kernel::System::AuthSession::DB::CreateSessionID][326] DB.pm->Do (7) SQL: 'INSERT INTO sessions (session_id, data_key, data_value, serialized) VALUES (?,?,?,?)'
[Wed May 7 11:14:24 2014][Debug][Kernel::System::AuthSession::DB::CreateSessionID][326] DB.pm->Do (8) SQL: 'INSERT INTO sessions (session_id, data_key, data_value, serialized) VALUES (?,?,?,?)'
[Wed May 7 11:14:24 2014][Debug][Kernel::System::AuthSession::DB::CreateSessionID][326] DB.pm->Do (9) SQL: 'INSERT INTO sessions (session_id, data_key, data_value, serialized) VALUES (?,?,?,?)'
[Wed May 7 11:14:24 2014][Debug][Kernel::System::AuthSession::DB::CreateSessionID][326] DB.pm->Do (10) SQL: 'INSERT INTO sessions (session_id, data_key, data_value, serialized) VALUES (?,?,?,?)'
[Wed May 7 11:14:24 2014][Debug][Kernel::System::AuthSession::DB::CreateSessionID][326] DB.pm->Do (11) SQL: 'INSERT INTO sessions (session_id, data_key, data_value, serialized) VALUES (?,?,?,?)'
[Wed May 7 11:14:24 2014][Debug][Kernel::System::AuthSession::DB::CreateSessionID][326] DB.pm->Do (12) SQL: 'INSERT INTO sessions (session_id, data_key, data_value, serialized) VALUES (?,?,?,?)'
[Wed May 7 11:14:24 2014][Debug][Kernel::System::AuthSession::DB::CreateSessionID][326] DB.pm->Do (13) SQL: 'INSERT INTO sessions (session_id, data_key, data_value, serialized) VALUES (?,?,?,?)'
[Wed May 7 11:14:24 2014][Debug][Kernel::System::AuthSession::DB::CreateSessionID][326] DB.pm->Do (14) SQL: 'INSERT INTO sessions (session_id, data_key, data_value, serialized) VALUES (?,?,?,?)'
[Wed May 7 11:14:24 2014][Debug][Kernel::System::AuthSession::DB::CreateSessionID][326] DB.pm->Do (15) SQL: 'INSERT INTO sessions (session_id, data_key, data_value, serialized) VALUES (?,?,?,?)'
[Wed May 7 11:14:24 2014][Debug][Kernel::System::AuthSession::DB::CreateSessionID][326] DB.pm->Do (16) SQL: 'INSERT INTO sessions (session_id, data_key, data_value, serialized) VALUES (?,?,?,?)'
[Wed May 7 11:14:24 2014][Debug][Kernel::System::AuthSession::DB::CreateSessionID][326] DB.pm->Do (17) SQL: 'INSERT INTO sessions (session_id, data_key, data_value, serialized) VALUES (?,?,?,?)'
[Wed May 7 11:14:24 2014][Debug][Kernel::System::AuthSession::DB::CreateSessionID][326] DB.pm->Do (18) SQL: 'INSERT INTO sessions (session_id, data_key, data_value, serialized) VALUES (?,?,?,?)'
[Wed May 7 11:14:24 2014][Debug][Kernel::System::AuthSession::DB::CreateSessionID][326] DB.pm->Do (19) SQL: 'INSERT INTO sessions (session_id, data_key, data_value, serialized) VALUES (?,?,?,?)'
[Wed May 7 11:14:24 2014][Debug][Kernel::System::AuthSession::DB::CreateSessionID][326] DB.pm->Do (20) SQL: 'INSERT INTO sessions (session_id, data_key, data_value, serialized) VALUES (?,?,?,?)'
[Wed May 7 11:14:24 2014][Debug][Kernel::System::AuthSession::DB::CreateSessionID][326] DB.pm->Do (21) SQL: 'INSERT INTO sessions (session_id, data_key, data_value, serialized) VALUES (?,?,?,?)'
[Wed May 7 11:14:24 2014][Debug][Kernel::System::AuthSession::DB::CreateSessionID][326] DB.pm->Do (22) SQL: 'INSERT INTO sessions (session_id, data_key, data_value, serialized) VALUES (?,?,?,?)'
[Wed May 7 11:14:24 2014][Debug][Kernel::System::AuthSession::DB::CreateSessionID][326] DB.pm->Do (23) SQL: 'INSERT INTO sessions (session_id, data_key, data_value, serialized) VALUES (?,?,?,?)'
[Wed May 7 11:14:24 2014][Debug][Kernel::System::AuthSession::DB::CreateSessionID][326] DB.pm->Do (24) SQL: 'INSERT INTO sessions (session_id, data_key, data_value, serialized) VALUES (?,?,?,?)'
[Wed May 7 11:14:24 2014][Debug][Kernel::System::AuthSession::DB::CreateSessionID][326] DB.pm->Do (25) SQL: 'INSERT INTO sessions (session_id, data_key, data_value, serialized) VALUES (?,?,?,?)'
[Wed May 7 11:14:24 2014][Debug][Kernel::System::AuthSession::DB::CreateSessionID][326] DB.pm->Do (26) SQL: 'INSERT INTO sessions (session_id, data_key, data_value, serialized) VALUES (?,?,?,?)'
[Wed May 7 11:14:24 2014][Debug][Kernel::System::AuthSession::DB::CreateSessionID][326] DB.pm->Do (27) SQL: 'INSERT INTO sessions (session_id, data_key, data_value, serialized) VALUES (?,?,?,?)'
[Wed May 7 11:14:24 2014][Debug][Kernel::System::AuthSession::DB::CreateSessionID][326] DB.pm->Do (28) SQL: 'INSERT INTO sessions (session_id, data_key, data_value, serialized) VALUES (?,?,?,?)'
[Wed May 7 11:14:24 2014][Debug][Kernel::System::AuthSession::DB::CreateSessionID][326] DB.pm->Do (29) SQL: 'INSERT INTO sessions (session_id, data_key, data_value, serialized) VALUES (?,?,?,?)'
[Wed May 7 11:14:24 2014][Debug][Kernel::System::AuthSession::DB::CreateSessionID][326] DB.pm->Do (30) SQL: 'INSERT INTO sessions (session_id, data_key, data_value, serialized) VALUES (?,?,?,?)'
[Wed May 7 11:14:24 2014][Debug][Kernel::System::AuthSession::DB::CreateSessionID][326] DB.pm->Do (31) SQL: 'INSERT INTO sessions (session_id, data_key, data_value, serialized) VALUES (?,?,?,?)'
[Wed May 7 11:14:24 2014][Debug][Kernel::System::AuthSession::DB::CreateSessionID][326] DB.pm->Do (32) SQL: 'INSERT INTO sessions (session_id, data_key, data_value, serialized) VALUES (?,?,?,?)'
[Wed May 7 11:14:24 2014][Debug][Kernel::System::AuthSession::DB::CreateSessionID][326] DB.pm->Do (33) SQL: 'INSERT INTO sessions (session_id, data_key, data_value, serialized) VALUES (?,?,?,?)'
[Wed May 7 11:14:24 2014][Debug][Kernel::System::AuthSession::DB::CreateSessionID][326] DB.pm->Do (34) SQL: 'INSERT INTO sessions (session_id, data_key, data_value, serialized) VALUES (?,?,?,?)'
[Wed May 7 11:14:24 2014][Debug][Kernel::System::AuthSession::DB::CreateSessionID][326] DB.pm->Do (35) SQL: 'INSERT INTO sessions (session_id, data_key, data_value, serialized) VALUES (?,?,?,?)'
[Wed May 7 11:14:24 2014][Debug][Kernel::System::AuthSession::DB::CreateSessionID][326] DB.pm->Do (36) SQL: 'INSERT INTO sessions (session_id, data_key, data_value, serialized) VALUES (?,?,?,?)'
[Wed May 7 11:14:24 2014][Debug][Kernel::System::AuthSession::DB::CreateSessionID][326] DB.pm->Do (37) SQL: 'INSERT INTO sessions (session_id, data_key, data_value, serialized) VALUES (?,?,?,?)'
[Wed May 7 11:14:24 2014][Debug][Kernel::System::AuthSession::DB::CreateSessionID][326] DB.pm->Do (38) SQL: 'INSERT INTO sessions (session_id, data_key, data_value, serialized) VALUES (?,?,?,?)'
[Wed May 7 11:14:24 2014][Debug][Kernel::System::AuthSession::DB::CreateSessionID][326] DB.pm->Do (39) SQL: 'INSERT INTO sessions (session_id, data_key, data_value, serialized) VALUES (?,?,?,?)'
[Wed May 7 11:14:24 2014][Debug][Kernel::System::AuthSession::DB::CreateSessionID][326] DB.pm->Do (40) SQL: 'INSERT INTO sessions (session_id, data_key, data_value, serialized) VALUES (?,?,?,?)'
[Wed May 7 11:14:24 2014][Debug][Kernel::System::AuthSession::DB::CreateSessionID][326] DB.pm->Do (41) SQL: 'INSERT INTO sessions (session_id, data_key, data_value, serialized) VALUES (?,?,?,?)'
[Wed May 7 11:14:24 2014][Debug][Kernel::System::AuthSession::DB::CreateSessionID][326] DB.pm->Do (42) SQL: 'INSERT INTO sessions (session_id, data_key, data_value, serialized) VALUES (?,?,?,?)'
[Wed May 7 11:14:24 2014][Debug][Kernel::System::AuthSession::DB::CreateSessionID][326] DB.pm->Do (43) SQL: 'INSERT INTO sessions (session_id, data_key, data_value, serialized) VALUES (?,?,?,?)'
[Wed May 7 11:14:24 2014][Debug][Kernel::System::Web::InterfaceAgent::DESTROY][920] Global handle stopped.
[Wed May 7 11:14:25 2014][Debug][Kernel::System::Web::InterfaceAgent::new][84] Global handle started...
[Wed May 7 11:14:25 2014][Debug][Kernel::System::DB::Connect][268] DB.pm->Do (1) SQL: 'SET DATEFORMAT ymd'
[Wed May 7 11:14:26 2014][Debug][Kernel::System::Web::InterfaceAgent::DESTROY][920] Global handle stopped.