Re: [rt-users] Installing RT with Oracle 11g: ERROR: as user 'rt': ORA-01017

[support]

Alex,

It works!!

Thanks a lot.
-David

> On Sat, 2013-12-14 at 18:43 -0500, supp...@pureview.com wrote:
>> Could I still install with rt Oracle user in place already. If that is
>> true what would be the new configuration file? What options should I
>> omit...!
>
> sbin/rt-setup-database --action init --skip-create
>
>  - Alex
>
>

Re: [rt-users] [RESOLVED] RTv4.2.1: Uninitialized value in concatenation in Web.pm

[zbigniew00]

I had 3 weird saved queries that the menu builder didn't like.    I tried renaming 573 and 575 and it didn't help.  I removed them and all seems well.|  573 | SavedSearch | highest priority tickets I own 1    | storable    | RT::System |    1 |  12 | 2012-06-13 20:40:55 |    12 | 2012-06-13 20:40:55 ||  574 | SavedSearch | NULL    | storable    | RT::System |    1 |  26 | 2012-06-13 20:41:59 |    26 | 2012-06-13 20:41:59 ||  575 | SavedSearch | highest priority tickets I own 2    | storable    | RT::System |    1 |  12 | 2012-06-13 20:55:04 |    12 | 2012-06-13 20:55:07 |  On 12/16/13, zbignie...@verizon.net wrote: A little more information...   I setup a little debugging and seems to be related to "[_1] highest priority tickets I own".    [30856] [Mon Dec 16 22:01:08 2013] [notice]: DEBUG: [_1] highest priority tickets I own (/opt/rt4/sbin/../lib/RT/Interface/Web.pm:1792)[30856] [Mon Dec 16 22:01:08 2013] [warning]: Use of uninitialized value in concatenation (.) or string at /opt/rt4/sbin/../lib/RT/Interface/Web.pm line 1792. (/opt/rt4/sbin/../lib/RT/Interface/Web.pm:1792)  On 12/16/13, zbignie...@verizon.net wrote: Recently upgraded to v4.2.1 and the following error is occurring on pretty much every button click when using the interface:[warning]: Use of uninitialized value in concatenation (.) or string at /opt/rt4/sbin/../lib/RT/Interface/Web.pm line 1793. (/opt/rt4/sbin/../lib/RT/Interface/Web.pm:1792)Any suggestions on where to look?  Archive had similar issues with RT-Authen-ExternalAuth, but that seemed to be a different .pm and I also didn't have the identified config entries.-Zb

Re: [rt-users] RT 3.8.8: Which users have privileges on which

[John Miller]

Just gave Rights Matrix a look.  Is there a way to do a more generalized
query--to say look at all groups simultaneously, rather than one at a
time?  I'd also like to join against the users table, and roll the whole
thing up into a report.  Ideally if someone can point me toward some SQL
that would do the job, that'd work as well.

John


On Fri, Dec 13, 2013 at 2:11 PM, Kenneth Crocker wrote:

>  queues?
> MIME-Version: 1.0
> Content-Type: text/plain; charset="utf-8"
> Content-Transfer-Encoding: quoted-printable
>
> Have you tried Rights Matrix?
>
> Kenn
>
> Sent from my Windows Phone From: John Miller
> Sent: =E2=80=8E12/=E2=80=8E13/=E2=80=8E2013 8:37 AM
> To: rt-users@lists.bestpractical.com
> Subject: [rt-users] RT 3.8.8: Which users have privileges on which
> queues?
> Hello everyone,
>
> We're running RT 3.8.8 (yes, I know it's old).  We're managing our=20
> group and queue privileges via RT itself, rather than LDAP.  How can we=20
> generate a report that shows us per queue which users have rights?
>
> I dug through the database schema for about an hour; decided it was=20
> better to ask than to keep digging.
>
> John
> --=20
> John Miller
> Systems Engineer
> Brandeis University
> johnm...@brandeis.edu
> (781) 736-4619
>



-- 
John Miller
Systems Engineer
Brandeis University
johnm...@brandeis.edu
(781) 736-4619

Re: [rt-users] RT 3.8.8: Which users have privileges on which

[John Miller]

Hi Kenn,

No--hadn't heard of Rights Matrix before--will give it a shot.

John


On Fri, Dec 13, 2013 at 2:11 PM, Kenneth Crocker wrote:

>  queues?
> MIME-Version: 1.0
> Content-Type: text/plain; charset="utf-8"
> Content-Transfer-Encoding: quoted-printable
>
> Have you tried Rights Matrix?
>
> Kenn
>
> Sent from my Windows Phone From: John Miller
> Sent: =E2=80=8E12/=E2=80=8E13/=E2=80=8E2013 8:37 AM
> To: rt-users@lists.bestpractical.com
> Subject: [rt-users] RT 3.8.8: Which users have privileges on which
> queues?
> Hello everyone,
>
> We're running RT 3.8.8 (yes, I know it's old).  We're managing our=20
> group and queue privileges via RT itself, rather than LDAP.  How can we=20
> generate a report that shows us per queue which users have rights?
>
> I dug through the database schema for about an hour; decided it was=20
> better to ask than to keep digging.
>
> John
> --=20
> John Miller
> Systems Engineer
> Brandeis University
> johnm...@brandeis.edu
> (781) 736-4619
>



