Re: [rt-users] REST API and Saved Searches
Kevin Hi The spreadsheet feed is how we extract the data currently, what I am trying to end up with is a fully automated spreadsheet, where the manager opens the spreadsheet the data is collected using data import inside the spreadsheet and the data is then presented in various ways. I have tried various ways either with the REST API and also by using the URL used by RT to generate the spreadsheet but excel complains that the URL is too long. I am beginning to think that this is not possible without using SQL and joining all the tables together. Again thank you for your help and patience Simon -Original Message- From: Kevin Falcone [mailto:falc...@bestpractical.com] Sent: 20 August 2012 17:42 To: rt-users@lists.bestpractical.com Subject: Re: [rt-users] REST API and Saved Searches On Mon, Aug 20, 2012 at 04:02:27PM +0100, Simon Dray wrote: Thanks for taking the time to answer but the RSS feed doesn't give me the data and formatting I wanted, the result I was trying to get was the same as an output directly to the spreadsheet. My SQL is not good enough to stitch all the bits together. I am trying to make easy for management to just run the spreadsheet and then use excel to extract the data locally, I know the correct way is to do a MYSQL query and then do joins for the tables but my knowledge stops at getting one table let alone 7 or 8 I wasn't suggesting the RSS feed, I was suggesting the Spreadsheet Feed. -kevin -Original Message- From: Kevin Falcone [mailto:falc...@bestpractical.com] Sent: 20 August 2012 15:40 To: rt-users@lists.bestpractical.com Subject: Re: [rt-users] REST API and Saved Searches On Fri, Aug 17, 2012 at 12:40:52PM +0100, Simon Dray wrote: I am trying to use REAST API from excel and can do simple queries but want to use a saved search does anyone know of REST command line that can do this, I want to import the saved search out into a spreadsheet You cannot access saved searches via the REST API. Save searches can be exported out to spreadsheets from the Feeds tab in the web UI. -kevin
[rt-users] LDAP-Active Directory external authentification search/authentificate users in a subtree
Hello, I have set up a new Request Tracker server, that uses the RT::Authen::*ExternalAuth *extension. Everything is working fine, and i am able to authenticate users account from the Active Directory into RT, the problem is that i have is that my organisation has a complicated structure, with many OU, and the ldap search for users from what i could figure it out is made having as a scope just one level, what would i need is to have as a scope a whole Subtree. So let me give you an example. My base is in my RT_SiteConfig.pm file is : dc=mydomain, dc=local I am able to log into Request Tracker with a user account contain in CN=Users, DC=mydomain, DC=local But i am unable to log into Request Tracker with a user account contain in OU=Users,OU=DepartmentName,DC=mydomain,DC=local Many thanks for your future responses, or hints, i really appreciate them.
Re: [rt-users] RT_SiteConfig.pm issues after upgrade to 4.0.6
On Mon, Aug 20, 2012 at 05:40:50PM -0700, Slicer085 wrote: I've encountered a few issues since my recent upgrade from 4.0.4 to 4.0.6. It would seem some of the variables I have set in RT_SiteConfig.pm don't appear to be pushing through to RT_Config.pm. As such, I am forced to modify RT_Config.pm direct before some changes actually work. ie. Set($SetOutGoingMailFrom,1); (Some emails were bouncing as the domain was incorrect (Internal system only) The config option is named SetOutgoingMailFrom not SetOutGoingMailFrom Set( $WebDomaiin, 'rt.xxx.xxx' ); The config option is named WebDomain not WebDomaiin -kevin pgpIo19Ex84zd.pgp Description: PGP signature
[rt-users] rt-mailgate problem - certificate verify failure ?
Hello, The rt-mailgate program acts differently between v 3.8.8 and v 4.0.6. The v 3.8.8 version works fine using https, and even when I have v 4.0.6 running with the /etc/aliases point to the v 3.8.8 version of rtmailgate, email get sent to the queue. But the v 4.0.6 version fails with certificate verify failed, output from mailq: (temporary failure. Command output: An Error Occurred = 500 Can't connect to testrt.rc.fas.harvard.edu:443 (certificate verify failed)) r...@testrt.rc.fas.harvard.edu Any ideas as to the verification of my RT/ssl setup, on how to fix this ? Apparently the RT 4.0.6 is less forgiving about the ssl setup and config. I ran RT configure with the --enable-ssl-mailgate option and installed all perl modules required with make fixdeps in RT 4.0.6. Thanks, Mike This is in /etc/aliases: # rt3 rt: |/opt/rt-3.8.8/bin/rt-mailgate --queue 'General' --action correspond --url https://testrt.rc.fas.harvard.edu/; rt-comment: |/opt/rt-3.8.8/bin/rt-mailgate --queue 'General' --action comment --url https://testrt.rc.fas.harvard.edu/; # rt4 #rt: |/opt/rt4/bin/rt-mailgate --queue 'General' --ca-file /etc/pki/tls/certs/ca-bundle.crt --action correspond --url https://testrt.rc.fas.harvard.edu/; #rt-comment: |/opt/rt4/bin/rt-mailgate --queue 'General' --ca-file /etc/pki/tls/certs/ca-bundle.crt --action comment --url https://testrt.rc.fas.harvard.edu/;
Re: [rt-users] rt-mailgate problem - certificate verify failure ?
On 21.8.2012 15:59, Ethier, Michael wrote: Hello, The rt-mailgate program acts differently between v 3.8.8 and v 4.0.6. The v 3.8.8 version works fine using https, and even when I have v 4.0.6 running with the /etc/aliases point to the v 3.8.8 version of rtmailgate, email get sent to the queue. But the v 4.0.6 version fails with certificate verify failed, output from mailq: (temporary failure. Command output: An Error Occurred = 500 Can't connect to testrt.rc.fas.harvard.edu:443 (certificate verify failed)) r...@testrt.rc.fas.harvard.edu Any ideas as to the verification of my RT/ssl setup, on how to fix this ? Apparently the RT 4.0.6 is less forgiving about the ssl setup and config. I ran RT configure with the --enable-ssl-mailgate option and installed all perl modules required with “make fixdeps” in RT 4.0.6. Thanks, Mike This is in /etc/aliases: # rt3 rt: |/opt/rt-3.8.8/bin/rt-mailgate --queue 'General' --action correspond --url https://testrt.rc.fas.harvard.edu/; rt-comment: |/opt/rt-3.8.8/bin/rt-mailgate --queue 'General' --action comment --url https://testrt.rc.fas.harvard.edu/; # rt4 #rt: |/opt/rt4/bin/rt-mailgate --queue 'General' --ca-file /etc/pki/tls/certs/ca-bundle.crt --action correspond --url https://testrt.rc.fas.harvard.edu/; #rt-comment: |/opt/rt4/bin/rt-mailgate --queue 'General' --ca-file /etc/pki/tls/certs/ca-bundle.crt --action comment --url https://testrt.rc.fas.harvard.edu/; Hi Mike, add this option to your aliases if you want to bypass certificate validation: --no-verify-ssl So your rt entry in /etc/aliases would look like this: #rt: |/opt/rt4/bin/rt-mailgate --queue 'General' --ca-file /etc/pki/tls/certs/ca-bundle.crt --action correspond --url https://testrt.rc.fas.harvard.edu/ --no-verify-ssl Martin
Re: [rt-users] rt-mailgate problem - certificate verify failure ?
Hi Martin, Thanks for the suggestion but if I enable --no-ssl I will be creating a security vulnerability no ? Thanks, Mike -Original Message- From: rt-users-boun...@lists.bestpractical.com [mailto:rt-users-boun...@lists.bestpractical.com] On Behalf Of Martin Drasar Sent: Tuesday, August 21, 2012 10:11 AM To: rt-users@lists.bestpractical.com Subject: Re: [rt-users] rt-mailgate problem - certificate verify failure ? On 21.8.2012 15:59, Ethier, Michael wrote: Hello, The rt-mailgate program acts differently between v 3.8.8 and v 4.0.6. The v 3.8.8 version works fine using https, and even when I have v 4.0.6 running with the /etc/aliases point to the v 3.8.8 version of rtmailgate, email get sent to the queue. But the v 4.0.6 version fails with certificate verify failed, output from mailq: (temporary failure. Command output: An Error Occurred = 500 Can't connect to testrt.rc.fas.harvard.edu:443 (certificate verify failed)) r...@testrt.rc.fas.harvard.edu Any ideas as to the verification of my RT/ssl setup, on how to fix this ? Apparently the RT 4.0.6 is less forgiving about the ssl setup and config. I ran RT configure with the --enable-ssl-mailgate option and installed all perl modules required with make fixdeps in RT 4.0.6. Thanks, Mike This is in /etc/aliases: # rt3 rt: |/opt/rt-3.8.8/bin/rt-mailgate --queue 'General' --action correspond --url https://testrt.rc.fas.harvard.edu/; rt-comment: |/opt/rt-3.8.8/bin/rt-mailgate --queue 'General' --action comment --url https://testrt.rc.fas.harvard.edu/; # rt4 #rt: |/opt/rt4/bin/rt-mailgate --queue 'General' --ca-file /etc/pki/tls/certs/ca-bundle.crt --action correspond --url https://testrt.rc.fas.harvard.edu/; #rt-comment: |/opt/rt4/bin/rt-mailgate --queue 'General' --ca-file /etc/pki/tls/certs/ca-bundle.crt --action comment --url https://testrt.rc.fas.harvard.edu/; Hi Mike, add this option to your aliases if you want to bypass certificate validation: --no-verify-ssl So your rt entry in /etc/aliases would look like this: #rt: |/opt/rt4/bin/rt-mailgate --queue 'General' --ca-file /etc/pki/tls/certs/ca-bundle.crt --action correspond --url https://testrt.rc.fas.harvard.edu/ --no-verify-ssl Martin
Re: [rt-users] rt-mailgate problem - certificate verify failure ?
On 21.8.2012 16:16, Ethier, Michael wrote: Hi Martin, Thanks for the suggestion but if I enable --no-ssl I will be creating a security vulnerability no ? Thanks, Mike Hi, that's for sure. This was a suggestion for a development machine (the name testrt.rc.fas.harvard.edu suggest that it is). If you want to avoid this step then you have to have a valid certificate for testrt.rc.fas.harvard.edu signed by a certificate authority that is in the ca bundle you are passing to rt-mailgate. Martin
Re: [rt-users] LDAP-Active Directory external authentification search/authentificate users in a subtree
On 08/21/2012 05:58 AM, Limit Less wrote: I have set up a new Request Tracker server, that uses the RT::Authen::*ExternalAuth *extension. Everything is working fine, and i am able to authenticate users account from the Active Directory into RT, the problem is that i have is that my organisation has a complicated structure, with many OU, and the ldap search for users from what i could figure it out is made having as a scope just one level, what would i need is to have as a scope a whole Subtree. The whole subtree is searched. Here's the line of code: https://github.com/bestpractical/rt-authen-externalauth/blob/master/lib/RT/Authen/ExternalAuth/LDAP.pm#L57 and the documentation for the default it's relying on: https://metacpan.org/module/Net::LDAP#search-OPTIONS- You should post your entire config, and error messages, etc.
Re: [rt-users] rt-mailgate problem - certificate verify failure ?
On 08/21/2012 08:03 AM, Martin Drasar wrote: If you want to avoid this step then you have to have a valid certificate for testrt.rc.fas.harvard.edu signed by a certificate authority that is in the ca bundle you are passing to rt-mailgate. Martin's referring to the --ca-file argument you can pass. You can also simply make sure to put your CA root cert used for signing into /etc/ssl/certs/ or your system's equivalent. See `perldoc bin/rt-mailgate` for more info.
Re: [rt-users] LDAP-Active Directory external authentification search/authentificate users in a subtree
It searches from the base down (subtree). Sadly, it looks like his base are not under a single container. (limit less, correct me if I misunderstood). You might be able to defined more auth services, each one identical, except with different bases, to auth against. Thanks, Jok -- | Joachim Thuau | IT Systems Engineer - Linux / SpaceX | On 8/21/12 8:11 AM, Thomas Sibley t...@bestpractical.com wrote: On 08/21/2012 05:58 AM, Limit Less wrote: I have set up a new Request Tracker server, that uses the RT::Authen::*ExternalAuth *extension. Everything is working fine, and i am able to authenticate users account from the Active Directory into RT, the problem is that i have is that my organisation has a complicated structure, with many OU, and the ldap search for users from what i could figure it out is made having as a scope just one level, what would i need is to have as a scope a whole Subtree. The whole subtree is searched. Here's the line of code: https://github.com/bestpractical/rt-authen-externalauth/blob/master/lib/RT /Authen/ExternalAuth/LDAP.pm#L57 and the documentation for the default it's relying on: https://metacpan.org/module/Net::LDAP#search-OPTIONS- You should post your entire config, and error messages, etc.
Re: [rt-users] Set up problems
On Mon, Aug 20, 2012 at 8:11 PM, Paul Tomblin ptomb...@xcski.com wrote: I send a copy of my latest code to my client. He followed my installation instructions (added the plugin name to RT_SiteConfig.pm @Plugins, do a perl Makefile.pm; make; make initdb; make install, restart the server), but when he tries to go to the first page of my code http://hisdomain.com/rt/cf/change_request.html , it redirects him to https://hisdomain.com/rt/SelfService/ I think I figured out the problem - somehow he's made all the users unprivileged. Either that or he changed the SelfServiceRegex. -- http://www.linkedin.com/in/paultomblin http://careers.stackoverflow.com/ptomblin
[rt-users] Need a custom PostgreSQL query to retrieve tickets
Hi there, I'm having a little trouble trying to create a custom query within RT. Typically I'd create a new search term using the query builder within RT to find the results what I am looking for however I've tried with all the available field options but no query can give me the search results that I want. The query that I'm having problems writing is one that will list any tickets that I touched between given dates. It can be a ticket that I don't own but made a comment or ticket which I simply updated with a different subject line or linked to related another related ticket. I've create a script so I can query the RT database directly and avoid using the query builder. The database we are using is PostgreSQL. If anyone can point me in the right direction or if they know of a book to buy or a thread post to read would really appreciate your feedback. Best regards, -- Phillip Pace - Account Manager A view into the Anchor Engineroom: http://anchor.com.au/blog/ Solving your problems 24x7 : http://anchor.com.au/wiki/ -- === Anchor Systems Pty Ltd - Hosting Heavyweights Level 1, 230 Clarence Street Sydney NSW 2000 Australia === Email: supp...@anchor.com.au Web: http://www.anchor.com.au Phone: 1300 883 979 Fax: 02 8296 5199 ===