Re: [rt-users] Trouble upgrading to 3.8.1

2008-10-09 Thread Joop
Kenneth Crocker wrote:
 To all,


   The regular guy who has done our installs before is no longer 
 available, so I ended up with this little task. In trying to install 
 3.8.1, I ran into a couple problems. We do not use the default /opt/rt 
 directory, but a different one. I had instructions to run a 
 configuration module that consisted of:

 ./configure \
  --prefix=//rt/rt-3.8.1 \
  --with-mod_perl=yes \
  --with-rt-group=rt \
  --with-bin-owner=rt \
  --with-libs-owner=rt \
  --with-libs-group=rt \
  --with-db-type=Oracle \
  --with-db-host= \
  --with-db-dba= \
  --with-db-database= \
  --with-db-rt-user= \
  --with-db-rt-pass= \
  --with-web-user=rt \
  --with-web-group=rt

   where '' is really something I can't print. My concern was if 
 something was missing. I got the error message:

 checking for a BSD-compatible install... ./install-sh -c
 checking for gawk... no
 checking for mawk... no
 checking for nawk... nawk
 checking for perl... /usr/bin/perl
 checking for chosen layout... relative
 checking for gcc... no
 checking for cc... no
 checking for cl.exe... no
 configure: error: no acceptable C compiler found in $PATH
 See `config.log' for more details.

   I went ahead and tried to run make testdeps and I got these results:
   

   I don't know where this stuff is or why it's missing. Doesn't 
 SearchBuilder come with the installation? If so, why can't it find the 
 latest version? I really do NOT understand this. Can I get some guidence 
 here? Thanks.
make testdeps just does that it test for dependancies and prints MISSING 
if it finds perl modules which are not up to date.
Running 'make fixdeps'  takes care of updating the required modules, BUT 
then you'll need a properly configured CPAN and the needed gcc and 
assorted utils.

Please supply your OS as the way to get the required utils varies with 
the Linux distribution.

Just ask if you need help, I have installed RT dozens of times on both 
Ubuntu and Centos almost always using Oracle as a backend.

Joop

___
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] Adding CC / BCC to Ticket Reply causes 533 LIST error from sendmail

2008-10-09 Thread Paul Broadwith
There is a HUGE warning in RT_Config.pm that you shouldn't edit it but
instead copy sections to the RT_SiteConfig.pm.

I'm still unsure of even what variable or section I should be editing.
Can you give me some pointers?

Kind regards,

Paul Broadwith (MBCS)
Blue Ivy Ltd - Microsoft Small Business Specialist, UK Partner Qualified
for 2008


Tel.: 01955 698203
Windows Messenger: [EMAIL PROTECTED]
Web: http://www.blueivy.co.uk



-Original Message-
From: Jesse Vincent [mailto:[EMAIL PROTECTED] 
Sent: 08 October 2008 21:49
To: Paul Broadwith
Cc: RT-Users Users
Subject: Re: [rt-users] Adding CC / BCC to Ticket Reply causes 533 LIST
error from sendmail

[please keep rt-users CCed]

On Oct 8, 2008, at 4:29 PM, Paul Broadwith wrote:

 Hi Jesse,

 Thanks for emailing me.

 Can you be more specific? I have been through the RT_SiteConfig.pm  
 about
 a dozen times today to see if I can figure out where it is and I am  
 none
 the wiser. I have it set to 'sendmailpipe' as per the default.


Try RT_Config.pm, not RT_SiteConfig.pm.



 ===
 Set($MailCommand , 'sendmailpipe');
 Set($SendmailArguments , '-oi -t -ODeliveryMode=b -OErrorMode=m
 -f[EMAIL PROTECTED]');
 Set($SendmailBounceArguments , '-f [EMAIL PROTECTED]');
 Set($SendmailPath , /usr/sbin/sendmail);
 ===

 Mail does go out and in, it just doesn't when CC or BCC addresses are
 added ...

 Kind regards,

 Paul Broadwith (MBCS)
 Blue Ivy Ltd - Microsoft Small Business Specialist, UK Partner  
 Qualified
 for 2008


 Tel.: 01955 698203
 Windows Messenger: [EMAIL PROTECTED]
 Web: http://www.blueivy.co.uk



 -Original Message-
 From: Jesse Vincent [mailto:[EMAIL PROTECTED]
 Sent: 08 October 2008 20:00
 To: Paul Broadwith
 Cc: rt-users@lists.bestpractical.com
 Subject: Re: [rt-users] Adding CC / BCC to Ticket Reply causes 533  
 LIST
 error from sendmail




 On Wed, Oct 08, 2008 at 04:32:23PM +0100, Paul Broadwith wrote:
 If I click to Reply to a message in an RT Ticket and add either CC,
 BCC
 or both I get the following message immediately returned (obviously I
 change some names to protect the guilty - they are in uppercase):

 You've misconfigured RT. Have a look in the RT_Config.pm file. You  
 might
 want to look for 'Sendmail'

 -jesse


 ===
 Your message did not reach some or all of the intended recipients.

  Subject:[#51] SUBJECT TEXT
  Sent:   08/10/2008 16:28

 The following recipient(s) cannot be reached:

  553 List:; syntax illegal for recipient
 addresses@SERVER.DOMAIN.LOCAL on 08/10/2008 16:28
The format of the e-mail address is incorrect.  Check the
 address, look up the recipient in the Address Book, or contact the
 recipient directly to find out the correct address.
 SERVER.DOMAIN.LOCAL #5.1.3
 ===

 I was the Requestor which is why I assume I got the message back. I
 assume if another customer was the Requestor they would get the
 message
 back.

 The /var/log/maillog is:

 ===
 Oct  8 16:28:04 SERVER sendmail[11331]: m98FS4jI011331: from=apache,
 size=1272, class=-60, nrcpts=1,
 msgid=[EMAIL PROTECTED],
 [EMAIL PROTECTED]
 Oct  8 16:28:04 SERVER sendmail[11331]: m98FS4jI011331:
 m98FS4jJ011331:
 DSN: OtherRecipients of COMPANY Ticket #51:;... List:; syntax
 illegal
 for recipient addresses
 ===

 I don't have the experience with RT to have changed anything other
 than
 the config file when setting it up. Does anybody have any  
 suggestions?

 Kind regards,

 Paul Broadwith (MBCS)
 Blue Ivy Ltd - Microsoft Small Business Specialist, UK Partner
 Qualified
 for 2008


 Tel.: 01955 698203
 Windows Messenger: [EMAIL PROTECTED]
 Web: http://www.blueivy.co.uk



 -Original Message-
 From: [EMAIL PROTECTED]
 [mailto:[EMAIL PROTECTED] On Behalf Of  
 Gabriel
 Cadieux
 Sent: 08 October 2008 16:06
 To: Curtis Bruneau; rt-users@lists.bestpractical.com
 Subject: Re: [rt-users] reall odd apache2 crashes with blank pages

 ahh, i get you.

 indeed, the SSL functionality should work flawlessly now, but we
 weren't
 actually *using* it per se, it was just turned on by default. our RT
 implementation is internal only, and the mysql database is runs on  
 the
 same host as apache, so there's really no need for it.

 :)

 -gabe

 -Original Message-
 From: Curtis Bruneau [mailto:[EMAIL PROTECTED]
 Sent: Wednesday, October 08, 2008 10:03 AM
 To: Gabriel Cadieux; rt-users@lists.bestpractical.com
 Subject: Re: [rt-users] reall odd apache2 crashes with blank pages


 Understood, just saying you should still be able to use SSL without
 issues with the fixed driver.

 Gabriel Cadieux wrote:
 yes, i understand that, but you have to take into consideration the
 fact that someone also mentioned disabling SSL altogether slowed  
 their
 segfaults, and this is exactly what happened when i tried it as well.
 before i disabled SSL, i was getting several crashes per day,  
 around 8
 or so... constantly. this continued for almost a week. after  
 disabling
 it, it went steady for a couple 

Re: [rt-users] Action::EscalatePriority messing up my ticket history

2008-10-09 Thread Bernd Kuhlen -WetterOnline-

Hi,
that doesn't to the trick either I have to stick with EscalatePriority  
(for various reasons which are beyond the scope of this thread) an  
there these options are not available.
In fact I cannot find any Option there that gives me a hint it might  
help me out.


best regards,
Bernd

On 9 Oct 2008, at 12:38, Ham MI-ID, Torsten Brumm wrote:


Hi Bernd,
not sure for EscalatePriority Module, but for the  
RT::Action::LinearEscalate you can define to not mess um the history:


--from the modul:

  You should prefix options with LinearEscalate_ in the config:

  Set( $LinearEscalate_RecordTransaction, 1 );
  Set( $LinearEscalate_UpdateLastUpdated, 1 );

  From a shell you can use the following command:

  rt-crontool --search RT::Search::FromSQL --search-arg \
  (Status='new' OR Status='open' OR Status = 'stalled') \
  --action RT::Action::LinearEscalate \
  --action-arg RecordTransaction: 1

If i understand this correct, then set both to 0 will disable this.  
I think this module is doing more or less the same, but in a linear  
way.


Torsten


Kühne + Nagel (AG  Co.) KG, Geschäftsleitung: Hans-Georg Brinkmann  
(Vors.), Uwe Bielang (Stellv.), Bruno Mang, Dirk Blesius (Stellv.),  
Alfred Manke, Christian Marnetté (Stellv.),  Mark Reinhardt  
(Stellv.), Jens Wollesen, Rainer Wunn, Sitz: Bremen,  
Registergericht: Bremen, HRA 21928, USt-IdNr.: DE 812773878,  
Persönlich haftende Gesellschaft: Kühne  Nagel A.G., Sitz: Contern/ 
Luxemburg Geschäftsführender Verwaltungsrat: Klaus-Michael Kühne



-Ursprüngliche Nachricht-
Von: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] 
] Im Auftrag von Bernd Kuhlen -WetterOnline-

Gesendet: Donnerstag, 9. Oktober 2008 11:21
An: rt-users@lists.bestpractical.com
Betreff: [rt-users] Action::EscalatePriority messing up my ticket  
history


Hi everyone,

I've set up my rt-crontool like this:

0 1 * * * /usr/local/bin/rt-crontool --search RT::Search::FromSQL --  
search-arg (Status='new' OR Status='open' OR Status = 'stalled')  
-- action RT::Action::EscalatePriority /dev/null 2/dev/null


and it's working fine. But I don't want it to mess up my ticket  
history. I have tickets starting with a priority of 0 and ending  
with 100 in some weeks time and every night I get a new entry saying  
that the ticket priority has changed. These entry are informative if  
the priority has been manually changed but not if they just trace  
the linear priority escalation done by a cronjob. So after a couple  
of weeks I have numerous lines with a ticket-priority changed entry.

That's not nice.

I'm new to RT and couldn't find anything about this matter by google  
or in any wiki.


best regards,
Bernd

___
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




Mit freundlichen Grüßen
Best Regards

Bernd Kuhlen
Diplom-Meteorologe
Diplom-Informatiker (FH)
Leitung Systemadministration
___

WetterOnline
Meteorologische Dienstleistungen GmbH
Am Rheindorfer Ufer 2
D-53117 Bonn
Amtsgericht Bonn | HRB Nummer 008664
Geschäftsführer: Dr. Joachim Klaßen
Fon:   +49 (0) 228 55937-73
Fax:   +49 (0) 228 55937-80
Mobil: +49 (0) 177 8214319
E-Mail: [EMAIL PROTECTED]
Web: http://www.wetteronline-gmbh.de
___

___
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] Approval workflow problem

2008-10-09 Thread sunnavy
Hi Andro

try to move the line Depended-On-By: TOP out of the Content: ...  
ENDOFCONTENT block, e.g. move it above the Content: ... line.

This should fix the problem.

Good luck!

On Oct 9, 2008, at 4:18 PM, Andro Wei wrote:

 Hi all

 According to the book: RT Essentials page 94. It say : Once an  
 approval is rejected, its original ticket is immediately rejected,  
 and all of its other approvals are rejected as well.
 I test it in my RT system (version 3.8.1), but in fact RT does not  
 follow the rule mentioned above.
 When I rejected the approval, RT system just changed the approval  
 ticket' status to Reject,
 and the original ticket didn't change anything. Because the approval  
 ticket's status setted to Reject,
 the original ticket didn't depend on the approval, so the original  
 ticket displayed in the queue without approving.

 I think the action about Approval does not make sense.
 The original ticket should be rejected automatically.
 Anyone had the same problem?? And how did you solve it?
 Thanks!!


 ___
 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


best wishes
sunnavy





___
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] Trouble upgrading to 3.8.1

2008-10-09 Thread Stephen Turner
On Wed, 08 Oct 2008 17:46:36 -0400, Kenneth Crocker [EMAIL PROTECTED]  
wrote:


   where '' is really something I can't print.

It's not the 'F' word is it? ;)

As Phillip mentioned you need to install or have a gcc or cc compiler in  
your path when you do the install. What OS are you using? Most Unix   
Linux flavors come with a compiler. Is this a new machine or are you  
installing on a machine that RT has been installed on before?


   I went ahead and tried to run make testdeps and I got these results:

 /tools/bin/perl ./sbin/rt-test-dependencies --verbose --with-SQLite
 --with-fastcgi

RT has a lot of dependencies on various Perl modules found on CPAN. The  
'make fixdeps' step of the install will download and install them for you.  
You might have to do that multiple times until 'make testdeps' shows that  
there's nothing missing. You don;t need to supply any additional args to  
'make testdeps' and 'make fixdeps'.

Reading through the 'README' and 'README.Oracle' docs that come with the  
software should help you figure all this out.

Steve

-- 
Stephen Turner
Senior Programmer/Analyst - SAIS
MIT IST
___
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] Action::EscalatePriority messing up my ticket history

2008-10-09 Thread Ham MI-ID, Torsten Brumm
Hi Bernd,
not sure for EscalatePriority Module, but for the RT::Action::LinearEscalate 
you can define to not mess um the history:

--from the modul:

   You should prefix options with LinearEscalate_ in the config:

   Set( $LinearEscalate_RecordTransaction, 1 );
   Set( $LinearEscalate_UpdateLastUpdated, 1 );

   From a shell you can use the following command:

   rt-crontool --search RT::Search::FromSQL --search-arg \
   (Status='new' OR Status='open' OR Status = 'stalled') \
   --action RT::Action::LinearEscalate \
   --action-arg RecordTransaction: 1

If i understand this correct, then set both to 0 will disable this. I think 
this module is doing more or less the same, but in a linear way.

Torsten 


Kühne + Nagel (AG  Co.) KG, Geschäftsleitung: Hans-Georg Brinkmann (Vors.), 
Uwe Bielang (Stellv.), Bruno Mang, Dirk Blesius (Stellv.), Alfred Manke, 
Christian Marnetté (Stellv.),  Mark Reinhardt (Stellv.), Jens Wollesen, Rainer 
Wunn, Sitz: Bremen, Registergericht: Bremen, HRA 21928, USt-IdNr.: DE 
812773878, Persönlich haftende Gesellschaft: Kühne  Nagel A.G., Sitz: 
Contern/Luxemburg Geschäftsführender Verwaltungsrat: Klaus-Michael Kühne


-Ursprüngliche Nachricht-
Von: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Im Auftrag von Bernd Kuhlen 
-WetterOnline-
Gesendet: Donnerstag, 9. Oktober 2008 11:21
An: rt-users@lists.bestpractical.com
Betreff: [rt-users] Action::EscalatePriority messing up my ticket history

Hi everyone,

I've set up my rt-crontool like this:

0 1 * * * /usr/local/bin/rt-crontool --search RT::Search::FromSQL -- search-arg 
(Status='new' OR Status='open' OR Status = 'stalled') -- action 
RT::Action::EscalatePriority /dev/null 2/dev/null

and it's working fine. But I don't want it to mess up my ticket history. I have 
tickets starting with a priority of 0 and ending with 100 in some weeks time 
and every night I get a new entry saying that the ticket priority has changed. 
These entry are informative if the priority has been manually changed but not 
if they just trace the linear priority escalation done by a cronjob. So after a 
couple of weeks I have numerous lines with a ticket-priority changed entry.  
That's not nice.

I'm new to RT and couldn't find anything about this matter by google or in any 
wiki.

best regards,
Bernd

___
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] Action::EscalatePriority messing up my ticket history

2008-10-09 Thread Bernd Kuhlen -WetterOnline-

Dear Alex, Dear List,
thanks for your quick response. I should add that I'm using RT-3.8.1  
on FreeBSD6.3/amd64 (which I forgot in my first mail).


I did the following (which didn't quite help me):

mkdir -p Callbacks/MyCallbacks/Ticket/Elements/ShowHistory in my rt- 
root/local/html/Ticket directory. The whole directory Callbacks  
hadn't existed beforehand.

Into the file SkipTransaction I dumped the following:

%init
  $$skip = 1 if (($_SkipSystemMessages)  ($Transaction-Creator eq  
1));

/%init
%args
$Transaction = undef
$skip = undef
$_SkipSystemMessages = undef
/%args

Then in my Display.html I changed this block


 /Ticket/Elements/ShowHistory ,
 Ticket = $TicketObj,
 Tickets = $Tickets,
 Collapsed = $ARGS{'Collapsed'},
 ShowHeaders = $ARGS{'ShowHeaders'},
 Attachments = $attachments,
 AttachmentContent = $attachment_content,
 _SkipSystemMessages = !0- that's what I added
 

I must confess I don't have a clue what this code is doing I'm not a  
programmer. The only thing I know: my ticket history is still being  
messed up with priority-change entries.


I'm wondering if I could fix my problem by simply denying any existing  
rights for the user doing the cron job. Of course the Right  
ModifyTicket is needed but maybe there's some right for tracing  
changes in the history ?


best regards,
Bernd



On 9 Oct 2008, at 11:29, Alex Young wrote:


I set RT to hide some of the history using this:
http://wiki.bestpractical.com/view/HideTransactions

All I have done is set it to hide the history of the RT_System user  
and

the user I have setup to escalate the tickets. You can still see their
entries on the history page, just not in anoy of the other pages.


-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Bernd
Kuhlen -WetterOnline-
Sent: 09 October 2008 10:21
To: rt-users@lists.bestpractical.com
Subject: [rt-users] Action::EscalatePriority messing up my ticket
history

Hi everyone,

I've set up my rt-crontool like this:

0 1 * * * /usr/local/bin/rt-crontool --search RT::Search::FromSQL --
search-arg (Status='new' OR Status='open' OR Status = 'stalled') --
action RT::Action::EscalatePriority /dev/null 2/dev/null

and it's working fine. But I don't want it to mess up my ticket
history. I have tickets starting with a priority of 0 and ending with
100 in some weeks time and every night I get a new entry saying that
the ticket priority has changed. These entry are informative if the
priority has been manually changed but not if they just trace the
linear priority escalation done by a cronjob. So after a couple of
weeks I have numerous lines with a ticket-priority changed entry.
That's not nice.

I'm new to RT and couldn't find anything about this matter by google
or in any wiki.

best regards,
Bernd

___
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



Mit freundlichen Grüßen
Best Regards

Bernd Kuhlen
Diplom-Meteorologe
Diplom-Informatiker (FH)
Leitung Systemadministration
___

WetterOnline
Meteorologische Dienstleistungen GmbH
Am Rheindorfer Ufer 2
D-53117 Bonn
Amtsgericht Bonn | HRB Nummer 008664
Geschäftsführer: Dr. Joachim Klaßen
Fon:   +49 (0) 228 55937-73
Fax:   +49 (0) 228 55937-80
Mobil: +49 (0) 177 8214319
E-Mail: [EMAIL PROTECTED]
Web: http://www.wetteronline-gmbh.de
___

___
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] Action::EscalatePriority messing up my ticket history

2008-10-09 Thread Bernd Kuhlen -WetterOnline-

Hi Alex,
I think I know the core of my problem. The whole directory ./Callbacks/ 
MyCallbacks hasn't existed before so I just made a mkdir to have  
it in my directory-tree.
But the RT doesn't know about the existence of this directory (it's  
not configured anywhere). That's why it's not working out, I guess.


I have a file called ShowHistory in my rt-root/html/Ticket/ 
Elements/ShowHistory. I'm pretty sure somewhere within this file I  
have to do the changes
I dump it for you (in case you have the time, please feel free just to  
skip this mail if you're busy ..)


%perl
if ($ShowDisplayModes or $ShowTitle) {
my $title = $ShowTitle
? loc('History')
: 'nbsp;';

my $titleright;

if ($ShowDisplayModes) {
$titleright = '';

if ($ShowHeaders) {
$titleright .= qq{a href=$URIFile?id=} .
   $Ticket-id.qq{} .
   loc(Brief headers) .
   qq{/a mdash; };
$titleright .= q[span class=selected] . loc(Full  
headers) . /span;

}
else {
$titleright .= q[span class=selected] . loc(Brief  
headers) . /span mdash; ;

$titleright .= qq{a href=$URIFile?ShowHeaders=1;id=} .
   $Ticket-id.qq{} .
   loc(Full headers) .
   qq{/a};
}
}
/%perl
div class=history
 /Widgets/TitleBoxStart, title = $title, titleright_raw =  
$titleright 

% }

div id=ticket-history
%perl
my @attachments = @{$Attachments-ItemsArrayRef()};
my @attachment_content = @{$AttachmentContent-ItemsArrayRef()};

while ( my $Transaction = $Transactions-Next ) {
my $skip = 0;
$m-callback(
%ARGS,
Transaction   = $Transaction,
skip  = \$skip,
CallbackName  = 'SkipTransaction',
);
next if $skip;

$i++;

my @trans_attachments = grep { $_-TransactionId == $Transaction- 
Id } @attachments;


my $trans_content = {};
grep { ($_-TransactionId == $Transaction-Id )   
($trans_content-{$_-Id} = $_)  } @attachment_content;



my $IsLastTransaction = 0;
if ( $OldestFirst ) {
$IsLastTransaction = $Transactions-IsLast;
} else {
$IsLastTransaction = 1 if ( $i == 1 );
}
#Args is first because we're clobbering the Attachments parameter
$m-comp( 'ShowTransaction',
%ARGS,

  Ticket   = $Ticket,
  Transaction  = $Transaction,
  ShowHeaders  = $ShowHeaders,
  RowNum   = $i,
  Attachments  = [EMAIL PROTECTED],
  AttachmentContent= $trans_content,
  LastTransaction  = $IsLastTransaction
 );

# manually flush the content buffer after each txn, so the user sees
# some update
$m-flush_buffer();
}

/%perl
/div
% if ($ShowDisplayModes or $ShowTitle) {
 /Widgets/TitleBoxEnd 
% }
/div
%INIT
my $Transactions = new RT::Transactions($session{'CurrentUser'});
if ($Tickets) {
while (my $t = $Tickets-Next) {
$Transactions-LimitToTicket($t-id);
}
} else {
$Transactions = $Ticket-Transactions;
}

my $OldestFirst = RT-Config-Get( 'OldestTransactionsFirst',  
$session{'CurrentUser'} );

my $SortOrder = $OldestFirst? 'ASC': 'DESC';
$Transactions-OrderByCols( { FIELD = 'Created',
  ORDER = $SortOrder },
{ FIELD = 'id',
  ORDER = $SortOrder },
  );

my $i;
$Attachments ||=  $m-comp('/Ticket/Elements/FindAttachments', Ticket  
= $Ticket, Tickets = $Tickets || undef);
$AttachmentContent ||= $m-comp('/Ticket/Elements/ 
LoadTextAttachments', Ticket = $Ticket);


/%INIT
%ARGS
$URIFile = RT-Config-Get('WebPath')./Ticket/Display.html
$Ticket = undef
$Tickets = undef
$Attachments = undef
$AttachmentContent = undef
$ShowHeaders = undef
$ShowTitle = 1
$ShowDisplayModes = 1
$WarnUnsigned = undef
/%ARGS



On 9 Oct 2008, at 14:43, Bernd Kuhlen -WetterOnline- wrote:


thanks a lot.
I'll check this out.

On 9 Oct 2008, at 14:39, Alex Young wrote:


Here is a copy of my file
/opt/rt3/local/html/Callbacks/MyCallbacks/Ticket/Elements/ 
ShowHistory/SkipTransaction


%init
  $$skip = 1 if (($_SkipSystemMessages)  ($Transaction-Creator  
eq 1 | $Transaction-Creator eq 12));

/%init
%args
$Transaction = undef
$skip = undef
$_SkipSystemMessages = undef
/%args

Creator ID 1 is RT_System, which pops up when you send emails out  
and other systems.

Creator ID 12 is the linux/RT user which runs the escelate job.

All it is doing is seeing who created the transaction, and if its  
user number 1 or 12, it skips it.


You will need ot find out the user ID number for the user running  
the escelate job. You can od this by looking in the user list. The  
nuber to the left is the number you would want to put into the  
“Creator eq XX” bit of the code.


From: Bernd 

Re: [rt-users] Action::EscalatePriority messing up my ticket history

2008-10-09 Thread Alex Young
All I ever do is mkdir each directly that is needed by a script. I never
edit anything into the /opt/rt3/share/ folder. I always copy the
files I want to edit from there to /opt/rt3/local/

 

Check out Using the 'local' directory here:
http://wiki.bestpractical.com/view/CleanlyCustomizeRT

 

 

 

 

From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Bernd
Kuhlen -WetterOnline-
Sent: 09 October 2008 14:10
To: Bernd Kuhlen -WetterOnline-; rt-users@lists.bestpractical.com
Subject: Re: [rt-users] Action::EscalatePriority messing up my ticket
history

 

Hi Alex,

I think I know the core of my problem. The whole directory
./Callbacks/MyCallbacks hasn't existed before so I just made a
mkdir to have it in my directory-tree.

But the RT doesn't know about the existence of this directory (it's not
configured anywhere). That's why it's not working out, I guess.

 

I have a file called ShowHistory in my
rt-root/html/Ticket/Elements/ShowHistory. I'm pretty sure somewhere
within this file I have to do the changes

I dump it for you (in case you have the time, please feel free just to
skip this mail if you're busy ..)

 

%perl

if ($ShowDisplayModes or $ShowTitle) {

my $title = $ShowTitle

? loc('History')

: 'nbsp;';

 

my $titleright;

 

if ($ShowDisplayModes) {

$titleright = '';



if ($ShowHeaders) {

$titleright .= qq{a href=$URIFile?id=} .

   $Ticket-id.qq{} .

   loc(Brief headers) .  

   qq{/a mdash; };

$titleright .= q[span class=selected] . loc(Full
headers) . /span;

}

else {

$titleright .= q[span class=selected] . loc(Brief
headers) . /span mdash; ;

$titleright .= qq{a href=$URIFile?ShowHeaders=1;id=} .

   $Ticket-id.qq{} .

   loc(Full headers) .

   qq{/a};

}

}

/%perl

div class=history

 /Widgets/TitleBoxStart, title = $title, titleright_raw =
$titleright 

% }

   

div id=ticket-history

%perl

my @attachments = @{$Attachments-ItemsArrayRef()};

my @attachment_content = @{$AttachmentContent-ItemsArrayRef()};

 

while ( my $Transaction = $Transactions-Next ) {

my $skip = 0;

$m-callback(

%ARGS,   

Transaction   = $Transaction,

skip  = \$skip,

CallbackName  = 'SkipTransaction',

);

next if $skip;

 

$i++;

 

my @trans_attachments = grep { $_-TransactionId == $Transaction-Id
} @attachments;

 

my $trans_content = {};

grep { ($_-TransactionId == $Transaction-Id ) 
($trans_content-{$_-Id} = $_)  } @attachment_content;

 

 

my $IsLastTransaction = 0;

if ( $OldestFirst ) {

$IsLastTransaction = $Transactions-IsLast;

} else {

$IsLastTransaction = 1 if ( $i == 1 );

}

#Args is first because we're clobbering the Attachments parameter

$m-comp( 'ShowTransaction',

%ARGS,

 

  Ticket   = $Ticket,

  Transaction  = $Transaction,

  ShowHeaders  = $ShowHeaders,

  RowNum   = $i,

  Attachments  = [EMAIL PROTECTED],

  AttachmentContent= $trans_content,

  LastTransaction  = $IsLastTransaction

 );

   

# manually flush the content buffer after each txn, so the user sees

# some update

$m-flush_buffer();

}

 

/%perl

/div  

% if ($ShowDisplayModes or $ShowTitle) {

 /Widgets/TitleBoxEnd 

% }

/div

%INIT

my $Transactions = new RT::Transactions($session{'CurrentUser'});

if ($Tickets) {

while (my $t = $Tickets-Next) {

$Transactions-LimitToTicket($t-id);

}

} else {

$Transactions = $Ticket-Transactions;

}

 

my $OldestFirst = RT-Config-Get( 'OldestTransactionsFirst',
$session{'CurrentUser'} );

my $SortOrder = $OldestFirst? 'ASC': 'DESC';

$Transactions-OrderByCols( { FIELD = 'Created',

  ORDER = $SortOrder },

{ FIELD = 'id',

  ORDER = $SortOrder },

  );

 

my $i;

$Attachments ||=  $m-comp('/Ticket/Elements/FindAttachments', Ticket =
$Ticket, Tickets = $Tickets || undef);

$AttachmentContent ||= $m-comp('/Ticket/Elements/LoadTextAttachments',
Ticket = $Ticket);

 

/%INIT

%ARGS 

$URIFile = RT-Config-Get('WebPath')./Ticket/Display.html

$Ticket = undef

$Tickets = undef

$Attachments = undef

$AttachmentContent = undef

$ShowHeaders = undef

$ShowTitle = 1

$ShowDisplayModes = 1

$WarnUnsigned = undef

/%ARGS

 

 

 

On 9 Oct 2008, at 14:43, Bernd Kuhlen -WetterOnline- wrote:





thanks a lot. 

I'll check this out.

 

On 9 Oct 2008, at 14:39, Alex Young wrote:





Here is a copy of my file


Re: [rt-users] Adding CC / BCC to Ticket Reply causes 533 LIST error from sendmail

2008-10-09 Thread Joop
Paul Broadwith wrote:
 There is a HUGE warning in RT_Config.pm that you shouldn't edit it but
 instead copy sections to the RT_SiteConfig.pm.

 I'm still unsure of even what variable or section I should be editing.
 Can you give me some pointers?
I think Jesse is referring to the fact that using FriendlyNameFrom/To 
isn't supported when your mailagent is Sendmail.

I tried that a couple of weeks ago also and the result was that no email 
went out, thankfully it was on a test instance ;-)


Joop

___
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] scrip to setting due date back to unset

2008-10-09 Thread Violetta Wawryk
Hey,

My queustion is the following. I have a queue where the default for the 
due date is set to 7 days. I have different scrips that set the due date 
to either 1 or 14 if the subject contains certain key words.

As I understand RT, as soon as a ticket comes in the defaults in the 
basics will be set and if there are different matching scrips they 
change the wished values like due date.

So what do I have to do to unset the due date?

This is the part of the scrip I use to set it to 1 day:

my $duedate = RT::Date-new($RT::SystemUser);
   $duedate-Set(Format='unknown', Value='1 days');
   $self-TicketObj-SetDue($duedate-ISO);

Thanks for your help.

Violetta



-- 
 creating IT solutions
Violetta J. Wawryk   science + computing ag
IT-Service   Hagellocher Weg 73
phone +49 7071 9457 282  72070 Tuebingen, Germany
fax   +49 7071 9457 211  www.science-computing.de
-- 
Vorstand/Board of Management:
Dr. Bernd Finkbeiner, Dr. Florian Geyer,
Dr. Roland Niemeier, Dr. Arno Steitz, Dr. Ingrid Zech
Vorsitzender des Aufsichtsrats/
Chairman of the Supervisory Board:
Prof. Dr. Hanns Ruder
Sitz/Registered Office: Tuebingen
Registergericht/Registration Court: Stuttgart
Registernummer/Commercial Register No.: HRB 382196 


___
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] Action::EscalatePriority messing up my ticket history

2008-10-09 Thread Bernd Kuhlen -WetterOnline-
Hi everyone,

I've set up my rt-crontool like this:

0 1 * * * /usr/local/bin/rt-crontool --search RT::Search::FromSQL -- 
search-arg (Status='new' OR Status='open' OR Status = 'stalled') -- 
action RT::Action::EscalatePriority /dev/null 2/dev/null

and it's working fine. But I don't want it to mess up my ticket  
history. I have tickets starting with a priority of 0 and ending with  
100 in some weeks time and every night I get a new entry saying that  
the ticket priority has changed. These entry are informative if the  
priority has been manually changed but not if they just trace the  
linear priority escalation done by a cronjob. So after a couple of  
weeks I have numerous lines with a ticket-priority changed entry.  
That's not nice.

I'm new to RT and couldn't find anything about this matter by google  
or in any wiki.

best regards,
Bernd

___
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] Trouble upgrading to 3.8.1 (Kenneth Crocker)

2008-10-09 Thread Maurice
Hi Kenneth,

I wrote a howto on installing RT on a Debian box that might help.

http://rtvm.tehcorner.com/rt38/

[EMAIL PROTECTED] wrote:
 Send RT-Users mailing list submissions to
   rt-users@lists.bestpractical.com

 To subscribe or unsubscribe via the World Wide Web, visit
   http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
 or, via email, send a message with subject or body 'help' to
   [EMAIL PROTECTED]

 You can reach the person managing the list at
   [EMAIL PROTECTED]

 When replying, please edit your Subject line so it is more specific
 than Re: Contents of RT-Users digest...


 Today's Topics:

1. Trouble upgrading to 3.8.1 (Kenneth Crocker)
2. Re: RT 3.8.: Customize RT at a glance (Sean McCreadie)
3. Re: RT 3.8.: Customize RT at a glance (Sean McCreadie)


 --

 Message: 1
 Date: Wed, 08 Oct 2008 14:46:36 -0700
 From: Kenneth Crocker [EMAIL PROTECTED]
 Subject: [rt-users] Trouble upgrading to 3.8.1
 To: rt Users rt-users@lists.bestpractical.com
 Message-ID: [EMAIL PROTECTED]
 Content-Type: text/plain; charset=ISO-8859-1; format=flowed

 To all,


   The regular guy who has done our installs before is no longer 
 available, so I ended up with this little task. In trying to install 
 3.8.1, I ran into a couple problems. We do not use the default /opt/rt 
 directory, but a different one. I had instructions to run a 
 configuration module that consisted of:

 ./configure \
  --prefix=//rt/rt-3.8.1 \
  --with-mod_perl=yes \
  --with-rt-group=rt \
  --with-bin-owner=rt \
  --with-libs-owner=rt \
  --with-libs-group=rt \
  --with-db-type=Oracle \
  --with-db-host= \
  --with-db-dba= \
  --with-db-database= \
  --with-db-rt-user= \
  --with-db-rt-pass= \
  --with-web-user=rt \
  --with-web-group=rt

   where '' is really something I can't print. My concern was if 
 something was missing. I got the error message:

 checking for a BSD-compatible install... ./install-sh -c
 checking for gawk... no
 checking for mawk... no
 checking for nawk... nawk
 checking for perl... /usr/bin/perl
 checking for chosen layout... relative
 checking for gcc... no
 checking for cc... no
 checking for cl.exe... no
 configure: error: no acceptable C compiler found in $PATH
 See `config.log' for more details.

   I went ahead and tried to run make testdeps and I got these results:

 /tools/bin/perl ./sbin/rt-test-dependencies --verbose --with-SQLite 
 --with-fastcgi
 perl:
  =5.8.3(5.8.5)...found
 users:
  rt group (www)...MISSING
  bin owner (root)...found
  libs owner (root)...found
  libs group (bin)...found
  web owner (www)...MISSING
  web group (www)...MISSING
 CLI dependencies:
  Term::ReadKey...found
  Getopt::Long = 2.24...found
  HTTP::Request::Common...found
  Term::ReadLine...found
  Text::ParseWords...found
  LWP...found
 CORE dependencies:
  Class::ReturnValue = 0.40...found
  Text::Quoted = 2.02...found
  CSS::Squish = 0.06...MISSING
  Encode = 2.13...MISSING
  Encode version 2.13 required--this is only version 2.01
  Module::Versions::Report = 1.05...MISSING
  Module::Versions::Report version 1.05 required--this is 
 only version 1.03
  MIME::Entity = 5.425...MISSING
  MIME::Entity version 5.425 required--this is only 
 version 5.417
  DBI = 1.37...found
  Locale::Maketext::Lexicon = 0.32...found
  Devel::StackTrace = 1.19...MISSING
  Devel::StackTrace version 1.19 required--this is only 
 version 1.13
  Digest::base...found
  Time::ParseDate...found
  File::Temp = 0.18...MISSING
  File::Temp version 0.18 required--this is only version 
 0.16
  Locale::Maketext = 1.06...found
  Tree::Simple = 1.04...found
  Text::Template...found
  Scalar::Util...found
  HTML::Scrubber = 0.08...found
  File::Spec = 0.8...found
  Calendar::Simple...found
  DBIx::SearchBuilder = 1.54...MISSING
  DBIx::SearchBuilder version 1.54 required--this is only 
 version 1.49
  Mail::Mailer = 1.57...found
  File::ShareDir...MISSING
  Regexp::Common...found
  Digest::MD5 = 2.27...found
  HTML::Entities...found
  Cache::Simple::TimedExpiry...found
  File::Glob...found
  Locale::Maketext::Fuzzy...found
  Time::HiRes...found
  Text::Wrapper...found
  Log::Dispatch = 2.0...found
  UNIVERSAL::require...found
  Email::Address...MISSING
 DASHBOARDS dependencies:
  HTML::RewriteAttributes = 0.02...MISSING
  

