Re: [rt-users] Graphviz anti-aliased output?

2008-08-25 Thread Ruslan Zakirov
On Mon, Aug 25, 2008 at 8:56 AM, Aaron Hathaway [EMAIL PROTECTED] wrote: Message: 2 Date: Sun, 24 Aug 2008 16:54:30 +1000 From: [EMAIL PROTECTED] (Trent W. Buck) Subject: Re: [rt-users] Graphviz anti-aliased output? To: [EMAIL PROTECTED] Message-ID: [EMAIL PROTECTED] Content-Type:

Re: [rt-users] 0 results after corrupt sessions table, myisamchk

2008-08-25 Thread Ruslan Zakirov
Most of RT's table MUST use InnoDB engine to work correctly. I'm not sure what's going on but I have feeling that you've disabled innodb and mysql went wild after that. On Mon, Aug 25, 2008 at 6:40 AM, Peter Nikolaidis [EMAIL PROTECTED] wrote: Additional info: After a short while, I observed

[rt-users] Slow GET_LOCK queries on merged tickets

2008-08-25 Thread Hoogstraten, Ton
Hi all, I managed to track down a problem with merged tickets being slow to display. I have enabled the slow queries log on Mysql (5.0.51a) and get the following in the log files. I searched over the RT list archives and I found note of setting low_priority_updates to 1 on mysql for this. This

Re: [rt-users] 3.8.1 issues, not displaying page

2008-08-25 Thread andrew fay
scratch that... got that monday morning feeling ;) use rtdb; From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Date: Mon, 25 Aug 2008 08:04:29 + CC: rt-users@lists.bestpractical.com Subject: Re: [rt-users] 3.8.1 issues, not displaying page Hi, When i use this command it says error

[rt-users] 3.6.4 - 3.8.1 db corrupting attachments

2008-08-25 Thread andrew fay
Hi, So I installed a fresh copy of 3.8.1.. copied the db over from 3.6.4 and upgraded, Now the attachements are corrupted.. any fix for this? Thanks, Andy _ Make a mini you on Windows Live Messenger!

[rt-users] RT 3.8.1 web interface

2008-08-25 Thread Nick Price
HiI'm having a few problems with the web interface of rt-3.8.1 on a new install of fedora 9 including all the latest updatesIn firefox on the localhost RT will run as follows http://localhost or http://localhost/rt both take me to RT login pageOn a remote PC if I try to connect to RT

Re: [rt-users] 3.6.4 - 3.8.1 db corrupting attachments

