Problem setting up RT database

Hi all,

I’m trying to install RT on Linux, and I got all the dependencies to work,
used make install to install RT, and changed RT_SiteConfig.pm. But, I can’t
get the web server set up properly. When I try to set it up by running
/opt/rt4/sbin/rt-server, I’m told that “RT couldn’t connect to the database
where tickets are stored” and “Connect failed access denied for user
’rt_user’@’‘localhost’ using password YES”.

Then, the program hangs, and I have control-C out of it.

I changed my root user name and password in RT_SiteConfig.pm and checked my
permissions, but I can’t figure out what’s going on. If anyone could help
me out, I’d appreciate it.

Thanks!

I recently upgraded an RT installation from 3.4.5 to 4.0.7, in parallel to
the original installation, and am still testing RT 4.0.

In general things look good now, but I receive this warning in the Apache2
error.log when I select the Modify people option for a ticket.
For example, (http://10.20.30.40/rt4/Ticket/ModifyPeople.html?id=12345)
(real IP address obscured…)

[Fri Apr 12 21:34:10 2013] [warning]: Use of uninitialized value
$Text::Template::GEN5::comment in substitution (s///) at template line 1.
(template:1)

The ‘GENnn’ part of the message is variable, but ‘nn’ is always observed to
be a sequentially increasing multiple of 5. (0, 5, 10, etc.)

What could I do to track this down further?

Ken

I’m trying to install RT on Linux, and I got all the dependencies to work, used make install
to install RT, and changed RT_SiteConfig.pm. But, I can’t get the web server set up properly.
When I try to set it up by running /opt/rt4/sbin/rt-server, I’m told that “RT couldn’t connect
to the database where tickets are stored” and “Connect failed access denied for user
‘rt_user’@'‘localhost’ using password YES”.

Then, the program hangs, and I have control-C out of it.

I changed my root user name and password in RT_SiteConfig.pm and checked my permissions, but I
can’t figure out what’s going on. If anyone could help me out, I’d appreciate it.

You appear to have skipped over the rest of that message:

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.

Look at the end of it, you’ll see something like:

HTTP::Server::PSGI: Accepting connections at http://0:8084/

which you can click on.

Of course, the easier way to get your database set up is simply to
follow the manual portion of 6a in the readme and type
make initialize-database to set up your database.

-kevin

I recently upgraded an RT installation from 3.4.5 to 4.0.7, in parallel to
the original installation, and am still testing RT 4.0.

In general things look good now, but I receive this warning in the Apache2
error.log when I select the Modify people option for a ticket.
For example, (http://10.20.30.40/rt4/Ticket/ModifyPeople.html?id=12345)
(real IP address obscured…)

[Fri Apr 12 21:34:10 2013] [warning]: Use of uninitialized value
$Text::Template::GEN5::comment in substitution (s///) at template line 1.
(template:1)

Your Admin Comment template likely contains older code that a) warns
and b) has some bugs.

You can go find that template and compare it to the code here:

After editing your template, ensure that AdminCcs are still sent mail
on Comments. It’s easy to introduce errors there.

-kevin

Thanks Kevin,
I can’t click on that link when it pops up (although since I was using a
terminal I didn’t realize it was a link to begin with), and using make
initialize-database tells me it can’t connect, access denied for user root.
Is there anything else I’m missing?
Thanks!On Fri, Apr 12, 2013 at 6:47 PM, Kevin Falcone falcone@bestpractical.comwrote:

On Fri, Apr 12, 2013 at 02:42:30PM -0400, Jessica Reuter wrote:

I’m trying to install RT on Linux, and I got all the dependencies to
work, used make install
to install RT, and changed RT_SiteConfig.pm. But, I can’t get the web
server set up properly.
When I try to set it up by running /opt/rt4/sbin/rt-server, I’m told
that “RT couldn’t connect
to the database where tickets are stored” and “Connect failed access
denied for user
‘rt_user’@'‘localhost’ using password YES”.

Then, the program hangs, and I have control-C out of it.

I changed my root user name and password in RT_SiteConfig.pm and
checked my permissions, but I
can’t figure out what’s going on. If anyone could help me out, I’d
appreciate it.

You appear to have skipped over the rest of that message:

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.

Look at the end of it, you’ll see something like:

HTTP::Server::PSGI: Accepting connections at http://0:8084/

which you can click on.

Of course, the easier way to get your database set up is simply to
follow the manual portion of 6a in the readme and type
make initialize-database to set up your database.

-kevin

I can’t click on that link when it pops up (although since I was using a terminal I didn’t
realize it was a link to begin with),

It’s a URL - just copy and paste it into a browser if your terminal
doesn’t make them clicky.

and using make initialize-database tells me it can’t
connect, access denied for user root.

Did you type your password correctly?
Does the root user have access to the database server?
What’s in the logs for the database server?

There are so many things to check.

-kevin

Thanks for bearing with me; apparently it was a configuration issue on my
end and it’s fixed now.On Tue, Apr 16, 2013 at 2:39 PM, Kevin Falcone falcone@bestpractical.comwrote:

On Mon, Apr 15, 2013 at 09:48:42AM -0400, Jessica Reuter wrote:

I can’t click on that link when it pops up (although since I was
using a terminal I didn’t
realize it was a link to begin with),

It’s a URL - just copy and paste it into a browser if your terminal
doesn’t make them clicky.

and using make initialize-database tells me it can’t
connect, access denied for user root.

Did you type your password correctly?
Does the root user have access to the database server?
What’s in the logs for the database server?

There are so many things to check.

-kevin

I recently upgraded an RT installation from 3.4.5 to 4.0.7, in
parallel to the original installation, and am still testing RT 4.0.

In general things look good now, but I receive this warning in the
Apache2 error.log when I select the Modify people option for a ticket.
For example,
(http://10.20.30.40/rt4/Ticket/ModifyPeople.html?id=12345)
(real IP address obscured…)

[Fri Apr 12 21:34:10 2013] [warning]: Use of uninitialized value
$Text::Template::GEN5::comment in substitution (s///) at template line 1.
(template:1)

Your Admin Comment template likely contains older code that a) warns and b)
has some bugs.

You can go find that template and compare it to the code here:
rt/etc/initialdata at stable · bestpractical/rt · GitHub

After editing your template, ensure that AdminCcs are still sent mail on
Comments. It’s easy >to introduce errors there.

-kevin

Thanks for this helpful pointer. I checked/updated all of the templates,
and added the missing password change template.

Ken