Re: [rt-users] A problem with Ticket Search

2009-02-02 Thread Emmanuel Lacour
On Wed, Jan 14, 2009 at 02:58:28AM -0800, anusiak wrote: I am a begginer RT administrator, and we are using RT with our company's user support system. We have about 10 or more e-mail addresses/users in RT database at the moment, and trying to enter search engine, run simple search or

Re: [rt-users] New Created Queues are not visible in RT after upgrade.

2009-02-02 Thread Emmanuel Lacour
On Sat, Jan 31, 2009 at 08:51:58PM +0500, Rana Tanveer wrote: Hi RT Users/Admins I have upgraded my RT from 3.6.5 to 3.8.1 after reading UPGRADING.mysql and other relevant documents. it seems working fine now. but i am facing one problem. when i create new Queue and assign its user/group

Re: [rt-users] Anyone get Exchange working?

2009-02-02 Thread Martin Maurer
Hi, I am just working on a howto for our RT virtual appliance - with exchange: http://pve.proxmox.com/wiki/RT_Request_Tracker#Integrate_RT_to_Exchange_ Server_2000.2F2003_environment (should be finished end of week) In short: - I prefer using a new user with addr...@domain.com (this is the

Re: [rt-users] Drop Attachments or Deny attachments

2009-02-02 Thread Joe Hartley
I use a script called stripmime to take out attachments and HTML formatting in emails going to RT. It's at http://www.phred.org/~alex/stripmime.html -- Joe Hartley | Sr. Linux SysAdmin Retail Solutions, Inc. 40 Sharpe Drive Cranston, RI 02920 joe.hart...@retailsolutions.com +1 401.824.5040

Re: [rt-users] RT 3.6.4, user list too long when resolving multiple tickets

2009-02-02 Thread Emmanuel Lacour
On Mon, Feb 02, 2009 at 03:57:45PM +0100, Christopher Kunz (Filoo GmbH) wrote: kem cho schrieb: Check this out: http://www.gossamer-threads.com/lists/rt/users/81858#81858 Nice workaround, works fine for me. Owner change is very rarely used in our setup, anyway. Yes, but it

Re: [rt-users] RT 3.6.4, user list too long when resolving multiple tickets

2009-02-02 Thread Ruslan Zakirov
Sorry :) you've already analyzed this with Emmanuel. On Mon, Feb 2, 2009 at 6:42 PM, Ruslan Zakirov ruslan.zaki...@gmail.com wrote: SELECT * FROM ACL WHERE RightName = 'OwnTicket'; paste here It can be a role on a queue. On Mon, Feb 2, 2009 at 3:33 PM, Christopher Kunz (Filoo GmbH)

Re: [rt-users] RT 3.6.4, user list too long when resolving multiple tickets

2009-02-02 Thread Christopher Kunz (Filoo GmbH)
Emmanuel Lacour schrieb: On queue with Id 33, you gave right OwnTicket to Group 5 and Group 5 is usually the Unprivileged group! I removed that privilege from the respective queue (it is a test queue that was never actually used), and double-checked all other queues. However, I found a couple

Re: [rt-users] RT 3.6.4, user list too long when resolving multiple tickets

2009-02-02 Thread Emmanuel Lacour
On Mon, Feb 02, 2009 at 06:44:07PM +0300, Ruslan Zakirov wrote: Sorry :) you've already analyzed this with Emmanuel. I just added this in the FAQ (section Performances) on the wiki :) http://wiki.bestpractical.com/view/FAQ ___

Re: [rt-users] RT 3.6.4, user list too long when resolving multiple tickets

