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

[Josh Moore]

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