[rt-users] RTFM make initdb needs superuser rights to assign ACLs

[Jo Rhett]

Make initdb fails.  It seems to want to assign rights, which would  
require an admin login not the user login.

$ /usr/bin/perl -Ilib -I/d/u/rtweb/rt38/local/lib -I/u/rtweb/rt38/lib / 
d/u/rtweb/rt38/sbin/rt-setup-database --action acl --datadir etc --dba  
rtweb_tickets --prompt-for-dba-password
In order to create or update your RT database, this script needs to  
connect to your  mysql instance on localhost as rtweb_tickets
Please specify that user's database password below. If the user has no  
database
password, just press return.

Password:
(snip)
Now inserting database ACLs
Granting access to rtweb_tickets@'localhost' on rtweb_tickets.
DBD::mysql::st execute failed: Access denied for user  
'rtweb_tickets'@'localhost' to database 'mysql' at /d/u/rtweb/rt38/ 
sbin/../lib/RT/Handle.pm line 430, <STDIN> line 1.
DBD::mysql::st execute failed: Access denied for user  
'rtweb_tickets'@'localhost' to database 'mysql' at /d/u/rtweb/rt38/ 
sbin/../lib/RT/Handle.pm line 430, <STDIN> line 1.

Changing the command line to use the admin login solved this:
$ /usr/bin/perl -Ilib -I/d/u/rtweb/rt38/local/lib -I/u/rtweb/rt38/lib / 
d/u/rtweb/rt38/sbin/rt-setup-database --action acl --datadir etc --dba  
root --prompt-for-dba-password
In order to create or update your RT database, this script needs to  
connect to your  mysql instance on localhost as root
Please specify that user's database password below. If the user has no  
database
password, just press return.

Password:
Working with:
Type:   mysql
Host:   localhost
Name:   rtweb_tickets
User:   rtweb_tickets
DBA:    root
Now inserting database ACLs
Granting access to rtweb_tickets@'localhost' on rtweb_tickets.
Done.

-- 
Jo Rhett
Net Consonance : consonant endings by net philanthropy, open source  
and other randomness

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20090728/2104f7d5/attachment.htm>