from:"Jourdan Perla"

Re: [rt-users] Migration to a new server

2013-04-05 Thread Jourdan Perla

That's the way to do it.

Just a warning. You will overwrite all the tickets on your new server, so I 
hope you're not in production yet.

From: rt-users-boun...@lists.bestpractical.com 
[mailto:rt-users-boun...@lists.bestpractical.com] On Behalf Of Sergio Mesquita
Sent: Friday, April 05, 2013 9:22 AM
To: Gary Mason
Cc: rt-users@lists.bestpractical.com
Subject: Re: [rt-users] Migration to a new server

Hello Gary!
The better way it´s to dump your database.
After that, you need to upload to the new server, and finaly use the comand 
make upgrad database.
I upgrade my server from 3.6.0 to 4.0.10.
Works like a charm.

2013/4/5 Gary Mason mailto:g.ma...@fairfx.com>>
Hi,

I have inherited an RT 3.6.7 system with around 300,000 tickets in it, taking 
up about 40GB of disk space.

The hardware this runs on is getting on a bit, and response times are now 
getting to the frustratingly slow point.

I have a new server (Debian Squeeze) on which I have managed to get RT 4.0.7 up 
and running via backports PPA.  I have managed to include all the configuration 
and scrips from the existing system, and have created a few tickets in order to 
be able to demonstrate the updated UI/reporting/graphs etc to the helpdesk 
team.  People here are impressed :)

My problem is that I have been asked to migrate all the current tickets over to 
the new system in order to retain history.  I have next to no postgresql 
knowledge and am at a loss as to how to do this. I have briefly looked at the 
migration documents online, but I can't find anything that resembles a "run 
this script, point it to the current and new installations, cross your fingers 
and hold your breathe ..." type of migration script that would be so useful.

Is there anything that I can read, or can anyone offer some suggestions, as to 
how I can get the ticket information from the current to the new server ?

Thanks,
Gary

--
Cumprimentos/Mit freundlichen Gruss/Best Regards

Sergio Mesquita
Phone:
e-mail:sergio.mesqui...@gmail.com
www.gmail.com
--

Re: [rt-users] request

2013-01-07 Thread Jourdan Perla

There is a prepackaged version for Ubuntu on the repository, but it's a pain to 
upgrade.

You're an Ubuntu novice? Any other preferred *nix os? (If you're running it 
under a Windows VM, I'd suggest CentOS instead.)

There are some instructions for doing a fresh install under Ubuntu (and others) 
on the wiki.
http://requesttracker.wikia.com/wiki/InstallationGuides
With all the different setups out there, there is no one true a-z install guide 
that will work for everybody. Just read a few and try it out.

Jourdan Perla
University of California, Davis


From: rt-users-boun...@lists.bestpractical.com 
[rt-users-boun...@lists.bestpractical.com] on behalf of Yetomiwa Jabar 
[teeja...@rocketmail.com]
Sent: Sunday, January 06, 2013 01:38 AM
To: rt-users@lists.bestpractical.com
Subject: [rt-users] request

Hello,

PLease i have been trying to install request tracker on my ubuntu 12.04 since 
four weeks ago with no major headways, i have been stocked at different 
junctions.Now that i have been able to join rtusers, can any one give an a-z 
easy to follow installation guide to any rt version for ubuntu 12.04.i am a 
complete novice to ubuntu,and i am not a programmer.please any help is welcomed.

Thanks

Re: [rt-users] Lookup of Requestor Custom Field

2012-04-26 Thread Jourdan Perla

That did it. Thanks!

From: Ruslan Zakirov [mailto:ruslan.zaki...@gmail.com]
Sent: Tuesday, April 24, 2012 10:23 PM
To: Jourdan Perla
Cc: rt-users@lists.bestpractical.com
Subject: Re: [rt-users] Lookup of Requestor Custom Field

You need FirstCustomFieldValue method instead of _Value.

Ruslan from phone.
25.04.2012 1:59 пользователь "Jourdan Perla" 
mailto:jkpe...@ucdavis.edu>> написал:
I have a request to create a scrip that will automatically assign an owner to a 
ticket based on the requestor’s assigned Purchaser.

I have a Global custom field Purchaser, assigned to all Users.
Select one value.
For each value, Name is the username of the Purchaser, and Description is their 
full name (to make things easy for the managers).

So far my attempts to get the value of the custom field have ended in failure, 
mostly with
[error]: Impossible to assign the ticket to : That user does not exist ((eval 
1502):10)

My current script is below. Am I missing something obvious here? I’ve been up 
and down the PODs and I’m not finding a fix for this.

PREP
return 1;

CLEANUP:
#Get requestor
my $Reqstr_Obj = $self->TicketObj->Requestors;
# get value of custom field, which should be user ID of newowner
my $newowner = $self->TransactionObj->CreatorObj->_Value('Purchaser');
$RT::Logger->error( $newowner );

