[rt-users] DashBoaard

2009-06-03 Thread Odhiambo ワシントン
Hello list, I am seeing so much mention of the word "DashBoard" in relation to RT. Having been off active running of RT, I am inclined to ask what it is and how I can use it. -- Best regards, Odhiambo WASHINGTON, Nairobi,KE +254733744121/+254722743223 _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

[rt-users] Problem with CustomCondition

2009-06-03 Thread Martin B.
Hey, i want to write a CustomCondition who activate a action if the queue is changed from x to y this is my code: return 0 unless $self->TransactionObj->Type eq "Set"; return 0 unless $self->TransactionObj->Field eq "Queue"; return 0 unless $self->TransactionObj->NewValue == "y"; return 0

Re: [rt-users] RT 3.8.2 -> 3.8.3 Update/Changes

2009-06-03 Thread Odhiambo ワシントン
On Thu, Jun 4, 2009 at 12:58 AM, Jo Rhett wrote: > On Jun 3, 2009, at 12:28 PM, Kevin Falcone wrote: > > I don't think you're doing this from a tarball, > > you're trying to do it from the installed directory. > > Nope, from the extracted tarball in ports directory. > > > It gives you an even mor

[rt-users] rt 3.8.2 ticket cloning starts/due dates 1970?

2009-06-03 Thread Paul C.
Ahoy, Running RT 3.8.2 when I clone a ticket via one of the (parent|child|etc.) "Create" links it's filling in "1970-01-01 00:00:00" for both the Starts and Due dates when those values are Not set in the originating ticket. In the database it's being stored as "1970-01-01 08:00:00" (have a -8:00 t

Re: [rt-users] RT 3.8.2 -> 3.8.3 Update/Changes

2009-06-03 Thread jmoseley
Everyone has their own way of doing things, but I find upgrading RT is easiest by essentially installing RT from scratch upon each upgrade and then soft-linking to the new directory. In this way, upgrades are straightforward and not hard to follow. For example: download new RT source untar/unzip

Re: [rt-users] RT ExternalAuth LDAP and Adding Local users in 3.8.2

2009-06-03 Thread Cassandra L. Brockett
((Apologies for top-posting, but it's just easier at the moment for me to use outlook to send email)) I can answer a few of your questsions:- 1) Users with multiple email addresses on our system become one single user, the LDAP query finds the one user responsible for the email address, and just

Re: [rt-users] RT 3.8.2 -> 3.8.3 Update/Changes

2009-06-03 Thread Jo Rhett
On Jun 3, 2009, at 12:28 PM, Kevin Falcone wrote: > I don't think you're doing this from a tarball, > you're trying to do it from the installed directory. Nope, from the extracted tarball in ports directory. > It gives you an even more specific command to run > at the end of the output from make

[rt-users] RT ExternalAuth LDAP and Adding Local users in 3.8.2

2009-06-03 Thread Susan McClure
I have been reading the postings about RT-Authen-ExternalAuth but am confused on what appears to be some conflicting setup information. I am using: RT 3.8.2 RT-Authen-ExternalAuth 0.08 I would like to use LDAP for authentication and information first, and that part seems to work OK. But I al

Re: [rt-users] RT 3.8.2 -> 3.8.3 Update/Changes

2009-06-03 Thread Ruslan Zakirov
Except that your command is just wrong: $ rt-setup-database --action upgrade --datadir etc/upgrade ... Enter RT version you're upgrading from: 3.8.2 Going to apply following upgrades: * 3.8.3 Enter RT version if you want to stop upgrade at some point, or leave it blank if you want apply above up

Re: [rt-users] search for deleted tickets in a Dashboard?

2009-06-03 Thread Ruslan Zakirov
On Wed, Jun 3, 2009 at 11:09 PM, Jo Rhett wrote: > Sorry to be dense, but can you translate the first sentence for me? ;-) > > I realize that this parameter needs to be set, I'm just unclear as to how. Create share/html/Elements/DeleteTickets that does the search and displays it, register it in H

Re: [rt-users] Binary files broken since upgrade to RT 3.8

2009-06-03 Thread Dominic Lepiane
Thanks, it looks like this might work. We basically have a script which selects the data out of the 3.6 db and then update the corresponding row in the 3.8 db and so far I'm getting better results. Thanks, - Dominic Aaron Guise wrote: > Hi, > > I too had a similar problem. I inherited our RT Sy

Re: [rt-users] RT 3.8.2 -> 3.8.3 Update/Changes

2009-06-03 Thread Kevin Falcone
On Jun 3, 2009, at 3:17 PM, Jo Rhett wrote: > On Jun 3, 2009, at 5:30 AM, Kevin Falcone wrote: >> Yes, there is a database upgrade involved. > > $ rt-setup-database --action upgrade --datadir etc/upgrade/3.8.3 > (snip) > Enter RT version you're upgrading from: 3.8.2 > No DB changes between 3.8.2

Re: [rt-users] RT 3.8.2 -> 3.8.3 Update/Changes

2009-06-03 Thread Jo Rhett
On Jun 3, 2009, at 5:30 AM, Kevin Falcone wrote: > Yes, there is a database upgrade involved. $ rt-setup-database --action upgrade --datadir etc/upgrade/3.8.3 (snip) Enter RT version you're upgrading from: 3.8.2 No DB changes between 3.8.2 and 3.8.3 Done. -- Jo Rhett Net Consonance : consonant

Re: [rt-users] RT 3.8.2 -> 3.8.3 Update/Changes

2009-06-03 Thread Jo Rhett
On Jun 3, 2009, at 5:30 AM, Kevin Falcone wrote: >> Is a database upgrade needed? When we went from 3.8.2 to .3 it failed >> saying that group something id already exists. > > Yes, there is a database upgrade involved. Really? Documentation didn't mention that. > UPGRADING FROM 3.8.2 and earlie

Re: [rt-users] search for deleted tickets in a Dashboard?

2009-06-03 Thread Jo Rhett
Sorry to be dense, but can you translate the first sentence for me? ;-) I realize that this parameter needs to be set, I'm just unclear as to how. And would you guys accept a patch which put a checkbox for searching deleted messages on the Web UI? On Jun 3, 2009, at 7:05 AM, Ruslan Zakirov w

Re: [rt-users] 3.8.2 message display bug reappears in 3.8.3

2009-06-03 Thread jmoseley
FWIW, I do not see this behavior using RT 3.8.3 and FireFox 3.0.10. James Moseley Jo Rhett wrote: It only happens when you click "Show" for outbound messages - ie, to AdminCcs or Requestors. Normal ticket display is unaffected. ___ http://lis

Re: [rt-users] 3.8.2 message display bug reappears in 3.8.3

2009-06-03 Thread Kevin Falcone
On Jun 3, 2009, at 2:47 PM, Jo Rhett wrote: > On Jun 3, 2009, at 5:23 AM, Kevin Falcone wrote: >>> I reported this message display bug about 3 months ago, Kevin agreed >>> with the fix, but it's still present in 3.8.3. Without this fix, if >>> you click "Show" next to an outgoing mail message, re

Re: [rt-users] 3.8.2 message display bug reappears in 3.8.3

2009-06-03 Thread Jo Rhett
On Jun 3, 2009, at 5:23 AM, Kevin Falcone wrote: >> I reported this message display bug about 3 months ago, Kevin agreed >> with the fix, but it's still present in 3.8.3. Without this fix, if >> you click "Show" next to an outgoing mail message, regardless of your >> preference settings, text para

[rt-users] RT-3.8.3, RT-Authen-ExternalAuth-0.08 login issue

2009-06-03 Thread Matt Millard
I'm doing a fresh install of RT-3.8.3, RT-Authen-ExternalAuth-0.08, and AD for authentication. All running on RHEL5 x86_64 for the OS. I had this all working with RT-3.6.7 and RT-Authen-ExternalAuth-0.05, but had the brilliant idea that I needed to be current since 3.8.3 was released on the same da

Re: [rt-users] Tickets with Owner= (no value)

2009-06-03 Thread Ken Crocker
Alberto, If you removed the owners of a ticket by removing those user records from the USERS Table, then you will NEVER find those owners, nor will you be able to change the owner on those tickets that point to the removed UserId. The reason is that RT has several Tables that are updated w

Re: [rt-users] Help with Time display

2009-06-03 Thread Ken Crocker
Jesse, HA! Well, that explains that. Thank you for the answer. Hopefully, next month I'll be able to install 3.8.3 in development and play with it. Thanks again. Kenn LBNL On 6/3/2009 10:10 AM, Jesse Vincent wrote: On Wed, Jun 03, 2009 at 10:04:41AM -0700, Ken Crocker wrote: To list

Re: [rt-users] Help with Time display

2009-06-03 Thread Jesse Vincent
On Wed, Jun 03, 2009 at 10:04:41AM -0700, Ken Crocker wrote: > To list, > > I am on 3.6.4. To remove the "Time" portion of any date being > displayed, I used this setting: > > Set($DateTimeFormat, {Format => 'Default',Time => 0,}); > > It did not work. Is there another setting I need

[rt-users] Help with Time display

2009-06-03 Thread Ken Crocker
To list, I am on 3.6.4. To remove the "Time" portion of any date being displayed, I used this setting: Set($DateTimeFormat, {Format => 'Default',Time => 0,}); It did not work. Is there another setting I need to use in conjunction with this one or am I in left field here. Is this settin

Re: [rt-users] Storing custom field file to local file system

2009-06-03 Thread Tom Lahti
Kevin Falcone wrote: > On Jun 3, 2009, at 7:23 AM, BJ Blanchard wrote: > >> Thanks Tom - but actually my custom field IS defined as "Upload one >> file" (or an attachment). >> My problem is saving that attachment from RT to /tmp (for >> manipulation from command-line script). >> There must b

Re: [rt-users] 3.6.7 to 3.8.2 upgrade issue (mysql)

2009-06-03 Thread Ruslan Zakirov
On Wed, Jun 3, 2009 at 11:51 AM, Karel Vervaeke wrote: > Hi list, > > Due to persistent memory problems I decided to try and upgrade to a > more recent version of RT. (RT 3.6 was installed on a xen VM running > Debian etch using the default apt package.  In the mean time the > machine has been upg

Re: [rt-users] Tickets with Owner= (no value)

2009-06-03 Thread Ken Crocker
Alberto, When you say you removed a user via MySQL do you mean you merely dropped the record from the USERS Table? Kenn LBNL On 6/3/2009 1:55 AM, Alberto Villanueva wrote: > Good morning, > > Yesterday I removed a user (within MySQL) had several assigned > tickets. Now these have Owner= (n

Re: [rt-users] RT on Oracle - ORA-04043 object Attachments does not exist

2009-06-03 Thread Nick Yonko
Do you know how I would do that? - Original Message - From: "Joop van de Wege" To: "Nick Yonko" Cc: rt-us...@bestpractical.com Sent: Wednesday, June 3, 2009 12:30:51 AM GMT -08:00 US/Canada Pacific Subject: Re: [rt-users] RT on Oracle - ORA-04043 object Attachments does not exist Nick

[rt-users] 3.6.7 to 3.8.2 upgrade issue (mysql)

2009-06-03 Thread Karel Vervaeke
Hi list, Due to persistent memory problems I decided to try and upgrade to a more recent version of RT. (RT 3.6 was installed on a xen VM running Debian etch using the default apt package. In the mean time the machine has been upgraded to Debian lenny, without side-effects for RT. After the dist

[rt-users] R: R: R: RT Queue Subject Tag problem

2009-06-03 Thread Guadagnino Cristiano
Jesse, after Jeremy's last email I upgraded our test system to 3.8.3, and the feature is now working perfectly. The web configuration UI sometimes still fails to show the subject tag, though. Thank you for your help! Bye Cris -Messaggio originale- Da: Jesse Vincent [mailto:je...@bestpr

Re: [rt-users] RT 3.8.2 -> 3.8.3 Update/Changes

2009-06-03 Thread Gavin Henry
2009/6/3 Kevin Falcone : > > On Jun 3, 2009, at 9:20 AM, Gavin Henry wrote: > >> Yeah, we use Pg. >> We got 'relation 'groupmembers1' already exists. > > Oh, thats ok.  We added an index that existed on MySQL but not on Pg, > but if you do your own database tuning there is always a chance > we'll c

Re: [rt-users] RT 3.8.3 and AT 1.2.4b1 - Batch and Grid updates broken

2009-06-03 Thread Ruslan Zakirov
It's better to return empty list: sub ACLEquivalenceObjects { return () } On Tue, Jun 2, 2009 at 11:56 PM, BJ Blanchard wrote: > For those out there using RT 3.8.2 with Asset Tracker 1.2.4b1 - an upgrade > to RT 3.8.3 breaks Batch and Grid updates of Assets. > > This is due to a missing method c

Re: [rt-users] admin cc not receiving mail

2009-06-03 Thread Ruslan Zakirov
you need scrip for that: On any transaction notify admin ccs with template transaction. On Wed, Jun 3, 2009 at 2:48 PM, Bashir Jahed wrote: > Hi, > > > > Been googling for 2 weeks with no success. > > > > I have an issue with admin cc. I am listed as admin cc of a queue. If > someone adds a comm

Re: [rt-users] search for deleted tickets in a Dashboard?

2009-06-03 Thread Ruslan Zakirov
You can use custom portlet based on a component with $tickets->{'allow_search_deleted'} = 1; On Wed, Jun 3, 2009 at 6:04 PM, Ruslan Zakirov wrote: > There is no way to search deleted tickets in the web UI. > > On Tue, Jun 2, 2009 at 10:48 PM, Jo Rhett wrote: >> I'm trying to create a Dashboard w

Re: [rt-users] search for deleted tickets in a Dashboard?

2009-06-03 Thread Ruslan Zakirov
There is no way to search deleted tickets in the web UI. On Tue, Jun 2, 2009 at 10:48 PM, Jo Rhett wrote: > I'm trying to create a Dashboard which will mail out the tickets for > review which are going to be purged from the system by rt-scrubber. > > In testing I have found something weird.  Givi

Re: [rt-users] How to Migrate the Bugzilla Ticket Description into Request Tracker

2009-06-03 Thread Ruslan Zakirov
Content of tickets is organized as MIME parts in attachments table. Each attachment may have a parent and sticketed to a transaction. Transactions with attachments usually have Create, Correspond or Comment type. What else do you want to know? On Tue, Jun 2, 2009 at 7:23 PM, Kwasi Date-Bah wrot

Re: [rt-users] R: R: RT Queue Subject Tag problem

2009-06-03 Thread Jesse Vincent
Can you please test on 3.8.3? On Wed, Jun 03, 2009 at 10:30:27AM +0200, Guadagnino Cristiano wrote: > Hi Jesse! > First of all, thank you for your response. > > Unfortunately, it seems it is not working. > On a test system (RT 3.8.2) we have two "incoming" queues: DBA and SCHEDU. I > have set

Re: [rt-users] RT 3.8.2 -> 3.8.3 Update/Changes

2009-06-03 Thread Gavin Henry
Great, thanks! Will run that later and report back. On 03/06/2009, Kevin Falcone wrote: > > On Jun 3, 2009, at 9:20 AM, Gavin Henry wrote: > >> Yeah, we use Pg. >> We got 'relation 'groupmembers1' already exists. > > Oh, thats ok. We added an index that existed on MySQL but not on Pg, > but if y

Re: [rt-users] RT 3.8.2 -> 3.8.3 Update/Changes

2009-06-03 Thread Kevin Falcone
On Jun 3, 2009, at 9:20 AM, Gavin Henry wrote: > Yeah, we use Pg. > We got 'relation 'groupmembers1' already exists. Oh, thats ok. We added an index that existed on MySQL but not on Pg, but if you do your own database tuning there is always a chance we'll conflict with you. Pointers to portabl

Re: [rt-users] RT 3.8.2 -> 3.8.3 Update/Changes

2009-06-03 Thread Gavin Henry
Yeah, we use Pg. We got 'relation 'groupmembers1' already exists. On 03/06/2009, jmose...@corp.xanadoo.com wrote: > I see a database upgrade for postgres, but nothing for mysql going from > 3.8.2 to 3.8.3. Perhaps I'm missing something... > > > James Moseley > > > > Kevin Falcone wrote: > > >

Re: [rt-users] RT 3.8.2 -> 3.8.3 Update/Changes

2009-06-03 Thread Kevin Falcone
On Jun 3, 2009, at 9:18 AM, jmose...@corp.xanadoo.com wrote: > I see a database upgrade for postgres, but nothing for mysql going > from > 3.8.2 to 3.8.3. Perhaps I'm missing something... etc/upgrade/3.8.3/content It isn't a schema change, but it upgrades things in the database. -kevin > >

Re: [rt-users] RT 3.8.2 -> 3.8.3 Update/Changes

2009-06-03 Thread jmoseley
I see a database upgrade for postgres, but nothing for mysql going from 3.8.2 to 3.8.3. Perhaps I'm missing something... James Moseley Kevin Falcone wrote: Yes, there is a database upgrade involved. ___ http://lists.bestpractical.com/cgi-

Re: [rt-users] TransactionBatch Question

2009-06-03 Thread Stephen Turner
On Mon, 01 Jun 2009 18:19:35 -0400, Ruslan Zakirov wrote: > Steve, sorry, but I can't say that I fully understand your > description, but conditions of batch scrips tested on every > transaction in a batch, but process stops as soon as we find a match. > We don't want to fire the same scrip mul

Re: [rt-users] RT 3.8.2 -> 3.8.3 Update/Changes

2009-06-03 Thread Gavin Henry
Will do, thanks. On 03/06/2009, Kevin Falcone wrote: > > On Jun 3, 2009, at 6:43 AM, Gavin Henry wrote: > >> Is a database upgrade needed? When we went from 3.8.2 to .3 it failed >> saying that group something id already exists. > > Yes, there is a database upgrade involved. > > Please send the f

Re: [rt-users] Storing custom field file to local file system

2009-06-03 Thread Kevin Falcone
On Jun 3, 2009, at 7:23 AM, BJ Blanchard wrote: > Thanks Tom - but actually my custom field IS defined as "Upload one > file" (or an attachment). > My problem is saving that attachment from RT to /tmp (for > manipulation from command-line script). > There must be some non-http method of ext

Re: [rt-users] RT 3.8.2 -> 3.8.3 Update/Changes

2009-06-03 Thread Kevin Falcone
On Jun 3, 2009, at 6:43 AM, Gavin Henry wrote: > Is a database upgrade needed? When we went from 3.8.2 to .3 it failed > saying that group something id already exists. Yes, there is a database upgrade involved. Please send the full error message and the command you use to rt-b...@bestpractical.

Re: [rt-users] Creating Tickets Via Email

2009-06-03 Thread Kevin Falcone
On Jun 2, 2009, at 4:22 PM, Nick Coronado wrote: > I looked up the Email Integration document under the wiki pages. I > followed the steps and was able to perform the following: > cat testfile | /usr/bin/rt-mailgate --debug Exchange --action > correspond –url http://rt.isncom.com > > > AND REC

Re: [rt-users] RT::User::MergeInto Unimplemented in HTML::Mason::Commands

2009-06-03 Thread Kevin Falcone
On Jun 2, 2009, at 2:41 PM, Jeff Lucas wrote: > I’ve installed RT-Extension-MergeUsers-0.03_02 but get the following > when trying to use it from the User account page… > > RT::User::MergeInto Unimplemented in HTML::Mason::Commands. (/apps/ > rt-3.8.2/share/html/Callbacks/RT-Extension-MergeUse

Re: [rt-users] 3.8.2 message display bug reappears in 3.8.3

2009-06-03 Thread Kevin Falcone
On Jun 2, 2009, at 5:28 AM, Jo Rhett wrote: > I reported this message display bug about 3 months ago, Kevin agreed > with the fix, but it's still present in 3.8.3. Without this fix, if > you click "Show" next to an outgoing mail message, regardless of your > preference settings, text paragraphs a

Re: [rt-users] Custom Fields in Update.html view

2009-06-03 Thread Kevin Falcone
On Jun 1, 2009, at 11:34 PM, Stephen Cochran wrote: > Custom fields are displayed in Update.html (reached by clicking on > Comment, Reply, or Resolve). Are they supposed to be modifiable in > that interface? I don't see anything in Update.html that would be > saving their settings, though I

Re: [rt-users] Only Plain Text Mails.

2009-06-03 Thread Kevin Falcone
On Jun 1, 2009, at 8:18 PM, Rana Tanveer wrote: > Hi Kavin > > > I have tried hard to implement according to your advise. but > unfortunately it does not work or may i did something wrong. > http://code.bestpractical.com/bps-public/rt/3.8/trunk/docs/templates.pod > > can you please give me some

Re: [rt-users] Storing custom field file to local file system

2009-06-03 Thread BJ Blanchard
Thanks Tom - but actually my custom field IS defined as "Upload one file" (or an attachment). My problem is saving that attachment from RT to /tmp (for manipulation from command-line script). There must be some non-http method of extracting the attachment to a file? -Original Message- Fr

Re: [rt-users] RT 3.8.2 -> 3.8.3 Update/Changes

2009-06-03 Thread Gavin Henry
Is a database upgrade needed? When we went from 3.8.2 to .3 it failed saying that group something id already exists. Thanks. On 01/06/2009, Jesse Vincent wrote: > > >> Second, I just wanted to point out to folks that use WebExternalAuth, and >> potentially the companion WebFallbackToInternalAuth

[rt-users] admin cc not receiving mail

2009-06-03 Thread Bashir Jahed
Hi, Been googling for 2 weeks with no success. I have an issue with admin cc. I am listed as admin cc of a queue. If someone adds a comment to a ticket i receive the correspondence, however if someone emails a comment the correspondence is not sent out to admin cc's Is this the standard

Re: [rt-users] Help with RT Groups and LDAP group.

2009-06-03 Thread Mike Peachey
Tue 02 Jun 2009 23:16:38 GMT Kevin Gagel wrote: > I've got the ldap plug in working but I seem to have a disconnect > between root and ldap users. What I mean is that I can login to RT using > my ldap credentials but I have nothing available except tickets to open, > close and new tickets. The root

[rt-users] Tickets with Owner= (no value)

2009-06-03 Thread Alberto Villanueva
Good morning, Yesterday I removed a user (within MySQL) had several assigned tickets. Now these have Owner= (no value). I have tested next: 1.- MySQL query, but I cannot select because Owner= (no value) 2.- In RT: new Search / Batch update / (I cannot because RT says "Only you can assign tickets

Re: [rt-users] RT 3.8.2 -> 3.8.3 Update/Changes

2009-06-03 Thread Emmanuel Lacour
On Mon, Jun 01, 2009 at 01:53:38PM -0400, Jesse Vincent wrote: > > > > Second, I just wanted to point out to folks that use > > WebExternalAuth, and potentially the companion > > WebFallbackToInternalAuth, that it has been reversed. In RT 3.8.2, > > it was "...is undefined, the user..." and in 3

[rt-users] R: R: RT Queue Subject Tag problem

2009-06-03 Thread Guadagnino Cristiano
Hi Jesse! First of all, thank you for your response. Unfortunately, it seems it is not working. On a test system (RT 3.8.2) we have two "incoming" queues: DBA and SCHEDU. I have set the subject tag for the DBA queue as "DBA", while the subject tag for the SCHEDU queue is "SCHD". In the RT_SiteC

Re: [rt-users] RT on Oracle - ORA-04043 object Attachments does not exist

2009-06-03 Thread Joop van de Wege
Nick Yonko wrote: > That was my initial thought, but when I log into the database using the rt > user with sqlplus, as the account that runs the apache daemon no less, I can > issue a 'desc attachments' command and a 'desc "Attachments"' command and > both return the table structure. Can you tur