[ADMIN] Re: [rt-users] Wolfgang Fuertbauer is out of the office.

2006-06-23 Thread Jesse Vincent
Wolfgang Fuertbauer has been unsubscribed from rt-users. Please feel
free to resubscribe when you're sure your vacation mailer won't send
mail to public mailinglists.

Jesse


On Fri, Jun 23, 2006 at 12:31:31AM +0200, [EMAIL PROTECTED] wrote:
 
 Ich werde ab  23.06.2006 nicht im Büro sein. Ich kehre zurück am
 26.06.2006.
 
 Please call IT-Helpdesk: +43 7665 8123 333
 or email to: [EMAIL PROTECTED]
 
 Best regards
 
 --
   (e-Mail: [EMAIL PROTECTED])
 EBEWE Pharma
 Mondseestrasse 11
 4866  Unterach, Austria
 Tel +43 7665 8123 0*
 Fax +43 7665 8123 11
 http://www.ebewe.com
 ___
 http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
 
 Community help: http://wiki.bestpractical.com
 Commercial support: [EMAIL PROTECTED]
 
 
 Discover RT's hidden secrets with RT Essentials from O'Reilly Media. 
 Buy a copy at http://rtbook.bestpractical.com
 
 
 We're hiring! Come hack Perl for Best Practical: 
 http://bestpractical.com/about/jobs.html

-- 
___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: [EMAIL PROTECTED]


Discover RT's hidden secrets with RT Essentials from O'Reilly Media. 
Buy a copy at http://rtbook.bestpractical.com


We're hiring! Come hack Perl for Best Practical: 
http://bestpractical.com/about/jobs.html


RE: [rt-users] Patching RedHat breaks RT

2006-06-23 Thread Kemp, Darren
Thanks, that got it!

-dkk
 

