Possible startup optimization?

RT Users
1

Jesse – you asked what sort of startup optimizations might be included –
I don’t know if you’re doing this now, but what about initializing a
persistent database connection within the webmux.pl script?

i.e. include something like:

warm up the database connection

$DS::DBI::CONNECT = “dbi:Pg:dbname=web”;
Apache::DBI->connect_on_init($DS::DBI::CONNECT);

Ignore if this is already being done.

Dave

David C. Troy [dave@toad.net] 410-544-6193 Sales
ToadNet - Want to go fast? 410-544-1329 FAX
570 Ritchie Highway, Severna Park, MD 21146-2925 www.toad.net

2

Apache::DBI should take care of this transparently for us.On Fri, Aug 24, 2001 at 01:12:47PM -0400, David C. Troy wrote:

Jesse – you asked what sort of startup optimizations might be included –
I don’t know if you’re doing this now, but what about initializing a
persistent database connection within the webmux.pl script?

i.e. include something like:

warm up the database connection

$DS::DBI::CONNECT = “dbi:Pg:dbname=web”;
Apache::DBI->connect_on_init($DS::DBI::CONNECT);

Ignore if this is already being done.

Dave

=====================================================================
David C. Troy [dave@toad.net] 410-544-6193 Sales
ToadNet - Want to go fast? 410-544-1329 FAX
570 Ritchie Highway, Severna Park, MD 21146-2925 www.toad.net

rt-users mailing list
rt-users@lists.fsck.com
http://lists.fsck.com/mailman/listinfo/rt-users

http://www.bestpractical.com/products/rt – Trouble Ticketing. Free.

3

Hi another rt2 to rt1 differnace or a missunderstanding on my part

When we get new tickets we have somone assign them to owners
but need an email sent to the owener saying this has been given to you ?

I can’t see how this is done I can see how to do it on status change or all
transactions
but not on owner change

Eg I want to send an email ticket xxx has been assgined to you by admin

Regards

4

Craig,

I was stumped by this one, too. I ended up finding a solution in the
list archives.

http://lists.fsck.com/pipermail/rt-devel/2001-June/001433.html

I use a slightly modified version of the OwnerChange template that
picks up the correct name for the rt name.

Our template is:

The previous owner of the following ticket:
Request: [{$RT::rtname} #{$Ticket->id}]
Request Subject: {$Ticket->Subject}

Has named you as the new owner of this ticket.

Click on the following link to view the full history.
<URL: {$RT::WebURL}/Ticket/Display.html?id={$Ticket->id} >

Hope that helps.
TravisOn Sat, Aug 25, 2001 at 02:05:37PM +1200, Craig St George wrote:

Hi another rt2 to rt1 differnace or a missunderstanding on my part

When we get new tickets we have somone assign them to owners
but need an email sent to the owener saying this has been given to you ?

I can’t see how this is done I can see how to do it on status change or all
transactions
but not on owner change

Eg I want to send an email ticket xxx has been assgined to you by admin

Regards

rt-users mailing list
rt-users@lists.fsck.com
http://lists.fsck.com/mailman/listinfo/rt-users

Travis Campbell - Unix Systems Administrator = travis@beast.amd.com
5900 E. Ben White Blvd, Austin, TX 78741 = travis.campbell@amd.com
TEL: (512) 602-1888 PAG: (512) 604-0341 = webmaster@beast.amd.com
“Does anything work as expected?” Yes. An axe through the CPU.