[rt-users] Request for advice or assistance - rt-validator/upgrade
Hi folks, I asked (badly) about this a bit ago, and I'm hoping someone might have a suggestion. I'm trying to run an upgrade from 3.8.7 to the latest, but when I'm running the rt-validator before the database upgrade, I'm hitting multiple errors as follows : Record #600812 in Attachments references not existent record in Attachments Parent => '600810' => id Attachment #600812 -> Txn #1567410, Transaction #1567410 -> object RT::Ticket #187695 I tried using shredder to delete the tickets in question, but am still seeing the error. Does anyone have any recommendations on how to proceed? Many thanks for any assistance Arnon We're hiring! http://bestpractical.com/jobs
[rt-users] Shredder not shredding attachments?
So I'm running validator and getting the following error for a few tickets : example : Record #600816 in Attachments references not existent record in Attachments Parent => '600813' => id Attachment #600816 -> Txn #1567423, Transaction #1567423 -> object RT::Ticket #187697 I attempted to fix this using shredder for ticket ID 187697 (succesfully), but am still getting the error. How do I shred the attachment itself? I'm afraid I'm not sure what the query would be. Many thanks for any assistance Arnon We're hiring! http://bestpractical.com/jobs
[rt-users] wondering about webdomain & organization
Hey all, I'm having a problem where correspondence isn't being created properly on creation of a ticket. The following error is showing up in my log: [Mon May 28 14:17:25 2012] [info]: #50/997661 - Scrip 22 On create email requestor (/opt/rt4/sbin/../lib/RT/Action/SendEmail.pm:301) [Mon May 28 14:17:25 2012] [info]: No recipients found. Not sending. (/opt/rt4/sbin/../lib/RT/Interface/Email.pm:352) I've gone through the various forums and seen a number of different reasons this could be happening. Mail works fine, tickets are sent out appropriately, it's only on creation from external addresses that the reply to requestors isn't created. I'm running 4.0.5 (upgrading to the new patch soon) and using a DB I ported over from an earlier install for test purposes (already at 4.0.5 as well). Eventually I wish to port over a few hundred thousand tickets from an existing install on 3.8.7 on another box, and the RT_Site_Config below is adapted from that. I was given to understand that I need to leave the 'rtname' the same or risk bucking all earlier tickets. is this the case? I changed the webdomain from 'ticketing.company.com' to 'prometheus.support.company.com' (for value $company) to match the actual new server name. saniticed site_config: # Any configuration directives you include here will override # RT's default configuration file, RT_Config.pm # # To include a directive here, just copy the equivalent statement # from RT_Config.pm and change the value. We've included a single # sample value below. # # This file is actually a perl module, so you can include valid # perl code, as well. # # The converse is also true, if this file isn't valid perl, you're # going to run into trouble. To check your SiteConfig file, use # this comamnd: # # perl -c /path/to/your/etc/RT_SiteConfig.pm Set($WebBaseURL , "https://prometheus.support.commpany.com";); Set($rtname, 'easydns'); Set($Organization , "prometheus.support.company.com"); Set($WebPort, 443); Set($WebDomain, "prometheus.support.company.com"); Set($WebImagesURL, RT->Config->Get('WebPath') . "/NoAuth/images/"); Set($LogoURL, RT->Config->Get('WebImagesURL') . "easydns_logo.gif"); #Set($MailCommand, "testfile"); Set($MailCommand, "sendmailpipe"); Set($DatabaseHost, 'localhost'); Set($MessageBoxRichText , 0); Set($DatabaseType, "mysql"); Set($DatabaseUser , 'userid'); Set($DatabasePassword , 'password'); Set($DatabaseName , 'rt4'); Set($UseFriendlyFromLine, 1); Set($FriendlyFromLineFormat, "\"%s from company\" <%s>"); Set($UseOriginatorHeader, 0); Set($CorrespondAddress, 'supp...@support.company.com'); Set($CommentAddress, 'supp...@support.company.com'); Set($OwnerEmail, 'ar...@support.company.com'); Set($LoopsToRTOwner, 1); Set($ForwardFromUser, 0); Set($SendmailPath, "/usr/sbin/sendmail"); Set($DefaultQueue, "Support"); Set($RememberDefaultQueue, 1); Set($LogDir, '/var/log/'); Set($LogToFileNamed , "rt_output.log");#log to rt.log Set($ShowMoreAboutPrivilegedUsers, 1); Set($MoreAboutRequestorTicketList, "Active"); Set($MoreAboutRequestorGroupsLimit, 5); Set($AutocompleteOwners, 1); Set($ShowUnreadMessageNotifications, 1); Set($DisplayTicketAfterQuickCreate, 1); #experimental Set($ApprovalRejectionNotes, 0); Set($StrictLinkACL, 0); Set(@Active_MakeClicky, qw()); Set($PlainTextPre, 1); #Set($PlainTextMono, 0); Set($MessageBoxIncludeSignatureOnComment, 0); Set($DeferTransactionLoading, 1); Set($MessageBoxRichText, 1); Set($MessageBoxIncludeSignature, 1); Set($ArticleOnTicketCreate, 1); Set($UserAutocompleteFields, { EmailAddress => 'STARTSWITH', Name => 'STARTSWITH', RealName => 'LIKE', }); Set($SimplifiedRecipients, 1); Set($UseSQLForACLChecks , 1); Set($RTAddressRegexp, undef); Set($ChartsTimezonesInDB, 1); Set($LogToFile , 'debug'); #debug is very noisy Set(%FullTextSearch, Enable => 1, Indexed => 0, ); #For later enablement #security related #Set($WebSecureCookies, 1); #Set($MinimumPasswordLength, 8); #these next two go together with details on generating regex in rt_Config #Set($ParseNewMessageForTicketCcs, undef); #Set($RTAddressRegexp, undef); #Required for use with reverse proxying #Set($CanonicalizeRedirectURLs, 0); #for external auth ## Couldn't figure this out quickly, so dropping it for now. - eroberts - 2010-05-31 #Set($CanonicalizeEmailAddressMatch , '@evanroberts\.com$'); #Set($CanonicalizeEmailAddressReplace , '@easydns.com'); #Set($CanonicalizeOnCreate, 0); #Set(@Plugins,(qw(RT::Extension::SummaryByUser))); #Set($HomepageComponents, [qw(OwnerSummary Quicksearch)]); #Set($WebImagesURL , $WebPath . "/NoAuth/images/"); # need this for below #Set($LogoURL, $WebImagesURL . "company_logo.gif"); #Set($LogoLinkURL, 'https://ticketing.easydns.com'); #Set($LogoImageURL, $WebImagesURL . "easydns_logo.gif"); #Set($LogoAltText, "easyDNS Technologies Inc."); #Set(@Plugins,(qw(Extension::QuickDelete RT::FM))); ;
[rt-users] Problem with XML::Parser
I've got a Centos 5.8 machine with Perl 14.2 running on it, and I'm having the devil's own time getting XML::Parser installed. CPAN returns errors regarding expat when I try and make manually through it. I can respond with the detailed error messages, but I was wondering if anyone had run into this yet. I didn't find anything on Gossamer. I know there's an issue with Expat for Centos, but I installed via the RPM and I thought I had itr good, though I seem to be incorrect. Let me know what specifics you want in terms of system config and I'll provide. Regards Arnon
[rt-users] Solved : Re: Error running rt-validator
Curse my over-exuberance. I forgot step 6b in the readme. Obviously Validator is going to fail if the DB schema is off, and other assorted dumbs. Many thanks to Kevin's swift and accurate catch of it on the chat-room! RTFM. Always RTFM. Thanks! A On 11-12-19 10:39 AM, Arnon Clark wrote: Hey folks, I'm trying to run validator and am running into the following error : Executing query: SELECT m.id, g.id, g.Instance FROM Groups g JOIN ACL m ON g.id = m.LastUpdatedBy WHERE g.Domain = ? AND g.Type = ? [Mon Dec 19 15:38:54 2011] [warning]: DBD::mysql::st execute failed: Unknown column 'm.LastUpdatedBy' in 'on clause' at ./sbin/rt-validator line 1078. (./sbin/rt-validator:1078) [Mon Dec 19 15:38:54 2011] [crit]: DBD::mysql::st execute failed: Unknown column 'm.LastUpdatedBy' in 'on clause' at ./sbin/rt-validator line 1078. (/home/arnon/rt-4.0.4/sbin/../lib/RT.pm:341) DBD::mysql::st execute failed: Unknown column 'm.LastUpdatedBy' in 'on clause' at ./sbin/rt-validator line 1078. Circumstances : I've got a clean install of 4.0.4, bringing in a DB from 3.8.7 I import the mysql dump I made, run the vulnerable passwords, shrink-transactions and shrink cgm scripts, but when I check with validator, I get that error. Any suggestions? Regards, and thanks Arnon RT Training Sessions (http://bestpractical.com/services/training.html) * Boston March 5 & 6, 2012 RT Training Sessions (http://bestpractical.com/services/training.html) * Boston March 5 & 6, 2012
[rt-users] Error running rt-validator
Hey folks, I'm trying to run validator and am running into the following error : Executing query: SELECT m.id, g.id, g.Instance FROM Groups g JOIN ACL m ON g.id = m.LastUpdatedBy WHERE g.Domain = ? AND g.Type = ? [Mon Dec 19 15:38:54 2011] [warning]: DBD::mysql::st execute failed: Unknown column 'm.LastUpdatedBy' in 'on clause' at ./sbin/rt-validator line 1078. (./sbin/rt-validator:1078) [Mon Dec 19 15:38:54 2011] [crit]: DBD::mysql::st execute failed: Unknown column 'm.LastUpdatedBy' in 'on clause' at ./sbin/rt-validator line 1078. (/home/arnon/rt-4.0.4/sbin/../lib/RT.pm:341) DBD::mysql::st execute failed: Unknown column 'm.LastUpdatedBy' in 'on clause' at ./sbin/rt-validator line 1078. Circumstances : I've got a clean install of 4.0.4, bringing in a DB from 3.8.7 I import the mysql dump I made, run the vulnerable passwords, shrink-transactions and shrink cgm scripts, but when I check with validator, I get that error. Any suggestions? Regards, and thanks Arnon RT Training Sessions (http://bestpractical.com/services/training.html) * Boston March 5 & 6, 2012
[rt-users] Issue with mailgate on rt4
Hola, I'm reasonably sure this is a permissions issue, (and an utter noob question) but I'm afraid I don't know where RT creates the tmpdir. so I'm not certain where to fix that. Debian install of RT4.0.4, MYSQL, and I'm, able to create tickets fine, but when mail comes in Postfix returns a deferral with the following error : (temporary failure. Command output: /opt/rt4/bin/rt-mailgate: Couldn't create temp file, using memory error: Error in tempdir() using XX: Could not create directory KVG5obldxe: Permission denied at /opt/rt4/bin/rt-mailgate line 266 RT server error. The RT server which handled your email did not behave as expected. It said: Can't call method "crit" on an undefined value at /opt/rt4/sbin/../lib/RT/EmailParser.pm line 483. Stack: [/opt/rt4/sbin/../lib/RT/EmailParser.pm:483] [/opt/rt4/sbin/../lib/RT/EmailParser.pm:203] [/opt/rt4/sbin/../lib/RT/EmailParser.pm:168] [/opt/rt4/sbin/../lib/RT/EmailParser.pm:138] [/opt/rt4/sbin/../lib/RT/Interface/Email.pm:1344] [/opt/rt4/share/html/REST/1.0/NoAuth/mail-gateway:61] ) Any suggestions as to what I bugged up? Thanks! A RT Training Sessions (http://bestpractical.com/services/training.html) * Barcelona, Spain November 28 & 29, 2011