Clickhouse connect timeout

mrxz44
HOBBY

a year 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

mrxz44
HOBBY

a year ago

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


mrxz44
HOBBY

a year ago

1263960484244230100


a year ago

you need to use port 443


a year ago

this is an https service


mrxz44
HOBBY

a year ago

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


a year ago

do you have a PORT variable set to 8123?


mrxz44
HOBBY

a year ago

Changed port variable to 443 and redeployed now. Having new error 'Unexpected end of file from server'.


a year ago

bruh


a year ago

8123


mrxz44
HOBBY

a year ago

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


iamrony777
TRIAL

a year 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


a year ago

please create your own thread


mrxz44
HOBBY

a year 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)


mrxz44
HOBBY

a year ago

Hey @Brody anyway is there a solution to establish connection via dbeaver or datagrip?


a year ago

you are likely entering the wrong info when attempting to connect


Clickhouse connect timeout - Railway Help Station