Re: [rt-users] RT-WinXP-Apache-Oracle10g-ActivePERL

2007-08-16 Thread Joop
Lutz, Thomas W. wrote: I’m trying to get RT installed on an XP-SP2 box using Oracle10g. I can’t seem to be able to get the manual install to go. I have used the 3^rd party installers to get it working but none of them install for Oracle, only mySQL. I started out trying to manually install

Re: [rt-users] maintainably tagging custom fields for CSS

2007-08-16 Thread Espen Wiborg
Nicholas Clark [EMAIL PROTECTED] writes: Jesse, on IRC, has the alternative suggestion of using a class. It has the advantage that it won't be invalid XML if two fields happen to end up with the same ID. But what's going to be impractical in class names for CSS? I did this to map and -snip-

[rt-users] Insert blank column in results

2007-08-16 Thread Keith Edmunds
RT 3.6.1 Some default displays have two lines per entry with the second line typically being in a smaller font (eg, the requester name). However, under the ticket ID in such displays there is no data on the second line, and editing the display shows that this field is represented by 'blank'. I've

AW: [rt-users] Issue with Extended mail commands / CommandByMail

2007-08-16 Thread Ham MI-ID, Torsten Brumm
Nobody have a hint on this problem?!? Torsten -Original Message- From: [EMAIL PROTECTED] [EMAIL PROTECTED] To: rt-users@lists.bestpractical.com rt-users@lists.bestpractical.com CC: [EMAIL PROTECTED] [EMAIL PROTECTED] Sent: Mon Jul 30 10:10:01 2007 Subject: [rt-users] Issue with Extended

Re: [rt-users] Insert blank column in results

2007-08-16 Thread Stephen Turner
At Thursday 8/16/2007 03:47 AM, Keith Edmunds wrote: RT 3.6.1 Some default displays have two lines per entry with the second line typically being in a smaller font (eg, the requester name). However, under the ticket ID in such displays there is no data on the second line, and editing the

RE: [rt-users] Issue with Extended mail commands / CommandByMail

2007-08-16 Thread Helmuth Ramirez
Well, I don’t know how to “fix it”, but what we do here is put asterisks after we put in our commands and it looks like that stops CommandByMail to continue looking for commands. If we don’t do the asterisks, then it will definitely continue going down the line looking for words with “:” at

Re: [rt-users] maintainably tagging custom fields for CSS

2007-08-16 Thread Nicholas Clark
On Thu, Aug 16, 2007 at 09:18:05AM +0200, Espen Wiborg wrote: Nicholas Clark [EMAIL PROTECTED] writes: Jesse, on IRC, has the alternative suggestion of using a class. It has the advantage that it won't be invalid XML if two fields happen to end up with the same ID. But what's going to be

Re: [rt-users] needs clarification on Cc and Bcc

2007-08-16 Thread slamp slamp
How can I make it so all e-mails sent out is a Bcc? This will get rid of the issue when some users hit Reply All and recipients getting duplicates. We want our users to be able to reply to the queue e-mail only. On 8/2/07, slamp slamp [EMAIL PROTECTED] wrote: The way our RT is setup AdminCc does

[rt-users] Changing Ticket Id Sequence No

2007-08-16 Thread iontrance
Hi, I've searched several times through the mailing lists and was wondering if it is possible to change the start number for the ticket ids? For example, we'll be migrating from one system to RT but we'd like to keep the last sequence on the old system, 115835, and start with RT at

[rt-users] RT error

2007-08-16 Thread Tamer Tayea
Hi , I am getting the following error on my RT 3 system.. Any Ideas ]# /usr/local/scripts/rt/ticket_agechk.pl DBD::mysql::st execute failed: Can't open file: 'Tickets.MYI' (errno: 145) at /usr/local/scripts/rt/ticket_agechk.pl line 50. DBD::mysql::st fetchrow_hashref failed:

[rt-users] Issue with RT system

2007-08-16 Thread Tamer Tayea
Hi , I am getting the following error on my RT 3 system.. Any Ideas ]# /usr/local/scripts/rt/ticket_agechk.pl DBD::mysql::st execute failed: Can't open file: 'Tickets.MYI' (errno: 145) at /usr/local/scripts/rt/ticket_agechk.pl line 50. DBD::mysql::st fetchrow_hashref failed:

[rt-users] rt3 and LDAP auth

2007-08-16 Thread Noah
Hi, can somebody please explain to me the easiest way to configure rt3 to use LDAP authentication? Cheers, Noah ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial

RE: [rt-users] rt3 and LDAP auth

2007-08-16 Thread Schincke, Keith D. (JSC-IT)[MEI]
Hey Noah, Have you looked at the below wiki entry? http://wiki.bestpractical.com/view/LDAP Keith -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Noah Sent: Thursday, August 16, 2007 12:55 PM To: rt-users@lists.bestpractical.com Subject: [rt-users] rt3

RE: [rt-users] Issue with RT system

2007-08-16 Thread Tamer Tayea
Another error , I believe both errors are due to same reason .. This error gets logged in the rt.log when somebody tries to connect to RT system. Any Idea what may be the problem.. Thanks [Thu Aug 16 14:52:35 2007] [crit]: Ticket could not be created due to an internal error

Re: [rt-users] Use 'Watcher = X' inestead of 'Requestor = X : RT 3.6.4

