Page 1 of 3

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

PostPosted: Thu Jan 28, 2016 1:34 pm
by 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
BinOmeroLogin.JPG (25.75 KiB) Viewed 4338 times

Below I'm attaching diagnostics screen.
AdminDiagnostics.jpg
AdminDiagnostics.jpg (229.69 KiB) Viewed 4345 times

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

Regards slozosnitram

Re: Can't login into OMERO.server (known logins aren't worki

PostPosted: Thu Jan 28, 2016 1:50 pm
by 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

Re: Can't login into OMERO.server (known logins aren't worki

PostPosted: Thu Jan 28, 2016 1:56 pm
by slozosnitram
Please see attached C:\OMERO.server-5.1.1-ice34-b43\var\log\Blitz-0.log .rar file

Re: Can't login into OMERO.server (known logins aren't worki

PostPosted: Thu Jan 28, 2016 2:05 pm
by kennethgillen
Hi Martins,

slozosnitram wrote: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

Re: Can't login into OMERO.server (known logins aren't worki

PostPosted: Thu Jan 28, 2016 3:26 pm
by 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:\..... ?

Re: Can't login into OMERO.server (known logins aren't worki

PostPosted: Thu Jan 28, 2016 3:51 pm
by 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>

Re: Can't login into OMERO.server (known logins aren't worki

PostPosted: Thu Jan 28, 2016 4:45 pm
by kennethgillen
slozosnitram wrote: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.

Re: Can't login into OMERO.server (known logins aren't worki

PostPosted: Fri Jan 29, 2016 9:48 am
by 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
LoginDetails.JPG (24.56 KiB) Viewed 4306 times


What I'm doing wrong !?

Re: Can't login into OMERO.server (known logins aren't worki

PostPosted: Fri Jan 29, 2016 10:05 am
by 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

Re: Can't login into OMERO.server (known logins aren't worki

PostPosted: Fri Jan 29, 2016 10:49 am
by slozosnitram
OK I got connected
YEAH.JPG
YEAH.JPG (17.77 KiB) Viewed 4299 times

but when I'm trying to do the same with bin\omero login I'm getting this
WTF.JPG
WTF.JPG (27.74 KiB) Viewed 4299 times

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