Re: [rt-users] sendmail error (exited with code 75) - RHEL6

2012-09-06 Thread Raphaël Berlamont
TMP_FILE}" exec tee -a "${TMP_FILE}" | /usr/sbin/sendmail.real "$@" echo "MESSAGE ENDED" >> "${TMP_FILE}" echo "`date +%Y%m%d-%H%M%S`" >> "${TMP_FILE}" echo "==END SENDMAIL CALL==" >> &q

Re: [rt-users] Using 'today' in an Advanced search gives different results than using explicit date.

2012-09-06 Thread Robert Blackwell
On Fri, Aug 24, 2012 at 12:59 PM, Thomas Sibley wrote: > On 08/24/2012 09:35 AM, Robert Blackwell wrote: >> For example I would expect these to return the same tickets but they don't: >> >> This returns 7 tickets. >> Status != 'resolved' AND CF.{FollowUp} < '2012-08-25' >> >> This returns 513. >>

[rt-users] Custom SQL

2012-09-06 Thread Winn Johnston
All, I am trying to create a top closers list on the default dashboard. I have the exact SQL statment i want to use, but i am lost after that. select u.Name as User, count(1) as TotalClosedTix from Users u join Tickets t on u.id = t.owner where t.Status = "resolved" group by u.Name order by 2 d

[rt-users] How to grant access to users to edit the values in custom fields?

2012-09-06 Thread Jason Marshall
Hi all, I'm using rt-3.8.8. Looking at the permissions I can grant, I thought this would be pretty simple. I granted Modify and Admin rights on the custom field itself, but at this point a Configure menu doesn't even appear on the left side of the users' screens. Is there something else I ne

Re: [rt-users] How to grant access to users to edit the values in custom fields?

2012-09-06 Thread Matt Brennan
On version 4, there is a permission called "ShowConfigTab" which is also required. If memory serves, that was the same on 3.8. -Matt On Thu, Sep 6, 2012 at 11:28 AM, Jason Marshall wrote: > Hi all, I'm using rt-3.8.8. Looking at the permissions I can grant, I > thought this would be pretty simp

Re: [rt-users] check for available recipients on reply

2012-09-06 Thread Kevin Falcone
On Mon, Sep 03, 2012 at 12:00:52PM +0200, inb...@telenet.be wrote: > Our internal staff uses comments to put information in tickets for co-workers > that can't be viewed by customers. > Customer information is shared via correspondence. > > Last week, a staff member deleted (accidentaly) the requ

Re: [rt-users] How to grant access to users to edit the values in custom fields?

2012-09-06 Thread Jason Marshall
Thanks Matt, that might just have done it. I set it for the Privileged Users group, so anyone who needs to do something in there should now be able to. I'm getting the users to test now -- thanks again! On version 4, there is a permission called "ShowConfigTab" which is also required. If me

Re: [rt-users] sendmail error (exited with code 75) - RHEL6

2012-09-06 Thread Thomas Sibley
On 09/06/2012 06:55 AM, Raphaël Berlamont wrote: > So I can now tell that sendmail IS called, but nothing is piped in, or > it crashs before RT can pipe anything in it... This is indeed strange. Can you show us the output of `apachectl -V`? apachectl may be spelled apache2ctl or httpdctl on RHEL

Re: [rt-users] Using 'today' in an Advanced search gives different results than using explicit date.

2012-09-06 Thread Thomas Sibley
On 09/06/2012 07:07 AM, Robert Blackwell wrote: > Here is the SQL and stack trace of two queries obtained by using > "Configuration » Tools » SQL Queries". > [snip] > ObjectCustomFieldValues_1.Content < 'today' Er, right. I forgot that date and datetime CFs don't get the same "natural language"

Re: [rt-users] Custom SQL

2012-09-06 Thread Kenneth Crocker
Winn, Are you using the RT SQL provided with the system? Once you've created a search with RTSQL, you save the search and then it is available to be used in a Dashboard. Hope this helps. Kenn On Thu, Sep 6, 2012 at 7:54 AM, Winn Johnston wrote: > All, > > I am trying to create a top closers l

Re: [rt-users] configure RT-Authen-ExternalAuth to not verify certificates

2012-09-06 Thread Brent Wiese
> Hello All, > > Is there anyway to configure RT-Authen-ExternalAuth to not verify ssl > certificates? I'm hitting an ldap server that has a self-signed cert > and it would be much more simple to not verify the certificate. I tried > adding "verify => 'none'" to net_ldap_args which is used by Net: