Hi all,

 

I have configured OTRS 2.0 to use an Sybase database, using ODBC driver...

 

But when I try to enter the system, I get the following : SessionIDinvalid! Need user data!

 

So I have modified a little bit DB.PM just to have more explanations in my log file, see below.

Apparently it seems that the PrepareStatement doesn't execute the SQL statement, it's very strange because the system is making some updates in the table sessions.

 

Has anyone could help me ?

 

[Fri Sep  8 15:03:33 2006][Notice][Kernel::System::Auth::DB::Auth] User: root authentication ok (REMOTE_ADDR: 192.168.52.203).
[Fri Sep  8 15:03:33 2006][Notice][Kernel::System::AuthSession::DB::GetSessionIDData] SQL Text: SELECT session_value  FROM  sessions  WHERE  session_id = '10433c2c352b3dce52b1f64cd8b21acb02'
[Fri Sep  8 15:03:33 2006][Notice][Kernel::System::AuthSession::DB::RemoveSessionID] Removed SessionID 10433c2c352b3dce52b1f64cd8b21acb02.
[Fri Sep  8 15:03:33 2006][Notice][Kernel::System::AuthSession::DB::GetSessionIDData] SQL Text: SELECT session_value  FROM  sessions  WHERE  session_id = '10072b87ed7802b087e2637f71516c071b'
[Fri Sep  8 15:03:33 2006][Notice][Kernel::System::AuthSession::DB::CheckSessionID] SessionID: '10072b87ed7802b087e2637f71516c071b' is invalid!!!