Accessing Clickhouse SQL Console?

I’m trying to work with the new Metrics backend together with Prometheus scrapers (and OTel Ingest)

But I’d like to access the SQL Console for troubleshooting reasons as its somewhat cumbersome to use custom graphs.

The (german) docs shows a screenshot of the console but no way to access it. Tried port 26788 but didn’t work..

The port is bound to localhost. So, use the -L option of SSH to forward it to your local machine:

ssh -L 26788:localhost:26788 someuser@mycmkserver

Please note that the port is generated from the site name and thus changes between setups.

1 Like

Thanks. I was thinking perhaps there would be some proxy going on in Apache just like a regular site.

I was looking at the conf files as well do bind to the host, but saw some settings for user permissions was bond to localhost so didn’t want to change any of that.

I did try curl first but it was not working

curl -vv http://localhost:26788                                                                                                                                                                                               

11:33:57.908609 [0-0] * Host localhost:26788 was resolved.                                                                                                                                                                                 

11:33:57.908661 [0-0] * IPv6: ::1                                                                                                                                                                                                          

11:33:57.908687 [0-0] * IPv4: 127.0.0.1                                                                                                                                                                                                    

11:33:57.908711 [0-0] * [SETUP] added                                                                                                                                                                                                      

11:33:57.908754 [0-0] *   Trying [::1]:26788...                                                                                                                                                                                            

11:33:57.908869 [0-0] * Connected to localhost (::1) port 26788                                                                                                                                                                            

11:33:57.908893 [0-0] * using HTTP/1.x                                                                                                                                                                                                     

11:33:57.908940 [0-0] > GET / HTTP/1.1                                                                                                                                                                                                     

11:33:57.908940 [0-0] > Host: localhost:26788                                                                                                                                                                                              

11:33:57.908940 [0-0] > User-Agent: curl/8.12.1                                                                                                                                                                                            

11:33:57.908940 [0-0] > Accept: */*                                                                                                                                                                                                        

11:33:57.908940 [0-0] >                                                                                                                                                                                                                    

11:33:57.909076 [0-0] * Request completely sent off                                                                                                                                                                                        

11:33:57.909360 [0-0] * Recv failure: Connection reset by peer                                                                                                                                                                             

11:33:57.909384 [0-0] * closing connection #0                                                                                                                                                                                              

11:33:57.909404 [0-0] * [SETUP] close                                                                                                                                                                                                      

11:33:57.909443 [0-0] * [SETUP] destroy