[rt-users] RT 4.2 mysql/postgres migration

2013-12-18 Thread Matthias Peplow
Hi, I am curious if somebody already tried a mysql/postgres migration in RT 4.2. From what I read in the docs the intended way to accomplish this task is to dump the mysql database using the rt-serializer command and importing the dump using rt-importer to a new instance. In detail I would

Re: [rt-users] Reply text box slow to load

2013-12-18 Thread Marius Flage
On 12/17/2013 08:26 PM, Kevin Falcone wrote: While this confirms that something is taking a long time to load, the consistent 15 seconds on each request is quite odd, especially since larger files take mere milliseconds to download. Are you using JSMin? How is your RT configured, etc, etc.

[rt-users] RTIR for RT 4.2.x

2013-12-18 Thread Alex Young
I'm assuming that the current 3.0 version of RTIR isn't compatible with RT 4.2.x at the moment. When can we expect to see a release of RTIR compatible with the currently version of RT? Thanks.

[rt-users] RTIR for RT 4.2.x

2013-12-18 Thread Alex Young
I'm assuming that the current 3.0 version of RTIR isn't compatible with RT 4.2.x at the moment. When can we expect to see a release of RTIR compatible with the currently version of RT? Thanks.

Re: [rt-users] Excessive communication between RT and postgresql

2013-12-18 Thread Jacobsson, Henrik G
We upgraded from 4.0.17. Yes. Stopping RT stopped the WAL generation. Continued as if nothing happened when started up again. The mail into the system should be quite negligible in this case since that would make the database grow in roughly the same pace as the WAL log generation, but the

Re: [rt-users] RTIR for RT 4.2.x

2013-12-18 Thread Kevin Falcone
On Wed, Dec 18, 2013 at 11:14:50AM +, Alex Young wrote: I'm assuming that the current 3.0 version of RTIR isn't compatible with RT 4.2.x at the moment. When can we expect to see a release of RTIR compatible with the currently version of RT? This is now the third time you've sent this

[rt-users] Owner mail on login page.

2013-12-18 Thread Albert Shih
Hi all, I would like to known how can I disable the Owner mail on login page (new in 4.2.x) It's very important for us because with this information 50% of the user going to send a email directly to this address. Regards. JAS -- Albert SHIH DIO bâtiment 15 Observatoire de Paris 5 Place

[rt-users] RT 4.2.1 problem with Preference

2013-12-18 Thread Albert Shih
Hi, I got a bug with preferences pages. When I go into (I have all right) I got this message on the web interface : General Default queue Remember default queue Yes No Use default (No) Username format Use autocomplete to find owners? Yes No Use default (No) Replaces the

Re: [rt-users] any page showing a user drop down in a ticket is loading slow

2013-12-18 Thread Kevin Falcone
On Tue, Dec 17, 2013 at 02:53:53PM -0500, Adam Hobaugh wrote: I just updated from 4.0.10 to 4.2.1 and it seems to be working well except when I am in a ticket, any page that shows a user drop down, ie display and people load incredible slowly. I enabled slow query logging and below are the two

Re: [rt-users] ExecuteCode by Queue AdminCc groups on RT::System

2013-12-18 Thread Kevin Falcone
On Tue, Dec 17, 2013 at 11:00:35PM +0100, Kai Storbeck wrote: My production system contains a few ACL's that do not dump correctly using rt-dump-metadata. They end up multiple times in our dump as: { Right : ExecuteCode, GroupDomain : RT::System-Role,

Re: [rt-users] installing rt tracker with a screen reader

2013-12-18 Thread Kevin Falcone
On Wed, Dec 18, 2013 at 03:54:23PM -0800, Marvin Hunkin wrote: And using this software. And using the jaws for windows screen reader from [1]http://www.freedomscientific.com Now. How do I install this software and then configure. Using windows 7 pro 32 bit, firefox

Re: [rt-users] rt 4.2.1 error: Internal Server Error

