On Wed, Dec 3, 2008 at 1:22 AM, Aleksey Tsalolikhin <[EMAIL PROTECTED]> wrote: > Hi. I just downloaded rt-3.8.1 and am trying to install in on CentOS > 5.2 with PostgreSQL 8.1.11 > > make initialize-database exists with error: > > Working with: > Type: Pg > Host: localhost > Name: rt3 > User: rt_user > DBA: postgres > Now creating a Pg database rt3 for RT. > Done. > Now populating database schema. > Done. > Now inserting database ACLs > Couldn't finish 'acl' step. > > ERROR: Couldn't run SQL query: > GRANT USAGE, SELECT, UPDATE ON attachments_id_seq TO rt_user;
USAGE for sequences has been added in Pg 8.2. Replace "GRANT USAGE, SELECT, UPDATE" with "GRANT SELECT, UPDATE" in etc/acl.Pg. > > ERROR: ERROR: invalid privilege type USAGE for table > > make: *** [initialize-database] Error 255 > [EMAIL PROTECTED] rt-3.8.1]# > > > So I re-ran this command as: > > rt3=# GRANT SELECT, UPDATE ON attachments_id_seq TO rt_user; > GRANT > rt3=# > > MySQL.com docs say "USAGE" is synonym for "no privileges". > > Does anybody know the PostgreSQL equivalent for "no priveleges", please? > > Best, > Aleksey > > -- > Aleksey Tsalolikhin > UNIX System Administrator > "I get stuff done!" > http://www.lifesurvives.com/ > _______________________________________________ > 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
