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
--------------------------------------------------------------------- OTRS mailing list: otrs - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/otrs To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs
