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

Thu Nov 1 20:33:03 GMT 2012

Hi Josh,
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?

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...

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.
>>>>
>>>
>>> Esta cabecera ha sido añadida automáticamente por la Vicegerencia  
>>> de las TIC:
>>> --------------------------------------------------------------------------------
>>> ATENCION!! Este correo contiene la palabra "contraseña" y puede  
>>> tratarse de un fraude.
>>> No proporcione nunca sus credenciales por correo electrónico.
>>> Si tiene alguna duda consulte con el CAU (154400).
>>> UPV/EHU, Vicegerencia de las TIC
>>>
>>> ERNE!! Mezu honek "contraseña" hitza dauka eta iruzurrezko mezua  
>>> izan daiteke.
>>> Ez eman inoiz zure pasahitza posta elektronikoaren bidez.
>>> Zalantzarik izanez gero deitu BAZren telefonora (154400)
>>> UPV/EHU, IKT Gerenteordetza
>>> --------------------------------------------------------------------------------
>>> ·
>>>
>>>
>>
>>
>> <ERROR Screenshot.jpg>_______________________________________________
>> ome-users mailing list
>> ome-users at lists.openmicroscopy.org.uk
>> http://lists.openmicroscopy.org.uk/mailman/listinfo/ome-users
>
> Esta cabecera ha sido añadida automáticamente por la Vicegerencia de las TIC:
> --------------------------------------------------------------------------------
> ATENCION!! Este correo contiene la palabra "contraseña" y puede  
> tratarse de un fraude.
> No proporcione nunca sus credenciales por correo electrónico.
> Si tiene alguna duda consulte con el CAU (154400).
> UPV/EHU, Vicegerencia de las TIC
>
> ERNE!! Mezu honek "contraseña" hitza dauka eta iruzurrezko mezua  
> izan daiteke.
> Ez eman inoiz zure pasahitza posta elektronikoaren bidez.
> Zalantzarik izanez gero deitu BAZren telefonora (154400)
> UPV/EHU, IKT Gerenteordetza
> --------------------------------------------------------------------------------
> ·
>
>