Woo-hoo! That did it! So to summarize, for anybody reading this in the list archives, the solution was to remove USAGE from etc/acl.Pg and then to re-run "make init" and "make initdb".
Thanks!! Aleksey On Tue, Dec 2, 2008 at 6:18 PM, Ruslan Zakirov <[EMAIL PROTECTED]> wrote: > do make install, files for init step are used from destination dir. > > On Wed, Dec 3, 2008 at 5:14 AM, Aleksey Tsalolikhin > <[EMAIL PROTECTED]> wrote: >> On Tue, Dec 2, 2008 at 6:11 PM, Ruslan Zakirov <[EMAIL PROTECTED]> wrote: >>> As you stopped at ACL step during initialization of the DB then your >>> DB just has no data. >> >> >> Ok. That makes sense. I tried updating etc/acl.Pg as you suggested >> but my make still fails: >> >> [EMAIL PROTECTED] rt-3.8.1]# grep GRANT etc/acl.Pg >> push @acls, "GRANT SELECT, UPDATE ON $table TO $db_user;" >> push @acls, "GRANT SELECT, INSERT, UPDATE, DELETE ON >> $table TO $db_user;" >> [EMAIL PROTECTED] rt-3.8.1]# >> >> [EMAIL PROTECTED] rt-3.8.1]# make initdb >> /usr/bin/perl sbin/rt-setup-database --action init --dba postgres >> --prompt-for-dba-password >> In order to create or update your RT database, this script needs to >> connect to your Pg instance on localhost as postgres >> Please specify that user's database password below. If the user has no >> database >> password, just press return. >> >> Password: >> 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; >> >> ERROR: ERROR: invalid privilege type USAGE for table >> >> make: *** [initialize-database] Error 255 >> [EMAIL PROTECTED] rt-3.8.1]# >> >> >> >> What gives? Where is it getting USAGE? >> >> Thanks, >> Aleksey >> > > > > -- > Best regards, Ruslan. > -- 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
