You did something wrong. Either start over with patched acl.Pg file or in Pg client grant SELECT/CREATE/UPDATE/DELETE rights to rt_user on all tables in RT DB.
On Wed, Dec 3, 2008 at 1:52 AM, Aleksey Tsalolikhin <[EMAIL PROTECTED]> wrote: > On Tue, Dec 2, 2008 at 2:36 PM, Ruslan Zakirov <[EMAIL PROTECTED]> wrote: >> >> USAGE for sequences has been added in Pg 8.2. Replace "GRANT USAGE, >> SELECT, UPDATE" with "GRANT SELECT, UPDATE" in etc/acl.Pg. > > Thanks, Ruslan! that's what I did. But now I get HTTP 500 internal > server error when I try to access my RT for the first time. > > My httpd error log reads: > > DBD::Pg::st execute failed: ERROR: permission denied for relation > users at /usr/lib/perl5/site_perl/5.8.8/DBIx/SearchBuilder/Handle.pm > line 505. > RT::Handle=HASH(0x2aea5f3f0590) couldn't execute the query 'SELECT * > FROM Users WHERE LOWER(Name) = LOWER(?)' at > /usr/lib/perl5/site_perl/5.8.8/DBIx/SearchBuilder/Handle.pm line 518 > > Please advise? > > Thanks, > Aleksey > _______________________________________________ > http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users > > Community help: http://wiki.bestpractical.com > Commercial support: [EMAIL PROTECTED] > > > Discover RT's hidden secrets with RT Essentials from O'Reilly Media. > Buy a copy at http://rtbook.bestpractical.com > -- Best regards, Ruslan. _______________________________________________ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: [EMAIL PROTECTED] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
