Re: [rt-users] Combining Apache Auth with RT:Authen:External overlays

2009-10-08 Thread Ruslan Zakirov
David,

Do you use some SingleSignOn solution? If it's not the case then why
do you need apache auth at all?

On Thu, Oct 8, 2009 at 4:51 AM, David Nillesen dnill...@une.edu.au wrote:
 Hi,



     I’ve been trying to get this to work for a bit, but am not
 having any luck.



 o   What I would like is to use Apache authentication via LDAP, so that all
 the apps on our server running RT are using the same auth system.

 o   Then I would like to use an LDAP overlay so that users are driven with
 current information from our LDAP system.



 So far, I’ve had RT-Authen-ExternalAuth working, but not in combination with
 Apache Auth. RT External Auth works fine, but forces people to log in
 multiple times to the system,

 once for Apache and once for RT. The way users are handled inside
 RT-Authen-ExternalAuth is excellent and ideal for my case.



 Is there any way to tie this to Apache Basic Auth?



 I would use an LDAP overlay, but all the docs seem to have been pulled from
 the wiki and now point back to the RT-Authen-ExternalAuth module.



 I’m running the latest 3.8 RT with 0.08 RT-Authen-ExternalAuth.



 My other option appears to be to use an SSO cookie auth system and protect
 my server that way and get RT-Authen-ExternalAuth to use the cookie. I was
 really trying to avoid this however as it is massive overkill, well IMO.



 Thanks for your time,

 Dave



 ___
 http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

 Community help: http://wiki.bestpractical.com
 Commercial support: sa...@bestpractical.com


 Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
 Buy a copy at http://rtbook.bestpractical.com




-- 
Best regards, Ruslan.
___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: sa...@bestpractical.com


Discover RT's hidden secrets with RT Essentials from O'Reilly Media. 
Buy a copy at http://rtbook.bestpractical.com

Re: [rt-users] rt at a glance components

2009-10-08 Thread Emmanuel Lacour
On Thu, Oct 08, 2009 at 09:27:14AM +0100, G.Booth wrote:
 Hi
 
 Does anybody know if there is an easy way to make a clone of a component on 
 the RT at a glance page (MyRT.html) ? e.g. take a copy of QuickCreate and 
 have a QuickCreate2.
 

copy share/html/Elements/Quicksearch to local/html/Elements/Quicksearch2
modify it to suit your needs
add it to RT_Site_Config.pm:

Set($HomepageComponents, [qw(QuickCreate Quicksearch MyAdminQueues
MySupportQueues MyReminders RefreshHomepage Dashboards Quicksearch2)]);

restart webserver
___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: sa...@bestpractical.com


Discover RT's hidden secrets with RT Essentials from O'Reilly Media. 
Buy a copy at http://rtbook.bestpractical.com


Re: [rt-users] Combining Apache Auth with RT:Authen:External overlays

2009-10-08 Thread David Nillesen
For our area which is essentially the datacentre staff, we have a variety of 
applications, such as nagios, (hopefully) request tracker, a blog, wiki, 
fileshare etc etc all running of a single webserver that forms the home of 
our activities and documentation.

I'd like to reduce it to a single login to get on and move around freely.

Though even as I explain it, it is going to make more sense with an SSO 
solution. I might take another look at webauth. It's one more thing to run, but 
may be simpler in total.

Thanks,
Dave

-Original Message-
From: Ruslan Zakirov [mailto:ruslan.zaki...@gmail.com] 
Sent: Thursday, 8 October 2009 6:07 PM
To: David Nillesen
Cc: rt-users@lists.bestpractical.com
Subject: Re: [rt-users] Combining Apache Auth with RT:Authen:External overlays

David,

Do you use some SingleSignOn solution? If it's not the case then why
do you need apache auth at all?

