[rt-users] Ticket_Overlay/Attachment_Overlay->Import for 4.x?

2016-02-09 Thread Curtis Bruneau
Has anyone tried to port the 'Import' methods in the old 3.x Ticket_Overlay.pm, and Attachment_Overlay.pm to RT 4.x? (4.2.x here). I understand the new way to do overlays are to use Ticket_Local.pm or Attachment_Local.pm file names. I'm going to try copying over the methods and dependent

Re: [rt-users] Ticket_Overlay/Attachment_Overlay->Import for 4.x?

2016-02-09 Thread Curtis Bruneau
I noticed the 4.0.x code base has ->Import included in Ticket.pm and Attachment.pm. I'm going to try starting from there but I'm wondering if there's any known technical reasons why these methods may not work in rt 4.2.x Thanks again, Curtis On 2/9/2016 5:10 PM, Curtis Bruneau wrote:

Re: [rt-users] Page Formatting (Only Text) After Perl Update

2011-08-22 Thread Curtis Bruneau
I've encourtered this issue when you try to alias the noauth directories to bypass the mason.handler in the Apache config. If you have an Apache config line similar to below try to comment it out. Alias /NoAuth /opt/rt3/share/html/NoAuth Basically in the above situation the css isn't

Re: [rt-users] Problem with rt-crontool and SendEmail(Re-posted because I did not register before posting it originally)

2010-12-07 Thread Curtis Bruneau
I've used the following to make it transparent, also not updating last update. -action-arg RecordTransaction: 0 --action-arg UpdateLastUpdated: 0 On 10-12-07 11:08 AM, imonike wrote: Hello Kevin, Thanks for your reply. Please how would I do it if I wanted to avoid

Re: [rt-users] Problem with rt-crontool and SendEmail(Re-posted because I did not register before posting it originally)

2010-12-07 Thread Curtis Bruneau
It would appear the action-arg is dependent on the action. I'm not sure if they support the same features. You may need to check out the source for them. Mine was for LinearEscalate. On 10-12-07 11:17 AM, Curtis Bruneau wrote: I've used the following to make it transparent, also not updating

[rt-users] RT-Extension-Mobile Links/Dependencies

2010-09-10 Thread Curtis Bruneau
I was wondering if there was plans to convert the Links/dependent tickets to use the mobile URLs instead. I briefly checked out the code and it's using the main site's elements. It seems like it's a bit of work to convert due to a few files being used. Curtis RT Training in Washington DC,

Re: [rt-users] [Fwd: Re: No mail in the creation of a ticket]

2010-04-28 Thread Curtis Bruneau
You need to either set up a global scrip or single scrip to On Create Notify (type of user) with template (transaction or blank .. which ever). It can be watchers, requester, owner etc. josé fernandez wrote: Thank you for your help. In doing what I want is simply to be notified when a user

Re: [rt-users] Question about using an external SMTP server

2010-04-27 Thread Curtis Bruneau
You should be able to set up postfix using the parameter 'relayhost' for relaying, you can specify a different port if needed. This would allow you to still use the sendmail commands to send. This is assuming you can still receive on port 25 for MX deliveries. Otherwise you may have no choice

Re: [rt-users] Question about using an external SMTP server

2010-04-27 Thread Curtis Bruneau
I reply to the email... any ideas as to why? On Tue, Apr 27, 2010 at 3:37 PM, Curtis Bruneau curt...@vianet.ca mailto:curt...@vianet.ca wrote: You should be able to set up postfix using the parameter 'relayhost' for relaying, you can specify a different port if needed. This would

Re: [rt-users] Question about using an external SMTP server

2010-04-27 Thread Curtis Bruneau
to the SMTP server, or do I really have to go through the entirety of the installation? ...lotsa questions there, sry. On Tue, Apr 27, 2010 at 3:51 PM, Curtis Bruneau curt...@vianet.ca mailto:curt...@vianet.ca wrote: Assuming the SMTPFrom setting isn't overriding the reply addresses

Re: [rt-users] Tickets created with ???? In subject and header fields

