Hi,

I am unable to login using root@localhost/root
getting the following error. Please help.

Oct 19 10:42:47 newotrs OTRS-CGI-10[31370]: [Error][Kernel::System::Valid::ValidIDsGet][Line:215]: ERROR:  permission denied for relation valid, SQL: 'SELECT id FROM valid WHERE name = ?'
Oct 19 10:42:47 newotrs OTRS-CGI-10[31370]: [Error][Kernel::System::Auth::DB::Auth][Line:95]: ERROR:  syntax error at or near ")"#012LINE 1: SELECT pw, id  FROM  users  WHERE  valid_id IN (  ) AND  log...#012                                                          ^, SQL: 'SELECT pw, id  FROM  users  WHERE  valid_id IN (  ) AND  login = 'root@localhost''
Oct 19 10:42:47 newotrs OTRS-CGI-10[31370]: [Notice][Kernel::System::Auth::DB::Auth] User: root@localhost doesn't exist or is invalid!!! (REMOTE_ADDR: 10.251.10.12)
Oct 19 10:42:48 newotrs OTRS-CGI-10[31370]: [Error][Kernel::System::User::UserLookup][Line:736]: ERROR:  permission denied for relation users, SQL: 'SELECT id FROM users  WHERE LOWER(login) = ?'


Also getting the following error whey run database check.

DBD::Pg::st execute failed: ERROR:  permission denied for relation valid at /opt/otrs/Kernel/System/DB.pm line 553.
ERROR: OTRS-otrs.CheckDB.pl-10 Perl: 5.10.1 OS: linux Time: Wed Oct 19 10:47:37 2011

 Message: ERROR:  permission denied for relation valid, SQL: 'SELECT * FROM valid'

 Traceback (32444):
   Module: /opt/otrs/bin/otrs.CheckDB.pl (v1.4) Line: 71

DBD::Pg::st fetchrow_array failed: no statement executing at /opt/otrs/Kernel/System/DB.pm line 616.


/Ekram