Re: [rt-users] That ticket has unresolved dependencies - [Pork] Email found in subject

2008-02-26 Thread Ben Robson
Kenn, Thanks for this. I have done as you suggested and have had the following results, but can not see what might be causing the issue (unless there is some confusion within RT for assets in the AT addon. Any additional guidance you (or others) can provide would be greatly appreciated. Result

Re: [rt-users] HTTP and HTTPS on same RT server?

2008-02-26 Thread Matt Westfall
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Godaddy sells valid ssl certs for 20 a year. *rolls eyes* Matt Westfall Owner / Operator FiftyPounds Internet http://www.fiftypounds.com This message is digitally signed with Pretty Good Privacy (PGP) Info: http://en.wikipedia.org/wiki/Pretty_Good_Pr

[rt-users] Resend today's emails?

2008-02-26 Thread Christopher Short
Hi, every so often our RT 3.6.1 silently stops forwarding emails on to the appropriate recipients, having used up a shocking amount of memory. It's the "Cannot allocate memory" problem, which I gather is a known bug. We're setting up a process to restart RT every night, that will hopefully reduc

Re: [rt-users] case-insensitive searches?

2008-02-26 Thread Ruslan Zakirov
1) Searches in RT are case-insensetive 2) Type of the search? 3) DB? On Wed, Feb 27, 2008 at 12:10 AM, Erik Anderson <[EMAIL PROTECTED]> wrote: > Hello all - we're on RT-3.6.5. It seems like the default behavior of > the ticket search is to do case-sensitive searches. Is there any way > to cha

[rt-users] case-insensitive searches?

2008-02-26 Thread Erik Anderson
Hello all - we're on RT-3.6.5. It seems like the default behavior of the ticket search is to do case-sensitive searches. Is there any way to change that to default to case-insensitive searches? Thanks! -Erik -- Erik Anderson http://andersonfam.org __

Re: [rt-users] Question about users and their associated tickets...

2008-02-26 Thread Greg Evans
Hey Craig, Thanks for the ShowPeople file, that works perfectly and with some small tweaks as you suggested it will definitely make things easier when we are doing tickets. Regards, Greg Evans Internet Support Hood Canal Communications (360) 898-2481 ext.212 -Original Message- From:

[rt-users] RT Upgrade question

2008-02-26 Thread Kenneth Crocker
To all, Much to my surprise, Stephen Turner and Roy El-Hames have pointed out that I missed a possible DB change. I looked at the "content" file in 3.5.1 (coming from 3.4.4 that was all I needed to look at) and the only thing I see that I missed was a couple of options for the homepage

Re: [rt-users] Question about users and their associated tickets...

2008-02-26 Thread Patterson, Craig
Greg, We do something similar already. We've modified ...share/html/Ticket/Elements/ShowPeople to display each requestors user name, work phone, mobile phone, a customfield named department I've attached our version. You should only have copy my file into your local directory and tweak a couple

Re: [rt-users] HTTP and HTTPS on same RT server?

2008-02-26 Thread Vivek Khera
On Feb 26, 2008, at 3:15 AM, Danie Marais wrote: Can someone perhaps just confirm that an HTTP and HTTPS combination is not possible? It mostly works. the problem is you can only specify one address as the $WebBaseURL. On our instance, we can access it via either http or https, but a

[rt-users] RT keyboard shortcuts

2008-02-26 Thread Alex Moura
Hi Team, I was wondering if keyboard shortcuts would be a desirable feature for RT, similar to Gmail + Better Gmail Firefox extension. Alex ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.c

Re: [rt-users] Question about users and their associated tickets...