2010-02-05 Thread Curtis Bruneau
I suspect it has to do with subject length in the header and encoded characters. Seems to be an exim issue. I've read a few pages describing some fixes. I'd do a search for exim rfc2047 subject Curtis Coco, Alex wrote: I am stumped here, I have emails coming in from users in Asia where the

Re: [rt-users] Upgrade 3.6.5-3.8.7: Duplicate entry '' for key 2

2010-01-26 Thread Curtis Bruneau
This is due to the UTF8 collation recognizing accents as being the same. The old latin collation saw them as unique. There's no real fix other then going utf8_binary but that would make everything case sensitive. Basically latin1 in mysql is CI_AS and utf8 is CI_AI. For me it was the email

[rt-users] Login password save

2009-09-24 Thread Curtis Bruneau
Has anyone ever come across an extension or made a login password saver using cookies? I'm just wondering I had a few users ask about saving their login password. Curtis ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community

Re: [rt-users] _default_ VirtualHost overlap on port 443, the first has precedence

2009-08-21 Thread Curtis Bruneau
Each SSL site pretty much needs to be on it's own IP address, the reasoning is the cert negotiation isn't name based header as apache would. The only other way would be to have them on different ports but then you'd have to specify the port when going to the site. testwreq wreq wrote: * I

Re: [rt-users] Wrong due date output, related to SetToMidnight ?

2009-08-20 Thread Curtis Bruneau
I've had the same issue setting due dates in a scrip, I've done the following to somewhat accurately go back (usual DST issues apply). I imagine there might be cleaner ways. $1 being an ISO format, I'm parsing from the email. I hope that helps. my $duedate =

Re: [rt-users] Wrong due date output, related to SetToMidnight ?

