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

[kennethgillen]

OK I got connected

Try removing the single quotes either side of the DB name in the OMERO configuration.

omero config set omero.db.name omerodb

[slozosnitram]

Removed the quotes.

SingleQuotes.JPG (31.37 KiB) Viewed 3355 times

[kennethgillen]

Removed the quotes.

Okay, time for another Blitz-0.log please! (the quotes would highly likely have stopped OMERO talking to the database - we'll see what's being logged now).

Thanks.

[slozosnitram]

BLITZ attachement

[kennethgillen]

BLITZ attachement

More problems with OMERO connecting to the database.

Can you try the following using psql?

Code: Select all

psql -h <DB-HOST> -U <DB_USER> -c "select * from dbpatch" <DB-NAME>

This will tell us if the DB creation/scaffolding scripts were run successfully c.f https://www.openmicroscopy.org/site/sup ... stallation

[slozosnitram]

DBscriptStuff.JPG (18.16 KiB) Viewed 3349 times

[manics]

Looks like your database is empty. What steps did you do to initialise it?

Edit: Also it looks like you're using an old server, the latest (and best supported) is 5.2.1: http://downloads.openmicroscopy.org/omero/5.2.1/

[kennethgillen]

DBscriptStuff.JPG

So this tells us that the OMERO database doesn't have one of the required tables.

If you were to perform a listing with a "Describe" statement like the following

Code: Select all

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

It will tell you what objects are in the OMERO database. This would normally include the table "dbpatch" which OMERO requires. If you could attach the output of that command, that'd be useful.

Your initial post said "known logins aren't working." suggesting you did have a working system. Do you have any Database backups? Did anything happen to the database that you were previously using?

[slozosnitram]

As I said I'm new to OMERO .
Organisation I'm working for asked me to test OMERO products so we can decide is it good for them. Original purpose will be 3D microorganism image database. So at the moment I'm trying to setup Omero.server on temp workstation to have the basic uderstanding how it works and what's necessary to make it work (no I don't have working system yet....at this moment all images are in the file system "all over the place" which means they don't have working db ). Afterwards we are going to install full set on to Linux/Ubuntu server.

[manics]

Afterwards we are going to install full set on to Linux/Ubuntu server.

Is there any chance you could get access to a Linux/Ubuntu server now? OMERO is a lot easier to install on Linux, If it's Ubuntu 14.04 we have scripts you can copy to do most of the work.