10 months ago
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?
0 Replies
10 months ago
you need to use port 443
10 months ago
this is an https service
10 months ago
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'.
10 months ago
bruh
10 months ago
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
10 months ago
please create your own thread
If anyone having same issue, try python clickhouse_connect
client = clickhouseconnect.getclient(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?
10 months ago
you are likely entering the wrong info when attempting to connect