[rt-users] question about FromSQL

2007-06-19 Thread Mathew Snyder
Does the FromSQL method allow for the less-than-/greater-than-or-equal-to operators? <=, >= Using them would simplify a query I have. Thanks Mathew -- Keep up with me and what I'm up to: http://theillien.blogspot.com ___ http://lists.bestpractical.com

Re: [rt-users] Problem with ExtractCustomFieldValues

2007-06-19 Thread Mathew Snyder
It's the actual scrip which runs ExtractCustomFieldValues.pm. Condition: On Create Action: Extract Custom Field Values Template: Global template: ExtractEnvironment Stage: TransactionCreate Custom condition: Custom action Preparation code: return 1; Custom action cleanup code: Template ExtractEnv

[rt-users] Load balancer

2007-06-19 Thread Brian_Gupta
#x27;re on 3.6.3 and that "Everybody" doesn't > have the "OwnTickets" right? I've just reread this section of code > and I don't see hwo this can be happening. > > -- next part -- > A non-text attachment was scrubbed... > Na

Re: [rt-users] Load balancer

2007-06-19 Thread Matthew Keller
For a pair of high-volume clients, I've set up RT3.6 behind a lightweight Apache SSL server that uses an Apache rewrite map to balance the connections- one has 2 servers, one has 4. Works perfectly. Note: Both of these are using external authentication. I have no idea about intra-RT auth mechanis

Re: [rt-users] Problem with ExtractCustomFieldValues

2007-06-19 Thread Gene LeDuc
Mathew, what is scrip 18 doing? At 12:37 PM 6/19/2007, Mathew Snyder wrote: So far it hasn't posed a problem as it appears to be working but I was looking at the Apache error_log today and saw this: [Tue Jun 19 18:02:26 2007] [error]: Scrip Commit 18 died. - Can't call method "Content" on an und

[rt-users] Problem with ExtractCustomFieldValues

2007-06-19 Thread Mathew Snyder
So far it hasn't posed a problem as it appears to be working but I was looking at the Apache error_log today and saw this: [Tue Jun 19 18:02:26 2007] [error]: Scrip Commit 18 died. - Can't call method "Content" on an undefined value at /usr/local/rt-3.6.1//lib/RT/Action/ExtractCustomFieldValues.pm

[rt-users] LDAP and debugging

