Stats package Tabs Element

I installed the Stats package, and then the Tickets tab stopped working.
The new Tabs Element that Statistics imports tries to go to
Search/Listing.html, while the 3.2.1 Tabs Element goes to
Search/Build.html. If you go to Search/Build.html manually, the Tab
doesn’t expand like it should to show the Query options. I don’t have a
patch for it, but it should be trivial for someone to solve.

Ray

Thanks Bryan. I figured it was just a Nav change for 3.2 that had
confused it. I actually solved it myself with a different easy fix
after I sent the email. I just changed Search/Listing.html to
Search/Build.html in the new Tabs file and it worked fine.

Ray

Bryan Pennington wrote:

Another suggestion:

Create the following file:
/path to rt3/local/html/Callbacks/Statistics/Elements/Tabs/Default

<%init>
$toptabs->{‘ZZ-STATS’} = { title => ‘Statistics’,
path => “Statistics/index.html” };
</%init>
<%args>
$toptabs =>undef
</%args>

This way you won’t have to clobber the file:
/path to rt3/local/html/Elements/Tabs

This will use the Callback method to add Statistics item to the menu. Don’t
have to worry about changes to the original Tabs file anymore.

DaveFrom: Ray Walters [mailto:ray.walters@kiffanalytical.com]
Sent: Friday, July 30, 2004 5:45 PM
To: rt-users@lists.bestpractical.com
Subject: Re: [rt-users] Stats package Tabs Element

Thanks Bryan. I figured it was just a Nav change for 3.2 that had
confused it. I actually solved it myself with a different easy fix
after I sent the email. I just changed Search/Listing.html to
Search/Build.html in the new Tabs file and it worked fine.

Ray

Bryan Pennington wrote:

Ray,

I had the same problem. It’s an easy fix. The navigation changed in 3.2.
You
need to copy the Tabs file from the rt3/share tree to the /local tree and
then add the following.

  		Z => { title => 'Statistics',
                         path =>  'Statistics/index.html'
                       },

Bryan

-----Original Message-----
From: rt-users-bounces@lists.bestpractical.com
[mailto:rt-users-bounces@lists.bestpractical.com] On Behalf Of Ray Walters
Sent: Friday, July 30, 2004 3:16 PM
To: rt-users@lists.bestpractical.com
Subject: [rt-users] Stats package Tabs Element

I installed the Stats package, and then the Tickets tab stopped working.
The new Tabs Element that Statistics imports tries to go to
Search/Listing.html, while the 3.2.1 Tabs Element goes to
Search/Build.html.
If you go to Search/Build.html manually, the Tab doesn’t expand like it
should to show the Query options. I don’t have a patch for it, but it
should be trivial for someone to solve.

Ray


http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Be sure to check out the RT wiki at http://wiki.bestpractical.com

http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Be sure to check out the RT wiki at http://wiki.bestpractical.com

This e-mail may be privileged and/or confidential, and the sender does not waive any related rights and obligations. Any distribution, use or copying of this e-mail or the information it contains by other than an intended recipient is unauthorized. If you received this e-mail in error, please advise me (by return e-mail or otherwise) immediately.

Ce courrier �lectronique est confidentiel et prot�g�. L’exp�diteur ne renonce pas aux droits et obligations qui s’y rapportent. Toute diffusion, utilisation ou copie de ce message ou des renseignements qu’il contient par une personne autre que le (les) destinataire(s) d�sign�(s) est interdite. Si vous recevez ce courrier �lectronique par erreur, veuillez m’en aviser imm�diatement, par retour de courrier �lectronique ou par un autre moyen.

Thanks for the fix, I’ve been meaning to look at this one for a long time, but haven’t had a chance. This WILL be in the next stats release, don’t know when that will be, as Rik is working on a few things, but…

Kelly F. Hickel

Senior Software Architect

MQSoftware, Inc.

952.345.8677

