Re: [rt-users] RT session cleanup - session table size

2013-07-09 Thread Craig Ringer
On 07/09/2013 03:05 PM, Alex Decalli wrote: I think there is no such table. There certainly is. From my PostgreSQL logs on the database that RT is using: UPDATE sessions SET a_session = $1 WHERE id = $2 with a giant binary blob as $1 DETAIL: parameters: $1 = 'BQgDCQQRD1 RT

[rt-users] Digitaly signed e-mails in RT?

2013-07-09 Thread Petr Grolmus
Hi there, we would love to validate e-mails digitaly signed by certificate and we need to visualize (e.g. by green hook) that e-mail was successfuly verified. But not all e-mails will be digitaly signed, just some of them. I tried to find some plugins and/or extensions for this, but none was

Re: [rt-users] RT session cleanup - session table size

2013-07-09 Thread k...@rice.edu
On Tue, Jul 09, 2013 at 12:02:17PM +0800, Craig Ringer wrote: On 07/07/2013 08:21 PM, Alex Decalli wrote: Hello everybody I want to cleanup my session table, it is already about 1 Gigabyte! I hit: me@myserver:~$ sudo rt-clean-sessions --debug --older 1M That reminds me - is there any

[rt-users] Custom field appearance and single column ticket creation

2013-07-09 Thread Landon
When creating an RTIR Investigations ticket I'd like to modify the size of some of my custom fields and possibly having the Basics section with the custom fields in one column above the Launch a New Investigation section. I might also have to have more than one column *within* the Basics section

Re: [rt-users] Digitaly signed e-mails in RT?

2013-07-09 Thread Kevin Falcone
On Tue, Jul 09, 2013 at 11:01:36AM +0200, Petr Grolmus wrote: we would love to validate e-mails digitaly signed by certificate and we need to visualize (e.g. by green hook) that e-mail was successfuly verified. But not all e-mails will be digitaly signed, just some of them. I tried to find

Re: [rt-users] RT session cleanup - session table size

2013-07-09 Thread Kevin Falcone
On Tue, Jul 09, 2013 at 03:23:53PM +0800, Craig Ringer wrote: On 07/09/2013 03:05 PM, Alex Decalli wrote: I think there is no such table. There certainly is. From my PostgreSQL logs on the database that RT is using: UPDATE sessions SET a_session = $1 WHERE id = $2 with a giant

Re: [rt-users] RT session cleanup - session table size

2013-07-09 Thread Kevin Falcone
On Mon, Jul 08, 2013 at 08:05:32PM +0200, Alex Decalli wrote: Thanks a lot Kevin. Frankly I have been working on this server for like 1 week, this is RT3.8 on Ubuntu 11.04 (terrible, I know), it has no GUI installed (no problem for me), mysql 5.1 and the administrator has left

[rt-users] Mandatory Custom Field Privileges

2013-07-09 Thread Tim Wiley
GroupA are workers in effectively own Queue1. GroupA requested a number of custom fields for their queue that help facilitate better reporting on tickets. Because of the reporting nature of these custom fields, GroupA has requested that only they have the permissions required to set the

Re: [rt-users] Mandatory Custom Field Privileges

2013-07-09 Thread Thomas Sibley
On 07/09/2013 02:20 PM, Tim Wiley wrote: GroupA are workers in effectively own Queue1. GroupA requested a number of custom fields for their queue that help facilitate better reporting on tickets. Because of the reporting nature of these custom fields, GroupA has requested that only they

Re: [rt-users] Mandatory Custom Field Privileges

2013-07-09 Thread Tim Wiley
On 07/09/2013 04:43 PM, Thomas Sibley wrote: On 07/09/2013 02:20 PM, Tim Wiley wrote: GroupA are workers in effectively own Queue1. GroupA requested a number of custom fields for their queue that help facilitate better reporting on tickets. Because of the reporting nature of these custom