Re: [rt-users] Self service and user preferences
On Tue, Jan 22, 2008 at 09:40:19PM +0200, GUBBELS Jac wrote: > Hi, > I am implementing RT in a bilingual setting. The users of the self service > are either Turkish or English speaking. I want these users to be able to > choose their favorite language. Adding the 'ModifySelf' right to > unpriviledged users only gives them the opportunity to change their password > (something undesired actually in our situation). Do I overlook a user-right? > Is there a simple hack to the ...RT.../SelfService/Prefs.html that will solve > my problem? > Thanks a lot! > -- Jac One option is simply to let the user's browser determine it for you. If the user has set a preference for languages in their browser's config RT will just start with that. Jesse > PS: Thanks also for the help on my previous request! Hopefully I will be able > to contribute soon 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 -- ___ 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] Self service and user preferences
Hi, I am implementing RT in a bilingual setting. The users of the self service are either Turkish or English speaking. I want these users to be able to choose their favorite language. Adding the 'ModifySelf' right to unpriviledged users only gives them the opportunity to change their password (something undesired actually in our situation). Do I overlook a user-right? Is there a simple hack to the ...RT.../SelfService/Prefs.html that will solve my problem? Thanks a lot! -- Jac PS: Thanks also for the help on my previous request! Hopefully I will be able to contribute soon 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
Re: [rt-users] Oracle 9 and Build.html performance
On Tue, Jan 22, 2008 at 03:26:18PM +0100, Joop wrote: > Emmanuel Lacour wrote: > > > I tried both and with compute I get better results than estimate. Have a I just did the same, on oracle 9 it divides the by 2 :) Thanks very much! > look at the docs to see other options of analyze and with atleast Oracle > 10g it is recommended to use DBMS_STATS.GATHER_SCHEMA_STATS or one of > its relatives. It has the possibility to keep the compute timewise > within bays. My VM took about 1min to analyze the whole schema and it > does so each morning at 6:00 am so noone is bothered by it. > I will look deeper in those options... ___ 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] mysql2pg
Hey there, is this Howto suitable for 3.6.3? https://www.safernet.org.br/twiki/bin/view/Colaborar/RT_MySQL2Pg (from: http://wiki.bestpractical.com/view/MySQLToPg) Best regards, joey ___ 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] suppressing email generated by script to import tickets from another ticketing system
Tom H wrote: I have a script which imports tickets from another system using something like; Given I'm probably about to write something similar, I'd be interested in any script that you've come up with to do this... We're in the process of merging two RT systems, and there seems to be little to no code out there for doing this as it stands... I was going to create the tickets through the RT interface (having dropped most of it into an XML file. Then copy most of the Transaction, Link and Attachment data with a little munging directly from one DB into the other. It was decided that things like User and Group history weren't required, and the donor RT server had nothing interesting with regards templates or custom fields Mark -- Mark Chappell Unix Systems Administrator ___ 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-announce] Correction: RT 3.6.6 now available.
This is what I get for basing a release announcement on the annoucement for the Release Candidate. RT 3.6.6 FINAL is now availabe. And rest assured that I'm not getting on a plane or wandering off for vacation in the near future. Sorry for any confusion. Best, Jesse On Tue, Jan 22, 2008 at 12:11:58PM -0500, Jesse Vincent wrote: > I've just rolled a second rc of RT 3.6.6. It would likely be 3.6.6, but > I'm about to run away to Portugal for a week's holiday and big releases > right before one leaves on vacation are...not always the right call ;) > > Do note that this release of RT adds a dependency on CSS::Squish to help > improve display performance. As a reminder, you should always "make > testdeps" before installing a new release of RT. > > http://download.bestpractical.com/pub/rt/release/rt-3.6.6r.tar.gz > http://download.bestpractical.com/pub/rt/release/rt-3.6.6tar.gz.sig > > MD5 Sums: > b626c906e7b33c8d1879c15ed744f7e3 rt-3.6.6.tar.gz > f03cd392cee84905d38de36788391a30 rt-3.6.6.tar.gz.sig > > > > > Fixes: > * missing found by Steve Turner > * Sort Templates, Actions and Conditions by Name, > as suggested by Steve Turner > * ACL queries have been split apart into more small queries, which > leads to more effective caching _and_ has better performance > characteristics on MySQL 5.x > > Translations: > * Updated french translation from Emmanuel Lacour > * Massive internationalization fixes > * Full translation of zh_tw and zh_cn from Audrey Tang > > Tests: >* Add more tests on sorting by CF > > API: > * new callbacks in Simple Search > * Allow the caller of Googleish searches to choose what > queues go into the query > * Add an optional Clear button to SelectionBox > * Add a NoArrows option to selectionbox, > for when order doesn't matter > > Web Interface: > * A change to session handling that should improve stability with > File, Oracle and SQLite session stores. > * CSS and javascript files should be better cached on the client > * CSS files are now concatenated and squished to cut down on the > number of initial HTTP requests. > -- ___ RT-Announce mailing list [EMAIL PROTECTED] http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-announce ___ 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] CSS Changes in 3.6.5
fetch changes to the css dir from our svn server using either web interface or svn client. On Jan 22, 2008 8:24 PM, Sean <[EMAIL PROTECTED]> wrote: > Hi, > > I use RT 3.6.4 with Internet explorer. I have a problem where the text jumps > down a couple > pixels on a page. > > I read in the release notes for 3.6.5: > * reverted CSS changes causing problems in IE browser > > Im not really keen on upgrading my entire RT to 3.6.5, so, have the CSS > changes been isolated (or can they be) so that I can just fix the specific > CSS problem? > > Thanks, > Jeff > > > > > Be a better friend, newshound, and > know-it-all with Yahoo! Mobile. Try it now. > http://mobile.yahoo.com/;_ylt=Ahu06i62sR8HDtDypao8Wcj9tAcJ > > ___ > 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] CSS Changes in 3.6.5
Hi, I use RT 3.6.4 with Internet explorer. I have a problem where the text jumps down a couple pixels on a page. I read in the release notes for 3.6.5: * reverted CSS changes causing problems in IE browser Im not really keen on upgrading my entire RT to 3.6.5, so, have the CSS changes been isolated (or can they be) so that I can just fix the specific CSS problem? Thanks, Jeff Be a better friend, newshound, and know-it-all with Yahoo! Mobile. Try it now. http://mobile.yahoo.com/;_ylt=Ahu06i62sR8HDtDypao8Wcj9tAcJ ___ 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-announce] RT 3.6.6 now available.
I've just rolled a second rc of RT 3.6.6. It would likely be 3.6.6, but I'm about to run away to Portugal for a week's holiday and big releases right before one leaves on vacation are...not always the right call ;) Do note that this release of RT adds a dependency on CSS::Squish to help improve display performance. As a reminder, you should always "make testdeps" before installing a new release of RT. http://download.bestpractical.com/pub/rt/release/rt-3.6.6r.tar.gz http://download.bestpractical.com/pub/rt/release/rt-3.6.6tar.gz.sig MD5 Sums: b626c906e7b33c8d1879c15ed744f7e3 rt-3.6.6.tar.gz f03cd392cee84905d38de36788391a30 rt-3.6.6.tar.gz.sig Fixes: * missing found by Steve Turner * Sort Templates, Actions and Conditions by Name, as suggested by Steve Turner * ACL queries have been split apart into more small queries, which leads to more effective caching _and_ has better performance characteristics on MySQL 5.x Translations: * Updated french translation from Emmanuel Lacour * Massive internationalization fixes * Full translation of zh_tw and zh_cn from Audrey Tang Tests: * Add more tests on sorting by CF API: * new callbacks in Simple Search * Allow the caller of Googleish searches to choose what queues go into the query * Add an optional Clear button to SelectionBox * Add a NoArrows option to selectionbox, for when order doesn't matter Web Interface: * A change to session handling that should improve stability with File, Oracle and SQLite session stores. * CSS and javascript files should be better cached on the client * CSS files are now concatenated and squished to cut down on the number of initial HTTP requests. ___ RT-Announce mailing list [EMAIL PROTECTED] http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-announce ___ 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] Email notification On Resolve if CF value is
On Tue, Jan 22, 2008 at 01:40:43PM -0300, [EMAIL PROTECTED] wrote: > Hi guys, > > We are looking for a script that triggers and email notification to an > address if a Ticket is resolve with a CF specific value. > > CF name is "Billable", and status will be "YES". > > Anyone deal with this request? > Not exactly, but it would be easy for you to do it after reading some examples on the wiki: http://wiki.bestpractical.com/view/Contributions maybe OnResolveOnce + OnCustomFieldValueChange ___ 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] Email notification On Resolve if CF value is
Hi guys, We are looking for a script that triggers and email notification to an address if a Ticket is resolve with a CF specific value. CF name is "Billable", and status will be "YES". Anyone deal with this request? Many 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] Very troubling error
In addition to all of this we are not longer getting any emails into the
database. Postfix and procmail are handling things as they have been but
nothing is being entered into the DB
Keep up with me and what I'm up to: http://theillien.blogspot.com
Ruslan Zakirov wrote:
> Upgrade to the latest version of DBIx::SearchBuilder module.
>
> On Jan 22, 2008 1:46 AM, Mathew <[EMAIL PROTECTED]> wrote:
>> We recently started getting this error which seems to be preventing incoming
>> email from making it into the database:
>>
>> [Mon Jan 21 22:42:30 2008] [warning]: RT::Handle=HASH(0xadd9538) couldn't
>> execute the query 'SELECT DISTINCT main.* FROM ((Tickets main JOIN Groups
>> Groups_1 ON ((Groups_1.Domain = 'RT::Ticket-Role')) AND ( (Groups_1.Type =
>> 'Requestor')) AND ( Groups_1.Instance = main.id)) LEFT JOIN
>> CachedGroupMembers CachedGroupMembers_2 ON ( CachedGroupMembers_2.GroupId =
>> Groups_1.id) AND ( (CachedGroupMembers_2.MemberId = Users_3.id))) , Users
>> Users_3 WHERE ((Users_3.id = '60292')) AND ((main.EffectiveId = main.id))
>> AND ((main.Status != 'deleted')) AND ((main.Type = 'ticket')) AND ( (
>> (CachedGroupMembers_2.id IS NOT NULL) ) AND ( (main.Status = 'open') OR
>> (main.Status = 'new') ) ) ORDER BY main.Priority DESC LIMIT 10' at
>> /usr/lib/perl5/vendor_perl/5.8.8/DBIx/SearchBuilder/Handle.pm line 518
>>
>> DBIx::SearchBuilder::Handle::SimpleQuery('RT::Handle=HASH(0xadd9538)',
>> 'SELECT DISTINCT main.* FROM ((Tickets main JOIN Groups Group...') called
>> at /usr/lib/perl5/vendor_perl/5.8.8/DBIx/SearchBuilder.pm line 231
>> DBIx::SearchBuilder::_DoSearch('RT::Tickets=HASH(0xb59cf20)') called
>> at /usr/lib/perl5/vendor_perl/5.8.8/DBIx/SearchBuilder.pm line 491
>> DBIx::SearchBuilder::Next('RT::Tickets=HASH(0xb59cf20)') called at
>> /usr/local/rt3/lib/RT/Tickets_Overlay.pm line 2670
>> RT::Tickets::Next('RT::Tickets=HASH(0xb59cf20)') called at
>> /usr/local/rt3/share/html/Ticket/Elements/ShowRequestor line 74
>> HTML::Mason::Commands::__ANON__() called at
>> /usr/lib/perl5/vendor_perl/5.8.7/HTML/Mason/Request.pm line 1315
>>
>> HTML::Mason::Request::content('HTML::Mason::Request::ApacheHandler=HASH(0xb5655ac)')
>> called at /usr/local/rt3/share/html/Widgets/TitleBox line 51
>> HTML::Mason::Commands::__ANON__('title_href', 'undef', 'title',
>> 'More about [EMAIL PROTECTED]') called at
>> /usr/lib/perl5/vendor_perl/5.8.7/HTML/Mason/Component.pm line 135
>>
>> HTML::Mason::Component::run('HTML::Mason::Component::FileBased=HASH(0xb33a0dc)',
>> 'title_href', 'undef', 'title', 'More about [EMAIL PROTECTED]') called at
>> /usr/lib/perl5/vendor_perl/5.8.7/HTML/Mason/Request.pm line 1251
>> eval {...} called at
>> /usr/lib/perl5/vendor_perl/5.8.7/HTML/Mason/Request.pm line 1245
>> HTML::Mason::Request::comp('undef', 'undef', 'undef', 'title_href',
>> 'undef', 'title', 'More about [EMAIL PROTECTED]') called at
>> /usr/local/rt3/share/html/Ticket/Elements/ShowRequestor line 83
>> HTML::Mason::Commands::__ANON__('Ticket',
>> 'RT::Ticket=HASH(0xb59d67c)') called at
>> /usr/lib/perl5/vendor_perl/5.8.7/HTML/Mason/Component.pm line 135
>>
>> HTML::Mason::Component::run('HTML::Mason::Component::FileBased=HASH(0xb595ae4)',
>> 'Ticket', 'RT::Ticket=HASH(0xb59d67c)') called at
>> /usr/lib/perl5/vendor_perl/5.8.7/HTML/Mason/Request.pm line 1251
>> eval {...} called at
>> /usr/lib/perl5/vendor_perl/5.8.7/HTML/Mason/Request.pm line 1245
>> HTML::Mason::Request::comp('undef', 'undef', 'Ticket',
>> 'RT::Ticket=HASH(0xb59d67c)') called at
>> /usr/local/rt3/share/html/Ticket/Elements/ShowSummary line 72
>> HTML::Mason::Commands::__ANON__('Ticket',
>> 'RT::Ticket=HASH(0xb59d67c)', 'Attachments',
>> 'RT::Attachments=HASH(0xb578d7c)') called at
>> /usr/lib/perl5/vendor_perl/5.8.7/HTML/Mason/Component.pm line 135
>>
>> HTML::Mason::Component::run('HTML::Mason::Component::FileBased=HASH(0xb581864)',
>> 'Ticket', 'RT::Ticket=HASH(0xb59d67c)', 'Attachments',
>> 'RT::Attachments=HASH(0xb578d7c)') called at
>> /usr/lib/perl5/vendor_perl/5.8.7/HTML/Mason/Request.pm line 1251
>> eval {...} called at
>> /usr/lib/perl5/vendor_perl/5.8.7/HTML/Mason/Request.pm line 1245
>> HTML::Mason::Request::comp('undef', 'undef', 'Ticket',
>> 'RT::Ticket=HASH(0xb59d67c)', 'Attachments',
>> 'RT::Attachments=HASH(0xb578d7c)') called at
>> /usr/local/rt3/share/html/Ticket/Display.html line 58
>> HTML::Mason::Commands::__ANON__() called at
>> /usr/lib/perl5/vendor_perl/5.8.7/HTML/Mason/Request.pm line 1315
>>
>> HTML::Mason::Request::content('HTML::Mason::Request::ApacheHandler=HASH(0xb5655ac)')
>> called at /usr/local/rt3/share/html/Widgets/TitleBox line 51
>> HTML::Mason::Commands::__ANON__('title', 'Ticket metadata') called
>> at /usr/lib/perl5/vendor_perl/5.8.7/HTML/Mason/Component.pm line 135
>>
>> HT
Re: [rt-users] Very troubling error
I found an old post that suggested this error might have been caused by the
browser stop button being pressed prior to the page being fully loaded. This
isn't the case here.
Keep up with me and what I'm up to: http://theillien.blogspot.com
Mathew Snyder wrote:
> I'm also seeing a lot of this:
> [Tue Jan 22 15:30:31 2008] [crit]: Apache2::RequestIO::rflush: (104)
> Connection
> reset by peer at /usr/lib/perl5/vendor_perl/5.8.7/HTML/Mason/ApacheHandler.pm
> line 1029 (/usr/local/rt3/bin/webmux.pl:127)
> [Tue Jan 22 15:30:50 2008] [crit]: Apache2::RequestIO::rflush: (103) Software
> caused connection abort at
> /usr/lib/perl5/vendor_perl/5.8.7/HTML/Mason/ApacheHandler.pm line 1029
> (/usr/local/rt3/bin/webmux.pl:127)
>
> Keep up with me and what I'm up to: http://theillien.blogspot.com
>
>
> Jesse Vincent wrote:
>>
>> On Tue, Jan 22, 2008 at 10:25:50AM -0500, Mathew Snyder wrote:
>>> I updated DBIx::SearchBuilder but that didn't seem to fix another issue
>>> which I
>>> mentioned in an earlier post. That one being:
>>>
>>> [Tue Jan 22 15:01:13 2008] [crit]: Apache2::RequestIO::rflush: (103)
>>> Software
>>> caused connection abort at
>>> /usr/lib/perl5/vendor_perl/5.8.7/HTML/Mason/ApacheHandler.pm line 1029
>>> (/usr/local/rt3/bin/webmux.pl:127)
>>> [Tue Jan 22 15:11:27 2008] [error]: Template parsing error: Can't locate
>>> object
>>> method "id" via package "Ticket" (perhaps you forgot to load "Ticket"?) at
>>> template line 5.
>> AT a rough guess, there is code in one of your templates that looks like
>> this:
>>
>> { Ticket->}
>>
>> I bet you mean {$Ticket->}
>>
> ___
> 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] Very troubling error
On Tue, Jan 22, 2008 at 10:51:04AM -0500, Mathew Snyder wrote: > I'm also seeing a lot of this: > [Tue Jan 22 15:30:31 2008] [crit]: Apache2::RequestIO::rflush: (104) > Connection > reset by peer at /usr/lib/perl5/vendor_perl/5.8.7/HTML/Mason/ApacheHandler.pm > line 1029 (/usr/local/rt3/bin/webmux.pl:127) > [Tue Jan 22 15:30:50 2008] [crit]: Apache2::RequestIO::rflush: (103) Software > caused connection abort at > /usr/lib/perl5/vendor_perl/5.8.7/HTML/Mason/ApacheHandler.pm line 1029 > (/usr/local/rt3/bin/webmux.pl:127) Just at a guess, your end-users are hitting their "stop" or "reload" buttons in the middle of a page load. -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
Re: [rt-users] suppressing email generated by script to import tickets from another ticketing system
On Tue, Jan 22, 2008 at 03:30:28PM +, Tom H wrote:
>
> Hi,
>
> I have a script which imports tickets from another system using
> something like;
>
> foreach(ticket){
> $TicketObj->Create(subject, queue, priority, status);
> }
>
> etc. However I understand that that is going to trigger the sending of
> emails to all the watchers of these queues?
>
> is there any way to suppress that while this script is running?
I've previously used the following at the top of my script (after the RT::Init
call):
{
no warnings qw/redefine/;
use RT::Action::SendEmail;
sub RT::Action::SendEmail::Commit { 1}
}
If that works for you, I'd be indebted if you could add it to the wiki.
Thanks!
Jesse
>
> Thanks,
>
> 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
>
--
___
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] suppressing email generated by script to import tickets from another ticketing system
Hi,
I have a script which imports tickets from another system using
something like;
foreach(ticket){
$TicketObj->Create(subject, queue, priority, status);
}
etc. However I understand that that is going to trigger the sending of
emails to all the watchers of these queues?
is there any way to suppress that while this script is running?
Thanks,
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] Very troubling error
5 is not id of the template, but line in the template. That's our bad
that you don't see id in the log and have to scan all your templates.
On Jan 22, 2008 6:49 PM, Mathew Snyder <[EMAIL PROTECTED]> wrote:
> Assuming that template 5 is based on the id in the database, this is
> Correspondence which is one of the built in templates and uses $Transaction,
> not
> $Ticket
>
> Keep up with me and what I'm up to: http://theillien.blogspot.com
>
>
>
> Jesse Vincent wrote:
> >
> >
> > On Tue, Jan 22, 2008 at 10:25:50AM -0500, Mathew Snyder wrote:
> >> I updated DBIx::SearchBuilder but that didn't seem to fix another issue
> >> which I
> >> mentioned in an earlier post. That one being:
> >>
> >> [Tue Jan 22 15:01:13 2008] [crit]: Apache2::RequestIO::rflush: (103)
> >> Software
> >> caused connection abort at
> >> /usr/lib/perl5/vendor_perl/5.8.7/HTML/Mason/ApacheHandler.pm line 1029
> >> (/usr/local/rt3/bin/webmux.pl:127)
> >> [Tue Jan 22 15:11:27 2008] [error]: Template parsing error: Can't locate
> >> object
> >> method "id" via package "Ticket" (perhaps you forgot to load "Ticket"?) at
> >> template line 5.
> >
> > AT a rough guess, there is code in one of your templates that looks like
> > this:
> >
> > { Ticket->}
> >
> > I bet you mean {$Ticket->}
> >
>
--
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] Very troubling error
Assuming that template 5 is based on the id in the database, this is
Correspondence which is one of the built in templates and uses $Transaction, not
$Ticket
Keep up with me and what I'm up to: http://theillien.blogspot.com
Jesse Vincent wrote:
>
>
> On Tue, Jan 22, 2008 at 10:25:50AM -0500, Mathew Snyder wrote:
>> I updated DBIx::SearchBuilder but that didn't seem to fix another issue
>> which I
>> mentioned in an earlier post. That one being:
>>
>> [Tue Jan 22 15:01:13 2008] [crit]: Apache2::RequestIO::rflush: (103) Software
>> caused connection abort at
>> /usr/lib/perl5/vendor_perl/5.8.7/HTML/Mason/ApacheHandler.pm line 1029
>> (/usr/local/rt3/bin/webmux.pl:127)
>> [Tue Jan 22 15:11:27 2008] [error]: Template parsing error: Can't locate
>> object
>> method "id" via package "Ticket" (perhaps you forgot to load "Ticket"?) at
>> template line 5.
>
> AT a rough guess, there is code in one of your templates that looks like
> this:
>
> { Ticket->}
>
> I bet you mean {$Ticket->}
>
___
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] Very troubling error
I'm also seeing a lot of this:
[Tue Jan 22 15:30:31 2008] [crit]: Apache2::RequestIO::rflush: (104) Connection
reset by peer at /usr/lib/perl5/vendor_perl/5.8.7/HTML/Mason/ApacheHandler.pm
line 1029 (/usr/local/rt3/bin/webmux.pl:127)
[Tue Jan 22 15:30:50 2008] [crit]: Apache2::RequestIO::rflush: (103) Software
caused connection abort at
/usr/lib/perl5/vendor_perl/5.8.7/HTML/Mason/ApacheHandler.pm line 1029
(/usr/local/rt3/bin/webmux.pl:127)
Keep up with me and what I'm up to: http://theillien.blogspot.com
Jesse Vincent wrote:
>
>
> On Tue, Jan 22, 2008 at 10:25:50AM -0500, Mathew Snyder wrote:
>> I updated DBIx::SearchBuilder but that didn't seem to fix another issue
>> which I
>> mentioned in an earlier post. That one being:
>>
>> [Tue Jan 22 15:01:13 2008] [crit]: Apache2::RequestIO::rflush: (103) Software
>> caused connection abort at
>> /usr/lib/perl5/vendor_perl/5.8.7/HTML/Mason/ApacheHandler.pm line 1029
>> (/usr/local/rt3/bin/webmux.pl:127)
>> [Tue Jan 22 15:11:27 2008] [error]: Template parsing error: Can't locate
>> object
>> method "id" via package "Ticket" (perhaps you forgot to load "Ticket"?) at
>> template line 5.
>
> AT a rough guess, there is code in one of your templates that looks like
> this:
>
> { Ticket->}
>
> I bet you mean {$Ticket->}
>
___
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] Very troubling error
On Tue, Jan 22, 2008 at 10:25:50AM -0500, Mathew Snyder wrote:
> I updated DBIx::SearchBuilder but that didn't seem to fix another issue which
> I
> mentioned in an earlier post. That one being:
>
> [Tue Jan 22 15:01:13 2008] [crit]: Apache2::RequestIO::rflush: (103) Software
> caused connection abort at
> /usr/lib/perl5/vendor_perl/5.8.7/HTML/Mason/ApacheHandler.pm line 1029
> (/usr/local/rt3/bin/webmux.pl:127)
> [Tue Jan 22 15:11:27 2008] [error]: Template parsing error: Can't locate
> object
> method "id" via package "Ticket" (perhaps you forgot to load "Ticket"?) at
> template line 5.
AT a rough guess, there is code in one of your templates that looks like
this:
{ Ticket->}
I bet you mean {$Ticket->}
___
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] Very troubling error
I updated DBIx::SearchBuilder but that didn't seem to fix another issue which I mentioned in an earlier post. That one being: [Tue Jan 22 15:01:13 2008] [crit]: Apache2::RequestIO::rflush: (103) Software caused connection abort at /usr/lib/perl5/vendor_perl/5.8.7/HTML/Mason/ApacheHandler.pm line 1029 (/usr/local/rt3/bin/webmux.pl:127) [Tue Jan 22 15:11:27 2008] [error]: Template parsing error: Can't locate object method "id" via package "Ticket" (perhaps you forgot to load "Ticket"?) at template line 5. Stack: [template:5] [/usr/local/rt3/lib/RT/Template_Overlay.pm:392] [/usr/local/rt3/lib/RT/Template_Overlay.pm:313] [/usr/local/rt3/lib/RT/Action/SendEmail.pm:120] [/usr/local/rt3/lib/RT/Action/Notify.pm:67] [/usr/local/rt3/lib/RT/ScripAction_Overlay.pm:234] [/usr/local/rt3/lib/RT/Scrip_Overlay.pm:478] [/usr/local/rt3/lib/RT/Scrips_Overlay.pm:239] [/usr/local/rt3/lib/RT/Transaction_Overlay.pm:173] [/usr/local/rt3/lib/RT/Record.pm:1461] [/usr/local/rt3/lib/RT/Ticket_Overlay.pm:3554] [/usr/local/rt3/lib/RT/Ticket_Overlay.pm:3283] [/usr/local/rt3/lib/RT/Record.pm:951] [/usr/local/rt3/lib/RT/Interface/Web.pm:1041] [/usr/local/rt3/lib/RT/Interface/Web.pm:1156] [/usr/local/rt3/share/html/Ticket/Display.html:153] [/usr/local/rt3/local/html/Ticket/Update.html:220] [/usr/local/rt3/share/html/autohandler:291] (/usr/local/rt3/lib/RT/Template_Overlay.pm:388) [Tue Jan 22 15:11:27 2008] [error]: Impossible to assign the ticket to 81516: You can only reassign tickets that you own or that are unowned ((eval 349):14) This is time sensitive so if someone could help I'd really appreciate it. Keep up with me and what I'm up to: http://theillien.blogspot.com Ruslan Zakirov wrote: > Upgrade to the latest version of DBIx::SearchBuilder module. > ___ 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-announce] 2008 Training Announcement!
2008 RT Training As the creators of RT, Best Practical Solutions, LLC are the acknowledged leader in RT training. We provide unparalleled instruction in how to get the most out of RT. Best Practical is pleased to offer its training program with an intensive one-day developer and administrator training session taught by the developers who built RT. This comprehensive session will cover: * RT's system architecture * A guided tour of the RT source code * Extension mechanisms you can use to customize RT * How to tie RT into your existing authentication infrastructure * Bulding your own tools that talk to the RT backend * Automating common procedures * Customizing RT's workflow to match your own * How to write custom reports based on RT's data This session will be offered in: * Boston, MA on Monday, March 24th, 2008 * Amsterdam, The Netherlands on Monday, April 21st, 2008 * San Francisco, CA - date will be forthcoming Additionally, we offer private training sessions for organizations. If you would like to schedule a private training session, please drop us a line at [EMAIL PROTECTED] Register now to reserve your seat! Space is limited. Reservations To reserve a seat, please send mail to [EMAIL PROTECTED] with the names and email addresses of all attendees. We need to receive a check, wire transfer, or purchase order two weeks prior to the class or your seat will be released. Payment Policy The cost of the class includes materials. Payment or purchase order must be received two weeks prior to the date of the class. $995 USD for classes in the U.S. EUR 790 for the class in Amsterdam Upon receipt of your reservation we will email you an invoice. Hardcopies of your invoices will be given to you at the training session. If your company requires a hardcopy prior to that, please provide us with the contact and address and we will mail it. Cancellation Policy Two weeks prior to the start date of the class - $250 USD / EUR 200 is non-refundable. 72 hours prior to the start time of the class - entire fee is non- refundable. ___ RT-Announce mailing list [EMAIL PROTECTED] http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-announce ___ 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] Oracle 9 and Build.html performance
Emmanuel Lacour wrote:
On Tue, Jan 22, 2008 at 01:16:26PM +0100, Joop wrote:
Emmanuel Lacour wrote:
SQL> set autotrace on
SQL> CREATE INDEX Groups3 ON Groups (LOWER('Type'), LOWER('Domain'),
Instance);
Index created.
SQL> execute dbms_utility.analyze_schema( 'RT', 'estimate');
Any particular reason to run 'estimate' instead of 'compute' ?
Yes, I follow the rt README.Oracle ;) and I wasn't aware of "compute" ;)
I tried both and with compute I get better results than estimate. Have a
look at the docs to see other options of analyze and with atleast Oracle
10g it is recommended to use DBMS_STATS.GATHER_SCHEMA_STATS or one of
its relatives. It has the possibility to keep the compute timewise
within bays. My VM took about 1min to analyze the whole schema and it
does so each morning at 6:00 am so noone is bothered by it.
Further my explain plan is different. I have 3 full tablescans twice of
USERS and once of PRINCIPALS and my cost is around 480 (This is Oracle XE)
The query send by Ruslan is slighly worse then the original cost is 482
instead of 480.
Joop
___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
Community help: http://wiki.bestpractical.com
Commercial support: [EMAIL PROTECTED]
Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
Buy a copy at http://rtbook.bestpractical.com
Re: [rt-users] RT errors
On Tue, Jan 22, 2008 at 01:34:37PM +, Dalal, Kamber Z (Kamber) wrote: > The following errors are being logged. Can you please assist in > determining the possible causes. > It's only some warnings, you can ignore them. It's fixed in RT 3.6-RELEASE svn. Dirk Pape gave a patch on this list (or rt-devel) some weeks ago if you wan't. http://page.mi.fu-berlin.de/pape/rt3/patches/rt/ -> less_warnings...patch ___ 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] Oracle 9 and Build.html performance
On Tue, Jan 22, 2008 at 01:16:26PM +0100, Joop wrote:
> Emmanuel Lacour wrote:
> >SQL> set autotrace on
> >SQL> CREATE INDEX Groups3 ON Groups (LOWER('Type'), LOWER('Domain'),
> >Instance);
> >Index created.
> >SQL> execute dbms_utility.analyze_schema( 'RT', 'estimate');
> >
> Any particular reason to run 'estimate' instead of 'compute' ?
Yes, I follow the rt README.Oracle ;) and I wasn't aware of "compute" ;)
>
> Further your output of Oracle10g looks almost identical/is identical to
> the output of Oracle9. That sounds to me like a copy/paste problem
> because that is not what I expect and contradicts your own statement
> that Oracle10 is faster than Oracle9.
>
No It's just because the explain plan I gave is not about oracle 10g, but about
the request on oracle 9 with the indexes proposed by Ruslan.
Here is the result from oracle 10g, first request took about 25 seconds, if I
run it a second time, less than 1 second:
=
First
=
Execution Plan
--
Plan hash value: 1378103328
---
| Id | Operation| Name | Rows | Bytes |TempSpc| Cost
(%CPU)| Time |
---
| 0 | SELECT STATEMENT || 1699 | 386K| | 718
9 (3)| 00:01:27 |
| 1 | SORT ORDER BY || 1699 | 386K| 1064K| 718
9 (3)| 00:01:27 |
|* 2 | HASH JOIN || 1699 | 386K| | 710
0 (3)| 00:01:26 |
| 3 |VIEW || 1699 | 6796 | | 694
4 (3)| 00:01:24 |
| 4 | HASH UNIQUE || 1699 | 127K|65M| 694
4 (3)| 00:01:24 |
|* 5 | HASH JOIN || 767K|56M| | 199
2 (4)| 00:00:24 |
| 6 | INLIST ITERATOR|| | | |
| |
|* 7 |INDEX RANGE SCAN | ACL1 |21 | 609 | |
3 (0)| 00:00:01 |
|* 8 | HASH JOIN || 185K| 8715K| 4944K| 198
0 (4)| 00:00:24 |
|* 9 |TABLE ACCESS FULL | GROUPS | 136K| 3340K| | 45
5 (3)| 00:00:06 |
|* 10 |HASH JOIN || 185K| 4176K| | 96
9 (5)| 00:00:12 |
|* 11 | HASH JOIN|| 16950 | 248K| | 27
9 (5)| 00:00:04 |
|* 12 | INDEX FAST FULL SCAN| USERS_KEY | 16950 | 67800 | |1
1 (0)| 00:00:01 |
|* 13 | TABLE ACCESS FULL | PRINCIPALS | 72207 | 775K| | 26
6 (5)| 00:00:04 |
|* 14 | INDEX FAST FULL SCAN | GROUMEM| 789K| 6164K| | 67
9 (3)| 00:00:09 |
| 15 |TABLE ACCESS FULL | USERS | 16951 | 3790K| | 15
5 (2)| 00:00:02 |
---
Predicate Information (identified by operation id):
---
2 - access("MAIN"."ID"="DISTINCTQUERY"."ID")
5 - access("ACL_4"."PRINCIPALTYPE"="GROUPS_3"."TYPE")
7 - access("ACL_4"."RIGHTNAME"='OwnTicket' AND ("ACL_4"."OBJECTTYPE"='RT::Que
ue' OR
"ACL_4"."OBJECTTYPE"='RT::System'))
8 - access("GROUPS_3"."ID"="CACHEDGROUPMEMBERS_2"."GROUPID")
9 - filter("GROUPS_3"."DOMAIN"='RT::Queue-Role' OR
"GROUPS_3"."DOMAIN"='RT::System-Role')
10 - access("CACHEDGROUPMEMBERS_2"."MEMBERID"="PRINCIPALS_1"."ID")
11 - access("PRINCIPALS_1"."ID"="MAIN"."ID")
12 - filter("MAIN"."ID"<>1)
13 - filter("PRINCIPALS_1"."DISABLED"=0 AND "PRINCIPALS_1"."PRINCIPALTYPE"='Us
er' AND
"PRINCIPALS_1"."ID"<>1)
14 - filter("CACHEDGROUPMEMBERS_2"."MEMBERID"<>1)
Statistics
--
0 recursive calls
0 db block gets
5001 consistent gets
2550 physical reads
0 redo size
2379 bytes sent via SQL*Net to client
384 bytes received via SQL*Net from client
2 SQL*Net roundtrips to/from client
1 sorts (memory)
0 sorts (disk)
0 rows processed
==
Second
==
Execution Plan
--
Plan hash value: 1378103328
---
| Id | Operation| Name | Rows | Bytes |TempSpc| Cost
(%CPU)| Time |
---
| 0 | SELECT STATEMENT || 1699 | 386K| | 718
9 (3)| 00:01:27 |
| 1 | SORT ORDER BY || 1699 | 386K| 1064K| 718
[rt-users] RT errors
The following errors are being logged. Can you please assist in determining the possible causes. Thank you, Kamber Dalal Jan 21 15:13:10 nso-ticket RT: Use of uninitialized value in substitution (s///) at /opt/rt3.6/lib/RT/Interface/Web.pm line 1266. (/opt/rt3.6/lib/RT/Interface/Web.pm:1266) Jan 21 15:13:59 nso-ticket RT: Use of uninitialized value in string ne at /opt/rt3.6/lib/RT/Interface/Web.pm line 1481. (/opt/rt3.6/lib/RT/Interface/Web.pm:1481) Jan 21 15:14:00 nso-ticket RT: Use of uninitialized value in substitution (s///) at /opt/rt3.6/lib/RT/Interface/Web.pm line 617. (/opt/rt3.6/lib/RT/Interface/Web.pm:617) Jan 21 15:14:00 nso-ticket RT: Encode::Guess failed: ; fallback to iso-8859-1 (/opt/rt3.6/lib/RT/I18N.pm:414) Jan 21 15:14:00 nso-ticket RT: Encode::Guess failed: ; fallback to iso-8859-1 (/opt/rt3.6/lib/RT/I18N.pm:414) Jan 21 15:14:09 nso-ticket RT: Use of uninitialized value in substitution (s///) at /opt/rt3.6/lib/RT/Interface/Web.pm line 1266. (/opt/rt3.6/lib/RT/Interface/Web.pm:1266) Jan 21 15:14:50 nso-ticket RT: Use of uninitialized value in substitution (s///) at /opt/rt3.6/lib/RT/Interface/Web.pm line 1266. (/opt/rt3.6/lib/RT/Interface/Web.pm:1266) Jan 21 15:14:50 nso-ticket RT: Use of uninitialized value in string ne at /opt/rt3.6/lib/RT/Interface/Web.pm line 1481. (/opt/rt3.6/lib/RT/Interface/Web.pm:1481) Jan 21 15:14:51 nso-ticket RT: Use of uninitialized value in pattern match (m//) at /opt/rt3.6/lib/RT/Interface/Web.pm line 1390. (/opt/rt3.6/lib/RT/Interface/Web.pm:1390) Jan 21 15:15:40 nso-ticket RT: Use of uninitialized value in substitution (s///) at /opt/rt3.6/lib/RT/Interface/Web.pm line 1266. (/opt/rt3.6/lib/RT/Interface/Web.pm:1266) Jan 21 15:16:20 nso-ticket RT: Use of uninitialized value in substitution (s///) at /opt/rt3.6/lib/RT/Interface/Web.pm line 1266. (/opt/rt3.6/lib/RT/Interface/Web.pm:1266) Jan 21 15:22:23 nso-ticket RT: Use of uninitialized value in string ne at /opt/rt3.6/lib/RT/Interface/Web.pm line 1481. (/opt/rt3.6/lib/RT/Interface/Web.pm:1481) Jan 21 15:22:23 nso-ticket RT: Use of uninitialized value in substitution (s///) at /opt/rt3.6/lib/RT/Interface/Web.pm line 617. (/opt/rt3.6/lib/RT/Interface/Web.pm:617) Jan 21 15:22:23 nso-ticket RT: Encode::Guess failed: ; fallback to iso-8859-1 (/opt/rt3.6/lib/RT/I18N.pm:414) Jan 21 15:22:23 nso-ticket RT: Encode::Guess failed: ; fallback to iso-8859-1 (/opt/rt3.6/lib/RT/I18N.pm:414) Jan 21 15:22:45 nso-ticket RT: Use of uninitialized value in substitution (s///) at /opt/rt3.6/lib/RT/Interface/Web.pm line 1266. (/opt/rt3.6/lib/RT/Interface/Web.pm:1266) Jan 21 15:22:45 nso-ticket RT: Use of uninitialized value in string ne at /opt/rt3.6/lib/RT/Interface/Web.pm line 1481. (/opt/rt3.6/lib/RT/Interface/Web.pm:1481) Jan 21 15:22:45 nso-ticket RT: Use of uninitialized value in pattern match (m//) at /opt/rt3.6/lib/RT/Interface/Web.pm line 1390. (/opt/rt3.6/lib/RT/Interface/Web.pm:1390) Jan 21 15:30:12 nso-ticket RT: Use of uninitialized value in substitution (s///) at /opt/rt3.6/lib/RT/Interface/Web.pm line 1266. (/opt/rt3.6/lib/RT/Interface/Web.pm:1266) Jan 21 15:34:01 nso-ticket RT: Use of uninitialized value in substitution (s///) at /opt/rt3.6/lib/RT/Interface/Web.pm line 1266. (/opt/rt3.6/lib/RT/Interface/Web.pm:1266) Jan 21 15:37:43 nso-ticket RT: Use of uninitialized value in substitution (s///) at /opt/rt3.6/lib/RT/Interface/Web.pm line 1266. (/opt/rt3.6/lib/RT/Interface/Web.pm:1266) Jan 21 15:40:58 nso-ticket RT: Use of uninitialized value in pattern match (m//) at /opt/rt3.6/lib/RT/Interface/Web.pm line 1637. (/opt/rt3.6/lib/RT/Interface/Web.pm:1637) Jan 21 15:34:01 nso-ticket RT: Use of uninitialized value in substitution (s///) at /opt/rt3.6/lib/RT/Interface/Web.pm line 1266. (/opt/rt3.6/lib/RT/Interface/Web.pm:1266) ___ 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
AW: [rt-users] Searches.... and CurrentUser
Hi Emmanuel, You are great! Thanks again for your help :-) Its working perfect!!! Torsten > Kühne + Nagel (AG & Co.) KG, Geschäftsleitung: Hans-Georg Brinkmann (Vors.), > Uwe Bielang (Stellv.), Bruno Mang, Alfred Manke, Thorsten Meincke, Mark > Reinhardt (Stellv.), Jens Wollesen, Rainer Wunn (Stellv.), Sitz: Bremen, > Registergericht: Bremen, HRA 21928, USt-IdNr.: DE 812773878, Persönlich > haftende Gesellschaft: Kühne & Nagel A.G., Sitz: Contern/Luxemburg > Geschäftsführender Verwaltungsrat: Klaus-Michael Kühne -Ursprüngliche Nachricht- > Von: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] Im Auftrag > von Emmanuel Lacour > Gesendet: Dienstag, 22. Januar 2008 09:45 > An: rt-users@lists.bestpractical.com > Betreff: Re: [rt-users] Searches and CurrentUser > > On Tue, Jan 22, 2008 at 09:22:32AM +0100, Ham MI-ID, Torsten > Brumm wrote: > > Hi RT List, > > > > I remember some weeks ago a bigger threat regarding searches with > > CurrentUser inside. > > > > Today i tried to create a global SavedSearch like this: > AdminCc.Name = > > '__CurrentUser__' AND ( Status = 'new' OR Status = 'open' ) > > > > I copied this from My Tickets: Owner = '__CurrentUser__' > AND ( Status > > = 'new' OR Status = 'open' ) > > > > I also tried AdminCc.Name like '__CurrentUser__' both > without success. > > I'm pretty sure that __CurrentUser__ = User.id, not User.Name :( > > So try either AdminCc.Id = '__CurrentUser__'. > > Here I have search with Requestor.Id = '__CurrentUser__' which works. > > ___ > 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] Oracle 9 and Build.html performance
Emmanuel Lacour wrote:
SQL> set autotrace on
SQL> CREATE INDEX Groups3 ON Groups (LOWER('Type'), LOWER('Domain'), Instance);
Index created.
SQL> execute dbms_utility.analyze_schema( 'RT', 'estimate');
Any particular reason to run 'estimate' instead of 'compute' ?
Further your output of Oracle10g looks almost identical/is identical to
the output of Oracle9. That sounds to me like a copy/paste problem
because that is not what I expect and contradicts your own statement
that Oracle10 is faster than Oracle9.
Joop
___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
Community help: http://wiki.bestpractical.com
Commercial support: [EMAIL PROTECTED]
Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
Buy a copy at http://rtbook.bestpractical.com
[rt-users] At adjustment RT 3.6.5 problem with sessions.
MySQL: table "sessions" in which there is a field "a_session" which type is appropriated "longblob". At testing for the big size of a DB (~1.5Gb) and quantity tickets (~5), brakes begin. Ticket opens about one minute (a lot of tickets number is raises), perl eats all system resources, references to DB do not occur (strace -p PID on a demon httpd at work apache with mod_perl - gives out: time (NULL) = 1201000846). It has been noticed only casual by image if to expose type "a_session" in "longtext" (that is not correct type) all starts to work it is remarkable, only, naturally, sessions cease to work. Set ($WebSessionClass, ' Apache:: Session:: File '); which is responsible for storage of sessions not in a DB - as any successes has not given. Sessions work, RT hangs. PostgreSQL: a similar situation. Gentoo 2007.0 MySQL 5.0.44 or PostgreSQL 8.2.6 Perl 5.8.8 apache 2.2.6 with mod_perl or nginx with fastcgi 0.6.25 -- Best Regards, Artem A. Kuzyakov System Administrator AGAVA - Software Company http://www.agava.ru/ http://www.renter.ru/ [EMAIL PROTECTED] Tel.: +7 (495) 408-17-90 ___ 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] Oracle 9 and Build.html performance
On Mon, Jan 21, 2008 at 07:51:11PM +0300, Ruslan Zakirov wrote:
> I'm not that good in oracle's optimizer, but I'm pretty sure that the
> following index will help you:
> CREATE INDEX Groups3 ON Groups (LOWER('Type'), LOWER('Domain'), Instance);
>
> Can you add it, generate plan again and sent it to the list, so I can
> check that it really helps in the way I think it should :)
>
Thanks for your help Ruslan! Unfortunatly, it didn't solve anything :(
An interesting think is that I tried the same request on an Oracle 10g, with
same content ... and here no problem of performances with the stock RT indexes.
So maybe we would better try to upgrade to Oracle 10g.
I did:
SQL> set autotrace on
SQL> CREATE INDEX Groups3 ON Groups (LOWER('Type'), LOWER('Domain'), Instance);
Index created.
SQL> execute dbms_utility.analyze_schema( 'RT', 'estimate');
then here is the plan for the same request:
Execution Plan
--
0 SELECT STATEMENT Optimizer=CHOOSE (Cost=11446 Card=1 Bytes=2
54)
10 SORT (ORDER BY) (Cost=11446 Card=1 Bytes=254)
21 NESTED LOOPS (Cost=11444 Card=1 Bytes=254)
32 VIEW (Cost=11443 Card=1 Bytes=10)
43 SORT (UNIQUE) (Cost=11443 Card=1 Bytes=77)
54 NESTED LOOPS (Cost=1231 Card=1170677 Bytes=9014212
9)
65 HASH JOIN (Cost=1230 Card=20646030161 Bytes=1424
576081109)
76 TABLE ACCESS (FULL) OF 'GROUPS' (Cost=195 Card
=227456 Bytes=5686400)
86 NESTED LOOPS (Cost=205 Card=453847 Bytes=19969
268)
98 MERGE JOIN (CARTESIAN) (Cost=204 Card=209510
2 Bytes=83804080)
109 INLIST ITERATOR
11 10 INDEX (RANGE SCAN) OF 'ACL1' (NON-UNIQUE
) (Cost=1 Card=23 Bytes=667)
129 BUFFER (SORT) (Cost=203 Card=90683 Bytes=9
97513)
13 12 TABLE ACCESS (BY INDEX ROWID) OF 'PRINCI
PALS' (Cost=9 Card=90683 Bytes=997513)
14 13 INDEX (RANGE SCAN) OF 'FSHPRINCIPALS1'
(NON-UNIQUE)
158 INDEX (UNIQUE SCAN) OF 'USERS_KEY' (UNIQUE)
165 INDEX (RANGE SCAN) OF 'GROUMEM' (NON-UNIQUE)
172 TABLE ACCESS (BY INDEX ROWID) OF 'USERS' (Cost=1 Card=
1 Bytes=244)
18 17 INDEX (UNIQUE SCAN) OF 'USERS_KEY' (UNIQUE)
Statistics
--
0 recursive calls
0 db block gets
2699012 consistent gets
0 physical reads
0 redo size
1235 bytes sent via SQL*Net to client
275 bytes received via SQL*Net from client
2 SQL*Net roundtrips to/from client
3 sorts (memory)
0 sorts (disk)
0 rows processed
Also here is some statistics for this database:
SQL> SELECT count(*) FROM Attachments;
627770
SQL> SELECT count(*) FROM Queues;
334
SQL> SELECT count(*) FROM Links;
1737
SQL> SELECT count(*) FROM Principals;
358744
SQL> SELECT count(*) FROM Groups;
338358
SQL> SELECT count(*) FROM ScripConditions;
10
SQL> SELECT count(*) FROM Transactions;
1361371
SQL> SELECT count(*) FROM Scrips;
164
SQL> SELECT count(*) FROM ACL;
4124
SQL> SELECT count(*) FROM GroupMembers;
330161
SQL> SELECT count(*) FROM CachedGroupMembers;
981829
SQL> SELECT count(*) FROM Users;
19645
SQL> SELECT count(*) FROM Tickets;
76012
SQL> SELECT count(*) FROM ScripActions;
17
SQL> SELECT count(*) FROM Templates;
58
SQL> SELECT count(*) FROM ObjectCustomFields;
1198
SQL> SELECT count(*) FROM ObjectCustomFieldValues;
101937
SQL> SELECT count(*) FROM CustomFields;
176
SQL> SELECT count(*) FROM CustomFieldValues;
1244
SQL> SELECT count(*) FROM Attributes;
1316
SQL> SELECT count(*) FROM sessions;
0
___
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] Searches.... and CurrentUser
On Tue, Jan 22, 2008 at 09:22:32AM +0100, Ham MI-ID, Torsten Brumm wrote: > Hi RT List, > > I remember some weeks ago a bigger threat regarding searches with > CurrentUser inside. > > Today i tried to create a global SavedSearch like this: AdminCc.Name = > '__CurrentUser__' AND ( Status = 'new' OR Status = 'open' ) > > I copied this from My Tickets: Owner = '__CurrentUser__' AND ( Status = > 'new' OR Status = 'open' ) > > I also tried AdminCc.Name like '__CurrentUser__' both without success. I'm pretty sure that __CurrentUser__ = User.id, not User.Name :( So try either AdminCc.Id = '__CurrentUser__'. Here I have search with Requestor.Id = '__CurrentUser__' which works. ___ 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] Searches.... and CurrentUser
Hi RT List, I remember some weeks ago a bigger threat regarding searches with CurrentUser inside. Today i tried to create a global SavedSearch like this: AdminCc.Name = '__CurrentUser__' AND ( Status = 'new' OR Status = 'open' ) I copied this from My Tickets: Owner = '__CurrentUser__' AND ( Status = 'new' OR Status = 'open' ) I also tried AdminCc.Name like '__CurrentUser__' both without success. I'm using RT 3.6.5 (not the lastest patches and Updates installed). Did i missed something during the last weeks??? Is there any solution for this??? Thanks Torsten Kuhne + Nagel (AG & Co.) KG, Geschaftsleitung: Hans-Georg Brinkmann (Vors.), Uwe Bielang (Stellv.), Bruno Mang, Alfred Manke, Thorsten Meincke, Mark Reinhardt (Stellv.), Jens Wollesen, Rainer Wunn (Stellv.), Sitz: Bremen, Registergericht: Bremen, HRA 21928, USt-IdNr.: DE 812773878, Personlich haftende Gesellschaft: Kuhne & Nagel A.G., Sitz: Contern/Luxemburg Geschaftsfuhrender Verwaltungsrat: Klaus-Michael Kuhne ___ 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] disable autoreply on one queue only?
Elijah Wright wrote: Hi, we need to do a bulk import of some emails into tickets, but we want to not flood the original requestors with "ticket generation autoreplies". I see that we can disable autoreply by removing the global scrip that does that; however, we don't really want to remove it (and disable autoreplies for other queues...) just because we want to do this one bulk import. Is there an easy way to do this without taking our install offline temporarily, and without having to simply induce administrative downtime for the rest of the install? There is an extension written by Dirk Pape which allows you to disable scrips on a global and at queue level. Took some searching but here is the URL to it: http://page.mi.fu-berlin.de/pape/rt3/patches/rt Look for deactivate scrip-3.6.patch if you're using RT3.6.x Joop ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: [EMAIL PROTECTED] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
Re: [rt-users] disable autoreply on one queue only?
On Mon, Jan 21, 2008 at 09:40:51PM -0500, Elijah Wright wrote: > Hi, > > we need to do a bulk import of some emails into tickets, but we want to not > flood the original requestors with "ticket generation autoreplies". > > I see that we can disable autoreply by removing the global scrip that does > that; however, we don't really want to remove it (and disable autoreplies > for other queues...) just because we want to do this one bulk import. > > Is there an easy way to do this without taking our install offline > temporarily, and without having to simply induce administrative downtime for > the rest of the install? > Depending of your setup, you can flush your mailq on the RT server, then block the smtp port using iptables, then import your mails, then remove all outgoing messages from the smtp queue, then reopen the smtp port. Or you can edit the autoreply scrips and change the condition to be user defined and write a custom condition wich never match, then import, then revert the condition. You can also edit the RT configuration file to change $SendmailPath to /bin/true, this will disable all outgoing emails from RT. Remember that some of the previous solutions disable all the RT outgoing emails, so if your users continues to use RT during the import, their answer will never go out. Last idea, add to all your emails to import, a custom header to identify them, then change the condition in autoreply scrip to filter on this header. This way will not disturb your users. ___ 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
