Re: [rt-users] RT Migration

2008-06-05 Thread Ruslan Zakirov
I suspect that new version is not RT 3.6.6 as something like that was
fixed in 3.6.2.

On Thu, Jun 5, 2008 at 2:19 PM, Tariq Doukkali
[EMAIL PROTECTED] wrote:
 hello all,

 I had a RT-Server (3.2.1) on a linux Server (suse 9.3). Now I will migrate RT 
 to new Server with Suse 10.2. the database migration worked well. On the old 
 Server the installtion path was /opt/rt3.

 I have just copied this folder to my new server on suse 10.2. After that I 
 can start the server and do some things with, but not all things worked 
 properly.

 Sometime I bekome errors like this:


 error:  Can't call method Scrips on an undefined value at 
 /opt/rt3/share/html/Ticket/Elements/PreviewScrips line 49.
 context:
 ...
 45:
 46: my @non_recipients = $TicketObj-SquelchMailTo;
 47: /%init
 48: h2|/lThis message will be sent to...//h2
 49: i|/l(Check boxes to disable notifications to the listed 
 recipients)//ibr
 50: % foreach my $scrip (@{$Object-Scrips-Prepared}) {
 51: % next unless $scrip-ActionObj-Action-isa('RT::Action::SendEmail');
 52: b%$scrip-Description%/bbr
 53: |/l, $scrip-ConditionObj-Name, $scrip-ActionObj-Name, 
 $scrip-TemplateObj-Name[_1] [_2] with template [_3]/
 ...
 code stack: /opt/rt3/share/html/Ticket/Elements/PreviewScrips:49
 g /opt/rt3/local/html/Ticket/Update.html:113
 g /opt/rt3/share/html/autohandler:199
 g
 raw error



 thanks for any idea !!!


 Doukkali


 ___
 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] Connect Failed Too many connections

2008-06-05 Thread Sean
Hi,
Been running RT for almost 2 years w/o incident, and NEVER had this problem 
before.
Came in this morning to people saying they couldn't log into RT. I look in the 
apache error log and see:
[Thu Jun 05 09:48:59 2008] [error] [client xxx.xxx.xxx.xxx] Connect Failed Too 
many connections\n at /opt/rt3/lib/RT.pm line 220\n
DBI connect('dbname=rt3;host=localhost','rt_user',...) failed: Too many 
connections at /usr/lib/perl5/site_perl/5.8.8/DBIx/SearchBuilder/Handle.pm line 
106

I had made a change to resolv.conf the previous day to address a mail problem 
we had (which had caused
a lot of emails to back up) but as of 12:30am today (8 hours before the error 
cropped up) RT was working
fine, and I was getting emails. so something happened overnight. 
Like i said, never had this problem, don't know what could have caused it, and 
don't know what I can do to prevent it.
[EMAIL PROTECTED] DBIx]# rpm -qa | grep -i dbi
libdbi-drivers-0.8.1a-1.2.1
perl-DBI-1.50-2.2
libdbi-0.8.1-1.2.1
libdbi-dbd-mysql-0.8.1a-1.2.1
[EMAIL PROTECTED] DBIx]# rpm -qa | grep mysql
mysql-server-5.0.18-2.1
mysql-5.0.18-2.1
mysql-connector-odbc-3.51.12-1.2.1
libdbi-dbd-mysql-0.8.1a-1.2.1

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


Re: [rt-users] Connect Failed Too many connections

2008-06-05 Thread Drew Barnes
I would suggest upping *max*_*connections* in my.cnf since you are 
getting the Too many connections error from MySQL.


Sean wrote:
 Hi,
 Been running RT for almost 2 years w/o incident, and NEVER had this problem 
 before.
 Came in this morning to people saying they couldn't log into RT. I look in 
 the apache error log and see:
 [Thu Jun 05 09:48:59 2008] [error] [client xxx.xxx.xxx.xxx] Connect Failed 
 Too many connections\n at /opt/rt3/lib/RT.pm line 220\n
 DBI connect('dbname=rt3;host=localhost','rt_user',...) failed: Too many 
 connections at /usr/lib/perl5/site_perl/5.8.8/DBIx/SearchBuilder/Handle.pm 
 line 106

 I had made a change to resolv.conf the previous day to address a mail problem 
 we had (which had caused
 a lot of emails to back up) but as of 12:30am today (8 hours before the error 
 cropped up) RT was working
 fine, and I was getting emails. so something happened overnight. 
 Like i said, never had this problem, don't know what could have caused it, 
 and don't know what I can do to prevent it.
 [EMAIL PROTECTED] DBIx]# rpm -qa | grep -i dbi
 libdbi-drivers-0.8.1a-1.2.1
 perl-DBI-1.50-2.2
 libdbi-0.8.1-1.2.1
 libdbi-dbd-mysql-0.8.1a-1.2.1
 [EMAIL PROTECTED] DBIx]# rpm -qa | grep mysql
 mysql-server-5.0.18-2.1
 mysql-5.0.18-2.1
 mysql-connector-odbc-3.51.12-1.2.1
 libdbi-dbd-mysql-0.8.1a-1.2.1

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

