<div>Dear List members,</div>
<div> </div>
<div>I would like to use the OME list to thank Chris Roome for his excellent help in troubleshooting my Omero4 installation process on Linux (SLES10 SP2). With his help I'm now successfully running the server. I contacted him directly off-line last week, because his original problem posted earlier in this thread was similar to mine at the time.</div>
<div> Excellent list indeed! Thanks to all those who help us building these apps and dealing with our problems! </div>
<div> Best regards,</div>
<div> </div>
<div>Zoltan<br><br></div>
<div class="gmail_quote">On Wed, Apr 8, 2009 at 12:51 PM, Chris Roome <span dir="ltr"><<a href="mailto:Chris.Roome@mpimf-heidelberg.mpg.de">Chris.Roome@mpimf-heidelberg.mpg.de</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="PADDING-LEFT: 1ex; MARGIN: 0px 0px 0px 0.8ex; BORDER-LEFT: #ccc 1px solid">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>
<div>
<div></div>
<div class="h5"><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></div></div>--<br>__________________________________________________________________<br><font color="#888888"><br>Chris Roome t: +49 (0)6221 486 559<br>IT Services<br>Department of Biomolecular Mechanisms<br>
Max Planck Institute for Medical Research (MPImF)<br>Jahnstrasse 29<br>69120 Heidelberg w: <a href="http://www.mpimf-heidelberg.mpg.de/english" target="_blank">www.mpimf-heidelberg.mpg.de/english</a><br>Germany<br>
__________________________________________________________________<br></font>
<div>
<div></div>
<div class="h5"><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>
<div><br><br clear="all"><br>-- <br><br>Zoltan Cseresnyes<br>Facility manager, Imaging Suite</div>
<div>University of Cambridge, UK<br></div>