Re: [rt-users] Search for logged-in user as requestor
Thanks for the suggestion Gabriele but unfortunately that doesn't seem to work for me :( Oh I'm using 3.6.3 btw. Justin On 7 Jan 2009, at 15:00, Franzini, Gabriele [Nervianoms] wrote: Hello,Justin, I use in similar saved searches for V3.8.1 the clause: Owner.Id = '__CurrentUser__' so maybe Requestor.Id would do? HTH, Gabriele Franzini ICT Applications Manager Nerviano Medical Sciences SRL 20014 Nerviano Italy - Message: 1 Date: Wed, 7 Jan 2009 09:43:12 + From: Justin Hayes justin.ha...@orbisuk.com Subject: [rt-users] Search for logged-in user as requestor Hi, I would like to be able to create saved searches that will find tickets where the logged in user is the Requestor. This is easy for Owner as you can useOwner = '__CurrentUser__'. Is there a way to do this for Requestor though? I tried Requestor = '__CurrentUser__'but that doesn't work. I found this on the wiki, but that only seems to apply to RT2: http://wiki.bestpractical.com/view/CurrentUserEmail Any help much appreciated!! Justin ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: sa...@bestpractical.com 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: sa...@bestpractical.com Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
Re: [rt-users] Search for logged-in user as requestor
In case anyone's interested I figured out how to do this in share/html/Elements/ShowSearch you have: $SearchArg-{'Query'} =~ s/__CurrentUser__/$session{'CurrentUser'}- Id/ge; I've added a line for CurrentUserEmail so now I have: $SearchArg-{'Query'} =~ s/__CurrentUser__/$session{'CurrentUser'}- Id/ge; $SearchArg-{'Query'} =~ s/__CurrentUserEmail__/ $session{'CurrentUser'}-EmailAddress/ge; You can then use the following in searches that you add to the At A Glance screen: Requestor.EmailAddress = '__CurrentUserEmail__' Cheers, Justin On 7 Jan 2009, at 09:43, Justin Hayes wrote: Hi, I would like to be able to create saved searches that will find tickets where the logged in user is the Requestor. This is easy for Owner as you can use Owner = '__CurrentUser__'. Is there a way to do this for Requestor though? I tried Requestor = '__CurrentUser__' but that doesn't work. I found this on the wiki, but that only seems to apply to RT2: http://wiki.bestpractical.com/view/CurrentUserEmail Any help much appreciated!! Justin ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: sa...@bestpractical.com 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: sa...@bestpractical.com Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
[rt-users] RT 3.8.2 packages for Debian Lenny?
Hi all, Andrew published well working Lenny packages for 3.8.1 (deb http://debian.etc.gen.nz http://debian.etc.gen.nz lenny rt), also similar packages are available in Debian experimental. As Debian Lenny is the next stable, where can I get packages for the latest RT 3.8.2? anybody working already on this? We are working on a RT 3.8.x virtual appliance based on Debian Lenny for Proxmox VE (pve.proxmox.com) and we want to make sure that the update process will be straight forward for the users - we have already a working release candidate appliance for 3.8.1 and its very cool! Best Regards, Martin Maurer mar...@proxmox.com mailto:mar...@proxmox.com http://pve.proxmox.com Proxmox Server Solutions GmbH Kohlgasse 51/10, 1050 Vienna, Austria ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: sa...@bestpractical.com 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.8.2 packages for Debian Lenny?
Martin Maurer wrote: Hi all, Andrew published well working Lenny packages for 3.8.1 (deb http://debian.etc.gen.nz lenny rt), also similar packages are available in Debian experimental. As Debian Lenny is the next stable, where can I get packages for the latest RT 3.8.2? anybody working already on this? Give it time.. it only came out yesterday :) -- Kind Regards, __ Mike Peachey, IT Tel: +44 114 281 2655 Fax: +44 114 281 2951 Jennic Ltd, Furnival Street, Sheffield, S1 4QT, UK Comp Reg No: 3191371 - Registered In England http://www.jennic.com __ ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: sa...@bestpractical.com Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
Re: [rt-users] closing out spam tickets
hmm. okay. I don't know how to do bulk updates, I guess I can learn. So far we get two spams/day into the ticket system, so it hasn't been that big a deal yet. It's just a link at the top of any search results page. -- Cambridge Energy Alliance: Save money. Save the planet. ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: sa...@bestpractical.com Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
[rt-users] performance with mason_handler.fcgi
I recently posted regarding some performance issues after a migration from RT2.0.15 to RT3.8.1. I originally thought it might be a mysql issue, but I think it's apache and the Mason FCGI. The system will be practically 100% idle until I view a ticket. While the ticket is slowly coming up in the browser, the system goes to 0% idle, with the mason_handler.fcgi taking 3/4 of the CPU and memory, and mysql taking most of the rest. This is currently running on a VirtualBox with 512M memory. Is this not sufficient memory? Or is something else not tuned correctly? Any ideas would be great. Both standard with Slackware 12.2: Apache = 2.2.10 mysql = 5.0.67 Thanks! ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: sa...@bestpractical.com 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.8.2 packages for Debian Lenny?
On Thu, Jan 08, 2009 at 03:34:21PM +0100, Martin Maurer wrote: Andrew published well working Lenny packages for 3.8.1 (deb http://debian.etc.gen.nz http://debian.etc.gen.nz lenny rt), also similar packages are available in Debian experimental. As Debian Lenny is the next stable, where can I get packages for the latest RT 3.8.2? anybody working already on this? Yep - I hope to get packages uploaded to experimental (or possibly unstable - it won't be a candidate for lenny anyway due to the new package name) in the next few days. -- Dominic Hargreaves, Systems Development and Support Team Computing Services, University of Oxford ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: sa...@bestpractical.com Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
[rt-users] Self service error on page IE 6
Hi all, I have a customer which uses the Self Service HTTP interface using IE 6.0 The customer complains he cannot see the issue description text box when trying to submit new issue. he gets error on page with the following: Line: 124 Char: 2 Error: Object expected Code:0 URL: http://Server.URL/NoAuth/RichText/editor/fckeditor.html?InstanceName=ContentToolbar=Default It is working fine with IE7 and FF 3.0 any ideas how to fix it? ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: sa...@bestpractical.com Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
[rt-users] Text::Template versions (was Re: [Rt-announce] RT 3.8.2 Released)
On Wed, Jan 07, 2009 at 09:34:44AM -0500, Kevin Falcone wrote: * newer Text::Template which claims to have fixed the T:: cleanup, otherwise scrips in batch stage may be delayed [sartak] I note you have declared a dependency on Text::Template 1.45. Examining the changes between Text::Template 1.44 (which is nearly 6 years old) and 1.45 (released last year) I can't see a single code change. The only things that changes are the documentation, package metadata, version numbers, and test suite. There's also no changelog entry for 1.45 in the distribution. What am I missing? Could the dependency be relaxed to some other version of Text::Template? I can't see any particularly relevant entry in the T::T changelog, but I don't quite understand the above RT changelog entry either. Cheers, Dominic. -- Dominic Hargreaves, Systems Development and Support Team Computing Services, University of Oxford ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: sa...@bestpractical.com Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
[rt-users] Error message in upgrade from 3.6.5 to 3.8.1
Hi people, In the last step of upgrade from RT 3.6.5 to 3.8.1 on FreeBSD-7.1-RELEASE, got this error: ERROR 1062 (23000) at line 210: Duplicate entry '' for key 2 Steps executed: # cd /usr/ports/www/rt38/ make install # cd /usr/ports/www/rt38/work/rt-3.8.1/ # ./sbin/rt-setup-database --dba root --action upgrade # rm -fr /var/run/rt38/mason_data/obj/ # /usr/local/etc/rc.d/apache.sh restart # perl ./etc/upgrade/schema.mysql-4.0-4.1.pl rt3 root sql.queries # more sql.queries # mysql -u root -p rt3 sql.queries Enter password: ERROR 1062 (23000) at line 210: Duplicate entry '' for key 2 # The line 210 says: ALTER TABLE Users MODIFY Name VARCHAR(200) CHARACTER SET utf8 NOT NULL DEFAULT ''; Is this an error that I can ignore and move on, or will I regret if I do so? Thanks ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: sa...@bestpractical.com Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
Re: [rt-users] Text::Template versions (was Re: [Rt-announce] RT 3.8.2 Released)
On Thu, Jan 08, 2009 at 05:41:48PM +, Dominic Hargreaves wrote: On Wed, Jan 07, 2009 at 09:34:44AM -0500, Kevin Falcone wrote: * newer Text::Template which claims to have fixed the T:: cleanup, otherwise scrips in batch stage may be delayed [sartak] I note you have declared a dependency on Text::Template 1.45. Examining the changes between Text::Template 1.44 (which is nearly 6 years old) and 1.45 (released last year) I can't see a single code change. The only things that changes are the documentation, package metadata, version numbers, and test suite. There's also no changelog entry for 1.45 in the distribution. What am I missing? Could the dependency be relaxed to some other version of Text::Template? I can't see any particularly relevant entry in the T::T changelog, but I don't quite understand the above RT changelog entry either. Cheers, Dominic. Hi Dominic, Text::Template 1.44 had the important bugfix. From its README: _scrubpkg, which was responsible for eptying out temporary packages after the module had done with them, wasn't always working; the result was memory-leaks in long-running applications. This should be fixed now, and there is a test in the test suite for it. When bumping a dependency I generally depend on the latest and greatest for more bugfixes, documentation, etc. You're right that in this particular case we could have depended on just 1.44, since 1.45 appears to have only very minor doc and test tweaks. If you have 1.44 and upgrading a module is difficult, then I suppose you could get away without upgrading it. Shawn ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: sa...@bestpractical.com Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
Re: [rt-users] Error message in upgrade from 3.6.5 to 3.8.1
You have users with names slightly different. Default mysql collation assume that some characters with umlauts are equal to characters without. If the current character set is latin1 then after upgrade people with name field containing anything outside ascii wouldn't be able to login (using name). As well, data would be corrupted as it's UTF8 stored in latin1 column. You can: select different collation, rename conflicting users, convert name to latin1. First two solutions are preffered. On Thu, Jan 8, 2009 at 9:31 PM, Alex Moura ale...@gmail.com wrote: Hi people, In the last step of upgrade from RT 3.6.5 to 3.8.1 on FreeBSD-7.1-RELEASE, got this error: ERROR 1062 (23000) at line 210: Duplicate entry '' for key 2 Steps executed: # cd /usr/ports/www/rt38/ make install # cd /usr/ports/www/rt38/work/rt-3.8.1/ # ./sbin/rt-setup-database --dba root --action upgrade # rm -fr /var/run/rt38/mason_data/obj/ # /usr/local/etc/rc.d/apache.sh restart # perl ./etc/upgrade/schema.mysql-4.0-4.1.pl rt3 root sql.queries # more sql.queries # mysql -u root -p rt3 sql.queries Enter password: ERROR 1062 (23000) at line 210: Duplicate entry '' for key 2 # The line 210 says: ALTER TABLE Users MODIFY Name VARCHAR(200) CHARACTER SET utf8 NOT NULL DEFAULT ''; Is this an error that I can ignore and move on, or will I regret if I do so? Thanks ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: sa...@bestpractical.com 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: sa...@bestpractical.com Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
[rt-users] Filtering users
Is there a way within RT to create a scrip that prevents ticket creation if the email originates from a particular email address, or if it has a particular subject? I know.. this could be done via procmail, but I was hoping to have it such that the helpdesk admins could manage this from within the interface since they are not that familiar with anything other than Windows and web interfaces... I checked the archives, but I didn't come across much other than use procmail.. Thanks! -Rich ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: sa...@bestpractical.com Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
Re: [rt-users] Filtering users
I checked the archives, but I didn't come across much other than use procmail.. You could always setup a minimal webmin configuration to allow them to interact with procmail, though this open its own can of worms. -- Cambridge Energy Alliance: Save money. Save the planet. ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: sa...@bestpractical.com Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
Re: [rt-users] Filtering users
On Thu, 08 Jan 2009 14:29:08 -0500, Rich West rich.w...@wesmo.com wrote: Is there a way within RT to create a scrip that prevents ticket creation if the email originates from a particular email address, or if it has a particular subject? I know.. this could be done via procmail, but I was hoping to have it such that the helpdesk admins could manage this from within the interface since they are not that familiar with anything other than Windows and web interfaces... I checked the archives, but I didn't come across much other than use procmail.. Thanks! -Rich You can't do this in a scrip - by the time you get into the scrips, the ticket is already created. You could write on-create scrip that immediately deletes the ticket if the requestor or subject match your criteria. Steve -- Stephen Turner Senior Programmer/Analyst - SAIS MIT IST ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: sa...@bestpractical.com Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
[rt-users] MySQL Tuning
I'm looking for ways to tune MySQL because it gets increasingly slower. I've already set up cleaning out the sessions table to what I can only describe as limited effect. I found this: http://mysqlha.blogspot.com/2008/12/make-mysql-faster-in-one-hour_14.html which mentions a patch from Google. Not being a developer or pure database admin I have no clue what is being said here. Perhaps someone can either translate or simply tell me don't bother. -Mathew -- Keep up with my goings on at http://feeds.feedburner.com/theillien_atom ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: sa...@bestpractical.com Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
Re: [rt-users] MySQL Tuning
Do you have server with 8+ cores? If no then don't bother. For the beginning you can start from http://mysqltuner.pl On Fri, Jan 9, 2009 at 12:53 AM, Mathew mathew.sny...@gmail.com wrote: I'm looking for ways to tune MySQL because it gets increasingly slower. I've already set up cleaning out the sessions table to what I can only describe as limited effect. I found this: http://mysqlha.blogspot.com/2008/12/make-mysql-faster-in-one-hour_14.html which mentions a patch from Google. Not being a developer or pure database admin I have no clue what is being said here. Perhaps someone can either translate or simply tell me don't bother. -Mathew -- Keep up with my goings on at http://feeds.feedburner.com/theillien_atom ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: sa...@bestpractical.com 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: sa...@bestpractical.com Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
[rt-users] (no subject)
subscribe ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: sa...@bestpractical.com Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
Re: [rt-users] Text::Template versions (was Re: [Rt-announce] RT 3.8.2 Released)
On 09/01/2009, at 5:44 AM, Shawn M Moore wrote: On Thu, Jan 08, 2009 at 05:41:48PM +, Dominic Hargreaves wrote: On Wed, Jan 07, 2009 at 09:34:44AM -0500, Kevin Falcone wrote: * newer Text::Template which claims to have fixed the T:: cleanup, otherwise scrips in batch stage may be delayed [sartak] I note you have declared a dependency on Text::Template 1.45. Examining the changes between Text::Template 1.44 (which is nearly 6 years old) and 1.45 (released last year) I can't see a single code change. The only things that changes are the documentation, package metadata, version numbers, and test suite. There's also no changelog entry for 1.45 in the distribution. What am I missing? Could the dependency be relaxed to some other version of Text::Template? I can't see any particularly relevant entry in the T::T changelog, but I don't quite understand the above RT changelog entry either. ... Text::Template 1.44 had the important bugfix. From its README: _scrubpkg, which was responsible for eptying out temporary packages after the module had done with them, wasn't always working; the result was memory-leaks in long-running applications. This should be fixed now, and there is a test in the test suite for it. When bumping a dependency I generally depend on the latest and greatest for more bugfixes, documentation, etc. You're right that in this particular case we could have depended on just 1.44, since 1.45 appears to have only very minor doc and test tweaks. If you have 1.44 and upgrading a module is difficult, then I suppose you could get away without upgrading it. I think that Dominic's point is that choosing the newest package to depend on when the required fix was actually in a much earlier release has the consequence of making the dependancy one which is unlikely to be satisfied from the system libraries whereas the earlier version would have been. For example this is what Debian 4.0 Etch (currently stable) has packaged. # apt-cache show libtext-template-perl Package: libtext-template-perl Priority: extra Section: perl Installed-Size: 172 Maintainer: Scott M. Dier sd...@debian.org Architecture: all Version: 1.44-1.1 Depends: perl (= 5.6.0-16) Filename: pool/main/libt/libtext-template-perl/libtext-template- perl_1.44-1.1_all.deb Size: 54024 MD5sum: 7daed0bed4940c9d4c8f9e38a4aa6f53 SHA1: d7fea5528a38bfdf9f8ef5d8dc0dbc192771fa3b SHA256: ad9bf0b565c23b608979551504961be5df183273d80d91c6bfa667b12eef2890 Description: Text::Template perl module ... ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: sa...@bestpractical.com Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com