Operational
Node.js Express Engine
Port 3005 • Latency: 12ms
Connected
PostgreSQL Database Pool
Pool: 20 max • Fallback: MemoryStore ready
Active (IPv4)
Brevo Transactional SMTP
Delivery Rate: 99.4% • Email 2FA Ready
Listening
Paystack Payments Webhook
HMAC SHA512 Signature Checked
📡 Core Production Infrastructure & API Integrations (PRD Chapter 90)
| Service Name | Protocol / Target | Authentication Mode | Uptime Status | Last Successful Event |
|---|---|---|---|---|
|
Paystack Checkout & Webhooks
|
/api/v1/payments/paystack-webhook |
x-paystack-signature HMAC | Online & Active | Today (M-Pesa STK push verified) |
|
Brevo Email 2FA Engine
|
api.brevo.com/v3/smtp/email |
api-key (IPv4 Enforced) | Online (Zero Failures) | Just now (Staff OTP sent) |
|
Telegram Bot 2FA Dispatch
|
api.telegram.org/bot[TOKEN] |
Bot Token + Chat ID | Online (Dev Mock Active) | Master Admin 2FA alert sent |
|
PostgreSQL Adapter with Memory Fallback
|
db.js / schema.sql |
DATABASE_URL Connection Pool | Idempotent Sync Active | 28 tables verified & ready |
🛡️ Critical Zero Hard-Coding Compliance Audit (PRD Chapter 91)
100% Compliant
Strict policy check: Zero passwords, API keys, contact numbers, or secret tokens are hard-coded in source files. All values are driven by .env and PostgreSQL system_config.
| Config Area | Resolution Source | Variable / Key Name | Status |
|---|---|---|---|
| Paystack Secret & Public Keys | .env file |
PAYSTACK_SECRET_KEY, PAYSTACK_PUBLIC_KEY |
✓ Driven via Env |
| Brevo Transactional Email Key | .env file |
BREVO_API_KEY, BREVO_FROM_EMAIL |
✓ Driven via Env |
| Support Phone & WhatsApp Helpline | PostgreSQL system_config |
helpline_phone, whatsapp_number |
✓ Admin Editable in DB |
| Public Dropdown Options | PostgreSQL dropdown_options |
Universities, Campus Hubs, Support Tiers | ✓ Fully Managed in DB |
| Staff Credentials & Portals | PostgreSQL admins table |
scrypt password hashes, role RBAC enums | ✓ Zero Hard-Coded Credentials |
🔒 Active Sessions, Rate Limiting & Access Controls
Monitors active JWT tokens, OTP brute-force limits, and device authorization records across student and staff accounts.
| Scope | Active Sessions / Keys | Brute Force Protection | Session Expiry (TTL) | Emergency Action |
|---|---|---|---|---|
| Master Admin (madmin.sfbk.co.ke) | 1 Token Active | Telegram 2FA Enforced | 24 Hours | |
| Staff Unit Portals (13 Portals) | Multi-Role RBAC | 15-Min Email OTP Limit | 12 Hours | |
| Student Beneficiaries | Device Fingerprint Binding | 6-Digit Numerical OTP | 15 Minutes for OTP |
📜 Immutable System Security & Operational Audit Trail
Live Security Stream| Log ID | Event Action | Entity | Entity ID | Origin IP | Timestamp |
|---|---|---|---|---|---|
| #108 | STAFF_LOGIN_SUCCESS | staff | tech_lead | 127.0.0.1 |
Just now |
| #107 | DONATION_VERIFIED_SUCCESS | financial_donations | SFBK_173120194 |
197.232.84.12 |
12 mins ago |
| #106 | STUDENT_OTP_VERIFIED | students | SFBK-KE-28491 |
105.163.2.40 |
45 mins ago |
| #105 | FOOD_RESCUE_SUBMITTED | food_donations | DON-8491 |
41.90.112.5 |
1 hr ago |
🗄️ Relational Database Schema & Entities Verification (schema.sql)
Idempotent schema definitions: all 28 tables, columns, indexes, and safe migrations verified against schema.sql.
✓
students • Beneficiary profiles✓
assessments • Vulnerability scores✓
financial_donations • Paystack ledger✓
food_donations • Surplus rescue produce✓
food_safety_inspections • Safety log✓
admins • Staff accounts & 2FA✓
dropdown_options • Managed CMS lists✓
audit_logs • Immutable event trail