Re: [rt-users] Suggestions for auto-archiving?

2007-01-31 Thread Roy El-Hames

This is something I pondered over , few time in the past ..
for moving the tickets possibly have a look at Ruslan's RTx::Shredder as 
a starting point (the principle of that module is to delete tickets, 
however I think you can modify it to copy the tickets else where before 
deleting them).
The problems/obstacle then is how to search tickets that you have moved 
to the archive??

Roy

Philip Kime wrote:

Finally I have set up a spare RT server which I'd like to archive off
tickets older than, say, a year, in order to clean up the DB. I have a
few ideas about how to do this but has anyone done anything like this?
What I need is an automated procedure to move tickets more than a year
old to a different server/DB/RT instance. This probably needs doing at
an RT API level to catch all the links etc.
 
PK
 
--

Philip Kime
NOPS Systems Architect
310 401 0407
 

  



___
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] Merging RT Databases

2007-01-31 Thread Torsten Brumm

This sounds not possible to me, because i think both rt instances are useing
the same ticket numbers? When you try to merge them i think you get a awful
chaos!

Torsten

2007/1/30, Ruben Romao [EMAIL PROTECTED]:


 Hi!

I have made a migration of RT from version 3.0.9 to 3.6.1 with MySQL 5.0and 
it's working very well.

The problem is that I have a second RT running on another machine that
contains data that I want to put/merge into the new RT database.

With this I'll have one RT with one database instead two RT's with two
databases.

Is that possible?

If so, how can I do that?

I can't just make a mysqldump because the Ticket ID's already exists in
the first one…!

Someone can help me with this?

Thanks a lot.



Ruben Romao

e: [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





--
MFG

Torsten Brumm

http://www.torsten-brumm.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] Suggestions for auto-archiving?

2007-01-31 Thread Brian Gallew

Roy El-Hames wrote:

This is something I pondered over , few time in the past ..
for moving the tickets possibly have a look at Ruslan's RTx::Shredder 
as a starting point (the principle of that module is to delete 
tickets, however I think you can modify it to copy the tickets else 
where before deleting them).
The problems/obstacle then is how to search tickets that you have 
moved to the archive??


Actually, if you run RTx::Shredder, it write an SQL file out by default 
that can be used to restore the data.  That being the case, you would 
need to replicate the users and queues (by ID) in your backup database 
and load in the archive files.  For the very first purge, I'd be tempted 
to do it backwards: dump the entire database, restore the whole thing to 
the archive instance, and then purge everything newer than X, 
simultaneously purging everything older than X in the real instance.  
Then Shredder could be used to create future diffs to to apply to the 
archive.  You would have to come up with a reasonable way to add 
users/queues in a more or less automated fashion, too.

___
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] Correspond Transaction Twice on Reply in Batchmode

2007-01-31 Thread Audun Ytterdal
I want to control most of my tickets with mails and I am cc'ing all
tickets in a queue to a group of customers and a shared folder.

Since mail is the main interface i've put some effort into putting some
info in the footer of each mail

scrip
Description: 99LinproCorrespond
Condition: On Correspnd
Action: Notify Requestors, Ccs and AdminCcs
Template: Global template: LinproMailTemplateRe
Stage: TransactionCreate
/scrip

