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

[Josh Moore]

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