<html><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; ">Hi Steve-<div><br></div><div>Have you checked out:</div><div><br></div><div><a href="http://www.openmicroscopy.org/site/documents/data-management/omero4/troubleshooting">http://www.openmicroscopy.org/site/documents/data-management/omero4/troubleshooting</a></div><div><br></div><div>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.</div><div><br></div><div>Cheers,</div><div><br></div><div>Jason</div><div><br><div><div>On 16 Apr 2009, at 19:34, Steve Guerrero wrote:</div><br class="Apple-interchange-newline"><blockquote type="cite"><div>Hi Chris,<br><br>Thanks for your help. I tried logging in as root with the password I <br>assigned in the part you mentioned (in fact I have only used one <br>password for everything so far, just to simplify my testing), but no <br>luck, it still won't log in.<br><br>I noticed there was a previous thread where someone had a similar <br>problem to mine that turned out to be a problem with their postgres <br>installation (the thread subject: "Omero Beta 4 installation problems").<br><br>Although in my case, I only have one install of postgres, and that's <br>from a fresh install of ubuntu server, could it also be something <br>related to the db connectivity? How might I test it? This simple test <br>seems to be successful:<br><br>calm@omeserver1:~/ome/omero-Beta4.0.0$ psql -h localhost -U omero -l<br>Password for user omero:<br> List of databases<br> Name | Owner | Encoding<br>-----------+----------+----------<br> omero | omero | UTF8<br> postgres | postgres | UTF8<br> template0 | postgres | UTF8<br> template1 | postgres | UTF8<br>(4 rows)<br><br><br>Thanks again,<br>-sg<br><br>Chris Roome wrote:<br><blockquote type="cite">Hi Steve,<br></blockquote><blockquote type="cite"><br></blockquote><blockquote type="cite">For the first time you log in to omero service after an install, try<br></blockquote><blockquote type="cite">using username 'root' and the password that you set in this part of the<br></blockquote><blockquote type="cite">set-up procedure:<br></blockquote><blockquote type="cite"><br></blockquote><blockquote type="cite">.<br></blockquote><blockquote type="cite">.<br></blockquote><blockquote type="cite">Please enter omero.db.version [OMERO4]:<br></blockquote><blockquote type="cite">Please enter omero.db.patch [0]:<br></blockquote><blockquote type="cite">Please enter password for new OMERO root user: *<use this password>*<br></blockquote><blockquote type="cite">Please re-enter password for new OMERO root user: *<use this password>*<br></blockquote><blockquote type="cite">Saving to /home/omero/Desktop/omero/OMERO4__0.sql<br></blockquote><blockquote type="cite">.<br></blockquote><blockquote type="cite">.<br></blockquote><blockquote type="cite"><br></blockquote><blockquote type="cite">Once logged in as user 'root' (note this is not the the same as 'root'<br></blockquote><blockquote type="cite">on your ubuntu box) you can create new users (or 'scientists'),<br></blockquote><blockquote type="cite"><br></blockquote><blockquote type="cite">Hope this helps,<br></blockquote><blockquote type="cite"><br></blockquote><blockquote type="cite">Chris.<br></blockquote><blockquote type="cite"><br></blockquote><blockquote type="cite">Steve Guerrero wrote:<br></blockquote><blockquote type="cite"><blockquote type="cite">Hello,<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite"><br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">I am trying to install omero 4.0 in an 'out-of-the-box' simple <br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">configuration just for demonstration on an ubuntu server running <br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">postgres 8.3. In preparation, I installed these packages:<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite"><br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">sun-java6-jdk<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">ice33-services<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">zeroc-ice<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">python-sqlite<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">python-imaging<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">python-pyinotify<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite"><br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite"><br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">After following the online instructions for installing omero with no <br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">apparent errors, I am having difficulty logging in. The built in web <br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">server starts and I can connect on <a href="http://localhost:8000/admin">http://localhost:8000/admin</a> but I <br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">can't login. I get this error message:<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite"><br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">"Please enter a correct username and password. Note that both fields are <br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">case-sensitive."<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite"><br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">I'm fairly certain its not a username/password being incorrect. Even <br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">before I attempt logging in there are error messages in the log files <br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">(see Blitz-0.log below).<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite"><br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">Any pointers/help would be greatly appreciated.<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite"><br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">Thanks,<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">-sg<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite"><br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">In var/log/Blitz-0.log:<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite"><br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">2009-04-15 03:23:02,221 ERROR [ome.services.db.SelfCorrectingDataSource] (<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">main) Failed to acquire connection after retries=3<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">java.sql.SQLException: unable to get a connection from pool of a <br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">PoolingDataSour<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">ce containing an XAPool of resource 559a78e8-b14c-46fc-9de7-9e2154ed3acc <br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">with 0<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">connection(s) (0 still available)<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite"> at <br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">bitronix.tm.resource.jdbc.PoolingDataSource.getConnection(PoolingData<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">Source.java:109)<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite"> at <br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">org.springframework.jdbc.datasource.DelegatingDataSource.getConnectio<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">n(DelegatingDataSource.java:84)<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite"> at <br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">ome.services.db.SelfCorrectingDataSource.call(SelfCorrectingDataSourc<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">e.java:102)<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite"> at <br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">ome.services.db.SelfCorrectingDataSource.callWithRetries(SelfCorrecti<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">ngDataSource.java:75)<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite"> at <br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">ome.services.db.SelfCorrectingDataSource.getConnection(SelfCorrecting<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">DataSource.java:59)<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite"> at <br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">org.springframework.jdbc.datasource.LazyConnectionDataSourceProxy.aft<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">erPropertiesSet(LazyConnectionDataSourceProxy.java:163)<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite"> at <br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">org.springframework.beans.factory.support.AbstractAutowireCapableBean<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">Factory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1368)<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite"> at <br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">org.springframework.beans.factory.support.AbstractAutowireCapableBean<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">Factory.initializeBean(AbstractAutowireCapableBeanFactory.java:1334)<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite"> at <br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">org.springframework.beans.factory.support.AbstractAutowireCapableBean<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">Factory.doCreateBean(AbstractAutowireCapableBeanFactory.java:473)<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite"> at <br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">org.springframework.beans.factory.support.AbstractAutowireCapableBean<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">Factory$1.run(AbstractAutowireCapableBeanFactory.java:409)<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite"> at java.security.AccessController.doPrivileged(Native Method)<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite"> at <br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">org.springframework.beans.factory.support.AbstractAutowireCapableBean<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">Factory.createBean(AbstractAutowireCapableBeanFactory.java:380)<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite"> at <br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">org.springframework.beans.factory.support.AbstractBeanFactory$1.getOb<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">ject(AbstractBeanFactory.java:264)<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite"><br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">.<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">.<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">.<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite"> at ome.services.blitz.Entry.start(Entry.java:153)<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite"> at ome.services.blitz.Entry.main(Entry.java:119)<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">Caused by: java.sql.SQLException: unable to connect to non-XA resource <br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">org.postg<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">resql.Driver<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite"> at <br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">bitronix.tm.resource.jdbc.lrc.LrcXADataSource.getXAConnection(LrcXADa<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">taSource.java:82)<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite"> at <br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">bitronix.tm.resource.jdbc.PoolingDataSource.createPooledConnection(Po<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">olingDataSource.java:167)<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite"> at <br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">bitronix.tm.resource.common.XAPool.createPooledObject(XAPool.java:200<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">)<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite"> at bitronix.tm.resource.common.XAPool.grow(XAPool.java:310)<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite"> at bitronix.tm.resource.common.XAPool.getInPool(XAPool.java:289)<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite"> at <br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">bitronix.tm.resource.common.XAPool.getConnectionHandle(XAPool.java:72<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">)<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite"> at <br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">bitronix.tm.resource.common.XAPool.getConnectionHandle(XAPool.java:58<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">)<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite"> at <br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">bitronix.tm.resource.jdbc.PoolingDataSource.getConnection(PoolingData<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">Source.java:105)<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite"> ... 115 more<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">Caused by: org.postgresql.util.PSQLException: FATAL: password <br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">authentication fai<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">led for user "calm"<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite"> at <br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">org.postgresql.core.v3.ConnectionFactoryImpl.doAuthentication(Connect<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">ionFactoryImpl.java:276)<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite"> at <br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(Conne<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">ctionFactoryImpl.java:95)<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite"> at <br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactor<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">y.java:66)<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite"> at <br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">org.postgresql.jdbc2.AbstractJdbc2Connection.<init>(AbstractJdbc2Conn<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">ection.java:124)<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite"> at <br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">org.postgresql.jdbc3.AbstractJdbc3Connection.<init>(AbstractJdbc3Conn<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">ection.java:30)<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite"> at <br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">org.postgresql.jdbc3.Jdbc3Connection.<init>(Jdbc3Connection.java:24)<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite"> at org.postgresql.Driver.makeConnection(Driver.java:386)<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite"> at org.postgresql.Driver.connect(Driver.java:260)<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite"> at <br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">bitronix.tm.resource.jdbc.lrc.LrcXADataSource.getXAConnection(LrcXADa<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">taSource.java:79)<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite"><br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite"><br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite"><br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite"><br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite"><br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite"><br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">_______________________________________________<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">ome-users mailing list<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite"><a href="mailto:ome-users@lists.openmicroscopy.org.uk">ome-users@lists.openmicroscopy.org.uk</a><br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite"><a href="http://lists.openmicroscopy.org.uk/mailman/listinfo/ome-users">http://lists.openmicroscopy.org.uk/mailman/listinfo/ome-users</a><br></blockquote></blockquote><blockquote type="cite"><br></blockquote><br>_______________________________________________<br>ome-users mailing list<br><a href="mailto:ome-users@lists.openmicroscopy.org.uk">ome-users@lists.openmicroscopy.org.uk</a><br>http://lists.openmicroscopy.org.uk/mailman/listinfo/ome-users<br></div></blockquote></div><br><div apple-content-edited="true"> <span class="Apple-style-span" style="border-collapse: separate; color: rgb(0, 0, 0); font-family: Helvetica; font-size: 12px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: 2; text-align: auto; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-border-horizontal-spacing: 0px; -webkit-border-vertical-spacing: 0px; -webkit-text-decorations-in-effect: none; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0; "><div style="font-family: Helvetica; "><br class="Apple-interchange-newline"><br class="khtml-block-placeholder"></div><div style="font-family: Helvetica; "><span class="Apple-style-span" style="font-family: Helvetica; ">**************************</span></div><div style="font-family: Helvetica; "><font class="Apple-style-span" face="Arial">Wellcome Trust Centre for Gene Regulation & Expression</font></div><div style="font-family: Helvetica; "><font class="Apple-style-span" face="Arial">College of Life Sciences</font></div><div style="font-family: Helvetica; "><font class="Apple-style-span" face="Arial">MSI/WTB/JBC Complex</font></div><div style="font-family: Helvetica; "><span class="Apple-style-span" style="font-family: Helvetica; ">University of Dundee</span></div><div style="font-family: Helvetica; "><span class="Apple-style-span" style="font-family: Helvetica; ">Dow Street</span></div><div style="font-family: Helvetica; "><span class="Apple-style-span" style="font-family: Helvetica; ">Dundee DD1 5EH</span></div><div style="font-family: Helvetica; "><span class="Apple-style-span" style="font-family: Helvetica; ">United Kingdom</span></div><div style="font-family: Helvetica; "><br style="font-family: Helvetica; "></div><div style="font-family: Helvetica; "><span class="Apple-style-span" style="font-family: Helvetica; ">phone (01382) 385819</span></div><div style="font-family: Helvetica; "><span class="Apple-style-span" style="font-family: Helvetica; ">Intl phone: 44 1382 385819 </span></div><div style="font-family: Helvetica; "><span class="Apple-style-span" style="font-family: Helvetica; ">FAX (01382) 388072 </span></div><div style="font-family: Helvetica; "><span class="Apple-style-span" style="font-family: Helvetica; ">email: <a href="mailto:jason@lifesci.dundee.ac.uk">jason@lifesci.dundee.ac.uk</a></span></div><div style="font-family: Helvetica; "><br style="font-family: Helvetica; "></div><div style="font-family: Helvetica; "><span class="Apple-style-span" style="font-family: Helvetica; ">Lab Page: <a href="http://www.dundee.ac.uk/lifesciences/swedlow/">http://www.dundee.ac.uk/lifesciences/swedlow/</a></span></div><div style="font-family: Helvetica; "><span class="Apple-style-span" style="font-family: Helvetica; ">Open Microscopy Environment: <a href="http://openmicroscopy.org">http://openmicroscopy.org</a></span></div><div style="font-family: Helvetica; "><span class="Apple-style-span" style="font-family: Helvetica; ">**************************</span></div><div style="font-family: Helvetica; "><br class="webkit-block-placeholder"></div><div style="font-family: Helvetica; "><div>The University of Dundee is a Scottish Registered Charity, No. SC015096.</div></div><br class="Apple-interchange-newline"></span><br class="Apple-interchange-newline"> </div><br></div></body></html>