Re: [Phpgroupware-users] Calendar Perms: Conclusion

[Daryl L. L. Houston]

Since I generated a fair amount of mail about this, I thought I'd post a 
follow-up.  I resolved the issue at last by writing down all the groups and 
members and their access levels, deleting all data in the phpgw_acl table, 
and re-entering all the data using the group manager.  The problem is now 
gone.  I can't fathom how simply moving data from one database to the other 
(maintaing user ids, etc.) could have caused such problems, but resetting 
everything manually fixed the issue.  It appears to have been a data issue 
and not a code issue.  Thanks again to those who replied to my questions.

D


On Wednesday 18 June 2003 10:06 am, Daryl L. L. Houston wrote:
> Now for a final bit of info that may help pinpoint the problem. I have
> several groups defined.  Among them are "Calendar" and "Admin."  Everybody
> is added to the Calendar group.  I've made the Calendar and Admin group
> permissions identical, the best I can tell (as demonstrated in the mysql
> output pasted in below).  I create a new user and add him to the Calendar
> group and the problem is solved.  I add the new user to both groups and the
> problem is back.  I add the new user only to the Admin group and the
> problem persists. It appears that there's some conflict among groups.  Is
> there some fundamental feature of the permissions system that I'm just
> setting incorrectly?  I pulled all of my original permissions over from an
> older install in which this problem did not arise.  Thanks again for the
> responses so far and for any further help anyone can provide.
>
> D
>
>
> ### Calendar Group
> mysql> select * from phpgw_acl where acl_account=599548 order by
> acl_location; +-------------+--------------+-------------+------------+
>
> | acl_appname | acl_location | acl_account | acl_rights |
>
> +-------------+--------------+-------------+------------+
>
> | calendar    | 490417       |      599548 |         15 |
> | calendar    | 599437       |      599548 |         15 |
> | calendar    | 599442       |      599548 |         15 |
> | calendar    | 599447       |      599548 |         15 |
> | calendar    | 599448       |      599548 |         15 |
> | calendar    | 599497       |      599548 |         15 |
> | calendar    | 599498       |      599548 |         15 |
> | calendar    | 599499       |      599548 |         15 |
> | calendar    | 599500       |      599548 |         15 |
> | calendar    | 599507       |      599548 |         15 |
> | calendar    | 599511       |      599548 |         15 |
> | calendar    | 599512       |      599548 |         15 |
> | calendar    | 599513       |      599548 |         15 |
> | calendar    | 599537       |      599548 |         15 |
> | calendar    | 599548       |      599548 |         15 |
> | projects    | 599548       |      599548 |         15 |
> | calendar    | run          |      599548 |          1 |
> | projects    | run          |      599548 |          1 |
>
> +-------------+--------------+-------------+------------+
> 18 rows in set (0.00 sec)
>
>
> ### Admin Group
> mysql> select * from phpgw_acl where acl_account=599437 order by
> acl_location; +-------------+--------------+-------------+------------+
>
> | acl_appname | acl_location | acl_account | acl_rights |
>
> +-------------+--------------+-------------+------------+
>
> | calendar    | 490417       |      599437 |         15 |
> | projects    | 599437       |      599437 |         15 |
> | calendar    | 599437       |      599437 |         15 |
> | calendar    | 599442       |      599437 |         15 |
> | calendar    | 599447       |      599437 |         15 |
> | calendar    | 599448       |      599437 |         15 |
> | calendar    | 599497       |      599437 |         15 |
> | calendar    | 599498       |      599437 |         15 |
> | calendar    | 599499       |      599437 |         15 |
> | calendar    | 599500       |      599437 |         15 |
> | calendar    | 599507       |      599437 |         15 |
> | calendar    | 599511       |      599437 |         15 |
> | calendar    | 599512       |      599437 |         15 |
> | calendar    | 599513       |      599437 |         15 |
> | calendar    | 599537       |      599437 |         15 |
> | calendar    | 599547       |      599437 |         15 |
> | calendar    | 599548       |      599437 |         15 |
> | projects    | run          |      599437 |          1 |
> | calendar    | run          |      599437 |          1 |
>
> +-------------+--------------+-------------+------------+
>
> On Tuesday 17 June 2003 01:00 pm, Daryl L. L. Houston wrote:
> > No, this first appeared in production with a user who was logged in only
> > once. To verify that this wasn't the issue, I've just now logged out and
> > made sure I had no sessions still open.  Then I clicked through the
> > calendar and caused the problem, verifying after each click that I had
> > only one session open. Thanks for the tip, though.
> >
> > D
> >
> > On Tuesday 17 June 2003 12:03 pm, BOYER PASCAL wrote:
> > > Daryl L. L. Houston wrote:
> > > >I just deployed a release of .916 (.914.506, to be precise) and have
> > > > met the following calendar challenge:
> > > >
> > > >John Doe navigates from his calendar to Joe Smith's calendar by using
> > > > the appropriate select box.  When he hits the back button to return
> > > > to his calendar, he's sent to an entirely different user's calendar. 
> > > > This seems to happen sporadically and can be gotten around by telling
> > > > users not to use the back button, if nothing else.  That's why
> > > > there's nav, after all. But when John Doe tries to return to his
> > > > calendar by selecting his name from the select box, he's taken to his
> > > > calendar with no events showing. Initially, I thought it was
> > > > defaulting to display only private events, but when I created a
> > > > private event to test this out, I discovered that it's declining to
> > > > show any events, period.  In order for John Doe to see his calendar
> > > > after doing this, he has to log out of groupware and back in.
> > > >
> > > >Has anybody else encountered this?  I'm still looking around for a
> > > >cause/solution, but if anybody's already figured it out, I'd
> > > > appreciate hearing about the solution.  Thanks,
> > > >
> > > >D
> > > >
> > > >
> > > >
> > > >_______________________________________________
> > > >Phpgroupware-users mailing list
> > > >address@hidden
> > > >http://mail.gnu.org/mailman/listinfo/phpgroupware-users
> > >
> > > Aren't you testing the calendar with two opened sessions on the same
> > > browser ? Because I notice some strange behaviors in such
> > > circumstances. Now, I do my tests with two differente browsers. With
> > > Linux, I use Mozilla (whitch works very fine with M$ and Galeon) and
> > > I've no more problems.
> > >
> > > Pascal -- France
> > >
> > >
> > >
> > > _______________________________________________
> > > Phpgroupware-users mailing list
> > > address@hidden
> > > http://mail.gnu.org/mailman/listinfo/phpgroupware-users
> >
> > _______________________________________________
> > Phpgroupware-users mailing list
> > address@hidden
> > http://mail.gnu.org/mailman/listinfo/phpgroupware-users
>
> _______________________________________________
> Phpgroupware-users mailing list
> address@hidden
> http://mail.gnu.org/mailman/listinfo/phpgroupware-users