Re: [rt-users] SSL no verify function for rt cli tool? (with workaround)

2015-08-26 Thread Christian Loos
Am 27.08.2015 um 03:18 schrieb Dion Gullotta:
> I realise this isn’t an RT problem as it is really LWP, but it would be
> nice if the RT CLI supported a --no-verify-ssl option to workaround
> these situations. As it stands I had to edit the code of /opt/rt4/bin/rt
> and added the following on line 54 which allowed us to move forward, but
> this will be an issue for future upgrades:
> 
>  
> 
> BEGIN { $ENV{PERL_LWP_SSL_VERIFY_HOSTNAME} = 0;}
> 

You don't have to modify the code.
You can set "export PERL_LWP_SSL_VERIFY_HOSTNAME=0" somewhere on the
client host (/etc/environment or ~/.bashrc of the user who use the rt
client).

But remember that this will affect all LWP calls.

Chris


Re: [rt-users] RT CLI CF query operators

2015-08-26 Thread Christian Loos
Am 26.08.2015 um 21:25 schrieb supp...@pureview.com:
> rt list -i "'CF.{Modtrak}' > 0 AND Created >= '2015-07-01' AND Create <=
> '2015-07-31'"
> rt: Invalid query: 'Unknown field 'Create' in ''CF.{Modtrak}' > 0 AND
> Created >= '2015-07-01' AND Create <= '2015-07-31'' at
> /opt/rt4/sbin/../lib/RT/Tickets.pm line 2943.

The error message says all.
It's just a typo, the ticket field is called Created and not Create.

Chris


[rt-users] SSL no verify function for rt cli tool? (with workaround)

2015-08-26 Thread Dion Gullotta
Hi,

The rt-mailgate tool has a --no-verify-ssl option, I was wondering if the "rt" 
command line tool has a similar option?

I ask because we have a self signed cert that just doesn't seem to play nice 
with LWP. It used to work fine in RT3 but we upgraded to RT4 yesterday and the 
newer version of LWP isn't having any of it.


Cert verifies OK:
root@ariel:~# openssl verify /etc/ssl/certs/rt.ourdomain.com.au.crt
/etc/ssl/certs/rt.ourdomain.com.au.crt: OK


But rt doesn't like it:
root@ariel:~# rt list
Query:Status!='resolved' and Status!='rejected'
rt: Server error: Can't connect to rt.ourdomain.com.au:443 (certificate verify 
failed) (500)


Which is because of lwp:
root@ariel:~# lwp-request https://rt.ourdomain.com.au
Can't connect to rt.ourdomain.com.au:443 (certificate verify failed)
SSL connect attempt failed error:14090086:SSL 
routines:SSL3_GET_SERVER_CERTIFICATE:certificate verify failed at 
/usr/local/share/perl/5.18.2/LWP/Protocol/http.pm line 47.


I realise this isn't an RT problem as it is really LWP, but it would be nice if 
the RT CLI supported a --no-verify-ssl option to workaround these situations. 
As it stands I had to edit the code of /opt/rt4/bin/rt and added the following 
on line 54 which allowed us to move forward, but this will be an issue for 
future upgrades:

BEGIN { $ENV{PERL_LWP_SSL_VERIFY_HOSTNAME} = 0;}


Any thoughts?

Cheers,

Dion Gullotta
Far Edge Technology

p. 02 84251400
http://www.faredge.com.au




Re: [rt-users] missing plugin

2015-08-26 Thread Matt Zagrabelny
On Wed, Aug 26, 2015 at 10:20 AM, Steve Postma  wrote:
> Hi all,
>
> my repeat-ticket extension is missing from the web interface.
>
> cleared mason cache, restarted httpd,
>
>
> RT_SiteConfig.pm still calls on it to be loaded, no errors in 
> /var/log/messages or var/log/httpd
>
>
> How can I troubleshoot this?

Did you download the plugin?

https://metacpan.org/release/RT-Extension-RepeatTicket