2009-02-02 Thread Emmanuel Lacour
On Mon, Feb 02, 2009 at 05:03:26PM +0100, Christopher Kunz (Filoo GmbH) wrote: Emmanuel Lacour schrieb: On queue with Id 33, you gave right OwnTicket to Group 5 and Group 5 is usually the Unprivileged group! I removed that privilege from the respective queue (it is a test queue that was

Re: [rt-users] RT 3.6.4, user list too long when resolving multiple tickets

2009-02-02 Thread Christopher Kunz (Filoo GmbH)
Emmanuel Lacour schrieb: On Mon, Feb 02, 2009 at 05:03:26PM +0100, Christopher Kunz (Filoo GmbH) wrote: Emmanuel Lacour schrieb: On queue with Id 33, you gave right OwnTicket to Group 5 and Group 5 is usually the Unprivileged group! I removed that privilege from the respective queue (it is a

Re: [rt-users] RT full text indexing with PostgreSQL

2009-02-02 Thread Kenneth Marshall
On Sun, Feb 01, 2009 at 09:41:42PM -0600, Kenneth Marshall wrote: I just updated the PostgreSQLFullText pages on the wiki with the triggers to keep the parsed document columns updated whenever there is a change to the dependent columns. Here are the commands for adding the triggers to keep

Re: [rt-users] queue tag moved from left of subject to right of subject?

2009-02-02 Thread Jesse Vincent
On Sun, Feb 01, 2009 at 03:58:23PM -0500, Jerrad Pierce wrote: From this point forward, the tag in the e-mail will be on the right instead of the left. I cannot figure out exactly what causes this shift. Can someone clue me in? Can we prevent it? Same thing occurs here. Never really

Re: [rt-users] queue tag moved from left of subject to right of subject?

2009-02-02 Thread Jerrad Pierce
On Sun, Feb 01, 2009 at 03:58:23PM -0500, Jerrad Pierce wrote: From this point forward, the tag in the e-mail will be on the right instead of the left. I cannot figure out exactly what causes this shift. Can someone clue me in? Can we prevent it? Same thing occurs here. Never really

Re: [rt-users] RT 3.6.4, user list too long when resolving multiple tickets

2009-02-02 Thread Christopher Kunz (Filoo GmbH)
Emmanuel Lacour schrieb: On Mon, Feb 02, 2009 at 01:33:19PM +0100, Christopher Kunz (Filoo GmbH) wrote: Emmanuel Lacour schrieb: you seems to gave OwnTicket right to everyone or unprivileged users, check your permissions. Any other ideas? Is DBIx::SearchBuilder up to date? Yes, it's

Re: [rt-users] Anyone get Exchange working?

2009-02-02 Thread GravyFace
Forwarders! I completely overlooked that. I was trying to share address space between both boxes using the KB article on the subject and was having no luck. Working like a charm now, and don't have to mess with my default policies at all. I actually created two distributions groups: one for

[rt-users] RLIKE Query?

2009-02-02 Thread Jerrad Pierce
Is there any way to use RLIKE from the GUI? I see nothing on the wiki nor list archives, and Advanced Query Builder barfs :-/ In this case I'm just doing alternation so I can explode the query, but it's ugly and there are other times where that won;t be an option... -- Cambridge Energy Alliance:

[rt-users] Setting up Rights for Multiple Clients

2009-02-02 Thread GravyFace
I'm following along on ItsFinallyInstalledNowWhat and Rights wiki entries and while the Rights has described something similar to what we want to achieve, I'm not sure if it's going to provide the kind of client separation we want. We provide IT support for a few dozen small businesses. Most of

Re: [rt-users] RT 3.6.4, user list too long when resolving multiple tickets

2009-02-02 Thread Daksh Chauhan
I agree with Emmanuel that workaround does not really provide a fix on this issue. I have read and followed this issue (of users list too long, or QueryBuilder and Bulk update page takes too long to load) for a while. FYI: I am running RT 3.8.1 on opensuse11; perl 5.10; mysql 5.0 I did not see

Re: [rt-users] queue tag moved from left of subject to right of subject?

2009-02-02 Thread Jerrad Pierce
In particular, I have the following local/lib/RT/Interface/Email_Local.pm: http://codepad.org/pSthWrxD -- Cambridge Energy Alliance: Save money. Save the planet. ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help:

Re: [rt-users] RT 3.8.2 question

2009-02-02 Thread Jerrad Pierce
On Wed, Jan 7, 2009 at 15:21, Kenneth Crocker kfcroc...@lbl.gov wrote: To all, We are planning to move up to 3.8.2 soon (a month?). One of the tings my users do not like is that there are many CF's that are sowing up in their Modify Ticket screen that some use, some don't ,but needs to

Re: [rt-users] RT 3.6.4, user list too long when resolving multiple tickets

2009-02-02 Thread Emmanuel Lacour
On Mon, Feb 02, 2009 at 02:53:43PM +0100, Christopher Kunz (Filoo GmbH) wrote: Yes, it's current: cpan[12] r DBIx::SearchBuilder All modules are up to date for DBIx::SearchBuilder Do you still get unprivileged users if you access this directly: http:///rt/Elements/SelectOwner ?

Re: [rt-users] queue tag moved from left of subject to right of subject?

2009-02-02 Thread Jesse Vincent
On Mon, Feb 02, 2009 at 03:53:18PM -0500, Jerrad Pierce wrote: In particular, I have the following local/lib/RT/Interface/Email_Local.pm: http://codepad.org/pSthWrxD Does RT work correctly without your custom code? -- Cambridge Energy Alliance: Save money. Save the planet. --

Re: [rt-users] RT 3.6.4, user list too long when resolving multiple tickets

2009-02-02 Thread Emmanuel Lacour
On Mon, Feb 02, 2009 at 01:33:19PM +0100, Christopher Kunz (Filoo GmbH) wrote: Emmanuel Lacour schrieb: you seems to gave OwnTicket right to everyone or unprivileged users, check your permissions. Any other ideas? Is DBIx::SearchBuilder up to date?

[rt-users] replytoticket, modifyticket and change queue right

2009-02-02 Thread Michal Svoboda
Hi, in my RT setup I need to distinguish two groups of people: 1) internal staff which may not directly communicate with requestor 2) support manager who may I understand that the comment/correspondence mechanism is suitable for this scenario. However, it is important that the internal staff

