[rt-users] RT with postfix
I have a system runing RT 3.6.1 with sendmail. For some reason i have to install postfix on it for that I have to deinstall sendmail. I want to know can RT run with postfix, if yes then wht changes do it need to tell rt to commuicate with postfix. Food fight? Enjoy some healthy debate in the Yahoo! Answers Food Drink QA. http://answers.yahoo.com/dir/?link=listsid=396545367 ___ 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] Statistics revisitation
I would like too thanks Marco - Original Message - From: Jared Hanks To: Roy El-Hames ; Mathew Snyder Cc: RT Users Sent: Sunday, January 21, 2007 12:51 AM Subject: RE: [rt-users] Statistics revisitation I would like this too. Thanks, Jared Hi Nick; Can you also send me a copy of this .. Regards; Roy Mathew Snyder wrote: I would love to have a copy of this. Mathew Nick Metrowsky wrote: Hi Everyone, Over the past year or so, I have made some customizations to RTx::Statistics for our site use. Some of these changes include: 1. Some logic changes, because some of the calculations in the web display did not match the spreadsheet (spreadsheet was correct). 2. On the Tickets per day per Queue reports, I show columns for Created, Resolved, Rejected, Stalled, Queue Depth and Time to Resolve. Queue Depth shows how many tickets are open or new in a particular queue on any given day in time. This change is in both the spreadsheet and the web display. 3. Based upon the Ticket per day Queue screen, I have written batch reports which can generate text based reports for one or many queues for any time period. I also have a script which can do the same thing to an MS Excel or OpenOffice Calc spreadsheet. 3. Not related to RTx::Statistics, but I also have taking the rt-remind.pl script and used that for generating reports to our technical teams. There were a few minor modifications, again for our site. If anyone is interested in anything I have, I will be glad to send you a copy. I know Kelly wanted to implement some of the items mentioned in this e-mail, based upon an e-mail conversation we had a while back. Finally, RTx::Statistics does work with RT 3.6.3, but you have to change the index.html file for Tickets per day per Queue (CallsQueueDay directory) as for some reason it does not like /Elements/TitleBox, but will work with /Elements/TitleBoxStart and /Elements/TitleBoxEnd. Nick - Nick Metrowsky Consulting System Administrator 303-684-4785 Office 303-684-4100 Fax [EMAIL PROTECTED] DigitalGlobe (r), An Imaging and Information Company http://www.digitalglobe.com - -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Kelly F. Hickel Sent: Wednesday, January 17, 2007 2:00 PM To: Jason Fenner; Mathew Snyder Cc: RT Users Subject: RE: [rt-users] Statistics revisitation You could copy me as well. I haven't had time to get back to this, although that might change a bit in the future. I'm also still open to assistant maintainers (or someone who wants to take it over completely). I have a number of contributed changes pending, but haven't had any time to look at them. ___ 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 -- Get free, personalized online radio with MSN Radio powered by Pandora. Try it! -- ___ 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
[rt-users] ticket creation failed
Hi all, i'm new to RT ...i'm tryng to configure mailgate .. I would like that the mails to postmaster automatically create tickets on RT I have added in /etc/alias this lines postmaster: |/etc/smrsh/rt-mailgate --queue Posta --action correspond --url http://my.rt.server/; postmaster: |/etc/smrsh/rt-mailgate --queue Posta --action comment --url http://my.rt.server/; A mail error message return me from RT_CorrespondAddressNotSet ticket creation failed On queue Posta i have set the correspond address, but the error message no change. postmaster should be defined as user on rt? it's no possible to use this field only as mail from i reicive email requests? thanks for helps Marco ___ 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 with postfix
Hello! we are operating rt with postfix without any problems. You don't have to change anything because postfix comes with a compatibilty binary named sendmail. My line in RT-SiteConfig: Set($MailCommand , 'sendmailpipe'); Set($SendmailArguments , -oi -t); Set($SendmailBounceArguments , '-f '); Set($UseFriendlyFromLine , 1); Set($UseFriendlyToLine , 1); Set($FriendlyToLineFormat, \%s of $RT::rtname Ticket #%s\:;); regards! ___ 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] vanished lines in rt 3.6.1 reply
Hello! I'm surprised that i got no further reaction on my bug report (#8114), I think that the issue I reported is major bug because in our environment these vanished lines (even if they are in db) means data loss. Is this something only our installation suffers? I also wrote a bug report. But the open bug pages seems to be out of service: http://rt3.fsck.com//NoAuth/Buglist.html or are there really no bugs ;-) regards! sven On Fri, 2007-01-12 at 16:58 +0100, Sven Sternberger wrote: Hello! I upgraded the perl module Text::Quoted to the version 1.8, but the problem is still the same I tried to track down the problem, it only happens when I made a reply to an transaction, a reply to the ticket is always ok. The weird thing is that sometimes the first reply is okay but in the second reply the new entered lines are vanished again (the lines from the first try are still visible) It is not the word cpan which triggers the problem, but anything in the form /^\w+/ (this is an regexp). I now recognized the following: I create a ticket with a line which something like /^\w+/ RESULT: ok I reply on these transaction and enter again /^\w+/ RESULT: ok I reply on the reply transaction with an /^\w+/ RESULT: the newly entered line vanish So it is pretty clear that the quote mechanism is broken if you have more than one reply level best regards! sven ___ 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] RT with postfix
Its Azfar [EMAIL PROTECTED] writes: I want to know can RT run with postfix Sure. if yes then wht changes do it need to tell rt to commuicate with postfix. None, I believe, unless there is something tricky with your sendmail installation. -- Leif Nixon -Systems expert National Supercomputer Centre- Linkoping University ___ 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] Exporting tickets from one RT to another
[EMAIL PROTECTED] writes: With that said, you would need to upgrade the schema on the 2nd database as well. Then do a database dump on the appropriate tables. Since you'll probably have duplicate ticket numbers, you would need to create new ticket numbers in the dumped database tables as well as remove the tickets you no longer want. I'd say you would probably have to do a lot more than that to make all references to users, queues, transactions, and so on, valid. My 1th ticket sits in queue 14 and was last updated by user 98. -- Leif Nixon -Systems expert National Supercomputer Centre- Linkoping University ___ 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] create child ticket
Following up my previous non-answered post. Are there any other tools out there that lets the user easily create a subticket, preferably in another thread? -- regards, Robin ___ 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 3.4.5 rpm yum install not working
Hi All, I have a big problem that I just can't work out. I'm running CentOS 4.4 (clean install). I first tried installing the latest rt3 tarball, but some of the perl mods kept failing via CPAN. So I looked for a RPM which I found instructions for on the bestpractical site and followed and installed successfully. I can login ok and everything comes up. Although when I click on Tools I get the following Can't locate object method new via package RT::Action::CreateTickets at /var/rt/html/Tools/Offline.html line 107. Trace begun at /usr/lib/perl5/site_perl/5.8.5/HTML/Mason/Exceptions.pm line 129 HTML::Mason::Exceptions::rethrow_exception('Can\'t locate object method new via package RT::Action::CreateTickets at /var/rt/html/Tools/Offline.html line 107.^J') called at /var/rt/html/Tools/Offline.html line 107 HTML::Mason::Commands::__ANON__ at /usr/lib/perl5/site_perl/5.8.5/HTML/Mason/Component.pm line 135 HTML::Mason::Component::run('HTML::Mason::Component::FileBased=HASH(0xb0608fc)') called at /usr/lib/perl5/site_perl/5.8.5/HTML/Mason/Request.pm line 1256 eval {...} at /usr/lib/perl5/site_perl/5.8.5/HTML/Mason/Request.pm line 1246 HTML::Mason::Request::comp(undef, undef, undef) called at /usr/lib/perl5/site_perl/5.8.5/HTML/Mason/Request.pm line 915 HTML::Mason::Request::call_next('HTML::Mason::Request::ApacheHandler=HASH(0xb0040f4)') called at /var/rt/html/autohandler line 215 HTML::Mason::Commands::__ANON__ at /usr/lib/perl5/site_perl/5.8.5/HTML/Mason/Component.pm line 135 HTML::Mason::Component::run('HTML::Mason::Component::FileBased=HASH(0xaf4a724)') called at /usr/lib/perl5/site_perl/5.8.5/HTML/Mason/Request.pm line 1251 eval {...} at /usr/lib/perl5/site_perl/5.8.5/HTML/Mason/Request.pm line 1246 HTML::Mason::Request::comp(undef, undef, undef) called at /usr/lib/perl5/site_perl/5.8.5/HTML/Mason/Request.pm line 460 eval {...} at /usr/lib/perl5/site_perl/5.8.5/HTML/Mason/Request.pm line 460 eval {...} at /usr/lib/perl5/site_perl/5.8.5/HTML/Mason/Request.pm line 412 HTML::Mason::Request::exec('HTML::Mason::Request::ApacheHandler=HASH(0xb0040f4)') called at /usr/lib/perl5/site_perl/5.8.5/HTML/Mason/ApacheHandler.pm line 168 HTML::Mason::Request::ApacheHandler::exec('HTML::Mason::Request::ApacheHandler=HASH(0xb0040f4)') called at /usr/lib/perl5/site_perl/5.8.5/HTML/Mason/ApacheHandler.pm line 826 HTML::Mason::ApacheHandler::handle_request('HTML::Mason::ApacheHandler=HASH(0xa5ba218)', 'Apache2::RequestRec=SCALAR(0xb002514)') called at /usr/bin/webmux.pl line 123 eval {...} at /usr/bin/webmux.pl line 123 RT::Mason::handler('Apache2::RequestRec=SCALAR(0xb002514)') called at -e line 0 eval {...} at -e line 0 Does anyone know what I'm done wrong and how to fix it? All hat I can think of is that when I started doing the install from tarball with 'make fixdeps' it left something that the rpm didn't like? Although the 'make fixdeps' failed really early.. Can anyone help, it be much appreciated? Matt___ 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] Notifying owner of new content
Hi Ervin; You need to look at NotifyActor in RT_Config or RT_SiteConfig However If I may suggest the idea of having multi users using the same login is not a good one .. Better if you have a queue for you group members and make a defined search for tickets in their queue .. Just an idea Good luck Roy Chance Ervin wrote: I have a situation where I have more than one person logging into the RT system as the same user. This is so this group of users can see what tickets are assigned to them. The issue appears to be that when the owner of that ticket updates the ticket, the content does not get sent back to the owner of the ticket. This means other users in that group do not see the update. Is there a way to force RT to email the owner of the ticket on each content update? Even if it is the owner himself who updates the ticket? I have tried adding scrips for this, but it does not appear to update the owner making the update in any case. Thank you. Chance Ervin Level II Support IT Manager Intelenet Communications = This message and any files or text attached to it are intended only for the recipients named above, and contain information that may be confidential or privileged. If you are not an intended recipient, you must not read, copy, use or disclose this communication. Please also notify the sender by replying to this message, and then delete all copies of it from your system. Thank you. ___ 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
[rt-users] RT 3.4.5 CustomField SortOrder
Hello, I have a problem in visualization order of ticket custom fields: I am able to sort custom fields in the queue configuration page and the content of objectcustomfields table is correct according to sort order defined. In ticket display page otherwise, the custom fields order is wrong. I have RT version 3.4.5 on suse linux 10, perl 5.8.8, Oracle9i Enterprise Edition Release 9.2.0.7.0, DBIx::SearchBuilder v1.45. Can someone help me? thanks CONFIDENTIALITY NOTICE This message and its attachments (if any) may contain confidential, proprietary or legally privileged information and it is intended only for the use of the addressee named above. No confidentiality or privilege is waived or lost by any mistransmission. If you are not the intended recipient of this message you are hereby notified that you must not use, disseminate, copy it in any form or take any action in reliance on it. If you have received this message in error, please, delete it (and any copies of it) and kindly inform the sender, of this e-mail, by replying or go to www.pirelli.com on contact us. ___ 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] create child ticket
When you create a new ticket, you can click on 'show details' and enter a ticket number for Depends on. This isn't as nice as a button that says create child ticket though. Robin Ericsson wrote: Following up my previous non-answered post. Are there any other tools out there that lets the user easily create a subticket, preferably in another thread? ___ 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] Headers/ Emails out of RT
Hi there; The system is rt-3.6.1/mysql 5/apache2/exim/mod_perl2 Is there a way to change the Sender tag in emails out of RT to be the queue address instead from the default apache user .. any one any ideas?? the From tag is set correctly as the queue address however the Sender tag is always defaulting to apache user also how safe ist to remove the RT-Originator mail header, I can't see the purpose of it and the staff here do not wish their mail addresses in the mail headers .. Any pointers would be appreciated. Regards; Roy ___ 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.4.5 rpm yum install not working
Matthew Simpson wrote: Hi All, I have a big problem that I just can't work out. I'm running CentOS 4.4 (clean install). I first tried installing the latest rt3 tarball, but some of the perl mods kept failing via CPAN. So I looked for a RPM which I found instructions for on the bestpractical site and followed and installed successfully. I can login ok and everything comes up. Although when I click on Tools I get the following Can't locate object method new via package RT::Action::CreateTickets at /var/rt/html/Tools/Offline.html line 107. Trace begun at /usr/lib/perl5/site_perl/5.8.5/HTML/Mason/Exceptions.pm line 129 HTML::Mason::Exceptions::rethrow_exception('Can\'t locate object method new via package RT::Action::CreateTickets at /var/rt/html/Tools/Offline.html line 107.^J') called at /var/rt/html/Tools/Offline.html line 107 HTML::Mason::Commands::__ANON__ at /usr/lib/perl5/site_perl/5.8.5/HTML/Mason/Component.pm line 135 HTML::Mason::Component::run('HTML::Mason::Component::FileBased=HASH(0xb0608fc)') called at /usr/lib/perl5/site_perl/5.8.5/HTML/Mason/Request.pm line 1256 eval {...} at /usr/lib/perl5/site_perl/5.8.5/HTML/Mason/Request.pm line 1246 HTML::Mason::Request::comp(undef, undef, undef) called at /usr/lib/perl5/site_perl/5.8.5/HTML/Mason/Request.pm line 915 HTML::Mason::Request::call_next('HTML::Mason::Request::ApacheHandler=HASH(0xb0040f4)') called at /var/rt/html/autohandler line 215 HTML::Mason::Commands::__ANON__ at /usr/lib/perl5/site_perl/5.8.5/HTML/Mason/Component.pm line 135 HTML::Mason::Component::run('HTML::Mason::Component::FileBased=HASH(0xaf4a724)') called at /usr/lib/perl5/site_perl/5.8.5/HTML/Mason/Request.pm line 1251 eval {...} at /usr/lib/perl5/site_perl/5.8.5/HTML/Mason/Request.pm line 1246 HTML::Mason::Request::comp(undef, undef, undef) called at /usr/lib/perl5/site_perl/5.8.5/HTML/Mason/Request.pm line 460 eval {...} at /usr/lib/perl5/site_perl/5.8.5/HTML/Mason/Request.pm line 460 eval {...} at /usr/lib/perl5/site_perl/5.8.5/HTML/Mason/Request.pm line 412 HTML::Mason::Request::exec('HTML::Mason::Request::ApacheHandler=HASH(0xb0040f4)') called at /usr/lib/perl5/site_perl/5.8.5/HTML/Mason/ApacheHandler.pm line 168 HTML::Mason::Request::ApacheHandler::exec('HTML::Mason::Request::ApacheHandler=HASH(0xb0040f4)') called at /usr/lib/perl5/site_perl/5.8.5/HTML/Mason/ApacheHandler.pm line 826 HTML::Mason::ApacheHandler::handle_request('HTML::Mason::ApacheHandler=HASH(0xa5ba218)', 'Apache2::RequestRec=SCALAR(0xb002514)') called at /usr/bin/webmux.pl line 123 eval {...} at /usr/bin/webmux.pl line 123 RT::Mason::handler('Apache2::RequestRec=SCALAR(0xb002514)') called at -e line 0 eval {...} at -e line 0 Does anyone know what I'm done wrong and how to fix it? All hat I can think of is that when I started doing the install from tarball with 'make fixdeps' it left something that the rpm didn't like? Although the 'make fixdeps' failed really early.. Can anyone help, it be much appreciated? Does 'make fixdeps' still fail if you run it? Jason Matt ___ 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
[rt-users] Outgoing email - comment
Hi I have been using RT for Windows for a few months and have decided to now move to a Linux platform as it offers more flexibility I have installed 3.6.3 and I can create tickets and it will email me to my company email address which is on an exchange box. However, when I comment or reply to a ticket, then no emails are sent to the AdminsCcs or Ccs. It always worked on my Windows version Any help would be greatly appreciated Thanks in advance ___ 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] Outgoing email - comment
You need to make sure the proper scripts have been added either to the global or queue-specific 'scrips' list. It's been a long time since I setup RT from scratch, but I believe by default, CC's are not emailed when making a comment. Either way, you need to make sure that you have 'On Comment' and 'On Correspond' (aka reply) scrips set globally or queue-specifically in order to send email to the proper parties (CC's, AdminCC's, Requestors, Other Recipients, etc). James Moseley Nicholas Whitehead Nicholas.Whitehe To [EMAIL PROTECTED] rt-users@lists.bestpractical.com Sent by: cc rt-users-bounces@ lists.bestpractic Subject al.com[rt-users] Outgoing email - comment 01/22/2007 10:11 AM Hi I have been using RT for Windows for a few months and have decided to now move to a Linux platform as it offers more flexibility I have installed 3.6.3 and I can create tickets and it will email me to my company email address which is on an exchange box. However, when I comment or reply to a ticket, then no emails are sent to the AdminsCcs or Ccs. It always worked on my Windows version Any help would be greatly appreciated Thanks in advance ___ 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
[rt-users] Help with RT CLI
Is there way to to show the first transaction of a ticket in CLI, given the ticket id? This is how I do it manually ./rt show ticket/356750/attachments/ id: ticket/356750/attachments Attachments: 904948: (multipart/alternative / 0b), 904949: (text/plain / 4.4k), 904950: (text/html / 13.3k), 904951: (text/plain / 7.2k) ./rt show ticket/356750/attachments/904949 (I picked the second attachment since first one is 0 byte) However sometimes the first attachment has the first transaction. Thanks -- Asif Iqbal PGP Key: 0xE62693C5 KeyServer: pgp.mit.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
[rt-users] Take in 'N newest unowned tickets' display
Hi, I've created my own N newest unowned tickets search, but my Take column displays the id, instead of the word Take. How can I make it say Take instead? ...thnx, ...dave -- Dave Alden The Ohio State University Department of Mathematics ___ 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] remove summary from 'RT at a glance'
Hi, I've removed everything from the summary part of 'RT at a glance', but my body part is still skinny (there's lots of wasted white space on the right hand of my screen, and my Subject's are going onto a second line). Ideas? ...dave -- Dave Alden The Ohio State University Department of Mathematics ___ 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 and RTFM 2.2.0RC4 - how to create custom fields?
Hmm - that's exactly what mine doesn't have ... PK -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Bob Goldstein Sent: Sunday, January 21, 2007 8:13 PM To: Philip Kime Cc: rt-users@lists.bestpractical.com Subject: Re: [rt-users] RT-3.6.3 and RTFM 2.2.0RC4 - how to create custom fields? In my RT: RTFM - Configuration - Custom Fields (under the RTFM heading) - New Custom Field Then, the applies to contains RTFM articles as well as other entries. bobg This is a multi-part message in MIME format. --===1572521251== Content-class: urn:content-classes:message Content-Type: multipart/alternative; boundary=_=_NextPart_001_01C73DC9.B350C1E5 This is a multi-part message in MIME format. --_=_NextPart_001_01C73DC9.B350C1E5 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: quoted-printable I can't see how to create Custom Fields for RTFM 2.2.0RC4 and RT-3.6.3? If I select New custom field, it sends me to the usual custom field creation page (/Admin/CustomFields/Modify.html?Create=3D1) and there is nothing like article or RTFM class or whatever in the Applies to drop-down - just the usual =20 Tickets Groups Users Assets Ticket Transactions =20 Should I be seeing somthing else? This is a fresh install of RTFM, no previous version. =20 PK =20 -- Philip Kime NOPS Systems Architect 310 401 0407 =20 --_=_NextPart_001_01C73DC9.B350C1E5 Content-Type: text/html; charset=US-ASCII Content-Transfer-Encoding: quoted-printable !DOCTYPE HTML PUBLIC -//W3C//DTD HTML 4.0 Transitional//EN HTMLHEAD META http-equiv=3DContent-Type content=3Dtext/html; = charset=3Dus-ascii META content=3DMSHTML 6.00.5730.11 name=3DGENERATOR/HEAD BODY DIVFONT face=3DArial size=3D2SPAN class=3D232420202-22012007I = can't see how to=20 create Custom Fields for RTFM 2.2.0RC4 and RT-3.6.3? If I select New = custom=20 field, it sends me to the usual custom field creation page=20 (/Admin/CustomFields/Modify.html?Create=3D1) and there is nothing like = article=20 or RTFM class or whatever in the Applies to drop-down - just the=20 usual/SPAN/FONT/DIV DIVFONT face=3DArial size=3D2SPAN=20 class=3D232420202-22012007/SPAN/FONTnbsp;/DIV DIVFONT face=3DArial size=3D2SPAN=20 class=3D232420202-22012007Tickets/SPAN/FONT/DIV DIVFONT face=3DArial size=3D2SPAN=20 class=3D232420202-22012007Groups/SPAN/FONT/DIV DIVFONT face=3DArial size=3D2SPAN=20 class=3D232420202-22012007Users/SPAN/FONT/DIV DIVFONT face=3DArial size=3D2SPAN=20 class=3D232420202-22012007Assets/SPAN/FONT/DIV DIVFONT face=3DArial size=3D2SPAN class=3D232420202-22012007Ticket = Transactions/SPAN/FONT/DIV DIVFONT face=3DArial size=3D2SPAN=20 class=3D232420202-22012007/SPAN/FONTnbsp;/DIV DIVFONT face=3DArial size=3D2SPAN = class=3D232420202-22012007nbsp;Should I be=20 seeing somthing else? This is a fresh install of RTFM, no previous=20 version./SPAN/FONT/DIV DIVFONT face=3DArial size=3D2SPAN=20 class=3D232420202-22012007/SPAN/FONTnbsp;/DIV DIVFONT face=3DArial size=3D2SPAN=20 class=3D232420202-22012007PK/SPAN/FONT/DIV DIVnbsp;/DIV DIV align=3DleftFONT face=3DArial size=3D2--/FONT/DIV DIV align=3DleftFONT face=3DArial size=3D2Philip Kime/FONT/DIV DIV align=3DleftFONT face=3DArial size=3D2NOPS Systems = Architect/FONT/DIV DIV align=3DleftFONT face=3DArial size=3D2310 401 0407/FONT/DIV DIVnbsp;/DIV/BODY/HTML --_=_NextPart_001_01C73DC9.B350C1E5-- --===1572521251== Content-Type: text/plain; charset=us-ascii MIME-Version: 1.0 Content-Transfer-Encoding: 7bit Content-Disposition: inline ___ 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 --===1572521251==-- ___ 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] Performance-Bug in SelfService when updated from 3.6.1 to 3.6.3
Hello, I recently upgraded our test system from 3.6.1 to 3.6.3 and I observed a performance problem in SelfService which is new. SelfService/index.html takes more than 15 minutes to load on our server where RT. I tracked this issue down to a change in SelfService/Elements/MyRequest. In 3.6.1 and before SelfService only searched for Tickets of which the User is requestor. In 3.6.3 it searches for Tickets where user ist Requestor, AdminCc or Cc of. This search is not well performed by my mysql db server (Ver 12.22 Distrib 4.0.24, for pc-linux-gnu (i386)) as reported by me in other tickets before. I changed SelfService/Elements/MyRequest only to include Tickets with requestor and the page is performing well again. All indexes are as specified by the default installation. I tested some additional indexes whithout any success. Is this a known issue only applying to mysql? Only to mysql 4? Or why does no others report this error? Here is the query and the explaination: # Query_time: 805 Lock_time: 0 Rows_sent: 1 Rows_examined: 204821648 SELECT COUNT(DISTINCT main.id) FROM (Tickets main JOIN Groups Groups_4 ON ( Groups_4.Instance = main.id)) JOIN Groups Groups_7 ON ( Groups_7.Instance = main.id)) LEFT JOIN CachedGroupMembers CachedGroupMembers_5 ON ((CachedGroupMembers_5.GroupId != CachedGroupMembers_5.MemberId)) AND ( CachedGroupMembers_5.GroupId = Groups_4.id)) JOIN Groups Groups_1 ON ( Groups_1.Instance = main.id)) LEFT JOIN CachedGroupMembers CachedGroupMembers_8 ON ( CachedGroupMembers_8.GroupId = Groups_7.id) AND ( (CachedGroupMembers_8.GroupId != CachedGroupMembers_8.MemberId))) LEFT JOIN Users Users_6 ON ( Users_6.id = CachedGroupMembers_5.MemberId)) LEFT JOIN Users Users_9 ON ( Users_9.id = CachedGroupMembers_8.MemberId)) LEFT JOIN CachedGroupMembers CachedGroupMembers_2 ON ( CachedGroupMembers_2.GroupId = Groups_1.id) AND ( (CachedGroupMembers_2.GroupId != CachedGroupMembers_2.MemberId))) LEFT JOIN Users Users_3 ON ( Users_3.id = CachedGroupMembers_2.MemberId)) WHERE ((Groups_1.Domain = 'RT::Ticket-Role')) AND ((Groups_1.Type = 'Requestor')) AND ((Groups_4.Domain = 'RT::Ticket-Role')) AND ((Groups_4.Type = 'Cc')) AND ((Groups_7.Domain = 'RT::Ticket-Role')) AND ((Groups_7.Type = 'AdminCc')) AND ((main.EffectiveId = main.id)) AND ((main.Status != 'deleted')) AND ((main.Type = 'ticket')) AND ( ( ( (Users_3.EmailAddress = '') ) OR ( (Users_6.EmailAddress = '') ) OR ( (Users_9.EmailAddress = '') ) ) AND ( (main.Status = 'open') OR (main.Status = 'new') OR (main.Status = 'stalled') ) ); +--++-++-+---+---+--+ | table| type | possible_keys | key| key_len | ref | rows | Extra| +--++-++-+---+---+--+ | Groups_1 | ref| Groups1,Groups2 | Groups2| 65 | const | 51330 | Using where | | main | eq_ref | PRIMARY | PRIMARY| 4 | Groups_1.Instance | 1 | Using where | | Groups_7 | ref| Groups1,Groups2 | Groups1| 65 | const | 72594 | Using where; Using index | | CachedGroupMembers_8 | ref| DisGrouMem | DisGrouMem | 5 | Groups_7.id | 1 | Using index | | Groups_4 | ref| Groups1,Groups2 | Groups1| 65 | const | 72594 | Using where; Using index | | CachedGroupMembers_5 | ref| DisGrouMem | DisGrouMem | 5 | Groups_4.id | 1 | Using index | | Users_6 | eq_ref | PRIMARY | PRIMARY| 4 | CachedGroupMembers_5.MemberId | 1 | | | Users_9 | eq_ref | PRIMARY | PRIMARY| 4 | CachedGroupMembers_8.MemberId | 1 | | | CachedGroupMembers_2 | ref| DisGrouMem | DisGrouMem | 5 | Groups_1.id | 1 | Using index | | Users_3 | eq_ref | PRIMARY | PRIMARY| 4 | CachedGroupMembers_2.MemberId | 1 | Using where | +--++-++-+---+---+--+ 10 rows in set (0.05 sec) Regards, Dirk. -- Dr. Dirk Pape (eAS - Projektleitung Campus Management) Freie Universitaet Berlin Grunewaldstr. 34a, 12165 Berlin Tel. +49 (0)30 838 75143, Fax. +49 (0)30 838 54654 ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial