[ome-users] Insight login failure

[Simon Li]

Hi Kieran

I should've asked you this earlier- could you zip up your server log files and upload them to http://qa.openmicroscopy.org.uk/qa/upload/

More comments in line....

On 4 March 2015 at 14:13, Kieran McGourty <kieran.mcgourty at gmail.com<mailto:kieran.mcgourty at gmail.com>> wrote:
...

I think this the account that I created most recently. Foolishly I gave it the same login credentials as my missing account so I am not sure if this config refers to my new account or the missing one.

C:\omeroserverfiles>bin\omero config get

omero.data.dir=C:\\omero
omero.db.name<http://omero.db.name>=omero_database
omero.db.pass=***************
omero.db.user=kmcg
omero.web.application_server=development
omero.web.debug=True

below is a print screen of the managed repositories on the HDD. My missing data is in the folder kmcg_2. Most recently uploaded to on the 24 feb. I am not sure where or when the _2 suffix came from but I suspect it is when I created the new kmcg account after the problem manifested.

The "2" is the numeric user-id

...

 Have you previously setup OMERO on the same system (e.g. for initial testing)?
Yes

 What other databases do you have on your system?
I downloaded and installed MYSQL and set up a training database but it is not running at the moment and I have't altered that in a long while.
During the initial server installation I created a second OMERO database called omero_database1.

The missing user account does not have ownership of this database though. (kmcg = omero_database, superkmcg = omero_database1)


Could you log into each of those databases using the psql client, run the following and paste the output here?
SELECT * from dbpatch;

If it's a new server you should see just one line with a timestamp corresponding to when you installed the servers- do they both look correct (for your current and previous DBs/servers)?

...


I have the following users listed.

C:\omeroserverfiles>bin\omero user list
Using session b4792158-32a2-46c2-95ae-caece4bc2f7d (root at localhost:4064). Idle t
imeout: 10.0 min. Current group: system
 id | login | first name | last name | email                     | active | admin
n | member of | owner of
----+-------+------------+-----------+---------------------------+--------+-----
--+-----------+----------
 0  | root  | root       | root      |                           | Yes    | Yes
  |           |
 1  | guest | Guest      | Account   |                           |        |
  | 2         |
 2  | kmcg  | Kieran     | McGourty  | kieran.mcgourty at gmail.com<mailto:kieran.mcgourty at gmail.com> | Yes    |
  |           | 2
(3 rows)

C:\omeroserverfiles>


Cheers

Thanks a lot Simon

Simon

On 4 March 2015 at 13:35, Simon Li <spli at dundee.ac.uk<mailto:spli at dundee.ac.uk>> wrote:
Hi Kieran

Could you give us a bit more explanation about how you originally setup the server, how you created your users (e.g. manually, or using LDAP), whether you've done any system modifications recently such as upgrading or reinstalling OMERO, postgres, or any other OS upgrades, etc. Could you also post the output of `bin\omero config get` (blank out any passwords).

Do you have any other OMERO.servers? For example could you have inadvertently connected to a different one? Have you previously setup OMERO on the same system (e.g. for initial testing)? What other databases do you have on your system?

Cheers

Simon


On 4 March 2015 at 12:26, Kieran McGourty <kieran.mcgourty at gmail.com<mailto:kieran.mcgourty at gmail.com>> wrote:


Dear Josh and OMERO users,

For some reason today when I tried to connect to my Omero server I was unable to. Upon further inspection I found that all the user profiles I added were missing. I was able to login to root user but there were no other users recorded on the system. I was also able to create a new user from root and then to login to that account.

using the cmd line to
 bin\omero user list
 yields only root and guest accounts.

My database appears to still be there. I am able to connect to it using postgresql. I also am able to launch the postgresql shell and connect to my databases in all previously created users.

server admin diagnostics are normal. Everything appears to be working and writeable.

Is there a way to pull in previously created user profiles with associated data?

Thanks a lot,

Kieran

p.s. I looked on the forum for someone who had this issue previously but could not find any. Sorry if this was covered previously, I do not wish to spam.


Here is a copy of my diagnostics



The University of Dundee is a registered Scottish Charity, No: SC015096

_______________________________________________
ome-users mailing list
ome-users at lists.openmicroscopy.org.uk<mailto:ome-users at lists.openmicroscopy.org.uk>
http://lists.openmicroscopy.org.uk/mailman/listinfo/ome-users



The University of Dundee is a registered Scottish Charity, No: SC015096

_______________________________________________
ome-users mailing list
ome-users at lists.openmicroscopy.org.uk<mailto:ome-users at lists.openmicroscopy.org.uk>
http://lists.openmicroscopy.org.uk/mailman/listinfo/ome-users



The University of Dundee is a registered Scottish Charity, No: SC015096

_______________________________________________
ome-users mailing list
ome-users at lists.openmicroscopy.org.uk<mailto:ome-users at lists.openmicroscopy.org.uk>
http://lists.openmicroscopy.org.uk/mailman/listinfo/ome-users



The University of Dundee is a registered Scottish Charity, No: SC015096
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openmicroscopy.org.uk/pipermail/ome-users/attachments/20150304/1339d2a3/attachment.html>