template
RT-Attach-Message: yes
Subject: { Re: [.$RT::rtname. #.$Ticket-id.] .$Ticket-Subject}

{
 my $content = '';
 my $transactions = $Ticket-Transactions;
 $transactions-Limit( FIELD = 'Type', VALUE = 'Correspond' );

 while (my $transaction = $transactions-Next) {
   my $attachments = $transaction-Attachments;

   while (my $message = $attachments-Next) {
 next unless $message-ContentType =~
  m!^(text/plain|message|text$)!i;

 $content = $message-Content;
   }
 }
 my $output = ($content || $Transaction-Content());
 $output;
}
--
Linproticket: {$RT::WebURL}Ticket/Display.html?id={$Ticket-id}
[{$Ticket-Status}]
Requestor: {$Ticket-RequestorAddresses} Created: {$Ticket-Created}
Owner: {$Ticket-OwnerObj-EmailAddress || $Ticket-OwnerObj-Name}
Level: {$Ticket-FirstCustomFieldValue('LinproLevel') }
/template

This works, except the script is firing to soon so the information in
$Ticket-Status and friends is outdated.

After some googling around i found out that this works much better if I
put on correspondece  in TransactionBatch-stage. All the information
is now up to date and everything works as expected using the
mailinterface to set Owner and Status and such.

BUT, the script now fires twice If I use the webinterface. When I click
on reply on a ticket _and_ when I submit  the reply.

If the on correspondance is in TransactionCreate-Stage: Fire of the
scrip when update ticket is clicked. But info is outdated
If the on correspondance is in TransactionBatche-stage: Fire when
clicking on reply and on update ticket so I get two mails.

Is there anything I can to the get the benefit of both worlds? Is it a
bug to start a transaction when clicking on reply before you acctually
update it?

--
Audun
___
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] CustomField Why isn't the description displayed on tickets?

2007-01-31 Thread Brian Kjelin Olsen
Hi all,

On creation of a CustomField fx of type Select one value, you can create 
following information in your values:
Sort, Name, Description and Category. Sort and Category is not relevant for 
this issue.

In the combobox in the ticket display only Name is displayed but not 
Description. Why? Or more relevant... How do I do to display the description 
along with the name?

My problem is that I thought that I could use Name for my ID values and 
Desciption to guide the users.
Fx:
NAMEDESCRIPTION
-  ---
1   Norminal ledger
2   Subscription
3   Advertisement
...

On the ticket the users can only see 1, 2, 3... 

Med venlig hilsen / Best regards
Brian Kjelin Olsen
Systemkonsulent
 
Schilling A/S
Baldersbækvej 24-26
DK-2635 Ishøj
Tel: +45 70 27 99 00
Fax: +45 70 27 99 10
[EMAIL PROTECTED]
www.schilling.dk

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

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


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


[rt-users] RT::CustomField - Queue deprecated at (RT::Tickets:/opt/rt3/local/lib/RT/Tickets_Overlay.pm:2245)

2007-01-31 Thread Peer Michael
Greeting
 
When i use the function $tickets-LimitCustomField(CUSTOMFIELD =
'', OPERATOR = 'LIKE', VALUE = 'true'); i find this message in
the log:
[Wed Jan 31 15:47:34 2007] [debug]: RT::CustomField - Queue deprecated
at (RT::Tickets:/opt/rt3/local/lib/RT/Tickets_Overlay.pm:2245)
(/opt/rt3/lib/RT/CustomField_Overlay.pm:741)
 
How can i avoid this message?
 
Thanks
 

Michael Peer
ICT
___
EURAC research
Viale Druso/Drususallee 1
39100 Bolzano/Bozen
Italy

Email: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] 
Website: www.eurac.edu http://www.eurac.edu/ 

 
___
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] Re: [Rt-devel] RT 3.6.3 (and earlier) logs via RT::Logger in gmttime only?

2007-01-31 Thread Jon Daley

On Wed, 31 Jan 2007, Ruslan Zakirov wrote:

Yes, it's UTC. Use syslog :) I don't think there is any reason to switch.


	I am not quite sure what this means.  This is probably a dumb 
question, but try not to make too much fun of me...


	 I have also noticed the time difference, but hadn't spent enough 
time to figure out how to change it.  I normally use 'less' to read the 
syslogs, are you saying there is another app to read the logs with, or I 
should be passing the RT logs to syslogd and then he can convert the 
timestamps?

___
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] Re: LDAP Overlay and automated logins

2007-01-31 Thread Ryan Hardester
I have started digging myself into a hole, and my solution is to use RT to fill 
the hole :) .. 

I redirected our webmaster email address into RT. Problem there is there are 2 
issues that are generally sent into this address website issues, and customer 
service issues for our finance dept. They already have an e-mail address for 
customer service requests. The people who check that mailbox are less than 
technologically savvy. I'd like to have the customer service address dump into 
RT, and create a local user for them to log in as one user since more than one 
person can access/respond to issues. Then when an issue for them comes in to 
the Webmaster queue for them we just assign it to them and they can deal with 
it within RT. As it is we are having to get the message out of RT into that 
mailbox which isn't as easy as just assigning it. Security on this queue isn't 
a big deal to us, and I think the tracking of the issues would be a plus to 
them. 

