Earlier today in my companies davical install the Relationship entry id3
(Can read from). was deleted due to user error. This naturally had the
effect of removing the read only permission from all calendars where it was
used.
Since we have a large number of users and permissions we didn't want to try
to restore them all by hand.
The last database backup we had was a day old so rather than remove all
calendar entries added in the last day by restoring the entire backup we
tried restoring just the relationship_type and relationship tables back to
their state when the backup was made.
On the surface that seemed to work, all the readonly permissions mappings
returned in the web interface and testing from sunbird/lightning we could
access calendars again. However we noticed later on that if in iCal we
went to the Delegations tab under account settings that groups were being
listed rather than the users that the group should give access to. (for
example we have a group called global-read-access which most calendar users
have a readonly relationship to so that they all can read each other's
calendars. Previously we would see all those users listed in the
delegation tab list but now we just see global-read-access listed.)
I can only assume at this point our database restore has not quite worked as
well as we hoped. Can anybody point us in the direction of what we have
broken?
Thanks
-J
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.morphoss.com/pipermail/davical-users/attachments/20091127/fee22cbf/attachment.htm>
-------------- next part --------------
(Can read from). was deleted due to user error. This naturally had the
effect of removing the read only permission from all calendars where it was
used.
Since we have a large number of users and permissions we didn't want to try
to restore them all by hand.
The last database backup we had was a day old so rather than remove all
calendar entries added in the last day by restoring the entire backup we
tried restoring just the relationship_type and relationship tables back to
their state when the backup was made.
On the surface that seemed to work, all the readonly permissions mappings
returned in the web interface and testing from sunbird/lightning we could
access calendars again. However we noticed later on that if in iCal we
went to the Delegations tab under account settings that groups were being
listed rather than the users that the group should give access to. (for
example we have a group called global-read-access which most calendar users
have a readonly relationship to so that they all can read each other's
calendars. Previously we would see all those users listed in the
delegation tab list but now we just see global-read-access listed.)
I can only assume at this point our database restore has not quite worked as
well as we hoped. Can anybody point us in the direction of what we have
broken?
Thanks
-J
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.morphoss.com/pipermail/davical-users/attachments/20091127/fee22cbf/attachment.htm>
-------------- next part --------------