kfh@mqsoftware.comFrom: rt-users-bounces@lists.bestpractical.com [mailto:rt-users-bounces@lists.bestpractical.com] On Behalf Of david.falkenburger@rbc.com
Sent: Monday, August 09, 2004 3:03 PM
To: ray.walters@kiffanalytical.com; rt-users@lists.bestpractical.com
Subject: RE: [rt-users] Stats package Tabs Element

Another suggestion:

Create the following file:
/path to rt3/local/html/Callbacks/Statistics/Elements/Tabs/Default

<%init>
$toptabs->{‘ZZ-STATS’} = { title => ‘Statistics’,
path => “Statistics/index.html” };
</%init>
<%args>
$toptabs =>undef
</%args>

This way you won’t have to clobber the file:
/path to rt3/local/html/Elements/Tabs

This will use the Callback method to add Statistics item to the menu. Don’t have to worry about changes to the original Tabs file anymore.

Dave

From: Ray Walters [mailto:ray.walters@kiffanalytical.com]
Sent: Friday, July 30, 2004 5:45 PM
To: rt-users@lists.bestpractical.com
Subject: Re: [rt-users] Stats package Tabs Element

Thanks Bryan. I figured it was just a Nav change for 3.2 that had
confused it. I actually solved it myself with a different easy fix
after I sent the email. I just changed Search/Listing.html to
Search/Build.html in the new Tabs file and it worked fine.

Ray

Bryan Pennington wrote:

Ray,

I had the same problem. It’s an easy fix. The navigation changed in 3.2. You
need to copy the Tabs file from the rt3/share tree to the /local tree and
then add the following.

                          Z => { title => 'Statistics', 
                         path =>  'Statistics/index.html' 
                       }, 

Bryan

-----Original Message-----
From: rt-users-bounces@lists.bestpractical.com
[mailto:rt-users-bounces@lists.bestpractical.com] On Behalf Of Ray Walters
Sent: Friday, July 30, 2004 3:16 PM
To: rt-users@lists.bestpractical.com
Subject: [rt-users] Stats package Tabs Element

I installed the Stats package, and then the Tickets tab stopped working.
The new Tabs Element that Statistics imports tries to go to
Search/Listing.html, while the 3.2.1 Tabs Element goes to Search/Build.html.
If you go to Search/Build.html manually, the Tab doesn’t expand like it
should to show the Query options. I don’t have a patch for it, but it
should be trivial for someone to solve.

Ray


http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Be sure to check out the RT wiki at http://wiki.bestpractical.com

http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Be sure to check out the RT wiki at http://wiki.bestpractical.com

This e-mail may be privileged and/or confidential, and the sender does not waive any related rights and obligations. Any distribution, use or copying of this e-mail or the information it contains by other than an intended recipient is unauthorized. If you received this e-mail in error, please advise me (by return e-mail or otherwise) immediately.

Ce courrier électronique est confidentiel et protégé. L’expéditeur ne renonce pas aux droits et obligations qui s’y rapportent. Toute diffusion, utilisation ou copie de ce message ou des renseignements qu’il contient par une personne autre que le (les) destinataire(s) désigné(s) est interdite. Si vous recevez ce courrier électronique par erreur, veuillez m’en aviser immédiatement, par retour de courrier électronique ou par un autre moyen.

We have been happily running an instance of RT2 (and rt1 before that) here
at Global Crossing for several years and, this morning, we had a
catastrophic event happen… every admin’s worst nightmare. After having
one of two mirrored drives fail, I got right on my new machine to upgrade
to rt3 instead of replacing the drive (we’re a poor company nowadays).
Well, this am, after a power hit which took out our ac, the temperatures
rose in our data center (110 degrees +) and my last drive failed. Now, I
have nothing but a backup of the rt2 database from /usr/local/mysql.

Has anyone had any experience with this? I need to get my old data from
there (and /opt, which was backed up, too), but I’m not sure if anyone has
a nice script that can just magically import my old stuff from that into
mysql again, but in rt3 format.

Anyone?

Aubrey King
Global Crossing, Ltd.
IP Systems Engineering
Systems Administrator

