Remember that when trying to bypass logins with SQL injection, it’s a good idea to use
limit 1 to ensure that the code gets back the expected number of results!
In MySQL, you can use
concat() to return values from multiple columns in a single output field. Since
concat() accepts hexadecimal values for ASCII characters, we can use
:) to make field separation obvious.
Sometimes you can chain queries as part of SQL injection. This isn’t useful for retrieving input, but if the database is badly secured you can use this to modify the backend database (obviously requires the application to be using the same user/permissions for both reads and writes). Use the
sleep() function to test if this vulnerability impacts the system you’re attacking.
It’s really hard to get a reverse shell in PostgrSQL. But MySQL and MariaDB are more exploitable.
You can “upload” reverse shells using MySQL using
'<?php system($_GET["cmd"]); ?>' INTO OUTFILE '/var/www/html/cmd.php' (the path may require some brute-forcing or additional reconnaissance; sometimes you can force an error to return a potentially writeable path). This can then be leveraged into a reverse shell.
CloudWatch is primarily about log monitoring - metrics are extracted from logs, which can be watched by alarms that trigger certain actions (like sending messages to SNS) when triggered.
CloudWatch can ingest data from on-prem systems, in addition to services/system in AWS.
CloudTrail is AWS’s (API) logging engine.
Logs are stored in S3.
Events are logged with 15 minutes.
CloudTrail has its own alarm/automation system, called “CloudTrail Insights”.
You might thing of CloudTrail as being more concerned about account activity, and CloudWatch as being more focused on service/resource performance.
This seems to be a more general version of AWS Inspector - Trusted Advisor is more about your entire AWS account, while AWS Inspector is geared more towards individual systems.
Trusted Advisor can detect S3 buckets with open access permissions. (It’s starting to sound a bit like Scout Suite.)