[rt-users] General Question - Queue Management

2008-10-09 Thread Alan Cheng
Dear RT users,

I am wondering if there is a way to organize tickets in a queue.  For
example, we may have a queue called system administration.  But I
would like to sort tickets and put them into sub-categories like Email,
DNS, DHCP, LDAP, DB.

Is this possible?  Any suggestions or comments are very appreciated.

Thanks,

Alan
___
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] General Question - Queue Management

2008-10-09 Thread Jerrad Pierce
On Thu, Oct 9, 2008 at 12:06, Alan Cheng [EMAIL PROTECTED] wrote:
 Dear RT users,

 I am wondering if there is a way to organize tickets in a queue.  For
 example, we may have a queue called system administration.  But I
 would like to sort tickets and put them into sub-categories like Email,
 DNS, DHCP, LDAP, DB.
Yes. If you do not want to make more queues, try my RTx::Tags plugin
on CPAN. You can then tag messages in your sysadmin queue with
DNS, etc. and search for them...

-- 
Cambridge Energy Alliance: Save money  the planet
___
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] Corrupted attachment issue - RT 3.8.1

2008-10-09 Thread Timothy Butkiewicz

I am having the problem with corrupted attachments after upgrading to
3.8/3.8.1

I am using mysql 4.1.18

Here are my char_set variables:

