Database on separate system

RT Users
1

Hi

I have a mysql database server already running on my lan and I want to
use it for my RT system too. From whay I saw thus far the installation
process assumes the database is local and I didn’t see any documentation
on setting up the RT database on a remote installation of mysql.
Can anyone on the mailing list help me and save me the headache and
time that it will take me to reverse egineer the installation so I can
adapt it to running rt with a remote database?

TIA
Paolo

2

After make install step you must change RT_SiteConfig.pm and only then
run make initdb.
You’re looking for next options:
$DatabaseHost - mysql server
$DatabasePort - mysql’s port
$DatabaseUser - user RT uses to connect to mysql in normal conditions
$DatabasePassword - password of the above user
$DatabaseName - name of the RT’s DB
And important for you option is $DatabaseRTHost - RT’s host, when RT
connects to mysql on remote host, mysql checks that client connects
from this host.On 9/27/06, Paolo Supino paolo@actcom.net.il wrote:

Hi

I have a mysql database server already running on my lan and I want to
use it for my RT system too. From whay I saw thus far the installation
process assumes the database is local and I didn’t see any documentation
on setting up the RT database on a remote installation of mysql.
Can anyone on the mailing list help me and save me the headache and
time that it will take me to reverse egineer the installation so I can
adapt it to running rt with a remote database?

TIA
Paolo

The rt-users Archives

Community help: http://wiki.bestpractical.com
Commercial support: sales@bestpractical.com

Discover RT’s hidden secrets with RT Essentials from O’Reilly Media.
Buy a copy at http://rtbook.bestpractical.com

Best regards, Ruslan.

3

I have a mysql database server already running on my lan and I want
to
use it for my RT system too. From whay I saw thus far the
installation
process assumes the database is local and I didn’t see any
documentation
on setting up the RT database on a remote installation of mysql.

I just installed RT 3.6.1 from source with the DB running on a separate
server. As long as you specify the remote server properly when you do
the ./configure it will work just fine. Do

$ ./configure --help

to get a list of all the available options. I installed on Ubuntu 6.06,
but I followed the directions at
http://wiki.bestpractical.com/index.cgi?DebianStableInstallGuide
which worked quite well with only minor modifications.

-Tim

Tim Wilson, Director of Technology
Buffalo-Hanover-Montrose Schools
214 1st Ave NE Buffalo, MN 55313
ph: 763.682.8740 fax: 763.682.8743 http://www.buffalo.k12.mn.us

4

Hi Tim

I noticed that option after I wrote the email. I tried it and it
indeed created the database but it fails further down the line when it
tries to grant access. It’s probably more an issue of mysql than RT.
Please take a look at the log below and see if you can help solve the
problem.

make initialize-database

/usr/bin/perl //opt/rt3/sbin/rt-setup-database --action init --dba root
–prompt-for-dba-password
In order to create or update your RT database,this script needs to
connect to your mysql instance on rtdb.quicklook.local as root.
Please specify that user’s database password below. If the user has no
database
password, just press return.

Password:
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’@‘rt.idssite.com’ to database ‘rt3’ at
//opt/rt3/sbin/rt-setup-database line 345.
Problem with statement:
GRANT SELECT,INSERT,CREATE,INDEX,UPDATE,DELETE ON rt3.* TO
rt_user@‘rtdb.quicklook.local’ IDENTIFIED BY ‘rt_pass’;
Access denied for user ‘root’@‘rt.idssite.com’ to database ‘rt3’ at
//opt/rt3/sbin/rt-setup-database line 346.
make: *** [initialize-database] Error 255

TIA
Paolo

Tim Wilson wrote:>>>>On Tue, Sep 26, 2006 at 6:26 PM, in message 4519B723.7090307@actcom.net.il, Paolo Supino paolo@actcom.net.il wrote:

I have a mysql database server already running on my lan and I want

to

use it for my RT system too. From whay I saw thus far the

installation

process assumes the database is local and I didn’t see any

documentation

on setting up the RT database on a remote installation of mysql.

I just installed RT 3.6.1 from source with the DB running on a separate
server. As long as you specify the remote server properly when you do
the ./configure it will work just fine. Do

$ ./configure --help

to get a list of all the available options. I installed on Ubuntu 6.06,
but I followed the directions at
Request Tracker Wiki
which worked quite well with only minor modifications.

-Tim

5

You must connect as dba, see --with-db-dba option of the configure
script. I see you’re using root and this user has rights to create
databases. In the error below mysql says that “user ‘root’ who is
connecting from ‘rt.idssite.com’ has no access to database ‘rt3’”
which means that rt3 DB is there but root has no rights to access it
even he’s created it few seconds ago.On 9/28/06, Paolo Supino paolo@actcom.net.il wrote:

Hi Tim

I noticed that option after I wrote the email. I tried it and it
indeed created the database but it fails further down the line when it
tries to grant access. It’s probably more an issue of mysql than RT.
Please take a look at the log below and see if you can help solve the
problem.

make initialize-database

