Users Drop-Down

I have just upgraded from 3.0.11 to 3.4.5 and for the most part
everything has gone very well. The only problem I am having is
assigning ticket ownership. The Owner drop down currently shows
"Nobody" as the only available choice of owner. Is this a permissions
problem or something else? All users in question have ModifyTicket as
does Everyone.

Thanks
Alex

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

Alex,

You need to grant the ‘own ticket’ permission in order for the users to
appear in the drop-down.

Regards,
Dan-----Original Message-----
From: rt-users-bounces@lists.bestpractical.com
[mailto:rt-users-bounces@lists.bestpractical.com]On Behalf Of Alex
Romanauskas
Sent: July 27, 2006 9:14 AM
To: rt-users
Subject: [rt-users] Users Drop-Down

I have just upgraded from 3.0.11 to 3.4.5 and for the most part
everything has gone very well. The only problem I am having is
assigning ticket ownership. The Owner drop down currently shows
“Nobody” as the only available choice of owner. Is this a permissions
problem or something else? All users in question have ModifyTicket as
does Everyone.

Thanks
Alex

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: sales@bestpractical.com

Discover RT’s hidden secrets with RT Essentials from O’Reilly Media.
Buy a copy at http://rtbook.bestpractical.com

We’re hiring! Come hack Perl for Best Practical:
http://bestpractical.com/about/jobs.html

DISCLAIMER: The information in this message is confidential and may be
legally privileged. It is intended solely for the addressee. Access to this
message by anyone else is unauthorized. If you are not the intended
recipient, any disclosure, copying, or distribution of the message, or any
action or omission taken by you in reliance on it, is prohibited and may be
unlawful. Please immediately contact the sender if you have received this
message in error. Thank you.

Dan,

Own Ticket is enabled for all users and Everyone.  In case it could be

some other permission level here is what is assigned to the standard users:

CommentOnTicket
CreateTicket
ModifySelf
ModifyTicket
OwnTicket
ReplyToTicket
SeeQueue
ShowTicket
ShowTicketComments
Watch
WatchAsAdminCc

I have also noticed that you can’t even use query builder to search by
owner as that drop-down also just shows nobody.

Thanks
Alex

Lamers, Dan wrote:

Alex,

You need to grant the ‘own ticket’ permission in order for the users to
appear in the drop-down.

Regards,
Dan

-----Original Message-----
From: rt-users-bounces@lists.bestpractical.com
[mailto:rt-users-bounces@lists.bestpractical.com]On Behalf Of Alex
Romanauskas
Sent: July 27, 2006 9:14 AM
To: rt-users
Subject: [rt-users] Users Drop-Down

I have just upgraded from 3.0.11 to 3.4.5 and for the most part
everything has gone very well. The only problem I am having is
assigning ticket ownership. The Owner drop down currently shows
“Nobody” as the only available choice of owner. Is this a permissions
problem or something else? All users in question have ModifyTicket as
does Everyone.

Thanks

Alex

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

After enabling debug for RT this is the error I receive when it attempts
to retrieve the users lists for the drop-down.

