[rt-users] Problems creating remote rt3 database

Cameron Beattie cameron.beattie at appsteam.co.nz
Mon Sep 26 23:31:10 EDT 2005


I have two servers. Server A runs MySQL. Server B runs apache with rt3.4.4.

Server A
mysql
>grant all privileges on *.* to 'root'@'ServerB';

Server B
vi /opt/rt3/etc/RT_SiteConfig.pm
Set($DatabaseHost   , 'ServerA');
Set($DatabaseRTHost , 'ServerB');
Set($DatabaseUser , 'rt_remote');
Set($DatabasePassword , 'password');
Set($DatabaseName , 'rt3');

When I run make initialize-database I get the following message:
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'@'ServerA' to 
database 'rt3' at //opt/rt3/sbin/rt-setup-database line 341.
Problem with statement:
 GRANT SELECT,INSERT,CREATE,INDEX,UPDATE,DELETE ON rt3.* TO 
rt_remote@'ServerA' IDENTIFIED BY 'password';
Access denied for user 'root'@'ServerA' to database 'rt3' at 
//opt/rt3/sbin/rt-setup-database line 342.
make: *** [initialize-database] Error 255

Could anyone advise what I am doing wrong?

Many thanks

Cameron Beattie 




More information about the rt-users mailing list