Re: [rt-users] What's huge RT/Mysql

[Arkadiusz Miśkiewicz]

On Wednesday 11 of November 2015, Daniel Schwager wrote:
> Hi JAS,
> 
> > For normal usage it works fast. The number of tickets is only a problem
> > for searching. Here we still use sphinx and searching is quite slow.
> 
> ..
> 
> > Going to try mysql builtin fulltext next (that won't fix session problem
> > but has potential to be faster).
> 
> Currently, we are going to setup a system with sphinx & mysql 5.6 because
> of the sphinx-fulltext search feature.
> 
> So, do you think mysql-5.7 with enabled mysql-fulltext feature is faster?

Why 5.7? For 5.7 is to early to use in production IMO.

I plan to go with 5.6 + fulltext. I didn't do any measures yet but it should 
be on par with sphinx I think. The main advantage of mysql fulltext is that 
there is no gap between ticket coming into system and sphinx indexer being 
run. 

> Can RT use the builtin mysql fulltext search by default without any
> changes?

It can in recent versions.

sphinx is considered deprecated I think (and buggy; doesn't make proper sql 
queries because mysql optimization engine is allowed to optimize these in such 
way that breaks sphinx way of working).

> Best regards
> Danny


-- 
Arkadiusz Miśkiewicz, arekm / ( maven.pl | pld-linux.org )

Re: [rt-users] What's huge RT/Mysql

[Arkadiusz Miśkiewicz]

On Wednesday 04 of November 2015, Albert Shih wrote:
> Hi everyone,
> 
> I would like to know without any customisation how can a RT instance with
> mysql backend can goes.

Almost 2 000 000 tickets here (total), mysql DB is about 120GB, two rotational 
SATA disks in raid1 array.

> As I understand it's the number of tickets who can be a issue.

For normal usage it works fast. The number of tickets is only a problem for 
searching. Here we still use sphinx and searching is quite slow.

The other problem is that any action like searching blocks rt user session 
totally. So single user can't, for example, view other tickets in second 
browser tab while his search is in progress. That's major pain if you do a lot 
of searching.

Going to try mysql builtin fulltext next (that won't fix session problem but 
has potential to be faster).

Also for big mysql DB you need to plan backup well.

> And same question with specific hardware (like mysql on SSD).

IMO SSD is not required. Obviously will be much faster than rotational disks 
but our instance works well without ssd disks.

> 
> Regards.
> 
> JAS
> --
> Albert SHIH

-- 
Arkadiusz Miśkiewicz, arekm / ( maven.pl | pld-linux.org )

Re: [rt-users] What's huge RT/Mysql

[Daniel Schwager]

Hi JAS,

> For normal usage it works fast. The number of tickets is only a problem for
> searching. Here we still use sphinx and searching is quite slow.
..
> Going to try mysql builtin fulltext next (that won't fix session problem but
> has potential to be faster).

Currently, we are going to setup a system with sphinx & mysql 5.6 because of
the sphinx-fulltext search feature.

So, do you think mysql-5.7 with enabled mysql-fulltext feature is faster? 
Can RT use the builtin mysql fulltext search by default without any changes?

Best regards
Danny


smime.p7s
Description: S/MIME cryptographic signature

[rt-users] Owner Query - Custom

[Marcelo Calado | TBS TAX Services]

Hi,

I want to change (if possible) settings, under Permissions , modify the 
permissions that are allowed or denied for only the RT User's   to be Owner's 
when I create a new ticket or modify?

The Watcher's can't be Owner!

Is it possible?

Thank you!

Marcelo Calado.



-Original Message-
From: Matt Zagrabelny [mailto:mzagr...@d.umn.edu] 
Sent: Tuesday, November 10, 2015 4:38 PM
To: Marcelo Calado | TBS TAX Services 
Cc: rt-users 
Subject: Re: [rt-users] Owner Query - Custom

Hi Marcelo,

On Tue, Nov 10, 2015 at 8:42 AM, Marcelo Calado | TBS TAX Services 
 wrote:
> Hello!
>
>
>
> When I trying to create a ticket on RT 4.09, I’d like to select just 
> the RT User’s of Owner field on the basics table in the right side.
>
>
>
> I’d like to select only the RT User’s on my Owner Query! Is it 
> Possible? How Can I do this? I can’t see the Watcher’s!

