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

2009-06-03 Thread Joop van de Wege
Nick Yonko wrote: I am getting an error when rt-mailgate sends an email to RT saying that the Attachments object does not exist. The email is received and the details of it are written to the database, however the body of the email is missing. Has anyone dealt with this? I am on Oracle

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

2009-06-03 Thread Nick Yonko
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. - Original Message - From:

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 turn on

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

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.8.3, it is

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

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 je...@bestpractical.com wrote: Second, I just wanted to point out to folks that use WebExternalAuth, and potentially the companion

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 exact

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] 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 are a

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/

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

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

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

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 falc...@bestpractical.com 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.

Re: [rt-users] TransactionBatch Question

2009-06-03 Thread Stephen Turner
On Mon, 01 Jun 2009 18:19:35 -0400, Ruslan Zakirov ruslan.zaki...@gmail.com 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

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 falc...@bestpractical.com wrote: Yes, there is a database upgrade involved. ___

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 Gavin Henry
Yeah, we use Pg. We got 'relation 'groupmembers1' already exists. On 03/06/2009, jmose...@corp.xanadoo.com 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

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 falc...@bestpractical.com 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

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 the

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

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 jrh...@netconsonance.com 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

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 ruslan.zaki...@gmail.com wrote: There is no way to search deleted tickets in the web UI. On Tue, Jun 2, 2009 at 10:48 PM, Jo Rhett jrh...@netconsonance.com

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 bashir.ja...@nha.co.za 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

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 bl...@dainty.ca 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

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

2009-06-03 Thread Gavin Henry
2009/6/3 Kevin Falcone falc...@bestpractical.com: 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

[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

[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

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 joopvandew...@mococo.nl To: Nick Yonko nyo...@advnettech.net 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

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= (no

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

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

[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

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 paragraphs

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, regardless of

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 jrh...@netconsonance.com wrote: It only happens when you click Show for outbound messages - ie, to AdminCcs or Requestors. Normal ticket display is unaffected.

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

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

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

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 jrh...@netconsonance.com 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

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

[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

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

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

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

[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