On Thu, Aug 24, 2006 at 05:50:53PM +0200, Theo Kramer wrote:
> > > But I do not know what RT does by default when a ticket is created on
> > > receipt of an email - ie. does it set OwnTicket even if the permissions
> > > are set as above?
> >
> > It should not.
>
> Hmmm - perhaps some history would be useful
>
> Our system was migrated from RT 2 to RT 3.0.2 which we are currently
> running. The problem occurs when trying to upgrade to RT 3.4.[4-5] -
> tried both.
>
> I decided to do some testing by submitting a ticket from a non existent
> user via email to our upgrade test system running 3.4.5.
>
> I executed the following query (as derived from the mysql logs)
>
> SELECT COUNT(DISTINCT main.Name) FROM
> Users main,
> Principals Principals_1,
> ACL ACL_2,
> CachedGroupMembers CachedGroupMembers_3
> WHERE ((ACL_2.PrincipalId = CachedGroupMembers_3.GroupId))
> AND ((ACL_2.PrincipalType = 'Group'))
> AND ((ACL_2.RightName = 'OwnTicket'))
> AND ((CachedGroupMembers_3.MemberId = Principals_1.id))
> AND ((Principals_1.Disabled = '0'))
> AND ((Principals_1.PrincipalType = 'User'))
> AND ((Principals_1.id != '1'))
> AND ((main.id = Principals_1.id))
> AND ((ACL_2.ObjectType = 'RT::Queue') OR
> (ACL_2.ObjectType = 'RT::System'));
>
> The value returned before emailing the new ticket was 97602 and after
> sending a new ticket from an arbitrary new email address it went up to
> 97603...
>
> This with the permissions as above.
>
> I then decided to do the same with RT 3.6.1 but with an empty database.
> Before emailing a ticket the value returned was 1 (user Nobody), and
> after emailing a ticket the value returned was still 1.
Yes. That's saying the same thing as "the owner dropdown has too many
people in it"
>
> So this now raises the following question
>
> Is it possible that somehow permissions for Everyone includes
> 'OwnTicket' but is not visible via the configuration interface?
I suspect, but can't prove, that you're just not looking in the right
place.
Send this to the list:
SELECT * FROM ACL WHERE RightName = 'OwnTicket';
_______________________________________________
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
