[ome-users] Initialize the OMERO database

[josh.moore at gmx.de]

Smith, Stuart C writes:
 > Hi Josh,

Hi Stuart,

 > Anyway, with your help I sorted that that.   I know you mentioned that
 > 4.0.1 will be released soon, but i decided to carry on with 4.0 as a
 > test installation until 4.0.1 in available.  Everything else went ok,
 > until i tried to start the server and got the below error...
 > 
 > 	...
 > 	No descriptor given. Using etc/grid/default.xml
 > 	[SC] StartService FAILED 3:
 > 
 > 	The system cannot find the path specified.
 > 
 > 	Waiting on startup. Use CTRL-C to exit
 > 	icegridadmin: could not contact the default locator:
 > 	Network.cpp:1220: Ice::ConnectionRefusedException:
 > 	connection refused: WSAECONNREFUSED
 > 
 > Any ideas?

This is one of the errors fixed in 4.0.1. Though your best bet is to
wait for the release, I can give you a quick tip and you can go from
there: if you've installed Ice-3.3.1 which you probably have, move it
to C:\Ice-3.3.0 since the path is hard-coded. In the upcoming release,
it's not hard-coded, but after install it requires a reboot. Those are
the types of trade-offs in this business. :)

Best wishes,
~Josh.

 > Thanks,
 > 
 > Stuart
 > 
 > 
 > -----Original Message-----
 > From: josh.moore at gmx.de [mailto:josh.moore at gmx.de] 
 > Sent: 08 April 2009 19:09
 > To: Smith, Stuart C
 > Cc: ome-users at lists.openmicroscopy.org.uk
 > Subject: [ome-users] Initialize the OMERO database
 > 
 > 
 > Hi Stuart,
 > 
 > before I begin a minor warning, we'll be releasing 4.0.1 in the next
 > day or two with improved Windows support. So, though it doesn't change
 > any of the instructions for getting your database setup, it may make
 > sense to wait for the final installation until then.
 > 
 > But first, your db...
 > 
 > Smith, Stuart C writes:
 > 
 >  > Hi, I'm sure this will be a very basic question to most of you but
 >  > I have been asked to set up a PC running the OMERO server
 >  > installation and have followed the Windows installation document
 >  > upto the point where you are asked to "Initialize the OMERO
 >  > database" with the script...
 >  > 
 >  > $ cd C:\omero-Beta4.0.0\
 >  > $ bin\omero db script
 >  > Please enter omero.db.version [OMERO4]: 
 >  > Please enter omero.db.patch [0]: 
 >  > Please enter password for new OMERO root user: 
 >  > Please re-enter password for new OMERO root user: 
 >  > Saving to C:\omero-Beta4.0.0\OMERO4__0.sql
 >  > $
 > 
 >  > But have tried pasting into a cmd window, but it doesn't like it. I
 >  > therefore tried the first line & realised that it wasn't even
 > changing
 >  > directories, therefore removed the 1st "$" char & that worked, but
 > then
 >  > got stuck on the 2nd line.  Can someone please help me initialize the
 >  > DB.
 > 
 > The dollar signs are a copy-n-paste issue from the non-Windows
 > instructions. Sorry about that. I've fixed them in the documentation
 > for the coming release.
 > 
 >  > Also, as I was unsure if it had worked, although I wasn't prompted
 > for
 >  > the password as I added it to the script manually so I tried the next
 >  > step of populating the database by copying the script in the
 >  > installation document into "SQL Shell (psql)" and this errored, but
 > was
 >  > this because I hadn't initialized the db?
 >  >  
 >  > Any help you guys can offer would be great as I have been asked to
 > set
 >  > this up to see if the software is useful to us.
 > 
 > Alright. I'm a bit lost in what you tried, and what did and didn't
 > work. What you should use to create your database script is:
 > 
 >   cd C:\omero-Beta4.0.0\
 >   bin\omero db script
 > 
 > Then you should be asked the questions about version and
 > password. You said you weren't asked for a password. That seems
 > odd. How did you go about adding that manually?
 > 
 > Once you've done that, then opening the SQL Shell as mentioned in the
 > docs is certainly correct. The statement "\i ... OMERO4__0.sql" is the
 > process of initializing your db, so that can't be why it errored. Can
 > you send us the error that it produced?
 > 
 >  > Thanks in advance,
 >  > Stuart
 > 
 > 
 > Hope that helps somewhat.
 > Best wishes,
 > ~Josh.