Clickhouse connect timeout

mrxz44HOBBY

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

mrxz44HOBBY

10 months ago

project ID a042c04e-919a-4fa1-bd9c-a4a325b895fd


mrxz44HOBBY

10 months ago

1263960484244230100


10 months ago

you need to use port 443


10 months ago

this is an https service


mrxz44HOBBY

10 months ago

Tried 443 port, but its 'connection reset' error now


10 months ago

do you have a PORT variable set to 8123?


mrxz44HOBBY

10 months ago

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


mrxz44HOBBY

10 months ago

Ok I have PORT variable set to 8123 now. connecting via 443 port - Connection reset error


iamrony777TRIAL

10 months ago

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


mrxz44HOBBY

10 months ago

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)


mrxz44HOBBY

10 months ago

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