WinXP: "Error: PermissionDeniedException"

[afcarl]

Hello,
I've installed on two seperate pc's and am unable to logon via OMERO.insight.exe or OMEROWEB. Contents of OMEROweb.log as follows:

Tue, 28 Jul 2009 10:59:30 omero.util.UpgradeCheck ERROR <urlopen error (11001, 'getaddrinfo failed')>
Tue, 28 Jul 2009 10:59:30 root ERROR Settings.py has not been configured. EmailServerError: The application will not send any emails. Sharing notification is not available.

Tue, 28 Jul 2009 10:59:30 root INFO Application Starting...
Tue, 28 Jul 2009 10:59:46 views-admin INFO INIT '1324'
Tue, 28 Jul 2009 10:59:46 views-admin INFO timing getConnection
Tue, 28 Jul 2009 10:59:46 views-admin INFO timed getConnection : 0.100000
Tue, 28 Jul 2009 10:59:59 views-admin INFO timing getConnection
Tue, 28 Jul 2009 10:59:59 gateway INFO Starting thread...
Tue, 28 Jul 2009 10:59:59 gateway INFO Connecting...
Tue, 28 Jul 2009 10:59:59 gateway ERROR Traceback (most recent call last):
File "C:\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 "C:\omero_dist\lib\python\omero\__init__.py", line 335, in createSession
prx = self.getRouter(self.__ic).createSession(username, password)
File "C:\Ice-3.3.1\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
}

Tue, 28 Jul 2009 10:59:59 views-admin ERROR Traceback (most recent call last):
File "C:\omero_dist\lib\python\omeroweb\webadmin\views.py", line 144, in getConnection
conn.connect()
File "C:\omero_dist\lib\python\omeroweb\extlib\gateway.py", line 187, in connect
raise x
PermissionDeniedException: exception ::Glacier2::PermissionDeniedException
{
reason = internal server error
}

Tue, 28 Jul 2009 11:00:50 views-admin INFO timing getConnection
Tue, 28 Jul 2009 11:00:50 gateway INFO Starting thread...
Tue, 28 Jul 2009 11:00:50 gateway INFO Connecting...
Tue, 28 Jul 2009 11:00:50 gateway ERROR Traceback (most recent call last):
File "C:\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 "C:\omero_dist\lib\python\omero\__init__.py", line 335, in createSession
prx = self.getRouter(self.__ic).createSession(username, password)
File "C:\Ice-3.3.1\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
}

Tue, 28 Jul 2009 11:00:50 views-admin ERROR Traceback (most recent call last):
File "C:\omero_dist\lib\python\omeroweb\webadmin\views.py", line 144, in getConnection
conn.connect()
File "C:\omero_dist\lib\python\omeroweb\extlib\gateway.py", line 187, in connect
raise x
PermissionDeniedException: exception ::Glacier2::PermissionDeniedException
{
reason = internal server error
}

password)
File "C:\Ice-3.3.1\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-07-28 11:00:50,943 views-admin : ERROR Traceback (most recent call last):
File "C:\omero_dist\lib\python\omeroweb\webadmin\views.py", line 144, in getConnection
conn.connect()
File "C:\omero_dist\lib\python\omeroweb\extlib\gateway.py", line 187, in connect
raise x
PermissionDeniedException: exception ::Glacier2::PermissionDeniedException
{
reason = internal server error
}

How can I remove the requirement for password entry, so that I may verify otherwise normal operation?
Thanks,
Andy

[cxallan]

Hi Andy,

You can disable the password authentication by modifying the database directly but I suspect you have some server problems. Can you ZIP up and attach your C:\omero_dist\var\log?

What would also be helpful, from PostgreSQL:

Code: Select all

SELECT * FROM password;


[afcarl]

Please find attached the requested zipfile of the log folder. The post entitled: "OMERO server 4.03 login problems" is the same issue, but already has gone through a partial discovery process, but did not complete to find the answer. I pm'd the original poster, and he stated that he had given up on WinXP and switched to Linux to get around this problem. I do not have that option.
Thanks,
Andy

[cxallan]

While your client side error is similar you have a fully working OMERO server install based on your log file. It just appears that you have been entering the password incorrectly:

Code: Select all

...
2009-08-03 09:39:50,359 INFO  [        ome.services.util.ServiceHandler] (l.Server-6)  Executor.doWork -- ome.services.sessions.SessionManagerImpl.executeCheckPassword
2009-08-03 09:39:50,359 INFO  [        ome.services.util.ServiceHandler] (l.Server-6)  Args:    [null, ome.tools.spring.InternalServiceFactory@14f8b9a]
2009-08-03 09:39:50,437 INFO  [         ome.security.basic.EventHandler] (l.Server-6)  Auth:    user=0,group=0,event=null(Sessions)
2009-08-03 09:39:50,437 INFO  [        ome.services.util.ServiceHandler] (l.Server-6)  Rslt:    false
...


I assume you are attempting to login as "root"? Did you use the default password?

If you wish to reset the root password to "password", run the following from the PostgreSQL command line:

Code: Select all

UPDATE password SET hash = 'X03MO1qnZdYdgyfeuILPmQ==' WHERE experimenter_id = 0;


[afcarl]

I have been using the following:
Username: omero
Password: omero

Nothing fancy, just trying to follow the winxp install instruction exactly. But both the insight client and omeroweb logins are behaving the same. There appears to be a disconnect regarding the username/password between the server and clients. Any suggestions to run this to ground?

Thanks, Andy

[cxallan]

The username "root" is the only one created by default. So, you're going to want to login with "root", "omero".

[afcarl]

Well, that got me logged in to both the insight and omeroweb clients (i.e. "UPDATE password SET hash = 'X03MO1qnZdYdgyfeuILPmQ==' WHERE experimenter_id = 0;", and loging in w/ Username=root & Password=password). Thank you!

My next question, is why Username=omero & Password=omero works for psql, but not the clients since I followed the Windows install instuctions?
Thanks,
Andy

[cxallan]

Well, that got me logged in to both the insight and omeroweb clients (i.e. "UPDATE password SET hash = 'X03MO1qnZdYdgyfeuILPmQ==' WHERE experimenter_id = 0;", and loging in w/ Username=root & Password=password). Thank you!

My next question, is why Username=omero & Password=omero works for psql, but not the clients since I followed the Windows install instuctions?
Thanks,
Andy

Because that username and password is for the server to connect to the database server. OMERO has its own set of authentication credentials, stored in the database. The password for the initial user "root" was what you were setting during the database creation phase of the install.