2007-08-16 Thread Jason Long
[EMAIL PROTECTED] wrote: Performing queries using 'Requestor = X OR Cc = X OR AdminCc =X' in 3.6.3 yielded very fast results - a few seconds. However, doing the same search in 3.6.4 resulted in a timeout after four minutes. Using 'Watcher = X' is the preferred solution, faster, etc (and what I

RE: [rt-users] Issue with RT system

2007-08-16 Thread James Moseley
Looks like your Tickets mysql table is missing (or doesn't have the right permissions). Is this a new install? If so, you might want to reinitialize your database. James Moseley Tamer Tayea

RE: [rt-users] Issue with RT system

2007-08-16 Thread Tamer Tayea
This server has been running for 3 years at least. Today , the server wan hung , I had to reboot it .. Since rebooting it , I am getting these errors. Yes, the backend is mysql.. How I go about fixing this db issue ( I am not expert on DB) Thanks Tamer -Original Message- From: Ole

Re: [rt-users] Use 'Watcher = X' inestead of 'Requestor = X : RT 3.6.4

2007-08-16 Thread James Moseley
Ruslan released a patch for this a couple of weeks ago and posted it to the mailing list. It's attached here again: (See attached file: 3.6-searches_by_watchers_performance_fix.patch) James Moseley

RE: [rt-users] Issue with RT system

2007-08-16 Thread James Moseley
Did you check to make sure the mysqld process is running? Have you checked the mysql logs for errors? If the mysqld process is running and your Tickets table exists, it's possible the Tickets table is corrupted. Try a repair table operation if so. And like Ole stated, you need to provide a lot

Re: [rt-users] Issue with RT system

2007-08-16 Thread Robert Long
Hey Tamer, I would really help to know what all software you are running as outlined bellow, but chances are your database became corrupted. You might want to check your file systems, make sure there is enough free space, possibly just restoring from your most recent backup will solve the

RE: [rt-users] Issue with RT system

2007-08-16 Thread Edge, Sean
Also make sure that /var (or where ever MySQL is installed) is not mounted read-only. -Sean -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of James Moseley Sent: Thursday, August 16, 2007 3:12 PM To: Tamer Tayea Cc: RT-Users Subject: RE: [rt-users] Issue

RE: [rt-users] Issue with RT system

2007-08-16 Thread Ole Craig
On Thu, 2007-08-16 at 14:31 -0400, Tamer Tayea wrote: [...] [Thu Aug 16 14:52:36 2007] [crit]: Couldn't create a ticket: Internal Error: Couldn't execute the query 'INSERT INTO Tickets (Subject, Status, Queue, Creator, Owner, LastUpdatedBy, Started, Type, Starts, Resolved, Created, Priority,

Re: [rt-users] rt3 and LDAP auth

2007-08-16 Thread Noah
thanks Keith - checking it now Schincke, Keith D. (JSC-IT)[MEI] wrote: Hey Noah, Have you looked at the below wiki entry? http://wiki.bestpractical.com/view/LDAP Keith -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Noah Sent: Thursday, August 16,

Re: [rt-users] Use 'Watcher = X' inestead of 'Requestor = X : RT 3.6.4

2007-08-16 Thread Ruslan Zakirov
Note for everybody who's suffering from this bug. Jesse released RT-3.6.5-RC1 few days ago that is bug fix release and the patch is a part of it. If there wouldn't be negative feedback on the release candidate then 3.6.5 will be available really soon. On 8/16/07, James Moseley [EMAIL PROTECTED]

[rt-users] Chart grouped by priority

2007-08-16 Thread Jason Fenner
I am trying to be able to create charts grouped by priority. So far I have not found how to do this. Can anyone give me any clues as to how to do that? What I am doing is building a query in ticket search. Then, at the lower right hand corner of the screen there are drop downs to create

[rt-users] Elixus install auto-login...

2007-08-16 Thread Lutz, Thomas W.
I utilized the Elixus download for 3.4.0 and everything started up fine. The problem I am having is that RT automatically logs in as user root even if I tell it to logout it still autologs in as root. Where is the setting to change this? Tom Lutz Business Systems Analyst Georgia Power Company

[rt-users] Limit DeleteTicket Rights

2007-08-16 Thread Michele Hershey
I'm finding the opposite fixesI ahve the s same issue as [EMAIL PROTECTED] Hello, Using RT 3.6.3, does anyone know how to globally deny DeleteTicket privelege to a user? We have users with the following privs assigned on a per queue basis: ModifyTicket OwnTicket ShowTicket

Re: [rt-users] Chart grouped by priority

2007-08-16 Thread Jason Fenner
I wanted to update the list that I solved my own problem. To do this, you simply need to build a query and then build a graph from it with any group by. Then, once the graph is displayed, edit the URL. Locate at the end of the URL a parameter named: PrimaryGroupBy Change that parameter to the

Re: [rt-users] Limit DeleteTicket Rights

2007-08-16 Thread Kenneth Crocker
Michele, To take it a bit further, perhaps the ability to change a status or queue should be separate rights as well? Kenn LBNL Michele Hershey wrote: I'm finding the opposite fixesI ahve the s same issue as [EMAIL PROTECTED] Hello, Using RT 3.6.3, does anyone know how to

Re: [rt-users] Limit DeleteTicket Rights

2007-08-16 Thread Michele Hershey
Yes, but I believe that since DeleteTicket is already separate, it should not be included within other rights , as it may be a bug. Kenneth Crocker wrote: Michele, To take it a bit further, perhaps the ability to change a status or queue should be separate rights as well? Kenn LBNL

Re: [rt-users] how to add members to user defined group in RT

2007-08-16 Thread Akila Amarathunga
Hi Guys, I configured RT 3.6.4 but the problem i mentioned exists on this version too :( .. Only work around i found was to create user with admin privileges and add the user to the group and strip off the admin admin privileges.. Thanks, Akila On Wed, 2007-08-15 at 17:24 +0530, Akila