Re: [rt-users] Onetime CC are giving an internal error

2017-02-16 Thread Gordon Messmer

We are running rt-4.4.0 and just noticed that selecting a One-time Cc
gives an internal error in the Scrips and Recipients block.
The error is:

[9625] [Thu Apr  7 12:37:48 2016] [warning]: Use of uninitialized value in 
split at /opt/rt4/share/html/Helpers/PreviewScrips line 81. 
(/opt/rt4/share/html/Helpers/PreviewScrips:81)
[9625] [Thu Apr  7 12:37:48 2016] [error]: Operation "eq": no method found,
 left argument has no overloaded magic,
 right argument in overloaded package Email::Address at 
/opt/rt4/share/html/Helpers/PreviewScrips line 115.


http://lists.bestpractical.com/pipermail/rt-users/2016-April/087217.html

I've been seeing this error since the release of 4.4.  It was mentioned 
here on the list, and at the time I thought a fix would surely make its 
way down the pipeline.  Sadly, I haven't seen one, so I found the error 
and fixed it the other day.  If this is causing your users to miss 
replies to tickets, the issue is fairly simple to fix.  The attached 
patch corrects the problem by quoting a variable that has overloaded 
operators, so that it's treated like a string.  I've also sent this 
patch to rt-devel.


--- rt-4.4.1/share/html/Helpers/PreviewScrips.orig	2017-02-15 19:52:17.761241782 +
+++ rt-4.4.1/share/html/Helpers/PreviewScrips	2017-02-15 19:52:36.460407904 +
@@ -112,7 +112,7 @@
 % $recips{$addr->address}++;
   <%loc($type)%>:
 % my $show_checkbox = 1;
-% if ( grep {$_ eq $addr->address} @{$action->{NoSquelch}{$type}} ) {
+% if ( grep {$_ eq "$addr->address"} @{$action->{NoSquelch}{$type}} ) {
 % $show_checkbox = 0;
 % }
 


Re: [rt-users] Attachments don't reach database for one user

2016-03-15 Thread Gordon Scott Messmer
On Tue, Mar 15, 2016 at 9:31 AM, Chanel Wheeler 
wrote:

> Yes, everything in the ticket shows up for the faulty user except for the
> attachment. The rights for this user and other basic users of the system
> are the same.
>
>
>
Is that user using Outlook?  Might it be sending non-plain-text parts of
the message as winmail.dat?
-
RT 4.4 and RTIR Training Sessions https://bestpractical.com/training
* Washington DC - May 23 & 24, 2016


[rt-users] Should RT4 (4.4.0) display time sums under "the basics"?

2016-03-14 Thread Gordon Messmer
We recently upgraded to RT 4.4.0.  When our staff add time worked to a 
ticket, two labels appear under "The Basics," "Worked" and "Users"


After the "Worked" label, there is a sum of all the time entries. After 
the "Users" label, a user is listed with a time value that appears to be 
just the first time entry they've added.


So, for example, if Bob adds 15 minutes worked and then later adds 
another 5, the "Worked" label will read "20 minutes" and the "Users" 
label will read "bob: 15 minutes"


Is that the expected behavior?  I didn't pay attention to these fields 
in the past, but our staff are reporting that these aren't working as 
expected.


-
RT 4.4 and RTIR Training Sessions https://bestpractical.com/training
* Washington DC - May 23 & 24, 2016


[rt-users] Permission question

2013-11-14 Thread Gordon Messmer
I'd like to create a user account in RT3.8 with access to see all of the 
tickets in one queue.  I don't want this user to receive any email.


I've created the account and tried granting it AdminQueue, SeeQueue, 
Watch, WatchAsAdminCc permissions, but in all cases the user does not 
see any queue listed on the Home page and does not see any tickets 
listed if I manually load a correct search URL.


Does anyone know specifically what permissions are required to see all 
of the tickets within a queue?  Do I need to flush a cache somewhere?


Re: [rt-users] monthly reports?

2011-02-03 Thread gordon



That would be close - but what about tickets in the previous month, but
not resolved (or even still open)? After all, those are tickets we
worked on during the month in question...


You can also do Ticket searches on Updated or LastUpdated and 
LastContacted (aka Told) between dates. An Updated search will give 
you any tickets that had Comments or Replies added to them, had custom 
field changes or status changes.


Gordon


Re: [rt-users] Customised display format for Simple search

2010-05-30 Thread gordon

Thanks Kevin.

Here are some details for others about what I did:

I ended up modifying and renaming 3 files, Simple.html, Results.html and 
Googleish.pm


We now have a ticket custom field called Serial Number which is linked 
to a modified Simple.html (Simple2.html) web page. This allows us to 
click on the displayed serial number which then automatically opens a 
separate search page displaying all other tickets containing that serial 
number.


Unfortunately my programming skills are only good enough to hack 
together a solution for my particular requirements and would in no way 
be suitable for applying a patch. Also, this was still on rt-3.6 (will 
upgrade when I have to).


Gordon


On 27/05/2010 12:37 AM, Kevin Falcone wrote:

On Fri, May 21, 2010 at 09:25:07AM +1000, gor...@cryologic.com wrote:

Hi,

I would like to create a customised display format that is only used
for a Simple search. ie I would like to keep the default display
format for a regular search. Is this possible? If so, what files
would I have to add/change?


You'd need to change Search/Simple.html to pass a Format to
Result.html.

Most likely you'd want to use the style of the other Formats defined
in RT_Config.pm and make this a config option and send in a patch

-kevin


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


[rt-users] Customised display format for Simple search

2010-05-20 Thread gordon

Hi,

I would like to create a customised display format that is only used for 
a Simple search. ie I would like to keep the default display format for 
a regular search. Is this possible? If so, what files would I have to 
add/change?


Thanks for any advice.
Gordon

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


Re: [rt-users] Simple Search and Custome Field

2010-01-24 Thread gordon
In RT-3.6.7 we modified rt3/local/lib/RT/Search/Googleish_Local.pm
to perform searches of certain custom fields from simple search.
When we put sn:xxx in a simple search it finds any tickets containing 
xxx in a Serial Number custom field.

We also modified rt3/local/html/Search/Simple.html to provide 
instructions for this search.

Gordon

Michael Neuschafer wrote:
 Is there a way to allow simple search to also search custom fields?
 
  
 
 Thanks,
 
  
 
 *Michael Neuschafer*
___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

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

2010 RT Training Sessions!
San Francisco, CA, USA - Feb 22  23
Dublin, Ireland - Mar 15  16
Boston, MA, USA - April 5  6
Washington DC, USA - Oct 25  26

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


[rt-users] Modifying Comments or Replies

2010-01-12 Thread gordon
Hi,

I understand why a Ticket History is immutable and this is very 
important to us for auditing/security reasons.

However, Comments are often entered incorrectly or sometimes into the 
wrong tickets and can confuse issues even if a subsequent comment 
corrects the first.

I would like to have the best of both worlds where History is recorded 
but comments can be changed.

Is it not possible to treat the comments in the same way custom fields 
are, ie the data in the custom field changes but a record is kept of the 
change?

This would require a slightly different layout with comments listed 
separately under the ticket fields and a full history at the bottom of 
the ticket or elsewhere (we currently do this already, listing only 
comments on the ticket page and list the full history if the history 
link is selected).

Gordon
___
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] Tracking changes to queue structure

2009-11-23 Thread gordon
RT provides an excellent history log of all activities relating to a 
ticket. This provides an unchangeable record which auditors love when 
reviewing tickets.

However we occasionally make changes to a queue such as adding a new 
custom field. This does not get filled in for historical tickets (too 
many) only new ones. When reviewing the old tickets auditors ask why the 
fields were not filled in correctly.

We handle this by keeping a separate log of changes we make to queues 
and when they were made.

My question is: does anyone else keep track of the changes they make to 
queues, and if so, how do you do it? Is there any way to do this within 
RT - I would love to do so but have no idea where to begin.

thanks
Gordon
___
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] Tracking changes to queue structure

