Offline work would be great, but not needed for the first step!
- Originalnachricht -
Kuehne + Nagel (AG Co.) KG, Geschaeftsleitung: Hans-Georg Brinkmann (Vors.),
Dirk Blesius, Reiner Heiken, Bruno Mang, Alfred Manke, Christian Marnetté, Mark
Reinhardt, Jens Wollesen, Rainer Wunn,
Kevin Falcone wrote:
On Mon, Jun 28, 2010 at 12:05:13PM +0200, Wolfram Huettermann wrote:
Hello,
I have got a user customfield called MyComment and I want to filter all
users where this
customfield is not empty. In my case, it is of freefrom type. The function
Hello,
the following scrip works only On transaction but not wen a new
ticket is created.
What is wrong ?
- Condition : User Defined
- Custom condition :
my $trans = $self-TransactionObj;
my $ticket = $self-TicketObj;
if ($trans-Type eq 'CustomField') {
my $cf = new
Found some code in another thread.
my $AssObj = RTx::AssetTracker::Asset-new(RT-SystemUser);
$AssObj-Load($AssId);
my $AssCFs=$AssObj-CustomFields();
while(my $AssCF = $AssCFs-Next()) {
print $AssCF-Name, : ;
my $AssValues=$AssObj-CustomFieldValues($AssCF-id);
while($AssValues and my
As a first step, it would probably be easier to create a special
stylesheet to create the illusion of an app.
Yes, my first thought was that a mobile stylesheet might make it
easier to use RT on a mobile device. It could be done on the server
side, rather than the client
Hi everyone,
I've raised this before, but we've had another look at it and still can't see
how to improve things.
We put a lot of comments/replies in our tickets. Often there can be 50-100
entries in a ticket, mostly plain text. Loading such a ticket can take
10-20secs.
We don't have any
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi everyone
I've been trying to wrap my head around RT for a couple of days now
(actually RT-IR).
Currently I am trying to add some business logic (yes...scrips :) ).
I noted some oddities while trying to set my priority field using custom
fields. I
Quite outside of the speed of RT, what database are you using as a
back-end? How long has it been since you did some care and feeding of
your database? How big are your tables? If you are using mysql or
postgres have you used their tools to examine your database,
especially the indexes and
Hi Charles,
But as far as we can tell from our profiling the time is spent in the perl
rendering the ticket, not in the query used to retrieve the ticket and
attachments in the first place (which happens once at the start I believe). The
loop that renders the ticket history and each attachment
Hi,
If you are using mysqld have a look at mysqltuner.pl perl script
(google)
This has fixed quickly many performance issues on both RT and other
web-based software we use. I run this every few weeks and apply
suggested
changes and then simply restart mysqld when things are quite.
Regards,
Justin, thank you for the kindness of your reply. I didn't intend to
send you chasing rabbits, so to speak. Just offering something to add
to the checklist of items to be crossed off before digging too deeply
into the perl code. If you are convinced that mysql is performing at
its best
Thanks Jason - I'll give that a go as well. We have got a large DB (~10gb) so
keeping it tuned is definitely important.
However as stated the time seems to be lost in code, after I'd have thought it
had run the query for the ticket (though I may be wrong in that assumption).
Cheers,
Justin
I'm in the process of trying to upgrade now and I've gotten to the part of
updating the database and I get the following error. Can anyone help me?
r...@nethealth:/opt/rt3/sbin# ./rt-setup-database --dba root
--prompt-for-dba-password --action upgrade
In order to create or update your RT
Hehe thanks Charles.
I think you might have a point anyway. Running that script recommended by Jason
has thrown up a few things that need tweaking with mysql.
Not sure what some of them mean yet, and not sure if it'll help, but we'll see.
I appreciate you helping believe me!
Justin
I did just have a problem with 3.8.8 and one of the indexes (didn't have the
problem on 3.8.6 or below). It turned out to be the index GROUPS2 on the
Groups table... dropped the index, and performance was back to normal (pre
3.8.8)
Nicola
-Original Message-
From:
Seem to be quite a few things to look at Jason. Need to figure out what they
all mean first.
Justin
General Statistics --
[--] Skipped version check for MySQLTuner script
[OK] Currently running supported MySQL version
Hi Nicola,
I've just tried upgrading from 3.8.4 which I've been on for ages, on the hope
that it would be better, but isn't.
So I don't think it's something that has either been introduced or fixed by
3.8.8. I'll take a look at that index though.
Thanks,
Justin
On Tue, Jun 29, 2010 at 09:29:08AM +0200, Wolfram Huettermann wrote:
Kevin Falcone wrote:
On Mon, Jun 28, 2010 at 12:05:13PM +0200, Wolfram Huettermann wrote:
Hello,
I have got a user customfield called MyComment and I want to filter all
users where this
customfield is not
On Tue, Jun 29, 2010 at 10:09:19AM +0200, Horst Kriegers wrote:
the following scrip works only On transaction but not wen a new ticket
is created.
What is wrong ?
Your condition says only work when this is a custom field change, it
doesn't consider Create types at all.
-kevin
-
As a test we've just created a long ticket in an empty RT DB and it's very
fast. So does look to be DB related - contrary to our earlier investigations.
I guess it must still access the DB resultset during the ticket rendering
(which isn't how we thought it would work).
Time to tune the hell
On Tue, Jun 29, 2010 at 10:42:44AM -0400, Patton, Brandon wrote:
I'm in the process of trying to upgrade now and I've gotten to the part of
updating the database and I get the following error. Can anyone help me?
r...@nethealth:/opt/rt3/sbin# ./rt-setup-database --dba root
Justin,
I didn't see this mentioned and may have missed it, but are you displaying
attachements inline? That might cut back on the I/O for History. Just a
thought.
Kenn
LBNL
On Tue, Jun 29, 2010 at 8:04 AM, Justin Hayes justin.ha...@openbet.comwrote:
As a test we've just created a long ticket
Marc,
I could be wrong but I suspect that what you are seeing after you made a
change has to do with what is in cache.
Your scrip code was for Cleanup so after RT made your change to 100, the
Cleanup scrip came along and changed it back to 50, but cache still has
what you TYPED into that field.
Oeter,
What Kevin said is what you need.
nor can I add them to groups - You can only add Privileged Users to a
group
Kenn
LBNL.
On Mon, Jun 28, 2010 at 2:27 PM, Kevin Gagel ga...@cnc.bc.ca wrote:
Peter,
Look into:
Set($WebExternalAuto,1);
Set($AutoCreate,{Privileged=0});
It's one or
Pardon the top posting, but I feel that I have worked around the
problem we had with failing commits on ticket creation. Here is what I
did.
We first upgraded to the latest stable version of mod_perl for CentOS
5.2.
Second, we changed to custom cleanup code to use IPC::System::Simple
Ok, I'm getting closer and closer to getting this to work but having a problem
with the Apache setup. I have created the config for Apache as shown by
numerous examples but no matter which example I follow, I get the following
error trying to start Apache:
Can't load Perl file:
I have RTFM 2.4.2 installed and seems to be mostly working correctly.
But I can't finish setting it up to see.
I don't have a place to put comments into the FAQ, so the notes that I
found was to create a custom field.
I have a Custom field called Body, Fill in one text area, applies to
RTFM,
Do anybody have a copy of the QuickSpamHandler.tgz tarball that is
referenced from http://wiki.bestpractical.com/view/SpamFiltering ?
I have used it before and I was hoping to install it on a new RT
instance but unfortunately I can't find the tarball anywhere :(
Cheers,
Francois
Discover RT's
28 matches
Mail list logo