Re: [rt-users] rt startup

2010-12-09 Thread Evgeny OpenMsk
Спасибо Антон.
Проблема решилась правильным конфигом Апача (письмом выше).
сейчас страничка работает, и всё отображается.

Следующий шаг хотелось бы настроить доменную аутентификацию.
Сейчас RT_SiteConfig.pm выглядит так: http://pastebin.com/X3i3BGwu
посмотрите пжлста и комментирование строки. Когда снимаю комментарий с них
(нижняя часть касаема аутентификации) - апач ругается и не запускается

2010/12/9 Смирнов Антон rt.li...@gmail.com

 Видимо, для начала, стоит прописать в конфиге этот параметр RTAddressRegexp.
 Хотя как это может отражать на страничках я не понимаю

 8 декабря 2010 г. 10:58 пользователь Evgeny OpenMsk 
 open...@gmail.comнаписал:

 Здравствуйте товарищи.
 Подскажите пжлста, начал осваивать продукт request-tracker
 настроил по мануалу.

 сейчас в логи валиться такой текст:
 [Wed Dec 08 10:54:31 2010] [notice] caught SIGTERM, shutting down
 [Wed Dec  8 07:54:46 2010] [error]: The RTAddressRegexp option is not set
 in the config. Not setting this option results in additional SQL queries to
 check whether each address belongs to RT or not. It is especially important
 to set this option if RT recieves emails on addresses that are not in the
 database or config. (/opt/rt3/bin/../lib/RT/Config.pm:343)
 [Wed Dec 08 10:55:00 2010] [notice] SELinux policy enabled; httpd running
 as context user_u:system_r:httpd_t
 [Wed Dec  8 07:55:04 2010] [error]: The RTAddressRegexp option is not set
 in the config. Not setting this option results in additional SQL queries to
 check whether each address belongs to RT or not. It is especially important
 to set this option if RT recieves emails on addresses that are not in the
 database or config. (/opt/rt3/bin/../lib/RT/Config.pm:343)
 [Wed Dec 08 10:55:18 2010] [notice] Digest: generating secret for digest
 authentication ...
 [Wed Dec 08 10:55:18 2010] [notice] Digest: done
 [Wed Dec 08 10:55:18 2010] [notice] Apache/2.2.6 (Unix) DAV/2 PHP/5.1.6
 mod_perl/2.0.2 Perl/v5.8.8 configured -- resuming normal operations


 и страничка загружается с ошибками и без графики.
 пытался пересоздавать базу make dropdb/ make initialize-database - не
 помогло

 подскажите куда дальше копать?

 Evgeny OpenMsk.





[rt-users] RTFM puzzling readme

2010-12-09 Thread Giuseppe Sollazzo

Hi all,
this will sound trivial but...

RTFM's readme (v 2.4.2) contains the following sentence: Install RT 
3.4.2 or newer (Do not use this with 3.8.0 as there are incompatibilities)


Being strictly literal, should I interpret it as 3.8.x is fine except 
when x=0?


However, the wiki says: It includes a number of bugfixes and an 
important compatibility fix which you need to use RTFM with RT 3.8.3 or 
greater.


Typo?

Thanks,
Giuseppe

--


Giuseppe Sollazzo
Senior Systems Analyst
Computing Services
Information Services
St. George's, University Of London
Cranmer Terrace
London SW17 0RE

Email: gsoll...@sgul.ac.uk
Direct Dial: +44 20 8725 5160
Fax: +44 20 8725 3583




[rt-users] Can't send out email after moving RT

2010-12-09 Thread Kevin Bailey




Hi,


Hopefully a quick pointer is what I need.


We've been running RT 3.6.1 for years no probs.


We've now set up a new (replacement server) and installed RT 3.6.7.


The database under the 3.6.1 install was copied over and put on to the
3.6.7 server - the the RT instance was connected to this DB.


All seems to be working OK on the web interface. Only issue is that
emails are not being sent.


I.e. when I create a test ticket I set up my gmail email address as the
requestor. When I type up a reply via the web interface it says it's
going to send a reply to the requestor email address.


But according to the email server logs it doesn't even try to send
anything - and the ticket has no entry for the email being sent.


As the DB has been copied then all settings etc are the same as before
- and the RT_SiteConfig.pm file looks sane.


Is there something I need to set up RE the mail server (Postfix).


Any pointers gratefully received.


Regards,


Kevin Bailey

-- 
Kevin Bailey

Director/Programmer - Freeway Projects Limited

Web: www.freewayprojects.com

Email: kbai...@freewayprojects.com

Phone: +44 (0)1752 267090








[rt-users] Google crawlers.

2010-12-09 Thread Mark Jenks
I posted some links here when I was having problems with RT3.   Now
google is showing up with those links and is now trying to crawl my
site.

 

I tried to drop robots.txt into the html folder, but it goes to the
logon screen instead of showing me the robots.txt file.

 

What do I need to do? Could we remove my original post from
gossamer?  Or how do I get the robots.txt file to work?

 

I know they can only get to the front screen of RT without logging in,
but I don't want it to show up in google search at all.

 

Thanks!

 

-Mark

 

 

Mark Jenks

Network Administrator

 

1030 Ontario Road  Green Bay, WI 54311  p: 920.406.3702

 

mark.je...@iodincorporated.com

 


Electronic Privacy Notice. This e-mail, and any attachments, contains 
information that is, or may be, covered by electronic communications privacy
laws, and is also confidential and proprietary in nature. If you are not the 
intended recipient, please be advised that you are legally prohibited from
retaining, using, copying, distributing, or otherwise disclosing this 
information in any manner. Instead, please reply to the sender that you have
received this communication in error, and then immediately delete it. Thank you 
in advance for your cooperation
image001.jpg

Re: [rt-users] Google crawlers.

