[rt-users] Links are not clickable

2007-08-08 Thread Firas Batal \(QA/EMC\)
Hi everyone, I am wondering whether there is someone there who could help. This is the summary of the problem: Links are not clickable after I have changed the Default RT at a Glance. I am running RT 3.6.3, Perl v5.8.3 under Linux (FC6), and MySql 5.0.27. This is not a production

Re[2]: [rt-users] Attachments table of RT's Mysql database

2007-08-08 Thread Boris Lytochkin
Wiki would be enough, but there is a problem in current patch state: it uses special constant string inplace of real content to indicate that file is located out of DB. Right way is to use flag in table. I do not think that changing scheme witch patching is a good idea, that is why this patch

[rt-users] Pg database connection - authentication failed

2007-08-08 Thread Gary Stainburn
Hi folks. I've just had to move my RT3 install onto a new box and all's going well until I try to use it. When I try to bring the login page up I get Internal Server Error. The log file shows: [Wed Aug 08 11:18:06 2007] [error] [client 10.1.1.118] Connect Failed FATAL: password

Re: [rt-users] Trying to change the logo. Fedora Core 7, RT3.6.3 yum install

2007-08-08 Thread Joe Casadonte
On 8/7/2007 5:20 AM, Luke E Morgan wrote: I'm sure I'm just missing something simple, but I cannot seem to change the BP logo on my install of RT 3.6.3 on Fedora Core 7. I've installed RT using yum (lazy I know, but it works apart from this issue). It has been installed into /usr/share/rt3

Re: [rt-users] History Display for a Ticket

2007-08-08 Thread Joe Casadonte
On 8/7/2007 1:01 PM, Scott T. Hildreth wrote: If I query the Transactions table, selecting only transactions for this ticket that were created by non-RT::System ids, there are 29. All of type RT::Ticket. If unset the $OldestTransactionsFirst, the history on the display

Re: [rt-users] Links are not clickable

2007-08-08 Thread Joe Casadonte
On 8/7/2007 2:21 PM, Firas Batal (QA/EMC) wrote: This is the summary of the problem: Links are not clickable after I have changed the Default RT at a Glance. I am running RT 3.6.3, Perl v5.8.3 under Linux (FC6), and MySql 5.0.27. This is not a production site, but rather an experimental PC

Re: [rt-users] How does RT perform login?

2007-08-08 Thread Kevin Falcone
On Jul 26, 2007, at 6:53 AM, Jörg Ungermann wrote: What is the mechanism of logging a user in? Is it sufficient to have - a valid session in the sessions table - a valid cookie matching the session? to access RT via Browser? Can a session be hijacked this way? We are looking for a way to

Re: [rt-users] RT-3.6.4 ShowTransaction

2007-08-08 Thread Kevin Falcone
On Jul 31, 2007, at 6:58 AM, Roy El-Hames wrote: Hi; line 151 in ShowTransaction there is: my $aid = is that a bug else what ist used for, I can't find any other reference to $aid anywhere else .. Hi Roy It looks like it was an accidental commit with some changes a few lines down. It is

Re: [rt-users] History Display for a Ticket

2007-08-08 Thread Scott T. Hildreth
On Wed, 2007-08-08 at 08:28 -0400, Joe Casadonte wrote: On 8/7/2007 1:01 PM, Scott T. Hildreth wrote: If I query the Transactions table, selecting only transactions for this ticket that were created by non-RT::System ids, there are 29. All of type RT::Ticket. If

Re: [rt-users] Custom Fields and Rights Question / maybe a bug

2007-08-08 Thread Ruslan Zakirov
On 8/8/07, Ham MI-ID, Torsten Brumm [EMAIL PROTECTED] wrote: Hi RT Users, Developers, i'm not 100% sure if this is a bug or if i'm again too dumb... For a Custom Field, I can grant the following Group Rights: SeeCustomField ModifyCustomField AdminCustomField From my point of

Re: Re[2]: [rt-users] Attachments table of RT's Mysql database

2007-08-08 Thread Jesse Vincent
On Aug 8, 2007, at 5:17 AM, Boris Lytochkin wrote: Wiki would be enough, but there is a problem in current patch state: it uses special constant string inplace of real content to indicate that file is located out of DB. Right way is to use flag in table. I do not think that changing scheme

