We're Hiring!

OMERO server 4.03 login problems

Having a problem deploying OMERO? Please ask new questions at https://forum.image.sc/tags/omero
Please note:
Historical discussions about OMERO. Please look for and ask new questions at https://forum.image.sc/tags/omero

The OMERO.server installation documentation begins here and you can find OMERO.web deployment documentation here.

OMERO server 4.03 login problems

Postby chekki » Mon Jun 08, 2009 4:01 pm

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
chekki
 
Posts: 10
Joined: Mon Jun 08, 2009 3:42 pm

Re: OMERO server 4.03 login problems

Postby jmoore » Mon Jun 08, 2009 4:42 pm

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
User avatar
jmoore
Site Admin
 
Posts: 1591
Joined: Fri May 22, 2009 1:29 pm
Location: Germany

Re: OMERO server 4.03 login problems

Postby chekki » Mon Jun 15, 2009 8:32 am

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
chekki
 
Posts: 10
Joined: Mon Jun 08, 2009 3:42 pm

Re: OMERO server 4.03 login problems

Postby jmoore » Mon Jun 15, 2009 8:50 am

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.
User avatar
jmoore
Site Admin
 
Posts: 1591
Joined: Fri May 22, 2009 1:29 pm
Location: Germany

Re: OMERO server 4.03 login problems

Postby chekki » Mon Jun 15, 2009 1:28 pm

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
chekki
 
Posts: 10
Joined: Mon Jun 08, 2009 3:42 pm

Re: OMERO server 4.03 login problems

Postby jmoore » Mon Jun 15, 2009 1:46 pm

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


chekki wrote: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.
User avatar
jmoore
Site Admin
 
Posts: 1591
Joined: Fri May 22, 2009 1:29 pm
Location: Germany

Re: OMERO server 4.03 login problems

Postby chekki » Mon Jun 15, 2009 4:10 pm

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
chekki
 
Posts: 10
Joined: Mon Jun 08, 2009 3:42 pm

Re: OMERO server 4.03 login problems

Postby jmoore » Mon Jun 15, 2009 8:32 pm

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".
User avatar
jmoore
Site Admin
 
Posts: 1591
Joined: Fri May 22, 2009 1:29 pm
Location: Germany

Re: OMERO server 4.03 login problems

Postby chekki » Fri Jun 19, 2009 7:07 am

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...
Attachments
windefault.zip
(1.07 KiB) Downloaded 351 times
chekki
 
Posts: 10
Joined: Mon Jun 08, 2009 3:42 pm

Re: OMERO server 4.03 login problems

Postby jmoore » Sat Jun 20, 2009 6:05 pm

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
User avatar
jmoore
Site Admin
 
Posts: 1591
Joined: Fri May 22, 2009 1:29 pm
Location: Germany

Next

Return to Installation and Deployment

Who is online

Users browsing this forum: No registered users and 1 guest