[rt-users] Problems with SQL-time functions

2010-09-03 Thread Wolfram Huettermann

Hello,

I was given the task to filter all the tickets inside or outside fixed 
business hours in a specified date range. I will display you table to 
demonstrate what I mean:


weekday  office opensoffice closes

Monday-Thursday   8:00:0016:00:00
Friday  8:00:0015:30:00

In usual SQL, one would filter weekday by weekday and exclude the time 
outside or inside working hours. If you only want to enlist the Tickets 
inside business hours, you can use the TIME and WEEKDAY functions, the 
SQL statement would look like that:


Select id, Created, Subject from Tickets where WEEKDAY(Created) not in 
(0,6) and ((WEEKDAY(Created) in(1, 2, 3, 4) and TIME(Created)  
'08:00:00' and TIME(Created)  '16:00:00') or (WEEKDAY(Created)=5 and 
TIME(Created)  '08:00:00' and TIME(Created)  '15:30:00'))



If you put the statement after the where-clause into the method FormSQL 
of the class RT::Ticket, you will not get the right results, but /all/ 
tickets.



I do not know why that method does not work. Does anybody have any 
hints? Or is it just impossible to do so?


Greetings,

Wolfram




RT Training in Washington DC, USA on Oct 25  26 2010
Last one this year -- Learn how to get the most out of RT!


Re: [rt-users] Problems with SQL-time functions

2010-09-03 Thread Kevin Falcone
On Fri, Sep 03, 2010 at 11:30:17AM +0200, Wolfram Huettermann wrote:
 Hello,
 
 I was given the task to filter all the tickets inside or outside
 fixed business hours in a specified date range. I will display you
 table to demonstrate what I mean:
 
 weekday  office opensoffice closes
 
 Monday-Thursday   8:00:0016:00:00
 Friday  8:00:0015:30:00
 
 In usual SQL, one would filter weekday by weekday and exclude the
 time outside or inside working hours. If you only want to enlist the
 Tickets inside business hours, you can use the TIME and WEEKDAY
 functions, the SQL statement would look like that:
 
 Select id, Created, Subject from Tickets where WEEKDAY(Created) not
 in (0,6) and ((WEEKDAY(Created) in(1, 2, 3, 4) and TIME(Created) 
 '08:00:00' and TIME(Created)  '16:00:00') or (WEEKDAY(Created)=5
 and TIME(Created)  '08:00:00' and TIME(Created)  '15:30:00'))
 
 
 If you put the statement after the where-clause into the method
 FormSQL of the class RT::Ticket, you will not get the right results,
 but /all/ tickets.

FromSQL isn't SQL, it is TicketSQL.  I bet it is throwing away a
number of your constructs that it doesn't understand.  You may be able
to construct what you need using a vanilla Limit and the FUNCTION
arguments.

-kevin

 I do not know why that method does not work. Does anybody have any
 hints? Or is it just impossible to do so?
 
 Greetings,
 
 Wolfram
 
 
 
 
 RT Training in Washington DC, USA on Oct 25  26 2010
 Last one this year -- Learn how to get the most out of RT!


pgpUGtM3AKe2F.pgp
Description: PGP signature

RT Training in Washington DC, USA on Oct 25  26 2010
Last one this year -- Learn how to get the most out of RT!

[rt-users] User Information

2010-09-03 Thread Peter Barton
I have had some wonderful help getting my user information pulled from
AD into my RT installation.  Now I am looking at ways to present this to
the technicians.  We use our RT installation for our technical support
helpdesk and most of our tickets are opened via E-Mail.  

I want to present the user information on the main screen of each ticket
instead of having to click into the More about u...@info.com.  I have
looked at the SideBySideView extension, but that does not look like it
can be used for user info.  Please correct me if I am wrong.

Does anyone know of an already contributed way to do what I am looking
for?

Thanks,

--
Peter Barton

RT Training in Washington DC, USA on Oct 25  26 2010
Last one this year -- Learn how to get the most out of RT!


[rt-users] RT Dashboard result limits problem

2010-09-03 Thread Kenneth Crocker
To list (again),

I have a dashboard that I set up with *unlimited* as the number of rows.
My results should have been about 485 lines. Instead, my email had 20 rows.
I re-set it for *100* rows and I got 100 rows in the email. That was good.