Re: [rt-users] RT 3.6.4, user list too long when resolving multiple tickets

2009-02-02 Thread Christopher Kunz (Filoo GmbH)
Emmanuel Lacour schrieb: select * from ACL where RightName='OwnTicket'; mysql select * from ACL where RightName='OwnTicket'; +--+---+-+---++--+-+---+ | id | PrincipalType | PrincipalId | RightName | ObjectType

Re: [rt-users] queue tag moved from left of subject to right of subject?

2009-02-02 Thread Jerrad Pierce
Doh! Must amend $ExtractSubjectTagMatch in RT_SiteConfig to match the RE in my code. (Actually, why does RT::Interface::Email have a mix of config hard-coded regexpen?) ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community

Re: [rt-users] RT 3.6.4, user list too long when resolving multiple tickets

2009-02-02 Thread Ruslan Zakirov
SELECT * FROM ACL WHERE RightName = 'OwnTicket'; paste here It can be a role on a queue. On Mon, Feb 2, 2009 at 3:33 PM, Christopher Kunz (Filoo GmbH) ch...@de-punkt.de wrote: Emmanuel Lacour schrieb: you seems to gave OwnTicket right to everyone or unprivileged users, check your

[rt-users] Security risk! Passwords can be compromised!

2009-02-02 Thread Akash
Hi all, When I enabled logging of stack traces, the user passwords are being written in cleartext in the log files! I enabled stack tracing by adding the the following line in RT_SiteConfig.pm: Set($LogStackTraces, 4); Can somebody please fix this serious error so that passwords are encrypted?

Re: [rt-users] RT 3.6.4, user list too long when resolving multiple tickets

2009-02-02 Thread kem cho
Check this out:   http://www.gossamer-threads.com/lists/rt/users/81858#81858 --- On Mon, 2/2/09, Christopher Kunz (Filoo GmbH) ch...@de-punkt.de wrote: From: Christopher Kunz (Filoo GmbH) ch...@de-punkt.de Subject: [rt-users] RT 3.6.4, user list too long when resolving multiple tickets To:

Re: [rt-users] RT 3.6.4, user list too long when resolving multiple tickets

2009-02-02 Thread Christopher Kunz (Filoo GmbH)
kem cho schrieb: Check this out: http://www.gossamer-threads.com/lists/rt/users/81858#81858 Nice workaround, works fine for me. Owner change is very rarely used in our setup, anyway. Regards, --ck -- Christopher Kunz | Geschäftsführung | ch...@filoo.de Filoo GmbH | Tilsiter

Re: [rt-users] RT (request racker) mail sending configuration

2009-02-02 Thread Bruno Guimarães Sousa
I created an account in my mail server just for that. I am imagining something like this: 1) RT wants to send a message to a recipient, then it requests localhost for that 2) Localhost is configured with exim4 and for every smtp request it authenticates in the mail server with an specific account

Re: [rt-users] RT 3.6.4, user list too long when resolving multiple tickets

2009-02-02 Thread Emmanuel Lacour
On Mon, Feb 02, 2009 at 04:13:52PM +0100, Christopher Kunz (Filoo GmbH) wrote: Emmanuel Lacour schrieb: select * from ACL where RightName='OwnTicket'; mysql select * from ACL where RightName='OwnTicket';

