Re: [rt-users] RT 4.0.5 and IE8 very slow with the new menu

2012-04-11 Thread L B
On Tue, Apr 10, 2012 at 6:15 PM, Ruslan Zakirov r...@bestpractical.com wrote:
 On Tue, Apr 10, 2012 at 19:27, L B bertig...@gmail.com wrote:
 I don't know if it's related to PIE.htc, but there are also annoying
 bugs with IE, see attached.

 This has been fixed in
 4.0/ticket-history-alignment-fix-for-opera-and-ie7 branch.

Ok thanks. Sorry for mixing 2 problems in the same ticket. The
alignment is fixed now.

I continue my tests with PIE.htc and let you know.

-- 
L.B.


Re: [rt-users] RT 4.0.5 and IE8 very slow with the new menu

2012-04-11 Thread L B
 I continue my tests with PIE.htc and let you know.


I removed the aileron directory and replaced it with the one from
github. It's fast know, thanks !

-- 
L.B.


[rt-users] RT 4 and IE8 : text overlap

2012-04-11 Thread L B
Hello,

 I found a bug in the template with IE8, see attached. Not sure if
it's known and how to fix it. It works in Chrome.

-- 
L.B.
attachment: iebug.png

Re: [rt-users] mysql to oracle migration

2012-04-11 Thread Pedro Albuquerque
Thanks for the info.
I will take a look at these scripts and try to use them in Oracle.

I'll get back to you with updates.

Cheers,
Pedro.

On Tue, Apr 10, 2012 at 5:08 PM, Sabuj Pattanayek sab...@gmail.com wrote:

 see this thread

 http://www.gossamer-threads.com/lists/rt/users/103305?do=post_view_threaded#103305

 On Tue, Apr 10, 2012 at 11:06 AM, Sabuj Pattanayek sab...@gmail.com
 wrote:
  Looks like it's also supported with pgsql :
 
  http://blog.bestpractical.com/2011/06/full-text-searching.html
 
  if that's an option for you ...
 
  On Tue, Apr 10, 2012 at 11:03 AM, Pedro Albuquerque pedro...@gmail.com
 wrote:
  Hi,
 
  I am trying to migrate mysql to oracle to have full text search.
  I updated successfully a RT 3.6.10 to RT 4.0.5 using mysql. However,
 when I
  migrate data and objects to oracle using sql developer, there is some
 issues
  in the attachments encoding, for instance.
 
  Does anyone has migrated from mysql to oracle?
 
  Cheers,
  Pedro.



Re: [rt-users] RT 4.0.5 bug in Excel export

2012-04-11 Thread Tim Cutts

On 11 Apr 2012, at 09:41, L B wrote:

 Hi,
 
 Some HTML stuff is not handled properly, see attachment. It worked
 well in RT 3.8.7
 
 I don't know if it has been fixed in some branch but I experienced
 the problem with the last Results.tsv available on github.

I saw a similar thing when using Status with a CustomStatus callback which 
colours my statuses (as in the example in the Wiki).

The problem in that case was that the callback was being called *after* the 
Excel export does its ScrubHTML bit, so HTML gets through.  I had to alter my 
callback so that it checked if the request for a Results page.

This looks like a similar issue.  Are you using any callbacks or extensions 
which change how the priorities are displayed in your web pages?  If you are, 
that's probably the cause.

Tim

--
 The Wellcome Trust Sanger Institute is operated by Genome Research
 Limited, a charity registered in England with number 1021457 and a
 company registered in England with number 2742969, whose registered
 office is 215 Euston Road, London, NW1 2BE.


Re: [rt-users] RT 4.0.5 bug in Excel export

2012-04-11 Thread L B

 I saw a similar thing when using Status with a CustomStatus callback which 
 colours my statuses (as in the example in the Wiki).

 The problem in that case was that the callback was being called *after* the 
 Excel export does its ScrubHTML bit, so HTML gets through.  I had to alter my 
 callback so that it checked if the request for a Results page.

 This looks like a similar issue.  Are you using any callbacks or extensions 
 which change how the priorities are displayed in your web pages?  If you are, 
 that's probably the cause.

Yes, I use http://search.cpan.org/dist/RT-Extension-PriorityAsString/ extension.

-- 
L.B.


[rt-users] Ldap groups and queues permissions

2012-04-11 Thread Cristo Bolaños Trujillo
Hello,

