<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<META NAME="Generator" CONTENT="MS Exchange Server version 6.5.7652.24">
<TITLE>RE: [ome-users] OMERO b2.2 problems</TITLE>
</HEAD>
<BODY>
<!-- Converted from text/plain format -->
<P><FONT SIZE=2>Sorry for the ridiculous inability to do inline quoting on this (I *hate* MS LookOut).<BR>
<BR>
I have figured out the problem with the client access to the server upgraded from b2 to b2.2. The server did not have a DNS entry, so when accessing the b2 server with b2.1 clients, I used the server IP address. That worked fine for the pre-b2.2 server and clients, but does not work with the b2.2 server/clients. Getting a proper DNS entry for the server cured the access problem. Note that my /etc/hosts file has not been changed, and has always mapped the server name to it's IP. Just FYI for anyone else using non-resolvable addresses.<BR>
<BR>
As for the laptop, I used a stock pre-built binary install. Killing and restarting yields this:<BR>
09:19:06,051 INFO [HbmBinder] Mapping collection: ome.model.containers.Dataset.annotations -> datasetannotation<BR>
09:19:06,203 INFO [ConnectionProviderFactory] Initializing connection provider: org.springframework.orm.hibernate3.LocalDataSourceConnectionProvider<BR>
09:19:06,247 WARN [JBossManagedConnectionPool] Throwable while attempting to get a new connection: null<BR>
org.jboss.resource.JBossResourceException: Could not create connection; - nested throwable: (org.postgresql.util.PSQLException: FATAL: database "omero3" does not exist)<BR>
at org.jboss.resource.adapter.jdbc.local.LocalManagedConnectionFactory.createManagedConnection(LocalManagedConnectionFactory.java:179)<BR>
at org.jboss.resource.connectionmanager.InternalManagedConnectionPool.createConnectionEventListener(InternalManagedConnectionPool.java:57<BR>
<BR>
<BR>
The omero3 db is gone? Yep:<BR>
postgres$ psql -l<BR>
List of databases<BR>
Name | Owner | Encoding -----------+----------+-----------<BR>
postgres | postgres | SQL_ASCII<BR>
template0 | postgres | SQL_ASCII<BR>
template1 | postgres | SQL_ASCII<BR>
(3 rows)<BR>
<BR>
Yep, gone. Weird. And I'd created users, uploaded images, etc.<BR>
<BR>
I don't think I'm going to reinstall given the frequency of sleep events. It's not worth doing a laptop edition; it's just handy for demos where network connectivity is not available. If I can help with debugging, let me know.<BR>
<BR>
Mike<BR>
<BR>
Michael J. McCaughey, PhD<BR>
Molecular Physiology and Biophysics<BR>
U9203 MRBIII<BR>
6-6175<BR>
<BR>
<BR>
<BR>
-----Original Message-----<BR>
From: ome-users-bounces@lists.openmicroscopy.org.uk on behalf of Jason Swedlow<BR>
Sent: Mon 11/12/2007 4:36 PM<BR>
To: McCaughey, Michael J<BR>
Cc: ome-users@lists.openmicroscopy.org.uk<BR>
Subject: Re: [ome-users] OMERO b2.2 problems<BR>
<BR>
Hi Mike-<BR>
<BR>
Thanks for this.<BR>
<BR>
On 12 Nov 2007, at 22:12, McCaughey, Michael J wrote:<BR>
<BR>
> I've run into a couple of problems with the beta 2.2 release that I <BR>
> could use some help with...<BR>
><BR>
> First, I upgraded a 2 server to 2.2. The upgrade went smoothly, and <BR>
> process matched those on the upgrade wiki page. I deleted the <BR>
> existing 2.1 clients and installed 2.2 versions. The WebAdmin tool <BR>
> works as expected, the old users are there and new ones can be <BR>
> added, but now clients cannot connect to the server. I've deleted <BR>
> and reinstalled, etc., no luck.<BR>
> The server hosts file is correct (I had to fix it for the 2.1 <BR>
> clients). Brian is looking into this, but I thought I'd put it out <BR>
> there and see if anyone else had a suggestion.<BR>
><BR>
That sounds strange- I'll let the systems guys take that. To confirm, <BR>
webadmin connects and works (so server is up) but insight and <BR>
importer do not connect?<BR>
> Second, I installed 2.2 on a MacBook Pro (core duo), and installed <BR>
> the 2.2 clients on the same machine. This worked great, I used it <BR>
> for several hours setting up test users and the updated importer <BR>
> (thanks Brian & Mellisa for fixing the LSM large-file problem). No <BR>
> problems. I then let the machine hibernate a few minutes while I <BR>
> walked to a conference room to demo it for a group of interested <BR>
> parties. When I tried the clients (which I had left running), they <BR>
> bombed. WebAdmin did too. I rebooted, and now the clients won't <BR>
> connect. WebAdmin doesn't recognize any logins as valid, including <BR>
> root. Oops. Good thing the rest of my talk was long.<BR>
> So, does suspend/power save kill the server (the jboss process is <BR>
> still running, tho). Could it corrupt the db?<BR>
><BR>
<BR>
The phenotype you describe is expected-- JBOSS does not like sleep. <BR>
It doesn't like network changes (e.g., disconnecting network <BR>
connection). But no worries, the DB should be just fine. I've made <BR>
a similar mistake with my own machine-- and yes, things are then no <BR>
good at all. We've built OMERO assuming your server will stay up. <BR>
Try to kill the JBOSS process, and then restart it. I've done this <BR>
previously, and never had a problem.<BR>
<BR>
You obviously want to run the whole system on your laptop. We have <BR>
talked about building a specific version for this, but haven't done <BR>
it yet. From a developer's point of view, your approach should "just <BR>
work". Let us know if this is a strong requirement and we will look <BR>
into it. We just didn't feel like competing with Aperture ;-)!<BR>
<BR>
Hope that helps.<BR>
<BR>
Cheers,<BR>
<BR>
Jason<BR>
<BR>
**************************<BR>
Wellcome Trust Centre for Gene Regulation & Expression<BR>
College of Life Sciences<BR>
MSI/WTB/JBC Complex<BR>
University of Dundee<BR>
Dow Street<BR>
Dundee DD1 5EH<BR>
United Kingdom<BR>
<BR>
phone (01382) 385819<BR>
Intl phone: 44 1382 385819<BR>
FAX (01382) 388072<BR>
email: jason@lifesci.dundee.ac.uk<BR>
<BR>
Lab Page: <A HREF="http://www.dundee.ac.uk/lifesciences/swedlow/">http://www.dundee.ac.uk/lifesciences/swedlow/</A><BR>
Open Microscopy Environment: <A HREF="http://openmicroscopy.org">http://openmicroscopy.org</A><BR>
**************************<BR>
<BR>
<BR>
<BR>
</FONT>
</P>
</BODY>
</HTML>