Re: [rt-users] Have to restart apache2 after reboot

2013-06-13 Thread Christian Loos
Am 13.06.2013 19:08, schrieb rt4: > S18apache2 and S19postgresql. > > Changed postgresql to S17, but that didn't fix it. If your OS uses Upstart instead of SysV for Init scrips it isn't guarantied that PostgreSQL starts before Apache. In Debian they solved the problem with an RT Init scrips whic

Re: [rt-users] Extracting file attachments from tickets

2013-06-13 Thread Emmanuel Lacour
On 13/06/2013 19:10, john boris wrote: We use our rt3.6.6 instance to store reports from our system. Is there a way I can do an SQL against the database to extract these files without going into each ticket separatley? Look at this script for an example: http://git.home-dn.net/?p=manu/rt-scr

Re: [rt-users] RT MAX TICKET ID

2013-06-13 Thread romain.peliss...@bell.ca
Hi, Thanks for the information :) Romain -Message d'origine- De : k...@rice.edu [mailto:k...@rice.edu] Envoyé : 11 juin 2013 16:16 À : Pelissier, Romain (6045822) Cc : rt-users@lists.bestpractical.com Objet : Re: [rt-users] RT MAX TICKET ID On Tue, Jun 11, 2013 at 03:57:00PM -0400, romai

Re: [rt-users] Assign Global Rights to Group?

2013-06-13 Thread Ken Johnson
On Wed, Jun 12, 2013 at 03:46:29PM -0500, Ken Johnson wrote: > We find that the best way for us to manage user rights is to create a > number of groups, assign global rights to the groups, and then assign > users to the appropriate group. > > I'm trying to work out how to assign global rights t

Re: [rt-users] Can a scrip do a search like RT::Client::REST does?