mysql show variables like 'c%';
+--++
| Variable_name| Value  |
+--++
| character_set_client | latin1 |
| character_set_connection | latin1 |
| character_set_database   | utf8   |
| character_set_results| latin1 |
| character_set_server | utf8   |
| character_set_system | utf8   |
| character_sets_dir   | /usr/share/mysql/charsets/ |
| collation_connection | latin1_swedish_ci  |
| collation_database   | utf8_general_ci|
| collation_server | utf8_general_ci|
| concurrent_insert| ON |
| connect_timeout  | 5  |
+--++
12 rows in set (0.00 sec)


I have run 

perl etc/upgrade/schema.mysql-4.0-4.1.pl db user pass  sql.queries with
the output attached as sql.queries

I have then run

mysql -u root -p rt3  sql.queries
with the output of :

rt3.Groups.Instance has type VARCHAR however mapping is missing.
Use of uninitialized value in numeric gt () at
etc/upgrade/schema.mysql-4.0-4.1.pl line 310.
Use of uninitialized value in numeric gt () at
etc/upgrade/schema.mysql-4.0-4.1.pl line 310.
Use of uninitialized value in numeric gt () at
etc/upgrade/schema.mysql-4.0-4.1.pl line 310.
Use of uninitialized value in numeric gt () at
etc/upgrade/schema.mysql-4.0-4.1.pl line 310.
Use of uninitialized value in numeric gt () at
etc/upgrade/schema.mysql-4.0-4.1.pl line 310.



