Hi Ekram, This makes the 'otrs' user only able to select on the 'valid' table in your PostgreSQL but it must have ownership of the 'otrs' database.
Most probably, the command you're looking for is: ALTER DATABASE otrs OWNER TO otrs; Michiel Beijen Senior Consultant OTRS BV Schipholweg 103 2316 XC Leiden The Netherlands T: +31 71 8200 255 F: +31 71 8200 254 I: http://www.otrs.com Making OTRS even better! Exclusive Feature Add-Ons improve usability of OTRS and extend its functionality: http://j.mp/ndQvZj On Wed, Oct 19, 2011 at 11:09, Ekram <chutygo...@gmail.com> wrote: > 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 > --------------------------------------------------------------------- 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
