Re: [rt-users] Using https in web interface results sometimes in Bad Request
Thanks Benno - I'll let you know how I get on. I am a bit surprised that only one person other than you and me has noticed this issue! -Original Message- From: Benno Overeinder [mailto:be...@nlnetlabs.nl] Sent: 26 August 2009 20:14 To: James J. Oliver Cc: 'Ruslan Zakirov'; 'rt-users@lists.bestpractical.com' Subject: Re: [rt-users] Using https in web interface results sometimes in Bad Request James, On 8/25/09 9:47 AM, James J. Oliver wrote: Thanks for the investigation - that throws more light on it. We were using http internally and https externally - I think I may just patch my systems as per your test and use https 100% of the time, the server is not particularly heavily loaded so it should not be a big problem. How did you decide to proceed and have you had any more feedback on the if statement? Thank you for looking into unintended https/http switch. As we (at our lab) travel quite frequently and hook up to different wireless networks, we try to access our service via https/ssl/tls/... I did not receive any more feedback on the if statement. The way we proceed is quite simple, actually. If with an action a redirect of http://...:443/... occurs, we just correct the url in the browser to https://...:443/... Everything goes fine after that, including the confirmation that the action is processed. For convenience, I can hard code $uri-scheme('https'), which is fine for our workflow. Thanks, -- Benno -- Benno J. Overeinder NLnet Labs http://www.nlnetlabs.nl/ ___ 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] UseFriendlyFromLine seems to have no effect
Hello, I made an update from 3.6.5 to 3.8.4. Everything works fine except mail: the From:-line is empty for mails outside our network. In our network Outlook displays the name, but not the email address. Before the Update it worked. The settings are still the defaults: UseFriendlyFromLine 1 FriendlyFromLineFormat \%s via RT\ %s Any ideas? My environment: Red Hat Enterprise Linux ES release 4 (Nahant Update 6) Sendmail 8.13.1 Apache HTTPD 2.2.13 mod_perl 2.0.4 Perl 5.8.8.817 SendmailSetting: SendmailArguments , -oi -t -f m...@domain.com) Regards, Tobias ___ 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] Mandatory Edit not enforced on Ticket Update
Any help appreciated. I have a custom field with a select one value option and it is mandatory. It works fine on creating a ticket however if a ticket is changed from a queue that does not require or even have this cf associated with it to a queue that does have the cf the requirement for data entry is not enforced. I do not have much access to my perl person since it is the opening of the semester and was hoping someone had a script option that I could incorporate Thanks in advance Joe Kirby, UMBC ___ 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] User Provisioning from AD
On Thu, Aug 27, 2009 at 02:59:03PM -0500, Robert Nesius wrote: Hi Kevin, I finally had time to circle back and work on piloting/configuring RT Quick Recap - I had asked about solutions for bulk-loading identities from LDAP (active directory in my case) into RT so that the users appeared in the system as privileged users. You suggested two things: 1) Setting the flag that makes auto-created users privileged. 2) Using RT-Extension-LDAPImport I've installed RT-Extension-LDAPImport and was reading the README. What jumped out at me is that there is both a script to run (presumably to bulk-load identities) and a plug-in. I was expecting to see a script, but a plugin was unexpected, which lead me to wonder if this module is both a method for importing users from ldap, and an on-the-fly authentication and user-creation tool too? If so, that implies I don't need the 3rd party ldapauth plug-in I already have installed. (I'd rather use a module from Best Practical if I had a choice). Rob Please keep comments on the list rather than in my personal mailbox If you look at the script, it is 23 lines long. The plugin is where the import code is stored and organized, the script is just a wrapper. You still need RT-Authen-ExternalAuth or apache LDAP authentication if you want to validate passwords against an external source -kevin Just trying to make sure I'm understanding things correctly. Thanks much! -Rob On Tue, Aug 18, 2009 at 12:52 PM, Robert Nesius [1]nes...@gmail.com wrote: On Tue, Aug 18, 2009 at 12:50 PM, Kevin Falcone [2]falc...@bestpractical.com wrote: Have you looked at RT-Extension-LDAPImport ? -kevin I had not found my way to it yet! Now that I read the cpan page, that looks very much like what I'm looking for. Thanks so much, Kevin. I'll play with this and see how it goes! ___ 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] E-Mail to Queue Doesn't Generate Outbound Notifications
You have to create a scrip that says to email watcher. Mike Johnson Datatel Programmer/Analyst Northern Ontario School of Medicine 955 Oliver Road Thunder Bay, ON P7B 5E1 Phone: 807.766.7331 Email: mike.john...@normed.ca Technology assistance: email nosmhelpd...@normed.ca Technology Emergency Contact (TEC) Mon-Fri, 8am to 5pm excluding stat holidays: Off campus toll free 1-800-461-8777, option 8, or locally either (705)-662-7120 or (807)-766-7500 Tim Gustafson t...@soe.ucsc.edu 8/27/2009 12:59 PM Hi, I have a web form that is sending an e-mail directly to an RT Queue address. Tickets are being created based on those e-mails, but no messages are being sent out to the queue watchers when the new ticket is created. There is nothing in the ticket history that says any attempt to send out any e-mail was made. Is there some option I have to set to cause the queue to send out an Here's your RT tracking number e-mail for this queue? Tim Gustafson Baskin School of Engineering UC Santa Cruz t...@soe.ucsc.edu 831-459-5354 ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com ( 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://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] How do I get a ticket's parent ticket in a scrip
How do I get a ticket's parent ticket in a scrip? What I'm trying to do is modify one of our On Create scrip conditions to only trigger the scrip if the new ticket isn't a child. Any help will be greatly appreciated, Jeremy ___ 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] User Provisioning from AD
On Fri, Aug 28, 2009 at 7:20 AM, Kevin Falcone falc...@bestpractical.comwrote: On Thu, Aug 27, 2009 at 02:59:03PM -0500, Robert Nesius wrote: I've installed RT-Extension-LDAPImport and was reading the README. What jumped out at me is that there is both a script to run (presumably to bulk-load identities) and a plug-in. I was expecting to see a script, but a plugin was unexpected, which lead me to wonder if this module is both a method for importing users from ldap, and an on-the-fly authentication and user-creation tool too? If so, that implies I don't need the 3rd party ldapauth plug-in I already have installed. (I'd rather use a module from Best Practical if I had a choice). If you look at the script, it is 23 lines long. The plugin is where the import code is stored and organized, the script is just a wrapper. I saw that and I get that the script is a wrapper. What I was wondering is why the import code is stored in a plug-in and loaded as a plug-in, but I think I figured it out. Basically the import code is working against the objects and subsystems in RT, and needs those objects to exist before it's loaded, so you load your import code indirectly via by simply loading the RT runtime via the RT Module, which inspects RT_SiteConfig.pm, initializes the environment, and then eventually loads your plug-in, thus making your code available to your script within the context of a complete RT runtime environment. Okay, so I get that now. Once I configured the script the first thing I wanted to do was test the config. I was extremely surprised to see there is no look before you leap flag. Rather, just a comment advising back up your database first, which has this sense of playing russian roulette with a revolver with no empty cylinders. Having looked at the code I can see some ways to work around that. Not cleanly, since fetch users and load users are sitting inside one api call but it shouldn't be hard to change that. -Rob You still need RT-Authen-ExternalAuth or apache LDAP authentication if you want to validate passwords against an external source -kevin Just trying to make sure I'm understanding things correctly. Thanks much! -Rob On Tue, Aug 18, 2009 at 12:52 PM, Robert Nesius [1]nes...@gmail.com wrote: On Tue, Aug 18, 2009 at 12:50 PM, Kevin Falcone [2] falc...@bestpractical.com wrote: Have you looked at RT-Extension-LDAPImport ? -kevin I had not found my way to it yet! Now that I read the cpan page, that looks very much like what I'm looking for. Thanks so much, Kevin. I'll play with this and see how it goes! ___ 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] RTx::S3Invoker problems with Postgres 8.1.11 and RT 3.8.4
Hi folks, I'm setting up a new instance of RT 3.8.4 with postgres 8.1.11 on CentOS 5.3, and had some problems trying to implement the Rtx::S3Invoker plugin to enable simple search to execute saved searches. I fixed the problem, but have a couple of questions. Some background: After installing, when I tried to do a do:unowned at the simplesearch screen I got an error like this in rt.log: [Thu Aug 27 16:44:29 2009] [warning]: DBD::Pg::st execute failed: ERROR: column attributes.description must appear in the GROUP BY clause or be used in an aggregate function (/usr/lib/perl5/site_perl/5.8.8/DBIx/SearchBuilder/Handle.pm:509) [Thu Aug 27 16:44:29 2009] [warning]: RT::Handle=HASH(0x2ac0dc7a8be0) couldn't execute the query 'SELECT COUNT(*) FROM Attributes WHERE Description LIKE '%unowned%' AND ( (Name='SavedSearch' AND ( (ObjectType='RT::User' AND ObjectId=12) ) ) OR ( ObjectType='RT::System' AND (Name LIKE 'Search - %' OR Name='SavedSearch') ) ) ORDER BY Description;' at /usr/lib/perl5/site_perl/5.8.8/DBIx/SearchBuilder/Handle.pm line 522 DBIx::SearchBuilder::Handle::SimpleQuery('RT::Handle=HASH(0x2ac0dc7a8be0 )', 'SELECT COUNT(*) FROM Attributes WHERE Description LIKE \'%uno...') called at /usr/local/rt/plugins/RTx-S3Invoker/html/Search/Invoker line 36 A similar error appeared in the browser. After contemplating Invoker, I decided to run the query manually against the database with psql. I received the same error, so Postgres does not like this query format for some reason. Googling turned up this: http://archives.postgresql.org/pgsql-general/2004-02/msg01210.php in which the inimitable Tom Lane says: Postgres currently implements the SQL92 definition, which is that you can't refer to an ungrouped column except within an aggregate function call. So you need to call out all the columns to be referenced in GROUP BY. So I changed Invoker thusly. Before: my $WHERE = sprintf(WHERE Description LIKE '%s' AND ( (Name='SavedSearch' AND ( (ObjectType='RT::User' AND ObjectId=%i) %s ) ) OR ( ObjectType='RT::System' AND (Name LIKE 'Search - %' OR Name='SavedSearch') ) ) ORDER BY Description, %\Q${do}\E%, $session{'CurrentUser'}-Id, scalar @groups ? OR ( ObjectType='RT::Group' AND ObjectId IN (. join(',', @groups) .') )' : '' ); After: my $WHERE = sprintf(WHERE Description LIKE '%s' AND ( (Name='SavedSearch' AND ( (ObjectType='RT::User' AND ObjectId=%i) %s ) ) OR ( ObjectType='RT::System' AND (Name LIKE 'Search - %' OR Name='SavedSearch') ) ) GROUP BY Description, Objecttype, objectid, id ORDER BY Description, %\Q${do}\E%, $session{'CurrentUser'}-Id, scalar @groups ? OR ( ObjectType='RT::Group' AND ObjectId IN (. join(',', @groups) .') )' : '' ); This worked! great. Here are the questions: 1. It appears that Postgres *may* support SELECT with undefined GROUP BY in later releases, but I have not been able to test this yet. is 8.1.11 modern enough to make this worth filing a bug report? It's the default postgres package that comes with CentOS 5.3, so maybe it's not so ancient. 2. It doesn't look like calling out a GROUP BY explicitly like this would work against MySQL installs, but I'm really not sure. Would there be a better way of constructing the query than what I have done here? (SELECT DISTINCT maybe?) Thanks all for yout time! Ian Smith Director of Information Technology Production Resource Group 201-758-4315 findme 201-868-7195 fax ism...@prg.com mailto:ism...@prg.com www.prg.com http://www.prg.com/ invoke-modified.tar.gz Description: invoke-modified.tar.gz ___ 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.4 port for FreeBSD
Hi all, I would like to upgrade our RT installation from 3.8.1 to 3.8.4 on a FreeBSD based machine. 3.8.1 was previously installed from ports. Even if 3.8.4 port is not available yet, are there any instructions to update RT from one version to the other on FreeBSD (via ports)? Thanks, ___ 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] List of user accounts in CLI
Ho do I get the list of user accounts who can login to RT, from CLI? -- Asif Iqbal PGP Key: 0xE62693C5 KeyServer: pgp.mit.edu A: Because it messes up the order in which people normally read text. Q: Why is top-posting such a bad thing? ___ 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] RTx::S3Invoker problems with Postgres 8.1.11 and RT 3.8.4
No quite sure why this went to the list rather than rt.cpan, and with an archive rather than a diff, but thanks for the report. This has been fixed in 0.15 which is on its way to a CPAN mirror near you. -- Cambridge Energy Alliance: Save money. Save the planet. ___ 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] RT 3.8.4 port for FreeBSD
On Fri, 28 Aug 2009 13:55:10 -0400 Akash joe.rtu...@gmail.com wrote: Hi all, I would like to upgrade our RT installation from 3.8.1 to 3.8.4 on a FreeBSD based machine. 3.8.1 was previously installed from ports. Even if 3.8.4 port is not available yet, are there any instructions to update RT from one version to the other on FreeBSD (via ports)? Thanks, Hi Joe 3.8.4 is available: http://www.freshports.org/www/rt38 Cheers -- Tobias Lott ___ 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] RTx::S3Invoker problems with Postgres 8.1.11 and RT 3.8.4
Mostly because I wasn't sure it was bug-worthy, and wanted some feedback. It came as an archive because I am unfamiliar with the process! :-) Thanks, -Ian ___ 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