Re: [rt-users] Mysql upgrading to RT3.8 gives you garbled UTF8 text

2008-07-29 Thread Peter Eriksson
Hmm... I was just about to start an upgrade till RT 3.8.0 when I noticed these messages regarding these issues. Is there a complete list of what needs to be fixed to get it to work, or should one just wait for RT 3.8.1 to pop up? - Peter Mathieu Longtin wrote: So your patch for utf8 worked,

[rt-users] RT 3.8.0 Search build page real slow

2008-07-29 Thread Ask Holme
Hey List Lately (both before and after upgrade to 3.8.0) i'v been having problems with performance of the query builder. Overall RT runs quite fast, viewing of queues and tickets is fully acceptable and ticket updates is also fine. However, if i want to do a custom search and therefore opens a

Re: [rt-users] RT 3.8.0 Search build page real slow

2008-07-29 Thread Ask Holme
Iv solved the problem my self. Faulty rights on a specific queue caused the owner list to be quite long, which RT didn't like. (By mistake someone had given the own ticket right on the queue to all unprivileged users) Ask Holme wrote: Hey List Lately (both before and after upgrade to 3.8.0)

Re: [rt-users] Mysql upgrading to RT3.8 gives you garbled UTF8 text

2008-07-29 Thread Ruslan Zakirov
You can help test upgrade by using copy of your DB and RT from our repository. That would be really helpful. On Tue, Jul 29, 2008 at 12:59 PM, Peter Eriksson [EMAIL PROTECTED] wrote: Hmm... I was just about to start an upgrade till RT 3.8.0 when I noticed these messages regarding these

[rt-users] Autocomplete type Custom Fields in 3.8.0

2008-07-29 Thread BALINT Bekeny
Hi List, I have a question about how Enter one value with autocompletion type CFs work. I have created a Ticket CF with this type and also added some values for this but nothing happens if I start to type in the CF's input box. The apache log said: 10.8.0.10 - - [29/Jul/2008:11:16:35 +0200] POST

Re: [rt-users] Username at RT login not matching Ticket sent via e-mail

2008-07-29 Thread Drew Barnes
Try RT::Extension::MergeUsers (unless that has been merged into 3.8?) from CPAN. John Arends wrote: The fact that you have two accounts is the problem. An account can have a username and an email address so they can log in as 'bob' but have an email address of [EMAIL PROTECTED] I'm not

Re: [rt-users] Mysql upgrading to RT3.8 gives you garbled UTF8 text

2008-07-29 Thread Ask Holme
I'm having trouble with UTF8 text in 3.8.0 too. Ruslans patched fixed the special chars in queue names and ticket subjects. However when viewing tickets, UTF8 text in the email text is still wrong. But if i click reply/comment on the post, text is shown correctly in the editor (i'm using the

Re: [rt-users] Autocomplete type Custom Fields in 3.8.0

2008-07-29 Thread Kevin Falcone
On Jul 29, 2008, at 7:51 AM, BALINT Bekeny wrote: Hi List, I have a question about how Enter one value with autocompletion type CFs work. I have created a Ticket CF with this type and also added some values for this but nothing happens if I start to type in the CF's input box. The

[rt-users] Shrink CGM Table option?

2008-07-29 Thread Curtis Bruneau
Is there any way to get etc/upgrade/shrink_cgm_table.pl to do it's thing in pieces? I believe we have many rows in the cgm table and it's causing perl to take up to 2gb of memory eventually causing oom to invoke killing mysql or simply just crashing before it can. Thanks for your time, Curtis

[rt-users] configure failing?

2008-07-29 Thread John Arends
I'm trying to get an RT 3.8 machine up and running. ./configure --with-mysql --with-modperl2 does not appear to be doing anything, because when I run make install it does a dep check with --with-mysql --with-fastcgi, and then fails. ___

[rt-users] Forcing domains in email addresses

2008-07-29 Thread Mathieu Longtin
Is there a way to force email address entered to be [EMAIL PROTECTED] rather than accept just user? Also, in 3.8 (as opposed to 3.6), if you enter just user, the email is not sent, but no error message is given about it. Thanks -Mathieu ___

Re: [rt-users] configure failing?

2008-07-29 Thread Kevin Falcone
On Jul 29, 2008, at 10:22 AM, John Arends wrote: I'm trying to get an RT 3.8 machine up and running. ./configure --with-mysql --with-modperl2 does not appear to be doing anything, because when I run make install it does a dep check with --with-mysql --with-fastcgi, and then fails. John

[rt-users] Can't remove incorrect new ticket queue entry in dropdown

2008-07-29 Thread Kevin Freels
Greetings! RT 3.6.5 / FC8 I have a queue that only contains a couple people for confidential reasons (HR). I added the director of HR to be a watcher, and everything was fine; I had tested it, including logging in as her user. This was the second production queue I added to the system. Since

[rt-users] custom form for create ticket in a queue

2008-07-29 Thread Don Beethe
Has anyone used a form for creating a ticket in a particular queue? I have a group that wants to use our RT system (RT 3.6.3), but wants a form when a user selects create ticket... ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Re: [rt-users] Forcing domains in email addresses

