Re: [rt-users] RT on MAC

2013-07-24 Thread Craig Ringer
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

2013-07-24 Thread Weiss, Robin
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

2013-07-24 Thread G.Pitman
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

2013-07-24 Thread LAW Andy
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)

2013-07-24 Thread scott.dalzell
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

2013-07-24 Thread SSzretter
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)

2013-07-24 Thread window camera
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?

2013-07-24 Thread Thomas Sibley
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

2013-07-24 Thread rick
 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)

2013-07-24 Thread Thomas Sibley
[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)

2013-07-24 Thread Craig Ringer
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?

2013-07-24 Thread Craig Ringer
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

2013-07-24 Thread Craig Ringer
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)

2013-07-24 Thread Craig Ringer
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

2013-07-24 Thread Craig Ringer
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

2013-07-24 Thread Michael Gerow
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

2013-07-24 Thread Paul O'Rorke

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