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/07/22 15:32:23 UTC
[GitHub] [incubator-superset] liuyuchuan opened a new issue #10396: superset Database on mysql Unexpected error name '_mysql' is not defined
liuyuchuan opened a new issue #10396:
URL: https://github.com/apache/incubator-superset/issues/10396
A clear and concise description of what the bug is.
i install superset on MacOS 10.15.5
when i want to add the DB source of mysql, i click the button of [Test Connection],they out the error message
```
ERROR: Unexpected error occurred, please check your logs for details
```
then i see the console out the error info
```
Unexpected error name '_mysql' is not defined
ERROR:superset.views.core:Unexpected error name '_mysql' is not defined
INFO:werkzeug:127.0.0.1 - - [22/Jul/2020 23:10:09] "POST /superset/testconn HTTP/1.1" 400 -
```
### Expected results
i don't know what to do, please tell me what to do.
### Actual results
#### Screenshots
#### How to reproduce the bug
1. when i running the cmd of start superset and visit the web http://localhost:8088/,
2. use the menu -- > Sources --> Databases, input something then Click on 'Test Connection'
3. Scroll down to '....'
4. See error
```
Unexpected error name '_mysql' is not defined
ERROR:superset.views.core:Unexpected error name '_mysql' is not defined
INFO:werkzeug:127.0.0.1 - - [22/Jul/2020 23:10:09] "POST /superset/testconn HTTP/1.1" 400 -
```
### Environment
(please complete the following information):
- superset version: `superset 0.36.0`
- python version: `Python 3.7.7`
- node.js version: `node v12.10.0`
- npm version: `npm v6.11.3`
-mysql version:`mysql 8.0.19`
-mysqlclient version:`mysqlclient 2.0.1`
-mysql-connector-python version:`mysql-connector-python 8.0.21`
### Checklist
Make sure these boxes are checked before submitting your issue - thank you!
- [ ] I have checked the superset logs for python stacktraces and included it here as text if there are any.
- [ ] I have reproduced the issue with at least the latest released version of superset.
- [ ] I have checked the issue tracker for the same issue and I haven't found one similar.
### Additional context
Add any other context about the problem here.
----------------------------------------------------------------
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] liuyuchuan commented on issue #10396: superset Database on mysql Unexpected error name '_mysql' is not defined
Posted by GitBox <gi...@apache.org>.
liuyuchuan commented on issue #10396:
URL: https://github.com/apache/incubator-superset/issues/10396#issuecomment-662835171
it's my post URI: Request URL: http://127.0.0.1:8088/superset/testconn
----------------------------------------------------------------
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] liuyuchuan commented on issue #10396: superset Database on mysql Unexpected error name '_mysql' is not defined
Posted by GitBox <gi...@apache.org>.
liuyuchuan commented on issue #10396:
URL: https://github.com/apache/incubator-superset/issues/10396#issuecomment-675383088
mth
----------------------------------------------------------------
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 #10396: superset Database on mysql Unexpected error name '_mysql' is not defined
Posted by GitBox <gi...@apache.org>.
dpgaspar commented on issue #10396:
URL: https://github.com/apache/incubator-superset/issues/10396#issuecomment-662916041
oh, I haven't made my self clear, I mean the SQLAlchemy URI. Or send the payload your sending for the HTTP POST on http://127.0.0.1:8088/superset/testconn
----------------------------------------------------------------
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] liuyuchuan edited a comment on issue #10396: superset Database on mysql Unexpected error name '_mysql' is not defined
Posted by GitBox <gi...@apache.org>.
liuyuchuan edited a comment on issue #10396:
URL: https://github.com/apache/incubator-superset/issues/10396#issuecomment-675217932
OMG!
The problem is solved after i installed the pymysql driver like this:
`pip install pymysql`
then i use the SQLAlchemy URI like this:
`mysql+pymysql://root:Root1234@127.0.0.1:3306/superset
`
----------------------------------------------------------------
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] liuyuchuan removed a comment on issue #10396: superset Database on mysql Unexpected error name '_mysql' is not defined
Posted by GitBox <gi...@apache.org>.
liuyuchuan removed a comment on issue #10396:
URL: https://github.com/apache/incubator-superset/issues/10396#issuecomment-675207679
i am sorry, i forget.
when i try use the SQLAlchemy URI
mysql://root:Root1234@localhost/superset
mysql+mysqldb://root:Root1234@localhost/superset
the question is same.
----------------------------------------------------------------
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] liuyuchuan commented on issue #10396: superset Database on mysql Unexpected error name '_mysql' is not defined
Posted by GitBox <gi...@apache.org>.
liuyuchuan commented on issue #10396:
URL: https://github.com/apache/incubator-superset/issues/10396#issuecomment-675217932
OMG!
The problem is solved after i installed the pysql driver like this:
`pip install pymysql`
then i use the SQLAlchemy URI like this:
`mysql+pymysql://root:Root1234@127.0.0.1:3306/superset
`
----------------------------------------------------------------
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] liuyuchuan closed issue #10396: superset Database on mysql Unexpected error name '_mysql' is not defined
Posted by GitBox <gi...@apache.org>.
liuyuchuan closed issue #10396:
URL: https://github.com/apache/incubator-superset/issues/10396
----------------------------------------------------------------
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] willbarrett commented on issue #10396: superset Database on mysql Unexpected error name '_mysql' is not defined
Posted by GitBox <gi...@apache.org>.
willbarrett commented on issue #10396:
URL: https://github.com/apache/incubator-superset/issues/10396#issuecomment-668607061
The same issue has now been reported in #10495
----------------------------------------------------------------
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] liuyuchuan edited a comment on issue #10396: superset Database on mysql Unexpected error name '_mysql' is not defined
Posted by GitBox <gi...@apache.org>.
liuyuchuan edited a comment on issue #10396:
URL: https://github.com/apache/incubator-superset/issues/10396#issuecomment-675217932
OMG!
The problem is solved after i installed the pymysql driver like this:
`pip install pymysql`
then i use the SQLAlchemy URI like this:
`mysql+pymysql://root:Root1234@127.0.0.1:3306/superset
`
and i use the uri like this is work too.
`mysql+mysqlconnector://root:Root1234@127.0.0.1:3306/superset
`
i want to know why i can't use the SQLAlchemy URI like this:
```
mysql+mysqldb://root:Root1234@127.0.0.1:3306/superset
or
mysql://root:Root1234@127.0.0.1:3306/superset
```
----------------------------------------------------------------
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 #10396: superset Database on mysql Unexpected error name '_mysql' is not defined
Posted by GitBox <gi...@apache.org>.
dpgaspar commented on issue #10396:
URL: https://github.com/apache/incubator-superset/issues/10396#issuecomment-662574496
Can you post the mysql URI you're using?
----------------------------------------------------------------
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 #10396: superset Database on mysql Unexpected error name '_mysql' is not defined
Posted by GitBox <gi...@apache.org>.
issue-label-bot[bot] commented on issue #10396:
URL: https://github.com/apache/incubator-superset/issues/10396#issuecomment-662522660
Issue-Label Bot is automatically applying the label `#bug` to this issue, with a confidence of 0.80. 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] liuyuchuan commented on issue #10396: superset Database on mysql Unexpected error name '_mysql' is not defined
Posted by GitBox <gi...@apache.org>.
liuyuchuan commented on issue #10396:
URL: https://github.com/apache/incubator-superset/issues/10396#issuecomment-675207679
i am sorry, i forget.
when i try use the SQLAlchemy URI
mysql://root:Root1234@localhost/superset
mysql+mysqldb://root:Root1234@localhost/superset
the question is same.
----------------------------------------------------------------
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] willbarrett commented on issue #10396: superset Database on mysql Unexpected error name '_mysql' is not defined
Posted by GitBox <gi...@apache.org>.
willbarrett commented on issue #10396:
URL: https://github.com/apache/incubator-superset/issues/10396#issuecomment-668123977
Please remember to remove your secrets before posting :)
----------------------------------------------------------------
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