2008-02-26 Thread Greg Evans
As a follow-up to this, I would also like it to when I create a new ticket (if it is possible) that when I enter their name as the requestor, it would display certain items of the information for their user account, such as A) Full Name B) Email address (either of these would be the requestor, so

[rt-users] Using javascript in RT

2008-02-26 Thread Joel Schuweiler
I'm looking for some information on how I could go about getting started with getting javascript in play in rt. How can I go about adding an id to the queue name when you look at a ticket? I would like to use this to determine which queue I'm in via javascript. Alternatively, I could get around

[rt-users] Off-Topic - RE: Exchange 2007 and Fetchmail

2008-02-26 Thread Stef Morrell
Hello, Not sure where this relates to RT, but.. By default exchange 2007 requires SSL/TLS connections, which will be on port 995 for POP3. I have no clue if fetchmail supports this, check the setup. Alternatively you can loosen the default settings in Exchange to allow plain text connections via

[rt-users] reply creates new ticket instead of adding to existing

2008-02-26 Thread David Pitts
I built a box (Fedora Core 8), so I did the install via yum. I created a test queue, added the line in /etc/aliases and did newaliases. aliases: test: "|/usr/sbin/rt-mailgate --queue 'test' --action correspond --url http://myurl/"; rt-comment: "|/usr/sbin/rt-mailgate --queue 'test' -- action comm

Re: [rt-users] That ticket has unresolved dependencies

2008-02-26 Thread Kenneth Crocker
Ben, Sorry. I meant LINKS not LIMKS. HA! fat fingers again. Kenn LBNL On 2/26/2008 9:43 AM, Kenneth Crocker wrote: > Ben, > > > I would look at the DataBase. Try this SQL: > > select * from LIMKS > where LOCALTARGET = 9 > or LOCALBASE = 9; > >

Re: [rt-users] Upgrading from RT 3.6.1 to 3.6.4

2008-02-26 Thread Kenneth Crocker
Stephen, Well, in that case I'd sure like to know what they were or what they affected. I know that "Reminders" were added, but they are a link and didn't exist before so going to the upgraded version still would not require any DB changes. What kinda rows? What table? Thanks. Kenn LB

Re: [rt-users] Upgrading from RT 3.6.1 to 3.6.4

2008-02-26 Thread Kenneth Crocker
Samuel, Don't forget any changes needed for the SESSIONS table. There have been a few people with problems on that end, but I didn't know if you were using that table for sessions or not. Kenn LBNL On 2/26/2008 9:39 AM, Samuel P. Howard wrote: > Wow, I'm surprise there weren't any dat

[rt-users] Question about users and their associated tickets...

2008-02-26 Thread Greg Evans
I have followed some direction and made each of my customers a user in order to prevent the data duplication that I had created and that would have gotten out of hand otherwise. :) So the next question becomes: User 'johndoe' calls in for the first time. I create a ticket for him which automatic

Re: [rt-users] Upgrading from RT 3.6.1 to 3.6.4

2008-02-26 Thread Roy El-Hames
Hi; There is one database change from 3.5.1 to 3.6.x which is content changes (not a schema change though ).. You can identify what changes are needed from the rt source, look in the etc/upgrade/ .. and for every directory > than your current version there will be changes to be made. The rt in

Re: [rt-users] Upgrading from RT 3.6.1 to 3.6.4

2008-02-26 Thread Stephen Turner
At Tuesday 2/26/2008 12:29 PM, Kenneth Crocker wrote: >Samuel, > > > We just upgraded to 3.6.4 from 3.4.4 and there were NO > DataBase changes >(we are on Oracle). > >Kenn >LBNL That's not strictly true - there were no schema changes, but there are some necessary new rows inserted into t

Re: [rt-users] That ticket has unresolved dependencies

2008-02-26 Thread Kenneth Crocker
Ben, I would look at the DataBase. Try this SQL: select * from LIMKS where LOCALTARGET = 9 or LOCALBASE = 9; 9 is the ticket id in question. Anyway, once you have that little query up, look to see if there is some records that shows the

Re: [rt-users] Upgrading from RT 3.6.1 to 3.6.4