Jul 31 08:51:41 tickets RT: RT::Handle=HASH(0xa14171c) couldn’t execute
the query 'SELECT DISTINCT main.* FROM Users main , Principals
Principals_1, ACL ACL_2, Groups Groups_3, CachedGroupMembers
CachedGroupMembers_4 WHERE ((ACL_2.RightName = ‘OwnTicket’)) AND
((CachedGroupMembers_4.MemberId = Principals_1.id)) AND ((Groups_3.id =
CachedGroupMembers_4.GroupId)) AND ((Principals_1.Disabled =
‘0’)or(Principals_1.Disabled = ‘0’)) AND ((Principals_1.id != ‘1’)) AND
((main.id = Principals_1.id)) AND ( ( ACL_2.PrincipalId =
Groups_3.id AND ACL_2.PrincipalType = ‘Group’ AND (
Groups_3.Domain = ‘SystemInternal’ OR Groups_3.Domain = ‘UserDefined’ OR
Groups_3.Domain = ‘ACLEquivalence’))

Anyone have any info on where to look for the problem?

Thanks
Alex

Lamers, Dan wrote:

Sorry Alex, that’s the extent of my knowledge. I’m new to RT and it took me
a while to find out how to get that drop box populated. For me, the ‘Own
Ticket’ was all that was required and I assigned that to the ‘priviledged
users’ group.

Regards,
Dan

-----Original Message-----
From: Alex Romanauskas [mailto:aroman@ziplink.net]
Sent: July 28, 2006 9:34 AM
To: Lamers, Dan
Cc: rt-users
Subject: Re: [rt-users] Users Drop-Down

Dan,

Own Ticket is enabled for all users and Everyone. In case it could
be
some other permission level here is what is assigned to the standard users:

CommentOnTicket
CreateTicket
ModifySelf
ModifyTicket
OwnTicket
ReplyToTicket
SeeQueue
ShowTicket
ShowTicketComments
Watch
WatchAsAdminCc

I have also noticed that you can’t even use query builder to search by
owner as that drop-down also just shows nobody.

Thanks

Alex

Lamers, Dan wrote:

Alex,

You need to grant the ‘own ticket’ permission in order for the users to
appear in the drop-down.

Regards,
Dan

-----Original Message-----
From: rt-users-bounces@lists.bestpractical.com
[mailto:rt-users-bounces@lists.bestpractical.com]On Behalf Of Alex
Romanauskas
Sent: July 27, 2006 9:14 AM
To: rt-users
Subject: [rt-users] Users Drop-Down

I have just upgraded from 3.0.11 to 3.4.5 and for the most part
everything has gone very well. The only problem I am having is
assigning ticket ownership. The Owner drop down currently shows
“Nobody” as the only available choice of owner. Is this a permissions
problem or something else? All users in question have ModifyTicket as
does Everyone.

Thanks

Alex

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

Sounds like you didn’t run the upgrade scrips on the db. Check the README.

Alex Romanauskas wrote:

After enabling debug for RT this is the error I receive when it attempts
to retrieve the users lists for the drop-down.

Jul 31 08:51:41 tickets RT: RT::Handle=HASH(0xa14171c) couldn’t execute
the query 'SELECT DISTINCT main.* FROM Users main , Principals
Principals_1, ACL ACL_2, Groups Groups_3, CachedGroupMembers
CachedGroupMembers_4 WHERE ((ACL_2.RightName = ‘OwnTicket’)) AND
((CachedGroupMembers_4.MemberId = Principals_1.id)) AND ((Groups_3.id =
CachedGroupMembers_4.GroupId)) AND ((Principals_1.Disabled =
‘0’)or(Principals_1.Disabled = ‘0’)) AND ((Principals_1.id != ‘1’)) AND
((main.id = Principals_1.id)) AND ( ( ACL_2.PrincipalId =
Groups_3.id AND ACL_2.PrincipalType = ‘Group’ AND (
Groups_3.Domain = ‘SystemInternal’ OR Groups_3.Domain = ‘UserDefined’ OR
Groups_3.Domain = ‘ACLEquivalence’))

Anyone have any info on where to look for the problem?

Thanks

Alex

Lamers, Dan wrote:

Sorry Alex, that’s the extent of my knowledge. I’m new to RT and it took me
a while to find out how to get that drop box populated. For me, the ‘Own
Ticket’ was all that was required and I assigned that to the ‘priviledged
users’ group.

Regards,
Dan

-----Original Message-----
From: Alex Romanauskas [mailto:aroman@ziplink.net]
Sent: July 28, 2006 9:34 AM
To: Lamers, Dan
Cc: rt-users
Subject: Re: [rt-users] Users Drop-Down

Dan,

Own Ticket is enabled for all users and Everyone. In case it could
be
some other permission level here is what is assigned to the standard users:

CommentOnTicket
CreateTicket
ModifySelf
ModifyTicket
OwnTicket
ReplyToTicket
SeeQueue
ShowTicket
ShowTicketComments
Watch
WatchAsAdminCc

I have also noticed that you can’t even use query builder to search by
owner as that drop-down also just shows nobody.

Thanks

Alex

Lamers, Dan wrote:

Alex,

You need to grant the ‘own ticket’ permission in order for the users to
appear in the drop-down.

Regards,
Dan

-----Original Message-----
From: rt-users-bounces@lists.bestpractical.com
[mailto:rt-users-bounces@lists.bestpractical.com]On Behalf Of Alex
Romanauskas
Sent: July 27, 2006 9:14 AM
To: rt-users
Subject: [rt-users] Users Drop-Down

I have just upgraded from 3.0.11 to 3.4.5 and for the most part
everything has gone very well. The only problem I am having is
assigning ticket ownership. The Owner drop down currently shows
“Nobody” as the only available choice of owner. Is this a permissions
problem or something else? All users in question have ModifyTicket as
does Everyone.

Thanks

Alex

Drew Barnes
Applications Analyst
Raymond Walters College
University of Cincinnati