I'm using request tracker at work (succesfully!!) but got some problems
when tried to manage queues permission using groups.

I've googled about it, read documentation on wiki, tried request tracker
web interface and direct sql database changes taking as example already
working queues, but I can't get any success.

Scenario:

- I create a group on LDAP and request tracker.
- I create a user on LDAP and request tracker.
- I assign this user to group on LDAP and request tracker.
- I assign every role on group to a queue.

User can login to request tracker, get limited privileges, but user can't
see queue: it doesn't appear on the select next to New ticket.

I tried restarting apache, memcached, closing user web session and
restarting, but didn't get any success.

¿May be I've missed any step?

Any help is very appreciated :)

Thanks a lot in advance.


Re: [rt-users] [rt-devel] RT and JasperReports Server Integration (got it working, anyone interested?)

2012-04-11 Thread Benjamin Boksa
Wow - Thanks a lot for all of your feedback.

I will try to setup a (github-)repository  and some basic instructions about 
setting up RT4 and JasperServer on Debian 6 by the end of next week (April 22). 
At the moment I have to catch up on the backlog created while writing the 
integration toolkit - yesterday I started working on the backlog by sending out 
the first actual quarterly invoices created with it :-D

In the meantime feel free to send me suggestions, tell me about features you 
would like to see and use cases to be covered so that I can prepare a proposed 
roadmap as soon as we start! Also I still don't have a name for the project (my 
local repository is named jasper-rt which seems very boring) - if you have any 
cool suggestions please share them :-)

@mailinglist admins: Is it OK to use the rt-devel mailinglist for the first 
basic discussions or should I create a separate mailing list?

Thanks a lot for all your answers, I am sure your interest and feedback will 
help making this a cool tool.

Benjamin



Am 09.04.2012 um 13:44 schrieb Robert Blackwell:

 I agree this would be an excellent addition to RT. Is there a project
 repository set up somewhere? I would be interested using this and
 helping with the project.
 
 Robert
 
 
 On Mon, Apr 9, 2012 at 6:51 AM, Cornell D. Green cornellgr...@gmail.com 
 wrote:
 This sounds like an excellent addition to RT, a tool I myself have been 
 working with since nearly its inception.
 
 Not much of a developer myself, I encourage you to consider at least making 
 this available to the RT community, if not actually folding it into the RT 
 code base.
 
 Cornell D. Green
 CIO
 CommunIT Solutions
 Let's get Your Technology to WORK!
 http://CommunIT.us/helpdesk
 
 On Apr 9, 2012, at 6:39 AM, Benjamin Boksa mailingli...@boksa.de wrote:
 
 Hi Everyone,
 
 RT has been my primary tool to manage Tickets and other Requests since 2001 
 (RT 2.x) and I am still using it everyday. During the last few years I 
 integrated some billing functions into RT (by using custom fields, 
 workflows etc.). As a natural consequence I have reached the point where I 
 need a function I could not find in RT itself: easily manageable print 
 layouts (aka PDFs ;-) ) that can be custom tailored to fit my client's 
 needs (e.g. grouping by cost unit).
 
 After a few days of work I now have a completely working system that allows 
 me to create pretty, printable Reports from RT using JasperReports Server 
 [1].
 
 It uses RT's REST API with customizable (query builder) queries and a 
 simple definition (REST Interface URL, Username and Password) to access 
 ticket data from JasperReports Server. I have done so by creating a custom 
 DataSource [2] and a custom QueryExecuter [3] for JasperReports - all you 
 need to know to prepare your data from RT to be used in a Jasper report are 
 the credentials of your instance's REST Interface and the query builder 
 query you would like to run - you should know all of these if you work with 
 RT regularly ;-)
 
 You can then use tools like iReport [4] to design fantastic reporting 
 templates for your RT data including your logo, graphs and many other cool 
 things.
 
 As you already might have guessed I think I have found a pretty good 
 solution to integrate RT and JasperReports Server. Now I am standing at the 
 point where I wonder
 
 a) If this is interesting to the RT community (found some mails back in 
 2007)?
 b) If anyone of you is interested in joining my efforts to improve the 
 solution?
 c) If there is anything else you would like to know about the solution?
 d) As a part of the project I have also built a single J2EE component (DAO 
 [5]) to access the RT REST Interface - would you like to see this component 
 to be released independently?
 
 I would be glad to get some feedback from you to see if this will be a cool 
 thing for myself or if it makes sense to create a project for the RT 
 community - I have many cool ideas in the back of my head (like direct 
 integration into the RT web interface).
 
 Looking forward to your answers and sending curious greetings from Cologne
 
 Benjamin
 
 
 P.S.: As this is a very developerish topic I hope it is OK to crosspost 
 this mail...
 
 
 [1] http://jasperforge.org/projects/jasperserver
 [2] 
 http://jasperreports.sourceforge.net/sample.reference/datasource/index.html#customdatasource
 [3] 
 http://jasperforge.org/uploads/publish/jasperreportswebsite/trunk/sample.reference/hibernate/index.html#queryexecuters
 [4] http://jasperforge.org/projects/ireport
 [5] 
 http://java.sun.com/blueprints/corej2eepatterns/Patterns/DataAccessObject.html
 
 List info: http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-devel
 
 
 List info: http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-devel
 



