Re: [rt-users] Documentation.

2008-01-15 Thread Benjamin Weser
There's a very good user's documentation at 
http://www.css.washington.edu/wiki/Category:Request_Tracker which I 
chose to adapt for our internal documentation. You should have a look at 
the topics How To and Using RT.


Tom H schrieb:

Deepika Bhatia wrote:
  

Is there any users manual and administrators manual available for RT?





Hi,

We are currently writing end user documentation for RT, and it would
really help to see what has been done before. If you care to share ;-)

Many Thanks,

Tom
___
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
  


___
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


[rt-users] Sorting Saved Reports on Custom Fields

2008-01-15 Thread Darren Ellis

Hi All,

I have RT 3.6.5 and everything seems to be working well, except  
sorting on ticket custom fields.  I have an appointment date field and  
we store data in mmdd format.  I've set a saved search to display  
that field, and set it as the first sort, ascending.  Showing results  
gives the tickets in ID order even though I've specified a different  
order.


Is there a step that I have skipped?

Thanks.

Darren

Darren Ellis
[EMAIL PROTECTED]
Office: (207) 376-0137, x2201
Mobile: (207) 841-4000




--
This message has been scanned for viruses and
dangerous content by MailScanner, and is
believed to be clean.

___
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


[rt-users] New appearence of "create a new ticket"

2008-01-15 Thread Marie-Noelle Dauphin
HEllo
We would like not to have "status entry list" when select  "create a new ticket"


But we would like to have the value "new" as default when we push "create" 
button.

how could we do that ? with a callback ?
thanks for your response
MArie-Noelle
___
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


[rt-users] New appearence of "create a new ticket"

2008-01-15 Thread Marie-Noelle Dauphin

HEllo
We would like not to have "status entry list" when select  "create a new ticket"
___
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


Re: [rt-users] Documentation.

2008-01-15 Thread Jesse Vincent


Those of you who have built local user documentation for RT - would you
be interested in collaborating on an open RT user/admin guide to help
replace what's on the wiki and in RT Essentials? 

Whatever gets build can obviously tweaked for your local environment,
but the advantage of having other organizations contributing to a shared
guide is that it will be semi-magically kept up to date as RT continues
to grow and evolve.

Best Practical can, of course, provide mailing lists, version control
and all the rest of what you need. 

Best,

Jesse
___
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


[rt-users] Create Ticket on Resolve, but only if Custom Field is....

2008-01-15 Thread Matt Westfall

-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1

OK, I am getting ever so closer to getting this to work.

I have two Custom Fields:  Billable and Followup.

I want to create a followup ticket if Followup is Yes.
I want to create an invoice ticket if Billable is Yes/Covered/or/Gratis

Here is my Billable scrip code:

Condition User Defined
Action Create Tickets
Template Global Template Create-Invoice

return 0 unless $self->TransactionObj->Type eq "Resolved";
return 0 unless $self->TicketObj->FirstCustomFieldValue('Billable') =~
/Yes/i;
return 0 unless $self->TicketObj->FirstCustomFieldValue('Billable') =~
/Covered/i;
return 0 unless $self->TicketObj->FirstCustomFieldValue('Billable') =~
/Gratis/i;
$RT::Logger->debug("Scrip running");
1;

and the Billable Template:

===Create-Ticket: generate-invoice
Queue:  Accounting
Subject: Invoice: { $Tickets{'TOP'} -> Subject() }
Requestor: {$Tickets{'TOP'}->OwnerObj->EmailAddress() }
RefersTo:  {$Tickets{'TOP'}->Id() }
Content: Please generate an invoice for this customer.
Billable was set to:
{$Tickets}{'TOP'}->TicketObj->FirstCustomFieldValue('Billable')}

Billable hours was set to:
{$Tickets}{'TOP'}->TicketObj->FirstCustomFieldValue('Billable Hours')}
Please refer to previous ticket for more information.
ENDOFCONTENT

For Followup:

Condition User Defined
Action Create Ticket
Template Global Template Generate-Followup

===Create-Ticket: generate-followup
Queue:  Customer Service
Subject: Invoice: { $Tickets{'TOP'} -> Subject() }
Requestor: {$Tickets{'TOP'}->OwnerObj->EmailAddress() }
RefersTo:  {$Tickets{'TOP'}->Id() }
Content: A follow up was requested on this ticket.  Please refer to
previous ticket for more information.
ENDOFCONTENT


