Hi folks,
I have an Ubuntu 11.11 system that I want to install RT onto, but the MySQL
database is on another system. And this seems to be an issue even though
the installer seems to think it can do this.
I found this recent thread but the OP did not report back as to how he got
it to work
http://lists.bestpractical.com/pipermail/rt-users/2012-January/074770.html
So what did I do?
I installed the packages via apt-get
apt-get install request-tracker4 rt4-apache2 rt4-clients rt4-db-mysql
and then as part of that, it prompted me for a number of things. When it
came to the part where it said it wants to configure the database, I told
it I would do it manually because silly me I did not think it would deal
with having the DB on a separate system. So when the install was done I
went over to my other system and created a DB and user for RT, and gave the
user the proper permissions for the DB. I verified the permissions were
good by doing the DB creation from the RT system. I did this :
mysql --user-rt4 --password=rtticket --host=10.246.159.43
--database=requesttracker4 /usr/share/request-tracker4/etc/schema.mysql
Where the IP shown is not my RT system, it is the system with the MySQL DB.
This command worked well and so I then went about finding all the files
where I had to make changes for this to work. I thought I had found them,
but when I tried to start Apache I got this :
---snip---
apachectl restart
[Tue Mar 6 21:07:39 2012] [warning]: Use of uninitialized value in
concatenation (.) or string at /usr/share/request-tracker4/lib/RT/Handle.pm
line 242. (/usr/share/request-tracker4/lib/RT/Handle.pm:241)
RT couldn't connect to the database where tickets are stored.
If this is a new installation of RT, you should visit the URL below
to configure RT and initialize your database.
If this is an existing RT installation, this may indicate a database
connectivity problem.
The error RT got back when trying to connect to your database was:
Couldn't find RT_System user in the DB ''
---snip---
And when I went to the URL for it on my RT system, I got this :
---snip---
Permission denied at /usr/share/request-tracker4/html/Install/index.html
line 98.
---snip---
Then after mucking about a bit more I discovered the
Ubuntu dpkg-reconfigure command, which let me re-do the installation and
this time around I told it to go ahead and configure the database for me.
I answered the questions as best I could and it went ahead to try to do
something useful for me, but I ended back up where I began above. See
below, where I have replaced the actual FQDN with the text FQDN. I
then went over to my database and created a user root@FQDN and gave it
full permissions to the database for RT.
I suspect what my problem is, is that this root@FQDN user needs to have
full permission over my entire MySQL database in order to do a database
creation. But that makes me nervous as heck on my live database! Maybe
someone can confirm this?
Thanks for any help you can give me. I'd be happy with being able to
complete the 'dpkg-reconfigure' or with doing it manually. I thought I
had gotten all the manual stuff in place properly the first time around but
that error on line 98 is what completely stumped me. It was still lacking
this RT_System user best I could tell, and I could find nowhere to tell
me how to set that up manually.
---snip---
root@bioinfoadmin:/etc/request-tracker4# dpkg-reconfigure
request-tracker4**WARNING**
**WARNING** If you are using mod_perl or any form of persistent perl
**WARNING** process such as FastCGI, you will need to restart your
**WARNING** web server and any persistent processes now.
**WARNING**
dbconfig-common: writing config to
/etc/dbconfig-common/request-tracker4.conf
ERROR 1045 (28000): Access denied for user 'root'@'FQDN' (using password:
YES).
unable to connect to mysql server.
error encountered creating user:
ERROR 1045 (28000): Access denied for user 'root'@'FQDN' (using password:
YES)
dbconfig-common: request-tracker4 configure: trying again.
dbconfig-common: writing config to
/etc/dbconfig-common/request-tracker4.conf
dbconfig-common: flushing administrative password
root@bioinfoadmin:/etc/request-tracker4# !apa
apachectl restart
[Tue Mar 6 21:07:39 2012] [warning]: Use of uninitialized value in
concatenation (.) or string at /usr/share/request-tracker4/lib/RT/Handle.pm
line 242. (/usr/share/request-tracker4/lib/RT/Handle.pm:241)
RT couldn't connect to the database where tickets are stored.
If this is a new installation of RT, you should visit the URL below
to configure RT and initialize your database.
If this is an existing RT installation, this may indicate a database
connectivity problem.
The error RT got back when trying to connect to your database was:
Couldn't find RT_System user in the DB ''
apache2: Could not reliably determine the server's fully qualified domain
name, using 127.0.1.1 for ServerName
---snip---
Oh and one final note, I found this apache config