How did you do your backup? If you used the mysql HotCopy, you’re in
luck. Both because the restore is easy, and I happened to do it last
week. With hotcopy, it makes exact copies of the databases, so all you
have to do is take mysql down, copy the “rt3” directory from your
hotcopy (or whatever your database name was) to wherever your mysql data
directory is (like /var/lib/mysql/rt3), and bring mysql back up…

-Kelly-----Original Message-----
From: rt-users-bounces@lists.bestpractical.com
[mailto:rt-users-bounces@lists.bestpractical.com] On Behalf Of Aubrey
King
Sent: Monday, August 09, 2004 8:08 PM
Cc: rt-users@lists.bestpractical.com
Subject: [rt-users] UGLY EMERGENCY

We have been happily running an instance of RT2 (and rt1 before that)
here
at Global Crossing for several years and, this morning, we had a
catastrophic event happen… every admin’s worst nightmare. After having

one of two mirrored drives fail, I got right on my new machine to
upgrade
to rt3 instead of replacing the drive (we’re a poor company nowadays).
Well, this am, after a power hit which took out our ac, the temperatures

rose in our data center (110 degrees +) and my last drive failed. Now,
I
have nothing but a backup of the rt2 database from /usr/local/mysql.

Has anyone had any experience with this? I need to get my old data from

there (and /opt, which was backed up, too), but I’m not sure if anyone
has
a nice script that can just magically import my old stuff from that into

mysql again, but in rt3 format.

Anyone?

Aubrey King
Global Crossing, Ltd.
IP Systems Engineering
Systems Administrator
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Be sure to check out the RT wiki at http://wiki.bestpractical.com

Unfortunately, all we have is the file that the database was stored in
under /usr/local/mysql/data or wherever. This sucks.

Aubrey King
Global Crossing, Ltd.
IP Systems Engineering
Systems AdministratorOn Mon, 9 Aug 2004, Kelly F. Hickel wrote:

How did you do your backup? If you used the mysql HotCopy, you’re in
luck. Both because the restore is easy, and I happened to do it last
week. With hotcopy, it makes exact copies of the databases, so all you
have to do is take mysql down, copy the “rt3” directory from your
hotcopy (or whatever your database name was) to wherever your mysql data
directory is (like /var/lib/mysql/rt3), and bring mysql back up…

-Kelly

-----Original Message-----
From: rt-users-bounces@lists.bestpractical.com
[mailto:rt-users-bounces@lists.bestpractical.com] On Behalf Of Aubrey
King
Sent: Monday, August 09, 2004 8:08 PM
Cc: rt-users@lists.bestpractical.com
Subject: [rt-users] UGLY EMERGENCY

We have been happily running an instance of RT2 (and rt1 before that)
here
at Global Crossing for several years and, this morning, we had a
catastrophic event happen… every admin’s worst nightmare. After having

one of two mirrored drives fail, I got right on my new machine to
upgrade
to rt3 instead of replacing the drive (we’re a poor company nowadays).
Well, this am, after a power hit which took out our ac, the temperatures

rose in our data center (110 degrees +) and my last drive failed. Now,
I
have nothing but a backup of the rt2 database from /usr/local/mysql.

Has anyone had any experience with this? I need to get my old data from

there (and /opt, which was backed up, too), but I’m not sure if anyone
has
a nice script that can just magically import my old stuff from that into

mysql again, but in rt3 format.

Anyone?

Aubrey King
Global Crossing, Ltd.
IP Systems Engineering
Systems Administrator


http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Be sure to check out the RT wiki at http://wiki.bestpractical.com

OK, well, there should be many files in the directory that has the same
name as the database. You’re going to have to start by copying those
onto a shutdown, but working mysql machine (obviously make sure you have
a copy of the copy!). I’d probably just try bringing it up first to see
if it automatically replays whatever transaction logs exist, but you can
also check the mysql manual, I think there’s probably a way to tell it
to do that explicitly.