-- 
John Miller
Systems Engineer
Brandeis University
johnm...@brandeis.edu
(781) 736-4619

Re: [rt-users] Excessive communication between RT and postgresql

[Alex Vandiver]

On Mon, 2013-12-16 at 13:58 +, Jacobsson, Henrik G wrote:
> After upgrading to RT 4.2.1, the postgresql database is producing
> massive volumes of WAL files around the clock with peaks during office
> hours.

And what version were you upgrading from?

> Before the upgrade – we had very limited volumes of WAL files
> produced, and nothing at all during non work hours. Now – at least
> 32MB, but usually 64MB of WAL is written every minute, when the system
> is supposed to be quiet.

Does that output cease if you temporarily turn off the webserver?  What
about if you disable your incoming MTA?

> Should there be any traffic at all between the RT server and database
> server when the system is not in use? Apart from occasional handshakes
> etc.

Depends what you mean by "in use."  RT has no long-running programs
aside from the web front-end; as such, requests to the database are only
generated by requests to Apache, or the cron jobs.  At times when there
are no Apache requests and no cron jobs, there should be no significant
database traffic.

Bear in mind that even if no _users_ are accessing the website, incoming
email gets POST'ed to the mail gateway endpoint, which may account for
some of the activity when you believe the system is not in use.

It may be enlightening to examine the generated WAL logs using
http://www.postgresql.org/docs/current/static/pgxlogdump.html
 - Alex

Re: [rt-users] Installing RT with Oracle 11g: ERROR: as user 'rt': ORA-01017

[Alex Vandiver]

On Sat, 2013-12-14 at 18:43 -0500, supp...@pureview.com wrote:
> Could I still install with rt Oracle user in place already. If that is
> true what would be the new configuration file? What options should I
> omit...!

sbin/rt-setup-database --action init --skip-create

 - Alex

Re: [rt-users] RTv4.2.1: Uninitialized value in concatenation in Web.pm

[zbigniew00]

A little more information...   I setup a little debugging and seems to be related to "[_1] highest priority tickets I own".    [30856] [Mon Dec 16 22:01:08 2013] [notice]: DEBUG: [_1] highest priority tickets I own (/opt/rt4/sbin/../lib/RT/Interface/Web.pm:1792)[30856] [Mon Dec 16 22:01:08 2013] [warning]: Use of uninitialized value in concatenation (.) or string at /opt/rt4/sbin/../lib/RT/Interface/Web.pm line 1792. (/opt/rt4/sbin/../lib/RT/Interface/Web.pm:1792)  On 12/16/13, zbignie...@verizon.net wrote: Recently upgraded to v4.2.1 and the following error is occurring on pretty much every button click when using the interface:[warning]: Use of uninitialized value in concatenation (.) or string at /opt/rt4/sbin/../lib/RT/Interface/Web.pm line 1793. (/opt/rt4/sbin/../lib/RT/Interface/Web.pm:1792)Any suggestions on where to look?  Archive had similar issues with RT-Authen-ExternalAuth, but that seemed to be a different .pm and I also didn't have the identified config entries.-Zb

Re: [rt-users] RT sending emais www-data ; on behalf of; t...@rt-dev.com in RT 4.2.1

[Rob Lister]

On Mon, Dec 16 at 6:07:04 PM, Muhammad Amir wrote:

> when I send an email to test queue to my RT the response email
> showing up in Outlook look like this: www-data ; on 
> behalf of; t...@rt-dev.com.
>  
> I would like to get rid of “www-data ; on behalf
> of;”  so only t...@rt-dev.com shows up in Outlook.

You need to convince your MTA to allow the www-data user to set the
"Sender:" and "From:" headers to be the same thing.

In exim this is done in trusted_users = www-data

sendmail is set using -f I think, plus adding the user to a particular group?


Rob

[rt-users] RT sending emais www-data ; on behalf of; t...@rt-dev.com in RT 4.2.1

[Muhammad Amir]

Hi,
when I send an email to test queue to my RT the response email  showing up in 
Outlook look like this: www-data ; on behalf of; 
t...@rt-dev.com.
I would like to get rid of "www-data ; on behalf of;"  so 
only t...@rt-dev.com shows up in Outlook.
My RT is 4.21 running on Ubuntu 11.04 Natty. Sendmail version 8.14.4, Apache2 
version 2.2.17, Postgres 8.4.
Can someone guide where to change the RT setting to change the email response 
from RT.
Thank
Maimr

