Support direct clickhouse connection if possible

[jeffling]

Is your feature request related to a problem? Please describe. I'd like to use this directly from a python script or from a BI tool like hex

Describe the solution you'd like I'd like some documentation on a connection string to allow for connections

Describe alternatives you've considered Hacking the API used by the repo :)

[gingerwizard]

I think we can provide this. Assessing implications and will update README if no blockers.

[gingerwizard]

clickhouse client --host crypto-clickhouse.clickhouse.com --secure --user crypto --password ''

@jeffling

[keydexofficial]

clickhouse client --host crypto-clickhouse.clickhouse.com --secure --user crypto --password ''

@jeffling

when try connect to, but do not success, bro got this error. "Code: 210. DB::NetException: SSL connection unexpectedly closed" has allowed remote connect other than localhost? which port?

[gingerwizard]

Add —secure

On Sun, 11 Aug 2024 at 02:47, keydexofficial @.***> wrote:

clickhouse client --host crypto-clickhouse.clickhouse.com --secure --user crypto --password ''

@jeffling https://github.com/jeffling

when try connect to, but do not success, bro got this error. "Code: 210. DB::NetException: SSL connection unexpectedly closed" has allowed remote connect other than localhost? which port?

— Reply to this email directly, view it on GitHub https://github.com/ClickHouse/CryptoHouse/issues/2#issuecomment-2282346005, or unsubscribe https://github.com/notifications/unsubscribe-auth/ADA3R5FYMXSSXBUE7SGLUTTZQ27DNAVCNFSM6AAAAABMFVXJPSVHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMZDEOBSGM2DMMBQGU . You are receiving this because you were assigned.Message ID: @.***>

[keydexofficial]

Add —secure … On Sun, 11 Aug 2024 at 02:47, keydexofficial @.> wrote: clickhouse client --host crypto-clickhouse.clickhouse.com --secure --user crypto --password '' @jeffling https://github.com/jeffling when try connect to, but do not success, bro got this error. "Code: 210. DB::NetException: SSL connection unexpectedly closed" has allowed remote connect other than localhost? which port? — Reply to this email directly, view it on GitHub <#2 (comment)>, or unsubscribe https://github.com/notifications/unsubscribe-auth/ADA3R5FYMXSSXBUE7SGLUTTZQ27DNAVCNFSM6AAAAABMFVXJPSVHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMZDEOBSGM2DMMBQGU . You are receiving this because you were assigned.Message ID: @.>

already added --secure, but still got same error: "Code: 210. DB::NetException: SSL connection unexpectedly closed"

clickhouse-client --host crypto-clickhouse.clickhouse.com --secure --user crypto --password ''

[gingerwizard]

port 9440 should be open.

clickhouse client --host crypto-clickhouse.clickhouse.com --secure --user crypto --password ''
ClickHouse client version 24.6.1.1865 (official build).
Connecting to crypto-clickhouse.clickhouse.com:9440 as user crypto.
Connected to ClickHouse server version 24.5.1.

[keydexofficial]

clickhouse-client --host crypto-clickhouse.clickhouse.com --secure --user crypto --password '' clickhouse-client --host crypto-clickhouse.clickhouse.com --secure --user crypto --password '' ClickHouse client version 18.16.1. Connecting to crypto-clickhouse.clickhouse.com:9440 as user crypto. Code: 210. DB::NetException: SSL connection unexpectedly closed (crypto-clickhouse.clickhouse.com:9440, 35.186.193.237)

hit from https://clickhouse.com/docs/en/faq/troubleshooting, "Check the IP Access List, if you are attempting to connect from outside the allowed list then your connection will fail."

has you open access for external ip visit?

[gingerwizard]

Yes it’s open. Try https from the browser and confirm.

On Mon, 12 Aug 2024 at 09:29, keydexofficial @.***> wrote:

clickhouse-client --host crypto-clickhouse.clickhouse.com --secure --user crypto --password '' clickhouse-client --host crypto-clickhouse.clickhouse.com --secure --user crypto --password '' ClickHouse client version 18.16.1. Connecting to crypto-clickhouse.clickhouse.com:9440 as user crypto. Code: 210. DB::NetException: SSL connection unexpectedly closed ( crypto-clickhouse.clickhouse.com:9440, 35.186.193.237)

hit from https://clickhouse.com/docs/en/faq/troubleshooting, "Check the IP Access List https://clickhouse.com/docs/en/cloud/security/setting-ip-filters, if you are attempting to connect from outside the allowed list then your connection will fail."

has you open access for external ip visit?

— Reply to this email directly, view it on GitHub https://github.com/ClickHouse/CryptoHouse/issues/2#issuecomment-2283381375, or unsubscribe https://github.com/notifications/unsubscribe-auth/ADA3R5HXSKJCP5YMPSFI3LDZRBW47AVCNFSM6AAAAABMFVXJPSVHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMZDEOBTGM4DCMZXGU . You are receiving this because you were assigned.Message ID: @.***>

[gingerwizard]

https://crypto-clickhouse.clickhouse.com/

should be accessible.

wi1qn9wnij.us-central1.gcp.clickhouse.cloud is the cloud host name.

[gingerwizard]

@keydexofficial your client is 6 years out of date. Likely your SSL version is not compatible. Upgrade.

[jeffling]

@gingerwizard can we add a mention of direct connection string to the README and/or ui and we can close this out?

[gingerwizard]

documented in the readme. closing.