What state do you think the database was in at the time of this copy?
Was mysql running? Were transactions (especially write) likely to be
running on the database? If you were in the middle of your upgrade from
RT2 to RT3, had you done the database step yet?

Also, for the future, you’ll REALLY want to check out the hotcopy
script. It’s nice, easy, and fast…

-KellyFrom: Aubrey King [mailto:aking@gblx.net]
Sent: Monday, August 09, 2004 8:36 PM
To: Kelly F. Hickel
Cc: rt-users@lists.bestpractical.com
Subject: RE: [rt-users] UGLY EMERGENCY

Unfortunately, all we have is the file that the database was stored in
under /usr/local/mysql/data or wherever. This sucks.

Aubrey King
Global Crossing, Ltd.
IP Systems Engineering
Systems Administrator

How did you do your backup? If you used the mysql HotCopy, you’re in
luck. Both because the restore is easy, and I happened to do it last
week. With hotcopy, it makes exact copies of the databases, so all
you
have to do is take mysql down, copy the “rt3” directory from your
hotcopy (or whatever your database name was) to wherever your mysql
data
directory is (like /var/lib/mysql/rt3), and bring mysql back up…

-Kelly

-----Original Message-----
From: rt-users-bounces@lists.bestpractical.com
[mailto:rt-users-bounces@lists.bestpractical.com] On Behalf Of Aubrey
King
Sent: Monday, August 09, 2004 8:08 PM
Cc: rt-users@lists.bestpractical.com
Subject: [rt-users] UGLY EMERGENCY

We have been happily running an instance of RT2 (and rt1 before that)
here
at Global Crossing for several years and, this morning, we had a
catastrophic event happen… every admin’s worst nightmare. After
having

one of two mirrored drives fail, I got right on my new machine to
upgrade
to rt3 instead of replacing the drive (we’re a poor company nowadays).

Well, this am, after a power hit which took out our ac, the
temperatures

rose in our data center (110 degrees +) and my last drive failed.
Now,
I
have nothing but a backup of the rt2 database from /usr/local/mysql.

Has anyone had any experience with this? I need to get my old data
from

there (and /opt, which was backed up, too), but I’m not sure if anyone
has
a nice script that can just magically import my old stuff from that
into

mysql again, but in rt3 format.

Anyone?

Aubrey King
Global Crossing, Ltd.
IP Systems Engineering
Systems Administrator


http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Be sure to check out the RT wiki at http://wiki.bestpractical.com

OK… well… my backup had the MYD, MYI and frm files from the old rt2
database and I can read them just fine, which is good. NOW… I know I
could surf around and find rt2 to rt3 database conversion scripts, but I’m
really hoping someone here can help me with a shortcut on that. Anyone?
Bueller?

Thank you all, in advance.

Aubrey King
Global Crossing, Ltd.
IP Systems Engineering
Systems AdministratorOn Mon, 9 Aug 2004, Kelly F. Hickel wrote:

OK, well, there should be many files in the directory that has the same
name as the database. You’re going to have to start by copying those
onto a shutdown, but working mysql machine (obviously make sure you have
a copy of the copy!). I’d probably just try bringing it up first to see
if it automatically replays whatever transaction logs exist, but you can
also check the mysql manual, I think there’s probably a way to tell it
to do that explicitly.

What state do you think the database was in at the time of this copy?
Was mysql running? Were transactions (especially write) likely to be
running on the database? If you were in the middle of your upgrade from
RT2 to RT3, had you done the database step yet?

Also, for the future, you’ll REALLY want to check out the hotcopy
script. It’s nice, easy, and fast…

-Kelly

-----Original Message-----
From: Aubrey King [mailto:aking@gblx.net]
Sent: Monday, August 09, 2004 8:36 PM
To: Kelly F. Hickel
Cc: rt-users@lists.bestpractical.com
Subject: RE: [rt-users] UGLY EMERGENCY

Unfortunately, all we have is the file that the database was stored in
under /usr/local/mysql/data or wherever. This sucks.

Aubrey King
Global Crossing, Ltd.
IP Systems Engineering
Systems Administrator

