[ome-users] Fwd: Problems installing OMERO.server-4.4.4 for Windows7 (32bits)

Josh Moore josh at glencoesoftware.com
Mon Nov 5 22:03:12 GMT 2012 

On Mon, Nov 5, 2012 at 10:55 AM, UNAI LORENZO SIERRA
<ulorenzo001 at ikasle.ehu.es> wrote:
>
> Dear Josh,

Hi Unai,

> After running successfully OMERO.web and OMERO.insight on Friday I logged
> out and turned off the computer, and now I can't log in OMERO.web anymoreI

And it started up successfully when you turned the computer back on?

> get an internal server error.
> Could you please take a look at the command line?

....

> C:\omero_dist>bin\omero login
> Previously logged in to localhost:4064 as root
> Server: [localhost]
> Username: [root]
> Password:
> internal server error

The Blitz server isn't running which is needed for login. Could you
also send us the var\log\Blitz-0.log?

Cheers,
~Josh


> Thanks,
> Unai
>
>
>
>
> UNAI LORENZO SIERRA <ulorenzo001 at ikasle.ehu.es> escribió:
>
>> That worked perfectly!
>>
>> Thank you very much for your patience and your help.
>>
>> Cheers,
>> Unai
>>
>>
>>
>> Josh Moore <josh at glencoesoftware.com> escribió:
>>
>>>
>>> On Nov 2, 2012, at 12:22 PM, UNAI LORENZO SIERRA wrote:
>>>
>>>> Hi Josh,
>>>>
>>>> Apparently, I've been able to login with `bin\omero login
>>>> root at localhost` command. I could also start omero web, but I couldn't access
>>>> OMERO.web (with Username:db_user and Password:db_password).
>>>
>>>
>>> Can you try to use "root" and the same password as you used for
>>> `bin\omero login root at localhost`?
>>>
>>> Thanks,
>>> ~Josh.
>>>
>>>
>>>> (pid = 1188, enabled)
>>>> Server:     Tables-0                       inactive (disabled)
>>>> Server:     TestDropBox                    inactive (enabled)
>>>>
>>>> Log dir:    C:\omero_dist\var\log          exists
>>>>
>>>> Log files:  Blitz-0.log                    90.0 KB       errors=2
>>>> warnings=4
>>>>
>>>> Log files:  DropBox.log                    11.0 KB       errors=14
>>>> warnings=7
>>>>
>>>> Log files:  FileServer.log                 2.0 KB
>>>> Log files:  Indexer-0.log                  418.0 KB      errors=14
>>>> warnings=30
>>>>
>>>> Log files:  MonitorServer.log              3.0 KB
>>>> Log files:  OMEROweb.log                   113.0 KB      errors=32
>>>> warnings=0
>>>>
>>>> Log files:  OMEROweb_request.log           0.0 KB
>>>> Log files:  PixelData-0.log                346.0 KB      errors=20
>>>> warnings=22
>>>>
>>>> Log files:  Processor-0.log                106.0 KB      errors=28
>>>> warnings=56
>>>>
>>>> Log files:  Tables-0.log                   n/a
>>>> Log files:  TestDropBox.log                n/a
>>>> Log files:  master.err                     0.0 KB
>>>> Log files:  master.out                     0.0 KB
>>>> Log files:  Total size                     1.09 MB
>>>>
>>>> Parsing Blitz-0.log:[line:346] => Server restarted <=
>>>>
>>>> Environment:OMERO_HOME=(unset)
>>>> Environment:OMERO_NODE=(unset)
>>>> Environment:OMERO_MASTER=(unset)
>>>>
>>>> Environment:PATH=C:\Python26;C:\Windows\System32;C:\Windows\System32\WindowsPowe
>>>> rShell\v1.0;C:\Windows\System32\cmd.exe;C:\Program
>>>> Files\ZeroC\Ice-3.4.2\bin
>>>> Environment:ICE_HOME=(unset)
>>>> Environment:LD_LIBRARY_PATH=(unset)
>>>> Environment:DYLD_LIBRARY_PATH=(unset)
>>>>
>>>> OMERO data dir: 'C:\\OMERO'     Exists? True    Is writable? True
>>>> OMERO.web status... DEVELOPMENT: You will have to check status by hand!
>>>>
>>>>
>>>> C:\omero_dist>bin\omero login root at localhost
>>>> Previous session expired for root on localhost:4064
>>>> Password:
>>>> Created session 52008c20-73b1-4eac-b46c-decd791e13fb
>>>> (root at localhost:4064). Idle
>>>> timeout: 10.0 min. Current group: system
>>>>
>>>> C:\omero_dist>bin\omero config set omero.web.application_server
>>>> development
>>>>
>>>> C:\omero_dist>bin\omero config set omero.web.debug True
>>>>
>>>> C:\omero_dist>bin\omero config set omero.web.session_engine
>>>> "django.contrib.sess
>>>> ions.backends.cache"
>>>>
>>>> C:\omero_dist>bin\omero config set omero.web.cache_backend
>>>> "file://C:/windows/te
>>>> mp/"
>>>>
>>>> C:\omero_dist>bin\omero web start
>>>>
>>>> 0 static files copied to 'C:/omero_dist/lib/python/omeroweb/static' (798
>>>> unmodif
>>>> ied).
>>>> Starting OMERO.web... Validating models...
>>>>
>>>> 0 errors found
>>>> Django version 1.3.1, using settings 'omeroweb.settings'
>>>> Development server is running at http://0.0.0.0:4080/
>>>> Quit the server with CTRL-BREAK.
>>>> [02/Nov/2012 12:08:39] "GET /webclient/ HTTP/1.1" 302 0
>>>> ----------------------------------------
>>>> Exception happened during processing of request from ('127.0.0.1',
>>>> 65352)
>>>> Traceback (most recent call last):
>>>> File "C:\Python26\lib\SocketServer.py", line 283, in
>>>> _handle_request_noblock
>>>>   self.process_request(request, client_address)
>>>> File "C:\Python26\lib\SocketServer.py", line 309, in process_request
>>>>   self.finish_request(request, client_address)
>>>> File "C:\Python26\lib\SocketServer.py", line 322, in finish_request
>>>>   self.RequestHandlerClass(request, client_address, self)
>>>> File "C:\omero_dist\lib\python\django\core\servers\basehttp.py", line
>>>> 570, in
>>>> __init__
>>>>   BaseHTTPRequestHandler.__init__(self, *args, **kwargs)
>>>> File "C:\Python26\lib\SocketServer.py", line 617, in __init__
>>>>   self.handle()
>>>> File "C:\omero_dist\lib\python\django\core\servers\basehttp.py", line
>>>> 610, in
>>>> handle
>>>>   self.raw_requestline = self.rfile.readline()
>>>> File "C:\Python26\lib\socket.py", line 444, in readline
>>>>   data = self._sock.recv(self._rbufsize)error: [Errno 10054] Se ha
>>>> forzado la interrupci¾n de una conexi¾n existente por
>>>> el host remoto
>>>>
>>>> ----------------------------------------
>>>> [02/Nov/2012 12:08:40] "GET /webclient/login/?url=%2Fwebclient%2F
>>>> HTTP/1.1" 200
>>>> 3464
>>>> [02/Nov/2012 12:11:49] "POST /webclient/login/?url=%2Fwebclient%2F
>>>> HTTP/1.1" 200
>>>> 3610
>>>>
>>>>
>>>>
>>>> Cheers,
>>>> Unai
>>>>
>>>>
>>>>
>>>>
>>>>
>>>> Josh Moore <josh at glencoesoftware.com> escribió:
>>>>
>>>>>
>>>>> On Nov 1, 2012, at 9:33 PM, UNAI LORENZO SIERRA wrote:
>>>>>
>>>>>>
>>>>>> Hi Josh,
>>>>>
>>>>>
>>>>> Hi,
>>>>>
>>>>>> Thanks for your answer. I'm definitely having problems with all the
>>>>>> created users and passwords...
>>>>>>
>>>>>> Finally, I've been able to populate the database successfully.
>>>>>> The problem now is the login. This is the error I get:
>>>>>>
>>>>>> C:\omero_dist>bin\omero login
>>>>>> Server: [localhost]
>>>>>> Username: [Biofisica]
>>>>>> Password:
>>>>>> Ice.ConnectionRefusedException: localhost isn't running
>>>>>>
>>>>>> C:\omero_dist>
>>>>>>
>>>>>>
>>>>>>
>>>>>> I've been trying to login with all the passwords I've created during
>>>>>> the installation (especially with the root_password, of course), and I get
>>>>>> always the same message.
>>>>>>
>>>>>> Do you know if he problem is that I'm using a wrong password, or is it
>>>>>> a different problem?
>>>>>
>>>>>
>>>>> Here, the problem is that OMERO is not running and listening on port
>>>>> 4064 as it should. Did `bin\omero admin start` complete successfully? What
>>>>> does `bin\omero admin diagnostics` return?
>>>>>
>>>>>
>>>>>> Appart from that, could you please explain me where the login Username
>>>>>> (in this case Biofisica) comes from? I don't remember creating any username
>>>>>> with this name...
>>>>>
>>>>>
>>>>> Is that the name of the Windows user? `bin\omero login` tries to guess
>>>>> a username on your first login. You should probably try `bin\omero login
>>>>> root at localhost` once the server is running.
>>>>>
>>>>> Cheers,
>>>>> ~Josh.
>>>>>
>>>>>
>>>>>> Thanks,
>>>>>> Unai
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>> Josh Moore <josh at glencoesoftware.com> escribió:
>>>>>>
>>>>>>>
>>>>>>> On Oct 31, 2012, at 5:03 PM, UNAI LORENZO SIERRA wrote:
>>>>>>>>
>>>>>>>>
>>>>>>>> Hi Josh,
>>>>>>>
>>>>>>>
>>>>>>> Hi Unai,
>>>>>>>
>>>>>>>> Could you please take a look at the attached image?
>>>>>>>>
>>>>>>>> The first error means:
>>>>>>>>
>>>>>>>> psql:C:/omero_dist/OMERO4.4__0.sql:25: ERROR: the relation
>>>>>>>> "acquisitionmode" already exists.
>>>>>>>
>>>>>>>
>>>>>>> That means that the OMERO database schema (OMERO4.4__0.sql) has
>>>>>>> already been applied (during a previous attempt?). Can you configure OMERO
>>>>>>> to use the same values and then try restarting the server?
>>>>>>>
>>>>>>> Cheers,
>>>>>>> ~Josh
>>>>>>>
>>>>>>>> Cheers,
>>>>>>>> Unai
>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>> Josh Moore <josh at glencoesoftware.com> escribió:
>>>>>>>>
>>>>>>>>>
>>>>>>>>> On Oct 31, 2012, at 4:28 PM, UNAI LORENZO SIERRA wrote:
>>>>>>>>>
>>>>>>>>>> Hi Josh,
>>>>>>>>>
>>>>>>>>>
>>>>>>>>> Hi Unai,
>>>>>>>>>
>>>>>>>>>> Thanks for the link. I got mixed with the created usernames and
>>>>>>>>>> passwords.
>>>>>>>>>> I've been able to access the database, eventually:
>>>>>>>>>>
>>>>>>>>>> Server [localhost]:
>>>>>>>>>> Database [postgres]: Biophot_database
>>>>>>>>>> Port [5432]:
>>>>>>>>>> Username [postgres]: Biofisica
>>>>>>>>>> Contrase±a para usuario Biofisica:
>>>>>>>>>> psql (9.2.1)
>>>>>>>>>> ADVERTENCIA: El código de página de la consola (850) difiere del
>>>>>>>>>> código
>>>>>>>>>>        de página de Windows (1252).
>>>>>>>>>>        Los caracteres de 8 bits pueden funcionar incorrectamente.
>>>>>>>>>>        Vea la página de referencia de psql «Notes for Windows
>>>>>>>>>> users»
>>>>>>>>>>        para obtener más detalles.
>>>>>>>>>> Digite «help» para obtener ayuda.
>>>>>>>>>>
>>>>>>>>>> Biophot_database=> \i C:/omero_dist/OMERO4.4__0.sql
>>>>>>>>>
>>>>>>>>>
>>>>>>>>> Excellent!
>>>>>>>>>
>>>>>>>>>
>>>>>>>>>> When I try to populate the database (using \i
>>>>>>>>>> C:/omero_dist/OMERO4.4__0.sql) I got some errors. Those errors mean that the
>>>>>>>>>> orders will be ignored until the end of the transaction. Here are the only
>>>>>>>>>> ones I've been able to copy:
>>>>>>>>>>
>>>>>>>>>>
>>>>>>>>>> psql:C:/omero_dist/OMERO4.4__0.sql:6899: ERROR:  transacción
>>>>>>>>>> abortada, las órden
>>>>>>>>>> es serán ignoradas hasta el fin de bloque de transacción
>>>>>>>>>> ...
>>>>>>>>>> psql:C:/omero_dist/OMERO4.4__0.sql:7200: ERROR:  transacción
>>>>>>>>>> abortada, las órden
>>>>>>>>>> es serán ignoradas hasta el fin de bloque de transacción
>>>>>>>>>> ROLLBACK
>>>>>>>>>> Biophot_database=> \q
>>>>>>>>>>
>>>>>>>>>>
>>>>>>>>>> Do you know if this could be the cause of my problem?
>>>>>>>>>
>>>>>>>>>
>>>>>>>>> This will definitely be a problem for OMERO and you won't be able
>>>>>>>>> to start until you can import OMERO4.4__0.sql successfully. However, the
>>>>>>>>> reason that you can't import that script isn't clear from these lines. Can
>>>>>>>>> you find the first line that has an ERROR on it?
>>>>>>>>>
>>>>>>>>> Cheers,
>>>>>>>>> ~Josh.
>>>>>>>>>
>>>>>>>>>> Thanks,
>>>>>>>>>> Unai
>>>>>>>>>>
>>>>>>>>>>
>>>>>>>>>>
>>>>>>>>>>
>>>>>>>>>>
>>>>>>>>>> Josh Moore <josh at glencoesoftware.com> escribió:
>>>>>>>>>>
>>>>>>>>>>>
>>>>>>>>>>> On Oct 31, 2012, at 2:00 PM, UNAI LORENZO SIERRA wrote:
>>>>>>>>>>>
>>>>>>>>>>>
>>>>>>>>>>> Hi Unai,
>>>>>>>>>>>
>>>>>>>>>>> Until you can access the database via the PostgreSQL command
>>>>>>>>>>> line, OMERO definitely won't be able to start. The URL
>>>>>>>>>>>
>>>>>>>>>>>
>>>>>>>>>>> https://www.openmicroscopy.org/site/support/omero4/sysadmins/windows/server-installation.html#creating-a-database-as-root
>>>>>>>>>>>
>>>>>>>>>>> shows how to make an example database named "omero_database" with
>>>>>>>>>>> example user "db_user" and example password "db_password". You changed
>>>>>>>>>>> "omero_database" to "Biophot_database", did you possibly change "db_user" or
>>>>>>>>>>> "db_password" similarly?
>>>>>>>>>>>
>>>>>>>>>>> Cheers,
>>>>>>>>>>> ~Josh
>>>>>>>>>>>
>>>>>>>>>>>
>>>>>>>>>>>> Thanks,
>>>>>>>>>>>> Unai
>>>>>>>>>>>>
>>>>>>>>>>>>
>>>>>>>>>>>> On Oct 31, 2012, at 1:15 PM, Andrew King wrote:
>>>>>>>>>>>>
>>>>>>>>>>>> The log definitely shows issues with the database:
>>>>>>>>>>>>
>>>>>>>>>>>> Caused by: org.postgresql.util.PSQLException: FATAL: la
>>>>>>>>>>>> autentificaci?n password fall? para el usuario ?db_user?
>>>>>>>>>>>>
>>>>>>>>>>>> Can you access the database using psql? Can you show us the full
>>>>>>>>>>>> command-line? Also, how have you configured the omero.db.* properties via
>>>>>>>>>>>> bin\omero config?
>>>>>>>>>>>>
>>>>>>>>>>>> Cheers,
>>>>>>>>>>>> ~Josh.

More information about the ome-users mailing list