[rt-users] Make initialize-database with Postgresql
Hi
Today I want create a fresh rt-database. When I run make
initialize-database I get the follow error: invalid privilege type USAGE
for table.
The error comes from the acl.Pg file, that contains the following code:
foreach my $table (@tables) {
if ( $table =~ /^[a-z]/ $table ne 'sessions' ) {
# table like objectcustomfields_id_s
push @acls, GRANT USAGE, SELECT, UPDATE ON $table TO
$db_user;
}
else {
push @acls, GRANT SELECT, INSERT, UPDATE, DELETE ON $table
TO $db_user;
}
}
return (@acls);
}
1;
My current installation is:
Rt-3.8.1
Postgresql-8.1.9-1
perl-5.8.8-10
I checked the postgresql installation and compared the schemas without
success. I've been able to run make initialize-database by commenting
the following:
--- /opt/rt3/etc/acl.Pg 2008-09-05 11:34:12.0 +0200
+++ /root/rt-3.8.1/etc/acl.Pg 2008-09-05 11:00:49.0 +0200
@@ -58,13 +58,13 @@
}
foreach my $table (@tables) {
-if ( $table =~ /^[a-z]/ $table ne 'sessions' ) {
+#if ( $table =~ /^[a-z]/ $table ne 'sessions' ) {
# table like objectcustomfields_id_s
-push @acls, GRANT USAGE, SELECT, UPDATE ON $table TO
$db_user;
-}
-else {
+#push @acls, GRANT USAGE, SELECT, UPDATE ON $table TO
$db_user;
+#}
+#else {
push @acls, GRANT SELECT, INSERT, UPDATE, DELETE ON $table
TO $db_user;
-}
+#}
}
return (@acls);
}
What impact does these changes have? Do the current code need the newer
postgresql?
Any help is appreciated.
Regards Michael Peer
___
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::CustomField - Queue deprecated at(RT::Tickets:/opt/rt3/local/lib/RT/Tickets_Overlay.pm:2245)
Hello,
One year ago, I wrote this to the Mailinglist. Now I have upgraded my RT
to 3.8.0 and now the function
$tickets-LimitCustomField(CUSTOMFIELD = '', OPERATOR = 'LIKE',
VALUE = 'true');
doesn't work any more.
The reason is, that the function Queue in CustomField_Overlay.pm, marked
as deprecated in rt-3.4.5, is now eliminated, but is still called in
function LimitCustomField (Tickets_Overlay.pm, line 2466).
I think, that this part can be removed, because it does not do anything.
This diff removes this part:
--- /opt/rt3/lib/RT/Tickets_Overlay.pm 2008-07-14
16:30:19.0 +0200
+++ /opt/rt3/local/lib/RT/Tickets_Overlay.pm2008-07-22
10:54:54.0 +0200
@@ -2462,12 +2464,7 @@
$CF-Name, $args{OPERATOR}, $args{VALUE} );
}
-my $q = ;
-if ( $CF-Queue ) {
-my $qo = new RT::Queue( $self-CurrentUser );
-$qo-Load( $CF-Queue );
-$q = $qo-Name;
-}
my @rest;
@rest = ( ENTRYAGGREGATOR = 'AND' )
@@ -2477,9 +2474,7 @@
VALUE = $args{VALUE},
FIELD = CF.
. (
- $q
-? $q . .{ . $CF-Name . }
-: $CF-Name
+$CF-Name
),
OPERATOR= $args{OPERATOR},
CUSTOMFIELD = 1,
What's your opinion about eliminating the above snippet?
Michael Peer
-Original Message-
From: Jesse Vincent [mailto:[EMAIL PROTECTED]
Sent: Wednesday, 14 February, 2007 13:55
To: Peer Michael
Cc: rt-users@lists.bestpractical.com
Subject: Re: [rt-users] RT::CustomField - Queue deprecated
at(RT::Tickets:/opt/rt3/local/lib/RT/Tickets_Overlay.pm:2245)
On Wed, Feb 14, 2007 at 10:41:11AM +0100, Peer Michael wrote:
I never get a response to this problem. Any idea?
Ruslan did reply. It's fixed in newer releases. But don't worry about
the issue. It's harmless.
Michael Peer
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Peer
Michael
Sent: Thursday, 01 February, 2007 08:52
To: Ruslan Zakirov
Cc: rt-users@lists.bestpractical.com
Subject: RE: [rt-users] RT::CustomField - Queue deprecated
at(RT::Tickets:/opt/rt3/local/lib/RT/Tickets_Overlay.pm:2245)
I'm using rt-3.4.5.
-Original Message-
From: Ruslan Zakirov [mailto:[EMAIL PROTECTED]
Sent: Wednesday, 31 January, 2007 17:52
To: Peer Michael
Cc: rt-users@lists.bestpractical.com
Subject: Re: [rt-users] RT::CustomField - Queue deprecated at
(RT::Tickets:/opt/rt3/local/lib/RT/Tickets_Overlay.pm:2245)
On 1/31/07, Peer Michael [EMAIL PROTECTED] wrote:
Greeting
When i use the function
$tickets-LimitCustomField(CUSTOMFIELD = '', OPERATOR =
'LIKE',
VALUE = 'true'); i find this message in the log:
[Wed Jan 31 15:47:34 2007] [debug]: RT::CustomField - Queue
deprecated at
(RT::Tickets:/opt/rt3/local/lib/RT/Tickets_Overlay.pm:2245)
(/opt/rt3/lib/RT/CustomField_Overlay.pm:741)
How can i avoid this message?
Update to newer version of the RT? Or at least say us what version
you're using.
Thanks
--
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
___
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] RT::CustomField - Queue deprecated at(RT::Tickets:/opt/rt3/local/lib/RT/Tickets_Overlay.pm:2245)
Thanks for you quick help
Michael
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On
Behalf Of Ruslan Zakirov
Sent: Tuesday, 22 July, 2008 16:30
To: Peer Michael
Cc: Jesse Vincent; rt-users@lists.bestpractical.com
Subject: Re: [rt-users] RT::CustomField - Queue deprecated
at(RT::Tickets:/opt/rt3/local/lib/RT/Tickets_Overlay.pm:2245)
Look at this ticket:
http://rt3.fsck.com//Ticket/Display.html?id=10235
guest/guest
On Tue, Jul 22, 2008 at 1:07 PM, Peer Michael [EMAIL PROTECTED]
wrote:
Hello,
One year ago, I wrote this to the Mailinglist. Now I have upgraded my
RT to 3.8.0 and now the function
$tickets-LimitCustomField(CUSTOMFIELD = '', OPERATOR = 'LIKE',
VALUE = 'true'); doesn't work any more.
The reason is, that the function Queue in CustomField_Overlay.pm,
marked as deprecated in rt-3.4.5, is now eliminated, but is still
called in function LimitCustomField (Tickets_Overlay.pm, line 2466).
I think, that this part can be removed, because it does not do
anything.
This diff removes this part:
--- /opt/rt3/lib/RT/Tickets_Overlay.pm 2008-07-14
16:30:19.0 +0200
+++ /opt/rt3/local/lib/RT/Tickets_Overlay.pm2008-07-22
10:54:54.0 +0200
@@ -2462,12 +2464,7 @@
$CF-Name, $args{OPERATOR}, $args{VALUE} );
}
-my $q = ;
-if ( $CF-Queue ) {
-my $qo = new RT::Queue( $self-CurrentUser );
-$qo-Load( $CF-Queue );
-$q = $qo-Name;
-}
my @rest;
@rest = ( ENTRYAGGREGATOR = 'AND' ) @@ -2477,9 +2474,7 @@
VALUE = $args{VALUE},
FIELD = CF.
. (
- $q
-? $q . .{ . $CF-Name . }
-: $CF-Name
+$CF-Name
),
OPERATOR= $args{OPERATOR},
CUSTOMFIELD = 1,
What's your opinion about eliminating the above snippet?
Michael Peer
-Original Message-
From: Jesse Vincent [mailto:[EMAIL PROTECTED]
Sent: Wednesday, 14 February, 2007 13:55
To: Peer Michael
Cc: rt-users@lists.bestpractical.com
Subject: Re: [rt-users] RT::CustomField - Queue deprecated
at(RT::Tickets:/opt/rt3/local/lib/RT/Tickets_Overlay.pm:2245)
On Wed, Feb 14, 2007 at 10:41:11AM +0100, Peer Michael wrote:
I never get a response to this problem. Any idea?
Ruslan did reply. It's fixed in newer releases. But don't worry about
the issue. It's harmless.
Michael Peer
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Peer
Michael
Sent: Thursday, 01 February, 2007 08:52
To: Ruslan Zakirov
Cc: rt-users@lists.bestpractical.com
Subject: RE: [rt-users] RT::CustomField - Queue deprecated
at(RT::Tickets:/opt/rt3/local/lib/RT/Tickets_Overlay.pm:2245)
I'm using rt-3.4.5.
-Original Message-
From: Ruslan Zakirov [mailto:[EMAIL PROTECTED]
Sent: Wednesday, 31 January, 2007 17:52
To: Peer Michael
Cc: rt-users@lists.bestpractical.com
Subject: Re: [rt-users] RT::CustomField - Queue deprecated at
(RT::Tickets:/opt/rt3/local/lib/RT/Tickets_Overlay.pm:2245)
On 1/31/07, Peer Michael [EMAIL PROTECTED] wrote:
Greeting
When i use the function
$tickets-LimitCustomField(CUSTOMFIELD = '', OPERATOR =
'LIKE',
VALUE = 'true'); i find this message in the log:
[Wed Jan 31 15:47:34 2007] [debug]: RT::CustomField - Queue
deprecated at
(RT::Tickets:/opt/rt3/local/lib/RT/Tickets_Overlay.pm:2245)
(/opt/rt3/lib/RT/CustomField_Overlay.pm:741)
How can i avoid this message?
Update to newer version of the RT? Or at least say us what version
you're using.
Thanks
--
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
___
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
--
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
RE: [rt-users] Oracle and special German characters
Thanks for the quick reply. I tested your suggestion, but nothing changed. Michael -Original Message- From: Joop [mailto:[EMAIL PROTECTED] Sent: Tuesday, 25 September, 2007 09:24 To: Peer Michael Cc: rt-users@lists.bestpractical.com Subject: Re: [rt-users] Oracle and special German characters Peer Michael wrote: Hello! We are testing RT with oracle database. Everything works fine, but I have problems with special German characters. RT doesn't show this characters in the right mode. He substitute this characters with other characters. Does someone of you has any experience with RT and oracle? We are using: rt-3.4.5 oracle 9i DBIx::SearchBuilder v1.45 I added/replaced the following to my /etc/int.d/apache2, about the 4-5 line from above: ENV=env -i LANG=C PATH=/usr/local/bin:/usr/bin:/bin NLS_LANG=AMERICAN_AMERICA.UTF8 The added stuff is about NLS_LANG, adjust to your database settings. Joop ___ 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] Migrate database from PostgreSQL to Oracle
Hello all, I want to migrate our rt-3.4.6-database from postgresql to Oracle. Has someone else done this before? Any help is welcome Michael ___ 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] Oracle and special German characters
Hello! We are testing RT with oracle database. Everything works fine, but I have problems with special German characters. RT doesn't show this characters in the right mode. He substitute this characters with other characters. Does someone of you has any experience with RT and oracle? We are using: rt-3.4.5 oracle 9i DBIx::SearchBuilder v1.45 ___ 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 web interface
Hi I'm looking for an alternative web interface. Currently I use the rt-3.4.5 interface, but my boss will a new interface that is different as rt 3.4 and rt-3.6. Any suggestion? Thanks in advanced Michael Peer ___ 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 stops sending mails to ticket requestors
It's seems, that your Autoreply script isn't a global script, but a script, that runs only in a specific queue. Michael No - the following scrips are active for that queue: Scrips which apply to all queues * Open Blank On Correspond Open Tickets with template Blank * OwnerChangeNotify On Owner Change Notify Owner with template Transaction * CreateNotifyAdminCC On Create Notify AdminCcs with template Transaction * CorrespondNotifyAdminCC On Correspond Notify AdminCcs with template Admin Correspondence * CorrespondNotifyReq On Correspond Notify Requestors and Ccs with template Correspondence * CorrespondNotify On Correspond Notify Other Recipients with template Correspondence * CommentNotifyAdminCC On Comment Notify AdminCcs as Comment with template Admin Comment * CommentNotify On Comment Notify Other Recipients as Comment with template Correspondence Current Scrips Autoreply On Create Autoreply To Requestors with template Autoreply de-punkt AFAICT, they are all untouched. I'm really at a loss as to where the problem might be... Regards, --ck -- http://www.de-punkt.de [ [EMAIL PROTECTED] ]http://www.stormix.de PHP-Anwendungen sind gefährdet! SQL-Injection, XSS, Session-Angriffe, CSRF, Commandshells, Response Splitting,... böhmische Dörfer? Dann gleich PHP-Sicherheit direkt beim Verlag vorbestellen! http://www.php-sicherheit.de/ ___ 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] RT::CustomField - Queue deprecated at(RT::Tickets:/opt/rt3/local/lib/RT/Tickets_Overlay.pm:2245)
I never get a response to this problem. Any idea? Michael Peer -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Peer Michael Sent: Thursday, 01 February, 2007 08:52 To: Ruslan Zakirov Cc: rt-users@lists.bestpractical.com Subject: RE: [rt-users] RT::CustomField - Queue deprecated at(RT::Tickets:/opt/rt3/local/lib/RT/Tickets_Overlay.pm:2245) I'm using rt-3.4.5. -Original Message- From: Ruslan Zakirov [mailto:[EMAIL PROTECTED] Sent: Wednesday, 31 January, 2007 17:52 To: Peer Michael Cc: rt-users@lists.bestpractical.com Subject: Re: [rt-users] RT::CustomField - Queue deprecated at (RT::Tickets:/opt/rt3/local/lib/RT/Tickets_Overlay.pm:2245) On 1/31/07, Peer Michael [EMAIL PROTECTED] wrote: Greeting When i use the function $tickets-LimitCustomField(CUSTOMFIELD = '', OPERATOR = 'LIKE', VALUE = 'true'); i find this message in the log: [Wed Jan 31 15:47:34 2007] [debug]: RT::CustomField - Queue deprecated at (RT::Tickets:/opt/rt3/local/lib/RT/Tickets_Overlay.pm:2245) (/opt/rt3/lib/RT/CustomField_Overlay.pm:741) How can i avoid this message? Update to newer version of the RT? Or at least say us what version you're using. Thanks -- 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 ___ 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] SetDates in rt-3.4.5
Dear all, I'm using rt-3.4.5 When I set dates with this format: 1 week 13:12, then RT set the date to now+1 week at 13:12. But when I type 1 month 13:12 then RT set the date to now+1 month at the current time. How can this behavior be corrected? Thanks Michael Peer ___ 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] Some thoughts on the Quick Search list
Hi
With this diffs I added the SavedSearch in the Home-site. It works, but
some times I recive the following error:
System error
error: RT::Attribute::Name Unimplemented in RT::Attributes.
(/opt/rt3/lib/RT/Attributes_Overlay.pm line 81)
context:...
492:else {
493:my ( $package, $filename, $line );
494:( $package, $filename, $line ) = caller;
495:
496:die $AUTOLOAD Unimplemented in $package. ($filename
line $line) \n;
497:}
498:
499:}
500:
...
code stack:
/usr/lib/perl5/site_perl/5.8.5/DBIx/SearchBuilder/Record.pm:496
/opt/rt3/lib/RT/Attributes_Overlay.pm:81
/opt/rt3/lib/RT/Attributes_Overlay.pm:73
/opt/rt3/lib/RT/Attributes_Overlay.pm:88
/opt/rt3/lib/RT/Attributes_Overlay.pm:119
/opt/rt3/share/html/Search/Elements/SelectSearchesForObjects:58
/opt/rt3/local/html/index.html:97
/opt/rt3/local/html/autohandler:242
What du you think about?
Michael Peer
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Stephen
Turner
Sent: Thursday, 01 February, 2007 15:11
To: Bob Goldstein
Cc: rt-users@lists.bestpractical.com
Subject: Re: [rt-users] Some thoughts on the Quick Search list
Bob Goldstein wrote:
On Wed, Jan 31, 2007 at 10:04:39AM +1100, Taan Lindemans wrote:
Does anybody else think it would be useful if the Quick Search list
could be modified to include saved searches on a per user basis?
I think that this might want to be another portlet, but I'd love to
see it happen.
There is something similar at
http://www.cs.kent.ac.uk/people/staff/tdb/rt3/
At the bottom, there is a set of callbacks, one of which puts a list
of saved searches in the left navigation column. (I know I found
out
about this from the wiki, but I can't find the reference on
the wiki right now.) FWIW, we really like these; the colorizing
and a couple extra menu options add a very nice polish to the
experience.
(I didn't write these, I just like them. Tim Bishop gets the
credit.)
bobg
This way you could display summaries of categorized (by custom
field) tickets without displaying a list of tickets. This would make
for a more versatile rt dashboard. Of coarse you could set up a
separate queue for each category but this is overkill in some
situations such as having one queue for software issues with
categories for bugs, feature requests etc.
I don't know how difficult this is to implement however.
Taan
___
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
___
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
The Home Page Saved Searches contrib could be adapted to do this -
http://wiki.bestpractical.com/index.cgi?HomePageSavedSearches
Steve
___
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] RT 3.6.3: Cannot chnage owner to another user.
With this diff, superusers can reassign tickets. It works for us.
--- /opt/rt3/lib/RT/Ticket_Overlay.pm 2005-11-14 21:43:24.0
+0100
+++ /opt/rt3/local/lib/RT/Ticket_Overlay.pm 2007-01-30
17:39:31.0 +0100
@@ -2959,6 +2959,7 @@
and#If we're not stealing
( $self-OwnerObj-Id != $RT::Nobody-Id ) and#and the
owner is set
( $self-CurrentUser-Id ne $self-OwnerObj-Id() )
+ and (!$self-CurrentUserHasRight('SuperUser')) #and is not
superuser
) { #and it's not
us
return ( 0,
$self-loc(
Michael Peer
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Nick
Metrowsky
Sent: Thursday, 01 February, 2007 23:25
To: RT Users
Subject: [rt-users] RT 3.6.3: Cannot chnage owner to another user.
Hi Everyone,
I have Super User and I cannot change the ownership of a ticket from one
person to another. I get an error You can only take tickets that are
unowned or You can only reassign tickets that you own or that are
unowned. This is definitely a different behavior than that of RT 3.4.4.
Any ideas on this one?
Nick
-
Nick Metrowsky
Consulting System Administrator
303-684-4785 Office
303-684-4100 Fax
[EMAIL PROTECTED] mailto:[EMAIL PROTECTED]
DigitalGlobe (r), An Imaging and Information Company
http://www.digitalglobe.com http://www.digitalglobe.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] RT::CustomField - Queue deprecated at (RT::Tickets:/opt/rt3/local/lib/RT/Tickets_Overlay.pm:2245)
Greeting When i use the function $tickets-LimitCustomField(CUSTOMFIELD = '', OPERATOR = 'LIKE', VALUE = 'true'); i find this message in the log: [Wed Jan 31 15:47:34 2007] [debug]: RT::CustomField - Queue deprecated at (RT::Tickets:/opt/rt3/local/lib/RT/Tickets_Overlay.pm:2245) (/opt/rt3/lib/RT/CustomField_Overlay.pm:741) How can i avoid this message? Thanks Michael Peer ICT ___ EURAC research Viale Druso/Drususallee 1 39100 Bolzano/Bozen Italy Email: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] Website: www.eurac.edu http://www.eurac.edu/ ___ 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::CustomField - Queue deprecated at (RT::Tickets:/opt/rt3/local/lib/RT/Tickets_Overlay.pm:2245)
I'm using rt-3.4.5. -Original Message- From: Ruslan Zakirov [mailto:[EMAIL PROTECTED] Sent: Wednesday, 31 January, 2007 17:52 To: Peer Michael Cc: rt-users@lists.bestpractical.com Subject: Re: [rt-users] RT::CustomField - Queue deprecated at (RT::Tickets:/opt/rt3/local/lib/RT/Tickets_Overlay.pm:2245) On 1/31/07, Peer Michael [EMAIL PROTECTED] wrote: Greeting When i use the function $tickets-LimitCustomField(CUSTOMFIELD = '', OPERATOR = 'LIKE', VALUE = 'true'); i find this message in the log: [Wed Jan 31 15:47:34 2007] [debug]: RT::CustomField - Queue deprecated at (RT::Tickets:/opt/rt3/local/lib/RT/Tickets_Overlay.pm:2245) (/opt/rt3/lib/RT/CustomField_Overlay.pm:741) How can i avoid this message? Update to newer version of the RT? Or at least say us what version you're using. Thanks -- 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] Reply to stalled tickets
Greetings I am using rt-3.4.5. My problem is, when i reply to a stalled ticket and i don't want change the status, the rt-system set the status to open. I know, that the reason of this is the autoopen-script. But i don't understand, why rt-2.0.4, the system that i used before, Doesn't do that, nevertheless the script exists. Thanks for helping Michael Peer ICT ___ EURAC research Viale Druso/Drususallee 1 39100 Bolzano/Bozen Italy Email: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] Website: www.eurac.edu http://www.eurac.edu/ ___ 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] (no subject)
Hi
You have to change the file User.pm when privileged user will view this
information. In the diff I give privileged users permission to view comments
and workphone from users.
--- /opt/rt3/lib/RT/User.pm 2005-02-01 15:20:40.0 +0100
+++ /opt/rt3/local/lib/RT/User.pm 2006-09-29 13:59:25.0 +0200
@@ -770,7 +770,7 @@
Password =
{read = 1, write = 1, sql_type = 12, length = 40, is_blob
= 0, is_numeric = 0, type = 'varchar(40)', default = ''},
Comments =
- {read = 1, write = 1, sql_type = -4, length = 0, is_blob
= 1, is_numeric = 0, type = 'blob', default = ''},
+ {read = 1, write = 1, public = 1, sql_type = -4, length =
0, is_blob = 1, is_numeric = 0, type = 'blob', default = ''},
Signature =
{read = 1, write = 1, sql_type = -4, length = 0, is_blob
= 1, is_numeric = 0, type = 'blob', default = ''},
EmailAddress =
@@ -802,7 +802,7 @@
HomePhone =
{read = 1, write = 1, sql_type = 12, length = 30, is_blob
= 0, is_numeric = 0, type = 'varchar(30)', default = ''},
WorkPhone =
- {read = 1, write = 1, sql_type = 12, length = 30, is_blob
= 0, is_numeric = 0, type = 'varchar(30)', default = ''},
+ {read = 1, write = 1, public = 1, sql_type = 12, length =
30, is_blob = 0, is_numeric = 0, type = 'varchar(30)', default = ''},
MobilePhone =
{read = 1, write = 1, sql_type = 12, length = 30, is_blob
= 0, is_numeric = 0, type = 'varchar(30)', default = ''},
PagerPhone =
Michael
PS: Sorry for my bad english
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Ian Clancy
Sent: Wednesday, 04 October, 2006 14:03
To: rt-users@lists.bestpractical.com
Subject: [rt-users] Permissions to view More about user
Hi list,
I wrote a script to pull all our user information from out directory into RT.
Information such as Phone Numbers etc.. that kind of thing.
All this information can now be viewed from the root account but not from the
other privileged accounts.
What permission do i need to give to the priviliged accounts to be able to view
this information ?.
Thanks
--
Ian Clancy
IT Co-ordinator
Connaught Electronics Ltd.
Dunmore Rd,
Tuam,
Co. Galway,
Ireland.
P : ++353 93 23151
F : ++353 93 23110
E : mailto:[EMAIL PROTECTED]
W : http://www.cel-europe.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
___
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
