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 <[EMAIL PROTECTED]> wrote: > THANK YOU. I am up now! > > Best, > Aleksey > > On Tue, Dec 2, 2008 at 3:57 PM, Ruslan Zakirov <[EMAIL PROTECTED]> 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 >> <[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. >> > > > > -- > Aleksey Tsalolikhin > UNIX System Administrator > "I get stuff done!" > http://www.lifesurvives.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
