[rt-users] Owner Query - Custom

[Marcelo Calado | TBS TAX Services]

Hello!

 

When I trying to create a ticket on RT 4.09, I'd like to select just the RT
User's of Owner field on the basics table in the right side.

 

I'd like to select only the RT User's on my Owner Query! Is it Possible? How
Can I do this? I can't see the Watcher's!

 



Owner:





 Nobody in particular

 RT User 1

 Watcher 1

"

"

 

 

Thanks,

 

Marcelo Calado.

 

Re: [rt-users] Owner Query - Custom

[Matt Zagrabelny]

Hi Marcelo,

On Tue, Nov 10, 2015 at 8:42 AM, Marcelo Calado | TBS TAX Services
 wrote:
> Hello!
>
>
>
> When I trying to create a ticket on RT 4.09, I’d like to select just the RT
> User’s of Owner field on the basics table in the right side.
>
>
>
> I’d like to select only the RT User’s on my Owner Query! Is it Possible? How
> Can I do this? I can’t see the Watcher’s!

I don't quite understand your question. Do you think you could
rephrase it or write it out differently?

Cheers,

-m

[rt-users] Regarding RT External Authentication.

[bharath reddy]

Dear All,

I'm facing issue while RT External AUthentication with LDAP, following is
the error from log files :

[7338] [Tue Nov 10 21:57:41 2015] [debug]: Attempting to use external auth
service: My_LDAP
(/rt/local/plugins/RT-Authen-ExternalAuth/lib/RT/Authen/ExternalAuth.pm:424)
[7338] [Tue Nov 10 21:57:41 2015] [debug]: Calling UserExists with
$username (myuser) and $service (My_LDAP)
(/rt/local/plugins/RT-Authen-ExternalAuth/lib/RT/Authen/ExternalAuth.pm:465)
[7338] [Tue Nov 10 21:57:41 2015] [debug]: UserExists params:
username: bvangoor , service: My_LDAP
(/rt/local/plugins/RT-Authen-ExternalAuth/lib/RT/Authen/ExternalAuth/LDAP.pm:439)
[7338] [Tue Nov 10 21:57:41 2015] [debug]: LDAP Search ===  Base:
OU=SBCS,DC=cs,DC=stonybrook,DC=edu == Filter:
(&(&(objectClass=user)(|(memberOf=CN=System Staff Users,OU=Security
Groups,OU=SBCS,DC=cs,DC=stonybrook,DC=edu)(memberOf=CN=Student Assistant
Users,OU=Security
Groups,OU=SBCS,DC=cs,DC=stonybrook,DC=edu)(memberOf=CN=Assistant
Professors,OU=Security
Groups,OU=SBCS,DC=cs,DC=stonybrook,DC=edu)(memberOf=CN=Full
Professors,OU=Security
Groups,OU=SBCS,DC=cs,DC=stonybrook,DC=edu)(memberOf=CN=Associate
Professors,OU=Security
Groups,OU=SBCS,DC=cs,DC=stonybrook,DC=edu)(memberOf=CN=Instructors,OU=Security
Groups,OU=SBCS,DC=cs,DC=stonybrook,DC=edu)))(sAMAccountName=bvangoor)) ==
Attrs: cn,mail,sAMAccountName
(/rt/local/plugins/RT-Authen-ExternalAuth/lib/RT/Authen/ExternalAuth/LDAP.pm:469)
[7338] [Tue Nov 10 21:57:41 2015] [debug]:
RT::Authen::ExternalAuth::CanonicalizeUserInfo called by
RT::Authen::ExternalAuth
/rt/local/plugins/RT-Authen-ExternalAuth/lib/RT/Authen/ExternalAuth.pm 885
with: Disabled: , EmailAddress: , Gecos: myuser, Name: myuser, Privileged:
1
(/rt/local/plugins/RT-Authen-ExternalAuth/lib/RT/Authen/ExternalAuth.pm:792)
[7338] [Tue Nov 10 21:57:41 2015] [debug]: Attempting to get user info
using this external service: My_LDAP
(/rt/local/plugins/RT-Authen-ExternalAuth/lib/RT/Authen/ExternalAuth.pm:800)
[7338] [Tue Nov 10 21:57:41 2015] [debug]: Attempting to use this
canonicalization key: Name
(/rt/local/plugins/RT-Authen-ExternalAuth/lib/RT/Authen/ExternalAuth.pm:809)
[7338] [Tue Nov 10 21:57:42 2015] [debug]: LDAP Search ===  Base:
OU=SBCS,DC=cs,DC=stonybrook,DC=edu == Filter:
(&(&(objectClass=user)(|(memberOf=CN=System Staff Users,OU=Security
Groups,OU=SBCS,DC=cs,DC=stonybrook,DC=edu)(memberOf=CN=Student Assistant
Users,OU=Security
Groups,OU=SBCS,DC=cs,DC=stonybrook,DC=edu)(memberOf=CN=Assistant
Professors,OU=Security
Groups,OU=SBCS,DC=cs,DC=stonybrook,DC=edu)(memberOf=CN=Full
Professors,OU=Security
Groups,OU=SBCS,DC=cs,DC=stonybrook,DC=edu)(memberOf=CN=Associate
Professors,OU=Security
Groups,OU=SBCS,DC=cs,DC=stonybrook,DC=edu)(memberOf=CN=Instructors,OU=Security
Groups,OU=SBCS,DC=cs,DC=stonybrook,DC=edu)))(sAMAccountName=bvangoor)) ==
Attrs: cn,mail,sAMAccountName
(/rt/local/plugins/RT-Authen-ExternalAuth/lib/RT/Authen/ExternalAuth/LDAP.pm:357)
[7338] [Tue Nov 10 21:57:42 2015] [info]:
RT::Authen::ExternalAuth::CanonicalizeUserInfo returning Disabled: ,
EmailAddress: myu...@cs.stonybrook.edu ,
Gecos: myuser, Name: myuser, Privileged: 1,
RealName: myuser
(/rt/local/plugins/RT-Authen-ExternalAuth/lib/RT/Authen/ExternalAuth.pm:868)
*[7338] [Tue Nov 10 21:57:42 2015] [error]: Couldn't create user myuser:
Email address in use
(/rt/local/plugins/RT-Authen-ExternalAuth/lib/RT/Authen/ExternalAuth.pm:491)*
[7338] [Tue Nov 10 21:57:42 2015] [debug]: Autohandler called ExternalAuth.
Response: (0, No User)
(/rt/local/plugins/RT-Authen-ExternalAuth/html/Elements/DoAuth:11)

