[ome-users] omero 4.0.1 beta, configure to listen on other than loopback
josh.moore at gmx.de
josh.moore at gmx.de
Mon Apr 20 09:36:09 BST 2009
Hi Steve,
what method are you using for starting the webadmin? If you are using
the "Configuration for Django Web server (non-production)" section,
then you will need to modify etc\grid\templates.xml:
<server-template id="WebTemplate">
<parameter name="act" default="on-demand"/>
<server id="Web" exe="python" activation="${act}" pwd="${OMEROPY_HOME}omeroweb">
<option>manage.py</option>
<option>runserver</option>
<option>--noreload</option>
<env>${PYTHONPATH}</env>
<adapter name="WebAdapter" register-process="true" endpoints="tcp" server-lifetime="false"/>
</server>
</server-template>
by adding after --noreload:
<option>10.0.0.1:8000</option><!-- your ip & port here -->
but remember, by doing so you are possibly making a non-production
configuration available to the world. Do so with caution.
Best wishes,
~J.
Steve Guerrero writes:
> My next question is, how do configure the out of the box setup to
> listen for admin and webclient connections on something other than
> the loopback address (namely the external 8000 port)?
>
> Thanks,
> -sg
>
>
> Chris Roome wrote:
> > Hi Steve,
> >
> > If you tried Zoltan's idea of dropping the postgres database ('dropdb
> > omero') and the database user ('dropuser omero' - warning! these
> > commands permanently destroys the existing omero database) and
> > re-creating the omero4 database again and it still doesn't work, I would
> > check:
> >
> > 1) Try connecting to omero database and not just listing available
> > databases to double check everything is working OK:
> >
> > psql -U omero -h localhost omero
> >
> > output should be something like:
> >
> >> 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=>
> >
> > 2) Make sure all output (usernames, passwords) is as expected with:
> >
> > ~/ome/omero-Beta4.0.0> bin/omero config get
> >
> > 3) Make sure that postgres is listening on tcp port 5432:
> >
> > $ netstat -an | egrep '5432.*LISTEN'
> >
> > should produce something similar to:
> >
> > tcp 0 0 127.0.0.1:5432 0.0.0.0:* LISTEN
> > tcp 0 0 ::1:5432 :::* LISTEN
> >
> > 4) Have a look at your postgres HBA configuration, on SuSE linux this
> > file is in:
> >
> > /var/lib/pgsql/data/pg_hba.conf
> >
> > I had to edit the default pg_hba.conf to look like this:
> >
> > host all all 127.0.0.1/32 md5
> > local all all ident sameuser
> > host all all ::1/128 ident sameuser
> >
> > As somebody pointed out in a previous post, the order of these lines are
> > important. The postgres also needs to be stopped and started for changes
> > to take effect.
> >
> > Details about postgres and omero can be found here:
> >
> > http://www.openmicroscopy.org/site/documents/data-management/omero4/server/postgresql
> >
> > Good luck & cheers,
> >
> > Chris.
> >
> >
> > Jason Swedlow wrote:
> >> Hi Steve-
> >>
> >> Have you checked out:
> >>
> >> http://www.openmicroscopy.org/site/documents/data-management/omero4/troubleshooting
> >>
> >> Note that the OMERO install pages were updated today, to reflect various
> >> feedbakc we've had, and to support the new Beta4.0.1 release.
> >>
> >> Cheers,
> >>
> >> Jason
> >>
> >> On 16 Apr 2009, at 19:34, Steve Guerrero wrote:
> >>
> >>> Hi Chris,
> >>>
> >>> Thanks for your help. I tried logging in as root with the password I
> >>> assigned in the part you mentioned (in fact I have only used one
> >>> password for everything so far, just to simplify my testing), but no
> >>> luck, it still won't log in.
> >>>
> >>> I noticed there was a previous thread where someone had a similar
> >>> problem to mine that turned out to be a problem with their postgres
> >>> installation (the thread subject: "Omero Beta 4 installation problems").
> >>>
> >>> Although in my case, I only have one install of postgres, and that's
> >>> from a fresh install of ubuntu server, could it also be something
> >>> related to the db connectivity? How might I test it? This simple test
> >>> seems to be successful:
> >>>
> >>> calm at omeserver1:~/ome/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)
> >>>
> >>>
> >>> Thanks again,
> >>> -sg
> >>>
> >>> Chris Roome wrote:
> >>>> Hi Steve,
> >>>>
> >>>> For the first time you log in to omero service after an install, try
> >>>> using username 'root' and the password that you set in this part of the
> >>>> set-up procedure:
> >>>>
> >>>> .
> >>>> .
> >>>> Please enter omero.db.version [OMERO4]:
> >>>> Please enter omero.db.patch [0]:
> >>>> Please enter password for new OMERO root user: *<use this password>*
> >>>> Please re-enter password for new OMERO root user: *<use this password>*
> >>>> Saving to /home/omero/Desktop/omero/OMERO4__0.sql
> >>>> .
> >>>> .
> >>>>
> >>>> Once logged in as user 'root' (note this is not the the same as 'root'
> >>>> on your ubuntu box) you can create new users (or 'scientists'),
> >>>>
> >>>> Hope this helps,
> >>>>
> >>>> Chris.
> >>>>
> >>>> Steve Guerrero wrote:
> >>>>> Hello,
> >>>>>
> >>>>> I am trying to install omero 4.0 in an 'out-of-the-box' simple
> >>>>> configuration just for demonstration on an ubuntu server running
> >>>>> postgres 8.3. In preparation, I installed these packages:
> >>>>>
> >>>>> sun-java6-jdk
> >>>>> ice33-services
> >>>>> zeroc-ice
> >>>>> python-sqlite
> >>>>> python-imaging
> >>>>> python-pyinotify
> >>>>>
> >>>>>
> >>>>> After following the online instructions for installing omero with no
> >>>>> apparent errors, I am having difficulty logging in. The built in web
> >>>>> server starts and I can connect on http://localhost:8000/admin but I
> >>>>> can't login. I get this error message:
> >>>>>
> >>>>> "Please enter a correct username and password. Note that both fields
> >>>>> are
> >>>>> case-sensitive."
> >>>>>
> >>>>> I'm fairly certain its not a username/password being incorrect. Even
> >>>>> before I attempt logging in there are error messages in the log files
> >>>>> (see Blitz-0.log below).
> >>>>>
> >>>>> Any pointers/help would be greatly appreciated.
> >>>>>
> >>>>> Thanks,
> >>>>> -sg
> >>>>>
> >>>>> In var/log/Blitz-0.log:
> >>>>>
> >>>>> 2009-04-15 03:23:02,221 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
> >>>>> PoolingDataSour
> >>>>> ce containing an XAPool of resource
> >>>>> 559a78e8-b14c-46fc-9de7-9e2154ed3acc
> >>>>> with 0
> >>>>> connection(s) (0 still available)
> >>>>> at
> >>>>> bitronix.tm.resource.jdbc.PoolingDataSource.getConnection(PoolingData
> >>>>> Source.java:109)
> >>>>> at
> >>>>> org.springframework.jdbc.datasource.DelegatingDataSource.getConnectio
> >>>>> n(DelegatingDataSource.java:84)
> >>>>> at
> >>>>> ome.services.db.SelfCorrectingDataSource.call(SelfCorrectingDataSourc
> >>>>> e.java:102)
> >>>>> at
> >>>>> ome.services.db.SelfCorrectingDataSource.callWithRetries(SelfCorrecti
> >>>>> ngDataSource.java:75)
> >>>>> at
> >>>>> ome.services.db.SelfCorrectingDataSource.getConnection(SelfCorrecting
> >>>>> DataSource.java:59)
> >>>>> at
> >>>>> org.springframework.jdbc.datasource.LazyConnectionDataSourceProxy.aft
> >>>>> erPropertiesSet(LazyConnectionDataSourceProxy.java:163)
> >>>>> at
> >>>>> org.springframework.beans.factory.support.AbstractAutowireCapableBean
> >>>>> Factory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1368)
> >>>>> at
> >>>>> org.springframework.beans.factory.support.AbstractAutowireCapableBean
> >>>>> Factory.initializeBean(AbstractAutowireCapableBeanFactory.java:1334)
> >>>>> at
> >>>>> org.springframework.beans.factory.support.AbstractAutowireCapableBean
> >>>>> Factory.doCreateBean(AbstractAutowireCapableBeanFactory.java:473)
> >>>>> at
> >>>>> org.springframework.beans.factory.support.AbstractAutowireCapableBean
> >>>>> Factory$1.run(AbstractAutowireCapableBeanFactory.java:409)
> >>>>> at java.security.AccessController.doPrivileged(Native Method)
> >>>>> at
> >>>>> org.springframework.beans.factory.support.AbstractAutowireCapableBean
> >>>>> Factory.createBean(AbstractAutowireCapableBeanFactory.java:380)
> >>>>> at
> >>>>> org.springframework.beans.factory.support.AbstractBeanFactory$1.getOb
> >>>>> ject(AbstractBeanFactory.java:264)
> >>>>>
> >>>>> .
> >>>>> .
> >>>>> .
> >>>>> at ome.services.blitz.Entry.start(Entry.java:153)
> >>>>> at ome.services.blitz.Entry.main(Entry.java:119)
> >>>>> Caused by: java.sql.SQLException: unable to connect to non-XA resource
> >>>>> org.postg
> >>>>> resql.Driver
> >>>>> at
> >>>>> bitronix.tm.resource.jdbc.lrc.LrcXADataSource.getXAConnection(LrcXADa
> >>>>> taSource.java:82)
> >>>>> at
> >>>>> bitronix.tm.resource.jdbc.PoolingDataSource.createPooledConnection(Po
> >>>>> olingDataSource.java:167)
> >>>>> at
> >>>>> bitronix.tm.resource.common.XAPool.createPooledObject(XAPool.java:200
> >>>>> )
> >>>>> at bitronix.tm.resource.common.XAPool.grow(XAPool.java:310)
> >>>>> at bitronix.tm.resource.common.XAPool.getInPool(XAPool.java:289)
> >>>>> at
> >>>>> bitronix.tm.resource.common.XAPool.getConnectionHandle(XAPool.java:72
> >>>>> )
> >>>>> at
> >>>>> bitronix.tm.resource.common.XAPool.getConnectionHandle(XAPool.java:58
> >>>>> )
> >>>>> at
> >>>>> bitronix.tm.resource.jdbc.PoolingDataSource.getConnection(PoolingData
> >>>>> Source.java:105)
> >>>>> ... 115 more
> >>>>> Caused by: org.postgresql.util.PSQLException: FATAL: password
> >>>>> authentication fai
> >>>>> led for user "calm"
> >>>>> at
> >>>>> org.postgresql.core.v3.ConnectionFactoryImpl.doAuthentication(Connect
> >>>>> ionFactoryImpl.java:276)
> >>>>> at
> >>>>> org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(Conne
> >>>>> ctionFactoryImpl.java:95)
> >>>>> at
> >>>>> org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactor
> >>>>> y.java:66)
> >>>>> at
> >>>>> org.postgresql.jdbc2.AbstractJdbc2Connection.<init>(AbstractJdbc2Conn
> >>>>> ection.java:124)
> >>>>> at
> >>>>> org.postgresql.jdbc3.AbstractJdbc3Connection.<init>(AbstractJdbc3Conn
> >>>>> ection.java:30)
> >>>>> at
> >>>>> org.postgresql.jdbc3.Jdbc3Connection.<init>(Jdbc3Connection.java:24)
> >>>>> at org.postgresql.Driver.makeConnection(Driver.java:386)
> >>>>> at org.postgresql.Driver.connect(Driver.java:260)
> >>>>> at
> >>>>> bitronix.tm.resource.jdbc.lrc.LrcXADataSource.getXAConnection(LrcXADa
> >>>>> taSource.java:79)
> >>>>>
> >>>>>
> >>>>>
> >>>>>
> >>>>>
> >>>>>
> >>>>> _______________________________________________
> >>>>> ome-users mailing list
> >>>>> ome-users at lists.openmicroscopy.org.uk
> >>>>> <mailto:ome-users at lists.openmicroscopy.org.uk>
> >>>>> http://lists.openmicroscopy.org.uk/mailman/listinfo/ome-users
> >>> _______________________________________________
> >>> ome-users mailing list
> >>> ome-users at lists.openmicroscopy.org.uk
> >>> <mailto:ome-users at lists.openmicroscopy.org.uk>
> >>> http://lists.openmicroscopy.org.uk/mailman/listinfo/ome-users
> >>
> >>
> >> **************************
> >> Wellcome Trust Centre for Gene Regulation & Expression
> >> College of Life Sciences
> >> MSI/WTB/JBC Complex
> >> University of Dundee
> >> Dow Street
> >> Dundee DD1 5EH
> >> United Kingdom
> >>
> >> phone (01382) 385819
> >> Intl phone: 44 1382 385819
> >> FAX (01382) 388072
> >> email: jason at lifesci.dundee.ac.uk <mailto:jason at lifesci.dundee.ac.uk>
> >>
> >> Lab Page: http://www.dundee.ac.uk/lifesciences/swedlow/
> >> Open Microscopy Environment: http://openmicroscopy.org
> >> **************************
> >>
> >> The University of Dundee is a Scottish Registered Charity, No. SC015096.
> >>
> >>
> >>
> >>
> >> ------------------------------------------------------------------------
> >>
> >> _______________________________________________
> >> ome-users mailing list
> >> ome-users at lists.openmicroscopy.org.uk
> >> http://lists.openmicroscopy.org.uk/mailman/listinfo/ome-users
> >
>
> _______________________________________________
> ome-users mailing list
> ome-users at lists.openmicroscopy.org.uk
> http://lists.openmicroscopy.org.uk/mailman/listinfo/ome-users
More information about the ome-users
mailing list