You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@airflow.apache.org by GitBox <gi...@apache.org> on 2022/07/18 17:01:52 UTC

[GitHub] [airflow] uz-ext-r opened a new issue, #25129: Faulty DB setup during fresh install

uz-ext-r opened a new issue, #25129:
URL: https://github.com/apache/airflow/issues/25129

   ### Apache Airflow version
   
   2.3.3 (latest released)
   
   ### What happened
   
   Fresh install of 2.3.3 DB on both MySQL and PostgreSQL caused `Your user has no roles and/or permissions!` error on Web UI.
   
   
   ### What you think should happen instead
   
   Web UI should have been viewed as usual after login.
   
   ### How to reproduce
   
   Steps:
   1. Make a fresh install of the DB from scratch with version 2.3.3.
   2. Create a user with admin role from the CLI as usual.
   3. Try to login from the Webserver using the Admin account just created. 
   4. An error page will appear, that states; `Your user has no roles and/or permissions!` although the user is definitely assigned the Admin role which is verified by running  `airflow users list` clearly showing `Admin` under the `roles` column of the user.
   
   Additional info:
   * The command `airflow roles list` will only result in the role `Admin` being listed. Other roles `Op`, `Public`, `User`, `Viewer` won't appear.
    * Creating a user with a role other than `Admin` isn't possible as the other roles don't exist.
   * None of the issues above will occur on version 2.3.2. 
   
   Workaround:
   * Initialize DB with the version 2.3.2 and upgrade to 2.3.3.
   
   
   
   ### Operating System
   
   Docker image python:3.8.13-buster running on K8S
   
   ### Versions of Apache Airflow Providers
   
   apache-airflow-providers-google = "7.0.0"
   apache-airflow-providers-mysql = "^2.2.3"
   apache-airflow-providers-ssh = "^2.4.4"
   apache-airflow-providers-cncf-kubernetes = "4.0.2"
   apache-airflow-providers-amazon = "3.4.0"
   
   ### Deployment
   
   Other Docker-based deployment
   
   ### Deployment details
   
   Kubernetes Deployment.
   
   ### Anything else
   
   Only when doing a complete fresh install from 2.3.3
   
   ### Are you willing to submit PR?
   
   - [ ] Yes I am willing to submit a PR!
   
   ### Code of Conduct
   
   - [X] I agree to follow this project's [Code of Conduct](https://github.com/apache/airflow/blob/main/CODE_OF_CONDUCT.md)
   


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: commits-unsubscribe@airflow.apache.org.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org

[GitHub] [airflow] boring-cyborg[bot] commented on issue #25129: Faulty DB setup during fresh install

Posted by GitBox <gi...@apache.org>.
boring-cyborg[bot] commented on issue #25129:
URL: https://github.com/apache/airflow/issues/25129#issuecomment-1187769346

   Thanks for opening your first issue here! Be sure to follow the issue template!
   


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: commits-unsubscribe@airflow.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org

[GitHub] [airflow] potiuk closed issue #25129: Web UI not accessible / Faulty DB setup during fresh install

Posted by GitBox <gi...@apache.org>.
potiuk closed issue #25129: Web UI not accessible / Faulty DB setup during fresh install
URL: https://github.com/apache/airflow/issues/25129


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: commits-unsubscribe@airflow.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org