Re: [rt-users] Lowercasing of message headers
On 9.10.2012 18:38, Thomas Sibley wrote: > It's possible, yes. I don't know where it may be happening in this > particular case, and it may not even be in RT. Mail headers, however, > are case insensitive, so any change in case shouldn't be affecting your > usage. (And if it is, that sounds like a bug somewhere.) Hi Thomas, you are right... The lowercasing does not seem to be a problem. Right now it seems that the problem is much more devious - RT not executing the prepare action for a scrip. On my devel machine it was happening about half the time (the action is stored in a separate file), but it stopped after the restart (I was altering the file before the restart, though). I have added some debug code and restarted the production machine and will be monitoring it further... Martin Final RT training for 2012 in Atlanta, GA - October 23 & 24 http://bestpractical.com/training We're hiring! http://bestpractical.com/jobs
[rt-users] RT 4.0.X and LimeSurvey 2.X
Hi, I was wondering if anyone has gotten LimeSurvey and RT to work at generating surveys? I haven't tried yet, I am currently working at getting it up with 1.9. Thanks! Tom Final RT training for 2012 in Atlanta, GA - October 23 & 24 http://bestpractical.com/training We're hiring! http://bestpractical.com/jobs
[rt-users] Large Attachments Table
Dears; I have been face with a problem... after 3 years, out attachments table has been grown over 300GB in size and it's about 15 Million of records. for performance tuning I Ihad changes it's Table Engine into InnoDB and configured MySQL as file_peer_table with Dynamic Row format to bring out the BLOB data out of the caching space and reduction it's response time. but I have always a question in my mine! why RT is storing this much attached objects in BLOG fields? why it dose not use a separate file system to store file on and just table it links ( or auto generated name ) on DB? in such a way, we will have some better ways to backup this much files... -- features like snapshots on ZFS -- Regards, Ali R. Taleghani Final RT training for 2012 in Atlanta, GA - October 23 & 24 http://bestpractical.com/training We're hiring! http://bestpractical.com/jobs
Re: [rt-users] Large Attachments Table
On Wed, Oct 10, 2012 at 10:36:22PM +0330, shayne.al...@gmail.com wrote: > Dears; > > I have been face with a problem... after 3 years, out attachments table has > been grown over 300GB in size and it's about 15 Million of records. > for performance tuning I Ihad changes it's Table Engine into InnoDB and > configured MySQL as file_peer_table with Dynamic Row format to bring out > the BLOB data out of the caching space and reduction it's response time. > > but I have always a question in my mine! why RT is storing this much > attached objects in BLOG fields? > why it dose not use a separate file system to store file on and just table > it links ( or auto generated name ) on DB? > in such a way, we will have some better ways to backup this much files... > -- features like snapshots on ZFS > > -- > Regards, > Ali R. Taleghani Hi Ali, You can check the archives. There actually was a branch developed by Best Practical that moved the attachments into the filesystem. I believe the customer was motivated by performance needs. Certainly, keeping all of the information is a single DB is vastly easier to manage consistently. Once you get to the size of the DB that you are reaching, care and handling is a much different beast whether or not the data is in the DB or on a tied filesystem. You are certainly an inspiration using MySQL as the backend for an instance that large. Regards, Ken Final RT training for 2012 in Atlanta, GA - October 23 & 24 http://bestpractical.com/training We're hiring! http://bestpractical.com/jobs
Re: [rt-users] RT 4.0.X and LimeSurvey 2.X
Haven't started working with LimeSurvey 2.x yet -- although it's on my radar -- but we do have our RT 4.0.7 working with Lime 1.9's remote control features to generate customer evaluation surveys on ticket resolution (using the steps outlined in the RT wiki). Looking through the Lime 2 release notes, I didn't immediately see anything that'd make me expect that integration to break after upgrading, but of course the devil's in the details... -- MarkR From: rt-users-boun...@lists.bestpractical.com [mailto:rt-users-boun...@lists.bestpractical.com] On Behalf Of Thomas Misilo Sent: Wednesday, October 10, 2012 2:05 PM To: rt-users@lists.bestpractical.com Subject: [rt-users] RT 4.0.X and LimeSurvey 2.X Hi, I was wondering if anyone has gotten LimeSurvey and RT to work at generating surveys? I haven't tried yet, I am currently working at getting it up with 1.9. Thanks! Tom Final RT training for 2012 in Atlanta, GA - October 23 & 24 http://bestpractical.com/training We're hiring! http://bestpractical.com/jobs
Re: [rt-users] Large Attachments Table
Ali, Other than modifying RT itself to store attachments outside of the main database, you could also try InnoDB compression first. It is available in all recent MySQL versions (5.1, 5.5, 5.6) and it is completely transparent to queries or applications. Even with some number of larger attachments, there is always still a lot of plain text in this table (e-mails, comments), i.e. all the kind of data that should compress very well. You might be able to reduce the physical table size by 50% or even more this way (the compression level is actually tunable to some extent, at the expense of performance of course). Best regards, Maciek MySQL Consulting Services PSCE | http://www.psce.com/ Final RT training for 2012 in Atlanta, GA - October 23 & 24 http://bestpractical.com/training We're hiring! http://bestpractical.com/jobs
Re: [rt-users] Add to all emails a link to the ticket.
Juanjillo, You can create or update a template to have the ticket link in it. Kenn On Sat, Oct 6, 2012 at 3:51 PM, Juanjo wrote: > Any help? > El 01/10/2012 17:02, "Juanjo" escribió: > > Hi to all. >> >> When we create or assign a ticket the email that the user receive have a >> link to the ticket. >> But one response with email about the ticket make the user connecto to >> see it on the rt system. >> >> Coud i attach a link to the ticket in every email sended? >> >> Thanks >> Regards, >> >> -- >> Un saludo. >> Juanjo Corral >> > > > > Final RT training for 2012 in Atlanta, GA - October 23 & 24 > http://bestpractical.com/training > > We're hiring! http://bestpractical.com/jobs > > Final RT training for 2012 in Atlanta, GA - October 23 & 24 http://bestpractical.com/training We're hiring! http://bestpractical.com/jobs
Re: [rt-users] Large Attachments Table
Dear Ke; due the type if our attachments which are JPEG files, don't hope compression to help me more! but I serious to test it ASAP. it seems pretty to be able to compress Emails body on side DB engine. :-) On Wed, Oct 10, 2012 at 10:54 PM, k...@rice.edu wrote: > On Wed, Oct 10, 2012 at 10:36:22PM +0330, shayne.al...@gmail.com wrote: > > Dears; > > > > I have been face with a problem... after 3 years, out attachments table > has > > been grown over 300GB in size and it's about 15 Million of records. > > for performance tuning I Ihad changes it's Table Engine into InnoDB and > > configured MySQL as file_peer_table with Dynamic Row format to bring out > > the BLOB data out of the caching space and reduction it's response time. > > > > but I have always a question in my mine! why RT is storing this much > > attached objects in BLOG fields? > > why it dose not use a separate file system to store file on and just > table > > it links ( or auto generated name ) on DB? > > in such a way, we will have some better ways to backup this much files... > > -- features like snapshots on ZFS > > > > -- > > Regards, > > Ali R. Taleghani > > Hi Ali, > > You can check the archives. There actually was a branch developed by > Best Practical that moved the attachments into the filesystem. I believe > the customer was motivated by performance needs. Certainly, keeping all > of the information is a single DB is vastly easier to manage consistently. > Once you get to the size of the DB that you are reaching, care and handling > is a much different beast whether or not the data is in the DB or on a tied > filesystem. You are certainly an inspiration using MySQL as the backend for > an instance that large. > > Regards, > Ken > -- Regards, Ali R. Taleghani Final RT training for 2012 in Atlanta, GA - October 23 & 24 http://bestpractical.com/training We're hiring! http://bestpractical.com/jobs
Re: [rt-users] Large Attachments Table
Dear Ken; I will like that branch... and hope it to an alive branch :-/ tnx Dear Maciek; :-) due the type if our attachments which are JPEG files, don't hope compression to help me more! but I serious to test it ASAP. it seems pretty to be able to compress Emails body on side DB engine. tnx On Wed, Oct 10, 2012 at 11:13 PM, Maciej Dobrzanski < reg.bestpracti...@posterus.com> wrote: > Ali, > > * * > > Other than modifying RT itself to store attachments outside of the main > database, you could also try InnoDB compression first. It is available in > all recent MySQL versions (5.1, 5.5, 5.6) and it is completely transparent > to queries or applications. Even with some number of larger attachments, > there is always still a lot of plain text in this table (e-mails, > comments), i.e. all the kind of data that should compress very well. You > might be able to reduce the physical table size by 50% or even more this > way (the compression level is actually tunable to some extent, at the > expense of performance of course). > > ** ** > > Best regards, > > Maciek > > ** ** > > MySQL Consulting Services > > PSCE | http://www.psce.com/ > > > > Final RT training for 2012 in Atlanta, GA - October 23 & 24 > http://bestpractical.com/training > > We're hiring! http://bestpractical.com/jobs > > -- Regards, Ali R. Taleghani Final RT training for 2012 in Atlanta, GA - October 23 & 24 http://bestpractical.com/training We're hiring! http://bestpractical.com/jobs
[rt-users] Weekly tickets report by cron
Hi everyone. I'm looking for some way to create something like weekly digest for my clients, to send them every friday one email with all tickets that are waiting for their answer. I was looking at rt-crontool but it will require a lot of walkarounds to gather all tickets together. Maybe there is some way to generate report by cron (as it can be done from web-interface)? Thank you in advance for any solution. -- Jack Zabolotnyi Arces Network, LLC e: jzabolot...@arces.net w: http://www.arces.net PGP key: 2048R/7F2AB658 2012-07-02 PGP fingerprint: 4C7E 00A8 5210 F3D9 0509 C70E 87C8 666E 7F2A B658 Final RT training for 2012 in Atlanta, GA - October 23 & 24 http://bestpractical.com/training We're hiring! http://bestpractical.com/jobs