So, I'm trying to figure out why *unlimited* produces results of 20 rows
and all the others work fine.

Has anyone else had a problem with Query result limits in an email from a
dashboard?

Thanks for your help.

Kenn
LBNL

RT Training in Washington DC, USA on Oct 25  26 2010
Last one this year -- Learn how to get the most out of RT!

Re: [rt-users] Webmux.pl crashes Apache22 on FreeBSD 8.1

2010-09-03 Thread Kevin Falcone
On Thu, Sep 02, 2010 at 02:51:48PM -0700, dill weed wrote:
 I don't have access to the server until Monday to run make testdeps,
 but the version of Stacktrace that I'm using is p5-Devel-StackTrace
 1.23 from the FreeBSD ports collection.

Looks like the CPAN author made a mistake with 1.23.  He has released
1.24 to rectify it.

http://cpansearch.perl.org/src/DROLSKY/Devel-StackTrace-1.24/Changes

-kevin

 On Thu, Sep 2, 2010 at 2:20 PM, Jesse Vincent je...@bestpractical.com wrote:
 
 
 
  On Thu, Sep 02, 2010 at 02:16:06PM -0700, dill weed wrote:
  I recently updated my installation of rt38 from the ports collection
  on FreeBSD 8.1 and found that webmux.pl will not allow apache22 to
  start.  Here is a copy of the error that I'm am receiving:
 
 
  make testdeps from the RT build directory?
  Also, what version of Devel::StackTrace is installed?
 
 
  [Wed Sep 01 11:01:08 2010] [error] Devel::StackTrace does not define
  $Devel::StackTrace::VERSION--version check failed at
  /usr/local/lib/perl5/site_perl/5.10.1/Exception/Class/Base.pm line
  10.\nBEGIN failed--compilation aborted at
  /usr/local/lib/perl5/site_perl/5.10.1/Exception/Class/Base.pm line
  10.\nCompilation failed in require at
  /usr/local/lib/perl5/site_perl/5.10.1/Exception/Class.pm line
  10.\nBEGIN failed--compilation aborted at
  /usr/local/lib/perl5/site_perl/5.10.1/Exception/Class.pm line
  10.\nCompilation failed in require at
  /usr/local/lib/perl5/site_perl/5.10.1/HTML/Mason/Exceptions.pm line
  73.\nBEGIN failed--compilation aborted at
  /usr/local/lib/perl5/site_perl/5.10.1/HTML/Mason/Exceptions.pm line
  73.\nCompilation failed in require at
  /usr/local/lib/perl5/site_perl/5.10.1/HTML/Mason/Tools.pm line
  18.\nBEGIN failed--compilation aborted at
  /usr/local/lib/perl5/site_perl/5.10.1/HTML/Mason/Tools.pm line
  18.\nCompilation failed in require at
  /usr/local/lib/perl5/site_perl/5.10.1/HTML/Mason/Request.pm line
  41.\nBEGIN failed--compilation aborted at
  /usr/local/lib/perl5/site_perl/5.10.1/HTML/Mason/Request.pm line
  41.\nCompilation failed in require at (eval 1218) line
  3.\n\t...propagated at /usr/local/lib/perl5/5.10.1/base.pm line
  94.\nBEGIN failed--compilation aborted at
  /usr/local/lib/perl5/site_perl/5.10.1/RT/Interface/Web/Request.pm line
  55.\nCompilation failed in require at
  /usr/local/lib/perl5/site_perl/5.10.1/RT/Interface/Web/Handler.pm line
  60.\nBEGIN failed--compilation aborted at
  /usr/local/lib/perl5/site_perl/5.10.1/RT/Interface/Web/Handler.pm line
  60.\nCompilation failed in require at /usr/local/bin/webmux.pl line
  150.\nCompilation failed in require at (eval 4) line 1.\n
 
  [Wed Sep 01 11:01:08 2010] [error] Can't load Perl file:
  /usr/local/bin/webmux.pl for serve blah.blah.home:0, exiting...
 
  However when I comment out the webmux.pl line from my httpd.conf the
  server starts fine.  I'm not sure why the error is coming from
  Devel::StrackTrace and I'm not sure how to fix this error.  I'm
  anxious to hear what tips other users might have.
 
  Everything is update as far as the ports collection is concerned. I'm
  running FreeBSD 8.1, apache 2.2.16, mod_perl2 2.0.4, mysql
  5.1.(something).  All items were installed from the ports collection.
 
  Thank you in advance for the help,
  Reid
 
  RT Training in Washington DC, USA on Oct 25  26 2010
  Last one this year -- Learn how to get the most out of RT!
 
  --
 
 
 RT Training in Washington DC, USA on Oct 25  26 2010
 Last one this year -- Learn how to get the most out of RT!


