Hello All
Can anyone can tell me how i can log my queries that hits my database in
RT.log. I am using oracle 9i and RT 3.6.3 we have a performance issue as
our RT is very slow and takes 15-20 seconds for database operations. So
i want to log my queries so that i can then analyze them for
From RT_Config.pm
# DBIx-SearchBuilder 1.31_1 or higher; simply set $StatementLog to be
# the level that you wish SQL statements to be logged at.
Set($StatementLog,undef);
I am not sure what the different levels but :
Set($StatementLog,1);
will be a good start.
Remember to restart your web
Varun;
There is no straight forward answer to this , you possibly should start
by stating your RT version, DB type(oracle,mysql ??) and version ,
apache, mod_perl or fastcgi etc ..
Also search the wiki and mailing list there are lots of posts and a good
article in the wiki covering
Varun;
You should make it a habit to reply to the list and not individuals , I
have never deployed RT with Oracle so can't help you --
few in the may though
ps: A pointer so you know what RT is capable of , our RT db is 50G in
size, the attachments table alone is 26G, our db server is quad
And can you can tell me what kind of maintainance you have done on
application side i.e RT side to enhance its performance and what kind of
tweaks you have applied in apache configuration file and
RT_SiteConfig.pm file
Thanks In Advance
Raed El-Hames wrote:
Varun;
You should make it a
There is no bother, what I meant is the list will be more helpful than me.
for tweaks and performance tuning the wiki and mailing list is better
place than me, because it varies depending on the database server you use.
Start with observation and detect your bottle necks , ist the web part
or
Hello
We have found two bugs in the SQL statements sent to the database
(RT-3.8.2 / postgreSQL 8.3.7).
1) The first one gives us the wrong result when generating the
statistics graph for a queue (grouped by Status).
The problem is that it used DISTINCT outside the aggregate function
count().
Hello all,
I have just updated by RT to 3.8.4 (Debian package), and while I am a
Firefox user, I have just seen that using MSIE 7 is getting an empty
response at certain times, such as when updating a ticket (Update.html).
Looking at the Apache error log shows Malformed multipart POST
Oh geeze, how did I miss the StrictLinkACL setting in RT_Config before
:/ Sorry folks! That defaults to 1, setting it to 0 should take care
of this issue for me.
___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
Community help:
On Jun 29, 2009, at 11:01 AM, Mike Harris wrote:
I found a previous post from lwebb from April or so, asking how to
permanently disable the WYSIWYG editor, and there weren't any
responses to him.
I too, would like to disable users from changing to the WYSIWYG
editor. I found the
I've noticed that in the tables that the ticket ID is not unsigned.
Is there a use for ticket IDs smaller than zero? I've adjusted the
schema for my system to use INT UNSIGNED for all of the ticket ID
fields. I'm needing a big ticket ID number for my purposes. I just
wonder if I'm going to be
I just sent an email about UNSIGNED INT for the database. This is a
separate (but related) question: Is there a reason why ticket IDs
can't be CHAR(32)? I'd love to use a proper UUID as a ticket ID.
If I convert a UUID from hex (base 16) to alphanumeric (case
sensitive: base 62; case
On Jun 29, 2009, at 2:53 PM, Wes Topping wrote:
I am not sure what is happening here. All I know is that if a user
in AD is created without a comma in the container name they log in
just fine. When someone that does have a comma in their CN name
tries to authenticate this is what
Its been in svn for years. Its finally made it onto cpan also
http://search.cpan.org/dist/RT-Extension-QuickCalls/
Ok, Cool. Ay yes. The SVN. Home to many magical things
sometimes, but not always mentioned elsewhere :-P
--
Cambridge Energy Alliance: Save money. Save the planet.
On 6/30/09 12:24 PM, Kevin Falcone falc...@bestpractical.com wrote:
On Jun 30, 2009, at 2:02 PM, Gary Greene wrote:
I've been trying to get Minerva using RT for a bit now, however I've
run
into a few feature requests that my users (read bosses) view as
blockers.
Does anyone know of a plug in
On Tue, Jun 30, 2009 at 03:06:17PM -0500, Dusty Wilson [Megagram] wrote:
I just sent an email about UNSIGNED INT for the database. This is a
separate (but related) question: Is there a reason why ticket IDs
can't be CHAR(32)? I'd love to use a proper UUID as a ticket ID.
That's going to
On Tue, Jun 30, 2009 at 4:28 PM, Jesse Vincentje...@bestpractical.com wrote:
On Tue, Jun 30, 2009 at 03:06:17PM -0500, Dusty Wilson [Megagram] wrote:
I just sent an email about UNSIGNED INT for the database. This is a
separate (but related) question: Is there a reason why ticket IDs
can't be
Are you aware of anywhere that the code does anything with that ticket
ID other than pass it around? I haven't yet (but haven't done deep
digging) seen it being used for anything other than in the queries
themselves and displayed on the web UI and emails. My change from
signed int(11) to
Kevin Gagel wrote, On 6/30/09 4:41 PM:
How can I make the subject field a mandatory field?
Write a BeforeCreate callback to validate that the subject meets your needs.
The callback routine needs to be placed in:
$RT_ROOT/local/html/Callbacks/$localtag/Ticket/Create.html/BeforeCreate
19 matches
Mail list logo