#set the owner
my ($status, $msg) = $self->TicketObj->SetOwner( $newowner );
unless( $status ) {
$RT::Logger->error( "Impossible to assign the ticket to $newowner: $msg" );
return undef;
}
return 1;

-
Jourdan Perla
BFTV Admin Group (BAE/FST/TEX/VEN)
University of California, Davis
530-752-3065

[rt-users] Lookup of Requestor Custom Field

2012-04-24 Thread Jourdan Perla

I have a request to create a scrip that will automatically assign an owner to a 
ticket based on the requestor's assigned Purchaser.

I have a Global custom field Purchaser, assigned to all Users.
Select one value.
For each value, Name is the username of the Purchaser, and Description is their 
full name (to make things easy for the managers).

So far my attempts to get the value of the custom field have ended in failure, 
mostly with
[error]: Impossible to assign the ticket to : That user does not exist ((eval 
1502):10)

My current script is below. Am I missing something obvious here? I've been up 
and down the PODs and I'm not finding a fix for this.

PREP
return 1;


CLEANUP:
#Get requestor
my $Reqstr_Obj = $self->TicketObj->Requestors;
# get value of custom field, which should be user ID of newowner
my $newowner = $self->TransactionObj->CreatorObj->_Value('Purchaser');
$RT::Logger->error( $newowner );

#set the owner
my ($status, $msg) = $self->TicketObj->SetOwner( $newowner );
unless( $status ) {
$RT::Logger->error( "Impossible to assign the ticket to $newowner: $msg" );
return undef;
}
return 1;

-
Jourdan Perla
BFTV Admin Group (BAE/FST/TEX/VEN)
University of California, Davis
530-752-3065

[rt-users] FW: rt-mailgate 302 Error. No, not Plack.

2012-03-15 Thread Jourdan Perla

Missed a Location in /etc/request-tracker3.8/apache2-modperl2.conf



Order Allow,Deny
Allow from rt.myserver.com


Did the trick.

-Jourdan


-Original Message-
From: Jourdan Perla 
Sent: Thursday, March 15, 2012 10:44 AM
To: rt-users@lists.bestpractical.com
Subject: RE: [rt-users] rt-mailgate 302 Error. No, not Plack.

Using 3.8 since there are no RT4 packages for Ubuntu 10.4 LTS. Attempts to 
manually install RT4 on Lucid would result in a whole 'nother ticket. Plan was 
to run 3.8 for now, then migrate to 4 on 12 this winter once things had settled 
down here.

No https redirects going on. I am using CAS Authentication (via mod_auth_cas) 
for the main site.


Apache httpd.conf
LoadFile /usr/lib/libcurl.so
LoadModule auth_cas_module /usr/lib/apache2/modules/mod_auth_cas.so

CASLoginURL https://cas.myserver.com/cas/login
CASValidateURL https://cas.myserver.com/cas/serviceValidate
CASCertificatePath /etc/ssl/certs/my_cas_bundle.pem CASCookiePath 
/var/cache/apache2/mod_auth_cas/ CASSSOEnabled On CASValidateServer On CASDebug 
Off 


 
   AuthType CAS
   AuthName " CAS"
 
   Require valid-user


   AllowOverRide None
   Satisfy Any


   AllowOverRide None
   Allow from all
   Satisfy Any


   Order allow,deny
   Allow from all
   Satisfy Any


   Order allow,deny
   Allow from all
   Satisfy Any


Satisfy Any
Allow from all


-Original Message-
From: rt-users-boun...@lists.bestpractical.com 
[mailto:rt-users-boun...@lists.bestpractical.com] On Behalf Of Kevin Falcone
Sent: Wednesday, March 14, 2012 4:49 PM
To: rt-users@lists.bestpractical.com
Subject: Re: [rt-users] rt-mailgate 302 Error. No, not Plack.

On Wed, Mar 14, 2012 at 09:43:47PM +, Jourdan Perla wrote:
> 
> An Error Occurred
> =
> 
> 302 Found
> 
> /usr/bin/rt-mailgate: undefined server error

This is Apache issuing a 302 before it gets to RT

> Grep all my logs for what happens at the same time and
> apache2/access.log:
> rt.myserver.com - - [14/Mar/2012:14:05:33 -0700] "POST 
> /rt/REST/1.0/NoAuth/mail-gateway HTTP/1.1" 302 715 "-" "libwww-perl/6.04"
> 
> I've got the following in my httpd.conf
> 
> 
>AllowOverRide None
>Satisfy Any
> 
> 
>AllowOverRide None
>Allow from all
>Satisfy Any
> 
> 
>Order allow,deny
>Allow from all
>Satisfy Any
> 
> 
>Order allow,deny
>Allow from all
>Satisfy Any
> 

