Re: [rt-users] ExternalAuth workaround? while waiting for 0.9

2010-07-29 Thread Kenneth Marshall
On Thu, Jul 29, 2010 at 09:36:33AM -0400, Mike Johnson wrote: > Greetings all, > > Has anyone that is using ExternalAuth developed a workaround for the "new > user" creation issue with ExternalAuth? > > The issue was outlined in another rt-user message(I can't seem to find > now). It relates to

Re: [rt-users] Quick Syntax check for $RTAddressRegexp setting

2010-07-22 Thread Kenneth Marshall
On Thu, Jul 22, 2010 at 03:32:13PM -0400, Mike Johnson wrote: > Hi everyone, > > I just want to make sure i'm understanding the wiki properly... > > If I want to make sure RT doesn't create tickets using the following email > addresses, > > helpd...@here.ca > myhelpd...@here.ca > helpd...@there.

Re: [rt-users] Mysql queries slow

2010-07-22 Thread Kenneth Marshall
On Thu, Jul 22, 2010 at 09:52:14AM -0700, William Graboyes wrote: > Hi Ken, > > I do not have the full hardware specs. It is a hosted RT system. The specs > that I do have access to are as follows: > > Probably a dual core single CPU system, speed unknown > 2gb of ram > 80 gb hd space they are

Re: [rt-users] Mysql queries slow

2010-07-22 Thread Kenneth Marshall
On Wed, Jul 21, 2010 at 06:19:51PM -0700, William Graboyes wrote: > Hi List, > > As an example of what I am talking about the query `select count(id) from > Attachments;` The returned result is 174039, but it takes 39.1549 seconds > to return that simple query. The Transactions table returns 34

Re: [rt-users] 10 newest unowned tickets

2010-07-21 Thread Kenneth Marshall
You will need to enable using SQL for ACLs in RT_SiteConfig.pm. It is beta/testing so buyer beware... Ken On Wed, Jul 21, 2010 at 10:45:48AM -0500, Mark Jenks wrote: > I have an issue I am trying to figure out. > > > > The default search for unowned tickets is: > > Owner = 'Nobody' > > AND

Re: [rt-users] Possible?

2010-07-19 Thread Kenneth Marshall
On Mon, Jul 19, 2010 at 09:04:26AM -0700, Gene LeDuc wrote: > On 7/19/2010 4:21 AM, Jim Tambling wrote: >> Hi list, >> How would I dosomething like this in RT? I want it to apply to all >> queues/tickets. >> When due date = today, make priority = 0 >> Many thanks, Jim > > Hi Jim, > > As far as I kn

[rt-users] bug in charting for Pg

2010-07-14 Thread Kenneth Marshall
I received the following error for plotting a search by "CreatedMonthly": ERROR: column reference "created" is ambiguous at character 37 STATEMENT: SELECT COUNT(main.id) AS id, SUBSTR(Created::text,1,7) AS createdmonthly FROM Tickets main CROSS JOIN Users Users_3 JOIN Groups Groups_1 ON ( Gro

Re: [rt-users] SMTP auth in RT.

2010-07-12 Thread Kenneth Marshall
On Mon, Jul 12, 2010 at 08:03:55AM +0530, H Manohar Rayker wrote: > Hello everybody, > > > > Could anyone please show me how to implement SMTP auth technically in RT so > that I can send mails to different domain users? I tried following the wiki > but could not get clear cut idea where to make

Re: [rt-users] R??p. : Re: R??p. : Re: Query Builder froze

2010-07-06 Thread Kenneth Marshall
: > Hi Kenn, > thanks for your answer. > > How can I see the QueryBuilder's executed query ? > > Regards, > Horst > > > >>> Le Mardi, 6. Juillet 2010 ?? 14:57, Kenneth Marshall > a ??crit : > Hi Horst, > > Is the query hitting the D

Re: [rt-users] R??p. : Re: Query Builder froze

2010-07-06 Thread Kenneth Marshall
Hi Horst, Is the query hitting the DB the same with the CLI versus QueryBuilder? Maybe you are hitting a resource limit when the request goes through the web server. Try checking the system and web server logs to see if there is any more information. If it is not generating the same query, then th

Re: [rt-users] Understanding behavior of Ticket->SetOwner()

2010-07-02 Thread Kenneth Marshall
On Fri, Jul 02, 2010 at 01:04:22PM -0500, Hussam Dawood wrote: > On 06/25/2010 08:31 AM, Kenneth Marshall wrote: >> On Fri, Jun 25, 2010 at 08:21:55AM -0500, Hussam Dawood wrote: >>> We are running a mod_perl2 (2.0.4) REST application (using apache 2.2.9) >>> that handle

Re: [rt-users] Slow Ticket History 3.8.8

2010-07-01 Thread Kenneth Marshall
On Thu, Jul 01, 2010 at 02:30:56PM +0100, Justin Hayes wrote: > Hi Roy, > > We've logged the SQL statements on the test server - virtually every query is > .000s of a second. Yet the ticket we're using on there still takes 12s to > render. > > So the queries seem ok. However I know that having

Re: [rt-users] RT::Authen::ExternalAuth - Update LDAP information

2010-06-25 Thread Kenneth Marshall
On Fri, Jun 25, 2010 at 04:33:14PM +0200, Matthias Rieber wrote: > Hi, > > I've a few questions about RT::Authen::ExternalAuth module. I've installed > it and I can: > > 1. Authenticate using LDAP accounts and > 2. Email addresses in new tickets will be looked up, and the configured > values lik

Re: [rt-users] Understanding behavior of Ticket->SetOwner()

2010-06-25 Thread Kenneth Marshall
On Fri, Jun 25, 2010 at 08:21:55AM -0500, Hussam Dawood wrote: > Hello, > > We are running a mod_perl2 (2.0.4) REST application (using apache 2.2.9) > that handles various ticket operations for us using RT (rt-3.6.7 backed by > MySQL 5.0.51a). These operations include creating tickets, setting ow

Re: [rt-users] SMTP auth for RT.

2010-06-21 Thread Kenneth Marshall
Try this article: http://www.sendmail.org/~ca/email/auth.html Cheers, Ken On Mon, Jun 21, 2010 at 05:00:58PM +0530, H Manohar Rayker wrote: > Hi, > > > > > > How can I set SMTP authentication for the outgoing mails in RT? > > > > I have RT 3.8.4 , Centos 5.3, sendmail 8.13.8, mysql

Re: [rt-users] RT Theme

2010-06-17 Thread Kenneth Marshall
On Thu, Jun 17, 2010 at 08:59:33AM -0400, borngunn...@aol.com wrote: > > > > I will like to change the team of my RT but I don't know how to go about it. > Can someone lead me to the path of the web theme and what to do in changing > the theme to my own customizable css. I have RT 3.8.8 on U

Re: [rt-users] How do I exclude a global scrip for specific queues

2010-06-16 Thread Kenneth Marshall
and EditScrips) > that needs to be replaced in RT if using this extension. > > On Wed, Jun 16, 2010 at 9:26 AM, Kenneth Marshall wrote: > > Scrips are stored in the database backend and are automatically > > available to the upgraded RT software. > > > > Cheers, > &

Re: [rt-users] How do I exclude a global scrip for specific queues

2010-06-16 Thread Kenneth Marshall
Scrips are stored in the database backend and are automatically available to the upgraded RT software. Cheers, Ken On Wed, Jun 16, 2010 at 09:24:23AM -0400, slamp slamp wrote: > Thank you for the suggestion. I would use that if it was part of RT > itself however it would just be a pain to keep RT

Re: [rt-users] Storing messages containing invalid encodings

2010-06-15 Thread Kenneth Marshall
On Tue, Jun 15, 2010 at 02:07:36PM -0400, Jesse Vincent wrote: > > > > I would chose any approach that keeps bad data out of the database, > > in this case incorrect UTF-8. > > That's sort of a non-starter for me. On the open Internet, bad data is > a reality. RT needs to be able to deal. I su

Re: [rt-users] Storing messages containing invalid encodings

2010-06-15 Thread Kenneth Marshall
On Tue, Jun 15, 2010 at 06:24:13PM +0100, Dominic Hargreaves wrote: > Hello, > > We have found that messages from one particular sender are declared > as being in a UTF8 encoding, but contain byte sequences which are not > valid in UTF8; in particular '0xb2', '0xb3', '0xb9' - they appear to > rela

Re: [rt-users] RT email time

2010-06-09 Thread Kenneth Marshall
On Wed, Jun 09, 2010 at 09:01:34AM -0400, Juan N. DLC wrote: > So then, there is no way to change this? other than move my server local > time 4 hours behind the real time? That would affect the RT GUI too. > > On Thu, Jun 3, 2010 at 11:46 AM, James Moseley > wrote: > > > I believe RT, by design

Re: [rt-users] migrating database

2010-06-09 Thread Kenneth Marshall
It is set in the RT_Config.pm/RT_SiteConfig.pm files. Ken On Wed, Jun 09, 2010 at 02:37:59PM +0200, ronald higgins wrote: > Hi All, > > We're currently running RT 3.8.0 plugging into MySQL 5.0 (local) > running on Centos 5.4. > Due to performance issues i am looking at partitioning the Attachmen

Re: [rt-users] case insensitive searching in Content?

2010-06-08 Thread Kenneth Marshall
On Tue, Jun 08, 2010 at 04:57:25PM +0200, V?clav Ovs?k wrote: > Hi Ken, > > On Tue, Jun 08, 2010 at 07:48:15AM -0500, Kenneth Marshall wrote: > > ILIKE is fine on PostgreSQL as long as the search is anchored on > > the left and there is an index. Otherwise it will do a seque

Re: [rt-users] case insensitive searching in Content?

2010-06-08 Thread Kenneth Marshall
On Tue, Jun 08, 2010 at 09:10:23AM +0200, V?clav Ovs?k wrote: > ... 3rd try to mail ... > > On Sun, Jun 06, 2010 at 02:34:58PM -0500, Kenneth Marshall wrote: > > Hi Zito, > > > > You can look in the mailing list archives for several similar "discoveries" &g

Re: [rt-users] Time taken to open ticket history

2010-06-07 Thread Kenneth Marshall
Hi Justin, The last time I looked at this problem, the slow step is simply preparing all of the transactions for the web. The biggest gains were made by pruning the list of displayed transactions to the bare minimum, by default. Then have a button to allow seeing all of the transactions, if needed

Re: [rt-users] CPU Wait Maxed Out

2010-06-01 Thread Kenneth Marshall
0 1.6 0:04.33 httpd > > > 2159 mysql 18 0 138m 8704 2792 S 0.0 0.9 0:01.67 mysqld > > > - Original Message - > From: "Kenneth Marsha

Re: [rt-users] CPU Wait Maxed Out

2010-06-01 Thread Kenneth Marshall
On Tue, Jun 01, 2010 at 09:48:24AM -0400, Eriks Goodwin-Pfister wrote: > But then my question becomes, "why did this happen all of a sudden?" We have > not changed user loads, usage levels, etc. This is a dedicated box being > used by about 5 active users and 20 intermittent (once a week) users

Re: [rt-users] Search results anomaly

2010-05-17 Thread Kenneth Marshall
text, not HTML). > > So, that sounds like the problem. I wish that translated > to an obvious solution for me, but it doesn't :) > > On 5/17/2010 3:50 PM, Kenneth Marshall wrote: >> Hi Jeff, >> >> Here is a link to some PostgreSQL documentation on setting >&g

