[rt-users] installing RT with PostgreSQL yields "invalid privilege type USAGE for table" error

Ruslan Zakirov ruz at bestpractical.com
Tue Dec 2 18:57:07 EST 2008


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
<atsaloli.tech at gmail.com> wrote:
> On Tue, Dec 2, 2008 at 2:36 PM, Ruslan Zakirov <ruz at bestpractical.com> 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: sales at bestpractical.com
>
>
> Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
> Buy a copy at http://rtbook.bestpractical.com
>



-- 
Best regards, Ruslan.



More information about the rt-users mailing list