[rt-users] Installation negligence

[Ryan Wheaton]

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.
-r

-----Original Message-----
From: Ryan Wheaton [mailto:rwheaton at moguls.com]
Sent: Tuesday, May 06, 2003 10:44 AM
To: rt-users at 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


-----Original Message-----
From: Chr. v. Stuckrad [mailto:stucki at math.fu-berlin.de]
Sent: Tuesday, May 06, 2003 10:32 AM
To: Ryan Wheaton
Subject: Re: [rt-users] Installation negligence


On Tue, May 06, 2003 at 10:20:14AM -0600, Ryan Wheaton wrote:
> 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 at 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 at 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