[rt-users] Running RT2 with a remote database

Wed Dec 5 11:12:42 EST 2001

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:
>This is a multi-part message in MIME format.
>
>------=_NextPart_000_0007_01C17D3B.E63D3D00
>Content-Type: text/plain;
>	charset="iso-8859-1"
>Content-Transfer-Encoding: quoted-printable
>
>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
>
>------=_NextPart_000_0007_01C17D3B.E63D3D00
>Content-Type: text/html;
>	charset="iso-8859-1"
>Content-Transfer-Encoding: quoted-printable
>
><!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
><HTML><HEAD>
><META content=3D"text/html; charset=3Diso-8859-1" =
>http-equiv=3DContent-Type>
><META content=3D"MSHTML 5.00.2614.3500" name=3DGENERATOR>
><STYLE></STYLE>
></HEAD>
><BODY bgColor=3D#ffffff>
><DIV><FONT face=3DArial size=3D2>Hi,</FONT></DIV>
><DIV> </DIV>
><DIV><FONT face=3DArial size=3D2>I was trying to set up RT2, but I do =
>not have mysql=20
>installed on the web server.  And since the server i'm installing =
>it to is=20
>not that great, i'd rather not install it.  Also for security=20
>reasons.  We have another server just for databases running =
>mysql. =20
>It's a beefy machine, and if it's possible i would like to use that =
>machine to=20
>store the database for RT2.  Is this possible?  If so, does =
>anybody=20
>know how to do it?</FONT></DIV>
><DIV> </DIV>
><DIV><FONT face=3DArial size=3D2>Thanks,</FONT></DIV>
><DIV> </DIV>
><DIV><FONT face=3DArial size=3D2>Ryan Ferry</FONT></DIV></BODY></HTML>
>
>------=_NextPart_000_0007_01C17D3B.E63D3D00--
>
>
>_______________________________________________
>rt-users mailing list
>rt-users at lists.fsck.com
>http://lists.fsck.com/mailman/listinfo/rt-users
>