2007-06-19 Thread J Bell
Hi folks, I'm trying to debug an LDAP overlay, but I can't seem to get the logging done properly. Here is the relevant stanza from RT_SiteConfig.pm: Set($LogToSyslog, 'debug'); Set($LogToScreen, 'debug'); Set($LogToFile , 'debug'); Set($LogDir, '/var/log/rt3'); Set($LogToFileNamed

RE: [rt-users] Question about Dates in DB

2007-06-19 Thread Justin Brodley
That would be great especially when dealing with reporting applications, having a value there makes them more complex, as I have to set "not equals" statements. Justin Brodley  -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Ruslan Zakirov Sent: Tues

Re: [rt-users] Question about Dates in DB

2007-06-19 Thread Ruslan Zakirov
Yes, 1/1/1970 is equal to 'Not set', but I think you have to expect this to be changed to real NULL as I have very strong wish to change it as NULLs are clearer, easier for development and more flexible. Hope we'll have time to do it before 3.8.0 On 6/19/07, Stephen Turner <[EMAIL PROTECTED]> wro

Re: [rt-users] user names appearing in comments dropdown

2007-06-19 Thread Jesse Vincent
On Jun 18, 2007, at 3:13 PM, Michael Kukla wrote: Jesse et al, Sorry to say, I again need write the list about something we noticed last week--namely, that the names of **disabled** users continue to appear in the Owner drop down one gets when "Commenting" on ticket. It appeared that

[rt-users] Load balancer

2007-06-19 Thread Justin Brodley
Has anyone attempted to terminate SSL on a load balancer in front of the RT server? We did some initial tests but had issues with redirects, etc. We'd prefer not to terminate SSL directly to the web server as this adds additional stress to the server. Justin Brodley _

Re: [rt-users] Question about Dates in DB

2007-06-19 Thread Gene LeDuc
FWIW, a brief snoop didn't turn up any null date fields in our MySQL RT database. Gene At 08:31 AM 6/19/2007, Stephen Turner wrote: At Tuesday 6/19/2007 11:26 AM, Justin Brodley wrote: I'm working on some reports for our RT database, and I'm noticing that fields get populated with 1/1/1970 if

RE: [rt-users] Question about Dates in DB

2007-06-19 Thread Justin Brodley
It's nice to see that its consistently inconsistent. We are also running Oracle, so I'll have to look out for this. Justin Brodley -Original Message- From: Stephen Turner [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 19, 2007 8:31 AM To: Justin Brodley; rt-users@lists.bestpractical.com

Re: [rt-users] Question about Dates in DB

2007-06-19 Thread Stephen Turner
At Tuesday 6/19/2007 11:26 AM, Justin Brodley wrote: I'm working on some reports for our RT database, and I'm noticing that fields get populated with 1/1/1970 if there is nothing entered into the DB. Is this accurate assessment? If so can I just assume that 1/1/1970 = null? Yes, that's rig

[rt-users] Question about Dates in DB

2007-06-19 Thread Justin Brodley
I'm working on some reports for our RT database, and I'm noticing that fields get populated with 1/1/1970 if there is nothing entered into the DB. Is this accurate assessment? If so can I just assume that 1/1/1970 = null? Thanks in advance. Justin Brodley _

Re: [FILTER] [rt-users] RTFM search through body text 2.2.0RC5

2007-06-19 Thread Kevin Falcone
On Jun 7, 2007, at 3:02 PM, Jeff Platter wrote: So I finally think I fixed the issue. If anyone is interested it seemed that in the ArticleCollection_Overlay.pm file there was a select statement that had 2 things wrong with it. It was generating the JOIN with OR’s instead of AND’s and it w

Re: [rt-users] Not saving custom fields in RTFM upon Article creation

2007-06-19 Thread Ulrike Lindemann
Thanks, Jesse, we will test it! Ulrike Jesse Vincent wrote: On Jun 19, 2007, at 5:06 AM, Ulrike Lindemann wrote: Hi Joop! Sorry, I can't find RC6, is it available, yet? I would like to test, too! You can snag a copy at: http://download.bestpractical.com/pub/rt/devel/RTIR_M3/RTFM-2.2.0RC6.t

[rt-users] Custom Field Include Page

2007-06-19 Thread Matt Gilstrap
Could someone either explain or point me in the right direction about the Include Page field when creating a custom field in version 3.6.3? I can't seem to find any documentation on it. Thanks in advance. --Matt ___ http://lists.bestpractical.com/c

Re: [rt-users] Not saving custom fields in RTFM upon Article creation

2007-06-19 Thread Jesse Vincent
On Jun 19, 2007, at 5:06 AM, Ulrike Lindemann wrote: Hi Joop! Sorry, I can't find RC6, is it available, yet? I would like to test, too! You can snag a copy at: http://download.bestpractical.com/pub/rt/devel/RTIR_M3/ RTFM-2.2.0RC6.tar.gz Regards, Ulrike PGP.sig Description: This is a

Re: [rt-users] Not saving custom fields in RTFM upon Article creation

2007-06-19 Thread Joop
Ulrike Lindemann wrote: Hi Joop! Sorry, I can't find RC6, is it available, yet? I would like to test, too! Regards, Ulrike Joop wrote: Jeff Platter wrote: I’m using RTFM 2.2.0RC5 with RT 3.6.3. I have created a custom field for the body of the article. I have setup all permissions on the cust

Re: [rt-users] Not saving custom fields in RTFM upon Article creation

2007-06-19 Thread Ulrike Lindemann
Hi Joop! Sorry, I can't find RC6, is it available, yet? I would like to test, too! Regards, Ulrike Joop wrote: Jeff Platter wrote: I’m using RTFM 2.2.0RC5 with RT 3.6.3. I have created a custom field for the body of the article. I have setup all permissions on the custom field and added it to

Re: [rt-users] Fwd: [example.com #2] Test- changing example.com in to [test.com#2]

2007-06-19 Thread Christian Felber
Hi Buddika, Did you restart Apache? Changes take effect after. Christian buddika weeerasinghe schrieb am 19.06.2007 05:51: > Hi christian, > > I did it.But the result is the same. > > rgds, > Buddika. > > Christian Felber <[EMAIL PROTECTED]> wrote: > Hi, > > Just change $rtname