Re: [rt-users] RT 4.0.5 bug in Excel export

2012-04-11 Thread Tim Cutts

On 11 Apr 2012, at 10:25, L B wrote:

 
 I saw a similar thing when using Status with a CustomStatus callback which 
 colours my statuses (as in the example in the Wiki).
 
 The problem in that case was that the callback was being called *after* the 
 Excel export does its ScrubHTML bit, so HTML gets through.  I had to alter 
 my callback so that it checked if the request for a Results page.
 
 This looks like a similar issue.  Are you using any callbacks or extensions 
 which change how the priorities are displayed in your web pages?  If you 
 are, that's probably the cause.
 
 Yes, I use http://search.cpan.org/dist/RT-Extension-PriorityAsString/ 
 extension.

Aha!  The issue here is not a bug in RT 4.x at all, but merely a plugin which 
hasn't been updated for RT 4.

What you need to do is modify the callback in that extension 
(html/Callbacks/PriorityAsString/Elements/RT__Ticket/ColumnMap/Once) so that it 
doesn't do all that snazzy html when the request is for Results.tsv.  Something 
like this might work [WARNING:  Untested code!]:

%ARGS
$COLUMN_MAP = {}
/%ARGS
%INIT
my $printer = sub {
my ($class, $string) = @_;
return '' unless defined $string  length $string;

my $request_path = $HTML::Mason::Commands::r-path_info;

if ($request_path =~ /Results\.tsv/) {
return \$string;
}

my $escaped = $m-interp-apply_escapes($string, 'h');
my $loc_escaped = $m-interp-apply_escapes(loc($string), 'h');
return \( qq{span class=ticket-info-$class-}. lc($escaped) 
.qq{$loc_escaped/span} );

};
foreach my $field (qw(Priority InitialPriority FinalPriority)) {
$COLUMN_MAP-{ $field .'Number' } ||= $COLUMN_MAP-{ $field };

my $class = lc($field);
$class =~ s/(?=.)(?=priority)/-/;

my $method = $field .'AsString';

$COLUMN_MAP-{ $field }{'value'} = sub {
return $printer-( $class, $_[0]-$method() );
};
}
return;
/%INIT

--
 The Wellcome Trust Sanger Institute is operated by Genome Research
 Limited, a charity registered in England with number 1021457 and a
 company registered in England with number 2742969, whose registered
 office is 215 Euston Road, London, NW1 2BE.


Re: [rt-users] RT 4 and IE8 : text overlap

2012-04-11 Thread Thomas Sibley
On 04/11/2012 04:25 AM, L B wrote:
  I found a bug in the template with IE8, see attached. Not sure if
 it's known and how to fix it. It works in Chrome.

The zebra striping of transactions looks off there.  Are you filtering
the history in any way?

Please send the HTML source of the page you took a screenshot of.  Is it
only happening for a single ticket or many tickets?


Re: [rt-users] RT 4 and IE8 : text overlap

2012-04-11 Thread L B
Actually I can't find again this ticket :-)

I'll update this thread if I stumble upon another weird display like this one.

-- 
L.B.


Re: [rt-users] RT 4.0.5 bug in Excel export