So what I am looking to happen is have a URL I can make a favorite (and 
ultimately drag into their outlook bar so they can launch it within outlook) 
that will just open them up into the self service interface for that user 
without a password prompt. This user won't be working with LDAP as it will be 
local, but I don't know if the ldap overlay changes the potential for making 
that happen. We'll still want all the other users to use username/password. 

--Ryan

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Dave Ewart
Sent: Tuesday, January 30, 2007 12:56 AM
To: rt-users@lists.bestpractical.com
Subject: [rt-users] Re: LDAP Overlay and automated logins

-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1

On Monday, 29.01.2007 at 16:40 -0800, Ryan Hardester wrote:

 Is it possible to pass the username and password to RT in the link?
 
 we are running RT3.6.3 with the LDAP overlay. I realize the user would 
 not be terribly secure but i am looking for an easy way to direct many 
 people into a single login without too many steps.

Do you mean so that the users don't have to explicitly login?  And do you mean 
by direct many people into a single login, that you plan to have many users 
sharing a single RT account?

This sounds like a very unusual setup: can you explain why you want to do this?

Dave.
- --
Dave Ewart
[EMAIL PROTECTED]
Computing Manager, Cancer Epidemiology Unit Cancer Research UK / Oxford 
University
PGP: CC70 1883 BD92 E665 B840 118B 6E94 2CFD 694D E370 Get key from 
http://www.ceu.ox.ac.uk/~davee/davee-ceu-ox-ac-uk.asc
N 51.7518, W 1.2016
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.4.2.2 (GNU/Linux)

iD8DBQFFvwgXbpQs/WlN43ARAmUyAKDtze8UuWthxiQ+V6/Ljgload69/QCg53Ml
wuIt2LtoZo1jVHYq3GSGH+c=
=ZpDp
-END PGP SIGNATURE-
___
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] Re: LDAP Overlay and automated logins

2007-01-31 Thread John Arends
You could probably create a copy of the login form but make the login 
and password fields hidden fiends and populate them with the data. You 
can then point that user at that address and it'd drop them into RT all 
logged in.


I ask though, why would you want to do this? Even our least savvy 
computer users still have to use passwords. It's a matter of security. 
People can learn to type in a password.


Ryan Hardester wrote:
I have started digging myself into a hole, and my solution is to use RT to fill the hole :) .. 

I redirected our webmaster email address into RT. Problem there is there are 2 issues that are generally sent into this address website issues, and customer service issues for our finance dept. They already have an e-mail address for customer service requests. The people who check that mailbox are less than technologically savvy. I'd like to have the customer service address dump into RT, and create a local user for them to log in as one user since more than one person can access/respond to issues. Then when an issue for them comes in to the Webmaster queue for them we just assign it to them and they can deal with it within RT. As it is we are having to get the message out of RT into that mailbox which isn't as easy as just assigning it. Security on this queue isn't a big deal to us, and I think the tracking of the issues would be a plus to them. 

So what I am looking to happen is have a URL I can make a favorite (and ultimately drag into their outlook bar so they can launch it within outlook) that will just open them up into the self service interface for that user without a password prompt. This user won't be working with LDAP as it will be local, but I don't know if the ldap overlay changes the potential for making that happen. We'll still want all the other users to use username/password. 


--Ryan

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Dave Ewart
Sent: Tuesday, January 30, 2007 12:56 AM
To: rt-users@lists.bestpractical.com
Subject: [rt-users] Re: LDAP Overlay and automated logins

-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1

On Monday, 29.01.2007 at 16:40 -0800, Ryan Hardester wrote:


Is it possible to pass the username and password to RT in the link?

we are running RT3.6.3 with the LDAP overlay. I realize the user would 
not be terribly secure but i am looking for an easy way to direct many 
people into a single login without too many steps.


Do you mean so that the users don't have to explicitly login?  And do you mean by 
direct many people into a single login, that you plan to have many users 
sharing a single RT account?

This sounds like a very unusual setup: can you explain why you want to do this?

Dave.
- --
Dave Ewart
[EMAIL PROTECTED]
Computing Manager, Cancer Epidemiology Unit Cancer Research UK / Oxford 
University
PGP: CC70 1883 BD92 E665 B840 118B 6E94 2CFD 694D E370 Get key from 
http://www.ceu.ox.ac.uk/~davee/davee-ceu-ox-ac-uk.asc
N 51.7518, W 1.2016
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.4.2.2 (GNU/Linux)