2010-12-09 Thread Jason Ledford
http://www.google.com/support/webmasters/bin/answer.py?hl=enanswer=164734
If you own the site, you can verify your ownership in Webmaster Tools and use 
the verified URL removal tool to remove an entire directory from Google's 
search results.
Before using the URL Removal Tool, you must use robots.txt to block crawler 
access to the 
directoryhttp://www.google.com/support/webmasters/bin/answer.py?answer=156449 
(or, if you're removing a site, to your whole site). (For more information 
about blocking search engines from confidential information, see Blocking 
Googlehttp://www.google.com/support/webmasters/bin/answer.py?answer=93708.) 
Returning a 404 HTTP status code isn't enough, because it's possible for a 
directory to return a 404 status code, but still serve out files underneath it. 
Using robots.txt to block a directory ensures that all of its children are 
disallowed as well.
Once you have completed one of the steps above, you can request removal of the 
directory and all of its contents from search results using the URL Removal 
Tool in Webmaster Tools.

 1.  On the Webmaster Tools home page, click the site you want.
 2.  On the Dashboard, click Site configuration in the left-hand navigation.
 3.  Click Crawler access, and then click Remove URL.
 4.  Click New removal request.
 5.  Type the URL of the directory you want removed from search results and 
then click Continue. How to find the right 
URL.http://www.google.com/support/webmasters/bin/answer.py?answer=63758 Note 
that the URL is case-sensitive-you will need to submit the URL using exactly 
the same characters and the same capitalization that the site uses. If you want 
to remove the whole site, you can leave this blank.
 6.  Click Remove directory
 7.  Select the checkbox to confirm that you have completed the requirements 
listed in this article, and then click Submit Request.
Be careful when requesting removal of a site. The only reason you should 
request a site removal is when you want all the contents of a site permanently 
removed from Google's index.
Removing https://www.example.com will also remove http://www.example.com, as 
well as http://example.com and https://example.com.
If you're worried that your site may have a penalty, or you want to start from 
scratch after purchasing a domain from somebody else, we recommend filing a 
reconsideration 
requesthttp://www.google.com/support/webmasters/bin/answer.py?answer=35843 
letting us know what you're worried about and what has changed. If your site 
has been hacked, check this article for 
recommendations.http://www.google.com/support/webmasters/bin/answer.py?hl=enanswer=163633



From: rt-users-boun...@lists.bestpractical.com 
[mailto:rt-users-boun...@lists.bestpractical.com] On Behalf Of Mark Jenks
Sent: Thursday, December 09, 2010 7:37 AM
To: rt-users
Subject: [rt-users] Google crawlers.

I posted some links here when I was having problems with RT3.   Now google is 
showing up with those links and is now trying to crawl my site.

I tried to drop robots.txt into the html folder, but it goes to the logon 
screen instead of showing me the robots.txt file.

What do I need to do? Could we remove my original post from gossamer?  Or 
how do I get the robots.txt file to work?

I know they can only get to the front screen of RT without logging in, but I 
don't want it to show up in google search at all.

Thanks!

-Mark


Mark Jenks
Network Administrator
[cid:image001.jpg@01CB9778.684875C0]
1030 Ontario Road  Green Bay, WI 54311  p: 920.406.3702

mark.je...@iodincorporated.commailto:mark.je...@iodincorporated.com


Electronic Privacy Notice. This e-mail, and any attachments, contains 
information that is, or may be, covered by electronic communications privacy 
laws, and is also confidential and proprietary in nature. If you are not the 
intended recipient, please be advised that you are legally prohibited from 
retaining, using, copying, distributing, or otherwise disclosing this 
information in any manner. Instead, please reply to the sender that you have 
received this communication in error, and then immediately delete it. Thank you 
in advance for your cooperation   
inline: image001.jpg

Re: [rt-users] Google crawlers.

2010-12-09 Thread Mark Jenks
I guess I'm going for the DNS blocking method, since I don't see where
to put in a robots.txt file into RT.   I'll have to do some custom
conf.d stuff when I get back into the office next week.

 

-Mark

 

From: Jason Ledford [mailto:jledf...@biltmore.com] 
Sent: Thursday, December 09, 2010 7:10 AM
To: Mark Jenks
Cc: RT-Users@lists.bestpractical.com
Subject: RE: Google crawlers.

 

http://www.google.com/support/webmasters/bin/answer.py?hl=enanswer=1647
34

If you own the site, you can verify your ownership in Webmaster Tools
and use the verified URL removal tool to remove an entire directory from
Google's search results.

Before using the URL Removal Tool, you must use robots.txt to block
crawler access to the directory
http://www.google.com/support/webmasters/bin/answer.py?answer=156449
(or, if you're removing a site, to your whole site). (For more
information about blocking search engines from confidential information,
see Blocking Google
http://www.google.com/support/webmasters/bin/answer.py?answer=93708 .)
Returning a 404 HTTP status code isn't enough, because it's possible for
a directory to return a 404 status code, but still serve out files
underneath it. Using robots.txt to block a directory ensures that all of
its children are disallowed as well.

Once you have completed one of the steps above, you can request removal
of the directory and all of its contents from search results using the
URL Removal Tool in Webmaster Tools.

1.  On the Webmaster Tools home page, click the site you want.
2.  On the Dashboard, click Site configuration in the left-hand
navigation.
3.  Click Crawler access, and then click Remove URL.
4.  Click New removal request.
5.  Type the URL of the directory you want removed from search
results and then click Continue. How to find the right URL.
http://www.google.com/support/webmasters/bin/answer.py?answer=63758
Note that the URL is case-sensitive-you will need to submit the URL
using exactly the same characters and the same capitalization that the
site uses. If you want to remove the whole site, you can leave this
blank.
6.  Click Remove directory
7.  Select the checkbox to confirm that you have completed the
requirements listed in this article, and then click Submit Request.

Be careful when requesting removal of a site. The only reason you should
request a site removal is when you want all the contents of a site
permanently removed from Google's index. 

Removing https://www.example.com will also remove
http://www.example.com, as well as http://example.com and
https://example.com.

If you're worried that your site may have a penalty, or you want to
start from scratch after purchasing a domain from somebody else, we
recommend filing a reconsideration request
http://www.google.com/support/webmasters/bin/answer.py?answer=35843
letting us know what you're worried about and what has changed. If your
site has been hacked, check this article for recommendations.
http://www.google.com/support/webmasters/bin/answer.py?hl=enanswer=163
633 

 

 

 

From: rt-users-boun...@lists.bestpractical.com
[mailto:rt-users-boun...@lists.bestpractical.com] On Behalf Of Mark
Jenks
Sent: Thursday, December 09, 2010 7:37 AM
To: rt-users
Subject: [rt-users] Google crawlers.

 

I posted some links here when I was having problems with RT3.   Now
google is showing up with those links and is now trying to crawl my
site.

 

I tried to drop robots.txt into the html folder, but it goes to the
logon screen instead of showing me the robots.txt file.

 

What do I need to do? Could we remove my original post from
gossamer?  Or how do I get the robots.txt file to work?

 

I know they can only get to the front screen of RT without logging in,
but I don't want it to show up in google search at all.

 

Thanks!

 

-Mark

 

 

Mark Jenks

Network Administrator

 

1030 Ontario Road  Green Bay, WI 54311  p: 920.406.3702

 

mark.je...@iodincorporated.com

 


Electronic Privacy Notice. This e-mail, and any attachments, contains
information that is, or may be, covered by electronic communications
privacy laws, and is also confidential and proprietary in nature. If you
are not the intended recipient, please be advised that you are legally
prohibited from retaining, using, copying, distributing, or otherwise
disclosing this information in any manner. Instead, please reply to the
sender that you have received this communication in error, and then
immediately delete it. Thank you in advance for your cooperation   --  


Electronic Privacy Notice. This e-mail, and any attachments, contains 
information that is, or may be, covered by electronic communications privacy
laws, and is also confidential and proprietary in nature. If you are not the 
intended recipient, please be advised that you are legally prohibited from
retaining, using, copying, distributing, or otherwise disclosing this 
information in any manner. Instead, please reply to the sender that you have
received this 

Re: [rt-users] RTFM puzzling readme

2010-12-09 Thread Kevin Falcone
On Thu, Dec 09, 2010 at 11:38:49AM +, Giuseppe Sollazzo wrote:
 RTFM's readme (v 2.4.2) contains the following sentence: Install RT
 3.4.2 or newer (Do not use this with 3.8.0 as there are
 incompatibilities)
 
 Being strictly literal, should I interpret it as 3.8.x is fine
 except when x=0?

I was quite literal when I wrote it.
3.8.0 will not work with RTFM, other 3.8.x will be fine (see caveat
below)

 However, the wiki says: It includes a number of bugfixes and an
 important compatibility fix which you need to use RTFM with RT 3.8.3
 or greater.

I didn't edit the wiki, only the README.  When quoting the wiki, if
you provide a link it is a lot easier for fix mistakes.

If you are running RT 3.8.8, you should really try RTFM2.4.3rc1 since
it fixes one or two incompatibilities you may run into.

-kevin


pgpn2Xg4yUvAx.pgp
Description: PGP signature


Re: [rt-users] Can't send out email after moving RT

2010-12-09 Thread Kevin Falcone
On Thu, Dec 09, 2010 at 12:40:18PM +, Kevin Bailey wrote:
 Hi,
 
 Hopefully a quick pointer is what I need.
 
 We've been running RT 3.6.1 for years no probs.
 
 We've now set up a new (replacement server) and installed RT 3.6.7.
 
 The database under the 3.6.1 install was copied over and put on to
 the 3.6.7 server - the the RT instance was connected to this DB.
 
 All seems to be working OK on the web interface.  Only issue is that
 emails are not being sent.
 
 I.e. when I create a test ticket I set up my gmail email address as
 the requestor.  When I type up a reply via the web interface it says
 it's going to send a reply to the requestor email address.
 
 But according to the email server logs it doesn't even try to send
 anything - and the ticket has no entry for the email being sent.

You don't say what the RT logs say

 As the DB has been copied then all settings etc are the same as
 before - and the RT_SiteConfig.pm file looks sane.
 
 Is there something I need to set up RE the mail server (Postfix).
 
 Any pointers gratefully received.


pgptrCoAGKlCB.pgp
Description: PGP signature


Re: [rt-users] Comment/reply not being recorded

2010-12-09 Thread Kevin Falcone
On Wed, Dec 08, 2010 at 04:20:01PM -0500, Darin Perusich wrote:
 Hello All,
 
 I'm seeing some strange behavior with one of the my tickets in RT. When
 I add a comment or reply the message doesn't show up in the history yet
 email is sent out. The last message in the history is an error, see
 below, but nothing shows up after it. It doesn't matter if I
 comment/reply w/ my user account of the root account. Fortunately I'm
 just starting to use the system but I'm concerned this isn't the only
 ticket like this. Anything new doesn't appear to be having this problem.

If you search the list archives, you'll find recommendations for
either downgrading or upgrading your FCGI module due to some
overzealous utf8 handling

-kevin

 Any thoughts?
 
 RT 3.8.8
 
 Mon Dec 06 15:32:24 2010 Darin Perusich - Status changed from 'new' to
 'open'
 Wide character in FCGI::Stream::PRINT at
 /usr/lib/perl5/vendor_perl/5.12.1/HTML/Mason/CGIHandler.pm line 105.
 
 Thanks!
 --
 Darin Perusich
 Email: darin.perus...@ctg.com
 Office: 716-888-3690
 Cell: 716-807-4589
 
 
 The information transmitted is intended only for the person or entity to which
 it is addressed and may contain confidential and/or privileged material. Any
 review, retransmission, dissemination or other use of, or taking of any action
 in reliance upon, this information by persons or entities other than the
 intended recipient is prohibited. If you are not the intended recipient of 
 this 
 message, please contact the sender and delete this material from this 
 computer.
 


pgpTjgG7lJRgy.pgp
Description: PGP signature


Re: [rt-users] Google crawlers.

2010-12-09 Thread Stefan Hornburg (Racke)

On 12/09/2010 02:34 PM, Mark Jenks wrote:

I guess I'm going for the DNS blocking method, since I don't see where
to put in a robots.txt file into RT.   I'll have to do some custom
conf.d stuff when I get back into the office next week.



You can specify robots.txt in your Apache configuration, before
the statements you use for RT:

Alias /robots.txt /path/to/your/robots.txt

Regards
Racke


--
LinuXia Systems = http://www.linuxia.de/
Expert Interchange Consulting and System Administration
ICDEVGROUP = http://www.icdevgroup.org/
Interchange Development Team



Re: [rt-users] RTFM puzzling readme

2010-12-09 Thread Giuseppe Sollazzo

On 09/12/10 13:50, Kevin Falcone wrote:

RT 3.8.8, you should really try RTFM2.4.3rc1 since
it fixes one or two incompatibilities you may run into.
   

Hi Kevin,
sorry - I meant the blog, not the wiki. It's here: 
http://blog.bestpractical.com/2009/06/rtfm-242-now-available.html


As far as we're concerned, we use 3.8.7 - does the same suggestion apply?

Thanks,
Giuseppe



--


Giuseppe Sollazzo
Senior Systems Analyst
Computing Services
Information Services
St. George's, University Of London
Cranmer Terrace
London SW17 0RE

Email: gsoll...@sgul.ac.uk
Direct Dial: +44 20 8725 5160
Fax: +44 20 8725 3583




Re: [rt-users] callback for Search/Simple.html not working on freebsd

2010-12-09 Thread Kevin Falcone
On Tue, Dec 07, 2010 at 05:47:06PM +0300, alexander lunev wrote:
 FreeBSD port installs RT files under /usr/local/share:
 
 # ls /usr/local/share/rt38
 etc fonts   htmllib local   plugins po
 
 I created file with callback:
 
 /usr/local/share/rt38/local/html/Callbacks/MyCallbacks/Search/Simple.html/ModifyQuery:

You should really confirm from Configuration - Tools - System
Configuration that you have the correct MasonLocalComponentRoot

New enough RTs will also include a mason template search order listing

Also, you don't seem to have answered the question posed earlier about
whether or not you cleared your mason cache after writing this
callback.

You also don't have any logging in your callback which means you can't
tell whether or not it worked without examining the results.

-kevin

 %init
  $$query = $$query .  new open resolved stalled rejected deleted;
  /%init
 
  %args
  $query = undef
  /%args


pgpA4lGTjgHW5.pgp
Description: PGP signature


Re: [rt-users] RTFM puzzling readme

2010-12-09 Thread Kevin Falcone
On Thu, Dec 09, 2010 at 02:01:24PM +, Giuseppe Sollazzo wrote:
 On 09/12/10 13:50, Kevin Falcone wrote:
 RT 3.8.8, you should really try RTFM2.4.3rc1 since
 it fixes one or two incompatibilities you may run into.
 Hi Kevin,
 sorry - I meant the blog, not the wiki. It's here:
 http://blog.bestpractical.com/2009/06/rtfm-242-now-available.html

Read this as If you use RT 3.8.3 or higher, you need at least this
version of RTFM.  The Changelog later in the blog post covers the
reasons.

 As far as we're concerned, we use 3.8.7 - does the same suggestion apply?

Not unless you care about the other bugfixes included in the release
(Changelog is findable in the rt-devel mailing list archives)

-kevin


pgp4GKS69Wki0.pgp
Description: PGP signature


Re: [rt-users] How to setup holidays in RT::Extension:SLA - ServiceBusinessHours?

2010-12-09 Thread Ruslan Zakirov
Hello,

Your config looks good. Please, turn on debug loggin in the RT config,
stop/start server and try again, then collect errors from logs.
Without logs it's hard to guess what went wrong.

Holidays are supported in late versions of Business::Hours module, may
be version of the module you're using is old.

On Thu, Dec 9, 2010 at 6:28 AM, Rithy R rithy4u...@hotmail.com wrote:
 I beg for your help...

 Regards,
 Rithy




 
 From: rithy4u...@hotmail.com
 To: rt-users@lists.bestpractical.com
 Date: Tue, 7 Dec 2010 05:12:15 +
 Subject: Re: [rt-users] RT 3.8.7 + SLA 0.03 + RTFM 2.4.2 - How to setup
 holidays in ServiceBusinessHours?

 Please kindly help out...

 Regards,
 Rithy




 
 From: rithy4u...@hotmail.com
 To: rt-users@lists.bestpractical.com
 Date: Mon, 6 Dec 2010 06:37:44 +
 Subject: [rt-users] RT 3.8.7 + SLA 0.03 + RTFM 2.4.2 - How to setup holidays
 in ServiceBusinessHours?

 Dear RT Community:
 My SLA 3 and 4 never set the correct due date unless I mark #BusinessHours
 = 'work', in below configuration. After I did that, my SLA 3 and 4 work
 again without issue. They even calculate the due date based on my 'work'
 setting (0-6). But the problem now is, my holidays setting never apply to
 ticket. Can someone help to guide me thru on how to setup holidays in
 RT_SiteConfig.pm? Your advice will be much appreciated.
 +
 #Set Business Hours
 Set( %ServiceBusinessHours,
 'work' = {
 0 = {Name = 'Sunday',Start = 'undef', End = 'undef' },
 1 = {Name = 'Monday',Start = '07:30', End = '17:30' },
 2 = {Name = 'Tuesday',Start = '7:30', End = '17:30' },
 3 = {Name = 'Wednesday',Start = '7:30', End = '17:30' },
 4 = {Name = 'Thursday',Start = '7:30', End = '17:30' },
 5 = {Name = 'Friday',Start = '7:30', End = '17:30' },
 6 = {Name = 'Saturday',Start = 'undef', End = 'undef' },
 holidays = [qw(2011-01-01 2011-01-02 2011-01-03 2011-01-07 2011-02-18
 2011-03-8 2011-04-14 2011-04-15 2011-04-16 2011-04-17 2011-04-18 2011-05-01
 2011-05-02 2011-05-13 2011-05-14 2011-05-15 2011-05-16 2011-05-17 2011-05-21
 2011-05-22 2011-05-23 2011-06-1 2011-06-18 2011-06-18 2011-06-19 2011-06-20
 2011-09-24 2011-09-25 2011-09-26 2011-09-27 2011-09-28 2011-10-29 2011-10-30
 2011-10-31 2011-11-09 2011-11-10 2011-11-11 2011-12-10 2011-12-11
 2011-12-12)],
 },
 );
 #RT::Extension::SLA Config
 Set( %ServiceAgreements,
         Default = 'sev4',
         QueueDefault = {
             'General' = 'sev4',
         },
         Levels = {
             'sev1' = {
 StartImmediately = 1,
 Response = { RealMinutes = 60*0.5 },
 Resolve = { RealMinutes = 60*4 } },
             'sev2' = {
 StartImmediately = 1,
 Response = { RealMinutes = 60*0.5 },
 Resolve = { RealMinutes = 60*12 } },
    'sev3' = {
 #BusinessHours = 'work',
 OutOfHours = { Resolve = { RealMinutes = +60*28 } },
 Response = { BusinessMinutes = 60*4 },
 Resolve = { BusinessMinutes = 60*28 } },
    'sev4' = {
 #BusinessHours = 'work',
 OutOfHours = { Resolve = { RealMinutes = +60*52 } },
 Response = { BusinessMinutes = 60*8 },
 Resolve = { BusinessMinutes = 60*52 } },
         },
     );
 +
 Regards,
 Rithy






-- 
Best regards, Ruslan.


Re: [rt-users] Google crawlers.

2010-12-09 Thread Tracy Phillips
On Thu, Dec 9, 2010 at 5:59 AM, Stefan Hornburg (Racke) ra...@linuxia.dewrote:

 On 12/09/2010 02:34 PM, Mark Jenks wrote:

 I guess I'm going for the DNS blocking method, since I don't see where
 to put in a robots.txt file into RT.   I'll have to do some custom
 conf.d stuff when I get back into the office next week.


 You can specify robots.txt in your Apache configuration, before
 the statements you use for RT:

 Alias /robots.txt /path/to/your/robots.txt

 Regards
Racke


If that doesn't work for whatever reason, you can also throw this in your
VirtualHost

  Location /robots.txt
SetHandler None
  /Location

This is where I put my robots.txt

/opt/rt3/share/html/robots.txt


Re: [rt-users] Can't send out email after moving RT

2010-12-09 Thread Kevin Bailey




I've been asked about the output from the logs.

Currently there is no log file at all - so I'll have a look at setting
the debug level for the logs.

Cheers,

bailey86

On 09/12/10 12:40, Kevin Bailey wrote:

  
Hi,
  
  
Hopefully a quick pointer is what I need.
  
  
We've been running RT 3.6.1 for years no probs.
  
  
We've now set up a new (replacement server) and installed RT 3.6.7.
  
  
The database under the 3.6.1 install was copied over and put on to the
3.6.7 server - the the RT instance was connected to this DB.
  
  
All seems to be working OK on the web interface. Only issue is that
emails are not being sent.
  
  
I.e. when I create a test ticket I set up my gmail email address as the
requestor. When I type up a reply via the web interface it says it's
going to send a reply to the requestor email address.
  
  
But according to the email server logs it doesn't even try to send
anything - and the ticket has no entry for the email being sent.
  
  
As the DB has been copied then all settings etc are the same as before
- and the RT_SiteConfig.pm file looks sane.
  
  
Is there something I need to set up RE the mail server (Postfix).
  
  
Any pointers gratefully received.
  
  
Regards,
  
  
Kevin Bailey
  
  -- 
  Kevin Bailey
  
Director/Programmer - Freeway Projects Limited
  
Web: www.freewayprojects.com
  
Email: kbai...@freewayprojects.com
  
Phone: +44 (0)1752 267090
  
  
  
  


-- 
Kevin Bailey

Director/Programmer - Freeway Projects Limited

Web: www.freewayprojects.com

Email: kbai...@freewayprojects.com

Phone: +44 (0)1752 267090








Re: [rt-users] Can't send out email after moving RT

2010-12-09 Thread Kevin Bailey




I'll look at upping the debug level. Not sure how - but I'll get the
book out and look through the config file.

Thanks,

Kevin

On 09/12/10 13:57, Kevin Falcone wrote:

  On Thu, Dec 09, 2010 at 12:40:18PM +, Kevin Bailey wrote:
  
  
Hi,

Hopefully a quick pointer is what I need.

We've been running RT 3.6.1 for years no probs.

We've now set up a new (replacement server) and installed RT 3.6.7.

The database under the 3.6.1 install was copied over and put on to
the 3.6.7 server - the the RT instance was connected to this DB.

All seems to be working OK on the web interface.  Only issue is that
emails are not being sent.

I.e. when I create a test ticket I set up my gmail email address as
the requestor.  When I type up a reply via the web interface it says
it's going to send a reply to the requestor email address.

But according to the email server logs it doesn't even try to send
anything - and the ticket has no entry for the email being sent.

  
  
You don't say what the RT logs say

  
  
As the DB has been copied then all settings etc are the same as
before - and the RT_SiteConfig.pm file looks sane.

Is there something I need to set up RE the mail server (Postfix).

Any pointers gratefully received.

  


-- 
Kevin Bailey

Director/Programmer - Freeway Projects Limited

Web: www.freewayprojects.com

Email: kbai...@freewayprojects.com

Phone: +44 (0)1752 267090








Re: [rt-users] Can't send out email after moving RT

2010-12-09 Thread Kevin Bailey




Here's the log messages I found in syslog - I'm just looking through
them now:

Dec 9 16:34:22 cyclone2 RT: Guessed encoding: utf8#012
Dec 9 16:34:22 cyclone2 RT: Guessed encoding: ascii#012
Dec 9 16:34:22 cyclone2 RT: Guessed encoding: utf8#012
Dec 9 16:34:22 cyclone2 RT: Guessed encoding: ascii#012
Dec 9 16:34:22 cyclone2 RT: About to think about scrips for
transaction #21542#012
Dec 9 16:34:22 cyclone2 RT: About to prepare scrips for transaction
#21542#012
Dec 9 16:34:22 cyclone2 RT: Found 5 scrips#012
Dec 9 16:34:23 cyclone2 RT: About to commit scrips for transaction
#21542#012
Dec 9 16:34:23 cyclone2 RT:
rt-3.6.7-17319-1291912462-219.1147-...@cyclone2.freewayprojects.com
#1147/21542 - Scrip 5
(/usr/share/request-tracker3.6/lib/RT/Action/SendEmail.pm:266)#012
Dec 9 16:34:23 cyclone2 RT:
rt-3.6.7-17319-1291912462-219.1147-...@cyclone2.freewayprojects.com
No recipients found. Not sending.
(/usr/share/request-tracker3.6/lib/RT/Action/SendEmail.pm:278)#012
Dec 9 16:34:23 cyclone2 RT:
rt-3.6.7-17319-1291912462-219.1147-...@cyclone2.freewayprojects.com
#1147/21542 - Scrip 6
(/usr/share/request-tracker3.6/lib/RT/Action/SendEmail.pm:266)#012
Dec 9 16:34:23 cyclone2 RT:
rt-3.6.7-17319-1291912462-219.1147-...@cyclone2.freewayprojects.comCould
not send mail: Insecure $ENV{PATH} while running with -T switch at
/usr/share/request-tracker3.6/lib/RT/Action/SendEmail.pm line
333.#012#012Stack:#012
[/usr/share/request-tracker3.6/lib/RT/Action/SendEmail.pm:333]#012
[/usr/share/request-tracker3.6/lib/RT/Action/SendEmail.pm:288]#012
[/usr/share/request-tracker3.6/lib/RT/Action/SendEmail.pm:107]#012
[/usr/share/request-tracker3.6/lib/RT/ScripAction_Overlay.pm:242]#012
[/usr/share/request-tracker3.6/lib/RT/Scrip_Overlay.pm:507]#012
[/usr/share/request-tracker3.6/lib/RT/Scrips_Overlay.pm:195]#012
[/usr/share/request-tracker3.6/lib/RT/Transaction_Overlay.pm:181]#012
[/usr/share/request-tracker3.6/lib/RT/Record.pm:1466]#012
[/usr/share/request-tracker3.6/lib/RT/Ticket_Overlay.pm:2435]#012
[/usr/share/request-tracker3.6/lib/RT/Ticket_Overlay.pm:2348]#012
[/usr/share/request-tracker3.6/lib/RT/Interface/Web.pm:597]#012
[/usr/share/request-tracker3.6/html/Ticket/Display.html:144]#012
[/usr/share/request-tracker3.6/html/Ticket/Update.html:218]#012
[/usr/share/request-tracker3.6/html/autohandler:291]
(/usr/share/request-tracker3.6/lib/RT/Action/SendEmail.pm:349)#012
Dec 9 16:34:23 cyclone2 RT:
rt-3.6.7-17319-1291912462-219.1147-...@cyclone2.freewayprojects.com
#1147/21542 - Scrip 7
(/usr/share/request-tracker3.6/lib/RT/Action/SendEmail.pm:266)#012
Dec 9 16:34:23 cyclone2 RT:
rt-3.6.7-17319-1291912462-219.1147-...@cyclone2.freewayprojects.com
No recipients found. Not sending.
(/usr/share/request-tracker3.6/lib/RT/Action/SendEmail.pm:278)#012
Dec 9 16:34:23 cyclone2 RT: Use of uninitialized value in pattern
match (m//) at /usr/share/request-tracker3.6/lib/RT/Interface/Web.pm
line 1423.
(/usr/share/request-tracker3.6/lib/RT/Interface/Web.pm:1423)#012
Dec 9 16:34:23 cyclone2 RT: Use of uninitialized value in pattern
match (m//) at /usr/share/request-tracker3.6/lib/RT/Interface/Web.pm
line 1423.
(/usr/share/request-tracker3.6/lib/RT/Interface/Web.pm:1423)#012


On 09/12/10 16:32, Kevin Bailey wrote:

  
I'll look at upping the debug level. Not sure how - but I'll get the
book out and look through the config file.
  
Thanks,
  
Kevin
  
On 09/12/10 13:57, Kevin Falcone wrote:
  
On Thu, Dec 09, 2010 at 12:40:18PM +, Kevin Bailey wrote:
  

  Hi,

Hopefully a quick pointer is what I need.

We've been running RT 3.6.1 for years no probs.

We've now set up a new (replacement server) and installed RT 3.6.7.

The database under the 3.6.1 install was copied over and put on to
the 3.6.7 server - the the RT instance was connected to this DB.

All seems to be working OK on the web interface.  Only issue is that
emails are not being sent.

I.e. when I create a test ticket I set up my gmail email address as
the requestor.  When I type up a reply via the web interface it says
it's going to send a reply to the requestor email address.

But according to the email server logs it doesn't even try to send
anything - and the ticket has no entry for the email being sent.


You don't say what the RT logs say

  

  As the DB has been copied then all settings etc are the same as
before - and the RT_SiteConfig.pm file looks sane.

Is there something I need to set up RE the mail server (Postfix).

Any pointers gratefully received.


  
  
  -- 
  Kevin Bailey
  
Director/Programmer - Freeway Projects Limited
  
Web: www.freewayprojects.com
  
Email: kbai...@freewayprojects.com
  
Phone: +44 (0)1752 267090
  
  
  
  


-- 
Kevin Bailey

Director/Programmer - Freeway Projects Limited

Web: www.freewayprojects.com

Email: kbai...@freewayprojects.com

Phone: +44 (0)1752 267090








Re: [rt-users] Can't send out email after moving RT

2010-12-09 Thread Kevin Falcone
On Thu, Dec 09, 2010 at 04:35:45PM +, Kevin Bailey wrote:
 Here's the log messages I found in syslog - I'm just looking through
 them now:
 
 (/usr/share/request-tracker3.6/lib/RT/Action/SendEmail.pm:266)#012
 Dec  9 16:34:23 cyclone2 RT: 
 rt-3.6.7-17319-1291912462-219.1147-...@cyclone2.freewayprojects.comCould
 not send mail: Insecure $ENV{PATH} while running with -T switch at
 /usr/share/request-tracker3.6/lib/RT/Action/SendEmail.pm line
 333.#012#012Stack:#012

You appear to be running RT in taint mode.  Why?

-kevin


pgpMGJmfAqcms.pgp
Description: PGP signature


Re: [rt-users] Can't send out email after moving RT

2010-12-09 Thread Kevin Bailey




Not sure - it was installed by one of our guys. I don't even know what
taint mode is.

Currently the Apache2 web server won't start up due to RT. I'm getting


[Thu Dec 09 16:53:06 2010] [error] Insecure dependency in chdir
while running with -T switch at /usr/share/perl/5.10/File/Path.pm line
222.\nCompilation failed in require at (eval 2) line 1.\n
[Thu Dec 09 16:53:06 2010] [error] Can't load Perl file:
/usr/share/request-tracker3.6/libexec/webmux.pl for server
cyclone2.freewayprojects.com:80, exiting


I've got a feeling that I'm going to have to start again from scratch.
I'll ask for pointers RE migration on the list.

Thanks,

Kevin Bailey

On 09/12/10 16:38, Kevin Falcone wrote:

  On Thu, Dec 09, 2010 at 04:35:45PM +, Kevin Bailey wrote:
  
  
Here's the log messages I found in syslog - I'm just looking through
them now:

(/usr/share/request-tracker3.6/lib/RT/Action/SendEmail.pm:266)#012
Dec  9 16:34:23 cyclone2 RT: rt-3.6.7-17319-1291912462-219.1147-...@cyclone2.freewayprojects.comCould
not send mail: Insecure $ENV{PATH} while running with -T switch at
/usr/share/request-tracker3.6/lib/RT/Action/SendEmail.pm line
333.#012#012Stack:#012

  
  
You appear to be running RT in taint mode.  Why?

-kevin
  


-- 
Kevin Bailey

Director/Programmer - Freeway Projects Limited

Web: www.freewayprojects.com

Email: kbai...@freewayprojects.com

Phone: +44 (0)1752 267090








Re: [rt-users] Can't send out email after moving RT

2010-12-09 Thread Kevin Falcone
On Thu, Dec 09, 2010 at 05:08:32PM +, Kevin Bailey wrote:
 Not sure - it was installed by one of our guys.  I don't even know
 what taint mode is.
 
 Currently the Apache2 web server won't start up due to RT.  I'm getting

That is the same problem.  I suggest you ask the person doing the
install why they set it up in an undocumented manner.

-kevin

 [Thu Dec 09 16:53:06 2010] [error] Insecure dependency in chdir
 while running with -T switch at /usr/share/perl/5.10/File/Path.pm
 line 222.\nCompilation failed in require at (eval 2) line 1.\n
 [Thu Dec 09 16:53:06 2010] [error] Can't load Perl file:
 /usr/share/request-tracker3.6/libexec/webmux.pl for server
 cyclone2.freewayprojects.com:80, exiting
 
 
 I've got a feeling that I'm going to have to start again from
 scratch.  I'll ask for pointers RE migration on the list.
 
 Thanks,
 
 Kevin Bailey
 
 On 09/12/10 16:38, Kevin Falcone wrote:
 On Thu, Dec 09, 2010 at 04:35:45PM +, Kevin Bailey wrote:
 Here's the log messages I found in syslog - I'm just looking through
 them now:
 
 (/usr/share/request-tracker3.6/lib/RT/Action/SendEmail.pm:266)#012
 Dec  9 16:34:23 cyclone2 
 RT:rt-3.6.7-17319-1291912462-219.1147-...@cyclone2.freewayprojects.comCould
 not send mail: Insecure $ENV{PATH} while running with -T switch at
 /usr/share/request-tracker3.6/lib/RT/Action/SendEmail.pm line
 333.#012#012Stack:#012
 You appear to be running RT in taint mode.  Why?


pgpbHeAuS6iFm.pgp
Description: PGP signature


[rt-users] Migrate and upgrade RT

2010-12-09 Thread Kevin Bailey




Hi,

Currently we have RT running at version 

ii request-tracker3.6 3.6.1-4+etch1
Extensible trouble-ticket tracking system

on a Debian etch server.

We have a nice new Debian server set up running Debian lenny. And
we've installed RT on that server from the repository - currently
version 

ii request-tracker3.6 3.6.7-5+lenny4

Any pointers on how we move the data from the old server to the new one.

I was told that it was just a question of copying the database over to
the new server and connecting to it using the conf file. Then the
database would automatically get updated when it was first accessed -
but we've run into a problem whereby the web server fails to start

[Thu Dec 09 16:53:06 2010] [error] Insecure dependency in chdir
while running with -T switch at /usr/share/perl/5.10/File/Path.pm line
222.\nCompilation failed in require at (eval 2) line 1.\n
[Thu Dec 09 16:53:06 2010] [error] Can't load Perl file:
/usr/share/request-tracker3.6/libexec/webmux.pl for server
cyclone2.freewayprojects.com:80, exiting..

I will start looking through the docs etc but thought I'd ask for some
pointers first.

Thanks,
-- 
Kevin Bailey

Director/Programmer - Freeway Projects Limited

Web: www.freewayprojects.com

Email: kbai...@freewayprojects.com

Phone: +44 (0)1752 267090








[rt-users] associating customFields to QuickCalls?

2010-12-09 Thread Giuseppe Sollazzo

Hi all,
I'm using the QuickCalls extensions to create tickets of a given type.

It would be great if it were possible to, say, add custom fields to 
certain QuickCalls.


For example,
- a ticket referring to a network problem could have a field named IP 
address
- a ticket referring to a unaccessible web page could have a field named 
Http error reported


This can surely be done if associating a custom field to a given queue 
(using the Applies to option).


However, there could be situations in which it would be useful to 
specify a second level (a type) and get custom fields relevant to that 
type.


Has anyone done anything similar?

All the best,
Giuseppe

--


Giuseppe Sollazzo
Senior Systems Analyst
Computing Services
Information Services
St. George's, University Of London
Cranmer Terrace
London SW17 0RE

Email: gsoll...@sgul.ac.uk
Direct Dial: +44 20 8725 5160
Fax: +44 20 8725 3583




[rt-users] notification

2010-12-09 Thread Kurt Engle
I am looking for a way to send an email from RT to a specified e-mail address 
that is not an account in RT or associated with the ticket as a requestor, 
watcher, CC:, BCC:...etc 

I have the logic down to specify the e-mail address and have some nasty perl 
code to actually send the e-mail. But, it seems that RT has some internal 
module(s) that handle what the nasty perl code is doing. 

I can see the RT::Action:SendEmail module, but how do I incorporate that into a 
script that allows me to do what I am looking to do? 


Thanks, 


Kurt Engle 



[rt-users] 2 New locations

2010-12-09 Thread Peter Barton
108 Industrial Blvd

Kilgore, TX 75662

Phone: 903-984-5482

LCON: Cell: 903-983-9397 Marcie Platt

 

812 CR 367

Palestine, TX 75801

Phone: 903-723-5418

LCON: Cell: 903-948-3473 JD Hatten

 

Both locations were just purchased and it was closed last week.  I just
found out yesterday.  Once the orders are in please place expedites on
each.

 

Thanks,

 

-

Peter Barton

Network Manager

IESI Corporation

work.817-632-4000

mobile.817-683-9635

 



[rt-users] RT Sending Email too SLOW

2010-12-09 Thread Naresh Maharaj
Hi

We really need some help resolving the slow email issue.
I have been researching this for over 2 weeks now before calling our to
RT_Users.
I have searched all of the below,

http://wiki.bestpractical.com/
http://gossamer-threads.com/lists/rt/
http://www.google.com/

and much wider across the Internet. Almost given up!!

++Description:
Overall there are no issues with email leaving RT - email reaches all
destinations
There are no issues raising tickets into the queue via email.
Overall speed of moving around RT Web front end is fast / acceptable

++Issue:
replying to a ticket takes up to 30 seconds to complete and sending the
email in some cases up to 1 min.
this is simply prohibitive to use in a professional setup.

++Other Issues:
Squirrel Mail (Linux Web Mail) has the same issue, up to 30 seconds to send
an email - no solution
SSH to shell remotely same problem 30s - Now resolved by removing the DNS
lookup: /etc/ssh/sshd_config  [UseDNS no]
SFTP - Slow 30 sec - fixed by line above
Sendmail takes 30 sec to send an email from command line test an issue we
have had with php apps for over a year - now resolved by :
Edit the sendmail.cfg

Was:
# pass to name server to make hostname canonical
R$* $| $*  @ $*  $*  $: $2  @ $[ $3 $]  $4

Now:
# pass to name server to make hostname canonical
#R$* $| $*  @ $*  $*  $: $2  @ $[ $3 $]  $4

OR
sendmail.mc
Add:
FEATURE(`nocanonify')dnl

then rebuiuld sendmail using m4

Sendmail now blistering fast.

++RT mail Configuration:
Previously I was using sendmailpipe
$MailCommand = 'sendmailpipe';
$SendmailArguments = -oi -t;
$SendmailPath = /usr/sbin/sendmail;

Now that I have confirmed that Sendmail is NOT the issue I am now using:
$MailCommand = 'sendmailpipe';
#$SendmailArguments = -oi -t;
$SendmailArguments = -oi -ODeliveryMode=b -OErrorMode=m;
$SendmailPath = /usr/sbin/sendmail;

Also have soft link:
/etc/smrsh/rt-mailgate - /opt/rt3/bin/rt-mailgate

Note sure what else to test.

The common denominator here is Apache Http
So here is the conf entry for RT:


[r...@caitanya conf]# diff httpd.conf httpd.conf.working.20101126
997,1015d996
 Alias /rt /opt/rt3/share/html
 PerlModule Apache::DBI
 PerlRequire /opt/rt3/bin/webmux.pl
 Directory /opt/rt3/share/html
   AllowOverride All
   Options ExecCGI FollowSymLinks
   IfModule mod_access.c
 Order allow,deny
   Allow from all
   /IfModule
 /Directory

 Location /rt
   RewriteEngine On
   RedirectMatch permanent (.*)/$ $1/index.html
   AddDefaultCharset UTF-8
   SetHandler perl-script
   PerlHandler RT::Mason
 /Location

Appreciate any help that one can give.
Its the only issue stopping us from moving RT from test environment to
production.


Naresh Maharaj,

Hewitt  May (Shirtmakers) Ltd
email: i...@hewittandmay.com
web: http://www.hewittandmay.co.uk


Re: [rt-users] RT Sending Email too SLOW

2010-12-09 Thread Kenneth Marshall
It sounds like all of your problems are DNS related. Instead
of disabling the lookups everywhere because they are busted,
if you fixed them it would all just work. Barring that, you
will need to disable the DNS lookup that is causing the slow
mail problem. Good luck.

Cheers,
Ken

On Thu, Dec 09, 2010 at 09:48:56PM +, Naresh Maharaj wrote:
 Hi
 
 We really need some help resolving the slow email issue.
 I have been researching this for over 2 weeks now before calling our to
 RT_Users.
 I have searched all of the below,
 
 http://wiki.bestpractical.com/
 http://gossamer-threads.com/lists/rt/
 http://www.google.com/
 
 and much wider across the Internet. Almost given up!!
 
 ++Description:
 Overall there are no issues with email leaving RT - email reaches all
 destinations
 There are no issues raising tickets into the queue via email.
 Overall speed of moving around RT Web front end is fast / acceptable
 
 ++Issue:
 replying to a ticket takes up to 30 seconds to complete and sending the
 email in some cases up to 1 min.
 this is simply prohibitive to use in a professional setup.
 
 ++Other Issues:
 Squirrel Mail (Linux Web Mail) has the same issue, up to 30 seconds to send
 an email - no solution
 SSH to shell remotely same problem 30s - Now resolved by removing the DNS
 lookup: /etc/ssh/sshd_config  [UseDNS no]
 SFTP - Slow 30 sec - fixed by line above
 Sendmail takes 30 sec to send an email from command line test an issue we
 have had with php apps for over a year - now resolved by :
 Edit the sendmail.cfg
 
 Was:
 # pass to name server to make hostname canonical
 R$* $| $*  @ $*  $*  $: $2  @ $[ $3 $]  $4
 
 Now:
 # pass to name server to make hostname canonical
 #R$* $| $*  @ $*  $*  $: $2  @ $[ $3 $]  $4
 
 OR
 sendmail.mc
 Add:
 FEATURE(`nocanonify')dnl
 
 then rebuiuld sendmail using m4
 
 Sendmail now blistering fast.
 
 ++RT mail Configuration:
 Previously I was using sendmailpipe
 $MailCommand = 'sendmailpipe';
 $SendmailArguments = -oi -t;
 $SendmailPath = /usr/sbin/sendmail;
 
 Now that I have confirmed that Sendmail is NOT the issue I am now using:
 $MailCommand = 'sendmailpipe';
 #$SendmailArguments = -oi -t;
 $SendmailArguments = -oi -ODeliveryMode=b -OErrorMode=m;
 $SendmailPath = /usr/sbin/sendmail;
 
 Also have soft link:
 /etc/smrsh/rt-mailgate - /opt/rt3/bin/rt-mailgate
 
 Note sure what else to test.
 
 The common denominator here is Apache Http
 So here is the conf entry for RT:
 
 
 [r...@caitanya conf]# diff httpd.conf httpd.conf.working.20101126
 997,1015d996
  Alias /rt /opt/rt3/share/html
  PerlModule Apache::DBI
  PerlRequire /opt/rt3/bin/webmux.pl
  Directory /opt/rt3/share/html
AllowOverride All
Options ExecCGI FollowSymLinks
IfModule mod_access.c
  Order allow,deny
Allow from all
/IfModule
  /Directory
 
  Location /rt
RewriteEngine On
RedirectMatch permanent (.*)/$ $1/index.html
AddDefaultCharset UTF-8
SetHandler perl-script
PerlHandler RT::Mason
  /Location
 
 Appreciate any help that one can give.
 Its the only issue stopping us from moving RT from test environment to
 production.
 
 
 Naresh Maharaj,
 
 Hewitt  May (Shirtmakers) Ltd
 email: i...@hewittandmay.com
 web: http://www.hewittandmay.co.uk


Re: [rt-users] Migrate and upgrade RT

2010-12-09 Thread John Arends


  
  
The database doesn't get automatically upgraded, but old databases
will usually work just fine, so your problem is likely not database
related. You need to run manually upgrade the database schema.

On 12/9/10 11:17 AM, Kevin Bailey wrote:

  
  Hi,
  
  Currently we have RT running at version 
  
  ii request-tracker3.6
3.6.1-4+etch1
Extensible trouble-ticket tracking system
  
  on a Debian etch server.
  
  We have a nice new Debian server set up running Debian lenny. And
  we've installed RT on that server from the repository - currently
  version 
  
  ii request-tracker3.6 3.6.7-5+lenny4
  
  Any pointers on how we move the data from the old server to the
  new one.
  
  I was told that it was just a question of copying the database
  over to
  the new server and connecting to it using the conf file. Then the
  database would automatically get updated when it was first
  accessed -
  but we've run into a problem whereby the web server fails to start
  
  [Thu Dec 09 16:53:06 2010] [error] Insecure dependency in
chdir
while running with -T switch at
/usr/share/perl/5.10/File/Path.pm line
222.\nCompilation failed in require at (eval 2) line 1.\n
[Thu Dec 09 16:53:06 2010] [error] Can't load Perl file:
/usr/share/request-tracker3.6/libexec/webmux.pl for server
cyclone2.freewayprojects.com:80, exiting..
  
  I will start looking through the docs etc but thought I'd ask for
  some
  pointers first.
  
  Thanks,
  -- 
Kevin Bailey

Director/Programmer - Freeway Projects Limited

Web: www.freewayprojects.com

Email: kbai...@freewayprojects.com

Phone: +44 (0)1752 267090



  



-- 
John Arends
jare...@illinois.edu
Network Analyst
College of ACES ITCS
University of Illinois at Urbana-Champaign
  



Re: [rt-users] RT Sending Email too SLOW

2010-12-09 Thread Ruslan Zakirov
Hi,

The following may help you http://requesttracker.wikia.com/wiki/SendmailTips

On Fri, Dec 10, 2010 at 12:48 AM, Naresh Maharaj
nar...@hewittandmay.com wrote:
 Hi

 We really need some help resolving the slow email issue.
 I have been researching this for over 2 weeks now before calling our to
 RT_Users.
 I have searched all of the below,

 http://wiki.bestpractical.com/
 http://gossamer-threads.com/lists/rt/
 http://www.google.com/

 and much wider across the Internet. Almost given up!!

 ++Description:
 Overall there are no issues with email leaving RT - email reaches all
 destinations
 There are no issues raising tickets into the queue via email.
 Overall speed of moving around RT Web front end is fast / acceptable

 ++Issue:
 replying to a ticket takes up to 30 seconds to complete and sending the
 email in some cases up to 1 min.
 this is simply prohibitive to use in a professional setup.

 ++Other Issues:
 Squirrel Mail (Linux Web Mail) has the same issue, up to 30 seconds to send
 an email - no solution
 SSH to shell remotely same problem 30s - Now resolved by removing the DNS
 lookup: /etc/ssh/sshd_config  [UseDNS no]
 SFTP - Slow 30 sec - fixed by line above
 Sendmail takes 30 sec to send an email from command line test an issue we
 have had with php apps for over a year - now resolved by :
 Edit the sendmail.cfg

 Was:
 # pass to name server to make hostname canonical
 R$* $| $*  @ $*  $*  $: $2  @ $[ $3 $]  $4

 Now:
 # pass to name server to make hostname canonical
 #R$* $| $*  @ $*  $*  $: $2  @ $[ $3 $]  $4

 OR
 sendmail.mc
 Add:
 FEATURE(`nocanonify')dnl

 then rebuiuld sendmail using m4

 Sendmail now blistering fast.

 ++RT mail Configuration:
 Previously I was using sendmailpipe
 $MailCommand = 'sendmailpipe';
 $SendmailArguments = -oi -t;
 $SendmailPath = /usr/sbin/sendmail;

 Now that I have confirmed that Sendmail is NOT the issue I am now using:
 $MailCommand = 'sendmailpipe';
 #$SendmailArguments = -oi -t;
 $SendmailArguments = -oi -ODeliveryMode=b -OErrorMode=m;
 $SendmailPath = /usr/sbin/sendmail;

 Also have soft link:
 /etc/smrsh/rt-mailgate - /opt/rt3/bin/rt-mailgate

 Note sure what else to test.

 The common denominator here is Apache Http
 So here is the conf entry for RT:


 [r...@caitanya conf]# diff httpd.conf httpd.conf.working.20101126
 997,1015d996
  Alias /rt /opt/rt3/share/html
  PerlModule Apache::DBI
  PerlRequire /opt/rt3/bin/webmux.pl
  Directory /opt/rt3/share/html
    AllowOverride All
    Options ExecCGI FollowSymLinks
    IfModule mod_access.c
  Order allow,deny
    Allow from all
    /IfModule
  /Directory
 
  Location /rt
    RewriteEngine On
    RedirectMatch permanent (.*)/$ $1/index.html
    AddDefaultCharset UTF-8
    SetHandler perl-script
    PerlHandler RT::Mason
  /Location

 Appreciate any help that one can give.
 Its the only issue stopping us from moving RT from test environment to
 production.

 Naresh Maharaj,

 Hewitt  May (Shirtmakers) Ltd
 email: i...@hewittandmay.com
 web: http://www.hewittandmay.co.uk




-- 
Best regards, Ruslan.


Re: [rt-users] RT Sending Email too SLOW

2010-12-09 Thread Naresh Maharaj
Dear Ruslan


Thank you - have done all of this already.

Just checked the DNS Servers we use and it seems our ISP had not informed us
of a change to the DNS address.

Made a change to /etc/resolve.conf

added the new DNS server address and hey presto !!!

Super fast

Kind regards


Naresh Maharaj,

Hewitt  May (Shirtmakers) Ltd
email: i...@hewittandmay.com
web: http://www.hewittandmay.co.uk






On 9 December 2010 23:39, Ruslan Zakirov r...@bestpractical.com wrote:

 Hi,

 The following may help you
 http://requesttracker.wikia.com/wiki/SendmailTips

 On Fri, Dec 10, 2010 at 12:48 AM, Naresh Maharaj
 nar...@hewittandmay.com wrote:
  Hi
 
  We really need some help resolving the slow email issue.
  I have been researching this for over 2 weeks now before calling our to
  RT_Users.
  I have searched all of the below,
 
  http://wiki.bestpractical.com/
  http://gossamer-threads.com/lists/rt/
  http://www.google.com/
 
  and much wider across the Internet. Almost given up!!
 
  ++Description:
  Overall there are no issues with email leaving RT - email reaches all
  destinations
  There are no issues raising tickets into the queue via email.
  Overall speed of moving around RT Web front end is fast / acceptable
 
  ++Issue:
  replying to a ticket takes up to 30 seconds to complete and sending the
  email in some cases up to 1 min.
  this is simply prohibitive to use in a professional setup.
 
  ++Other Issues:
  Squirrel Mail (Linux Web Mail) has the same issue, up to 30 seconds to
 send
  an email - no solution
  SSH to shell remotely same problem 30s - Now resolved by removing the DNS
  lookup: /etc/ssh/sshd_config  [UseDNS no]
  SFTP - Slow 30 sec - fixed by line above
  Sendmail takes 30 sec to send an email from command line test an issue we
  have had with php apps for over a year - now resolved by :
  Edit the sendmail.cfg
 
  Was:
  # pass to name server to make hostname canonical
  R$* $| $*  @ $*  $*  $: $2  @ $[ $3 $]  $4
 
  Now:
  # pass to name server to make hostname canonical
  #R$* $| $*  @ $*  $*  $: $2  @ $[ $3 $]  $4
 
  OR
  sendmail.mc
  Add:
  FEATURE(`nocanonify')dnl
 
  then rebuiuld sendmail using m4
 
  Sendmail now blistering fast.
 
  ++RT mail Configuration:
  Previously I was using sendmailpipe
  $MailCommand = 'sendmailpipe';
  $SendmailArguments = -oi -t;
  $SendmailPath = /usr/sbin/sendmail;
 
  Now that I have confirmed that Sendmail is NOT the issue I am now using:
  $MailCommand = 'sendmailpipe';
  #$SendmailArguments = -oi -t;
  $SendmailArguments = -oi -ODeliveryMode=b -OErrorMode=m;
  $SendmailPath = /usr/sbin/sendmail;
 
  Also have soft link:
  /etc/smrsh/rt-mailgate - /opt/rt3/bin/rt-mailgate
 
  Note sure what else to test.
 
  The common denominator here is Apache Http
  So here is the conf entry for RT:
 
 
  [r...@caitanya conf]# diff httpd.conf httpd.conf.working.20101126
  997,1015d996
   Alias /rt /opt/rt3/share/html
   PerlModule Apache::DBI
   PerlRequire /opt/rt3/bin/webmux.pl
   Directory /opt/rt3/share/html
 AllowOverride All
 Options ExecCGI FollowSymLinks
 IfModule mod_access.c
   Order allow,deny
 Allow from all
 /IfModule
   /Directory
  
   Location /rt
 RewriteEngine On
 RedirectMatch permanent (.*)/$ $1/index.html
 AddDefaultCharset UTF-8
 SetHandler perl-script
 PerlHandler RT::Mason
   /Location
 
  Appreciate any help that one can give.
  Its the only issue stopping us from moving RT from test environment to
  production.
 
  Naresh Maharaj,
 
  Hewitt  May (Shirtmakers) Ltd
  email: i...@hewittandmay.com
  web: http://www.hewittandmay.co.uk
 



 --
 Best regards, Ruslan.




--


Re: [rt-users] RT Sending Email too SLOW

2010-12-09 Thread naresh
Kenneth

Thanks. Fixing DNS fixed e'thing

Kind regards


Naresh Maharaj
Hewitt  May (Shirtmakers) Ltd. 
email: nar...@hewittandmay.com
 
--

-Original Message-
From: Kenneth Marshall k...@rice.edu
Date: Thu, 9 Dec 2010 16:03:25 
To: Naresh Maharajnar...@hewittandmay.com
Cc: rt-users@lists.bestpractical.com; Managementmanagem...@hewittandmay.com
Subject: Re: [rt-users] RT Sending Email too SLOW

It sounds like all of your problems are DNS related. Instead
of disabling the lookups everywhere because they are busted,
if you fixed them it would all just work. Barring that, you
will need to disable the DNS lookup that is causing the slow
mail problem. Good luck.

Cheers,
Ken

On Thu, Dec 09, 2010 at 09:48:56PM +, Naresh Maharaj wrote:
 Hi
 
 We really need some help resolving the slow email issue.
 I have been researching this for over 2 weeks now before calling our to
 RT_Users.
 I have searched all of the below,
 
 http://wiki.bestpractical.com/
 http://gossamer-threads.com/lists/rt/
 http://www.google.com/
 
 and much wider across the Internet. Almost given up!!
 
 ++Description:
 Overall there are no issues with email leaving RT - email reaches all
 destinations
 There are no issues raising tickets into the queue via email.
 Overall speed of moving around RT Web front end is fast / acceptable
 
 ++Issue:
 replying to a ticket takes up to 30 seconds to complete and sending the
 email in some cases up to 1 min.
 this is simply prohibitive to use in a professional setup.
 
 ++Other Issues:
 Squirrel Mail (Linux Web Mail) has the same issue, up to 30 seconds to send
 an email - no solution
 SSH to shell remotely same problem 30s - Now resolved by removing the DNS
 lookup: /etc/ssh/sshd_config  [UseDNS no]
 SFTP - Slow 30 sec - fixed by line above
 Sendmail takes 30 sec to send an email from command line test an issue we
 have had with php apps for over a year - now resolved by :
 Edit the sendmail.cfg
 
 Was:
 # pass to name server to make hostname canonical
 R$* $| $*  @ $*  $*  $: $2  @ $[ $3 $]  $4
 
 Now:
 # pass to name server to make hostname canonical
 #R$* $| $*  @ $*  $*  $: $2  @ $[ $3 $]  $4
 
 OR
 sendmail.mc
 Add:
 FEATURE(`nocanonify')dnl
 
 then rebuiuld sendmail using m4
 
 Sendmail now blistering fast.
 
 ++RT mail Configuration:
 Previously I was using sendmailpipe
 $MailCommand = 'sendmailpipe';
 $SendmailArguments = -oi -t;
 $SendmailPath = /usr/sbin/sendmail;
 
 Now that I have confirmed that Sendmail is NOT the issue I am now using:
 $MailCommand = 'sendmailpipe';
 #$SendmailArguments = -oi -t;
 $SendmailArguments = -oi -ODeliveryMode=b -OErrorMode=m;
 $SendmailPath = /usr/sbin/sendmail;
 
 Also have soft link:
 /etc/smrsh/rt-mailgate - /opt/rt3/bin/rt-mailgate
 
 Note sure what else to test.
 
 The common denominator here is Apache Http
 So here is the conf entry for RT:
 
 
 [r...@caitanya conf]# diff httpd.conf httpd.conf.working.20101126
 997,1015d996
  Alias /rt /opt/rt3/share/html
  PerlModule Apache::DBI
  PerlRequire /opt/rt3/bin/webmux.pl
  Directory /opt/rt3/share/html
AllowOverride All
Options ExecCGI FollowSymLinks
IfModule mod_access.c
  Order allow,deny
Allow from all
/IfModule
  /Directory
 
  Location /rt
RewriteEngine On
RedirectMatch permanent (.*)/$ $1/index.html
AddDefaultCharset UTF-8
SetHandler perl-script
PerlHandler RT::Mason
  /Location
 
 Appreciate any help that one can give.
 Its the only issue stopping us from moving RT from test environment to
 production.
 
 
 Naresh Maharaj,
 
 Hewitt  May (Shirtmakers) Ltd
 email: i...@hewittandmay.com
 web: http://www.hewittandmay.co.uk


[rt-users] How to setup holidays in RT::Extension::SLA 0.03?

2010-12-09 Thread Rithy R

Dear RT Community - Please kindly advise on how can I accomplish the above. I 
trust you understand how urgent it is for me to have it up and running.

Regards,Rithy


  

[rt-users] RT::Extension::SLA - Holidays

2010-12-09 Thread Rithy R

Dear RT Community - Please kindly advise on how can I accomplish the above. I 
trust you understand how urgent it is for me to have it up and running.

Regards,Rithy


  

[rt-users] Custom Scrip question

2010-12-09 Thread Jason Knight
I am looking to write a custom scrip that will send an email to my 
allus...@domain.commailto:allus...@domain.com email address, if the subject 
line has [--Maintenance--] somewhere in it, to let them know when the scheduled 
maintenance will be performed.  It can be based on create ticket since I can 
include all the maintenance details in the initial email that goes to the queue.

Any help appreciated, or pointers to documentation.  I'm a newb and still 
reading through RT Essentials and the online User Manual.  Rockin product, love 
it!  You can make an easier to use help desk from an end user perspective.  
Very nice way for the IT dept to not only show accountability, but to have all 
the work in queue, so nothing gets missed, digest reports to managers, website 
change approval processes, the list goes on.  Having a lot of fun setting it up.

__
This email has been scanned by the MessageLabs Email Security System.
For more information please visit http://www.messagelabs.com/email 
__