2012-04-11 Thread L B
On Wed, Apr 11, 2012 at 2:35 PM, Tim Cutts t...@sanger.ac.uk wrote:

 On 11 Apr 2012, at 10:25, L B wrote:


 I saw a similar thing when using Status with a CustomStatus callback which 
 colours my statuses (as in the example in the Wiki).

 The problem in that case was that the callback was being called *after* the 
 Excel export does its ScrubHTML bit, so HTML gets through.  I had to alter 
 my callback so that it checked if the request for a Results page.

 This looks like a similar issue.  Are you using any callbacks or extensions 
 which change how the priorities are displayed in your web pages?  If you 
 are, that's probably the cause.

 Yes, I use http://search.cpan.org/dist/RT-Extension-PriorityAsString/ 
 extension.

 Aha!  The issue here is not a bug in RT 4.x at all, but merely a plugin which 
 hasn't been updated for RT 4.


Thanks Tim for the investigation.

Hello Ruslan,

Do you plan to upgrade your extension or should I try this hack?

Thanks!
-- 
L.B.


Re: [rt-users] Editing /opt/rt4/share/html/Ticket/Elements/ShowTransactionAttachments to show HTML in display ticket body breaks RT interface.

2012-04-11 Thread Kevin Falcone
On Wed, Apr 11, 2012 at 10:17:50AM +0700, Luong Bui Duc wrote:
 I'm trying to set RT so it shows the HTML tables/hyperlinks directly in
 Display ticket page. My RT_SiteConfig.pm includes PreferRichText 
 TrustHTMLAttachments 1, but that only seems to work when user downloads
 ticket as attachment. I edited some code in this file:
 
 /opt/rt4/share/html/Ticket/Elements/ShowTransactionAttachments
 
 uncommented these 2 lines:
 
 Line 209: #$content = $m-comp( '/Elements/ScrubHTML', Content = $content
 );
 Line 230: #$content = $m-comp( '/Elements/ScrubHTML', Content = $content
 );
 
 This seems to do the trick, but interface of RT has changed too, now
 buttons are underlined and labels are in blue color as hyperlinks.
 
 Please let me know what is the proper way to achieve this without breaking
 RT?

You've now opened yourself up to a ton of attack vectors by removing
the scrubbing.  PreferRichText is the correct way to do what you want,
if you need to allow certain pieces of HTML through that are currently
scrubbed, you can cleanly add to the ScrubHTML method in Web.pm using
the standard override techniques.

-kevin


pgpqfHCBQiIuh.pgp
Description: PGP signature


Re: [rt-users] Ldap groups and queues permissions

2012-04-11 Thread Kevin Falcone
On Wed, Apr 11, 2012 at 11:31:59AM +0100, Cristo Bolaños Trujillo wrote:
Hello,
I'm using request tracker at work (succesfully!!) but got some problems 
 when tried to manage
queues permission using groups.
I've googled about it, read documentation on wiki, tried request tracker 
 web interface and
direct sql database changes taking as example already working queues, but 
 I can't get any
success.
Scenario:
- I create a group on LDAP and request tracker.
- I create a user on LDAP and request tracker.
- I assign this user to group on LDAP and request tracker.
- I assign every role on group to a queue.
User can login to request tracker, get limited privileges, but user can't 
 see queue: it
doesn't appear on the select next to New ticket.
I tried restarting apache, memcached, closing user web session and 
 restarting, but didn't get
any success.
*May be I've missed any step?

Seeing the Queue is controlled by SeeQueue and you'll also need
CreateTicket there.  Is the user Privileged?

-kevin


pgpt4z3PQ6Nym.pgp
Description: PGP signature


Re: [rt-users] RT 4.0.5 bug in Excel export

2012-04-11 Thread Kevin Falcone
On Wed, Apr 11, 2012 at 04:03:57PM +0200, L B wrote:
 On Wed, Apr 11, 2012 at 2:35 PM, Tim Cutts t...@sanger.ac.uk wrote:
 
  On 11 Apr 2012, at 10:25, L B wrote:
 
 
  I saw a similar thing when using Status with a CustomStatus callback 
  which colours my statuses (as in the example in the Wiki).
 
  The problem in that case was that the callback was being called *after* 
  the Excel export does its ScrubHTML bit, so HTML gets through.  I had to 
  alter my callback so that it checked if the request for a Results page.
 
  This looks like a similar issue.  Are you using any callbacks or 
  extensions which change how the priorities are displayed in your web 
  pages?  If you are, that's probably the cause.
 
  Yes, I use http://search.cpan.org/dist/RT-Extension-PriorityAsString/ 
  extension.
 
  Aha!  The issue here is not a bug in RT 4.x at all, but merely a plugin 
  which hasn't been updated for RT 4.
 
 
 Thanks Tim for the investigation.
 
 Hello Ruslan,
 
 Do you plan to upgrade your extension or should I try this hack?

