[ome-users] Again cannot connect to WebAdmin after 3.2 upgrade

[Mario Valle]

I just upgraded my OMERO installation from beta 3.1.1 to beta 3.2 on Mac OSX 10.4.
And again I cannot connect to WebAdmin.
Remember, last upgrade I was forced to wipe-out the database and reinstall everything from 
scratch. This time I want to avoid this...

So here the steps I followed, please check if I missed something essential.
1) Unpacked the kit to a new directory (/omero-Beta3.2)
2) Copied local.properties form the 3.1.1 installation to the 3.2 /etc directory
3) Started the server (under sudo):
#!/bin/sh
JBOSS_HOME=/omero-Beta3.2/jboss-4.2.3.GA
export JBOSS_HOME
$JBOSS_HOME/bin/run.sh >/tmp/omero.log 2>&1 &
4) Tried to connect to http://machine.cscs.ch:8080/WebAdmin
The error I receive is:

Connection failure: Error creating bean with name 'init' defined in class path resource 
[ome/client/spring.xml]: Cannot resolve reference to bean 'managed-ome.api.ISession' while 
setting bean property 'sessionService'; nested exception is 
org.springframework.beans.factory.BeanCreationException: Error creating bean with name 
'managed-ome.api.ISession': FactoryBean threw exception on object creation; nested 
exception is ome.client.OutOfService: Cannot initialize service proxy

5) Maybe I missed the deploy step...
So I executed java omero setup-db deploy, but obtain the following messages:

Buildfile: build.xml

prepare:
Created dir: /omero-Beta3.2/omero/target
Created dir: /omero-Beta3.2/omero/target/generated/.done
Created dir: /omero-Beta3.2/omero/target/generated/src
Created dir: /omero-Beta3.2/omero/target/generated/resources
Created dir: /omero-Beta3.2/omero/target/classes
Created dir: /omero-Beta3.2/omero/target/test-classes
Created dir: /omero-Beta3.2/omero/target/reports
Copying 1 file to /omero-Beta3.2/omero/target/generated/resources
Copying 1 file to /omero-Beta3.2/omero/target/classes
Copying 1 file to /omero-Beta3.2/omero/target/generated/resources
Copying 1 file to /omero-Beta3.2/omero/target/classes
Copying 1 file to /omero-Beta3.2/omero/target/generated/resources
Copying 1 file to /omero-Beta3.2/omero/target/classes
Copying 1 file to /omero-Beta3.2/omero/target/generated/resources
Copying 1 file to /omero-Beta3.2/omero/target/classes
Copying 1 file to /omero-Beta3.2/omero/target/generated/resources
Copying 1 file to /omero-Beta3.2/omero/target/classes
Could not load definitions from resource emma_ant.properties. It could not be found.

setup-db:
Copying 1 file to /omero-Beta3.2/omero/target
Copying 1 file to /omero-Beta3.2/omero/target
Copying 1 file to /omero-Beta3.2/omero/target
Executing file: /omero-Beta3.2/omero/target/ddl.sql
Failed to execute:   create table aberrationcorrection ( id int8 not null, permissions 
int8 not null, value varchar(255) not null unique, creation_id int8 not null, external_id 
int8 unique, group_id int8 not null, owner_id int8 not null, primary key (id) )

BUILD FAILED
/omero-Beta3.2/omero/components/antlib/resources/lifecycle.xml:69: 
org.postgresql.util.PSQLException: ERROR: relation "aberrationcorrection" already exists

Total time: 10 seconds

Help!

Attached the jboss logs, in case they can help diagnose the problem.

Thanks a lot!
		mario


-- 
Ing. Mario Valle
Data Analysis Group                              | http://www.cscs.ch/~mvalle
Swiss National Supercomputing Centre (CSCS)      | Tel:  +41 (91) 610.82.60
v. Cantonale Galleria 2, 6928 Manno, Switzerland | Fax:  +41 (91) 610.82.82
-------------- next part --------------
A non-text attachment was scrubbed...
Name: boot.log
Type: text/x-log
Size: 65068 bytes
Desc: not available
URL: <http://lists.openmicroscopy.org.uk/pipermail/ome-users/attachments/20081202/a46f19a7/attachment.bin>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: server.log
Type: text/x-log
Size: 49637 bytes
Desc: not available
URL: <http://lists.openmicroscopy.org.uk/pipermail/ome-users/attachments/20081202/a46f19a7/attachment-0001.bin>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: WebAdmin.log
Type: text/x-log
Size: 668888 bytes
Desc: not available
URL: <http://lists.openmicroscopy.org.uk/pipermail/ome-users/attachments/20081202/a46f19a7/attachment-0002.bin>