Re: [rt-users] (RT::Authen::ExternalAuth) email exists problem authenticating trough AD
Hello, Anyone with an idea ? I've tried many times without any success. Thanks for your help. On Fri, Jul 5, 2013 at 4:18 PM, Maximilien Drouet mdro...@randco.fr wrote: Hi, Both AD RT have a user matching email Username. Regarding RealName, yes I read about it but in my case, real names are NEVER the same they use Kevin FALCONE, KEVIN A FALCONE, KEVIN B FALCONE, and so on. But yes you're right about what's documented. On Fri, Jul 5, 2013 at 4:14 PM, Kevin Falcone falc...@bestpractical.comwrote: On Thu, Jul 04, 2013 at 05:00:23PM +0200, Maximilien Drouet wrote: As you can see in the log output I successfully find the user BUT I have an error Couldn't create user myuser which I don't understand because YES user exists but I just want to authenticate not recreate a user. Does the user exist with a matching Email Address AND username? Or is the username different. Also, as documented, you probably shouldn't be using RealName here: 50 'attr_match_list' = [ 51 'Name', 52 'EmailAddress', 53 'RealName', 54 ], It means you can't have two users named Kevin Falcone in your RT. -kevin -- Max -- Cordialement, Maximilien DROUET Consultant Systèmes Réseaux RANDCO, Cabinet de conseil en Réseau, Sécurité Systèmes 19 Rue Pierre LESCOT 75001 Paris Mob. 06.30.91.70.09 Fax. 01.72.74.44.01 http://www.randco.fr
[rt-users] Notifications are sent before status and custom field changes are applied?
Hi all I was recently surprised to see that when a ticket is updated via the web ui, notifications appear to be sent to ticket/queue watchers before any custom field changes are applied. Tested in 4.0.13, albeit with a DB that was created originally on 4.0.7. After reading the code in question, it looks like the message is recorded against the ticket before any other field changes, and all the default notification scripts run on TransactionCreate not on TransactionBatch, so they fire their notifications immediately. Do any of the other RT users here know of a reason *not* to use TransactionBatch for sending email notifications? Have any of the other RT users here had similar issues? The behaviour surprising for a couple of reasons: * RT obviously can't rollback sending notifications, so it makes sense to do it after all the things that can be rolled back are done. * Notifications can't see CF and status changes made via the web UI when they fire. eg, in a recent ticket: Fri, 19 Jul 2013 23:02:00 +0800 The RT System itself - Outgoing email recorded [Show] Fri, 19 Jul 2013 23:02:00 +0800 The RT System itself - Outgoing email recorded [Show] Fri, 19 Jul 2013 23:02:00 +0800 Some User - Status changed from 'new' to 'open' Fri, 19 Jul 2013 23:02:00 +0800 Some User - WaitingOn Customer added where WaitingOn is a CF with values Customer or Support. Transaction numbers increase down the page. The CF is set using the extension RT::Extension::CustomFieldsOnUpdate, but the Status is of course set by the core code. The order of events logged in the Results tab after Update.html runs and redirects to Display.html is: [Results] Message recorded Ticket : Status changed from 'new' to 'open' WaitingOn Support changed to Customer -- Craig Ringer http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Training Services
Re: [rt-users] (RT::Authen::ExternalAuth) email exists problem authenticating trough AD
Hi, Let me try, i never used ldapsearch before so i need to check the syntax. On Tue, Jul 23, 2013 at 11:04 AM, Craig Ringer cr...@2ndquadrant.comwrote: On 07/04/2013 11:00 PM, Maximilien Drouet wrote: (((ObjectCategory=User)(ObjectClass=Person))(sAMAccountName=myuser )) If you execute this LDAP search directly against your directory with the same base dn as given in the logs, does it find the user? -- Craig Ringer http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Training Services -- Cordialement, Maximilien DROUET Consultant Systèmes Réseaux RANDCO, Cabinet de conseil en Réseau, Sécurité Systèmes 19 Rue Pierre LESCOT 75001 Paris Mob. 06.30.91.70.09 Fax. 01.72.74.44.01 http://www.randco.fr
[rt-users] rt-mailgate issue with postfix
Hi Folks We have just installed RT4.0.13 in our environment. Our foremost requirement is ticket creation via email. In our setup we already have postfix running on separate server. On RT we are having exim which is acting as relay server and using postfix mail server as master. Now I want to integrate my RT server with that mailbox. In order to do that I installed rt-mailgate on my mail server and created below mentioned entries in /etc/aliases *rt-database: |/opt/rt4/bin/rt-mailgate --queue database --action correspond --url http://rt.xyz.com/; rt-database-comment: |/opt/rt4/bin/rt-mailgate --queue database --action comment --url http://rt.xyz.com/; * I have database queue configured on my RT box with the above mentioned email-address. I have also given create-ticket rights to everyone. Both the email-ids rt-datab...@gml.com and rt-database-comm...@gml.com are configured on my AD. But whenever i am trying to create ticket, I get the below mentioned error from mail.log Jul 23 07:23:17 mail postfix/smtpd[7389]: connect from localhost[127.0.0.1] Jul 23 07:23:17 mail postfix/smtpd[7389]: DC0DC45C61: client=localhost[127.0.0.1] Jul 23 07:23:17 mail postfix/cleanup[7369]: DC0DC45C61: message-id=E1V1ag5-0001y3-Hu@dst-2 Jul 23 07:23:17 mail postfix/qmgr[5870]: DC0DC45C61: from=r...@gml.com, size=1448, nrcpt=1 (queue active) Jul 23 07:23:17 mail postfix/smtpd[7389]: disconnect from localhost[127.0.0.1] Jul 23 07:23:17 mail amavis[5064]: (05064-04) Passed CLEAN, [192.168.10.24] r...@gml.com - |/opt/rt4/bin/rt-mailgate --queue database --action correspond --url http://rt.tekmindz.com/@gml.com, Message-ID: E1V1ag5-0001y3-Hu@dst-2, mail_id: qXkzuLb1TZ4M, Hits: -1, size: 854, queued_as: DC0DC45C61, 28311 ms Jul 23 07:23:17 mail postfix/smtp[7386]: 8553245C65: to=|/opt/rt4/bin/rt-mailgate --queue database --action correspond --url http://rt.tekmindz.com/@gml.com, relay=127.0.0.1[127.0.0.1]:10024, delay=28, delays=0.11/0.03/0.01/28, dsn=2.0.0, status=sent (250 2.0.0 Ok, id=05064-04, from MTA([127.0.0.1]:10025): 250 2.0.0 Ok: queued as DC0DC45C61) Jul 23 07:23:17 mail postfix/qmgr[5870]: 8553245C65: removed Jul 23 07:23:18 mail postfix/virtual[7390]: DC0DC45C61: to=|/opt/rt4/bin/rt-mailgate --queue database --action correspond --url http://rt.tekmindz.com/@gml.com, relay=virtual, delay=0.17, delays=0.06/0.05/0/0.06, dsn=5.1.1, status=bounced (unknown user: |/opt/rt4/bin/rt-mailgate --queue database --action correspond --url http://rt.tekmindz.com/@gml.com;) Jul 23 07:23:18 mail postfix/cleanup[7369]: 106A845C64: message-id=20130723112318.106a845...@mail.gml.com Jul 23 07:23:18 mail postfix/qmgr[5870]: 106A845C64: from=, size=3673, nrcpt=1 (queue active) Jul 23 07:23:18 mail postfix/bounce[7391]: DC0DC45C61: sender non-delivery notification: 106A845C64 Jul 23 07:23:18 mail postfix/qmgr[5870]: DC0DC45C61: removed Jul 23 07:23:18 mail postfix/virtual[7390]: 106A845C64: to=r...@gml.com, relay=virtual, delay=0.12, delays=0.06/0.01/0/0.05, dsn=2.0.0, status=sent (delivered to maildir) Jul 23 07:23:18 mail postfix/qmgr[5870]: 106A845C64: removed Jul 23 07:24:29 mail postfix/smtpd[7363]: idle timeout -- exiting Actually whole rt-mailgate entry is treated like a user. Right now i am clueless about what to do. Kindly help me in troubleshooting this issue. Regards -- Disclaimer: The information contained in this communication is confidential, private, proprietary, or otherwise privileged and is intended only for the use of the addressee. Unauthorized use, disclosure, distribution or copying is strictly prohibited and may be unlawful. If you have received this communication in error, please delete this message and notify the sender immediately - Samin TekMindz India Pvt. Ltd. --
Re: [rt-users] SOS:: many mysql processes are killing RAM, why?
On Tue, Jul 23, 2013 at 10:14:39AM +0800, Craig Ringer wrote: On 07/19/2013 11:42 PM, Alex Decalli wrote: I have RT 3.8 on mysql 5.1 on ubuntu 11.04. Why do I have many mysql processes they are bringing down RAM. Quite likely you have too many Apache workers with mod_perl, or too many fcgi workers if you're using fcgi. You will need to limit the number of concurrent RT workers - assuming that the MySQL workers are even being used by RT, which we don't know based on the information you have provided. Alternately, you can put a *connection pool* in place between RT and the database. If you were using PostgreSQL I would advise you to use PgBouncer in transaction pooling mode, but I cannot offer much advice for MySQL. I'm sure there's a similar pooling proxy. This sort of question is probably better suited to Serverfault.com than the RT list. BTW, text output is usually way more useful than screenshots; eg top -b -n 1. Hi Alex, I will second Craig's suggestion about a connection pooler. We use fcgi/pgbouncer with PostgreSQL here and it works well. The only difference is that we use session mode and not transaction mode with pgbouncer. We had cases of ticket updates being interspersed. Maybe it was a local configuration problem but changing to session mode fixed it. Regards, Ken
Re: [rt-users] Notifications are sent before status and custom field changes are applied?
On Tue, Jul 23, 2013 at 03:56:49PM +0800, Craig Ringer wrote: Do any of the other RT users here know of a reason *not* to use TransactionBatch for sending email notifications? TransactionBatch Scrips do not show up in the Preview Scrips UI, so you'll be unable to squelch users either at the Ticket or Transaction level. -kevin pgprDlaM7qIwB.pgp Description: PGP signature
Re: [rt-users] RSS feed customization
On Mon, Jul 22, 2013 at 06:14:43PM -0700, S P wrote: Is there a way to include the queue name in the RSS feed of a saved search (or add it to the title or subject)? The directions at http://requesttracker.wikia.com/wiki/RssFeed reference adding strings to the dc hash, but the Results.rdf file distributed with 4.0.8 doesn't contain a dc hash section (and doesn't contain much, in contrast to the Results.rdf file in 3.x) There is no configuration of that code, just local overlays. As you say, in 4.0 that file is very short: /Search/Elements/ResultsRSSView, %ARGS That loads and runs the specified mason component (since the same code is used from 2 different places). If you're going to be making changes to RT, it's worth reviewing documentation on how Mason works. http://www.masonbook.com/ -kevin pgpjIgwu58NOS.pgp Description: PGP signature
Re: [rt-users] rt-mailgate issue with postfix
On 07/23/2013 04:53 AM, Rajat toshniwal wrote: Hi Folks We have just installed RT4.0.13 in our environment. Our foremost requirement is ticket creation via email. In our setup we already have postfix running on separate server. On RT we are having exim which is acting as relay server and using postfix mail server as master. Now I want to integrate my RT server with that mailbox. In order to do that I installed rt-mailgate on my mail server and created below mentioned entries in /etc/aliases *rt-database: |/opt/rt4/bin/rt-mailgate --queue database --action correspond --url http://rt.xyz.com/; rt-database-comment: |/opt/rt4/bin/rt-mailgate --queue database --action comment --url http://rt.xyz.com/; * I have database queue configured on my RT box with the above mentioned email-address. I have also given create-ticket rights to everyone. Both the email-ids rt-datab...@gml.com and rt-database-comm...@gml.com are configured on my AD. But whenever i am trying to create ticket, I get the below mentioned error from mail.log Jul 23 07:23:17 mail postfix/smtpd[7389]: connect from localhost[127.0.0.1] Jul 23 07:23:17 mail postfix/smtpd[7389]: DC0DC45C61: client=localhost[127.0.0.1] Jul 23 07:23:17 mail postfix/cleanup[7369]: DC0DC45C61: message-id=E1V1ag5-0001y3-Hu@dst-2 Jul 23 07:23:17 mail postfix/qmgr[5870]: DC0DC45C61: from=r...@gml.com, size=1448, nrcpt=1 (queue active) Jul 23 07:23:17 mail postfix/smtpd[7389]: disconnect from localhost[127.0.0.1] Jul 23 07:23:17 mail amavis[5064]: (05064-04) Passed CLEAN, [192.168.10.24] r...@gml.com - |/opt/rt4/bin/rt-mailgate --queue database --action correspond --url http://rt.tekmindz.com/@gml.com, Message-ID: E1V1ag5-0001y3-Hu@dst-2, mail_id: qXkzuLb1TZ4M, Hits: -1, size: 854, queued_as: DC0DC45C61, 28311 ms Jul 23 07:23:17 mail postfix/smtp[7386]: 8553245C65: to=|/opt/rt4/bin/rt-mailgate --queue database --action correspond --url http://rt.tekmindz.com/@gml.com, relay=127.0.0.1[127.0.0.1]:10024, delay=28, delays=0.11/0.03/0.01/28, dsn=2.0.0, status=sent (250 2.0.0 Ok, id=05064-04, from MTA([127.0.0.1]:10025): 250 2.0.0 Ok: queued as DC0DC45C61) Jul 23 07:23:17 mail postfix/qmgr[5870]: 8553245C65: removed Jul 23 07:23:18 mail postfix/virtual[7390]: DC0DC45C61: to=|/opt/rt4/bin/rt-mailgate --queue database --action correspond --url http://rt.tekmindz.com/@gml.com, relay=virtual, delay=0.17, delays=0.06/0.05/0/0.06, dsn=5.1.1, status=bounced (unknown user: |/opt/rt4/bin/rt-mailgate --queue database --action correspond --url http://rt.tekmindz.com/@gml.com;) Jul 23 07:23:18 mail postfix/cleanup[7369]: 106A845C64: message-id=20130723112318.106a845...@mail.gml.com Jul 23 07:23:18 mail postfix/qmgr[5870]: 106A845C64: from=, size=3673, nrcpt=1 (queue active) Jul 23 07:23:18 mail postfix/bounce[7391]: DC0DC45C61: sender non-delivery notification: 106A845C64 Jul 23 07:23:18 mail postfix/qmgr[5870]: DC0DC45C61: removed Jul 23 07:23:18 mail postfix/virtual[7390]: 106A845C64: to=r...@gml.com, relay=virtual, delay=0.12, delays=0.06/0.01/0/0.05, dsn=2.0.0, status=sent (delivered to maildir) Jul 23 07:23:18 mail postfix/qmgr[5870]: 106A845C64: removed Jul 23 07:24:29 mail postfix/smtpd[7363]: idle timeout -- exiting Actually whole rt-mailgate entry is treated like a user. Right now i am clueless about what to do. Kindly help me in troubleshooting this issue. Regards You didn't post your exim.conf, so I'm pretty much stabbing in the dark, but my guess is a lack of address_pipe transport configuration. That said, if your postfix machine is only used for routing to/from the RT machine, you may want to consider eliminating that machine running postfix on your RT box. And even if your postfix box is used for other things, you may want to consider using postfix on your RT box as well to eliminate the confusion of running 2 different MTAs.
[rt-users] Looking at upgrading 3.6.5 to latest
Hi everyone, I'm investigating what will be necessary to do an upgrade from our installation of RT 3.6.5 to the latest version. Currently installed versions of some items we are not looking to upgrade...are we safe here? * mysql 5.0.51a * perl 5.8.8 * Ubuntu 8.04 (yes, I know that's way old) * haven't been using CPAN, but instead pulling in needed modules from Ubuntu repo That last bit was at the sysadmin's request. What's the general opinion on whether that's a good way to go? Our RT is not exposed to the general internet; only our internal network, so I'm hoping the age of the Ubuntu distro isn't too much of a problem. But I can talk to the sysamin about upgrading it first if it seems like a really bad idea to stick with 8.04. Finally...I'm looking at the README files on the BP site and I have a question about the UPGRADING.mysql file. The first step seems to apply only if you're not upgrading mysql itself. Are there other steps in that document that are also not necessary if mysql isn't being upgraded? It's kind of hard to tell. Thanks! -- Kendric Beachey CONFIDENTIALITY NOTICE: This email and any attachments are for the sole use of the intended recipient(s) and contain information that may be confidential and/or legally privileged. If you have received this email in error, please notify the sender by reply email and delete the message. Any disclosure, copying, distribution or use of this communication (including attachments) by someone other than the intended recipient is prohibited. Thank you.
Re: [rt-users] Looking at upgrading 3.6.5 to latest
On Tue, Jul 23, 2013 at 03:35:20PM +, Beachey, Kendric wrote: I'm investigating what will be necessary to do an upgrade from our installation of RT 3.6.5 to the latest version. Currently installed versions of some items we are not looking to upgrade...are we safe here? * mysql 5.0.51a * perl 5.8.8 * Ubuntu 8.04 (yes, I know that's way old) * haven't been using CPAN, but instead pulling in needed modules from Ubuntu repo That last bit was at the sysadmin's request. What's the general opinion on whether that's a good way to go? You can build your own standalone perl without touching the system perl using something like perlbrew http://perlbrew.pl If you're planning to upgrade in-place, keep in mind that the UPGRADING.mysql step (more below) generally takes a while. We almost always recommend working on a new machine or VM for a larger upgrade. It allows you to test the upgrade and find out how much downtime you're going to need. Finally...I'm looking at the README files on the BP site and I have a question about the UPGRADING.mysql file. The first step seems to apply only if you're not upgrading mysql itself. Are there other steps in that document that are also not necessary if mysql isn't being upgraded? It's kind of hard to tell. If you're planning to upgrade in-place on that mysql, then you do not need to dump and restore, but I'd make *really* sure that my backups were sound before doing so. -kevin pgpJUipBAuWYf.pgp Description: PGP signature
[rt-users] Error when sending or reciving mail (fork::abort: address space needed by xxx)
Hi Guy i am running RT4.0.12 using a mysql 5.6.10 under cygwin 2.774 and i am having a major issue When i try and and reply to a ticket or create a ticket via email i get the following in the error.log ---log file--- [Tue Jul 23 16:51:49 2013] [error] (11)Resource temporarily unavailable: fork: Unable to fork new process [Tue Jul 23 15:51:50 2013] [warning]: Use of uninitialized value $_[2] in join or string at (eval 378) line 2. ((eval 378):2) [Tue Jul 23 15:51:50 2013] [warning]: Use of uninitialized value $_[2] in join or string at (eval 378) line 2. ((eval 378):2) [Tue Jul 23 15:51:50 2013] [warning]: Use of uninitialized value $_[2] in join or string at (eval 378) line 2. ((eval 378):2) [Tue Jul 23 15:51:50 2013] [warning]: Use of uninitialized value $_[2] in join or string at (eval 378) line 2. ((eval 378):2) [Tue Jul 23 15:51:50 2013] [warning]: Use of uninitialized value $_[2] in join or string at (eval 378) line 2. ((eval 378):2) [Tue Jul 23 15:51:50 2013] [warning]: Use of uninitialized value $_[2] in join or string at (eval 378) line 2. ((eval 378):2) [Tue Jul 23 15:51:50 2013] [warning]: Use of uninitialized value $_[2] in join or string at (eval 378) line 2. ((eval 378):2) [Tue Jul 23 15:51:50 2013] [warning]: Use of uninitialized value $_[2] in join or string at (eval 378) line 2. ((eval 378):2) [Tue Jul 23 15:51:50 2013] [warning]: Use of uninitialized value $_[2] in join or string at (eval 378) line 2. ((eval 378):2) [Tue Jul 23 15:51:50 2013] [warning]: Use of uninitialized value $_[2] in join or string at (eval 378) line 2. ((eval 378):2) [Tue Jul 23 15:51:50 2013] [warning]: Use of uninitialized value $_[2] in join or string at (eval 378) line 2. ((eval 378):2) [Tue Jul 23 15:51:50 2013] [warning]: Use of uninitialized value $_[2] in join or string at (eval 378) line 2. ((eval 378):2) [Tue Jul 23 15:51:50 2013] [warning]: Use of uninitialized value $_[2] in join or string at (eval 378) line 2. ((eval 378):2) [Tue Jul 23 15:51:50 2013] [warning]: Use of uninitialized value $_[2] in join or string at (eval 378) line 2. ((eval 378):2) [Tue Jul 23 15:51:50 2013] [warning]: Use of uninitialized value $_[2] in join or string at (eval 378) line 2. ((eval 378):2) [Tue Jul 23 15:51:50 2013] [warning]: Use of uninitialized value $_[2] in join or string at (eval 378) line 2. ((eval 378):2) [Tue Jul 23 15:51:51 2013] [warning]: Use of uninitialized value $_[2] in join or string at (eval 378) line 2. ((eval 378):2) [Tue Jul 23 15:51:51 2013] [warning]: Use of uninitialized value $_[2] in join or string at (eval 378) line 2. ((eval 378):2) [Tue Jul 23 16:51:51 2013] [warn] FastCGI: (dynamic) server /opt/rt4/sbin/rt-server.fcgi started (pid 408) [Tue Jul 23 15:52:05 2013] [info]: rt-4.0.12-408-1374594725-665.16552-2...@lfm-software.com #16552/15723 - Scrip 28 Notify Admin user - Reply (/opt/rt4/sbin/../lib/RT/Action/SendEmail.pm:285) [Tue Jul 23 15:52:05 2013] [info]: rt-4.0.12-408-1374594725-665.16552-2...@lfm-software.com No recipients found. Not sending. (/opt/rt4/sbin/../lib/RT/Interface/Email.pm:385) [Tue Jul 23 15:52:05 2013] [info]: rt-4.0.12-408-1374594725-1969.16552-5...@lfm-software.com #16552/15723 - Scrip 52 Notify user - Reply (/opt/rt4/sbin/../lib/RT/Action/SendEmail.pm:285) [Tue Jul 23 15:52:05 2013] [info]: rt-4.0.12-408-1374594725-1969.16552-5...@lfm-software.com No recipients found. Not sending. (/opt/rt4/sbin/../lib/RT/Interface/Email.pm:385) [Tue Jul 23 15:52:05 2013] [info]: rt-4.0.12-408-1374594725-1733.16552-...@lfm-software.com #16552/15723 - Scrip 5 On Correspond Notify AdminCcs (/opt/rt4/sbin/../lib/RT/Action/SendEmail.pm:285) [Tue Jul 23 15:52:05 2013] [info]: rt-4.0.12-408-1374594725-1733.16552-...@lfm-software.com No recipients found. Not sending. (/opt/rt4/sbin/../lib/RT/Interface/Email.pm:385) [Tue Jul 23 15:52:05 2013] [info]: rt-4.0.12-408-1374594725-1239.16552-...@lfm-software.com #16552/15723 - Scrip 7 On Correspond Notify Other Recipients (/opt/rt4/sbin/../lib/RT/Action/SendEmail.pm:285) [Tue Jul 23 15:52:05 2013] [info]: rt-4.0.12-408-1374594725-1239.16552-...@lfm-software.com No recipients found. Not sending. (/opt/rt4/sbin/../lib/RT/Interface/Email.pm:385) [Tue Jul 23 15:52:05 2013] [info]: rt-4.0.12-408-1374594725-1758.16552-...@lfm-software.com #16552/15723 - Scrip 6 On Correspond Notify Requestors and Ccs (/opt/rt4/sbin/../lib/RT/Action/SendEmail.pm:285) 2 [main] perl 1952 child_info_fork::abort: address space needed by 'cygcrypto-1.0.0.dll' (0x41) is already occupied [Tue Jul 23 15:52:05 2013] [critical]: rt-4.0.12-408-1374594725-1758.16552-...@lfm-software.com: Could not send mail with command `/opt/rt4/etc/msmtp_wrapper -oi -t -ODeliveryMode=b -OErrorMode=m -f lfm.t...@aveva.com`: open2: fork failed: Resource temporarily unavailable at /opt/rt4/sbin/../lib/RT/Interface/Email.pm line 474. Stack: [/usr/lib/perl5/site_perl/5.14/Carp.pm:100] [/usr/lib/perl5/5.14/IPC/Open3.pm:154] [/usr/lib/perl5/5.14/IPC/Open3.pm:242]
[rt-users] Sending a templated correspondence to a corresponded for tickets not updated by the correspondent for X hours
Hello, I thought this would be kinda easy but it's proving to be quite difficult. My problem is 2 parts: *1) * I've tried writing a custom condition for rt-crontool to find tickets that were: - last updated by the owner - not updated in X hours (like 24 hours) Since rt-crontool doesn't know who __CurrentOwner__ is it makes it hard to use a query like I would in the RT Interface. Presumably there might be some way to see if the last update was a privileged RT user but was done more than X hours ago. Queue = 'Investigations' AND Status = 'open' AND LastUpdatedBy = '__CurrentUser__' AND Owner = '__CurrentUser__' AND LastUpdated '24 hours ago' Basically I want to nag customers to update the ticket if they haven't updated it after 24 hours and then 36 hours. If they still haven't updated it after 48 hours I want do something like set the priority to 100 or something so I can see what tickets are not being updated so their accounts can be suspended or something in accordance with our policies. *2) * I also need help understanding the usage for the SendEmail action. I read an rt-users mailinglist post from a while ago about it but there's a mix of other stuff about RecordComment in there etc which doesn't really apply here. I've also been reading http://bestpractical.com/docs/rt/4.0/RT/Action/SendEmail.html but I'm unclear on what the Blue bolded sections are - are those methods? How does one use this in another Action script? Examples would be awesome if any exist. -- Landon Stewart landonstew...@gmail.com
[rt-users] Error when adding user to RT 4 (email exists)
Hello AllI've tried to add a person in our RT, but it says "email already in use", and doesn't let me create the new user.I query everything I can find, but nothing comes up.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. (And the RT Essentials book doesn't reveal how because it's for a much older version).Any ideas how I might resolve this issue?Thank you!Rick
Re: [rt-users] Error when adding user to RT 4 (email exists)
Thanks. Unfortunately there is nothing like that in the latest RT version. Plus, this is an unprivileged user, so it probably wouldn't show up anyway. Not sure.Strange though that I just can't get beyond this issue...Thanks!On Jul 23, 2013, at 05:16 PM, "Beachey, Kendric" kendric.beac...@garmin.com wrote:Hi Rick,It’s possible things have changed since the version of RT we’re running (3.6.5) but I do searches like this from the web interface, with the magic box checked...image001.pngHTH,Kendric BeacheyFrom: rt-users-boun...@lists.bestpractical.com [mailto:rt-users-boun...@lists.bestpractical.com] On Behalf Of window camera Sent: Tuesday, July 23, 2013 3:58 PM To: rt-users@lists.bestpractical.com Subject: [rt-users] Error when adding user to RT 4 (email exists)Hello AllI've tried to add a person in our RT, but it says "email already in use", and doesn't let me create the new user.I query everything I can find, but nothing comes up.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. (And the RT Essentials book doesn't reveal how because it's for a much older version).Any ideas how I might resolve this issue?Thank you!Rick CONFIDENTIALITY NOTICE: This email and any attachments are for the sole use of the intended recipient(s) and contain information that may be confidential and/or legally privileged. If you have received this email in error, please notify the sender by reply email and delete the message. Any disclosure, copying, distribution or use of this communication (including attachments) by someone other than the intended recipient is prohibited. Thank you.
Re: [rt-users] Error when adding user to RT 4 (email exists)
Hi Rick, It's possible things have changed since the version of RT we're running (3.6.5) but I do searches like this from the web interface, with the magic box checked... [rt.search.for.disabled.users.png] HTH, Kendric Beachey From: rt-users-boun...@lists.bestpractical.com [mailto:rt-users-boun...@lists.bestpractical.com] On Behalf Of window camera Sent: Tuesday, July 23, 2013 3:58 PM To: rt-users@lists.bestpractical.com Subject: [rt-users] Error when adding user to RT 4 (email exists) Hello All I've tried to add a person in our RT, but it says email already in use, and doesn't let me create the new user.I query everything I can find, but nothing comes up. 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. (And the RT Essentials book doesn't reveal how because it's for a much older version). Any ideas how I might resolve this issue? Thank you! Rick CONFIDENTIALITY NOTICE: This email and any attachments are for the sole use of the intended recipient(s) and contain information that may be confidential and/or legally privileged. If you have received this email in error, please notify the sender by reply email and delete the message. Any disclosure, copying, distribution or use of this communication (including attachments) by someone other than the intended recipient is prohibited. Thank you. inline: image001.png
Re: [rt-users] Error when adding user to RT 4 (email exists)
On 07/23/2013 02:31 PM, window camera wrote: Thanks. Unfortunately there is nothing like that in the latest RT version. Plus, this is an unprivileged user, so it probably wouldn't show 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] Error when sending or reciving mail (fork::abort: address space needed by xxx)
On 07/23/2013 09:19 AM, scott.dalzell wrote: Hi Guy i am running RT4.0.12 using a mysql 5.6.10 under cygwin 2.774 and i am having a major issue It's rather brave to use Cygwin for a production RT instance. When i try and and reply to a ticket or create a ticket via email i get the following in the error.log ---log file--- [Tue Jul 23 16:51:49 2013] [error] (11)Resource temporarily unavailable: fork: Unable to fork new process [snip] 2 [main] perl 1952 child_info_fork::abort: address space needed by 'cygcrypto-1.0.0.dll' (0x41) is already occupied [Tue Jul 23 15:52:05 2013] [critical]: rt-4.0.12-408-1374594725-1758.16552-...@lfm-software.com: Could not send mail with command `/opt/rt4/etc/msmtp_wrapper -oi -t -ODeliveryMode=b -OErrorMode=m -f lfm.t...@aveva.com`: open2: fork failed: Resource temporarily unavailable at /opt/rt4/sbin/../lib/RT/Interface/Email.pm line 474. Your server is running out of memory, likely because the maximum memory usages of MySQL and Apache aren't properly configured to coexist peacefully within the limits of your server. Most people install Apache and MySQL without tuning them, and then eventually run into problems like this. You should read about how to tune Apache and MySQL. Starting with mysqltuner.pl is a good start, but nothing will do this automatically for you. You'll need to manually make changes. this all started to happen when i added in a set of new queues. i have removed the queues but the error persists. The new queues have nothing in particular to do with it. 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.
Re: [rt-users] Notifications are sent before status and custom field changes are applied?
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 07/23/2013 09:00 PM, Kevin Falcone wrote: On Tue, Jul 23, 2013 at 03:56:49PM +0800, Craig Ringer wrote: Do any of the other RT users here know of a reason *not* to use TransactionBatch for sending email notifications? TransactionBatch Scrips do not show up in the Preview Scrips UI, so you'll be unable to squelch users either at the Ticket or Transaction level. Thanks for the tip. I don't think that matters much for my particular use, but it's good to have on record here for others who're trying to find out about the same issue later. Would you be potentially inclined to accept a patch that recorded the message *after* the status and other attribute changes - or would that be too likely to break other things? - -- Craig Ringer http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Training Services -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.13 (GNU/Linux) Comment: Using GnuPG with Thunderbird - http://www.enigmail.net/ iQEcBAEBAgAGBQJR71SSAAoJELBXNkqjr+S2QLMH/0VqQAig1efaAJJilkFh+4RF HvHcIbpSsWlR2GduZaJvyoCqdtU6Ifc/fV3IbPC3fOfCl/2p0r+spq+NnYJaKJV9 of9ENB/HJB5Gye/ihR1FFDloZleKDm/WtqenVeZaykAMVwwPQwszJrMjj4hjhq80 dO/J6RHGeJVMbxMRyDz9FmdSSbyTQ9m+mHquCZOkHjFbHJUVm2V44Zp0Jlgpu5r7 MfMRpfgZVt7wHi/6AlJqYDci8NGnzbRz+py4LHf5poMp2rstSqCqYfsgq2kqKxO1 sSKddyAt+LjxYShBzzLkhaCG+3bEJkbS0cymm3InAHR3OoXDq9I6pgxEt+3bTIo= =adr/ -END PGP SIGNATURE-
[rt-users] RT on MAC
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 Thank you. Kenn