= Ethical Hacker : sesión 4
  * [[info:cursos:pue:ethical-hacker:sesion4]]

== clase
  * Modulo 14
  * Modulo 15
  * Modulo 16
  * Modulo 17

== Modulo 14: Hacking Web Applications
  * Amenazas
  * OWASP - [[https://owasp.org]]
    * asociación sin ánimo de lucro
    * proyectos relacionados con seguridad
    * Coraza - ModSecurity - set reglas programables
    * web security testint guide
  * Componentes de terceros con problemas: [[https://blog.elhacker.net/2022/06/herramienta-YODA-encuentra-miles-plugins-maliciosos-en-wordpress.html]]
  * Falta de monitorización
  * Ataques a aplicaciones web
    * ataque transversal directorio
    * https://certifiedhacker.com/<portales/
      * se pueden escanear, permitido
      * ejemplos de vulnerabildiades
    * manipulación campos ocultos (via POST/GET)
      * amazon: ''&pct-off=60-99'' - Truco para añadir a la URL de amazon para ver los productos con un descuento dado.
    * pass-the-cookie
      * robar cookies para logearse en una web
    * same-site
    * command injection
      * shell
      * html
      * file
    * LDAP injection
    * XSS en comentarios (tipo 2)
    * evasión filtros XSS
    * Timing attacks
      * direct timing: deducir por la respuesta si el usuario existe o no
      * cross-site timing: paquetes de solictud manipulados usando javascript
      * browser-based timing: estimar el tiempo que tarda el server en procesar para saber si es correcto o no
    * XXE
      * invocación desde XML a una petición de fichero/recurso externo
    * redirecciones / reenvios inválidos
    * Magecart (web skimming): componentes de terceros desactualizados
    * Watering Hole (abrevadero): espera de potenciales víctimas, emboscada
    * CSRF
    * Manipulación / envenenamiento de cookies
    * Deserialización insegura
    * Ataques a servicios web
      * apuntes Fernando:
        * **SOAP** (Simple Object Access Protocol) es un protocolo estándar que define cómo dos objetos en diferentes procesos pueden comunicarse entre si, preguntando a UDDI por su localización, y por medio de intercambio de datos XML (documentos WSDL).
          * https://txikiboo.wordpress.com/2013/11/11/relacion-soap-wsdl-uddi/ - Artículo sobre SOAP
        * **UDDI** son las siglas del catálogo de servicios denominado Universal Description, Discovery and Integration. UDDI se comunica intercambiando archivos WSDL. Un servidor (o proveedor del servicio) debe realizar el registro de su servicio en UDDI para que sea localizable.
        * **WSDL** (Web Services Description Language), es un formato (XML) que se utiliza para describir servicios web (WS).
    * XML Poisoning
    * DNS Rebinding
      * saltarse restricciones de seguridad
      * controlar DNS secundario, bajar TTL
      * primera petición legítima, la siguiente manipulada
    * ...
  * burpsuite: megaherramienta de seguridad (también vale para ZAP)
    * https://portswigger.net/burp - Descarga. Hay tres versiones:
      * Burp Suite Community Edition (gratis): https://portswigger.net/burp/communitydownload
      * Burp Suite Professional (349$ / año)
      * Burp Suite Enterprise Edition (a partir de 6000$ / año)
    * https://portswigger.net/web-security - Academy, formación gratuita, pero requiere cuenta.
    * https://portswigger.net/web-security/all-labs - Labs gratuitos, aunque requieren tener cuenta.
    * https://www.youtube.com/playlist?list=PL4TbrTdoQBY_dZQ9XI9NKwb5evvyfYQNQ - Un curso en video de Burp Suite, en español, que está bastante bien. Para novatos. Sacado de https://sniferl4bs.com/2020/06/curso-burp-suite-desde-0-presentaci%C3%B3n/
    * https://github.com/alphaSeclab/awesome-burp-suite/blob/master/Readme_en.md - Recopilación de recursos de Burp Suite

=== Lab 1 Module 14: Footprint the Web Infrastructure
==== Task 1: Perform Web Application Reconnaissance using Nmap and Telnet
  - Perform a Whois lookup to gather information about the IP address of the web server and the complete information about the domain such as its registration details, name servers, IP address, and location.
  - Use tools such as Netcraft (https://www.netcraft.com), SmartWhois (https://www.tamos.com), WHOIS Lookup (https://whois.domaintools.com), and Batch IP Converter (http://www.sabsoft.com) to perform the Whois lookup.
  - Perform DNS Interrogation to gather information about the DNS servers, DNS records, and types of servers used by the target organization. DNS zone data include DNS domain names, computer names, IP addresses, domain mail servers, service records, etc.
  - Use tools such as, DNSRecon (https://github.com), and Domain Dossier (https://centralops.net) to perform DNS interrogation.
  - In the Parrot Terminal window, run nmap -T4 -A -v [Target Web Application] command (here, the target web application is www.moviescope.com) to perform a port and service discovery scan.{{:info:cursos:pue:ethical-hacker:pasted:20250220-020649.png?500}}{{:info:cursos:pue:ethical-hacker:pasted:20250220-020712.png?500}}{{:info:cursos:pue:ethical-hacker:pasted:20250220-020728.png?500}}
  - In the terminal window, run command telnet www.moviescope.com 80 to establish a telnet connection with the target machine.{{:info:cursos:pue:ethical-hacker:pasted:20250220-020848.png?500}}{{:info:cursos:pue:ethical-hacker:pasted:20250220-020951.png?500}}

==== Task 2: Perform Web Spidering using OWASP ZAP
  - In the Terminal window, type zaproxy and press Enter to launch OWASP ZAP.
  - After completing initialization, a prompt that reads Do you want to persist the ZAP Session? appears; select the No, I do not want to persist this session at this moment in time radio button and click Start.{{:info:cursos:pue:ethical-hacker:pasted:20250220-021241.png?500}}
  - The Automated Scan wizard appears; enter the target website under the URL to attack field (here, www.moviescope.com). Leave the other settings to default and click the Attack button.{{:info:cursos:pue:ethical-hacker:pasted:20250220-021357.png?500}}
  - OWASP ZAP starts scanning the target website. You can observe various URLs under the Spider tab.{{:info:cursos:pue:ethical-hacker:pasted:20250220-021612.png?500}}
  - After performing web spidering, OWASP ZAP performs active scanning. Navigate to the Active Scan tab to observe the various scanned links.{{:info:cursos:pue:ethical-hacker:pasted:20250220-021644.png?500}}
  - After completing the active scan, the results appear under the Alerts tab, displaying the various vulnerabilities and issues associated with the target website, as shown in the screenshot.{{:info:cursos:pue:ethical-hacker:pasted:20250220-021744.png?500}}
  - Now, click on the Spider tab from the lower section of the window to view the web spidering information. By default, the URLs tab appears under the Spider tab.
  - The URLs tab contains various links for hidden content and functionality associated with the target website (www.moviescope.com).{{:info:cursos:pue:ethical-hacker:pasted:20250220-021906.png?500}}
  - Now, navigate to the Messages tab under the Spider tab to view more detailed information regarding the URLs obtained while performing the web spidering, as shown in the screenshot. In real-time, attackers perform web spidering or crawling to discover hidden content and functionality, which is not reachable from the main visible content, to exploit user privileges within the application. It also allows attackers to recover backup copies of live files, configuration and log files containing sensitive data, backup archives containing snapshots of files within the web root, and new functionality that is not linked to the main application.{{:info:cursos:pue:ethical-hacker:pasted:20250220-021958.png?500}}

==== Task 3: Perform Web Application Vulnerability Scanning using SmartScanner
  - SmartScanner window appears. In the enter site address to scan field, enter www.moviescope.com and click scan button.{{:info:cursos:pue:ethical-hacker:pasted:20250220-022053.png?500}}
  - The tool starts scanning the target website for vulnerabilities.{{:info:cursos:pue:ethical-hacker:pasted:20250220-022253.png?500}}
  - Once the tool completes scanning, it will display the issues that are found under Found Issues section and Severity of Issues.{{:info:cursos:pue:ethical-hacker:pasted:20250220-022315.png?500}}
  - Now, expand Password Sent Over HTTP and click on first http://www.moviescope.com link from the left pane to view the details of the vulnerability.{{:info:cursos:pue:ethical-hacker:pasted:20250220-022341.png?500}}
  - In the right pane, scroll down to the DESCRIPTION part. We can observe that this website contains a vulnerability, which could be exploited by attackers to intercept sensitive information like passwords during transmission over unencrypted HTTP traffic.{{:info:cursos:pue:ethical-hacker:pasted:20250220-022532.png?500}}
  - You can also go through the RECOMMENDATION section to check for the recommended actions to patch the vulnerability.
  - Now, under REFERENCES section, press Ctrl and click on CWE-319 hyperlink .
  - A CWE website appears in Microsoft Edge web browser, displaying the details of CWE-319 ClearText Transmission of Sensitive Information.
  - Similarly, click the http://www.moviescope.com link available under X-Frame-Options Header is Missing node which is termed as Low severity.{{:info:cursos:pue:ethical-hacker:pasted:20250220-022800.png?500}}
  - Scroll down to the DESCRIPTION here, we can observe that the X-Frame-Options Header is Missing which will make this site vulnerable to click-jacking.{{:info:cursos:pue:ethical-hacker:pasted:20250220-022850.png?500}}
  - Now, expand X-Content-Type-Options Header is Missing node and click on http://www.moviescope.com link to view its contents.
  - Under DESCRIPTION section we can observe that the browsers can perform MIME sniffing which can cause the browsers to transform non-executable content into executable content.{{:info:cursos:pue:ethical-hacker:pasted:20250220-023014.png?500}}
  - Similarly, you can view the the RECOMMENDATION section and click on the reference link under REFERENCES section.
  - You can also use other web application vulnerability scanning tools such as: 
    - WPScan Vulnerability Database (https://wpscan.com), 
    - Codename SCNR (https://ecsypno.com), 
    - AppSpider (https://www.rapid7.com), 
    - Uniscan (https://github.com), 
    - N-Stalker (https://www.nstalker.com).

=== Lab 2 Module 14: Perform Web Application Attacks
==== Task 1: Perform a Brute-force Attack using Burp Suite
  - In this task, the target WordPress website (http://10.10.1.22:8080/CEH) is hosted by the victim machine, Windows Server 2022. Here, the host machine is the Parrot Security machine.
  - Ensure that the Wampserver is running in Windows Server 2022 machine. To run the WampServer, execute the following steps:
    - Now, click Type here to search field on the Desktop, search for wampserver64 in the search bar and select Wampserver64 from the results.
    - Click the Show hidden icons icon, observe that the WampServer icon appears.
    - Wait for this icon to turn green, which indicates that the WampServer is successfully running.
  - Launch the Mozilla Firefox web browser and go to http://10.10.1.22:8080/CEH/wp-login.php?.{{:info:cursos:pue:ethical-hacker:pasted:20250220-023610.png?500}}
    - Here, we will perform a brute-force attack on the designated WordPress website hosted by the Windows Server 2022 machine.
  - Now, we shall set up a Burp Suite proxy by first configuring the proxy settings of the browser.In the Mozilla Firefox browser, click the Open application menu icon in the right corner of the menu bar and select Settings from the drop-down list. The General settings tab appears. In the Find in Settings search bar, search for proxy and in the Search Results, click the Settings button under the Network Settings option.{{:info:cursos:pue:ethical-hacker:pasted:20250220-023710.png?500}}
  - The Connection Settings window appears; select the Manual proxy configuration radio button and specify the HTTP Proxy as 127.0.0.1 and the Port as 8080. Tick the Also use this proxy for HTTPS checkbox and click OK. Close the Settings tab and minimize the browser window.{{:info:cursos:pue:ethical-hacker:pasted:20250220-024017.png?500}}
  - Now, minimize the browser window, click the Applications menu form the top left corner of Desktop, and navigate to Pentesting --> Web Application Analysis --> Web Application Proxies --> Burpsuite CE to launch the Burpsuite CE application.{{:info:cursos:pue:ethical-hacker:pasted:20250220-024157.png?500}}
    - In the next window, select the Use Burp defaults radio-button and click the Start Burp button.
  - The Burp Suite main window appears; click the Proxy tab from the available options in the top section of the window.{{:info:cursos:pue:ethical-hacker:pasted:20250220-024242.png?500}}
  - In the Proxy settings, by default, the Intercept tab opens-up. Observe that by default, the interception is active as the button says Intercept is on. Leave it running.{{:info:cursos:pue:ethical-hacker:pasted:20250220-024338.png?500}}
  - Switch back to the browser window. On the login page of the target WordPress website, type random credentials, here admin and password. Click the Log In button.
  - Switch back to the Burp Suite window; observe that the HTTP request was intercepted by the application.
  - Now, right-click anywhere on the HTTP request window, and from the context menu, click Send to Intruder.{{:info:cursos:pue:ethical-hacker:pasted:20250220-024851.png?500}}
  - Now, click on the Intruder tab from the toolbar and observe that under the Intruder tab, the Positions tab appears by default. In the Positions tab under the Intruder tab observe that Burp Suite sets the target positions by default, as shown in the HTTP request. Click the Clear § button from the right-pane to clear the default payload values. {{:info:cursos:pue:ethical-hacker:pasted:20250220-024928.png?500}}
  - Once you clear the default payload values, select Cluster bomb from the Attack type drop-down list. Cluster bomb uses multiple payload sets. There is a different payload set for each defined position (up to a maximum of 20). The attack iterates through each payload set in turn so that all permutations of payload combinations are tested. For example, if there are two payload positions, the attack will place the first payload from payload set 2 into position 2 and iterate through all payloads in payload set 1 in position 1; it will then place the second payload from payload set 2 into position 2 and iterate through all the payloads in payload set 1 in position 1. {{:info:cursos:pue:ethical-hacker:pasted:20250220-025703.png?500}}
  - Now, we will set the username and password as the payload values. To do so, select the username value entered in Step#14 and click Add § from the right-pane. Similarly, select the password value entered in Step#14 and click Add § from the right-pane.{{:info:cursos:pue:ethical-hacker:pasted:20250220-030501.png?500}}
  - Once the username and password payloads are added. The symbol ‘§’ will be added at the start and end of the selected payload values. Here, as the screenshot shows, the values are admin and password.{{:info:cursos:pue:ethical-hacker:pasted:20250220-030525.png?500}}
  - Navigate to the Payloads tab under the Intruder tab and ensure that under the Payload Sets section, the Payload set is selected as 1, and the Payload type is selected as Simple list. Under the Payload settings [Simple list] section, click the Load… button.
  - A file selection window appears; navigate to the location /home/attacker/Desktop/CEHv13 Module 14 Hacking Web Applications/Wordlist, select the username.txt file, and click the Open button.{{:info:cursos:pue:ethical-hacker:pasted:20250220-030614.png?500?500}}
  - Observe that the selected username.txt file content appears under the Payload settings [Simple list] section, as shown in the screenshot.{{:info:cursos:pue:ethical-hacker:pasted:20250220-030719.png?500}}
  - Similarly, load a password file for the payload set 2. To do so, under the Payload Sets section, select the Payload set as 2 from the drop-down options and ensure that the Payload type is selected as Simple list.{{:info:cursos:pue:ethical-hacker:pasted:20250220-030750.png?500}}
  - Observe that selected password.txt file content appears under the Payload settings [Simple list] section, as shown in the screenshot.{{:info:cursos:pue:ethical-hacker:pasted:20250220-030808.png?500}}
  - Once the wordlist files are selected as payload values, click the Start attack button to launch the attack.{{:info:cursos:pue:ethical-hacker:pasted:20250220-030821.png?500}}
  - The Intruder attack of 10.10.1.22 window appears as the brute-attack initializes. It displays various username-password combinations along with the Length of the response and the Status.{{:info:cursos:pue:ethical-hacker:pasted:20250220-030858.png?500}}
  - After the progress bar completes, scroll down and observe the different values of Status and Length. Here, Status=302 and Length= 1155.
  - In the Raw tab under the Request tab, the HTTP request with a set of the correct credentials is displayed. (here, username=admin and password=qwerty@123), as shown in the screenshot. Note down these user credentials.{{:info:cursos:pue:ethical-hacker:pasted:20250220-030938.png?500}}

==== Task 2: Perform Remote Code Execution (RCE) Attack
Remote Code Execution (RCE) Attack vulnerability is a critical security flaw that allows an attacker to execute arbitrary code on a target system remotely, without needing physical access to the system. This type of vulnerability is particularly dangerous because it enables attackers to take control of the target system, potentially gaining unauthorized access, stealing data, or causing damage to the system or network.

Attackers exploit these vulnerabilities by injecting malicious code into the target system through various means such as input fields, file uploads, or network protocols. Once the malicious code is executed, the attacker can gain control over the system and perform actions as if they were an authenticated user or system administrator.

Here, we will perform a CSRF attack using vulnerability present in the wp-upg plugin.

  - Click Type here to search field on the Desktop, search for wampserver64 in the search bar and select Wampserver64 from the results.
  - Wait for this icon to turn green, which indicates that the WampServer is successfully running.
  - Now, open any web browser, and go to http://10.10.1.22:8080/CEH/wp-login.php? (here, we are using Mozilla Firefox).
  - A WordPress webpage appears. Type Username or Email Address and Password as admin and qwerty@123. Click the Log In button.
  - Hover your mouse cursor on Plugins in the left pane and click Installed Plugins, as shown in the screenshot.{{:info:cursos:pue:ethical-hacker:pasted:20250220-031557.png}}{{:info:cursos:pue:ethical-hacker:pasted:20250220-031617.png?500}}
  - Open Mozilla Firefox web browser and go to https://wpscan.com/ and login to the wpscan account that you have created in previous task.
  - You get signed in successfully in the website. Now, click the Get Started button and click Start for free button under Researcher section.
  - The Edit Profile page appears; in the API Token section and observe the API Token. Note down or copy this API Token; we will use this token in the later steps.{{:info:cursos:pue:ethical-hacker:pasted:20250220-031726.png?500}}
  - In the Parrot Security machine, open a Terminal window and execute sudo su to run the programs as a root user (When prompted, enter the password toor).
  - In the Terminal window, run ''wpscan --url http://10.10.1.22:8080/CEH --api-token [API Token from Step#13]'' command.{{:info:cursos:pue:ethical-hacker:pasted:20250220-032133.png?500}}
  - The result appears, displaying detailed information regarding the target website.{{:info:cursos:pue:ethical-hacker:pasted:20250220-032152.png?500}}
  - Scroll down to the Plugin(s) Identified section, and observe the installed vulnerable plugins (wp-upg) on the target website.
  - In the Plugin(s) Identified section, within the context of the wp-upg plugin, an Unauthenticated Remote Code Execution (RCE) vulnerability has been detected as shown in the screenshot.{{:info:cursos:pue:ethical-hacker:pasted:20250220-032216.png?500}}
  - To perform RCE attack, run curl -i 'http://10.10.1.22:8080/CEH/wp-admin/admin-ajax.php?action=upg_datatable&field=field:exec:whoami:NULL:NULL' command.{{:info:cursos:pue:ethical-hacker:pasted:20250220-032439.png?500}}
  - This curl command exploits a WordPress plugin vulnerability by sending a malicious request to the admin-ajax.php file, allowing an attacker to execute arbitrary system commands via the exec function, potentially leading to remote code execution.

=== Lab 3: Detect Web Application Vulnerabilities using Various Web Application Security Tools
==== Task 1: Detect Web Application Vulnerabilities using Wapiti Web Application Security Scanner
  - In the terminal window run ''cd wapiti'' command to navigate into wapiti directory and run ''python3 -m venv wapiti3'' command to create virtual environment in python.{{:info:cursos:pue:ethical-hacker:pasted:20250220-032950.png?500}}
  - Now, run ''. wapiti3/bin/activate command to activate virtual environment.''{{:info:cursos:pue:ethical-hacker:pasted:20250220-033129.png?500}}
  - Run ''pip install .'' command to install wapiti web application security scanner.{{:info:cursos:pue:ethical-hacker:pasted:20250220-033155.png?500}}
  - After installing the tool run wapiti -u https://www.certifiedhacker.com command to perform web application security scanning on certifiedhacker.com website.{{:info:cursos:pue:ethical-hacker:pasted:20250220-033209.png?500}}
  - Now, in the terminal run cd /root/.wapiti/generated_report/ to navigate to generated_report directory.{{:info:cursos:pue:ethical-hacker:pasted:20250220-033220.png?500}}
  - Run ls command to view the contents of the directory. we can see that the certifiedhacker.com_xxxxxxxx_xxxx.html file is created.{{:info:cursos:pue:ethical-hacker:pasted:20250220-033230.png?500}}
  - Run cp certifiedhacker.com_xxxxxxxx_xxxx.html /home/attacker/ command to copy the .html file to /home/attacker location.{{:info:cursos:pue:ethical-hacker:pasted:20250220-033242.png?500}}
  - Open a new terminal and run firefox certifiedhacker.com_xxxxxxxx_xxxx.html command to open the .html file in Firefox browser.{{:info:cursos:pue:ethical-hacker:pasted:20250220-033250.png?500}}
  - Wapiti scan report opens upp in Firefox browser, you can analyze the scan result with the discovered vulnerabilities.{{:info:cursos:pue:ethical-hacker:pasted:20250220-033307.png?500}}
  - Scroll down to view the detailed information regarding each discovered vulnerability.{{:info:cursos:pue:ethical-hacker:pasted:20250220-033319.png?500}}

=== Lab 4: Perform Web Application Hacking using AI
==== Task 1: Perform Web Application Hacking using ShellGPT
== Module 15: SQL Injection
=== apuntes fernando
  * https://owasp.org/www-community/attacks/SQL_Injection - Recursos en Inglés
  * FUN:
    * https://es.xkcd.com/strips/exploits-de-una-madre/ - SQL Injection
    * https://xkcd.com/1253/ - Otro SQL Injection
    * https://computerhoy.com/noticias/life/pone-nombre-null-matricula-hacerse-invisible-cobran-12000-dolares-multas-defectuosas-473645 - Le pone a su matricula "NULL" y le caen decenas de multas pendientes de cobrar.
    * https://www.xataka.com/otros/internet-tu-nombre-puede-convertirse-tu-peor-pesadilla-1 - Jennifer Null
    * https://i.kinja-img.com/gawker-media/image/upload/s--UzcqSr8_--/c_fill,fl_progressive,g_center,h_900,q_80,w_1600/18mpenleoksq8jpg.jpg - SQL Injection
    * https://sqlpd.com/ - Para aprender SQL jugando
    * https://dvwa.co.uk/ - Damm Vulnerable web application <-- Aprenderás jugando
    * https://portswigger.net/web-security/sql-injection/union-attacks - Cómo detectar número de columnas en una query, para poder utilizar el operador UNION

=== extras
  * bash: usar ''--'' y comillas para crear ficheros que no deja (igual para borrar)<code bash>touch -- '*'
rm -- '*'</code>

=== sección 1
  * ''UNION'': mismo número de campos

=== sección 2
  * inband: hago y veo el resultado en la misma web
  * out-of-band: respuesta por otro cana
  * provocar errores para ver si es accesible via SQL injection o si los errores son descriptivos
  * usar ''UNION''
  * Blind/inferial
  * ''WAITFOR DELAY'': <code sql>if exists(select * from users) waitfor delay '00:00:10'</code>
  * Testing strings SQL Injection
    * Material de Alumnos: Modulo15_SQL_Injection_Cheat_Sheet.pdf
  * ''OPENROWSHEET''
  * ''LOAD_FILE()''
  * ''INTO OUTFILE()''
  * Herramientas
    * sqlmap
    * Mole
    * noSQLMap
  * Evasión
  * Contramedidas

=== Lab 1 Modulo 15: Perform SQL Injection Attacks
==== Task 1: Perform an SQL Injection Attack Against MSSQL to Extract Databases using sqlmap
sqlmap is an open-source penetration testing tool that automates the process of detecting and exploiting SQL injection flaws and taking over of database servers. It comes with a powerful detection engine, many niche features, and a broad range of switches—from database fingerprinting and data fetching from the database to accessing the underlying file system and executing commands on the OS via out-of-band connections.

You can use sqlmap to perform SQL injection on a target website using various techniques, including Boolean-based blind, time-based blind, error-based, UNION query-based, stacked queries, and out-of-band SQL injection.

In this task, we will use sqlmap to perform SQL injection attack against MSSQL to extract databases.

  - Navigate to http://www.moviescope.com/. A Login page loads; enter the Username and Password as sam and test, respectively.
  - Once you are logged into the website, click the View Profile tab on the menu bar and, when the page has loaded, make a note of the URL in the address bar of the browser.
  - Right-click anywhere on the webpage and click Inspect (Q) from the context menu, as shown in the screenshot.{{:info:cursos:pue:ethical-hacker:pasted:20250220-062410.png?500}}
  - The Developer Tools frame appears in the lower section of the browser window. Click the Console tab, type document.cookie in the lower-left corner of the browser, and press Enter.{{:info:cursos:pue:ethical-hacker:pasted:20250220-062429.png?500}}
  - Select the cookie value, then right-click and copy it, as shown in the screenshot. Minimize the web browser. Note down the URL of the web page.
  - As root, Run ''sqlmap -u "http://www.moviescope.com/viewprofile.aspx?id=1" %%--%%cookie="[cookie value that you copied in Step#7]" %%--%%dbs'' command.
    - In this query, -u specifies the target URL (the one you noted down in Step#7), --cookie specifies the HTTP cookie header value, and --dbs enumerates DBMS databases.
  - The above query causes sqlmap to enforce various injection techniques on the name parameter of the URL in an attempt to extract the database information of the MovieScope website.{{:info:cursos:pue:ethical-hacker:pasted:20250220-062545.png?500}}
  - If the message Do you want to skip test payloads specific for other DBMSes? [Y/n] appears, type Y and press Enter.
  - If the message for the remaining tests, do you want to include all tests for ‘Microsoft SQL Server’ extending provided level (1) and risk (1) values? [Y/n] appears, type Y and press Enter.{{:info:cursos:pue:ethical-hacker:pasted:20250220-062611.png?500}}
  - sqlmap retrieves the databases present in the MSSQL server. It also displays information about the web server OS, web application technology, and the backend DBMS, as shown in the screenshot.
  - Now, you need to choose a database and use sqlmap to retrieve the tables in the database. In this lab, we are going to determine the tables associated with the database moviescope.{{:info:cursos:pue:ethical-hacker:pasted:20250220-062654.png?500}}
  - Run ''sqlmap -u "http://www.moviescope.com/viewprofile.aspx?id=1" --cookie="[cookie value which you have copied in Step#7]" -D moviescope --tables'' command.
    - In this query, -D specifies the DBMS database to enumerate and --tables enumerates DBMS database tables.
  - sqlmap retrieves the table contents of the moviescope database and displays them, as shown in screenshot.{{:info:cursos:pue:ethical-hacker:pasted:20250220-062742.png?500}}
  - Now, you need to retrieve the table content of the column User_Login.
  - Run ''sqlmap -u "http://www.moviescope.com/viewprofile.aspx?id=1" --cookie="[cookie value which you have copied in Step#7]" -D moviescope -T User_Login --dump'' command to dump all the **User_Login** table content.
  - sqlmap retrieves the complete User_Login table data from the database moviescope, containing all users’ usernames under the Uname column and passwords under the password column, as shown in screenshot.
  - You will see that under the password column, the passwords are shown in plain text form.{{:info:cursos:pue:ethical-hacker:pasted:20250220-062836.png?500}}
  - Now, switch back to the Parrot Terminal window. Run ''sqlmap -u "http://www.moviescope.com/viewprofile.aspx?id=1" --cookie="[cookie value which you have copied in Step#7]" --os-shell''.{{:info:cursos:pue:ethical-hacker:pasted:20250220-062905.png?500}}
  - If the message do you want sqlmap to try to optimize value(s) for DBMS delay responses appears, type Y and press Enter to continue.{{:info:cursos:pue:ethical-hacker:pasted:20250220-062932.png?500}}
  - Once sqlmap acquires the permission to optimize the machine, it will provide you with the OS shell. Type hostname and press Enter to find the machine name where the site is running. If the message do you want to retrieve the command standard output? appears, type Y and press Enter.{{:info:cursos:pue:ethical-hacker:pasted:20250220-063001.png?500}}
  - sqlmap will retrieve the hostname of the machine on which the target web application is running, as shown in the screenshot.{{:info:cursos:pue:ethical-hacker:pasted:20250220-063019.png?500}}
  - Type **TASKLIST** and press Enter to view a list of tasks that are currently running on the target system.
  - If the message do you want to retrieve the command standard output? appears, type Y and press Enter. The above command retrieves the tasks and displays them under the command standard output section, as shown in the screenshots below.{{:info:cursos:pue:ethical-hacker:pasted:20250220-063054.png?500}}
  - To view the available commands under the OS shell, type help and press Enter.
  - You can also use other SQL injection tools such as:
    - Mole (https://sourceforge.net),
    - jSQL Injection (https://github.com),
    - NoSQLMap (https://github.com),
    - Havij (https://github.com) and 
    - blind_sql_bitshifting (https://github.com).

=== Lab 2 Modulo 15: Detect SQL Injection Vulnerabilities using Various SQL Injection Detection Tools
==== Task 1: Detect SQL Injection Vulnerabilities using OWASP ZAP
  - OWASP ZAP initialized and a prompt that reads Do you want to persist the ZAP Session? appears; select the No, I do not want to persist this session at this moment in time radio button, and click Start.{{:info:cursos:pue:ethical-hacker:pasted:20250220-064105.png?500}}
  - The OWASP ZAP main window appears; under the Quick Start tab, click the Automated Scan option.{{:info:cursos:pue:ethical-hacker:pasted:20250220-064143.png?500}}
  - The Automated Scan wizard appears, enter the target website in the URL to attack field (in this case, http://www.moviescope.com). Leave other options set to default, and then click the Attack button. OWASP ZAP starts performing Active Scan on the target website, as shown in the screenshot.{{:info:cursos:pue:ethical-hacker:pasted:20250220-064214.png?500}}
  - After the scan completes, Alerts tab appears. You can observe the vulnerabilities found on the website under the Alerts tab.{{:info:cursos:pue:ethical-hacker:pasted:20250220-064326.png?500}}
  - Now, expand the SQL Injection vulnerability node under the Alerts tab.{{:info:cursos:pue:ethical-hacker:pasted:20250220-064339.png?500}}
  - Click on the discovered SQL Injection vulnerability and further click on the vulnerable URL.
  - You can observe the information such as Risk, Confidence, Parameter, Attack, etc., regarding the discovered SQL Injection vulnerability in the lower right-bottom, as shown in the screenshot.
    - Red Flag: High risk
    - Orange Flag: Medium risk
    - Yellow Flag: Low risk
    - Blue Flag: Provides details about information disclosure vulnerabilities{{:info:cursos:pue:ethical-hacker:pasted:20250220-064414.png?500}}
  - Similarly, expand any other vulnerability (here, SQL Injection-MsSQL) node under the Alerts tab and further click on the vulnerable URLs.{{:info:cursos:pue:ethical-hacker:pasted:20250220-064431.png}}{{:info:cursos:pue:ethical-hacker:pasted:20250220-064438.png?500}}
  - You can also use other SQL injection detection tools such as:
    - Damn Small SQLi Scanner (DSSS) (https://github.com),
    - Snort (https://snort.org),
    - Burp Suite (https://www.portswigger.net),
    - HCL AppScan (https://www. hcl-software.com) etc. to detect SQL injection vulnerabilities.

=== Lab 3: Perform SQL Injection using AI
==== Task 1: Perform SQL Injection using ShellGPT
  -  enumerate the database of the target website to do so, switch to the terminal window and run ''sgpt --chat sql --shell “Use sqlmap on target url http://www.moviescope.com/viewprofile.aspx?id=1 with cookie value '[cookie value which you have copied in Step#3]' and enumerate the DBMS databases” '' command to scan the target website for SQL injection vulnerability and enumerate databases. {{:info:cursos:pue:ethical-hacker:pasted:20250220-064818.png?500}}{{:info:cursos:pue:ethical-hacker:pasted:20250220-064836.png?500}}{{:info:cursos:pue:ethical-hacker:pasted:20250220-064841.png?500}}
  - We have successfully enumerated the databases from the target website, we will now enumerate the tables pertaining to the database moviescope. To do so run ''sgpt --chat sql --shell “Use sqlmap on target url http://www.moviescope.com/viewprofile.aspx?id=1 with cookie value '[cookie value which you have copied in Step#3]' and enumerate the tables pertaining to moviescope database"'' command.{{:info:cursos:pue:ethical-hacker:pasted:20250220-064905.png?500}}{{:info:cursos:pue:ethical-hacker:pasted:20250220-064913.png?500}}
  - After enumerating the database tables we will dump the contents of the User_Login table to view the login information of the target website.
  - Run ''sgpt --chat sql --shell “Use sqlmap on target url http://www.moviescope.com/viewprofile.aspx?id=1 with cookie value '[cookie value which you have copied in Step#3]' and retrieve User_Login table contents from moviescope database"'' command.{{:info:cursos:pue:ethical-hacker:pasted:20250220-064938.png?500}}{{:info:cursos:pue:ethical-hacker:pasted:20250220-064943.png?500}}
  - Sqlmap retrieves the complete User_Login table data from the database moviescope, containing all users’ usernames under the Uname column and passwords under the password column, as shown in screenshot.


== Module 16: Hacking Wireless Networks
<code>
----------------------------------------------------------------------------------------------------------------
Generation     IEEE Standard       Maximum Linkrate
Wi-Fi 7     802.11be          46 Gbit/s  
Wi-Fi 6E    802.11ax          11 Gbit/s  Añade la banda de los 6GHz
Wi-Fi 6     802.11ax          11 Gbit/s  2,4GHz y 5GHz
Wi-Fi 5     802.11ac    680–6933 Mbit/s  2,4GHz y 5GHz
Wi-Fi 4     802.11n       72–600 Mbit/s  2,4GHz y 5GHz
Wi-Fi 3     802.11g         3–54 Mbit/s  2,4GHz
Wi-Fi 2     802.11b    1.5 to 54 Mbit/s  2,4GHz
Wi-Fi 1     802.11a      1 to 11 Mbit/s  3,7GHz y 5GHz
----------------------------------------------------------------------------------------------------------------
</code>
  * WIFI 802.11bf: detección de movimiento (incloso frecuencia respiratoria) - WLAN sensing
    * https://www.genbeta.com/actualidad/detectar-movimiento-e-incluso-nuestra-frecuencia-respiratoria-asi-funcionaran-routers-nuevo-estandar-wifi-802-11bf
  * Material Alumnos CEH (pCloud) -> ZAC_FRTG_2024 2.pdf
  * Algortimos:
    * RC4: algoritmo simétrico de tipo streaming
      * aún se usa en IoT, algoritmo rápido y poco consumo
    * <code>---------------------------------------------------------------------------------------------------------------------------
Tecn.      <-------- IV ---------->      Alg.      Longitud key     Int. Check Alg.      Key Management     Año  
WEP       RC4  24 bits   EAP  40/104 bits    CRC-32       No              1997
WPA       RC4  48 bits   TKIP    128 bits  MA & CRC-32    4way Handshake  1999
WPA2      AES  48 bits   CCMP    128 bits   CBC-MAC       4way Handshake  2004
WPA3  AES-256 1-64 bits  GCMP    192 bits  BIP-GMAC-256   ECDH and ECDSA  2018
---------------------------------------------------------------------------------------------------------------------------</code>
    * Todos crackeables, contraseña lo más larga
  * Ataques
    * Control de acceso
    * De integridad
    * de confidencialidad
    * Disponibilidad
    * Autenticación
    * KRACK -> WPA2
  * WPS -> PIN numérico
    * incibe, guía para securizar router
    * [[https://www.redeszone.net/tutoriales/redes-wifi/metodos-crackear-wps-routers-wifi/ ]]
    * [[https://www.redeszone.net/tutoriales/redes-wifi/wps-que-es-como-funciona/]]
  * [[https://www.incibe.es/sites/default/files/docs/guia_router/osi-guia-tu-router-tu-castillo.pdf]]
  * Modo promíscuo = modo monitor
    * no todas las tarjetas -> alpha wifi ASUS036ACH
    * ojo drivers OS
  * Suite aircrack-ng
    * poner tarjeta en modo monitor
    * ''airdump-ng''
  * aLTEr Attack - error de diseño de 4G, antena falsa
  * Contramedidas: VPN
  * Hasta telefonia 4G, antena multidireccional. Varias antenas para triangular
  * en 5G, unidireccional. Geolocalización con una sola antena, más precisión (hasta 50cm de margen)
  * móviles anuncian su MAC al detectar una WIFI -> seguimiento
    * los móviles ahora rotan la MAC para evitar el seguimiento
    * se puede forzar a usar la real (mirando en la WIFI)
    * [[https://computerhoy.com/noticias/moviles/papeleras-espia-rastrean-transeuntes-londres-5593]]
  * Sidewalk -> red WIFI de medio/largo alcance
    * red MESH
    * [[https://www.redeszone.net/reportajes/tecnologias/sidewalk-que-es-wifi-amazon-como-funciona/ ]]
    * Solo EEUU, no UE

=== Lab 1 Modulo 16: Perform Wireless Traffic Analysis
==== Task 1: Wi-Fi Packet Analysis using Wireshark
  - The **Wireshark** Network Analyzer window appears.
  - In the menu bar, click File and click Open option from the drop-down list.{{:info:cursos:pue:ethical-hacker:pasted:20250220-065504.png?500}}
  - Wireshark: Open Capture File window appears, navigate to E:\CEH-Tools\CEHv13 Module 16 Hacking Wireless Networks\Sample Captures, select WPA2crack-01.cap and click Open.{{:info:cursos:pue:ethical-hacker:pasted:20250220-065521.png?500}}
  - The WPA2crack-01.cap file opens in Wireshark window showing you the details of the packet for analysis. Here you can see the wireless packets captured which were otherwise masked to look like ethernet traffic.
  - Here 802.11 protocol indicates wireless packets.
  - You can access the saved packet capture file anytime, and by issuing packet filtering commands in the Filter field, you can narrow down the packet search in an attempt to find packets containing sensible information.
  - In real time, attackers enforce packet capture and packet filtering techniques to capture packets containing passwords (only for websites implemented on HTTP channel), perform attacks such as session hijacking, and so on. {{:info:cursos:pue:ethical-hacker:pasted:20250220-065857.png?500}}
  - You can also use other wireless traffic analyzers such as:
    - AirMagnet WiFi Analyzer PRO (https://www.netally.com), 
    - SteelCentral Packet Analyzer (https://www.riverbed.com), 
    - Omnipeek Network Protocol Analyzer (https://www.liveaction.com), 
    - and CommView for Wi-Fi (https://www.tamos.com) to analyze Wi-Fi traffic.

=== Lab 2: Perform Wireless Attacks
==== Task 1: Crack a WPA2 Network using Aircrack-ng
  - In the Parrot Terminal window, run ''aircrack-ng -a2 -b [Target BSSID] -w /home/attacker/Desktop/Wordlist/password.txt "/home/attacker/Desktop/Sample Captures/WPA2crack-01.cap"''. Here, the BSSID of the target is 22:7F:AC:6D:E6:8B.
    - -a is the technique used to crack the handshake, 2=WPA technique.
    - -b refers to bssid; replace with the BSSID of the target router.
    - -w stands for wordlist; provide the path to a wordlist.
  - {{:info:cursos:pue:ethical-hacker:pasted:20250220-070731.png?500}}
  - The result appears, showing the WPA handshake packet captured with airodump-ng. The target access point’s password is cracked and displayed in plain text next to the message KEY FOUND!, as shown in the screenshot.
    - If the password is complex, aircrack-ng will take a long time to crack it.
      - {{:info:cursos:pue:ethical-hacker:pasted:20250220-070809.png?500}}
    - You can also use other tools such as:
      - hashcat (https://hashcat.net), 
      - Portable Penetrator (https://www.secpoint.com), 
      - WepCrackGui (https://sourceforge.net) to crack WEP/WPA/WPA2 encryption.
== Module 17: Hacking Mobile Platforms
=== Lab 1
==== Task 1: Exploit the Android Platform through ADB using PhoneSploit-Pro
==== Task 2: Hack an Android Device by Creating APK File using AndroRAT
=== Lab 2
==== Task 1: Secure Android Devices from Malicious Apps using AVG