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 <chutygo...@gmail.com> wrote: > 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