2009-11-23 Thread gordon
Thanks Ken,

I use this feature for some fields but others require information 
specific to a ticket (eg description of product design change). Also, 
reviewers of historical tickets can still ask the question: why wasn't 
the field filled in when the ticket was active?

Gordon


Ken Crocker wrote:
 Gordon,
 
 RT has a Bulk Update feature which would allow you to add whatever 
 value to specific Custom Fields on tickets in specific Queues as well as 
 add comments to specific tickets in a queue. By specific, I mean 
 whatever criteria you use for selecting the ticket you want to update.
 
 Kenn
 LBNL
 
 On 11/23/2009 3:01 PM, gor...@cryologic.com wrote:
 RT provides an excellent history log of all activities relating to a 
 ticket. This provides an unchangeable record which auditors love when 
 reviewing tickets.

 However we occasionally make changes to a queue such as adding a new 
 custom field. This does not get filled in for historical tickets (too 
 many) only new ones. When reviewing the old tickets auditors ask why the 
 fields were not filled in correctly.

 We handle this by keeping a separate log of changes we make to queues 
 and when they were made.

 My question is: does anyone else keep track of the changes they make to 
 queues, and if so, how do you do it? Is there any way to do this within 
 RT - I would love to do so but have no idea where to begin.

 thanks
 Gordon
___
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] Tracking changes to queue structure

2009-11-23 Thread gordon
Nice idea, I like it!

thanks
Gordon


Nick Kartsioukas wrote:
 On Tue, 24 Nov 2009 10:35:31 +1100, gor...@cryologic.com said:
 I use this feature for some fields but others require information 
 specific to a ticket (eg description of product design change). Also, 
 reviewers of historical tickets can still ask the question: why wasn't 
 the field filled in when the ticket was active?
 
 I would do this:
 1) Create the new custom field, and add any selection values to it that
 you'll need (if it's not a fill-in-the-blank type CF)
 2) Also add a selection value of Field not available at time of ticket
 creation
 3) Using Bulk Update, set that CF value to Field not available at time
 of ticket creation for all existing tickets
 4) Go back to the custom field settings, delete the value Field not
 available at time of ticket creation as an option
 5) Explain to the auditors that new fields are added every so often, and
 explain the procedure you went through to set that value, emphasizing
 that by removing that particular value as an option, users are unable to
 set any new ticket custom field to that value.
 
 That should hopefully be sufficient to satisfy everyone...
 ___
 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


[rt-users] Version of RT that works with RT-Extension-MandatorySubject-0.01

2009-11-10 Thread gordon
Hi,

I had a look in the documentation but couldn't easily find which version 
of RT this extension works with.

V0.02 and V0.03 state they require RT 3.8.3 at least.

I am still running RT-3.6.7.

thanks
Gordon
___
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] On saving changes to a ticket edit page displayed

2009-08-20 Thread gordon
I know this has been mentioned before but I haven't been able to find in 
the lists the reason for this small, possible inconsistency.

When you Update a ticket after adding a comment the modified ticket is 
displayed.

When you Save Changes to a ticket, after modifying fields in the edit 
  Basics page (for instance) the edit window remains displayed, rather 
than returning to the ticket display page.

I am sure there is a logical reason for this, and am just trying to find 
out what it is to provide our users with an explanation.

thanks
Gordon
___
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] PATH: shredder deletes users with valid messages

2009-07-23 Thread gordon
Demanding work be done by developers who kindly (ie for free) maintain 
open source software, in my opinion, borders on being plain rude.
You are free to patch your own version of RT, or find alternative 
software which falls more in line with your expectations for ongoing 
development. The excuse of being tired and emotional only carries weight 
for so long.

Gordon

Jo Rhett wrote:
 See my reply.   The part of the patch which you refused because it was  
 well documented breaks RT.  Not fixing that isn't something you can  
 simply document -- RT falls over.  Searches break.  Pulling up  
 tickets break.  Pulling reports on users work on tickets break.   You  
 can't simply document this behavior, it's a must-fix issue.


___
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] Difference between a CC and a Requestor

2009-06-25 Thread gordon
The role of watchers (CC, Requestor, AdminCc and Owner) can be 
customised to meet specific requirements. Using scrips and templates 
different emails can be sent to different watchers and different rights 
can be assigned for modifying tickets. And, with custom scrips, 
different actions can be taken. The default roles have been outlined in 
the other replies to this question.

As an example for our Customer Support tickets we assign the watcher 
roles as this:
Requestor:  Customer with issue. Receives automated and customer 
specific emails
Owner: Person responsible for contacting customer. Only owners can Reply 
(send emails to Requestors) to tickets and have full rights to ticket 
modifications
AdminCc: Staff member required to add input to ticket issue. They 
receive automated email notifying them them their input is required. Can 
comment on tickets.
Cc: Staff member with interest in issue. Receives all emails generated.

regards
Gordon


Richard Brady wrote:
 Hi folks
 
 I am struggling to understand the difference between a CC and a 
 Requestor? When adding extra people to a ticket, it's not clear whether 
 they should be added as one or the other.
 
 Any clarification would  be much appreciated. (I have looked for 
 documentation on this but have not found much).
 
 Richard
___
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] ACL for modify links

2009-04-08 Thread gordon
Using rt-3.6.7

I would like all users to be able to link tickets in different queues, 
however, in some queues, we require only Owners be able to add Replies.
Is this impossible without modifying RT?

It seems ModifyTicket right is required for linking tickets but by 
default this also allows replies.

thanks
Gordon
___
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] Is it possible to rename the rt database?

2009-03-23 Thread gordon
We currently have two instances of rt-3.6 (production and testing) 
running on the same pc. One is handled by mod_perl and the other by 
FastCGI. This has worked fine with separately created databases.

Recently I made a copy of my production database and renamed it from rt3 
to rt3-eval. This rt3-eval database mostly works with my test rt3 except 
that a lot of links (MyTickets on RT at a glance etc) all point back to 
my production site. If I manually enter the correct test web address the 
tickets display correctly. I have cleared the mason cache and restarted 
the webserver.

Is the web path stored in the database? Is there any way to correctly 
rename a database?

thanks
Gordon
___
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] Is it possible to rename the rt database?

2009-03-23 Thread gordon
My RT_SiteConfig.pm has remained unchanged for the rt-eval site and 
points to the correct web location (/rt-eval).

All of my saved searches (copied from production to eval) point to the 
wrong web location.

What I have noticed is that if I look at my Saved Searches in the 
Advanced Editor the bottom section displays:
href=/rt/Ticket/Display.html
instead of href=/rt-eval/Ticket/Display.html

Is this href value stored as part of the saved search in the database?

Gordon


Ruslan Zakirov wrote:
 I think your problem is not a DB, but RT's config file. you should
 adjust Web* options. Also, make sure test server connects to test
 (rt3-eval) DB, check Database* options.
___
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] tickets created in RT don't line-wrap?

2009-02-10 Thread gordon
Perhaps deleting the mason cache before restarting apache may fix it?

Gordon


