<div>Steve, </div>
<div> </div>
<div>If I may contribute a bit, although I'm nowhere near as conversant in these as Chris, obviously. I had a similar problem as yours; the solution in my case was to go back to postgres, drop the omero database and user and then re-create the omero user and database (and language binding) again. Then do the "bin/omero db script" and choose a NEW password for omero's root!! Then run the psql bit for the OMERO4__0.sql and make sure that you get no error messages. Then start the omero server and log in on webadmin with the new password as root. It worked for me. </div>
<div> Hope this helps,</div>
<div> </div>
<div>Zoltan<br><br></div>
<div class="gmail_quote">On Thu, Apr 16, 2009 at 7:25 PM, Steve Guerrero <span dir="ltr"><<a href="mailto:guerrero.steve@gene.com">guerrero.steve@gene.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="PADDING-LEFT: 1ex; MARGIN: 0px 0px 0px 0.8ex; BORDER-LEFT: #ccc 1px solid">Hi Chris,<br><br>Thanks for your help. I tried logging in as root with the password I<br>assigned in the part you mentioned (in fact I have only used one<br>
password for everything so far, just to simplify my testing), but no<br>luck, it still won't log in.<br><br>I noticed there was a previous thread where someone had a similar<br>problem to mine that turned out to be a problem with their postgres<br>
installation (the thread subject: "Omero Beta 4 installation problems").<br><br>Although in my case, I only have one install of postgres, and that's<br>from a fresh install of ubuntu server, could it also be something<br>
related to the db connectivity? How might I test it? This simple test<br>seems to be successful:<br><br>calm@omeserver1:~/ome/omero-Beta4.0.0$ psql -h localhost -U omero -l<br>
<div class="im">Password for user omero:<br> List of databases<br> Name | Owner | Encoding<br>-----------+----------+----------<br> omero | omero | UTF8<br> postgres | postgres | UTF8<br> template0 | postgres | UTF8<br>
template1 | postgres | UTF8<br>(4 rows)<br><br><br></div>Thanks again,<br><font color="#888888">-sg<br></font>
<div>
<div></div>
<div class="h5"><br><br>Chris Roome wrote:<br>> Hi all,<br>><br>> Fixed.<br>><br>> In the end it was not a problem with the PostgreSQL database encoding,<br>> it was a problem with the manually installed postgresql and newly<br>
> created database. There were some executables from an older version of<br>> postgresql installed on the system which were not correctly removed.<br>><br>> After removal of these and re-creating the database, the installation<br>
> and server start went through faultlessly. The database encoding can be<br>> UTF8.<br>><br>> Many, many thanks to Josh for helping with this!<br>><br>> Regards,<br>><br>> Chris.<br>><br>><br>
> Chris Roome wrote:<br>>> Hi Josh,<br>>><br>>> Sure - will do!<br>>><br>>> Gone off list...<br>>><br>>> Chris.<br>>><br>>> <a href="mailto:josh.moore@gmx.de">josh.moore@gmx.de</a> wrote:<br>
>>> Well, congratulations, Chris, looks like you've found a new and<br>>>> interesting problem for us! I wouldn't think that this is related to<br>>>> the encoding, though you can certainly try that out. Could you<br>
>>> possibly send me your log files zipped us off list?<br>>>><br>>>> Thanks,<br>>>> ~Josh.<br>>>><br>>>> Chris Roome writes:<br>>>> > There was no extra configuration for postgreSQL. The output of<br>
>>> > 'bin/omero config get' gives:<br>>>> ><br>>>> > local/omero-Beta4.0.0> bin/omero config get<br>>>> > omero.data.dir=/usr/local/OMERO-DB<br>>>> > <a href="http://omero.db.name/" target="_blank">omero.db.name</a>=omero<br>
>>> > omero.db.pass=<my-password><br>>>> > omero.db.user=omero<br>>>> > with the correct db name, password and user.<br>>>> ><br>>>> > 'psql -U omero -h localhost omero' gives:<br>
>>> ><br>>>> > local/omero-Beta4.0.0> psql -U omero -h localhost omero<br>>>> > Password for user omero:<br>>>> > Welcome to psql 8.1.4, the PostgreSQL interactive terminal.<br>
>>> ><br>>>> > Type: \copyright for distribution terms<br>>>> > \h for help with SQL commands<br>>>> > \? for help with psql commands<br>>>> > \g or terminate with semicolon to execute query<br>
>>> > \q to quit<br>>>> ><br>>>> > omero=> \q<br>>>> ><br>>>> > One thing I did notice when setting up the postgres db was that the<br>>>> > encoding is 'UTF8' and not 'SQL_ASCII' as described in the installation<br>
>>> > instructions:<br>>>> ><br>>>> > local/omero-Beta4.0.0> psql -h localhost -U omero -l<br>>>> > Password for user omero:<br>>>> > List of databases<br>
>>> > Name | Owner | Encoding<br>>>> > -----------+----------+----------<br>>>> > omero | omero | UTF8<br>>>> > postgres | postgres | UTF8<br>>>> > template0 | postgres | UTF8<br>
>>> > template1 | postgres | UTF8<br>>>> > (4 rows)<br>>>> ><br>>>> > Could this be the problem?<br>>>> ><br>>>> > Many thanks for all your help!<br>
>>> ><br>>>> > Cheers,<br>>>> ><br>>>> > Chris.<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>
>> 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><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>
</div></div></blockquote></div><br><br clear="all"><br>-- <br><br>Zoltan Cseresnyes<br>Facility manager, Imaging Suite<br>