Page 1 of 1

Retrieve data LDAP users

PostPosted: Thu Aug 16, 2018 10:57 am
by pdebeule
We have an installation of OMERO 5.0.8. working on a CENTOS server, using OMERO.insight and internet browser to manage data. LDAP connection between OMERO and our institute login was enabled by a former employee. For some reason, the LDAP connection was lost and several users can no longer login.
How can we retrieve data from the LDAP users?

This does not seem to be possible through the JAVA app OMERO.insight. We have access to the OMERO system through CYGWIN. What kind of actions would be required to
1) restore LDAP access of the users
2) reset the password of OMERO LDAP users
or
3) migrate all data from LDAP user to newly created user?

Re: Retrieve data LDAP users

PostPosted: Thu Aug 16, 2018 12:26 pm
by jmoore
Hi Pieter,

pdebeule wrote:We have an installation of OMERO 5.0.8. working on a CENTOS server, using OMERO.insight and internet browser to manage data.


Wow. Upfront: We cannot provide our usual support for servers that are that old. We highly suggest that you upgrade your server as soon as possible.

...For some reason, the LDAP connection was lost and several users can no longer login.


Were there any particular messages in the log files when this happened or when users try to login? What do the users see? Have you see a log file from any of your users' clients?

How can we retrieve data from the LDAP users? What kind of actions would be required to
1) restore LDAP access of the users
2) reset the password of OMERO LDAP users
or
3) migrate all data from LDAP user to newly created user?


The first step is to get a list of the LDAP users who cannot login as well as at least one LDAP user who can login and compare their settings in the experimenter and password tables of the PostgreSQL database, especially the "dn" field of "password":

see https://github.com/openmicroscopy/openmicroscopy/blob/v.5.0.8/sql/psql/OMERO5.0__0/psql-footer.sql#L2173

Cheers,
~Josh