Thank you


sql.queries
Description: sql.queries
___
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] Corrupted attachment issue - RT 3.8.1

2008-10-09 Thread Timothy Butkiewicz
I am having the problem with corrupted attachments after upgrading to
3.8/3.8.1

I am using mysql 4.1.18

Here are my char_set variables:

mysql show variables like 'c%';
+--++
| Variable_name| Value  |
+--++
| character_set_client | latin1 |
| character_set_connection | latin1 |
| character_set_database   | utf8   |
| character_set_results| latin1 |
| character_set_server | utf8   |
| character_set_system | utf8   |
| character_sets_dir   | /usr/share/mysql/charsets/ |
| collation_connection | latin1_swedish_ci  |
| collation_database   | utf8_general_ci|
| collation_server | utf8_general_ci|
| concurrent_insert| ON |
| connect_timeout  | 5  |
+--++
12 rows in set (0.00 sec)


I have run 

perl etc/upgrade/schema.mysql-4.0-4.1.pl db user pass  sql.queries 
with the output attached as sql.queries

I have then run

mysql -u root -p rt3  sql.queries
with the output of :

rt3.Groups.Instance has type VARCHAR however mapping is missing.
Use of uninitialized value in numeric gt () at
etc/upgrade/schema.mysql-4.0-4.1.pl line 310.
Use of uninitialized value in numeric gt () at
etc/upgrade/schema.mysql-4.0-4.1.pl line 310.
Use of uninitialized value in numeric gt () at
etc/upgrade/schema.mysql-4.0-4.1.pl line 310.
Use of uninitialized value in numeric gt () at
etc/upgrade/schema.mysql-4.0-4.1.pl line 310.
Use of uninitialized value in numeric gt () at
etc/upgrade/schema.mysql-4.0-4.1.pl line 310.