2008-08-25 Thread Knaupp, Thomas
I had the same problem when I did a direct upgrade from 3.6.x to 3.8.1 ... It worked for me this way: - upgrade to 3.8.0 - applying the mysql-4.0-41 update - upgrade from 3.8.0 to 3.8.1 ... Regards, Tom From: [EMAIL PROTECTED] [mailto:[EMAIL

Re: [rt-users] 3.8.1 issues, not displaying page

2008-08-25 Thread Sebastien Termeau
Andrew, If you are upgrading, even if you are not using Mysql 4.0, you should follow the UPGRADING.mysql procedure. This procedure produce an sql file that includes David suggestion. Regards Sebastien On Fri, Aug 22, 2008 at 5:31 PM, David Svejda [EMAIL PROTECTED] wrote: andrew fay wrote: Hi,

Re: [rt-users] 0 results after corrupt sessions table, myisamchk

2008-08-25 Thread Peter Nikolaidis
Ruslan Zakirov wrote: Most of RT's table MUST use InnoDB engine to work correctly. I'm not sure what's going on but I have feeling that you've disabled innodb and mysql went wild after that. Hi Ruslan, To my knowledge, we've never used InnoDB on this system. We upgraded to 3.6.6 months ago,

Re: [rt-users] 0 results after corrupt sessions table, myisamchk

2008-08-25 Thread Tim Cutts
On 25 Aug 2008, at 7:37 am, Peter Nikolaidis wrote: Ruslan Zakirov wrote: Most of RT's table MUST use InnoDB engine to work correctly. I'm not sure what's going on but I have feeling that you've disabled innodb and mysql went wild after that. Hi Ruslan, To my knowledge, we've never used

Re: [rt-users] A header line which makes RT not re-open tickets?

2008-08-25 Thread Jesse Vincent
You want to look at RT::Action::AutoOpen. Particularly, you're looking for a line like this: return undef if ($msg-GetHeader('RT-Control') || '') =~ / \bno-autoopen\b/i; On Aug 25, 2008, at 4:35 AM, Richard Hartmann wrote: Hi all, is there any header line I could add that would

[rt-users] SOLVED 0 results after corrupt sessions table, myisamchk

2008-08-25 Thread Peter Nikolaidis
Problem solved. I wrote a loop to go through and convert all of my tables to InnoDB. It choked on the Tickets table, so I ran a myisamchk -r Tickets on it, which repaired 7 indexes. I was then able to successfully convert it to InnoDB along with the rest of the tables. Oh Happy Day! It's

Re: [rt-users] Search order by custom field

2008-08-25 Thread Jesse Vincent
On Aug 22, 2008, at 9:16 PM, scott smith wrote: scott smith wrote: I'm having trouble saving a search ordered by custom field. I have to manually change the URL to fix the order, since the GET param is not set FWIW, I saved the html, put it in docroot/Search/Build2.html and modified the

[rt-users] rt 3.8.0 - Problem with AutoEmailAfterComment

2008-08-25 Thread SINN Andreas
Hi all! I want to create a script to notificate the owner after adding a new comment, but I don't know why it does work. The log file says all the time No recipients found. Not sending. Can someone help me please? Thanks. BR Andreas ___

Re: [rt-users] Creating users using CLI: assigning to a group?

2008-08-25 Thread Stephen Turner
On Fri, 22 Aug 2008 01:36:02 -0400, Graham Ballantyne [EMAIL PROTECTED] wrote: I'm working on a script to create users in RT based on a list of usernames. I need to add these users to an RT group upon creation. I can do it by doing an INSERT into the GroupMembers table, but I'm wondering if

[rt-users] Lost Links after Upgrade 3.6.7 - 3.8.1

2008-08-25 Thread Knaupp, Thomas
Hello List, after upgrading rt 3.6.7 to 3.8.1, all links ( Depends on / Parents / Refers to / etc.) seem to be lost : / Suggestions? Anyone who knows a solution for this? Regards, Tom ___

Re: [rt-users] A header line which makes RT not re-open tickets?

2008-08-25 Thread Richard Hartmann
On Mon, Aug 25, 2008 at 14:18, Jesse Vincent [EMAIL PROTECTED] wrote: return undef if ($msg-GetHeader('RT-Control') || '') =~ /\bno-autoopen\b/i; Perfect, thanks. Richard ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Re: [rt-users] Forking a ticket

2008-08-25 Thread Roedel, Mark
I do really like the built-in capability to create a related ticket, but Dirk's patchset adds a couple of things to it that have been really valuable to us: (1) The newly created ticket is preloaded with the contents of a particular transaction, and (2) You get to choose which queue the new

[rt-users] Forwarding of a complete ticket?

2008-08-25 Thread Richard Hartmann
Hi all, I was wondering if there is a way to forward a complete ticket, with or without comments. Thanks, Richard ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support:

[rt-users] RFC: Dashboard upgrades

2008-08-25 Thread Richard Hartmann
Hi all, yet another RFC which I might turn into wishlist items. 1) Should it be possible to order messages by read/unread messages within said ticket? 2) Should it be possible to bolden/color/whatever the values of certain fields and/or whole lines depending on user-defined rules? 3) Who else

Re: [rt-users] AT links gone in 3.8.1

2008-08-25 Thread Todd Chapman
I think that component was refactored in 3.8. Anyone have time to submit a patch for AT that fixes this? On Mon, Aug 25, 2008 at 10:04 AM, JOHN ROMAN [EMAIL PROTECTED] wrote: going from 3.5.4 to 3.8.1 ive lost the area in tickets pertaining to AT links. any ideas?

[rt-users] Moving attachments from DB to disk...

2008-08-25 Thread Jean-Sebastien Morisset
Hi everyone, I'm sure I've seen this somewhere, but can't find it in the Wiki, google, etc. Does anyone know of a script or something to move attachments out of the DB and onto local disk? Thanks, js. -- Jean-Sebastien Morisset, Sr. UNIX Administrator [EMAIL PROTECTED]

Re: [rt-users] Moving attachments from DB to disk...

