Re: [rt-users] Set Mailgate to not Create Tickets

2013-01-18 Thread Ruslan Zakirov
On Thu, Jan 17, 2013 at 8:11 PM, Chris Lasater chris.lasa...@oracle.com wrote: Hi, Is there a way to set rt-mailgate to not create tickets, but still allow it to correspond/reply? I have a queue I want people to create tickets for in the web interface to ensure that the mandatory custom

Re: [rt-users] Find ticket numbers of tickets with large attachments

2013-01-18 Thread Ruslan Zakirov
Hi, I hoped you will do some leg work and figure this out. On Thu, Jan 17, 2013 at 5:35 PM, Remy van Elst re...@relst.nl wrote: Hy Rus, Tried some more stuff, now it is working. Thanks! The Query: mysql SELECT DISTINCT Transactions.ObjectId,Attachments.Subject FROM Attachments LEFT OUTER

[rt-users] how to dump out all users from database ?

2013-01-18 Thread Philip
Hi I am using RT 4.0.5-3 from debian squeeze-backports and ExternalAuth pointing at the company AD. I'm not much of a database admin. The database is mysql 5.1.63. Can someone tell me the commands that would tell me:- All users whether they are privileged or not? what RT thinks their AD

Re: [rt-users] Using RT for tickets opened by phone - RT 4.0.8

2013-01-18 Thread Ruslan Zakirov
On Fri, Jan 18, 2013 at 12:29 AM, Jim Lesinski jim.lesin...@gmail.com wrote: Hello, What is the process that people are using to add new users to the RT system when taking a phone call? For example you receive a call from a person who is not currently in the RT users list. Would your helpdesk

[rt-users] Problemwith rt-crontool: can't get it running

2013-01-18 Thread Patrick G. Stoesser
Hello there, even after googleing and trying several hours I'm still stuck with rt-crontool. I'm running RT 4.0.7 via Backports on a Debian Squeeze system. RT istelfs works ok so far, but rt-crontool not. According to the manual, I have added a non-privileged system user (rtcron).This

[rt-users] [SOLVED] Re: Problemwith rt-crontool: can't get it running

2013-01-18 Thread Patrick G. Stoesser
As often, just after I wrote to the list, I got a solution. I just opened the line specified in the error message once again and saw the comment VALUE is a queue id or Name. In the cron line, I specified --search-arg general. And so my idea was that maybe general is not a queue id or Name. So

Re: [rt-users] [SOLVED] Re: Problemwith rt-crontool: can't get it running

2013-01-18 Thread Kevin Falcone
On Fri, Jan 18, 2013 at 03:53:25PM +0100, Patrick G. Stoesser wrote: As often, just after I wrote to the list, I got a solution. I just opened the line specified in the error message once again and saw the comment VALUE is a queue id or Name. In the cron line, I specified --search-arg

Re: [rt-users] [SOLVED] Re: Problemwith rt-crontool: can't get it running

2013-01-18 Thread Patrick G. Stoesser
Aaall right! I understood general as apply to all queues... Regards,pgs Am 18.01.2013 16:01, schrieb Kevin Falcone: On Fri, Jan 18, 2013 at 03:53:25PM +0100, Patrick G. Stoesser wrote: As often, just after I wrote to the list, I got a solution. I just opened the line specified in the

[rt-users] [SOLVED] how to dump out all users from database ?

2013-01-18 Thread Philip
I managed to dump out usernames by logging in as root in the web GUI and doing a user search. Job done regards, Philip On 18/01/13 12:55, Philip wrote: Hi I am using RT 4.0.5-3 from debian squeeze-backports and ExternalAuth pointing at the company AD. I'm not much of a database admin. The

[rt-users] [solved-ish] Company keeps changing is name/email addresses - User creation failed in mailgateway: Name in use?

2013-01-18 Thread Philip
I found that when I searched for users by select_user-email_address_matches-@companyy.com that there were two categories of user. 1. The username was a.per...@companyy.com I think that these users had been created without a successful AD lookup. When such a person sent another email from

[rt-users] Attaching a Custom Data File to a New Ticket

2013-01-18 Thread Vega, Angel L.
Hello, I'm trying to attach a custom data file to a new ticket but it's not being saved once the ticket has been created. (The data file contains plain text and commands in JSON format and the custom file extension is .punt). I've tried extracting the content into a .txt file but the end result

Re: [rt-users] Ignoring out of office emails

2013-01-18 Thread Thomas Sibley
On 01/15/2013 03:26 PM, Brent Wiese wrote: I have a powershell script that emails users (using the System.Net.Mail class) and the “From” address is set to our RT system, making it easier for users to get help if needed. The problem is, people’s out-of-office responses are opening tickets.

Re: [rt-users] RT Migration to new HW and version

2013-01-18 Thread Judy Gaukel
I have a sort of related question here -- we have an embarrassingly old version of RT on another server -- I am trying to install it on a new (Solaris 10) machine and see that openCSW no longer has mysql5rt --- and don't really know the tweaks that make mysql5 mysql5rt. Where do people get their