Please don't CC developers directly, lots of us work on the
extensions.  It would be great if Tim filed his patch in the appropriate
rt.cpan.org queue.

-kevin


pgpvLBSFApwek.pgp
Description: PGP signature


Re: [rt-users] RT 4.0.5 bug in Excel export

2012-04-11 Thread Tim Cutts

On 11 Apr 2012, at 15:50, Kevin Falcone wrote:

 Please don't CC developers directly, lots of us work on the
 extensions.  It would be great if Tim filed his patch in the appropriate
 rt.cpan.org queue.

I wasn't brave enough to do that.  It's not an extension I use - I wrote that 
patched version direct in my email with code pasted from the CPAN code browser, 
so it really hasn't be tested at all.   The ColumnMap examples in the Wiki have 
the same bug.  Given that all ColumnMap callbacks that worked in RT 3.8 will 
be affected by this, it could be considered a regression in 4.0 I suppose; the 
fundamental cause is that the callback happens in 
share/html/Elements/ColumnMap, which is called by 
share/html/Search/Results.tsv.  Unfortunately, that callback happens *after* 
Results.tsv has cbballed the ScrubHTML code.

There might be more satisfactory and general solutions that could be 
implemented in the Results.tsv mason page.  Rather simplistically, it could 
just run ScrubHTML across everything that comes out of the ColumnMap.

Tim

--
 The Wellcome Trust Sanger Institute is operated by Genome Research
 Limited, a charity registered in England with number 1021457 and a
 company registered in England with number 2742969, whose registered
 office is 215 Euston Road, London, NW1 2BE.


Re: [rt-users] RT 4.0.5 bug in Excel export

2012-04-11 Thread Kevin Falcone
On Wed, Apr 11, 2012 at 04:35:25PM +0100, Tim Cutts wrote:
 
 On 11 Apr 2012, at 15:50, Kevin Falcone wrote:
 
  Please don't CC developers directly, lots of us work on the
  extensions.  It would be great if Tim filed his patch in the appropriate
  rt.cpan.org queue.
 
 I wasn't brave enough to do that. It's not an extension I use - I
 wrote that patched version direct in my email with code pasted from
 the CPAN code browser, so it really hasn't be tested at all. The
 ColumnMap examples in the Wiki have the same bug. Given that all
 ColumnMap callbacks that worked in RT 3.8 will be affected by this, it
 could be considered a regression in 4.0 I suppose; the fundamental
 cause is that the callback happens in share/html/Elements/ColumnMap,
 which is called by share/html/Search/Results.tsv. Unfortunately, that
 callback happens *after* Results.tsv has cbballed the ScrubHTML code.

 
 There might be more satisfactory and general solutions that could be
 implemented in the Results.tsv mason page. Rather simplistically, it
 could just run ScrubHTML across everything that comes out of the
 ColumnMap.

Yep, but it wants a bug somewhere (in RT for the possible regression)
or in the module pointing out the problem.  Possibly both, with
pointers between them.

I appreciate you digging into it and checking it out.

-kevin


pgpO8oG7PC7tT.pgp
Description: PGP signature


[rt-users] RT Asset Tracker - unique name field

2012-04-11 Thread Darren Hildebrand

Hello,

I'm looking at using RT AssetTracker module for tracking our hardware 
and software licenses.  It does exactly what I'd like for hardware, but 
I'd also like to track software licenses.  The problem that I'm running 
up against is that each asset name field must be unique.  For example, 
if I'm tracking Windows licenses, I'd like to be able to have 20 assets 
called something like Windows 7 Professional (64-bit) with separate 
Asset IDs and product keys, and then I'd link them to the workstations 
that they run on.  Is there any way to accomplish something like this?  
If not, how do people generally go about tracking software licenses with 
the RT Asset Tracker?


Please let me know if I'm approaching this from the wrong angle 
completely - I'm open to suggestions.  Thanks!


Darren


Re: [rt-users] RT Asset Tracker - unique name field

