ok. so i moved the DB, remade the test DB, moved the /mysql/rt3 directory
(what the old DB was) to the new mysql directory, reinstalled RT, edited the
httpd.conf file and restarted both mysql and httpd. now, it seems that
somewhere along the way, the Apache::DBI module got set up to use the 'old’
database. Is there a config file for DBI where i can change it from
/var/lib/mysql to /usr/local/var/mysql? or should i just make a symlink?
Or just edit the Handle.pm line 119 directly?
here’s the output of my httpd errorlog
DBI->connect(dbname=rt3;host=localhost) failed: Can’t connect to local MySQL
server through socket ‘/var/lib/mysql/mysql.sock’ (2) at
/usr/lib/perl5/site_perl/5.6.1/DBIx/SearchBuilder/Handle.pm line 119
[Tue May 6 12:17:34 2003] [error] Connect Failed Can’t connect to local
MySQL server through socket ‘/var/lib/mysql/mysql.sock’ (2)
at /usr/rt3/lib/RT.pm line 123
-rFrom: Ryan Wheaton [mailto:email@example.com]
Sent: Tuesday, May 06, 2003 10:44 AM
Subject: RE: [rt-users] Installation negligence
Yea, i thought of this… then i realized that my DB is stored on a 250M
partition. crap. Guess my only option is a reinstall? Unless someone has
a better idea?
Are there any other config files that I need to copy besides
RT_SiteConfig.pm that will help me preserve what i’ve set up already?
(users, queues, etc) Or… is there a way to move that DB out of /var and
so far, here’s the plan. Lemme know if anyone has any pointers cause i’ve
never done this before and it’s my first install of RT…
-edit /etc/my.cnf to point to a different datadir, add optimizations (from
the Speed thread)
-delete old install
-reinstall to /usr/rt3
-edit httpd.conf and change /opt to /usr
From: Chr. v. Stuckrad [mailto:firstname.lastname@example.org]
Sent: Tuesday, May 06, 2003 10:32 AM
To: Ryan Wheaton
Subject: Re: [rt-users] Installation negligence
experience, I know that filling up / is a PITA later on down the line, and
I’d rather keep track of it and not let things get out of hand. So,
my question: How much of a pain is it to move RT out of /opt and into
We always moved programs (whole trees) around, by replacing the
original /opt/whatever by a symlink to the future residence.
(Just be careful, how you upgrade later!)
Only if the program uses very convoluted scripts to find out
’where it lives’ this sometimes failed, normally it simply works.
Stucki (postmaster at math.fu-berlin.de)
Christoph von Stuckrad * * |nickname |email@example.com
Freie Universitaet Berlin |/_*|‘stucki’ |Tel(days):+49 30 838-75 459|
Fachbereich Mathematik, EDV|\ |if online|Tel(else):+49 30 77 39 6600|
Arnimallee 2-6/14195 Berlin * |on IRCnet|Fax(alle):+49 30 838-75454/
rt-users mailing list
Have you read the FAQ? The RT FAQ Manager lives at http://fsck.com/rtfm