iD8DBQFFvwgXbpQs/WlN43ARAmUyAKDtze8UuWthxiQ+V6/Ljgload69/QCg53Ml
wuIt2LtoZo1jVHYq3GSGH+c=
=ZpDp
-END PGP SIGNATURE-
___
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

___
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] Re: [Rt-devel] RT 3.6.3 (and earlier) logs via RT::Logger in gmttime only?

2007-01-31 Thread Ruslan Zakirov

We print timestamps only to Screen and File, but never to syslog. So
if you want mix different logs in one place then syslog is your
answer.
Set( $RT::LogToSyslog, 'error' );
Set( $RT::LogToScreen, '' );
Set( $RT::LogToFile, '' );

On 1/31/07, Jon Daley [EMAIL PROTECTED] wrote:

On Wed, 31 Jan 2007, Ruslan Zakirov wrote:
 Yes, it's UTC. Use syslog :) I don't think there is any reason to switch.

I am not quite sure what this means.  This is probably a dumb
question, but try not to make too much fun of me...

 I have also noticed the time difference, but hadn't spent enough
time to figure out how to change it.  I normally use 'less' to read the
syslogs, are you saying there is another app to read the logs with, or I
should be passing the RT logs to syslogd and then he can convert the
timestamps?



--
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] Re: [Rt-devel] RT 3.6.3 (and earlier) logs via RT::Logger in gmttime only?

2007-01-31 Thread Jon Daley

Ah, I see.  I have it set like this:
Set($LogToSyslog, 'error');
Set($LogToScreen, 'error');
Set($LogToFile  , 'notice');

So, I basically never see anything in my syslog (since RT is so great...)
but see stuff in the rt.log file with the timestamps as you said.

Thanks for the clarification.


On Wed, 31 Jan 2007, Ruslan Zakirov wrote:

We print timestamps only to Screen and File, but never to syslog. So
if you want mix different logs in one place then syslog is your
answer.
Set( $RT::LogToSyslog, 'error' );
Set( $RT::LogToScreen, '' );
Set( $RT::LogToFile, '' );

On 1/31/07, Jon Daley [EMAIL PROTECTED] wrote:

On Wed, 31 Jan 2007, Ruslan Zakirov wrote:
 Yes, it's UTC. Use syslog :) I don't think there is any reason to switch.

I am not quite sure what this means.  This is probably a dumb
question, but try not to make too much fun of me...

 I have also noticed the time difference, but hadn't spent enough
time to figure out how to change it.  I normally use 'less' to read the
syslogs, are you saying there is another app to read the logs with, or I
should be passing the RT logs to syslogd and then he can convert the
timestamps?



--
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] RT 3.6.3 upgrade

2007-01-31 Thread Ruslan Zakirov

Do see an outgoing email transaction with autoreply in the history of
the ticket?

On 1/31/07, Michael Hogan [EMAIL PROTECTED] wrote:

Last night I upgraded from 3.6.1 to 3.6.3.  When I send an e-mail the ticket
is logged ok and that all works fine.  It does not however send the
autoreply like it used to do before the upgrade.  I have checked my mail
logs and rt doesn't even attempt to send it to sendmail.  So I was wondering
if there was a known issue in which this occurs.  I couldn't find anything
in the wiki or thread archives.  Thanks.

Mike

___
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] RT 3.6.3 upgrade

2007-01-31 Thread Michael Hogan

No, it is not showing an outgoing mail there either.  I have tracked down
the issue a little further.  My apache logs showed errors with the
Date::Format module which I installed from cpan before the upgrade.  It is
required when running make testdeps.  It was looking for the Date/Format.pm
in a bunch of directories and it wasn't there.  cpan had installed it in my
perl 5.8.5 directory instead of 5.8.8.  I copied it over to the other
directory but now I get this error:

[Wed Jan 31 20:32:31 2007] [error]: Scrip Prepare 3 died. - Require of
RT::Action::Autoreply failed.
strftime is not exported by the Date::Format module
Can't continue after import errors at /opt/rt3/lib/RT/Action/SendEmail.pm
line 59
BEGIN failed--compilation aborted at /opt/rt3/lib/RT/Action/SendEmail.pm
line 59.