Re: [rt-users] RT 3.6.4, user list too long when resolving multiple tickets

2009-02-02 Thread Emmanuel Lacour
On Mon, Feb 02, 2009 at 01:15:30PM +0100, Christopher Kunz (Filoo GmbH) wrote: Hi all, since our upgrade to RT 3.6.4, the resolve multiple tickets functionality shows erratic behavior in my installation. When before, it only showed the privileged users (which are in the ballpark of 3-10 per

Re: [rt-users] RT 3.6.4, user list too long when resolving multiple tickets

2009-02-02 Thread Christopher Kunz (Filoo GmbH)
Emmanuel Lacour schrieb: you seems to gave OwnTicket right to everyone or unprivileged users, check your permissions. Currently, global Group Rights are as follows: Everyone: CreateTicket Privileged: ShowOutgoingEmail Unprivileged: CreateTicket, ReplyToTicket, ShowOutgoingEmail, Watch

Re: [rt-users] Security risk! Passwords can be compromised!

2009-02-02 Thread Jo Rhett
On Feb 2, 2009, at 2:26 PM, Akash wrote: Also, if a 3.8.2 port is available, is it stable enough to update my 3.8.1 version? The 3.8.2 port update is here: http://www.freebsd.org/cgi/query-pr.cgi?pr=131167 And we've been running it for a week with no problems. The change from 3.8.1 to

Re: [rt-users] Security risk! Passwords can be compromised!

2009-02-02 Thread Jesse Vincent
Akash, Just as a general point of etiquette, it's customary to notify vendors of security related issues privately before publicly announcing them. Posting the details of security-related issues to a public mailinglist without giving the folks who make a package to address a potential

Re: [rt-users] queue tag moved from left of subject to right of subject?

2009-02-02 Thread Jo Rhett
On Feb 2, 2009, at 9:54 AM, Jesse Vincent wrote: This is the subject-token extraction kicking in. It's designed to let two RT's talk to each other. There's a global scrip. I'm not sure why it would kick in for your own RT's tag though. Patches gratefully appreciated. Okay, so it seems

Re: [rt-users] queue tag moved from left of subject to right of subject?

2009-02-02 Thread Jesse Vincent
Likewise, I assume that if I got off my butt and created a patch which set this list based on all of the configured subject tags you'd be okay with that? Certainly. It probably makes sense to extract the code from lib/RT/Interface/Email.pm's ParseTicketId so it can be used by both.

Re: [rt-users] RT 3.6.4, user list too long when resolving multiple tickets

2009-02-02 Thread Stephen Turner
On Mon, 02 Feb 2009 09:57:45 -0500, Christopher Kunz (Filoo GmbH) ch...@de-punkt.de wrote: kem cho schrieb: Check this out: http://www.gossamer-threads.com/lists/rt/users/81858#81858 Nice workaround, works fine for me. Owner change is very rarely used in our setup, anyway. Regards,

[rt-users] RT 3.6.4, user list too long when resolving multiple tickets

2009-02-02 Thread Christopher Kunz (Filoo GmbH)
Hi all, since our upgrade to RT 3.6.4, the resolve multiple tickets functionality shows erratic behavior in my installation. When before, it only showed the privileged users (which are in the ballpark of 3-10 per queue), it then started to show *all* users who ever submitted tickets, including

[rt-users] Scrip send email on create

2009-02-02 Thread Dan O'Neill
Enclosed is a script that adds one or more AdminCC's to a ticket during Create. This does not cause the AdminCC's to receive an email. How do I modify this Scrip or otherwise configure the Queue such that AdminCC's will receive a copy of the text in the opening transaction? Here is the scrip

Re: [rt-users] queue tag moved from left of subject to right of subject?

2009-02-02 Thread Jerrad Pierce
For anyone interested in using that queue name in tag hack, this is the other half to keep RT from munging subjects: Set($ExtractSubjectTagMatch, qr/\[.+?\s+(?:\w+\s+)?\#\d+\]/); Set($ExtractSubjectTagNoMatch, ( ${RT::EmailSubjectTagRegex} ?

[rt-users] Get Value of Custom Field in Custom Action

2009-02-02 Thread Sam Chenkin
Hello all, I am trying to write a custom action that pulls a custom value from a user and changes the new ticket's priority based on that value. Below is the code I've written so far. It does successfully pull values (The -Count method returns the correct number of values), but I can't GET the