2012-04-11 Thread Jay Ashworth
- Original Message -
 From: Darren Hildebrand darren.hildebr...@opusvfx.com

 I'm looking at using RT AssetTracker module for tracking our hardware
 and software licenses. It does exactly what I'd like for hardware, but
 I'd also like to track software licenses. The problem that I'm running
 up against is that each asset name field must be unique. For example,
 if I'm tracking Windows licenses, I'd like to be able to have 20 assets
 called something like Windows 7 Professional (64-bit) with separate
 Asset IDs and product keys, and then I'd link them to the workstations
 that they run on. Is there any way to accomplish something like this?
 If not, how do people generally go about tracking software licenses
 with the RT Asset Tracker?

I would use that as a description, and use the license key itself -- or 
some unique component thereof, as the name.

You're hitting an analog of the serial numbered inventory problem.

Cheers,
-- jra
-- 
Jay R. Ashworth  Baylink   j...@baylink.com
Designer The Things I Think   RFC 2100
Ashworth  Associates http://baylink.pitas.com 2000 Land Rover DII
St Petersburg FL USA  http://photo.imageinc.us +1 727 647 1274


Re: [rt-users] Ldap groups and queues permissions

2012-04-11 Thread Cristo Bolaños Trujillo
Hello,


 Seeing the Queue is controlled by SeeQueue and you'll also need
 CreateTicket there.  Is the user Privileged?


Yup, it's right.

All problem come from cachedgroupmembers table: it looks there was a record
for that user.

I manually created a record and it works :)

Thanks a lot for your help.


 -kevin



Re: [rt-users] Ldap groups and queues permissions

2012-04-11 Thread Thomas Sibley
Please keep replies on the list.

On 04/11/2012 01:43 PM, Cristo Bolaños Trujillo wrote:
 This is interesting: I created user on RT user admin page, but didn't
 see any change on user permissing.

