Re: [rt-users] RT Migration
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
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
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
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
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
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
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
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
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
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
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
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