When I check my Database (mysql) I find the following details :

mysql> select * from Users where EmailAddress like "%bvangoor%"\G
*** 1. row ***
   id: 46061
* Name: myu...@cs.stonybrook.edu
*
 Password: *NO-PASSWORD*
 Comments: NULL
Signature: NULL
 EmailAddress: myu...@cs.stonybrook.edu 

Can anyone help me what the issue is.

RT Authentication works fine If I delete the user entry from
Database(mysql).


Thanks,
Bharath.

Re: [rt-users] Unable to create scrips in RT 4.2.12

[Parish, Brent]

Good catch!

I'm sure other people have better ways to do this, but this is what works for 
me in our environment:

First I copy the original RT file into the local/  directory tree (per standard 
RT modification practices).
But I make two copies there - one is named with a ".orig" file extension.
  e.g.
Tabs
 Tabs.orig

The .orig file is a copy of the original Tabs file (at the time I modified it, 
lets say version 4.0.9.
After I run an upgrade (e,g, to 4.2.12), I first do a 'diff' on the Tabs.orig 
(remember, that is 4.0.9) against the new Tabs (4.2.12).
If the files are the same (no changes in the new version of RT), I keep my 
changed Tabs file as-is.
If there are changes in the new rev, I must manually merge my changes into it.
(and then copy the new version (original) as the new Tabs.orig, ready for the 
next upgrade).

A nice side effect of this is that I can run a 'find' command after each 
upgrade for *.orig, to ensure I am merging all code changes.

Just my 2 cents.

-  Brent



From: rt-users [mailto:rt-users-boun...@lists.bestpractical.com] On Behalf Of 
David Ramage
Sent: Tuesday, November 10, 2015 6:42 PM
To: rt-users@lists.bestpractical.com
Subject: Re: [rt-users] Unable to create scrips in RT 4.2.12

The previous admin had made some customizations to the Tabs file.  It looks 
like some internal URL plumbing changed between 4.0.9 and 4.2.12, and the URLs 
specified in the menu pointed to bad locations.

From: rt-users [mailto:rt-users-boun...@lists.bestpractical.com] On Behalf Of 
David Ramage
Sent: Monday, November 09, 2015 3:54 PM
To: rt-users@lists.bestpractical.com
Subject: [rt-users] Unable to create scrips in RT 4.2.12

Good afternoon,
I recently inherited a RT installation.  After upgrading our test system to 
4.2.12 I am unable to create scrips, either locally or for a specific queue.  I 
get a standard "An internal error has occurred" message from the web UI, and 
the following in syslog:

[17510] Can't call method "Queue" on an undefined value at 
/opt/rt4/sbin/../lib/RT/Scrip.pm line 450.#012#012Stack:#012  
[/opt/rt4/sbin/../lib/RT/Scrip.pm:450]#012
[/opt/rt4/share/html/Admin/Elements/EditScrip:83]#012
[/opt/rt4/share/html/Widgets/TitleBox:56]#012
[/opt/rt4/share/html/Admin/Elements/EditScrip:89]#012
[/opt/rt4/share/html/Admin/Queues/Scrip.html:52]#012
[/opt/rt4/share/html/Admin/autohandler:49]#012
[/opt/rt4/sbin/../lib/RT/Interface/Web.pm:681]#012
[/opt/rt4/sbin/../lib/RT/Interface/Web.pm:369]#012
[/opt/rt4/share/html/autohandler:53]#012

I have verified that the undefined value is $args{'TicketObj'} in the Stage 
function in Scrip.pm, but haven't gotten any further.  I'll be greatful for any 
suggestions.

Re: [rt-users] Unable to create scrips in RT 4.2.12

[Christian Loos]

Hi Brent,

you should give Callbacks [1] a chance.
We use this for years. Minor (4.2.11 > 4.2.12) version updates are done
without any modification. Sometimes even major (4.2.12 > 4.4.0) updates
can be make without changing a callback file.

Chris

[1]
https://www.bestpractical.com/docs/rt/4.2/writing_extensions.html#Callbacks

Am 11.11.2015 um 03:53 schrieb Parish, Brent:
> Good catch!
> 
>  
> 
> I’m sure other people have better ways to do this, but this is what
> works for me in our environment:
> 
>  
> 
> First I copy the original RT file into the local/  directory tree (per
> standard RT modification practices).
> 
> But I make two copies there – one is named with a “.orig” file extension.
> 
>   e.g.
> 
> Tabs
> 
>  Tabs.orig
> 
>  
> 
> The .orig file is a copy of the original Tabs file (at the time I
> modified it, lets say version 4.0.9.
> 
> After I run an upgrade (e,g, to 4.2.12), I first do a ‘diff’ on the
> Tabs.orig (remember, that is 4.0.9) against the new Tabs (4.2.12).
> 
> If the files are the same (no changes in the new version of RT), I keep
> my changed Tabs file as-is.
> 
> If there are changes in the new rev, I must manually merge my changes
> into it.
> 
> (and then copy the new version (original) as the new Tabs.orig, ready
> for the next upgrade).
> 
>  
> 
> A nice side effect of this is that I can run a ‘find’ command after each
> upgrade for *.orig, to ensure I am merging all code changes.
> 
>  
> 
> Just my 2 cents.
> 
> -  Brent
> 

Re: [rt-users] What's huge RT/Mysql

[Christian Loos]

Hi,

we have over 30 tickets and process 8 tickets a year.
We currently use a single VM for our RT (Webserver and Database on the
same Machine).
And our RT is still really fast.
Thanks to the BPS developers.

Chris

Am 04.11.2015 um 22:23 schrieb Albert Shih:
> Hi everyone,
> 
> I would like to know without any customisation how can a RT instance with
> mysql backend can goes.
> 
> As I understand it's the number of tickets who can be a issue.
> 
> Sowhen it's can become a problem ? 50 000 ? 100 000 ? 500 000 ?
> 
> And same question with specific hardware (like mysql on SSD).
> 
> Regards.
> 
> JAS

Re: [rt-users] Unable to create scrips in RT 4.2.12

[David Ramage]

The previous admin had made some customizations to the Tabs file.  It looks 
like some internal URL plumbing changed between 4.0.9 and 4.2.12, and the URLs 
specified in the menu pointed to bad locations.

From: rt-users [mailto:rt-users-boun...@lists.bestpractical.com] On Behalf Of 
David Ramage
Sent: Monday, November 09, 2015 3:54 PM
To: rt-users@lists.bestpractical.com
Subject: [rt-users] Unable to create scrips in RT 4.2.12

Good afternoon,
I recently inherited a RT installation.  After upgrading our test system to 
4.2.12 I am unable to create scrips, either locally or for a specific queue.  I 
get a standard "An internal error has occurred" message from the web UI, and 
the following in syslog:

[17510] Can't call method "Queue" on an undefined value at 
/opt/rt4/sbin/../lib/RT/Scrip.pm line 450.#012#012Stack:#012  
[/opt/rt4/sbin/../lib/RT/Scrip.pm:450]#012
[/opt/rt4/share/html/Admin/Elements/EditScrip:83]#012
[/opt/rt4/share/html/Widgets/TitleBox:56]#012
[/opt/rt4/share/html/Admin/Elements/EditScrip:89]#012
[/opt/rt4/share/html/Admin/Queues/Scrip.html:52]#012
[/opt/rt4/share/html/Admin/autohandler:49]#012
[/opt/rt4/sbin/../lib/RT/Interface/Web.pm:681]#012
[/opt/rt4/sbin/../lib/RT/Interface/Web.pm:369]#012
[/opt/rt4/share/html/autohandler:53]#012

I have verified that the undefined value is $args{'TicketObj'} in the Stage 
function in Scrip.pm, but haven't gotten any further.  I'll be greatful for any 
suggestions.