Can't login into OMERO.server (known logins aren't working)

[slozosnitram]

Hi everybody !!

I'm new to OMERO and for testing purposes I installed OMERO.server with some(not all) dependancies on Windows 7 Pro workstation. Everything seems OK but when I'm trying to login using CMD and insight known logins aren't working.

BinOmeroLogin.JPG (25.75 KiB) Viewed 4340 times

Below I'm attaching diagnostics screen.

AdminDiagnostics.jpg (229.69 KiB) Viewed 4347 times

Any suggestions how to fix or where to look for solution ?!

Regards slozosnitram

[kennethgillen]

Hi Martins,

>Any suggestions how to fix or where to look for solution ?!

Could you please send us your Blitz logfile too?

C:\OMERO.server-5.1.1-ice34-b43\var\log\Blitz-0.log

You may submit .zip files of the logs, if you like, via our QA tool, or attach the zip to this forum post.

Thanks,

Kenny

[slozosnitram]

Please see attached C:\OMERO.server-5.1.1-ice34-b43\var\log\Blitz-0.log .rar file

[kennethgillen]

Hi Martins,

Please see attached C:\OMERO.server-5.1.1-ice34-b43\var\log\Blitz-0.log .rar file

In that file I'm seeing:

>ome.conditions.DatabaseBusyException: Cannot acquire connection

This is OMERO unable to talk to the database.

Please check that the database is running, and you can connect to it with the credentials OMERO is configured to use.

The output of the following OMERO command will tell us how OMERO is configured in that regard:

Code: Select all

omero config get --hide-password

Best,

Kenny

[slozosnitram]

I checked the db_name, db_password, db_user ... everything seems OK.
Can it be related to permissions OMERO is C:\ ..... PostgreSQL is C:\Progrm Files\.... ??
What if I reinstall PostgreSQL and recreate db in C:\..... ?

[manics]

Can you run this at the command line and paste the output (you should be prompted for the database password):

Code: Select all

>psql -h <DB-HOST> -U <DB_USER> -c "\conninfo" <DB-NAME>

[kennethgillen]

I checked the db_name, db_password, db_user ... everything seems OK.
Can it be related to permissions OMERO is C:\ ..... PostgreSQL is C:\Progrm Files\.... ??
What if I reinstall PostgreSQL and recreate db in C:\..... ?

If you could add to the post, as before, the output of:

Code: Select all

omero config get --hide-password

We can just glance over it.

[slozosnitram]

Good morning everybody !

Ok .... I reinstalled PostgreSQL from C:\Program Files to the C:\ , modified Env.var. in PATH, gave all possible permissions .... still result the same.
Here is the output of bin\omero config get --hide-password

LoginDetails.JPG (24.56 KiB) Viewed 4308 times

What I'm doing wrong !?

[manics]

Did you see my previous post? Can you run this at hte command line and show us the output?

Code: Select all

psql -h <DB-HOST> -U <DB_USER> -c "\conninfo" <DB-NAME>

Thanks

[slozosnitram]

OK I got connected

YEAH.JPG (17.77 KiB) Viewed 4301 times

but when I'm trying to do the same with bin\omero login I'm getting this

WTF.JPG (27.74 KiB) Viewed 4301 times

..... and how can I login using .insight (it uses port 4064)