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

[Ruslan Zakirov]

This has been fixed in the repository. RT 3.8.2 will have two acl.Pg
files: acl.Pg and acl.Pg-8.2 for different Pg versions.

On Wed, Dec 3, 2008 at 3:27 AM, Aleksey Tsalolikhin
<atsaloli.tech at gmail.com> wrote:
> THANK YOU.   I am up now!
>
> Best,
> Aleksey
>
> On Tue, Dec 2, 2008 at 3:57 PM, Ruslan Zakirov <ruz at bestpractical.com> wrote:
>> 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.
>>
>
>
>
> --
> Aleksey Tsalolikhin
> UNIX System Administrator
> "I get stuff done!"
> http://www.lifesurvives.com/
>



-- 
Best regards, Ruslan.