Re: [rt-users] Trying to change the logo. Fedora Core 7, RT3.6.3 yum install

2007-08-08 Thread Luke E Morgan
Thanks for the suggestion. Unfortunately it doesn't seem to have helped. I've now set /usr/local/rt3/html/Elements/Logo to read : a href=%$RT::WebBaseURL%img src=%$RT::WebImagesURL%mtllogo.jpg alt=Intranet width=92 height=50 //a Stopped apache, cleared the mason cache, (rm -rf

[rt-users] Another rights question

2007-08-08 Thread Benjamin Weser
Hi everybody, just saw the request of Torsten and Ruslan's answer to it. I have a similar situation (bug??) here: A user with the rights CreateTicket ReplyTicket SeeQueue ShowTicket Watch can create a ticket but also set Status and the Owner while creating the ticket. In the mail list I've

Re[4]: [rt-users] Attachments table of RT's Mysql database

2007-08-08 Thread Boris Lytochkin
Wednesday, August 8, 2007, 6:22:31 PM, you wrote: This might be a good place to use the ContentEncoding field to describe an 'ondisk' encoding. How do you expect to use this filed? Something like '(ondisk|inDB),(base64|quoted-printable|...)'? On Aug 8, 2007, at 5:17 AM, Boris Lytochkin

Re: [rt-users] Trying to change the logo. Fedora Core 7, RT3.6.3 yum install

2007-08-08 Thread Luke E Morgan
James, Thanks for pointing that out. I was following some instructions somewhere in setting that up. If I can find them, and I didn't just follow them wrong, then I'll correct them ! Unfortunately, your suggestion hasn't fixed my problem, but has got me thinking along different lines. I noticed

Re: [rt-users] Trying to change the logo. Fedora Core 7, RT3.6.3 yum install

2007-08-08 Thread Joe Casadonte
On 8/8/2007 10:25 AM, Luke E Morgan wrote: Started up apache again, and it still displays the Best Practical logo. Try logging out and logging back in. -- Regards, joe Joe Casadonte [EMAIL PROTECTED] == == == The statements

Re: [rt-users] Trying to change the logo. Fedora Core 7, RT3.6.3 yum install

2007-08-08 Thread James Moseley
I would assume /usr/local/lib/rt3 exists? Is /usr/share/rt3 simply a symbolic link to /usr/local/lib/rt3? If RT is actually installed in /usr/local/lib, then see if /usr/local/lib/rt3/local/html exists. Lastly, check your Apache config and logs to see where RT is pulling the RT logo from.

Re: [rt-users] Trying to change the logo. Fedora Core 7, RT3.6.3 yum install

2007-08-08 Thread Luke E Morgan
It appears to be almost fixed now. The system configuration on the web interface has this line : RT::LocalPath /usr/local/lib/rt3 so I created /usr/local/lib/rt3/html/Elements/Logo and made that use the local logo that I wanted. Cleared the mason cache, restarted Apache and it worked !! I

AW: Re: [rt-users] Custom Fields and Rights Question / maybe a bug