2009-08-20 Thread Curtis Bruneau
Also wanted to note the would probably fail if ran near the end of the day, you may want to specify a specific $time in gmtime($time), localtime($time). Curtis Bruneau wrote: I've had the same issue setting due dates in a scrip, I've done the following to somewhat accurately go back (usual

[rt-users] Set due date from extracted field?

2009-08-06 Thread Curtis Bruneau
Does anyone know if you can set the due date based on a string/field in the e-mail/body. I'm using ExtractCustomFieldValues for custom fields, the functionality would be similar. I know this could be an issue for the queue option (due in x days), ideally it could override that if specified. I

Re: [rt-users] Set due date from extracted field?

2009-08-06 Thread Curtis Bruneau
local time, the web interface seems to do this already. Curtis Kevin Falcone wrote: On Thu, Aug 06, 2009 at 12:00:01PM -0400, Curtis Bruneau wrote: Does anyone know if you can set the due date based on a string/field in the e-mail/body. I'm using ExtractCustomFieldValues for custom fields

Re: [rt-users] Segmentation Fault - RT3.8.4 - Apache2

2009-08-06 Thread Curtis Bruneau
This has been known to occur with some versions of DBD:mysql. I believe the latest versions fix this; I'm currently using 3.0008. raym...@pilotsupplies.com wrote: Hi, ubuntu 9.04 dual Xeon process, 2GB memory. New install RT 3.8.4 with imported RT 3.2.2 database and followed the

Re: [rt-users] completely horked my rt database connection

2009-04-07 Thread Curtis Bruneau
It may have added a line to your my.cnf .. usually in /etc/mysql/my.cnf skip-innodb You will want to #comment that. There may be other settings but that will skip the innodb engine and won't initialize your database. Kimberly McKinnis wrote: Following Jesse’s suggestion to run mysqltuner, I

Re: [rt-users] Hanging Login Page (ModPerl2, HTTPD, Oracle, RHEL5)

2009-04-07 Thread Curtis Bruneau
Seems a lot like the DBD::MySQL bug that many people have had with older versions, basically the children are segfaulting on some timeout bug. During a refresh the parent process is reaping the child and restarting it with a functional process, which is why it appears to take several refreshes

Re: [rt-users] ERROR 1062 during 3.4.5 - 3.8.2 database update

2009-02-19 Thread Curtis Bruneau
I had the same problem and it was caused by accents, since mysql has no accent sensitive collations (_as) aside from utf8_bin which is everything sensitive, I basically just removed the user (or rename) to fix the issue. Since emails generally shouldn't have them it's pretty safe to do, the

Re: [rt-users] Hardware Config

2009-01-16 Thread Curtis Bruneau
Jesse Vincent wrote: I agree completely with the above, but more important to me than just RAM and processing power is the speed of disk access. He mentioned using RAID 5 in a follow-up post. That's fine, but are these IDE or 15k SCSI drives? Faster drives should always speed up database

Re: [rt-users] Hardware Config

2009-01-16 Thread Curtis Bruneau
I'm currently running a roughly 8GB database on 2gb of ram (quad core xeon 2.4), webserver and db on the same machine. The indexes sit just over a 1GB and I have 768MB on the pool, iowait is very low and the index hit rate is high. The shredder indexes account for a large portion of it so it

Re: [rt-users] how to disable fckeditor globally?

2009-01-15 Thread Curtis Bruneau
in your etc/RT_SiteConfig.pm Set($MessageBoxRichText, 0); slamp slamp wrote: is there a way to do this? i have not been able to find it. ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help:

[rt-users] sendmail memory allocation.

2009-01-07 Thread Curtis Bruneau
Has anyone ever come across the following error? It seemed to have happened randomly, I had to shutdown apache since it was stuck in this state for sending mails. I'm using apache2 and fastcgi, I'm guessing something broke once and due to the constant running it affected everything else. I

Re: [rt-users] User_Overlay.pm line 1530 - Warning Message

2008-12-10 Thread Curtis Bruneau
That's your typical perl warning for using undef values, in a condition check or whatever. There's ways to get around them while coding by checking defined first but you can basically ignore them. Duane Hill wrote: I have a new RT v3.8.1 I'm setting up on FreeBSD 7.0. I'm seeing a number of

Re: [rt-users] Custom Fields Issue in RT 3.6.6

2008-11-17 Thread Curtis Bruneau
I'm not sure if it's like 3.8.x but there's a checkbox to include disabled custom fields. Curtis Jonathan Jeppson wrote: All, I created a new custom field and unchecked the enable box to disable it and now I can not see the custom field in the UI. Also, I don't know if it is related to

Re: [rt-users] search case sensitiv

2008-11-14 Thread Curtis Bruneau
I'm guessing you are using utf8_bin collation, the others are case insensitive. Unfortunately non binary utf8 ones aren't accent sensitive so it lacks a bit compared to latin1 which offers both. If accents aren't a major concern you should be using like utf8_unicode_ci or utf8_general_ci or

Re: [rt-users] Login screen after each click

2008-11-12 Thread Curtis Bruneau
I would suggest checking the mailing list archives, I believe it's related to Apache::Session (assuming you aren't using an external auth) .. it works for me so I'm not sure the issue, also make sure you have cookies enabled. Kobus Bensch - No Sig wrote: Hi Hopefully one last issue from me.

Re: [rt-users] AssetTracker crashes loading asset

2008-11-07 Thread Curtis Bruneau
Sounds exactly like the issue I have, I think something is trying to get all those records, I tried to trace it but with no luck, I think it may be related to the back/next links on the ticket display page. It's checking each record for something, This is ok with small results but crashes with

Re: [rt-users] AssetTracker crashes loading asset

2008-11-07 Thread Curtis Bruneau
? is there a seperate control for syslogging in AT? On Fri, 7 Nov 2008, Curtis Bruneau wrote: Date: Fri, 07 Nov 2008 10:43:48 -0500 From: Curtis Bruneau [EMAIL PROTECTED] To: John [EMAIL PROTECTED], rt-users@lists.bestpractical.com Subject: Re: [rt-users] AssetTracker crashes loading asset Sounds

Re: [rt-users] AssetTracker crashes loading asset

