[rt-users] RT Mobile for iPhone (Dustin Collins)

2010-06-25 Thread Bartelt, John E.
I bought it but I can't get it to connect. (1) Does it understand https? (2) Does it understand external authentication? John Bartelt Date: Thu, 24 Jun 2010 17:56:30 -0400 From: Dustin Collins To: "rt-users@lists.bestpractical.com" Subject: [rt-users] RT Mobile for iPhone Message-ID: <-

Re: [rt-users] RT Mobile for iPhone

2010-06-25 Thread Joel Merrick
+1 from me too On Fri, Jun 25, 2010 at 4:45 AM, Torsten Brumm wrote: > And here! Please, one for the Androids > > 2010/6/25 Paul >> >> Same here. >> >> Paul >> >> On 06/24/2010 03:03 PM, Ariel Saia wrote: >> > I would love to see an Android version :) >> > >> > Ariel >> > >> > >> > -Orig

[rt-users] Thank you for your advice!

2010-06-25 Thread Wolfram Huettermann
Kevin Falcone wrote: On Thu, Jun 24, 2010 at 03:45:23PM +0200, Wolfram Huettermann wrote: Hello, I have got a queue in whose tickets I display some Custom fields (CFs). These CFs should be displayed in a special order determined by their id's. That means: if I fix 21 104 102, then CF #21 is

Re: [rt-users] RT Mobile for iPhone

2010-06-25 Thread Kobus Bensch
And if I can jump on the bandwagon, one for the blackberry. Kobus Best Regards Kobus Bensch Fullnet Solutions LTD 07703503733 Sent from my BlackBerry® wireless device -Original Message- From: Joel Merrick Sender: rt-users-boun...@lists.bestpractical.com Date: Fri, 25 Jun 2010 08:44:34

Re: [rt-users] slow mysql query after upgrade from 3.8.6 to 3.8.8

2010-06-25 Thread Fabrice
Hi, Why you don't use rt 3.8.8 cli client ? http://wiki.bestpractical.com/view/CLI rt ls -o -Created -t ticket "Queue = '4' AND Status != 'resolved' AND \ Created < '30 days ago'" -f id,subject,status,created,lastupdated,owner \ | mail -s "Report of tickets 30 days old" usern...@email Regards,

Re: [rt-users] RT Mobile for iPhone

2010-06-25 Thread Gary Holmes
Any chance you can get this listed on the UK AppStore? Thanks, Gary On 24 June 2010 22:56, Dustin Collins wrote: > This is an RT client for iPhone. Check it out if your interested. > > http://itunes.apple.com/us/app/rt-mobile/id377642006?mt=8 > > Discover RT's hidden secrets with RT Essentials f

Re: [rt-users] RT Mobile for iPhone

2010-06-25 Thread Björn Schulz
And on the german store too? cherrs, Björn Am 25.06.10 10:41, schrieb Gary Holmes: Any chance you can get this listed on the UK AppStore? Thanks, Gary On 24 June 2010 22:56, Dustin Collins wrote: This is an RT client for iPhone. Check it out if your interested. http://itunes.apple.com/us

[rt-users] Migration from OTRS to RT3

2010-06-25 Thread Richard Pijnenburg
Hi all, My goal is to implement RT3 as new ticketing system but it seems a demand is that the current history of OTRS needs to be integrated into RT3. I'm not all to happy with it but does someone have experience with this? I haven't found any import scripts yet. Met vriendelijke groet

Re: [rt-users] RT Mobile for iPhone (Dustin Collins)

2010-06-25 Thread Chuck Boeheim
Likewise. We use webauth in front of RT, so we need to authenticate to another web page first, and then return a cookie with the transactions. -Chuck On Jun 25, 2010, at 3:02 AM, "Bartelt, John E." wrote: > I bought it but I can't get it to connect. > (1) Does it understand https? > (2) Do

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

2010-06-25 Thread Hussam Dawood
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 owners, setting states, changing queues etc. The front-end to all of th

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

[rt-users] How to safely uninstall RTFM

2010-06-25 Thread Fernanda Martins
Hi, I need to remove RTFM from RT. But I don't want to drop de FM's tables, cause I'm afraid that I may corrupt something. Any sugestion? how to safely uninstall RTFM? Fernanda L. M. Martins Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpra

Re: [rt-users] slow mysql query after upgrade from 3.8.6 to 3.8.8

2010-06-25 Thread Foggi, Nicola
I forgot to include the top part with the query stats: # Time: 100624 22:44:19 # u...@host: rt_user[rt_user] @ rt.internal [10.12.10.72] # Query_time: 12 Lock_time: 0 Rows_sent: 8 Rows_examined: 3314678 use rt3; SELECT DISTINCT main.* FROM Users main JOIN Principals Principals_1 ON ( Princip

Re: [rt-users] RT Mobile for iPhone

2010-06-25 Thread Jason Ledford
I am jealous since we use blackberry almost exclusively. -Original Message- From: rt-users-boun...@lists.bestpractical.com [mailto:rt-users-boun...@lists.bestpractical.com] On Behalf Of Kobus Bensch Sent: Friday, June 25, 2010 3:47 AM To: Joel Merrick; rt-users-boun...@lists.bestpractical

Re: [rt-users] RT Mobile for iPhone (Dustin Collins)

2010-06-25 Thread Troy Knabe
Yes. I just installed it and it does do https and external auth fine. -Troy Sent from my Mobile Device On Jun 25, 2010, at 12:05 AM, "Bartelt, John E." wrote: > I bought it but I can't get it to connect. > (1) Does it understand https? > (2) Does it understand external authentication? > > Jo

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

2010-06-25 Thread Matthias Rieber
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 like RealName, WorkPhone will be put in the appropriate fields. It seems that

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

