[ome-users] Mac OS X OMERO.server installation

[josh.moore at gmx.de]

Hello wormbuff (Good email)

The exception you received starting "Failed to execute: create table
aberrationcorrection ( id int8 not" says that your database was
already created by setup-db, so that shouldn't be the issue. Can you
check the value for your root password?

As you can see here:

$ echo -n ome | openssl md5 -binary | openssl base64
vvFwuczAmpyoRC0Nsv8FCw==
$ echo -n omero | openssl md5 -binary | openssl base64
LSjpGNDDKH/7iZyIwB8OTA==
$ psql omero3 -c "select hash from password where experimenter_id = 0"
           hash           
--------------------------
 vvFwuczAmpyoRC0Nsv8FCw==
(1 row)

The default password is usually ome (I'm not sure if the dmg has a
different default password, but this will certainly tell you.) If your
password is something else, you can always use:

$ psql omero3 -c "update password set hash = 'LSjpGNDDKH/7iZyIwB8OTA==' where experimenter_id = 0"
UPDATE 1


Unfortunately, if you can't login as root, the only way to fix things
is to work with the database directly. Hope this helps.

~Josh.

wormbuff writes:
 > I have encountered some difficulties while installing OMERO.server.   
 > I am attempting to install OMERO.server Beta 1 on Mac OS v10.4.8.   
 > When I try to login using either .admin or .insight, I have no luck.   
 > I have been trying to track down where the problem is, but to no avail.
 > 
 > I downloaded the Mac OS X package installation and it installed  
 > successfully (at least it did not report an error).  However, upon  
 > trying to login with .admin (using localhost with l/p: root/omero),  
 > the login attempt fails.

 > I tried working through the OmeroInstall trac pages and this is what  
 > I have been able to verify.
 > 
 > -> Port 1099 and 5432 are open
 > -> javac v1.5.0_07
 > -> postgres v8.1.5 is installed in /Library/PostgreSQL8/bin
 > -> in postgres, omero3 database exists and omero user exists
 > NOTE: to "su postgres" I had to assign a password to the postgres  
 > account
 > 
 > -> I would try to initialize the OMERO database by running  
 > "$JBOSS_HOME/bin/run.sh", however, I do not seem to have  
 > "jboss-4.0.4.GA" in my OMERO directory.  The closest thing I see is  
 > OMERO/server/client/jbosssx-4.0.4.GA.jar
 > 
 > -> Upon trying to in initialize the OMERO database with "sudo java  
 > omero update setup-db deploy" (sudo as /Applications/OMERO is owned  
 > by root) I get the following message:
 > 
 > /Applications/OMERO/server $ sudo java omero update setup-db deploy
 > Password:
 > Buildfile: build.xml
 > 
 > update:
 > Created dir: /Applications/OMERO/server/omero756254785
 > Copying 1 file to /Applications/OMERO/server/omero756254785
 > Updating jar: /Applications/OMERO/server/omero.ear
 > Deleting directory /Applications/OMERO/server/omero756254785
 > 
 > reload-db:
 > statements executed successfully
 > Executing file: /Applications/OMERO/server/target/ddl.sql
 > Failed to execute:   create table aberrationcorrection ( id int8 not  
 > null, owner_id int8 not null, group_id int8 not null, creation_id  
 > int8 not null, permissions int8 not null, external_id int8 unique,  
 > value varchar(255) not null unique, primary key (id) )
 > 
 > BUILD FAILED
 > /Applications/OMERO/server/build.xml:71: The following error occurred  
 > while executing this line:
 > /Applications/OMERO/server/components/server/build.xml:17: The  
 > following error occurred while executing this line:
 > /Applications/OMERO/server/components/antlib/resources/macros.xml:94:  
 > org.postgresql.util.PSQLException: ERROR: relation  
 > "aberrationcorrection" already exists
 > 
 > Total time: 11 seconds
 > 
 > Any help/insight would be greatly appreciated.  Thanks!