Re: [rt-users] Problems getting LDAP authentication working...
Mon 01 Jun 2009 20:26:02 GMT Kevin Gagel wrote: I'm trying to setup LDAP through the RT-Authen-ExternalAuth plugin. I have gotten far enough to login as a user via LDAP but I want to restrict login's to a specific group within my Windows AD. Try these: # Does authentication depend on group membership? What group name? 'group' = 'cn=CSER,insert base', # What is the attribute for the group object that determines membership? 'group_attr'= 'member', -- 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] Default value for custom fields
I may be being thick here, but I can't see a way to do this from the web interface. If I create a custom field of 'Select One Value' type, is there any way of making one of the values selected by default? The actual application I'm looking at here is for tracking time spent working on tickets out of normal business hours, for which we would charge extra. The vast majority of work will be done during normal hours, so I'd like that to be the default value. Cheers, Matthew -- Dr Matthew SeamanThe Bunker, Ash Radar Station PGP: 0x60AE908C on servers Marshborough Rd Tel: +44 1304 814890 Sandwich Fax: +44 1304 814899 Kent, CT13 0PL, UK signature.asc Description: OpenPGP digital signature ___ 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.8.2 message display bug reappears in 3.8.3
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. --- 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( 'div id=bodypre style=padding: 2em;' ); +$m-out( 'div id=body style=white-space: pre-wrap; padding: 2em;' ); $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( '/pre/div' ); +$m-out( '/div' ); }; 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
Re: [rt-users] ldap autocreate with ExternalAuth?
Cheers again, my problem seems to be more unique then i thought. I will first update to 3.83 now, maybe the new callbacks are giving me some support. Otherwise i will try to use WebExternalAuth instead of ExternalAuth. sincerly, julien Julien Lacroix schrieb: Cheers RT-users, as i understand it, RT::Authen::ExternalAuth 0.08 supports autocreate an user account if he can't auth via the external service (AutoCreateNonExternalUsers). Whats about the other way round? Can ExternalAuth serving the same functionality as AutoCreateFromExternalUserInfo, or is this (overlay) the tool which fills the gap? sincerly, julien ___ 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
[rt-users] Installing RTFM in second instance
Hi Every one. I would like to install new (clean) RTFM on a second instance of RT installation. I would not like to do make initdb on first instance which is already in production for years. Is it OK to set $RTHOME env on a new instance (export RTHOME=/opt/path-to-new-instance) and do the initdb. Can you please help ? -- View this message in context: http://www.nabble.com/Installing-RTFM-in-second-instance-tp23830329p23830329.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
Re: [rt-users] Installing RTFM in second instance
On Tue, Jun 2, 2009 at 2:55 PM, Bostjan9 bostjan.vid...@gmail.com wrote: Hi Every one. I would like to install new (clean) RTFM on a second instance of RT installation. I would not like to do make initdb on first instance which is already in production for years. Is it OK to set $RTHOME env on a new instance (export RTHOME=/opt/path-to-new-instance) and do the initdb. Can you please help ? RTHOME=/path/to/new/instance perl Makefile.PL check paths in the output make make install make initdb check DB info before providing password. -- View this message in context: http://www.nabble.com/Installing-RTFM-in-second-instance-tp23830329p23830329.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 -- 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] Help with approval templates
Two steps forward, one step back. Ok, I have my initial problem of the approvers not receiving the 'New Pending Approval' email from the template in the ___Approvals queue resolved. I fixed it with change to the code: --- rt-3.8.3/lib/RT/Approval/Rule/NewPending.pm.orig2009-05-27 11:50:50.0 -0400 +++ rt-3.8.3/lib/RT/Approval/Rule/NewPending.pm 2009-06-02 11:17:21.0 -0400 @@ -76,6 +76,7 @@ # first txn entry of the approval ticket local $self-{TransactionObj} = $to; $self-RunScripAction('Notify Owner', 'New Pending Approval', @_); +$self-RunScripAction('Notify AdminCcs', 'New Pending Approval', @_); return; Since the template says Notify Owners and AdminCcs of new items pending their approval that this is a bug that was over looked. However, I still have the second problem, which I understand better now. Anytime an approval ticket is created using the scrip and template in my General queue, the approvers get two emails. One of which is the 'New Pending Approval' email from the default template in the ___Approvals queue, and the other is the 'Global: On Create Notify AdminCcs with template Transaction' script. I would rather not delete a scrip installed as part of RT. It could make things confusing down the road as our implementation evolves. However, our approvers are complaining about getting both emails, and see as they are the bosses, they get what they want. Is there another way around this issue or is simply removing that global scrip my best path? Thanks, Jeremy On Mon, 2009-06-01 at 18:16 -0400, Jeremy Winder wrote: Ok, I removed the AdminCC and put the Owner: back in the template for the General queue, just to ensure I wasn't loosing my mind. I get both needs approval notifications, which I didn't realize before. So what I want to happen is this, I want to be able to have multiple users with the ability to approve tickets; but I only want the ticket to require one of them. And I want the better looking default notification emails. Any help will be greatly appreciated. I'm trying to learn the system and go live at the same time, which isn't a good combination. Thanks in advance, Jeremy On Mon, 2009-06-01 at 17:09 -0400, Jeremy Winder wrote: I have been fighting this all day, I'm sure it is something simple but I'm completely missing it. I had approvals setup with one person being the approver using the following scrip and template on my General queue: scrip Description: Create Approval Condition: On Create Action: Create Tickets Template: Approvals Stage: TransactionCreate /scrip template Name: Approvals Description: Template used for requesting approvals Content: ===Create-Ticket: Approval Subject: Approval for {$Tickets{'TOP'}-Subject} Depended-On-By: TOP Queue: ___Approvals Type: approval Owner: name-of-user Content: Someone has created a ticket. you should review and approve it, so work can begin. ENDOFCONTENT /template And all was well. I was receiving these emails as the needs to be approved notices: Greetings, There is a new item pending your approval: CR Approval for: 9 - This is a test ticket 5, a summary of which appears below. Please visit http://localhost/rt/Approvals/Display.html?id=10 to approve or reject this ticket, or http://localhost/rt/Approvals/ to batch-process all your pending approvals. - Someone has created a ticket. you should review and approve it, so they can finish their work But then the fun began. I needed to it up so multiple people can approve a ticket but only one of them has to. So I followed the instructions at the bottom on http://wiki.bestpractical.com/view/ApprovalCreation and changed my General queue's template to be: template Name: Approvals Description: Template used for requesting approvals Content: ===Create-Ticket: Approval Subject: Approval for {$Tickets{'TOP'}-Subject} Depended-On-By: TOP Queue: ___Approvals Type: approval AdminCC: { my $group_name = 'Group Name'; my $groups = RT::Groups-new( $RT::SystemUser ); $groups-LimitToUserDefinedGroups(); $groups-Limit( 'FIELD'= 'Name', 'OPERATOR' = '=', 'VALUE'= $group_name ); $groups-First-Id; } Content: Someone has created a ticket. you should review and approve it, so work can begin. ENDOFCONTENT /template Now I get the emails that looks like this: Mon Jun 01 16:51:24 2009: Request 35 was acted upon. Transaction: Ticket created by RT_System Queue: ___Approvals Subject: Approval for Testing Approvials again Owner: Nobody Requestors: Status:
Re: [rt-users] How to Migrate the Bugzilla Ticket Description into Request Tracker
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 mailto:sarah.clell...@snowvalley.com 10 Emerald Street, London, WC1N 3QA Website: http://www.snowvalley.com http://www.snowvalley.com Blog: http://snowpatrol.snowvalley.com 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
Re: [rt-users] Default value for custom fields
Matthew, Try creating a scrip that has the condition of OnCreate, an action as user-Defined and put code in the prep action code area that sets the CF to the value you want (see below). Put return 1; in the clean-up action area. That should do it. Prep Action code: # set the CF Work-Completed Date my $trans = $self-TransactionObj; my $ticket = $self-TicketObj; my $cf_obj = RT::CustomField-new($RT::SystemUser); my $cf_name = Work-Completed Date; my ( undef, undef, undef, $mon, $day, $year ) = localtime( time ); my $cf_value = sprintf( '%d/%02d/%02d', $year + 1900, $mon, $day ); $cf_obj-LoadByName(Name=$cf_name); $RT::Logger-debug(Loaded\$cf_obj-Name = . $cf_obj-Name() .\n); $ticket-AddCustomFieldValue(Field=$cf_obj, Value=$cf_value, RecordTransaction=0); return 1; Kenn LBNL On 6/2/2009 1:41 AM, Matthew Seaman wrote: I may be being thick here, but I can't see a way to do this from the web interface. If I create a custom field of 'Select One Value' type, is there any way of making one of the values selected by default? The actual application I'm looking at here is for tracking time spent working on tickets out of normal business hours, for which we would charge extra. The vast majority of work will be done during normal hours, so I'd like that to be the default value. Cheers, Matthew ___ 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] How to Migrate the Bugzilla Ticket Description into Request Tracker
Kwasi, I'm not sure I understand what you mean by Detail of the Ticket (especially in terms of attachments), but in the RT wiki, I put the code for a perl program we used to convert a legacy ticket system to RT using API. Take a look, it might answer some of your questions. Hope this helps. Kenn LBNL On 6/2/2009 8:23 AM, 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 mailto:sarah.clell...@snowvalley.com 10 Emerald Street, London, WC1N 3QA Website: http://www.snowvalley.com Blog: http://snowpatrol.snowvalley.com 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 ___ 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] no documentation for Shredder?
If you search the wiki for Shredder you find 1) Lots of notes to not do this, use Shredder instead 2) The extensions page where it says RTx::Shredder is not supported for 3.0, but that the functionality is built into 3.8 series But no documentation whatsoever on how to use Shredder. I'll try to fix, but since I'm learning this myself right now, other people adding good comments would be nice. -- 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] Default value for custom fields
Ken Crocker wrote: Matthew, Try creating a scrip that has the condition of OnCreate, an action as user-Defined and put code in the prep action code area that sets the CF to the value you want (see below). Put return 1; in the clean-up action area. That should do it. Prep Action code: # set the CF Work-Completed Date my $trans = $self-TransactionObj; my $ticket = $self-TicketObj; my $cf_obj = RT::CustomField-new($RT::SystemUser); my $cf_name = Work-Completed Date; my ( undef, undef, undef, $mon, $day, $year ) = localtime( time ); my $cf_value = sprintf( '%d/%02d/%02d', $year + 1900, $mon, $day ); $cf_obj-LoadByName(Name=$cf_name); $RT::Logger-debug(Loaded\$cf_obj-Name = . $cf_obj-Name() .\n); $ticket-AddCustomFieldValue(Field=$cf_obj, Value=$cf_value, RecordTransaction=0); return 1; Hmmm... Thanks. I'd pretty much already come to the conclusion a bit of scriping (if that's the appropriate gerund) would be necessary. Cheers, Matthew -- Dr Matthew Seaman The Bunker, Ash Radar Station PGP: 0x60AE908C on serversMarshborough Rd Tel: +44 1304 814890 Sandwich Fax: +44 1304 814899 Kent, CT13 0PL, UK signature.asc Description: OpenPGP digital signature ___ 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] Resend: Problems getting LDAP authentication working...
No bites on this so here is additional/updated information. Using RT 3.8.2 Using Plugin RT-Authen-ExternalAuth to connect to Windows Active Directory for authentication I cannot get the group E group_attr figured out to allow login by group only. What changes to my configuration do I need to make? My RT_SiteConfig.pm: Set( $rtname, 'XX'); Set($LogToFileNamed, /var/tmp/rt3.error); Set($LogToFile, 'debug'); Set($ExternalAuthPriority,['My_LDAP']); Set($ExternalInfoPriority,['My_LDAP']); Set(@Plugins,qw(RT::Authen::ExternalAuth)); Set($ExternalSettings, { 'My_LDAP' = { ## GENERIC SECTION # The type of service (db/ldap/cookie) 'type' = 'ldap', 'auth' = 1, 'info' = 1, # The server hosting the service 'server' = 'XXX.XXX.XXX.XXX', ## SERVICE-SPECIFIC SECTION # If you can bind to your LDAP server anonymously you should # remove the user and pass config lines, otherwise specify them here: # # The username RT should use to connect to the LDAP server 'user' = 'X', # The password RT should use to connect to the LDAP server 'pass' = 'X', # # The LDAP search base 'base' = 'ou=Campus,dc=ad,dc=cnc,dc=bc,dc=ca', # # ALL FILTERS MUST BE VALID LDAP FILTERS ENCASED IN PARENTHESES! # YOU **MUST** SPECIFY A filter AND A d_filter!! # # The filter to use to match RT-Users 'filter' = '(objectClass=User)', # A catch-all example filter: '(objectClass=*)' # # The filter that will only match disabled users 'd_filter' = '(userAccountConrol:1.2.840.113556.1.4.803:=2)', # A catch-none example d_filter: '(objectClass=FooBarBaz)' # # Should we try to use TLS to encrypt connections? 'tls' = 0, # SSL Version to provide to Net::SSLeay *if* using SSL 'ssl_version' = 3, # What other args should I pass to Net::LDAP-new($host,@args)? 'net_ldap_args' = [version = 3 ], # Does authentication depend on group membership? What group name? 'group' = 'CSER', # What is the attribute for the group object that determines membership? 'group_attr' = 'member', ## RT ATTRIBUTE MATCHING SECTION # The list of RT attributes that uniquely identify a user # This example shows what you *can* specify.. I recommend reducing this # to just the Name and EmailAddress to save encountering problems later. 'attr_match_list' = ['Name',
[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($ExternalAuthPriority, ['My_LDAP'] ); Set($ExternalInfoPriority,
[rt-users] BUG: no_tickets option in rt-shredder Users misses Cc people
rt-shredder --plugin help-Users (snip) no_tickets - boolean If true then plugin looks for users who are not watchers (Owners, Requestors, Ccs or AdminCcs) of any ticket. Well, using the following command gets me thousands of results: rt-shredder --plugin Users=no_tickets;status,any;replace_relations,Nobody;limit,1 -- sqldump /u/rtweb/shredder-restore-users.sql Investigating these users, I find that all of them are Ccs of tickets, but are not Requestors of any tickets. This seems to conflict with both the documentation for the option, and the expected result. -- 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
[rt-users] Creating Tickets Via Email
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? 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
[rt-users] RT 3.8.3 and AT 1.2.4b1 - Batch and Grid updates broken
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
[rt-users] Storing custom field file to local file system
I am writing a custom dhandler for a CMMS/Work Order system based on RT/AT. Essentially I have a Work Order Template (an OpenOffice ODT file with user-defined fields) that I populate with custom fields from an RT Ticket using command-line XMLstarlet tool. Everything is working when I store my template document on the file system.. ie. my $file = dirname($m-current_comp-source_file) . '/MaintenanceWO.odt'; But I want to get the template document from an Asset Custom Field. From outside of RT, and using LWP::Simple - I can do this - which works: my $asset = RTx::AssetTracker::Asset-new($RT::SystemUser); my $cf = RT::CustomFieldValue-new($RT::SystemUser); $asset-Load(WO Template); $cf = $asset-CustomFieldValues(File)-First; my $id = $cf-Id; my $url = RT-Config-Get('WebPath') . /Download/CustomFieldValue/.$cf-Id.'/'.$cf-Content; getstore($url,/tmp/temp.odt); Unfortunately from within the dhandler it does not work. There are authentication issues.. ie. it returns the RT login html instead of the template document. I tried appending ?user=rtuserpass=rtpassword to the url, but no luck. Within RT itself, is there a LWP::Simple::getstore equivalent?? Or perhaps more easily put: How do you extract a file from a custom field and store it on the local file system? Thanks, -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
Re: [rt-users] SuperUser shown in Owner selection list
Hi, Jo. I added a little note in the SuperUser article in the wiki last week after Elton wrote in. If people on the list want to accuracy- check it that would be great. http://wiki.bestpractical.com/view/ShredderControl - I think these are the instructions on how to use the Shredder (though I may be wrong). -- Cassandra Phillips-Sears Office Manager Best Practical Solutions, LLC http://www.bestpractical.com On Jun 2, 2009, at 1:30 PM 6/2/09, Jo Rhett wrote: On May 22, 2009, at 1:30 PM, Elton S. Fenner wrote: My suggestion is to put some note about this in the wiki (http://wiki.bestpractical.com/view/SuperUser ). Why not you? The wiki gets better the more you update it ;-) -- 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] Storing custom field file to local file system
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. -- -- 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
Re: [rt-users] no documentation for Shredder?
This is now documented at http://wiki.bestpractical.com/view/Shredder I just aimed for some easy to use recipies. It would be good for others to add what they know ;-) On Jun 2, 2009, at 10:57 AM, Jo Rhett wrote: If you search the wiki for Shredder you find 1) Lots of notes to not do this, use Shredder instead 2) The extensions page where it says RTx::Shredder is not supported for 3.0, but that the functionality is built into 3.8 series But no documentation whatsoever on how to use Shredder. I'll try to fix, but since I'm learning this myself right now, other people adding good comments would be nice. -- Jo Rhett Net Consonance : consonant endings by net philanthropy, open source and other randomness -- 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
[rt-users] Binary files broken since upgrade to RT 3.8
Dear RT users, I am trying to get our RT installation moved from RT 3.6.6 to 3.8.3. I've tried following the upgrade steps in the UPGRADING.mysql and the README files as diligently as I can. The DBMS is MySQL 5.0.45. I updated all the perl modules... When I try the new version, everything coming in works okay, but all the old binary attachments are broken, in truth, anything other than regular ascii is mangled (e.g. diacritical marks like é, ô, ç etc). If I try to open an image, it says The image http://rt/Ticket/Attachment/672/883/spots1.bmpcannot be displayed, because it contains errors.. Clearly I've either missed something or something has to be done to convert this data. If I convert the Content column back to longtext from longblob, then the binary data works again. Please advise what can I do to get the data into the new table schema. Thanks, - Dominic ___ 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] can I make Shredder Plugins use strict PLEASE?
So I've been chasing this bug around in the code for over an hour, and all I can say at this point is I REALLY HATE GLOBAL VARIABLES. There is absolutely no reason for having subroutines modify global variables, and it makes the code darn hard to debug. If I was to do the work to make all of these modules strict, would you accept the patches? On Jun 2, 2009, at 12:25 PM, Jo Rhett wrote: rt-shredder --plugin help-Users (snip) no_tickets - boolean If true then plugin looks for users who are not watchers (Owners, Requestors, Ccs or AdminCcs) of any ticket. Well, using the following command gets me thousands of results: rt-shredder --plugin Users=no_tickets;status,any;replace_relations,Nobody;limit,1 -- sqldump /u/rtweb/shredder-restore-users.sql Investigating these users, I find that all of them are Ccs of tickets, but are not Requestors of any tickets. This seems to conflict with both the documentation for the option, and the expected result. -- Jo Rhett Net Consonance : consonant endings by net philanthropy, open source and other randomness -- 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] Binary files broken since upgrade to RT 3.8
Did you apply the schema updates as indicated in steps 4-6 of UPGRADING.mysql? James Moseley Dominic Lepiane dominic.lepi...@ptgrey.com wrote: Dear RT users, I am trying to get our RT installation moved from RT 3.6.6 to 3.8.3. I've tried following the upgrade steps in the UPGRADING.mysql and the README files as diligently as I can. The DBMS is MySQL 5.0.45. I updated all the perl modules... When I try the new version, everything coming in works okay, but all the old binary attachments are broken, in truth, anything other than regular ascii is mangled (e.g. diacritical marks like é, ô, ç etc). If I try to open an image, it says The image http://rt/Ticket/Attachment/672/883/spots1.bmpcannot be displayed, because it contains errors.. Clearly I've either missed something or something has to be done to convert this data. If I convert the Content column back to longtext from longblob, then the binary data works again. Please advise what can I do to get the data into the new table schema. ___ 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] no documentation for Shredder?
Thank you, when you're learning things it's the best way to update wiki. I'll look into shredding users vs. ccs. On Wed, Jun 3, 2009 at 12:42 AM, Jo Rhett jrh...@netconsonance.com wrote: This is now documented at http://wiki.bestpractical.com/view/Shredder I just aimed for some easy to use recipies. It would be good for others to add what they know ;-) On Jun 2, 2009, at 10:57 AM, Jo Rhett wrote: If you search the wiki for Shredder you find 1) Lots of notes to not do this, use Shredder instead 2) The extensions page where it says RTx::Shredder is not supported for 3.0, but that the functionality is built into 3.8 series But no documentation whatsoever on how to use Shredder. I'll try to fix, but since I'm learning this myself right now, other people adding good comments would be nice. -- Jo Rhett Net Consonance : consonant endings by net philanthropy, open source and other randomness -- 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] Binary files broken since upgrade to RT 3.8
I did run steps 4-6 from the UPGRADING.mysql , yes. I've included the generated SQL below. I should note the DBMS is on a separate host from the RT (Apache / Postfix) server. Actually, now that I think about it, when I generated the SQL, there was this message: Use of uninitialized value in join or string at etc/upgrade/upgrade-mysql-schema.pl line 261. But as I recall, when I looked for more info on this only, other people reported seeing this message but then did not have any problems. When I ran the SQL (below), there was no error. It took a while, but did not produce any errors. Thanks, - Dominic ALTER DATABASE rt3 DEFAULT CHARACTER SET utf8; ALTER TABLE ACL DEFAULT CHARACTER SET utf8, MODIFY RightName VARBINARY(25) NOT NULL DEFAULT '', MODIFY PrincipalType VARBINARY(25) NOT NULL DEFAULT '', MODIFY ObjectType VARBINARY(25) NOT NULL DEFAULT ''; ALTER TABLE ACL MODIFY RightName VARCHAR(25) CHARACTER SET ascii NOT NULL DEFAULT '', MODIFY PrincipalType VARCHAR(25) CHARACTER SET ascii NOT NULL DEFAULT '', MODIFY ObjectType VARCHAR(25) CHARACTER SET ascii NOT NULL DEFAULT ''; ALTER TABLE Attachments DEFAULT CHARACTER SET utf8, MODIFY ContentType VARBINARY(80) NULL DEFAULT NULL, MODIFY MessageId VARBINARY(160) NULL DEFAULT NULL, MODIFY Content LONGBLOB NULL DEFAULT NULL, MODIFY ContentEncoding VARBINARY(80) NULL DEFAULT NULL; ALTER TABLE Attachments MODIFY ContentType VARCHAR(80) CHARACTER SET ascii NULL DEFAULT NULL, MODIFY MessageId VARCHAR(160) CHARACTER SET ascii NULL DEFAULT NULL, MODIFY ContentEncoding VARCHAR(80) CHARACTER SET ascii NULL DEFAULT NULL; ALTER TABLE Attributes DEFAULT CHARACTER SET utf8, MODIFY ContentType VARBINARY(16) NULL DEFAULT NULL, MODIFY Content BLOB NULL DEFAULT NULL, MODIFY ObjectType VARBINARY(64) NULL DEFAULT NULL; ALTER TABLE Attributes MODIFY ContentType VARCHAR(16) CHARACTER SET ascii NULL DEFAULT NULL, MODIFY ObjectType VARCHAR(64) CHARACTER SET ascii NULL DEFAULT NULL; ALTER TABLE CustomFields DEFAULT CHARACTER SET utf8, MODIFY LookupType VARBINARY(255) NOT NULL DEFAULT '', MODIFY Type VARBINARY(200) NULL DEFAULT NULL; ALTER TABLE CustomFields MODIFY LookupType VARCHAR(255) CHARACTER SET ascii NOT NULL DEFAULT '', MODIFY Type VARCHAR(200) CHARACTER SET ascii NULL DEFAULT NULL; ALTER TABLE CustomFieldValues DEFAULT CHARACTER SET utf8; ALTER TABLE GroupMembers DEFAULT CHARACTER SET utf8; ALTER TABLE Groups DEFAULT CHARACTER SET utf8, MODIFY Domain VARBINARY(64) NULL DEFAULT NULL, MODIFY Type VARBINARY(64) NULL DEFAULT NULL; ALTER TABLE Groups MODIFY Domain VARCHAR(64) CHARACTER SET ascii NULL DEFAULT NULL, MODIFY Type VARCHAR(64) CHARACTER SET ascii NULL DEFAULT NULL; ALTER TABLE Links DEFAULT CHARACTER SET utf8, MODIFY Target VARBINARY(240) NULL DEFAULT NULL, MODIFY Base VARBINARY(240) NULL DEFAULT NULL, MODIFY Type VARBINARY(20) NOT NULL DEFAULT ''; ALTER TABLE Links MODIFY Target VARCHAR(240) CHARACTER SET ascii NULL DEFAULT NULL, MODIFY Base VARCHAR(240) CHARACTER SET ascii NULL DEFAULT NULL, MODIFY Type VARCHAR(20) CHARACTER SET ascii NOT NULL DEFAULT ''; ALTER TABLE ObjectCustomFields DEFAULT CHARACTER SET utf8; ALTER TABLE ObjectCustomFieldValues DEFAULT CHARACTER SET utf8, MODIFY ContentType VARBINARY(80) NULL DEFAULT NULL, MODIFY LargeContent LONGBLOB NULL DEFAULT NULL, MODIFY ContentEncoding VARBINARY(80) NULL DEFAULT NULL, MODIFY ObjectType VARBINARY(255) NOT NULL DEFAULT ''; ALTER TABLE ObjectCustomFieldValues MODIFY ContentType VARCHAR(80) CHARACTER SET ascii NULL DEFAULT NULL, MODIFY ContentEncoding VARCHAR(80) CHARACTER SET ascii NULL DEFAULT NULL, MODIFY ObjectType VARCHAR(255) CHARACTER SET ascii NOT NULL DEFAULT ''; ALTER TABLE Principals DEFAULT CHARACTER SET utf8, MODIFY PrincipalType VARBINARY(16) NOT NULL DEFAULT ''; ALTER TABLE Principals MODIFY PrincipalType VARCHAR(16) CHARACTER SET ascii NOT NULL DEFAULT ''; ALTER TABLE Queues DEFAULT CHARACTER SET utf8, MODIFY CorrespondAddress VARBINARY(120) NULL DEFAULT NULL, MODIFY CommentAddress VARBINARY(120) NULL DEFAULT NULL; ALTER TABLE Queues MODIFY CorrespondAddress VARCHAR(120) CHARACTER SET ascii NULL DEFAULT NULL, MODIFY CommentAddress VARCHAR(120) CHARACTER SET ascii NULL DEFAULT NULL; ALTER TABLE ScripActions DEFAULT CHARACTER SET utf8, MODIFY Argument VARBINARY(255) NULL DEFAULT NULL, MODIFY ExecModule VARBINARY(60) NULL DEFAULT NULL; ALTER TABLE ScripActions MODIFY ExecModule VARCHAR(60) CHARACTER SET ascii NULL DEFAULT NULL; ALTER TABLE ScripConditions DEFAULT CHARACTER SET utf8, MODIFY ApplicableTransTypes VARBINARY(60) NULL DEFAULT NULL, MODIFY Argument VARBINARY(255) NULL DEFAULT NULL, MODIFY ExecModule VARBINARY(60) NULL DEFAULT NULL; ALTER TABLE ScripConditions MODIFY ApplicableTransTypes VARCHAR(60) CHARACTER SET ascii NULL DEFAULT NULL, MODIFY ExecModule VARCHAR(60) CHARACTER SET
Re: [rt-users] BUG: no_tickets option in rt-shredder Users misses Cc people
I found the bug. It's a documentation bug mostly -- the no_tickets option is listed as binary, which said to me no value should be provided. However, if you don't define a value (like quoted below) then it doesn't work. This code change would allow it to be used either way: --- Users.pm_orig 2009-06-02 12:28:24.0 -0700 +++ Users.pm2009-06-02 14:25:26.0 -0700 @@ -165,7 +165,7 @@ ); } -if( $self-{'opt'}{'no_tickets'} ) { +if( exists $self-{'opt'}{'no_tickets'} ) { return $self-FilterWithoutTickets( Shredder = $args{'Shredder'}, Objects = $objs, On Jun 2, 2009, at 12:25 PM, Jo Rhett wrote: rt-shredder --plugin help-Users (snip) no_tickets - boolean If true then plugin looks for users who are not watchers (Owners, Requestors, Ccs or AdminCcs) of any ticket. Well, using the following command gets me thousands of results: rt-shredder --plugin Users=no_tickets;status,any;replace_relations,Nobody;limit,1 -- sqldump /u/rtweb/shredder-restore-users.sql Investigating these users, I find that all of them are Ccs of tickets, but are not Requestors of any tickets. This seems to conflict with both the documentation for the option, and the expected result. -- Jo Rhett Net Consonance : consonant endings by net philanthropy, open source and other randomness -- 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] Binary files broken since upgrade to RT 3.8
I believe you used backuprestore of original production DB, didn't you? In this case you probably mangled data on load. Use --default-character-set=binary on mysqldump and later on mysql load. This only required for not upgraded DBs, after proper upgrade you don't need this option. On Wed, Jun 3, 2009 at 12:55 AM, Dominic Lepiane dominic.lepi...@ptgrey.com wrote: Dear RT users, I am trying to get our RT installation moved from RT 3.6.6 to 3.8.3. I've tried following the upgrade steps in the UPGRADING.mysql and the README files as diligently as I can. The DBMS is MySQL 5.0.45. I updated all the perl modules... When I try the new version, everything coming in works okay, but all the old binary attachments are broken, in truth, anything other than regular ascii is mangled (e.g. diacritical marks like é, ô, ç etc). If I try to open an image, it says The image http://rt/Ticket/Attachment/672/883/spots1.bmpcannot be displayed, because it contains errors.. Clearly I've either missed something or something has to be done to convert this data. If I convert the Content column back to longtext from longblob, then the binary data works again. Please advise what can I do to get the data into the new table schema. Thanks, - Dominic ___ 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] Binary files broken since upgrade to RT 3.8
Hmmm, usually the cause of binary attachments not displaying properly is because folks didn't apply the 'mysql 4.1' update... James Moseley Dominic Lepiane dominic.lepi...@ptgrey.com wrote: I did run steps 4-6 from the UPGRADING.mysql , yes. I've included the generated SQL below. I should note the DBMS is on a separate host from the RT (Apache / Postfix) server. Actually, now that I think about it, when I generated the SQL, there was this message: Use of uninitialized value in join or string at etc/upgrade/upgrade-mysql-schema.pl line 261. But as I recall, when I looked for more info on this only, other people reported seeing this message but then did not have any problems. When I ran the SQL (below), there was no error. It took a while, but did not produce any errors. ___ 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 RT Groups and LDAP group.
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? Kevin W. Gagel Network Administrator Local 5448 My blog: http://mail.cnc.bc.ca/blogs/gagel My shared files: http://mail.cnc.bc.ca/users/gagel ___ 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] BUG: shredder noticket option ignores deleted messages
The shredder users module will delete users actively assigned to tickets which are Deleted. I suspect that the tickets should be Wiped before these users are removed. --- Users.pm_orig 2009-06-02 12:28:24.0 -0700 +++ Users.pm2009-06-02 15:34:56.0 -0700 @@ -219,7 +219,8 @@ sub _WithoutTickets { my ($self, $user) = @_; my $tickets = RT::Tickets-new( $RT::SystemUser ); -$tickets-FromSQL( 'Watcher.id = '. $user-id ); + $tickets-{'allow_deleted_search'} = 1; $tickets-FromSQL( 'Watcher.id = '. $user-id ); # HACK: we may use Count method which counts all records # that match condtion, but we really want to know only that # at least one record exist, so we fetch first row only -- 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
[rt-users] Shredder notickets finds users who have valid contributions
Okay, so this is something I'm not sure how to resolve. I open a ticket for jo.rh...@company.com. Jo receives his e-mail, and sends replies to me from j...@company.com. Obviously a second user is created for jo@ but it's also picked up to be deleted by Scrubber. I'm not sure this is the right approach. Is there any way to modify the query done to pick up any valid contributor? All we really want to do is delete users whose tickets have been deleted (ie spam) -- 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] BUG: shredder noticket option ignores deleted messages
Sorry, revised patch is: --- Users.pm_orig 2009-06-02 12:28:24.0 -0700 +++ Users.pm2009-06-02 15:34:56.0 -0700 @@ -219,7 +219,8 @@ sub _WithoutTickets { my ($self, $user) = @_; my $tickets = RT::Tickets-new( $RT::SystemUser ); + $tickets-{'allow_deleted_search'} = 1; $tickets-FromSQL( 'Watcher.id = '. $user-id ); # HACK: we may use Count method which counts all records # that match condtion, but we really want to know only that # at least one record exist, so we fetch first row only -- 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] Binary files broken since upgrade to RT 3.8
Hi, I'm not too clear what you mean. In creating the test system, I did backup restore the db. But I built a 3.6.6 system and then tested the upgrade from that database. So I stopped Apache and Postfix, removed the old /opt/rt3 folder, make install to get the new 3.8 files, and then followed the upgrade instructions including the rt-setup-database and upgrade-mysql-schema.pl scripts. At this point, I'm simply trying to get a handful of binary attachments working with a simple script to spit out the image entirely independent of RT. So I'm doing this: mysqldump --default-character-set=binary --compact -c -t -q -Q -w TransactionId 2500 AND ContentType=\image/bmp\ -u root rt3 Attachments /data/attachments-dump4.sql mysql --default-character-set=binary -u root rttest attachments-dump4.sql As you can sortof see, I'm trying to dump a couple attachments from the 3.6.6 rt3 database which contain image/bmp data and then restoring to the test database. I have a couple PHP scripts which simply spit out the ContentType as the Content-type header first and then echo the Content second. And it looks to me like the data coming out of the rttest database still is broken. However, I know that if I push new tickets in to the upgraded RT 3.8.3, those images do come out good the same as the old data does under 3.6.6. I must still be confused or missing something though, what do I do now? Thanks, - Dominic Ruslan Zakirov wrote: I believe you used backuprestore of original production DB, didn't you? In this case you probably mangled data on load. Use --default-character-set=binary on mysqldump and later on mysql load. This only required for not upgraded DBs, after proper upgrade you don't need this option. On Wed, Jun 3, 2009 at 12:55 AM, Dominic Lepiane dominic.lepi...@ptgrey.com wrote: Dear RT users, I am trying to get our RT installation moved from RT 3.6.6 to 3.8.3. I've tried following the upgrade steps in the UPGRADING.mysql and the README files as diligently as I can. The DBMS is MySQL 5.0.45. I updated all the perl modules... When I try the new version, everything coming in works okay, but all the old binary attachments are broken, in truth, anything other than regular ascii is mangled (e.g. diacritical marks like é, ô, ç etc). If I try to open an image, it says The image http://rt/Ticket/Attachment/672/883/spots1.bmpcannot be displayed, because it contains errors.. Clearly I've either missed something or something has to be done to convert this data. If I convert the Content column back to longtext from longblob, then the binary data works again. Please advise what can I do to get the data into the new table schema. Thanks, - Dominic ___ 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] Binary files broken since upgrade to RT 3.8
I'm not too clear what you mean. In creating the test system, I did backup restore the db. But I built a 3.6.6 system and then tested the upgrade from that database. So I stopped Apache and Postfix, removed the old /opt/rt3 folder, make install to get the new 3.8 files, and then followed the upgrade instructions including the rt-setup-database and upgrade-mysql-schema.pl scripts. [snip] Check the list archives. Odds are, you ran upgrade-mysql-schema.pl but did not run the SQL script that it generates to actually upgrade the schema. update-mysql-schema.pl does NOT upgrade the mysql schema. It generates a script to do so. I asked Jesse about changing the name of the script but he didn't seem to think it was a good idea, and yet people keep thumping into this. -- -- 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
Re: [rt-users] Binary files broken since upgrade to RT 3.8
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 027 212 6638 aa...@guise.net.nz * On Wed, Jun 3, 2009 at 11:14 AM, Dominic Lepiane dominic.lepi...@ptgrey.com wrote: Hi, I'm not too clear what you mean. In creating the test system, I did backup restore the db. But I built a 3.6.6 system and then tested the upgrade from that database. So I stopped Apache and Postfix, removed the old /opt/rt3 folder, make install to get the new 3.8 files, and then followed the upgrade instructions including the rt-setup-database and upgrade-mysql-schema.pl scripts. At this point, I'm simply trying to get a handful of binary attachments working with a simple script to spit out the image entirely independent of RT. So I'm doing this: mysqldump --default-character-set=binary --compact -c -t -q -Q -w TransactionId 2500 AND ContentType=\image/bmp\ -u root rt3 Attachments /data/attachments-dump4.sql mysql --default-character-set=binary -u root rttest attachments-dump4.sql As you can sortof see, I'm trying to dump a couple attachments from the 3.6.6 rt3 database which contain image/bmp data and then restoring to the test database. I have a couple PHP scripts which simply spit out the ContentType as the Content-type header first and then echo the Content second. And it looks to me like the data coming out of the rttest database still is broken. However, I know that if I push new tickets in to the upgraded RT 3.8.3, those images do come out good the same as the old data does under 3.6.6. I must still be confused or missing something though, what do I do now? Thanks, - Dominic Ruslan Zakirov wrote: I believe you used backuprestore of original production DB, didn't you? In this case you probably mangled data on load. Use --default-character-set=binary on mysqldump and later on mysql load. This only required for not upgraded DBs, after proper upgrade you don't need this option. On Wed, Jun 3, 2009 at 12:55 AM, Dominic Lepianedominic.lepi...@ptgrey.com dominic.lepi...@ptgrey.com wrote: Dear RT users, I am trying to get our RT installation moved from RT 3.6.6 to 3.8.3. I've tried following the upgrade steps in the UPGRADING.mysql and the README files as diligently as I can. The DBMS is MySQL 5.0.45. I updated all the perl modules... When I try the new version, everything coming in works okay, but all the old binary attachments are broken, in truth, anything other than regular ascii is mangled (e.g. diacritical marks like é, ô, ç etc). If I try to open an image, it says The imagehttp://rt/Ticket/Attachment/672/883/spots1.bmpcannot be displayed, because it contains errors.. Clearly I've either missed something or something has to be done to convert this data. If I convert the Content column back to longtext from longblob, then the binary data works again. Please advise what can I do to get the data into the new table schema. Thanks, - Dominic ___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 ___ 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 on Oracle - ORA-04043 object Attachments does not exist
I am getting an error when rt-mailgate sends an email to RT saying that the Attachments object does not exist. The email is received and the details of it are written to the database, however the body of the email is missing. Has anyone dealt with this? I am on Oracle 10.2.0, running RT on openSuSE 11.1 using the full administrator install of the Oracle client. ___ 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