Thank you


sql.queries
Description: sql.queries
___
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] General Question - Queue Management

2008-10-09 Thread Jerrad Pierce
 Sure - you can use a queue custom field for this.
Yes, and to clarify, that is what RTX::Tags has you do. It then
provides some helpful tools for interacting with that field.

In the near future I'll be adding an optional RT at a glance nodelet
for the tags, and may let users select the queues for which they
wish to display tag clouds.
-- 
Cambridge Energy Alliance: Save money  the planet
___
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] Trouble upgrading to 3.8.1

2008-10-09 Thread Kenneth Crocker
Stephen,


Very funny HA! No, it's not the F word. I didn't want to give out any 
company-specific directory names so I wouldn't get in trouble. This is 
an Upgrade from 3.6.4. on a Unix/Solaris machine and the DB is Oracle 10g.
I DID read the README and README.Oracle files and some of it made 
sense, some of it was Greek.
I guess I was just surprised that an install package would tell me I 
needed a later version of something I thought was already in the 
package. I don't understand why it would say it or even how the install 
package could be missing things that the 'testdeps' would find. In other 
words, my question is also, Why isn't the latest of everything included 
in the install package? But I think I understand now that the install 
package doesn't contain all the software. It contains the ability to 
check for the software and the 'fixdeps' will oad what is needed. That 
helps the understanding a bit.
Any clues as to why the C compiler is needed? Thanks.


