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 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 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