/usr/bin/perl //opt/rt3/sbin/rt-setup-database --action init --dba root
–prompt-for-dba-password
In order to create or update your RT database,this script needs to
connect to your mysql instance on rtdb.quicklook.local as root.
Please specify that user’s database password below. If the user has no
database
password, just press return.

Password:
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’@‘rt.idssite.com’ to database ‘rt3’ at
//opt/rt3/sbin/rt-setup-database line 345.
Problem with statement:
GRANT SELECT,INSERT,CREATE,INDEX,UPDATE,DELETE ON rt3.* TO
rt_user@‘rtdb.quicklook.local’ IDENTIFIED BY ‘rt_pass’;
Access denied for user ‘root’@‘rt.idssite.com’ to database ‘rt3’ at
//opt/rt3/sbin/rt-setup-database line 346.
make: *** [initialize-database] Error 255

TIA
Paolo

Tim Wilson wrote:

On Tue, Sep 26, 2006 at 6:26 PM, in message 4519B723.7090307@actcom.net.il, Paolo Supino paolo@actcom.net.il wrote:

I have a mysql database server already running on my lan and I want

to

use it for my RT system too. From whay I saw thus far the

installation

process assumes the database is local and I didn’t see any

documentation

on setting up the RT database on a remote installation of mysql.

I just installed RT 3.6.1 from source with the DB running on a separate
server. As long as you specify the remote server properly when you do
the ./configure it will work just fine. Do

$ ./configure --help

to get a list of all the available options. I installed on Ubuntu 6.06,
but I followed the directions at
Request Tracker Wiki
which worked quite well with only minor modifications.

-Tim

The rt-users Archives

Community help: http://wiki.bestpractical.com
Commercial support: sales@bestpractical.com

Discover RT’s hidden secrets with RT Essentials from O’Reilly Media.
Buy a copy at http://rtbook.bestpractical.com

Best regards, Ruslan.

6

Hi Ruslan

And how to fix that?

TIA
Paolo

Ruslan Zakirov wrote:

7

Using this.

http://dev.mysql.com/doc/refman/4.1/en/grant.htmlOn 9/29/06, Paolo Supino paolo@actcom.net.il wrote:

Hi Ruslan

And how to fix that?

TIA
Paolo

Ruslan Zakirov wrote:

You must connect as dba, see --with-db-dba option of the configure
script. I see you’re using root and this user has rights to create
databases. In the error below mysql says that “user ‘root’ who is
connecting from ‘rt.idssite.com’ has no access to database ‘rt3’”
which means that rt3 DB is there but root has no rights to access it
even he’s created it few seconds ago.

On 9/28/06, Paolo Supino paolo@actcom.net.il wrote:

Hi Tim

I noticed that option after I wrote the email. I tried it and it
indeed created the database but it fails further down the line when it
tries to grant access. It’s probably more an issue of mysql than RT.
Please take a look at the log below and see if you can help solve the
problem.

make initialize-database

/usr/bin/perl //opt/rt3/sbin/rt-setup-database --action init --dba root
–prompt-for-dba-password
In order to create or update your RT database,this script needs to
connect to your mysql instance on rtdb.quicklook.local as root.
Please specify that user’s database password below. If the user has no
database
password, just press return.

Password:
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’@‘rt.idssite.com’ to database ‘rt3’ at
//opt/rt3/sbin/rt-setup-database line 345.
Problem with statement:
GRANT SELECT,INSERT,CREATE,INDEX,UPDATE,DELETE ON rt3.* TO
rt_user@‘rtdb.quicklook.local’ IDENTIFIED BY ‘rt_pass’;
Access denied for user ‘root’@‘rt.idssite.com’ to database ‘rt3’ at
//opt/rt3/sbin/rt-setup-database line 346.
make: *** [initialize-database] Error 255

TIA
Paolo

Tim Wilson wrote:

On Tue, Sep 26, 2006 at 6:26 PM, in message 4519B723.7090307@actcom.net.il, Paolo Supino paolo@actcom.net.il wrote:

I have a mysql database server already running on my lan and I want

to

use it for my RT system too. From whay I saw thus far the

installation

process assumes the database is local and I didn’t see any

documentation

on setting up the RT database on a remote installation of mysql.

I just installed RT 3.6.1 from source with the DB running on a separate
server. As long as you specify the remote server properly when you do
the ./configure it will work just fine. Do

$ ./configure --help

to get a list of all the available options. I installed on Ubuntu 6.06,
but I followed the directions at
Request Tracker Wiki
which worked quite well with only minor modifications.

-Tim

The rt-users Archives

Community help: http://wiki.bestpractical.com
Commercial support: sales@bestpractical.com

Discover RT’s hidden secrets with RT Essentials from O’Reilly Media.
Buy a copy at http://rtbook.bestpractical.com

The rt-users Archives

Community help: http://wiki.bestpractical.com
Commercial support: sales@bestpractical.com

Discover RT’s hidden secrets with RT Essentials from O’Reilly Media.
Buy a copy at http://rtbook.bestpractical.com