<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
</head>
<body>
<div dir="ltr">
<div>Hi Kieran<br>
<br>
</div>
<div>I should've asked you this earlier- could you zip up your server log files and upload them to
<a href="http://qa.openmicroscopy.org.uk/qa/upload/">http://qa.openmicroscopy.org.uk/qa/upload/</a><br>
</div>
<br>
More comments in line....<br>
<div>
<div><br>
On 4 March 2015 at 14:13, Kieran McGourty <span dir="ltr"><<a href="mailto:kieran.mcgourty@gmail.com" target="_blank">kieran.mcgourty@gmail.com</a>></span> wrote:<br>
<div class="gmail_extra">
<div class="gmail_quote">
<div>...<br>
</div>
<blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">
<div>
<div dir="ltr">
<div>
<div><span>
<div style="font-size:12.8px"></div>
</span>
<div style="font-size:12.8px"><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.8px"><b><br>
</b></div>
<div><span style="font-size:12.8px"><b>
<div><b style="font-size:12.8px">
<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>
</b></span></div>
</div>
</div>
</div>
</div>
</blockquote>
<div><br>
</div>
<div>The "2" is the numeric user-id<br>
</div>
<div><br>
... <br>
<br>
</div>
<blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">
<div>
<div dir="ltr">
<div><span>
<div><span style="font-size:12.8px"></span></div>
<div><span style="font-size:12.8px"> Have you previously setup OMERO on the same system (e.g. for initial testing)?</span></div>
</span>
<div><span style="font-size:12.8px"><b>Yes</b></span></div>
<div><span style="font-size:12.8px"><b><br>
</b></span></div>
<div><span><span style="font-size:12.8px"> What other databases do you have on your system?</span><br>
</span><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></b><br>
</div>
</div>
</div>
</div>
</blockquote>
<div><br>
</div>
<div>Could you log into each of those databases using the psql client, run the following and paste the output here?<br>
</div>
<div>SELECT * from dbpatch;<br>
</div>
<div><br>
</div>
<div>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)?<br>
</div>
<div><br>
...<br>
</div>
<blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">
<div>
<div dir="ltr">
<div>
<div><b></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" target="_blank">
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.8px">Cheers</span></div>
<div><span style="font-size:12.8px"><br>
</span></div>
<div><span style="font-size:12.8px"><b>Thanks a lot Simon</b><br>
</span><br>
</div>
<span style="font-size:12.8px">Simon</span><br>
</div>
<div>
<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:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);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>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:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">
<div>
<div>
<div>
<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.8px"> bin\</span><span style="font-size:12.8px">omero</span><span style="font-size:12.8px"> user list</span><br>
</div>
<div><span style="font-size:12.8px"> 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" 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>
</div>
</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>
</div>
</div>
</div>
<br>
<span style="font-size:10pt;">The University of Dundee is a registered Scottish Charity, No: SC015096</span>
</body>
</html>