[rt-users] Update database: location of host

[Kanwar Ranbir Sandhu]

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, <STDIN> 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.
www.systemsaligned.com