2007-08-08 Thread Ham MI-ID, Torsten Brumm
Hi ruslan, Yes for a normal cf this is not critical, but together with a cf set to mandatory this becomes critical, because the user is not able to create a ticket via gui anymore for this queue :-( Torsten -Original Message- From: [EMAIL PROTECTED] [EMAIL PROTECTED] To: Ham MI-ID,

RE: Re[4]: [rt-users] Attachments table of RT's Mysql database

2007-08-08 Thread Schincke, Keith D. (JSC-IT)[MEI]
You could do that or just have 'ondisk' be a new encoding type added at the end of the list. The Content field of the data base could store the path to the file relative to a config option. I would suggest a file size threshold option if RT starts using the file system to store attachements.

Re: Re[4]: [rt-users] Attachments table of RT's Mysql database

2007-08-08 Thread Jesse Vincent
On Aug 8, 2007, at 10:47 AM, Boris Lytochkin wrote: Wednesday, August 8, 2007, 6:22:31 PM, you wrote: This might be a good place to use the ContentEncoding field to describe an 'ondisk' encoding. How do you expect to use this filed? Something like

Re: AW: Re: [rt-users] Custom Fields and Rights Question / maybe a bug

2007-08-08 Thread Joe Casadonte
On 8/8/2007 11:28 AM, Ham MI-ID, Torsten Brumm wrote: Yes for a normal cf this is not critical, but together with a cf set to mandatory this becomes critical, because the user is not able to create a ticket via gui anymore for this queue :-( We get around this by having a scrip kick off and

AW: Re: AW: Re: [rt-users] Custom Fields and Rights Question / maybe a bug

2007-08-08 Thread Ham MI-ID, Torsten Brumm
At create time? Or how have you fixef this problem??? -Original Message- From: Joe Casadonte [EMAIL PROTECTED] To: Ham MI-ID, Torsten Brumm CC: [EMAIL PROTECTED] [EMAIL PROTECTED]; rt-users@lists.bestpractical.com rt-users@lists.bestpractical.com Sent: Wed Aug 08 17:53:33 2007 Subject:

Re: Re: [rt-users] Custom Fields and Rights Question / maybe a bug

2007-08-08 Thread Ruslan Zakirov
If a CF is mandatory then all users who can create tickets in queues CF applies to must have 'ModifyCustomField' right. I think this way. Do you have another ideas? At least as I understand this the way it work now. I was thinking about while fixing bug in 3.7 and came to two ideas: 1) Mandatory

AW: Re: Re: [rt-users] Custom Fields and Rights Question / maybe a bug

2007-08-08 Thread Ham MI-ID, Torsten Brumm
H, an new right would not fix the core of the problemi think this not only occurs on create, this can also hapen at resolve time. From the workflow point of view we have the situation that a user creates a ticket with only limited rights, later groups working at the same ticket have

Re[6]: [rt-users] Attachments table of RT's Mysql database

2007-08-08 Thread Boris Lytochkin
Wednesday, August 8, 2007, 7:45:08 PM, you wrote: I think I was envisioning ondisk as a new encoding meaning the content is the path to the attachment's content on disk (presumably named as a sha1 sum of its content) and not a prefox to the existing encodings. There's not much sense in

Re: [rt-users] Sorting on custom fields: still broken?

2007-08-08 Thread Kenneth Crocker
Tim, We are testing 3.6.4 and have NOT been able to get the sort by a custom field (let alone MORE than 1) to work. We have not heard of an expected fix date either. Kenn LBNL Timothy Smith wrote: My client is running a customized RT 3.6.1 and they're unable to sort searches by a custom

Re: [rt-users] Sorting on custom fields: still broken?

2007-08-08 Thread Jesse Vincent
Kenn, On Aug 8, 2007, at 12:55 PM, Kenneth Crocker wrote: We have not heard of an expected fix date either. We don't generally promise fixes for things to non-customers. (Verified security issues are, of course, an exception.) It's one of the few things we actually charge money for ;).

Re: Re: Re: [rt-users] Custom Fields and Rights Question / maybe a bug

2007-08-08 Thread Ruslan Zakirov
On 8/8/07, Ham MI-ID, Torsten Brumm [EMAIL PROTECTED] wrote: H, an new right would not fix the core of the problemi think this not only occurs on create, this can also hapen at resolve time. What exactly can happen? From the workflow point of view we have the situation that a user

Re: [rt-users] Trying to change the logo. Fedora Core 7, RT3.6.3 yum install

2007-08-08 Thread James Moseley
Obviously, RT is installed in /usr/local/lib/rt3. To make custom changes to your logo without changing the default Logo file, put the customized Logo file in /usr/local/lib/rt3/local/htmlElements/Logo. Next, dump the $LocalPath setting in RT_SiteConfig.pm - it's not needed. BTW, what is the path

Re: Re: Re: [rt-users] Custom Fields and Rights Question / maybe a bug

2007-08-08 Thread Forrest Blount
Regarding what makes a field mandatory: What I'd love to see (and what I initially assumed the mandatory option provided) was for fields to be required before a ticket could be resolved. We have yet to implement the mandatory feature on any queues here because, for the vast majority of the time,