pgpzM9PNcbxBq.pgp
Description: PGP signature

RT Training in Washington DC, USA on Oct 25  26 2010
Last one this year -- Learn how to get the most out of RT!

Re: [rt-users] RT Dashboard result limits problem

2010-09-03 Thread Emmanuel Lacour
On Fri, Sep 03, 2010 at 09:12:02AM -0700, Kenneth Crocker wrote:
To list (again),
 
I have a dashboard that I set up with unlimited as the number of rows.
My results should have been about 485 lines. Instead, my email had 20
rows. I re-set it for 100 rows and I got 100 rows in the email. That was
good.
 
So, I'm trying to figure out why unlimited produces results of 20 rows
and all the others work fine.
 
Has anyone else had a problem with Query result limits in an email from a
dashboard?
 

well should fit in one of those issues:

http://issues.bestpractical.com/Ticket/Display.html?id=13913
http://issues.bestpractical.com/Ticket/Display.html?id=15541

;)

RT Training in Washington DC, USA on Oct 25  26 2010
Last one this year -- Learn how to get the most out of RT!


[rt-users] Can't get ExternalAuth to work with Windows 2003 AD

2010-09-03 Thread John Alberts

 I have a brand new install of RT 3.8.8 on CentOS 5.5 with the
RT-Authen-ExternalAuth.  No matter what I do, I can't seem to get RT to
let me log in with my AD login.  I've tried changing the filter options,
etc with no luck.  The debug log seems to indicate that it can't bind
with the LDAP server; however, I can successfully bind with the same
user and filters using ldapsearch and also a small test script that I
wrote which uses Net::LDAP.

I have my RT_Siteconfig.pm, debug log, ldapsearch example, and test
script all in the following gist:
https://gist.github.com/1ba81d5642611de654f9

I would appreciate any suggestions.

--
John Alberts
Hosted Services
Exlibris USA
john.albe...@exlibrisgroup.com
cell: 1-508-878-2197


RT Training in Washington DC, USA on Oct 25  26 2010
Last one this year -- Learn how to get the most out of RT!

[rt-users] embed link in email notification

2010-09-03 Thread charlie
How would I include a link to a newly created ticket in the email text
that is sent to requestors?

thanks,

-- 
Charlie Farinella
Appropriate Solutions, Inc.
603.924.6079


RT Training in Washington DC, USA on Oct 25  26 2010
Last one this year -- Learn how to get the most out of RT!


Re: [rt-users] User Information

2010-09-03 Thread Peter Barton
Well I found RT-Extension-UserDetails and am very excited about it.  The
install seems very easy.  I applied the patch as per the instructions in
the README.  I am running RT-3.8.6 so I needed to apply the patch.  I am
no Linux Admin, but I did the following:

Cd /opt/rt3/
patch -p1 
/opt/rt3/src/RT-Extension-UserDetails-0.01/patches/callbacks-3.8.patch

It ran with no errors.

I followed the rest of the README with no problems.  I then restarted
apache and not I had a little link bubble to the right of my user's
names.  However with I passed my mouse over it all that popped up in the
window is Details.  When I actually clicked on the bubble I got the
following error:

 RT::User:: Unimplemented in HTML::Mason::Commands.
(/opt/rt3/local/plugins/RT-Extension-UserDetails/html/Elements/ShowUserD
etails line 10)

I was able to verify when I moused over the bubble in the bottom of my
web browser it reflected the correct user #.

After messing around with it with no luck I decided to upgrade my test
RT installation to 3.8.8 and I am still having the exact same problems.

Any help would be appreciated.

Thanks,

--
Peter Barton