I am currently trying to track this down.  Any help would be appreciated.
:^)

Mike

On 1/31/07, Ruslan Zakirov [EMAIL PROTECTED] wrote:


Do see an outgoing email transaction with autoreply in the history of
the ticket?

On 1/31/07, Michael Hogan [EMAIL PROTECTED] wrote:
 Last night I upgraded from 3.6.1 to 3.6.3.  When I send an e-mail the
ticket
 is logged ok and that all works fine.  It does not however send the
 autoreply like it used to do before the upgrade.  I have checked my mail
 logs and rt doesn't even attempt to send it to sendmail.  So I was
wondering
 if there was a known issue in which this occurs.  I couldn't find
anything
 in the wiki or thread archives.  Thanks.

 Mike

 ___
 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] RT 3.6.3 upgrade

2007-01-31 Thread Ruslan Zakirov

On 1/31/07, Michael Hogan [EMAIL PROTECTED] wrote:

No, it is not showing an outgoing mail there either.  I have tracked down
the issue a little further.  My apache logs showed errors with the
Date::Format module which I installed from cpan before the upgrade.  It is
required when running make testdeps.  It was looking for the Date/Format.pm
in a bunch of directories and it wasn't there.  cpan had installed it in my
perl 5.8.5 directory instead of 5.8.8.  I copied it over to the other
directory but now I get this error:

[Wed Jan 31 20:32:31 2007] [error]: Scrip Prepare 3 died. - Require of
RT::Action::Autoreply failed.
strftime is not exported by the Date::Format module
Can't continue after import errors at
/opt/rt3/lib/RT/Action/SendEmail.pm line 59
BEGIN failed--compilation aborted at
/opt/rt3/lib/RT/Action/SendEmail.pm line 59.


I am currently trying to track this down.  Any help would be appreciated.
:^)

Instead of copying things around what is really weird way to do things
done in this case you should run installer with perl 5.8.8 binaries.
If you're using the cpan shell then just do:
/path/to/perl5.8.8 -MCPAN -eshell
and then do install XXX.

If you install things from a tarball yourself then do:
/path/to/perl5.8.8 Makefile.PL  make  make test  sudo make install



Mike


On 1/31/07, Ruslan Zakirov [EMAIL PROTECTED] wrote:
 Do see an outgoing email transaction with autoreply in the history of
 the ticket?

 On 1/31/07, Michael Hogan [EMAIL PROTECTED] wrote:
  Last night I upgraded from 3.6.1 to 3.6.3.  When I send an e-mail the
ticket
  is logged ok and that all works fine.  It does not however send the
  autoreply like it used to do before the upgrade.  I have checked my mail
  logs and rt doesn't even attempt to send it to sendmail.  So I was
wondering
  if there was a known issue in which this occurs.  I couldn't find
anything
  in the wiki or thread archives.  Thanks.
 
  Mike
 
  ___
 
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.






--
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] RT 3.6.3 upgrade

2007-01-31 Thread Michael Hogan

I uninstalled the copy I had moved over and then found the perl executable
for 5.8.8 and moved it to usr bin so it was the one that ran when I used the
command perl and the prompt.  Then I installed the 5.8.8 binary of the
date::format as you described and it is up and running correctly again.   I
restarted my webserver as well.  Thanks for the help.

Mike


On 1/31/07, Michael Hogan [EMAIL PROTECTED] wrote:


No, it is not showing an outgoing mail there either.  I have tracked down
the issue a little further.  My apache logs showed errors with the
Date::Format module which I installed from cpan before the upgrade.  It is
required when running make testdeps.  It was looking for the Date/Format.pm
in a bunch of directories and it wasn't there.  cpan had installed it in my
perl 5.8.5 directory instead of 5.8.8.  I copied it over to the other
directory but now I get this error:

[Wed Jan 31 20:32:31 2007] [error]: Scrip Prepare 3 died. - Require of
RT::Action::Autoreply failed.
strftime is not exported by the Date::Format module
Can't continue after import errors at /opt/rt3/lib/RT/Action/SendEmail.pm
line 59
BEGIN failed--compilation aborted at /opt/rt3/lib/RT/Action/SendEmail.pm
line 59.


