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

[UNAI LORENZO SIERRA]

Hi Josh,

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.

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


-------------- next part --------------
A non-text attachment was scrubbed...
Name: ERROR Screenshot.jpg
Type: image/jpeg
Size: 458514 bytes
Desc: not available
URL: <http://lists.openmicroscopy.org.uk/pipermail/ome-users/attachments/20121031/f8646c69/attachment.jpg>