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

[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 meth

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 processed

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 no

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 clutte

[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, USA

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 cre

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

2010-04-27 Thread Curtis Bruneau
my rt-mailgate from my bin dir on the rt server 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 <mailto:curt...@vianet.ca>> wrote: Assuming the SMTPFrom settin

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

2010-04-27 Thread Curtis Bruneau
//rt.##.com"; (obviously w/o the # signs...) but nothing seems to happen when I reply to the email... any ideas as to why? On Tue, Apr 27, 2010 at 3:37 PM, Curtis Bruneau <mailto:curt...@vianet.ca>> wrote: You should be able to set up postfix using the parameter '

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 b

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

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 he

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 h

Re: [rt-users] mod_fastcgi problems

2009-08-20 Thread Curtis Bruneau
According to the fastcgi docs it's a server config directive (FastCgiIpcDir). I've set it in my module config file. It's saying the FastCgiServer can be server or virtual host in context but i'm doing it here for simplicity as it's the only site on my server. cat /etc/apache2/mods-available/fas

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 accuratel

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 = RT::Date->new($RT::SystemUser

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 > READM

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

2009-08-06 Thread Curtis Bruneau
o reflect 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 Ex

[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] 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
Just realised you are using Oracle, but the bug seems almost identical. Curtis Bruneau wrote: > 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 re

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 old

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 cac

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

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: http://wiki.bestpract

[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 doub

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

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 swe

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 m

Re: [rt-users] EX_TEMPFAIL Error

2008-11-12 Thread Curtis Bruneau
The url in the command needs to be valid and accessible from the local interface, dns and all. If your hostname is pointing to 127.0.0.1 from the local machine you'll have to add that IP to the apache configuration or remove the hostname pointing to localhost in /etc/hosts .. Personally I have

Re: [rt-users] AssetTracker crashes loading asset

2008-11-07 Thread Curtis Bruneau
7;); as a solution? > > this seems isolated 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.

Re: [rt-users] AssetTracker crashes loading asset

2008-11-07 Thread Curtis Bruneau
er had 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.bes

Re: [rt-users] AssetTracker crashes loading asset

2008-11-07 Thread Curtis Bruneau
s be a syslog issue like in RT? 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]>,

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] spam button

2008-10-31 Thread Curtis Bruneau
Michael Grant wrote: > Does anyone have any code I could copy/paste that creates a spam > button which lets me delete the spam and then runs it through > spamassassin -r to train spamassassin? At the moment, I have to view > the original message with the full headers and copy/pasting it into > spa

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

2008-10-24 Thread Curtis Bruneau
gt;> >> -Original Message- >> From: Kobus Bensch - No Sig <[EMAIL PROTECTED]> >> >> Date: Fri, 24 Oct 2008 21:01:27 >> To: Curtis Bruneau<[EMAIL PROTECTED]> >> Cc: >> Subject: Re: [rt-users] DBD::mysql::st execute failed: MySQL server

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 of

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 Cor

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

2008-10-08 Thread Curtis Bruneau
turned on. > > -gabe > > -Original Message- > 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 > &

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] 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: >

[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 sched

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 to

Re: [rt-users] Overnight segfault since RT 3.8.1 upgrade

2008-09-15 Thread Curtis Bruneau
When I had this problem it was a bug in DBD:mysql 4.007. I'm not sure the exact details but it only happend on low traffic sites, my guess is the connection pool times out when it shouldn't causing the http server to fail on the first try and then working again once the proccesses reconnect. Se

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 { displa

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

2008-09-12 Thread Curtis Bruneau
that mod_perl/fastcgi hasnt been > installed. same as before. > > so i guess it's got nothing 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 > >

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 /etc/apache2/mods-enabled/p

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 Install

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 righ

Re: [rt-users] (no subject)

2008-08-26 Thread Curtis Bruneau
Basically looks like you need a 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 basically your apach

Re: [rt-users] No permission notify

2008-08-21 Thread Curtis Bruneau
t 'privileged' to) users that pass authentication and all email > 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 h

Re: [rt-users] No permission notify

2008-08-21 Thread Curtis Bruneau
t 'privileged' to) users that pass authentication and all email > 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 h

Re: [rt-users] No permission notify

2008-08-21 Thread Curtis Bruneau
privileged? 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

[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 c

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

2008-08-18 Thread CURTIS BRUNEAU
Curtis Bruneau writes: > Ole Craig wrote: >> Curtis - >> I don't think there's a config option for this; it's hardcoded into >> the Quicksearch element. I needed to do something similar, but in my >> case, it was *adding* some statuses to the quicks

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

2008-08-18 Thread Curtis Bruneau
mt') }, > + {cond => "Status = 'pendres'", name => loc ('pendres') }, > {cond => "Status = 'stalled'", name => loc ('stalled') }] &> > > > > > > - >

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: > > | Argumen

Re: [rt-users] make initialize-database error

2008-08-15 Thread Curtis Bruneau
Chaim Rieger wrote: > Jerrad Pierce wrote: > >> Was your MySQL maybe *built* without InnoDB? >> >> -- >> Cambridge Energy Alliance: Save money & the planet >> > > i installed the binary, > > if it was built without innodb support it wouldnt start up with the > current my.cnf > If you d

[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 j

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

2008-08-14 Thread Curtis Bruneau
Helmuth Ramirez wrote: > Thanks Curtis, unfortunately I am still getting the same message. I > tried running it from my installed location: > > "/opt/rt3/sbin/rt-setup-database --dba root --prompt-for-dba-password > --action upgrade" > > As well as from the rt-3.8.0 folders I used to make the inst

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.

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

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

[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 b

[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, i

Re: [rt-users] utf8 and accents.

2008-08-11 Thread Curtis Bruneau
Curtis Bruneau wrote: > 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

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

[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 varian

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

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

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; chars

[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_t

[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 _

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 >

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 t

[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] Problematic Search/Display Query

2008-07-18 Thread Curtis Bruneau
7;RT::System' AND ACL.ObjectId = 1) OR (ACL.ObjectType = 'RT::Queue' AND ACL.ObjectId = 1) OR (ACL.ObjectType = 'RT::Ticket' AND ACL.ObjectId = 2)) LIMIT 1 245 Query SELECT * FROM Users WHERE id = '12' Does anyone have any idea how to fix this? Is thi

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

2008-07-18 Thread Curtis Bruneau
ably met the version requirements, the others were done 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

[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 possib

[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 poten