I have to move RT from machine A to B… I did a fresh install and then
overwrote the new mysql database with the original… And I’ve now lost
access to the message bodies…
I’ve also copied the old transactions… Help… users are screaming at
me…
T�o de Hesselle, | Diplomacy is about surviving until
Unix Systems Administrator | the next century. Politics is
| about surviving until Friday
University of Technology, Sydney | afternoon. – Yes, Minister
I have to move RT from machine A to B… I did a fresh install and then
overwrote the new mysql database with the original… And I’ve now lost
access to the message bodies…
I’ve also copied the old transactions… Help… users are screaming at
me…
When I moved from one machine to another, I did a mysqldump out, built
the new RT 1.07 install, then piped in the dump file after excising the
bits that create tables and whatnot. It worked like a dream.
That probably doesn’t help you very much, but it was how I went about
the process.
| I’ve also copied the old transactions… Help… users are screaming at
| me…
±–>8
Are they in the same place relative to the RT base directory?
Does etc/config.pm have the same location listed?
Does the web server have read (and write) permissions on the transactions
directory and its contents?
brandon s. allbery [os/2][linux][solaris][japh] allbery@kf8nh.apk.net
system administrator [WAY too many hats] allbery@ece.cmu.edu
electrical and computer engineering KF8NH
carnegie mellon university [“better check the oblivious first” -ke6sls]
±----
| I’ve also copied the old transactions… Help… users are screaming at
| me…
±–>8
Are they in the same place relative to the RT base directory?
Does etc/config.pm have the same location listed?
Yes. I’ve also made a symlink, so the old full path would still work.
Does the web server have read (and write) permissions on the transactions
directory and its contents?
Yes. And then to be double sure, I did:
cd /usr/local/rt1/transactions
chmod -R 777 .
chown -R rt:rt .
Oddly, some of them appear to be working now… in some cases one out of 5
transactions are appearing, whilst the others (in the same ticket!) are
not.
There doesn’t seem to be a correlation between tickets before the move and
tickets after the move, which makes it all the more frustrating.
T�o de Hesselle, | Diplomacy is about surviving until
Unix Systems Administrator | the next century. Politics is
| about surviving until Friday
University of Technology, Sydney | afternoon. – Yes, Minister
| Oddly, some of them appear to be working now… in some cases one out of 5
| transactions are appearing, whilst the others (in the same ticket!) are
| not.
|
| There doesn’t seem to be a correlation between tickets before the move and
| tickets after the move, which makes it all the more frustrating.
±–>8
That sounds like whatever you did to transfer the database generated new
autoincrement sequence numbers — which would pretty well break things
because the ones in each_req and transactions are what tie everything
together.
I’d re-dump the old RT installation with mysqldump and reload it.
brandon s. allbery [os/2][linux][solaris][japh] allbery@kf8nh.apk.net
system administrator [WAY too many hats] allbery@ece.cmu.edu
electrical and computer engineering KF8NH
carnegie mellon university [“better check the oblivious first” -ke6sls]
±----
| Oddly, some of them appear to be working now… in some cases one out of 5
| transactions are appearing, whilst the others (in the same ticket!) are
| not.
|
| There doesn’t seem to be a correlation between tickets before the move and
| tickets after the move, which makes it all the more frustrating.
±–>8
You might think so, but new requests are being generated with the expected
serial numbers, and the new files are being created in the proper place
within the transaction heirachy… it’s just that they (the message
bodies) aren’t showing up on the webpage.
Does RT Log anywhere apart from the apache erorr log (which has nothing
interesting in it)?
T�o de Hesselle, | Diplomacy is about surviving until
Unix Systems Administrator | the next century. Politics is
| about surviving until Friday
University of Technology, Sydney | afternoon. – Yes, Minister
| You might think so, but new requests are being generated with the expected
| serial numbers, and the new files are being created in the proper place
| within the transaction heirachy… it’s just that they (the message
| bodies) aren’t showing up on the webpage.
±–>8
Weird. Make sure the webserver is actually running as user rt, maybe?
| Does RT Log anywhere apart from the apache erorr log (which has nothing
| interesting in it)?
±–>8
Not by default; I installed Log::Stderr and added an invocation of it in
rtmux.pl in our copy.
brandon s. allbery [os/2][linux][solaris][japh] allbery@kf8nh.apk.net
system administrator [WAY too many hats] allbery@ece.cmu.edu
electrical and computer engineering KF8NH
carnegie mellon university [“better check the oblivious first” -ke6sls]
I have to move RT from machine A to B… I did a fresh install and then
overwrote the new mysql database with the original… And I’ve now lost
access to the message bodies…
I’ve also copied the old transactions… Help… users are screaming at
me…
More exciting information:
I shut the rt interface down, so I can play without affecting the users.
Now… I copied mysql/var/rt to mysql/var/rt-broke
then went into mysql and did a DROP DATABASE rt;
Next… moved /usr/local/rt1 to usr/local/rt1-broke
Changed the uid from 42 to 60001, to match the previous system it was
installed on.
“make install” from source.
The new database behaves exactly the same as the old… though I tried
creating/commenting from the web interface, and that works fine (the text
is displayed)… otherwise, the text is gone.
Now… there is no trace of the ‘old’ data on the system whatsoever… but
the behavior is still there.
Any ideas?
T�o de Hesselle, | Diplomacy is about surviving until
Unix Systems Administrator | the next century. Politics is
| about surviving until Friday
University of Technology, Sydney | afternoon. – Yes, Minister
You might think so, but new requests are being generated with the expected
serial numbers, and the new files are being created in the proper place
within the transaction heirachy… it’s just that they (the message
bodies) aren’t showing up on the webpage.
Is it just imported messages which aren’t displaying, or are new messages affected too? If so, before reimporting anything, recreate the new database as per a fresh install, and check that it works okay without any imported messages.
Does RT Log anywhere apart from the apache erorr log (which has nothing
interesting in it)?
Not that I know of. Logging has never been a strong suit.
Yes. Both are set to TZ=Australia/NSW in /etc/default/init (it’s solaris).
However as I’ve found that I can’t get a default frelling install to
happen, I longer think this is an import problem… how I failed to notice
before, I don’t know…
T�o de Hesselle, | Diplomacy is about surviving until
Unix Systems Administrator | the next century. Politics is
| about surviving until Friday
University of Technology, Sydney | afternoon. – Yes, Minister
Okay… you’ve obviously been here before… when I use the web, it
creates it using yesterday’s date, and displays fine. If i move Jul/6/* to
Jul/5/*, they display fine also.
Now I just have to work out where this incorrect timezone info is coming
from…
What is the difference in the method used by the web and the mailgate?
T�o de Hesselle, | Diplomacy is about surviving until
Unix Systems Administrator | the next century. Politics is
| about surviving until Friday
University of Technology, Sydney | afternoon. – Yes, Minister
They’re different users and may have different default environments.
This is one of the larger design screwups in RT 1.0.xOn Fri, Jul 06, 2001 at 12:35:00PM +1000, Teo de Hesselle wrote:
Jesse wrote:
is the timezone on the two systems set the same?
Okay… you’ve obviously been here before… when I use the web, it
creates it using yesterday’s date, and displays fine. If i move Jul/6/* to
Jul/5/*, they display fine also.
Now I just have to work out where this incorrect timezone info is coming
from…
What is the difference in the method used by the web and the mailgate?
–
Téo de Hesselle, | Diplomacy is about surviving until
Unix Systems Administrator | the next century. Politics is
| about surviving until Friday
University of Technology, Sydney | afternoon. – Yes, Minister