On Thu, Oct 8, 2009 at 4:51 AM, David Nillesen dnill...@une.edu.au wrote:
 Hi,



     I’ve been trying to get this to work for a bit, but am not
 having any luck.



 o   What I would like is to use Apache authentication via LDAP, so that all
 the apps on our server running RT are using the same auth system.

 o   Then I would like to use an LDAP overlay so that users are driven with
 current information from our LDAP system.



 So far, I’ve had RT-Authen-ExternalAuth working, but not in combination with
 Apache Auth. RT External Auth works fine, but forces people to log in
 multiple times to the system,

 once for Apache and once for RT. The way users are handled inside
 RT-Authen-ExternalAuth is excellent and ideal for my case.



 Is there any way to tie this to Apache Basic Auth?



 I would use an LDAP overlay, but all the docs seem to have been pulled from
 the wiki and now point back to the RT-Authen-ExternalAuth module.



 I’m running the latest 3.8 RT with 0.08 RT-Authen-ExternalAuth.



 My other option appears to be to use an SSO cookie auth system and protect
 my server that way and get RT-Authen-ExternalAuth to use the cookie. I was
 really trying to avoid this however as it is massive overkill, well IMO.



 Thanks for your time,

 Dave



 ___
 http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

 Community help: http://wiki.bestpractical.com
 Commercial support: sa...@bestpractical.com


 Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
 Buy a copy at http://rtbook.bestpractical.com




-- 
Best regards, Ruslan.

No virus found in this incoming message.
Checked by AVG - www.avg.com 
Version: 8.5.421 / Virus Database: 270.14.7/2421 - Release Date: 10/07/09 
20:49:00
___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: sa...@bestpractical.com


Discover RT's hidden secrets with RT Essentials from O'Reilly Media. 
Buy a copy at http://rtbook.bestpractical.com

Re: [rt-users] Combining Apache Auth with RT:Authen:External overlays

2009-10-08 Thread Ruslan Zakirov
Got it. You want SSO. Probably it's easy to fix in ExternalAuth extension.

On Thu, Oct 8, 2009 at 2:12 PM, David Nillesen dnill...@une.edu.au wrote:
 For our area which is essentially the datacentre staff, we have a variety of 
 applications, such as nagios, (hopefully) request tracker, a blog, wiki, 
 fileshare etc etc all running of a single webserver that forms the home of 
 our activities and documentation.

 I'd like to reduce it to a single login to get on and move around freely.

 Though even as I explain it, it is going to make more sense with an SSO 
 solution. I might take another look at webauth. It's one more thing to run, 
 but may be simpler in total.

 Thanks,
 Dave

 -Original Message-
 From: Ruslan Zakirov [mailto:ruslan.zaki...@gmail.com]
 Sent: Thursday, 8 October 2009 6:07 PM
 To: David Nillesen
 Cc: rt-users@lists.bestpractical.com
 Subject: Re: [rt-users] Combining Apache Auth with RT:Authen:External overlays

 David,

 Do you use some SingleSignOn solution? If it's not the case then why
 do you need apache auth at all?

 On Thu, Oct 8, 2009 at 4:51 AM, David Nillesen dnill...@une.edu.au wrote:
 Hi,



     I’ve been trying to get this to work for a bit, but am not
 having any luck.



 o   What I would like is to use Apache authentication via LDAP, so that all
 the apps on our server running RT are using the same auth system.

 o   Then I would like to use an LDAP overlay so that users are driven with
 current information from our LDAP system.



 So far, I’ve had RT-Authen-ExternalAuth working, but not in combination with
 Apache Auth. RT External Auth works fine, but forces people to log in
 multiple times to the system,

 once for Apache and once for RT. The way users are handled inside
 RT-Authen-ExternalAuth is excellent and ideal for my case.



 Is there any way to tie this to Apache Basic Auth?



 I would use an LDAP overlay, but all the docs seem to have been pulled from
 the wiki and now point back to the RT-Authen-ExternalAuth module.



 I’m running the latest 3.8 RT with 0.08 RT-Authen-ExternalAuth.



 My other option appears to be to use an SSO cookie auth system and protect
 my server that way and get RT-Authen-ExternalAuth to use the cookie. I was
 really trying to avoid this however as it is massive overkill, well IMO.



 Thanks for your time,

 Dave



 ___
 http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

 Community help: http://wiki.bestpractical.com
 Commercial support: sa...@bestpractical.com


 Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
 Buy a copy at http://rtbook.bestpractical.com




 --
 Best regards, Ruslan.

 No virus found in this incoming message.
 Checked by AVG - www.avg.com
 Version: 8.5.421 / Virus Database: 270.14.7/2421 - Release Date: 10/07/09 
 20:49:00




-- 
Best regards, Ruslan.
___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: sa...@bestpractical.com


Discover RT's hidden secrets with RT Essentials from O'Reilly Media. 
Buy a copy at http://rtbook.bestpractical.com

