<html>

<head>

<meta http-equiv="Content-Type" content="text/html; charset=us-ascii">

</head>

<body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space;" class="">

Hi Qi,

<div class=""><br class="">

</div>

<div class="">can you check that the owner of the omero database is the omero user/login role you created previously.</div>

<div class="">With pgAdmin 4 it would look like this (instead your database name as well as login role apparently would be "testOmero"):</div>

<div class=""><br class="">

</div>

<div class=""><img apple-inline="yes" id="CA34773A-360E-4970-BCFB-14E427862B0D" height="191" width="512" apple-width="yes" apple-height="yes" src="cid:C8F9EB75-6D66-43EC-8BCC-0DEEC65CCFD5@lifesci.dundee.ac.uk" class=""></div>

<div class=""><br class="">

</div>

<div class="">Also check that the omero user/login role has the permission to log in.</div>

<div class="">With pgAdmin 4 it would look like this:</div>

<div class=""><br class="">

</div>

<div class=""><img apple-inline="yes" id="D572062E-5814-4C48-A382-E3AC82A2301C" height="327" width="507" apple-width="yes" apple-height="yes" src="cid:27113DEA-D1A5-47B4-AC76-8847A6EBE0D9@lifesci.dundee.ac.uk" class=""></div>

<div class=""><br class="">

</div>

<div class="">Regards,</div>

<div class="">Dominik</div>

<div class=""><br class="">

</div>

<div class=""><br class="">

<div>

<blockquote type="cite" class="">

<div class="">On 3 Mar 2017, at 21:55, Qi Gong <<a href="mailto:qigong@gwmail.gwu.edu" class="">qigong@gwmail.gwu.edu</a>> wrote:</div>

<br class="Apple-interchange-newline">

<div class="">

<div dir="ltr" class="">Hello Dominik,

<div class=""><br class="">

</div>

<div class="">Sorry for reply late. The "<span style="font-size:12.8px" class="">Set the data directory" command is working. Now I could set root_password. But I still face some problem. (I set root password to "testOmeroRoot")</span></div>

<div class=""><span style="font-size:12.8px" class=""><br class="">

</span></div>

<div class=""><span style="font-size:12.8px" class="">1. In SQL Shell. It says the role is not permitted.</span></div>

<div class=""><span style="font-size:12.8px" class="">2. In cmd, there is diagnostics problem.</span></div>

<div class=""><span style="font-size:12.8px" class="">3. In cmd, can't start admin.</span></div>

<div class=""><span style="font-size:12.8px" class=""><br class="">

</span></div>

<div class=""><span style="font-size:12.8px" class="">Thank you very much. </span></div>

<div class=""><span style="font-size:12.8px" class=""><br class="">

</span></div>

<div class=""><span style="font-size:12.8px" class="">Regards,</span></div>

<div class=""><span style="font-size:12.8px" class="">Qi</span></div>

</div>

</div>

</blockquote>

</div>

<br class="">

</div>

<br>

<span style="font-size:10pt;">The University of Dundee is a registered Scottish Charity, No: SC015096</span>

</body>

</html>