Live data from Hacker News

Inside PostHog: SSRF, ClickHouse SQL Escape and Default Postgres Creds to RCE

mdisec.com

21–30 of 38 posts

Re: Inside PostHog: SSRF, ClickHouse SQL Escape and Default Postgres Creds to RCE

#21

Wow, chapeau to the author. What an elegant, interesting read. What I don't quite understand: Why is the Clickhouse bug not given more scrutiny? Like that escape bug was what made the RCE possible and certainly a core DB company like ClickHouse should be held accountable for such an oversight?

The ClickHouse bug was fixed here: https://github.com/ClickHouse/ClickHouse/pull/74144

Re: Inside PostHog: SSRF, ClickHouse SQL Escape and Default Postgres Creds to RCE

#22
post #9

Earlier quoted context omitted.

Just because AI tools are involved doesn't mean it's "Vibe coding".

What does it mean?

The preferred definition of "vibe coding" is when you have AI generate code that you use without reviewing it first: https://simonwillison.net/2025/Mar/19/vibe-coding/

Unfortunately a lot of people think it means any time an LLM helps write code, but I think we're winning that semantic battle - I'm seeing more examples of it used correctly than incorrectly these days.

It's likely that the majority of code will be AI assisted in some way in the future, at which point calling all of it "vibe coding" will lose any value at all. That's why I prefer the definition that specifies unreviewed.

Re: Inside PostHog: SSRF, ClickHouse SQL Escape and Default Postgres Creds to RCE

#23
post #22

Earlier quoted context omitted.

What does it mean?

The preferred definition of "vibe coding" is when you have AI generate code that you use without reviewing it first: https://simonwillison.net/2025/Mar/19/vibe-coding/ Unfortunately a lot of people think it means any time an LLM helps write code, but I think we're winning that semantic battle - I'm seeing more examples of it used correctly than incorrectly these days. It's likely that the majority of code will be AI…

I also hope that majority of the code in the future is AI assisted like it is with PostHog because my cyber security firm is going to make so much money.

Re: Inside PostHog: SSRF, ClickHouse SQL Escape and Default Postgres Creds to RCE

#24
post #22

Earlier quoted context omitted.

What does it mean?

The preferred definition of "vibe coding" is when you have AI generate code that you use without reviewing it first: https://simonwillison.net/2025/Mar/19/vibe-coding/ Unfortunately a lot of people think it means any time an LLM helps write code, but I think we're winning that semantic battle - I'm seeing more examples of it used correctly than incorrectly these days. It's likely that the majority of code will be AI…

I share your preference. (I also mourn the loss of the word "vibe" for other contexts.) In this case there were apparently hundreds of commit messages stating "generated by Claude Code". I feel like there's a missing set of descriptors -- something similar to Creative Commons with its now-familiar labels like "CC-BY-SA" -- that could be used to indicate the relative degree of human involvement. Full-on "AI-YOLO-Paperclips" at one extreme could be distinguished from "AI-IDE-TA" for typeahead / fancy autocomplete at the other. Simon, you're in a fantastic position to champion some kind of basic system like this. If you run w/ this idea, please give me a shout-out. :)

Re: Inside PostHog: SSRF, ClickHouse SQL Escape and Default Postgres Creds to RCE

#25
post #9
post #7

Earlier quoted context omitted.

looking at their commits, there are about 300+ commits tagged with " Generated with https://claude.com/claude-code " attribution.

Just because AI tools are involved doesn't mean it's "Vibe coding".

If you leave "Generated with claude-code" in the commit message, It was vibe coded.

Re: Inside PostHog: SSRF, ClickHouse SQL Escape and Default Postgres Creds to RCE

#26
Need an edit here

> As it described on Clickhouse documentation, their API is designed to be READ ONLY on any operation for HTTP GET As described in the Clickhouse documentation, their API is designed to be READ ONLY on any operation for HTTP GET requests.

Re: Inside PostHog: SSRF, ClickHouse SQL Escape and Default Postgres Creds to RCE

#28
post #8

Out of interest, how much does ZDI pay for a bug like this?

They probably don't accept something like this. Not that many Posthog self-hosted instances out there...

That's what I thought too, but the article says it was submitted to ZDI and they handled the communication with Posthog

Re: Inside PostHog: SSRF, ClickHouse SQL Escape and Default Postgres Creds to RCE

#29

Does this require authenticated access to the posthog api to kick off? In that case I feel clickhouse and posthog both have their share of the blame here.

It looks like the entire class of bugs here are "if you have access to Posthog's admin dashboard, you can configure webhook URLs that hit Posthog's internal services". That's not particularly surprising for a self-hosted system like the author's, but I expect it would pretty bad if you were using their cloud-hosted product.

Ah of couse! I forgot about the cloud hosted option.
Post reply on HN