I am currently trying to track this down.  Any help would be appreciated.
:^)

Mike

On 1/31/07, Ruslan Zakirov [EMAIL PROTECTED] wrote:

 Do see an outgoing email transaction with autoreply in the history of
 the ticket?

 On 1/31/07, Michael Hogan [EMAIL PROTECTED] wrote:
  Last night I upgraded from 3.6.1 to 3.6.3.  When I send an e-mail the
 ticket
  is logged ok and that all works fine.  It does not however send the
  autoreply like it used to do before the upgrade.  I have checked my
 mail
  logs and rt doesn't even attempt to send it to sendmail.  So I was
 wondering
  if there was a known issue in which this occurs.  I couldn't find
 anything
  in the wiki or thread archives.  Thanks.
 
  Mike
 
  ___
  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

[rt-users] resolve link defaults to comment, not reply

2007-01-31 Thread N.J. Thomas
When clicking on the resolve link for a ticket, the UpdateType is set
to comment on the ticket by defauly. I'd like to change this to reply,
where can I change this behavior?
___
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] Generating static html files for crawler

2007-01-31 Thread Asif Iqbal

Hi All

Currently I am using a wget/perl script to generate static html pages
so that my crawler can index those html files. However `wget/perl'
script is giving my mysql a jump from a usual 1% cpu to now--when I
run the script--27% cpu.

Is there a less expensive way (RT way) to generate exact static
replica of a default ticket page--look and feel as well?

I am using a `for loop' and `rt show ticket/id' to generate a list of
valid ticket numbers and the
createstatic.pl file takes those numbers as arguments and creates
static html files.

for example I am assuming--not sure how to get the latest ticket id
otherwise--my latest ticket id is 40. So I run


for i in `seq 1 40`; do rt show ticket/$i | grep -q id  echo $i
; done  tickets