What else do you have in apache.  Are you redirecting from http to https?  
Since you're using the debian packages, what else is going on there.  Also, 
this is where I feel compelled to ask why you're using
3.8 rather than 4.0 for a new install.

-kevin

Re: [rt-users] rt-mailgate 302 Error. No, not Plack.

2012-03-15 Thread Jourdan Perla

Using 3.8 since there are no RT4 packages for Ubuntu 10.4 LTS. Attempts to 
manually install RT4 on Lucid would result in a whole 'nother ticket. Plan was 
to run 3.8 for now, then migrate to 4 on 12 this winter once things had settled 
down here.

No https redirects going on. I am using CAS Authentication (via mod_auth_cas) 
for the main site.


Apache httpd.conf
LoadFile /usr/lib/libcurl.so
LoadModule auth_cas_module /usr/lib/apache2/modules/mod_auth_cas.so

CASLoginURL https://cas.myserver.com/cas/login
CASValidateURL https://cas.myserver.com/cas/serviceValidate
CASCertificatePath /etc/ssl/certs/my_cas_bundle.pem
CASCookiePath /var/cache/apache2/mod_auth_cas/
CASSSOEnabled On
CASValidateServer On
CASDebug Off



 
   AuthType CAS
   AuthName " CAS"
 
   Require valid-user


   AllowOverRide None
   Satisfy Any


   AllowOverRide None
   Allow from all
   Satisfy Any


   Order allow,deny
   Allow from all
   Satisfy Any


   Order allow,deny
   Allow from all
   Satisfy Any


Satisfy Any
Allow from all


-Original Message-
From: rt-users-boun...@lists.bestpractical.com 
[mailto:rt-users-boun...@lists.bestpractical.com] On Behalf Of Kevin Falcone
Sent: Wednesday, March 14, 2012 4:49 PM
To: rt-users@lists.bestpractical.com
Subject: Re: [rt-users] rt-mailgate 302 Error. No, not Plack.

On Wed, Mar 14, 2012 at 09:43:47PM +, Jourdan Perla wrote:
> 
> An Error Occurred
> =
> 
> 302 Found
> 
> /usr/bin/rt-mailgate: undefined server error

This is Apache issuing a 302 before it gets to RT

> Grep all my logs for what happens at the same time and
> apache2/access.log:
> rt.myserver.com - - [14/Mar/2012:14:05:33 -0700] "POST 
> /rt/REST/1.0/NoAuth/mail-gateway HTTP/1.1" 302 715 "-" "libwww-perl/6.04"
> 
> I've got the following in my httpd.conf
> 
> 
>AllowOverRide None
>Satisfy Any
> 
> 
>AllowOverRide None
>Allow from all
>Satisfy Any
> 
> 
>Order allow,deny
>Allow from all
>Satisfy Any
> 
> 
>Order allow,deny
>Allow from all
>Satisfy Any
> 

What else do you have in apache.  Are you redirecting from http to https?  
Since you're using the debian packages, what else is going on there.  Also, 
this is where I feel compelled to ask why you're using
3.8 rather than 4.0 for a new install.

-kevin

Re: [rt-users] rt-mailgate 302 Error. No, not Plack.

2012-03-14 Thread Jourdan Perla


> Please - keep list replies on the list.

Sorry, will do.

Thought I had this licked, but now as I build a *clean* production image, I'm 
running into the same error again..

$ cat mbox | /usr/bin/rt-mailgate --queue general --action correspond --url 
http://rt.myserver.com /rt -debug
/usr/bin/rt-mailgate: temp file is '/tmp/Dm_pceG62x'
/usr/bin/rt-mailgate: connecting to 
http://rt.myserver.com/rt/REST/1.0/NoAuth/mail-gateway
An Error Occurred
=

302 Found

/usr/bin/rt-mailgate: undefined server error

Grep all my logs for what happens at the same time and
apache2/access.log:
rt.myserver.com - - [14/Mar/2012:14:05:33 -0700] "POST 
/rt/REST/1.0/NoAuth/mail-gateway HTTP/1.1" 302 715 "-" "libwww-perl/6.04"
mail.info:
Mar 14 14:05:33 RT-PROD-SVR postfix/qmgr[4393]: 17286120B94: 
from=, size=7604, nrcpt=1 (queue active)
mail.info:
Mar 14 14:05:33 RT-PROD-SVR postfix/local[29538]: 88DCB1207CF: 
to=http://rt.myserver.com/REST/1.0/NoAuth/mail-gateway An Error 
Occurred =  302 Found  /usr/bin/rt-mailgate: undefined server 
error )

rt3.log shows nothing but:
[Wed Mar 14 15:56:08 2012] [error]: gpg: error reading key: secret key not 
available (/usr/share/request-tracker3.8/lib/RT/Crypt/GnuPG.pm:2078)
Which is from earlier.

