[ome-users] Failed OMERO install on a Mac server - requesting help

[Josh Moore]

Hi Ronald,

it looks like either the connection information for your PostgreSQL 
server is wrong, or the server itself is not listening to for TCP 
connections. For debugging this, you might take a look at some of these 
pages:

  * https://www.openmicroscopy.org/site/support/omero4/server/postgresql
  * 
http://lists.openmicroscopy.org.uk/pipermail/ome-users/2009-April/001596.html
  * 
http://lists.openmicroscopy.org.uk/pipermail/ome-devel/2007-August/000886.html

Basically, if you can connect to your database with "psql omero" but not 
"psql -h localhost omero" then most likely TCP is not configuration in 
postgresql.conf. If you can reach with "psql -h localhost -U omero 
omero" (or whatever values you configured for omero.db.host, 
omero.db.user, and omero.db.name), then something else is going on.

Cheers,
~Josh


On 6/21/10 10:38 PM, Taylor, Ronald C wrote:
> Hello folks,
>
> I have successfully installed OMERO on my MacBook and on my Red hat Linux desktop. I'm now trying to install OMERO on our Mac server, which is the host machine we plan to use for the medium/long term.
>
> Our Mac server just got upgraded to Mac OS X Server 10.6, so I was using Ken's OMERO for 10.6 install instructions as my template. I copied over the appropriate subdirectories from /Library and /Library/Frameworks on my MacBook, and then made the additional changes that appeared to be required in Ken's instructions (for example, a couple Python libs that still had to be re-installed from source since they don't have separate subdirectories).
>
> I also set the firewall using  Server -->  Server Preferences -->  Security -->  Firewall
>    to have open ports at 8000 (for OMERO.web) and at 5433 (the port I'm using for Postgres).
>
> I then invoked Postgres. It comes up fine. I then tried invoking OMERO using
>     omero admin start
>
> That fails  - it times out after 5 minutes.
>
> So - need help again.
>
> I have attached a record* file that contains the screen output of the failed start, including the results of
>     omero admin diagnostics  (which I have also repeated at bottom)
>
> I have also attached all the log files in
>      ../omero_dist/var/log
>   except for the master.out file, which remained empty.
>
> And I have attached my .bash_profile file for the account (/Users/rontaylor) in which I started Postgres and attempted to start OMERO.
>
> The Blitz-0 log shows a SQL error msg which I have not seen before. Could that have anything to do with a blocked port to Postgres at the router/intranet level, something I should check out with our network people?
>
> As before, any help would be greatly appreciated.
>
>