Then I run the next `for loop' to generate the static html pages

for t in `cat tickets ` ; do perl createstatic.pl $t 
/var/apache/htdocs/tickets/${t}.html; sleep 2; done

So now my crawler can index the static pages.

Here is my createstatic.pl attached

Thanks

--
Asif Iqbal
PGP Key: 0xE62693C5 KeyServer: pgp.mit.edu
#!/usr/bin/perl

use strict;

my $_WGET = /usr/local/bin/wget --no-check-certificate -q -O -;
my $BASE = https://rt.host.net/Ticket;;
my $USERNAME = staticuser;
my $PASSWORD = staticpass;

my $ticketID = $ARGV[0];


my $QUERY = ${BASE}/Display.html?id=${ticketID}. #-
user=${USERNAME}pass=${PASSWORD};
open (INFILE, ${_WGET} '${QUERY}' |) || die Unable to open '${_WGET}' $!;
while (my $line = INFILE) {
if ($line =~ /TITLE[^]*\/TITLE/) { # Title Of Page
print ${line}base href=\${BASE}\\n;
next;
} elsif ($line =~ /bTicket metadata\/b/) {
print a href=\https://rt.host.net/Ticket;. #-
/Display.html?id=${ticketID}\. #-
This is a cached copy of this page.  . #-
Click here to view live ticket/abr\n${line};
next;
}
print $line;
}
close (INFILE);
___
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] resolve link defaults to comment, not reply

2007-01-31 Thread Ruslan Zakirov

look in archives of the list

On 2/1/07, N.J. Thomas [EMAIL PROTECTED] wrote:

When clicking on the resolve link for a ticket, the UpdateType is set
to comment on the ticket by defauly. I'd like to change this to reply,
where can I change this behavior?
___
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


[rt-users] HTTP::Server::Simple::Mason Install woes

2007-01-31 Thread Joe Casadonte

OS: RHAS4 (2.6.9-42.0.2)
RT: 3.6.3
Perl: 5.8.5
HTML::Mason: 1.35

I'm trying to install HTTP::Server::Simple::Mason and I'm getting the 
following errors.  I searched the archives and found the same errors, 
and the solution was to upgrade to HTML::Mason 1.31 -- I'm beyond that. 
 I also have another installation of RT which has the same exact setup 
of the above versions, and HTTP::Server::Simple::Mason installed there 
just fine.  Any ideas?  Thanks!



cpan[1] install HTTP::Server::Simple::Mason
CPAN: Storable loaded ok
Going to read /root/.cpan/Metadata
  Database was generated on Wed, 31 Jan 2007 04:27:27 GMT
Running install for module HTTP::Server::Simple::Mason
Running make for J/JE/JESSE/HTTP-Server-Simple-Mason-0.09.tar.gz
CPAN: Digest::SHA loaded ok
Checksum for 
/root/.cpan/sources/authors/id/J/JE/JESSE/HTTP-Server-Simple-Mason-

0.09.tar.gz ok
Scanning cache /root/.cpan/build for sizes
HTTP-Server-Simple-Mason-0.09/
HTTP-Server-Simple-Mason-0.09/lib/
HTTP-Server-Simple-Mason-0.09/lib/HTTP/
HTTP-Server-Simple-Mason-0.09/lib/HTTP/Server/
HTTP-Server-Simple-Mason-0.09/lib/HTTP/Server/Simple/
HTTP-Server-Simple-Mason-0.09/lib/HTTP/Server/Simple/Mason.pm
HTTP-Server-Simple-Mason-0.09/inc/
HTTP-Server-Simple-Mason-0.09/inc/Module/
HTTP-Server-Simple-Mason-0.09/inc/Module/Install.pm
HTTP-Server-Simple-Mason-0.09/inc/Module/Install/
HTTP-Server-Simple-Mason-0.09/inc/Module/Install/Fetch.pm
HTTP-Server-Simple-Mason-0.09/inc/Module/Install/Makefile.pm
HTTP-Server-Simple-Mason-0.09/inc/Module/Install/Base.pm
HTTP-Server-Simple-Mason-0.09/inc/Module/Install/Metadata.pm
HTTP-Server-Simple-Mason-0.09/inc/Module/Install/Can.pm
HTTP-Server-Simple-Mason-0.09/inc/Module/Install/WriteAll.pm
HTTP-Server-Simple-Mason-0.09/inc/Module/Install/Win32.pm
HTTP-Server-Simple-Mason-0.09/t/
HTTP-Server-Simple-Mason-0.09/t/05handlederrors.t
HTTP-Server-Simple-Mason-0.09/t/04unhandlederrors.t
HTTP-Server-Simple-Mason-0.09/t/03podcoverage.t
HTTP-Server-Simple-Mason-0.09/t/02pod.t
HTTP-Server-Simple-Mason-0.09/t/01live.t
HTTP-Server-Simple-Mason-0.09/t/00smoke.t
HTTP-Server-Simple-Mason-0.09/Changes
HTTP-Server-Simple-Mason-0.09/MANIFEST
HTTP-Server-Simple-Mason-0.09/META.yml
HTTP-Server-Simple-Mason-0.09/ex/
HTTP-Server-Simple-Mason-0.09/ex/sample_server.pl
HTTP-Server-Simple-Mason-0.09/Makefile.PL
HTTP-Server-Simple-Mason-0.09/SIGNATURE
Removing previously used /root/.cpan/build/HTTP-Server-Simple-Mason-0.09

  CPAN.pm: Going to build J/JE/JESSE/HTTP-Server-Simple-Mason-0.09.tar.gz

Checking if your kit is complete...
Looks good
Writing Makefile for HTTP::Server::Simple::Mason
CPAN: YAML loaded ok
cp lib/HTTP/Server/Simple/Mason.pm blib/lib/HTTP/Server/Simple/Mason.pm
Manifying blib/man3/HTTP::Server::Simple::Mason.3pm
  /usr/bin/make  -- OK
Running make test
PERL_DL_NONLAZY=1 /usr/bin/perl -MExtUtils::Command::MM -e 
test_harness(0,

'inc', 'blib/lib', 'blib/arch') t/*.t
t/00smoke..ok
t/01live...ok 1/5Use of uninitialized value in pattern match 
(m//) a

t t/01live.t line 18, DATA line 16.

#   Failed test 'Returns a page containing only 2'
#   at t/01live.t line 18.
#   undef
# doesn't match '(?-xism:2$)'
t/01live...ok 5/5# Looks like you failed 1 test of 5.
t/01live...dubious
Test returned status 1 (wstat 256, 0x100)
DIED. FAILED test 4
Failed 1/5 tests, 80.00% okay
t/02podskipped
all skipped: Test::Pod 1.14 required for testing POD
t/03podcoverageskipped
all skipped: Test::Pod::Coverage 1.04 required for testing POD 
coverage

t/04unhandlederrorsok 1/5
#   Failed test 'Returns an empty page'
#   at t/04unhandlederrors.t line 18.
#  got: undef
# expected: ''
t/04unhandlederrorsok 5/5# Looks like you failed 1 test of 5.
t/04unhandlederrorsdubious
Test returned status 1 (wstat 256, 0x100)
DIED. FAILED test 4
Failed 1/5 tests, 80.00% okay
t/05handlederrors..ok 1/5
#   Failed test 'custom error handler called'
#   at t/05handlederrors.t line 18.
#  got: undef
# expected: 'We handled this error'
t/05handlederrors..NOK 4/5# Looks like you failed 1 test of 5.
t/05handlederrors..dubious
Test returned status 1 (wstat 256, 0x100)
DIED. FAILED test 4
Failed 1/5 tests, 80.00% okay
Failed Test   Stat Wstat Total Fail  List of Failed
---
t/01live.t   1   256 51  4
t/04unhandlederrors.t1   256 51  4
t/05handlederrors.t  1   256 51  4
2 tests skipped.
Failed 3/6 test scripts. 3/23 subtests failed.
Files=6, Tests=23,  6 wallclock secs ( 1.36 cusr +  0.37 csys =  1.73 CPU)
Failed 3/6 test programs. 3/23 subtests failed.
make: *** [test_dynamic] Error 1
  /usr/bin/make test -- NOT OK
Running make install
  make test had returned bad status, won't install without force
Failed during this command:
  

Re: [rt-users] HTTP::Server::Simple::Mason Install woes

2007-01-31 Thread Joe Casadonte

On 1/31/2007 7:34 PM, Joe Casadonte wrote:

OS: RHAS4 (2.6.9-42.0.2)
RT: 3.6.3
Perl: 5.8.5
HTML::Mason: 1.35

I'm trying to install HTTP::Server::Simple::Mason and I'm getting the 
following errors.  I searched the archives and found the same errors, 
and the solution was to upgrade to HTML::Mason 1.31 -- I'm beyond that. 
 I also have another installation of RT which has the same exact setup 
of the above versions, and HTTP::Server::Simple::Mason installed there 
just fine.  Any ideas?  Thanks!


I have tried to get the two Perl environments as close as possible. 
Here are the only differences:


Module Name  Fails  Works
===  =  ==
DBI  1.53   1.40-8
PAR::Dist0.21   0.11
Test::Exception  0.24   0.21
Test::Harness2.64   (not installed)

If I remove Test::Harness from the system that fails, I can't install 
*anything*.  Anything else I can try?  Can I just ignore the failed test 
and force it?  How soon will I know if that causes problems?


Thanks!

--
Regards,


joe
Joe Casadonte
[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


RE: [rt-users] RT::CustomField - Queue deprecated at (RT::Tickets:/opt/rt3/local/lib/RT/Tickets_Overlay.pm:2245)

2007-01-31 Thread Peer Michael
I'm using rt-3.4.5.
 

-Original Message-
From: Ruslan Zakirov [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, 31 January, 2007 17:52
To: Peer Michael
Cc: rt-users@lists.bestpractical.com
Subject: Re: [rt-users] RT::CustomField - Queue deprecated at
(RT::Tickets:/opt/rt3/local/lib/RT/Tickets_Overlay.pm:2245)

On 1/31/07, Peer Michael [EMAIL PROTECTED] wrote:


 Greeting

 When i use the function
 $tickets-LimitCustomField(CUSTOMFIELD = '', OPERATOR = 'LIKE',

 VALUE = 'true'); i find this message in the log:
 [Wed Jan 31 15:47:34 2007] [debug]: RT::CustomField - Queue 
 deprecated at
 (RT::Tickets:/opt/rt3/local/lib/RT/Tickets_Overlay.pm:2245)
 (/opt/rt3/lib/RT/CustomField_Overlay.pm:741)

 How can i avoid this message?
Update to newer version of the RT? Or at least say us what version
you're using.


 Thanks


--
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