Problems creating remote rt3 database

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

Hi,

i had the same problem within the same environment. its easy to fix.

My Solution (maybe not the best) is, start at the webserver also a mysql
server just for install it clean… and make a dump from the db then import
to the real mysql server. change the RT_Config/SiteConfig and point to the
real mysql server(check the DB Rights)

For me it works…

Thanks in advance

: Torsten Brumm
: IT Security Engineer
:
: Kuehne + Nagel
: HAM - MI-C
:
: Ferdinand Strasse 29-33
: 20095 Hamburg
:
: +49 (40) 329 15 199
: +49 (40) 329 15 500
:
: torsten.brumm@kuehne-nagel.com
: www.kn-portal.com
: icq: 78258840
…Von: rt-users-bounces@lists.bestpractical.com
[mailto:rt-users-bounces@lists.bestpractical.com] Im Auftrag von Cameron
Beattie
Gesendet: Dienstag, 27. September 2005 05:31
An: rt-users@lists.bestpractical.com
Betreff: [rt-users] Problems creating remote rt3 database

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

http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Be sure to check out the RT Wiki at http://wiki.bestpractical.com

Buy your copy of our new book, RT Essentials, today!

Download a free sample chapter from http://rtbook.bestpractical.com