[rt-users] what's the username to log in? root/password does not work

[Aleksey Tsalolikhin]

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 <ruz at bestpractical.com> wrote:
> do make install, files for init step are used from destination dir.
>
> On Wed, Dec 3, 2008 at 5:14 AM, Aleksey Tsalolikhin
> <atsaloli.tech at gmail.com> wrote:
>> On Tue, Dec 2, 2008 at 6:11 PM, Ruslan Zakirov <ruz at bestpractical.com> 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:
>>
>> [root at hwd-ddc-app-prod01 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;"
>> [root at hwd-ddc-app-prod01 rt-3.8.1]#
>>
>> [root at hwd-ddc-app-prod01 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
>> [root at hwd-ddc-app-prod01 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/