# Critical Secrets Found — MySQL Deep Search
# Date: 2026-09-24

## /etc/hosts — INTERNAL DOMAINS
```
13.250.197.171 all.apodoc.id all
13.250.197.171 prog2.pharmanet.id prog2
```
- apodoc.id = prog2 (internal domain)
- DNS not externally resolvable

## /etc/resolv.conf
```
search ap-southeast-1.compute.internal pharmanet.id
nameserver 172.30.0.2
```
- AWS VPC DNS: 172.30.0.2
- Search domains: ap-southeast-1.compute.internal, pharmanet.id

## E-COMMERCE API KEYS (ecommerce_data)
### Shopee (32 records)
- APIKey, PartnerID, ShopID for 32 shops
- Example: ShopID=252313100, APIKey=bec4b0da11dd...
- Some APIKeys base64 encoded
- Path: /home/filindo/shopee/jsonData/

### Lazada (2 records)
- appkey=102142, secretkey=ux6myyw4BIPjXkwqJaCQusK0VLHxsgfQ
- appkey=104831, secretkey=4tR8TZrKyUnRWJfKNB7GpPLrHOcyx37X
- tokens=50000601725i1JjqbrSc7GcRCmRyDlivH4msS19abe650kc4GqrExS2ulbPFm8KJ

## CUSTOMER DATA (apps_master.customer)
- 50 customers with MD5 password hashes
- Phones: 085780497909, 081280389367, 081575388806
- Common hash: bcafccbe76eaf3bb9c3d8b8df912ab3f (multiple customers)
- Hash e10adc3949ba59abbe56e057f20f883e = MD5("123456")

## FCM TOKENS (apps_master.m_device)
- Firebase Cloud Messaging tokens for push notifications
- Can intercept push notifications
- Format: APA91b... (Google FCM)

## CREDENTIAL TABLES DUMPED
- ecommerce_data.data_api (32 Shopee API keys)
- ecommerce_data.data_api_lazada (2 Lazada keys)
- ecommerce_data.token_shopee_v2 (2 Shopee tokens)
- apps_master.customer (50 customers with MD5 hashes)
- apps_master.m_ecommerce_akunpelapak (34 seller accounts)
- apps_master.m_device (50 FCM tokens)
- apps_master.m_cus_device (7 device records)
- apps_master_history.history_m_device (50 historical tokens)
- apps_survey.m_user (3 users, passwords=1,2,3)
- apps_transformation.user (6 users, password=123456)
- delphi_crawling.m_user (2 users, password=Hai12345!)
- CenturyMaster.M_Token (0 rows)
- absensi.karyawan (4 employees)

## TOTAL DATABASES: 30
## TOTAL TABLES: ~2000+
## TOTAL ROWS: ~32M+

### Largest databases:
- ecommerce: 19.6M rows
- sayasehat3: 4.1M rows  
- sayasehat: 3.07M rows
- ecommerce_data: 3.2M rows
- apps_master_history: 2.8M rows
- u8182940_wpni213: 1.6M rows (WordPress)
- test: 2.9M rows
- century_emember: 352K rows
- pharmanet_ai: 761K rows
- apps_transaction: 819K rows