[rt-users] Custom Field could not be modified

2006-08-31 Thread Arnas Kupsys

Hello everybody,
I have a strange problem with our RT 3.4. I have two queues with same 
rights for groups and with same Custom Fields assigned. One custom field 
has problems when I move ticket from one queue to another. I cannot set 
it anymore. When I change its value its is immediately deleted by 
RT_System. If I move the ticket back to the first queue everything is 
fine. As I told I checked ACLs for queues and for fields everything is 
set OK. Does anybody experienced something like this, and can give me a 
clues where to look at.


Thanks,
Arnas

--
Arnas KUPSYS
Swisscom-Eurospot  IT
Phone:  +41 62 839 6794
Fax:  +41 22 797 6322
Mobile:  +41 79 746 0218
[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


[rt-users] rtTicket/Display.html

2006-08-31 Thread alex nderitu
I recently installed rt3.6 on freeBSD 6.0 from ports collection.
Everything seems to work fine but on clicking on Update Ticket when
reply it I keep getting the error
 Not Found
The requested URL /rt/rtTicket/Display.html was not found on this
server. 

/rt is my alias in my apache webserver. 

Any solutions out there?




___
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] ram usage and mysql processes

2006-08-31 Thread Phil
RT 3.4.2 On Fedora Core 3Recently I have noticed that there are about 12 to 15 mysql processes running on my RT server. Is there a way to limit these processes? I have limited my httpd to 4 processes but I do not know how to limit the mysqld processes? All of the mysqld process are using 
4.5% of the RAM so needless to say it is eating up alot of my ram...Any help would be great...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

Re: [rt-users] extractcustomfields breaks with attachments ?

2006-08-31 Thread Ruslan Zakirov

On 8/30/06, Justin Lim [EMAIL PROTECTED] wrote:


Whenever I have mail attachments its breaking the extractcustomfields.  When
I submit the same email without the attachments it looks like the
extractcustomfields is working fine.

Any suggestions ?

Most probably this extension has problems with selecting a text part
in a multipart email (message with attachments).

--
Best regards, Ruslan.
___
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] MyRT Line 76 error/upgrade error

2006-08-31 Thread Shannon Adams
I restored a 3.4.3 mysql db into 3.6.0.  I am
receiving the line 76 error that has already been
reported.  When I run the upgrade command:

/opt/rt3/sbin/rt-setup-database --action schema \
 --datadir \
/usr/src/build/rt-3.6.0/etc/upgrade/3.5.1 

I receive the following error:

DBI connect('dbname=rt3;host=localhost','',...)
failed: Access denied for user 
root'@'localhost' (using password: NO) at
/opt/rt3/sbin/rt-setup-database line 
169   
 
Use of uninitialized value in concatenation (.) or
string at /opt/rt3/sbin/rt-se
tup-database line 169.

Failed to connect to dbi:mysql:;host=localhost as :
Access denied for user 'root
'@'localhost' (using password: NO) at
/opt/rt3/sbin/rt-setup-database line 169.

Any suggestions on how to get around this error?

Thanks,
Shannon

__
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around 
http://mail.yahoo.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] MyRT Line 76 error/upgrade error

2006-08-31 Thread Jesse Vincent



On Thu, Aug 31, 2006 at 07:30:13AM -0700, Shannon Adams wrote:
 I restored a 3.4.3 mysql db into 3.6.0.  I am
 receiving the line 76 error that has already been
 reported.  When I run the upgrade command:
 
 /opt/rt3/sbin/rt-setup-database --action schema \
  --datadir \
 /usr/src/build/rt-3.6.0/etc/upgrade/3.5.1 
 
 I receive the following error:
 
 DBI connect('dbname=rt3;host=localhost','',...)
 failed: Access denied for user 
 root'@'localhost' (using password: NO) at
 /opt/rt3/sbin/rt-setup-database line 
 169   


The makefile tells you to:

@echo $(RT_SBIN_PATH)/rt-setup-database --dba $(DB_DBA) 
--prompt-for-dba-passwor
d --action schema --datadir etc/upgrade/version
@echo $(RT_SBIN_PATH)/rt-setup-database --dba $(DB_DBA) 
--prompt-for-dba-passwor
d --action acl --datadir etc/upgrade/version
@echo $(RT_SBIN_PATH)/rt-setup-database --dba $(DB_DBA) 
--prompt-for-dba-passwor
d --action insert --datadir etc/upgrade/version
 

