[ome-users] Omero Beta 4 installation problems

[Chris Roome]

Hi Josh,

Thanks for the fast response!

josh.moore at gmx.de wrote:
<snip>
> 
> Right. In the latest version we've added a timeout of 5 minutes, but
> it's expected that icegridadmin will be called periodically, with the
> hope that your server comes up.
> 

Ok.

>  > If I try to run this command directly from the shell, I get:
>  > 
>  > local/omero-Beta4.0.0> icegridadmin
>  > --Ice.Config=/usr/local/omero-Beta4.0.0/etc/internal.cfg -e node ping master
>  > icegridadmin: too many arguments
> 
> You need to add quotes here:  ... -e "node ping master"

Thanks for that.

<snip>
> 
> Great. Thanks. This is the bit that's getting you:
> 
>  > 2009-04-07 16:41:38,046 ERROR [ome.services.db.SelfCorrectingDataSource]
>  > (      main) Failed to acquire connection after retries=3
>  > java.sql.SQLException: unable to get a connection from pool of a
>  > PoolingDataSource containing an XAPool of resource
>  > 6046fc17-e86a-4705-8b4a-1790059947ab with 0 connec
> 
> Your database is not reachable. Did you do any extra configuration? If
> so, what does `bin/omero config get` look like? Does `psql -U omero -h
> localhost omero` (or your values for those properties) work?
>

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.