-Original Message-
From: Ruslan Zakirov [mailto:[EMAIL PROTECTED] 
Sent: Thursday, June 22, 2006 9:11 PM
To: Kemp, Darren
Cc: rt-users@lists.bestpractical.com
Subject: Re: [rt-users] Patching RedHat breaks RT

On 6/23/06, Kemp, Darren [EMAIL PROTECTED] wrote:


 I recently patched my RT server to the latest levels (it is redhat ES 
 4) (yah I know, bad idea)

 Unfortunately this horribly broke my RT install. I have managed to fix

 and update most of the modules and issues I have encountered, but this

 last one is puzzling, I can no longer get mail to go through
rt-mailgate.
Rebuild Log::Dispatch from sources, don't forget to run test suite.
Also, read http://wiki.bestpractical.com/index.cgi?NoConnectionToSyslog


 From sendmail the error appears as so:

 Jun 22 16:24:40 sauron sendmail[3436]: k5MKOeFT003435:
 to=|/etc/smrsh/rt-mailgate --queue 'operations' --action comment 
 --url http://foo.bar.com/;, ctladdr=[EMAIL PROTECTED] (8/0), 
 delay=00:00:00, xdelay=00:00:00, mailer=prog, pri=30574, dsn=4.0.0,
 stat=Deferred: prog mailer (/usr/sbin/smrsh) exited with EX_TEMPFAIL

 I tried a manual send with debug on and recieved the following:

 [EMAIL PROTECTED] dkemp]# /usr/local/rt/bin/rt-mailgate --queue operations 
 --action correspond --debug --url=http://foo.bar.com  ./testmsg 
 Connecting to http://foo.bar.com/REST/1.0/NoAuth/mail-gateway at 
 /usr/local/rt/bin/rt-mailgate line 99,  chunk 1.
 no connection to syslog available
 - _PATH_LOG not available in syslog.h at 
 /usr/local/lib/perl5/site_perl/5.8.7/Log/Dispatch/Syslog.pm
 line 77

 Stack:
   [/usr/local/lib/perl5/5.8.7/Carp.pm:269]
   [/usr/local/lib/perl5/5.8.7/i686-linux/Sys/Syslog.pm:412]
   [/usr/local/lib/perl5/5.8.7/i686-linux/Sys/Syslog.pm:241]

 [/usr/local/lib/perl5/site_perl/5.8.7/Log/Dispatch/Syslog.pm:77]

 [/usr/local/lib/perl5/site_perl/5.8.7/Log/Dispatch/Output.pm:41]
   [/usr/local/lib/perl5/site_perl/5.8.7/Log/Dispatch.pm:95]
   [/usr/local/lib/perl5/site_perl/5.8.7/Log/Dispatch.pm:74]
   [/usr/local/lib/perl5/site_perl/5.8.7/Log/Dispatch.pm:22]
   [/usr/local/rt/lib/RT/I18N.pm:410]
   [/usr/local/rt/lib/RT/I18N.pm:367]
   [/usr/local/rt/lib/RT/I18N.pm:190]
   [/usr/local/rt/lib/RT/EmailParser.pm:266]
   [/usr/local/rt/lib/RT/EmailParser.pm:237]
   [/usr/local/rt/lib/RT/EmailParser.pm:176]
   [/usr/local/rt/lib/RT/EmailParser.pm:136]
   [/usr/local/rt/lib/RT/Interface/Email.pm:515]

 [/usr/local/rt/share/html/REST/1.0/NoAuth/mail-gateway:59]
 RT server error.

 The RT server which handled your email did not behave as expected. It
 said:

 no connection to syslog available
 - _PATH_LOG not available in syslog.h at 
 /usr/local/lib/perl5/site_perl/5.8.7/Log/Dispatch/Syslog.pm
 line 77

 Stack:
   [/usr/local/lib/perl5/5.8.7/Carp.pm:269]
   [/usr/local/lib/perl5/5.8.7/i686-linux/Sys/Syslog.pm:412]
   [/usr/local/lib/perl5/5.8.7/i686-linux/Sys/Syslog.pm:241]

 [/usr/local/lib/perl5/site_perl/5.8.7/Log/Dispatch/Syslog.pm:77]

 [/usr/local/lib/perl5/site_perl/5.8.7/Log/Dispatch/Output.pm:41]
   [/usr/local/lib/perl5/site_perl/5.8.7/Log/Dispatch.pm:95]
   [/usr/local/lib/perl5/site_perl/5.8.7/Log/Dispatch.pm:74]
   [/usr/local/lib/perl5/site_perl/5.8.7/Log/Dispatch.pm:22]
   [/usr/local/rt/lib/RT/I18N.pm:410]
   [/usr/local/rt/lib/RT/I18N.pm:367]
   [/usr/local/rt/lib/RT/I18N.pm:190]
   [/usr/local/rt/lib/RT/EmailParser.pm:266]
   [/usr/local/rt/lib/RT/EmailParser.pm:237]
   [/usr/local/rt/lib/RT/EmailParser.pm:176]
   [/usr/local/rt/lib/RT/EmailParser.pm:136]
   [/usr/local/rt/lib/RT/Interface/Email.pm:515]

 [/usr/local/rt/share/html/REST/1.0/NoAuth/mail-gateway:59]

 Google has come up short on tihs issue except for some solaris 
 specific bugs way back in perl 5.8.0 I have tried to force a reinstall

 of Sys::Syslog but it did not help.

 Anyone who has any insight to this issue, please let me know.

 -dkk


 version information:

 Sendmail 8.12.11.20060308/8.12.11;

 Perl v5.8.7 under linux
   Apache::Session v1.81;
   Apache::Session::Generate::MD5 v2.1;
   Apache::Session::Lock::MySQL v1.00;
   Apache::Session::MySQL v1.01;
   Apache::Session::Serialize::Storable v1.00;
   Apache::Session::Store::DBI v1.02;
   Apache::Session::Store::MySQL v1.04;
   AutoLoader v5.60;
   base v2.07;
   Benchmark v1.07;
   bytes v1.02;
   Cache::Simple::TimedExpiry v0.23;
   capitalization v0.03;
   Carp v1.04;
   CGI v3.20;
   CGI::Cookie v1.27;
   CGI::Fast v1.07;
   CGI::Util v1.5;
   Class::Container v0.12;
   Class::Data::Inheritable v0.04;
   Class::ReturnValue v0.53;
   Clone v0.20;
   constant v1.05;
   Cwd v3.18;
   Data::Dumper v2.121_04;
   DBD::mysql v3.0002;
   DBI v1.51;
   DBIx::SearchBuilder v1.43;
   DBIx::SearchBuilder::Unique v0.01;
   Devel::StackTrace v1.13;
   Devel::StackTraceFrame v0.6;
   Devel::Symdump v2.0601;
   Digest::base v1.00;
   Digest::MD5 v2.36;
   DynaLoader v1.05;
   Encode v2.18;
   Encode::Alias v2.06;
   Encode::Config v2.03;
   Encode::Encoding v2.04;
  