Re: [rt-users] email filter that sets ticket via subject lookup?

2009-10-08 Thread Kevin Falcone
On Wed, Oct 07, 2009 at 11:24:50PM -0500, Robert Eden wrote:
 Howdy All.
 
 We work with a vendor and store the vendor's ticket # in a custom field.
 
 We'd like to be able to add a comment to the RT ticket by ccing  RT on 
 vendor email. The subject of the message contains the vendor ticket 
 number, and I'll determine the RT # via a search.
 
 I'm trying to figure out the best way to do this. The Right method 
 appears to be a custom  RT::Interface::Email module, but the only hook 
 appears to be GetCurrentUser and there's no way to set ticket number or 
 modify the message.   I looked at the code and don't see a 
 GetCurrentTicket callback.   Are the  RT::Interface::Email modules 
 only good for authentication?
 
 Another method is to replace the  rt-mailgate script with one of my 
 own.   This seems like an excessive hack into RT internals.  Is there 
 a more official way?

You may just want to borrow the Nagios scrips on the wiki and On
Create find the existing ticket you need to merge into and set the CF
from there.  You'll find the Scrip Action interface to be a lot easier
to do what you need (since the tickets exist and you can set
properties).

-kevin


pgpyS2Hx5rwMC.pgp
Description: PGP signature
___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: sa...@bestpractical.com


Discover RT's hidden secrets with RT Essentials from O'Reilly Media. 
Buy a copy at http://rtbook.bestpractical.com

[rt-users] Autofill CFs from LDAP

2009-10-08 Thread Lander, Scott
I am sure this has come up and been dealt with before, but, I can't seem to 
find a solution anywhere.

We authenticate our RT users via ldap, and one of the things it picks up is the 
users phone number.I would like to include that information in the new 
ticket screen - IE, have a field that defaults to their phone number that they 
can overwrite.

I have a CF (currently empty) on the screen for phone number.   The question, 
of course, is how do I populate it with the info from ldap, much like the 
requesters email address is populated?

Thanks


This e-mail message is intended only for the personal use of the recipient(s) 
named above. If you are not an intended recipient, you may not review, copy or 
distribute this message. If you have received this communication in error, 
please notify the Hearst Service Center (cad...@hearstsc.com) immediately by 
email and delete the original message.

___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: sa...@bestpractical.com


Discover RT's hidden secrets with RT Essentials from O'Reilly Media. 
Buy a copy at http://rtbook.bestpractical.com

[rt-users] Partial upgrade form 3.6.1 to 3.8.5

2009-10-08 Thread Nicolas GUIOT
Hi,

I had a debian-packaged (etch) RT on a box and new options from 3.8 are 
interesting to us, so I plan to install a brand new RT install from sources, 
but would like to keep my existing DB.

Correct me if I'm wrong : 
I juste need to do the RT setup, without the DB creation, run the DB upgrade 
script, et voilà ??

Thanks for your attention

--
Nicolas GUIOT
Risc Group - Service Production Exploitation
Alcatel/CTI - Av. du Gal de Gaulle
45140 ORMES - FRANCE
Tel : (+33) 2 38 71 84 98
Fax : (+33) 2 38 75 76 92
___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: sa...@bestpractical.com


Discover RT's hidden secrets with RT Essentials from O'Reilly Media. 
Buy a copy at http://rtbook.bestpractical.com

[rt-users] Error in viewing one ticket

2009-10-08 Thread Lander, Scott
I have one ticket that, when I go to view it, it displays about a half of the 
details and then give the following error:

Can't call method Name on an undefined value at 
/opt/rt3/bin/../lib/RT/Transaction_Overlay.pm line 700.


Any one have any idea what could cause this?




This e-mail message is intended only for the personal use of the recipient(s) 
named above. If you are not an intended recipient, you may not review, copy or 
distribute this message. If you have received this communication in error, 
please notify the Hearst Service Center (cad...@hearstsc.com) immediately by 
email and delete the original message.

___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: sa...@bestpractical.com


Discover RT's hidden secrets with RT Essentials from O'Reilly Media. 
Buy a copy at http://rtbook.bestpractical.com

[rt-users] Finding the current user for a reply (scrips)

2009-10-08 Thread Howard Jones
I'm trying to write a scrip to set a ticket's status based on who
replies to it - if it's staff, set it to stalled, if it's not, set to open.

