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

[Josh Moore]

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