We're Hiring!

CLOSED: omero library setting issue

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.

Re: omero library setting issue

Postby toh2 » Tue Apr 05, 2011 3:17 pm

I already tried ID(root) and password(testomero) to log in the web.
But, it seems not work.

Anyway, I executed commands like you said above.

Code: Select all
[omerouser@europa bin]$ ./omero db password
Please enter password for OMERO root user:
Please re-enter password for OMERO root user:
UPDATE password SET hash = 'QdBhtcCVVuZomIa3ejRUSw==' WHERE experimenter_id = 0;
[omerouser@europa bin]$ psql omero -c "UPDATE password SET hash = 'QdBhtcCVVuZomIa3ejRUSw==' WHERE experimenter_id = 0;"
psql: FATAL:  role "omerouser" does not exist


I think that database name should be omero. I don't know why this error message was generated.
psql: FATAL: role "omerouser" does not exist

Thanks for your help in advance.

Steve
toh2
 
Posts: 40
Joined: Tue Mar 01, 2011 6:59 pm

Re: omero library setting issue

Postby toh2 » Tue Apr 05, 2011 3:22 pm

Hi Josh,

I tried root (id) and testomero(p.w) to log in the omero web.
but it seems not work.

anyway, I executed commands like as follows.
Code: Select all
[omerouser@europa bin]$ ./omero db password
Please enter password for OMERO root user:
Please re-enter password for OMERO root user:
UPDATE password SET hash = 'QdBhtcCVVuZomIa3ejRUSw==' WHERE experimenter_id = 0;
[omerouser@europa bin]$ psql omero -c "UPDATE password SET hash = 'QdBhtcCVVuZomIa3ejRUSw==' WHERE experimenter_id = 0;"
psql: FATAL:  role "omerouser" does not exist


It still generated error message (psql: FATAL: role "omerouser" does not exist)
I guess that 'omero' should be a database name.

Thanks in advance,
Steve
toh2
 
Posts: 40
Joined: Tue Mar 01, 2011 6:59 pm

Re: omero library setting issue

Postby jmoore » Tue Apr 05, 2011 3:33 pm

Hi Steve,

That's because "omerouser" (your Linux user) is not configured to access the database. Assuming the directions on the installation guide, you probably want to use the "omero" database user:
Code: Select all
psql -h localhost -U omero omero -c "UPDATE password SET hash = 'QdBhtcCVVuZomIa3ejRUSw==' WHERE experimenter_id = 0;"

It may ask for a password which may be "omero".

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

Re: omero library setting issue

Postby toh2 » Wed Apr 06, 2011 2:42 pm

Thanks for your reply.

I executed commands as follows.

Code: Select all
[omerouser@europa bin]$ ./omero db script
Please enter omero.db.version [OMERO4.2]: 4.2
Please enter omero.db.patch [0]: 0
Invalid Database version/patch: /home/omerouser/omero/omero_dist/sql/psql/4.2__0 does not exist


could you let me know what is appropriate version and patch ?

also, I run commands as follows.

Code: Select all
[omerouser@europa bin]$ psql omero -c "UPDATE password SET hash = 'vvFwuczAmpyoRC0Nsv8FCw==' WHERE experimenter_id = 0;"
psql: FATAL:  role "omerouser" does not exist
[omerouser@europa bin]$


it generate error messages.
how I can fix this error message ?

Thanks,
Steve Oh
toh2
 
Posts: 40
Joined: Tue Mar 01, 2011 6:59 pm

Re: omero library setting issue

Postby toh2 » Wed Apr 06, 2011 2:44 pm

oops.. Sorry I misstyped hash value "QdBhtcCVVuZomIa3ejRUSw".
But, it still generates same error. d

Steve Oh
toh2
 
Posts: 40
Joined: Tue Mar 01, 2011 6:59 pm

Re: omero library setting issue

Postby jmoore » Wed Apr 06, 2011 3:09 pm

Hi Steve,

The default version & patch are correct, OMERO4.2 and 0 respectively. You can just hit enter to both questions. As for the psql command, do you remember how you created your database? If so, what was the command you used?

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

Re: omero library setting issue

Postby toh2 » Wed Apr 06, 2011 5:29 pm

Hi Josh,

Thanks for your quick response.
I followed one of installation manual in the omero site (Omero Server Best 4.2.0 - installation on CentOS)

I executed as follows commands to create a database.
Code: Select all
sudo -u postgres createuser -P -D _R -S omero
sudo -u postgres createdb -O omero omero
sudo -u postgres createlang plpgsql omero


Thanks,
Steve Oh
toh2
 
Posts: 40
Joined: Tue Mar 01, 2011 6:59 pm

Re: omero library setting issue

Postby jmoore » Thu Apr 07, 2011 8:10 am

Ok, then the command you want is likely:
Code: Select all
psql -h localhost -U omero omero -c "UPDATE password SET hash = 'QdBhtcCVVuZomIa3ejRUSw==' WHERE experimenter_id = 0;"

After you run that the password for the OMERO user "root" will be set to "testomero", which you can use to login to OMERO.webadmin. From there, you can create an experimenter, etc.

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

Re: omero library setting issue

Postby toh2 » Thu Apr 07, 2011 2:58 pm

Thank you very much.
Finally, it works well.

I executed commands like as follows.
hopefully, it is useful for other folks.

Code: Select all
[omerouser@europa bin]$ ./omero web stop
Stopping OMERO.web... DEVELOPMENT: You will have to kill processes by hand!
[omerouser@europa bin]$ ./omero admin stop
Waiting on shutdown. Use CTRL-C to exit
.[omerouser@europa bin]$ ./omero db script
Please enter omero.db.version [OMERO4.2]:
Please enter omero.db.patch [0]:
Please enter password for OMERO root user:
Please re-enter password for OMERO root user:
Saving to /home/omerouser/omero/omero_dist/bin/OMERO4.2__0.sql
[omerouser@europa bin]$ ./omero db password
Please enter password for OMERO root user:
Please re-enter password for OMERO root user:
UPDATE password SET hash = 'QdBhtcCVVuZomIa3ejRUSw==' WHERE experimenter_id = 0;
[omerouser@europa bin]$ psql -h localhost -U omero omero -c "UPDATE password SET hash = 'QdBhtcCVVuZomIa3ejRUSw==' WHERE experimenter_id =0;"
UPDATE 1
[omerouser@europa bin]$ ./omero admin start
No descriptor given. Using etc/grid/default.xml
Waiting on startup. Use CTRL-C to exit
[omerouser@europa bin]$ ./omero web start
Starting OMERO.web... Validating models...
0 errors found

Django version 1.1.1, using settings 'omeroweb.settings'
Development server is running at http://0.0.0.0:9999/
Quit the server with CONTROL-C.


Thanks,
Steve Oh
toh2
 
Posts: 40
Joined: Tue Mar 01, 2011 6:59 pm

Re: omero library setting issue

Postby jmoore » Thu Apr 07, 2011 7:04 pm

Great to hear it, Steve. Enjoy!
~J.
User avatar
jmoore
Site Admin
 
Posts: 1591
Joined: Fri May 22, 2009 1:29 pm
Location: Germany

PreviousNext

Return to Installation and Deployment

Who is online

Users browsing this forum: No registered users and 1 guest

cron