[rt-users] Best method to authenticate with AD

2008-08-25 Thread Gerrit Kilian
Hi I need to let RT authenticate users through AD. We have a number of levels in our AD structure to separate users on geographical and departmental reasons. On the best practice website I have read that there are three ways: 1. Apache Authentication 2. Mike Peachey's RT:Authen

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

[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 ___ http://lists.bestpractical.com/cgi-bin/mailman

[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]: > #46/454 - S

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

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] 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 m

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

[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, the

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

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 c

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+\]/); Set($ExtractSub

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 prompt

[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 again

Re: [rt-users] Is there a howto on setting up GPG w/ RT-3.8.0?

2008-08-25 Thread Charlie Reddington
Okay I have some progress but more questions. When I use only this line for my GPG options I get the options in my queue to 'sign by default' and 'encrypt by default'. Set(%GnuPG, Enable=>1, OutgoingMessagesFormat=>RFC, EncryptDataInDb=>0,); What I did was as root , create a gpg key using

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 continu

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

2008-08-25 Thread Asif Iqbal
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 running the rt from cli to generate the new ticket list. As far actually working on ticket I should

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 Message

[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 i

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

2008-08-25 Thread Otmar Lendl
On 2008/08/25 16:08, Jerrad Pierce <[EMAIL PROTECTED]> wrote: > 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 se

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 –

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 s

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: Subject: [rt-users] Upgrade from 3.0.11 to 3.4.6 _

[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 version

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 ticke

[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 number

[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, 2008

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/ -- Cambridge

[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] RFC: Dashboard upgrades

2008-08-25 Thread Richard Hartmann
On Mon, Aug 25, 2008 at 16:19, Richard Hartmann <[EMAIL PROTECTED]> wrote: > 1) Should it be possible to order messages by read/unread messages > within said ticket? s/messages/tickets/ ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-user

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] 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 w

[rt-users] AT links gone in 3.8.1

2008-08-25 Thread JOHN ROMAN
going from 3.5.4 to 3.8.1 ive lost the area in tickets pertaining to AT links.  any ideas? ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: [EMAIL PROTECTED] Discov

[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: [E

Re: [rt-users] Lost Links after Upgrade 3.6.7 -> 3.8.1

2008-08-25 Thread Knaupp, Thomas
That's it : ) Thank you : ) | -Original Message- | From: Jesse Vincent [mailto:[EMAIL PROTECTED] | Sent: Monday, August 25, 2008 3:31 PM | To: Knaupp, Thomas | Cc: rt mailing list | Subject: Re: [rt-users] Lost Links after Upgrade 3.6.7 -> 3.8.1 | | You probably changed your

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 ticke

[rt-users] RT Training Announcement - November 24, 2008

2008-08-25 Thread Cassandra Phillips-Sears
Due to popular demand, we're holding a second European RT training session in 2008! Come and join us! 2008 RT Fall Training We provide unparalleled instruction in how to get the most out of RT. On November 24, we will be offering an intensive one-day developer and administrator training sessio

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-use

Re: [rt-users] Lost Links after Upgrade 3.6.7 -> 3.8.1

2008-08-25 Thread Jesse Vincent
You probably changed your $Organization field in the RT config file. You'd want to change it back. -j On Aug 25, 2008, at 9:29 AM, Knaupp, Thomas wrote: > Hello List, > > after upgrading rt 3.6.7 to 3.8.1, all links > ( Depends on / Parents / Refers to / etc.) > seem to be lost : / > > Suggest

[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 ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-use

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 > wonderi

[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 ___ http://lis

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 /Search/Build2.html and > modified t

[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 worki

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 woul

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'

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 a

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: >>

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 PROTECTE

[rt-users] RT 3.8.1 web interface

2008-08-25 Thread andrew fay
Hi Nick, Might want to have a look at the mail below, I was having the same problem a few days ago and this sorted it for me. Cheers, Andy From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Date: Fri, 22 Aug 2008 13:35:59 + CC: rt-users@lists.bestpractical.com Subject: Re: [rt-users] rt 3.8.1

[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 http://my

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

2008-08-25 Thread Richard Hartmann
Hi all, is there any header line I could add that would RT ignore incoming emails (i.e. not reopen the ticket) or, preferably, to file the reply as a comment but not re-open any closed tickets? As always, if there is not, what would others think of the usefulness of such a thing? Thanks, Richar

[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! http://clk.atdmt.com/UKM/go/1

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 datab

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

2008-08-25 Thread andrew fay
Hi, When i use this command it says error database not selected, how do I select the RTDB database before i do this? Thanks, Andy > Date: Fri, 22 Aug 2008 17:31:31 +0200 > From: [EMAIL PROTECTED] > To: [EMAIL PROTECTED] > CC: rt-users@lists.bestpractical.com > Subject: Re: [rt-users] 3.8.1 i

[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