[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