Running RT2 with a remote database

RT Users
1

Hi,

I was trying to set up RT2, but I do not have mysql installed on the web server. And since the server i’m installing it to is not that great, i’d rather not install it. Also for security reasons. We have another server just for databases running mysql. It’s a beefy machine, and if it’s possible i would like to use that machine to store the database for RT2. Is this possible? If so, does anybody know how to do it?

Thanks,

Ryan Ferry

2

I’m running RT2 on a different server than my database.

You’ll need the mysql client on the same server as RT. That doesn’t
mean your RT/web server has to have the mysql server on it. You can put
the mysql server wherever you want, as long as you still have the mysql
client on the RT/web server.

I believe you can configure your mysql server for RT in the Makefile
before installation. By default, it is localhost.

You may want to spend some time becoming comfortable with mysql access
notions. RT’s installation takes care of everything if your Makefile
and mysql user access settings are correct. But if your mysql stuff is
not setup correctly, you could still run into problems. I guess the
most important thing there is that there is a mysql user (actually
a mysql user, not a system user called “mysql”) that can create
databases on your mysql server. RT’s installation needs such a
user to exist so that it can create its database.

Someone correct me if any of that is wrong.

Matt

“Ryan Ferry” writes:

3

So. It should “just work.” Have you looked through the makefile yet?On Wed, Dec 05, 2001 at 03:21:16AM -0800, Ryan Ferry wrote:

Hi,

I was trying to set up RT2, but I do not have mysql installed on the web server. And since the server i’m installing it to is not that great, i’d rather not install it. Also for security reasons. We have another server just for databases running mysql. It’s a beefy machine, and if it’s possible i would like to use that machine to store the database for RT2. Is this possible? If so, does anybody know how to do it?

Thanks,

Ryan Ferry

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