<div dir="ltr"><div><div><div style="font-size:12.8000001907349px"><div>Hi Kieran<br><b>Hi Simon, Thanks for getting back to me</b></div><div><br></div>Could you give us a bit more explanation about how you originally setup the server,</div><div style="font-size:12.8000001907349px">how you created your users (e.g. manually, or using LDAP),</div><div style="font-size:12.8000001907349px"><br></div><div style="font-size:12.8000001907349px"><b>I created users manually in INSIGHT</b></div><div style="font-size:12.8000001907349px"><br></div><div style="font-size:12.8000001907349px"> whether you've done any system modifications recently such as upgrading or reinstalling OMERO,</div><div style="font-size:12.8000001907349px"><b>No</b></div><div style="font-size:12.8000001907349px"><b><br></b></div><div style="font-size:12.8000001907349px"> postgres,</div><div style="font-size:12.8000001907349px"><b>No</b></div><div style="font-size:12.8000001907349px"> or any other OS upgrades,</div><div style="font-size:12.8000001907349px"><b>Win7 Auto updates off... I have just, post problem manifestation, updated Java to 8.40</b></div><div style="font-size:12.8000001907349px"><br></div><div style="font-size:12.8000001907349px">etc. Could you also post the output of `bin\omero config get` (blank out any passwords).<br><br></div><div style="font-size:12.8000001907349px"><b>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. </b></div><div style="font-size:12.8000001907349px"><b><br></b></div><div><span style="font-size:12.8000001907349px"><b><div><b style="font-size:12.8000001907349px"><div style="display:inline!important">C:\omeroserverfiles>bin\omero config get</div></b><br></div><div>omero.data.dir=C:\\omero</div><div><a href="http://omero.db.name" target="_blank">omero.db.name</a>=omero_database</div><div>omero.db.pass=***************</div><div>omero.db.user=kmcg</div><div>omero.web.application_server=development</div><div>omero.web.debug=True</div><div><br></div><div>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. </div><div><br></div><div><br></div></b></span></div><div style="font-size:12.8000001907349px"><img src="cid:ii_14be512e5e49ead3" alt="Inline images 1" width="562" height="351"><br></div><div style="font-size:12.8000001907349px"><br></div><span style="font-size:12.8000001907349px">Do you have any other OMERO.servers? </span></div><div><span style="font-size:12.8000001907349px"><b>I have only one OMERO server. I verified that I am trying to connect to either local host (on the server) or to the correct IP address (from my laptop).</b></span></div><div><span style="font-size:12.8000001907349px"><br></span></div><div><span style="font-size:12.8000001907349px">For example could you have inadvertently connected to a different one?</span></div><div><span style="font-size:12.8000001907349px"><b>No</b></span></div><div><span style="font-size:12.8000001907349px"><br></span></div><div><span style="font-size:12.8000001907349px"> Have you previously setup OMERO on the same system (e.g. for initial testing)?</span></div><div><span style="font-size:12.8000001907349px"><b>Yes</b></span></div><div><span style="font-size:12.8000001907349px"><b><br></b></span></div><div><span style="font-size:12.8000001907349px"> What other databases do you have on your system?</span><br><b>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. </b></div><div><b>During the initial server installation I created a second OMERO database called omero_database1.</b></div><div><br></div><div><b>The missing user account does not have ownership of this database though. (kmcg = omero_database, superkmcg = omero_database1)</b></div><div><b><img src="cid:ii_14be516c69496261" alt="Inline images 2" width="562" height="351"><br></b></div><div><b><img src="cid:ii_14be51935b2c50e8" alt="Inline images 3" width="562" height="351"><br></b></div><div><b><br></b></div><div><b>I have the following users listed.</b></div><div><b><br></b></div><div><b><div>C:\omeroserverfiles>bin\omero user list</div><div><div>Using session b4792158-32a2-46c2-95ae-caece4bc2f7d (root@localhost:4064). Idle t</div><div>imeout: 10.0 min. Current group: system</div><div> id | login | first name | last name | email | active | admin</div><div>n | member of | owner of</div><div>----+-------+------------+-----------+---------------------------+--------+-----</div><div>--+-----------+----------</div><div> 0 | root | root | root | | Yes | Yes</div><div> | |</div><div> 1 | guest | Guest | Account | | |</div><div> | 2 |</div><div> 2 | kmcg | Kieran | McGourty | <a href="mailto:kieran.mcgourty@gmail.com">kieran.mcgourty@gmail.com</a> | Yes |</div><div> | | 2</div><div>(3 rows)</div><div><br></div><div>C:\omeroserverfiles></div></div></b></div><div><br></div><div><br></div><span style="font-size:12.8000001907349px">Cheers</span></div><div><span style="font-size:12.8000001907349px"><br></span></div><div><span style="font-size:12.8000001907349px"><b>Thanks a lot Simon</b><br></span><br></div><span style="font-size:12.8000001907349px">Simon</span><br></div><div class="gmail_extra"><br><div class="gmail_quote">On 4 March 2015 at 13:35, Simon Li <span dir="ltr"><<a href="mailto:spli@dundee.ac.uk" target="_blank">spli@dundee.ac.uk</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div>
<div dir="ltr">
<div>
<div>
<div>
<div>Hi Kieran<br>
<br>
</div>
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).<br>
<br>
</div>
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?<br>
<br>
</div>
Cheers<br>
<br>
</div>
Simon<br>
<div>
<div><br>
</div>
</div>
</div>
<div class="gmail_extra"><br>
<div class="gmail_quote"><div><div class="h5">On 4 March 2015 at 12:26, Kieran McGourty <span dir="ltr">
<<a href="mailto:kieran.mcgourty@gmail.com" target="_blank">kieran.mcgourty@gmail.com</a>></span> wrote:<br>
</div></div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div><div><div class="h5">
<div dir="ltr">
<div><br>
</div>
<div><br>
</div>
Dear Josh and OMERO users,
<div><br>
</div>
<div>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.</div>
<div><br>
</div>
<div>using the cmd line to </div>
<div><span style="font-size:12.8000001907349px"> bin\</span><span style="font-size:12.8000001907349px">omero</span><span style="font-size:12.8000001907349px"> user list</span><br>
</div>
<div><span style="font-size:12.8000001907349px"> yields only root and guest accounts. </span></div>
<div><br>
</div>
<div>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. </div>
<div><br>
</div>
<div>server admin diagnostics are normal. Everything appears to be working and writeable.</div>
<div><br>
</div>
<div>Is there a way to pull in previously created user profiles with associated data?</div>
<div><br>
</div>
<div>Thanks a lot,</div>
<div><br>
</div>
<div>Kieran</div>
<div><br>
</div>
<div>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.</div>
<div><br>
</div>
<div><br>
</div>
<div>Here is a copy of my diagnostics </div>
<div><br>
</div>
<div><br>
</div>
</div>
<br>
</div></div><span style="font-size:10pt">The University of Dundee is a registered Scottish Charity, No: SC015096</span>
</div>
<br>
_______________________________________________<br>
ome-users mailing list<br>
<a href="mailto:ome-users@lists.openmicroscopy.org.uk" target="_blank">ome-users@lists.openmicroscopy.org.uk</a><br>
<a href="http://lists.openmicroscopy.org.uk/mailman/listinfo/ome-users" target="_blank">http://lists.openmicroscopy.org.uk/mailman/listinfo/ome-users</a><br>
<br>
</blockquote>
</div>
<br>
</div>
<br>
<span style="font-size:10pt">The University of Dundee is a registered Scottish Charity, No: SC015096</span>
</div>
<br>_______________________________________________<br>
ome-users mailing list<br>
<a href="mailto:ome-users@lists.openmicroscopy.org.uk">ome-users@lists.openmicroscopy.org.uk</a><br>
<a href="http://lists.openmicroscopy.org.uk/mailman/listinfo/ome-users" target="_blank">http://lists.openmicroscopy.org.uk/mailman/listinfo/ome-users</a><br>
<br></blockquote></div><br></div>