[rt-users] RTv4.2.1: Uninitialized value in concatenation in Web.pm

[zbigniew00]

Recently upgraded to v4.2.1 and the following error is occurring on pretty much every button click when using the interface:[warning]: Use of uninitialized value in concatenation (.) or string at /opt/rt4/sbin/../lib/RT/Interface/Web.pm line 1793. (/opt/rt4/sbin/../lib/RT/Interface/Web.pm:1792)Any suggestions on where to look?  Archive had similar issues with RT-Authen-ExternalAuth, but that seemed to be a different .pm and I also didn't have the identified config entries.-Zb

[rt-users] Excessive communication between RT and postgresql

[Jacobsson, Henrik G]

After upgrading to RT 4.2.1, the postgresql database is producing massive 
volumes of WAL files around the clock with peaks during office hours.

Before the upgrade - we had very limited volumes of WAL files produced, and 
nothing at all during non work hours. Now - at least 32MB, but usually 64MB of 
WAL is written every minute, when the system is supposed to be quiet.

The pattern of volume of WAL produced closely match up to the graph of network 
traffic between the RT server and the database server.

Should there be any traffic at all between the RT server and database server 
when the system is not in use? Apart from occasional handshakes etc.

Any clues on what this might be caused by?

We are running
RT 4.2.1 and Apache 2.2.15 on CentOS 6.4
Postgresql 9.3 on CentOS 5.10

Kind regards
//Henrik

--
Confidentiality Notice: This message is private and may contain confidential 
and proprietary information. If you have received this message in error, please 
notify us and remove it from your system and note that you must not copy, 
distribute or take any action in reliance on it. Any unauthorized use or 
disclosure of the contents of this message is not permitted and may be unlawful.
 

[rt-users] Scrip question

[Roman Steven]

Hi

RT 3.8.7
MySQL

I have been asked to do the following:  when updating a ticket and a
specific User is selected as the new Owner, I will Force that User to be
the new Owner.  We have several Users which I need to Force as new Owners.
Is it possible to create a Scrip to do this? Should I use the
TransactionObj or the TicketObj? I am thinking I should use the
TransactionCreate Stage.

Thanks,
Roman

[rt-users] Tickets stuck in Approvals

[koendb]

Hi I am having troubles with a few tickets.

Behaviour is that the Responses to 2 tickets always end up in the Approval
list, but at the same time, the message is recorded in the proper ticket.

Has anyone seen this behaviour? and how do I fix this ?

All other tickets behave OK.

Regards, Koen



--
View this message in context: 
http://requesttracker.8502.n7.nabble.com/Tickets-stuck-in-Approvals-tp56049.html
Sent from the Request Tracker - User mailing list archive at Nabble.com.

Re: [rt-users] apache segfaults with 4.2

[Marko Cupać]

On Fri, 13 Dec 2013 10:40:52 -0500
Kevin Falcone  wrote:

> You didn't say how you're running RT under Apache.
I run rt42-4.2.1_2 on apache22-2.2.26 with ap22-mod_perl2-2.0.8,3.
I run it on virtual ssl-enabled host under /tiketing subdirectory.
Document root serves wordpress, there are also additional
subdirectories (phpmyadmin and racktables). There is no segfault
on restart  when I comment out rt-related sections. There were no
segfaults before upgrade to 4.2.

Here's relevant apache config:


   ServerName server.example.com
   Redirect permanent / https://server.example.com/




   ServerName server.example.com
   DocumentRoot /usr/local/www/wordpress
   
   SSLEngine on
   SSLProtocol all -SSLv2
   SSLCipherSuite HIGH:MEDIUM
   SSLCertificateFile "/etc/ssl/certs/server.crt"
   SSLCertificateKeyFile "/etc/ssl/certs/server.key"

   
  Options FollowSymLinks
  AllowOverride All
  Order Allow,Deny
  Allow from all
   

   Alias /dbadmin /usr/local/www/phpMyAdmin

   
  Options none
  AllowOverride Limit
  Order Allow,Deny
  Allow from all
   

   Alias /tiketing /usr/local/share/rt42/html

   
  Options FollowSymLinks
  AllowOverride All
  Order allow,deny
  Allow from all
   

   
  AddDefaultCharset UTF-8
  SetHandler modperl
  PerlResponseHandler Plack::Handler::Apache2
  PerlSetVar psgi_app /usr/local/sbin/rt-server
   

   
  use Plack::Handler::Apache2;
  Plack::Handler::Apache2->preload("/usr/local/sbin/rt-server");
   

   Alias /racktables /usr/local/www/racktables/wwwroot

   
  Options Indexes FollowSymlinks MultiViews
  AllowOverride Limit
  Order Allow,Deny
  Allow from all
   





-- 
Marko Cupać