2008-08-25 Thread Jerrad Pierce
Alas, no. When I last I asked I was told it was a design feature. But it does seem mighty useful, as it would allow for OCR and indexing of attachments. I'd planned on attempting this once I got the more important parts of our setup functional. P.S. Grr reply-to one P.P.S s/disk/fs/ --

[rt-users] FW: RT 3.8.1 web interface

2008-08-25 Thread Nick Price
Hi I tried the config below It still starts at http://localhost and http://localhost/rtbut now only in text mode I’m not a programmer so finding this config hard going Any ideas please Cheers Nick From: andrew fay [mailto:[EMAIL PROTECTED] Sent: Monday, August 25,

[rt-users] Query Builder - Need to know whenever a ticket has been updated, commented, or resolved, in sense a COUNT.

2008-08-25 Thread cavemancanada
Is there a way, and what would the syntax be to build a query that will output how many times a particular ticket was updated, commented, and or resolved? In a sense to find out how many comments were added to a particular ticket. Here is a sample query I was running in order to gather the

Re: [rt-users] Design/usage question

2008-08-25 Thread Roedel, Mark
Have you looked at creating a list of Reminders in the ticket? We use them as a way of creating a checklist to track multi-task processes (for example, all the things that need to be done to activate a new employee - various system accounts, long distance calling PIN, etc.) within a single

[rt-users] Upgrade from 3.0.11 to 3.4.6

2008-08-25 Thread Dawid Trojanowski
Ok I had been given a task to update the Request Tracker, the problem is the older version is 3.0.11 and the person who managed it left without any information so I had to analyze as much as possible. Here is the information: Old RT system; Debian (no clue what version) Apache 1.3

Re: [rt-users] Upgrade from 3.0.11 to 3.4.6

2008-08-25 Thread chaim . rieger
I've seen that error, try reinstalling scalar utils. Sent via BlackBerry from T-Mobile -Original Message- From: Dawid Trojanowski [EMAIL PROTECTED] Date: Mon, 25 Aug 2008 10:37:00 To: rt-users@lists.bestpractical.com Subject: [rt-users] Upgrade from 3.0.11 to 3.4.6

Re: [rt-users] Upgrade from 3.0.11 to 3.4.6

2008-08-25 Thread Jesse Vincent
On Aug 25, 2008, at 10:37 AM, Dawid Trojanowski wrote: Ok I had been given a task to update the Request Tracker, the problem is the older version is 3.0.11 and the person who managed it left without any information so I had to analyze as much as possible. Here is the information: Old RT

Re: [rt-users] Design/usage question