I currently have an OnCorrespond condition, and a custom Action, but I'm
not seeing the user I expect from the Transaction object.

$RT::Logger-warning(Welcome to Scrip 13);

# get actor ID
my $trans = $self-TransactionObj;
my $Ticket = $trans-TicketObj;
my $Actor = $self-CurrentUser();

$RT::Logger-warning(ref($Ticket). .ref($Actor));

# if actor is RT_SystemUser then get out of here
return 1 if $Actor == $RT::SystemUser-id;

$RT::Logger-warning(Actor is .$Actor-Name);

my $staff = 0;

my $GroupObj = RT::Group-new($Actor);
$GroupObj-LoadUserDefinedGroup( 'RTUsers' );

my $PrincipalObj = RT::Principal-new($Actor);
$PrincipalObj-Load($Actor-id);

$RT::Logger-warning(groupname: .$GroupObj-Name); #Remove them from
production
$RT::Logger-warning(principaltype: .$PrincipalObj-PrincipalType);

if ($GroupObj-HasMemberRecursively($PrincipalObj)) {
   $staff = 1;
   $self-TicketObj-SetStatus('stalled');
   $RT::Logger-warning(Staff);
}
else
{
   $RT::Logger-warning(Non-staff);
}

return 1;

and the log output is:
Oct  8 16:49:31 rt RT: Welcome to Scrip 13 ((eval 759):1)
Oct  8 16:49:31 rt RT: RT::Ticket RT::CurrentUser ((eval 759):9)
Oct  8 16:49:31 rt RT: Actor is RT_System ((eval 759):14)
Oct  8 16:49:31 rt RT: groupname: RTUsers ((eval 759):26)
Oct  8 16:49:31 rt RT: principaltype: User ((eval 759):27)
Oct  8 16:49:31 rt RT: Non-staff ((eval 759):36)

even though I am triggering this by replying to a ticket logged in as a
normal user (in the RTUsers group) from the web UI. Why is it 'RT_System'?

Can someone please point me in the right direction? I think I'm probably
missing something fundamental...

Thanks,

Howie
___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: sa...@bestpractical.com


Discover RT's hidden secrets with RT Essentials from O'Reilly Media. 
Buy a copy at http://rtbook.bestpractical.com


Re: [rt-users] Error in viewing one ticket

2009-10-08 Thread Kevin Falcone
On Thu, Oct 08, 2009 at 11:59:38AM -0400, Lander, Scott wrote:
 I have one ticket that, when I go to view it, it displays about a half of the 
 details and then give the following error:
 
 Can't call method Name on an undefined value at 
 /opt/rt3/bin/../lib/RT/Transaction_Overlay.pm line 700.
 
 Any one have any idea what could cause this?

In 3.8.5 that line involves a User object.
Have you deleted a user manually or forced a shredder deletion of a
user who was still associated with tickets?

-kevin


pgpaUQzVtr34x.pgp
Description: PGP signature
___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: sa...@bestpractical.com


Discover RT's hidden secrets with RT Essentials from O'Reilly Media. 
Buy a copy at http://rtbook.bestpractical.com

Re: [rt-users] Error in viewing one ticket

2009-10-08 Thread William Graboyes
Hi Scott,
I have seen that happen when there is a missing user, or the Principals
table is out of whack.  It is hard to tell with the information that is
given though.

Did you happen to do a partial database migration?
Are you running a cron job that is removing users?
Are you acting directly in the database?
Maybe you are using RT Shredder?


Thanks,
Bill Graboyes

On Thu, Oct 8, 2009 at 8:59 AM, Lander, Scott slan...@hearstsc.com wrote:

  I have one ticket that, when I go to view it, it displays about a half of
 the details and then give the following error:

 Can't call method Name on an undefined value at
 /opt/rt3/bin/../lib/RT/Transaction_Overlay.pm line 700.


 Any one have any idea what could cause this?




 
 This e-mail message is intended only for the personal use of the recipient(s) 
 named above. If you are not an intended recipient, you may not review, copy 
 or distribute this message. If you have received this communication in error, 
 please notify the Hearst Service Center (cad...@hearstsc.com) immediately by 
 email and delete the original message.
 


 ___
 http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

 Community help: http://wiki.bestpractical.com
 Commercial support: sa...@bestpractical.com


 Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
 Buy a copy at http://rtbook.bestpractical.com
