Database connect failure

RT Users
1

I upgraded a development box to RT 3.0.6 and now it simply will not connect
to the MySQL database.

The database resides on the localhost, and the user and password are default
for RT. I’ve verified the permissions, and I can connect from the command
line with all users in the DB, including the RT user.

I’ve narrowed it down to actually being outside the scope of RT, as the
issue is somehow tied to DBI (test Perl scripts have verified that I just
can’t connect using Perl, period). I’ve reinstalled DBI and DBD::mysql
hoping that would resolve the problem, but nothing has worked. Does anyone
ahve any idea what I’m missing?

Mike Frazer
Web Production Support Specialist
InterCept Payment Solutions
E-Mail: michael.frazer@intercept.net
Phone: 302-326-0700 x2172
Cell: 302-420-7567

2

The database resides on the localhost, and the user and password are default
for RT. I’ve verified the permissions, and I can connect from the command
line with all users in the DB, including the RT user.

Does anyone ahve any idea what I’m missing?

without seeing the actual error, it’s hard to say. One persistant
problem I’ve have with mysql, is whether or not it thinks I’m
connecting as “user” “user@localhost” or “user@hostname”.

seph

3

Using a test script I get the following error, even with root:

DBI connect(‘database=test;host=localhost’,‘root’,…) failed: Access denied
for user: ‘root@localhost’ (Using password: YES) at testcnx.pl line 26

Here is the code:

Include the necessary libraries

use DBI;
use DBD::mysql;

Set up DSN

my $dsn = “DBI:mysql:database=$database;host=$hostname”;

Establish connection to database

my $cnx = DBI->connect($dsn, $username, $password);

(All connection-related variables are being set properly).

Root has privileges to connect from localhost (duh), and I set the same
permissions for rt_user.

I tried upgrading DBD::mysql to the latest version and it fails all tests.
So I tried updating DBI as well, and all goes fine with that. No errors.

This all started when I attempted to upgrade from rt-3.0.2 to 3.0.6 so we
could install and test RTFM. The RT upgrade went just fine, but all
database connectivity is now broken for all of Perl.From: seph [mailto:seph@directionless.org]
Sent: Tuesday, November 18, 2003 9:36 PM
To: Mike Frazer
Cc: rt-users@lists.fsck.com
Subject: Re: Database connect failure

The database resides on the localhost, and the user and password are
default
for RT. I’ve verified the permissions, and I can connect from the command
line with all users in the DB, including the RT user.

Does anyone ahve any idea what I’m missing?

without seeing the actual error, it’s hard to say. One persistant
problem I’ve have with mysql, is whether or not it thinks I’m
connecting as “user” “user@localhost” or “user@hostname”.

seph

4

I’ve narrowed it down to actually being outside the scope of RT, as the
issue is somehow tied to DBI (test Perl scripts have verified that I just
can’t connect using Perl, period). I’ve reinstalled DBI and DBD::mysql
hoping that would resolve the problem, but nothing has worked. Does anyone
ahve any idea what I’m missing?

Are there any error messages in the logs?