[ome-users] omero 4.0 beta login problems
Chris Roome
Chris.Roome at mpimf-heidelberg.mpg.de
Fri Apr 17 08:27:49 BST 2009
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
--
__________________________________________________________________
Chris Roome t: +49 (0)6221 486 559
IT Services
Department of Biomolecular Mechanisms
Max Planck Institute for Medical Research (MPImF)
Jahnstrasse 29
69120 Heidelberg w: www.mpimf-heidelberg.mpg.de/english
Germany
__________________________________________________________________
More information about the ome-users
mailing list