Re: [rt-users] list unprivileged users

2009-09-28 Thread mailinglists
Jerrad Pierce a crit: Do you know how I can give it for the rt staff users, like a kind of saved search ? Saved searches are for ticket builder, this is a user search. They can either create a browser bookmark, or you could add a link to it in the UI with a Tabs callback.

[rt-users] how to check for existence of user from scrip

2009-09-28 Thread Jeroen Baten
Hello, I am making a script that does an auto-assignment based on the contents of the email. How can I check in a scrip whether a certain userid already exists? kind regards, -- Met vriendelijke groet, ONVZ Zorgverzekeraar Jeroen Baten Stafmedewerker Automatisering De Molen 66 Postbus 392

[rt-users] RT Upgrade 3.0.6 - 3.8.5 database problem

2009-09-28 Thread Torsten Olschewski
Hi all, Upgrade of RT software is done without problems following the README file. But upgrading the MySQL Database makes one problem with importing the SQL file generated by upgrade-mysql-schema.pl at point 6 in UPGRADING.mysql. If I import the SQL file with mysql -u root -p rt3 sql.queries

[rt-users] Update owner before comment

2009-09-28 Thread Bastian Ballmann
Hi list, in the Ticket/Update view one can set a new owner and add a comment, but the comment is added before the new owner is set. Can I modify this behaviour? I want RT to first update the owner and than set the comment and execute Scrips. If this cannot be done with configuration or

Re: [rt-users] RT Upgrade 3.0.6 - 3.8.5 database problem

2009-09-28 Thread Ruslan Zakirov
Hello Torsten, This happens when Name in the Users table contains duplicate values in terms of case-sensetivity or incorrect UTF-8 data that gets converted to empty string. You either have two users with name 'Санкт-Петербург' spelled in different case or this value is not UTF-8, but cp1251,

Re: [rt-users] how to check for existence of user from scrip

