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/05/03 01:16:06 UTC
[GitHub] [incubator-superset] chuang39 opened a new issue #9719: Clickhouse connection issue
chuang39 opened a new issue #9719:
URL: https://github.com/apache/incubator-superset/issues/9719
After "pip install superset-clickhouse", I couldn't add the clickhosue in superset as below.
<img width="782" alt="Screen Shot 2020-05-02 at 6 08 14 PM" src="https://user-images.githubusercontent.com/1077727/80896150-244e7900-8ca0-11ea-942c-938e5882bb59.png">
The port change can make effect. If I don't use 8123, it reports error since it is http connectin. However, no matter what I set for other fields like user, password. It will always gave error in server log as below.
`DEBUG:urllib3.connectionpool:Starting new HTTP connection (1): localhost:8123
DEBUG:urllib3.connectionpool:http://localhost:8123 "POST / HTTP/1.1" 401 None
Unexpected error Code: 194, e.displayText() = DB::Exception: Password required for user default (version 19.17.5.18 (official build))
ERROR:superset.views.core:Unexpected error Code: 194, e.displayText() = DB::Exception: Password required for user default (version 19.17.5.18 (official build))
INFO:werkzeug:127.0.0.1 - - [03/May/2020 01:08:00] "POST /superset/testconn HTTP/1.1" 400 -`
Any idea? Thanks!
#### Screenshots
If applicable, add screenshots to help explain your problem.
#### How to reproduce the bug
- Go to Sources -> Databases
- Click on '+' button
- fill Database and URI
- press Test Connection
### Environment
(please complete the following information):
- superset version:0.30.1 or 0.36.0 for apache-superset
- python version: `3.6.9`
- sqlalchemy-clickhouse version: 0.1.5.post0
### Checklist
Make sure these boxes are checked before submitting your issue - thank you!
- [X] I have checked the superset logs for python stacktraces and included it here as text if there are any.
- [X] I have reproduced the issue with at least the latest released version of superset.
- [X] 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] victorcheng2333 commented on issue #9719: Clickhouse connection issue
Posted by GitBox <gi...@apache.org>.
victorcheng2333 commented on issue #9719:
URL: https://github.com/apache/incubator-superset/issues/9719#issuecomment-696028307
> pip install infi.clickhouse_orm==1.0.4
Thanks , it also work to me
----------------------------------------------------------------
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] mdianjun commented on issue #9719: Clickhouse connection issue
Posted by GitBox <gi...@apache.org>.
mdianjun commented on issue #9719:
URL: https://github.com/apache/incubator-superset/issues/9719#issuecomment-656035134
I have another error:
----------------------------------------------------------------
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] rubenSastre commented on issue #9719: Clickhouse connection issue
Posted by GitBox <gi...@apache.org>.
rubenSastre commented on issue #9719:
URL: https://github.com/apache/incubator-superset/issues/9719#issuecomment-629182135
I have used, clickhouse-sqlalchemy instead of sqlalchemy-clickhouse, seems to have a recent version, but i am finding some diferent problems for it(missing first 2 rows of result).I am trying to find a solution also.
----------------------------------------------------------------
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] rogerlzp commented on issue #9719: Clickhouse connection issue
Posted by GitBox <gi...@apache.org>.
rogerlzp commented on issue #9719:
URL: https://github.com/apache/incubator-superset/issues/9719#issuecomment-734047388
cool, it works for me.
For local install, you can use the infi.clickhouse_orm-1.0.4-py2-none-any.whl file directly, if you are using python2;
However, you have to download infi.clickhouse_orm-1.0.4.tar.gz, and using "python3 setup.py install" command to install it when you are using Python3.
----------------------------------------------------------------
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] Sam--Shan commented on issue #9719: Clickhouse connection issue
Posted by GitBox <gi...@apache.org>.
Sam--Shan commented on issue #9719:
URL: https://github.com/apache/incubator-superset/issues/9719#issuecomment-630526691
I tried re install infi.clickhouse_orm and it works.
pip uninstall infi.clickhouse_orm
pip install infi.clickhouse_orm==1.0.4
----------------------------------------------------------------
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] victorcheng2333 commented on issue #9719: Clickhouse connection issue
Posted by GitBox <gi...@apache.org>.
victorcheng2333 commented on issue #9719:
URL: https://github.com/apache/incubator-superset/issues/9719#issuecomment-696028307
> pip install infi.clickhouse_orm==1.0.4
Thanks , it also work to me
----------------------------------------------------------------
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] junlincc closed issue #9719: Clickhouse connection issue
Posted by GitBox <gi...@apache.org>.
junlincc closed issue #9719:
URL: https://github.com/apache/incubator-superset/issues/9719
----------------------------------------------------------------
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] villebro commented on issue #9719: Clickhouse connection issue
Posted by GitBox <gi...@apache.org>.
villebro commented on issue #9719:
URL: https://github.com/apache/incubator-superset/issues/9719#issuecomment-690066831
I can take a look.
----------------------------------------------------------------
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] windylcx commented on issue #9719: Clickhouse connection issue
Posted by GitBox <gi...@apache.org>.
windylcx commented on issue #9719:
URL: https://github.com/apache/incubator-superset/issues/9719#issuecomment-705954772
> I tried re install infi.clickhouse_orm and it works.
> pip uninstall infi.clickhouse_orm
> pip install infi.clickhouse_orm==1.0.4
work for me ,thx.
----------------------------------------------------------------
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] dubin555 commented on issue #9719: Clickhouse connection issue
Posted by GitBox <gi...@apache.org>.
dubin555 commented on issue #9719:
URL: https://github.com/apache/incubator-superset/issues/9719#issuecomment-690055316
same issue, can someone take a look?
----------------------------------------------------------------
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] windylcx commented on issue #9719: Clickhouse connection issue
Posted by GitBox <gi...@apache.org>.
windylcx commented on issue #9719:
URL: https://github.com/apache/incubator-superset/issues/9719#issuecomment-705954772
> I tried re install infi.clickhouse_orm and it works.
> pip uninstall infi.clickhouse_orm
> pip install infi.clickhouse_orm==1.0.4
work for me ,thx.
----------------------------------------------------------------
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] Sam--Shan commented on issue #9719: Clickhouse connection issue
Posted by GitBox <gi...@apache.org>.
Sam--Shan commented on issue #9719:
URL: https://github.com/apache/incubator-superset/issues/9719#issuecomment-630022816
@rubenSastre @chuang39 hi,did you find any solution.i came across the issue,too,but different message:
INFO:werkzeug:218.4.91.131 - - [18/May/2020 08:05:46] "POST /superset/testconn HTTP/1.1" 400 -
DEBUG:urllib3.connectionpool:Starting new HTTP connection (1): 42.159.158.64:8123
DEBUG:urllib3.connectionpool:http://42.159.158.64:8123 "POST / HTTP/1.1" 500 None
Unexpected error Code: 516, e.displayText() = DB::Exception: default: Authentication failed: password is incorrect or there is no user with such name (version 20.4.1.2909)
ERROR:superset.views.core:Unexpected error Code: 516, e.displayText() = DB::Exception: default: Authentication failed: password is incorrect or there is no user with such name (version 20.4.1.2909)
----------------------------------------------------------------
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] stale[bot] commented on issue #9719: Clickhouse connection issue
Posted by GitBox <gi...@apache.org>.
stale[bot] commented on issue #9719:
URL: https://github.com/apache/incubator-superset/issues/9719#issuecomment-688229590
This issue has been automatically marked as stale because it has not had recent activity. It will be closed if no further activity occurs. Thank you for your contributions. For admin, please label this issue `.pinned` to prevent stale bot from closing the issue.
----------------------------------------------------------------
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