[rt-users] Re: Session table growing.
Anya Figlin
afiglin at pictage.com
Thu Apr 28 10:23:19 EDT 2005
Sessions table is used internally by Apache. I have recently deleted
all sessions entries older than a month, I feel that it is a safe thing
to do - the change had no effect on my instance of RT.
It'd be a good practice to include sessions table cleaning routine into
one of your regular maintenance scripts.
-anya
On Thu, 2005-04-28 at 10:00 -0400, rt-users-
request at lists.bestpractical.com wrote:
> Send RT-Users mailing list submissions to
> rt-users at lists.bestpractical.com
>
> To subscribe or unsubscribe via the World Wide Web, visit
> http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
> or, via email, send a message with subject or body 'help' to
> rt-users-request at lists.bestpractical.com
>
> You can reach the person managing the list at
> rt-users-owner at lists.bestpractical.com
>
> When replying, please edit your Subject line so it is more specific
> than "Re: Contents of RT-Users digest..."
>
>
> Today's Topics:
>
> 1. Re: Question on setting up email of tickets (Sam Snow)
> 2. setting priority in rt-mailgate (Andrew Xenides)
> 3. Re: Let everybody see all tickets (seph)
> 4. Re: RT3 Cannot select a queue to create a new ticket (seph)
> 5. Re: Export RT data to CSV file (seph)
> 6. CreateTicket - Template question (Ruediger Riediger)
> 7. Re: Re: Let everybody see all tickets (Jan-Frode Myklebust)
> 8. Re: Let everybody see all tickets (seph)
> 9. Re: Let everybody see all tickets (m.bruni at ifad.org)
> 10. Session table growing. (Barnacle Bob)
>
>
> ----------------------------------------------------------------------
>
> Message: 1
> Date: Wed, 27 Apr 2005 16:59:35 -0500
> From: Sam Snow <sam.snow at christianheritageschool.org>
> Subject: Re: [rt-users] Question on setting up email of tickets
> To: Jonathan Jesse <jjesse at ftpb.com>
> Cc: rt-users at lists.bestpractical.com
> Message-ID: <42700B47.7080202 at christianheritageschool.org>
> Content-Type: text/plain; charset=ISO-8859-1; format=flowed
>
> Jonathan Jesse wrote:
> > Pardon the ignorance, but I could not find any help through
> > wiki.bestpractical.com, but I would like to use an existing smtp server
> > to send emails from rt to the rest of my group.
> > I am somewhat new to Linux so would need some help on setting this up.
> > We currently use MS Exchange as our mail/groupwise program w/ Active
> > Directory. I have some Copiers w/ the scan -> email function that uses
> > my smtp server on my exchange server to send emails to people inside my
> > organization. I would like to do the same thing w/ RT. Bounce emails
> > off my exchange servers smtp server. How can I do that?
> > 0
> > Thanks in advance
> >
> >
>
> More details are needed.
> 1. What version and flavor of Linux are you running?
> 2. Do you have a working email server program installed on your current
> Linux server? (if so, you just need to tell it where to send all the
> messages-- ie, to the exchange server.)
>
> Sam
>
>
> ------------------------------
>
> Message: 2
> Date: Thu, 28 Apr 2005 11:28:20 +0930
> From: "Andrew Xenides" <andrew at staff.esc.net.au>
> Subject: [rt-users] setting priority in rt-mailgate
> To: <rt-users at lists.bestpractical.com>
> Message-ID: <20050428020234.A1BF861C232 at sr-gw.esc.net.au>
> Content-Type: text/plain; charset="us-ascii"
>
> I am inserting jobs in to a queue using rt-mailgate by a php script sending
> email
>
> however, different jobs require different priority, am i able to set the
> priority on a job by job basis from the email, or can i make a different
> alias for each job type and point them to a different mailgate command to
> set the priority?
>
> thanks
>
>
> Andrew Xenides
> Web Developer
> EscapeNet
> 465 South Road
> Keswick SA 5035
> T: (08) 8292 5200
> F: (08) 8292 5299
> E: andrew at staff.esc.net.au
> W: http://www.esc.net.au
>
>
> -------------- next part --------------
> An HTML attachment was scrubbed...
> URL: http://lists.bestpractical.com/pipermail/rt-users/attachments/20050428/1f78f208/attachment-0001.htm
>
> ------------------------------
>
> Message: 3
> Date: Wed, 27 Apr 2005 23:02:24 -0400
> From: seph <seph at directionless.org>
> Subject: [rt-users] Re: Let everybody see all tickets
> To: rt-users at lists.bestpractical.com
> Message-ID: <w52acnjy56n.fsf at lame.message.id>
> Content-Type: text/plain; charset=us-ascii
>
> > I would want all our autogenerated/unprivileged users to see and
> > search all tickets in the system. I've tried adding all privileges to
> > the "Everyone" group, but the users still can't see any other tickets
> > than their own (unless typing in the ticket number directly in the
> > GotoTicket box).
>
> Are you using the SelfService interface? I'm not sure it does that.
>
> seph
>
>
> ------------------------------
>
> Message: 4
> Date: Wed, 27 Apr 2005 23:13:29 -0400
> From: seph <seph at directionless.org>
> Subject: [rt-users] Re: RT3 Cannot select a queue to create a new
> ticket
> To: "Cameron Beattie" <cameron.beattie at appsteam.co.nz>
> Cc: rt-users at lists.bestpractical.com
> Message-ID: <w52y8b3wq3q.fsf at lame.message.id>
> Content-Type: text/plain; charset=us-ascii
>
> > However when a non-privelaged user that I have created logs in and
> > attempts to create a new ticket they get the CreateTicketInQueue.html
> > page up and are asked to "select a queue for your new ticket". However
> > there is no place for them to do this.
>
> I believe that would normally be a pulldown list of allowed
> queues. Does Everyone of Unprivledged have create ticket rights in any
> queues?
>
> seph
>
>
> ------------------------------
>
> Message: 5
> Date: Wed, 27 Apr 2005 23:28:27 -0400
> From: seph <seph at directionless.org>
> Subject: [rt-users] Re: Export RT data to CSV file
> To: "Steinigans-Hillemann, Joerg"
> <Joerg.Steinigans-Hillemann at keymile.com>
> Cc: rt-users at lists.bestpractical.com
> Message-ID: <w52r7gvwpes.fsf at lame.message.id>
> Content-Type: text/plain; charset=us-ascii
>
> > Is there any other way to export data from the RT (3.0.11)? Maybe a
> > perl script or other reporting utilities?
>
> Yes, you can right a perl script around the api to spit back csv, or
> whatever you want. the command line interface might also be able to do
> what you want.
>
> seph
>
>
> ------------------------------
>
> Message: 6
> Date: Thu, 28 Apr 2005 10:39:50 +0200
> From: Ruediger Riediger <ruediger.riediger at sun.com>
> Subject: [rt-users] CreateTicket - Template question
> To: rt-users at lists.bestpractical.com
> Message-ID: <4270A156.8010703 at sun.com>
> Content-Type: text/plain; charset=ISO-8859-15
>
> Hello RT community,
>
> is there any way to include the ticket number from a "CreateTicket"
> action into the template of the CreateTicket?
>
> E.g. I want to include the string
>
> please reply with the subject "[RT-name #12345]"
>
> in the ticket created through "===Create-Ticket: Inform", with 12345 the
> number of the just created ticket. This will then be sent automatically
> (On Create Notify Requester with Template Global: Correspond).
>
> If I put {$Ticket->id} into the template, it will give the number of the
> ticket this is run from. {$Tickets{'TOP'}->id} gives the same number
> (this is the correct way to get the number of the creating ticket after
> all). {$Tickets{'Inform'}->id} is not yet defined.
>
> What else to use?
>
> Best regards,
>
> Ruediger Riediger
>
> --
> Dr. Ruediger Riediger Sun Microsystems GmbH
> NSG - SunCERT Komturstr. 18a
> mailto:Ruediger.Riediger at Sun.com D-12099 Berlin
> ------------------------------------------------------------------------
> NOTICE: This email message is for the sole use of the intended
> recipient(s) and may contain confidential and privileged information.
> Any unauthorized review, use, disclosure or distribution is prohibited.
> If you are not the intended recipient, please contact the sender by
> reply email and destroy all copies of the original message.
> ------------------------------------------------------------------------
> PGP 2048RSA/0x2C5020E9 964C E189 0FF0 8882 2BAB 65E2 6912 1FF2
> ------------------------------------------------------------------------
>
>
> ------------------------------
>
> Message: 7
> Date: Thu, 28 Apr 2005 13:36:55 +0200
> From: Jan-Frode Myklebust <Jan-Frode.Myklebust at bccs.uib.no>
> Subject: Re: [rt-users] Re: Let everybody see all tickets
> To: rt-users at lists.bestpractical.com
> Message-ID: <20050428113655.GA15760 at ii.uib.no>
> Content-Type: text/plain; charset=us-ascii
>
> On Wed, Apr 27, 2005 at 11:02:24PM -0400, seph wrote:
> >
> > Are you using the SelfService interface? I'm not sure it does that.
>
> Yes, when logging in as unprivileged user, one is dropped into the
> SelfService interface... Is this configurable? Are there any other
> interfaces suitable for the unprivileged users?
>
>
> -jf
>
>
> ------------------------------
>
> Message: 8
> Date: Thu, 28 Apr 2005 07:47:39 -0400
> From: seph <seph at directionless.org>
> Subject: [rt-users] Re: Let everybody see all tickets
> To: rt-users at lists.bestpractical.com
> Message-ID: <w52sm1b9l7o.fsf at lame.message.id>
> Content-Type: text/plain; charset=us-ascii
>
> > Yes, when logging in as unprivileged user, one is dropped into the
> > SelfService interface... Is this configurable? Are there any other
> > interfaces suitable for the unprivileged users?
>
> Ah. I'm not sure, but I suspect not. Why not just create them privledged?
>
> seph
>
>
> ------------------------------
>
> Message: 9
> Date: Thu, 28 Apr 2005 05:01:51 +0200
> From: m.bruni at ifad.org
> Subject: [rt-users] Re: Let everybody see all tickets
> To: rt-users at lists.bestpractical.com
> Message-ID: <courier.4270521F.00001DC0 at ifslx5>
> Content-Type: text/plain; format=flowed; charset="utf-8"
>
> I am on duty travel until May 4th.
> If your query requires immediate attention, please call Hotline ext. 2121.
>
> Regards
>
> Marco Bruni
>
>
>
> ________________________________________________________
> 2005 is the International Year of Microcredit -
> Microfinance is one way to fight poverty in rural areas,
> where most of the world's poorest people live.
> ________________________________________________________
> Mail Scanned by AntiVirus (Clean Mail)
> *.#IFAD#.*
>
> ________________________________________________________
>
>
>
>
> ------------------------------
>
> Message: 10
> Date: Thu, 28 Apr 2005 09:53:33 -0400
> From: Barnacle Bob <barnaclebob at gmail.com>
> Subject: [rt-users] Session table growing.
> To: "rt-users at lists.bestpractical.com"
> <rt-users at lists.bestpractical.com>
> Message-ID: <d1387ed0050428065336de4b3e at mail.gmail.com>
> Content-Type: text/plain; charset=ISO-8859-1
>
> Hello everyone,
> I was recently browsing through my databases and spied that the RT
> session table has grown to 10 meg. I was wondering what is stored in
> this table as i thought session data would be cleared at some point.
> (oldest entries seem to be over a year old, about when we started
> using RT). My question is: is it safe to just delete everything that
> has not been updated in a month or so?
>
> -Karl Pietri
>
>
> ------------------------------
>
> _______________________________________________
> RT-Users mailing list
> RT-Users at lists.bestpractical.com
> http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
>
>
> End of RT-Users Digest, Vol 13, Issue 100
> *****************************************
More information about the rt-users
mailing list