[rt-users] database on separate system

[Paolo Supino]

Hi Tim

  I noticed that option after I wrote the email. I tried it and it 
indeed created the database but it fails further down the line when it 
tries to grant access. It's probably more an issue of mysql than RT. 
Please take a look at the log below and see if you can help solve the 
problem.

# make initialize-database
/usr/bin/perl //opt/rt3/sbin/rt-setup-database --action init --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 rtdb.quicklook.local as root.
Please specify that user's database password below. If the user has no 
database
password, just press return.

Password:
Now creating a database for RT.
Creating mysql database rt3.
Now populating database schema.
Creating database schema.
Done setting up database schema.
Now inserting database ACLs
DBD::mysql::st execute failed: Access denied for user 
'root'@'rt.idssite.com' to database 'rt3' at 
//opt/rt3/sbin/rt-setup-database line 345.
Problem with statement:
 GRANT SELECT,INSERT,CREATE,INDEX,UPDATE,DELETE ON rt3.* TO 
rt_user@'rtdb.quicklook.local' IDENTIFIED BY 'rt_pass';
Access denied for user 'root'@'rt.idssite.com' to database 'rt3' at 
//opt/rt3/sbin/rt-setup-database line 346.
make: *** [initialize-database] Error 255





TIA
Paolo



Tim Wilson wrote:

>>>>On Tue, Sep 26, 2006 at  6:26 PM, in message
>>>>        
>>>>
><4519B723.7090307 at actcom.net.il>,
>Paolo Supino <paolo at actcom.net.il> wrote: 
>
>  
>
>>  I have a mysql database server already running on my lan and I want
>>    
>>
>to 
>  
>
>>use it for my RT system too. From whay I saw thus far the
>>    
>>
>installation 
>  
>
>>process assumes the database is local and I didn't see any
>>    
>>
>documentation 
>  
>
>>on setting up the RT database on a remote installation of mysql.
>>    
>>
>
>I just installed RT 3.6.1 from source with the DB running on a separate
>server. As long as you specify the remote server properly when you do
>the ./configure it will work just fine. Do
>
>$ ./configure --help
>
>to get a list of all the available options. I installed on Ubuntu 6.06,
>but I followed the directions at
>http://wiki.bestpractical.com/index.cgi?DebianStableInstallGuide
>which worked quite well with only minor modifications.
>
>-Tim
>
>
>  
>