We're Hiring!

cannot log in to omero root account

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.

cannot log in to omero root account

Postby dpbrown » Thu Apr 07, 2016 9:25 pm

I have a new setup that appears to be basically working: After starting omero and omero web, I'm able to bring up the OMERO.web login page but am unable to log in using the omero root user credentials. Also, I cannot log in to the root account from the command line.

According to the Diagnostics output, it appears that everything's up and running (except DropBox).

I've confirmed that i can connect to the DB and that DB creation/configuration is ok

Here's a summary of the platform:

Dell Precision 370
2GB RAM (I'll be increasing this to 8GB asap)
4TB HD
CentOS 6.5 (yeah, I know...., but I followed the guidelines for setting up Python 2.7 & Ice 3.5 on CentOS 6 and think I have things in place)

I'm attaching copies of the Diagnostics and the Blitz-0 log file and a terminal snippet of the DB access operations.

Any suggestions would be appreciated.

Almost forgot to mention: I've reset the omero root password. The initial version had a special character in it and I wanted to make sure that wasn't the problem.
Attachments
Diagnostics_4-7-2016.txt.zip
(2.06 KiB) Downloaded 198 times
OMERO_DB_access_4-7-2016.txt.zip
(1.05 KiB) Downloaded 187 times
Blitz-0_4-7-2016.log.zip
(78.74 KiB) Downloaded 192 times
dpbrown
 
Posts: 19
Joined: Thu Sep 02, 2010 9:29 pm

Re: cannot log in to omero root account

Postby atarkowska » Thu Apr 07, 2016 10:42 pm

Hi, Could you also send us OMEROweb*.log ?

Ola
atarkowska
 
Posts: 327
Joined: Mon May 18, 2009 12:44 pm

Re: cannot log in to omero root account

Postby dpbrown » Fri Apr 08, 2016 3:00 pm

Here's the OMEROweb.log from my system.

You'll notice that it complains about the lack of PIL. I've confirmed PIL (Pillow-2.9.0) is installed. I can import any of the appropriate modules from the command line (e.g. python -c 'from PIL import Image''. Don't understand why the same command in webclient_gateway.py doesn't work.

I didn't think this would be involved in logins to the root account from the command line.

dpb
Attachments
OMEROweb_4-8-2016.log.zip
(7.71 KiB) Downloaded 198 times
dpbrown
 
Posts: 19
Joined: Thu Sep 02, 2010 9:29 pm

Re: cannot log in to omero root account

Postby atarkowska » Mon Apr 11, 2016 10:29 am

Hi,

Did you set up your bash like stated in the doc https://www.openmicroscopy.org/site/sup ... requisites?

Code: Select all
# Environment file for OMERO

ICE_HOME=/opt/Ice-3.5.1
export PATH="${ICE_HOME}/bin:/home/omero/omeroenv/bin:$PATH"
#Remove commented out export below if Ice is not set globally accessible
#export LD_LIBRARY_PATH="${ICE_HOME}/lib64:${ICE_HOME}/lib:$LD_LIBRARY_PATH"
export PYTHONPATH="${ICE_HOME}/python:$PYTHONPATH"
export SLICEPATH="${ICE_HOME}/slice"


echo source /home/omero/omero-centos6py27ius.env >> /home/omero/.bashrc

Is Pillow installed in your virtualenv?

Code: Select all
/home/omero/omeroenv/lib64/python2.7/site-packages


If you started OMERO.web withouth previously activating omeroenv this will result in missing Pillow

Ola
atarkowska
 
Posts: 327
Joined: Mon May 18, 2009 12:44 pm

Re: cannot log in to omero root account

Postby atarkowska » Mon Apr 11, 2016 10:48 am

as

Code: Select all
$ omero login
Server: [localhost:4064]
Username: [omero]root
Password:
Password check failed for 'root': [id=0]
Password:Cancelled
InternalException: Failed to connect: die called: Cancelled


dod you use correct password?

could you also show me the output of

Code: Select all
omero --debug=debug,trace login


Ola
atarkowska
 
Posts: 327
Joined: Mon May 18, 2009 12:44 pm

Re: cannot log in to omero root account

Postby dpbrown » Mon Apr 11, 2016 9:18 pm

Yes, I've confirmed that my bashrc is configured as directed.

And yes, Pillow (2.9.0) is installed in my virtualenv and I can import PIL modules from the command line (after activating virtualenv).

I've started OMERO.web after activating omeroenv and still see "Pillow not installed" in my OMEROweb.log following an attempt to log in from the OMERO.web interface.

I've double-checked the omero root user password and I'm confident I'm using the correct pw. Still getting
Code: Select all
Password check failed for 'root': [id=0]


I've attached the output form a login attempt using
Code: Select all
omero --debug=debug,trace login
Attachments
Omero_login_debug-trace_4-11-2016.txt.zip
(28.38 KiB) Downloaded 198 times
dpbrown
 
Posts: 19
Joined: Thu Sep 02, 2010 9:29 pm

Re: cannot log in to omero root account

Postby atarkowska » Wed Apr 13, 2016 9:37 am

Hi

Log files: Blitz-0.log n/a


Is the server running?

If you have any stale processes, you need to kill them

Try bin/omero admin stop , delete content of OMERO.server/var and then bin/omero admin start

Ola
atarkowska
 
Posts: 327
Joined: Mon May 18, 2009 12:44 pm

Re: cannot log in to omero root account

Postby dpbrown » Wed Apr 13, 2016 3:47 pm

Yes, I've always made sure I've had a fresh restart of omero (as well as omero.web) prior to all of my attempts to login as root.

The most recent effort followed the deletion of the contents of OMERO.server/var as you suggested.

I've attached the terminal output of this most recent attempt, which includes the diagnostics output.

Unless you have a better suggestion, I think I'm going to start over and build a new system de novo. This time I'll try CentOS 7 to obviate the need for all of the alternate Python installation mischief.
Attachments
omero_start_after_var_wipe_4-13-2016.txt.zip
(2.07 KiB) Downloaded 197 times
dpbrown
 
Posts: 19
Joined: Thu Sep 02, 2010 9:29 pm

Re: cannot log in to omero root account

Postby jmoore » Thu Apr 14, 2016 11:12 am

Have you ever been able to login to the server? How did you reset the root password? I wonder if some console handling has affected the hashing. For example, if you have openssl installed you can double check that the SQL for updating the password matches:

Code: Select all
$ bin/omero db password --no-salt ome
UPDATE password SET hash = 'vvFwuczAmpyoRC0Nsv8FCw==' WHERE experimenter_id  = 0;

$ echo -n ome | openssl md5 -binary | openssl base64
vvFwuczAmpyoRC0Nsv8FCw==


Cheers,
~Josh.
User avatar
jmoore
Site Admin
 
Posts: 1591
Joined: Fri May 22, 2009 1:29 pm
Location: Germany

Re: cannot log in to omero root account

Postby dpbrown » Thu Apr 14, 2016 5:11 pm

Bingo!!

I'd never succeeded with any omero root login attempts. And as I mentioned, suspecting my original pw was problematic, I reset it thus:

Code: Select all
[omero@omero ~]$ omero db password
Please enter password for OMERO root user:
Please re-enter password for OMERO root user:
UPDATE password SET hash = 'ibTzrADXfsKFfNwBdQsa+g==' WHERE experimenter_id  = 0;
[omero@omero ~]$


Thought that was all there was to it. Didn't realize that the hash wouldn't propagate to the db, which it hadn't:

Code: Select all
[omero@omero ~]$ psql -h localhost omdbprim -U omdbusr1 -c " select * from password"
Password for user omdbusr1:
experimenter_id |           hash           | changed
-----------------+--------------------------+---------
               0 | kO7cztnXqU33M8Hk5kr6DQ== |
               1 |                          |
(2 rows)


So, today I did so manually and double-checked that it matches:

Code: Select all
[omero@omero ~]$ psql -h localhost omdbprim -U omdbusr1 -c "UPDATE password SET hash = 'ibTzrADXfsKFfNwBdQsa+g==' WHERE experimenter_id  = 0;"
Password for user omdbusr1:
UPDATE 1
[omero@omero ~]$
[omero@omero ~]$
[omero@omero ~]$ psql -h localhost omdbprim -U omdbusr1 -c " select * from password"
Password for user omdbusr1:
experimenter_id |           hash           | changed
-----------------+--------------------------+---------
               1 |                          |
               0 | ibTzrADXfsKFfNwBdQsa+g== |
(2 rows)


And lo and behold, I can now log in to the root account from the command line!

I can authenticate for the root account as well using the OMERO.web client. However, whenever I try to do anything within the web interface, I get returned to the login screen.

I suspect this is probably due to OMERO.web still not recognizing that I have PIL installed (yes, in the omeroenv). OMEROweb log still says "No Pillow installed...."

Any suggestions for a resolution of this last problem?
dpbrown
 
Posts: 19
Joined: Thu Sep 02, 2010 9:29 pm

Next

Return to Installation and Deployment

Who is online

Users browsing this forum: No registered users and 1 guest