-- 
Drew Barnes
Applications Analyst
Network Resources Department
Raymond Walters College
University of Cincinnati

___
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] Move Tickets from one instance to another

2008-06-05 Thread Forrest Blount
I'm in an interesting situation and have been scouring the wiki and threads
to find an answer, all to no avail.

My organization has a main RT instance (3.6.4, everything working smoothly)
and a secondary instance (3.4.5) which was set up for a small subset of our
users.  The employee who configured the smaller instance has left the
company, and in the interest of streamlining things, we'd like to combine it
into our larger instance.  All of the queues, cfs, scrips, templates were
easy enough to move over (there really weren't that many) but the group
using the instance would also like their 600+ tickets moved to the new
instance.  To make things more interesting, most of these tickets have at
least one file attachment.

I put together a scrip and template in the small instance that will email
all of the ticket information (comments, correspondence and field
attributes), but I can't manage to get it to attach the files and send those
out as well.  The idea behind this approach is that I can have one instance
mail the other, thereby avoiding any issue with conflicting IDs-- once the
email reaches the primary instance I'll have a scrip decode and apply the
fields...

Has anyone attempted to merge a smaller instance into a larger one?  Does
anyone have a scrip/template that will send whole files out as attachments?

Thanks in advance for any help/input!

Forrest
___
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] Including RTFM uploaded file in ticket causes a System Error

2008-06-05 Thread Kevin Falcone
WOuld you mind sending this into [EMAIL PROTECTED]
but including your RT versions, RTFM versions and some
information about the Custom FIelds your using?

We don't currently handle adding attachments to tickets
that are stored in RTFM articles, but it shouldn't throw
this error.

-kevin