[rt-users] regex help

2006-06-23 Thread Justin Lim





I am trying to get a specific 
regex for extract custom fields and wondering if someone can help 
me.

what i am trying to get is the 
xxx out of "Name : xx" where the end of the line can be \n or 
br or br / or br/

can someone please help with 
the regex for this ?

Thanks

___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: [EMAIL PROTECTED]


Discover RT's hidden secrets with RT Essentials from O'Reilly Media. 
Buy a copy at http://rtbook.bestpractical.com


We're hiring! Come hack Perl for Best Practical: 
http://bestpractical.com/about/jobs.html

Re: [rt-users] regex help

2006-06-23 Thread Jim Meyer

Hello!

On 6/23/06, Justin Lim [EMAIL PROTECTED] wrote:

what i am trying to get is the xxx out of Name : xx where the
end of the line can be \n or br or br / or br/


m/Name:\s*([^]*)(?:br\s*\/?)?$/

Might work. =]

--j, who likes a good regex.
--
Jim Meyer, Geek at Large[EMAIL PROTECTED]
___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: [EMAIL PROTECTED]


Discover RT's hidden secrets with RT Essentials from O'Reilly Media. 
Buy a copy at http://rtbook.bestpractical.com



We're hiring! Come hack Perl for Best Practical: 
http://bestpractical.com/about/jobs.html


[rt-users] migration from rt2 to rt3

2006-06-23 Thread venkata.kurra
Hi, 

We are trying to migrate rt2 to rt3 using mysql. The size of the
database is 100 Mb with 3500 tickets. It took 45 min to migrate to rt3
(mysql 5). Anybody has similar experience of the time it took.
Ultimately we would like to migrate the main database of size 6 GB. At
this ratio it might take more than 24 hours to migrate.

We have 4GB memory in the import server. Any clues to speed up the
process! Do I have to modify the database parameters before migrate!

My-huge.conf:
key_buffer = 384M
max_allowed_packet = 128M
table_cache = 512
sort_buffer_size = 2M
read_buffer_size = 2M
read_rnd_buffer_size = 8M
myisam_sort_buffer_size = 64M
thread_cache = 8
query_cache_size = 32M
___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: [EMAIL PROTECTED]


Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
Buy a copy at http://rtbook.bestpractical.com


We're hiring! Come hack Perl for Best Practical: 
http://bestpractical.com/about/jobs.html


[rt-users] Regular Expressions for Custom Field Validation in RT 3.6.0

2006-06-23 Thread Nick Metrowsky








Hi Everyone,



Once I was told where Custom Field Validation is maintained
in RT 3.6.0, I thought I make this small contribution to RT 3.6.0. The
following code snippet contains several useful regexp validations. Two of these
are provided with RT 3.6.0 (Mandatory, Digits), the new additions are as
follows:




 DateMMDD  Date in
 -MM-DD or /MM/DD format
 DateMMDD  Date in
 MM-DD- or MM/DD/ format
 DateDDMM  Date in
 DD-MM- or DD/MM/ format
 Float  Floating Point
 Numbers
 Email  Email address
 format
 IPAddress  IP Address
 format
 USZipCode5  US 5 digit
 Zip Code
 UZZipCode9  US 9 digit
 Zip Code
 USZipCode5or9  US Zip
 Code (either 5 digit or 9 digit)
 USTelephone  US Telephone
 Numbers
 RowRackHeight  Something
 used by us locally for locating equipment in out data center; Row #, Rack
 #, and Unit Height # in Rack.




I hope you find this information useful. Also, if folks have
additional regular expressions they should contribute them to this forum so
they can be shared with everybody.



Take care!



Nick



The following module contains the Custom Field Validation
definitions for RT 3.6.0:



/opt/rt3/share/html/Admin/CustomFields/Modify.html



The following code begins at line 82; I removed the regexp
for Years and added new code beginning at line 89:



 /Widgets/ComboBox,

 Name =
'Pattern',

 Default =
