Session table growing

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

Barnacle Bob wrote:

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?
Yeah, it’s save, you can even put script like
http://wiki.bestpractical.com/index.cgi?CleanupSessions into your crontab.

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.

-anyaOn Thu, 2005-04-28 at 10:00 -0400, rt-users- request@lists.bestpractical.com wrote:

Send RT-Users mailing list submissions to
rt-users@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@lists.bestpractical.com

You can reach the person managing the list at
rt-users-owner@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@ifad.org)
  10. Session table growing. (Barnacle Bob)

Message: 1
Date: Wed, 27 Apr 2005 16:59:35 -0500
From: Sam Snow sam.snow@christianheritageschool.org
Subject: Re: [rt-users] Question on setting up email of tickets
To: Jonathan Jesse jjesse@ftpb.com
Cc: rt-users@lists.bestpractical.com
Message-ID: 42700B47.7080202@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@staff.esc.net.au
Subject: [rt-users] setting priority in rt-mailgate
To: rt-users@lists.bestpractical.com
Message-ID: 20050428020234.A1BF861C232@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@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@directionless.org
Subject: [rt-users] Re: Let everybody see all tickets
To: rt-users@lists.bestpractical.com
Message-ID: w52acnjy56n.fsf@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@directionless.org
Subject: [rt-users] Re: RT3 Cannot select a queue to create a new
ticket
To: “Cameron Beattie” cameron.beattie@appsteam.co.nz
Cc: rt-users@lists.bestpractical.com
Message-ID: w52y8b3wq3q.fsf@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@directionless.org
Subject: [rt-users] Re: Export RT data to CSV file
To: "Steinigans-Hillemann, Joerg"
Joerg.Steinigans-Hillemann@keymile.com
Cc: rt-users@lists.bestpractical.com
Message-ID: w52r7gvwpes.fsf@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@sun.com
Subject: [rt-users] CreateTicket - Template question
To: rt-users@lists.bestpractical.com
Message-ID: 4270A156.8010703@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@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@bccs.uib.no
Subject: Re: [rt-users] Re: Let everybody see all tickets
To: rt-users@lists.bestpractical.com
Message-ID: 20050428113655.GA15760@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@directionless.org
Subject: [rt-users] Re: Let everybody see all tickets
To: rt-users@lists.bestpractical.com
Message-ID: w52sm1b9l7o.fsf@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@ifad.org
Subject: [rt-users] Re: Let everybody see all tickets
To: rt-users@lists.bestpractical.com
Message-ID: courier.4270521F.00001DC0@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@gmail.com
Subject: [rt-users] Session table growing.
To: "rt-users@lists.bestpractical.com"
rt-users@lists.bestpractical.com
Message-ID: d1387ed0050428065336de4b3e@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@lists.bestpractical.com
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

End of RT-Users Digest, Vol 13, Issue 100