Re: [rt-users] simple one I think...
I think, you can remove this edit button by removing the right to edit saved searches. Torsten 2007/5/15, Christopher Moughan <[EMAIL PROTECTED]>: Howdy All, I am not a programmer, and the advice I have received so far has been great. I am having trouble locating where to edit the headers for the main page. ie.. ^ 10 Highest Priority Tickets I Own *Edit * * * * * I want to remove the "EDIT" part from these toolbars. I can't find the location to remove the EDIT part… Any help?? Christopher Moughan System Administrator Brown & Brown Lehigh Valley 268 Brodhead Road Bethlehem, PA 18017 Office 610-694-1814 Fax 610-974-9791 *IMPORTANT: *Insurance coverage can not be bound, amended or changed via voicemail, facsimile or Email message without confirmation from an authorized Brown & Brown representative. *NOTICE:* The information contained in this electronic message is legally privileged and confidential and is intended for the use of the individual or entity named above. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution or copy of this message is strictly prohibited. If you have received this communication in error, please contact the sender by reply email and destroy all electronic and printed copies of this message. ___ 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 -- MFG Torsten Brumm http://www.torsten-brumm.de ___ 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] Regex for ExtractCustomFieldValue
I'm testing this out but am weak on the Regex front. The value I'm going to be extracting from emails is on a line that looks like CUSTOMER ENVIRONMENT customer_name The customer_name will never have spaces Would the Regex be CUSTOMER ENVIRONMENT\s+(\w) If not, could someone help me out? Mathew -- Keep up with me and what I'm up to: http://theillien.blogspot.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] RTFM 2.2.0RC4 bug (with RT 3.6.3): Search not working for values of Cfs with type "select one value"
Dirk, could please try the latest svn code, I hope I've fixed the problem you're seeing. On 5/1/07, Jesse Vincent <[EMAIL PROTECTED]> wrote: Hm. Having just tested, this patch breaks sh-2.05b# export PERL5LIB=/opt/rt3/lib sh-2.05b# prove -lv t/ArticleCollection_Overlay.pm.t for me. On Apr 28, 2007, at 2:48 AM, Dirk Pape wrote: > http://page.mi.fu-berlin.de/~pape/rt3/patches/rtfm/2.2.0RC5/ > artice_cf_search.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 -- 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] http vs https problem
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Tue, 15 May 2007 at 17:01 (-0700), mike wrote:
I also had that issue when migrating to 3.6.3, using mod_rewrite to
redirect http to https, and resolved it in the exact same manner. we
didn't have this issue running the 3.2.x release, but i never bothered
diffing to see when that change was added. i couldn't find any other
way to fix it, and couldn't understand the need to explicitly set the
server port env variable anyways, so i just called it "fixed" and moved
on to my next problem :). The only difference is that in my config, I
set $WebBaseURL to the non-https URL, since we've no need for SSL when
accessing RT from inside the private network.
I had to apply the 'hack' (see below) because I'm running on a virtual app
server where the apache instance that points to RT is at 'localhost' and
the outward-facing apache is a reverse proxy. So the latter listens at
port 443 but the inner one that runs RT uses a high numbered port assigned
to my own apache instance. Until I commented out the 'SERVER_PORT' line,
I got weird results (including a popup error message in Firefox under some
circumstances), no matter what I set $WebPort to).
All of which is to say that I still don't understand the intended use of
$WebPort, which didn't exist in earlier RT releases anyway. I ended up
setting it to 443 (I figured it needed some value), but I overrode its use
by constructing my $WebURL explicitly and commenting out the 'SERVER_PORT'
line in the code as shown below.
Mike
===
On 5/15/07, Robert Long <[EMAIL PROTECTED]> wrote:
We ran into that problem as well and we fixed it via this hackish-ness:
in RT/Interface/Web.pm . At around line 194 you will see something that
looks like this:
if ($uri->host eq $server_uri->host &
$uri->port eq $server_uri->port) {
$uri->host($ENV{'HTTP_HOST'});
# $uri->port($ENV{'SERVER_PORT'});
}
Make sure that "$uri->port($ENV{'SERVER_PORT'});" is commented out.
If you look at what the webclient is being told to access, it ends up
being something like "https://:80"- which fails. I doubt
this is the correct way to fix this problem, but after it started
working we kinda lost interest ...
_
Mike FriedmanInformation Services & Technology
[EMAIL PROTECTED] 2484 Shattuck Avenue
1-510-642-1410 University of California at Berkeley
http://socrates.berkeley.edu/~mikef http://ist.berkeley.edu
_
-BEGIN PGP SIGNATURE-
Version: PGP 6.5.8
iQA/AwUBRkp0Bq0bf1iNr4mCEQLpGQCcCz3konAkk/pBeqss5LJMCHuBEs8An2zU
1eroNtFex0rIH8jFzISNZ3Xt
=BMU0
-END PGP SIGNATURE-
___
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] http vs https problem
I also had that issue when migrating to 3.6.3, using mod_rewrite to redirect
http to https, and resolved it in the exact same manner. we didn't have
this issue running the 3.2.x release, but i never bothered diffing to see
when that change was added. i couldn't find any other way to fix it, and
couldn't understand the need to explicitly set the server port env variable
anyways, so i just called it "fixed" and moved on to my next problem :).
The only difference is that in my config, I set $WebBaseURL to the non-https
URL, since we've no need for SSL when accessing RT from inside the private
network.
On 5/15/07, Robert Long <[EMAIL PROTECTED]> wrote:
We ran into that problem as well and we fixed it via this hackish-ness:
in RT/Interface/Web.pm . At around line 194 you will see something that
looks like this:
if ($uri->host eq $server_uri->host &
$uri->port eq $server_uri->port) {
$uri->host($ENV{'HTTP_HOST'});
# $uri->port($ENV{'SERVER_PORT'});
}
Make sure that "$uri->port($ENV{'SERVER_PORT'});" is commented out.
If you look at what the webclient is being told to access, it ends up
being something like "https://:80"- which fails. I doubt this
is the correct way to fix this problem, but after it started working we
kinda lost interest ...
.r'
Petr Grolmus wrote:
> Hello,
>
> I have got a problem with RT runnig simultaneously on http and https
ports.
> On the https port we are using WebAuth authentication for internal
users,
> whereas on http port remains RT-authentication for external users.
>
> With this setting in RT_SiteConfig.pm:
>
> Set($WebPath , "/rt");
> Set($WebBaseURL , "https://rtest2.zcu.cz";);
>
> works everything fine on https, but when I click on several submit
button
> on http port - e.g. Search (main page) or Update Ticket (in Reply) -
> I always get:
>
> "The connection to rtest2.zcu.cz:80 has terminated unexpectedly. Some
> data may have been transferred."
>
> It seems it try to communicate on http port with https protocol. When I
> switch settings to:
>
> Set($WebBaseURL , "http://rtest2.zcu.cz";);
>
> then works everything fine on http port, whereas on https I get "Bad
> request" with click on the same submit buttons.
>
> I'm using RT 3.6.1 from debian package (stable branch).
> Could someone help me to avoid this behavior?
>
> Thanks,
> Petr Grolmus
>
--
> Petr Grolmus
>
> Laboratory for Computer Science
> University of West Bohemia
> Univerzitni 20, 306 14 Pilsen Tel.: +420 377 632
851
> Czech RepublicE-mail:
[EMAIL PROTECTED]
>
--
>
> ___
> 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
--
--
One way or another, everyone stops bleeding.
___
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-CRONTool Tasks
Reposting...hoping for some feedback as this is impacting our escalation strategy. Thanks, - Stark From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jeff Stark Sent: Monday, May 14, 2007 11:22 AM To: rt-users Subject: [rt-users] RT-CRONTool Tasks Hello, I am new to Perl and RT...so this may seem like an obvious question. I created a new script, much like the "EscalatePriority" script and I put it in the same directory, but when I try to call it from RT-CronTool I get the following error: Failed to load module RT::Action::ResolveInReview. () at /opt/rt3/bin/rt-crontool line 206. Can someone provide a quick list of the steps needed to get a script to work with the rt-crontool, I looked on the lists and wiki, but wasn't able to find anything. Thanks, Jeff Stark ___ 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] SVN checkout probs.
Thanks for the quick(!) reply. Now, I get timeout errors. So, I suspect that the proxy settings might not be working for the svn:// protocol. What port is being used by svn://svn.bestpractical.com? Mike The information in this message may be proprietary and/or confidential, and protected from disclosure. If the reader of this message is not the intended recipient, or an employee or agent responsible for delivering this message to the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please notify Stonebridge Bank immediately by replying to this message and deleting it from your computer. ___ 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] Problem with taking ticket under RT 3.6.3 (WebURL or WebPort issue ?)
I had a similar problem when I first installed 3.6.3. What worked for me was changing my RT_SiteConfig.pm settings to these: Set($WebPath , "/rt"); Set($WebPort , 443); Set($WebBaseURL , "https://rtserver.sdsu.edu:$WebPort";); Set($WebURL , $WebBaseURL . $WebPath . "/"); The only difference I see between what you have and mine is that I add the port number to the URL. Gene At 07:04 AM 5/15/2007, Didier Contis wrote: I have Set($WebBaseURL , "https://ceert3.ce.gatech.edu";); in my RT_SiteConfig.pm Everything is working great except when a user click to take a ticket. He is being redirected to the following URL for some reason -> https://ceert3.ce.gatech.edu:80/Ticket/Display.html?id=4 ^ This seems to happen only when someone try to take a ticket. Everything other actions work just fine. I have tried to modify the WebPort value to 443 Set($WebPort , 443); but still no luck. I must admit I am kind of loss on that one. -- Gene LeDuc, GSEC Security Analyst San Diego State University ___ 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] SVN checkout probs.
On May 15, 2007, at 5:26 PM, Michael James wrote: I installed Tortoise SVN on my WinXP box, and set up the proxy server. It works when I check out the latest release of RTx::Statistics from http://opensvn.csie.org/RTx_Statistics , for example. However, when I try to get the latest RT release from http:// svn.bestpractical.com/svn/bps/browse/rt/branches/3.6-RELEASE , I get an error: Error * PROPFIND request failed on '/' PROPFIND of '/': 405 Method Not Allowed (http://svn.bestpractical.com) I imagine this is an SVN newbie problem, but can anyone shed any light on this? Yes. You're using the wrong protocol for our repository. you want svn://, rather than http:// Jesse Thanks, Mike The information in this message may be proprietary and/or confidential, and protected from disclosure. If the reader of this message is not the intended recipient, or an employee or agent responsible for delivering this message to the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please notify Stonebridge Bank immediately by replying to this message and deleting it from your computer. ___ 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 PGP.sig Description: This is a digitally signed message part ___ 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] SVN checkout probs.
I installed Tortoise SVN on my WinXP box, and set up the proxy server. It works when I check out the latest release of RTx::Statistics from http://opensvn.csie.org/RTx_Statistics , for example. However, when I try to get the latest RT release from http://svn.bestpractical.com/svn/bps/browse/rt/branches/3.6-RELEASE , I get an error: Error * PROPFIND request failed on '/' PROPFIND of '/': 405 Method Not Allowed (http://svn.bestpractical.com) I imagine this is an SVN newbie problem, but can anyone shed any light on this? Thanks, Mike The information in this message may be proprietary and/or confidential, and protected from disclosure. If the reader of this message is not the intended recipient, or an employee or agent responsible for delivering this message to the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please notify Stonebridge Bank immediately by replying to this message and deleting it from your computer. ___ 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] Problem with taking ticket under RT 3.6.3 (WebURL or WebPort issue ?)
I had tried a full httpd restart before posting to the mailing list. It seems like the port :80 is coming from one of the module and added to whatever WebURL is set to. Didier. - Original Message - From: "Matthew Keller" <[EMAIL PROTECTED]> To: "Didier Contis" <[EMAIL PROTECTED]> Cc: rt-users@lists.bestpractical.com Sent: Tuesday, May 15, 2007 11:09:53 AM (GMT-0500) America/New_York Subject: Re: [rt-users] Problem with taking ticket under RT 3.6.3 (WebURL or WebPort issue ?) On Tue, 2007-05-15 at 10:04 -0400, Didier Contis wrote: > I have tried to modify the WebPort value to 443 > Set($WebPort , 443); > but still no luck. Did you restart your webserver after making this change? -- Didier Contis IT Manager School of CEE / Georgia Tech ___ 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] http vs https problem
We ran into that problem as well and we fixed it via this hackish-ness:
in RT/Interface/Web.pm . At around line 194 you will see something that
looks like this:
if ($uri->host eq $server_uri->host &
$uri->port eq $server_uri->port) {
$uri->host($ENV{'HTTP_HOST'});
# $uri->port($ENV{'SERVER_PORT'});
}
Make sure that "$uri->port($ENV{'SERVER_PORT'});" is commented out.
If you look at what the webclient is being told to access, it ends up
being something like "https://:80"- which fails. I doubt this
is the correct way to fix this problem, but after it started working we
kinda lost interest ...
.r'
Petr Grolmus wrote:
> Hello,
>
> I have got a problem with RT runnig simultaneously on http and https ports.
> On the https port we are using WebAuth authentication for internal users,
> whereas on http port remains RT-authentication for external users.
>
> With this setting in RT_SiteConfig.pm:
>
> Set($WebPath , "/rt");
> Set($WebBaseURL , "https://rtest2.zcu.cz";);
>
> works everything fine on https, but when I click on several submit button
> on http port - e.g. Search (main page) or Update Ticket (in Reply) -
> I always get:
>
> "The connection to rtest2.zcu.cz:80 has terminated unexpectedly. Some
> data may have been transferred."
>
> It seems it try to communicate on http port with https protocol. When I
> switch settings to:
>
> Set($WebBaseURL , "http://rtest2.zcu.cz";);
>
> then works everything fine on http port, whereas on https I get "Bad
> request" with click on the same submit buttons.
>
> I'm using RT 3.6.1 from debian package (stable branch).
> Could someone help me to avoid this behavior?
>
> Thanks,
> Petr Grolmus
> --
> Petr Grolmus
>
> Laboratory for Computer Science
> University of West Bohemia
> Univerzitni 20, 306 14 Pilsen Tel.: +420 377 632 851
> Czech RepublicE-mail: [EMAIL PROTECTED]
> --
>
> ___
> 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] Expensive Queries
They are just saved searches we are displaying on the home pageI am not sure exactly where that specific query that I posted was created, but where we are seeing the biggest performance hit is on RT at a Glance. Thanks for the feedback on the indexes, we shall give them a try. - Stark -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Kenneth Marshall Sent: Tuesday, May 15, 2007 2:34 PM To: [EMAIL PROTECTED] Cc: rt-users@lists.bestpractical.com Subject: Re: [rt-users] Expensive Queries We are running RT 3.4.5 on PostgreSQL with 1200 open tickets and 110k tickets processed and growing. We have no performance problem to speak of. How are you generating the slow query? Ken On Tue, May 15, 2007 at 02:18:15PM -0400, [EMAIL PROTECTED] wrote: > > Has this been integrated with RT? > > > > Justin Brodley > > I suspect that most people are running RT with MySQL, so it is quite > unlikely that enough people have run into performance issues that need > to be resolved by memcached. That said, I'd imagine it would be fairly > trivial to get up and running. > > I'd be interested in hearing what Jesse has to say on this topic. > > -Brian > > Brian Gupta > Time Inc > Information Technology Dept > 212-522-1401 > ___ > 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 ___ 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] Expensive Queries
We are running RT 3.4.5 on PostgreSQL with 1200 open tickets and 110k tickets processed and growing. We have no performance problem to speak of. How are you generating the slow query? Ken On Tue, May 15, 2007 at 02:18:15PM -0400, [EMAIL PROTECTED] wrote: > > Has this been integrated with RT? > > > > Justin Brodley > > I suspect that most people are running RT with MySQL, so it is quite > unlikely that enough people have run into performance issues that need > to be resolved by memcached. That said, I'd imagine it would be fairly > trivial to get up and running. > > I'd be interested in hearing what Jesse has to say on this topic. > > -Brian > > Brian Gupta > Time Inc > Information Technology Dept > 212-522-1401 > ___ > 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] Expensive Queries
Justin, I never saw any problem plans posted, but some of the most needed indexes reduced the need for a sequential scan of a table by replacing it with an index lookup. Here are some candidates to check for in your DB instance: CREATE UNIQUE INDEX Queues1 ON Queues (lower(Name)) ; CREATE INDEX GroupMembers1 ON GroupMembers (GroupID); CREATE UNIQUE INDEX Users1 ON Users (lower(Name)) ; CREATE INDEX Users2 ON Users (lower(EmailAddress)); CREATE INDEX Tickets4 ON Tickets (Status); Again look for slow queries caused by sequential scans of a table. I think that Oracle has something equivalent to the functional indexes above to allow you to index the lowercased values. Good luck in your performance problem seek-n-destroy. Ken On Tue, May 15, 2007 at 11:08:14AM -0700, Justin Brodley wrote: > Has this been integrated with RT? > > Justin Brodley > > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of > [EMAIL PROTECTED] > Sent: Tuesday, May 15, 2007 11:00 AM > To: rt-users@lists.bestpractical.com > Subject: Re: [rt-users] Expensive Queries > > > Thanks Ken and Jesse. We will continue to evaluate to see if we can > > find some performance gains in other ways. > > > > -Stark > > Are the queries repeated? If so then memcached might be able to help you > out. http://en.wikipedia.org/wiki/Memcached > > -Brian > > Brian Gupta > Time Inc > Information Technology Dept > 212-522-1401 > ___ > 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 > ___ 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] Double e-mails for RT 3.6.1
Does anyone have an available Scrip which eliminates all of the double e-mails which occur in RT 3.6.1? It's getting awfully repetitive. Will upgrading RT versions work? I'm almost willing to downgrade as well. Thanks, - sf ___ 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] Expensive Queries
> Has this been integrated with RT? > > Justin Brodley I suspect that most people are running RT with MySQL, so it is quite unlikely that enough people have run into performance issues that need to be resolved by memcached. That said, I'd imagine it would be fairly trivial to get up and running. I'd be interested in hearing what Jesse has to say on this topic. -Brian Brian Gupta Time Inc Information Technology Dept 212-522-1401 ___ 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] simple one I think...
Howdy All, I am not a programmer, and the advice I have received so far has been great. I am having trouble locating where to edit the headers for the main page. ie.. ^ 10 Highest Priority Tickets I Own Edit I want to remove the "EDIT" part from these toolbars. I can't find the location to remove the EDIT part... Any help?? Christopher Moughan System Administrator Brown & Brown Lehigh Valley 268 Brodhead Road Bethlehem, PA 18017 Office 610-694-1814 Fax 610-974-9791 IMPORTANT: Insurance coverage can not be bound, amended or changed via voicemail, facsimile or Email message without confirmation from an authorized Brown & Brown representative. NOTICE: The information contained in this electronic message is legally privileged and confidential and is intended for the use of the individual or entity named above. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution or copy of this message is strictly prohibited. If you have received this communication in error, please contact the sender by reply email and destroy all electronic and printed copies of this message. ___ 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] Expensive Queries
Has this been integrated with RT? Justin Brodley -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Tuesday, May 15, 2007 11:00 AM To: rt-users@lists.bestpractical.com Subject: Re: [rt-users] Expensive Queries > Thanks Ken and Jesse. We will continue to evaluate to see if we can > find some performance gains in other ways. > > -Stark Are the queries repeated? If so then memcached might be able to help you out. http://en.wikipedia.org/wiki/Memcached -Brian Brian Gupta Time Inc Information Technology Dept 212-522-1401 ___ 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] Expensive Queries
> Thanks Ken and Jesse. We will continue to evaluate to see if we can > find some performance gains in other ways. > > -Stark Are the queries repeated? If so then memcached might be able to help you out. http://en.wikipedia.org/wiki/Memcached -Brian Brian Gupta Time Inc Information Technology Dept 212-522-1401 ___ 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] Speeding up queries
I found that if I index the Subject column in the Tickets table, searches are much faster. Thank you, Micah Gersten onShore Networks www.onshore.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] Still lots of Spam hitting RT after filtering via Procmail/Spamassasin/Rules Du Jour
On Thu, 10 May 2007 16:03:34 +0100 "Pedro Santa" <[EMAIL PROTECTED]> wrote: > Hi list! > > My RT instance still receives lots of SPAM even with procmail > filtering, with Spamassasin updated with "rules du jour" script. > > My procmail logs show that some of the mail is filtered but still gets > trough lots of spam. Any suggestions. > > Thanks in advance. > > Pedro Machado Santa > > RT 3.4.1 > > Here are my configuration files: < SNIPPED > Looks like you used my configs :-) I would review the headers of the ones getting through. Most likely you can "turn down" the SPAM assassins rating number. Review the X-SPAM-SCORE: header of all the spam getting through, then look over the same headers of "good" email getting through. Problably will not take look to see a pattern. You can then change your spam assassin config to reflect what you have found. Also note that SPAM assassin needs some time to learn. Do a bit of googling for "sa-learn --ham" and "sa-learn --spam" to get a better idea. For what it is worth, here is top portion of my /etc/ # Added by KDS on 1/10/05 # Lowered to catch a little more then necessary required_hits 3.5 # ok_languages en ok_locales en rewrite_header subject [*** SPAM ***] # Next line adds info to top of email body report_safe 0 fold_headers 1 # next line should be all one line, watch for wrapping add_header all Status _YESNO_, hits=_HITS_ required=_REQD_ tests=_TESTS_ autolearn=_AUTOLEARN_ version=_VERSION_ -- http://gentgeen.homelinux.org # Associate yourself with men of good quality if you esteem your own reputation; for 'tis better to be alone then in bad company.- George Washington, Rules of Civility ___ 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] Expensive Queries
Thanks Ken and Jesse. We will continue to evaluate to see if we can find some performance gains in other ways. -Stark -Original Message- From: Jesse Vincent [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 15, 2007 12:47 PM To: Kenneth Marshall Cc: Jeff Stark; rt-users Subject: Re: [rt-users] Expensive Queries On May 15, 2007, at 12:43 PM, Kenneth Marshall wrote: > Jeff, > > It sounds like you may need to make some more indexes. Please have > your DBAs provide a plan for the query execution. Look for sequential > scans in particular. That may help you identify possible index > creation options. We use PostgreSQL here, but I would suspect that > many of the index creations needed for it to be performant would be > the same with Oracle. Sadly, no. Every database really does want a different set of indexes. In particular, Oracle seems to strongly prefer single-column indexes. (And can use many of them on the same query.) The last time we saw test data with mysql and postgres, they dealt better with multi-column indexes. Best, 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] Expensive Queries
On May 15, 2007, at 12:43 PM, Kenneth Marshall wrote: Jeff, It sounds like you may need to make some more indexes. Please have your DBAs provide a plan for the query execution. Look for sequential scans in particular. That may help you identify possible index creation options. We use PostgreSQL here, but I would suspect that many of the index creations needed for it to be performant would be the same with Oracle. Sadly, no. Every database really does want a different set of indexes. In particular, Oracle seems to strongly prefer single-column indexes. (And can use many of them on the same query.) The last time we saw test data with mysql and postgres, they dealt better with multi-column indexes. Best, Jesse PGP.sig Description: This is a digitally signed message part ___ 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] Expensive Queries
Jeff, It sounds like you may need to make some more indexes. Please have your DBAs provide a plan for the query execution. Look for sequential scans in particular. That may help you identify possible index creation options. We use PostgreSQL here, but I would suspect that many of the index creations needed for it to be performant would be the same with Oracle. There are a couple of posts about PostgreSQL tuning in the mailing list that you can refer too. Good luck. Ken On Tue, May 15, 2007 at 09:37:11AM -0700, Jeff Stark wrote: > Hello, > > We are trying to identify very poor performance levels of the RT > Application 3.6.3 on REHL/Apache with Oracle. In doing so, we had our > DBAs take a look at the Oracle box and the identified some very > expensive queries that were taking nearly 10 seconds to return, such as: > > SELECT * FROM > ( SELECT limitquery.*, rownum limitrownum FROM > ( SELECT main.* FROM > ( SELECT DISTINCT main.id > FROM CustomFields main > JOIN ObjectCustomFields > ObjectCustomFields_1 ON ( ObjectCustomFields_1.CustomField = main.id ) > WHERE (main.Name = 'Customer') > AND (ObjectCustomFields_1.ObjectId = > '0') > AND (main.LookupType = > 'RT::Queue-RT::Ticket') ) distinctquery, > CustomFields main > WHERE (main.id = distinctquery.id) > ORDER BY main.SortOrder ASC, main.id ASC ) > limitquery WHERE rownum <= 1 ) > WHERE limitrownum >= 1 > > Their concern is mainly around the joins being inequality joins, as even > indexes won't help with these types of queries. Has anyone seen this > same behavior and/or has anyone done anything to modify the system to > generate better join clauses in the queries? > > Also I must note, we only have 450 tickets in the system at this > time...this was in just over a week with less than half of the users > active, so we expect the number to grow significantly as we onboard > additional users. > > Thanks, > > Jeff Stark > > > ___ > 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] Expensive Queries
Hello, We are trying to identify very poor performance levels of the RT Application 3.6.3 on REHL/Apache with Oracle. In doing so, we had our DBAs take a look at the Oracle box and the identified some very expensive queries that were taking nearly 10 seconds to return, such as: SELECT * FROM ( SELECT limitquery.*, rownum limitrownum FROM ( SELECT main.* FROM ( SELECT DISTINCT main.id FROM CustomFields main JOIN ObjectCustomFields ObjectCustomFields_1 ON ( ObjectCustomFields_1.CustomField = main.id ) WHERE (main.Name = 'Customer') AND (ObjectCustomFields_1.ObjectId = '0') AND (main.LookupType = 'RT::Queue-RT::Ticket') ) distinctquery, CustomFields main WHERE (main.id = distinctquery.id) ORDER BY main.SortOrder ASC, main.id ASC ) limitquery WHERE rownum <= 1 ) WHERE limitrownum >= 1 Their concern is mainly around the joins being inequality joins, as even indexes won't help with these types of queries. Has anyone seen this same behavior and/or has anyone done anything to modify the system to generate better join clauses in the queries? Also I must note, we only have 450 tickets in the system at this time...this was in just over a week with less than half of the users active, so we expect the number to grow significantly as we onboard additional users. Thanks, Jeff Stark ___ 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] Same user has several e-mail addresses
Hi Gene,
There probably is a better way... But heres the way that one of my
guys solved it many moons ago in a previous version. I'm not sure if its
the right way, if this even exists in the version you run, etc.
In the config.pm there is a section called :
LookupExternalUserInfo
At the time it allowed you to sync incoming users with an
external data source.
We put the following into it :
sub LookupExternalUserInfo {
my ($EmailAddress, $RealName) = @_;
my $FoundInExternalDatabase = undef;
my %params;
#Name is the RT username you want to use for this user.
$params{'Name'} = $EmailAddress;
$params{'EmailAddress'} = $EmailAddress;
$params{'RealName'} = $RealName;
$RT::Logger->debug("LookupExternalUserInfo: Entered with:\n",
"\tName = $params{'Name'}\n",
lAddress = $params{'EmailAddress'}\n",
"\tRealName = $params{'RealName'}\n",
"\tFound= $FoundInExternalDatabase\n");
# See RT's contributed code for examples.
# http://www.fsck.com/pub/rt/contrib/
$findkey= lc($EmailAddress);
tie (%fdbi,'NDBM_File',"/usr/local/rt2/etc/keyedfile",O_RDWR,0777) or die $!;
if ($fdbi{$findkey}) {
$params{'Orig'} = "$EmailAddress";
chomp($params{'Orig'});
($params{'Name'},$params{'EmailAddress'})=split(/\|/,$fdbi{$findkey});
chomp($params{'Name'});
$params{'RealName'} = "$params{'Name'}";
chomp($params{'RealName'});
chomp($params{'EmailAddress'});
$FoundInExternalDatabase = 1;
}else {
$FoundInExternalDatabase = undef;
}
untie %fdbi;
$RT::Logger->debug("LookupExternalUserInfo: Leaving local file ",
"examination with:\n",
"\tName = \"$params{'Name'}\"\n",
"\tEmailAddress = $params{'EmailAddress'}\n",
"\tRealName = $params{'RealName'}\n",
"\tOrig = $params{'Orig'}\n",
"\tFound= $FoundInExternalDatabase\n");
return ($FoundInExternalDatabase, %params);
}
We then created a file formatted like :
#Format is ALTERNATE_EMAIL_ADDRESS:RT_LOGIN_ID|PRIMARY_EMAIL_ADDRESS
#Cust1
[EMAIL PROTECTED]:cust1|[EMAIL PROTECTED]
[EMAIL PROTECTED]:cust1|[EMAIL PROTECTED]
[EMAIL PROTECTED]:cust1|[EMAIL PROTECTED]
[EMAIL PROTECTED]:cust1|[EMAIL PROTECTED]
[EMAIL PROTECTED]:cust1|[EMAIL PROTECTED]
[EMAIL PROTECTED]:cust1|[EMAIL PROTECTED]
#Cust2
[EMAIL PROTECTED]:cust2|[EMAIL PROTECTED]
[EMAIL PROTECTED]:cust2|[EMAIL PROTECTED]
[EMAIL PROTECTED]:cust2|[EMAIL PROTECTED]
#Cust3
[EMAIL PROTECTED]:cust3|[EMAIL PROTECTED]
[EMAIL PROTECTED]:cust3|[EMAIL PROTECTED]
[EMAIL PROTECTED]:cust3|[EMAIL PROTECTED]
[EMAIL PROTECTED]:cust3|[EMAIL PROTECTED]
[EMAIL PROTECTED]:cust3|[EMAIL PROTECTED]
And then loaded them into the file like :
#!/usr/local/bin/perl
use Fcntl;
use NDBM_File;
$flatfile="user.data";
tie (%fdbi,'NDBM_File',"keyedfile",O_CREAT|O_RDWR,0777) or die $!;
open(IN,"$flatfile");
while () {
if($_ =~ /^\#/) {
next;
}
if($_ =~ /^\s+/) {
next;
}
($key,$data)=split(/\:/,$_);
$fdbi{$key}=$data;
}
close (IN);
untie %fdbi;
close(IN);
There was also some rt-mailgate, lib/RT/Action/Notify.pm
lib/RT/Interface/Email.pm changes needed, nothing big. Email me
directly for those.
Like I said, maybe with the newer version this is
obsolete.
Tuc
>
> Hi All,
>
> I think I saw this issue brought up in the list or on the wiki a couple (or
> few) months ago, but I haven't been able to find the posts. One of my
> users is using an address (not seen before by RT) other than his
> "requestor" address to reply to tickets, and his reply is going to the bit
> bucker rather than being added to the ticket because RT won't create a new
> acct for him. Since this user will be a pretty regular ticket creator, I'd
> like to associate both e-mail addresses to the same acct. I'd appreciate
> it if someone could point me to where this was already discussed.
>
> Thanks,
> Gene
___
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] http vs https problem
On May 15, 2007, at 11:17 AM, Petr Grolmus wrote: Hello, I have got a problem with RT runnig simultaneously on http and https ports. On the https port we are using WebAuth authentication for internal users, whereas on http port remains RT-authentication for external users. With this setting in RT_SiteConfig.pm: Set($WebPath , "/rt"); Set($WebBaseURL , "https://rtest2.zcu.cz";); works everything fine on https, but when I click on several submit button on http port - e.g. Search (main page) or Update Ticket (in Reply) - I always get: "The connection to rtest2.zcu.cz:80 has terminated unexpectedly. Some data may have been transferred." It seems it try to communicate on http port with https protocol. When I switch settings to: Set($WebBaseURL , "http://rtest2.zcu.cz";); then works everything fine on http port, whereas on https I get "Bad request" with click on the same submit buttons. I'm using RT 3.6.1 from debian package (stable branch). Could someone help me to avoid this behavior? We've done work on the redirects which I suspect are the issue in 3.6.3. Best, Jesse Thanks, Petr Grolmus -- Petr Grolmus Laboratory for Computer Science University of West Bohemia Univerzitni 20, 306 14 Pilsen Tel.: +420 377 632 851 Czech RepublicE-mail: [EMAIL PROTECTED] -- ___ 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 PGP.sig Description: This is a digitally signed message part ___ 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] Odd problem with RT customization
Hello all, I'm getting some strange behavior here that I can't explain and that I've never seen before. I've made a copy of Templates_Overlay.pm - it's called Templates_Local.pm and its in my local/lib/RT directory. I've made a small mod to the file. The odd thing is, I'm getting inconsistent behavior in the web interface. Just by refreshing the same page (admin global templates) I can see via the RT log that sometimes my modified code is executed and sometimes the original code is executed. This is RT 3.4.2, Apache 1.27 (SSL), mod_perl 1.29, mysql 4.022, RHEL 3 Any ideas why my local copy of the code isn't consistently picked up? I should add that I have completely stopped & started apache, and that I've made many modifications to other .pm files before without having this problem. Stephen Turner Senior Programmer/Analyst - Client Support Services MIT Information Services and Technology (IS&T) ___ 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] CommandByMail Extension
Hello!
I installed the CommandByMail extension on my request tracker. It's
kinda working, but I have the following behavior:
If I send an email with the 'status' or 'queue' command, it works
perfectly. It works ok too with the custom fields like this:
CF.{Sala}: 2300
But I have other fields, like CF.{Classificação do Chamado} that are
not working with the CommandByMail extension. No log messages,
nothing, it just don't execute the command. I have two theories:
1) The extension has some problem with the field name using
spaces/special/non-ascii characters
2) The extension works only on editable Custom fields (Sala is a entry
field, the others are select drop downs, all are mandatory.
Anyone can think in something?
[]s
Jose P. E. Junior
___
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] http vs https problem
Hello, I have got a problem with RT runnig simultaneously on http and https ports. On the https port we are using WebAuth authentication for internal users, whereas on http port remains RT-authentication for external users. With this setting in RT_SiteConfig.pm: Set($WebPath , "/rt"); Set($WebBaseURL , "https://rtest2.zcu.cz";); works everything fine on https, but when I click on several submit button on http port - e.g. Search (main page) or Update Ticket (in Reply) - I always get: "The connection to rtest2.zcu.cz:80 has terminated unexpectedly. Some data may have been transferred." It seems it try to communicate on http port with https protocol. When I switch settings to: Set($WebBaseURL , "http://rtest2.zcu.cz";); then works everything fine on http port, whereas on https I get "Bad request" with click on the same submit buttons. I'm using RT 3.6.1 from debian package (stable branch). Could someone help me to avoid this behavior? Thanks, Petr Grolmus -- Petr Grolmus Laboratory for Computer Science University of West Bohemia Univerzitni 20, 306 14 Pilsen Tel.: +420 377 632 851 Czech RepublicE-mail: [EMAIL PROTECTED] -- ___ 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] Problem with taking ticket under RT 3.6.3 (WebURL or WebPort issue ?)
On Tue, 2007-05-15 at 10:04 -0400, Didier Contis wrote: > I have tried to modify the WebPort value to 443 > Set($WebPort , 443); > but still no luck. Did you restart your webserver after making this change? ___ 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] Problem with taking ticket under RT 3.6.3 (WebURL or WebPort issue ?)
I am running into a strange issue. I have Set($WebBaseURL , "https://ceert3.ce.gatech.edu";); in my RT_SiteConfig.pm Everything is working great except when a user click to take a ticket. He is being redirected to the following URL for some reason -> https://ceert3.ce.gatech.edu:80/Ticket/Display.html?id=4 ^ This seems to happen only when someone try to take a ticket. Everything other actions work just fine. I have tried to modify the WebPort value to 443 Set($WebPort , 443); but still no luck. I must admit I am kind of loss on that one. The only thing I can see in the apache log are [15/May/2007:09:49:25 -0400] "GET /Ticket/Display.html?Action=Take&id=4 HTTP/1.1" 302 240 I was wondering if someone as seen this before with 3.6.3 Thanks - Didier -- Didier Contis IT Manager School of CEE / Georgia Tech ___ 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 Billing ?
On Tue, 2007-05-15 at 11:00 +0300, Subredu Manuel wrote: > I've seen that someone has mentioned that RT::Billing will be released > soon ? What is this and who's making it and when is going to be released ? > /me very very curious Mentioned by me, written by me. Cleaning it up and packaging it is pretty high on my TODO list, but it's an off-hours project, and this time of year is very busy for those of us working in US universities, so it might be a month or so. I don't generally pimp my software on lists, so if you want to know when it's up, send me a message off-list and I'll let you know. My RT stuff is at the URL below: http://mattwork.potsdam.edu/rt -- Matthew Keller Information Security Officer & Network Administrator Computing & Technology Services State University of New York @ Potsdam Potsdam, NY, USA http://mattwork.potsdam.edu/ ___ 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] Re: Remove Ticket Number from outgoing mails
Ham MI-ID, Torsten Brumm wrote in Article <[EMAIL PROTECTED]> posted to gmane.comp.bug-tracking.request-tracker.user: > is it possible to remove a ticketnumber from a outgoing mail? I believe doing so would reduce the number of replies getting assigned to the correct ticket, since having the ticket number already in the subject when replying means the user doesn't have to do anything to the subject to make it assign to the correct ticket. -- Paul Johnson Email and IM (XMPP & Google Talk): [EMAIL PROTECTED] ___ 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] Help with RT database model
Hi all! Following the instructions of RT Wiki, I´ve downloaded the ' rt3-schema-relationships.dot'. Now I want to visualize this file (.dot) in the dbdesigner4 but I have not success because this program needs a xml file to load the database model. Other thing I´ve tried is to connect from dbdesigner4 to RT database (in Postgre) but it doesn´t recognize dbuser and password Can anyone help me? Thanks in advance Best Regards Teresa ___ 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 Billing ?
On Tue, 2007-05-15 at 11:00 +0300, Subredu Manuel wrote: > I've seen that someone has mentioned that RT::Billing will be released > soon ? What is this and who's making it and when is going to be released ? > /me very very curious /me supports the inquiry Serge -- Serge van Ginderachter http://www.vanginderachter.be/ Thou shalt not conf before thy morning coffee. ___ 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] RTx::EmailCompletion 0.02
Hi, RTx::EmailCompletion 0.02 just hit cpan : http://search.cpan.org/~nchuche/RTx-EmailCompletion-0.02/ -+-+-+-+-+-+- Changes for 0.02 * allow email completion for unprivileged users (disable by default). See README * add debugging tools to find input tags found by emailcompletion.js ___ 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 Billing ?
Hi, I've seen that someone has mentioned that RT::Billing will be released soon ? What is this and who's making it and when is going to be released ? /me very very curious ___ 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
