RT 2.0.7 config problem

RT Users
1

I’m running into some problems with getting the MySQL access sorted out with
my new RT 2.0.7 install.

I have a box (call it www) that runs Apache and MySQL. I have another box
that is the central mail hub (call it mail) running Sendmail. All the email
RT requests are sent to rt2@mail, then rt-mailgate would connect to www.

I have this method working currently with my RT 1.0.7 install.

What should I set DB_HOST and DB_RT_HOST to in the Makefile to make this
work? I’ve tried setting DB_HOST to www and DB_RT_HOST to mail, but that
doesn’t seem to work.

Thanks,

-Grant Miller grant@pico.apple.com x42917

Unix Systems Admin, Engineering Compute Services
unix-support@pico.apple.com, http://www-ecs.apple.com
ECS Hotline: x44747

2

For “interesting” configs like this, you’ll probably have to go grant database
rights by hand.

-jOn Wed, Oct 03, 2001 at 04:09:55PM -0700, Grant Miller wrote:

I’m running into some problems with getting the MySQL access sorted out with
my new RT 2.0.7 install.

I have a box (call it www) that runs Apache and MySQL. I have another box
that is the central mail hub (call it mail) running Sendmail. All the email
RT requests are sent to rt2@mail, then rt-mailgate would connect to www.

I have this method working currently with my RT 1.0.7 install.

What should I set DB_HOST and DB_RT_HOST to in the Makefile to make this
work? I’ve tried setting DB_HOST to www and DB_RT_HOST to mail, but that
doesn’t seem to work.

Thanks,

–

-Grant Miller grant@pico.apple.com x42917

Unix Systems Admin, Engineering Compute Services
unix-support@pico.apple.com, http://www-ecs.apple.com
ECS Hotline: x44747

rt-users mailing list
rt-users@lists.fsck.com
http://lists.fsck.com/mailman/listinfo/rt-users

http://www.bestpractical.com/products/rt – Trouble Ticketing. Free.

3

|+ What should I set DB_HOST and DB_RT_HOST to in the Makefile to make this
|+ work? I’ve tried setting DB_HOST to www and DB_RT_HOST to mail, but that
|+ doesn’t seem to work.

What we did on initial install was, set DB_RT_HOST to the machine running
Apache (www). Installed RT, then manually went to the database, and did
some GRANT statements.

The setup we have is a little different. We have one primary database
server, Apache running on 3 different hosts (located in various spots in
the country), and our mailserver which has rt-mailgate installed.

The 3 “other” machines must be able to connect to the database, with the
same rights as the initial RT www machine.