I don't quite understand your question. Do you think you could rephrase it or 
write it out differently?

Cheers,

-m

Re: [rt-users] Unable to create scrips in RT 4.2.12

[Parish, Brent]

Awesome idea -- thanks, Chris!  



-Original Message-
From: Christian Loos [mailto:cl...@netcologne.de] 
Sent: Wednesday, November 11, 2015 1:33 AM
To: Parish, Brent; David Ramage; rt-users@lists.bestpractical.com
Subject: Re: Unable to create scrips in RT 4.2.12

Hi Brent,

you should give Callbacks [1] a chance.
We use this for years. Minor (4.2.11 > 4.2.12) version updates are done without 
any modification. Sometimes even major (4.2.12 > 4.4.0) updates can be make 
without changing a callback file.

Chris

[1]
https://urldefense.proofpoint.com/v2/url?u=https-3A__www.bestpractical.com_docs_rt_4.2_writing-5Fextensions.html-23Callbacks=CwID-g=VCWpAYkS3z1bOCIxc-BPGZarCq9MRCAVxZJE051VqH8=luSRdPePk6fhFa3rH2PFBzWEtgcJguY0a__6vpfaX-I=McuUaLqBVdmZULlQOCtTdy-4eKG1SF68GCtyYZn8kEU=_59KjpgZJcA4mJMDI7cIiDyOEDdhVc2aaiW-8M8CwmA=
 

Am 11.11.2015 um 03:53 schrieb Parish, Brent:
> Good catch!
> 
>  
> 
> I'm sure other people have better ways to do this, but this is what 
> works for me in our environment:
> 
>  
> 
> First I copy the original RT file into the local/  directory tree (per 
> standard RT modification practices).
> 
> But I make two copies there - one is named with a ".orig" file extension.
> 
>   e.g.
> 
> Tabs
> 
>  Tabs.orig
> 
>  
> 
> The .orig file is a copy of the original Tabs file (at the time I 
> modified it, lets say version 4.0.9.
> 
> After I run an upgrade (e,g, to 4.2.12), I first do a 'diff' on the 
> Tabs.orig (remember, that is 4.0.9) against the new Tabs (4.2.12).
> 
> If the files are the same (no changes in the new version of RT), I 
> keep my changed Tabs file as-is.
> 
> If there are changes in the new rev, I must manually merge my changes 
> into it.
> 
> (and then copy the new version (original) as the new Tabs.orig, ready 
> for the next upgrade).
> 
>  
> 
> A nice side effect of this is that I can run a 'find' command after 
> each upgrade for *.orig, to ensure I am merging all code changes.
> 
>  
> 
> Just my 2 cents.
> 
> -  Brent
> 

[rt-users] Mails not sended

[Sternberger, Sven]

Hello!

I have again the problem that RT from time to time has problems to send mails.
But in the logs I have a new error message 

Scrip Prepare 158 died. - panic: attempt to copy freed scalar 7f89fe68dc08 to 
7f8a641ca550 at /usr/local/share/perl/5.18.2/Devel/StackTrace.pm line 59

any ideas?

METADATA:
rt 4.2.11
Ubuntu 14.04
apache/mod_perl2

Sven Sternberger
System Engineer
Tel.: 040/8998-4397
DESY IT

[rt-users] RT 4.2 + RTIR 3.2 - Incident - Resolve entry comments disappear after submitting

[jotenko]

Good evening.

I have a weird problem when resolving an Incident.

I go to Actions > Resolve.

Then, under the message body, I write whatever I want, like "Closing this
case". Then I click on Update Incident, and it is in fact closed.

However, the text I wrote in the case closure action ("Closing this case")
won't appear in the History of the incident. The only thing appearing is
"Status changed from 'open' to 'resolved'". I have to add a comment later,
to workaround this.

No errors in logs.

Thanks.
Joao



--
View this message in context: 
http://requesttracker.8502.n7.nabble.com/RT-4-2-RTIR-3-2-Incident-Resolve-entry-comments-disappear-after-submitting-tp60911.html
Sent from the Request Tracker - User mailing list archive at Nabble.com.