Re: [rt-users] Owner Query - Custom

[Matt Zagrabelny]

Hi Marcelo,

On Fri, Nov 13, 2015 at 10:17 AM, Marcelo Calado | TBS TAX Services
 wrote:
>
> Thanks Matt!
>
> I've been working on it, But I have no idea how to set up this!
>
> I would like to use  the something like "WHERE" clause to filter my results 
> from Users (/html/helpers/Autocomplete/Owner) to show me only the Users who 
> can be Owner.

I haven't looked into that Mason component, so I don't have a good
answer for you. Sorry.

RT uses an ORM called SearchBuilder (SB) - BPS wrote it. Using SB is
how you will filter your query results down - like using a where
clause. SB calls it Limit.

However, Limit may or may not be what you want. It is tough to say
without looking at the code more closely, which I don't have time for
right now. :(

Best of luck!

-m

Re: [rt-users] Owner Query - Custom

[Marcelo Calado | TBS TAX Services]

Thanks Matt!

I've been working on it, But I have no idea how to set up this!

I would like to use  the something like "WHERE" clause to filter my results 
from Users (/html/helpers/Autocomplete/Owner) to show me only the Users who can 
be Owner.  

I'd like to return only Users checked   "Let this user access RT" and  "Let 
this user be granted rights (Privileged)" on Create/Modify User page. 

I've tried changing /share/html/Ticket/Create.html   - 
http://www.gossamer-threads.com/lists/rt/devel/44771?search_string=Owner;#44771 
, but no lock!

I also tried changing line 72 in share/html/Ticket/Create.html from: 
"..., Default => $ARGS{Owner}||$RT::Nobody->Id, ..." 
to each of these: 
"..., Default => $ARGS{Owner}||12, 13,14 ..."  by Id.did not function as 
expected...:(

How to add a new arguments when the function was called? 

At this point I can add my condition? 

(/html/helpers/Autocomplete/Owner)

<%ARGS>
$return => 'Name'
$limit => undef
$term => undef
$max => 10



Thanks,

Marcelo Calado.

-Original Message-
From: Matt Zagrabelny [mailto:mzagr...@d.umn.edu] 
Sent: Thursday, November 12, 2015 10:09 AM
To: Marcelo Calado | TBS TAX Services 
Cc: rt-users 
Subject: Re: [rt-users] Owner Query - Custom

On Wed, Nov 11, 2015 at 10:21 AM, Marcelo Calado | TBS TAX Services 
 wrote:
> Hi,
>
> I want to change (if possible) settings, under Permissions , modify the 
> permissions that are allowed or denied for only the RT User's   to be Owner's 
> when I create a new ticket or modify?
>
> The Watcher's can't be Owner!
>
> Is it possible?

You can hack on:

share/html/Helpers/Autocomplete/Owners

I see there is only one callback in there. You could add another callback to 
the mason component and then have your code utilize that callback. BPS is 
usually pretty accepting to new callbacks - send a patch their way to 
(hopefully) get it included in upstream.

-m

Re: [rt-users] Regarding Apache server failure

[Matt Brennan]

Hi Bharath,

  Were you able to get a solution to this? I just upgraded to Ubuntu 14.04
(from 11.04) and am experienced this same issue. Your post actually helped
me localize it to the external auth plugin.

  I found that I was running and older version (0.20) of the plugin. When I
upgraded to version 0.25, the issue went away.

Thanks, and hope that helps you.

-Matt

On Thu, Oct 8, 2015 at 11:48 AM, bharath reddy 
wrote:

> Matt,
>
> I don't think it is a problem with RAM or any hardware, because when I
> revert my changes in RT_SiteConfig.pm (with out LDAPAuthentication) apache
> starts with out any error.
>
> Thanks,
> Bharath.
>
> On Thu, Oct 8, 2015 at 10:54 AM, Matt Zagrabelny 
> wrote:
>
>> On Thu, Oct 8, 2015 at 9:21 AM, bharath reddy 
>> wrote:
>> > Hi Matt,
>> >
>> > Thanks for replying back, here are the details :
>> >
>> > Distro :
>> > root@devrt:~# cat /etc/os-release
>> > NAME="Ubuntu"
>> > VERSION="12.04.3 LTS, Precise Pangolin"
>> > ID=ubuntu
>> > ID_LIKE=debian
>> > PRETTY_NAME="Ubuntu precise (12.04.3 LTS)"
>> > VERSION_ID="12.04"
>> >
>> > cd /var/log
>> > ls -lrt (I'm showing only latest)
>> > -rw-r- 1 syslogadm  124 Oct  8 09:58 kern.log
>> > -rw-r- 1 root  adm  529 Oct  8 09:58 apport.log
>> > -rw-r- 1 syslogadm 3086 Oct  8 10:00 syslog
>> > -rw-r- 1 syslogadm   113879 Oct  8 10:00 auth.log
>> >
>> > root@devrt:/var/log# cat kern.log
>> > Oct  8 09:58:10 devrt kernel: [3001033.121438] /usr/sbin/apach[5529]:
>> > segfault at b54d9f80 ip b54d9f80 sp bfc702dc error 14
>> >
>> > root@devrt:/var/log# cat apport.log
>> > ERROR: apport (pid 5532) Thu Oct  8 09:58:11 2015: called for pid 5529,
>> > signal 11
>> > ERROR: apport (pid 5532) Thu Oct  8 09:58:11 2015: executable:
>> > /usr/lib/apache2/mpm-prefork/apache2 (command line "/usr/sbin/apache2 -k
>> > start")
>> > ERROR: apport (pid 5532) Thu Oct  8 09:58:11 2015:
>> is_closing_session(): no
>> > DBUS_SESSION_BUS_ADDRESS in environment
>> > ERROR: apport (pid 5532) Thu Oct  8 09:58:11 2015: apport: report
>> > /var/crash/_usr_lib_apache2_mpm-prefork_apache2.0.crash already exists
>> and
>> > unseen, doing nothing to avoid disk usage DoS
>> >
>> > root@devrt:/var/log# cat syslog
>> > Oct  8 09:58:10 devrt kernel: [3001033.121438] /usr/sbin/apach[5529]:
>> > segfault at b54d9f80 ip b54d9f80 sp bfc702dc error 14
>> > Oct  8 10:00:01 devrt CRON[5582]: (smmsp) CMD (test -x
>> /etc/init.d/sendmail
>> > && /usr/share/sendmail/sendmail cron-msp)
>>
>> Apache is segfaulting. Perhaps you have some bad RAM or other hardware
>> issues.
>>
>> You could try to set up another system with the same configs as this one.
>>
>> > cd /var/log/apache2
>> > ls -lrt
>> >
>> > last updated file under this directory is on oct 6th
>> > rw-r--r-- 1 root root  0 Oct  6 15:33 error.log
>> >
>> > Is there any way I can enable more debug messages through apache ?
>>
>> Not sure. Try google. :)
>>
>> -m
>>
>
>

Re: [rt-users] Regarding Apache server failure

[bharath reddy]

Hi Matt,

Thanks for posting this, Yes I was able to get the solution. The issue in
my case was I missed one of the key plugin and Apache didn't show me that
missing plugin in logs, later when I set the RT log then i was able to
found it.

Thanks,
Bharath.

On Fri, Nov 13, 2015 at 3:38 PM, Matt Brennan  wrote:

> Hi Bharath,
>
>   Were you able to get a solution to this? I just upgraded to Ubuntu 14.04
> (from 11.04) and am experienced this same issue. Your post actually helped
> me localize it to the external auth plugin.
>
>   I found that I was running and older version (0.20) of the plugin. When
> I upgraded to version 0.25, the issue went away.
>
> Thanks, and hope that helps you.
>
> -Matt
>
> On Thu, Oct 8, 2015 at 11:48 AM, bharath reddy 
> wrote:
>
>> Matt,
>>
>> I don't think it is a problem with RAM or any hardware, because when I
>> revert my changes in RT_SiteConfig.pm (with out LDAPAuthentication) apache
>> starts with out any error.
>>
>> Thanks,
>> Bharath.
>>
>> On Thu, Oct 8, 2015 at 10:54 AM, Matt Zagrabelny 
>> wrote:
>>
>>> On Thu, Oct 8, 2015 at 9:21 AM, bharath reddy 
>>> wrote:
>>> > Hi Matt,
>>> >
>>> > Thanks for replying back, here are the details :
>>> >
>>> > Distro :
>>> > root@devrt:~# cat /etc/os-release
>>> > NAME="Ubuntu"
>>> > VERSION="12.04.3 LTS, Precise Pangolin"
>>> > ID=ubuntu
>>> > ID_LIKE=debian
>>> > PRETTY_NAME="Ubuntu precise (12.04.3 LTS)"
>>> > VERSION_ID="12.04"
>>> >
>>> > cd /var/log
>>> > ls -lrt (I'm showing only latest)
>>> > -rw-r- 1 syslogadm  124 Oct  8 09:58 kern.log
>>> > -rw-r- 1 root  adm  529 Oct  8 09:58 apport.log
>>> > -rw-r- 1 syslogadm 3086 Oct  8 10:00 syslog
>>> > -rw-r- 1 syslogadm   113879 Oct  8 10:00 auth.log
>>> >
>>> > root@devrt:/var/log# cat kern.log
>>> > Oct  8 09:58:10 devrt kernel: [3001033.121438] /usr/sbin/apach[5529]:
>>> > segfault at b54d9f80 ip b54d9f80 sp bfc702dc error 14
>>> >
>>> > root@devrt:/var/log# cat apport.log
>>> > ERROR: apport (pid 5532) Thu Oct  8 09:58:11 2015: called for pid 5529,
>>> > signal 11
>>> > ERROR: apport (pid 5532) Thu Oct  8 09:58:11 2015: executable:
>>> > /usr/lib/apache2/mpm-prefork/apache2 (command line "/usr/sbin/apache2
>>> -k
>>> > start")
>>> > ERROR: apport (pid 5532) Thu Oct  8 09:58:11 2015:
>>> is_closing_session(): no
>>> > DBUS_SESSION_BUS_ADDRESS in environment
>>> > ERROR: apport (pid 5532) Thu Oct  8 09:58:11 2015: apport: report
>>> > /var/crash/_usr_lib_apache2_mpm-prefork_apache2.0.crash already exists
>>> and
>>> > unseen, doing nothing to avoid disk usage DoS
>>> >
>>> > root@devrt:/var/log# cat syslog
>>> > Oct  8 09:58:10 devrt kernel: [3001033.121438] /usr/sbin/apach[5529]:
>>> > segfault at b54d9f80 ip b54d9f80 sp bfc702dc error 14
>>> > Oct  8 10:00:01 devrt CRON[5582]: (smmsp) CMD (test -x
>>> /etc/init.d/sendmail
>>> > && /usr/share/sendmail/sendmail cron-msp)
>>>
>>> Apache is segfaulting. Perhaps you have some bad RAM or other hardware
>>> issues.
>>>
>>> You could try to set up another system with the same configs as this one.
>>>
>>> > cd /var/log/apache2
>>> > ls -lrt
>>> >
>>> > last updated file under this directory is on oct 6th
>>> > rw-r--r-- 1 root root  0 Oct  6 15:33 error.log
>>> >
>>> > Is there any way I can enable more debug messages through apache ?
>>>
>>> Not sure. Try google. :)
>>>
>>> -m
>>>
>>
>>
>