___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: sa...@bestpractical.com


Discover RT's hidden secrets with RT Essentials from O'Reilly Media. 
Buy a copy at http://rtbook.bestpractical.com

Re: [rt-users] Finding the current user for a reply (scrips)

2009-10-08 Thread Kevin Falcone
On Thu, Oct 08, 2009 at 05:12:13PM +0100, Howard Jones wrote:
 I'm trying to write a scrip to set a ticket's status based on who
 replies to it - if it's staff, set it to stalled, if it's not, set to open.
 
 I currently have an OnCorrespond condition, and a custom Action, but I'm
 not seeing the user I expect from the Transaction object.
 
 $RT::Logger-warning(Welcome to Scrip 13);
 
 # get actor ID
 my $trans = $self-TransactionObj;
 my $Ticket = $trans-TicketObj;
 my $Actor = $self-CurrentUser();

Try using $trans-Creator or $trans-CreatorObj
Scrips run in a system context, but the creator of the transaction
will be the user who triggered it.

-kevin

 $RT::Logger-warning(ref($Ticket). .ref($Actor));
 
 # if actor is RT_SystemUser then get out of here
 return 1 if $Actor == $RT::SystemUser-id;
 
 $RT::Logger-warning(Actor is .$Actor-Name);
 
 my $staff = 0;
 
 my $GroupObj = RT::Group-new($Actor);
 $GroupObj-LoadUserDefinedGroup( 'RTUsers' );
 
 my $PrincipalObj = RT::Principal-new($Actor);
 $PrincipalObj-Load($Actor-id);
 
 $RT::Logger-warning(groupname: .$GroupObj-Name); #Remove them from
 production
 $RT::Logger-warning(principaltype: .$PrincipalObj-PrincipalType);
 
 if ($GroupObj-HasMemberRecursively($PrincipalObj)) {
$staff = 1;
$self-TicketObj-SetStatus('stalled');
$RT::Logger-warning(Staff);
 }
 else
 {
$RT::Logger-warning(Non-staff);
 }
 
 return 1;
 
 and the log output is:
 Oct  8 16:49:31 rt RT: Welcome to Scrip 13 ((eval 759):1)
 Oct  8 16:49:31 rt RT: RT::Ticket RT::CurrentUser ((eval 759):9)
 Oct  8 16:49:31 rt RT: Actor is RT_System ((eval 759):14)
 Oct  8 16:49:31 rt RT: groupname: RTUsers ((eval 759):26)
 Oct  8 16:49:31 rt RT: principaltype: User ((eval 759):27)
 Oct  8 16:49:31 rt RT: Non-staff ((eval 759):36)
 
 even though I am triggering this by replying to a ticket logged in as a
 normal user (in the RTUsers group) from the web UI. Why is it 'RT_System'?
 
 Can someone please point me in the right direction? I think I'm probably
 missing something fundamental...
 
 Thanks,
 
 Howie
 ___
 http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
 
 Community help: http://wiki.bestpractical.com
 Commercial support: sa...@bestpractical.com
 
 
 Discover RT's hidden secrets with RT Essentials from O'Reilly Media. 
 Buy a copy at http://rtbook.bestpractical.com
 


pgpjWtSaFo0Ci.pgp
Description: PGP signature
___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: sa...@bestpractical.com


Discover RT's hidden secrets with RT Essentials from O'Reilly Media. 
Buy a copy at http://rtbook.bestpractical.com

Re: [rt-users] Error in viewing one ticket

2009-10-08 Thread Ken Crocker

Scott,

Every ticket will try to show it's history. In your case, it died trying 
to find a UserID on the USERS table that was identified in the 
transaction record. I recommend the following:


1) Get into the DataBase and find that Transaction (usually, I look at 
the history in that ticket and see where it stops. That gives me an idea 
of what to look for in terms of action)
2) Get the UserId identified in that transaction record and see if it is 
in the USERS table.
3) If not in the Users table, you have a couple of options on how to fix 
it, one being using SQL to change the UserID on that transaction record 
to a Users Id that already exist and will suffice as a replacement. This 
type of action would NOT meet the approval of Audit, but it WILL fix the 
error situation.


I have a set of SQL commands I have used in the past to resolve these 
types of problems. Let m eknow if you want them.