Re: [rt-users] Search results anomaly

2010-05-17 Thread Kenneth Marshall
on, May 17, 2010 at 03:30:27PM -0400, Jeff Blaine wrote: > On 5/17/2010 3:26 PM, Kenneth Marshall wrote: >> Hi Jeff, >> >> Those are just what I would have expected. I would take one >> of the results from the second set of 77 and figure out why >> it is not matc

Re: [rt-users] Search results anomaly

2010-05-17 Thread Kenneth Marshall
tionId = Transactions_1.id ) > WHERE (Transactions_1.ObjectType = 'RT::Ticket') >AND (main.Status != 'deleted') >AND ( ( Attachments_2.Content ILIKE '%linode%' ) AND main.Owner = > '66') >AND (main.Type = 'ticket&#

Re: [rt-users] Search results anomaly

2010-05-17 Thread Kenneth Marshall
Owner = jsmith" > > 77 results, all of which have "members.linode" in the content. > > On 4/26/2010 5:32 PM, Jeff Blaine wrote: >> On 4/26/2010 5:04 PM, Kenneth Marshall wrote: >>> I am not certain what to do. For myself, I would turn on >>>

Re: [rt-users] use per-queue custom status?

2010-05-17 Thread Kenneth Marshall
Hi Michael, It looks like you should be able to set up an appropriate "approval" chain using RTx-WorkflowBuilder. Regards, Ken On Mon, May 17, 2010 at 12:07:20PM -0400, Michael W. Lucas wrote: > Hi, > > I have custom status fields set in RT_SiteConfig.pm, and they work fine. > > I'd like to ha

Re: [rt-users] Requestor email address search hangs apache process

2010-04-29 Thread Kenneth Marshall
On Thu, Apr 29, 2010 at 08:24:22AM +0100, Justin Hayes wrote: > RT3.8.4 > > If I use an unprivileged user (or a privileged user with no rights to see > queues or tickets) to create a very simple search that looks like this: > > Requestor.EmailAddress Like '' > > then the apache process handlin

Re: [rt-users] Search results anomaly

2010-04-26 Thread Kenneth Marshall
t; On 4/26/2010 4:52 PM, Kenneth Marshall wrote: >> Jeff, >> >> Are you using the Full-text index support from the wiki? > > Nope. > > Just RT 3.8.7 + RTFM 2.4.2. No add-ons/tweaks from the wiki. > >> There were some index bugs that may require you to re-index

Re: [rt-users] Search results anomaly

2010-04-26 Thread Kenneth Marshall
are using RT-3.8.5 and PostgreSQL 8.4.2 here with the full-text support without an issue. Regards, Ken On Mon, Apr 26, 2010 at 03:00:39PM -0400, Jeff Blaine wrote: > On 4/26/2010 2:19 PM, Kenneth Marshall wrote: >> Well, that knocks out the ACL issue. Do you think that your >>

Re: [rt-users] Search results anomaly

2010-04-26 Thread Kenneth Marshall
foo.com blah blah... not including in this email > foo.com matching lines 66 more times... not including in this email > [r...@rtsrv1 etc]# > > > >> Regards; >> Roy >> >> >> >> >> >> Jeff Blaine wrote: >>> On 4/26/2010 11:50

Re: [rt-users] Search results anomaly

2010-04-26 Thread Kenneth Marshall
Hi Jeff, There is nothing here that indicates a problem. It looks like an apples vs. oranges comparison by the time you include the actual parameters of the search from the web interface and the rt commandline interface and possible privilege and ACL differences. You can use DB query logging to fi

Re: [rt-users] Howto change user email

2010-04-15 Thread Kenneth Marshall
On Thu, Apr 15, 2010 at 06:08:59AM -0700, Ian Pellew wrote: > From r...@a_glance if I change a users email I get "Email address in use". > How do I change his email address? > > New installation & still finding my way with RT. > > . The E-mail addresses must be unique. Find the account(s) with t

Re: [rt-users] "homepage refresh interval" under preferences

2010-04-14 Thread Kenneth Marshall
It works for me on version 3.8.5. Cheers, Ken On Wed, Apr 14, 2010 at 02:30:21PM -0700, psminusaxl wrote: > Anybody else can chime in? I think if I can determine where and how the > "home page interval" gets triggered I can better pin point the problem. > Right now i'm clueless the process flow

Re: [rt-users] DisGrouMem index

2010-04-14 Thread Kenneth Marshall
Roy, The schema that came with RT 3.8.5 has the DisGrouMem index on CachedGroupMembers and not the GrouMem index. I would drop that latter index. Regards, Ken On Wed, Apr 14, 2010 at 02:54:01PM +0100, Raed El-Hames wrote: > Jesse; > > Ah - In my database I do also have index GrouMem (GroupId,Mem

Re: [rt-users] DisGrouMem index

2010-04-14 Thread Kenneth Marshall
If you do not have an index, won't you need to do a sequential scan of the full table each time. With 6m entries, it could take a while. Cheers, Ken On Wed, Apr 14, 2010 at 02:17:10PM +0100, Raed El-Hames wrote: > Hi; > > rt-3.8.7 > mysql 5.1 > > Is the index DisGrouMem (GroupId,MemberId,Disabled

Re: [rt-users] CommandByMail only listening to commands issued by privileged users

2010-03-29 Thread Kenneth Marshall
Bad, bad, bad, bad idea. Did I mention that this is a bad idea? :) Seriously, the CommandByMail gives a lot of access to the internals of your RT system. It can totally subvert your workflow. Imagine a generic E-mail that can close or delete any ticket in the system. What are you trying to accompli

Re: [rt-users] CommandByMail hide commands

2010-03-29 Thread Kenneth Marshall
rote: > It seems like the requestor receives mail sent to rt-comment. Or is > this a option I can disable? > > > On Tue, Mar 23, 2010 at 7:06 PM, Kenneth Marshall wrote: > > The comment address is the mail to RT that is only sent to > > admins and adminccs and not requesto

Re: [rt-users] CommandByMail hide commands

2010-03-23 Thread Kenneth Marshall
nforum but that seems death. > > P. > > On Mon, Mar 22, 2010 at 2:04 PM, Kenneth Marshall wrote: > > What about using the comment address and not the E-mail > > address. It should also be possible to make a patch to > > strip them out, maybe to a separate attachment to

Re: [rt-users] CommandByMail hide commands

2010-03-22 Thread Kenneth Marshall
What about using the comment address and not the E-mail address. It should also be possible to make a patch to strip them out, maybe to a separate attachment to help debug problems. Ken On Sun, Mar 21, 2010 at 01:39:53PM +0100, polloxx wrote: > Dear list, > > Is there a way to hide CommandByMail

Re: [rt-users] modifying From: header in global template to pull from queue description

2010-03-17 Thread Kenneth Marshall
On Wed, Mar 17, 2010 at 02:37:22PM -0400, Busalacchi, Eric wrote: > I tried searching the archive a bit for the answer but I wasn't able to > pin down exactly what I'm doing wrong. Basically we are trying to give > a friendly generic name to our queues. Management doesn't want the > "User Name vi

Re: [rt-users] Copy tickets

2010-03-16 Thread Kenneth Marshall
Could you use a scrip to do this? Ken On Tue, Mar 16, 2010 at 04:07:19PM -0500, Max McGrath wrote: > Hi All - > > I'm looking to be able to create a "template" ticket and have it be copied > when support staff are creating an actual ticket. > > If this is possible, can it copy all of the custom

Re: [rt-users] rt-shredder Users plugin deletes tickets?

2010-03-16 Thread Kenneth Marshall
I do not think I agree with this. If you ask for a user to be removed, any ticket that they have touched should go as well. Otherwise you will have unattributed updates in the system. It seems like you may have a bit too aggressive a policy for cleaning out users. Another approach is to put a bette

Re: [rt-users] Creating Child/Parent tickets with content (text) from original ticket

2010-03-12 Thread Kenneth Marshall
Okay, I found it under rt-extension-cloneticket-withdata. Thank you for the hint. Cheers, Ken On Fri, Mar 12, 2010 at 12:12:02PM -0600, Kenneth Marshall wrote: > I could not find anything using the Search box. You do not happen > to have the actual URL? > > Cheers, > Ken >

Re: [rt-users] Creating Child/Parent tickets with content (text) from original ticket

2010-03-12 Thread Kenneth Marshall
I could not find anything using the Search box. You do not happen to have the actual URL? Cheers, Ken On Fri, Mar 12, 2010 at 06:45:34PM +0100, Brumm, Torsten / Kuehne + Nagel / Ham MI-ID wrote: > Search at bps github for cloneticketwithcontent, this is what you are looking > for! > > - Or

Re: [rt-users] comment ticket with select individual users

2010-03-10 Thread Kenneth Marshall
Can you use some Javascript similar to the select all/clear all button on the bulk update screen? Cheers, Ken On Wed, Mar 10, 2010 at 09:14:16PM +, satish patel wrote: > > Hi RT Team, > > > > We are using RT system but i have a question about is there anyway to edit > code to select all

Re: [rt-users] Listing of scrips

2010-03-05 Thread Kenneth Marshall
I think that you will need to make local modifications to share/html/Admin/Queues/index.html and files/functions called from there. Ken On Fri, Mar 05, 2010 at 09:34:07AM -0800, Ken Crocker wrote: > To List, > > How do I modify the way the list of scrips is displayed? I want to > remove the id

Re: [rt-users] Question on subscriptions to dashboards

2010-03-04 Thread Kenneth Marshall
There are three entries that need to be made in a crontab to support the E-mail notifications. Look in the README file for details. Cheers, Ken On Thu, Mar 04, 2010 at 09:36:28AM -0800, Ken Crocker wrote: > To list, > > We're currently testing our installation of 3.8.7. While setting up a > das

Re: [rt-users] CommandByMail Extension

2010-03-03 Thread Kenneth Marshall
t; > Kenn > LBNL > > On 3/3/2010 12:29 PM, Kenneth Marshall wrote: >> Oops, the syntax for Custom Fields using CommandByMail is >> >> CustomField.{}: >> >> or >> CF.{}: >> >> That works here with spaces. >> >> Cheers, >>

Re: [rt-users] CommandByMail Extension

2010-03-03 Thread Kenneth Marshall
Oh, and the dot (".") should not be there. You also need the latest release to fix the regex space bug. Cheers, Ken On Wed, Mar 03, 2010 at 02:29:07PM -0600, Kenneth Marshall wrote: > Oops, the syntax for Custom Fields using CommandByMail is > > CustomField.{}: > > o

Re: [rt-users] CommandByMail Extension

2010-03-03 Thread Kenneth Marshall
Oops, the syntax for Custom Fields using CommandByMail is CustomField.{}: or CF.{}: That works here with spaces. Cheers, Ken On Wed, Mar 03, 2010 at 02:09:46PM -0600, Kenneth Marshall wrote: > Since the parsing for this is via regex, maybe we can adjust > the regex used to incor

Re: [rt-users] CommandByMail Extension

2010-03-03 Thread Kenneth Marshall
Since the parsing for this is via regex, maybe we can adjust the regex used to incorporate spaces in CFs. Cheers, Ken On Wed, Mar 03, 2010 at 11:39:29AM -0800, Ken Crocker wrote: > To list, > > I've finally got CommandByMail to work with Custom Fields. Apparently, for > any Custom Field to work,

Re: [rt-users] correspondence emails not being sent

2010-03-01 Thread Kenneth Marshall
Have you check the queue specific templates? Maybe you are having the default responsed overridden with an empty/no response. Ken On Mon, Mar 01, 2010 at 01:32:40PM +, John Roman wrote: > I have a problem with email from a certain queue not getting sent. a > users corresponding to the ticke

Re: [rt-users] RT Apache memory leak. any examples of MPM settings?

2010-02-19 Thread Kenneth Marshall
It is not a memory leak, memory does not get returned to the system -- ever. So a large query can bloat the memory usage and it will not shrink. We use cron to do a "graceful" apache restart once a day. No impact to users and it handles the memory usage growth over time. Regards, Ken On Fri, Feb

Re: [rt-users] Full-text indexing on Pg (was Re: Upgrade and migration questions)

2010-01-27 Thread Kenneth Marshall
On Wed, Jan 27, 2010 at 05:49:06PM +, Dominic Hargreaves wrote: > On Wed, Jan 27, 2010 at 08:58:47AM -0600, Kenneth Marshall wrote: > > On Wed, Jan 27, 2010 at 02:45:52PM +, Dominic Hargreaves wrote: > > > > Just to note that I assume you're

Re: [rt-users] Upgrade and migration questions

2010-01-27 Thread Kenneth Marshall
On Wed, Jan 27, 2010 at 02:45:52PM +, Dominic Hargreaves wrote: > On Tue, Jan 26, 2010 at 02:12:34PM -0600, Kenneth Marshall wrote: > > > Moving from PostgreSQL -> MySQL will need a little bit more work. > > I think that there is a wiki article and possibly some tools

Re: [rt-users] Hide "The RT System itself" in History

2010-01-26 Thread Kenneth Marshall
On Tue, Jan 26, 2010 at 12:14:51PM -0800, Michael Neuschafer wrote: > Is there a way to hide or not show in the RT history "The RT System > itself" makes history look messy. > > > > Thanks, > > > > Michael Neuschafer > > PC Support Specialist > > National Stores Inc. > > (310) 436 - 2150

Re: [rt-users] Upgrade and migration questions

2010-01-26 Thread Kenneth Marshall
On Tue, Jan 26, 2010 at 11:52:27AM -0800, Tim Mitchell wrote: > Does anyone have a link that will let me know if I can go from 3.4.4 to > 3.8.4 directly? System is Ubuntu v6.06 LTS + Postgresql 7.4 > > Also any advice about moving from Postgresql to Mysql either before or after > the upgrade?

Re: [rt-users] RT and email bounces

2010-01-25 Thread Kenneth Marshall
On Mon, Jan 25, 2010 at 03:19:40PM +0100, L B wrote: > I think it's difficult for bounced emails because there is no standard > regarding this kind of emails, so it's hard to stop loops, but it > should be easier for out of office messages. The problem is that, I > think, we need to parse the email

Re: [rt-users] RT and email bounces

2010-01-25 Thread Kenneth Marshall
On Mon, Jan 25, 2010 at 02:15:47PM +0100, L B wrote: > Hi all, > > When we send email to an address that doesn't exist, ie, that bounces, > RT doesn't record the problem in the ticket. So we could be in a > situation where we think that everyone knows about the ticket, but the > email address was

Re: [rt-users] RT and spamassasin 2010 bug

2010-01-11 Thread Kenneth Marshall
On Mon, Jan 11, 2010 at 12:20:29PM -0500, David Bristow wrote: > Anybody else using spamassassin with RT? We got hit by the 2010 bug > and now we have tons of valid tickets in the SPAM queue. > > Hoping there's some scripted way to move these tickets back to the > appropriate queue. > > -- > Da

Re: [rt-users] screendumps, searching and editing

2010-01-08 Thread Kenneth Marshall
On Fri, Jan 08, 2010 at 11:42:32AM -, Tim Bonnell wrote: > I tried RT in the Spring of 2008 and though it did most of what I > wanted, there were a couple of features (or lack of them) that made me > stop. I have searched this mailing list for an update on these features, > but have failed to f

Re: [rt-users] RT Integration with Twitter?

2010-01-06 Thread Kenneth Marshall
On Tue, Jan 05, 2010 at 09:37:31PM -0500, ste...@stevencochran.com wrote: > Boss wants to know if RT can interface directly with Twitter. I think he > wants the server to send tweets, instead of paging someone. Has anyone done > anything like this? > > thanks! > You should be able to use the Net:

Re: [rt-users] Custom commands by Email

2010-01-05 Thread Kenneth Marshall
Falcone wrote: > On Tue, Jan 05, 2010 at 08:04:21AM -0600, Kenneth Marshall wrote: > > There is a documentation problem on the wiki page in the description > > for Custom field management. It describes the syntax as: > > There are tests (t/03update.t for example) that use

Re: [rt-users] Custom commands by Email

2010-01-05 Thread Kenneth Marshall
On Tue, Jan 05, 2010 at 11:45:47AM +0100, Francisco G?mez Mar?n wrote: > Niki Serakiotou escribi?: > > If the CommandByEmail plugin worked for setting Custom Fields, you could > > create a custom fields and set it. But I have not been able to set custom > > fields by mail! > > > > Has anybody tri

Re: [rt-users] Screening user list from certain accounts on ticket forms

2010-01-03 Thread Kenneth Marshall
On Sat, Jan 02, 2010 at 08:35:11PM -0500, ste...@stevencochran.com wrote: > Hello, I am looking to build concurrent queue systems insulated from each > other on the same RT server. The problem I am running into right now is that > when someone in one queue system goes to assign ownership of a ticke

Re: [rt-users] limit ticket owners dropdown box by group memberships

2009-12-21 Thread Kenneth Marshall
On Mon, Dec 21, 2009 at 04:59:07PM -0500, Kevin Falcone wrote: > On Mon, Dec 21, 2009 at 03:38:45PM -0600, Kenneth Marshall wrote: > > Does anyone have a recipe to restrict the ticket Owner dropdown > > box to the members in a group? By default, it looks like all > > privil

[rt-users] limit ticket owners dropdown box by group memberships

2009-12-21 Thread Kenneth Marshall
Does anyone have a recipe to restrict the ticket Owner dropdown box to the members in a group? By default, it looks like all privileged users are in the dropdown and for the queues in question, only members of a particular group can own tickets so just seeing the pre-trimmed list would really help.

Re: [rt-users] problem with basic configuration of rt-3.8.7 stripping domainname from incoming emails and setting default values

2009-12-21 Thread Kenneth Marshall
On Mon, Dec 21, 2009 at 03:37:01PM +0100, Jeroen Baten wrote: > Hi, > > I have 2 probably very simple questions: > > question 1: > === > I have a basic auth working with autocreate users. > The usernames are without domainname. It works, I'm happy. > > I have a form that does ticket crea

Re: [rt-users] RT with authenticated mail server

2009-12-11 Thread Kenneth Marshall
On Fri, Dec 11, 2009 at 01:37:56PM +0530, Jignesh Parmar wrote: > Hi > > I have a setup where RT is installed in specific server with it's own email > system. > And we have setup mails in such a way that my corporate group email id has > one additional email as RT's email id, so the ticket is get

[rt-users] UseSQLForACLChecks bug in graph/charting

2009-12-09 Thread Kenneth Marshall
FYI, To any users of the UseSQLForACLChecks option, we noticed a problem with that option and the graph/chart functions in our RT 3.4.5 instance using a PostgreSQL 8.4.1 backend. If the user in question had SuperUser rights, the results from the ticket search matched the count of results in the gr

[rt-users] Schema problem with RT

2009-12-09 Thread Kenneth Marshall
Dear RT developers, I have been investigating a problem with the automatic account creation process. I have been getting "could not load user" errors when internal users where trying to test from their external E-mail accounts to verify functionality. The upshot of my investigation is that the sch

Re: [rt-users] Help reverting RT 3.8.6 back to displaying username instead of RealName

2009-12-07 Thread Kenneth Marshall
On Sun, Dec 06, 2009 at 11:12:56PM +1300, Aaron Guise wrote: > Hi, > > Just updated to RT 3.8.6, all looks well but on rt 3.8.0 all users were > listed in select box and transaction history as username i.e aguise for > myself. RT 3.8.6 is displaying the full name (Aaron Guise) . Our users > ar

Re: [rt-users] Requester details in query

2009-12-04 Thread Kenneth Marshall
On Fri, Dec 04, 2009 at 10:09:49AM -0700, Randy Smith wrote: > Kenneth Marshall wrote: > > On Thu, Dec 03, 2009 at 03:36:42PM -0700, Randy Smith wrote: > >> Greetings, > >> > >> I want to create a printable report that lists open tickets in a queue > >&

Re: [rt-users] Requester details in query

2009-12-03 Thread Kenneth Marshall
On Thu, Dec 03, 2009 at 03:36:42PM -0700, Randy Smith wrote: > Greetings, > > I want to create a printable report that lists open tickets in a queue > that includes requester details including phone and address. > > Is there a way to do that with the query builder or do I have to whip > out my pe

Re: [rt-users] Slow queries building list of privileged users (Postgres)

2009-11-20 Thread Kenneth Marshall
On Fri, Nov 20, 2009 at 04:14:52PM +, Dominic Hargreaves wrote: > On Fri, Nov 20, 2009 at 08:02:46AM -0600, Kenneth Marshall wrote: > > On Fri, Nov 20, 2009 at 11:41:50AM +, Dominic Hargreaves wrote: > > > I'm migrating from an RT 2 install to an RT 3.8 instal

Re: [rt-users] Slow queries building list of privileged users (Postgres)

2009-11-20 Thread Kenneth Marshall
On Fri, Nov 20, 2009 at 11:41:50AM +, Dominic Hargreaves wrote: > I'm migrating from an RT 2 install to an RT 3.8 install with around > 170 privileged users (and around 90,000 total users). > > I've done some initial testing with RT 3.8.6 and have observed > that building the list of privilege

Re: [rt-users] Search Results Display

2009-11-10 Thread Kenneth Marshall
On Tue, Nov 10, 2009 at 02:05:40PM -0500, Waller, Bradley wrote: > I have been looking all over the net and can't find an answer. Here is > what my problem is: When I do a search I want the results to include > the Requestors Address1 field, but cannot figure out how to make it > display. I figure

Re: [rt-users] Cookies Problem with RT 3.8.5

2009-11-04 Thread Kenneth Marshall
On Wed, Nov 04, 2009 at 03:19:44PM +0530, Varun wrote: > Hello All > > > > Yesterday I have upgraded from 3.6.3 to 3.8.5 all has works well. But I m > facing a strange problem for e.g. I have logged with root user and all > operations works fine but when I logged in with other user after loggin

Re: [rt-users] UseSQLForACLChecks causes slow performance

2009-10-31 Thread Kenneth Marshall
On Sat, Oct 31, 2009 at 11:21:08AM +, Justin Hayes wrote: > I've just upgraded to 3.8.4 and as part of that I've enabled > UseSQLForACLChecks > > RT_SiteConfig.pm:Set($UseSQLForACLChecks, 1); > > However this really slows down load of the homepage. For example with > my default layout loa

Re: [rt-users] Email completion and LDAP authentication

2009-10-13 Thread Kenneth Marshall
You need all of the plugins listed on the same line, not two separate lines. Ken On Tue, Oct 13, 2009 at 07:58:06PM +0300, Jac Gubbels wrote: > Hi, > > I am having trouble running two plugins at the same time. Probably i am > missing something stupid. Here is a snipped of my RT_SiteConfig.pm. >

Re: [rt-users] email filter that sets ticket via subject lookup?

2009-10-09 Thread Kenneth Marshall
On Fri, Oct 09, 2009 at 09:27:15AM -0400, Kevin Falcone wrote: > On Thu, Oct 08, 2009 at 11:12:11PM -0500, Robert Eden wrote: > > On 10/8/2009 9:02 AM, Kevin Falcone wrote: > > > On Wed, Oct 07, 2009 at 11:24:50PM -0500, Robert Eden wrote: > > > > > >> Howdy All. > > >> > > >> We work with a ven

Re: [rt-users] adding stuff to emails

2009-10-07 Thread Kenneth Marshall
This is the approach we use. We did make a custom field called send resolve notice that is set to yes initially and then to no after the resolve notice is sent. Then the second resolve does not send an E-mail. We may eventually add a one-click resolve button to just change the status but it has not

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, > >

Re: [rt-users] On saving changes to a ticket edit page displayed

2009-08-21 Thread Kenneth Marshall
On Fri, Aug 21, 2009 at 11:19:12AM -0400, Jerrad Pierce wrote: > > One reason is that certain scip actions can be based on the settings > > of particular fields. So you need to first set one field and then > > another to produce the correct action. One field we have is whether > > or not to send E-

Re: [rt-users] On saving changes to a ticket edit page displayed

2009-08-21 Thread Kenneth Marshall
On Fri, Aug 21, 2009 at 10:54:10AM +1000, gor...@cryologic.com wrote: > I know this has been mentioned before but I haven't been able to find in > the lists the reason for this small, possible inconsistency. > > When you "Update" a ticket after adding a comment the modified ticket is > displayed

Re: [rt-users] Massive memory usage

2009-08-20 Thread Kenneth Marshall
On Thu, Aug 20, 2009 at 11:48:13AM -0700, Nick Kartsioukas wrote: > I'm running a few instances of RT on a Debian 5.0 box, Apache 2.2.9, > fastcgi 2.4.6, RT 3.8.2. I'm noticing the mason_handler.fcgi processes > are taking up quite a bit of memory. One RT instance's processes are > using ~35 megs

Re: [rt-users] ticket info displayed in header

2009-08-19 Thread Kenneth Marshall
On Wed, Aug 19, 2009 at 05:12:34PM -0400, Jerrad Pierce wrote: > > I will add a second to the do not use queue name camp. It also gets > > very ugly if a ticket changes queues. Maybe your setup is so simple > > that you only have a single queue now and forever, but if so, is > > it really going to

Re: [rt-users] ticket info displayed in header

2009-08-19 Thread Kenneth Marshall
On Wed, Aug 19, 2009 at 09:42:57PM +0200, Emmanuel Lacour wrote: > On Wed, Aug 19, 2009 at 11:45:45AM -0700, spark wrote: > > Hello all, > > New RT user here. Everything is up and running great, and we're testing > > the system for a possible enterprise deployment. > > > > One user has a request

Re: [rt-users] Installing RT - second posting of these questions

2009-08-19 Thread Kenneth Marshall
On Wed, Aug 19, 2009 at 08:55:26AM -0700, Ken Crocker wrote: > Jerrad, Ken, > > So, do I have to install these modules in a certain order? RT, RTFM, RTIR, > etc? thanks. > > Kenn > LBNL > RT should be installed first, then add the rest. Ken > On 8/18/2009 12:35 PM, Jerrad Pierce wrote: >>> Jerra

Re: [rt-users] Installing RT - second posting of these questions

2009-08-18 Thread Kenneth Marshall
No. You download it separately. Ken On Tue, Aug 18, 2009 at 11:07:53AM -0700, Ken Crocker wrote: > Jerrad, > > Is the new RTFM 2.4.2 part of the RT 3.8.4 download? > > Kenn > LBNL > > On 8/18/2009 9:40 AM, Jerrad Pierce wrote: > > --with-foo= are for specifying the (non-standard) locales of RT

Re: [rt-users] Some users are losing their rights every night

2009-08-18 Thread Kenneth Marshall
On Mon, Aug 17, 2009 at 02:38:59PM -0700, Ken Crocker wrote: > Nathan, > > This is certainly a conundrum. The only thing I can think of is that there > is some configuration setting that causes an automatic re-set OR some > setting that removes certain settings when RT is re-started. Something li

Re: [rt-users] RT Essentials, still revelant

2009-08-06 Thread Kenneth Marshall
On Thu, Aug 06, 2009 at 09:30:33AM -0400, Andrew Libby wrote: > > I'm considering the RT Essentials book, though noticed it's > publication date is in 2005. Thats almost 4 years old. > I've been using RT about that long and I fear it's changed > enough that the essentials book is not as relevant

Re: [rt-users] 3.8.4 installation issue

2009-08-04 Thread Kenneth Marshall
On Tue, Aug 04, 2009 at 08:57:58AM -0700, Joel Hartshorn wrote: > I had the same issue and found no help. I did see the offer for "paid" > services, which seems to condradict the idea that you can at least install > the software. > > I personally had to crack open each file and examine the failur

Re: [rt-users] RT feature request

2009-08-02 Thread Kenneth Marshall
On Sun, Aug 02, 2009 at 02:09:39AM -0700, Sean wrote: > Hi, > > Not sure what/where the appropriate place is for an RFE, just thought I'd > suggest it while im thinking of it. > > I'd like to suggest a way to implement a .. for lack of better terminology, a > "ticket flow" so - for example - Us

<    1   2   3   4   >