On Mon, 9 Aug 2004, Kelly F. Hickel wrote:

How did you do your backup? If you used the mysql HotCopy, you’re in
luck. Both because the restore is easy, and I happened to do it last
week. With hotcopy, it makes exact copies of the databases, so all
you
have to do is take mysql down, copy the “rt3” directory from your
hotcopy (or whatever your database name was) to wherever your mysql
data
directory is (like /var/lib/mysql/rt3), and bring mysql back up…

-Kelly

-----Original Message-----
From: rt-users-bounces@lists.bestpractical.com
[mailto:rt-users-bounces@lists.bestpractical.com] On Behalf Of Aubrey
King
Sent: Monday, August 09, 2004 8:08 PM
Cc: rt-users@lists.bestpractical.com
Subject: [rt-users] UGLY EMERGENCY

We have been happily running an instance of RT2 (and rt1 before that)
here
at Global Crossing for several years and, this morning, we had a
catastrophic event happen… every admin’s worst nightmare. After
having

one of two mirrored drives fail, I got right on my new machine to
upgrade
to rt3 instead of replacing the drive (we’re a poor company nowadays).

Well, this am, after a power hit which took out our ac, the
temperatures

rose in our data center (110 degrees +) and my last drive failed.
Now,
I
have nothing but a backup of the rt2 database from /usr/local/mysql.

Has anyone had any experience with this? I need to get my old data
from

there (and /opt, which was backed up, too), but I’m not sure if anyone
has
a nice script that can just magically import my old stuff from that
into

mysql again, but in rt3 format.

Anyone?

Aubrey King
Global Crossing, Ltd.
IP Systems Engineering
Systems Administrator


http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Be sure to check out the RT wiki at http://wiki.bestpractical.com

OK… well… my backup had the MYD, MYI and frm files from the old rt2
database and I can read them just fine, which is good. NOW… I know I
could surf around and find rt2 to rt3 database conversion scripts, but
I’m
really hoping someone here can help me with a shortcut on that.
Anyone?
Bueller?

BestPractical provides a conversion script, but You need a running rt2
instance to export the data.
I don’t think there is a better solution available.

Regards,
Harald

OK… well… my backup had the MYD, MYI and frm files from the old rt2
database and I can read them just fine, which is good. NOW… I know I
could surf around and find rt2 to rt3 database conversion scripts, but I’m
really hoping someone here can help me with a shortcut on that. Anyone?
Bueller?

That doesn’t work, because the application would probably need a lot of
"intelligence". “Intelligence” that is normally sitting in RT itself.
So I doubt someone has made the effort and dublicated the functionality
of RT in a script.

RT is complex enough that you can’t simply modify the database directly
anymore (if you don’t know what you’re doing - and if you have to ask,
you probably really don’t…), you have to go through the API.

Good Luck.

Rainer

could surf around and find rt2 to rt3 database conversion scripts, but
I’m
really hoping someone here can help me with a shortcut on that.
Anyone?
Bueller?

There is no shortcut. In fact, you have to install and configure RT2
in order to run the rt2 export script. So just fetch RT2, point it at
your database and start running the converter.

If there was a shortcut, I’m sure the rt2-rt3 migration scripts would
vanish quickly and be replaced by the faster way.

Vivek Khera, Ph.D.
+1-301-869-4449 x806

I believe that they’re looking for a shortcut to surfing around, not a
shortcut for the conversion.

Kelly F. Hickel
Senior Software Architect
MQSoftware, Inc.
952.345.8677
kfh@mqsoftware.com

-----Original Message-----
From: rt-users-bounces@lists.bestpractical.com [mailto:rt-users-
bounces@lists.bestpractical.com] On Behalf Of Vivek Khera
Sent: Tuesday, August 10, 2004 3:17 PM
To: RT Mailing List
Subject: Re: [rt-users] UGLY EMERGENCY

could surf around and find rt2 to rt3 database conversion scripts,
but

