Update database: location of host

Hello Everyone,

I’m trying to upgrade our RT install from 3.2.2 to 3.2.3. I’ve
performed upgrades in the past without any problem, but this time
there’s a bit of a change, and it’s throwing me for a loop.

We used to keep RT and the database on the same host, but recently we
moved the database to another machine. At the moment, RT is running
happily.

However, when I try to run the database updates, I receive this error:

Password: DBI connect(‘dbname=rt3;host=localhost’,‘root’,…) failed:
Can’t connect to local MySQL server through socket
‘/var/lib/mysql/mysql.sock’ (2) at ./sbin/rt-setup-database line 163
Failed to connect to dbi:mysql:;host=localhost as root: Can’t connect to
local MySQL server through socket ‘/var/lib/mysql/mysql.sock’ (2)
at ./sbin/rt-setup-database line 163, line 1.

The upgrade script is looking for the database on the localhost, but
it’s no longer there! I haven’t been able to figure out how to specify
where the database actually resides.

This is a fairly basic issue: how do I tell the update script where the
mysql database is running?

Thanks,

Ranbir
Kanwar Ranbir Sandhu
Systems Aligned Inc.

This is a fairly basic issue: how do I tell the update script where the
mysql database is running?

Whoops. I was trying to run the database updates from the rt-3.2.3
install directory, instead of from the location where I actually have rt
setup.

After I figured that out, the update proceeded normally. All is well
now!

Sorry for the noise.

Regards,

Ranbir
Kanwar Ranbir Sandhu
Systems Aligned Inc.
www.systemsaligned.com