Kenn
LBNL

On 10/8/2009 8:59 AM, Lander, Scott wrote:
I have one ticket that, when I go to view it, it displays about a half 
of the details and then give the following error:
 
Can't call method Name on an undefined value at 
/opt/rt3/bin/../lib/RT/Transaction_Overlay.pm line 700.
 
 
Any one have any idea what could cause this?
 
 
 


This e-mail message is intended only for the personal use of the recipient(s) 
named above. If you are not an intended recipient, you may not review, copy or 
distribute this message. If you have received this communication in error, 
please notify the Hearst Service Center (cad...@hearstsc.com) immediately by 
email and delete the original message.

  



___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: sa...@bestpractical.com


Discover RT's hidden secrets with RT Essentials from O'Reilly Media. 
Buy a copy at http://rtbook.bestpractical.com
___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: sa...@bestpractical.com


Discover RT's hidden secrets with RT Essentials from O'Reilly Media. 
Buy a copy at http://rtbook.bestpractical.com

Re: [rt-users] Partial upgrade form 3.6.1 to 3.8.5

2009-10-08 Thread Dominic Hargreaves
On Thu, Oct 08, 2009 at 04:33:13PM +0200, Nicolas GUIOT wrote:
 I had a debian-packaged (etch) RT on a box and new options from 3.8 are 
 interesting to us, so I plan to install a brand new RT install from sources, 
 but would like to keep my existing DB.
 
 Correct me if I'm wrong : 
 I juste need to do the RT setup, without the DB creation, run the DB upgrade 
 script, et voil?? ??

That should be just about it, yes. It's worth bearing in mind that
you should be able to install RT3.8 onto etch without too much trouble
if you are confident with installing selected packages from another
release without hosing your system; the packages are available in
squeeze/sid.

Cheers,
Dominic.

-- 
Dominic Hargreaves, Systems Development and Support Team
Computing Services, University of Oxford
___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: sa...@bestpractical.com


Discover RT's hidden secrets with RT Essentials from O'Reilly Media. 
Buy a copy at http://rtbook.bestpractical.com


[rt-users] Matching relative dates in scrips

2009-10-08 Thread Nick Kartsioukas
I'm trying to get a scrip condition to match when the Starts field of a
ticket has a date of today.  We want to be able to set tickets as
stalled with a Starts date sometime in the future, and have a cron job
open tickets on the day when they start, and have a scrip notify the
ticket owner.

Cron entry looks like this:
rt-crontool --search RT::Search::FromSQL --search-arg Status =
'stalled' AND Starts = 'today' --action RT::Action::SetStatus
--action-arg open

Scrip condition looks like this:
my $txn = $self-TransactionObj;
my $starts = $self-TicketObj-StartsObj;
if ( $txn-OldValue eq stalled  $txn-NewValue eq open  $starts
eq today )
{
 return 1;
}
else
{
 return 0;
}

The date isn't matching though.  I'm missing something, I'm just not
sure what (date conversion maybe?)
___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: sa...@bestpractical.com


Discover RT's hidden secrets with RT Essentials from O'Reilly Media. 
Buy a copy at http://rtbook.bestpractical.com


Re: [rt-users] email filter that sets ticket via subject lookup?

2009-10-08 Thread Robert Eden
On 10/8/2009 9:02 AM, Kevin Falcone wrote:
 On Wed, Oct 07, 2009 at 11:24:50PM -0500, Robert Eden wrote:
   
 Howdy All.

 We work with a vendor and store the vendor's ticket # in a custom field.

 We'd like to be able to add a comment to the RT ticket by ccing  RT on 
 vendor email. The subject of the message contains the vendor ticket 
 number, and I'll determine the RT # via a search.
 

 You may just want to borrow the Nagios scrips on the wiki and On
 Create find the existing ticket you need to merge into and set the CF
 from there.  You'll find the Scrip Action interface to be a lot easier
 to do what you need (since the tickets exist and you can set
 properties).

Thanks for the idea Kevin...  I got a modified scrip working. That 
solution takes the new ticket and merges it with my main one.  It works, 
but you have the side-effect of potentially a lot of extra tickets and 
also additional requestors because they're merged.

Is there any way to avoid the new ticket with new requestor?  I get the 
feeling the ticket is already created by the time on-create hits, so 
that damage is already done. 

