[rt-users] Problem with Attachments including German Umlaute in filename
Hi RT Users, during the weeks, we got more and more reports from our users, that mails sent to RT (RT 3.6.5) have corrupted file attachments. RT stores and displays them as .dat file. I've played around a little and figured out, only Files with german umlaute in filename have this problem. I'm not sure where to start to fix this at this moment. as example i create a mail with the following files attached: apple iMer.jpg - no problem apple_iMer.jpg - no problem apple_üMer.jpg - problem Inside the RT History the file looks like this: Download apple iMer.jpg [image/jpeg 7k] Download apple_iMer.jpg [image/jpeg 7k] Download (untitled) [name=apple_ 7k] Message body not shown because it is too large or is not plain text. I have really no idea at this moment where to start trouble shooting. Any help is welcome. Thanks Torsten Kühne + Nagel (AG Co.) KG, Geschäftsleitung: Hans-Georg Brinkmann (Vors.), Uwe Bielang (Stellv.), Bruno Mang, Dirk Blesius (Stellv.), Alfred Manke, Christian Marnetté (Stellv.), Mark Reinhardt (Stellv.), Jens Wollesen, Rainer Wunn, Sitz: Bremen, Registergericht: Bremen, HRA 21928, USt-IdNr.: DE 812773878, Persönlich haftende Gesellschaft: Kühne Nagel A.G., Sitz: Contern/Luxemburg Geschäftsführender Verwaltungsrat: Klaus-Michael Kühne ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: [EMAIL PROTECTED] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
[rt-users] Can't reinstall: CORE missing dependencies: File::ShareDir...MISSING
I upgraded my version of Ubuntu server to 8.0.4 because I was having some trouble after upgrading to RT 3.8.1. I assumed that the problems had something to do with my apache configuration or the fact that I was running out of date software. So, I attempted an upgrade of Ubuntu. I'm a Linux newbie. After the upgrade, I couldn't get Apache to start at all. I found that if I commented out the line about RT (the include in the Apache config) Apache started fine and all other sites were working great. So, I decided I would reinstall RT. I removed my /opt/rt3.8/ directory and went all the way back to the install steps. I ran the tar command to get the file to /tmp/. I then cd to /tmp/rt3-8-1/ and run 'sudo ./configure --prefix=/opt/rt3.8/ --enable-gd'. Then I run 'sudo make testdeps'. It tells me 'File::ShareDir...MISSING'. So, I run 'sudo make fixdeps' and it tells me all dependencies found. Then I could get into an endless loop - because testdeps still says it's missing. I figured I would go ahead and just run 'sudo make install' but it bombs with the same error as above: CORE missing dependencies: File::ShareDir...MISSING. It's worth mentioning that I looked and the directory /opt/rt3.8/ is not being created (I don't know if that matters or not). Anyway, I've taken an annoyance and managed to make a critical error out of it - however, I've been wanting to understand Linux and RT better - so maybe this is a blessing in disguise. Any help would be greatly appreciated. -Chris ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: [EMAIL PROTECTED] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
[rt-users] Search for field one equal to field two
I have an RT system running on Debian Stable (RT from the debian repo). I would like to have that follows the logic below - but when I tried it in the Advance search option, I had errors - so my guess is I am missing something and/or don't correctly understand how things work. (my Perl and PostSQL skills come down to copy/paste with a bit of guesstimating) Is what I am thinking even possible? Any help with pointers/reading material will also be appreciated. Queue = 'HelpDesk' AND LastUpdatedBy = Requestor.EmailAddress AND LastUpdated Created -- http://gentgeen.homelinux.org # Associate yourself with men of good quality if you esteem your own reputation; for 'tis better to be alone then in bad company.- George Washington, Rules of Civility ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: [EMAIL PROTECTED] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
[rt-users] Another Attachment / Mail Problem with RT 3.6.5
Hi together, it looks like a bad day for Mail/Attachments Just a few minutes ago a user reports problems with mails he sent out via RT webui with attachments. OK, what i figured out so far: 1. Attachment Size: 800KB (allowed are 8000KB) 2. User added at the reply screen a list of 20 people as cc 3. The list of CC'ed People is 1250 characters long 4. RT shows the mail (Show Outgoing Mail) correctly with all Cc'ed people 5. Users get the mail totally destroyed! Problem: 1. The CC list is cut after 994 characters, in the middle of an address 2. The rest of the people from the cc list are the first part of the body 3. The attachment is corrupted. 4. The encoding for content is incorrect, german umlaute are broken. The body looks like this: agel.com, [EMAIL PROTECTED], [EMAIL PROTECTED], [EMAIL PROTECTED], [EMAIL PROTECTED], [EMAIL PROTECTED], [EMAIL PROTECTED], [EMAIL PROTECTED], [EMAIL PROTECTED] MIME-Version: 1.0 X-RT-Original-Encoding: utf-8 Content-type: multipart/mixed; boundary=--=_1221049687-28898-8 Date: Wed, 10 Sep 2008 12:28:08 + This is a multi-part message in MIME format... =_1221049687-28898-8 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 8bit The original Text Content! Torsten Brumm =_1221049687-28898-8 Content-Type: application/octet-stream; name=CIEL-Umstellung.zip Content-Disposition: inline; filename=CIEL-Umstellung.zip Content-Transfer-Encoding: base64 RT-Attachment: 1147288/17593439/12279229 UEsDBBQIAENiKjlslM3qiBQBAO1JAQANQ0lFTCAtIEFaLnBkZsRb .. .. lots of lines like this .. =_1221049687-28898-8-- Any ideas what went wrong? We can reproduce this error. Torsten Kühne + Nagel (AG Co.) KG, Geschäftsleitung: Hans-Georg Brinkmann (Vors.), Uwe Bielang (Stellv.), Bruno Mang, Dirk Blesius (Stellv.), Alfred Manke, Christian Marnetté (Stellv.), Mark Reinhardt (Stellv.), Jens Wollesen, Rainer Wunn, Sitz: Bremen, Registergericht: Bremen, HRA 21928, USt-IdNr.: DE 812773878, Persönlich haftende Gesellschaft: Kühne Nagel A.G., Sitz: Contern/Luxemburg Geschäftsführender Verwaltungsrat: Klaus-Michael Kühne ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: [EMAIL PROTECTED] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
Re: [rt-users] Can't reinstall: CORE missing dependencies: File::ShareDir...MISSING
Chris Nelson wrote: I upgraded my version of Ubuntu server to 8.0.4 because I was having some trouble after upgrading to RT 3.8.1. http://3.8.1. I assumed that the problems had something to do with my apache configuration or the fact that I was running out of date software. So, I attempted an upgrade of Ubuntu. I'm a Linux newbie. After the upgrade, I couldn't get Apache to start at all. I found that if I commented out the line about RT (the include in the Apache config) Apache started fine and all other sites were working great. So, I decided I would reinstall RT. I removed my /opt/rt3.8/ directory and went all the way back to the install steps. I ran the tar command to get the file to /tmp/. I then cd to /tmp/rt3-8-1/ and run 'sudo ./configure --prefix=/opt/rt3.8/ --enable-gd'. Then I run 'sudo make testdeps'. It tells me 'File::ShareDir...MISSING'. So, I run 'sudo make fixdeps' and it tells me all dependencies found. Then I could get into an endless loop - because testdeps still says it's missing. I figured I would go ahead and just run 'sudo make install' but it bombs with the same error as above: CORE missing dependencies: File::ShareDir...MISSING. It's worth mentioning that I looked and the directory /opt/rt3.8/ is not being created (I don't know if that matters or not). In case you haven't done so run the following: sudo cpan File::ShareDir This should install File::ShareDir and resolve the problems of fixdeps. Running 'make install' also runs 'make fixdeps' thats why you don't get /opt/rt3.8 Regards, Joop ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: [EMAIL PROTECTED] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
Re: [rt-users] Can't reinstall: CORE missing dependencies: File::ShareDir...MISSING
Joop, This is what it says when I run that command: [EMAIL PROTECTED]:/tmp/rt-3.8.1$ sudo cpan File::ShareDir CPAN: Storable loaded ok Going to read /home/cnelson/.cpan/Metadata Database was generated on Tue, 09 Sep 2008 01:02:57 GMT File::ShareDir is up to date. However, it still fails on sudo make testdeps. I run sudo make fixdeps and here are the relevant lines: - File::ShareDir...MISSING - Install module File::ShareDir CPAN: Storable loaded ok Going to read /home/cnelson/.cpan/Metadata Database was generated on Tue, 09 Sep 2008 01:02:57 GMT File::ShareDir is up to date. Thanks so much for your help. -Chris On Wed, Sep 10, 2008 at 9:16 AM, Joop [EMAIL PROTECTED] wrote: Chris Nelson wrote: I upgraded my version of Ubuntu server to 8.0.4 because I was having some trouble after upgrading to RT 3.8.1. http://3.8.1. I assumed that the problems had something to do with my apache configuration or the fact that I was running out of date software. So, I attempted an upgrade of Ubuntu. I'm a Linux newbie. After the upgrade, I couldn't get Apache to start at all. I found that if I commented out the line about RT (the include in the Apache config) Apache started fine and all other sites were working great. So, I decided I would reinstall RT. I removed my /opt/rt3.8/ directory and went all the way back to the install steps. I ran the tar command to get the file to /tmp/. I then cd to /tmp/rt3-8-1/ and run 'sudo ./configure --prefix=/opt/rt3.8/ --enable-gd'. Then I run 'sudo make testdeps'. It tells me 'File::ShareDir...MISSING'. So, I run 'sudo make fixdeps' and it tells me all dependencies found. Then I could get into an endless loop - because testdeps still says it's missing. I figured I would go ahead and just run 'sudo make install' but it bombs with the same error as above: CORE missing dependencies: File::ShareDir...MISSING. It's worth mentioning that I looked and the directory /opt/rt3.8/ is not being created (I don't know if that matters or not). In case you haven't done so run the following: sudo cpan File::ShareDir This should install File::ShareDir and resolve the problems of fixdeps. Running 'make install' also runs 'make fixdeps' thats why you don't get /opt/rt3.8 Regards, Joop ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: [EMAIL PROTECTED] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
Re: [rt-users] Can't reinstall: CORE missing dependencies: File::ShareDir...MISSING
Chris Nelson wrote: Joop, This is what it says when I run that command: [EMAIL PROTECTED]:/tmp/rt-3.8.1$ sudo cpan File::ShareDir CPAN: Storable loaded ok Going to read /home/cnelson/.cpan/Metadata Database was generated on Tue, 09 Sep 2008 01:02:57 GMT File::ShareDir is up to date. However, it still fails on sudo make testdeps. I run sudo make fixdeps and here are the relevant lines: * File::ShareDir...MISSING * Install module File::ShareDir CPAN: Storable loaded ok Going to read /home/cnelson/.cpan/Metadata Database was generated on Tue, 09 Sep 2008 01:02:57 GMT File::ShareDir is up to date. I have had something like this and it turned out that the version comparison didn't work as expected. The solution I then use is: sudo make -k install The -k option tells make to continue even if it encounters errors. Just be sure that the File::ShareDir is the only error else make will happily continue doing potential a lot of bad things. Lets see if I can reproduce your problem with a VM running Ubuntu 8.04 which is updated to the latest patches. I'll let you know what happens. Joop ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: [EMAIL PROTECTED] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
Re: [rt-users] Extension CommandByMail
Something I've noticed with this extension is that using vcards actually forces the extension to spew out mailgate errors. I assume the reason being that vcards use something similar to: something: somethingelse cmd via mail extension doesn't like this. I've got around this with a very bad hack by sending errors to another email address. Specifically this line: my $ErrorsTo = RT::Interface::Email::ParseErrorsToAddressFromHead( $args{'Message'}-head ); I changed this to: my $ErrorsTo = "[EMAIL PROTECTED]"; and restarted apache. Hope this helps someone. Reginaldo Russinholi wrote: Thanx Shawn, But I've put the following line at the end of RT_SiteConfig.pm @MailPlugins = qw(Auth::MailFrom Filter::TakeAction); and it doesn't work yet. One more question, to send commands by e-mail I need put the commands at beginning of the mail, right? Like that: _ Owner: root Status: open Some comments about the changes. _ Is it correct? Reginaldo Shawn M Moore escreveu: On Thu, Sep 04, 2008 at 01:59:06PM -0300, Reginaldo Russinholi wrote: Hi all, I'm using RT 3.6.6 and I'd like to use the extension CommandByMail. Well, I downloaded the source and follow the instrunctions to install, but I didn't understand in what file and in what part of that file I have to put the CommandByMail configuration. Any help? Hi Reginaldo, The config for CommandByMail goes in your RT_SiteConfig.pm file. If you're using the standard layout, it'll be in /opt/rt3/etc. Shawn ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: [EMAIL PROTECTED] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com -- Garith Dugmore Senior Systems Administrator South African Astronomical Observatory and Southern African Large Telescope Phone: 021 460 9343 Fax:021 447 3639 SAAO Website: http://www.saao.ac.za SALT Website: http://www.salt.ac.za Jabber: [EMAIL PROTECTED] MSN:[EMAIL PROTECTED] Skype: garith5512 ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: [EMAIL PROTECTED] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
Re: [rt-users] Can't reinstall: CORE missing dependencies: File::ShareDir...MISSING
Awesome. It's worth pointing out I'm doing make upgrade (so I'm going to do make -k upgrade). Thanks! On Wed, Sep 10, 2008 at 10:12 AM, Joop [EMAIL PROTECTED] wrote: Chris Nelson wrote: Joop, This is what it says when I run that command: [EMAIL PROTECTED]:/tmp/rt-3.8.1$ sudo cpan File::ShareDir CPAN: Storable loaded ok Going to read /home/cnelson/.cpan/Metadata Database was generated on Tue, 09 Sep 2008 01:02:57 GMT File::ShareDir is up to date. However, it still fails on sudo make testdeps. I run sudo make fixdeps and here are the relevant lines: * File::ShareDir...MISSING * Install module File::ShareDir CPAN: Storable loaded ok Going to read /home/cnelson/.cpan/Metadata Database was generated on Tue, 09 Sep 2008 01:02:57 GMT File::ShareDir is up to date. I have had something like this and it turned out that the version comparison didn't work as expected. The solution I then use is: sudo make -k install The -k option tells make to continue even if it encounters errors. Just be sure that the File::ShareDir is the only error else make will happily continue doing potential a lot of bad things. Lets see if I can reproduce your problem with a VM running Ubuntu 8.04 which is updated to the latest patches. I'll let you know what happens. Joop ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: [EMAIL PROTECTED] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
Re: [rt-users] Can't reinstall: CORE missing dependencies: File::ShareDir...MISSING
Oh. Wait. So, do I do the make -k upgrade from within /tmp/rt-3.8.1/ or do I need to make the directory for /opt/rt3.8/ first? On Wed, Sep 10, 2008 at 10:15 AM, Chris Nelson [EMAIL PROTECTED] wrote: Awesome. It's worth pointing out I'm doing make upgrade (so I'm going to do make -k upgrade). Thanks! On Wed, Sep 10, 2008 at 10:12 AM, Joop [EMAIL PROTECTED] wrote: Chris Nelson wrote: Joop, This is what it says when I run that command: [EMAIL PROTECTED]:/tmp/rt-3.8.1$ sudo cpan File::ShareDir CPAN: Storable loaded ok Going to read /home/cnelson/.cpan/Metadata Database was generated on Tue, 09 Sep 2008 01:02:57 GMT File::ShareDir is up to date. However, it still fails on sudo make testdeps. I run sudo make fixdeps and here are the relevant lines: * File::ShareDir...MISSING * Install module File::ShareDir CPAN: Storable loaded ok Going to read /home/cnelson/.cpan/Metadata Database was generated on Tue, 09 Sep 2008 01:02:57 GMT File::ShareDir is up to date. I have had something like this and it turned out that the version comparison didn't work as expected. The solution I then use is: sudo make -k install The -k option tells make to continue even if it encounters errors. Just be sure that the File::ShareDir is the only error else make will happily continue doing potential a lot of bad things. Lets see if I can reproduce your problem with a VM running Ubuntu 8.04 which is updated to the latest patches. I'll let you know what happens. Joop ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: [EMAIL PROTECTED] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
Re: [rt-users] Another Attachment / Mail Problem with RT 3.6.5
On Sep 10, 2008, at 9:14 AM, Ham MI-ID, Torsten Brumm wrote: Hi together, it looks like a bad day for Mail/Attachments Just a few minutes ago a user reports problems with mails he sent out via RT webui with attachments. OK, what i figured out so far: 1. Attachment Size: 800KB (allowed are 8000KB) 2. User added at the reply screen a list of 20 people as cc 3. The list of CC'ed People is 1250 characters long 4. RT shows the mail (Show Outgoing Mail) correctly with all Cc'ed people 5. Users get the mail totally destroyed! Problem: 1. The CC list is cut after 994 characters, in the middle of an address That sure sounds like a 1000 character wrapping issue. Can you reproduce it? 2. The rest of the people from the cc list are the first part of the body 3. The attachment is corrupted. That's due to #2 4. The encoding for content is incorrect, german umlaute are broken. That's due to #2 ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: [EMAIL PROTECTED] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
[rt-users] Repair CachedGroupMembers? was: 3.8.1 -- Ticket Search doesn't find Requestor?
RT Users - After some digging, I believe I've discovered why some tickets do not appear when searched by Requestor. It appears that some records are missing from CachedGroupMembers. Can anyone recommend a way of querying for the requestor from GroupMembers and using that to populate CachedGroupMembers? GroupMembers contains the correct requestors -- but that doesn't seem to apply to the standard Search functions. Here's the dirt -- I have two tickets: * Ticket #1 -- Does not display a requestor in Simple.html and is not found using a Requestor search, but does show a Requestor in the Ticket View (under People). * Ticket #26 -- Shows a requestor and is found using a Requestor search. For Ticket #1 -- mysql select id from Groups where instance='1' and Domain = 'RT::Ticket-Role' and Type = 'Requestor'; ++ | id | ++ | 52 | ++ 1 row in set (0.00 sec) mysql select MemberId from GroupMembers where GroupId = '52'; +--+ | MemberId | +--+ | 34 | +--+ 1 row in set (0.00 sec) mysql select EmailAddress from Users where id = '34'; +--+ | EmailAddress | +--+ | [EMAIL PROTECTED] | +--+ However, mysql SELECT DISTINCT t1.id Ticket_id, g2.id RoleGroup_id, g2.Type Role_Type, cgm3.MemberId RoleMember_id, p4.PrincipalType, u5.Name FROM Tickets t1, Groups g2, CachedGroupMembers cgm3, Principals p4, Users u5 WHERE t1.id = 1 AND g2.Domain = 'RT::Ticket-Role' AND g2.Instance = t1.id AND cgm3.GroupId = g2.id AND p4.id = cgm3.MemberId AND p4.Disabled = 0 AND p4.PrincipalType = 'User' AND u5.id = p4.id; Empty set (0.00 sec) On ticket #26 (the ticket that is discoverable using search), mysql SELECT DISTINCT t1.id Ticket_id, g2.id RoleGroup_id, g2.Type Role_Type, cgm3.MemberId RoleMember_id, p4.PrincipalType, u5.Name FROM Tickets t1, Groups g2, CachedGroupMembers cgm3, Principals p4, Users u5 WHERE t1.id = 26 AND g2.Domain = 'RT::Ticket-Role' AND g2.Instance = t1.id AND cgm3.GroupId = g2.id AND p4.id = cgm3.MemberId AND p4.Disabled = 0 AND p4.PrincipalType = 'User' AND u5.id = p4.id; +---+--+---+---+---+--+ | Ticket_id | RoleGroup_id | Role_Type | RoleMember_id | PrincipalType | Name | +---+--+---+---+---+--+ |26 | 521 | Requestor | 124 | User | bubbleman | +---+--+---+---+---+--+ 1 row in set (0.00 sec) Obviously the ticket view uses something more closely related to the initial query, and the Search functions use CachedGroupMembers. Any help is appreciated. I've modified Googlish.pm to do a fulltext search on Content, but that's a /really/ ugly hack. Thanks so much! ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: [EMAIL PROTECTED] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
Re: [rt-users] Can't reinstall: CORE missing dependencies: File::ShareDir...MISSING
Chris Nelson wrote: Ok. The install worked with the -k flag. However, I had to run: sudo cp /usr/share/request-tracker3.6/libexec/webmux.pl /opt/rt3.8/bin and sudo cp backups/apache/apache2-modperl2.conf /opt/rt3.8/ (which is just a copy of this file I made RIGHT before I did the upgrade of RT). Please supply your configure line. If you can't remember what it was try 'history' in you bash shell or else see config.log in your /tmp/rt-3.8.1 directory Regards, Joop ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: [EMAIL PROTECTED] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
[rt-users] 3.6.6 display problem
Hi, I'm running SLES 10, SP1, with RT 3.6.6. Yesterday, I installed 2 php5 modules, then ran online updates last night from YAST2, and today I see nothing when I access the site, just a blank page. The Apache access_log shows a successful connection: 172.31.4.143 - - [10/Sep/2008:10:43:55 -0400] GET /index.html HTTP/1.1 200 - - Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.9.0.1) Gecko/2008070208 Firefox/3.0.1 But Firefox displays a blank page, 0 bytes. I'm guessing it's a Perl module from the YAST update. Any clues? The information in this message may be proprietary and/or confidential, and protected from disclosure. If the reader of this message is not the intended recipient, or an employee or agent responsible for delivering this message to the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please notify Stonebridge Bank immediately by replying to this message and deleting it from your computer. ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: [EMAIL PROTECTED] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
[rt-users] 3.8.1 corrupting attachments
I'm having a problem with corruption as well. I had missed this upgrade because I am running mysql 5.x so presumed it didn't apply. I've since run the script and everything seemed to work, but of course this is after doing the 3.8.1 upgrades. My attachments still seem to be corrupting, any suggestions? This is the output of show create table attachments: Attachments CREATE TABLE `Attachments` ( `id` int(11) NOT NULL auto_increment, `TransactionId` int(11) NOT NULL, `Parent` int(11) NOT NULL default '0', `MessageId` varchar(160) character set ascii default NULL, `Subject` varchar(255) default NULL, `Filename` varchar(255) default NULL, `ContentType` varchar(80) character set ascii default NULL, `ContentEncoding` varchar(80) character set ascii default NULL, `Content` longblob, `Headers` longtext, `Creator` int(11) NOT NULL default '0', `Created` datetime default NULL, PRIMARY KEY (`id`), KEY `Attachments2` (`TransactionId`), KEY `Attachments3` (`Parent`,`TransactionId`) ) ENGINE=InnoDB AUTO_INCREMENT=4221 DEFAULT CHARSET=utf8 Quoted Text Below: -- Shouldn't at this point, but there is a chance that later we'll have an upgrade for some 3.8.x version that wouldn't work correct if your DB is not changed using the script. Could you please send us output of SHOW CREATE TABLE Attachments; SQL command? On Fri, Aug 22, 2008 at 3:38 AM, Aaron Hathaway aaron.hathaway at prager.com http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users wrote: * Helmuth, I ran the script after updating from 3.8.0 to 3.8.1. Would that make a** difference? Thanks, Aaron From: Helmuth Ramirez [mailto:HelmuthRamirez at compupay.com http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users]** Sent: Thursday, August 21, 2008 3:32 PM** To: Aaron Hathaway; jmoseley at corp.xanadoo.com http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users** Cc: rt-users at lists.bestpractical.com http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users** Subject: Re: [rt-users] 3.8.1 corrupting attachments Did you upgrade the db to 3.8.0, run the script, then update to 3.8.1?*** ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: [EMAIL PROTECTED] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
Re: [rt-users] upgrade 3.6.1-3.8.1 Looping login
I have the same problem. But I suppose because of External LDAP Auth plug-in. Sean wrote: I'm having the same problem with a fresh install of 3.8.1 using MySQL 5.0.60. On Wed, Aug 20, 2008 at 02:54:31PM -0400, Helmuth Ramirez wrote: Were you coming from MySQL 4.0? I had the same problem until I did the MySQL 4.0 - 4.1 updates -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Chip Mefford Sent: Wednesday, August 20, 2008 2:30 PM Cc: RT Users Subject: [rt-users] upgrade 3.6.1-3.8.1 Looping login Upgraded 3.6.1 to 3.8.1, carefully read the docs, followed the instructions (for mysql) and the upgrade went brilliantly. Good job folks. Very nice. Logged into my new shiny RT. And all looks good. however, when running (some) reports, and fiddling about with advanced searches, I'll get returned to a login screen, and I must log in again in order to access the result. ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: [EMAIL PROTECTED] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: [EMAIL PROTECTED] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com -- Dmitry Monakhov System Administrator Open Technologies, tel: +7(495)787-7027 e-mail: [EMAIL PROTECTED], http://www.ot.ru/ ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: [EMAIL PROTECTED] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
Re: [rt-users] 3.6.6 display problem
Yeah, 'rpm -qa --last | less' showed me that perl-5.8.8-14.10 was installed Wed Sep 10 03:26:19 2008. I tried to reinstall Scalar::Utils but I'm having some trouble with CPAN — any suggestions? cpan[1] install Scalar::Utils CPAN: Storable loaded ok (v2.15) Going to read /root/.cpan/Metadata Database was generated on Thu, 05 Jun 2008 19:06:52 GMT Going to read /root/.cpan/sources/authors/01mailrc.txt.gz Use of uninitialized value in concatenation (.) or string at /usr/lib/perl5/5.8.8/i586-linux-thread-multi/Scalar/Util.pm line 30. Use of uninitialized value in concatenation (.) or string at /usr/lib/perl5/5.8.8/i586-linux-thread-multi/Scalar/Util.pm line 30. DONE CPAN: LWP::UserAgent loaded ok (v2.036) CPAN: Time::HiRes loaded ok (v1.86) Fetching with LWP: ftp://bc1.hpc.lsu.edu/pub/mirrors/CPAN/modules/02packages.details.txt.gz Use of uninitialized value in concatenation (.) or string at /usr/lib/perl5/5.8.8/i586-linux-thread-multi/Scalar/Util.pm line 30. LWP failed with code[500] message[read timeout] CPAN: Net::FTP loaded ok (v2.77) Fetching with Net::FTP: ftp://bc1.hpc.lsu.edu/pub/mirrors/CPAN/modules/02packages.details.txt.gz Couldn't cwd pub/mirrors/CPAN/modules: pub/mirrors/CPAN/modules: No such file or directory. Fetching with Net::FTP ftp://bc1.hpc.lsu.edu/pub/mirrors/CPAN/modules/02packages.details.txt.gz.gz Couldn't cwd pub/mirrors/CPAN/modules: pub/mirrors/CPAN/modules: No such file or directory. Trying with /usr/bin/wget -O /root/.cpan/sources/modules/02packages.details.txt.tmp22613 to get ftp://bc1.hpc.lsu.edu/pub/mirrors/CPAN/modules/02packages.details.txt.gz --11:36:08-- ftp://bc1.hpc.lsu.edu/pub/mirrors/CPAN/modules/02packages.details.txt.gz = `/root/.cpan/sources/modules/02packages.details.txt.tmp22613' Connecting to 172.31.4.254:8080... connected. Proxy request sent, awaiting response... 404 Not Found 11:36:10 ERROR 404: Not Found. System call /usr/bin/wget -O /root/.cpan/sources/modules/02packages.details.txt.tmp22613 ftp://bc1.hpc.lsu.edu/pub/mirrors/CPAN/modules/02packages.details.txt.gz; returned status 1 (wstat 256) Warning: expected file [/root/.cpan/sources/modules/02packages.details.txt.gz.tmp22613] doesn't exist Fetching with LWP: ftp://cpan.calvin.edu/pub/CPAN/modules/02packages.details.txt.gz CPAN: YAML loaded ok (v0.66) Going to read /root/.cpan/sources/modules/02packages.details.txt.gz Catching error: 'Undefined subroutine Compress::Zlib::gzopen called at /usr/lib/perl5/5.8.8/CPAN/Tarzip.pm line 103. ' at /usr/lib/perl5/5.8.8/CPAN.pm line 281 CPAN::shell() called at -e line 1 Going to read /root/.cpan/sources/authors/01mailrc.txt.gz Lockfile removed. Undefined subroutine Compress::Zlib::gzopen called at /usr/lib/perl5/5.8.8/CPAN/Tarzip.pm line 103. Michael James [EMAIL PROTECTED] 9/10/2008 10:57 AM Hi, I'm running SLES 10, SP1, with RT 3.6.6. Yesterday, I installed 2 php5 modules, then ran online updates last night from YAST2, and today I see nothing when I access the site, just a blank page. The Apache access_log shows a successful connection: 172.31.4.143 - - [10/Sep/2008:10:43:55 -0400] GET /index.html HTTP/1.1 200 - - Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.9.0.1) Gecko/2008070208 Firefox/3.0.1 But Firefox displays a blank page, 0 bytes. I'm guessing it's a Perl module from the YAST update. Any clues? The information in this message may be proprietary and/or confidential, and protected from disclosure. If the reader of this message is not the intended recipient, or an employee or agent responsible for delivering this message to the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please notify Stonebridge Bank immediately by replying to this message and deleting it from your computer. ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: [EMAIL PROTECTED] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com The information in this message may be proprietary and/or confidential, and protected from disclosure. If the reader of this message is not the intended recipient, or an employee or agent responsible for delivering this message to the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please notify Stonebridge Bank immediately by replying to this message and deleting it from your computer. ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com
Re: [rt-users] upgrade 3.6.1-3.8.1 Looping login
I'm using ExternalAuth and it doesn't do the looping issue. The only time I've noticed it loop is when I click on a child/parent ticket link of a ticket I created using the New child in button, it takes me to the login. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Dmitry Monakhov Sent: Wednesday, September 10, 2008 10:35 AM To: Sean; rt-users@lists.bestpractical.com Subject: Re: [rt-users] upgrade 3.6.1-3.8.1 Looping login I have the same problem. But I suppose because of External LDAP Auth plug-in. Sean wrote: I'm having the same problem with a fresh install of 3.8.1 using MySQL 5.0.60. On Wed, Aug 20, 2008 at 02:54:31PM -0400, Helmuth Ramirez wrote: Were you coming from MySQL 4.0? I had the same problem until I did the MySQL 4.0 - 4.1 updates -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Chip Mefford Sent: Wednesday, August 20, 2008 2:30 PM Cc: RT Users Subject: [rt-users] upgrade 3.6.1-3.8.1 Looping login Upgraded 3.6.1 to 3.8.1, carefully read the docs, followed the instructions (for mysql) and the upgrade went brilliantly. Good job folks. Very nice. Logged into my new shiny RT. And all looks good. however, when running (some) reports, and fiddling about with advanced searches, I'll get returned to a login screen, and I must log in again in order to access the result. ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: [EMAIL PROTECTED] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: [EMAIL PROTECTED] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com -- Dmitry Monakhov System Administrator Open Technologies, tel: +7(495)787-7027 e-mail: [EMAIL PROTECTED], http://www.ot.ru/ ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: [EMAIL PROTECTED] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: [EMAIL PROTECTED] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
Re: [rt-users] 3.6.6 display problem
OK, I did 'force install Scalar::Util' and that worked for me. The login page displays properly. Still working on Compress::Zlib ... Thanks for listening, Mike :) Michael James [EMAIL PROTECTED] 9/10/2008 11:38 AM Yeah, 'rpm -qa --last | less' showed me that perl-5.8.8-14.10 was installed Wed Sep 10 03:26:19 2008. I tried to reinstall Scalar::Utils but I'm having some trouble with CPAN — any suggestions? cpan[1] install Scalar::Utils CPAN: Storable loaded ok (v2.15) Going to read /root/.cpan/Metadata Database was generated on Thu, 05 Jun 2008 19:06:52 GMT Going to read /root/.cpan/sources/authors/01mailrc.txt.gz Use of uninitialized value in concatenation (.) or string at /usr/lib/perl5/5.8.8/i586-linux-thread-multi/Scalar/Util.pm line 30. Use of uninitialized value in concatenation (.) or string at /usr/lib/perl5/5.8.8/i586-linux-thread-multi/Scalar/Util.pm line 30. DONE CPAN: LWP::UserAgent loaded ok (v2.036) CPAN: Time::HiRes loaded ok (v1.86) Fetching with LWP: ftp://bc1.hpc.lsu.edu/pub/mirrors/CPAN/modules/02packages.details.txt.gz Use of uninitialized value in concatenation (.) or string at /usr/lib/perl5/5.8.8/i586-linux-thread-multi/Scalar/Util.pm line 30. LWP failed with code[500] message[read timeout] CPAN: Net::FTP loaded ok (v2.77) Fetching with Net::FTP: ftp://bc1.hpc.lsu.edu/pub/mirrors/CPAN/modules/02packages.details.txt.gz Couldn't cwd pub/mirrors/CPAN/modules: pub/mirrors/CPAN/modules: No such file or directory. Fetching with Net::FTP ftp://bc1.hpc.lsu.edu/pub/mirrors/CPAN/modules/02packages.details.txt.gz.gz Couldn't cwd pub/mirrors/CPAN/modules: pub/mirrors/CPAN/modules: No such file or directory. Trying with /usr/bin/wget -O /root/.cpan/sources/modules/02packages.details.txt.tmp22613 to get ftp://bc1.hpc.lsu.edu/pub/mirrors/CPAN/modules/02packages.details.txt.gz --11:36:08-- ftp://bc1.hpc.lsu.edu/pub/mirrors/CPAN/modules/02packages.details.txt.gz = `/root/.cpan/sources/modules/02packages.details.txt.tmp22613' Connecting to 172.31.4.254:8080... connected. Proxy request sent, awaiting response... 404 Not Found 11:36:10 ERROR 404: Not Found. System call /usr/bin/wget -O /root/.cpan/sources/modules/02packages.details.txt.tmp22613 ftp://bc1.hpc.lsu.edu/pub/mirrors/CPAN/modules/02packages.details.txt.gz; returned status 1 (wstat 256) Warning: expected file [/root/.cpan/sources/modules/02packages.details.txt.gz.tmp22613] doesn't exist Fetching with LWP: ftp://cpan.calvin.edu/pub/CPAN/modules/02packages.details.txt.gz CPAN: YAML loaded ok (v0.66) Going to read /root/.cpan/sources/modules/02packages.details.txt.gz Catching error: 'Undefined subroutine Compress::Zlib::gzopen called at /usr/lib/perl5/5.8.8/CPAN/Tarzip.pm line 103. ' at /usr/lib/perl5/5.8.8/CPAN.pm line 281 CPAN::shell() called at -e line 1 Going to read /root/.cpan/sources/authors/01mailrc.txt.gz Lockfile removed. Undefined subroutine Compress::Zlib::gzopen called at /usr/lib/perl5/5.8.8/CPAN/Tarzip.pm line 103. Michael James [EMAIL PROTECTED] 9/10/2008 10:57 AM Hi, I'm running SLES 10, SP1, with RT 3.6.6. Yesterday, I installed 2 php5 modules, then ran online updates last night from YAST2, and today I see nothing when I access the site, just a blank page. The Apache access_log shows a successful connection: 172.31.4.143 - - [10/Sep/2008:10:43:55 -0400] GET /index.html HTTP/1.1 200 - - Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.9.0.1) Gecko/2008070208 Firefox/3.0.1 But Firefox displays a blank page, 0 bytes. I'm guessing it's a Perl module from the YAST update. Any clues? The information in this message may be proprietary and/or confidential, and protected from disclosure. If the reader of this message is not the intended recipient, or an employee or agent responsible for delivering this message to the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please notify Stonebridge Bank immediately by replying to this message and deleting it from your computer. ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: [EMAIL PROTECTED] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com The information in this message may be proprietary and/or confidential, and protected from disclosure. If the reader of this message is not the intended recipient, or an employee or agent responsible for delivering this message to the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please notify Stonebridge Bank immediately
Re: [rt-users] Repair CachedGroupMembers? was: 3.8.1 -- Ticket Search doesn't find Requestor?
All - I would like to get opinions on repairing my database using SQL. If there is a more graceful way to accomplish this using the RT perl modules (RT::CachedGroupMembers, etc) any help is appreciated. From the RT Essentials book (http://is.gd/2rG6), we find that in CachedGroupMembers: id == any incremental value GroupId == requestor group id MemberId == MemberId in question (requestor) Via == usually equal to the CachedGroupMembers id ImmediateParentId == requestor group id Disabled == 0 I'm going to work from the values in Ticket #1 (see previous message). insert into CachedGroupMembers values ('', '52', '34', '', '52', '0'); ** And Voila! ** The requestor appears in the regular Search as expected, and is searchable by requestor in Query Builder. And here is what it looks like in the end: mysql select * from CachedGroupMembers where GroupId='52' and MemberId='34' and ImmediateParentId='52'; +---+-+--+--+---+--+ | id| GroupId | MemberId | Via | ImmediateParentId | Disabled | +---+-+--+--+---+--+ | 81550 | 52 | 34 |0 |52 |0 | +---+-+--+--+---+--+ Should the Disabled status be pulled from Principals? (select Disabled from Principals where id = '34') Any opinions on making these modifications is appreciated. On Wed, Sep 10, 2008 at 10:08 AM, RT [EMAIL PROTECTED] wrote: RT Users - After some digging, I believe I've discovered why some tickets do not appear when searched by Requestor. It appears that some records are missing from CachedGroupMembers. Can anyone recommend a way of querying for the requestor from GroupMembers and using that to populate CachedGroupMembers? GroupMembers contains the correct requestors -- but that doesn't seem to apply to the standard Search functions. ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: [EMAIL PROTECTED] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
[rt-users] Repair CachedGroupMembers? was: 3.8.1 -- Ticket Search doesn't find Requestor?
(For some reason, my message was cut off in the previous post.) All - I would like to get opinions on repairing my database using SQL. If there is a more graceful way to accomplish this using the RT perl modules (RT::CachedGroupMembers, etc) any help is appreciated. From the RT Essentials book, we find that in CachedGroupMembers: id == any incremental value GroupId == requestor group id MemberId == MemberId in question (requestor) Via == usually equal to the CachedGroupMembers id ImmediateParentId == requestor group id Disabled == 0 I'm going to work from the values in Ticket #1 (see previous message). insert into CachedGroupMembers values ('', '52', '34', '', '52', '0'); ** And Voila! ** The requestor appears in the regular Search as expected, and is searchable by requestor in Query Builder. And here is what it looks like in the end: mysql select * from CachedGroupMembers where GroupId='52' and MemberId='34' and ImmediateParentId='52'; +---+-+--+--+---+--+ | id| GroupId | MemberId | Via | ImmediateParentId | Disabled | +---+-+--+--+---+--+ | 81550 | 52 | 34 |0 |52 |0 | +---+-+--+--+---+--+ Should the Disabled status be pulled from Principals? (select Disabled from Principals where id = '34') Any opinions on making these modifications is appreciated. ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: [EMAIL PROTECTED] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
[rt-users] Repair CachedGroupMembers? was: 3.8.1 -- Ticket Search doesn't find Requestor?
From the RT Essentials book, we find that in CachedGroupMembers: id == any incremental value GroupId == requestor group id MemberId == MemberId in question (requestor) Via == usually equal to the CachedGroupMembers id ImmediateParentId == requestor group id Disabled == 0 I'm going to work from the values in Ticket #1 (see previous message). insert into CachedGroupMembers values ('', '52', '34', '', '52', '0'); ** And Voila! ** The requestor appears in the regular Search as expected, and is searchable by requestor in Query Builder. And here is what it looks like in the end: mysql select * from CachedGroupMembers where GroupId='52' and MemberId='34' and ImmediateParentId='52'; +---+-+--+--+---+--+ | id| GroupId | MemberId | Via | ImmediateParentId | Disabled | +---+-+--+--+---+--+ | 81550 | 52 | 34 |0 |52 |0 | +---+-+--+--+---+--+ Should the Disabled status be pulled from Principals? (select Disabled from Principals where id = '34') Any opinions on making these modifications is appreciated. ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: [EMAIL PROTECTED] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
Re: [rt-users] Repair CachedGroupMembers? was: 3.8.1 -- Ticket Search doesn't find Requestor?
All - I would like to get opinions on repairing my database using SQL. If there is a more graceful way to accomplish this using the RT perl modules (RT::CachedGroupMembers, etc) any help is appreciated. From the RT Essentials book (http://is.gd/2rG6), we find that in CachedGroupMembers: id = any incremental value GroupId = requestor group id MemberId = MemberId in question (requestor) Via = usually equal to the CachedGroupMembers id ImmediateParentId = requestor group id Disabled = 0 I'm going to work from the values in Ticket #1 (see previous message). insert into CachedGroupMembers values ('', '52', '34', '', '52', '0'); ** And Voila! ** The requestor appears in the regular Search as expected, and is searchable by requestor in Query Builder. And here is what it looks like in the end: mysql select * from CachedGroupMembers where GroupId='52' and MemberId='34' and ImmediateParentId='52'; +---+-+--+--+---+--+ | id| GroupId | MemberId | Via | ImmediateParentId | Disabled | +---+-+--+--+---+--+ | 81550 | 52 | 34 |0 |52 |0 | +---+-+--+--+---+--+ Should the Disabled status be pulled from Principals? (select Disabled from Principals where id = '34') Any opinions on making these modifications is appreciated. RT Users - After some digging, I believe I've discovered why some tickets do not appear when searched by Requestor. It appears that some records are missing from CachedGroupMembers. Can anyone recommend a way of querying for the requestor from GroupMembers and using that to populate CachedGroupMembers? GroupMembers contains the correct requestors -- but that doesn't seem to apply to the standard Search functions. ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: [EMAIL PROTECTED] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
Re: [rt-users] Repair CachedGroupMembers? was: 3.8.1 -- Ticket Search doesn't find Requestor?
And now you should do: UPDATE CachedGroupMembers SET Via = 81550 WHERE id = 81550; But major question is how did it happen that there is no this record in CachedGroupMembers table? On Wed, Sep 10, 2008 at 8:00 PM, RT [EMAIL PROTECTED] wrote: All - I would like to get opinions on repairing my database using SQL. If there is a more graceful way to accomplish this using the RT perl modules (RT::CachedGroupMembers, etc) any help is appreciated. From the RT Essentials book (http://is.gd/2rG6), we find that in CachedGroupMembers: id == any incremental value GroupId == requestor group id MemberId == MemberId in question (requestor) Via == usually equal to the CachedGroupMembers id ImmediateParentId == requestor group id Disabled == 0 I'm going to work from the values in Ticket #1 (see previous message). insert into CachedGroupMembers values ('', '52', '34', '', '52', '0'); ** And Voila! ** The requestor appears in the regular Search as expected, and is searchable by requestor in Query Builder. And here is what it looks like in the end: mysql select * from CachedGroupMembers where GroupId='52' and MemberId='34' and ImmediateParentId='52'; +---+-+--+--+---+--+ | id| GroupId | MemberId | Via | ImmediateParentId | Disabled | +---+-+--+--+---+--+ | 81550 | 52 | 34 |0 |52 |0 | +---+-+--+--+---+--+ Should the Disabled status be pulled from Principals? (select Disabled from Principals where id = '34') Any opinions on making these modifications is appreciated. On Wed, Sep 10, 2008 at 10:08 AM, RT [EMAIL PROTECTED] wrote: RT Users - After some digging, I believe I've discovered why some tickets do not appear when searched by Requestor. It appears that some records are missing from CachedGroupMembers. Can anyone recommend a way of querying for the requestor from GroupMembers and using that to populate CachedGroupMembers? GroupMembers contains the correct requestors -- but that doesn't seem to apply to the standard Search functions. -- Best regards, Ruslan. ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: [EMAIL PROTECTED] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
Re: [rt-users] Repair CachedGroupMembers? was: 3.8.1 -- Ticket Search doesn't find Requestor?
Thanks so much for the response! It is very much appreciated. How did it end up there was no record in CachedGroupMembers? To be honest, I don't know. I inherited this RT database from someone else, and I believe they made a number of changes blindly via SQL. I sincerely appreciate your help. I apologize for the multiple posts -- my messages weren't appearing in the list archive, so I assumed they weren't going out to the list. If list members received multiples, I apologize profusely! Hopefully this will help others should they find CachedGroupMembers missing records. On Wed, Sep 10, 2008 at 11:28 AM, Ruslan Zakirov [EMAIL PROTECTED]wrote: And now you should do: UPDATE CachedGroupMembers SET Via = 81550 WHERE id = 81550; But major question is how did it happen that there is no this record in CachedGroupMembers table? On Wed, Sep 10, 2008 at 8:00 PM, RT [EMAIL PROTECTED] wrote: All - I would like to get opinions on repairing my database using SQL. If there is a more graceful way to accomplish this using the RT perl modules (RT::CachedGroupMembers, etc) any help is appreciated. From the RT Essentials book (http://is.gd/2rG6), we find that in CachedGroupMembers: id == any incremental value GroupId == requestor group id MemberId == MemberId in question (requestor) Via == usually equal to the CachedGroupMembers id ImmediateParentId == requestor group id Disabled == 0 I'm going to work from the values in Ticket #1 (see previous message). insert into CachedGroupMembers values ('', '52', '34', '', '52', '0'); ** And Voila! ** The requestor appears in the regular Search as expected, and is searchable by requestor in Query Builder. And here is what it looks like in the end: mysql select * from CachedGroupMembers where GroupId='52' and MemberId='34' and ImmediateParentId='52'; +---+-+--+--+---+--+ | id| GroupId | MemberId | Via | ImmediateParentId | Disabled | +---+-+--+--+---+--+ | 81550 | 52 | 34 |0 |52 |0 | +---+-+--+--+---+--+ Should the Disabled status be pulled from Principals? (select Disabled from Principals where id = '34') Any opinions on making these modifications is appreciated. On Wed, Sep 10, 2008 at 10:08 AM, RT [EMAIL PROTECTED] wrote: RT Users - After some digging, I believe I've discovered why some tickets do not appear when searched by Requestor. It appears that some records are missing from CachedGroupMembers. Can anyone recommend a way of querying for the requestor from GroupMembers and using that to populate CachedGroupMembers? GroupMembers contains the correct requestors -- but that doesn't seem to apply to the standard Search functions. ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: [EMAIL PROTECTED] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
Re: [rt-users] Another Attachment / Mail Problem with RT 3.6.5
Hi Jesse, RT Users, yes i can reproduce it. tryed it several times. Torsten 2008/9/10 Jesse Vincent [EMAIL PROTECTED] On Sep 10, 2008, at 9:14 AM, Ham MI-ID, Torsten Brumm wrote: Hi together, it looks like a bad day for Mail/Attachments Just a few minutes ago a user reports problems with mails he sent out via RT webui with attachments. OK, what i figured out so far: 1. Attachment Size: 800KB (allowed are 8000KB) 2. User added at the reply screen a list of 20 people as cc 3. The list of CC'ed People is 1250 characters long 4. RT shows the mail (Show Outgoing Mail) correctly with all Cc'ed people 5. Users get the mail totally destroyed! Problem: 1. The CC list is cut after 994 characters, in the middle of an address That sure sounds like a 1000 character wrapping issue. Can you reproduce it? 2. The rest of the people from the cc list are the first part of the body 3. The attachment is corrupted. That's due to #2 4. The encoding for content is incorrect, german umlaute are broken. That's due to #2 ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: [EMAIL PROTECTED] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com -- MFG Torsten Brumm http://www.torsten-brumm.de ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: [EMAIL PROTECTED] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
Re: [rt-users] Search for field one equal to field two
Kevin, I believe you are trying to compare fields that are not defined the same. LastUpdatedBy is a numeric field and contains the ID of the user, not the email address. The numeric field will not compare to a character field. Two different types of data. You need to take the UserID from LastUPdatedBy and get the emailaddress of that user and then compare it to the Requestor Emailaddress. The LastUpdated IS the same type as Created, so that compare is OK. Hope this helps. Kenn LBNL On 9/10/2008 5:39 AM, Kevin Squire wrote: I have an RT system running on Debian Stable (RT from the debian repo). I would like to have that follows the logic below - but when I tried it in the Advance search option, I had errors - so my guess is I am missing something and/or don't correctly understand how things work. (my Perl and PostSQL skills come down to copy/paste with a bit of guesstimating) Is what I am thinking even possible? Any help with pointers/reading material will also be appreciated. Queue = 'HelpDesk' AND LastUpdatedBy = Requestor.EmailAddress AND LastUpdated Created ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: [EMAIL PROTECTED] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
Re: [rt-users] Repair CachedGroupMembers? was: 3.8.1 -- Ticket Search doesn't find Requestor?
To whomever (can't find name in address), There might be a way IF the person that created the ticket is always the requestor. IF so, you could walk thru the TICKETS table and take every CREATOR and check to see if there is a MemberID for that CREATOR in the CACHEDGROUPMEMBERS Table for the ticket created. IF not, then you could re-establish the link via CLI OR you could do it manually using WebUI by printing out a list of those Tickets/Creators and using that list to go to each affected ticket and remove/add the correct requestor. I would not recommend re-creating the records with SQL because there may be ACL issues, etc that RT would normally take care of, hence using CLI. That's all I can think of at the moment. Hope this helps. Kenn LBNL On 9/10/2008 9:03 AM, RT wrote: (For some reason, my message was cut off in the previous post.) All - I would like to get opinions on repairing my database using SQL. If there is a more graceful way to accomplish this using the RT perl modules (RT::CachedGroupMembers, etc) any help is appreciated. From the RT Essentials book, we find that in CachedGroupMembers: id == any incremental value GroupId == requestor group id MemberId == MemberId in question (requestor) Via == usually equal to the CachedGroupMembers id ImmediateParentId == requestor group id Disabled == 0 I'm going to work from the values in Ticket #1 (see previous message). insert into CachedGroupMembers values ('', '52', '34', '', '52', '0'); ** And Voila! ** The requestor appears in the regular Search as expected, and is searchable by requestor in Query Builder. And here is what it looks like in the end: mysql select * from CachedGroupMembers where GroupId='52' and MemberId='34' and ImmediateParentId='52'; +---+-+--+--+---+--+ | id| GroupId | MemberId | Via | ImmediateParentId | Disabled | +---+-+--+--+---+--+ | 81550 | 52 | 34 |0 |52 |0 | +---+-+--+--+---+--+ Should the Disabled status be pulled from Principals? (select Disabled from Principals where id = '34') Any opinions on making these modifications is appreciated. ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: [EMAIL PROTECTED] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: [EMAIL PROTECTED] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
Re: [rt-users] Quick Search in 3.8.1 doesn't include Resolved Status
Jesse Vincent [EMAIL PROTECTED] writes: On Fri, Sep 05, 2008 at 10:49:35AM +0200, Espen Wiborg wrote: Jesse Vincent [EMAIL PROTECTED] writes: As I sad before, I'd love to take a patch :) Something like this, perhaps? Given the sorts of customizability people want, it might make sense to let the admin specify SimpleSearchStatuses (so that someone could, say, force it to only resolved). You're actually only a couple lines away from making this a user preference. If you look at lib/RT/Config.pm, you can see the data structire you need to fill in. To get your RT-Config-Get invocation to notice user preferences, you just need to pass in the currentuser object as an extra argument. Right, the attached version of the patch makes SimpleSearchStatuses an absolute configurable, overridable by user preference. For best results, you'll need the patch in http://rt3.fsck.com/Ticket/Display.html?id=12447 as well. One thing, though: With this, I get Use of uninitialized value in join or string at /usr/local/opt/rt3/share/html/Widgets/Form/Select line 74. in the Apache error log. It seems to be something to do with DefaultValue, but I can't figure out how to make it go away... -- Espen Wiborg [EMAIL PROTECTED] Veritas vos liberabit Index: lib/RT/Config.pm === --- lib/RT/Config.pm (revision 15886) +++ lib/RT/Config.pm (working copy) @@ -353,6 +353,23 @@ } } }, +SimpleSearchStatuses = { +Section = 'Search',#loc +Overridable = 1, +SortOrder = 1, +Widget = '/Widgets/Form/Select', +WidgetArguments = { +Multiple= 1, +Description = 'Statuses included in simple search results', #loc +Callback= sub { +my $ret = { +Values = [ RT::Queue-StatusArray ], +DefaultValue = scalar RT-Config-Get('SimpleSearchStatuses'), +}; +return $ret; +}, +}, +}, ); my %OPTIONS = (); Index: lib/RT/Search/Googleish.pm === --- lib/RT/Search/Googleish.pm (revision 15886) +++ lib/RT/Search/Googleish.pm (working copy) @@ -162,7 +162,8 @@ push @tql_clauses, join( OR , sort @id_clauses ); push @tql_clauses, join( OR , sort @owner_clauses ); if ( ! @status_clauses ) { -push @tql_clauses, join( OR , map Status = '$_', RT::Queue-ActiveStatusArray()); +push @tql_clauses, join( OR , map Status = '$_', + RT-Config-Get('SimpleSearchStatuses', $self-TicketsObj-CurrentUser)); } else { push @tql_clauses, join( OR , sort @status_clauses ); } Index: etc/RT_Config.pm.in === --- etc/RT_Config.pm.in (revision 15886) +++ etc/RT_Config.pm.in (working copy) @@ -1323,6 +1323,15 @@ Set(@ActiveStatus, qw(new open stalled)); Set(@InactiveStatus, qw(resolved rejected deleted)); +=item C$SimpleSearchStatuses + +Tickets in these states are included in the results of a simple +search. + +=cut + +Set(@SimpleSearchStatuses, RT-Config-Get('ActiveStatus')); + =item C$LinkTransactionsRun1Scrip RT-3.4 backward compatibility setting. Add/Delete Link used to record one ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: [EMAIL PROTECTED] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
[rt-users] Adding comments using REST and form post, how?
I am working on a tool that, for varoius reasons, need to use the web-available REST interface for its operations. I am currently pulling hairs, due to the fact that all examples I am able to find on using REST, refers to using Perl and the RT::Client:REST module or variations.. I am perfectly able to do a POST request on https://rtserver/REST/1.0/edit with ContentType: form-data and the follwing POST data: id: ticket/12345 status: open owner: newowner priority: 3 .. and thus changing ticket 12345 from a new ticket, with owner Nobody and priority '' to the new values (open/newowner/3) What I am now trying to achieve, is adding transactions, i.e. adding a comment to the ticket, and I hope to be able to do this using the REST interface over HTTP or HTTPS, as I do not have the option of doing this using Perl-code or CLI. Can anyone help me add Comments or Correspondence to RT tickets using HTTP POST forms? -- Jon Langseth, Systems/network administrator, IT-Tjenesten, Høgskolen i Gjøvik (Gjøvik University College) - http://www.hig.no Direkte(direct): +47 61135156 Mobil(cell): +47 95492540 IT-Tjenesten:+47 61135300 Sentralbord: +47 61135100 Fax: +47 61135301 ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: [EMAIL PROTECTED] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
Re: [rt-users] Problem with 'Top N tickets' links on 'RT at a glance' page in 3.8.1
I looked into this some more and after some debugging, I see that the query string argument ($Query) passed in to Search/Results.html is URI encoded when it shouldn't be. It looks like it's encoded properly in the link URL when I 'View Souce' on the displayed 'Home' page but never gets decoded (or it gets decoded and re-encoded somehow). Does anyone have any ideas where I should look next? I'm kinda surprised that there haven't been any other reports of this sort of problem. It seems to affect all saved searches. We're running RT 3.8.1 on a CentOS 5.2 with perl 5.10.0. David Good wrote: I'm seeing an odd problem with the 'Top N tickets' links ('N highest priority tickets I own' and '10 newest unowned tickets') on the 'RT at a glance' page in RT 3.8.1. On the 'RT at a glance' page itself tickets show up as they should but when I click on the link for the search (i.e. click on the '10 highest priority tickets I own' link) I get a 'Found 0 tickets' page. When I click on the 'Edit Search' link, it kicks me into 'Advanced' and I get an error in the 'Results' section: Wrong query, expecting a OPERATOR in '%20Owner%20--here%3D%20%27__CurrentUser__%27%20AND%20(%20Status%20%3D%20%27new%27%20OR%20Status%20%3D%20%27open%27)' And the text in the Query textbox is similarly URI-escaped. If I fix it manually and click 'Apply' I then get the Edit Search page and if I click the Update format and Search button on that page I then get the results I was expecting. But if I then go back to the Home page and try the same link again I get the same problem. The really odd thing is that the 'Bookmarked Tickets' link on the 'RT at a glance' page works fine. Here is the link URI for the 'N highest priority tickets I own' link: http://calhd01.na.local/Search/Results.html?Format=%27%3Ca%20href%3D%22%2FTicket%2FDisplay.html%3Fid%3D__id__%22%3E__id__%3C%2Fa%3E%2FTITLE%3A%23%27%2C%0A%27%3Ca%20href%3D%22%2FTicket%2FDisplay.html%3Fid%3D__id__%22%3E__Subject__%3C%2Fa%3E%2FTITLE%3ASubject%27%2C%0A%27__Priority__%27%2C%0A%27__QueueName__%27%2C%0A%27__ExtendedStatus__%27%2C%0A%27__Bookmark__%27Order=DESC%7CASC%7CASC%7CASCOrderBy=Priority%7CidQuery=%20Owner%20%3D%20%27__CurrentUser__%27%20AND%20(%20Status%20%3D%20%27new%27%20OR%20Status%20%3D%20%27open%27)RowsPerPage=50 and here's the one for the 'Bookmarked Tickets' link: http://calhd01.na.local/Search/Results.html?Format=%27%3Ca%20href%3D%22%2FTicket%2FDisplay.html%3Fid%3D__id__%22%3E__id__%3C%2Fa%3E%2FTITLE%3A%23%27%2C%27%3Ca%20href%3D%22%2FTicket%2FDisplay.html%3Fid%3D__id__%22%3E__Subject__%3C%2Fa%3E%2FTITLE%3ASubject%27%2CPriority%2C%20QueueName%2C%20ExtendedStatus%2C%20BookmarkOrder=DESCOrderBy=LastUpdatedQuery=id%20%3D%20%27__Bookmarked__%27Rows=999 Thanks! David Good ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: [EMAIL PROTECTED] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
Re: [rt-users] Quick Search in 3.8.1 doesn't include Resolved Status
Thanks. I've bounced this to rt-bugs for review and probable application for 3.8.2 -jesse On Sep 10, 2008, at 2:26 PM, Espen Wiborg wrote: Jesse Vincent [EMAIL PROTECTED] writes: On Fri, Sep 05, 2008 at 10:49:35AM +0200, Espen Wiborg wrote: Jesse Vincent [EMAIL PROTECTED] writes: As I sad before, I'd love to take a patch :) Something like this, perhaps? Given the sorts of customizability people want, it might make sense to let the admin specify SimpleSearchStatuses (so that someone could, say, force it to only resolved). You're actually only a couple lines away from making this a user preference. If you look at lib/RT/Config.pm, you can see the data structire you need to fill in. To get your RT-Config-Get invocation to notice user preferences, you just need to pass in the currentuser object as an extra argument. Right, the attached version of the patch makes SimpleSearchStatuses an absolute configurable, overridable by user preference. For best results, you'll need the patch in http://rt3.fsck.com/Ticket/Display.html?id=12447 as well. One thing, though: With this, I get Use of uninitialized value in join or string at /usr/local/opt/rt3/share/html/Widgets/Form/Select line 74. in the Apache error log. It seems to be something to do with DefaultValue, but I can't figure out how to make it go away... -- Espen Wiborg [EMAIL PROTECTED] Veritas vos liberabit rt-customizable- simplesearchstates .patch___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: [EMAIL PROTECTED] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: [EMAIL PROTECTED] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
[rt-users] GraphViz issue in 3.8.1
Just about worked out all the kinks in my 3.8.1 installation before the final transition from 3.4.2. The last one is that when I pull up a ticket and try to view the relationship graph with GraphViz I get the following error in the browser. --- Error during compilation of /opt/rt3/share/html/Ticket/Graphs/index.html: Attempt to reload RT/Graph/Tickets.pm aborted. Compilation failed in require at /opt/rt3/share/html/Ticket/Graphs/index.html line 78. Stack: [/opt/rt3/share/html/Ticket/Graphs/index.html:78] [/opt/rt3/share/html/Ticket/Graphs/index.html:78] [/usr/local/lib/perl5/site_perl/5.10.0/HTML/Mason/Interp.pm:811] [/usr/local/lib/perl5/site_perl/5.10.0/HTML/Mason/Interp.pm:441] [/usr/local/lib/perl5/site_perl/5.10.0/HTML/Mason/Request.pm:246] [/usr/local/lib/perl5/site_perl/5.10.0/HTML/Mason/Request.pm:211] [/usr/local/lib/perl5/site_perl/5.10.0/HTML/Mason/ApacheHandler.pm:97] [/opt/rt3/bin/../lib/RT/Interface/Web/Request.pm:68] [/usr/local/lib/perl5/site_perl/5.10.0/Class/Container.pm:275] [/usr/local/lib/perl5/site_perl/5.10.0/Class/Container.pm:353] [/usr/local/lib/perl5/site_perl/5.10.0/HTML/Mason/Interp.pm:348] [/usr/local/lib/perl5/site_perl/5.10.0/HTML/Mason/ApacheHandler.pm:868] [/usr/local/lib/perl5/site_perl/5.10.0/HTML/Mason/ApacheHandler.pm:822] [/opt/rt3/bin/webmux.pl:148] [/opt/rt3/share/html/Ticket/Graphs/index.html:78] BEGIN failed--compilation aborted at /opt/rt3/share/html/Ticket/Graphs/index.html line 78. Stack: [/opt/rt3/share/html/Ticket/Graphs/index.html:78] [/usr/local/lib/perl5/site_perl/5.10.0/HTML/Mason/Interp.pm:811] [/usr/local/lib/perl5/site_perl/5.10.0/HTML/Mason/Interp.pm:441] [/usr/local/lib/perl5/site_perl/5.10.0/HTML/Mason/Request.pm:246] [/usr/local/lib/perl5/site_perl/5.10.0/HTML/Mason/Request.pm:211] [/usr/local/lib/perl5/site_perl/5.10.0/HTML/Mason/ApacheHandler.pm:97] [/opt/rt3/bin/../lib/RT/Interface/Web/Request.pm:68] [/usr/local/lib/perl5/site_perl/5.10.0/Class/Container.pm:275] [/usr/local/lib/perl5/site_perl/5.10.0/Class/Container.pm:353] [/usr/local/lib/perl5/site_perl/5.10.0/HTML/Mason/Interp.pm:348] [/usr/local/lib/perl5/site_perl/5.10.0/HTML/Mason/ApacheHandler.pm:868] [/usr/local/lib/perl5/site_perl/5.10.0/HTML/Mason/ApacheHandler.pm:822] [/opt/rt3/bin/webmux.pl:148] [/opt/rt3/share/html/Ticket/Graphs/index.html:78] --- There are no other messages being generated and I am logging in debug mode. Install Details. CentOS 5.2 Apache 2.2.9 mod_perl 2.0.4 GraphViz 2.20.2 GraphViz.pm 2.03 Any ideas where to look? Thanks, Todd ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: [EMAIL PROTECTED] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
[rt-users] Email works for AutoReply, and Forwarding but not Resolve or Reply
Working on RT 3.8.0 with a fresh install. Everything seems to be working like a creating a ticket, change status etc. However, when I change the update type to Reply to Requestors, no email is sent, even though the autoreply and forward emails work. Seems like a config issue but I can't seem to find out where to set it. Looking for any advice on where to look. ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: [EMAIL PROTECTED] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
Re: [rt-users] Email works for AutoReply, and Forwarding but not Resolve or Reply
Janice Myint wrote: Working on RT 3.8.0 with a fresh install. Everything seems to be working like a creating a ticket, change status etc. However, when I change the update type to Reply to Requestors, no email is sent, even though the autoreply and forward emails work. Seems like a config issue but I can't seem to find out where to set it. Looking for any advice on where to look. ___ the scrips -- -- Chaim Rieger ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: [EMAIL PROTECTED] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
Re: [rt-users] Fedora Core 9 versus Ubuntu
[EMAIL PROTECTED] wrote: Just an FYI email... We have been using RT 3.6 for a year now. A few months ago we upgraded to 3.8 and ever since the performance on certain actions has been painful. In my opinion it is related to perl, not mysql. Sometimes I can submit a comment using the web interface and I will get the email before the screen refreshes. So, on a whim I installed the latest version of Ubuntu and copied the database over. Oddly enough RT screams! So, I am going to start using Ubuntu instead of Fedora. If anyone wants more details, I can do some version comparisons and such. Does anyone know if this is the problem: http://blog.vipul.net/2008/08/24/redhat-perl-what-a-tragedy/ It would affect Centos5.2 as well. -- Les Mikesell [EMAIL PROTECTED] ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: [EMAIL PROTECTED] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
Re: [rt-users] Email works for AutoReply, and Forwarding but not Resolve or Reply
the scrip for On Resolve is set to the original template, but emails are still not going out unless I'm logged in as root... any clues? On Sep 10, 2008, at 2:50 PM, Chaim Rieger wrote: Janice Myint wrote: Working on RT 3.8.0 with a fresh install. Everything seems to be working like a creating a ticket, change status etc. However, when I change the update type to Reply to Requestors, no email is sent, even though the autoreply and forward emails work. Seems like a config issue but I can't seem to find out where to set it. Looking for any advice on where to look. ___ the scrips -- -- Chaim Rieger ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: [EMAIL PROTECTED] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
Re: [rt-users] Email works for AutoReply, and Forwarding but not Resolve or Reply
Then it sould be premissions --Original Message-- From: Janice Myint To: Chaim Rieger To: rt-users@lists.bestpractical.com Sent: Sep 10, 2008 15:52 Subject: Re: [rt-users] Email works for AutoReply, and Forwarding but not Resolve or Reply the scrip for On Resolve is set to the original template, but emails are still not going out unless I'm logged in as root... any clues? On Sep 10, 2008, at 2:50 PM, Chaim Rieger wrote: Janice Myint wrote: Working on RT 3.8.0 with a fresh install. Everything seems to be working like a creating a ticket, change status etc. However, when I change the update type to Reply to Requestors, no email is sent, even though the autoreply and forward emails work. Seems like a config issue but I can't seem to find out where to set it. Looking for any advice on where to look. ___ the scrips -- -- Chaim Rieger Sent via BlackBerry from T-Mobile ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: [EMAIL PROTECTED] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
Re: [rt-users] Email works for AutoReply, and Forwarding but not Resolve or Reply
thanks again for the advice.. however, I've set the permissions but globally and for the user to have all rights.. email still doesn't get create however.. anything else to check? On Sep 10, 2008, at 3:52 PM, [EMAIL PROTECTED] wrote: Then it sould be premissions --Original Message-- From: Janice Myint To: Chaim Rieger To: rt-users@lists.bestpractical.com Sent: Sep 10, 2008 15:52 Subject: Re: [rt-users] Email works for AutoReply, and Forwarding but not Resolve or Reply the scrip for On Resolve is set to the original template, but emails are still not going out unless I'm logged in as root... any clues? On Sep 10, 2008, at 2:50 PM, Chaim Rieger wrote: Janice Myint wrote: Working on RT 3.8.0 with a fresh install. Everything seems to be working like a creating a ticket, change status etc. However, when I change the update type to Reply to Requestors, no email is sent, even though the autoreply and forward emails work. Seems like a config issue but I can't seem to find out where to set it. Looking for any advice on where to look. ___ the scrips -- -- Chaim Rieger Sent via BlackBerry from T-Mobile ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: [EMAIL PROTECTED] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
Re: [rt-users] Email works for AutoReply, and Forwarding but not Resolve or Reply
Anything in your rt log ? --Original Message-- From: Janice Myint To: [EMAIL PROTECTED] Cc: rt-users@lists.bestpractical.com Sent: Sep 10, 2008 16:02 Subject: Re: [rt-users] Email works for AutoReply, and Forwarding but not Resolve or Reply thanks again for the advice.. however, I've set the permissions but globally and for the user to have all rights.. email still doesn't get create however.. anything else to check? On Sep 10, 2008, at 3:52 PM, [EMAIL PROTECTED] wrote: Then it sould be premissions --Original Message-- From: Janice Myint To: Chaim Rieger To: rt-users@lists.bestpractical.com Sent: Sep 10, 2008 15:52 Subject: Re: [rt-users] Email works for AutoReply, and Forwarding but not Resolve or Reply the scrip for On Resolve is set to the original template, but emails are still not going out unless I'm logged in as root... any clues? On Sep 10, 2008, at 2:50 PM, Chaim Rieger wrote: Janice Myint wrote: Working on RT 3.8.0 with a fresh install. Everything seems to be working like a creating a ticket, change status etc. However, when I change the update type to Reply to Requestors, no email is sent, even though the autoreply and forward emails work. Seems like a config issue but I can't seem to find out where to set it. Looking for any advice on where to look. ___ the scrips -- -- Chaim Rieger Sent via BlackBerry from T-Mobile Sent via BlackBerry from T-Mobile ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: [EMAIL PROTECTED] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
Re: [rt-users] Email works for AutoReply, and Forwarding but not Resolve or Reply
Hi Janice, If the person creating the transaction is the requestor, then by default RT will not Reply (even if the selected action is Reply to Requestor); that seems to be one of the main differences between Autoreply and Reply. If your case is not one where the requestor is the transaction creator, then this doesn't apply to you. Otherwise... You can change this behavior by setting the NotifyActor variable in your RT_SiteConfig file: Set($NotifyActor, 1); Regards, Gene At 02:28 PM 9/10/2008, Janice Myint wrote: Working on RT 3.8.0 with a fresh install. Everything seems to be working like a creating a ticket, change status etc. However, when I change the update type to Reply to Requestors, no email is sent, even though the autoreply and forward emails work. Seems like a config issue but I can't seem to find out where to set it. Looking for any advice on where to look. -- Gene LeDuc, GSEC Security Analyst San Diego State University ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: [EMAIL PROTECTED] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
Re: [rt-users] Email works for AutoReply, and Forwarding but not Resolve or Reply
Hi Gene, Thank you SO much!!! That totally worked. I owe you one. :) Take Care, Janice On Sep 10, 2008, at 4:17 PM, Gene LeDuc wrote: Hi Janice, If the person creating the transaction is the requestor, then by default RT will not Reply (even if the selected action is Reply to Requestor); that seems to be one of the main differences between Autoreply and Reply. If your case is not one where the requestor is the transaction creator, then this doesn't apply to you. Otherwise... You can change this behavior by setting the NotifyActor variable in your RT_SiteConfig file: Set($NotifyActor, 1); Regards, Gene At 02:28 PM 9/10/2008, Janice Myint wrote: Working on RT 3.8.0 with a fresh install. Everything seems to be working like a creating a ticket, change status etc. However, when I change the update type to Reply to Requestors, no email is sent, even though the autoreply and forward emails work. Seems like a config issue but I can't seem to find out where to set it. Looking for any advice on where to look. -- Gene LeDuc, GSEC Security Analyst San Diego State University ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: [EMAIL PROTECTED] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
[rt-users] Upgraded RT and Ubuntu and now Apache2 can't find RT::Mason
I'm a Linux newbie. I'm running Ubuntu 8.04 (I just upgraded from 7.0.4). I am running RT 3.8.1 (I just upgraded from 3.6). I happen to be running TikiWiki on this server and it's working just fine (so, at least I know that Apache is working - and the server is serving Web pages in general). My Apache2 error log shows that it can't find RT::Mason. I noticed that my old apache config referenced a file 'webmux.pl' - which didn't exist in /opt/rt3.8/bin/ and did exist in /etc/request-tracker3.6/bin/. So, I copied the file to /opt/rt3.8/bin and updated the Apache Config to reference the new file location. So, if I comment out the webmux.pl line in the Apache config - I get a 404 error. If I leave it in, I get a 500 Internal Server error. I feel like I've been very high maintenance with this upgrade. I can't tell you all how extremely helpful you've been! Thanks all, -Chris ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: [EMAIL PROTECTED] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com