2013-12-18 Thread Kevin Falcone
On Wed, Dec 18, 2013 at 02:15:05AM -0500, supp...@pureview.com wrote: Any one can help me to find the issues here. RH6 Oracle as DB fastcgi Does RT_Config.pm exist in /opt/rt4/etc Is it readable by the web user (su to the web user and try to read it) Do you have anything like SELinux which

Re: [rt-users] Chart and Show Results not showing correct query

2013-12-18 Thread Kevin Falcone
On Tue, Dec 17, 2013 at 09:12:17PM +, Richard McMahon wrote: I have been using the Chart option in RT 3.8. When I click on Show Results a different query is shown e.g. the most recent other saved query. RT 3.8 is no longer receiving anything other than security bugfixes. You also don't

Re: [rt-users] How to create a new condition through the web gui

2013-12-18 Thread Kevin Falcone
On Tue, Dec 17, 2013 at 10:49:49PM +0100, Marius Flage wrote: Den 17.12.2013 20:19, skrev Kevin Falcone: You may find it easier to use the new extension we blogged about, instead of User Defined scrips/actions

Re: [rt-users] RT 4.2 mysql/postgres migration

2013-12-18 Thread Kevin Falcone
On Wed, Dec 18, 2013 at 09:03:37AM +0100, Matthias Peplow wrote: Hi, I am curious if somebody already tried a mysql/postgres migration in RT 4.2. From what I read in the docs the intended way to accomplish this task is to dump the mysql database using the rt-serializer command and

Re: [rt-users] RT 4.2.1 problem with Preference

2013-12-18 Thread Albert Shih
Le 18/12/2013 à 17:29:07+0100, Albert Shih a écrit Hi, I got a bug with preferences pages. When I go into (I have all right) I got this message on the web interface : General Default queue Remember default queue Yes No Use default (No) Username format Use

Re: [rt-users] any page showing a user drop down in a ticket is loading slow

2013-12-18 Thread Adam Hobaugh
On 12/18/2013 11:43 AM, Kevin Falcone wrote: On Tue, Dec 17, 2013 at 02:53:53PM -0500, Adam Hobaugh wrote: I just updated from 4.0.10 to 4.2.1 and it seems to be working well except when I am in a ticket, any page that shows a user drop down, ie display and people load incredible slowly. I

Re: [rt-users] any page showing a user drop down in a ticket is loading slow

2013-12-18 Thread Kevin Falcone
On Wed, Dec 18, 2013 at 12:29:05PM -0500, Adam Hobaugh wrote: The slow query logs are most helpful when you then run EXPLAIN on the query so you know why the database is having trouble. Here is the EXPLAIN for the two queries. mysql EXPLAIN SELECT DISTINCT main.* FROM Users main CROSS JOIN

Re: [rt-users] any page showing a user drop down in a ticket is loading slow

2013-12-18 Thread Landon Stewart
On 18 December 2013 10:07, Kevin Falcone falc...@bestpractical.com wrote: Can you download and run http://mysqltuner.pl on your database. Fun tip. You can download that with just “wget mysqltuner.pl”. There’s some redirection magic that makes it work with just that command. -- Landon

[rt-users] RT-Extension-Assets link

2013-12-18 Thread JZ
I am trying to figure out the best way to get a link created to an asset at the time a ticket is created. I am using RT-Extension-Assets in RT 4.2, and am having trouble finding information regarding this extension and doing what I want to do. I am having trouble making the connection from

Re: [rt-users] any page showing a user drop down in a ticket is loading slow

