[ome-users] omero 4.0 beta login problems

[Steve Guerrero]

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
>> http://lists.openmicroscopy.org.uk/mailman/listinfo/ome-users
>