-Original Message-
From: rt-users-boun...@lists.bestpractical.com
[mailto:rt-users-boun...@lists.bestpractical.com] On Behalf Of Peter
Barton
Sent: Friday, September 03, 2010 10:02 AM
To: rt-users@lists.bestpractical.com
Subject: [rt-users] User Information

I have had some wonderful help getting my user information pulled from
AD into my RT installation.  Now I am looking at ways to present this to
the technicians.  We use our RT installation for our technical support
helpdesk and most of our tickets are opened via E-Mail.  

I want to present the user information on the main screen of each ticket
instead of having to click into the More about u...@info.com.  I have
looked at the SideBySideView extension, but that does not look like it
can be used for user info.  Please correct me if I am wrong.

Does anyone know of an already contributed way to do what I am looking
for?

Thanks,

--
Peter Barton

RT Training in Washington DC, USA on Oct 25  26 2010
Last one this year -- Learn how to get the most out of RT!

RT Training in Washington DC, USA on Oct 25  26 2010
Last one this year -- Learn how to get the most out of RT!


Re: [rt-users] embed link in email notification

2010-09-03 Thread Mark Jenks
I just added this to mine.


In the Global Autoreply template, I added:

You can check the current status and history of the request at:

{RT-Config-Get('WebURL')}Ticket/Display.html?id={$Ticket-id}


To the end before the thank you.

-Mark

-Original Message-
From: rt-users-boun...@lists.bestpractical.com
[mailto:rt-users-boun...@lists.bestpractical.com] On Behalf Of charlie
Sent: Friday, September 03, 2010 2:11 PM
To: rt-users@lists.bestpractical.com
Subject: [rt-users] embed link in email notification

How would I include a link to a newly created ticket in the email text
that is sent to requestors?

thanks,

-- 
Charlie Farinella
Appropriate Solutions, Inc.
603.924.6079


RT Training in Washington DC, USA on Oct 25  26 2010
Last one this year -- Learn how to get the most out of RT!

CONFIDENTIALITY NOTICE:  The information contained in this email message, 
including any attachments, may be 
privileged, confidential and otherwise protected from disclosure.  If the 
reader of this message is not the 
intended recipient, you are hereby notified that any use, dissemination, 
distribution or copying of this 
message, including any attachments, is strictly prohibited.  If you have 
received this email message in 
error, please notify the sender by reply email and delete/destroy the email 
message, including attachments, 
and any copies thereof.  Although we have taken precautions to minimize the 
risk of transmitting viruses via 
email and attachments thereto, we do not guarantee that either is virus-free, 
and we accept no liability for 
any damages sustained as a result of any such viruses.

RT Training in Washington DC, USA on Oct 25  26 2010
Last one this year -- Learn how to get the most out of RT!


Re: [rt-users] Webmux.pl crashes Apache22 on FreeBSD 8.1

2010-09-03 Thread dill weed
Thanks that good information. When I get back into work next week,
I'll give that a go.  I'm sure that is what the problem is.

Thank you everyone for the help.
Reid

