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

[Taylor, Ronald C]

Josh, Ken,

I have reinstalled Postgres from source and now
  psql -h localhost -U omero omero

 does work - it brings up the omero db and I can list the tables, etc.

But OMERO still does not come up and now I've found another problem. I cannot use

  omero config set <param> <val>

When I try doing something like

  omero config set omero.data.dir /var/lib/omero/data   (following top of p 10 in Ken's manual)

 the command apparently does not do anything. That is, there is no error msg on-screen but when I do

  omero config get
Or
  omero config get omero.data.dir

I get nothing back - I just return to the command prompt with no information displayed on the param.

So - it looks like the config setting never gets stored. From Ken's Mac instructions (bottom of p 9), I would expect to see a config file here (working in the rontaylor acct):

   /Users/rontaylor/Library/Preferences/omero.prefs.default.plist

But there is no such file. I need to set omero.data.dir - and also need to set omero.db.port to 5433. I'm thinking if I can do that, OMERO might come up OK. But now I have this config problem. Any guidance? Am I looking for the plist file in the wrong place? Do you have any idea why my config values are not getting stored?

I'm tempted to try altering the ../omero_dist/etc/omero_properties file, but the instructions say not to do that. Besides, need to figure out why "omero config set' is not working.

 Ron
___________________________________________
Ronald Taylor, Ph.D.
Computational Biology & Bioinformatics Group
Pacific Northwest National Laboratory
902 Battelle Boulevard
P.O. Box 999, Mail Stop J4-33
Richland, WA  99352 USA
Office:  509-372-6568
Email: ronald.taylor at pnl.gov

-----Original Message-----
From: ome-users-bounces at lists.openmicroscopy.org.uk [mailto:ome-users-bounces at lists.openmicroscopy.org.uk] On Behalf Of Josh Moore
Sent: Monday, June 21, 2010 11:27 PM
To: ome-users at lists.openmicroscopy.org.uk
Subject: Re: [ome-users] Failed OMERO install on a Mac server - requesting help

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.
>
>    

_______________________________________________
ome-users mailing list
ome-users at lists.openmicroscopy.org.uk
http://lists.openmicroscopy.org.uk/mailman/listinfo/ome-users