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: [email protected]

For queries about this service, please contact Infrastructure at:
[email protected]

Reply via email to