On Jun 4, 2008, at 8:19 PM, Kimberly McKinnis wrote:

 Whoops. I guess I just had to create the proper custom field. My  
 bad, I’m new to RTFM.

 However, I’m now having trouble including uploaded files into  
 tickets. When I search on an article, put it into the “Include RTFM  
 article” box, click Go, it updates the text of the ticket. But when  
 I click Submit, I receive the following error. Any hints would be  
 appreciated.

 error:
 RT::FM::Article::_UpdateTimeTaken Unimplemented in RT::Record. (/usr/ 
 lib/rt/RT/Record.pm line 1462)
 context:
 ...

 492:
 else {
 493:
 my ( $package, $filename, $line );
 494:
 ( $package, $filename, $line ) = caller;
 495:

 496:
 die $AUTOLOAD Unimplemented in $package. ($filename line $line) \n;
 497:
 }
 498:

 499:
 }
 500:

 ...

 code stack:
 /usr/lib/perl5/site_perl/5.8.5/DBIx/SearchBuilder/Record.pm:496
 /usr/lib/rt/RT/Record.pm:1462
 /usr/lib/rt/RT/Ticket_Overlay.pm:2641
 /usr/lib/rt/RT/Ticket_Overlay.pm:2557
 /usr/lib/rt/RT/Interface/Web.pm:1496
 /usr/lib/rt/RT/Interface/Web.pm:1446
 /var/rt/html/Ticket/Display.html:145
 /var/rt/html/Ticket/Update.html:214
 /var/rt/html/autohandler:215
 raw error

 RT::FM::Article::_UpdateTimeTaken Unimplemented in RT::Record. (/usr/ 
 lib/rt/RT/Record.pm line 1462)


 Trace begun at /usr/lib/perl5/site_perl/5.8.5/HTML/Mason/ 
 Exceptions.pm line 129
 HTML 
 ::Mason 
 ::Exceptions::rethrow_exception('RT::FM::Article::_UpdateTimeTaken  
 Unimplemented in RT::Record. (/usr/lib/rt/RT/Record.pm line 1462)  
 ^J') called at /usr/lib/perl5/site_perl/5.8.5/DBIx/SearchBuilder/ 
 Record.pm line 496
 DBIx 
 ::SearchBuilder::Record::AUTOLOAD('RT::FM::Article=HASH(0xae7f040)',  
 0) called at /usr/lib/rt/RT/Record.pm line 1462
 RT::Record::_NewTransaction('RT::FM::Article=HASH(0xae7f040)',  
 'Type', 'AddLink', 'Field', 'ReferredToBy', 'NewValue', 'fsck.com- 
 rt://squee.tivo.com/ticket/7', 'ActivateScrips', '', 'TimeTaken', 0)  
 called at /usr/lib/rt/RT/Ticket_Overlay.pm line 2641
 RT::Ticket::_AddLink('RT::Ticket=HASH(0xac738b8)', 'Silent', undef,  
 'Type', 'RefersTo', 'Target', 'fsck.com-rtfm://squee.tivo.com/ 
 article/1', 'Base', '') called at /usr/lib/rt/RT/Ticket_Overlay.pm  
 line 2557
 RT::Ticket::AddLink('RT::Ticket=HASH(0xac738b8)', 'Target',  
 'fsck.com-rtfm://squee.tivo.com/article/1', 'Type', 'RefersTo')  
 called at /usr/lib/rt/RT/Interface/Web.pm line 1496
 HTML::Mason::Commands::ProcessRecordLinks('RecordObj',  
 'RT::Ticket=HASH(0xac738b8)', 'ARGSRef', 'HASH(0xacc)') called  
 at /usr/lib/rt/RT/Interface/Web.pm line 1446
 HTML::Mason::Commands::ProcessTicketLinks('TicketObj',  
 'RT::Ticket=HASH(0xac738b8)', 'ARGSRef', 'HASH(0xacc)') called  
 at /var/rt/html/Ticket/Display.html line 145
 HTML::Mason::Commands::__ANON__('TicketObj',  
 'RT::Ticket=HASH(0xac738b8)', 'UpdateCc', '', 'RTFM-Include-Article- 
 Named', '', 'SubmitTicket', 'Update Ticket', 'Status', 'open', '7- 
 RefersTo', 'fsck.com-rtfm://squee.tivo.com/article/1',  
 'QuoteTransaction', 105, 'UpdateBcc', '', 'UpdateType', 'response',  
 'Action', 'Respond', 'Attach', '', 'id', 7, 'UpdateTimeWorked', '',  
 'RTFM_Content', '', 'UpdateSubject', 'test', 'Owner', 22,  
 'UpdateContent', '#1: SuperClustering^M^J--- 
 ^M^JSuper Clustering documentation^M^J^M^JAttachment:^M^J-- 
 ^M^JSuperClustering.pdf^M^J^M^JWikiText: ^M^J^M^JAttachments: ^M^J  
 [kmckinnis - Mon May 12 04:11:36 2008]:^M^J ^M^J test^M^J ^M^J',  
 'UpdateAttach', 1, 'DefaultStatus', 'open') called at /usr/lib/perl5/ 
 site_perl/5.8.5/HTML/Mason/Component.pm line 135
 HTML 
 ::Mason 
 ::Component 
 ::run('HTML::Mason::Component::FileBased=HASH(0xabc6204)',  
 'TicketObj', 'RT::Ticket=HASH(0xac738b8)', 'UpdateCc', '', 'RTFM- 
 Include-Article-Named', '', 'SubmitTicket', 'Update Ticket',  
 'Status', 'open', '7-RefersTo', 'fsck.com-rtfm://squee.tivo.com/ 
 article/1', 'QuoteTransaction', 105, 'UpdateBcc', '', 'UpdateType',  
 'response', 'Action', 'Respond', 'Attach', '', 'id', 7,  
 'UpdateTimeWorked', '', 'RTFM_Content', '', 'UpdateSubject', 'test',  
 'Owner', 22, 'UpdateContent', '#1:  
 SuperClustering^M^J---^M^JSuper Clustering  
 documentation^M^J^M^JAttachment:^M^J-- 
 ^M^JSuperClustering.pdf^M^J^M^JWikiText: ^M^J^M^JAttachments: ^M^J  
 [kmckinnis - Mon May 12 04:11:36 2008]:^M^J ^M^J test^M^J ^M^J',  
 'UpdateAttach', 1, 'DefaultStatus', 'open') called at /usr/lib/perl5/ 
 site_perl/5.8.5/HTML/Mason/Request.pm line 1255
 eval {...} at /usr/lib/perl5/site_perl/5.8.5/HTML/Mason/Request.pm  
 line 1249
 HTML::Mason::Request::comp(undef, undef, 'TicketObj',  
 'RT::Ticket=HASH(0xac738b8)', 'UpdateCc', '', 'RTFM-Include-Article- 
 Named', '', 

[rt-users] CLI question

2008-06-05 Thread Kenneth Crocker
To all RT users,


I wanted to know if I could use CLI to batch create a bunch of 
tickets with specified ticket numbers (for old tickets. The numbers 
would be WAY lower than currently used). The RT Essentials book mentions 
the ability to create/edit/show a ticket, but no specifics on how to 
create a whole bunch using a file or what delimiters those records in 
that file would need, etc. Does anyone know how to do this? Thanks in 
advance.


Kenn
LBNL

___
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] How to add a new status

2008-06-05 Thread Adrien Laurent
Hello Everyone,

I'm happy user of RT, and I would like to add a new status: testing
and create custom scrips about it. I have looked in the documentation
but I haven't found anything.
Any hint ?

Thanks,

Adrien
___
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] rtfm browse by topic permissions

2008-06-05 Thread Kimberly McKinnis
I recently installed RTFM 2.2.1, and I have granted group permissions by
article class. I then created a number of topics under each class. The
problem is that for some reason, users get a blank list under Browse by
topic. However, if I click on an article with a topic from the Overview
link, and then through to that topic, I can view the topic hierarchy.
I.e. the Topics menu gives me http://10.100.58.145/RTFM/Topics.html
with a blank list, and clicking through articles and onto their topics
gives me http://10.100.58.145/RTFM/Topics.html?id=8class=1 with a
hierarchy listing. 

 

I searched the mailing list archives, and didn't find much at all. The
RTFM online manual
(http://www.bestpractical.com/rtfm/rtfm-2.0-manual-v1.0.pdf) doesn't
appear to even mention topics. 

 

Am I missing something simple here?

 

 

 

 

 

 


 

___
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] Help with RT permissions

2008-06-05 Thread Tom Smith
Hi All,

I'm trying to configure permissions in RT so that everyone can see  
every queue but only see those tickets that they are listed as  
Requestor or Owner on.

If I assign the rights SeeQueue and ShowTicket to Privileged, they  
can see every queue and every ticket on the system. If I assign these  
same rights to Requestor (and remove them from Privileged), they  
can't see any of the queues and can see their tickets only if they  
search for them.

Ideally, I'd like everyone to be able to see every queue listed in  
the Quick search section of RT at a glance but only be able to  
see tickets that they Own or Requested.

Can anyone offer any help for achieving this?

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

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


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


Re: [rt-users] How to add a new status

2008-06-05 Thread Kenneth Crocker
Adrien,


You need to change your RT-SiteConfig.pm file. We have added several 
new statuses:

@ActiveStatus = ('new', 'pending rv', 'rq approvd', 'open', 'pending 
qa', 'qa approvd', 'st
alled') unless @ActiveStatus;

This line sets the status values considered active, meaning not 
closed, rejected, or resolved. Hope this helps.


Kenn
LBNL

On 6/5/2008 3:29 PM, Adrien Laurent wrote:
 Hello Everyone,
 
 I'm happy user of RT, and I would like to add a new status: testing
 and create custom scrips about it. I have looked in the documentation
 but I haven't found anything.
 Any hint ?
 
 Thanks,
 
 Adrien
 ___
 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] How to add a new status

2008-06-05 Thread Adrien Laurent
It works perfectly,

Thanks !

On Thu, Jun 5, 2008 at 8:20 PM, Kenneth Crocker [EMAIL PROTECTED] wrote:
 Adrien,


You need to change your RT-SiteConfig.pm file. We have added several
 new statuses:

 @ActiveStatus = ('new', 'pending rv', 'rq approvd', 'open', 'pending qa',
 'qa approvd', 'st
 alled') unless @ActiveStatus;

This line sets the status values considered active, meaning not
 closed, rejected, or resolved. Hope this helps.


 Kenn
 LBNL

 On 6/5/2008 3:29 PM, Adrien Laurent wrote:

 Hello Everyone,

 I'm happy user of RT, and I would like to add a new status: testing
 and create custom scrips about it. I have looked in the documentation
 but I haven't found anything.
 Any hint ?

 Thanks,

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






-- 
Adrien Laurent
CEO
514 284 2020 x 202
___
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] What's new with RT 3.8

2008-06-05 Thread chaim . rieger
Next time you show up in souther cal let me know, will get ya a cup of coffee. 

Thanx much for the great product.


Sent via BlackBerry from T-Mobile

-Original Message-
From: Jesse Vincent [EMAIL PROTECTED]

Date: Thu, 5 Jun 2008 22:18:13 
To:rt Users rt-users@lists.bestpractical.com
Subject: [rt-users] What's new with RT 3.8


So, this is mostly a short note to acknowledge the hard work of  
Emmanuel Lacour along with Ruslan, sunnavy, Shawn Moore, Alex Vandiver  
and Kevin Falcone.

Over the past few weeks, we've (they've) been hard at work to get RT  
3.8 ready for release. As part of that work, they've been going  
through the RT3 bug list. You can check it out by visiting http://rt3.fsck.com 
, Log in as guest with the password guest.  It's running a snapshot of  
RT 3.8 from earlier today.

There are currently 354 open tickets related to RT3. That includes  
bugs, feature requests, and the odd test ticket.

What's absolutely amazing is how many FEWER tickets there are than  
there were 3 weeks ago.

Since May 15, these guys have resolved 289 tickets in the RT3 queue.  
There have also been 267 commits to RT 3.8.

We're definitely into the home stretch.

But mostly, I just wanted to brag about how hard these guys are  
working :)

Best,
Jesse

___
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