2008-02-26 Thread Samuel P. Howard
Wow, I'm surprise there weren't any database updates from 3.4 to 3.6 ... you'd think that'd be almost a guarantee ... hrmmm I should pull down the source tarballs for 3.6.1 -> 3.6.4 and take a look I guess ... maybe it will be that easy! (I'll point to a *COPY* of my production database, of co

[rt-users] Exchange 2007 and Fetchmail

2008-02-26 Thread Candelario, Bill
Hi, I've recently upgrade to Exchange 2007 from 2003 and am having issues with logging into our mailbox using fetchmail via POP3. I am able to telnet into the server via POP3 and log in but when fetchmail tries it it says bad username and password. I was wondering if anyone would know if it was

Re: [rt-users] Upgrading from RT 3.6.1 to 3.6.4

2008-02-26 Thread Kenneth Crocker
Samuel, We just upgraded to 3.6.4 from 3.4.4 and there were NO DataBase changes (we are on Oracle). I think all you need to do is set the RT_SiteConfig.pm DataBase parameters to refer to the DataBase you want to use and supply the password and you should be OK. Hope this helps. Kenn L

Re: [rt-users] HTTP and HTTPS on same RT server?

2008-02-26 Thread Lutz Jaenicke
[EMAIL PROTECTED] wrote: > Better yet, import the self-generated CA cert (that you used to sign each > of your SSL certs) into each browser as a trusted root certificate > authority and no more warnings... > > This is a pretty bad idea unless you are living in a closed system. If I add the "xana

[rt-users] Saved Searches Not Found

2008-02-26 Thread Mathew Snyder
For starters, my apologies for sending this again instead of replying to my first email about it. For some reason I'm not getting my own posts to the list. I've checked the settings and my spam folder but nothing is being sent or trapped. That said, on with the question. I've created two saved

Re: [rt-users] behavior of email with multiple attachments

2008-02-26 Thread Chris Fabri
On 2/25/08 2:22 PM, Ruslan Zakirov wrote: > yep, only top most text part is treated as content of a transaction, > all other parts are treated as attachments. You can configure > notifications to attach those objects as well to outgoing emails. Read > about that on the wiki - page Template. As well

Re: [rt-users] HTTP and HTTPS on same RT server?

2008-02-26 Thread Roy El-Hames
Pending on which country, but data protection is worth a lot more than $249 .. I am sure your customer 's data is worth a lot more than that .. http is insecure. Roy [EMAIL PROTECTED] wrote: > Danie, if you've got customers using RT and you want them to use SSL, then > pay up for a legitimate c

Re: [rt-users] HTTP and HTTPS on same RT server?

2008-02-26 Thread Danie Marais
James, I do not need SSL for the customers. Only for internal techies. > > Danie, if you've got customers using RT and you want them to > use SSL, then > pay up for a legitimate certificate. > > > James Moseley > > > > > > > > There is a self-signed cert on the box. But we need to give

Re: [rt-users] HTTP and HTTPS on same RT server?

2008-02-26 Thread jmoseley
Danie, if you've got customers using RT and you want them to use SSL, then pay up for a legitimate certificate. James Moseley > There is a self-signed cert on the box. But we need to give Internet access to customers and do not want them to get a certificate warning. So they must either us

Re: [rt-users] HTTP and HTTPS on same RT server?

2008-02-26 Thread Danie Marais
> -Original Message- > From: Joseph Spenner [mailto:[EMAIL PROTECTED] > Sent: 26 February 2008 04:23 PM > To: Danie Marais; [EMAIL PROTECTED] > Cc: rt-users@lists.bestpractical.com > Subject: Re: [rt-users] HTTP and HTTPS on same RT server? > > --- Danie Marais <[EMAIL PROTECTED]> wrot

Re: [rt-users] HTTP and HTTPS on same RT server?

2008-02-26 Thread jmoseley
Better yet, import the self-generated CA cert (that you used to sign each of your SSL certs) into each browser as a trusted root certificate authority and no more warnings... James Moseley You can generate your own SSL certs for free. The only reason you'd want to buy them from Thawt ($15

[rt-users] Adjusting SetSubjectToken

2008-02-26 Thread Sharlon Carty
Hello everyone, I am trying to add the date to the subject line that rt generates. for example [rtname #260208-101] I adjusted as follows: sub SetSubjectToken { my $self = shift; my $sub = $self->TemplateObj->MIMEObj->head->get('Subject'); my $id = $self->TicketObj->id; my $to

Re: [rt-users] HTTP and HTTPS on same RT server?

2008-02-26 Thread Joseph Spenner
--- Danie Marais <[EMAIL PROTECTED]> wrote: > Matt, > > Maybe I am daft, but the SSL cert sites I looked at > listed it at $399 per > year. Where can you get $20 certs? > > > > -Original Message- > > From: [EMAIL PROTECTED] > > [mailto:[EMAIL PROTECTED] > On Behalf > > Of Matt Westf

Re: [rt-users] HTTP and HTTPS on same RT server?

2008-02-26 Thread Danie Marais
Matt, Maybe I am daft, but the SSL cert sites I looked at listed it at $399 per year. Where can you get $20 certs? > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf > Of Matt Westfall > Sent: 26 February 2008 03:56 PM > To: Lutz Jaenicke > Cc: rt-us

Re: [rt-users] HTTP and HTTPS on same RT server?

2008-02-26 Thread Matt Westfall
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Umm, SSL Certs are $20 a year, lol Matt Westfall Owner / Operator FiftyPounds Internet http://www.fiftypounds.com This message is digitally signed with Pretty Good Privacy (PGP) Info: http://en.wikipedia.org/wiki/Pretty_Good_Privacy Lutz Jaenicke

Re: [rt-users] HTTP and HTTPS on same RT server?

2008-02-26 Thread Lutz Jaenicke
Danie Marais wrote: > > >>> Can someone perhaps just confirm that an HTTP and HTTPS >>> >> combination is >> >>> not possible? >>> >>> Thanks >>> > > >> I don't see why it wouldn't be possible. You can have both an HTTP and >> an HTTPS site serving the same pages, and

Re: [rt-users] HTTP and HTTPS on same RT server?

2008-02-26 Thread Danie Marais
Eynat, Thanks very much for your response. I added the file as you suggested. I also changed WebURL to http (not https). Now HTTPS works fine - I can submit and reply to a ticket. When I log in to selfservice via HTTP my browser (IE) tries to connect to https://rt.mydomain.com:80/SelfService/

Re: [rt-users] HTTP and HTTPS on same RT server?

2008-02-26 Thread Eynat Nir Mishor
I encountered this problem and solved it for RT 3.6.5. >From what I saw, the problem was in RT::Interface::Web::Redirect() function that is called from html/Ticket/Display.html (and other places). It redirected the browser to a URL based on $RT::WebURL configuration only. So it always redirected

Re: [rt-users] Query in script not working

2008-02-26 Thread Roy El-Hames
SetToNow is in Date.pm, 3 rd function in the 3.6.4 version :¬) GoBack functions seems I have added them some time in the past couple of years, (possibly of the wiki.. the code is too neat to be mine), I have attached my Date_Vendor in case its helpful to you and anyone else Roy Mathew Snyder

Re: [rt-users] Query in script not working

2008-02-26 Thread Roy El-Hames
Hi Mathew; Not sure if you are aware of it, but in case you did not RT gives you a very powerful Date functions in Date.pm, from a perl script you can do the below: use RT::Date; my $date = new RT::Date($RT::SystemUser); $date->SetToNow(); my $now = $date->ISO; $date->GoBackDays(1); my $yesterda

Re: [rt-users] Query in script not working

2008-02-26 Thread Mathew Snyder
Hmmm...that certainly would have been helpful. But I'm looking at the perldoc on Date.pm and I don't see SetToNow or GoBackDays Roy El-Hames wrote: > Hi Mathew; > > Not sure if you are aware of it, but in case you did not RT gives you a > very powerful Date functions in Date.pm, > from a perl sc

Re: [rt-users] Query in script not working

2008-02-26 Thread Mathew Snyder
FWIW, this is the script I came up with: #!/usr/bin/perl ### # Name: daily_transactions.pl # Version: 0.1 # Author: Mathew Snyder # Date: February 24, 2008 # Comments: This is a script which lists #how

Re: [rt-users] HTTP and HTTPS on same RT server?

2008-02-26 Thread Danie Marais
> > Can someone perhaps just confirm that an HTTP and HTTPS > combination is > > not possible? > > > > Thanks > I don't see why it wouldn't be possible. You can have both an HTTP and > an HTTPS site serving the same pages, and then redirect people between > the two based on certain condition

Re: [rt-users] HTTP and HTTPS on same RT server?

2008-02-26 Thread Oliver Jeeves
Danie Marais wrote: > Can someone perhaps just confirm that an HTTP and HTTPS combination is > not possible? > > Thanks I don't see why it wouldn't be possible. You can have both an HTTP and an HTTPS site serving the same pages, and then redirect people between the two based on certain condition

Re: [rt-users] HTTP and HTTPS on same RT server?

2008-02-26 Thread Danie Marais
Can someone perhaps just confirm that an HTTP and HTTPS combination is not possible? Thanks _ From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Danie Marais Sent: 22 February 2008 10:24 AM To: rt-users@lists.bestpractical.com Subject: [rt-users] HTTP and HTTPS on same RT