[GitHub] [superset] genzgd commented on issue #23065: Connect to Clickhouse Error

["genzgd (via GitHub)" <gi...@apache.org>]

genzgd commented on issue #23065:
URL: https://github.com/apache/superset/issues/23065#issuecomment-1432488487

   What port did you use in your SQLAlchemy URI?  ClickHouse Connect uses the ClickHouse HTTP interface, so if you are using the SQLAlchemy URL the port should normally be 8123 (for plain HTTP) or 8443 (for HTTPS).  I can reproduce your exact error if I use the wrong (native interface) port of 9440:
   
   ```
   clickhousedb://play:clickhouse@play.clickhouse.com:9440
   ```
   causes the "connection reset by peer error
   
   ```
   clickhousedb://play:clickhouse@play.clickhouse.com:443
   ```
   
   works correctly (play.clickhouse.com uses the standard HTTP port of 443 instead of 8443).
   
   Please try the HTTP (8123) or HTTPS (8443) port on your server.


-- 
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: notifications-unsubscribe@superset.apache.org

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