2008-07-29 Thread Mathieu Longtin
Found the difference. RT3.6 use Mail::Address, RT3.8 uses Email::Address. The later just ignores strings without a @ in there. See example below. Regardless, I'd like to be able to just block any email address that have no domain. $ perl -MMail::Address -e 'print join(\n, map { $_-address

[rt-users] ExtractCustomFieldValues with attachments.

2008-07-29 Thread Roy Sowa
I am currently using RT 3.6.5 and ECFV 1.2.b3 I cannot get the extract to work if the MatchString is not in the first attachment. I have been using ECFV for a while on basic standard type email tickets, but now I have the requirement to extract the MatchString from an attachment. It does not

Re: [rt-users] ExtractCustomFieldValues with attachments.

2008-07-29 Thread Jean-Sebastien Morisset
The problem is with the FindMatch function. It only checks the first attachment. I overhauled this perl module quite a bit. Here's my version attached. Diff this one to yours to see the differences. :-) js. On Tue, Jul 29, 2008 at 01:01:49PM -0400, Roy Sowa wrote: I am currently using RT 3.6.5

Re: [rt-users] ExtractCustomFieldValues with attachments.

2008-07-29 Thread Roy Sowa
JS, There was/is a big diff between the two , so I copied your version over to test... Cleared the mason stop/started the web and repeated my tests... Works I will now go through the diffs and try an understand it all ;-) Many thanks for your quick help ( this list

Re: [rt-users] ExtractCustomFieldValues with attachments.

2008-07-29 Thread Roy Sowa
JS, I spoke too soon... The issue now is that I extract fine from the attachment, but now if the matchstring is in the first attachment it is not found... So I have put back the original file, and am back to not being able to extract from attachments .. So between the two files is the

Re: [rt-users] ExtractCustomFieldValues with attachments.

2008-07-29 Thread Jean-Sebastien Morisset
On Tue, Jul 29, 2008 at 03:22:15PM -0400, Roy Sowa wrote: JS, I spoke too soon... The issue now is that I extract fine from the attachment, but now if the matchstring is in the first attachment it is not found... What's the MIME Type of your first attachment? Line #100 might be skipping the

Re: [rt-users] Shrink CGM Table option?

2008-07-29 Thread Ruslan Zakirov
Try attached patch. On Tue, Jul 29, 2008 at 5:50 PM, Curtis Bruneau [EMAIL PROTECTED] wrote: Is there any way to get etc/upgrade/shrink_cgm_table.pl to do it's thing in pieces? I believe we have many rows in the cgm table and it's causing perl to take up to 2gb of memory eventually causing oom

Re: [rt-users] RT running slowly... Caused by RTx-Shredder

2008-07-29 Thread Ruslan Zakirov
It's know issue of mysql, here is reference to a description on request-tracker.ru site http://request-tracker.ru/node/65 (in russian) On Thu, May 29, 2008 at 1:14 AM, Boris Lytochkin [EMAIL PROTECTED] wrote: After adding this key: ALTER TABLE CachedGroupMembers Add KEY `SHREDDER_CGM1`

Re: [rt-users] RIP tickets

2008-07-29 Thread Ruslan Zakirov
Use rt-crontool utility. Look for help about its actions in archives and on the wiki. On Mon, May 26, 2008 at 9:09 PM, Dominic Lepiane [EMAIL PROTECTED] wrote: We don't want to remove the data from old tickets, so I don't think RTx::Shredder will work in our case. We could try moving old

Re: [rt-users] RT running slowly... Caused by RTx-Shredder indexes

2008-07-29 Thread Ruslan Zakirov
Known issue with mysql's optimizer. Either drop index or upgrade mysql to 5.0.45 and newer. Mysql 5.1.x have some optmiser issues as well. On Thu, May 22, 2008 at 10:08 AM, David Hobley [EMAIL PROTECTED] wrote: All, I ran an explain on the query in MySQL and noticed that it was using one of

Re: [rt-users] New install of RT 3.8.0 - Another Logo Issue

2008-07-29 Thread Greg Petras
I'm having a similar issue. I get the same exact error, after upgrading to 3.8.0 from 3.6.2. But, in my situation it comes up when I click the Statistics link. I don't see anything of use in rt.log, or Apache2's error_log. Anyone have ideas here? I searched the archives as well as the wiki and

Re: [rt-users] New install of RT 3.8.0 - Another Logo Issue

2008-07-29 Thread Greg Petras
I guess I didn't search hard enough (well, specifically I did not search rt-devel). Here's the solution to the problem: http://lists.bestpractical.com/pipermail/rt-devel/2008-July/009967.html Changed header_out to headers_out-add in /opt/rt3/share/html/dhandler and that problem went away. Greg

Re: [rt-users] Urgent help on multi-stage approvals

2008-07-29 Thread Hong Fai Leong
Dear Jesse, The setup only uses a single script and template. The setup works out of the box as described in RT Essentials. In the v3.6.3, the email to the director won't fire off until the manager approves his ticket. This was achieved using the Depends-On directive in the director's