Re: [rt-users] RT on MAC
On 07/24/2013 01:02 PM, Kenneth Crocker wrote: I have an IMAC with Windows 7 running on Parallels. Is it possible to install RT into that environment? If so, what are the system requirements and do you have a good set of installation instructions for this If your iMac is running a vaguely recent version of Mac OS X then RT should be fairly easy to install natively on your mac. See the Mac OS X section of http://requesttracker.wikia.com/wiki/InstallationGuides for hints, but be aware that these guides are unofficial and may be outdated. The official documentation here: http://bestpractical.com/docs/rt/4.0/ is probably the best starting point. Make sure you have a suitable Perl version installed, download unpack the RT source code, run make fixdeps to make sure you have appropriate Perl modules, and generally follow the install guide. As far as I know the RT server its self doesn't run on Windows. -- Craig Ringer http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Training Services
[rt-users] Warnings in log files after update to 4.0.13
Hi ! We updated RT to 4.0.13, everything works, but there are now warnings in the log files. For example: Jul 24 15:22:19 rt RT: Use of uninitialized value in string eq at (eval 1895) line 1. ((eval 1895):1) Jul 24 15:22:19 rt RT: Use of uninitialized value in string eq at (eval 1926) line 1. ((eval 1926):1) Jul 24 15:22:28 rt RT: Use of uninitialized value in string eq at (eval 1882) line 1. ((eval 1882):1) Jul 24 15:22:28 rt RT: Use of uninitialized value in string eq at (eval 1913) line 1. ((eval 1913):1) Jul 24 15:22:33 rt RT: Use of uninitialized value in string eq at (eval 1946) line 1. ((eval 1946):1) Perl is not our native language ;-) , so maybe someone can help me where to look for the problem. Thx. Greets Robin
[rt-users] Auto reply only working on one queue despite being global
I have received complaints that several of our queues are not sending auto replies on ticket creation. We run a pretty vanilla install of RT 4.0.7 on Ubuntu. I am seeing log messages like this when the autoreplies do not work: [Mon Jul 22 20:45:41 2013] [debug]: Converting 'iso-8859-1' to 'utf-8' for text/plain - Subjectless message (/opt/rt4/sbin/../lib/RT/I18N.pm:233) [Mon Jul 22 20:45:41 2013] [debug]: Encode::Guess guessed encoding: ascii (/opt/rt4/sbin/../lib/RT/I18N.pm:467) [Mon Jul 22 20:45:41 2013] [debug]: Encode::Guess guessed encoding: ascii (/opt/rt4/sbin/../lib/RT/I18N.pm:467) [Mon Jul 22 20:45:41 2013] [debug]: Mail from user #8321 ( gpit...@rec.ri.cmu.edu) (/opt/rt4/sbin/../lib/RT/Interface/Email/Auth/MailFrom.pm:79) [Mon Jul 22 20:45:41 2013] [debug]: About to think about scrips for transaction #384368 (/opt/rt4/sbin/../lib/RT/Transaction.pm:173) [Mon Jul 22 20:45:41 2013] [debug]: About to think about scrips for transaction #384369 (/opt/rt4/sbin/../lib/RT/Transaction.pm:173) [Mon Jul 22 20:45:41 2013] [debug]: About to think about scrips for transaction #384370 (/opt/rt4/sbin/../lib/RT/Transaction.pm:173) [Mon Jul 22 20:45:41 2013] [debug]: About to think about scrips for transaction #384371 (/opt/rt4/sbin/../lib/RT/Transaction.pm:173) [Mon Jul 22 20:45:41 2013] [debug]: About to think about scrips for transaction #384372 (/opt/rt4/sbin/../lib/RT/Transaction.pm:173) [Mon Jul 22 20:45:41 2013] [debug]: About to prepare scrips for transaction #384372 (/opt/rt4/sbin/../lib/RT/Transaction.pm:177) [Mon Jul 22 20:45:41 2013] [debug]: Found 5 scrips for TransactionCreate stage with applicable type(s) Create for txn #384372 on ticket #23536 (/opt/rt4/sbin/../lib/RT/Scrips.pm:377) [Mon Jul 22 20:45:41 2013] [error]: Template parsing error: RT::Queue::Tag Unimplemented in Text::Template::GEN58. (template line 12) Stack: [/opt/rt4/sbin/../local/lib/DBIx/SearchBuilder/Record.pm:494] [template:12] [/opt/rt4/sbin/../lib/RT/Template.pm:478] [/opt/rt4/sbin/../lib/RT/Template.pm:434] [/opt/rt4/sbin/../lib/RT/Template.pm:363] [/opt/rt4/sbin/../lib/RT/Template.pm:343] [/opt/rt4/sbin/../lib/RT/Action/SendEmail.pm:154] [/opt/rt4/sbin/../lib/RT/Action/Autoreply.pm:66] [/opt/rt4/sbin/../lib/RT/ScripAction.pm:226] [/opt/rt4/sbin/../lib/RT/Scrip.pm:448] [/opt/rt4/sbin/../lib/RT/Scrips.pm:234] [/opt/rt4/sbin/../lib/RT/Transaction.pm:179] [/opt/rt4/sbin/../lib/RT/Record.pm:1461] [/opt/rt4/sbin/../lib/RT/Ticket.pm:676] [/opt/rt4/sbin/../lib/RT/Interface/Email.pm:1530] [/opt/rt4/share/html/REST/1.0/NoAuth/mail-gateway:61] (/opt/rt4/sbin/../lib/RT/Template.pm:473) [Mon Jul 22 20:45:41 2013] [debug]: Skipping Scrip #2 because it didn't Prepare (/opt/rt4/sbin/../lib/RT/Scrips.pm:237) [Mon Jul 22 20:45:41 2013] [debug]: Converting 'utf-8' to 'utf-8' for text/plain - [OPS #23536] test (/opt/rt4/sbin/../lib/RT/I18N.pm:233) [Mon Jul 22 20:45:41 2013] [debug]: Skipping Scrip #15 because it isn't applicable (/opt/rt4/sbin/../lib/RT/Scrips.pm:229) [Mon Jul 22 20:45:41 2013] [debug]: About to commit scrips for transaction #384372 (/opt/rt4/sbin/../lib/RT/Transaction.pm:200) [Mon Jul 22 20:45:41 2013] [debug]: Committing scrip #3 on txn #384372 of ticket #23536 (/opt/rt4/sbin/../lib/RT/Scrips.pm:182) [Mon Jul 22 20:45:41 2013] [debug]: Calling SetRecipientDigests for transaction RT::Transaction=HASH(0x915ab38), id 384372 (/opt/rt4/sbin/../lib/RT/Action/SendEmail.pm:644) [Mon Jul 22 20:45:41 2013] [debug]: Working on mailfield To; recipients are (/opt/rt4/sbin/../lib/RT/Action/SendEmail.pm:660) We do use the Subject Tag in all our queues if that is what the Template parsing error: RT::Queue::Tag Unimplemented line is complaining about. I also have added a autoreply scrip to just one queue and it fails with the same messages as above. I would like advise on how to troubleshoot this problem.
[rt-users] blah.b...@foo.com is an address RT receives mail at
Just noticed that if I try to create a ticket with a particular client as requestor, I get the message that this is the RT email address and that I will create a mail loop. This most certainly is NOT the RT correspondence address. I see a couple of previous threads mentioning this, but no obvious resolution. Any clues or pointers as got how to fix this apparent configuration problem? Later, Andy Yada, yada, yada... Disclaimer: This e-mail and any attachments are confidential and intended solely for the use of the recipient(s) to whom they are addressed. If you have received it in error, please destroy all copies and inform the sender. -- The University of Edinburgh is a charitable body, registered in Scotland, with registration number SC005336.
Re: [rt-users] Error when sending or reciving mail (fork::abort: address space needed by xxx)
Thanks Thomas I think this has put me on the right track. i found and tweeked the mysqltuner.pl to run on mysql database (needed the host ip address to login into mysql) This suggested that i increase afew max table/cache values to optimize my database. i then Optimized all my databases and increase the Virtual memory on the machine This has resulted in me being able to send emails from RT again (yeah!), but the (fork::abort: address space needed by xxx) errors are still sometimes appearing in the error.log but as of yet have not caused any more disruption knowing that this will be a ticking time bomb if i leave it in this state, Do you have any advice on how to tune Apache? Is there an equivalent 'Apachetuner.pl' that you know of as the mysqltuner.pl was very handly for a beginner like me -- View this message in context: http://requesttracker.8502.n7.nabble.com/Error-when-sending-or-reciving-mail-fork-abort-address-space-needed-by-xxx-tp54702p54715.html Sent from the Request Tracker - User mailing list archive at Nabble.com.
Re: [rt-users] asset tracker config
So I do believe it's a permissions issue, but I cant find it. If I log in as root, the asset drop down in the upper right works, and two asset types are there. However, as a normal privileged user logs in, there are no types.I have gone to select types, group rights, and for system and roles, set ALL the permissions (everyone, priv, etc)! I also set the user defined groups for the groups I have, still nothing under the asset type drop down... what am I missing? Thanks. 2013/7/17 Brumm, Torsten / Kuehne + Nagel / Ham GI-ID torsten.br...@kuehne-nagel.com: Asset Types are mainly the same like Queues inside RT, you can/must give propper Rights also to Asset Types that users can work. Torsten -Ursprüngliche Nachricht- Von: rt-users-boun...@lists.bestpractical.com [mailto:rt-users-boun...@lists.bestpractical.com] Im Auftrag von SSzretter Gesendet: Dienstag, 16. Juli 2013 14:07 An: rt-users@lists.bestpractical.com Betreff: [rt-users] asset tracker config Is there any documentation for Asset Tracker? I managed to get it installed (via apt-get and added to my siteconfig plugins 'set'). It shows up now, but the end users do not see any asset types in the drop down for 'create asset'. I am guessing it's a rights/permissions issue, but I added some rights to the type for the user groups (see type and a few others), and still nothing in the drop down. Are there any docs, or can someone explain what I need to do to make the types appear for people? Thanks! Kühne + Nagel (AG Co.) KG, Geschäftsleitung: Hans-Georg Brinkmann (Vors.), Dirk Blesius, Reiner Heiken, Holger Ketz (Stellv.), Jan-Hendrik Köstergarten (Stellv.), Bruno Mang, Christian Marnetté, Jens Wollesen, Sitz: Bremen, Registergericht: Bremen, HRA 21928, USt-IdNr.: DE 812773878, Persönlich haftende Gesellschaft: Kühne Nagel A.G., Sitz: Contern/Luxemburg Geschäftsführender Verwaltungsrat: Karl Gernandt Wir arbeiten ausschließlich auf Grundlage der Allgemeinen Deutschen Spediteursbedingungen (ADSp), jeweils neuester Fassung. Wir verweisen insbesondere auf die vom Gesetz abweichen den Haftungsbeschränkungen von Ziffer 23 und 24 ADSp. Den vollständigen Text der ADSp übersenden wir Ihnen gerne auf Anfrage und können Sie auch unter http://www.kn-portal.com einsehen. Ergänzend wird vereinbart, dass (1) Ziffer 27 ADSp im Rahmen internationaler Übereinkommen weder unsere Haftung noch die Zurechnung des Verschuldens von Leuten und sonstigen Dritten zu Gunsten des Auftraggebers erweitert, und (2) wir in den im deutschen Seehandelsrecht aufgeführten Fällen des nautischen Verschuldens oder Feuer an Bord nur für eigenes Verschulden und (3) im Sinne der CMNI genannten Voraussetzungen nicht für nautisches Verschulden, Feuer an Bord oder Mängel des Schiffes haften.
Re: [rt-users] Error when adding user to RT 4 (email exists)
Thanks Thomas. This worked for me. (I'm a newbie, so just learning the ropes.)RickOn Jul 23, 2013, at 05:43 PM, Thomas Sibley t...@bestpractical.com wrote:On 07/23/2013 02:31 PM, window camera wrote:Thanks. Unfortunately there is nothing like that in the latest RTversion. Plus, this is an unprivileged user, so it probably wouldn'tshow up anyway. Not sure. Tools - Configuration - Users The search form shows up there. Unprivileged users are shown in user searches, but not when you first load the page (since there are often thousands of unprivileged users).
Re: [rt-users] Notifications are sent before status and custom field changes are applied?
On 07/23/2013 12:56 AM, Craig Ringer wrote: Do any of the other RT users here know of a reason *not* to use TransactionBatch for sending email notifications? Be wary of $self-TransactionObj in TransactionBatch scrips; it isn't guaranteed to be the transaction that matched the scrip condition but merely the first transaction in the batch. You can use $self-TicketObj-TransactionBatch to get an arrayref of transaction objects.
Re: [rt-users] asset tracker config
So I do believe it's a permissions issue, but I cant find it. If I log in as root, the asset drop down in the upper right works, and two asset types are there. However, as a normal privileged user logs in, there are no types.I have gone to select types, group rights, and for system and roles, set ALL the permissions (everyone, priv, etc)! I also set the user defined groups for the groups I have, still nothing under the asset type drop down... what am I missing? I found some old (2007) Asset Tracker documentation here, not sure if it will help: http://www.sgsosu.net/nmetro/Docs/ - Rick Bychowski
Re: [rt-users] Error when sending or reciving mail (fork::abort: address space needed by xxx)
[Posted back to the list for posterity.] On 07/24/2013 11:43 AM, John Rouillard wrote: On Tue, Jul 23, 2013 at 03:13:13PM -0700, Thomas Sibley wrote: On 07/23/2013 09:19 AM, scott.dalzell wrote: i have done some research and rebasing might be the answer. if this is the case how to i rebase and will it effect my mysql database? Whatever research you did was mistaken or misleading. Rebasing has nothing to do with MySQL. It is a concept in git, a source code management tool, used during development. You don't need to worry about rebasing. Actually rebasing is also a method for aligning the link libraries addresses in windows so that cygwin can properly emulate fork(2). The errors he is getting with failure to fork due to conflicting address layouts in the executable address space may be fixed with a (cygwin) rebase. Ahhh. Today I learned... :) Thanks for the explanation! Using rebase probably needs to be discussed on the cygwin list as it has nothing whatsoever to do with RT. Agreed.
Re: [rt-users] Error when sending or reciving mail (fork::abort: address space needed by xxx)
On 07/24/2013 06:13 AM, Thomas Sibley wrote: It's rather brave to use Cygwin for a production RT instance. Heh. I see the same thing with PostgreSQL sometimes, usually on Stack Overflow, but also with one particular client. The upside is that when it's not a paying client stuck on Cygwin, it's easy to fix the person's problem. Well, your question starts with 'I'm using 9.0.1 on Cygwin' there's your problem. Cygwin used to be important, but these days with easy, high performance VMs and native ports of many open source packages to Windows I no longer see the appeal. -- Craig Ringer http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Training Services
Re: [rt-users] Notifications are sent before status and custom field changes are applied?
On 07/25/2013 12:49 AM, Thomas Sibley wrote: On 07/23/2013 12:56 AM, Craig Ringer wrote: Do any of the other RT users here know of a reason *not* to use TransactionBatch for sending email notifications? Be wary of $self-TransactionObj in TransactionBatch scrips; it isn't guaranteed to be the transaction that matched the scrip condition but merely the first transaction in the batch. You can use $self-TicketObj-TransactionBatch to get an arrayref of transaction objects. Thank-you very much for that tip. I'm compiling a pile of RT extension/development notes that I'm working on merging into the perldoc; I'll hopefully have a patch for you to pick and choose from in a few weeks. Considered adding a warn(...) line in TransactionObj() when invoked in batch context? -- Craig Ringer http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Training Services
Re: [rt-users] blah.b...@foo.com is an address RT receives mail at
On 07/24/2013 10:37 PM, LAW Andy wrote: I see a couple of previous threads mentioning this, but no obvious resolution. Any clues or pointers as got how to fix this apparent configuration problem? It sounds like the address must match your $RTAddressRegexp . Have you tested this manually? Try: cpan install Devel::REPL re.pl 'the@address' =~ qr{^my-rt-address-regexp-here$}; see if you get any match(es). -- Craig Ringer http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Training Services
Re: [rt-users] Error when adding user to RT 4 (email exists)
On 07/24/2013 04:58 AM, window camera wrote: Obviously this is a user who doesn't have an account yet, but was included in one of the ticket emails. However, I'm unclear how to run a query for a non privileged user. The search by name box in Tools-Configuration-Users-Select accepts SQL wildcards. So you can search for: % to find all users. It's always struck me as very weird that the user browser does not provide an include unprivileged users checkbox, like the include disabled users checkbox. Any ideas how I might resolve this issue? Searching for the user by email address should find them. If not, try a wildcard. -- Craig Ringer http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Training Services
Re: [rt-users] How to update CF via scripted mySQL commands
On 07/22/2013 09:40 PM, scott.dalzell wrote: Thanks for pointing that out. i think ill try to do the API route as i cant afford to corrupt the database. Can the RT API be used to modify a database that is not being used by RT. When you load the RT perl modules they'll read RT_SiteConfig.pm for database details and use that database. It isn't really clear what you want here, though. Do you want to update more than one database at a time? If so, nothing stops you from loading DBI and opening direct DBI connections to other databases from within a Perl script that also uses the RT APIs. Just that my final goal is to modify a field in our Bugzilla database (also MYsql) when an RT CF is given a bug number You should do that by adding a scrip in RT. Write a condition that checks whether the CF has been changed. I've attached a condition I'm using that you can adapt if you want. Then write an action that opens a Perl DBI connection to your Bugzilla and issues the appropriate UPDATEs against Bugzilla. Or, better, use any HTTP web service API bugzilla provides to do the update via Bugzilla from within the RT scrip as a simple web service call - usually done with LWP::Simple. -- Craig Ringer http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Training Services CustomFieldSetTo.pm Description: Perl program
[rt-users] External custom fields: unable to change categories are based on
Hello, I'm trying to use external custom field values from a database of mine and am having a weird issue where the option to select the Categories are based on field is gone after selecting a Fields value source (it just seems to disappear). Also, and this may be unrelated, I don't seem to be able to change the Fields values source field from my external values back to Provide list of values below. It lets the change happen in the UI, but it resets back after I click Save Changes. Has anyone else had issues like this? I'm using RT 4.0.4. -Mike signature.asc Description: Digital signature
[rt-users] Migration Prep
Hi, I've been putting off upgrading my RT 3.8.4 to current because I always got stuck. Now I can't put it off any more. I have read lost about upgrading but I don't want to upgrade the current server/installation, I want to move it to a brand new server and OS. From what I've read it seems that the best approach might be to: 1. make a clone of the existing RT, 2. upgrade it to 4.0.13 3. do a mysqldump on the upgraded clone 4. restore the dump on the new server. It's the details of step 4 I'm concerned about. If I set up the database on the new server and restore it from the dump do I then use make upgrade on the new server? I don't understand what the right process would be to make sure the new server has mailgate, users etc and can accept the dump. Do I configure the whole new RT instance as though it were a new install then try to migrate my data or should it be and 'upgrade' even though it's new? I apologise if this is a dumb question or if it's covered somewhere in the docs - the whole task of upgrading from 3.8.4 has been overwhelming and I've been avoiding it. -- *Paul O'Rorke* Tracker Software Products p...@tracker-software.com mailto:paul.oro...@tracker-software.com