Systems & Architecture / Services Health
🕐 --:-- --
⚡ System Uptime: 99.98%
🔄
TL
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