[ome-users] FW: Latest OMERO Binary repository

[Josh Moore]

Hi Kristin,

are you actively using the "default" and "guest" groups at your site? If not, your best bet is probably to move all data for users 4, 5, and 8 (and probably all others) to group 5 ("BSCL") and make that group collaborative or read-only depending on your needs.

To do that, execute a command like:

  psql -vGRP=5 -vUSR=4 -v ON_ERROR_STOP=1 --pset pager=off -h localhost -U omero -f omero-4.1-move-to-group.sql  omero

for each user. Once that's done, re-try the upgrade. If that's successful, get your 4.2 server running and then either from Insight or WebAdmin change the permissions on the group. You can read more about the meaning of the permissions system under http://www.openmicroscopy.org/site/support/omero4/server/permissions and a screencast for administering a group's permissions is available under http://cvs.openmicroscopy.org.uk/snapshots/movies/omero-4-2/mov/Permissions1.mov

If you _are_ using the groups "default" and "guest" actively, you'll need to decide whether or not to add user 8 back to group 3, or move all of 8's data into another group. You'll also need to change the groups for the projects and datasets marked "Different groups", but we could provide an example script for that if necessary.

Let us know how things go.
~Josh