[rt-users] problems installing rt4 on Ubuntu 11.11

[Kevin Falcone]

On Wed, Mar 07, 2012 at 04:34:03PM -0500, Alan McKay wrote:
> 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.

While I can't answer questions about the Ubuntu process (but the
packager may chime in with answers) your problem is that while you did
part of the RT database install process, RT doesn't expect an empty
database, it expects one with a number of existing pieces of data (hence
your error).

You'll want to review the rt-setup-database --help output.
You could use the --skip-create option to let RT handle the schema and
data pieces, but since you already have the schema in place, you'll
need to run with --action coredata and with --action insert --datafile
/patch/to/where/ubuntu/puts/our/initialdata file.

-kevin
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 195 bytes
Desc: not available
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20120307/4412e962/attachment.sig>