When I resolve a ticket which has Yes in both fields, there are various
entries in the /var/log/messages, but none of them refer to scrip 22 or 23.

~From the RT_Config.pm debug messages should go to syslog or
/var/log/messages, but nothing is mentioned there.

I would greatly appreciate any help in finally nailing this down.


-BEGIN PGP SIGNATURE-
Version: GnuPG v1.4.7 (MingW32)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iD8DBQFHjMGPb/8X6V5MpAURAibmAKCzs+POmDswCQejfgv+GXFGmx5iRACg46ov
GIJZuWBqEqytMaeGjzMN9uU=
=i6ZE
-END PGP SIGNATURE-
___
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


Re: [rt-users] Customer Service Workflow

2008-01-15 Thread Jesse Vincent



On Mon, Jan 14, 2008 at 05:50:57PM -0500, Steve Cochran wrote:
> 
> One of the problems is that any ticket that is closed but responded to  
> is also owned by the first person to respond. So even if the logout  
> code cleared any tickets they owned, more worried about tickets that  
> become owned when they aren't there.

You could set up a custom scrip to set the owner to "nobody" on
resolution.  The only thing you might run into there is a reporting
issue, but there's no data loss. You could still dig everything out of
the transactions table.

Another option might be to set up a cron job that looks at open tickets 
which haven't been replied to in x hours and sends an alert message and
sets their owners to nobody.

Best,
Jesse

> Steve

PS Your products rock. I use them all the time ;)
___
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


[rt-users] sessions table myisam or innodb

2008-01-15 Thread Roy El-Hames

Hi;

rt-3.6.3
apache2
mysql5.1

For better performance should the sessions table be myisam or innondb??
had a look in etc/schema.mysql and there is no engine type definition 
for sessions
currently my sessions table is myisam, every now and then rt freezes due 
to user lock on the session table. To keep it small, I have a script 
that delete expired sessions every 6 hours. however I am wondering if 
this is causing another problem with concurrent inserts due to deleted 
rows in the middle of the table  ?/ any suggestion.


Regards
Roy
___
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


Re: [rt-users] Customer Service Workflow

2008-01-15 Thread Steve Cochran


I was referring to what happens when a customer responds to a ticket  
marked closed. If I own a ticket, respond and mark it closed, if the  
user responds again it will be reopened and still be owned by me.



Most of our email requests from customers require only a single  
response. So one thought I've had is to create a scrip that  
automatically marks a request closed with every response. Then create  
another scrip that triggers if a ticket is reopened that changes the  
owner to nobody.


Not all of those triggers and actions are already defined, but it  
shouldn't be too hard to code them.


Steve



On Jan 14, 2008, at 11:01 PM, Todd Chapman wrote:


I don't follow.

On 1/14/08, Steve Cochran <[EMAIL PROTECTED]> wrote:

One of the problems is that any ticket that is closed but responded to
is also owned by the first person to respond. So even if the logout
code cleared any tickets they owned, more worried about tickets that
become owned when they aren't there.

Steve

On Jan 14, 2008, at 11:58 AM, Todd Chapman wrote:

> You could have the person log out of RT before they leave. Then have
> the RT logout code give all that person's tickets to Nobody.

___
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



___
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

[rt-users] Mysqldump 3.6.3 -> 3.6.5 ( attachments )

2008-01-15 Thread Roy Sowa
I am in the process of moving my existing RedHat 3.6.3 install to a SUSE 10 
3.6.5 box ...
I thought all was going well, but I just stumbled into a problem...

I had been using  the following mysqldump ;
mysqldump --opt --add-drop-table --single-transaction  rt3 > backup.out

and this restores nicely.. ( I thought I was good to go ). 
the records look correct and I see the attachment links in the tickets that 
have them, But
now when I try and view an attachment  by clicking on the link  it says "page 
not found"
the url link matches the search format of that of the original working server 
...

what I have tried so far...

A few searches surfaced that I might try adding this to my dump statement 
"--default-character-set=binary"

but this did not change things...

Trying to create a new ticket with a simple attachment also does not work
Funny enough If I attach a simple gif, I see the gif in the newly created 
ticket, however I just cannot click on the download link in the transaction  or 
the link in the attachment area... ( page not found...)

So then I found this snippet  RE: binary attachment corruption; 

