[ome-users] Omero Beta 4 installation problems

[Chris Roome]

Hi all,

Fixed.

In the end it was not a problem with the PostgreSQL database encoding,
it was a problem with the manually installed postgresql and newly
created database. There were some executables from an older version of
postgresql installed on the system which were not correctly removed.

After removal of these and re-creating the database, the installation
and server start went through faultlessly. The database encoding can be
UTF8.

Many, many thanks to Josh for helping with this!

Regards,

Chris.


Chris Roome wrote:
> Hi Josh,
> 
> Sure - will do!
> 
> Gone off list...
> 
> Chris.
> 
> josh.moore at gmx.de wrote:
>> Well, congratulations, Chris, looks like you've found a new and
>> interesting problem for us! I wouldn't think that this is related to
>> the encoding, though you can certainly try that out. Could you
>> possibly send me your log files zipped us off list?
>>
>> Thanks,
>> ~Josh.
>>
>> Chris Roome writes:
>>  > There was no extra configuration for postgreSQL. The output of
>>  > 'bin/omero config get' gives:
>>  > 
>>  > local/omero-Beta4.0.0> bin/omero config get
>>  > omero.data.dir=/usr/local/OMERO-DB
>>  > omero.db.name=omero
>>  > omero.db.pass=<my-password>
>>  > omero.db.user=omero
>>  > with the correct db name, password and user.
>>  > 
>>  > 'psql -U omero -h localhost omero' gives:
>>  > 
>>  > local/omero-Beta4.0.0> psql -U omero -h localhost omero
>>  > Password for user omero:
>>  > Welcome to psql 8.1.4, the PostgreSQL interactive terminal.
>>  > 
>>  > Type:  \copyright for distribution terms
>>  >        \h for help with SQL commands
>>  >        \? for help with psql commands
>>  >        \g or terminate with semicolon to execute query
>>  >        \q to quit
>>  > 
>>  > omero=> \q
>>  > 
>>  > One thing I did notice when setting up the postgres db was that the
>>  > encoding is 'UTF8' and not 'SQL_ASCII' as described in the installation
>>  > instructions:
>>  > 
>>  > local/omero-Beta4.0.0> psql -h localhost -U omero -l
>>  > Password for user omero:
>>  >         List of databases
>>  >    Name    |  Owner   | Encoding
>>  > -----------+----------+----------
>>  >  omero     | omero    | UTF8
>>  >  postgres  | postgres | UTF8
>>  >  template0 | postgres | UTF8
>>  >  template1 | postgres | UTF8
>>  > (4 rows)
>>  > 
>>  > Could this be the problem?
>>  > 
>>  > Many thanks for all your help!
>>  > 
>>  > Cheers,
>>  > 
>>  > Chris.
>> _______________________________________________
>> ome-users mailing list
>> ome-users at lists.openmicroscopy.org.uk
>> http://lists.openmicroscopy.org.uk/mailman/listinfo/ome-users
> _______________________________________________
> ome-users mailing list
> ome-users at lists.openmicroscopy.org.uk
> http://lists.openmicroscopy.org.uk/mailman/listinfo/ome-users

-- 
__________________________________________________________________

Chris Roome              t: +49 (0)6221 486 559
IT Services
Department of Biomolecular Mechanisms
Max Planck Institute for Medical Research (MPImF)
Jahnstrasse 29
69120 Heidelberg         w: www.mpimf-heidelberg.mpg.de/english
Germany
__________________________________________________________________