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

Josh Moore josh at glencoesoftware.com
Fri Nov 2 13:13:35 GMT 2012 

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