2008-11-07 Thread Curtis Bruneau
this problem in rt 3.4.5 with at 1.2.3.. On Fri, 7 Nov 2008, Curtis Bruneau wrote: Date: Fri, 07 Nov 2008 12:52:04 -0500 From: Curtis Bruneau [EMAIL PROTECTED] To: John [EMAIL PROTECTED], rt-users@lists.bestpractical.com Subject: Re: [rt-users] AssetTracker crashes loading asset

Re: [rt-users] AssetTracker crashes loading asset

2008-11-07 Thread Curtis Bruneau
to assettracker...i think... On Fri, 7 Nov 2008, Curtis Bruneau wrote: Date: Fri, 07 Nov 2008 13:12:53 -0500 From: Curtis Bruneau [EMAIL PROTECTED] To: John [EMAIL PROTECTED], rt-users@lists.bestpractical.com Subject: Re: [rt-users] AssetTracker crashes loading asset While my issue

Re: [rt-users] DBD::mysql::st execute failed: MySQL server has gone away at

2008-10-24 Thread Curtis Bruneau
Sounds like the oom-killer is getting mysql. How much memory is on your db server? Is it configured in such a way that when the innodb pool is full it's not running out of memory? You shouldn't really have an issue with this unless you have a large amount of tickets. Might want to check some

Re: [rt-users] DBD::mysql::st execute failed: MySQL server has goneaway at

2008-10-24 Thread Curtis Bruneau
: Fri, 24 Oct 2008 21:01:27 To: Curtis Bruneau[EMAIL PROTECTED] Cc: rt-users@lists.bestpractical.com Subject: Re: [rt-users] DBD::mysql::st execute failed: MySQL server has gone away at Hi 2GB on rt/db server. I will have to look at the innodb settings, not changed these before so

Re: [rt-users] Continuous 500 errors

2008-10-10 Thread Curtis Bruneau
Running out of memory perhaps? I'll occationally get these if my search results are too big and you try to display a ticket (I get some odd bug where it tries to get every result of a search into memory on a single ticket display). It's really hard to say what though.. SIGSEGV 11

Re: [rt-users] reall odd apache2 crashes with blank pages

2008-10-08 Thread Curtis Bruneau
I think it's just a bug in DBD:mysql, I had the same issue and it's a well documented problem. I can't see why SSL would have any effect, it's just a protocol not a driver. Gabriel Cadieux wrote: after disabling SSL and downgrading DBD::mysql to 4.00.5 (from the buggy 4.00.7), i am happy to

Re: [rt-users] reall odd apache2 crashes with blank pages

