Hi all,
I would to remove all tickets, but I don't remove the whole database. Does
someone know which the best manner to do that?
I have a solution, but I don't know if it's the best:
mysql -p
password
use database
delete * from Transactions;
delete * from Tickets;
Regards,
On Mon, Feb 16, 2009 at 06:11:30PM -0600, Joel Schuweiler wrote:
Here's the scenario:
1) A User has a custom field called Billable with two choices, yes, and
no.
2) User creates ticket
3) Scrip checks Billable and sets ticket billable if user is billable
I'm having a
On Tue, Feb 17, 2009 at 09:21:27AM +0100, Alberto Villanueva wrote:
Hi all,
I would to remove all tickets, but I don't remove the whole database. Does
someone know which the best manner to do that?
You can use RTx::Shredder for this (as a module from CPAN if RT 3.8,
included in
Hi,
When I execute the sentence (rt-shredder --force -plugin 'Tickets=status,new'),
I get the next error:
[warning]: RT::CachedGroupMember-12--- bla,bla,bla
I'sorry by the warning.
Any idea??
Thanks a lot!
Regards,
ALBERTO VILLANUEVA VAL
Consultor
I also created the indexes:
CREATE INDEX SHREDDER_CGM1 ON CachedGroupMembers(MemberId, GroupId, Disabled);
CREATE INDEX SHREDDER_CGM2 ON CachedGroupMembers(ImmediateParentId,
MemberId);
CREATE UNIQUE INDEX SHREDDER_GM1 ON GroupMembers(MemberId, GroupId);
CREATE INDEX SHREDDER_TXN1
Hello
I have created a custom field to appear in all tickets. I have enabled
it globally for all queues but it does not appear in any new ticket.
Where am I going wrong?
Regards, Jim
___
Hi
Did you apply the group-rights and the user-rights with ShowCustomField and
ModifyCustomField rights?
Might be worth a look.
-Ashish
From: rt-users-boun...@lists.bestpractical.com
[rt-users-boun...@lists.bestpractical.com] On Behalf Of Jim Tambling
Thank you sir, that worked :)
-Original Message-
From: Potla, Ashish Bassaliel [mailto:c_apo...@qualcomm.com]
Sent: 17 February 2009 12:42
To: Jim Tambling; rt-us...@bestpractical.com
Subject: RE: Global CustomField not displaying
Hi
Did you apply the group-rights and the user-rights
[Tue Feb 17 14:06:09 2009] [error]: Scrip 67 Prepare failed: Can't call method
FirstCustomFieldValue without a package or object reference at (eval 932)
line 1.
-Original Message-
From: rt-users-boun...@lists.bestpractical.com
[mailto:rt-users-boun...@lists.bestpractical.com] On Behalf
Hi there!
I have RT system (3.8.1) running on RHEL 5 64bit server, using apache
2.23. For authentication I use the plugin RT::Authen::ExternalAuth to
authenticate against Active Directory and it all works great...but...
We wanted to make it even more simply and to utilize Kerbreros.
Our Linux
On Tue, Feb 17, 2009 at 08:08:50AM -0600, Joel Schuweiler wrote:
[Tue Feb 17 14:06:09 2009] [error]: Scrip 67 Prepare failed: Can't call
method FirstCustomFieldValue without a package or object reference at (eval
932) line 1.
my $billable =
Or maybe :
my $billable =
$self-TransactionObj-CreatorObj-FirstCustomFieldValue('Billable');
note the (Obj) at the end of Creator
Regards;
Roy
Emmanuel Lacour wrote:
On Tue, Feb 17, 2009 at 08:08:50AM -0600, Joel Schuweiler wrote:
[Tue Feb 17 14:06:09 2009] [error]: Scrip 67 Prepare
It also seems bizarre to me to implement the interface that way. Basically
its like making a web page with a single text area named content and then
requiring formatting within that one field. Why not have the REST interface
have discrete fields? Coding to it would be certainly be
Thanks, that worked.
Go in the DB, change the effectiveid of the ticket back to its ID. It could
be easier, but not the end of the world.
--
Mathieu Longtin
1-514-803-8977
On Mon, Feb 16, 2009 at 12:28 PM, Emmanuel Lacour
elac...@easter-eggs.comwrote:
On Mon, Feb 16, 2009 at 12:20:38PM
We migrated our RT server to RT 3.8.2 a week ago, and all went well
until today, when suddenly we've been hit by a massive performance
problem. It seems that almost any query which touches the Attachments
table takes an absolute age to complete. For example, I've just
logged into the
I am try to use RT to replace our current help desk system but have been
struggling with 2 points:
1.)We have an SLA with our customers and need to be able to incorporate
that into our ticket system. I have installed and begun configuring the SLA
extension but I am not really sure if it
On Tue 17.Feb'09 at 16:51:57 +, Tim Cutts wrote:
We migrated our RT server to RT 3.8.2 a week ago, and all went well
until today,
From what version?
when suddenly we've been hit by a massive performance
problem. It seems that almost any query which touches the Attachments
As far as I recall SLA extension supports multiple business hours, so
you have to define:
%RT::ServiceBusinessHours = (
'Default' = {
... your description description ...
},
);
Such config allow you to define multiple business hours sets.
Values of the SLA
On Tue 17.Feb'09 at 17:47:43 +, Dave Holland wrote:
Tim's just got into his car to go home, but I can provide some
answers...
On Tue, Feb 17, 2009 at 12:29:10PM -0500, Jesse Vincent wrote:
On Tue 17.Feb'09 at 16:51:57 +, Tim Cutts wrote:
We migrated our RT server to RT 3.8.2 a
On Tue, Feb 17, 2009 at 12:59:17PM -0500, Jesse Vincent wrote:
And just to be sure, you ran the commands in UPGRADING.mysql?
I believe so (Tim did it).
# Query_time: 240 Lock_time: 0 Rows_sent: 4 Rows_examined: 27
SELECT DISTINCT main.Id AS id, main.Filename AS filename,
Steve O'Brien wrote:
I am try to use RT to replace our current help desk system but have
been struggling with 2 points:
Yep. Same here.
1.)We have an SLA with our customers and need to be able to incorporate
that into our ticket system. I have installed and begun configuring the SLA
I believe so (Tim did it).
# Query_time: 240 Lock_time: 0 Rows_sent: 4 Rows_examined: 27
That just looks...crazy. Can you try an OPTIMIZE TABLE Attachments; ?
(It may take ... a while.)
pgpUvNTAP2WCd.pgp
Description: PGP signature
___
You would also need to check if the requesters list for each of your
tickets is as they should be, when you merge tickets both set of
requesters(and Ccs) get merged into the master ticket.
Regards;
Roy
Mathieu Longtin wrote:
Thanks, that worked.
Go in the DB, change the effectiveid of the
Tim's just got into his car to go home, but I can provide some
answers...
On Tue, Feb 17, 2009 at 12:29:10PM -0500, Jesse Vincent wrote:
On Tue 17.Feb'09 at 16:51:57 +, Tim Cutts wrote:
We migrated our RT server to RT 3.8.2 a week ago, and all went well
until today,
From what
[snip]
There's one feature I'd love to have added to RT::Extension::SLA -- setting
initial and final ticket priorities automatically -- exactly as 'Starts' and
'Due'
dates are set. One of these days I'll have enough spare time to have a go
at
coding that up.
In 3.8 there is
[snip]
You just need to configure the SLA custom field in the usual way -- as a
'Select one value' and then add your service levels as the list of available
options. Now when you go to set the SLA on a ticket it should automatically
set the 'Starts' and 'Due' dates on the ticket. You'll
On Tue, Feb 17, 2009 at 8:47 PM, Dave Holland d...@sanger.ac.uk wrote:
Tim's just got into his car to go home, but I can provide some
answers...
On Tue, Feb 17, 2009 at 12:29:10PM -0500, Jesse Vincent wrote:
On Tue 17.Feb'09 at 16:51:57 +, Tim Cutts wrote:
We migrated our RT server to
To all,
I am VERY confused. I went to Bestpractical
(http://cpansearch.perl.org/src/FALCONE/RT-Extensions) to download the
CommandByEmail Extension. I am on 3.6.4 so I'm unsure that .06 will
work for me. I went to insatlling Instruction and it mentioned the
install commands and also
Hello,
I need help to get my RT 363 system back online. By mistake, I unchecked
the enabled button for the RT administration group, and have disabled
it. Now I am unable to perform any admin tasks. I went into the database
(Oracle) and checked the principals and cachegroupmembers table and
Ruslan Zakirov wrote:
[snip]
You just need to configure the SLA custom field in the usual way -- as a
'Select one value' and then add your service levels as the list of available
options. Now when you go to set the SLA on a ticket it should automatically
set the 'Starts' and 'Due' dates on
On 17 Feb 2009, at 6:09 pm, Dave Holland wrote:
On Tue, Feb 17, 2009 at 12:59:17PM -0500, Jesse Vincent wrote:
And just to be sure, you ran the commands in UPGRADING.mysql?
I believe so (Tim did it).
Indeed. All done pukka according to the upgrade docs.
Tim
--
The Wellcome Trust
On 17 Feb 2009, at 6:16 pm, Jesse Vincent wrote:
I believe so (Tim did it).
# Query_time: 240 Lock_time: 0 Rows_sent: 4 Rows_examined: 27
That just looks...crazy. Can you try an OPTIMIZE TABLE Attachments; ?
(It may take ... a while.)
Might as well do that now, since we're out of
Hello world!
I have a brand new installation of RT 3.8.2.
The configure, testdeps, e install worked propperly, and I was able to
run initialize-database, all ok so far.
But setting apache to run the web interface fails because of bin/webmux.pl file.
Whenever I have the line:
PerlRequire
Hi,
I've seen this question asked before, but have not seen a definitive
reply yet so thought it worth asking again.
We have an intermittent issue regarding attachments, and it seems to
happen more often when users are including multiple attachments. The
error message is as follows:
read-open
On Tue 17.Feb'09 at 21:15:52 +, Ian Trenfield wrote:
Hi,
I've seen this question asked before, but have not seen a definitive
reply yet so thought it worth asking again.
We have an intermittent issue regarding attachments, and it seems to
happen more often when users are including
On 17 Feb 2009, at 6:16 pm, Jesse Vincent wrote:
I believe so (Tim did it).
# Query_time: 240 Lock_time: 0 Rows_sent: 4 Rows_examined: 27
That just looks...crazy. Can you try an OPTIMIZE TABLE Attachments; ?
(It may take ... a while.)
OK, OPTIMIZE TABLE done, but performance on
Now, I may be being silly here, but how can a table with only 806180
id's in its primary key have more than 3 million rows? And counting
them takes three minutes, which really isn't many rows a second...
Is this stored in InnoDB by chance? If it were me, I would mysqldump all
databases,
OK, OPTIMIZE TABLE done, but performance on SELECT COUNT(id) FROM
Attachments is still terrible:
This does sort of smell like an optimiser bug - it says it's using
indices, but the level of I/O being done by the machine suggests it's
actually performing a full table scan.
Indeed.
On 17 Feb 2009, at 6:39 pm, Ruslan Zakirov wrote:
I hope you see that mysql examined only 27 rows and spend 240 seconds
to do that. I suspect that it's related to very high IO activity that
were going parallel with this query and blocked mysql's IO requests.
That was my worry. I've shuffled
Hello,
I've been using the mysqltuner script to check up on things, tune mem use to
our resources, etc. One thing remains consistent: no matter what i have
things set to, within a few hours of restart or full stop / start (at most),
the Attachments table becomes fragmented. Here's the most
On 17 Feb 2009, at 10:52 pm, Jesse Vincent wrote:
OK, OPTIMIZE TABLE done, but performance on SELECT COUNT(id) FROM
Attachments is still terrible:
This does sort of smell like an optimiser bug - it says it's using
indices, but the level of I/O being done by the machine suggests it's
[!!] Total fragmented tables: 1
[--] Reads / Writes: 64% / 36%
Fragmentation is normal, especially with that read/write ratio. It doesn't
necessarily indicate a problem. You can periodically optimize the
fragmented tables to improve performance, if performance becomes an issue,
which should
First time I see something like that. May be it's better to ask on
mysql lists. And sure you should keep digging into a reason. My
practice shows that there is no such thing as suddenly in IT. There
is always some change that turn world up side down.
optimize/analyze on InnoDB don't do the same
Thanks Matthew!
I am still a bit foggy on how to use this module and what it really
does. I configured the custom fields with a sort value, name and
description (I did not know what to put for category).
Care to share your ColorMap config with the SLA priorities?
TIA,
Steve
On Tue, 2009-02-17
On 18 Feb 2009, at 12:48 am, Ruslan Zakirov wrote:
First time I see something like that. May be it's better to ask on
mysql lists. And sure you should keep digging into a reason. My
practice shows that there is no such thing as suddenly in IT. There
is always some change that turn world up
Hi All
Have just updated 3.8.1 to 3.8.2 on FC10 using yum update, and now the httpd
service will not start up. The following errors are in the log file. Any
help would be appreciated as I am pretty new to Linux:
[Wed Feb 18 07:12:50 2009] [error] Base class package
Class::Accessor::Fast is
46 matches
Mail list logo