2013-12-18 Thread Adam Hobaugh
On 12/18/2013 01:07 PM, Kevin Falcone wrote: Your query here says that MySQL is looking at a pretty tiny dataset and running the same query on multiple databases here shows a wildly different explain and very quick results. This usually points to you having some enormous tables (although the

Re: [rt-users] Owner mail on login page.

2013-12-18 Thread Kevin Falcone
On Wed, Dec 18, 2013 at 05:19:16PM +0100, Albert Shih wrote: I would like to known how can I disable the Owner mail on login page (new in 4.2.x) It's very important for us because with this information 50% of the user going to send a email directly to this address. Hide it with css (the div

Re: [rt-users] any page showing a user drop down in a ticket is loading slow

2013-12-18 Thread Kevin Falcone
On Wed, Dec 18, 2013 at 02:15:06PM -0500, Adam Hobaugh wrote: On 12/18/2013 01:07 PM, Kevin Falcone wrote: Your query here says that MySQL is looking at a pretty tiny dataset and running the same query on multiple databases here shows a wildly different explain and very quick results. This

[rt-users] RT 4.2 Segfaults on FreeBSD 9.2

2013-12-18 Thread Tim Gustafson
I've upgraded from RT 4.0.16 to 4.2 on a FreeBSD 9.2 system. I'm using Perl 5.16.3. When I try to start Apache, it segfaults with the following information in /var/log/httpd-error.log: [Tue Dec 17 11:42:38 2013] [error] [client 128.114.49.22] Can't locate RT/Action/SendEmail.pm in @INC (you may

Re: [rt-users] RT 4.2 Segfaults on FreeBSD 9.2

2013-12-18 Thread Tim Gustafson
Can you show what’s in /etc/make.conf? WRKDIRPREFIX=/var/ports DISTDIR=/var/ports/distfiles PACKAGES=/var/ports/packages Perl 5.16 should be the default. http://svnweb.freebsd.org/ports/head/Mk/bsd.default-versions.mk?view=log Where did your modules come from? I installed everything from

Re: [rt-users] RT 4.2 Segfaults on FreeBSD 9.2

2013-12-18 Thread Rainer Duffner
Why is RT looking for them in a non-existant 5.18 folder? Should I just create a symlink for now to get past this? Can you show what’s in /etc/make.conf ? Perl 5.16 should be the default. http://svnweb.freebsd.org/ports/head/Mk/bsd.default-versions.mk?view=log Where did your modules

Re: [rt-users] RT 4.2 Segfaults on FreeBSD 9.2

2013-12-18 Thread Rainer Duffner
Am 19.12.2013 um 00:38 schrieb Tim Gustafson t...@ucsc.edu: Can you show what’s in /etc/make.conf? WRKDIRPREFIX=/var/ports DISTDIR=/var/ports/distfiles PACKAGES=/var/ports/packages So, it’s a jail. Did you actually install perl? pkg_info |grep ^perl or pkg info |grep ^perl (in case

Re: [rt-users] RT 4.2 Segfaults on FreeBSD 9.2

2013-12-18 Thread Tim Gustafson
So, it’s a jail. Yes, sorry, I forgot to mention that. Did you actually install perl? Of course, it's a dependency of RT: r...@rt-dev.soe.ucsc.edu: pkg_info |grep ^perl perl5-5.16.3_4 Practical Extraction and Report Language But it’s OK, if reproducibility is not an issue. For what

Re: [rt-users] RT 4.2 Segfaults on FreeBSD 9.2

2013-12-18 Thread Rainer Duffner
Am 19.12.2013 um 01:00 schrieb Tim Gustafson t...@ucsc.edu: So, it’s a jail. Yes, sorry, I forgot to mention that. Did you actually install perl? Of course, it's a dependency of RT: r...@rt-dev.soe.ucsc.edu: pkg_info |grep ^perl perl5-5.16.3_4 Practical Extraction and Report

Re: [rt-users] RT 4.2 Segfaults on FreeBSD 9.2

2013-12-18 Thread Rainer Duffner
Do you actually have a 5.18 site_perl directory? Ah, sorry. You answered that before. I missed it. Something thinks you have perl 5.18. Is the perl outside the jail also 5.16?

Re: [rt-users] RT 4.2 Segfaults on FreeBSD 9.2

2013-12-18 Thread Tim Gustafson
Something thinks you have perl 5.18. Is the perl outside the jail also 5.16? I believe its 5.16, but what difference should that make? The jail has no access to view any aspect of the root system. -- Tim Gustafson t...@ucsc.edu 831-459-5354 Baskin Engineering, Room 313A