2009-09-28 Thread Ruslan Zakirov
Hello Jeroen, my $user = RT::User-new( $CurrentUser ); $user-Load( $user_id_or_name ); if ( $user-id ) { ... exists ... } else { ... doesn't ... } Check more examples on wiki to figure out what is CurrentUser and look at POD of RT::User to find more Load* methods. 2009/9/28 Jeroen Baten

Re: [rt-users] ModifySelf Privilege Prevents Login

2009-09-28 Thread Jesse Vincent
On Fri, Sep 25, 2009 at 06:28:09PM -0700, Behzad Mahini wrote: Here is what I received (and 12 matches with the id for my 'root') [Sat Sep 26 01:25:15 2009] [warning]: 12 at ./replace_password.pl line 15. (./replace_password.pl:15) [Sat Sep 26 01:25:15 2009] [warning]: 0That is already

Re: [rt-users] ModifySelf Privilege Prevents Login

2009-09-28 Thread Behzad Mahini
None whatsoever. Everything was working fine prior to the ModifySelf change of mine, and all I wanted to do was grant my users the privilege to be able to change their own passwords, using: Configuration Global User Rights user_xyz was Granted ModifySelf -Behzad On Sep 28, 2009,

Re: [rt-users] ModifySelf Privilege Prevents Login

2009-09-28 Thread Jesse Vincent
On Mon, Sep 28, 2009 at 08:42:11AM -0700, Behzad Mahini wrote: None whatsoever. Everything was working fine prior to the ModifySelf change of mine, and all I wanted to do was grant my users the privilege to be able to change their own passwords, using: Configuration Global

Re: [rt-users] ModifySelf Privilege Prevents Login

2009-09-28 Thread Behzad Mahini
Only the un-privilged ones. -Behzad On Sep 28, 2009, at 8:50 AM, Behzad Mahini wrote: Only the un-privilged ones. -Behzad On Sep 28, 2009, at 8:44 AM, Jesse Vincent wrote: On Mon, Sep 28, 2009 at 08:42:11AM -0700, Behzad Mahini wrote: None whatsoever. Everything was working fine prior

Re: [rt-users] timeworked.pl requires every extension lib to be added?

2009-09-28 Thread Allen
My original line pointed only to the root install of RT: /u/rtweb/rt38/ lib in this case. I also have a lot of plugins and this is the use lib line that was needed to cover them all: use lib qw(/usr/local/share/request-tracker3.8/lib /usr/share/request-tracker3.8/lib); That is for

[rt-users] Scrip to send original ticket request contents upon resolve

2009-09-28 Thread Rich West
I'm having trouble locating exactly how to do this, but I was looking for a way to create a script (or process) to sent the resolved email message which includes the original ticket content at the end of the message. I thought about modifying the current scrip since the 11 queues we have all want

Re: [rt-users] timeworked.pl requires every extension lib to be added?

2009-09-28 Thread Kevin Falcone
On Mon, Sep 28, 2009 at 09:53:54AM -0700, Allen wrote: My original line pointed only to the root install of RT: /u/rtweb/rt38/ lib in this case. I also have a lot of plugins and this is the use lib line that was needed to cover them all: use lib

[rt-users] Custom Field validation rules

2009-09-28 Thread Mike Johnson
What version of RT was validation rules for custom fields added? I've done some googling, and I found that 3.8 definitely has the ability to make fields manditory, as well as using regular expressions to validate the data entered in them all done through the web interface. I'm just curious

[rt-users] users setting custom fields

2009-09-28 Thread David Griffith
I would like to allow users to set the custom fields when only they file a trouble ticket. Thereafter, only members of the Helpdesk group should be allowed to alter the custom fields (eg, the user misidentified his workstation's hardware). My Helpdesk queue follows the Yoyodyne example from

Re: [rt-users] RT Upgrade 3.0.6 - 3.8.5 database problem

2009-09-28 Thread Torsten Olschewski
Hi Ruslan, This happens when Name in the Users table contains duplicate values in terms of case-sensetivity or incorrect UTF-8 data that gets converted to empty string. You either have two users with name 'Санкт-Петербург' spelled in different case or this value is not UTF-8, but cp1251,

Re: [rt-users] RT Upgrade 3.0.6 - 3.8.5 database problem

2009-09-28 Thread Graeme Fowler
Torsten Olschewski wrote: I'am not a MySQL guru. How can I find this users or how can I fix this problem? There are about 30k users. Most of them from spam mail. Try this MySQL query: SELECT COUNT(*), id, Name, EmailAddress from Users GROUP BY EmailAddress HAVING COUNT(*) 1 order by Name,

Re: [rt-users] Time in logs not matching system time

2009-09-28 Thread Kimberly McKinnis
That seems to be as designed. At least, that's what I was told when I asked this same question last year. Slightly annoying but you get used to it. -Original Message- From: Lander, Scott [mailto:slan...@hearstsc.com] Sent: Monday, September 28, 2009 11:54 AM To: Kimberly McKinnis;

Re: [rt-users] Time in logs not matching system time

2009-09-28 Thread Lander, Scott
Hmm in syslog, it logs the correct time: Sep 28 14:46:18 MyHelpDesk RT: Ticket 327 created in queue 'Monitoring' by root (/opt/rt3/bin/../lib/RT/Ticket_Overlay.pm:667) While in the rt.log file it logs in UTC: [Mon Sep 28 18:46:18 2009] [info]: Ticket 327 created in queue 'Monitoring' by root

Re: [rt-users] Custom Field validation rules

2009-09-28 Thread Kevin Falcone
On Mon, Sep 28, 2009 at 02:01:40PM -0400, Mike Johnson wrote: What version of RT was validation rules for custom fields added? I've done some googling, and I found that 3.8 definitely has the ability to make fields manditory, as well as using regular expressions to validate the

[rt-users] Simple RT script makes Mysql Server go away

2009-09-28 Thread Todd Chapman
All, I am customizing RT to add an attribute to transactions that meet certain criteria. The script below is meant to update all the existing transactions but after a while the Mysal server goes away. Is there anything obvious about the script causing this? Thanks! #!/opt/perl/bin/perl use

Re: [rt-users] Simple RT script makes Mysql Server go away

2009-09-28 Thread Jesse Vincent
On Mon, Sep 28, 2009 at 03:23:53PM -0400, Todd Chapman wrote: All, I am customizing RT to add an attribute to transactions that meet certain criteria. The script below is meant to update all the existing transactions but after a while the Mysal server goes away. Is there anything obvious

Re: [rt-users] ModifySelf Privilege Prevents Login

2009-09-28 Thread Jesse Vincent
On Mon, Sep 28, 2009 at 08:52:35AM -0700, Behzad Mahini wrote: Only the un-privilged ones. I'm stumped. Without looking into your RT, I'm not sure what's going wrong. -Behzad On Sep 28, 2009, at 8:50 AM, Behzad Mahini wrote: Only the un-privilged ones. -Behzad On Sep 28, 2009, at

Re: [rt-users] Simple RT script makes Mysql Server go away

2009-09-28 Thread Kenneth Marshall
Todd, Checking the MySQL logs would help. One MySQL configuration parameter that seems to cause behavior of this type is the connection timeout, maybe it should be larger or the behavior disabled? Just an idea. Cheers, Ken On Mon, Sep 28, 2009 at 03:23:53PM -0400, Todd Chapman wrote: All, I

Re: [rt-users] Simple RT script makes Mysql Server go away

2009-09-28 Thread Todd Chapman
On Mon, Sep 28, 2009 at 3:32 PM, Jesse Vincent je...@bestpractical.com wrote: On Mon, Sep 28, 2009 at 03:23:53PM -0400, Todd Chapman wrote: All, I am customizing RT to add an attribute to transactions that meet certain criteria. The script below is meant to update all the existing

Re: [rt-users] ModifySelf Privilege Prevents Login

2009-09-28 Thread Behzad Mahini
So in my situation, I have to do a re-installation of 3.8.4 (and RT-FM RT-IR). Are the following steps in the sequence listed below correct (if anything missing, please comment): 1) back up MySQL (mysqldump) 2) backup (copy) my existing RT_SiteConfig.pm -- to replace the one that gets

[rt-users] Helpdesk Anthem

2009-09-28 Thread Helmuth Ramirez
I wanted to share with everyone something that I've been working on. It is a short video. The concept behind the video was taking a popular pop song, and rewriting the lyrics to be techy and a music video to go along with :) As IT people, I think you can all appreciate it and hopefully smile if

[rt-users] rename Nobody ?

2009-09-28 Thread Jo Rhett
One of the managers here wants to rename the Nobody user to have a different name.Can this be done without a code change? (I'm leaving SVcolo on 9/30 so custom code fixes aren't a good idea any more) -- Jo Rhett Net Consonance : consonant endings by net philanthropy, open source and

Re: [rt-users] rename Nobody ?

2009-09-28 Thread Jesse Vincent
On Mon, Sep 28, 2009 at 05:09:49PM -0700, Jo Rhett wrote: One of the managers here wants to rename the Nobody user to have a different name.Can this be done without a code change? To a first sapproximation, no, you can't do that. It would take some real work. (I'm leaving SVcolo on

Re: [rt-users] rename Nobody ?

2009-09-28 Thread Jo Rhett
On Sep 28, 2009, at 6:29 PM, Jesse Vincent wrote: On Mon, Sep 28, 2009 at 05:09:49PM -0700, Jo Rhett wrote: One of the managers here wants to rename the Nobody user to have a different name.Can this be done without a code change? To a first sapproximation, no, you can't do that. It would