2008-10-08 Thread Curtis Bruneau
- From: Curtis Bruneau [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 08, 2008 9:45 AM To: Gabriel Cadieux; rt-users@lists.bestpractical.com Subject: Re: [rt-users] reall odd apache2 crashes with blank pages I think it's just a bug in DBD:mysql, I had the same issue and it's a well documented

Re: [rt-users] Event Cal Extension?

2008-09-22 Thread Curtis Bruneau
Ah ok, I was under the impression that it was integrated into 3.8.x but it appears just the iCal aspect of it. I'll have to try it out, it looks like it was updated for 3.8.x compatibility. Emmanuel Lacour wrote: On Fri, Sep 19, 2008 at 10:26:49AM -0400, Curtis Bruneau wrote: I'm not sure

[rt-users] Event Cal Extension?

2008-09-19 Thread Curtis Bruneau
I'm not sure if this is the right place to ask... I'm currently using RT 3.8.1 and I was wondering if there is an extension to do very basic calendering, ideally the display would be built into RT instead of relying on an external iCal. Some of our service techs want to make a basic event

Re: [rt-users] Performance problems with 3.8.1

2008-09-17 Thread Curtis Bruneau
For FastCGI, I changed my configuration to allow multiple processes so other requests aren't getting queued up when big queries are hitting the server. Without this setting the site was pretty slow to respond but once the request got in it was fast. I've also changed the default idle timeout

Re: [rt-users] Can't Restart Apache2 on fresh install of Ubuntu 8.04 and RT 3.8.1

2008-09-12 Thread Curtis Bruneau
Looks like mod_perl2 isn't installed. Curtis Chris Nelson wrote: I have been running a fresh install of RT 3.8.1 on Ubuntu 8.04. I've made it successfully to the configuring of Apache2. I added this to /etc/apache2/sites-enabled/000-default #==Begin Added by CN for RT

Re: [rt-users] Errors on installing RT 3.8.1

2008-09-12 Thread Curtis Bruneau
You can check what the server is running by using telnet on port 80. telnet localhost 80 HEAD / HTTP 1.0 It should respond with the server header and installed modules (usually). In most apache/mod_perl installs it should be working as is. The files to load it are in

Re: [rt-users] Errors on installing RT 3.8.1

2008-09-12 Thread Curtis Bruneau
to do with my virtual hosts then. btw i did try to install libapache2-mod-perl2 but said it was already installed. going to try with fastcgi and see how i go thanks for your help! On Fri, 2008-09-12 at 14:44 +0100, Curtis Bruneau wrote: You can check what the server is running

Re: [rt-users] [Rt-devel] Customized logo top left corner

2008-09-12 Thread Curtis Bruneau
copy /opt/rt3/share/html/NoAuth/css/web2/layout.css to /opt/rt3/local/html/NoAuth/css/web2 (assuming you are using the web2 layout).. modify the div#logo area and remove the display: none; you may have to force the display, not sure exactly I haven't tried changing it. div#logo a {

Re: [rt-users] Issues on RT 3.8.1

2008-09-11 Thread Curtis Bruneau
Basically you need to make a database called 'test' which is somewhat standard for mysql installations, these scripts will run a series of tests like creating tables and trying different kinds of queries, it wouldn't be a good idea to try it on a production database. Make sure the user has

Re: [rt-users] (no subject)

2008-08-26 Thread Curtis Bruneau
Basically looks like you need a VirtualHost entry with your outside IP address. Since the default site is using a wildcard you can't on your secondary site, You could remove default and have the following with ServerName blah ServerAlias blah2 etc .. something along these lines .. but

Re: [rt-users] No permission notify

2008-08-21 Thread Curtis Bruneau
? Curtis Kenneth Crocker wrote: Curtis, Try removing those permissions from EVERYONE and UNPRIVILEGED to PRIVILEGED only. Hope this helps. Kenn LBNL On 8/20/2008 10:48 AM, Curtis Bruneau wrote: Is there any way to not notify the sender when they don't have permission? I don't mind

Re: [rt-users] No permission notify

2008-08-21 Thread Curtis Bruneau
users get automatically created as 'unprivileged' users. That's what we do and it works fine. Kenn LBNL On 8/21/2008 7:04 AM, Curtis Bruneau wrote: That's how my private queues are set up, but that doesn't prevent spammers from trying every possible email address on my server, when they do

Re: [rt-users] No permission notify

2008-08-21 Thread Curtis Bruneau
users get automatically created as 'unprivileged' users. That's what we do and it works fine. Kenn LBNL On 8/21/2008 7:04 AM, Curtis Bruneau wrote: That's how my private queues are set up, but that doesn't prevent spammers from trying every possible email address on my server, when they do

[rt-users] No permission notify

2008-08-20 Thread Curtis Bruneau
Is there any way to not notify the sender when they don't have permission? I don't mind the root@ notification but spammers just hammer all our queues and the closed ones don't have a spam filter on it .. so it causes tons of backscatter (spoofed sender returns spam). All our public queues are

Re: [rt-users] rt-shredder cli

2008-08-18 Thread Curtis Bruneau
Alfred M. Szmidt wrote: Hi! How on earth does one use the rt-shredder utility? There is an example: | rt-shredder --plugin 'Tickets=status,deleted;queue,general' But according to `rt-shredder --plugin help-Tickets', queue, status have been dropped infavour of queue: | Arguments

[rt-users] Default status' for queue lists.

2008-08-15 Thread Curtis Bruneau
In the Quick Search queue listing on RT at a Glance is there a way to change the default status' that is searched? It individually shows new/open/stalled and the queue link itself has all three.. I would like to exclude stalled from the main link. I know I could achieve this editing files but

[rt-users] Missing directory in configuration link.

2008-08-14 Thread Curtis Bruneau
The links in the content area are missing /CustomFields when you navigate from the top menu in Configuration Global Custom Fields. The top menu final link is ok just the ones in the content area. MENU: /Admin/Global/CustomFields/Users.html CONTENT: /Admin/Global/Users.html This appears to be

Re: [rt-users] Missing directory in configuration link.

2008-08-14 Thread Curtis Bruneau
Kevin Falcone wrote: On Aug 14, 2008, at 1:46 PM, Curtis Bruneau wrote: The links in the content area are missing /CustomFields when you navigate from the top menu in Configuration Global Custom Fields. The top menu final link is ok just the ones in the content area. MENU: /Admin

Re: [rt-users] Missing directory in configuration link.

2008-08-14 Thread Curtis Bruneau
Curtis Bruneau wrote: Kevin Falcone wrote: On Aug 14, 2008, at 1:46 PM, Curtis Bruneau wrote: The links in the content area are missing /CustomFields when you navigate from the top menu in Configuration Global Custom Fields. The top menu final link is ok just the ones

Re: [rt-users] RT 3.8 New Installation, migrating existing 3.6 database

2008-08-14 Thread Curtis Bruneau
Helmuth Ramirez wrote: Hi everyone, I just installed a fresh copy of 3.8 (new server). It is up and running. I want to use the data in my existing 3.6.3 db on it. I dumped and copied my db over to the new server, I restored it. Good so far. I now want to update it to make sure its 3.8

[rt-users] shrink_cgm_table

2008-08-11 Thread Curtis Bruneau
I have a quick question regarding shrink_cgm_table.pl The 'extra' records it deletes, will the system now take these into account in 3.8.x in regards to deletes/etc? Basically does shrink_cgm_table.pl only have to be ran once since RT will now take care of the extra? Also regarding shredder,

Re: [rt-users] Rt at Glance and upgrade from 3.2.1 to 3.8.0

2008-08-08 Thread Curtis Bruneau
d tbsky wrote: 2008/8/8 Jean-Michel Barbet [EMAIL PROTECTED]: d tbsky wrote: hi: it is a little fix.almost the same as 3.8.0. and utf8 fix is what we need. so i don't need to tune mysql utf8 parameter. After looking at the way the mysql update procedure works, I believe it

Re: [rt-users] Rt at Glance and upgrade from 3.2.1 to 3.8.0

2008-08-08 Thread Curtis Bruneau
Curtis Bruneau wrote: d tbsky wrote: 2008/8/8 Jean-Michel Barbet [EMAIL PROTECTED]: d tbsky wrote: hi: it is a little fix.almost the same as 3.8.0. and utf8 fix is what we need. so i don't need to tune mysql utf8 parameter. After looking

[rt-users] utf8 and accents.

2008-08-08 Thread Curtis Bruneau
I need some suggestions, I have come to the conclusion that all utf8 collations don't do french properly, not like latin1 anyway. All accents are seen as the same, while binary distinct they cannot be unique indexed and sorting will recognize them as the same as well as queries using any

Re: [rt-users] utf8 and accents.

2008-08-08 Thread Curtis Bruneau
Ruslan Zakirov wrote: On Sat, Aug 9, 2008 at 12:20 AM, Curtis Bruneau [EMAIL PROTECTED] wrote: I need some suggestions, I have come to the conclusion that all utf8 collations don't do french properly, not like latin1 anyway. All accents are seen as the same, while binary distinct

Re: [rt-users] RT-Users Digest, Vol 53, Issue 18

2008-08-07 Thread Curtis Bruneau
Date: Thu, 07 Aug 2008 16:50:47 +0200 From: Jean-Michel Barbet [EMAIL PROTECTED] Subject: Re: [rt-users] Rt at Glance and upgrade from 3.2.1 to 3.8.0 To: d tbsky [EMAIL PROTECTED] Cc: rt-users@lists.bestpractical.com Message-ID: [EMAIL PROTECTED] Content-Type: text/plain;

[rt-users] Shredder Indexes

2008-08-01 Thread Curtis Bruneau
I'm just curious if the Indexes recommended by the old RTx-Shredder-0.07 documentation are still recommended, I would assume yes unless the queries have changed. I know a few were added to the default schema, but there's a couple others. I'm just wondering since the indexes can be rather large

[rt-users] ScripActions

2008-07-31 Thread Curtis Bruneau
I'm trying to upgrade our RT instance. I was going through the etc/initialdata and I noticed the 'Extract Subject Tag' action for lib/RT/Action/ExtractSubjectTag.pm wasn't in the upgrade scripts for ScripActions, also the related Scrip On transaction, add any tags in the transaction's subject

Re: [rt-users] Shrink CGM Table option?

2008-07-30 Thread Curtis Bruneau
I just tried the mentioned patch, it works much nicer, it uses around 165-220mb. Curtis. Ruslan Zakirov wrote: Try attached patch. On Tue, Jul 29, 2008 at 5:50 PM, Curtis Bruneau [EMAIL PROTECTED] wrote: Is there any way to get etc/upgrade/shrink_cgm_table.pl to do it's thing in pieces

[rt-users] Shrink CGM Table option?

2008-07-29 Thread Curtis Bruneau
Is there any way to get etc/upgrade/shrink_cgm_table.pl to do it's thing in pieces? I believe we have many rows in the cgm table and it's causing perl to take up to 2gb of memory eventually causing oom to invoke killing mysql or simply just crashing before it can. Thanks for your time, Curtis

[rt-users] DB upgrade from 3.4.4 to 3.8.0.

2008-07-24 Thread Curtis Bruneau
I'm having an issue with the mysql 4.0 - 4.1 conversion, the script performs ok (i had to update my DBD::mysql) it generates the proper SQL, I went a step further and merged each tables ALTER into two commands (before-after) so our bigger tables didn't have to dump more then it needs to (very

Re: [rt-users] DB upgrade from 3.4.4 to 3.8.0.

2008-07-24 Thread Curtis Bruneau
Curtis Bruneau wrote: I'm having an issue with the mysql 4.0 - 4.1 conversion, the script performs ok (i had to update my DBD::mysql) it generates the proper SQL, I went a step further and merged each tables ALTER into two commands (before-after) so our bigger tables didn't have to dump

Re: [rt-users] DB upgrade from 3.4.4 to 3.8.0.

2008-07-24 Thread Curtis Bruneau
Curtis Bruneau wrote: Curtis Bruneau wrote: I'm having an issue with the mysql 4.0 - 4.1 conversion, the script performs ok (i had to update my DBD::mysql) it generates the proper SQL, I went a step further and merged each tables ALTER into two commands (before-after) so our bigger tables

Re: [rt-users] Problematic Search/Display Query

2008-07-18 Thread Curtis Bruneau
from source. make testdeps comes back fine, I attempted to upgrade to the latest versions for modules that could be related to the db/query. The module versions are also attached. Thanks Curtis Bruneau wrote: Greetings everyone, We're having an issue with several versions of RT that are all

Re: [rt-users] Problematic Search/Display Query

2008-07-18 Thread Curtis Bruneau
1 245 Query SELECT * FROM Users WHERE id = '12' Does anyone have any idea how to fix this? Is this suppose to happen? Any kind of confirmation would be great. Curtis Curtis Bruneau wrote: Just an update, I have reinstalled the machine in attempt to solve this problem, I am using etch

[rt-users] 3.8.0 Install

2008-07-16 Thread Curtis Bruneau
Is there a way to explicitly turn off the standalone server during install/compile? the previous versions didn't force it. I'm trying to stay away from the extra perl modules as I don't believe I'll be using it at all. I've tried various configure switches but it doesn't appear to be

[rt-users] Search-Display Oddity

2008-05-27 Thread Curtis Bruneau
I'm not sure if this a common issue, from RT sites I have tried it seems to have similar symptoms. Basically this is what happens, when you do a search regardless of what criteria the Ticket/Display.html page attempts do to a limitless query based on the same criteria, effectively loading