On Fri, Sep 3, 2010 at 9:17 AM, Kevin Falcone falc...@bestpractical.com wrote:
 On Thu, Sep 02, 2010 at 02:51:48PM -0700, dill weed wrote:
 I don't have access to the server until Monday to run make testdeps,
 but the version of Stacktrace that I'm using is p5-Devel-StackTrace
 1.23 from the FreeBSD ports collection.

 Looks like the CPAN author made a mistake with 1.23.  He has released
 1.24 to rectify it.

 http://cpansearch.perl.org/src/DROLSKY/Devel-StackTrace-1.24/Changes

 -kevin

 On Thu, Sep 2, 2010 at 2:20 PM, Jesse Vincent je...@bestpractical.com 
 wrote:
 
 
 
  On Thu, Sep 02, 2010 at 02:16:06PM -0700, dill weed wrote:
  I recently updated my installation of rt38 from the ports collection
  on FreeBSD 8.1 and found that webmux.pl will not allow apache22 to
  start.  Here is a copy of the error that I'm am receiving:
 
 
  make testdeps from the RT build directory?
  Also, what version of Devel::StackTrace is installed?
 
 
  [Wed Sep 01 11:01:08 2010] [error] Devel::StackTrace does not define
  $Devel::StackTrace::VERSION--version check failed at
  /usr/local/lib/perl5/site_perl/5.10.1/Exception/Class/Base.pm line
  10.\nBEGIN failed--compilation aborted at
  /usr/local/lib/perl5/site_perl/5.10.1/Exception/Class/Base.pm line
  10.\nCompilation failed in require at
  /usr/local/lib/perl5/site_perl/5.10.1/Exception/Class.pm line
  10.\nBEGIN failed--compilation aborted at
  /usr/local/lib/perl5/site_perl/5.10.1/Exception/Class.pm line
  10.\nCompilation failed in require at
  /usr/local/lib/perl5/site_perl/5.10.1/HTML/Mason/Exceptions.pm line
  73.\nBEGIN failed--compilation aborted at
  /usr/local/lib/perl5/site_perl/5.10.1/HTML/Mason/Exceptions.pm line
  73.\nCompilation failed in require at
  /usr/local/lib/perl5/site_perl/5.10.1/HTML/Mason/Tools.pm line
  18.\nBEGIN failed--compilation aborted at
  /usr/local/lib/perl5/site_perl/5.10.1/HTML/Mason/Tools.pm line
  18.\nCompilation failed in require at
  /usr/local/lib/perl5/site_perl/5.10.1/HTML/Mason/Request.pm line
  41.\nBEGIN failed--compilation aborted at
  /usr/local/lib/perl5/site_perl/5.10.1/HTML/Mason/Request.pm line
  41.\nCompilation failed in require at (eval 1218) line
  3.\n\t...propagated at /usr/local/lib/perl5/5.10.1/base.pm line
  94.\nBEGIN failed--compilation aborted at
  /usr/local/lib/perl5/site_perl/5.10.1/RT/Interface/Web/Request.pm line
  55.\nCompilation failed in require at
  /usr/local/lib/perl5/site_perl/5.10.1/RT/Interface/Web/Handler.pm line
  60.\nBEGIN failed--compilation aborted at
  /usr/local/lib/perl5/site_perl/5.10.1/RT/Interface/Web/Handler.pm line
  60.\nCompilation failed in require at /usr/local/bin/webmux.pl line
  150.\nCompilation failed in require at (eval 4) line 1.\n
 
  [Wed Sep 01 11:01:08 2010] [error] Can't load Perl file:
  /usr/local/bin/webmux.pl for serve blah.blah.home:0, exiting...
 
  However when I comment out the webmux.pl line from my httpd.conf the
  server starts fine.  I'm not sure why the error is coming from
  Devel::StrackTrace and I'm not sure how to fix this error.  I'm
  anxious to hear what tips other users might have.
 
  Everything is update as far as the ports collection is concerned. I'm
  running FreeBSD 8.1, apache 2.2.16, mod_perl2 2.0.4, mysql
  5.1.(something).  All items were installed from the ports collection.
 
  Thank you in advance for the help,
  Reid
 
  RT Training in Washington DC, USA on Oct 25  26 2010
  Last one this year -- Learn how to get the most out of RT!
 
  --
 

 RT Training in Washington DC, USA on Oct 25  26 2010
 Last one this year -- Learn how to get the most out of RT!


 RT Training in Washington DC, USA on Oct 25  26 2010
 Last one this year -- Learn how to get the most out of RT!


RT Training in Washington DC, USA on Oct 25  26 2010
Last one this year -- Learn how to get the most out of RT!


Re: [rt-users] embed link in email notification

2010-09-03 Thread Emmanuel Lacour
On Fri, Sep 03, 2010 at 03:10:46PM -0400, charlie wrote:
 How would I include a link to a newly created ticket in the email text
 that is sent to requestors?
 


Add something like this:

URL: {RT-Config-Get('WebURL')}Ticket/Display.html?id={$Ticket-id}

in Configuration-Global-Template-Autoreply




RT Training in Washington DC, USA on Oct 25  26 2010
Last one this year -- Learn how to get the most out of RT!


Re: [rt-users] User Information

2010-09-03 Thread Peter Barton
I ended up making a change to my RT_SiteConfig.pm and it started
working.  I am using FireFox 3.6.8 and it works great.  However as noted
by Steve McStravick this is not working with IE8.  He posted something
about it on August 17th entitled RT-Extension-UserDetails not working
with IE8.  Has anyone found a fix for this?

--
Peter Barton