$CustomFieldObj-Pattern,

 Size = 50,

 Values = [


'(?#Mandatory).',

 '(?#Digits)^[\d.]+$',


'(?#Float)^(\+|-)?([0-9]+\.?[0-9]*|\.[0-9]+)([eE](\+|-)?[0-9]+)?',


'(?#DateMMDD)^(19|20)\d\d([-
/.])(0[1-9]|1[012])\2(0[1-9]|[12][0-9]|3[01])$',


'(?#DateMMDD)^(0[1-9]|1[012])[- /.](0[1-9]|[12][0-9]|3[01])[-
/.](19|20)\d\d',


'(?#DateDDMM)^(0[1-9]|[12][0-9]|3[01])[- /.](0[1-9]|1[012])[-
/.](19|20)\d\d',


'(?#Email)[EMAIL PROTECTED]',


'(?#IPAddress)^((25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9][0-9]|[0-9])\.){3}(25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9][0-9]|[0-9])$',


'(?#USZipCode5)^\d{5}$',


'(?#USZipCode9)^\d{5}-\d{4}$',


'(?#USZipCode5or9)^\d{5}(-?\d{4})?$',


'(?#USTelephone)^1?\s*-?\s*(\d{3}|\(\s*\d{3}\s*\))\s*-?\s*\d{3}\s*-?\s*\d{4}$',


'(?#RowRackHeight)^\d{2}-\d{2}-\d{2}$',

 '',

 ],





-

Nick
Metrowsky

Consulting
System Administrator

303-684-4785
Office

303-684-4100
Fax

[EMAIL PROTECTED]

DigitalGlobe
, An Imaging and Information Company

http://www.digitalglobe.com

-








___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: [EMAIL PROTECTED]


Discover RT's hidden secrets with RT Essentials from O'Reilly Media. 
Buy a copy at http://rtbook.bestpractical.com


We're hiring! Come hack Perl for Best Practical: 
http://bestpractical.com/about/jobs.html

Re: [rt-users] Patching RedHat breaks RT

2006-06-23 Thread Mike Patterson
Patching Redhat (EL4) broke our system too. 
Searches weren't working and email correspondence wasn't being sent out.


I followed the advice of someone else who had a similar error message to 
the one I got when searching for tickets.
subject: sent on 5/22/2006 Re: [rt-users] 
RT::Interface::Web::QueryBuilder::Tree at
/usr/local/rt3/share/html/Search/Build.html line 288 error


#This is what I did to fix it (force updated the perl Scalar::Util 
module with CPAN)


perl -MCPAN -e shell
cpan force install Scalar::Util

#then restarted apache
service httpd restart

Things seem OK now.

--
Mike Patterson
Systems Manager
UC Berkeley Extension

___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: [EMAIL PROTECTED]


Discover RT's hidden secrets with RT Essentials from O'Reilly Media. 
Buy a copy at http://rtbook.bestpractical.com



We're hiring! Come hack Perl for Best Practical: 
http://bestpractical.com/about/jobs.html


Re: [rt-users] Shredder CLI Question

2006-06-23 Thread Mathew Snyder
Sorry, v04.

Mathew Snyder
Systems Administrator
Network+
ServerVault TechOps



Ruslan Zakirov wrote:
 RT/Shredder versions?
 
 On 6/23/06, Mathew Snyder [EMAIL PROTECTED] wrote:
 I'm trying to test out the removal of deleted tickets using the
 rtx-shredder CLI method.  I've been entering it nearly verbatim from the
 RTx::Shredder page on CPAN (ie, rtx-shredder --force --plugin
 'Tickets=queue,CustomerCare;status,deleted').  However, nothing is being
 done.  I don't know where the log file for mysql is aside from
 /var/log/mysqld.log.  But that doesn't provide any useful information.

 I'm wondering if Im supposed to provide the password for the rt3
 database somewhere.

 Any help would be appreciated.


 -- 
 Mathew Snyder
 Systems Administrator
 Network+
 ServerVault TechOps

 ___
 http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

 Community help: http://wiki.bestpractical.com
 Commercial support: [EMAIL PROTECTED]


 Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
 Buy a copy at http://rtbook.bestpractical.com


 We're hiring! Come hack Perl for Best Practical:
 http://bestpractical.com/about/jobs.html

 
 
___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: [EMAIL PROTECTED]


Discover RT's hidden secrets with RT Essentials from O'Reilly Media. 
Buy a copy at http://rtbook.bestpractical.com


We're hiring! Come hack Perl for Best Practical: 
http://bestpractical.com/about/jobs.html