Kenn
LBNL

On 10/9/2008 6:01 AM, Stephen Turner wrote:
 On Wed, 08 Oct 2008 17:46:36 -0400, Kenneth Crocker [EMAIL PROTECTED] 
 wrote:
 

 where '' is really something I can't print.
 
 It's not the 'F' word is it? ;)
 
 As Phillip mentioned you need to install or have a gcc or cc compiler in 
 your path when you do the install. What OS are you using? Most Unix  
 Linux flavors come with a compiler. Is this a new machine or are you 
 installing on a machine that RT has been installed on before?
 

 I went ahead and tried to run make testdeps and I got these results:

 /tools/bin/perl ./sbin/rt-test-dependencies --verbose --with-SQLite
 --with-fastcgi
 
 RT has a lot of dependencies on various Perl modules found on CPAN. The 
 'make fixdeps' step of the install will download and install them for 
 you. You might have to do that multiple times until 'make testdeps' 
 shows that there's nothing missing. You don;t need to supply any 
 additional args to 'make testdeps' and 'make fixdeps'.
 
 Reading through the 'README' and 'README.Oracle' docs that come with the 
 software should help you figure all this out.
 
 Steve
 

___
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] Trouble upgrading to 3.8.1

2008-10-09 Thread Kenneth Crocker
Joop,


Thank you very much. I'm sure with Stephen and you and Philip and 
others, I'll get thru this little drama (URG!). I'm such an ignoramous 
in this server world. I've been in this business 40 years (yes, I really 
DID wire collators and sorters) and most of it was spent in front of a 
dumb terminal. I think only Gene LeDuc on the list remembers what 
those are (he he, yes. I just 'outed' him as being as old as I am in 
this business). So, my experience with Unix and Perl and all of that 
server stuff is quite limited. I'm more of a project leader now. But 
with limited staff, I'm now back to rolling up my sleeves and trying to 
understand how all this works so I can do it. So, thanks for your help, 
really.
We are on a Solaris machine, Oracle 10g DB. I'm not sure why the 'C' 
compiler is necessaqry, as I am trying to install this upgrade ona 
machine we already installed 3.6.4 on.
Any help is greatly appreciated.


Kenn
LBNL

