Re: [rt-users] Identifying sessions

2015-03-16 Thread Luca Ferrari
Ciao,

On Mon, Mar 16, 2015 at 11:59 AM, Giuseppe Sollazzo  wrote:
>
> How can I identify what's running this session? I suspect this might be 
> linked to some users running heavy searches, and what I read online in the 
> archives seems to confirm the suspicion.
>

Logging long time queries could show some hint on what is happening,
assuming that the load is really on the database.

Luca


[rt-users] RTIR 4.0.4 mail not working

2015-03-16 Thread Miller, Shane
Hello

I have been working on an existing installation that has been installed for 
some time. I have tried everything to get it working but no dice. Our domain 
just changed from one domain to another. I am not sure if this is part of the 
issue but I had an smtp relay put in place but should work regardless. I am 
able to telnet to it using port 25 but I cannot create tickets through email 
nor can I reply and comment to open tickets either. Here are the different logs 
I have done. I am hoping someone on here will be able to provide any 
information what else I should do.

# /etc/aliases
mailer-daemon: postmaster
postmaster: root
nobody: root
hostmaster: root
usenet: root
news: root
webmaster: root
www: root
ftp: root
abuse: root
noc: root
security: root
root: rtuser
Intelligence: "|/usr/bin/rt-mailgate --debug --queue Intelligence --action 
correspond --url https://rtir.domain.com/rt/ --no-verify-ssl"

Intelligence-comment: "|/usr/bin/rt-mailgate --debug --queue Intelligence 
--action comment --url https://rtir.domain.com/rt/ --no-verify-ssl"

Alerts: "|/usr/bin/rt-mailgate --debug --queue Alerts --action correspond --url 
https://rtir.domain.com/rt/ --no-verify-ssl"

Alerts-comment:  "|/usr/bin/rt-mailgate --debug --queue Alerts --action comment 
--url https://rtir.domain.com/rt/ --no-verify-ssl"

DLP: "|/usr/bin/rt-mailgate --debug --queue DLP --action correspond --url 
https://rtir.domain.com/rt/ --no-verify-ssl"

DLP-comment:  "|/usr/bin/rt-mailgate --debug --queue DLP --action comment --url 
https://rtir.domain.com/rt/ --no-verify-ssl"

Litigation Holds: "|/usr/bin/rt-mailgate --debug --queue Litigation --action 
correspond --url https://rtir.domain.com/rt/ --no-verify-ssl"

Litigation Holds-comment: "/|usr/bin/rt-mailgate --debug --queue Litigation 
--action comment --url https://rtir.domain.com/rt/ --no-verify-ssl"

Phishing: "|/usr/bin/rt-mailgate --debug --queue Phishing --action correspond 
--url https://rtir.domain.com/rt/ --no-verify-ssl"

Phishing-comment: "|/usr/bin/rt-mailgate --debug --queue Phishing --action 
comment --url https://rtir.domain.com/rt/ --no-verify-ssl"

/etc/postfix/main.cf
myhostname = rtir.domain.com
alias_maps = hash:/etc/aliases
alias_database = hash:/etc/aliases
myorigin = /etc/mailname
mydestination = rtir-...@rtir.domain.com, rtir.domain.com, 
localhost.domain.com, localhost
relayhost = smtp-up.domain.com
mynetworks = 127.0.0.0/8 [:::127.0.0.0]/104 [::1]/128
mailbox_size_limit = 0
recipient_delimiter = +
inet_interfaces = all
inet_protocols = all
local_recipient_maps = @domain.tld

/etc/requesttracker4\RT_SiteConfig.pm
Set($rtname, 'RTIR-IRU');
Set($Organization, 'domain.com');
Set($WebDomain, 'rtir.domain.com');
Set($CorrespondAddress , 'rt-...@rtir.domain.com');
Set($CommentAddress , 'rt-iru-comm...@rtir.domain.com');



# THE WEBSERVER:

Set($WebPath , "/rt");
Set($WebBaseURL , "https://rtir.domain.com";);


Thanks

Shane Miller
 

--

Notice: This e-mail is intended solely for use of the individual or entity to 
which it is addressed and may contain information that is proprietary, 
privileged and exempt from disclosure under applicable law. If the reader is 
not the intended recipient or agent responsible for delivering the message to 
the intended recipient, you are hereby notified that any dissemination, 
distribution or copying of this communication is strictly prohibited. This 
communication may also contain data subject to U.S. export laws. If so, that 
data subject to the International Traffic in Arms Regulation cannot be 
disseminated, distributed or copied to foreign nationals, residing in the U.S. 
or abroad, absent the express prior approval of the U.S. Department of State. 
If you have received this communication in error, please notify the sender by 
reply e-mail and destroy the e-mail message and any physical copies made of the 
communication. Thank you.

 


Re: [rt-users] RT 4.x multi-instances

2015-03-16 Thread Alex Vandiver
On Sat, 14 Mar 2015 13:30:54 -0400 Gaston Huot  wrote:
> Hello.
> 
> Is there something new about running 2 RT-4.x instances on the same
> installation ?
> Most comments are quite outdated, including the wiki.
> 
> Someone doing it using version 4.x ?

Just install into two directories and use one of the fastcgi solutions;
mod_perl does not support multiple instances.
 - Alex


[rt-users] Possible problem with From and BCC being the same?

2015-03-16 Thread Lewis, Valerie
All,

I have an online form that I am using to create tickets in RT for Data and/or 
Report Requests.  The way that the requests are getting to RT is in the 
Completion email message, I am BCCing the address that is forwarding to the 
queue.  Unfortunately the form maker doesn't allow a noreply address in the 
From field, so I am using the email address that is forwarding to RT queue in 
the From field as well.  There appears to be a hang-up somewhere when the From 
field and BCC field are the same.  I am working with the software distributor 
to see if it is something on their end but I am also wondering if it may be a 
problem with RT.  Has anyone had a similar problem or have any advice?  Thank,
Valerie Lewis
IT Support Analyst



[rt-users] Identifying sessions

2015-03-16 Thread Giuseppe Sollazzo
Hi list,


we've been having some issues with RT (4) becoming very slow at times. By using 
mytop, I've realised that there are often SQL sessions showing up as "slow" or 
completely froze such as:


577   rt_user   localhostrt4   234  Query SELECT 
GET_LOCK('Apache-Session-d5370769b644a8e12a7df739cf100b8a', 3600)?



This one, with process id 577, never goes away for example. Others appear and 
disappear.


How can I identify what's running this session? I suspect this might be linked 
to some users running heavy searches, and what I read online in the archives 
seems to confirm the suspicion.


Any idea would be welcome.


Thanks,

Giuseppe



--
Giuseppe Sollazzo
Senior System Analyst

Member of the Open Data User Group (Cabinet Office)
Member of the Technical Standards Board (Cabinet Office)?
Member of the Health and Social Care Transparency Panel (Department of Health)


Computing Services
Information Services
St George's, University of London
Cranmer Terrace
London SW17 0RE

gsoll...@sgul.ac.uk
+44 20 8725 5160
@sgulit

St George's, University of London is proud to be a Stonewall Diversity 
Champion: 'people perform better when they can be themselves'.


[http://www.sgul.ac.uk/images/misc/diversity_logo_with_text.jpg]


Re: [rt-users] RT 4.x multi-instances

2015-03-16 Thread Markus . Wildbolz
Hello!

We are running two instances of RT (4.2.9 with MySQL) as two completely 
separated installs (the installation is done in two different 
directories).
Access is separated through Apache Alias configuration.

We haven't had problems in the past, all is working fine...


BR,
Markus