Take note of the checkbox Let this user be granted rights (Privileged)
which turns a user Privileged or not (Unprivileged).

 After sometime (I don't know really how many and when), user get right
 permission.

Permissions come from RT's internal system groups, ticket/queue roles,
and your own custom user groups.  You can grant rights to these globally
or on a specific queue/article/custom field level.

 It looks like cachedgroupmembers table get updated periodically, so, is
 there any way to force it to refresh immediatelly?

No, it doesn't get updated periodically.  It gets updated immediately.
There's no refresh.  Futzing with the database is the really wrong way
to go about what you want and will almost certainly lead to you breaking RT.


Re: [rt-users] RT Asset Tracker - unique name field

2012-04-11 Thread Darren Hildebrand
Thanks, but my problem with that approach is that records of a specific 
software license can disappear along with a computer.  Since there are 
times when I'd be moving licenses from one computer to another, I'd 
prefer for a software license to be a separate entity that can be 
unlinked from one computer and linked to another, but it'll always exist 
unless it's intentionally removed.


It sounds like I'm stuck with using a unique name, so I'm thinking that 
I'll probably append the name with part of the product key or something.


Thanks for the suggestions!

Darren

On 12-04-11 11:52 AM, Paul Muther wrote:

Hello. What we have been doing is track the software as custom fields attached 
to hardware records. The custom fields have values for versions of office apps 
etc.

PM


On Apr 11, 2012, at 9:45, Darren Hildebranddarren.hildebr...@opusvfx.com  
wrote:


Hello,

I'm looking at using RT AssetTracker module for tracking our hardware and software 
licenses.  It does exactly what I'd like for hardware, but I'd also like to track 
software licenses.  The problem that I'm running up against is that each asset name field 
must be unique.  For example, if I'm tracking Windows licenses, I'd like to be able to 
have 20 assets called something like Windows 7 Professional (64-bit) with 
separate Asset IDs and product keys, and then I'd link them to the workstations that they 
run on.  Is there any way to accomplish something like this?  If not, how do people 
generally go about tracking software licenses with the RT Asset Tracker?

Please let me know if I'm approaching this from the wrong angle completely - 
I'm open to suggestions.  Thanks!

Darren


Re: [rt-users] number of displayed rows in saved search

2012-04-11 Thread Gašper Zupančič
Not even one?

From: rt-users-boun...@lists.bestpractical.com 
[mailto:rt-users-boun...@lists.bestpractical.com] On Behalf Of Gašper Zupančič
Sent: Friday, April 06, 2012 10:21 AM
To: rt-users@lists.bestpractical.com
Subject: [rt-users] number of displayed rows in saved search

Dear RT,

i have a problem with dashboard showing only 50 rows of tickets per page, 
regardles if i set it in saved search to unlimited. There isn't even an option 
to show next page. Did i miss something somewhere in the settings?



Gašper Zupančič
Skrbnik aplikacij
TSmedia, d.o.o., Cigaletova ulica 15, SI-1000 Ljubljana
T: +386 1 473 00 35, F: +386 1 473 00 16, M: +386 31 347 698

[cid:image001.jpg@01CD182B.D5652B50]http://www.tsmedia.si/
Pravni pogoji / Legal disclaimerhttp://www.tsmedia.si/Disclaimer_TSmedia.aspx

inline: image001.jpg

[rt-users] sending an email to owner when ticket is nearly due

2012-04-11 Thread Florin Andrei

Using RT-4.0.5 on Linux.

What is the best way to configure RT to automatically send an email to 
the owner of a ticket when the ticket is nearly due? Let's say, 1 day 
before the due date.


I've seen this page...

http://requesttracker.wikia.com/wiki/Reminders

...but it's for reminders. I'd like to just look at the existing tickets 
and send the notifications when they're close to due date.


--
Florin Andrei
http://florin.myip.org/


Re: [rt-users] RT 4.0.5 bug in Excel export

2012-04-11 Thread Christian Loos
Am 11.04.2012 17:35, schrieb Tim Cutts:
 There might be more satisfactory and general solutions that could be 
 implemented in the Results.tsv mason page.  Rather simplistically, it could 
 just run ScrubHTML across everything that comes out of the ColumnMap.

Long time ago I send an patch for this but sadly it wasn't accepted
(Patch 2/2):
http://article.gmane.org/gmane.comp.bug-tracking.request-tracker.devel/6244

-Chris


Re: [rt-users] RT 4.0.5 bug in Excel export

2012-04-11 Thread Kevin Falcone
On Wed, Apr 11, 2012 at 11:39:00PM +0200, Christian Loos wrote:
 Am 11.04.2012 17:35, schrieb Tim Cutts:
  There might be more satisfactory and general solutions that could be 
  implemented in the Results.tsv mason page.  Rather simplistically, it could 
  just run ScrubHTML across everything that comes out of the ColumnMap.
 
 Long time ago I send an patch for this but sadly it wasn't accepted
 (Patch 2/2):
 http://article.gmane.org/gmane.comp.bug-tracking.request-tracker.devel/6244

I don't think you replied to my reply:
http://article.gmane.org/gmane.comp.bug-tracking.request-tracker.devel/6256
or filed a bug with an updated patch with a commit message that
explained the problem.

-kevin


pgpY4z2oc2H6q.pgp
Description: PGP signature


Re: [rt-users] RT 4.0.5 smrsh and EX_TEMPFAIL

2012-04-11 Thread UnixMan

I found the issue. I forgot that this system uses https and so I changed the
/etc/aliases http to https and all is now working.



UnixMan wrote:
 
 I have scoured the web and cannot find a satisfying answer to mail not
 working on RT 4.0.5. 
 
 At this point the mail is in the mailq. 
 
 All the mail queues in  /etc/aliases do the same thing. I copied the
 /etc/aliases from RT 3.8.8 to RT 4.0.5, does anyone know if they are
 different when using smrsh ? 
 
 When I test it on the server on the command line it all works, just mail
 coming externally is the issue. 
 
 Any and all help is surely appreciated. 
 
 Thanks, 
 Scott 
 
 

-- 
View this message in context: 
http://old.nabble.com/RT-4.0.5-smrsh-and-EX_TEMPFAIL-tp33544914p33671910.html
Sent from the Request Tracker - User mailing list archive at Nabble.com.



[rt-users] RT 4.0.5 : rt-email-dashboards cron not working

2012-04-11 Thread UnixMan

Ever since we upgraded from RT 3.8.8 to RT 4.0.5 our dashboard cron hasn't
been sending out emails. I checked the logs but nothing to note there other
than it says it emailed them out.

I ran a test email on the command line and the mail went through, NTF.

Any and all help is always appreciated,
Thanks,
Scott
-- 
View this message in context: 
http://old.nabble.com/RT-4.0.5-%3A-rt-email-dashboards-cron-not-working-tp33671941p33671941.html
Sent from the Request Tracker - User mailing list archive at Nabble.com.



Re: [rt-users] RT 4.0.5 : rt-email-dashboards cron not working

2012-04-11 Thread Kevin Falcone
On Wed, Apr 11, 2012 at 02:58:21PM -0700, UnixMan wrote:
 Ever since we upgraded from RT 3.8.8 to RT 4.0.5 our dashboard cron hasn't
 been sending out emails. I checked the logs but nothing to note there other
 than it says it emailed them out.
 
 I ran a test email on the command line and the mail went through, NTF.

If you read the documentation for the dashboard mailer, there are two
flags you can use for debugging.

-kevin


pgpwISWPLROwc.pgp
Description: PGP signature


Re: [rt-users] RT Extension LDAPImport Using LDAPS?

2012-04-11 Thread Scott Pestana

Hi,
It looks like the issue I have with those extra [critical] 
messages may be resolved by a newer version that Kevin has released as a 
dev release.


Without modifying my original configuration the release candidate 
from March 2012 reports only the [info] output.


-Scott



On 4/9/2012 4:58 PM, Thomas Sibley wrote:

On 04/09/2012 04:50 PM, Scott Pestana wrote:

[Mon Apr  9 19:51:49 2012] [critical]:
RT::Authen::ExternalAuth::LDAP::CanonicalizeUserInfo : Search for
((|(objectClass=posixAccount)(objectClass=account))(mail=userem...@linguamatics.com))
failed:  LDAP_NO_SUCH_OBJECT 32
(/opt/rt4/local/plugins/RT-Authen-ExternalAuth/lib/RT/Authen/ExternalAuth/LDAP.pm:232)

[Mon Apr  9 19:51:49 2012] [critical]:
RT::Authen::ExternalAuth::LDAP::CanonicalizeUserInfo : Search for
((|(objectClass=posixAccount)(objectClass=account))(uid=USERID))
failed:  LDAP_NO_SUCH_OBJECT 32
(/opt/rt4/local/plugins/RT-Authen-ExternalAuth/lib/RT/Authen/ExternalAuth/LDAP.pm:232)

You'll note these errors are from RT-Authen-ExternalAuth, not
RT-Extension-LDAPImport.  Please show us the config for ExternalAuth.


 For each user we get the above two critical errors, and the below
info message (which I don't mind aside from the Disabled part):

Those critical errors are passed along from your LDAP server.


[Mon Apr  9 19:51:49 2012] [info]:
RT::Authen::ExternalAuth::CanonicalizeUserInfo returning Disabled: ,
EmailAddress: userem...@linguamatics.com, ExternalAuthId: USERID, Gecos:
USERFULLNAME, Name: USERID, Privileged: 1, RealName: USERFULLNAME
(/opt/rt4/local/plugins/RT-Authen-ExternalAuth/lib/RT/Authen/ExternalAuth.pm:651)

This is just an informational message.  Disabled: is blank, so that's fine.


 When I inspected the MySQL tables that were created, I found that
all the users appeared to be created as I wanted.  I am having trouble
with the Web view at the moment, so I need to verify them through that
view as well.

This is probably because you're only looking at privileged users in the
admin interface and LDAPImport creates unprivileged users.  You can
search for them using the form on the admin page.

Thomas



--
N. Scott Pestana
IT Infrastructure
Linguamatics
275 Grove Street, Suite 2-400
Newton, MA 02466

Tel: +1-774-571-7135

US Tel: +1-617-674-3256
UK Tel: 011-44-1223-421360
UK Fax: 011-44-1223-421361
Web: www.linguamatics.com



[rt-users] Can 'Username' be Removed as a Required Field From the User Creation Form?

2012-04-11 Thread Timothy Tate
I got my first install of RT up and going today and I'm very excited 
about getting to know it better!


I'm curious if it would be possible to prevent the 'Username' field of 
the User Creation form from being required? I would prefer to reference 
each user account by the 'Real Name' only when filling in the 
'Requestor' field on a new ticket. This would be useful for users that 
have no need to login to RT, such as a user account that is created for 
a company I support.


I've searched the Wiki and Google for any help with this, but so far 
haven't found any information. I apologize if I've overlooked a source 
of information about this topic and will gladly take a look at it if 
anyone knows of such a source.


I'm using RT 4.0.5 on CentOS 6, which is running Apache.

Thanks in advance for any help!
Sincerely,
Timothy