Jo Rhett wrote:
 FWIW, this setting is now 0 and there are still pre tags in the  
 output.
 
 div class=messagebody
 prediv class=message-stanza-depth-0Go into my preferences and
 
 $ grep TextPre /usr/local/etc/rt38/*
 /usr/local/etc/rt38/RT_Config.pm:=item C$PlainTextPre
 /usr/local/etc/rt38/RT_Config.pm:to be displayed correctly.  By  
 setting $PlainTextPre they'll be
 /usr/local/etc/rt38/RT_Config.pm:Set($PlainTextPre, 0);
 /usr/local/etc/rt38/RT_SiteConfig.pm:Set( $PlainTextPre, 0 );
 
 Apache has been fully stopped and started and this behavior continues.
___
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] tickets created in RT don't line-wrap?

2009-02-09 Thread gordon
Jo Rhett wrote:
 Most of our tickets are created through e-mail so I didn't notice this.
 
 I just created a ticket inside RT 3.8.2 using the New Ticket In  
 button at the top of the page and the text is unreadable when viewing  
 the ticket because my paragraphs simply aren't line wrapping.  There  
 is a scrollbar in the view and you can scroll back and forth but this  
 is obnoxiously difficult.

in RT_Site_Config change

Set($MessageBoxWrap, SOFT);

Set($MessageBoxWrap, HARD);
___
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] Scrip send email on create

2009-02-03 Thread gordon
possibly:

Stage: TransactionBatch

 From memory (at least in RT-3.6.x) I think you also have to enable 
batch transactions in RTSiteConfig.pm, something like:

Set($UseTransactionBatch , 1);

Gordon


Dan O'Neill wrote:
 Dan O'Neill wrote:
 Enclosed is a script that adds one or more AdminCC's to a ticket during 
 Create. This does not cause the AdminCC's to receive an email.

 How do I modify this Scrip or otherwise configure the Queue such that 
 AdminCC's will receive a copy of the text in the opening transaction?

 Here is the scrip information.  I've reviewed the contributions page and 
 read what I can before asking this question.  Thanks for the help.

 Condition:  On Create
 Action: User Defined
 Template: Global template: Blank
 Stage: Transaction Create
 
 A little update. At the suggestion of some docs on the wiki, I added a 
 new template to see if that would get this scrip to send a notification 
 to the AdminCC's.  Didn't work, still no outbound notification.  I'll 
 whip up an Amazon gift certificate to anyone who can help me resolve 
 this problem before close of business Wednesday.
 
 Thanks,
 
 Dan
 ___
 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] Adding users to groups to share tickets

2008-12-04 Thread gordon
Would it be possible to customise the SelfService search to display 
tickets with Requestors from the same email domain (assuming all 
Requestors from the one company use the same domain)?

Gordon




Jason p wrote:
 Ok, I have been trying to figure this out for the past week.  Simple 
 problem we have many customers that share the same queue (support), now 
 some of our larger customers want to be able to group their users so 
 that they can view all their own tickets generated by anyone in their 
 company.
 
  I can not find a way to do this without allowing the users to see all 
 tickets in the entire support queue ( This would be very bad ) as it is 
 made up of many competing companies. It would be a Pain to have to 
 create a new support queue for every customer.
 
 
 
 Any Help would be great.
 
 Thanks
 
 Jason
___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: [EMAIL PROTECTED]


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


Re: [rt-users] printable work order

2008-11-18 Thread gordon
 I modified the default RT template to include a separate stylesheet 
reference for printouts.

I'm not exactly sure which file this refers to? Could somebody please 
point me at it.

Does anyone care to share their customised style sheet they use for 
printing?

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

Community help: http://wiki.bestpractical.com
Commercial support: [EMAIL PROTECTED]


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


[rt-users] Hiding empty Custom Fields

2008-11-13 Thread gordon
I am sure I read a post a few weeks back discussing the possibility of 
hiding Custom Fields from the display page if they contained no data.
For the life of me I can't seem to find it. Could somebody please point 
me in the right direction, or am I just imagining the whole thing?


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

Community help: http://wiki.bestpractical.com
Commercial support: [EMAIL PROTECTED]


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


Re: [rt-users] ClickableLinks in custom fields

2008-11-11 Thread gordon
Thanks Torsten,

I had looked at this earlier and originally thought it wouldn't be 
useful for my application. However, after revisiting the idea, I see I 
can simply put in file:/__CustomField__  as the URL and users can 
put in their network file paths as the custom field value, to create a 
clickable link.

Gordon


Torsten Brumm wrote:
 Hi Gordon,
 
 have a look into CF Configuration:
 
 Link values to
 RT can make this custom field's values into hyperlinks to another 
 service. Fill in this field with a URL. RT will replace __id__ and 
 __CustomField__ with the record id and custom field value, respectively
 
 Create a CF and type inside the Link Values to: __CustomField__ which 
 will create a clickable link with the content of the CF.
 
 
 2008/11/11 [EMAIL PROTECTED] mailto:[EMAIL PROTECTED]
 
 Before I reinvent the wheel I thought I would ask if anybody had created
 something similar to the ClickableLinks Callback
 (http://wiki.bestpractical.com/view/ClickableLinks  Dirk Pape et al.)
 applicable to Custom Fields.
 
 RT-3.6.7
 
 thanks
 Gordon
___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: [EMAIL PROTECTED]


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


[rt-users] ClickableLinks in custom fields

2008-11-10 Thread gordon
Before I reinvent the wheel I thought I would ask if anybody had created 
something similar to the ClickableLinks Callback 
(http://wiki.bestpractical.com/view/ClickableLinks  Dirk Pape et al.)
applicable to Custom Fields.

RT-3.6.7

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

Community help: http://wiki.bestpractical.com
Commercial support: [EMAIL PROTECTED]


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


[rt-users] wildcards in custom field searches

2008-11-06 Thread gordon
I am currently performing a search on a custom field like so:

'CF.{Serial Numbers}' LIKE '655'

This obviously searches through the custom field Serial Numbers.

Unfortunately information often gets put in the wrong place and locating 
it can be difficult.

Is it possible to use a wildcard (or other simple method) to search 
through all custom fields? For example:

'CF.{%}' LIKE '655'  (I tried this but it didn't work)

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

Community help: http://wiki.bestpractical.com
Commercial support: [EMAIL PROTECTED]


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


Re: [rt-users] Requestors recieving blank email after replying

2008-10-23 Thread gordon
  I'm not sure what you mean by the NotifyActor option.

In your RT_SiteConfig.pm

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

Community help: http://wiki.bestpractical.com
Commercial support: [EMAIL PROTECTED]


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


Re: [rt-users] Safe to modify ScripActions table in database

2008-10-21 Thread gordon
   Is there a better way to make the changes?
 
 You can edit etc/initialdata and run poke rt-setup-database for
 inserting the new stuff. If you do so, it would be great if you
 wrote a Wiki entry and replied with a link.

I'm guessing /etc/initialdata would be overwritten on an upgrade

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

Community help: http://wiki.bestpractical.com
Commercial support: [EMAIL PROTECTED]


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


[rt-users] Safe to modify ScripActions table in database

2008-10-20 Thread gordon
I have manually added a row to the ScripActions table of the database.
Is this a bad thing to do in terms of future upgrades?
Is there a better way to make the changes?

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

Community help: http://wiki.bestpractical.com
Commercial support: [EMAIL PROTECTED]


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


Re: [rt-users] A reminder creates a ticket and sends email to queue watchers???

2008-10-09 Thread gordon
Kenneth Crocker wrote:
 To all,
 
 
   We'er using 3.6.4 and ha never had the problem your discussing in terms 
 of reminders. Is this new due to 3.8?

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

Community help: http://wiki.bestpractical.com
Commercial support: [EMAIL PROTECTED]


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


[rt-users] Upgrading MySQL 4.1 to MySQL 5.0

2008-10-09 Thread gordon
RT-3.8.1

I was just wondering if there are any database changes required for 
upgrading from MySQL 4.1 to MySQL 5.0.

There is no mention of MySQL 5.0 in UPGRADING.mysql so I am assuming not.

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

Community help: http://wiki.bestpractical.com
Commercial support: [EMAIL PROTECTED]


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


Re: [rt-users] Rich Text doesn't show up in ticket view

2008-09-23 Thread gordon
I think RT cleans up the html for safety reasons and only displays a 
subset of the html formatting (such as bold text) in the ticket display. 
Emails should contain the full html though.

Does anyone know exactly what can be displayed in the ticket?

I think a feature request has been previously made for a configuration 
setting that allows display of full html in the ticket. It sounds like a 
good idea to me.

Gordon


Chris Nelson wrote:
 I pre-apologize if this is a total newbie question - but when I create a 
 comment or a ticket with Rich Text in the body (say I make a name blue), 
 the formatting does not appear when I view the ticket.
 
 For example, I create a ticket and type CRITICAL ISSUE in all red 
 letters at the top of a comment. When I finish the comment and click 
 Display at the top of the ticket, CRITICAL ISSUE is there, but it 
 doesn't show red - it just shows black. When I download the attachment 
 the html code is correct - which makes me wonder if it's a browser issue 
 or if I'm just doing something that's preventing it from displaying in 
 the UI.
 
 Thanks in advance!
 
 Firefox 2 (cuz ff3 is just plain SLOW on all web pages)
 RT 3.8.1
 Ubuntu Linux
 MySQL
 
 Thanks,
 -Chris
___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: [EMAIL PROTECTED]


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


Re: [rt-users] Rich text editor on Ticket Creation page

2008-09-18 Thread gordon
I noticed on the BestPractical Website Blog:

http://bestpractical.typepad.com/worst_impractical/2008/07/today-were-rele.html

a screenshot for the Create a New Ticket page which shows the Rich 
Text Editor enabled.

This leads me to assume I have a configuration, or possible Rights, 
problem which is not displaying the Rich Text Editor on the Create a 
New Ticket page for me as SuperUser. It is available for Comments and 
Replies however.

Any suggestions to what I am doing wrong?

thanks
Gordon

[EMAIL PROTECTED] wrote:
 Clean install of rt-3.8.1
 
 When you open the page to create a new ticket is it possible to turn on 
 the Rich Text Editor toolbar for the Describe the issue below textbox?
 Or is this textbox somehow different to the Comment and Reply textboxes?
 
 Thanks
 Gordon
___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: [EMAIL PROTECTED]


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


[rt-users] Rich text editor on Ticket Creation page

2008-09-16 Thread gordon
Clean install of rt-3.8.1

When you open the page to create a new ticket is it possible to turn on 
the Rich Text Editor toolbar for the Describe the issue below textbox?
Or is this textbox somehow different to the Comment and Reply textboxes?

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

Community help: http://wiki.bestpractical.com
Commercial support: [EMAIL PROTECTED]


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


Re: [rt-users] Quick Search in 3.8.1 doesn't include Resolved Status

2008-09-04 Thread gordon
We are the same, much prefer searching for all unresolved and resolved 
tickets in the quick search. The change has caused quite a bit of abuse 
at the sysadmin (me).

Gordon


Helmuth Ramirez wrote:
 On our end when we're searching for a ticket, 
 99% of the time its to look for something that's already been 
 done/resolved (end users calling for status, etc).
 
 Thanks
 Helmuth
___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: [EMAIL PROTECTED]


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


Re: [rt-users] Delayed scrip

2008-08-31 Thread gordon
On create you could also generate a Reminder for the ticket which is set 
to notify the owner in 24 hours.

Gordon


Jerrad Pierce wrote:
 Hey all,
 
 Is anyone aware (nothing on wiki or archives that I could see) of an 
 easy/elegant way to purposefully delay the delivery of OnCreate messages?
 We're using RT to accept new clients, but then are syncing the data with 
 our call center on a nightly basis, so we want to wait until that happens
 before notifying the user...
___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: [EMAIL PROTECTED]


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


[rt-users] Open all linked tickets in browser

2008-08-29 Thread gordon
Has anyone any ideas on how to open all linked tickets automatically in 
separate browser tabs?

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

Community help: http://wiki.bestpractical.com
Commercial support: [EMAIL PROTECTED]


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


Re: [rt-users] Personal Queues/Tags

2008-08-05 Thread gordon
I have multiple searches listed on my homepage which are subsets of all 
the tickets I own:
a list of tickets due this week
a list of tickets of highest priority
etc, etc.

If you can categorise your tickets effectively you should be able to 
create searches to list just those categories.

Gordon


Alex Howells wrote:
 This is as much a question to find out how everyone else manages, as a
 query about what features / hacks / patches may exist to solve stuff!
 
 We operate a number of queues such as:
 
Admin
Enquiries
Orders
etc etc etc
 
 Tickets will come in to those via various mail addresses, but in terms
 of daily work-flow, generally anyone will pick up tickets from across
 the queues to deal with. Ownership will change to that person, ownership
 can be changed to pass a ticket if required (escalation).
 
 What I'm really after is a way to better handle my own queue, which
 often gets quite full and difficult to navigate with 100+ 'open' tickets
 -- typically tickets fall into a few different categories:
 
* Just taken, requires initial response to request
  more information or begin to address customer issue.
  Important if I take these during the working day they
  get a reply (to the customer) before 5pm.
 
* Taken, dialogue has happened. Customer is now waiting
  on me to action something but it isn't a new ticket;
  these don't require action by 5pm but need movement
  within 48-72 hours or people don't feel the love.
 
* Waiting on information from customer, no expectation
  the issue is resolved.  Clarification required, etc.
 
* Suspect the issue is fixed, waiting for confirmation
  of that from the customer.  If no response received
  then I'd usually close these after 48-72 hours which
  issues an explicit mail stating We believe its fixed.
 
 Fourth 'category' (48-72 hour wait) basically avoids spamming customers
 with a resolved mail -- logic behind this is customers get frustrated if
 there's been a misunderstanding and they do *not* think the issue is
 resolved, plus a high churn rate (resolved - reopened) is bad.
 
 I almost get tempted to stall stuff in the fourth category since that
 gets them out of my 'front page' view but they'll pop back up if/when
 the customer replies, but then they never actually get resolved!
 
 So how do you chaps manage a 'large' personal queue, ensuring the right
 tickets get your attention at the right times?
 
 As a side note -- with regards stalled/resolved tickets in a personal
 queue where a member of staff is away.. is there an easy way to tell RT
 someone is away, so any reopened stuff during that duration
 automatically gets moved into the unowned queue for attention?
 
 Cheers!
 Alex
___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: [EMAIL PROTECTED]


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


Re: [rt-users] Add to a particular RT ticket/thread via email based on subject line

2008-07-24 Thread gordon
You could have an On Create scrip which parses the subject line and 
links tickets with the same Old System Number in some ordered fashion.

Gordon

Peter Collins wrote:
 Hi, it's been a while since I used RT and I'm not sure if I'm wording 
 this question correctly, but...
  
 We have a decrepit ticketing system tied to a good monitoring system. 
 When a machine or service goes down, it creates a ticket and sends a 
 page and email.
  
 I want to start using RT here, and have our old ticketing system email 
 tickets into RT. The problem is, How can RT recognize 2nd, 3rd, 4th, etc 
 updates from the old system and add them into the same ticket thread?
  
 Like:
  
 Old system sends an email to RT with its own ticket number in the 
 subject line.
  
 RT creates at ticket. So far so good.
  
 Old system has an update,such as the problem is trending down, or up, so 
 it sends another email with the same ticket number in the subj line.
  
 RT creates a NEW ticket, right? how can I get RT to read that ticket 
 number from the old system and add the comment to the original ticket?
  
 thanks in advance,
  
 Peter
 
 
 
 
 ___
 http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
 
 Community help: http://wiki.bestpractical.com
 Commercial support: [EMAIL PROTECTED]
 
 
 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: [EMAIL PROTECTED]


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


Re: [rt-users] Multipe rtname or branded queue with single RT instance?

2008-07-22 Thread gordon

Isn't it possible to simply have different templates for different 
queues which change the subject title accordingly?

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

Community help: http://wiki.bestpractical.com
Commercial support: [EMAIL PROTECTED]


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


Re: [rt-users] Multipe rtname or branded queue with single RT instance?

2008-07-22 Thread gordon
Would it be simpler to have an On Create scrip which modifies the 
ticket subject to add the queue name?

Gordon

Ruslan Zakirov wrote:
 With good regexp in the config and 3.6.7 (may be 3.6.6) it's possible.
___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: [EMAIL PROTECTED]


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


[rt-users] rt-3.8.0rc testing on same pc running rt-3.6

2008-06-24 Thread gordon
Hi,

I was wondering if I can install a test instance of rt-3.8.0rcX on the 
same computer running our production rt-3.6.3?

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

Community help: http://wiki.bestpractical.com
Commercial support: [EMAIL PROTECTED]


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


Re: [rt-users] Per-queue page customisations?

2008-05-27 Thread gordon
Alternatively you could have a custom web form for creating tickets in a 
particular queue and email the data to rt. Wouldn't be much use for 
updating tickets however.

Gordon

 
 Mark,
 
 Unfortunately just using custom-fields will not be enough to fulfill  
 our requirements as we need logic to do things like hiding the 'Owner'  
 select box for some queues.
 
 Regards,
 Tom
___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: [EMAIL PROTECTED]


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


Re: [rt-users] RIP tickets

2008-05-25 Thread gordon
How about moving all tickets of a certain age to a separate (archive) 
queue which has reply to requestor scrips disabled.

Gordon


Dominic Lepiane wrote:
 Hi,
 
 We've been using RT for many years now and an issue has recently come to my 
 attention regarding old tickets being re-opened.  Specifically, when dealing 
 with RMAs, we have both an RT ticket number and an separate tracking number 
 for another system.  As it turns out, the RT ticket numbers are all 5 digits 
 these days (going on 6) and the other number is 4 digits.  What happened was 
 that by human error, the numbers can be mixed up whereby an arbitrary and 
 very old RT ticket gets reopened when someone tries to update the RMA ticket. 
  Which is not a problem per se, support staff just close the ticket again, 
 however, RT then emails out this customer from 5 years ago.
 
 So we were wondering if we can somehow catch emails referring to very old 
 closed tickets and do something else with them.  Either email them to someone 
 in particular, open up a new ticket, drop them altogether or possibly find 
 the correct ticket based on the custom field which contains the 4-digit 
 ticket number from the other system.
 
 Can we do this and what are we looking at doing to do this?
 
 If nothing else, I would like to intercept all messages to tickets  1 
 and redirect those emails to a separate mailbox which I can probably do in 
 procmail (if my fu is strong).
 
 Thanks in advance
 
 Dominic Lepiane
 Network Administrator
 Point Grey Research

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

Community help: http://wiki.bestpractical.com
Commercial support: [EMAIL PROTECTED]


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


Re: [rt-users] RT 3.8 beta 2 now available

2008-05-08 Thread gordon
  On Wed, Jan 16, 2008 at 12:02:52PM -0500, Yitzchak Schaffer wrote:
  Greetings:
 
  Has anyone added custom fields where the choices are taken from a query
  against an outside database, perhaps by modifying the RT code? I didn't
  see anything about this in the docs, and it didn't seem like Include
  page in the CF modification screen would be able to achieve this. If
  not, where should I look in the source code -
  share/html/Elements/EditCustomField seems like a good starting spot.


 That's a feature we've added for RT 3.8. If you're currently in
 development, you might want to start with RT 3.7 - we're trying to get
 3.8 ready for release now (though don't have a scheduled date)



Did this feature actually make it into 3.8? I haven't found reference to 
it in the changelogs.

gordon





Jesse Vincent wrote:
 We've integrated about 350 changes to RT in the last two months as part 
 of the big push toward RT 3.8.0. Many of those changes were made to 
 integrate features Best Practical has built or prototyped for clients 
 over the past several years. Below, please find the high-level changelog 
 for the differences between RT 3.7.81 and RT 3.7.85 (Beta 1 and Beta 2).
 
 At this point, the known remaining work is mostly related to polishing 
 the new web-based installation mechanism and cleaning up small issues as 
 they're reported.
 
 RT 3.7.85 is NOT RECOMMENDED for production use, however we strongly 
 urge you to deploy it in your testing environment and provide feedback 
 to help ensure that RT 3.8.0 is released soon and does what you need 
 when we release it.
 
 
 http://download.bestpractical.com/pub/rt/devel/rt-3.7.85.tar.gz
 http://download.bestpractical.com/pub/rt/devel/rt-3.7.85.tar.gz.sig
 
 Best,
 Jesse
 
 
 Major new features:
 * Designed a new default RT 3.8 visual style
 * Added support for Rich text / HTML mail composition within RT
 * Added support for  batched email 'digests' (Weekly or daily)
   as well as the ability for a user disable mail him or herself
 * Added the ability for users to build multiple custom 'dashboards'
   out of saved searches, saved graphs and saved charts and to mail
   those dashboards as reports on a regular basis.
 * Added a new, friendlier web-based installation system.
 * Added a Graphviz based visualization of ticket relationships
 * Added simple buttons to create new related tickets
 * Added simple 'bookmarks'/'favorites' support for tickets
 * Added the Ability to subscribe to iCalendar feeds of ticket start/due
   dates in Google Calendar / iCal.app
 * Integrated BrandedQueues RT extension. Let you specify a different
   subject token per queue
 * Integrated RT::Action::ExtractSubjectTag to better support 
 conversations
   between multiple ticketing systems
 * Integrated RT::Action::LinearEscalate
 * Integrated RT::Action::NotifyGroup
 
 Minor new features:
 * EmailInput refactoring, for possible later autocompleter
 * Clean up prototype/scriptaculous files
 * more cleanups on mysql schema vs. charsets, update upgrade script 
 as well
 * Allow mailto:; links as nav menu items
 * Adding a PreForking variant of our Standalone webserver. 
 (currently disabled)
 * Applied a patch from Brian Nelson to add better display of large 
 text
   custom fields.
 * The CreateTicket widget now supports ticket bodies
 * Added Dean Edwards IE7.js to make it easier to write 
 cross-browser styles
 * Finally killed code duplicated between RT::EmailParser and 
 RT::InterfaceEmail

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

Community help: http://wiki.bestpractical.com
Commercial support: [EMAIL PROTECTED]


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


Re: [rt-users] Can I automatically display a Ticket after CF modification?

2007-12-11 Thread gordon
When I click the link for Basics or People or Dates the page for 
modifying the associated information is displayed and at the bottom of 
the page is a Save Changes button. Clicking this button does save any 
changes I have made to the page but, unlike adding a Comment, the modify 
page remains open and I have to click the Display link to show the ticket.


Perhaps this issue has been discussed earlier, however my searches of 
the list have not uncovered anything. Does anyone know where I can look 
for a solution?


thanks
Gordon


Drew Barnes wrote:

The Save Changes button, as far as I can tell, doesn't actually change
anything until the Update Ticket button is pressed.  It is used to add
or remove recipients from a given message, be they AdminCCs, CCs or Bccs
on the ticket.


[EMAIL PROTECTED] wrote:

Is there a simple mod which would automatically display the ticket after
the Save Changes button has been clicked on the Modify.html page,
instead of returning to the Modify page?

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

SAVE THOUSANDS OF DOLLARS ON RT SUPPORT:

If you sign up for a new RT support contract before December 31, we'll take
up to 20 percent off the price. This sale won't last long, so get in touch today. 
   Email us at [EMAIL PROTECTED] or call us at +1 617 812 0745.



Community help: http://wiki.bestpractical.com
Commercial support: [EMAIL PROTECTED]


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


Re: [rt-users] how to limit create ticket permission to particular email domain

2007-12-04 Thread Gordon Messmer
Depending on how seriously you take that idea, I have a filter for the 
Courier MTA that does exactly that:


http://phantom.dragonsdawn.net/~gordon/courier-pythonfilter/latest/filters/privateaddr.py

Kenneth Marshall wrote:

It may be worth doing it in the mail system before the ticket is
logged to RT. Then you do not have a ticket you need to delete.

Ken

  


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

SAVE THOUSANDS OF DOLLARS ON RT SUPPORT:

If you sign up for a new RT support contract before December 31, we'll take
up to 20 percent off the price. This sale won't last long, so get in touch today. 
   Email us at [EMAIL PROTECTED] or call us at +1 617 812 0745.



Community help: http://wiki.bestpractical.com
Commercial support: [EMAIL PROTECTED]


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


Re: [rt-users] How to Configure RT with MS Exchange 2007

2007-11-30 Thread Gordon Messmer

tariq.doukkali wrote:

In the file /etc/postfix/maincf:

replayhost=IP-Adress of Courier-mail server
...

Now we changed our mail server form courier to exchange 2007. I 
configured the IP adress of exchange server in the /etc/postfix/maincf 
as replayhost. This configuration dont works!!! the mail notification 
through RT dont works again !! ...


I'm assuming that you mean relayhost.  Postfix should be logging any 
errors that occur when it tries to send mail to the exchange server.  
Start by checking your postfix logs.


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

SAVE THOUSANDS OF DOLLARS ON RT SUPPORT:

If you sign up for a new RT support contract before December 31, we'll take
up to 20 percent off the price. This sale won't last long, so get in touch today. 
   Email us at [EMAIL PROTECTED] or call us at +1 617 812 0745.



Community help: http://wiki.bestpractical.com
Commercial support: [EMAIL PROTECTED]


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


Re: AW: Re: [rt-users] clean up user table

2007-11-27 Thread Gordon Messmer

Ham MI-ID, Torsten Brumm wrote:

Hi,
Make sure to delete the users in a safe way with rtx-shredder and not 
directly from the db.


I'd prefer to, but as I said before, it doesn't work.  The newest 
version of rtx-shredder has a User plugin that has a no_tickets option, 
but when I use that, it says that there's nothing to remove.


Btw, about how many users we talk? We have NO 
performance problems with 30.000 active and a half a million inactive 
users


From my original message: CachedGroupMembers (254475 rows), 
GroupMembers (87456 rows), Groups (95138 rows), Principals (110714 
rows), and Users (15574 rows) tables.


It doesn't seem like much, but it is mighty slow.  How do your tables 
compare?


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

SAVE THOUSANDS OF DOLLARS ON RT SUPPORT:

If you sign up for a new RT support contract before December 31, we'll take
up to 20 percent off the price. This sale won't last long, so get in touch today. 
   Email us at [EMAIL PROTECTED] or call us at +1 617 812 0745.



Community help: http://wiki.bestpractical.com
Commercial support: [EMAIL PROTECTED]


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


Re: AW: Re: [rt-users] clean up user table

2007-11-27 Thread Gordon Messmer

Sven Sternberger wrote:

oops!

On Di, 2007-11-27 at 10:07 +0100, Sven Sternberger wrote:

But rtx-shredder don't give you a simple way to delete all
users without a ticket, so you have to combine the select
statement from Gordon, and then call rtx-shredder


so Geordons sql statemaent is of course not correct
(for most of us) we have a lot of valid users who never
owned a ticket.
So replace Ticket.owner with Transaction.creator, 
which gives us all users where we deleted 
their tickets via rtx-shredder.


Yep, I noticed that later. So far, the best I've got is this:

SELECT users.id
FROM users
WHERE users.id NOT IN
 (SELECT users.id
  FROM users
  INNER JOIN principals ON users.id = principals.id
  LEFT JOIN tickets ON principals.id = tickets.Owner
 OR principals.id = tickets.creator
  WHERE Tickets.id IS NOT NULL);

I still don't know how other relationships are tracked, like CCs?
___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

SAVE THOUSANDS OF DOLLARS ON RT SUPPORT:

If you sign up for a new RT support contract before December 31, we'll take
up to 20 percent off the price. This sale won't last long, so get in touch today. 
   Email us at [EMAIL PROTECTED] or call us at +1 617 812 0745.



Community help: http://wiki.bestpractical.com
Commercial support: [EMAIL PROTECTED]


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


Re: AW: Re: [rt-users] clean up user table

2007-11-27 Thread Gordon Messmer

Kenneth Marshall wrote:

Here is our instance data, not slow at all:


I'm willing to consider that I'm looking in the wrong place...  When you 
open a ticket, what's the time to display on your instance?  Which DB 
are you using, and what tuning did you do to it?


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

SAVE THOUSANDS OF DOLLARS ON RT SUPPORT:

If you sign up for a new RT support contract before December 31, we'll take
up to 20 percent off the price. This sale won't last long, so get in touch today. 
   Email us at [EMAIL PROTECTED] or call us at +1 617 812 0745.



Community help: http://wiki.bestpractical.com
Commercial support: [EMAIL PROTECTED]


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


Re: AW: Re: [rt-users] clean up user table

2007-11-27 Thread Gordon Messmer

Kenneth Marshall wrote:


The time to open and display a ticket varies based on the number
of transactions involved, but typically takes on the order of 1-3s.


With RT3 3.6.5 and PG 8.1.9, I'm seeing newish tickets open in a little 
more than two seconds.  I don't have numbers for MySQL 5, but I recall 
it being less than half a second.  It was much longer than that with our 
slightly older rt3 on MySQL 5, and also much longer before we'd done 
vacuum analyse on postgres. ;)


Yes, having seen the system behave much faster, I do think that 2 
seconds is slow.



A new ticket with a few updates will take about 1s and an older
ticket with many updates takes 3-4s. We are using PostgreSQL 8.2
for the backend DB with the index patches from the mailing list
posting. I did have to watch the logs for slow queries, to figure
out where indexes were needed. That and keeping the session table
cleaned is pretty much all that we need to do. From your description,
it sounds like you are just missing an index or two. Once you find
out what you need and add them, you will be fine. I can help with
PostgreSQL but I do not have much experience with tuning MySQL.


After enabling the log, this is the single slowest query that I saw.

2007-11-27 09:39:53 PST rt3 - LOG:  duration: 450.262 ms  statement: 
SELECT main.* FROM ( SELECT main.id FROM GroupMembers main JOIN Groups 
Groups_1  ON ( Groups_1.id = main.GroupId )  WHERE (Groups_1.Domain = 
'SystemInternal' OR Groups_1.Domain = 'UserDefined') AND (main.MemberId 
= '169133')   GROUP BY main.id  ORDER BY min(Groups_1.Domain) ASC, 
min(Groups_1.Name) ASC  ) distinctquery, GroupMembers main WHERE 
(main.id = distinctquery.id)


Where would I look for index patches?
___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

SAVE THOUSANDS OF DOLLARS ON RT SUPPORT:

If you sign up for a new RT support contract before December 31, we'll take
up to 20 percent off the price. This sale won't last long, so get in touch today. 
   Email us at [EMAIL PROTECTED] or call us at +1 617 812 0745.



Community help: http://wiki.bestpractical.com
Commercial support: [EMAIL PROTECTED]


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


Re: [rt-users] clean up user table

2007-11-27 Thread Gordon Messmer

Ruslan Zakirov wrote:

Try to combine no_tickets option with another option.


Ah, I see.  Now that you've pointed that out, I notice that 
status=disabled is used as a default filter.  I missed that, 
previously.  If I specify status,any, I get many results.  I'll give 
this a shot later on.  Thanks very much.


$ rtx-shredder --plugin 
'Users=no_tickets,true;limit,2;status,any;replace_relations,Nobody'



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

SAVE THOUSANDS OF DOLLARS ON RT SUPPORT:

If you sign up for a new RT support contract before December 31, we'll take
up to 20 percent off the price. This sale won't last long, so get in touch today. 
   Email us at [EMAIL PROTECTED] or call us at +1 617 812 0745.



Community help: http://wiki.bestpractical.com
Commercial support: [EMAIL PROTECTED]


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


Re: [rt-users] clean up user table

2007-11-26 Thread Gordon Messmer

Todd Chapman wrote:

Are you having preformance problems related to the users? If not why
clean it up? Do you like to play with fire?
  


Yes, I am.  RT3 makes multiple queries per ticket displayed that join 
the very large principals and cachedgroupmembers tables.  It causes 
tickets to display somewhat slowly.  There's a small but notable delay 
with RT3 3.6.5 and Pg 8.1.  The delay was intolerably long with some 
earlier minor revision of 3.6 and MySQL 5.0.


I'm tired of running into these problems when I update some component of 
the system, and would like to prune out the tens of thousands of user 
records created by spam through the mail gateway.  I'd be grateful for 
any help that the list can offer.

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

SAVE THOUSANDS OF DOLLARS ON RT SUPPORT:

If you sign up for a new RT support contract before December 31, we'll take
up to 20 percent off the price. This sale won't last long, so get in touch today. 
   Email us at [EMAIL PROTECTED] or call us at +1 617 812 0745.



Community help: http://wiki.bestpractical.com
Commercial support: [EMAIL PROTECTED]


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


[rt-users] Finding users with no accociated tickets.

2007-10-30 Thread Kevin Gordon
Hi List,

I'm cleaning out RT with rtx-shredder and have vast amounts of old spam
to remove.  

I'm looking for a solution/query to list all users with no tickets this
I believe will considerably cut down the huge list of spam emails to
remove.

I have tried the no_tickets Boolean option in rtx-shredder but returns
no results, I'm not sure what arguments the Boolean accepts, tried true?
 
I'm wondering if this could be done from the rt command line or with an
SQL query, just looking for a point in the right direction.

Also any comment on cleaning out RT greatly accepted.

I'm using the latest version of RT with Pg backend.

Thanks,

Kevin

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

SAVE THOUSANDS OF DOLLARS ON RT SUPPORT:

If you sign up for a new RT support contract before December 31, we'll take
up to 20 percent off the price. This sale won't last long, so get in touch 
today. 
Email us at [EMAIL PROTECTED] or call us at +1 617 812 0745.


Community help: http://wiki.bestpractical.com
Commercial support: [EMAIL PROTECTED]


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


[rt-users] At A Glance

2007-10-29 Thread Kevin Gordon
Hi List,

Trying to upgrade from 3.4.2 - 3.6.5, all went smooth only apparent
errors where updating the schema from 3.5.1; couldn't find schema for;
Pd, after browsing lists I'm under the impression that this can be
ignored? as there is no schema update?

When logging in to 3.6.5 the home page contains no tickets for the user
at a glance also contains no tickets.

If I try to edit:

http://rt.smtl.co.uk/rt3/Admin/Global/MyRT.html

The following error occurs:

error:  Can't call method Content on an undefined value
at /usr/local/rt3/share/html/Admin/Global/MyRT.html line 97, DATA line
1662.
context:  
... 

93: 
my ( $conf, $pane ) = @_;
94: 
$default_portlets-SetContent( $conf );
95: 
push @actions, loc( 'Global portlet
[_1] saved.', $pane );
96: 
}
97: 
);
98: 

99: 
$m-comp( '/Widgets/SelectionBox:process', %ARGS, self = $_, nojs = 1 )
100: 
for @panes;
101: 

... 

code stack:   /usr/local/rt3/share/html/Admin/Global/MyRT.html:97
/usr/local/rt3/share/html/Admin/autohandler:49
/usr/local/rt3/share/html/autohandler:291

RAW error:

Can't call method Content on an undefined value
at /usr/local/rt3/share/html/Admin/Global/MyRT.html line 97.


Trace begun at /usr/local/share/perl/5.8.7/HTML/Mason/Exceptions.pm line 129
HTML::Mason::Exceptions::rethrow_exception('Can\'t call method Content on an 
undefined value at /usr/local/rt3/share/html/Admin/Global/MyRT.html line 
97.^J') called at /usr/local/rt3/share/html/Admin/Global/MyRT.html line 97
HTML::Mason::Commands::__ANON__ at 
/usr/local/share/perl/5.8.7/HTML/Mason/Component.pm line 135
HTML::Mason::Component::run('HTML::Mason::Component::FileBased=HASH(0xa0cb0a0)')
 called at /usr/local/share/perl/5.8.7/HTML/Mason/Request.pm line 1262
eval {...} at /usr/local/share/perl/5.8.7/HTML/Mason/Request.pm line 1252
HTML::Mason::Request::comp(undef, undef, undef) called at 
/usr/local/share/perl/5.8.7/HTML/Mason/Request.pm line 921
HTML::Mason::Request::call_next('HTML::Mason::Request::ApacheHandler=HASH(0xa0b2cf0)')
 called at /usr/local/rt3/share/html/Admin/autohandler line 49
HTML::Mason::Commands::__ANON__ at 
/usr/local/share/perl/5.8.7/HTML/Mason/Component.pm line 135
HTML::Mason::Component::run('HTML::Mason::Component::FileBased=HASH(0xa0cb5e0)')
 called at /usr/local/share/perl/5.8.7/HTML/Mason/Request.pm line 1262
eval {...} at /usr/local/share/perl/5.8.7/HTML/Mason/Request.pm line 1252
HTML::Mason::Request::comp(undef, undef, undef) called at 
/usr/local/rt3/share/html/autohandler line 291
HTML::Mason::Commands::__ANON__ at 
/usr/local/share/perl/5.8.7/HTML/Mason/Component.pm line 135
HTML::Mason::Component::run('HTML::Mason::Component::FileBased=HASH(0xa0de5c4)')
 called at /usr/local/share/perl/5.8.7/HTML/Mason/Request.pm line 1257
eval {...} at /usr/local/share/perl/5.8.7/HTML/Mason/Request.pm line 1252
HTML::Mason::Request::comp(undef, undef, undef) called at 
/usr/local/share/perl/5.8.7/HTML/Mason/Request.pm line 466
eval {...} at /usr/local/share/perl/5.8.7/HTML/Mason/Request.pm line 466
eval {...} at /usr/local/share/perl/5.8.7/HTML/Mason/Request.pm line 418
HTML::Mason::Request::exec('HTML::Mason::Request::ApacheHandler=HASH(0xa0b2cf0)')
 called at /usr/local/share/perl/5.8.7/HTML/Mason/ApacheHandler.pm line 168
HTML::Mason::Request::ApacheHandler::exec('HTML::Mason::Request::ApacheHandler=HASH(0xa0b2cf0)')
 called at /usr/local/share/perl/5.8.7/HTML/Mason/ApacheHandler.pm line 826
HTML::Mason::ApacheHandler::handle_request('HTML::Mason::ApacheHandler=HASH(0x97d1dbc)',
 'Apache2::RequestRec=SCALAR(0x9774970)') called at 
/usr/local/rt3/bin/webmux.pl line 125
eval {...} at /usr/local/rt3/bin/webmux.pl line 125
RT::Mason::handler('Apache2::RequestRec=SCALAR(0x9774970)') called at -e line 0
eval {...} at -e line 0

The newer system looks pretty fresh and I'm eager to upgrade.

Thanks,

Kevin

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

SAVE THOUSANDS OF DOLLARS ON RT SUPPORT:

If you sign up for a new RT support contract before December 31, we'll take
up to 20 percent off the price. This sale won't last long, so get in touch 
today. 
Email us at [EMAIL PROTECTED] or call us at +1 617 812 0745.


Community help: http://wiki.bestpractical.com
Commercial support: [EMAIL PROTECTED]


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


[rt-users] Bar/Pie Chart issue

2007-10-12 Thread Brock Gordon
I've not been able to find a clue in the lists and was wondering if 
someone could point me in the right direction. Pie and Bar charts aren't 
working in my 3.6.4 install. Using FreeBSD with Apache2 and ModPerl2. 
Charting works fine in Webalizer (generates png graphs), so I'm assuming 
it's not an issue with GD. Where do I begin? Here's what the properties 
of the red x show (I'm manually adding the line break of course):


Chart?Order=ASCChartStyle=barQuery=Queue%20%3D%20'Support'%20AND%20(Status%20%3D%20'open'%20OR%20Status%20%3D%20'new'%20OR%20Status%20%3D%20'stalled') 
\

Rows=50SecondaryGroupBy=OrderBy=idPrimaryGroupBy=StatusFormat=

and here is the referenced URL:

http://support.southwood.org/rt/Search/Chart?Order=ASCChartStyle=barQuery=Queue%20%3D%20'Support'%20AND%20(Status%20%3D%20'open'%20OR%20Status%20%3D%20'new'%20OR%20Status%20%3D%20'stalled') 
\

Rows=50SecondaryGroupBy=OrderBy=idPrimaryGroupBy=StatusFormat=

I enter the URL in lynx and get an unexpected network read error

The apache access-log shows a 200 code.

I am seeing a message in /var/log/message that says httpd is exiting on 
signal 6


I get a red x and a table with data below.

What next?

Thanks for any help you can provide.

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

Community help: http://wiki.bestpractical.com
Commercial support: [EMAIL PROTECTED]


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


[rt-users] deleting data

2006-11-07 Thread Gordon Messmer
We're currently running RT 3.6.0.  For quite a while, we had a mail 
gateway running that allowed a whole lot of spam into the database.  
I've put up a mail filter so that only local users can email RT, now, 
and I'd like to clean up the database some.


I've used rtx-shredder to remove all of the deleted tickets.  At this 
point, though, I'm not sure how to delete users that aren't associated 
with any tickets (spam addresses).  I'm also confused about the size of 
some of the tables.  I've attached a row count from all of the tables.  
rtx-shredder doesn't seem to help cleaning some of them out.


Can anyone guess why there are several times more groups than users?  
Why is the CachedGroupMembers table so large?  Can the 
CachedGroupMembers and sessions tables be cleared entirely?  Where else 
can I look at cleaning up?


ACL :: 333
Attachments :: 61741
Attributes :: 7
CachedGroupMembers :: 227942
CustomFieldValues :: 0
CustomFields :: 0
GroupMembers :: 79256
Groups :: 83990
Links :: 295
ObjectCustomFieldValues :: 0
ObjectCustomFields :: 0
Principals :: 98550
Queues :: 16
ScripActions :: 17
ScripConditions :: 10
Scrips :: 26
Templates :: 14
Tickets :: 17338
Transactions :: 116876
Users :: 14559
sessions :: 13552

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

Community help: http://wiki.bestpractical.com
Commercial support: [EMAIL PROTECTED]


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


[rt-users] Re: RT LDAP

2006-10-29 Thread Kyle Gordon
On Thursday 26 October 2006 17:15, Jim Meyer wrote:
 On 10/23/06, Kyle Gordon [EMAIL PROTECTED] wrote:
  Hey Jim,
 
  Great work on the LDAP overlay for RT :-) Ive gotten it talking to
  eDirectory nicely now. Just two things though... :-p
 
  The documentation up on wiki.bestpractical.com suggests use the
  Set($foo, 'bar') style, yet I could only get it to work with $foo='bar';
  style directives. Dunno if this is intended or not :-)

 Hmm. Works for me with RT 3.5.x and 3.6.x with Set(...) syntax. What
 version of RT are you using?


I'm using version v3.4.4 on Ubuntu Edgy. Not quite upgrade to 3.6 yet. The 
rest of the 3.4.4 configuration directives use Set(...), so looks like an 
oddity.

  Also, I'm trying to get it to recursively search our directory for the
  username that is entered. This is all well and good if I give it an OU to
  search in along with the organisation. However, if I leave the OU out and
  try to get it to search the entire organisation from the ground up, it
  fails.
 
  Any thoughts on this? I have users from several parts of the NHS in the
  facility here, and only about 75% of them are in the OU for the facility.
  It makes it a little troublesome to roll out a fantastic new ticketing
  system when some of them can't access it (although I'd prefer if they
  couldn't log any problems at all :-)

 Hmmm. I'm not an LDAP expert, so I've copied this to the list in hopes
 we'll hear from one. My first instinct is to be sure the limitation
 isn't on the directory server's part (e.g. they've limited the depth
 of a search to avoid lots of full-depth searches) but that's probably
 not right.


The server at work doesn't have any recursion/depth limits on it, so I'm not 
sure where it's playing up. I've just tested RT on my home eDirectory setup, 
and it worked fine when the user was dropped straight into the top level of 
the organization, as well as when the the user was several OU's down the 
tree. This is all with the $LdapBase=o=glasgownet I've tried moving the 
object at work into the top level, but it still bailed out. 

My object at work is cn=KyleG,ou=Net_Team,ou=CLIFTON,o=SCPMDE, and it'll only 
work with $LdapBase=ou=CLIFTON,o=SCPMDE, and my object at home is 
cn=kylegordon,ou=Home,ou=lodge,o=glasgownet yet it'll work with 
$LdapBase=o=glasgownet This shows that it's probably something up with our 
eDir configuration, but I'm not sure where to start looking. Is it possible 
to get more debug output from RT or Perl?

Any thoughts would be appreciated :-)
 
 --j

Kyle
-- 
Kyle Gordon
[EMAIL PROTECTED]
http://lodge.glasgownet.com
___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: [EMAIL PROTECTED]


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


Re: [rt-users] eDirectory authentication and creation

2006-10-23 Thread Kyle Gordon
Well, it mostly works now. I left if for a while and came back to it late on 
Friday night. After some random tests, I decided to ignore the 
documentation... Where Jim Meyer had suggested using 
Set($LdapServer, 'foo.bar');, it actually needed $LdapServer=foo.bar;. 
Rinse and repeat for the rest of the relevant directives.

I don't know if this qualifies as a bug, but at least the information is out 
there now.

Kyle

On Wednesday 11 October 2006 18:46, Kyle Gordon wrote:
 On Wednesday 11 October 2006 18:29, Tim Wilson wrote:
   On Wed, Oct 11, 2006 at 11:39 AM, in message
 
  [EMAIL PROTECTED], Kyle Gordon
 
  [EMAIL PROTECTED] wrote:
   I'm having a few issues setting up LDAP/eDirectory authentication and
 
  user
 
   creation with RT3.4 on Ubuntu Dapper.
 
  Kyle,
 
  I've got a similar setup and I was having some problems too. I've
  discovered that each time I authenticate to eDirectory through RT, our
  Novell system is registering a failed login attempt even though the
  authentication was successful. That was decrementing my grace logins
  until they expired, at which point authentication via RT would fail. I
  ended up turning off that feature so that I have an unlimited number of
  login attempts. Further, we discovered that the problem wasn't uniform.
  Some users aren't affected and some are. It appears that users created
  with the pre-ConsoleOne admin tool behave differently than newer users.
  We haven't nailed everything down yet.

 Hey,

 Thanks for the info. My grace login count is at the level it should be, and
 intruder lockout is disabled - so all appears to be good from that angle.

 I'm going to sleep on it and see what I come up with tomorrow :-)

 Regards

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

 Community help: http://wiki.bestpractical.com
 Commercial support: [EMAIL PROTECTED]


 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: [EMAIL PROTECTED]


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


[rt-users] eDirectory authentication and creation

2006-10-11 Thread Kyle Gordon
Hi all, 

I'm having a few issues setting up LDAP/eDirectory authentication and user 
creation with RT3.4 on Ubuntu Dapper.

I've followed the instructions on http://wiki.bestpractical.com/index.cgi?
LDAP, and am using it purely for authentication, and then user creation if 
the user does not exist in the RT database.

When I go to log in as a valid eDir user, I get the following error 
messages...

Oct 11 17:12:53 ticketbox RT: Trying LDAP authentication
Oct 11 17:12:53 ticketbox RT: RT::User::IsLDAPPassword AUTH FAILED: KyleG 
(/usr/share/request-tracker3.4/lib/RT/User_Local.pm:182)
Oct 11 17:12:53 ticketbox RT: RT::User::IsPassword auth method 
IsLDAPPassword FAILED
Oct 11 17:12:53 ticketbox RT: RT::User::IsInternalPassword AUTH FAILED (no 
passwd): KyleG (/usr/share/request-tracker3.4/lib/RT/User_Local.pm:232)
Oct 11 17:12:53 ticketbox RT: RT::User::IsPassword auth method 
IsInternalPassword FAILED
Oct 11 17:12:53 ticketbox RT: FAILED LOGIN for KyleG from 10.30.213.156 
(/usr/share/request-tracker3.4/html/autohandler:191)

I've posted the RT_SiteConfig.pm to 
http://lodge.glasgownet.com/~bagpuss/RT_SiteConfig.pm.txt, if anyone is 
interested in it. Where would be the best place to start looking for the 
failure reason? I'm confident the user and pass is correct :-)

Regards

Kyle


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

Community help: http://wiki.bestpractical.com
Commercial support: [EMAIL PROTECTED]


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