AW: Re: Re: [rt-users] Custom Fields and Rights Question / maybe a bug

2007-08-08 Thread Ham MI-ID, Torsten Brumm
On 8/8/07, Ham MI-ID, Torsten Brumm [EMAIL PROTECTED] wrote: H, an new right would not fix the core of the problemi think this not only occurs on create, this can also hapen at resolve time. What exactly can happen? What happens? I think, from my scenario the last user in the list,

Re: [rt-users] Custom Fields and Rights Question / maybe a bug

2007-08-08 Thread Kenneth Crocker
To all, I can think of many situations where I could have a business group watching the progress (workflow status, etc.) of a ticket that is set/modified using a custom field. They need to see it because they are affected, but I do not want them to change it. Kenn LBNL Ruslan Zakirov

Re: [rt-users] Custom Fields and Rights Question / maybe a bug

2007-08-08 Thread Kenneth Crocker
To all, It would be great if, in future versions, you could specify mandatory for ticket creation and mandatory for ticket resolution. Here Here! That is an excellent suggestion. Kenn LBNL Forrest Blount wrote: Regarding what makes a field mandatory: What I'd love to see (and

AW: [rt-users] Another rights question

2007-08-08 Thread Ham MI-ID, Torsten Brumm
To the Rights Questioni'm really missing a right like UnOwnTicket...!!! -- Thanks in advance : Torsten Brumm : : Kuehne + Nagel : HAM - MI-ID : : Bauerbergweg 23-25 : 22111 Hamburg : : +49 (40) 30333 3199 : +49 (40) 30333 44 3199 : :

Re: [rt-users] I forgot how to do this

2007-08-08 Thread James Moseley
I am sure you can do this by using a single mysql command, but... To get the numeric id of the custom field: mysql select id from CustomFields where Name='custom field name'; Grab the id, then: mysql select * from CustomFieldValues where CustomField='id'; James Moseley

Re: [rt-users] I forgot how to do this

2007-08-08 Thread Forrest Blount
Why do you need a query to do this? Can't you just look at Configuration- CustomFields-YourCustomField and view its current value options? If you need to do a SQL query, use: SELECT DISTINCT CustomFieldValues.Name FROM CustomFieldValues JOIN CustomFields ON

Re: [rt-users] Search old tickets from within scrip

2007-08-08 Thread Keith Edmunds
On Wed, 8 Aug 2007 03:26:21 +0400, [EMAIL PROTECTED] said: I can suggest you another way with two scrips: 1) Update Company field of requestors when an user update customer custom field That's a smart idea, but how does one access the requestor's company field (presumably Organization) from

[rt-users] Query to find open tkts where customer hasn't been replied to

2007-08-08 Thread Gary Oberbrunner
I'd like to make a query to find all open tickets where the customer's been waiting for a reply for longer than N hours. It looks to me like Told is the last time the customer was replied to, and LastUpdated is the last time anything happened in the ticket. So I tried this, in the Edit Query

[rt-users] Reporting Solution

2007-08-08 Thread [EMAIL PROTECTED]
Hi, We been browsing Best Practical Wiki and Google in order to find any How-to or docs to get Resports on the RT. Probably someone did the work and would like to share it? Thx. Seb.- ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Re: [rt-users] Search old tickets from within scrip

2007-08-08 Thread Ruslan Zakirov
$user_obj-Organisation; # returns value $user_obj-SetOrganisation('new value'); # set new value `perldoc lib/RT/User.pm` - basic accessors `perldoc lib/RT/User_Overlay.pm` - more methods On 8/9/07, Keith Edmunds [EMAIL PROTECTED] wrote: On Wed, 8 Aug 2007 03:26:21 +0400, [EMAIL PROTECTED] said:

Re: [rt-users] I forgot how to do this

2007-08-08 Thread Mathew
I'm sure I don't have to explain that sometimes people do things that require this kind of information. It's hard to look at the RT interface and telepathically move the information in the custom field to the application I'll be using it in. That said, as the API has the functionality to do this

Re: [rt-users] I forgot how to do this

