manage to get using
GRANT SELECT ON valid TO otrs;
Trying to connect to database
DSN: DBI:Pg:dbname=otrs;
DatabaseUser: otrs
It looks Ok!
but its unable to login giving the
Oct 19 11:06:41 newotrs OTRS-CGI-10[30806]:
[Notice][Kernel::System::Auth::DB::Auth] User: root@localhost doesn't exist
or is invalid!!! (REMOTE_ADDR: 10.251.10.12)
Oct 19 11:06:41 newotrs OTRS-CGI-10[30806]:
[Error][Kernel::System::User::UserLookup][Line:736]: ERROR: permission
denied for relation users, SQL: 'SELECT id FROM users WHERE LOWER(login) =
?
):
On Wed, Oct 19, 2011 at 2:48 PM, Ekram
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