OMERO server 4.03 login problems

[chekki]

Hi,

I read a thread in the old ome community forum, initiated by Jon, see below. It reports the same problem (not able to login to OMERO) I face right now deploying Omero Server 4.0.3 on XP.
Unfortunately this thread was not continued but I hope that somebody can help me out.
Some hints how to proceed would be great!

I attached some logs for detailed info.

Thanks and regards,

Stefan

OMEROweb.zip

(7.84 KiB) Downloaded 489 times

------------------------------------------------------------------
old thread...
------------------------------------------------------------------
Jon Wakelin writes:
> Dear All,

Hi Jon,

the message

> PermissionDeniedException: exception ::Glacier2::PermissionDeniedException
> {
> reason = internal server error
> }

tell us that the blitz server is not properly started. Can you send us
the Blitz-0.log from the var/log directory?

Thanks,
~Josh.

> I've just installed OMERO beta4.0.1. on Linux but I'm having problems
> logging in. I'm not sure which username/password I'm meant to use when
> accessing OMERO.web (http://<myserver>:8000/webadmin)
>
> I can access the page just fine, but no matter what combination of
> username/passwords I try I get the following message on the login page:
>
> "Error: PermissionDeniedException"
>
> and the following entry in $OMERO_HOME/var/log/OMEROweb.log :
>
> --------------------------------------------------------------------------------
>
> 2009-04-23 16:29:28,507 gateway : INFO Starting thread...
> 2009-04-23 16:29:28,508 gateway : INFO Connecting...
> 2009-04-23 16:29:28,514 gateway : ERROR Traceback (most recent
> call last):
> File "/opt/omero_dist/lib/python/omeroweb/extlib/gateway.py", line
> 159, in connect
> self.c.createSession(self._props[omero.constants.USERNAME],
> self._props[omero.constants.PASSWORD])
> File "/opt/omero_dist/lib/python/omero/__init__.py", line 335, in
> createSession
> prx = self.getRouter(self.__ic).createSession(username, password)
> File "/opt/Ice/py/python/Glacier2_Router_ice.py", line 107, in
> createSession
> return _M_Glacier2.Router._op_createSession.invoke(self, ((userId,
> password), _ctx))
> PermissionDeniedException: exception ::Glacier2::PermissionDeniedException
> {
> reason = internal server error
> }
>
> 2009-04-23 16:29:28,514 views-web : ERROR Traceback (most recent
> call last):
> File "/opt/omero_dist/lib/python/omeroweb/webclient/views.py", line
> 160, in getConnection
> conn.connect()
> File "/opt/omero_dist/lib/python/omeroweb/extlib/gateway.py", line
> 187, in connect
> raise x
> PermissionDeniedException: exception ::Glacier2::PermissionDeniedException
> {
> reason = internal server error
> }
>
>
> --------------------------------------------------------------------------------
>
>
> (1) I've tried the password that I set at this point of the installation:
>
> bin/omero config set omero.db.name <password>
> bin/omero config set omero.db.user <username>
>
>
> (2) I've also tried the password that I set at this point of the
> installation:
>
> $ bin/omero db script
> Please enter omero.db.version [OMERO4]:
> Please enter omero.db.patch [0]:
> Please enter password for new OMERO root user:
> Please re-enter password for new OMERO root user:
> Saving to /home/omero/Desktop/omero/OMERO4__0.sql
> $ psql -h localhost -U omero omero < OMERO4__0.sql
>
> (3) And I've tried the password that I set when I ran:
>
> python manage.py syncdb
>
>
> none of them seems to work. Am I missing something obvious? How should
> I login at http://localhost:8000/webclient ?
>
> regards
> Jon
> _______________________________________________
> ome-users mailing list
> ome-users at lists.openmicroscopy.org.uk
> http://lists.openmicroscopy.org.uk/mail ... /ome-users

[jmoore]

In the server log (Blitz-0.log) if you scroll somewhere into the middle you'll see:

Code: Select all

=====================================================
Data access exception: Did you create your database?
=====================================================


Did the "psql omero < OMERO4__0.sql" step work for you? Did you choose a database name other than "omero"? Can you show us the output of

Code: Select all

psql YOURDATABASENAMEHERE -c "\d"


Cheers,
~Josh

[chekki]

Thanks Josh,

yes, the command worked fine and the database name is omero.
Command did not work out, or I did a mistake in setting it ip, see listing:

D:\Program Files\PostgreSQL\8.3\bin>psql omero -c "\d"
psql: Warnung: überflüssiges Kommandozeilenargument »\d« ign
Passwort fⁿr Benutzer -c:
psql: FATAL: password authentication failed for user "-c"

Stefan

[jmoore]

Hmmm....perhaps that's a difference under Windows. However, "psql omero -c '\d'" should just print a list of all the tables to make sure that database creation was successful:

Code: Select all

$ psql omero -c "\d"
                               List of relations
Schema |                         Name                          | Type  | Owner
--------+-------------------------------------------------------+-------+-------
public | acquisitionmode                                       | table | josh
public | annotation                                            | table | josh
public | annotationannotationlink                              | table | josh
...


which you can also do after connecting:

Code: Select all

psql omero
...
omero=# \d


But if you know that db creation was successful, then the next check is to make sure that:

Code: Select all

psql -h localhost -U <yourdbuser> omero


works, either with no password or with the same password to which you set the "omero.db.pass" configuration property.

[chekki]

Thanks for fast response.

Finally got the output of the command:

omero-> omero=# \d
Liste der Relationen
Schema | Name | Typ | Eige
ntⁿmer
--------+-------------------------------------------------------+---------+-----
-------
public | acquisitionmode | Tabelle | omer
o
public | annotation | Tabelle | omer
o
public | annotationannotationlink | Tabelle | omer
o
public | arc | Tabelle | omer
o
...

Retried to run server but same message - Permission denied! Used user: omero and pwd: omero in login mask.

BTW: Can login into omero database using , but I have to use explicit username "omero", otherwise it fails using my default user name of windows. Is that normal?
See output:
D:\Program Files\PostgreSQL\8.3\bin>psql omero
Passwort:
psql: FATAL: password authentication failed for user "Stefan"

D:\Program Files\PostgreSQL\8.3\bin>psql -U omero omero
Passwort fⁿr Benutzer omero:
Dies ist psql 8.3.7, das interaktive PostgreSQL-Terminal.

Geben Sie ein: \copyright für Urheberrechtsinformationen
\h für Hilfe über SQL-Anweisungen
\? für Hilfe über interne Anweisungen
\g oder Semikolon, um eine Anfrage auszuführen
\q um zu beenden

Warnung: Konsolencodeseite (437) unterscheidet sich von der Windows-
Codeseite (1252). 8-Bit-Zeichen funktionieren möglicherweise nicht
richtig. Einzelheiten finden Sie auf der psql-Handbuchseite unter
»Notes for Windows users«.

omero=>
-----------------------------------------------

Any further ideas?

Stefan

[jmoore]

Retried to run server but same message - Permission denied! Used user: omero and pwd: omero in login mask.

Hmmm....does this mean that the results of:

Code: Select all

bin/omero config get


don't include any other values for "omero.db.name", "omero.db.user" and "omero.db.pass"? I.e. you are using all defaults. If so, then this is certainly sounding odd. As long as:

Code: Select all

psql -h <omero.db.host> -U <omero.db.user> <omero.db.name>
Password: <omero.db.pass>


works from the command-line, the server should be able to connect. If the "omero.db.*" properties don't show up in the output of "bin/omero config get", then the defaults are:

Code: Select all

omero.db.host=localhost
omero.db.name=omero
omero.db.user=omero
omero.db.pass=omero


BTW: Can login into omero database using , but I have to use explicit username "omero", otherwise it fails using my default user name of windows. Is that normal?
See output: D:\Program Files\PostgreSQL\8.3\bin>psql omero
Passwort:
psql: FATAL: password authentication failed for user "Stefan"

D:\Program Files\PostgreSQL\8.3\bin>psql -U omero omero

Yes, this is expected. By default, psql tries to use your current logged-in user for accessing the database, which is why we add the "-U <omero.db.user>" in the snippet above.

[chekki]

Josh, checked configuration and looks ok to me, but this is strange, can't get the config settings, see:

omero> config get

omero> config all
default

omero>

Where can I set the keys? Did I forget a step in setup? Manually setting by using config set omero.db.* didn't work either.

Thanks, Stefan

[jmoore]

My apologies, Stefan. I forgot a vital fact from your previous postings: you're working on Windows. Duh. Under "Limitations" on install-windows , it says:

bin\omero config does not work as advertised. omero config uses the registry but sets values for the current user, while the service is run as Local Services. If you are interested in running as another user, please contact the OME lists) See the "Installation" section for how to configure your setup.

any special configuration must take place in "etc\grid\windefault.xml".

[chekki]

Josh, I did check the windefault file, see previous posts, attached version of the file I configured with correct settings, cannot see anything wrong - maybe you can...

[jmoore]

Your windefault.xml certainly looks fine. Can you just verify that:

D:\Program Files\PostgreSQL\8.3\bin>psql -h localhost -U omero omero
Passwort für Benutzer omero: omero

works for you. The "-h localhost" is important since that specifies to connect to postgres over TCP (like the Java server must do) rather than using a local socket. If that fails, then the Postgres server will need to be configured for allowing TCP connections