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