-Original Message-
From: rt-users-boun...@lists.bestpractical.com
[mailto:rt-users-boun...@lists.bestpractical.com] On Behalf Of Peter
Barton
Sent: Friday, September 03, 2010 2:14 PM
To: rt-users@lists.bestpractical.com
Cc: elac...@home-dn.net
Subject: Re: [rt-users] User Information

Well I found RT-Extension-UserDetails and am very excited about it.  The
install seems very easy.  I applied the patch as per the instructions in
the README.  I am running RT-3.8.6 so I needed to apply the patch.  I am
no Linux Admin, but I did the following:

Cd /opt/rt3/
patch -p1 
/opt/rt3/src/RT-Extension-UserDetails-0.01/patches/callbacks-3.8.patch

It ran with no errors.

I followed the rest of the README with no problems.  I then restarted
apache and not I had a little link bubble to the right of my user's
names.  However with I passed my mouse over it all that popped up in the
window is Details.  When I actually clicked on the bubble I got the
following error:

 RT::User:: Unimplemented in HTML::Mason::Commands.
(/opt/rt3/local/plugins/RT-Extension-UserDetails/html/Elements/ShowUserD
etails line 10)

I was able to verify when I moused over the bubble in the bottom of my
web browser it reflected the correct user #.

After messing around with it with no luck I decided to upgrade my test
RT installation to 3.8.8 and I am still having the exact same problems.

Any help would be appreciated.

Thanks,

--
Peter Barton


-Original Message-
From: rt-users-boun...@lists.bestpractical.com
[mailto:rt-users-boun...@lists.bestpractical.com] On Behalf Of Peter
Barton
Sent: Friday, September 03, 2010 10:02 AM
To: rt-users@lists.bestpractical.com
Subject: [rt-users] User Information

I have had some wonderful help getting my user information pulled from
AD into my RT installation.  Now I am looking at ways to present this to
the technicians.  We use our RT installation for our technical support
helpdesk and most of our tickets are opened via E-Mail.  

I want to present the user information on the main screen of each ticket
instead of having to click into the More about u...@info.com.  I have
looked at the SideBySideView extension, but that does not look like it
can be used for user info.  Please correct me if I am wrong.

Does anyone know of an already contributed way to do what I am looking
for?

Thanks,

--
Peter Barton

RT Training in Washington DC, USA on Oct 25  26 2010
Last one this year -- Learn how to get the most out of RT!

RT Training in Washington DC, USA on Oct 25  26 2010
Last one this year -- Learn how to get the most out of RT!

RT Training in Washington DC, USA on Oct 25  26 2010
Last one this year -- Learn how to get the most out of RT!


Re: [rt-users] Can't get ExternalAuth to work with Windows 2003 AD

2010-09-03 Thread Peter Barton
I just got my ExternalAuth working and the one thing I had to mess with
was the authenticating user.  I used a syntax like this:

 

'user'  =
'cn=rtuser,cn=users,dc=iesicorp,dc=tf,dc=prv',

 

--

Peter Barton

IESI Corporation

Network Manager

work.817-632-4000

mobile.817-683-9635

 

From: rt-users-boun...@lists.bestpractical.com
[mailto:rt-users-boun...@lists.bestpractical.com] On Behalf Of John
Alberts
Sent: Friday, September 03, 2010 11:54 AM
To: rt-users@lists.bestpractical.com
Subject: [rt-users] Can't get ExternalAuth to work with Windows 2003 AD

 

I have a brand new install of RT 3.8.8 on CentOS 5.5 with the
RT-Authen-ExternalAuth.  No matter what I do, I can't seem to get RT to
let me log in with my AD login.  I've tried changing the filter options,
etc with no luck.  The debug log seems to indicate that it can't bind
with the LDAP server; however, I can successfully bind with the same
user and filters using ldapsearch and also a small test script that I
wrote which uses Net::LDAP.

I have my RT_Siteconfig.pm, debug log, ldapsearch example, and test
script all in the following gist:
https://gist.github.com/1ba81d5642611de654f9

I would appreciate any suggestions. 

-- 
John Alberts
Hosted Services
Exlibris USA
john.albe...@exlibrisgroup.com
cell: 1-508-878-2197

RT Training in Washington DC, USA on Oct 25  26 2010
Last one this year -- Learn how to get the most out of RT!