Message: 1
Date: Mon, 9 Aug 2004 20:33:11 -0500
From: “Kelly F. Hickel” kfh@mqsoftware.com
Subject: RE: [rt-users] UGLY EMERGENCY
To: “Aubrey King” aking@gblx.net
Cc: rt-users@lists.bestpractical.com
Message-ID:
3C05BBBA1B54ED43B1A6827E620EF1CD58551F@mailservermn.mqsoftware.com
Content-Type: text/plain; charset=“us-ascii”

How did you do your backup? If you used the mysql HotCopy, you’re in
luck. Both because the restore is easy, and I happened to do it last
week. With hotcopy, it makes exact copies of the databases, so all you
have to do is take mysql down, copy the “rt3” directory from your
hotcopy (or whatever your database name was) to wherever your mysql data
directory is (like /var/lib/mysql/rt3), and bring mysql back up…

-Kelly

-----Original Message-----
From: rt-users-bounces@lists.bestpractical.com
[mailto:rt-users-bounces@lists.bestpractical.com] On Behalf Of Aubrey
King
Sent: Monday, August 09, 2004 8:08 PM
Cc: rt-users@lists.bestpractical.com
Subject: [rt-users] UGLY EMERGENCY

We have been happily running an instance of RT2 (and rt1 before that)
here
at Global Crossing for several years and, this morning, we had a
catastrophic event happen… every admin’s worst nightmare. After having

one of two mirrored drives fail, I got right on my new machine to
upgrade
to rt3 instead of replacing the drive (we’re a poor company nowadays).
Well, this am, after a power hit which took out our ac, the temperatures

rose in our data center (110 degrees +) and my last drive failed. Now,
I
have nothing but a backup of the rt2 database from /usr/local/mysql.

Has anyone had any experience with this? I need to get my old data from

there (and /opt, which was backed up, too), but I’m not sure if anyone
has
a nice script that can just magically import my old stuff from that into

mysql again, but in rt3 format.

Anyone?

Aubrey King
Global Crossing, Ltd.
IP Systems Engineering
Systems Administrator


http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Be sure to check out the RT wiki at http://wiki.bestpractical.com

This is an awesome tip from Kelly. We were using Mysqldump every 6 hours
for backups, which is not exactly the quickest way to do it but it
worked. Tried mysqlhotcopy today and it was sub second ( ok we only have
5000 tickets so far) to complete the backup.

I’m a convert - thanks Kelly

This is an awesome tip from Kelly. We were using Mysqldump every 6
hours
for backups, which is not exactly the quickest way to do it but it
worked. Tried mysqlhotcopy today and it was sub second ( ok we only
have
5000 tickets so far) to complete the backup.

I’m a convert - thanks Kelly

But does mysqlhotcopy work with innodb style databases? the mysql web
site gives the impression one needs innodbhotcopy, which ist 390$ per
machine…

 Regards,
     Harald

-----Original Message-----
From: rt-users-bounces@lists.bestpractical.com [mailto:rt-users-
bounces@lists.bestpractical.com] On Behalf Of Harald Wagener
Sent: Thursday, August 12, 2004 3:07 AM
To: 'rt-users@lists.fsck.com’
Subject: [rt-users] Off-Topic: mysqlhotcopy and innodb databases

Am 11.08.2004 um 17:15 schrieb Richard Ellis:

This is an awesome tip from Kelly. We were using Mysqldump every 6
hours
for backups, which is not exactly the quickest way to do it but it
worked. Tried mysqlhotcopy today and it was sub second ( ok we only
have
5000 tickets so far) to complete the backup.

I’m a convert - thanks Kelly

But does mysqlhotcopy work with innodb style databases? the mysql web
site gives the impression one needs innodbhotcopy, which ist 390$ per
machine…
[Kelly F. Hickel] That’s a good question, the databases that I’m backing
up currently aren’t for RT, and off the top of my head, I don’t know if
they’re innodb or not. Something I’ll have to look into, but it won’t
be in the next week or to, so if someone else fells like figuring it
out…

-Kelly