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 <g...@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-boun...@lists.galaxyproject.org] on behalf
> of Rui Wang [ruiwang...@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...@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
>>
>
___________________________________________________________
Please keep all replies on the list by using "reply all"
in your mail client. To manage your subscriptions to this
and other Galaxy lists, please use the interface at:
https://lists.galaxyproject.org/
To search Galaxy mailing lists use the unified search at:
http://galaxyproject.org/search/