2007-08-08 Thread Ruslan Zakirov
my $values = RT::CustomFieldValues-new( $RT::SystemUser ); $values-LimitToCustomField( $custom_field_id ); while ( my $value = $values-Next ) { print $value-Name, \n; } On 8/8/07, Mathew Snyder [EMAIL PROTECTED] wrote: I need to get a list of all of the values for one particular custom

Re: [rt-users] Query to find open tkts where customer hasn't been replied to

2007-08-08 Thread Ruslan Zakirov
Try the following: Queue = 'support' AND Status = 'open' AND Told '-5 hours' Sorry, but the UI doesn't support building queries where date fields are compared to each other. On 8/9/07, Gary Oberbrunner [EMAIL PROTECTED] wrote: I'd like to make a query to find all open tickets where the

Re: [rt-users] Query to find open tkts where customer hasn't been replied to

2007-08-08 Thread Gary Oberbrunner
Ruslan Zakirov wrote: Try the following: Queue = 'support' AND Status = 'open' AND Told '-5 hours' Simple, but unfortunately it mostly gets the cases where we're waiting for the customer and not the other way around. I'd be happy if I could say LastUpdatedBy Owner too... Sorry, but the UI

Re: [rt-users] Reporting Solution

2007-08-08 Thread Kevin Squire
On Wed, 8 Aug 2007 17:57:10 -0300 [EMAIL PROTECTED] [EMAIL PROTECTED] wrote: Hi, We been browsing Best Practical Wiki and Google in order to find any How-to or docs to get Resports on the RT. Probably someone did the work and would like to share it? Thx. Seb.- I use two little scripts

Re: [rt-users] Query to find open tkts where customer hasn't been replied to

2007-08-08 Thread Gary Oberbrunner
James Moseley wrote: Additionally, you probably want to use a status of 'new'. New tickets mean they haven't been touched. Of course, new tickets don't have a 'Told' value. If a ticket is open, it's been touched in some manner, but it doesn't mean that the customer has been responded to...

[rt-users] Scripted creation of Outlook / Exchange tasks?

2007-08-08 Thread lists_rt
Hello folks! First off, I want to thank Best Practical for their brilliant system that made my life ten times easier. My question: has anyone ever scripted the generation of Outlook tasks from a *nix platform, either through some dandy Perl/Python/Ruby/etc. module or by manually piecing together

Re: [rt-users] Scripted creation of Outlook / Exchange tasks?

2007-08-08 Thread Jesse Vincent
On Aug 8, 2007, at 8:25 PM, lists_rt wrote: Hello folks! First off, I want to thank Best Practical for their brilliant system that made my life ten times easier. My question: has anyone ever scripted the generation of Outlook tasks from a *nix platform, either through some dandy

RE: [rt-users] Scripted creation of Outlook / Exchange tasks?

2007-08-08 Thread Helmuth Ramirez
Matt, if you get this up and running would you mind sharing the setup process with the group? This sounds like a pretty interesting integration, I know there have been many occassions when I would like to have this stuff in my Outlook. Keep us posted! -Original Message- From: Jesse

Re: [rt-users] Query to find open tkts where customer hasn't been replied to

2007-08-08 Thread James Moseley
I don't think there is a way in RT to perform the search you want (at least not a straightforward one). You're best bet is to create a custom script to perform a mysql query that would identify tickets that would match the following criteria: (status is open) AND (last update was performed by

Re: [rt-users] Query to find open tickets where customer hasn't been replied to

2007-08-08 Thread Robert Long
Gary Oberbrunner wrote: Isn't this a common thing, to want to find the open tickets that aren't being handled in a timely fashion? How about setting up a custom field like Where the ball lays with values of Customer or Us. Then write a scrip to flip that value if one of your people replies to

Re: [rt-users] Scripted creation of Outlook / Exchange tasks?

2007-08-08 Thread lists_rt
Jesse Vincent wrote: On Aug 8, 2007, at 8:25 PM, lists_rt wrote: Hello folks! First off, I want to thank Best Practical for their brilliant system that made my life ten times easier. My question: has anyone ever scripted the generation of Outlook tasks from a *nix platform, either