Re: [rt-users] embed link in email notification

2010-09-03 Thread charlie
On Fri, 2010-09-03 at 21:16 +0200, Emmanuel Lacour wrote:
 On Fri, Sep 03, 2010 at 03:10:46PM -0400, charlie wrote:
  How would I include a link to a newly created ticket in the email text
  that is sent to requestors?
  
 
 
 Add something like this:
 
 URL: {RT-Config-Get('WebURL')}Ticket/Display.html?id={$Ticket-id}
 
 in Configuration-Global-Template-Autoreply
 

You can tell I'm new.  :-)

Thanks to all, this is just what I was looking for.

-- 
Charlie Farinella
Appropriate Solutions, Inc.
603.924.6079


RT Training in Washington DC, USA on Oct 25  26 2010
Last one this year -- Learn how to get the most out of RT!


Re: [rt-users] Can't get ExternalAuth to work with Windows 2003 AD

2010-09-03 Thread John Alberts

 Thanks for you response Pete.

I just figured out what it was.

At some point, I changed the 'pass' variable name to 'password'. 

That's all it was.  :/

John



On 09/03/2010 02:52 PM, Peter Barton wrote:


I just got my ExternalAuth working and the one thing I had to mess 
with was the authenticating user.  I used a syntax like this:


'user'  =  
'cn=rtuser,cn=users,dc=iesicorp,dc=tf,dc=prv',


--

Peter Barton

IESI Corporation

Network Manager

work.817-632-4000

mobile.817-683-9635

*From:* rt-users-boun...@lists.bestpractical.com 
[mailto:rt-users-boun...@lists.bestpractical.com] *On Behalf Of *John 
Alberts

*Sent:* Friday, September 03, 2010 11:54 AM
*To:* rt-users@lists.bestpractical.com
*Subject:* [rt-users] Can't get ExternalAuth to work with Windows 2003 AD

I have a brand new install of RT 3.8.8 on CentOS 5.5 with the
RT-Authen-ExternalAuth.  No matter what I do, I can't seem to get RT to
let me log in with my AD login.  I've tried changing the filter options,
etc with no luck.  The debug log seems to indicate that it can't bind
with the LDAP server; however, I can successfully bind with the same
user and filters using ldapsearch and also a small test script that I
wrote which uses Net::LDAP.

I have my RT_Siteconfig.pm, debug log, ldapsearch example, and test
script all in the following gist:
https://gist.github.com/1ba81d5642611de654f9

I would appreciate any suggestions.

--
John Alberts
Hosted Services
Exlibris USA
john.albe...@exlibrisgroup.com  mailto:john.albe...@exlibrisgroup.com
cell: 1-508-878-2197


--
John Alberts
Hosted Services
Exlibris USA
john.albe...@exlibrisgroup.com
cell: 1-508-878-2197


RT Training in Washington DC, USA on Oct 25  26 2010
Last one this year -- Learn how to get the most out of RT!

Re: [rt-users] User Information

2010-09-03 Thread Emmanuel Lacour
On Fri, Sep 03, 2010 at 02:14:07PM -0500, Peter Barton wrote:
 
  RT::User:: Unimplemented in HTML::Mason::Commands.
 (/opt/rt3/local/plugins/RT-Extension-UserDetails/html/Elements/ShowUserD
 etails line 10)
 

fixed in git (bad handling of default settings, when you don't set a
setting yourself).

RT Training in Washington DC, USA on Oct 25  26 2010
Last one this year -- Learn how to get the most out of RT!


Re: [rt-users] User Information

2010-09-03 Thread Emmanuel Lacour
On Fri, Sep 03, 2010 at 02:43:39PM -0500, Peter Barton wrote:
 I ended up making a change to my RT_SiteConfig.pm and it started
 working.  I am using FireFox 3.6.8 and it works great.  However as noted
 by Steve McStravick this is not working with IE8.  He posted something
 about it on August 17th entitled RT-Extension-UserDetails not working
 with IE8.  Has anyone found a fix for this?
 

fixed in git (missing ending part of a tag :():

http://git.home-dn.net/?p=manu/RT-Extension-UserDetails.git;a=summary


RT Training in Washington DC, USA on Oct 25  26 2010
Last one this year -- Learn how to get the most out of RT!