Hello, Chris. 
Could you backup your DB, and run next to SQL queries? 
ALTER TABLE Attachments CHANGE Content Content LONGBLOB NULL; 
Then check if you could binary attachments without problems and report back. 
This query is safe but anyway I would suggest you to backup data. .


This did not change results either...

I really would like to convert  to the newer server/hardware 

any suggestions as to where I went wrong or how to move this forward ???

___
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


Re: [rt-users] Documentation.

2008-01-15 Thread Kenneth Crocker

Jesse,

	Yes, we would be glad to. We have a RT User's Guide and an RT Queue 
Admin Guide. Do you want me to send it to you or what?
	We are also have developed scrips/templates for an alternative (to 
RT's) "Approvals" workflow that involves a Ticket Collection Queue where 
tickets are reviewed/prioritised/approved/rejected and then moved to the 
appropriate support queue for work. The ticket numbers stay the same and 
all notifications and ticket status promotions/update are automatic upon 
update of the CF used for approval. If anyone is interested, they can 
contact me and I will forward the work, if it is close to their 
requirements.

Jesse, thanks for the help.


Kenn
LBNL

On 1/15/2008 6:05 AM, Jesse Vincent wrote:


Those of you who have built local user documentation for RT - would you
be interested in collaborating on an open RT user/admin guide to help
replace what's on the wiki and in RT Essentials? 


Whatever gets build can obviously tweaked for your local environment,
but the advantage of having other organizations contributing to a shared
guide is that it will be semi-magically kept up to date as RT continues
to grow and evolve.

Best Practical can, of course, provide mailing lists, version control
and all the rest of what you need. 


Best,

Jesse
___
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




___
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


Re: [rt-users] Mysqldump 3.6.3 -> 3.6.5 ( attachments )

2008-01-15 Thread James Moseley
Your mysqldump syntax looks fine, although depending on the version you are
running, the 'add-drop-table' argument is redundant since you are using
'opt'.

To rule out a DB problem, have you tried using your 3.6.5 SUSE instance of
RT with the DB sitting on the RedHat box?  If you get the same behavior,
then I think it's safe to say you probably don't have a DB problem but
something else wrong - missing perl module, apache fastcgi/mod_perl issue,
database/RT permissions, etc.

Have you looked at the RT or Apache logs yet?


James Moseley




   
 "Roy Sowa"
 <[EMAIL PROTECTED] 
 c.gc.ca>   To 
 Sent by:
 rt-users-bounces@  cc 
 lists.bestpractic 
 al.comSubject 
   [rt-users] Mysqldump 3.6.3 -> 3.6.5 
   ( attachments ) 
 01/15/2008 12:36  
 PM
   
   
   
   




I am in the process of moving my existing RedHat 3.6.3 install to a SUSE 10
3.6.5 box ...
I thought all was going well, but I just stumbled into a problem...

I had been using  the following mysqldump ;
mysqldump --opt --add-drop-table --single-transaction  rt3 >
backup.out

and this restores nicely.. ( I thought I was good to go ).
the records look correct and I see the attachment links in the tickets that
have them, But
now when I try and view an attachment  by clicking on the link  it says
"page not found"
the url link matches the search format of that of the original working
server ...

what I have tried so far...

A few searches surfaced that I might try adding this to my dump statement
"--default-character-set=binary"

but this did not change things...

Trying to create a new ticket with a simple attachment also does not
work
Funny enough If I attach a simple gif, I see the gif in the newly created
ticket, however I just cannot click on the download link in the transaction
or the link in the attachment area... ( page not found...)

So then I found this snippet  RE: binary attachment corruption;

Hello, Chris.
Could you backup your DB, and run next to SQL queries?
ALTER TABLE Attachments CHANGE Content Content LONGBLOB NULL;
Then check if you could binary attachments without problems and report
back.
This query is safe but anyway I would suggest you to backup data. .


This did not change results either...

I really would like to convert  to the newer server/hardware

any suggestions as to where I went wrong or how to move this forward ???

___
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


___
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


[rt-users] Vanishing attachment content

2008-01-15 Thread Justin Pratt
Tickets created from email with attachments something like:

--080002000901040106020609
Content-Type: message/rfc822;
 name="attachment.eml"
Content-Transfer-Encoding: base64
Content-Disposition: inline;
 filename="attachment.eml"

Received: ...
x-mimeole: Produced By Microsoft Exchange V6.0.6603.0
content-class: urn:content-classes:message
MIME-Version: 1.0
Content-Type: multipart/alternative;
boundary="_=_NextPart_001_01C85484.BABB2102"
Subject: ...
Date: Fri, 11 Jan 2008 11:04:02 -0800
Message-ID: ...
X-MS-Has-Attach: 
X-MS-TNEF-Correlator: 
Thread-Topic: H8DA3-2 On-Board SAS Feature
Thread-Index: AchUbJG5vOK/tePKTaKLVSrvzFFIowAFYhCg
From: ...
To: ...
Cc: ...
X-SpamReason: Bypass=B

VGhpcyBpcyBhIG11bHRpLXBhcnQgbWVzc2FnZSBpbiBNSU1FIGZvcm1hdC4NCg0KLS0tLS0t
Xz1fTmV4dFBhcnRfMDAxXzAxQzg1NDg0LkJBQkIyMTAyDQpDb250ZW50LVR5cGU6IHRleHQv
cGxhaW47DQoJY2hhcnNldD0idXMtYXNjaWkiDQpDb250ZW50LVRyYW5zZmVyLUVuY29kaW5n
OiBxdW90ZWQtcHJpbnRhYmxlDQoNCkhpIENhcm9saW5hLA0KDQo9MjANCg0KVGhlIFBDSS1F
...


are not only not decoded inline, but the content has vanished. The
header shows up, but I can't even view the encoded data. Is there a
problem with base64 decoding? Any suggestions?

Thanks,
Justin
___
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


[rt-users] Repeat login requests under FreeBSD

2008-01-15 Thread Yitzchak Schaffer

Greetings all --

I managed to get RT 3.6.5 running under FreeBSD 6.2, MySQL and Apache 
2.2 with mod_perl via the rt36, mysql50-server, apache22, and mod_perl2 
ports.  When I fire up Apache and login as root, I can follow links, but 
I have to re-enter the login at each link.  I'm using Firefox 2.0.0.11 
and IE6, and I see a cookie called RT_SID_..


I didn't encounter this problem when I installed from RT source under 
Debian with comparable packages and config settings.  Any ideas?


Many thanks,
--
Yitzchak Schaffer
Systems Librarian
Touro College Libraries
33 West 23rd Street
New York, NY 10010
Tel (212) 463-0400 x230
Fax (212) 627-3197
[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

Re: [rt-users] Repeat login requests under FreeBSD

2008-01-15 Thread Kenneth Crocker

Yitzchak,


	I have just gone thru this problem. Believe it or not, it is easy to 
fix. The answer came to me from someone who uses RT and is an Apache 
expert. You need to specify a tighter control (Transaction) over your 
session locks. Are you using the DataBase session record or file?


Kenn
LBNL

On 1/15/2008 12:31 PM, Yitzchak Schaffer wrote:

Greetings all --

I managed to get RT 3.6.5 running under FreeBSD 6.2, MySQL and Apache 
2.2 with mod_perl via the rt36, mysql50-server, apache22, and mod_perl2 
ports.  When I fire up Apache and login as root, I can follow links, but 
I have to re-enter the login at each link.  I'm using Firefox 2.0.0.11 
and IE6, and I see a cookie called RT_SID_..


I didn't encounter this problem when I installed from RT source under 
Debian with comparable packages and config settings.  Any ideas?


Many thanks,
--
Yitzchak Schaffer
Systems Librarian
Touro College Libraries
33 West 23rd Street
New York, NY 10010
Tel (212) 463-0400 x230
Fax (212) 627-3197
[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


___
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


Re: [rt-users] Repeat login requests under FreeBSD

2008-01-15 Thread Yitzchak Schaffer

Kenneth:

Thanks for the help.  I haven't changed from whatever the default is; I 
copied RT_Config.pm to RT_SiteConfig.pm and made some local changes.  
From there the setting appears to be DB, as ::File is commented out:


# $WebSessionClass is the class you wish to use for managing Sessions.
# It defaults to use your SQL database, but if you are using MySQL 3.x and
# plans to use non-ascii Queue names, uncomment and add this line to
# RT_SiteConfig.pm will prevent session corruption.

# Set($WebSessionClass , 'Apache::Session::File');


Yitzchak Schaffer
Systems Librarian
Touro College Libraries
33 West 23rd Street
New York, NY 10010
Tel (212) 463-0400 x230
Fax (212) 627-3197
[EMAIL PROTECTED]


Kenneth Crocker wrote:

Yitzchak,


I have just gone thru this problem. Believe it or not, it is easy 
to fix. The answer came to me from someone who uses RT and is an 
Apache expert. You need to specify a tighter control (Transaction) 
over your session locks. Are you using the DataBase session record or 
file?
___
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

Re: [rt-users] Repeat login requests under FreeBSD

2008-01-15 Thread Matthew Seaman
Yitzchak Schaffer wrote:
> Greetings all --
> 
> I managed to get RT 3.6.5 running under FreeBSD 6.2, MySQL and Apache
> 2.2 with mod_perl via the rt36, mysql50-server, apache22, and mod_perl2
> ports.  When I fire up Apache and login as root, I can follow links, but
> I have to re-enter the login at each link.  I'm using Firefox 2.0.0.11
> and IE6, and I see a cookie called RT_SID_..
> 
> I didn't encounter this problem when I installed from RT source under
> Debian with comparable packages and config settings.  Any ideas?
> 
> Many thanks,
> 

I have much the same setup you do -- I found this fix on the list:

ALTER TABLE sessions MODIFY a_session longblob ;

which worked for me.

See: http://lists.bestpractical.com/pipermail/rt-users/2006-July/040411.html

Cheers,

Matthew

-- 
Dr Matthew Seaman The Bunker, Ash Radar Station
PGP: 0x60AE908C on serversMarshborough Rd
Tel: +44 1304 814800  Sandwich
Fax: +44 1304 814899  Kent, CT13 0PL, UK



signature.asc
Description: OpenPGP digital signature
___
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

Re: [rt-users] Repeat login requests under FreeBSD

2008-01-15 Thread Yitzchak Schaffer
When I make that change and restart Apache, I see the following in 
/var/logs/httpd-error.log:


[Wed Jan 16 02:25:33 2008] [notice] caught SIGTERM, shutting down
[Wed Jan 16 02:25:53 2008] [error] Insecure dependency in unlink while 
running with -T switch at /usr/local/lib/perl5/5.8.8/File/Path.pm line 
267.\nCompilation failed in require at (eval 6) line 1.\n
[Wed Jan 16 02:25:53 2008] [error] Can't load Perl file: 
/usr/local/rt3/bin/webmux.pl for server libtest.touro.edu:0, exiting...


Yitzchak Schaffer
Systems Librarian
Touro College Libraries
33 West 23rd Street
New York, NY 10010
Tel (212) 463-0400 x230
Fax (212) 627-3197
[EMAIL PROTECTED]


Matthew Seaman wrote:

ALTER TABLE sessions MODIFY a_session longblob ;
___
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

[rt-users] Hide custom field in create.html

2008-01-15 Thread . .
Hello,

I'm using RT 3.6.1, and need to hide a particular custom field from the ticket 
creation process.  This field is still needed by all users, so I can't use the 
'see custom field' permission - otherwise users won't be able to see it in the 
ticket display.  

Any suggestions would be much appreciated. 
.
 
_
Get the power of Windows + Web with the new Windows Live.
http://www.windowslive.com?ocid=TXT_TAGHM_Wave2_powerofwindows_012008___
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

Re: [rt-users] Repeat login requests under FreeBSD

2008-01-15 Thread Yitzchak Schaffer
Heh, fixed - in trying to set up mod_perl earlier, I followed a howto 
that mentioned using taint mode - which doesn't work with the Session 
modules.  Now all appears to be shipshape.  Thanks for your help!


Yitzchak Schaffer
Systems Librarian
Touro College Libraries
33 West 23rd Street
New York, NY 10010
Tel (212) 463-0400 x230
Fax (212) 627-3197
[EMAIL PROTECTED]


Yitzchak Schaffer wrote:
When I make that change and restart Apache, I see the following in 
/var/logs/httpd-error.log:


[Wed Jan 16 02:25:33 2008] [notice] caught SIGTERM, shutting down
[Wed Jan 16 02:25:53 2008] [error] Insecure dependency in unlink while 
running with -T switch at /usr/local/lib/perl5/5.8.8/File/Path.pm line 
267.\nCompilation failed in require at (eval 6) line 1.\n
[Wed Jan 16 02:25:53 2008] [error] Can't load Perl file: 
/usr/local/rt3/bin/webmux.pl for server libtest.touro.edu:0, exiting...


Yitzchak Schaffer
Systems Librarian
Touro College Libraries
33 West 23rd Street
New York, NY 10010
Tel (212) 463-0400 x230
Fax (212) 627-3197
[EMAIL PROTECTED]


Matthew Seaman wrote:

Yitzchak Schaffer wrote:
  

Greetings all --

I managed to get RT 3.6.5 running under FreeBSD 6.2, MySQL and Apache
2.2 with mod_perl via the rt36, mysql50-server, apache22, and mod_perl2
ports.  When I fire up Apache and login as root, I can follow links, but
I have to re-enter the login at each link.  I'm using Firefox 2.0.0.11
and IE6, and I see a cookie called RT_SID_..

I didn't encounter this problem when I installed from RT source under
Debian with comparable packages and config settings.  Any ideas?

Many thanks,




I have much the same setup you do -- I found this fix on the list:

ALTER TABLE sessions MODIFY a_session longblob ;

which worked for me.

See: http://lists.bestpractical.com/pipermail/rt-users/2006-July/040411.html

Cheers,

Matthew

  
___
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

[rt-users] Mysqldump 3.6.3 -> 3.6.5 ( attachments )

2008-01-15 Thread Roy Sowa
The Issue does  not seem to be a result of the dumping/moving of the data, but 
instead now seems to be due to a missing trailing slash when I click on the 
attachment link on a ticket.
  If I manually add that trailing slash the attachment is indeed there.
  I am using lighttpd, my lighttpd.conf does have this ...
 
 server.document-root= "/"
  url.redirect = (
 "^/(.*)" => "https://MySERVERNAMEHERE/$1";
 
 
and my RT_SiteConfig has this;
 
Set($WebPort , 443); 
Set($WebBaseURL , "https://MyServerName:$WebPort";);
Set($WebPath , "");
Set($WebURL , $WebBaseURL . $WebPath . "/"); 
 
 
I have tried adding a trailing slash to the lighttpd.conf, cleared Mason and 
restarted
Still scratching my head though...
 

___
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

[rt-users] Mysqldump 3.6.3 -> 3.6.5 ( attachments ) Resolved

2008-01-15 Thread Roy Sowa
Sorry for the confusing post, ( stumbling as I learn )
 
  To fix my issue I have added a url rewrite to my lighttpd.conf to ensure that 
a trailing slash is added when an 
attachment link is followed;
url.rewrite = (
  "^(.*)/Ticket/Attachment/(.*)" => "/$1/Ticket/Attachment/$2/"
)
 
Now things seem to be back on track.
 
Thanks for your patience
 Roy
 
 
 
 
The Issue does  not seem to be a result of the dumping/moving of the data, but 
instead now seems to be due to a missing trailing slash when I click on the 
attachment link on a ticket.
  If I manually add that trailing slash the attachment is indeed there.
  I am using lighttpd, my lighttpd.conf does have this ...

server.document-root= "/"
  url.redirect = (
 "^/(.*)" => "https://MySERVERNAMEHERE/$1"; ( 'https://myservernamehere/$1";' 
)


and my RT_SiteConfig has this;

Set($WebPort , 443); 
Set($WebBaseURL , "https://MyServerName:$WebPort"; ( 
'https://myservername:$WebPort"/' ));
Set($WebPath , "");
Set($WebURL , $WebBaseURL . $WebPath . "/"); 


I have tried adding a trailing slash to the lighttpd.conf, cleared Mason and 
restarted
Still scratching my head though...
 
___
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

[rt-users] Disable Auto reply message for a group

2008-01-15 Thread Sean McCreadie
Hello,

 

I've been looking through the wiki and mailing lists trying to find a
solution to this with no success.  I'm sure it's very simple, I'm just
new to this.  I need to disable the default Auto reply scrip for only my
Helpdesk team, that way all the unprivileged users will still receive
the Auto reply, but not the HelpDesk team when they create a ticket.  I
tried adding this custom condition to the default scrip and was able to
disable it for one email address, but im hoping there is an easy way to
check group membership.  Thanks in advance for all the help.

 

if ( $self->TransactionObj->Type eq "Create" && 

 $self->TicketObj->RequestorAddresses() =~ /[EMAIL PROTECTED]/ 

{ 

  return undef;

} else {

  return 1;

 

 

 

Sean McCreadie

IT Support

Canyon Partners, LLC

310 858 4288

 

___
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