On 10/9/2008 12:07 AM, Joop wrote:
 Kenneth Crocker wrote:
 To all,


 The regular guy who has done our installs before is no longer 
 available, so I ended up with this little task. In trying to install 
 3.8.1, I ran into a couple problems. We do not use the default /opt/rt 
 directory, but a different one. I had instructions to run a 
 configuration module that consisted of:

 ./configure \
  --prefix=//rt/rt-3.8.1 \
  --with-mod_perl=yes \
  --with-rt-group=rt \
  --with-bin-owner=rt \
  --with-libs-owner=rt \
  --with-libs-group=rt \
  --with-db-type=Oracle \
  --with-db-host= \
  --with-db-dba= \
  --with-db-database= \
  --with-db-rt-user= \
  --with-db-rt-pass= \
  --with-web-user=rt \
  --with-web-group=rt

 where '' is really something I can't print. My concern was if 
 something was missing. I got the error message:

 checking for a BSD-compatible install... ./install-sh -c
 checking for gawk... no
 checking for mawk... no
 checking for nawk... nawk
 checking for perl... /usr/bin/perl
 checking for chosen layout... relative
 checking for gcc... no
 checking for cc... no
 checking for cl.exe... no
 configure: error: no acceptable C compiler found in $PATH
 See `config.log' for more details.

 I went ahead and tried to run make testdeps and I got these results:
   
 
 I don't know where this stuff is or why it's missing. Doesn't 
 SearchBuilder come with the installation? If so, why can't it find the 
 latest version? I really do NOT understand this. Can I get some 
 guidence here? Thanks.
 make testdeps just does that it test for dependancies and prints MISSING 
 if it finds perl modules which are not up to date.
 Running 'make fixdeps'  takes care of updating the required modules, BUT 
 then you'll need a properly configured CPAN and the needed gcc and 
 assorted utils.
 
 Please supply your OS as the way to get the required utils varies with 
 the Linux distribution.
 
 Just ask if you need help, I have installed RT dozens of times on both 
 Ubuntu and Centos almost always using Oracle as a backend.
 
 Joop
 
 

___
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] scrip to setting due date back to unset

2008-10-09 Thread Kenneth Crocker
Violetta,



If you have a scrip that modifies ticket data that is ALSO set by 
default RT code, you need to make the STAGE of the scrip in batch 
mode. That should do it. I've had that problem before and that fixed it.


Kenn
LBNL

On 10/9/2008 5:30 AM, Violetta Wawryk wrote:
 Hey,
 
 My queustion is the following. I have a queue where the default for the 
 due date is set to 7 days. I have different scrips that set the due date 
 to either 1 or 14 if the subject contains certain key words.
 
 As I understand RT, as soon as a ticket comes in the defaults in the 
 basics will be set and if there are different matching scrips they 
 change the wished values like due date.
 
 So what do I have to do to unset the due date?
 
 This is the part of the scrip I use to set it to 1 day:
 
 my $duedate = RT::Date-new($RT::SystemUser);
$duedate-Set(Format='unknown', Value='1 days');
$self-TicketObj-SetDue($duedate-ISO);
 
 Thanks for your help.
 
 Violetta
 
 
 

___
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] Trouble upgrading to 3.8.1 (Kenneth Crocker)

2008-10-09 Thread Kenneth Crocker
Maurice,


Thank You! I'll give it a look. At the level of knowledge that I have 
(or actually, haven't) I'm sure anything will help. Thanks again.


Kenn
LBNL

On 10/9/2008 9:17 AM, Maurice wrote:
 Hi Kenneth,
 
 I wrote a howto on installing RT on a Debian box that might help.
 
 http://rtvm.tehcorner.com/rt38/
 
 [EMAIL PROTECTED] wrote:
 Send RT-Users mailing list submissions to
  rt-users@lists.bestpractical.com

 To subscribe or unsubscribe via the World Wide Web, visit
  http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
 or, via email, send a message with subject or body 'help' to
  [EMAIL PROTECTED]

 You can reach the person managing the list at
  [EMAIL PROTECTED]

 When replying, please edit your Subject line so it is more specific
 than Re: Contents of RT-Users digest...


 Today's Topics:

1. Trouble upgrading to 3.8.1 (Kenneth Crocker)
2. Re: RT 3.8.: Customize RT at a glance (Sean McCreadie)
3. Re: RT 3.8.: Customize RT at a glance (Sean McCreadie)


 --

 Message: 1
 Date: Wed, 08 Oct 2008 14:46:36 -0700
 From: Kenneth Crocker [EMAIL PROTECTED]
 Subject: [rt-users] Trouble upgrading to 3.8.1
 To: rt Users rt-users@lists.bestpractical.com
 Message-ID: [EMAIL PROTECTED]
 Content-Type: text/plain; charset=ISO-8859-1; format=flowed

 To all,


  The regular guy who has done our installs before is no longer 
 available, so I ended up with this little task. In trying to install 
 3.8.1, I ran into a couple problems. We do not use the default /opt/rt 
 directory, but a different one. I had instructions to run a 
 configuration module that consisted of:

 ./configure \
  --prefix=//rt/rt-3.8.1 \
  --with-mod_perl=yes \
  --with-rt-group=rt \
  --with-bin-owner=rt \
  --with-libs-owner=rt \
  --with-libs-group=rt \
  --with-db-type=Oracle \
  --with-db-host= \
  --with-db-dba= \
  --with-db-database= \
  --with-db-rt-user= \
  --with-db-rt-pass= \
  --with-web-user=rt \
  --with-web-group=rt

  where '' is really something I can't print. My concern was if 
 something was missing. I got the error message:

 checking for a BSD-compatible install... ./install-sh -c
 checking for gawk... no
 checking for mawk... no
 checking for nawk... nawk
 checking for perl... /usr/bin/perl
 checking for chosen layout... relative
 checking for gcc... no
 checking for cc... no
 checking for cl.exe... no
 configure: error: no acceptable C compiler found in $PATH
 See `config.log' for more details.

  I went ahead and tried to run make testdeps and I got these results:

 /tools/bin/perl ./sbin/rt-test-dependencies --verbose --with-SQLite 
 --with-fastcgi
 perl:
  =5.8.3(5.8.5)...found
 users:
  rt group (www)...MISSING
  bin owner (root)...found
  libs owner (root)...found
  libs group (bin)...found
  web owner (www)...MISSING
  web group (www)...MISSING
 CLI dependencies:
  Term::ReadKey...found
  Getopt::Long = 2.24...found
  HTTP::Request::Common...found
  Term::ReadLine...found
  Text::ParseWords...found
  LWP...found
 CORE dependencies:
  Class::ReturnValue = 0.40...found
  Text::Quoted = 2.02...found
  CSS::Squish = 0.06...MISSING
  Encode = 2.13...MISSING
  Encode version 2.13 required--this is only version 2.01
  Module::Versions::Report = 1.05...MISSING
  Module::Versions::Report version 1.05 required--this is 
 only version 1.03
  MIME::Entity = 5.425...MISSING
  MIME::Entity version 5.425 required--this is only 
 version 5.417
  DBI = 1.37...found
  Locale::Maketext::Lexicon = 0.32...found
  Devel::StackTrace = 1.19...MISSING
  Devel::StackTrace version 1.19 required--this is only 
 version 1.13
  Digest::base...found
  Time::ParseDate...found
  File::Temp = 0.18...MISSING
  File::Temp version 0.18 required--this is only version 
 0.16
  Locale::Maketext = 1.06...found
  Tree::Simple = 1.04...found
  Text::Template...found
  Scalar::Util...found
  HTML::Scrubber = 0.08...found
  File::Spec = 0.8...found
  Calendar::Simple...found
  DBIx::SearchBuilder = 1.54...MISSING
  DBIx::SearchBuilder version 1.54 required--this is only 
 version 1.49
  Mail::Mailer = 1.57...found
  File::ShareDir...MISSING
  Regexp::Common...found
  Digest::MD5 = 2.27...found
  HTML::Entities...found
  Cache::Simple::TimedExpiry...found
  File::Glob...found
  Locale::Maketext::Fuzzy...found
  Time::HiRes...found
  

Re: [rt-users] Trouble upgrading to 3.8.1

2008-10-09 Thread Joop van de Wege
Kenneth Crocker wrote:
   Any clues as to why the C compiler is needed? Thanks.
Not all Perl modules are Pure Perl modules which means that for example 
GD has a Perl interface to the gd.so which fixdeps will try to compile 
for you.
That is probably not the right thing to say but I hope its close enough 
for you to understand the why of th C compiler.

If you really get stuck I might be able to help out, since we used to be 
quite involved with Sun Solaris.

Joop


___
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] Search by Requestor Organization

2008-10-09 Thread Auch, Benjamin
I'm looking to do a search that will group by requestor organization
(bar chart to be exact)

When running my search I can select Requestor Organization, but I cannot
display it as a column, therefore I cannot create a bar chart for it.   

 

What I want is a graph showing the number of tickets created in each
organization.

 

Ideas?

 

Thanks

Ben

 

 

 

 

 



The information contained in this communication may be confidential or legally 
privileged and is intended only for the recipient named above. If the reader of 
this message is not the intended recipient, you are hereby notified that any 
dissemination, distribution or copying of this communication or its contents is 
strictly prohibited. If you have received this communication in error, 
immediately advise the sender and delete the original and any copies from your 
computer system.

___
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] Search by Requestor Organization

2008-10-09 Thread Emmanuel Dreyfus
Auch, Benjamin [EMAIL PROTECTED] wrote:

 I'm looking to do a search that will group by requestor organization
 (bar chart to be exact)
 
 When running my search I can select Requestor Organization, but I cannot
 display it as a column, therefore I cannot create a bar chart for it.
 
 What I want is a graph showing the number of tickets created in each
 organization.

I have exactly the same need, but it seems that intrusive modifications
of RT are required to acheive that goal.

-- 
Emmanuel Dreyfus
http://hcpnet.free.fr/pubz
[EMAIL PROTECTED]
___
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] Richtext spell checker

2008-10-09 Thread Alex Young
Anyone managed to get Aspell working in FCK editor in RT?

 

I installed Aspell and set FCK to use it in its config, but when I click
on the FCK spell check button it pops up
(http://myserver/NoAuth/RichText/editor/fckdialog.html), says spell
check in progress and then gives error message saying:

The page you requested could not be found

Please check the URL and try again.

___
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] Trouble upgrading to 3.8.1

2008-10-09 Thread Kenneth Crocker
Joop,


I ran /tools/bin/ make fixdeps and I got this result:

Checking if your kit is complete...
Looks good
Warning: prerequisite Devel::StackTrace 0 not found.
Writing Makefile for Class::ReturnValue
 Unsatisfied dependencies detected during 
JESSE/Class-ReturnValue-0.55.tar.gz   
 Devel::StackTrace [requires]
Shall I follow them and prepend them to the queue
of modules we are processing right now? [yes] yes

So, I entered 'yes' and hit enter and got several interesting returns 
like this:

Running make test
   Delayed until after prerequisites
Running make install
   Delayed until after prerequisites


followed by this:

Checking if your kit is complete...
Looks good
Writing Makefile for Devel::StackTrace
make[1]: Entering directory 
`/home/rt/.cpan/build/Devel-StackTrace-1.1902-UYgoNf'
cp lib/Devel/StackTrace.pm blib/lib/Devel/StackTrace.pm
Manifying blib/man3/Devel::StackTrace.3
make[1]: Leaving directory 
`/home/rt/.cpan/build/Devel-StackTrace-1.1902-UYgoNf'
   DROLSKY/Devel-StackTrace-1.1902.tar.gz
   /tools/bin/make -- OK
