You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@superset.apache.org by GitBox <gi...@apache.org> on 2020/06/04 12:07:58 UTC
[GitHub] [incubator-superset] sedhha opened a new issue #9984: ERROR:flask_appbuilder.security.sqla.manager:Error adding new user to database.
sedhha opened a new issue #9984:
URL: https://github.com/apache/incubator-superset/issues/9984
I am using gcloud oauth2.0 to access it and store it in new database. But I am getting this weird error:
> ERROR:flask_appbuilder.security.sqla.manager:Error adding new user to
> database. (sqlite3.IntegrityError) UNIQUE constraint failed:
> ab_user.email
Some more log details:
> [SQL: INSERT INTO ab_user (first_name, last_name, username, password,
> active, email, last_login, login_count, fail_login_count, created_on,
> changed_on, created_by_fk, changed_by_fk) VALUES (?, ?, ?, ?, ?, ?, ?,
> ?, ?, ?, ?, ?, ?)] [parameters: ('Shivam', 'Sahil',
> 'some secret string',
> 'another secret string',
> 1, 'myemail@gmail.com', None, None, None, '2020-06-04
> 11:45:01.756574', '2020-06-04 11:45:01.756582', None, None)]
> (Background on this error at: http://sqlalche.me/e/gkpj)
ERROR:flask_appbuilder.security.manager:Error creating a new OAuth user google_<<Some Secret Code>>
As the error says *UNIQUE constraint failed*, initially I thought my account is pre-registered and since I am trying to re-register it that's why I am getting this error, but here's the deal, when I tried to login using oauth authentication, this is what I am getting:
> ERROR:flask_appbuilder.security.sqla.manager:Error adding new user to
> database. (sqlite3.IntegrityError) UNIQUE constraint failed:
> ab_user.email [SQL: INSERT INTO ab_user (first_name, last_name,
> username, password, active, email, last_login, login_count,
> fail_login_count, created_on, changed_on, created_by_fk,
> changed_by_fk) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)]
> [parameters: ('Shivam', 'Sahil', 'google_<Some secret numeric>',
> '<sha_key_details>',
> 1, 'myemail@gmail.com', None, None, None, '2020-06-04
> 11:57:19.778402', '2020-06-04 11:57:19.778409', None, None)]
> (Background on this error at: http://sqlalche.me/e/gkpj)
> ERROR:flask_appbuilder.security.manager:Error creating a new OAuth
> user google_101008928508605739475
I see both of them as the same error, has anyone done any research on this before? Any idea what's going wrong here? I have checked the authentication part well and google authentication page responds correctly on registration or wrong information feed. But even though it gets all the response this error shows up. Any help is highly appreciated!
----------------------------------------------------------------
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.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org
[GitHub] [incubator-superset] sedhha edited a comment on issue #9984: ERROR:flask_appbuilder.security.sqla.manager:Error adding new user to database.
Posted by GitBox <gi...@apache.org>.
sedhha edited a comment on issue #9984:
URL: https://github.com/apache/incubator-superset/issues/9984#issuecomment-639261081
Hi @dpgaspar,
Sorted the issue, Had a very silly problem, was trying to oauth register with an email which I already registered in the database using database authentication.
Sorry for the inconvenience caused and thank you very much for the help.
----------------------------------------------------------------
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.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org
[GitHub] [incubator-superset] dpgaspar commented on issue #9984: ERROR:flask_appbuilder.security.sqla.manager:Error adding new user to database.
Posted by GitBox <gi...@apache.org>.
dpgaspar commented on issue #9984:
URL: https://github.com/apache/incubator-superset/issues/9984#issuecomment-638884332
Seems like you already have a user with the same email: myemail@gmail.com
This is.a FAB specific question do you mind opening an issue there?
----------------------------------------------------------------
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.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org
[GitHub] [incubator-superset] issue-label-bot[bot] commented on issue #9984: ERROR:flask_appbuilder.security.sqla.manager:Error adding new user to database.
Posted by GitBox <gi...@apache.org>.
issue-label-bot[bot] commented on issue #9984:
URL: https://github.com/apache/incubator-superset/issues/9984#issuecomment-638807037
Issue-Label Bot is automatically applying the label `#question` to this issue, with a confidence of 0.64. Please mark this comment with :thumbsup: or :thumbsdown: to give our bot feedback!
Links: [app homepage](https://github.com/marketplace/issue-label-bot), [dashboard](https://mlbot.net/data/apache/incubator-superset) and [code](https://github.com/hamelsmu/MLapp) for this bot.
----------------------------------------------------------------
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.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org
[GitHub] [incubator-superset] sedhha commented on issue #9984: ERROR:flask_appbuilder.security.sqla.manager:Error adding new user to database.
Posted by GitBox <gi...@apache.org>.
sedhha commented on issue #9984:
URL: https://github.com/apache/incubator-superset/issues/9984#issuecomment-638808622
> Issue-Label Bot is automatically applying the label `#question` to this issue, with a confidence of 0.64. Please mark this comment with 👍 or 👎 to give our bot feedback!
>
> Links: [app homepage](https://github.com/marketplace/issue-label-bot), [dashboard](https://mlbot.net/data/apache/incubator-superset) and [code](https://github.com/hamelsmu/MLapp) for this bot.
👍
----------------------------------------------------------------
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.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org
[GitHub] [incubator-superset] sedhha commented on issue #9984: ERROR:flask_appbuilder.security.sqla.manager:Error adding new user to database.
Posted by GitBox <gi...@apache.org>.
sedhha commented on issue #9984:
URL: https://github.com/apache/incubator-superset/issues/9984#issuecomment-639261081
Hi @dpgaspar even though if it's the existing user I am unable to login as well with the existing user. :-/
----------------------------------------------------------------
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.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org
[GitHub] [incubator-superset] sedhha closed issue #9984: ERROR:flask_appbuilder.security.sqla.manager:Error adding new user to database.
Posted by GitBox <gi...@apache.org>.
sedhha closed issue #9984:
URL: https://github.com/apache/incubator-superset/issues/9984
----------------------------------------------------------------
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.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org