2008-08-25 Thread Jerrad Pierce
On Mon, Aug 25, 2008 at 10:59, Roedel, Mark [EMAIL PROTECTED] wrote: Have you looked at creating a list of Reminders in the ticket? We use them as a way of creating a checklist to track multi-task processes (for example, all the things that need to be done to activate a new employee –

[rt-users] Unpriveleged users questions

2008-08-25 Thread Jerrad Pierce
Why do users seem to only have even ids? Is there a more convenient way of listing or finding an unprivileged user, other than incrementing id in https://rt.cambenergy.org/Admin/Users/Modify.html?id=36 ? Last I read in the archives, the answer was unfortunately no. by design Why does the user id

Re: [rt-users] Ticket history template not working since upgrade to RT 3.8.0

2008-08-25 Thread Shannon Adams
I upgraded to 3.8.1 this weekend and we still cannot see a complete ticket history when a ticket is closed using the template below. Is there updated code I can use in this template that will list the complete ticket history - all comments and replies? Thanks, Shannon - Original

Re: [rt-users] Access tickets and receive replies without web access

2008-08-25 Thread Asif Iqbal
I am using RT 3.4.5 On Mon, Aug 25, 2008 at 11:59 AM, Asif Iqbal [EMAIL PROTECTED] wrote: Hi I won't have access to our ticket system through web for next about a month. I am looking for a way to receive all the replies that a new ticket generates for the requestor short of continuosly

[rt-users] Other RT re-opening tickets we close in our RT...

2008-08-25 Thread Rainer Duffner
Hi, I found we have a vendor that also uses RT. We had a ticket open with them, which got opened when they mailed a password to one of our RT-maintained email-addresses and created an autoreply which triggered an autoreply from their RT. Now, whenever I close the ticket, I get it re-opened

Re: [rt-users] Design/usage question

2008-08-25 Thread Gene LeDuc
Hi Jerrad, I used a custom field to emulate custom states for a process that required a ticket to change queues several times. A certain request comes in to the security office and they create a ticket in their queue. A scrip immediately moves the ticket into the network queue where it

Re: [rt-users] Other RT re-opening tickets we close in our RT...

2008-08-25 Thread Jerrad Pierce
In RT_Config.pm =item C$ExtractSubjectTagMatch, C$ExtractSubjectTagNoMatch The default extract remote tracking tags scrip settings; these detect when your RT is talking to another RT, and adjusts the subject accordingly. =cut Set($ExtractSubjectTagMatch, qr/\[.+? #\d+\]/);

Re: [rt-users] Design/usage question

2008-08-25 Thread Kenneth Crocker
Jerrad, Like Gene, we use a CF for this, but also created some new Ticket Status values to work in conjunction as well. Our process goes something like this: 1) New ticket created; automatically set CF Work-Status value to Requested. 2) New ticket is reviewed; we

Re: [rt-users] Design/usage question

2008-08-25 Thread Jerrad Pierce
Actually adding another CF might not be much of an issue, as I realized that many of our CFs are actually for information tied to the user and not the job per se. Plus, these fields (like phone and address) already exist for user objects. Alas, this also means my web client has to have ModifyUsers

[rt-users] After upgrade to 3.8.1, can't view ticket details

2008-08-25 Thread Adam Engel
Hey all, CentOS 4.5 RequestTracker 3.8.1 Apache 1.3.37 I upgraded our installation from 3.6.3 to 3.8.1 over the weekend after the users had tested it for about a week. The upgrade went without a hitch, but now the users are coming to me with a major problem: If a user clicks on a queue,

Re: [rt-users] Graphviz anti-aliased output?

2008-08-25 Thread Aaron Hathaway
-Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Ruslan Zakirov Sent: Sunday, August 24, 2008 11:25 PM To: Aaron Hathaway Cc: rt-users@lists.bestpractical.com Subject: Re: [rt-users] Graphviz anti-aliased output? On Mon, Aug 25, 2008 at 8:56 AM,

Re: [rt-users] Ticket history template not working since upgrade to RT 3.8.0

2008-08-25 Thread Shannon Adams
I turned on debugging and I keep getting the follow error in the log: [Mon Aug 25 18:06:21 2008] [error]: Scrip 226 IsApplicable failed: Global symbol $correspond requires explicit package name at (eval 477) line 8. (/opt/rt3/bin/../lib/RT/Condition/UserDefined.pm:64) Can translate this for me

Re: [rt-users] After upgrade to 3.8.1, can't view ticket details

2008-08-25 Thread Adam Engel
I would like to make an addition to this I looked in the rt-error_log file and found a lot of OOM errors. The server has at least 400MB of swap left. I guess Ill try increasing the memory within VMWare. Maybe Apache is running out of available memory Out of memory! Callback called

Re: [rt-users] Graphviz anti-aliased output?

2008-08-25 Thread Ruslan Zakirov
It's not a limitation of the module. Try print $graph-as_text and you'll see that it's has nothing specific that turn of anti-aliasing. Tested with sample from the module using: t.pl res.png t_with_as_text.pl | dot -Tpng res_via_dot.png Both images are anti-aliased. On Mon, Aug 25, 2008 at

[rt-users] gpg: bad passphrase in apache error logs

2008-08-25 Thread Charlie Reddington
I'm thinking that my gpg errors are all stemming from the fact that RT is may be reading my configs wrong. I'm not 100% yet but that's what my first thought is after staring at this for 2 days now. I'm getting this in my apache error logs [Mon Aug 25 20:50:28 2008] [info]:

[rt-users] Automatic Ticket Assignment upon Ticket Creation in Queue X

2008-08-25 Thread Russ Penar
The basic idea is, whenever a ticket is created in queue x the ticket is automatically assigned to xAdmin. Has anyone found this is possible? If so, do you have any details to share? Regards, Russ ___

Re: [rt-users] Forking a ticket

2008-08-25 Thread David Sitsky
Roedel, Mark wrote: I do really like the built-in capability to create a related ticket, but Dirk's patchset adds a couple of things to it that have been really valuable to us: (1) The newly created ticket is preloaded with the contents of a particular transaction, and This is really