Running make test
make[1]: Entering directory 
`/home/rt/.cpan/build/Devel-StackTrace-1.1902-UYgoNf'
PERL_DL_NONLAZY=1 /tools/bin/perl -MExtUtils::Command::MM -e 
test_harness(0, 'blib/lib', 'blib/arch') t/*.t
t/01-basicok 

 1/35 skipped: various reasons
t/02-bad-utf8.skipped
 all skipped: These tests require Perl 5.8.8+
t/kwaliteeskipped
 all skipped: This test is only run for the module author
t/pod-coverageskipped
 all skipped: This test is only run for the module author
t/pod.skipped
 all skipped: This test is only run for the module author
All tests successful, 4 tests and 1 subtest skipped.


which was followed by this:

Running make for J/JE/JESSE/Class-ReturnValue-0.55.tar.gz
   Has already been unwrapped into directory 
/home/rt/.cpan/build/Class-ReturnValue-0.55-YGoq86

   CPAN.pm: Going to build J/JE/JESSE/Class-ReturnValue-0.55.tar.gz

Warning: Prerequisite 'Devel::StackTrace = 0' for 
'J/JE/JESSE/Class-ReturnValue-0.55.tar.gz' already installed but 
installation looks suspicious. Skipping another installation attempt, to 
prevent looping endlessly.


and then lastly by this:

Running make test
make[1]: Entering directory 
`/home/rt/.cpan/build/Class-ReturnValue-0.55-YGoq86'
PERL_DL_NONLAZY=1 /tools/bin/perl -MExtUtils::Command::MM -e 
test_harness(0, 'inc', 'blib/lib', 'blib/arch') t/*.t
t/basic
#   Failed test 'use Class::ReturnValue;'
#   in t/basic.t at line 5.
# Tried to use 'Class::ReturnValue'.
# Error:  Can't locate Devel/StackTrace.pm in @INC (@INC contains: 
/home/rt/.cpan/build/Class-ReturnValue-0.55-YGoq86/inc 
/home/rt/.cpan/build/Class-ReturnValue-0.55-YGoq86/blib/lib 
/home/rt/.cpan/build/Class-ReturnValue-0.55-YGoq86/blib/arch 
/soft/perl-5.8.5/run/default/sparc-SunOS-5.8/lib/5.8.5/sun4-solaris 
/soft/perl-5.8.5/run/default/sparc-SunOS-5.8/lib/5.8.5/sun4-solaris 
/soft/perl-5.8.5/run/default/sparc-SunOS-5.8/lib/5.8.5 
/soft/perl-5.8.5/run/default/sparc-SunOS-5.8/lib/site_perl/5.8.5/sun4-solaris 
/soft/perl-5.8.5/run/default/sparc-SunOS-5.8/lib/site_perl/5.8.5/sun4-solaris 
/soft/perl-5.8.5/run/default/sparc-SunOS-5.8/lib/site_perl/5.8.5 
/soft/perl-5.8.5/run/default/sparc-SunOS-5.8/lib/site_perl/5.8.5/sun4-solaris 
/soft/perl-5.8.5/run/default/sparc-SunOS-5.8/lib/site_perl/5.8.5 
/soft/perl-5.8.5/run/default/sparc-SunOS-5.8/lib/site_perl . 
/soft/perl-5.8.5/run/default/sparc-SunOS-5.8/lib/5.8.5/sun4-solaris 
/soft/perl-5.8.5/run/default/sparc-SunOS-5.8/lib/5.8.5 
/soft/perl-5.8.5/run/default/sparc-SunOS-5.8/lib/site_perl/5.8.5/sun4-solaris 
/soft/perl-5.8.5/run/default/sparc-SunOS-5.8/lib/site_perl/5.8.5 
/soft/perl-5.8.5/run/default/sparc-SunOS-5.8/lib/site_perl .) at 
/home/rt/.cpan/build/Class-ReturnValue-0.55-YGoq86/blib/lib/Class/ReturnValue.pm
 
line 81.
# BEGIN failed--compilation aborted at t/basic.t line 5.
# Compilation failed in require at (eval 3) line 2.
# BEGIN failed--compilation aborted at (eval 3) line 2.
Can't locate object method new via package Class::ReturnValue at 
t/basic.t line 8.
# Looks like you planned 32 tests but only ran 1.
# Looks like you failed 1 test of 1 run.
# Looks like your test died just after 1.
t/basicdubious 

 Test returned status 255 (wstat 65280, 0xff00)
DIED. FAILED tests 1-32
 Failed 32/32 tests, 0.00% okay
Failed Test Stat Wstat Total Fail  List of Failed
---
t/basic.t255 6528032   63  1-32
Failed 1/1 test scripts. 32/32 subtests failed.
Files=1, Tests=32,  0 wallclock secs ( 0.10 cusr +  0.02 csys =  0.12 CPU)
Failed 1/1 test programs. 32/32 subtests failed.
make[1]: *** [test_dynamic] Error 255
make[1]: Leaving directory 
`/home/rt/.cpan/build/Class-ReturnValue-0.55-YGoq86'
   JESSE/Class-ReturnValue-0.55.tar.gz
   /tools/bin/make test -- NOT OK

Re: [rt-users] Trouble upgrading to 3.8.1

2008-10-09 Thread Kenneth Crocker
Joop,


I decided to try again. I have a couple questions:

1) how do I know that the 'automatic' installs are installing the 
latest versions of perl, SearchBuilder, etc.?
2) What am I really supposed to do with this result?

The automatic tests for GDGraph are not really a solid workout of the
library. The best way to test the package is to run the examples
before installing it.  You can run the examples in the samples
directory with `make samples` or by going into that directory, and
just running `make`.
If that fails, please read samples/Makefile.
 Unsatisfied dependencies detected during 
   BWARFIELD/GDGraph-1.44.tar.gz  
 GD::Text [requires]
Shall I follow them and prepend them to the queue
of modules we are processing right now? [yes]

Do I stop the 'make fixdeps' and run the 'make samples' (where IS the 
samples directory anyway)?


Kenn
LBNL

On 10/9/2008 10:41 AM, Joop van de Wege wrote:
 Kenneth Crocker wrote:
 Any clues as to why the C compiler is needed? Thanks.
 Not all Perl modules are Pure Perl modules which means that for example 
 GD has a Perl interface to the gd.so which fixdeps will try to compile 
 for you.
 That is probably not the right thing to say but I hope its close enough 
 for you to understand the why of th C compiler.
 
 If you really get stuck I might be able to help out, since we used to be 
 quite involved with Sun Solaris.
 
 Joop
 
 
 

___
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] New install of rt3.8.1 getting error

2008-10-09 Thread Don Beethe
 
Just loaded rt3.8.1 on redhat AS4.5/64. When I try to hit the site, get:

Can't call method HasRight on an undefined value at
/opt/rt3/bin/../lib/RT/User_Overlay.pm line 1209. 

What don't I have configured right? 

___
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] No theme on 3.8.1, Fresh Install

2008-10-09 Thread Adam Sailer
No theme on 3.8.1, Fresh Install

Pointers, anyone?

Thank you,

Adam Sailer
Computer Support Analyst II
Information Systems
University of Washington Bothell


___
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] Search by Requestor Organization

2008-10-09 Thread Ruslan Zakirov
Not that hard: 
http://svn.bestpractical.com/cgi-bin/index.cgi/bps/revision?rev=16264
Would be available in RT 3.8.3, however there is a bug in RT I should
fix that makes numbers incorrect for Requestors, Ccs and other
watchers.

On Thu, Oct 9, 2008 at 11:44 PM, Emmanuel Dreyfus [EMAIL PROTECTED] wrote:
 Auch, Benjamin [EMAIL PROTECTED] wrote:

 I'm looking to do a search that will group by requestor organization
 (bar chart to be exact)

 When running my search I can select Requestor Organization, but I cannot
 display it as a column, therefore I cannot create a bar chart for it.

 What I want is a graph showing the number of tickets created in each
 organization.

 I have exactly the same need, but it seems that intrusive modifications
 of RT are required to acheive that goal.

 --
 Emmanuel Dreyfus
 http://hcpnet.free.fr/pubz
 [EMAIL PROTECTED]
 ___
 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




-- 
Best regards, Ruslan.
___
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] Upgrading MySQL 4.1 to MySQL 5.0

2008-10-09 Thread Ruslan Zakirov
If RT 3.8.0 or newer has been installed on mysql 4.1 then there is no
need to do anything after upgrade of the server to mysql 5.0.x

On Fri, Oct 10, 2008 at 4:13 AM,  [EMAIL PROTECTED] wrote:
 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




-- 
Best regards, Ruslan.
___
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