Clickhouse connect timeout
Trying to connect to my freshly deployed clickhouse but no success. I use public HTTP address as host address and username/password from 'variables' of CH instance but it doesn't let me in. Using datagrip and dbeaver to connect. Am I doing something wrong?
13 Replies
Project ID:
a042c04e-919a-4fa1-bd9c-a4a325b895fdproject ID a042c04e-919a-4fa1-bd9c-a4a325b895fd
you need to use port 443
this is an https service
Tried 443 port, but its 'connection reset' error now
do you have a PORT variable set to 8123?
Changed port variable to 443 and redeployed now. Having new error 'Unexpected end of file from server'.
bruh
8123
Ok I have PORT variable set to 8123 now. connecting via 443 port - Connection reset error
I have a similar problem while connecting to a redis database. Tried public and private url both, still can't connect to the db. It was working fine yesterday
edit: Internal only
please create your own thread
If anyone having same issue, try python clickhouse_connect
client = clickhouse_connect.get_client(host=creds['host'], username=creds['user'], password=creds['password'], port = 443, secure=True)Hey @Brody anyway is there a solution to establish connection via dbeaver or datagrip?
you are likely entering the wrong info when attempting to connect