One solution is to extract the text and add the comment to the other 
ticket and then change the status of the newly created ticket to 
delete.  I still get an extra ticket, but at least it doesn't do much 
harm.  I'm leaning towards that.. I guess it's cleaner than intercepting 
it at the mail entry.

Robert

___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: sa...@bestpractical.com


Discover RT's hidden secrets with RT Essentials from O'Reilly Media. 
Buy a copy at http://rtbook.bestpractical.com


[rt-users] Apache Failed while Restarting - Request Tracker

2009-10-08 Thread Arun Balaji
Hello Experts

Please help me to proceed further steps in RT.  I am a newbie  in RT.

I am using RT3 in RHEL5. here with i am sending my files and log details.

[Fri Oct 09 15:10:40 2009] [error] Can't locate Extension/QuickDelete.pm in
@INC (@INC contains: /opt/rt3/bin/../local/lib /opt/rt3/bin/../lib
/usr/lib/perl5/site_perl/5.8.8/i386-linux-thread-multi
/usr/lib/perl5/site_perl/5.8.7/i386-linux-thread-multi
/usr/lib/perl5/site_perl/5.8.6/i386-linux-thread-multi
/usr/lib/perl5/site_perl/5.8.5/i386-linux-thread-multi
/usr/lib/perl5/site_perl/5.8.8 /usr/lib/perl5/site_perl/5.8.7
/usr/lib/perl5/site_perl/5.8.6 /usr/lib/perl5/site_perl/5.8.5
/usr/lib/perl5/site_perl
/usr/lib/perl5/vendor_perl/5.8.8/i386-linux-thread-multi
/usr/lib/perl5/vendor_perl/5.8.7/i386-linux-thread-multi
/usr/lib/perl5/vendor_perl/5.8.6/i386-linux-thread-multi
/usr/lib/perl5/vendor_perl/5.8.5/i386-linux-thread-multi
/usr/lib/perl5/vendor_perl/5.8.8 /usr/lib/perl5/vendor_perl/5.8.7
/usr/lib/perl5/vendor_perl/5.8.6 /usr/lib/perl5/vendor_perl/5.8.5
/usr/lib/perl5/vendor_perl /usr/lib/perl5/5.8.8/i386-linux-thread-multi
/usr/lib/perl5/5.8.8 . /etc/httpd) at /opt/rt3/bin/../lib/RT.pm line
627.\nCompilation failed in require at (eval 2) line 1.\n
[Fri Oct 09 15:10:40 2009] [error] Can't load Perl file: /opt/rt3/bin/
webmux.pl for server 192.168.1.2:0, exiting...

-
This is httpd.conf file

Directory /opt/rt3/share/html
  Options FollowSymLinks ExecCGI
  AllowOverride None
/Directory

VirtualHost 192.168.1.2
ServerName 192.168.1.2
 DocumentRoot /opt/rt3/share/html
AddDefaultCharset UTF-8
PerlModule Apache2 Apache::compat
PerlModule Apache::DBI
PerlRequire /opt/rt3/bin/webmux.pl
Location /rt
RedirectMatch permanent (.*)/$ $1/index.html
SetHandler perl-script
PerlHandler RT::Mason
/Location
/VirtualHost
-
This is /opt/rt3/etc/SiteConfig.pm file

Set($rtname, 'rt3');
#Set($Organization, 'example.org');
#Set($CorrespondAddress , 'supp...@example.org');
#Set($CommentAddress , 'support-comm...@example.org');
#Set($Timezone , ‘GMT’); # obviously choose what suits you

# THE DATABASE:

Set($DatabaseType, 'mysql'); # e.g. Pg or mysql

# These are the settings we used above when creating the RT database,
# you MUST set these to what you chose in the section above.

Set($DatabaseUser , 'rt');
Set($DatabasePassword , 'semansys');
Set($DatabaseName , 'rt3'); # Ensure this is set to rt3!

# THE WEBSERVER:

Set($WebPath , '/opt/rt3/share/html/');
Set($WebBaseURL , 'http://192.168.1.2');

Set(@Plugins,(qw(Extension::QuickDelete RT::FM)))

---

Please help me to solve the issue.


Regards
Arun Balaji.L
___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: sa...@bestpractical.com


Discover RT's hidden secrets with RT Essentials from O'Reilly Media. 
Buy a copy at http://rtbook.bestpractical.com