2013-06-13 Thread Landon
. .. and in case anyone was curious the equivelent and much better looking code to the RT::Client::REST snippet I provided earlier is: my $ips = $self->TicketObj->CustomFieldValues( 'IP' ); while ( my $ipobj = $ips->Next ) { my $ip = $ipobj->Content; my $tsql = qq/Queue = 'Incidents' AND Statu

Re: [rt-users] Can a scrip do a search like RT::Client::REST does?

2013-06-13 Thread Landon
On 13 June 2013 11:05, Thomas Sibley wrote: > On 06/13/2013 10:52 AM, Landon wrote: > > Thanks Ken. The document I found was > > at http://bestpractical.com/rt/docs/4.0/RT/Search.html > > You don't want RT::Search for this. > > You want to use the RT::Tickets class using the ->FromSQL method, wh

Re: [rt-users] Can a scrip do a search like RT::Client::REST does?

2013-06-13 Thread Thomas Sibley
On 06/13/2013 10:52 AM, Landon wrote: > Thanks Ken. The document I found was > at http://bestpractical.com/rt/docs/4.0/RT/Search.html You don't want RT::Search for this. You want to use the RT::Tickets class using the ->FromSQL method, which accepts TicketSQL. There are docs and plenty of examp

Re: [rt-users] Can a scrip do a search like RT::Client::REST does?

2013-06-13 Thread Landon
On 13 June 2013 10:44, k...@rice.edu wrote: > > Hi Landon, > > I think you should be able to use RT::Search from your scrip directly. > Check out the API docs. > > Thanks Ken. The document I found was at http://bestpractical.com/rt/docs/4.0/RT/Search.html I don't know how to specify the query t

Re: [rt-users] Can a scrip do a search like RT::Client::REST does?

2013-06-13 Thread k...@rice.edu
On Thu, Jun 13, 2013 at 10:38:06AM -0700, Landon wrote: > My scrip looks for currently open Incidents that are related to each of the > IP addresses in CF.{IP} on an Incident Report. If it finds one it links > the Incident Report to that Incident thus making it unnecessary for someone > to do it m

[rt-users] Can a scrip do a search like RT::Client::REST does?

2013-06-13 Thread Landon
My scrip looks for currently open Incidents that are related to each of the IP addresses in CF.{IP} on an Incident Report. If it finds one it links the Incident Report to that Incident thus making it unnecessary for someone to do it manually later. This might be changed to CustomerID or something

Re: [rt-users] REST vs GUI: huge performance diference

2013-06-13 Thread Ram
After using a few tools suggested by Tom (MasonX::Profiler and then NYTProf) it looks to me like the issue imay be in share/html/REST/1.0/Forms/ticket/default and really relates to a difference in the default (fields) in GUI quick search compared to what the REST servicer does. By changing my quer

[rt-users] Extracting file attachments from tickets

2013-06-13 Thread john boris
We use our rt3.6.6 instance to store reports from our system. Is there a way I can do an SQL against the database to extract these files without going into each ticket separatley? -- John J. Boris, Sr. Online Services www.onlinesvc.com -- RT Training in Seattle, June 19-20: http://bestpractica

Re: [rt-users] Have to restart apache2 after reboot

2013-06-13 Thread rt4
S18apache2 and S19postgresql. Changed postgresql to S17, but that didn't fix it. -- View this message in context: http://requesttracker.8502.n7.nabble.com/Have-to-restart-apache2-after-reboot-tp54292p54294.html Sent from the Request Tracker - User mailing list archive at Nabble.com. -- RT T

Re: [rt-users] Have to restart apache2 after reboot

2013-06-13 Thread Kevin Falcone
On Thu, Jun 13, 2013 at 09:40:23AM -0700, rt4 wrote: > I'm experiencing some peculiar behavior. After reboot, RT (4.0.13 with > libapache2-mod-perl2 version 2.0.7-3) > can't connect to database (postgresql 9.1). PG is up and running and I can > connect to it from other clients. > If I restart Ap

[rt-users] Have to restart apache2 after reboot

2013-06-13 Thread rt4
I'm experiencing some peculiar behavior. After reboot, RT (4.0.13 with libapache2-mod-perl2 version 2.0.7-3) can't connect to database (postgresql 9.1). PG is up and running and I can connect to it from other clients. If I restart Apache2, then everything is ok. >From log: RT: DBI connect('dbn

Re: [rt-users] RT_SiteConfig help

2013-06-13 Thread Kevin Falcone
On Thu, Jun 13, 2013 at 04:57:27PM +0400, Ruslan Zakirov wrote: >On Thu, Jun 13, 2013 at 4:42 PM, Heracross77 <[1]heracros...@gmail.com> > wrote: > > Set($WebBaseURL , "[2]http://help.rtlti.com";); > >Where did you take an idea that you should set above instead of "Base > configura

Re: [rt-users] Change template resolved for send more information to user

2013-06-13 Thread Kevin Falcone
On Wed, Jun 12, 2013 at 02:50:01PM -0700, jrios wrote: >I want change the template resolved. because i need send more > information when resolved tickets. for example i want send the date started > ticket and date resolved tickets > >this is new codec into the template > > Date st

Re: [rt-users] Short URL for saved searches

2013-06-13 Thread Kevin Falcone
On Wed, Jun 12, 2013 at 04:28:07PM +0200, Wasko Lukasz wrote: > is there any chances for short url linking to saved searches? Short links have come up a few times, and wouldn't actually be too bad to implement, but we could never come up with a strong enough use-case to account for the time neede

Re: [rt-users] RT_SiteConfig help

2013-06-13 Thread jrios
Hello I installed the RT in the server with port is 8081 ... for work only need change into the file /etc/request-tracker4/RT_SiteConfig.pm # # THE WEBSERVER: Set($WebPath , "/rt"); Set($WebBaseURL , "http://www..com:8081";); /etc/init.d/apache2 restart good luck -- Vi

Re: [rt-users] RT_SiteConfig help

2013-06-13 Thread Heracross77
But wich configuration can I use to at least start using RT at a Glance page whitout receiving "An internal RT error has occurred. Your administrator can find more details in RT's log files." error? I actually need a guide to configure RT and apache2 files after the instalation to use it in the mos

Re: [rt-users] RT_SiteConfig help

2013-06-13 Thread Ruslan Zakirov
On Thu, Jun 13, 2013 at 4:42 PM, Heracross77 wrote: > > Set($WebBaseURL , "http://help.rtlti.com";); Where did you take an idea that you should set above instead of "Base configuration" [1]? [1] http://bestpractical.com/rt/docs/latest/RT_Config.html#Base-configuration Quote from the documenta

[rt-users] RT_SiteConfig help

2013-06-13 Thread Heracross77
Hi! I'm pretty new to RT and i had to install it here at work. We will use it to manage the computer support request sent by our clients. I finished installing it, following the tutorial below: http://simonsmicrophone.com/2011/10/19/rt-4-debian-6-installation/ I'm using Debian Wheezy and RT 4.0.13

Re: [rt-users] CF - article - image as attachment - link values to

2013-06-13 Thread Ruslan Zakirov
On Thu, Jun 13, 2013 at 12:00 PM, Alexander Kucheryuk < alex.kucher...@eltoma-offshore.com> wrote: > Hello! > I am running RT 4.0.13 on Centos 6.3. > I have configured CF for articles. Type of CF is "upload multiple images". > When inserting article with that CF (for example, replying to ticket),

Re: [rt-users] Decrypting messages with GPG

2013-06-13 Thread Ruslan Zakirov
On Thu, Jun 13, 2013 at 2:30 AM, Oliver Day wrote: > I haven't found documentation that explains how to cache passwords that > will allow mailgate to decrypt messages sent to RT. I've set the home > directory to the default location and imported the appropriate keys. So I'm > able to encrypt a me

[rt-users] CF - article - image as attachment - link values to

2013-06-13 Thread Alexander Kucheryuk
Hello! I am running RT 4.0.13 on Centos 6.3. I have configured CF for articles. Type of CF is "upload multiple images". When inserting article with that CF (for example, replying to ticket), only the name (of image) is inserted, not the image itself. I was thinking of bypassing that issue using

Re: [rt-users] Assign Global Rights to Group?

2013-06-13 Thread Emmanuel Lacour
On Wed, Jun 12, 2013 at 03:46:29PM -0500, Ken Johnson wrote: > We find that the best way for us to manage user rights is to create a number > of groups, assign global rights to the groups, and then assign users to the > appropriate group. > > I'm trying to work out how to assign global rights to a