/etc/aliases:
# See man 5 aliases for format
postmaster:myroot
help:  "|/usr/bin/rt-mailgate --queue general --action correspond --url 
http://rt.myserver.com/rt -debug"
comment: "|/usr/bin/rt-mailgate --queue general --action comment --url 
http://rt.myserver.com/rt -debug"


I've got the following in my httpd.conf


   AllowOverRide None
   Satisfy Any


   AllowOverRide None
   Allow from all
   Satisfy Any


   Order allow,deny
   Allow from all
   Satisfy Any


   Order allow,deny
   Allow from all
   Satisfy Any


Logging options in RT_SiteConfig.d
## Logging Options
# From lowest to highest priority, the levels are:
#  debug info notice warning error critical alert emergency
Set($LogToSyslog, 'info');
Set($LogToScreen, 'warning');
# log to /var/log/rt3.log
Set($LogToFile, 'debug');
Set($LogDir, '/var/log');
Set($LogToFileNamed , "rt3.log");


On Fri, Feb 24, 2012 at 10:24:52PM +, Jourdan Perla wrote:
> Fixed it. I was missing an Auth exclusion for the /REST/1.0/NoAuth 
> directory
> 
> As for the RT logs, can't find them. And can't find out where they're 
> configured.

Search in RT_Config.pm for the various Log config options and check their 
documentation.  Then see what you have in your RT_SiteConfig.pm

-kevin

> 
> On 2/24/12 2:15 PM, "Kevin Falcone"  wrote:
> 
> >On Fri, Feb 24, 2012 at 08:54:00PM +, Jourdan Perla wrote:
> >>Install of RT3.8 on Ubuntu 10.4 LTS.
> >>I'm getting that pesky "302 Found" error as I'm trying to push 
> >>mail into my queues using
> >>rt-mailqueue.
> >>I've done the usual Googling and wiki hunts, and I've run out of 
> >>options.
> >>- Aliases are working fine, it's a rt-mailgate error.
> >>- Plack is up to date (0.9985).
> >>- There's no extra '/'. It's finding rt-mailgate fine.
> >>- Not configured for SSL. That's on my to-do list, and if I need 
> >>to bump that up, I will.
> >>Command : /usr/bin/rt-mailgate --queue myqueue --action 
> >>correspond --url
> >>http://myserver.com/rt -debug < test.msg
> >>Output:
> >>/usr/bin/rt-mailgate: temp file is '/tmp/TykSIIvN17'
> >>/usr/bin/rt-mailgate: connecting to 
> >>http://myserver.com/rt/REST/1.0/NoAuth/mail-gateway
> >>An Error Occurred
> >>=
> >>302 Found
> >>/usr/bin/rt-mailgate: undefined server error
> >>Thoughts?
> >
> >What's in the RT logs.
> >
> >What's your test.msg.
> >
> >Also, Plack is only used in RT4
> >
> >-kevin
> >
> >RT Training Sessions 
> >(http://bestpractical.com/services/training.html)
> >* Boston — March 5 & 6, 2012
>

[rt-users] rt-mailgate 302 Error. No, not Plack.

2012-02-24 Thread Jourdan Perla

Install of RT3.8 on Ubuntu 10.4 LTS.

I'm getting that pesky "302 Found" error as I'm trying to push mail into my 
queues using rt-mailqueue.

I've done the usual Googling and wiki hunts, and I've run out of options.
- Aliases are working fine, it's a rt-mailgate error.
- Plack is up to date (0.9985).
- There's no extra '/'. It's finding rt-mailgate fine.
- Not configured for SSL. That's on my to-do list, and if I need to bump that 
up, I will.

Command : /usr/bin/rt-mailgate --queue myqueue --action correspond --url 
http://myserver.com/rt -debug < test.msg
Output:
/usr/bin/rt-mailgate: temp file is '/tmp/TykSIIvN17'
/usr/bin/rt-mailgate: connecting to 
http://myserver.com/rt/REST/1.0/NoAuth/mail-gateway
An Error Occurred
=

302 Found

/usr/bin/rt-mailgate: undefined server error

Thoughts?

RT Training Sessions (http://bestpractical.com/services/training.html)
* Boston  March 5 & 6, 2012

Re: [rt-users] Migration to a new server

Re: [rt-users] request

Re: [rt-users] Lookup of Requestor Custom Field

[rt-users] Lookup of Requestor Custom Field

[rt-users] FW: rt-mailgate 302 Error. No, not Plack.

Re: [rt-users] rt-mailgate 302 Error. No, not Plack.

Re: [rt-users] rt-mailgate 302 Error. No, not Plack.

[rt-users] rt-mailgate 302 Error. No, not Plack.

8 matches

Site Navigation

Mail list logo

Footer information