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 2021/04/19 05:52:26 UTC
[GitHub] [superset] Michaelsky0913 opened a new issue #14229: Couldn't add clickhouse databases
Michaelsky0913 opened a new issue #14229:
URL: https://github.com/apache/superset/issues/14229
A clear and concise description of what the bug is.
I try to add clickhouse database, but I got an error: DB::Exception: default: Authentication failed: password is incorrect or there is no user with such name (version 21.3.4.25 (official build))
I think the result it's not true, because I try to use a linux shell command to connect my clickhouse database, it succeed! The command is ```curl 192.168.13.251:8123 -udefault:123qwe```. Look the picture:
### Expected results
what you expected to happen.
Successfully add clickhouse database
### Actual results
what actually happens.
I got an error: DB::Exception: default: Authentication failed: password is incorrect or there is no user with such name (version 21.3.4.25 (official build))
But I think the result it's not true.
#### Screenshots
If applicable, add screenshots to help explain your problem.
#### How to reproduce the bug
1. Go to fronted page
2. Click on "Data -> Databases -> +DATABASE"
3. Type DATABASE NAME: clickhouse, and SQLALCHEMY URI: clickhouse://default:123qwe@192.168.13.251:8123/dbtest
4. See error
### Environment
(please complete the following information):
- superset version: `superset version`
0.999.0dev
- python version: `python --version`
Python 3.7.9
- node.js version: `node -v`
### Checklist
Make sure to follow these steps 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.
I builded the docker image with docker-compose use the latest branch.
--
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] [superset] Michaelsky0913 commented on issue #14229: Couldn't add clickhouse databases
Posted by GitBox <gi...@apache.org>.
Michaelsky0913 commented on issue #14229:
URL: https://github.com/apache/superset/issues/14229#issuecomment-822203820
sorry, I use a wrong linux command to test, the correct is:
```
echo 'SELECT 1' | curl 'http://localhost:8123/' -udefault:123qwe --data-binary @-
```
--
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] [superset] Michaelsky0913 commented on issue #14229: Couldn't add clickhouse databases
Posted by GitBox <gi...@apache.org>.
Michaelsky0913 commented on issue #14229:
URL: https://github.com/apache/superset/issues/14229#issuecomment-822198835
If I don't set password for user default, everything is ok. otherwise, the superset could not add clickhouse database.
--
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] [superset] Michaelsky0913 removed a comment on issue #14229: Couldn't add clickhouse databases
Posted by GitBox <gi...@apache.org>.
Michaelsky0913 removed a comment on issue #14229:
URL: https://github.com/apache/superset/issues/14229#issuecomment-822203820
sorry, I use a wrong linux command to test, the correct is:
```
echo 'SELECT 1' | curl 'http://localhost:8123/' -udefault:123qwe --data-binary @-
```
--
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] [superset] Michaelsky0913 closed issue #14229: Couldn't add clickhouse databases
Posted by GitBox <gi...@apache.org>.
Michaelsky0913 closed issue #14229:
URL: https://github.com/apache/superset/issues/14229
--
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] [superset] HeinzMayer commented on issue #14229: Couldn't add clickhouse databases
Posted by GitBox <gi...@apache.org>.
HeinzMayer commented on issue #14229:
URL: https://github.com/apache/superset/issues/14229#issuecomment-823034732
The driver "sqlalchemy-clickhouse" doesn't work if the default user has a password
Workaraound
install "pip install infi.clickhouse_orm==1.0.4"
I recommend to use the driver "clickhouse-sqlalchemy"
--
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] [superset] jcalhinho commented on issue #14229: Couldn't add clickhouse databases
Posted by GitBox <gi...@apache.org>.
jcalhinho commented on issue #14229:
URL: https://github.com/apache/superset/issues/14229#issuecomment-823074401
try to go in sqlalchemy_clickhouse/connector.py
in line 104, try to comment "database._send = _send" and restart 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] [superset] Michaelsky0913 commented on issue #14229: Couldn't add clickhouse databases
Posted by GitBox <gi...@apache.org>.
Michaelsky0913 commented on issue #14229:
URL: https://github.com/apache/superset/issues/14229#issuecomment-823162270
--
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