Re: [rt-users] RT on Oracle - ORA-04043 object Attachments does not exist
Nick Yonko wrote: > That was my initial thought, but when I log into the database using the rt > user with sqlplus, as the account that runs the apache daemon no less, I can > issue a 'desc attachments' command and a 'desc "Attachments"' command and > both return the table structure. Can you turn on sql logging within RT? This might give you a clue as to what exact statement is causing the ora-04043 error Regards, Joop ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: sa...@bestpractical.com Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
[rt-users] R: R: RT Queue Subject Tag problem
Hi Jesse! First of all, thank you for your response. Unfortunately, it seems it is not working. On a test system (RT 3.8.2) we have two "incoming" queues: DBA and SCHEDU. I have set the subject tag for the DBA queue as "DBA", while the subject tag for the SCHEDU queue is "SCHD". In the RT_SiteConfig i have: Set($rtname , "SCHEDULAZIONE"); Set($ExtractSubjectTagMatch, qr/\[(?:DBA|SCHD) #\d+\]/); I have restarted apache, then I created a test ticket in both queues (using the "quick ticket creation" panel). BOTH of these ticket came out as having [SCHEDULAZIONE #] in the subject of the email, i.e. they both have the $rtname instead of the intended subject tag. We are running 3.8.2 both in production and in test. Is this a show-stopper? Should we upgrade to 3.8.3 to have the functionality? Or am I misunderstanding the intended behaviour of the subject tag setting? Thank you in advance! Bye Cris -Messaggio originale- Da: Jesse Vincent [mailto:je...@bestpractical.com] Inviato: venerdì 29 maggio 2009 22.59 A: Guadagnino Cristiano Cc: rt-users@lists.bestpractical.com; jer...@umbc.edu Oggetto: Re: [rt-users] R: RT Queue Subject Tag problem On Fri, May 29, 2009 at 12:22:15PM +0200, Guadagnino Cristiano wrote: > Hi all, > I am having the same problem as Jeremy here. Nobody replied since january... > can somebody help please? > > We just added some queues to out RT installation; these queues are to be used > by an entirely new set of users, and we need then to have a different subject > tag. > > If I understand correctly, the default subject tag is taken by the $rtname > variable. So I changed the "subject tag" field in the queues, which was > previously unset. RT tells me it has saved the value, but if I reenter the > queue configuration panel I see mixed results: sometimes I see "subject tag" > field empty, and sometimes I see it populated with what I have set. > The behaviour also seems to be unconsistent: sometimes it uses the subject > tag I have set, sometimes (90% of times) it uses the $rtname. > > I have looked at the database (MySQL here), and I also see that the only > place where the value is apparently stored is in the "attributes" table. > > Is this a known bug? > It's an interaction with the ExtractSubjectTag scrip. I believe that if you add all your subject tags to ExtractSubjectTagMatch in RT_SiteConfig, that will take care of it. I also _Thought_ this was sorted out for 3.8.3, but someone who actually had code in the release can likely correct me on that ;) ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: sa...@bestpractical.com Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
Re: [rt-users] RT 3.8.2 -> 3.8.3 Update/Changes
On Mon, Jun 01, 2009 at 01:53:38PM -0400, Jesse Vincent wrote: > > > > Second, I just wanted to point out to folks that use > > WebExternalAuth, and potentially the companion > > WebFallbackToInternalAuth, that it has been reversed. In RT 3.8.2, > > it was "...is undefined, the user..." and in 3.8.3, it is now "...is > > defined, the user..." so please be careful. > > My recollection is that this was a documentation fix, not a change in > actual behaviour. > I confirm, see svn 17865 and rt ticket 12478. ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: sa...@bestpractical.com Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
[rt-users] Tickets with Owner= (no value)
Good morning, Yesterday I removed a user (within MySQL) had several assigned tickets. Now these have Owner= (no value). I have tested next: 1.- MySQL query, but I cannot select because Owner= (no value) 2.- In RT: new Search / Batch update / (I cannot because RT says "Only you can assign tickets that they haven't Owner or it's Nobody") Could I tell me how I assign the new owner? Best regards, ALBERTO VILLANUEVA DEL VAL Consultant Altran Technologies ParqueEmpresarial Las Mercedes, Edificio 1 Campezo Street, 1- 28022 - Madrid, Spain Tel: + 34 91 744 46 00 - Ext: 2205 Fax: + 34 91 415 24 57 www.altran.es ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: sa...@bestpractical.com Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
Re: [rt-users] Help with RT Groups and LDAP group.
Tue 02 Jun 2009 23:16:38 GMT Kevin Gagel wrote: > I've got the ldap plug in working but I seem to have a disconnect > between root and ldap users. What I mean is that I can login to RT using > my ldap credentials but I have nothing available except tickets to open, > close and new tickets. The root account is still available and when I > login with that I can configure rights but my ldap users don't appear > unless I do a search for them specifically. Some rights cannot be > assigned because the ldap account does not appear in the list of choices > to add a right to. > > Can someone point me in the right direction here please? Your LDAP users are being auto-created as Unprivileged which means they see the SelfService screen, not the staff/privileged user interface. Also the default user list only shows privileged users. If you want to see all users search for % If you want LDAP users to be automatically created as privileged then you need to set: Set($AutoCreate, {Privileged => 1}) If you just want selected LDAP users to be privileged then search for the user, go into their settings and set "Allow this user to be granted rights". -- Kind Regards, __ Mike Peachey, IT Tel: +44 114 281 2655 Fax: +44 114 281 2951 Jennic Ltd, Furnival Street, Sheffield, S1 4QT, UK Comp Reg No: 3191371 - Registered In England http://www.jennic.com __ ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: sa...@bestpractical.com Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
[rt-users] admin cc not receiving mail
Hi, Been googling for 2 weeks with no success. I have an issue with admin cc. I am listed as admin cc of a queue. If someone adds a comment to a ticket i receive the correspondence, however if someone emails a comment the correspondence is not sent out to admin cc's Is this the standard way it should work? I would like all transacations on a particular queue to be sent to the admin cc's. Is this possible? Bashir ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: sa...@bestpractical.com Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
Re: [rt-users] RT 3.8.2 -> 3.8.3 Update/Changes
Is a database upgrade needed? When we went from 3.8.2 to .3 it failed saying that group something id already exists. Thanks. On 01/06/2009, Jesse Vincent wrote: > > >> Second, I just wanted to point out to folks that use WebExternalAuth, and >> potentially the companion WebFallbackToInternalAuth, that it has been >> reversed. In RT 3.8.2, it was "...is undefined, the user..." and in >> 3.8.3, it is now "...is defined, the user..." so please be careful. > > My recollection is that this was a documentation fix, not a change in > actual behaviour. > > > ___ > http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users > > Community help: http://wiki.bestpractical.com > Commercial support: sa...@bestpractical.com > > > Discover RT's hidden secrets with RT Essentials from O'Reilly Media. > Buy a copy at http://rtbook.bestpractical.com > -- Sent from my mobile device http://www.suretecsystems.com/services/openldap/ http://www.suretectelecom.com ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: sa...@bestpractical.com Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
Re: [rt-users] Storing custom field file to local file system
Thanks Tom - but actually my custom field IS defined as "Upload one file" (or an attachment). My problem is saving that attachment from RT to /tmp (for manipulation from command-line script). There must be some non-http method of extracting the attachment to a file? -Original Message- From: Tom Lahti To: BJ Blanchard Cc: RT-Users@lists.bestpractical.com Subject: Re: [rt-users] Storing custom field file to local file system Date: Tue, 02 Jun 2009 13:42:07 -0700 > my $url = RT->Config->Get('WebPath') . > "/Download/CustomFieldValue/".$cf->Id.'/'.$cf->Content; > getstore($url,"/tmp/temp.odt"); > > Or perhaps more easily put: How do you extract a file from a custom > field and store it on the local file system? Since the custom field just names the file, set up a separate name space in your web server (Apache?) that doesn't go through RT to fetch the document through with getstore(). my $url = "http://not-rt.server.com/some/dir/"; . $cf->Content; getstore($url...); If you need to secure it better make sure not-rt.server.com isn't publicly available, or use "localhost" and clamp that down in Apache config, or whatever. If you need RT to authenticate document access, then you're better off storing the document as an attachment. ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: sa...@bestpractical.com Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
Re: [rt-users] Only Plain Text Mails.
On Jun 1, 2009, at 8:18 PM, Rana Tanveer wrote: > Hi Kavin > > > I have tried hard to implement according to your advise. but > unfortunately it does not work or may i did something wrong. > http://code.bestpractical.com/bps-public/rt/3.8/trunk/docs/templates.pod > > can you please give me some exact example so that i use that with > little modification. > > I have spent 10 hours for this task to sent mails in text/html. You appear to have missed the important part of that URL =item Content-Type: text/html The special header "Content-Type: text/html" tells RT that the template should be parsed as HTML. RT will automatically make the outgoing message multipart. That way, recipients who can read only plaintext email will receive something readable, while users with clients which can display HTML will receive the full experience. Please be aware that HTML support in mail clients varies greatly, much more so than different web browsers. We welcome contributions of HTML-ization of builtin templates. =back You didn't provide examples of what you tried, which makes it difficult to tell you what broke. -kevin > > > i am thinking about to modify SendEmail.pm, as this was not the > right way to deal with so i did not change this file. as it is > clearly mentioned here that for security reason we only send textual > mails. > > can you please help ? > > Part of the > /usr/lib/perl5/vendor_perl/5.10.0/RT/Action/SendEmail.pm > # For security reasons, we only send out textual mails. > foreach my $part ( grep !$_->is_multipart, $MIMEObj->parts_DFS ) { > . > . > . > > On May 31, 2009, at 12:32 AM, Rana Tanveer wrote: > > > I am using RT 3.8.2, but RT is sending only plain text messages. > > Please read docs/templates.pod in your RT tarball which > describes the steps necessary to generate outgoing HTML > email (the settings below only affect display of mail within > RT) > > -kevin > > > > > > i used below setting but same result. > > > > Set($PreferRichText, 1); > > Set($MessageBoxRichText, 1); > > Set($MessageBoxRichTextHeight, 200); > > > > I even try to search mailing lists but no luck. > > > > could anyone guide me what is wrong, or what might should i have to > > use ? > > > > -- > > - > > Rana Tanveer > > +923224194457 > > http://www.sysadminsline.com > > - > > On Sun, May 31, 2009 at 10:32 AM, Rana Tanveer > wrote: > Hi Every one. > > I am using RT 3.8.2, but RT is sending only plain text messages. > > i used below setting but same result. > > Set($PreferRichText, 1); > Set($MessageBoxRichText, 1); > Set($MessageBoxRichTextHeight, 200); > > I even try to search mailing lists but no luck. > > could anyone guide me what is wrong, or what might should i have to > use ? > > -- > - > Rana Tanveer > +923224194457 > http://www.sysadminsline.com > - > > > > -- > - > Rana Tanveer > +923224194457 > http://www.sysadminsline.com > - > ___ > http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users > > Community help: http://wiki.bestpractical.com > Commercial support: sa...@bestpractical.com > > > 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: sa...@bestpractical.com Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
Re: [rt-users] Custom Fields in Update.html view
On Jun 1, 2009, at 11:34 PM, Stephen Cochran wrote: > Custom fields are displayed in Update.html (reached by clicking on > Comment, Reply, or Resolve). Are they supposed to be modifiable in > that interface? I don't see anything in Update.html that would be > saving their settings, though I don't recognize the form submission > handling in Update.html. > > I know the ticket status and owners are saved, but CFs dont' seem to > be. Sounds like you have an incomplete local modification RT only displays Transaction Custom Fields on that page, not Ticket Custom Fields -kevin ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: sa...@bestpractical.com Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
Re: [rt-users] 3.8.2 message display bug reappears in 3.8.3
On Jun 2, 2009, at 5:28 AM, Jo Rhett wrote: > I reported this message display bug about 3 months ago, Kevin agreed > with the fix, but it's still present in 3.8.3. Without this fix, if > you click "Show" next to an outgoing mail message, regardless of your > preference settings, text paragraphs are a single long line. I don't recall agreeing with the fix, but I did ask for it to end up in the bug tracker so it could be tracked. Its currently slated for review for 3.8.4 http://rt3.fsck.com/Ticket/Display.html?id=13230 As I recall, during triage for 3.8.3 I couldn't immediately replicate the problem you were solving so we left it for further review when we had a little more time to replicate. -kevin > > > --- ShowEmailRecord.html_orig 2009-02-23 16:55:17.0 -0800 > +++ ShowEmailRecord.html2009-02-23 16:56:22.0 -0800 > -65,7 +65,7 > my $show; > $show = sub { > my $attach = shift; > -$m->out( '' ); > +$m->out( '' ); > $m->out( $m->interp->apply_escapes( $attach->Headers, 'h' ) ); > $m->out( "\n\n" ); > if ( $attach->ContentType =~ m{^multipart/}i ) { > -76,7 +76,7 > } else { > $show_content->( $attach ); > } > -$m->out( '' ); > +$m->out( '' ); > }; > > my $AttachmentObj = new RT::Attachment($session{'CurrentUser'}); > > -- > Jo Rhett > Net Consonance : consonant endings by net philanthropy, open source > and other randomness > > > > ___ > http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users > > Community help: http://wiki.bestpractical.com > Commercial support: sa...@bestpractical.com > > > 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: sa...@bestpractical.com Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
Re: [rt-users] RT::User::MergeInto Unimplemented in HTML::Mason::Commands
On Jun 2, 2009, at 2:41 PM, Jeff Lucas wrote: > I’ve installed RT-Extension-MergeUsers-0.03_02 but get the following > when trying to use it from the User account page… > > RT::User::MergeInto Unimplemented in HTML::Mason::Commands. (/apps/ > rt-3.8.2/share/html/Callbacks/RT-Extension-MergeUsers/Admin/Users/ > Modify.html/RightColumnBottom line 71) > > > My install is a bit unusual in that I have RT installed in /apps as > follows… > # find /apps/rt-3.8.2/ -name \*erge\* > /apps/rt-3.8.2/man/auto/RT/Extension/MergeUsers > /apps/rt-3.8.2/man/man3/RT::Extension::MergeUsers.3pm > /apps/rt-3.8.2/lib/RT/Extension/MergeUsers.pm I wonder what else is unusual about your install, I'd expect MergeUsers.pm and all the callbacks to live in: /apps/rt-3.8.2/local/plugins/RT-Extension-MergeUsers/ Otherwise, Set(@Plugins) won't be able to properly load it. -kevin > /apps/rt-3.8.2/share/html/REST/1.0/ticket/merge > /apps/rt-3.8.2/share/html/REST/1.0/Forms/ticket/merge > /apps/rt-3.8.2/share/html/Callbacks/RT-Extension-MergeUsers > /apps/rt-3.8.2/bin/rt-update-merged-users > /apps/rt-3.8.2/bin/rt-merge-users > /apps/rt-3.8.2/var/mason_data/obj/2362954981/standard/Callbacks/RT- > Extension-MergeUsers > > # grep -i merge /apps/rt-3.8.2/etc/* > /apps/rt-3.8.2/etc/RT_Config.pm: debug info notice warning error > critical alert emergency > /apps/rt-3.8.2/etc/RT_SiteConfig.pm:Set(@Plugins, > qw(RT::Extension::MergeUsers)); > > I’m not sure if my non-standard install location is the problem or > not. > > TIA. > > -Jeff > ___ > http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users > > Community help: http://wiki.bestpractical.com > Commercial support: sa...@bestpractical.com > > > 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: sa...@bestpractical.com Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
Re: [rt-users] Creating Tickets Via Email
On Jun 2, 2009, at 4:22 PM, Nick Coronado wrote: > I looked up the Email Integration document under the wiki pages. I > followed the steps and was able to perform the following: > cat testfile | /usr/bin/rt-mailgate --debug Exchange --action > correspond –url http://rt.isncom.com > > > AND RECEIVED: > > Connecting to http://rt.isncom.com/REST/1.0/NoAuth/mail-gateway at / > usr/bin/rt-mailgate line 99, <> line 1. > okTicket: 12648Queue: Owner: NobodyStatus: rejectedSubject: testing > ticketRequestor: at /usr/bin/rt-mailgate line 108, <> line 1. > > > In order to keep the ticket from being rejected when I use the web > interface I have to have the following fields: > > 1. mandatory customer ID > 2. support level > 3. severity > > If the whole point is for a user to be able to email an issue and > have it create a ticket how could I do this without getting the > ticket rejected? Do you have a customization to reject tickets if those Custom Fields aren't filled out? It appears there is something setting the status to Rejected. RT's Custom Field validation code prevents ticket creation in the web ui, but not in the mailgate for precisely this reason. -kevin > > Basically, instead of having customer service deal with so many > calls we would like users to be able to create their own tickets. ? > Has anyone dealt with this issue before? > ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: sa...@bestpractical.com Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
Re: [rt-users] RT 3.8.2 -> 3.8.3 Update/Changes
On Jun 3, 2009, at 6:43 AM, Gavin Henry wrote: > Is a database upgrade needed? When we went from 3.8.2 to .3 it failed > saying that group something id already exists. Yes, there is a database upgrade involved. Please send the full error message and the command you use to rt-b...@bestpractical.com so we can review it. There were no groups created between 3.8.2 and 3.8.3 so I wonder what happened. -kevin > On 01/06/2009, Jesse Vincent wrote: >> >> >>> Second, I just wanted to point out to folks that use >>> WebExternalAuth, and >>> potentially the companion WebFallbackToInternalAuth, that it has >>> been >>> reversed. In RT 3.8.2, it was "...is undefined, the user..." and in >>> 3.8.3, it is now "...is defined, the user..." so please be careful. >> >> My recollection is that this was a documentation fix, not a change in >> actual behaviour. >> >> >> ___ >> http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users >> >> Community help: http://wiki.bestpractical.com >> Commercial support: sa...@bestpractical.com >> >> >> Discover RT's hidden secrets with RT Essentials from O'Reilly Media. >> Buy a copy at http://rtbook.bestpractical.com >> > > -- > Sent from my mobile device > > http://www.suretecsystems.com/services/openldap/ > http://www.suretectelecom.com > ___ > http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users > > Community help: http://wiki.bestpractical.com > Commercial support: sa...@bestpractical.com > > > 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: sa...@bestpractical.com Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
Re: [rt-users] Storing custom field file to local file system
On Jun 3, 2009, at 7:23 AM, BJ Blanchard wrote: > Thanks Tom - but actually my custom field IS defined as "Upload one > file" (or an attachment). > My problem is saving that attachment from RT to /tmp (for > manipulation from command-line script). > There must be some non-http method of extracting the attachment to > a file? Look at Download/CustomFieldValue/dhandler You need to get an ObjectCustomFieldValue object and then fetch the LargeContent -kevin > > > -Original Message- > From: Tom Lahti > To: BJ Blanchard > Cc: RT-Users@lists.bestpractical.com > Subject: Re: [rt-users] Storing custom field file to local file system > Date: Tue, 02 Jun 2009 13:42:07 -0700 > > > my $url = RT->Config->Get('WebPath') . > > "/Download/CustomFieldValue/".$cf->Id.'/'.$cf->Content; > > getstore($url,"/tmp/temp.odt"); > > > > Or perhaps more easily put: How do you extract a file from a custom > > field and store it on the local file system? > > Since the custom field just names the file, set up a separate name > space in > your web server (Apache?) that doesn't go through RT to fetch the > document > through with getstore(). > > my $url = "http://not-rt.server.com/some/dir/"; . $cf->Content; > getstore($url...); > > If you need to secure it better make sure not-rt.server.com isn't > publicly > available, or use "localhost" and clamp that down in Apache config, > or whatever. > > If you need RT to authenticate document access, then you're better off > storing the document as an attachment. > > ___ > http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users > > Community help: http://wiki.bestpractical.com > Commercial support: sa...@bestpractical.com > > > 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: sa...@bestpractical.com Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
Re: [rt-users] RT 3.8.2 -> 3.8.3 Update/Changes
Will do, thanks. On 03/06/2009, Kevin Falcone wrote: > > On Jun 3, 2009, at 6:43 AM, Gavin Henry wrote: > >> Is a database upgrade needed? When we went from 3.8.2 to .3 it failed >> saying that group something id already exists. > > Yes, there is a database upgrade involved. > > Please send the full error message and the command you use > to rt-b...@bestpractical.com so we can review it. > > There were no groups created between 3.8.2 and 3.8.3 so I wonder > what happened. > > -kevin > >> On 01/06/2009, Jesse Vincent wrote: >>> >>> Second, I just wanted to point out to folks that use WebExternalAuth, and potentially the companion WebFallbackToInternalAuth, that it has been reversed. In RT 3.8.2, it was "...is undefined, the user..." and in 3.8.3, it is now "...is defined, the user..." so please be careful. >>> >>> My recollection is that this was a documentation fix, not a change in >>> actual behaviour. >>> >>> >>> ___ >>> http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users >>> >>> Community help: http://wiki.bestpractical.com >>> Commercial support: sa...@bestpractical.com >>> >>> >>> Discover RT's hidden secrets with RT Essentials from O'Reilly Media. >>> Buy a copy at http://rtbook.bestpractical.com >>> >> >> -- >> Sent from my mobile device >> >> http://www.suretecsystems.com/services/openldap/ >> http://www.suretectelecom.com >> ___ >> http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users >> >> Community help: http://wiki.bestpractical.com >> Commercial support: sa...@bestpractical.com >> >> >> 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: sa...@bestpractical.com > > > Discover RT's hidden secrets with RT Essentials from O'Reilly Media. > Buy a copy at http://rtbook.bestpractical.com > -- Sent from my mobile device http://www.suretecsystems.com/services/openldap/ http://www.suretectelecom.com ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: sa...@bestpractical.com Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
Re: [rt-users] TransactionBatch Question
On Mon, 01 Jun 2009 18:19:35 -0400, Ruslan Zakirov wrote: > Steve, sorry, but I can't say that I fully understand your > description, but conditions of batch scrips tested on every > transaction in a batch, but process stops as soon as we find a match. > We don't want to fire the same scrip multiple times on the same batch. > > For example batch has status, queue and two cfs change. > * If a condition fires its scrip on correspond then the scrip action > wouldn't be applied. All txns in the batch would be checked against > the condition. > * if a condition fires its scrip on queue change then the scrip action > would be applied and default transaction accessor will point to queue > change. The condition wouldn't be checked against cf changes. > * if a condition fires its scrip on any cf change then the scrip > action would be applied and default transaction accessor will point to > the first cf change. The condition wouldn't be checked against other > transacactions after the first change in a cf. > > Something like that, hope it helps. > > >> >> Steve >> > > > I think I've got it now! Thanks for your help Ruslan, Steve -- Stephen Turner Sr. Analyst/Programmer MIT IS&T - SAIS ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: sa...@bestpractical.com Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
Re: [rt-users] RT 3.8.2 -> 3.8.3 Update/Changes
I see a database upgrade for postgres, but nothing for mysql going from 3.8.2 to 3.8.3. Perhaps I'm missing something... James Moseley Kevin Falcone wrote: Yes, there is a database upgrade involved. ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: sa...@bestpractical.com Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
Re: [rt-users] RT 3.8.2 -> 3.8.3 Update/Changes
On Jun 3, 2009, at 9:18 AM, jmose...@corp.xanadoo.com wrote: > I see a database upgrade for postgres, but nothing for mysql going > from > 3.8.2 to 3.8.3. Perhaps I'm missing something... etc/upgrade/3.8.3/content It isn't a schema change, but it upgrades things in the database. -kevin > > > > James Moseley > > > > Kevin Falcone wrote: > > > > > Yes, there is a database upgrade involved. > > > > > > ___ > http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users > > Community help: http://wiki.bestpractical.com > Commercial support: sa...@bestpractical.com > > > 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: sa...@bestpractical.com Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
Re: [rt-users] RT 3.8.2 -> 3.8.3 Update/Changes
Yeah, we use Pg. We got 'relation 'groupmembers1' already exists. On 03/06/2009, jmose...@corp.xanadoo.com wrote: > I see a database upgrade for postgres, but nothing for mysql going from > 3.8.2 to 3.8.3. Perhaps I'm missing something... > > > James Moseley > > > > Kevin Falcone wrote: > > > > > Yes, there is a database upgrade involved. > > > > > > ___ > http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users > > Community help: http://wiki.bestpractical.com > Commercial support: sa...@bestpractical.com > > > Discover RT's hidden secrets with RT Essentials from O'Reilly Media. > Buy a copy at http://rtbook.bestpractical.com > -- Sent from my mobile device http://www.suretecsystems.com/services/openldap/ http://www.suretectelecom.com ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: sa...@bestpractical.com Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
Re: [rt-users] RT 3.8.2 -> 3.8.3 Update/Changes
On Jun 3, 2009, at 9:20 AM, Gavin Henry wrote: > Yeah, we use Pg. > We got 'relation 'groupmembers1' already exists. Oh, thats ok. We added an index that existed on MySQL but not on Pg, but if you do your own database tuning there is always a chance we'll conflict with you. Pointers to portable, simple and back- compatible ways of detecting indexes appreciated. You may want to run /opt/rt3/sbin/rt-setup-database --action insert --datadir etc/upgrade/ 3.8.3 manually if the upgrade errored out after the failed index. Or just delete schema.Pg and let --action upgrade do the magic -kevin > > > On 03/06/2009, jmose...@corp.xanadoo.com > wrote: >> I see a database upgrade for postgres, but nothing for mysql going >> from >> 3.8.2 to 3.8.3. Perhaps I'm missing something... >> >> >> James Moseley >> >> >> >> Kevin Falcone wrote: >> >> >> >> >> Yes, there is a database upgrade involved. >> >> >> >> >> >> ___ >> http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users >> >> Community help: http://wiki.bestpractical.com >> Commercial support: sa...@bestpractical.com >> >> >> Discover RT's hidden secrets with RT Essentials from O'Reilly Media. >> Buy a copy at http://rtbook.bestpractical.com >> > > -- > Sent from my mobile device > > http://www.suretecsystems.com/services/openldap/ > http://www.suretectelecom.com > ___ > http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users > > Community help: http://wiki.bestpractical.com > Commercial support: sa...@bestpractical.com > > > 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: sa...@bestpractical.com Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
Re: [rt-users] RT 3.8.2 -> 3.8.3 Update/Changes
Great, thanks! Will run that later and report back. On 03/06/2009, Kevin Falcone wrote: > > On Jun 3, 2009, at 9:20 AM, Gavin Henry wrote: > >> Yeah, we use Pg. >> We got 'relation 'groupmembers1' already exists. > > Oh, thats ok. We added an index that existed on MySQL but not on Pg, > but if you do your own database tuning there is always a chance > we'll conflict with you. Pointers to portable, simple and back- > compatible > ways of detecting indexes appreciated. > > You may want to run > > /opt/rt3/sbin/rt-setup-database --action insert --datadir etc/upgrade/ > 3.8.3 > > manually if the upgrade errored out after the failed index. > Or just delete schema.Pg and let --action upgrade do the magic > > -kevin > >> >> >> On 03/06/2009, jmose...@corp.xanadoo.com >> wrote: >>> I see a database upgrade for postgres, but nothing for mysql going >>> from >>> 3.8.2 to 3.8.3. Perhaps I'm missing something... >>> >>> >>> James Moseley >>> >>> >>> >>> Kevin Falcone wrote: >>> >>> >>> >>> >>> Yes, there is a database upgrade involved. >>> >>> >>> >>> >>> >>> ___ >>> http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users >>> >>> Community help: http://wiki.bestpractical.com >>> Commercial support: sa...@bestpractical.com >>> >>> >>> Discover RT's hidden secrets with RT Essentials from O'Reilly Media. >>> Buy a copy at http://rtbook.bestpractical.com >>> >> >> -- >> Sent from my mobile device >> >> http://www.suretecsystems.com/services/openldap/ >> http://www.suretectelecom.com >> ___ >> http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users >> >> Community help: http://wiki.bestpractical.com >> Commercial support: sa...@bestpractical.com >> >> >> 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: sa...@bestpractical.com > > > Discover RT's hidden secrets with RT Essentials from O'Reilly Media. > Buy a copy at http://rtbook.bestpractical.com > -- Sent from my mobile device http://www.suretecsystems.com/services/openldap/ http://www.suretectelecom.com ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: sa...@bestpractical.com Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
Re: [rt-users] R: R: RT Queue Subject Tag problem
Can you please test on 3.8.3? On Wed, Jun 03, 2009 at 10:30:27AM +0200, Guadagnino Cristiano wrote: > Hi Jesse! > First of all, thank you for your response. > > Unfortunately, it seems it is not working. > On a test system (RT 3.8.2) we have two "incoming" queues: DBA and SCHEDU. I > have set the subject tag for the DBA queue as "DBA", while the subject tag > for the SCHEDU queue is "SCHD". > > In the RT_SiteConfig i have: > > Set($rtname , "SCHEDULAZIONE"); > Set($ExtractSubjectTagMatch, qr/\[(?:DBA|SCHD) #\d+\]/); > > I have restarted apache, then I created a test ticket in both queues (using > the "quick ticket creation" panel). BOTH of these ticket came out as having > [SCHEDULAZIONE #] in the subject of the email, i.e. they both have the > $rtname instead of the intended subject tag. > > We are running 3.8.2 both in production and in test. Is this a show-stopper? > Should we upgrade to 3.8.3 to have the functionality? Or am I > misunderstanding the intended behaviour of the subject tag setting? > > Thank you in advance! > > Bye > Cris > > > > -Messaggio originale- > Da: Jesse Vincent [mailto:je...@bestpractical.com] > Inviato: venerdì 29 maggio 2009 22.59 > A: Guadagnino Cristiano > Cc: rt-users@lists.bestpractical.com; jer...@umbc.edu > Oggetto: Re: [rt-users] R: RT Queue Subject Tag problem > > > > > On Fri, May 29, 2009 at 12:22:15PM +0200, Guadagnino Cristiano wrote: > > Hi all, > > I am having the same problem as Jeremy here. Nobody replied since > > january... can somebody help please? > > > > We just added some queues to out RT installation; these queues are to be > > used by an entirely new set of users, and we need then to have a different > > subject tag. > > > > If I understand correctly, the default subject tag is taken by the $rtname > > variable. So I changed the "subject tag" field in the queues, which was > > previously unset. RT tells me it has saved the value, but if I reenter the > > queue configuration panel I see mixed results: sometimes I see "subject > > tag" field empty, and sometimes I see it populated with what I have set. > > The behaviour also seems to be unconsistent: sometimes it uses the subject > > tag I have set, sometimes (90% of times) it uses the $rtname. > > > > I have looked at the database (MySQL here), and I also see that the only > > place where the value is apparently stored is in the "attributes" table. > > > > Is this a known bug? > > > > It's an interaction with the ExtractSubjectTag scrip. I believe that > if you add all your subject tags to ExtractSubjectTagMatch in > RT_SiteConfig, that will take care of it. I also _Thought_ this was > sorted out for 3.8.3, but someone who actually had code in the release > can likely correct me on that ;) > -- ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: sa...@bestpractical.com Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
Re: [rt-users] How to Migrate the Bugzilla Ticket Description into Request Tracker
Content of tickets is organized as MIME parts in attachments table. Each attachment may have a parent and sticketed to a transaction. Transactions with attachments usually have Create, Correspond or Comment type. What else do you want to know? On Tue, Jun 2, 2009 at 7:23 PM, Kwasi Date-Bah wrote: > Issue > > > > My colleague and I have mostly completed the migration of our company > bugzilla database to request tracker. > > The issue I am currently encountering is that although the tickets have > migrated across, the actual body content > of the ticket has not migrated across. > > > > I have seen that the detail for a ticket should be held in the attachments > table. > > I would really appreciate any advise that you can offer me. > > > > Thanks, > > __ > > Kwasi Date-Bah > Database Administrator > > Direct Line: +44 20 7813 9536 > kwasi.date-...@snowvalley.com > > 10 Emerald Street, London, WC1N 3QA > Website: http://www.snowvalley.com > > Blog: http://snowpatrol.snowvalley.com > > > > ___ > http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users > > Community help: http://wiki.bestpractical.com > Commercial support: sa...@bestpractical.com > > > Discover RT's hidden secrets with RT Essentials from O'Reilly Media. > Buy a copy at http://rtbook.bestpractical.com > -- Best regards, Ruslan. ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: sa...@bestpractical.com 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 deleted tickets in a Dashboard?
There is no way to search deleted tickets in the web UI. On Tue, Jun 2, 2009 at 10:48 PM, Jo Rhett wrote: > I'm trying to create a Dashboard which will mail out the tickets for > review which are going to be purged from the system by rt-scrubber. > > In testing I have found something weird. Giving rt-scrubber a query > like this works fine. > > rt-shredder --plugin "Tickets=query, Status = 'deleted' AND > LastUpdated < '90 days ago';limit,100" --sqldump /u/rtweb/shredder- > restore.sql > > However the same query in the ticket system returns no results. Is > there something about doing ticket queries where Deleted is not a > valid status? How do we solve this problem? > > -- > Jo Rhett > Net Consonance : consonant endings by net philanthropy, open source > and other randomness > > > > ___ > http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users > > Community help: http://wiki.bestpractical.com > Commercial support: sa...@bestpractical.com > > > Discover RT's hidden secrets with RT Essentials from O'Reilly Media. > Buy a copy at http://rtbook.bestpractical.com > -- Best regards, Ruslan. ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: sa...@bestpractical.com 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 deleted tickets in a Dashboard?
You can use custom portlet based on a component with $tickets->{'allow_search_deleted'} = 1; On Wed, Jun 3, 2009 at 6:04 PM, Ruslan Zakirov wrote: > There is no way to search deleted tickets in the web UI. > > On Tue, Jun 2, 2009 at 10:48 PM, Jo Rhett wrote: >> I'm trying to create a Dashboard which will mail out the tickets for >> review which are going to be purged from the system by rt-scrubber. >> >> In testing I have found something weird. Giving rt-scrubber a query >> like this works fine. >> >> rt-shredder --plugin "Tickets=query, Status = 'deleted' AND >> LastUpdated < '90 days ago';limit,100" --sqldump /u/rtweb/shredder- >> restore.sql >> >> However the same query in the ticket system returns no results. Is >> there something about doing ticket queries where Deleted is not a >> valid status? How do we solve this problem? >> >> -- >> Jo Rhett >> Net Consonance : consonant endings by net philanthropy, open source >> and other randomness >> >> >> >> ___ >> http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users >> >> Community help: http://wiki.bestpractical.com >> Commercial support: sa...@bestpractical.com >> >> >> Discover RT's hidden secrets with RT Essentials from O'Reilly Media. >> Buy a copy at http://rtbook.bestpractical.com >> > > > > -- > Best regards, Ruslan. > -- Best regards, Ruslan. ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: sa...@bestpractical.com Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
Re: [rt-users] admin cc not receiving mail
you need scrip for that: On any transaction notify admin ccs with template transaction. On Wed, Jun 3, 2009 at 2:48 PM, Bashir Jahed wrote: > Hi, > > > > Been googling for 2 weeks with no success. > > > > I have an issue with admin cc. I am listed as admin cc of a queue. If > someone adds a comment to a ticket i receive the correspondence, however if > someone emails a comment the correspondence is not sent out to admin cc’s > > > > Is this the standard way it should work? I would like all transacations on a > particular queue to be sent to the admin cc’s. Is this possible? > > > > Bashir > > ___ > http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users > > Community help: http://wiki.bestpractical.com > Commercial support: sa...@bestpractical.com > > > Discover RT's hidden secrets with RT Essentials from O'Reilly Media. > Buy a copy at http://rtbook.bestpractical.com > -- Best regards, Ruslan. ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: sa...@bestpractical.com Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
Re: [rt-users] RT 3.8.3 and AT 1.2.4b1 - Batch and Grid updates broken
It's better to return empty list: sub ACLEquivalenceObjects { return () } On Tue, Jun 2, 2009 at 11:56 PM, BJ Blanchard wrote: > For those out there using RT 3.8.2 with Asset Tracker 1.2.4b1 - an upgrade > to RT 3.8.3 breaks Batch and Grid updates of Assets. > > This is due to a missing method called ACLEquivalenceObjects in > /opt/rt3/local/lib/RTx/AssetTracker/System.pm. > > I added this and it restored functionality of both Batch and Grid updates: > > sub ACLEquivalenceObjects { > my $self = shift; > return $self; > > } > > Otherwise, Asset Tracker works great in 3.8.3 so far. > > -Bob > ___ > http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users > > Community help: http://wiki.bestpractical.com > Commercial support: sa...@bestpractical.com > > > Discover RT's hidden secrets with RT Essentials from O'Reilly Media. > Buy a copy at http://rtbook.bestpractical.com > -- Best regards, Ruslan. ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: sa...@bestpractical.com Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
Re: [rt-users] RT 3.8.2 -> 3.8.3 Update/Changes
2009/6/3 Kevin Falcone : > > On Jun 3, 2009, at 9:20 AM, Gavin Henry wrote: > >> Yeah, we use Pg. >> We got 'relation 'groupmembers1' already exists. > > Oh, thats ok. We added an index that existed on MySQL but not on Pg, > but if you do your own database tuning there is always a chance > we'll conflict with you. Pointers to portable, simple and back- > compatible > ways of detecting indexes appreciated. > > You may want to run > > /opt/rt3/sbin/rt-setup-database --action insert --datadir etc/upgrade/ > 3.8.3 > > manually if the upgrade errored out after the failed index. > Or just delete schema.Pg and let --action upgrade do the magic Great, worked fine. Just deleted schema.Pg Thanks. -- http://www.suretecsystems.com/services/openldap/ http://www.suretectelecom.com ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: sa...@bestpractical.com Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
[rt-users] R: R: R: RT Queue Subject Tag problem
Jesse, after Jeremy's last email I upgraded our test system to 3.8.3, and the feature is now working perfectly. The web configuration UI sometimes still fails to show the subject tag, though. Thank you for your help! Bye Cris -Messaggio originale- Da: Jesse Vincent [mailto:je...@bestpractical.com] Inviato: mercoledì 3 giugno 2009 15.44 A: Guadagnino Cristiano Cc: Jesse Vincent; rt-users@lists.bestpractical.com; jer...@umbc.edu Oggetto: Re: R: [rt-users] R: RT Queue Subject Tag problem Can you please test on 3.8.3? On Wed, Jun 03, 2009 at 10:30:27AM +0200, Guadagnino Cristiano wrote: > Hi Jesse! > First of all, thank you for your response. > > Unfortunately, it seems it is not working. > On a test system (RT 3.8.2) we have two "incoming" queues: DBA and SCHEDU. I > have set the subject tag for the DBA queue as "DBA", while the subject tag > for the SCHEDU queue is "SCHD". > > In the RT_SiteConfig i have: > > Set($rtname , "SCHEDULAZIONE"); > Set($ExtractSubjectTagMatch, qr/\[(?:DBA|SCHD) #\d+\]/); > > I have restarted apache, then I created a test ticket in both queues (using > the "quick ticket creation" panel). BOTH of these ticket came out as having > [SCHEDULAZIONE #] in the subject of the email, i.e. they both have the > $rtname instead of the intended subject tag. > > We are running 3.8.2 both in production and in test. Is this a show-stopper? > Should we upgrade to 3.8.3 to have the functionality? Or am I > misunderstanding the intended behaviour of the subject tag setting? > > Thank you in advance! > > Bye > Cris > > > > -Messaggio originale- > Da: Jesse Vincent [mailto:je...@bestpractical.com] > Inviato: venerdì 29 maggio 2009 22.59 > A: Guadagnino Cristiano > Cc: rt-users@lists.bestpractical.com; jer...@umbc.edu > Oggetto: Re: [rt-users] R: RT Queue Subject Tag problem > > > > > On Fri, May 29, 2009 at 12:22:15PM +0200, Guadagnino Cristiano wrote: > > Hi all, > > I am having the same problem as Jeremy here. Nobody replied since > > january... can somebody help please? > > > > We just added some queues to out RT installation; these queues are to be > > used by an entirely new set of users, and we need then to have a different > > subject tag. > > > > If I understand correctly, the default subject tag is taken by the $rtname > > variable. So I changed the "subject tag" field in the queues, which was > > previously unset. RT tells me it has saved the value, but if I reenter the > > queue configuration panel I see mixed results: sometimes I see "subject > > tag" field empty, and sometimes I see it populated with what I have set. > > The behaviour also seems to be unconsistent: sometimes it uses the subject > > tag I have set, sometimes (90% of times) it uses the $rtname. > > > > I have looked at the database (MySQL here), and I also see that the only > > place where the value is apparently stored is in the "attributes" table. > > > > Is this a known bug? > > > > It's an interaction with the ExtractSubjectTag scrip. I believe that > if you add all your subject tags to ExtractSubjectTagMatch in > RT_SiteConfig, that will take care of it. I also _Thought_ this was > sorted out for 3.8.3, but someone who actually had code in the release > can likely correct me on that ;) > -- ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: sa...@bestpractical.com Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
[rt-users] 3.6.7 to 3.8.2 upgrade issue (mysql)
Hi list, Due to persistent memory problems I decided to try and upgrade to a more recent version of RT. (RT 3.6 was installed on a xen VM running Debian etch using the default apt package. In the mean time the machine has been upgraded to Debian lenny, without side-effects for RT. After the distro upgrade RT 3.8 was installed (again using apt). The mysql db upgrade script was generated like this: perl /usr/share/request-tracker3.8/etc/upgrade/upgrade-mysql-schema.pl rtdb rtuser rt > rt-upgrade-mysql.sql Unfortunately the upgrade script fails at line 210: 209 ALTER TABLE Users MODIFY Name VARBINARY(200) NOT NULL; 210 ALTER TABLE Users MODIFY Name VARCHAR(200) CHARACTER SET utf8 NOT NULL; This is due to the fact that we have these records in the users database: 703 xxx...@customer.com 723 ...@customer.com Both email addresses belong to the same person - the Users table currently is using charset latin1. What's the best way to move forward? * Should I alter the upgrade script to make the Name column accent sensitive? * Alternatively I update all tables so they point to the same user record and remove the conflicting one (but what will happen when a new email from that address arrives?) Regards, Karel ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: sa...@bestpractical.com Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
Re: [rt-users] RT on Oracle - ORA-04043 object Attachments does not exist
Do you know how I would do that? - Original Message - From: "Joop van de Wege" To: "Nick Yonko" Cc: rt-us...@bestpractical.com Sent: Wednesday, June 3, 2009 12:30:51 AM GMT -08:00 US/Canada Pacific Subject: Re: [rt-users] RT on Oracle - ORA-04043 object Attachments does not exist Nick Yonko wrote: > That was my initial thought, but when I log into the database using the rt > user with sqlplus, as the account that runs the apache daemon no less, I can > issue a 'desc attachments' command and a 'desc "Attachments"' command and > both return the table structure. Can you turn on sql logging within RT? This might give you a clue as to what exact statement is causing the ora-04043 error Regards, Joop ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: sa...@bestpractical.com Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
Re: [rt-users] Tickets with Owner= (no value)
Alberto, When you say you removed a user via MySQL do you mean you merely dropped the record from the USERS Table? Kenn LBNL On 6/3/2009 1:55 AM, Alberto Villanueva wrote: > Good morning, > > Yesterday I removed a user (within MySQL) had several assigned > tickets. Now these have Owner= (no value). > > I have tested next: > > 1.- MySQL query, but I cannot select because Owner= (no value) > 2.- In RT: new Search / Batch update / (I cannot because RT says > "Only you can assign tickets that they haven't Owner or it's > Nobody") > > Could I tell me how I assign the new owner? > > Best regards, > > ALBERTO VILLANUEVA DEL VAL > Consultant > > Altran Technologies > ParqueEmpresarial Las Mercedes, Edificio 1 > Campezo Street, 1- 28022 - Madrid, Spain > Tel: + 34 91 744 46 00 - Ext: 2205 > Fax: + 34 91 415 24 57 > www.altran.es > > > ___ > http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users > > Community help: http://wiki.bestpractical.com > Commercial support: sa...@bestpractical.com > > > 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: sa...@bestpractical.com 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.7 to 3.8.2 upgrade issue (mysql)
On Wed, Jun 3, 2009 at 11:51 AM, Karel Vervaeke wrote: > Hi list, > > Due to persistent memory problems I decided to try and upgrade to a > more recent version of RT. (RT 3.6 was installed on a xen VM running > Debian etch using the default apt package. In the mean time the > machine has been upgraded to Debian lenny, without side-effects for > RT. After the distro upgrade RT 3.8 was installed (again using apt). > > The mysql db upgrade script was generated like this: > perl /usr/share/request-tracker3.8/etc/upgrade/upgrade-mysql-schema.pl > rtdb rtuser rt > rt-upgrade-mysql.sql > > Unfortunately the upgrade script fails at line 210: > 209 ALTER TABLE Users MODIFY Name VARBINARY(200) NOT NULL; > 210 ALTER TABLE Users MODIFY Name VARCHAR(200) CHARACTER SET utf8 NOT NULL; > > This is due to the fact that we have these records in the users database: > 703 xxx...@customer.com > 723 ...@customer.com > > Both email addresses belong to the same person - the Users table > currently is using charset latin1. > What's the best way to move forward? > * Should I alter the upgrade script to make the Name column accent sensitive? > * Alternatively I update all tables so they point to the same user > record and remove the conflicting one (but what will happen when a new > email from that address arrives?) If accounts are duplicates then you can: * rename all duplicates and leave only primary accounts unchanged, by adding a "-duplicate" suffix or something like that * apply the rest commands Next time RT will use primary account cuz mysql treat e equal to é when default collation is used. If accounts are different and you don't want to treat e equal to é then you should adjust SQL commands the script generates and set different collation for Name column, the same applies to EmailAddress. > Regards, > Karel > ___ > http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users > > Community help: http://wiki.bestpractical.com > Commercial support: sa...@bestpractical.com > > > Discover RT's hidden secrets with RT Essentials from O'Reilly Media. > Buy a copy at http://rtbook.bestpractical.com > -- Best regards, Ruslan. ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: sa...@bestpractical.com Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
Re: [rt-users] Storing custom field file to local file system
Kevin Falcone wrote: > On Jun 3, 2009, at 7:23 AM, BJ Blanchard wrote: > >> Thanks Tom - but actually my custom field IS defined as "Upload one >> file" (or an attachment). >> My problem is saving that attachment from RT to /tmp (for >> manipulation from command-line script). >> There must be some non-http method of extracting the attachment to >> a file? > > Look at Download/CustomFieldValue/dhandler > > You need to get an ObjectCustomFieldValue object and then fetch the > LargeContent Also, if its an attachment you can get it through the REST interface. http://wiki.bestpractical.com/view/REST -- -- Tom Lahti BIT Statement LLC (425)251-0833 x 117 http://www.bitstatement.net/ -- ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: sa...@bestpractical.com Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
[rt-users] Help with Time display
To list, I am on 3.6.4. To remove the "Time" portion of any date being displayed, I used this setting: Set($DateTimeFormat, {Format => 'Default',Time => 0,}); It did not work. Is there another setting I need to use in conjunction with this one or am I in left field here. Is this setting usable in 3.6.4? Thanks in advance. Kenn LBNL ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: sa...@bestpractical.com Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
Re: [rt-users] Help with Time display
On Wed, Jun 03, 2009 at 10:04:41AM -0700, Ken Crocker wrote: > To list, > > I am on 3.6.4. To remove the "Time" portion of any date being > displayed, I used this setting: > > Set($DateTimeFormat, {Format => 'Default',Time => 0,}); > > It did not work. Is there another setting I need to use in > conjunction with this one or am I in left field here. Is this setting > usable in 3.6.4? Thanks in advance. That's very much a 3.8ism. Best, Jesse ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: sa...@bestpractical.com Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
Re: [rt-users] Help with Time display
Jesse, HA! Well, that explains that. Thank you for the answer. Hopefully, next month I'll be able to install 3.8.3 in development and play with it. Thanks again. Kenn LBNL On 6/3/2009 10:10 AM, Jesse Vincent wrote: On Wed, Jun 03, 2009 at 10:04:41AM -0700, Ken Crocker wrote: To list, I am on 3.6.4. To remove the "Time" portion of any date being displayed, I used this setting: Set($DateTimeFormat, {Format => 'Default',Time => 0,}); It did not work. Is there another setting I need to use in conjunction with this one or am I in left field here. Is this setting usable in 3.6.4? Thanks in advance. That's very much a 3.8ism. Best, Jesse ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: sa...@bestpractical.com 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: sa...@bestpractical.com Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
Re: [rt-users] Tickets with Owner= (no value)
Alberto, If you removed the owners of a ticket by removing those user records from the USERS Table, then you will NEVER find those owners, nor will you be able to change the owner on those tickets that point to the removed UserId. The reason is that RT has several Tables that are updated when a Ticket gets an owner. RT cannot replace an owner on a ticket if it can't find the old one. RT tries to find the old one so it can remove him from group membership in the "owner" role for that ticket. This is just one reason why it is NEVER a good idea to remove a User from the DataBase manually. The problem now is that you have several tickets that have an ID in the owner field that points to a User record that does /not/ exist. VERY BAD! If you take a look at the history for any of those tickets, you will see that the history display stops with an error when it tries to find that (removed) UserId to show when they became an owner. I'm not sure if Ruslan or any of the other RT gurus have any recovery SQL that you can use. If they do not, I have some SQL code that will do the job, but it will be a process of steps for EACH User you removed from the DataBase. If no one from RT can help you with this, then let me know and I'll send you my SQL code/process and explain it to you so you can fix your DataBase. Kenn LBNL On 6/3/2009 10:17 AM, Alberto Villanueva wrote: Dear Ken, Nowadays, I have several tickets without owner. I have search some queries, and I see tickets on RT with Owner no value. And I cannot assign a new owner. why can I do that? Now I have run some simple queries :-) and I have the old ID (user), so I will be able to update these tickets :-) My question is: do I have to update all tables (Principals, Groups, ...) with the new user's ID? If the answer is YES, I'll try it tomorrow ;-). Else, explain me it, please. thanks a lot! ;-) Best regards, ALBERTO VILLANUEVA DEL VAL Consultant Altran Technologies ParqueEmpresarial Las Mercedes, Edificio 1 Campezo Street, 1- 28022 - Madrid, Spain Tel: + 34 91 744 46 00 - Ext: 2205 Fax: + 34 91 415 24 57 www.altran.es *De:* Ken Crocker [mailto:kfcroc...@lbl.gov] *Enviado el:* miércoles, 03 de junio de 2009 18:59 *Para:* Alberto Villanueva *Asunto:* Re: [rt-users] Tickets with Owner= (no value) Alberto, You're database is now out of sync. Did you remember to remove the appropriate records from the PRINCIPLALS, GROUPS, GROUIPMEMBERS, CACHEDGROUPMEMBERS, ACL, ATTACHMENTS, & TRANSACTIONS Tables as well as the ACLEquivilence record from the USERS Table? All these records are tied to the user that is an owner of a ticket. Removing Users manually from the DataBase is highly discouraged. Now, if you can go back and see what the ID was for that particular User record, you will need to re-create it. If not, then you will have to go thru several SQL steps to create the User all over again and then link that User ID to all the records that WERE linked to the old UserID. Let me know what your situation is. I've gone thru this several times and have my own set of SQL that keeps all these table records in sync. Kenn LBNL On 6/3/2009 9:36 AM, Alberto Villanueva wrote: Alberto, Hi, When you say you removed a user via MySQL do you mean you merely dropped the record from the USERS Table? Yes, only I dropped it from USERS table. I had a "little" error :( :( Any idea? :S Thanks! Kenn LBNL On 6/3/2009 1:55 AM, Alberto Villanueva wrote: Good morning, Yesterday I removed a user (within MySQL) had several assigned tickets. Now these have Owner= (no value). I have tested next: 1.- MySQL query, but I cannot select because Owner= (no value) 2.- In RT: new Search / Batch update / (I cannot because RT says "Only you can assign tickets that they haven't Owner or it's Nobody") Could I tell me how I assign the new owner? Best regards, ALBERTO VILLANUEVA DEL VAL Consultant Altran Technologies ParqueEmpresarial Las Mercedes, Edificio 1 Campezo Street, 1- 28022 - Madrid, Spain Tel: + 34 91 744 46 00 - Ext: 2205 Fax: + 34 91 415 24 57 www.altran.es ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: sa...@bestpractical.com Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
[rt-users] RT-3.8.3, RT-Authen-ExternalAuth-0.08 login issue
I'm doing a fresh install of RT-3.8.3, RT-Authen-ExternalAuth-0.08, and AD for authentication. All running on RHEL5 x86_64 for the OS. I had this all working with RT-3.6.7 and RT-Authen-ExternalAuth-0.05, but had the brilliant idea that I needed to be current since 3.8.3 was released on the same day I got the old version working. Oh well... Any thoughts on where to go with this? Here is what I get in my error_log when I login with a verified username/password. [Wed Jun 3 17:46:08 2009] [error]: FAILED LOGIN for myuser from 192.168.1.100 (/opt/rt3/share/html/autohandler:268) Trace begun at /opt/rt3/bin/../lib/RT.pm line 289 Log::Dispatch::__ANON__('Log::Dispatch=HASH(0x2aeca7462620)', 'FAILED LOGIN for myuser from 192.168.1.100') called at /opt/rt3/share/html/autohandler line 268 HTML::Mason::Commands::__ANON__('pass', 'mypass', 'user', 'myuser') called at /usr/lib/perl5/vendor_perl/5.8.8/HTML/Mason/Component.pm line 135 HTML::Mason::Component::run('HTML::Mason::Component::FileBased=HASH(0x2aeca75a3180)', 'pass', 'mypass', 'user', 'myuser') called at /usr/lib/perl5/vendor_perl/5.8.8/HTML/Mason/Request.pm line 1273 eval {...} at /usr/lib/perl5/vendor_perl/5.8.8/HTML/Mason/Request.pm line 1268 HTML::Mason::Request::comp(undef, undef, undef, 'pass', 'mypass', 'user', 'myuser') called at /usr/lib/perl5/vendor_perl/5.8.8/HTML/Mason/Request.pm line 467 eval {...} at /usr/lib/perl5/vendor_perl/5.8.8/HTML/Mason/Request.pm line 467 eval {...} at /usr/lib/perl5/vendor_perl/5.8.8/HTML/Mason/Request.pm line 419 HTML::Mason::Request::exec('RT::Interface::Web::Request=HASH(0x2aeca74a6ff0)') called at /usr/lib/perl5/vendor_perl/5.8.8/HTML/Mason/ApacheHandler.pm line 168 HTML::Mason::Request::ApacheHandler::exec('RT::Interface::Web::Request=HASH(0x2aeca74a6ff0)') called at /usr/lib/perl5/vendor_perl/5.8.8/HTML/Mason/ApacheHandler.pm line 825 HTML::Mason::ApacheHandler::handle_request('HTML::Mason::ApacheHandler=HASH(0x2aeca42ab740)', 'Apache2::RequestRec=SCALAR(0x2aeca3f49f70)') called at /opt/rt3/bin/webmux.pl line 163 eval {...} at /opt/rt3/bin/webmux.pl line 163 RT::Mason::handler('Apache2::RequestRec=SCALAR(0x2aeca3f49f70)') called at -e line 0 Site Config from web interface: Loaded perl modules Perl v5.8.8 under linux Apache2::Const v2.04; Apache2::Log v2.04; Apache2::RequestIO v2.04; Apache2::RequestRec v2.04; Apache2::RequestUtil v2.04; Apache2::Response v2.04; Apache2::ServerUtil v2.04; Apache2::Status v4.00; Apache::Session v1.86; Apache::Session::Generate::MD5 v2.1; Apache::Session::Lock::MySQL v1.01; Apache::Session::MySQL v1.01; Apache::Session::Serialize::Storable v1.01; Apache::Session::Store::DBI v1.02; Apache::Session::Store::MySQL v1.04; APR v0.009000; APR::Pool v0.009000; APR::Table v0.009000; AutoLoader v5.60; base v2.07; bytes v1.02; Cache::Simple::TimedExpiry v0.27; Carp v1.04; CGI v3.43; CGI::Cookie v1.29; CGI::Util v1.5_01; Class::Accessor v0.33; Class::Accessor::Fast v0.33; Class::Container v0.12; Class::Data::Inheritable v0.06; Class::Inspector v1.24; Class::ISA v0.33; Class::ReturnValue v0.55; Clone v0.27; constant v1.05; Convert::ASN1 v0.22; CSS::Squish v0.07; Cwd v3.12; Data::Dumper v2.121_08; Date::Format v2.22; Date::Parse v2.27; DateTime v0.50; DateTime::Locale v0.42; DateTime::TimeZone v0.91; DateTime::TimeZone::Floating v0.01; DateTime::TimeZone::Local v0.01; DateTime::TimeZone::OffsetOnly v0.02; DateTime::TimeZone::UTC v0.01; DBD::mysql v3.0007; DBI v1.52; DBIx::SearchBuilder v1.54; DBIx::SearchBuilder::Union v0; DBIx::SearchBuilder::Unique v0.01; Devel::StackTrace v1.20; Devel::StackTraceFrame v1.20; Digest::base v1.00; Digest::MD5 v2.36; DynaLoader v1.05; Email::Address v1.889; Encode v2.33; Encode::Alias v2.12; Encode::Config v2.05; Encode::Encoding v2.05; Errno v1.0901; Exception::Class v1.23; Exception::Class::Base v1.2; Exporter v5.58; Exporter::Heavy v5.58; Fcntl v1.05; File::Basename v2.74; File::Glob v1.05; File::Path v1.08; File::ShareDir v1.00; File::Spec v3.12; File::Spec::Unix v1.5; File::Temp v0.21; FileHandle v2.01; GD v2.35; GD::Image v2.27; HTML::Element v3.23; HTML::Entities v1.35; HTML::Formatter v2.04; HTML::FormatText v2.04; HTML::Mason v1.39; HTML::Mason::ApacheHandler v1.69; HTML::Mason::Exception v1.1; HTML::Mason::Exception::Abort v1.1; HTML::Mason::Exception::Compilation v1.1; HTML::Mason::Exception::Compilation::IncompatibleCompiler v1.1; HTML::Mason::Exception::Compiler v1.1; HTML::Mason::Exception::Decline v1.1; HTML::Mason::Exception::Params v1.1; HTML::Mason::Exception::Syntax v1.1; HTML::Mason::Exception::System v1.1; HTML::Mason::Exception::TopLevelNotFound v1.1; HTML::Mason::Exception::VirtualMethod v1.1; HTML::Mason::Exceptions v1.43; HTML::Parser v3.55; HTML::Scrubber v0.08; HTML::Tagset v3.10; HTML::TreeBuilder v3.23; I18N::LangTags v0.35; I18N::LangTags::Detect v1.03; integer v1.00; IO v1.22; IO::File v1.13; IO::
Re: [rt-users] 3.8.2 message display bug reappears in 3.8.3
On Jun 3, 2009, at 5:23 AM, Kevin Falcone wrote: >> I reported this message display bug about 3 months ago, Kevin agreed >> with the fix, but it's still present in 3.8.3. Without this fix, if >> you click "Show" next to an outgoing mail message, regardless of your >> preference settings, text paragraphs are a single long line. > > I don't recall agreeing with the fix, but I did ask for it to end up > in the > bug tracker so it could be tracked. > > Its currently slated for review for 3.8.4 > http://rt3.fsck.com/Ticket/Display.html?id=13230 > > As I recall, during triage for 3.8.3 I couldn't immediately replicate > the problem you were solving so we left it for further review when > we had a little more time to replicate. It only happens when you click "Show" for outbound messages - ie, to AdminCcs or Requestors. Normal ticket display is unaffected. -- Jo Rhett Net Consonance : consonant endings by net philanthropy, open source and other randomness ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: sa...@bestpractical.com Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
Re: [rt-users] 3.8.2 message display bug reappears in 3.8.3
On Jun 3, 2009, at 2:47 PM, Jo Rhett wrote: > On Jun 3, 2009, at 5:23 AM, Kevin Falcone wrote: >>> I reported this message display bug about 3 months ago, Kevin agreed >>> with the fix, but it's still present in 3.8.3. Without this fix, if >>> you click "Show" next to an outgoing mail message, regardless of >>> your >>> preference settings, text paragraphs are a single long line. >> >> I don't recall agreeing with the fix, but I did ask for it to end up >> in the >> bug tracker so it could be tracked. >> >> Its currently slated for review for 3.8.4 >> http://rt3.fsck.com/Ticket/Display.html?id=13230 >> >> As I recall, during triage for 3.8.3 I couldn't immediately replicate >> the problem you were solving so we left it for further review when >> we had a little more time to replicate. > > > It only happens when you click "Show" for outbound messages - ie, to > AdminCcs or Requestors. Normal ticket display is unaffected. http://rt3.fsck.com/Ticket/ShowEmailRecord.html?id=13230&Transaction=109609&Attachment=52649 That looked fine, so I tabled it for 3.8.3 until we could figure out what it was trying to fix. -kevin ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: sa...@bestpractical.com Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
Re: [rt-users] 3.8.2 message display bug reappears in 3.8.3
FWIW, I do not see this behavior using RT 3.8.3 and FireFox 3.0.10. James Moseley Jo Rhett wrote: It only happens when you click "Show" for outbound messages - ie, to AdminCcs or Requestors. Normal ticket display is unaffected. ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: sa...@bestpractical.com 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 deleted tickets in a Dashboard?
Sorry to be dense, but can you translate the first sentence for me? ;-) I realize that this parameter needs to be set, I'm just unclear as to how. And would you guys accept a patch which put a checkbox for searching deleted messages on the Web UI? On Jun 3, 2009, at 7:05 AM, Ruslan Zakirov wrote: > You can use custom portlet based on a component with > $tickets->{'allow_search_deleted'} = 1; > > On Wed, Jun 3, 2009 at 6:04 PM, Ruslan Zakirov > wrote: >> There is no way to search deleted tickets in the web UI. >> >> On Tue, Jun 2, 2009 at 10:48 PM, Jo Rhett >> wrote: >>> I'm trying to create a Dashboard which will mail out the tickets for >>> review which are going to be purged from the system by rt-scrubber. >>> >>> In testing I have found something weird. Giving rt-scrubber a query >>> like this works fine. >>> >>> rt-shredder --plugin "Tickets=query, Status = 'deleted' AND >>> LastUpdated < '90 days ago';limit,100" --sqldump /u/rtweb/shredder- >>> restore.sql >>> >>> However the same query in the ticket system returns no results. Is >>> there something about doing ticket queries where Deleted is not a >>> valid status? How do we solve this problem? >>> >>> -- >>> Jo Rhett >>> Net Consonance : consonant endings by net philanthropy, open source >>> and other randomness >>> >>> >>> >>> ___ >>> http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users >>> >>> Community help: http://wiki.bestpractical.com >>> Commercial support: sa...@bestpractical.com >>> >>> >>> Discover RT's hidden secrets with RT Essentials from O'Reilly Media. >>> Buy a copy at http://rtbook.bestpractical.com >>> >> >> >> >> -- >> Best regards, Ruslan. >> > > > > -- > Best regards, Ruslan. -- Jo Rhett Net Consonance : consonant endings by net philanthropy, open source and other randomness ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: sa...@bestpractical.com Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
Re: [rt-users] RT 3.8.2 -> 3.8.3 Update/Changes
On Jun 3, 2009, at 5:30 AM, Kevin Falcone wrote: >> Is a database upgrade needed? When we went from 3.8.2 to .3 it failed >> saying that group something id already exists. > > Yes, there is a database upgrade involved. Really? Documentation didn't mention that. > UPGRADING FROM 3.8.2 and earlier - Changes: > > New scrip condition 'On Reject'. That's the only mention, and this seems like more of a feature than a todo for the UPGRADING document. UPGRADING.mysql only mentions mysql 4.0 -> 4.1 and versions prior to 3.8.0. If upgrades from 3.8.2 to 3.8.3 are supposed to do something, it is entirely undocumented. -- Jo Rhett Net Consonance : consonant endings by net philanthropy, open source and other randomness ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: sa...@bestpractical.com Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
Re: [rt-users] RT 3.8.2 -> 3.8.3 Update/Changes
On Jun 3, 2009, at 5:30 AM, Kevin Falcone wrote: > Yes, there is a database upgrade involved. $ rt-setup-database --action upgrade --datadir etc/upgrade/3.8.3 (snip) Enter RT version you're upgrading from: 3.8.2 No DB changes between 3.8.2 and 3.8.3 Done. -- Jo Rhett Net Consonance : consonant endings by net philanthropy, open source and other randomness ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: sa...@bestpractical.com Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
Re: [rt-users] RT 3.8.2 -> 3.8.3 Update/Changes
On Jun 3, 2009, at 3:17 PM, Jo Rhett wrote: > On Jun 3, 2009, at 5:30 AM, Kevin Falcone wrote: >> Yes, there is a database upgrade involved. > > $ rt-setup-database --action upgrade --datadir etc/upgrade/3.8.3 > (snip) > Enter RT version you're upgrading from: 3.8.2 > No DB changes between 3.8.2 and 3.8.3 > Done. /tmp/rt-3.8.3$ /opt/rt3/sbin/rt-setup-database --action upgrade Enter RT version you're upgrading from: 3.8.2 Going to apply following upgrades: * 3.8.3 Enter RT version if you want to stop upgrade at some point, or leave it blank if you want apply above upgrades: I don't think you're doing this from a tarball, you're trying to do it from the installed directory. It gives you an even more specific command to run at the end of the output from make upgrade -kevin ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: sa...@bestpractical.com Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
Re: [rt-users] Binary files broken since upgrade to RT 3.8
Thanks, it looks like this might work. We basically have a script which selects the data out of the 3.6 db and then update the corresponding row in the 3.8 db and so far I'm getting better results. Thanks, - Dominic Aaron Guise wrote: > Hi, > > I too had a similar problem. I inherited our RT System from an earlier > administrator whom didn't complete some step correctly earlier in the > life of the system. We were going from 3.6.5 to 3.8.0 and all worked > fine. Since then to enable some plugins I attempted to update to 3.8.2. > > I did use --default-character-set=binary on mysqldump and completed > all of the upgrade steps as per UPGRADING.mysql but upon browsing the > newly updated RT System to my surprise all the binary attachments had > been corrupted as you are mentioning. > > To get around this I created a couple of perl scripts. > 1. Pulls all attachments out of the functioning database > (Pre-Upgrade) and dumps them to the filesystem > 2. Inserts all attachments back into the newly updated schema. > > This approach worked for me, I was then able to use 3.8.2 without any > trouble at all. > > *Regards,* > > *Aaron Guise > * > > ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: sa...@bestpractical.com 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 deleted tickets in a Dashboard?
On Wed, Jun 3, 2009 at 11:09 PM, Jo Rhett wrote: > Sorry to be dense, but can you translate the first sentence for me? ;-) > > I realize that this parameter needs to be set, I'm just unclear as to how. Create share/html/Elements/DeleteTickets that does the search and displays it, register it in HomepageComponents option. > And would you guys accept a patch which put a checkbox for searching deleted > messages on the Web UI? It's up to Jesse Vincent. > > On Jun 3, 2009, at 7:05 AM, Ruslan Zakirov wrote: >> >> You can use custom portlet based on a component with >> $tickets->{'allow_search_deleted'} = 1; >> >> On Wed, Jun 3, 2009 at 6:04 PM, Ruslan Zakirov >> wrote: >>> >>> There is no way to search deleted tickets in the web UI. >>> >>> On Tue, Jun 2, 2009 at 10:48 PM, Jo Rhett >>> wrote: I'm trying to create a Dashboard which will mail out the tickets for review which are going to be purged from the system by rt-scrubber. In testing I have found something weird. Giving rt-scrubber a query like this works fine. rt-shredder --plugin "Tickets=query, Status = 'deleted' AND LastUpdated < '90 days ago';limit,100" --sqldump /u/rtweb/shredder- restore.sql However the same query in the ticket system returns no results. Is there something about doing ticket queries where Deleted is not a valid status? How do we solve this problem? -- Jo Rhett Net Consonance : consonant endings by net philanthropy, open source and other randomness ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: sa...@bestpractical.com Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com >>> >>> >>> >>> -- >>> Best regards, Ruslan. >>> >> >> >> >> -- >> Best regards, Ruslan. > > -- > Jo Rhett > Net Consonance : consonant endings by net philanthropy, open source and > other randomness > > > > -- Best regards, Ruslan. ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: sa...@bestpractical.com Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
Re: [rt-users] RT 3.8.2 -> 3.8.3 Update/Changes
Except that your command is just wrong: $ rt-setup-database --action upgrade --datadir etc/upgrade ... Enter RT version you're upgrading from: 3.8.2 Going to apply following upgrades: * 3.8.3 Enter RT version if you want to stop upgrade at some point, or leave it blank if you want apply above upgrades: On Wed, Jun 3, 2009 at 11:17 PM, Jo Rhett wrote: > On Jun 3, 2009, at 5:30 AM, Kevin Falcone wrote: >> Yes, there is a database upgrade involved. > > $ rt-setup-database --action upgrade --datadir etc/upgrade/3.8.3 > (snip) > Enter RT version you're upgrading from: 3.8.2 > No DB changes between 3.8.2 and 3.8.3 > Done. > > -- > Jo Rhett > Net Consonance : consonant endings by net philanthropy, open source > and other randomness > > > > ___ > http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users > > Community help: http://wiki.bestpractical.com > Commercial support: sa...@bestpractical.com > > > Discover RT's hidden secrets with RT Essentials from O'Reilly Media. > Buy a copy at http://rtbook.bestpractical.com > -- Best regards, Ruslan. ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: sa...@bestpractical.com Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
[rt-users] RT ExternalAuth LDAP and Adding Local users in 3.8.2
I have been reading the postings about RT-Authen-ExternalAuth but am confused on what appears to be some conflicting setup information. I am using: RT 3.8.2 RT-Authen-ExternalAuth 0.08 I would like to use LDAP for authentication and information first, and that part seems to work OK. But I also would like to: - add LOCAL users to RT internal DB (i.e; test and test-admin type accounts) - NOT autocreate a new RT account, if we receive an email from a user that is unknown in local RT or LDAP. - NOT make multiple accounts for a user's multiple email aliases. (Our ldap contains several email addresses for each user (uid) ) When I try to add a local account through the Web(using Root, Configuration->Users->Create). I receive the error "Name in Use" The username I am trying to create is NOT in existence, but the email for that new account IS. My error_log shows: == > [Tue Jun 2 17:45:21 2009] [debug]: User Check Failed :: ( My_LDAP ) root > User not found > (/opt/opt.CORE/rt-3.8/rhel4/PROD/local/plugins/RT-Authen-ExternalAuth/lib/RT/Authen/ExternalAuth/LDAP.pm:318) > [Tue Jun 2 17:45:21 2009] [debug]: Autohandler called ExternalAuth. > Response: (0, No User) > (/opt/opt.CORE/rt-3.8/rhel4/PROD/local/plugins/RT-Authen-ExternalAuth/html/Callbacks/ExternalAuth/autohandler/Auth:26) > [Tue Jun 2 17:45:21 2009] [info]: Successful login for root from > 168.7.56.227 (/usr/site/rt-3.8/PROD/share/html/autohandler:276) > [Tue Jun 2 17:46:40 2009] [debug]: /ServiceUpdate/Elements/Header calls old > style callback, use $m->callback > (/usr/site/rt-3.8/PROD/share/html/Elements/Callback:51) > [Tue Jun 2 17:46:40 2009] [crit]: HasRight called with no valid object > (/usr/site/rt-3.8/PROD/bin/../lib/RT/Principal_Overlay.pm:322) > [Tue Jun 2 17:51:36 2009] [debug]: > RT::Authen::ExternalAuth::CanonicalizeUserInfo called by RT::User > /opt/opt.CORE/rt-3.8/rhel4/PROD/local/plugins/RT-Authen-ExternalAuth/lib/RT/User_Vendor.pm > 20 with: Address1: , Address2: , AuthSystem: , City: , Comments: Admin > Authority Level Account for RT, ContactInfoSystem: , Country: , Disabled: 0, > EmailAddress: smccl...@rice.edu, EmailEncoding: , ExternalAuthId: , > ExternalContactInfoId: , FreeformContactInfo: , Gecos: , HomePhone: , Lang: > en, MobilePhone: , Name: smcclure-admin, NickName: Smcclure-Admin, > Organization: , PagerPhone: , Privileged: 1, RealName: Susan McClure, > Signature: , State: , > WebEncoding: , WorkPhone: , Zip: > (/opt/opt.CORE/rt-3.8/rhel4/PROD/local/plugins/RT-Authen-ExternalAuth/lib/RT/Authen/ExternalAuth.pm:450) > [Tue Jun 2 17:51:36 2009] [debug]: Attempting to get user info using this > external service: My_LDAP > (/opt/opt.CORE/rt-3.8/rhel4/PROD/local/plugins/RT-Authen-ExternalAuth/lib/RT/Authen/ExternalAuth.pm:458) > [Tue Jun 2 17:51:36 2009] [debug]: Attempting to use this canonicalization > key: Name > (/opt/opt.CORE/rt-3.8/rhel4/PROD/local/plugins/RT-Authen-ExternalAuth/lib/RT/Authen/ExternalAuth.pm:472) > [Tue Jun 2 17:51:36 2009] [debug]: LDAP Search === Base: > ou=People,dc=rice,dc=edu == Filter: (&(objectclass=*)(uid=smcclure-admin)) == > Attrs: > Houston,cn,TX,mail,gecos,postalAddress,postalCode,telephoneNumber,uid,physicalDeliveryOfficeName,uid > > (/opt/opt.CORE/rt-3.8/rhel4/PROD/local/plugins/RT-Authen-ExternalAuth/lib/RT/Authen/ExternalAuth/LDAP.pm:195) > [Tue Jun 2 17:51:36 2009] [debug]: Attempting to use this canonicalization > key: EmailAddress > (/opt/opt.CORE/rt-3.8/rhel4/PROD/local/plugins/RT-Authen-ExternalAuth/lib/RT/Authen/ExternalAuth.pm:472) > [Tue Jun 2 17:51:36 2009] [debug]: LDAP Search === Base: > ou=People,dc=rice,dc=edu == Filter: > (&(objectclass=*)(mail=smccl...@rice.edu)) == Attrs: > Houston,cn,TX,mail,gecos,postalAddress,postalCode,telephoneNumber,uid,physicalDeliveryOfficeName,uid > > (/opt/opt.CORE/rt-3.8/rhel4/PROD/local/plugins/RT-Authen-ExternalAuth/lib/RT/Authen/ExternalAuth/LDAP.pm:195) > [Tue Jun 2 17:51:36 2009] [info]: > RT::Authen::ExternalAuth::CanonicalizeUserInfo returning > Address1: 6100 Main Street, Address2: , AuthSystem: , City: , Comments: Admin > Authority Level Account for RT, ContactInfoSystem: , Country: , Disabled: 0, > EmailAddress: smccl...@rice.edu, EmailEncoding: , ExternalAuthId: smcclure, > ExternalContactInfoId: , FreeformContactInfo: , Gecos: , HomePhone: , Lang: > en, MobilePhone: , Name: smcclure, NickName: Smcclure-Admin, > Organization: 222 Mudd Building, PagerPhone: , Privileged: 1, RealName: > McClure, Susan, Signature: , State: , WebEncoding: , WorkPhone: 713-348-4852, > Zip: 77005 > (/opt/opt.CORE/rt-3.8/rhel4/PROD/local/plugins/RT-Authen-ExternalAuth/lib/RT/Authen/ExternalAuth.pm:536) == My Current RT_SiteConfig.pm for LDAP and External Auth has Set(@Plugins,qw(RT::FM RT::IR RT::Authen::ExternalAuth ... and for LDAP # special options for various plugins # Authen::ExternalAuth Set($ExternalA
Re: [rt-users] RT 3.8.2 -> 3.8.3 Update/Changes
On Jun 3, 2009, at 12:28 PM, Kevin Falcone wrote: > I don't think you're doing this from a tarball, > you're trying to do it from the installed directory. Nope, from the extracted tarball in ports directory. > It gives you an even more specific command to run > at the end of the output from make upgrade FreeBSD port doesn't use "make install" or "make upgrade" -- unless perhaps we're supposed to run "make upgrade" from the extraction directory afterwards. The port doesn't indicate this. I'm very tempted to stop using the FreeBSD port and just run RT from a single install directory, but I'm also aware that this will make the installation even more tied-to-Jos-brain and less easy for others to maintain, so... -- Jo Rhett Net Consonance : consonant endings by net philanthropy, open source and other randomness ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: sa...@bestpractical.com Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
Re: [rt-users] RT ExternalAuth LDAP and Adding Local users in 3.8.2
((Apologies for top-posting, but it's just easier at the moment for me to use outlook to send email)) I can answer a few of your questsions:- 1) Users with multiple email addresses on our system become one single user, the LDAP query finds the one user responsible for the email address, and just link the submitted ticket to the correct ID. 2) You cannot have multiple RT accounts with the same email address in the system, we had a lot of cleanup when we migrated to 3.8.2 from a badly botched install of 3.6, and this was our biggest hassle. 3) I have AutoCreateNonExternalUsers on, but that's mostly because of the nature of the business my company is in :) However, the system seems to work fine with that disabled, and it doesn't autocreate any non-LDAP accounts unless you do so yourself. On another level, I know you'll hear this from a lot of angles, but it always deserves to be said... You should try this sort of thing out on a test system before setting it up in production... Especially when dealing with things like authentication, you really want to make sure youself that it does what you want it to do... -- Cass -Original Message- From: rt-users-boun...@lists.bestpractical.com [mailto:rt-users-boun...@lists.bestpractical.com] On Behalf Of Susan McClure Sent: Wednesday, June 03, 2009 2:30 PM To: rt-users@lists.bestpractical.com Cc: Susan McClure Subject: [rt-users] RT ExternalAuth LDAP and Adding Local users in 3.8.2 I have been reading the postings about RT-Authen-ExternalAuth but am confused on what appears to be some conflicting setup information. I am using: RT 3.8.2 RT-Authen-ExternalAuth 0.08 I would like to use LDAP for authentication and information first, and that part seems to work OK. But I also would like to: - add LOCAL users to RT internal DB (i.e; test and test-admin type accounts) - NOT autocreate a new RT account, if we receive an email from a user that is unknown in local RT or LDAP. - NOT make multiple accounts for a user's multiple email aliases. (Our ldap contains several email addresses for each user (uid) ) When I try to add a local account through the Web(using Root, Configuration->Users->Create). I receive the error "Name in Use" The username I am trying to create is NOT in existence, but the email for that new account IS. My error_log shows: == > [Tue Jun 2 17:45:21 2009] [debug]: User Check Failed :: ( My_LDAP ) > root User not found > (/opt/opt.CORE/rt-3.8/rhel4/PROD/local/plugins/RT-Authen-ExternalAuth/ > lib/RT/Authen/ExternalAuth/LDAP.pm:318) > [Tue Jun 2 17:45:21 2009] [debug]: Autohandler called ExternalAuth. > Response: (0, No User) > (/opt/opt.CORE/rt-3.8/rhel4/PROD/local/plugins/RT-Authen-ExternalAuth/ > html/Callbacks/ExternalAuth/autohandler/Auth:26) > [Tue Jun 2 17:45:21 2009] [info]: Successful login for root from > 168.7.56.227 (/usr/site/rt-3.8/PROD/share/html/autohandler:276) > [Tue Jun 2 17:46:40 2009] [debug]: /ServiceUpdate/Elements/Header > calls old style callback, use $m->callback > (/usr/site/rt-3.8/PROD/share/html/Elements/Callback:51) > [Tue Jun 2 17:46:40 2009] [crit]: HasRight called with no valid > object (/usr/site/rt-3.8/PROD/bin/../lib/RT/Principal_Overlay.pm:322) > [Tue Jun 2 17:51:36 2009] [debug]: > RT::Authen::ExternalAuth::CanonicalizeUserInfo called by RT::User > /opt/opt.CORE/rt-3.8/rhel4/PROD/local/plugins/RT-Authen-ExternalAuth/l > ib/RT/User_Vendor.pm 20 with: Address1: , Address2: , AuthSystem: , > City: , Comments: Admin Authority Level Account for RT, > ContactInfoSystem: , Country: , Disabled: 0, EmailAddress: > smccl...@rice.edu, EmailEncoding: , ExternalAuthId: , > ExternalContactInfoId: , FreeformContactInfo: , Gecos: , HomePhone: , > Lang: en, MobilePhone: , Name: smcclure-admin, NickName: > Smcclure-Admin, > Organization: , PagerPhone: , Privileged: 1, RealName: Susan McClure, > Signature: , State: , > WebEncoding: , WorkPhone: , Zip: > (/opt/opt.CORE/rt-3.8/rhel4/PROD/local/plugins/RT-Authen-ExternalAuth/ > lib/RT/Authen/ExternalAuth.pm:450) > [Tue Jun 2 17:51:36 2009] [debug]: Attempting to get user info using > this external service: My_LDAP > (/opt/opt.CORE/rt-3.8/rhel4/PROD/local/plugins/RT-Authen-ExternalAuth/ > lib/RT/Authen/ExternalAuth.pm:458) > [Tue Jun 2 17:51:36 2009] [debug]: Attempting to use this > canonicalization key: Name > (/opt/opt.CORE/rt-3.8/rhel4/PROD/local/plugins/RT-Authen-ExternalAuth/ > lib/RT/Authen/ExternalAuth.pm:472) > [Tue Jun 2 17:51:36 2009] [debug]: LDAP Search === Base: > ou=People,dc=rice,dc=edu == Filter: > (&(objectclass=*)(uid=smcclure-admin)) == Attrs: > Houston,cn,TX,mail,gecos,postalAddress,postalCode,telephoneNumber,uid, > physicalDeliveryOfficeName,uid > (/opt/opt.CORE/rt-3.8/rhel4/PROD/local/plugins/RT-Authen-ExternalAuth/ > lib/RT/Authen/ExternalAuth/LDAP.pm:195) > [Tue Jun 2 17:51:36 2009] [debug]: Attempting to use this > canonicalization key: EmailAddress > (/o
Re: [rt-users] RT 3.8.2 -> 3.8.3 Update/Changes
Everyone has their own way of doing things, but I find upgrading RT is easiest by essentially installing RT from scratch upon each upgrade and then soft-linking to the new directory. In this way, upgrades are straightforward and not hard to follow. For example: download new RT source untar/unzip RT source rename RT source to rt-3.8.3.src (in this example RT 3.8.3) cd rt-3.8.3.src ./configure --prefix=/opt/rt3.8.3 --with-web-user=apache --with-web-group=apache --with-mysql --with-web-handler=fastcgi (or mod_perl, etc) make testdeps upgrade/install any required perl modules via 'make fixdeps' or cpan make install copy RT_SiteConfig.pm from current RT installation (let's assume /opt/rt3 and that /opt/rt3 is a soft link to, for example, /opt/rt3.8.2) to /opt/rt3.8.3/etc/ *and* /opt/rt-3.8.3.src/etc Copy any local customizations from /opt/rt3/local into /opt/rt-3.8.3/local >From within source directory: sbin/rt-setup-database --action upgrade --datadir etc/upgrade (The above step upgrades the database) cd /opt rm /rt3 ln -s /opt/rt-3.8.3/ rt3 (relinking /opt/rt3 to new source) restart httpd In this way, if the new version of RT breaks or doesn't seem to work right, I can just relink /opt/rt3 to the old installation. Of course, if the database upgrade doesn't go right and is the cause of breakage, you'll need to restore the database from a backup. A backup you hopefully just performed prior to beginning the upgrade process. ;-) If it's a major schema upgrade, then I suggest testing things out by running the new RT installation from a test server against a static/test copy of your RT database. James Moseley Jo Rhett wrote: FreeBSD port doesn't use "make install" or "make upgrade" -- unless perhaps we're supposed to run "make upgrade" from the extraction directory afterwards. The port doesn't indicate this. I'm very tempted to stop using the FreeBSD port and just run RT from a single install directory, but I'm also aware that this will make the installation even more tied-to-Jos-brain and less easy for others to maintain, so... ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: sa...@bestpractical.com Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
[rt-users] rt 3.8.2 ticket cloning starts/due dates 1970?
Ahoy, Running RT 3.8.2 when I clone a ticket via one of the (parent|child|etc.) "Create" links it's filling in "1970-01-01 00:00:00" for both the Starts and Due dates when those values are Not set in the originating ticket. In the database it's being stored as "1970-01-01 08:00:00" (have a -8:00 timezone offset) so the new tickets are showing up as starting and due in 1970. Is there a quick patch for this floating around or is this something fixed in 3.8.3 (or is this just me)? Cheers, Paul ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: sa...@bestpractical.com Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
Re: [rt-users] RT 3.8.2 -> 3.8.3 Update/Changes
On Thu, Jun 4, 2009 at 12:58 AM, Jo Rhett wrote: > On Jun 3, 2009, at 12:28 PM, Kevin Falcone wrote: > > I don't think you're doing this from a tarball, > > you're trying to do it from the installed directory. > > Nope, from the extracted tarball in ports directory. > > > It gives you an even more specific command to run > > at the end of the output from make upgrade > > FreeBSD port doesn't use "make install" or "make upgrade" -- unless > perhaps we're supposed to run "make upgrade" from the extraction > directory afterwards. The port doesn't indicate this. > > I'm very tempted to stop using the FreeBSD port and just run RT from a > single install directory, but I'm also aware that this will make the > installation even more tied-to-Jos-brain and less easy for others to > maintain, so... I have always run my RT from the tarball on FreeBSD and it installs everything in /opt/. Upgrading that should not cause any hell if you follow the rules. The only deviation is the upgrade of the perl modules, which "make fixdeps" does for you. If other people are to maintain the system, then write them a howto for maintaining RT, but AFAICS, it's already there for you in UPGRADING. Just point them to it. -- Best regards, Odhiambo WASHINGTON, Nairobi,KE +254733744121/+254722743223 _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ "Clothes make the man. Naked people have little or no influence on society." -- Mark Twain ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: sa...@bestpractical.com Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
[rt-users] Problem with CustomCondition
Hey, i want to write a CustomCondition who activate a action if the queue is changed from x to y this is my code: return 0 unless $self->TransactionObj->Type eq "Set"; return 0 unless $self->TransactionObj->Field eq "Queue"; return 0 unless $self->TransactionObj->NewValue == "y"; return 0 unless $self->TransactionObj->OldValue == "x"; return 1; It does not work :-( But when i delete the line return 0 unless $self->TransactionObj->OldValue == "x"; it is all OK - but now start the action, even if the old value is not "x" Martin -- View this message in context: http://www.nabble.com/Problem-with-CustomCondition-tp23827737p23827737.html Sent from the Request Tracker - User mailing list archive at Nabble.com. ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: sa...@bestpractical.com Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
[rt-users] DashBoaard
Hello list, I am seeing so much mention of the word "DashBoard" in relation to RT. Having been off active running of RT, I am inclined to ask what it is and how I can use it. -- Best regards, Odhiambo WASHINGTON, Nairobi,KE +254733744121/+254722743223 _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ "Clothes make the man. Naked people have little or no influence on society." -- Mark Twain ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: sa...@bestpractical.com Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com