Re: [galaxy-dev] can't create user on a new instance

12 Oct 2018

      Hi Qiang,

I looked at the postgres, here is the ownership info:

bioinfoadmin=> \l
                                     List of databases
     Name     |    Owner     | Encoding |   Collate   |    Ctype    |
 Access privileges
--------------+--------------+----------+-------------+-------------+-----------------------
 bioinfoadmin | bioinfoadmin | UTF8     | en_US.UTF-8 | en_US.UTF-8 |
 citation     | bioinfoadmin | UTF8     | en_US.UTF-8 | en_US.UTF-8 |
 postgres     | postgres     | UTF8     | en_US.UTF-8 | en_US.UTF-8 |
 template0    | postgres     | UTF8     | en_US.UTF-8 | en_US.UTF-8 |
=c/postgres          +
              |              |          |             |             |
postgres=CTc/postgres
 template1    | postgres     | UTF8     | en_US.UTF-8 | en_US.UTF-8 |
=c/postgres          +
              |              |          |             |             |
postgres=CTc/postgres
(5 rows)

Does this look okay to you? the db bioinfoadmin is the one that is set in
the galaxy config, and it's owned by
the user bioinfoadmin which is used to start galaxy.

Thanks,
Rui

On Wed, Oct 10, 2018 at 10:12 PM Qiang Gu <guq@ohsu.edu> wrote:
...
Hi Rui,
Does the default database sqlite work for you? I guess there is certain
mis-configuration in your
postgresql settings or certain element in the config/galaxy.yml file is
broken. Try to enter your postgresql database in terminal using the same
login info and create a table to make sure you have proper privileges.
Alternatively, using GalaxyKickStart (
https://github.com/ARTbio/GalaxyKickStart) to deploy a server
isn't that difficult and a postgresql database comes with it by default.
Good luck!
Thanks,
-Qiang
------------------------------
*From:* galaxy-dev [galaxy-dev-bounces@lists.galaxyproject.org] on behalf
of Rui Wang [ruiwang.sz@gmail.com]
*Sent:* Wednesday, October 10, 2018 9:30 PM
*To:* galaxy-dev@lists.galaxyproject.org
*Subject:* Re: [galaxy-dev] can't create user on a new instance
Hi Folks,
I still could not create new user account with the same error message. Has
anyone happened to see this before?
Cheers,
Rui
On Tue, Oct 9, 2018 at 5:48 PM Rui Wang <ruiwang.sz@gmail.com> wrote:
...
Hey Folks,
I just installed a new 18.05 instance with a new postgresql db created.
However, the UI doesn't allow me to create any user. After I provided all
input information, it says
galaxy.web.framework.webapp WARNING 2018-10-09 17:28:35,735
[p:32925,w:1,m:0] [uWSGIWorker1Core2] Wrong session token found, denying
request
in the server log. Btw, I enabled 'allow to create user' and admin user
list is empty.
I looked into it, and it's a function in
lib/galaxy/web/framework/webapp.py:
def check_csrf_token(self):
        session_csrf_token =
self.request.params.get("session_csrf_token", None)
        problem = False
        if not session_csrf_token:
            log.warning("No session_csrf_token set, denying request.")
            problem = True
        elif session_csrf_token != self.session_csrf_token:
            log.warning("Wrong session token found, denying request.")
            problem = True
if problem:
            return self.show_warn_message("Failed to authorize action.")
Could someone give me a hand? :-)
Cheers,
Rui