[rt-users] GnuPG Interface Mouse and Moose - Missing dependencies

2010-06-25 Thread Mark Street
Hi, I broke rt 3.8.8 after updating my Centos 5 box with yum...it upgraded perl. I knew it was going to be a problem right after I did it I ran make testdeps in my rt3 source directory and used CPAN to update all of the missing modules... all but 1, the GnuPG::Interface module is not beha

Re: [rt-users] slow mysql query after upgrade from 3.8.6 to 3.8.8

2010-06-25 Thread Ruslan Zakirov
Hello, Do you use SQLForACLChecks option? Where is EXPLAIN for this query? Show indexes from Groups table. On Fri, Jun 25, 2010 at 8:04 AM, Foggi, Nicola wrote: > > hey everyone, > > after upgrading from 3.8.6 to 3.8.8 we're getting a slow query on this > query: > > use rt3; > SELECT DISTINCT ma

Re: [rt-users] slow mysql query after upgrade from 3.8.6 to 3.8.8

2010-06-25 Thread Foggi, Nicola
UseSQLForACLChecks is set as the default under RT_Config.pm to "Set($UseSQLForACLChecks, undef);" here is the explain: EXPLAIN SELECT DISTINCT main.* FROM Users main JOIN Principals Principals_1 ON ( Principals_1.id = main.id ) JOIN CachedGroupMembers CachedGroupMembers_2 ON ( CachedGroupMe

Re: [rt-users] RT Mobile for iPhone

2010-06-25 Thread Paul O'Rorke
another vote for it on Android... :-) On 24/06/2010 3:15 PM, Paul wrote: Same here. Paul On 06/24/2010 03:03 PM, Ariel Saia wrote: I would love to see an Android version :) Ariel -Original Message- From: rt-users-boun...@lists.bestpractical.com [mailto:rt-users-boun...@lists.

Re: [rt-users] RT Mobile for iPhone (Dustin Collins)

2010-06-25 Thread John Bartelt
I just looked at the server log. It is passing the username and password as part of the URL in CLEAR TEXT! This can't work with external authentication - by which I mean, the authentication is done by the apache server, not by RT. It uses the REMOTE_USER environment variable, not a URL. John On

Re: [rt-users] slow mysql query after upgrade from 3.8.6 to 3.8.8

2010-06-25 Thread Foggi, Nicola
A little follow up on the explains: here is the query as run when displaying a ticket: mysql> EXPLAIN SELECT DISTINCT main.* FROM Users main JOIN Principals Principals_1 ON ( Principals_1.id = main.id ) JOIN CachedGroupMembers CachedGroupMembers_2 ON ( CachedGroupMembers_2.MemberId = Princip

Re: [rt-users] RT Mobile for iPhone (Dustin Collins)

2010-06-25 Thread Daniel Farst
We use external auth with LDAP and it opens and immediately crashes for me. In my Apache logs, I see two attempts to connect with my username and password in cleartext *shudders* -- Daniel Farst IT Support Coordinator College of Arts and Sciences Case Western Reserve University Public key on k

Re: [rt-users] RT Mobile for iPhone (Dustin Collins)

2010-06-25 Thread John Bartelt
On Fri, 25 Jun 2010, Daniel Farst wrote: In my Apache logs, I see two attempts to connect with my username and password in cleartext *shudders* Yes, I just spent several minutes chaning the passwords for the three accounts I had tested with. I wonder if I can get my money back? John +=+=+=

Re: [rt-users] RT Mobile for iPhone (Dustin Collins)

2010-06-25 Thread Troy Knabe
Yes, I have too. My apologies. I guess I should have said, "yes, it accepted https://hostname in the config." Again, Sorry! -Troy On Jun 25, 2010, at 9:49 AM, John Bartelt wrote: > On Fri, 25 Jun 2010, Daniel Farst wrote: >> >> In my Apache logs, I see two attempts to connect with my usern

[rt-users] Upgrading from RT 3.6.5

2010-06-25 Thread Patton, Brandon
Hello, I'm a fairly new Request Tracker user and a novice in the Linux world, but I've inherited this system after a co-worker left. We are in the process of getting more departments to use this product and I want to get it upgraded before we move forward. I have read a lot of the documentation

Re: [rt-users] Upgrading from RT 3.6.5

2010-06-25 Thread Jerrad Pierce
Ungh, Ubuntu as a server. Leaving that aside, simply use the package manager (something like Synaptic in the GUI) to check where the files for the rt package are installed. Back those up if you have concerns about possible customizations done to core instead of local code. Backup your database. Th

Re: [rt-users] Help and Ideas needed for a special setup

2010-06-25 Thread Christian Loos
Hi Torsten, I would create a special group to identify the possible ticket owner. So you can quickly pull someone out of the group, if he is on holiday. Get the group member,sort them by name and put them in a list. Get the last assigned owner by get all tickets from queue, order by ticket id de

Re: [rt-users] slow mysql query after upgrade from 3.8.6 to 3.8.8

2010-06-25 Thread Foggi, Nicola
I think i've tracked it down to: commit 932a5a25a3520f42471e for Users_Overlay.pm, when I back Users_Overlay back up to the version previous, no problems with a slow query, but whatever query this is building is the problem. I'm going to try and dig into the code to see if I can tell where

Re: [rt-users] slow mysql query after upgrade from 3.8.6 to 3.8.8

2010-06-25 Thread Foggi, Nicola
Ruslan, So I think I figured it out... the original EXPLAIN was showing it using Groups2 index. I forced a query against the Groups1 index, and the results came back in under 1 second vs 11-15 seconds before. I dropped the Groups2 index for the time being. Maybe with all the re-writes aroun