-m


[rt-users] missing plugin

2015-08-26 Thread Steve Postma
Hi all,

my repeat-ticket extension is missing from the web interface.

cleared mason cache, restarted httpd,


RT_SiteConfig.pm still calls on it to be loaded, no errors in /var/log/messages 
or var/log/httpd


How can I troubleshoot this?


Thanks,

Steve



[rt-users] RT CLI CF query operators

2015-08-26 Thread support
RT users,


I trying to use RT CLI on a CF for operators and I having a hard time to
get this working. Can any help on this. I do not know what I'm doing
wrong.


RT: rt.4.2
OS : RH 6.0


rt list -i "'CF.{Modtrak}' > 0 AND Created >= '2015-07-01' AND Create <=
'2015-07-31'"
rt: Invalid query: 'Unknown field 'Create' in ''CF.{Modtrak}' > 0 AND
Created >= '2015-07-01' AND Create <= '2015-07-31'' at
/opt/rt4/sbin/../lib/RT/Tickets.pm line 2943.

Stack:
  [/opt/rt4/sbin/../lib/RT/Tickets.pm:2943]
  [/opt/rt4/sbin/../lib/RT/SQL.pm:172]
  [/opt/rt4/sbin/../lib/RT/Tickets.pm:2979]
  [/opt/rt4/sbin/../lib/RT/Tickets.pm:2997]
  [/opt/rt4/share/html/REST/1.0/search/ticket:89]
  [/opt/rt4/share/html/REST/1.0/autohandler:54]
  [/opt/rt4/sbin/../lib/RT/Interface/Web.pm:680]
  [/opt/rt4/sbin/../lib/RT/Interface/Web.pm:368]
  [/opt/rt4/share/html/autohandler:53]
'.
Invalid query: 'Unknown field 'Create' in ''CF.{Modtrak}' > 0 AND Created
>= '2015-07-01' AND Create <= '2015-07-31'' at
/opt/rt4/sbin/../lib/RT/Tickets.pm line 2943.

Stack:
  [/opt/rt4/sbin/../lib/RT/Tickets.pm:2943]
  [/opt/rt4/sbin/../lib/RT/SQL.pm:172]
  [/opt/rt4/sbin/../lib/RT/Tickets.pm:2979]
  [/opt/rt4/sbin/../lib/RT/Tickets.pm:2997]
  [/opt/rt4/share/html/REST/1.0/search/ticket:89]
  [/opt/rt4/share/html/REST/1.0/autohandler:54]
  [/opt/rt4/sbin/../lib/RT/Interface/Web.pm:680]
  [/opt/rt4/sbin/../lib/RT/Interface/Web.pm:368]
  [/opt/rt4/share/html/autohandler:53]




[rt-users] Assets search in dashboard

2015-08-26 Thread James McAtee
Is there a built-in way to save an Assets search for use in a dashboard?

Thanks,
Michael


Re: [rt-users] Accidently removed Admin rights from users, whoopsy daisy

2015-08-26 Thread Markus . Wildbolz
Hi!

Maybe the article at

http://requesttracker.wikia.com/wiki/RecoverSuperUserRights

can help.

You have to consider a version change to RT 4, maybe...


BR,
Markus


Re: [rt-users] Problem with extension RepeatTicket

2015-08-26 Thread frankfurter
ok i will switch back to my old shell script solution till the bug is fixed



--
View this message in context: 
http://requesttracker.8502.n7.nabble.com/Problem-with-extension-RepeatTicket-tp60471p60533.html
Sent from the Request Tracker - User mailing list archive at Nabble.com.


[rt-users] Accidently removed Admin rights from users, whoopsy daisy

2015-08-26 Thread Ewan Meadows
Somehow I've managed to remove the admin rights even from the root
user, so I am unable to change rights/add users/etc.  When logging in
as root I no longer see the settings menu so I'm kinda stuck :\

Is there a way to manually edit the mysql database to gain admin rights again?