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
thanks again.
-rFrom: Ryan Wheaton [mailto:rwheaton@moguls.com]
Sent: Tuesday, May 06, 2003 10:44 AM
To: rt-users@lists.fsck.com
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
into /usr?
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…
-backup RT_SiteConfig.pm
-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
thanks again
-rtw
From: Chr. v. Stuckrad [mailto:stucki@math.fu-berlin.de]
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,
here’s
my question: How much of a pain is it to move RT out of /opt and into
/usr?
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 |stucki@math.fu-berlin.de
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
rt-users@lists.fsck.com
http://lists.fsck.com/mailman/listinfo/rt-users
Have you read the FAQ? The RT FAQ Manager lives at http://fsck.com/rtfm