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