Not able to login to OTRS Agents

[thankrts]

Hi,

I don't know what exactly happened. I'm not able to login to Agents Dashboard using my credentials. The error showing is either the username or password is incorrect. I tried using the root@localhost (Passwd: root). That too failed. Please help me in resetting the password.

Thanks

[jojo]

check the logfiles

[thankrts]

This is the error log:


[Wed Oct 16 13:18:58 2013][Error][Kernel::System::Auth::DB::Auth][95] You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND login = 'root@localhost'' at line 1, SQL: 'SELECT pw, id FROM users WHERE valid_id IN ( ) AND login = 'root@localhost''
[Wed Oct 16 13:18:58 2013][Notice][Kernel::System::Auth::DB::Auth] User: root@localhost doesn't exist or is invalid!!! (REMOTE_ADDR: 127.0.0.1)
[Wed Oct 16 13:20:09 2013][Error][Kernel::System::MailAccount::POP3S::_Fetch][154] POP3S: Auth for user ITSupport@xxx.com/pop.gmail.com failed!
[Wed Oct 16 13:20:28 2013][Error][Kernel::System::Auth::DB::Auth][95] You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND login = 'thankaraj'' at line 1, SQL: 'SELECT pw, id FROM users WHERE valid_id IN ( ) AND login = 'thankaraj''
[Wed Oct 16 13:20:28 2013][Notice][Kernel::System::Auth::DB::Auth] User: thankaraj doesn't exist or is invalid!!! (REMOTE_ADDR: 192.168.68.64)
[Wed Oct 16 13:20:28 2013][Error][Kernel::System::User::UserLookup][746] No UserID found for 'thankaraj'!
[Wed Oct 16 13:23:02 2013][Notice][Kernel::System::AuthSession::DB::RemoveSessionID] Removed SessionID 10ecd2f619ddc6145b5f45c0869646ef6d.

Thanks

[jojo]

check the database, the tables might be crashed

[thankrts]

I have checked the table, I can see the User data as well as Customer_User data in the table.

[thankrts]

No problem. I have already installed a new OTRS installation under Ubuntu. Its working fine.

Thank you!