You need to spec a username and password. 
___
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] CF Questions

2006-08-31 Thread Todd Chapman
On Thu, Aug 31, 2006 at 09:52:15AM -0400, Hornet wrote:
 Hello,
 
 I added a CF that holds ticket closure codes. My question is, how do I
 make it mandatory to select a code before the status is changed to
 close and make it so no matter how you close the ticket (jumbo, batch,
 single), it must be filled out? My first idea is to make a custom CGI
 that holds the codes and then uses the CLI tool to update and close
 the ticket.
 
 Thanks!

You need to hack the RT API so tht RT::Ticket::SetStatus checks
that the CF is set before it closes the ticket. You may still run 
into trouble if the web UI updates ticket status before it
updates custom fields...

-Todd

___
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 to SCRIPS, Trying to create On Due Date Change

2006-08-31 Thread Eric Sammons
I have been using RT for a bit now; however, I am just now entering the
wonderful world of custom scrips.  It seems there is a lot of information out
there as far as brief comments etc... ;however, I have not been able to find
an example or a document that will assist me in creating my custom scrip.

I was looking to create On Due Date Change, User Defined and then enter in a
custom condition.  My custom condition would be based on a change to the Due
Date field.  Simply looking for pointers, starting point, etc...  RT
Essentials has been little help.  

Any help is appreciated.  -thank you!

--
Open WebMail Project (http://openwebmail.org)

___
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] extractcustomfields breaks with attachments ?

2006-08-31 Thread Dirk Pape

Hello,

--Am 31. August 2006 18:21:18 +0400 schrieb Ruslan Zakirov 
[EMAIL PROTECTED]:



Most probably this extension has problems with selecting a text part
in a multipart email (message with attachments).


ECFV does its best, by using TransactionObj-ContentObj from the RT-API, 
which RT uses itself to select the most appropriate text part of a message 
/ multipart and so on.


to the original poster:

Maybe the message has no text part and matching text in html most probably 
fails because of intervening tags.


Be sure that you have the most recent version of ECFV (1.2b3 from 
http://page.mi.fu-berlin.de/~pape/rt3/ExtractCustomFieldValues.tgz).


There may be another cause as well: I recently observed that ECFV had 
problems with mail which have Content-type Headers with encoded filename 
entries from Outlook. That became better after a patch from you, Ruslan, 
which fixed it partly (regarding international characters in attachment 
filename).


Regards,
Dirk

___
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] RT 3.6.1 CLI--how to pass in a newline

2006-08-31 Thread Jim Brandt


Is there any way to pass in a new line character via the CLI? I'm trying 
to put one in the text field with 'create' and straight in with a 'comment'.


An actual return confuses the shell, and everything else I tried is 
translated literally. \n and br / both just showed up that way in the 
ticket. (It's actually very cool that RT is translating everything 
properly, but I'd like a control character to tell RT that I really want 
a newline.)



Thanks,
Jim


--
Jim Brandt
Administrative Computing Services
University at Buffalo


___
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] ticket with a new queue but requestor still from old queue/group

2006-08-31 Thread Maciak, TJ








Has anyone run into a problem where you have a ticket that has
been assigned to a queue (Queue A) and then given

To an owner who belongs to that group/queue. After
some time, the ticket is then moved to a different queue (Queue B)

But for some reason the owner is the same person from the
first queue (Queue A) even though they do not belong to the

New queue/group (Queue B)? Seems to me like the ticket
should change to Nobody as owner. Maybe this is permission

Issue that I have set up different for one queue/group as
this issue just recently came to my attention and we have been running

RT for a year now.



Any help, thoughts, ideas would be appreciated.



Thank you,



T.J. Maciak



Internet/Intranet Developer
Department of IT
City of Grand Rapids
P: (616)456-3713

F: (616)456-3448









___
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] RT 3.6.1 CLI--how to pass in a newline

2006-08-31 Thread Frank Pater
Hi Jim,

We recently had an application that required us to import data containing 
newlines into our RT instance via the command-line tool. We found that the text 
field of the 'create' option does not accept newlines, however adding an actual 
newline character to a 'comment' does:

