AW: [rt-users] Problems creating remote rt3 database

[HAM-MI-IC Torsten Brumm]

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 at kuehne-nagel.com
    : www.kn-portal.com
    : icq: 78258840
    ....
-----Ursprüngliche Nachricht-----
Von: rt-users-bounces at lists.bestpractical.com
[mailto:rt-users-bounces at lists.bestpractical.com] Im Auftrag von Cameron
Beattie
Gesendet: Dienstag, 27. September 2005 05:31
An: rt-users at 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