[EMAIL PROTECTED] ~]# /opt/rt3/bin/rt  comment -m 'foo
 bar' 40849
Password: 
Message recorded
[EMAIL PROTECTED] ~]# echo $?
0



Sincerely,
Frank Pater
DCANet
http://www.dca.net
voice: 888-4-DCANET (888-432-2638)
fax: 302-426-6386


On Thu, Aug 31, 2006 at 12:07:00PM -0400, Jim Brandt wrote:
 
 Is there any way to pass in a new line character via the CLI? I'm trying 
 to put one in the text field with 'create' and straight in with a 'comment'.
 
 An actual return confuses the shell, and everything else I tried is 
 translated literally. \n and br / both just showed up that way in the 
 ticket. (It's actually very cool that RT is translating everything 
 properly, but I'd like a control character to tell RT that I really want 
 a newline.)
 
 
 Thanks,
 Jim
 
 
 -- 
 Jim Brandt
 Administrative Computing Services
 University at Buffalo
 
 
 ___
 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


pgpwFzwDaDgWy.pgp
Description: 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] RT 3.6.1 CLI--how to pass in a newline

2006-08-31 Thread der Mouse
 Is there any way to pass in a new line character via the CLI?  [...]

 An actual return confuses the shell,

This is a shell problem, then, and should be addressed as such.  Every
shell I've used has a way to get a newline into a command argument -
though it's not always easy to find.  Which shell do you use?

/~\ The ASCII   der Mouse
\ / Ribbon Campaign
 X  Against HTML   [EMAIL PROTECTED]
/ \ Email!   7D C8 61 52 5D E7 2D 39  4E F1 31 3E E8 B3 27 4B
___
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] Test::Expect 0.30...MISSING

2006-08-31 Thread Shannon Adams
Trying to resolve 3.6.1 dependencies on Fedora Core 4.
 I am down to this one.  I cannot seem to find it with
yum or cpan.  I can only find an rpm for fc5.  Has
anyone had luck with this one on FC4?  

Thanks,
Shannon

__
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around 
http://mail.yahoo.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] Test::Expect 0.30...MISSING

2006-08-31 Thread Todd Chapman
On Thu, Aug 31, 2006 at 09:26:48PM -0700, Shannon Adams wrote:
 Trying to resolve 3.6.1 dependencies on Fedora Core 4.
  I am down to this one.  I cannot seem to find it with
 yum or cpan.  I can only find an rpm for fc5.  Has
 anyone had luck with this one on FC4?  
 

You won't need it unless you are going to run RT's
regression tests. But it is on CPAN:

http://search.cpan.org/author/LBROCARD/Test-Expect-0.30/lib/Test/Expect.pm
___
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] Does formatting a saved search have to be this *%!%! painful?

2006-08-31 Thread Ole Craig

I'm creating a dashboard of saved searches for my boss and the rest of
the company's executive team in our 3.6.0 installation. I started with
some already-saved searches which I can use to get at the info I need,
but wanted to add particular fields in particular places in the search
results screen, and in general rearrange the format to have the info
appear just-so for my not-very-pointy-haired friends. Each search has
about 12 columns, and I'm about ready to scream!

Is there any way to get a new field in a search to appear in the second
column of a multicolumn search OTHER THAN this cripplingly repetitive
process:

 1. select field under display columns
 2. select title, format, size, and style, and click -
 3. grab scrollbar in show columns, drag to bottom, select new
field, click ^ (uparrow)
 4. grab scrollbar in show columns, drag down, find new field (now
second from bottom), click ^
 5. grab scrollbar in show columns, drag down, find new field (now
third from bottom), click ^
 6. grab scrollbar in show columns, drag down, find new field (now
4th from bottom), click ^
[...] 

I'm hastening RSI onset with this... if this is the only way (short of
direct DB manipulation) to do it, this interface seriously needs to
change. 

Ok, I'm done venting, but lord there has to be a better way. Any UI
hackers out there already solved this? Or am I just incredibly dense and
missed the obvious?

-- 
/Ole Craig
Security Engineer
Team lead, customer support

303-381-3802 (main support hotline)
303-381-3824 (my direct line)
303-381-3801 (fax)

www.stillsecure.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