Environment Setup Checklist: E-Commerce Checkout System¶
Project: ShopFlow E-Commerce Platform - Checkout Module Enhancement
Version: 1.0
Prepared By: DevOps Team & QA Infrastructure
Date: 2024-01-22
Environment: QA Testing Environment
Status: Ready for Testing
Overview¶
This checklist provides comprehensive steps to set up and validate the QA test environment for the ShopFlow Checkout Module Enhancement project. The environment replicates production configuration to ensure accurate testing results.
Environment Purpose: System testing, integration testing, and UAT for checkout functionality
Target Completion: January 29, 2024
Table of Contents¶
- Hardware Infrastructure
- Software Installation
- Application Deployment
- Database Setup
- Network Configuration
- Third-Party Integrations
- Test Data Preparation
- Security Configuration
- Monitoring and Logging
- Test Tool Configuration
- Environment Validation
- Access and Credentials
1. Hardware Infrastructure¶
1.1 Application Servers¶
| Component | Status | Details | Validated By | Date |
|---|---|---|---|---|
| ☑ App Server 1 (Primary) | ✅ Complete | VM: qa-app-01 CPU: 8 cores RAM: 32GB Disk: 500GB SSD OS: Ubuntu 20.04 LTS | John Smith | 2024-01-22 |
| ☑ App Server 2 (Secondary) | ✅ Complete | VM: qa-app-02 CPU: 8 cores RAM: 32GB Disk: 500GB SSD OS: Ubuntu 20.04 LTS | John Smith | 2024-01-22 |
| ☑ Load Balancer | ✅ Complete | VM: qa-lb-01 CPU: 4 cores RAM: 16GB Software: HAProxy 2.6 | John Smith | 2024-01-22 |
Configuration Details: - IP Addresses: - qa-app-01: 10.50.10.101 - qa-app-02: 10.50.10.102 - qa-lb-01: 10.50.10.100 (VIP: 10.50.10.200)
- Resource Allocation:
- CPU Allocation: Dedicated cores, no oversubscription
- Memory: Non-swappable, 4GB reserved for OS
- Storage: RAID 10 configuration
1.2 Database Servers¶
| Component | Status | Details | Validated By | Date |
|---|---|---|---|---|
| ☑ Database Primary | ✅ Complete | VM: qa-db-01 CPU: 16 cores RAM: 64GB Disk: 1TB SSD PostgreSQL 14.5 | Maria Garcia | 2024-01-22 |
| ☑ Database Replica (Read) | ✅ Complete | VM: qa-db-02 CPU: 8 cores RAM: 32GB Disk: 1TB SSD PostgreSQL 14.5 | Maria Garcia | 2024-01-22 |
Configuration Details: - IP Addresses: - qa-db-01 (Primary): 10.50.10.111 - qa-db-02 (Replica): 10.50.10.112
- Replication:
- Type: Streaming replication (asynchronous)
- Lag Target: <5 seconds
1.3 Cache and Message Queue¶
| Component | Status | Details | Validated By | Date |
|---|---|---|---|---|
| ☑ Redis Cache | ✅ Complete | VM: qa-cache-01 CPU: 4 cores RAM: 16GB Redis 7.0.5 | James Wilson | 2024-01-22 |
| ☑ RabbitMQ | ✅ Complete | VM: qa-mq-01 CPU: 4 cores RAM: 8GB RabbitMQ 3.11.5 | James Wilson | 2024-01-22 |
1.4 Test Client Machines¶
| Component | Status | Details | Validated By | Date |
|---|---|---|---|---|
| ☑ Windows Workstation 1 | ✅ Complete | Physical: QA-WIN-01 Windows 11 Pro 8GB RAM, 256GB SSD | Lisa Patel | 2024-01-23 |
| ☑ Windows Workstation 2 | ✅ Complete | Physical: QA-WIN-02 Windows 10 Pro 8GB RAM, 256GB SSD | David Kim | 2024-01-23 |
| ☑ Mac Workstation | ✅ Complete | Physical: QA-MAC-01 macOS Ventura 13.5 16GB RAM, 512GB SSD | Emily Rodriguez | 2024-01-23 |
| ☑ Mobile Devices | ✅ Complete | - iPhone 13 (iOS 16.6) - iPhone 14 (iOS 17.2) - Samsung Galaxy S21 (Android 13) - Samsung Galaxy S22 (Android 13) - iPad Air 5th Gen (iOS 16.6) | Lisa Patel | 2024-01-23 |
2. Software Installation¶
2.1 Operating System and Base Software¶
| Component | Status | Version | Server | Validated By | Date |
|---|---|---|---|---|---|
| ☑ Ubuntu Server | ✅ Complete | 20.04.5 LTS | qa-app-01, qa-app-02 | John Smith | 2024-01-22 |
| ☑ System Updates | ✅ Complete | Latest patches | All servers | John Smith | 2024-01-22 |
| ☑ Security Hardening | ✅ Complete | CIS Benchmark | All servers | Security Team | 2024-01-22 |
| ☑ NTP Configuration | ✅ Complete | Chrony 3.5 | All servers | John Smith | 2024-01-22 |
| ☑ SSH Configuration | ✅ Complete | Key-based auth | All servers | Security Team | 2024-01-22 |
2.2 Runtime Environments¶
| Component | Status | Version | Server | Installation Path | Validated By | Date |
|---|---|---|---|---|---|---|
| ☑ Node.js | ✅ Complete | 18.19.0 LTS | qa-app-01, qa-app-02 | /usr/local/bin/node | James Wilson | 2024-01-22 |
| ☑ npm | ✅ Complete | 10.2.3 | qa-app-01, qa-app-02 | /usr/local/bin/npm | James Wilson | 2024-01-22 |
| ☑ PM2 Process Manager | ✅ Complete | 5.3.0 | qa-app-01, qa-app-02 | Global | James Wilson | 2024-01-22 |
Verification Commands:
node --version # Expected: v18.19.0
npm --version # Expected: 10.2.3
pm2 --version # Expected: 5.3.0
2.3 Database Software¶
| Component | Status | Version | Server | Validated By | Date |
|---|---|---|---|---|---|
| ☑ PostgreSQL | ✅ Complete | 14.5 | qa-db-01, qa-db-02 | Maria Garcia | 2024-01-22 |
| ☑ PostgreSQL Extensions | ✅ Complete | uuid-ossp, pg_trgm, pgcrypto | qa-db-01 | Maria Garcia | 2024-01-22 |
| ☑ Database Backup Tools | ✅ Complete | pg_dump, pg_restore | qa-db-01 | Maria Garcia | 2024-01-22 |
2.4 Cache and Message Queue Software¶
| Component | Status | Version | Server | Validated By | Date |
|---|---|---|---|---|---|
| ☑ Redis Server | ✅ Complete | 7.0.5 | qa-cache-01 | James Wilson | 2024-01-22 |
| ☑ RabbitMQ Server | ✅ Complete | 3.11.5 | qa-mq-01 | James Wilson | 2024-01-22 |
| ☑ RabbitMQ Management Plugin | ✅ Complete | Enabled | qa-mq-01 | James Wilson | 2024-01-22 |
2.5 Web Browsers (Test Clients)¶
| Browser | Status | Version | Workstation | Validated By | Date |
|---|---|---|---|---|---|
| ☑ Chrome | ✅ Complete | 120.0.6099.129 | All Windows/Mac | Lisa Patel | 2024-01-23 |
| ☑ Firefox | ✅ Complete | 121.0 | All Windows/Mac | Lisa Patel | 2024-01-23 |
| ☑ Edge | ✅ Complete | 120.0.2210.91 | Windows only | David Kim | 2024-01-23 |
| ☑ Safari | ✅ Complete | 17.2 | Mac only | Emily Rodriguez | 2024-01-23 |
3. Application Deployment¶
3.1 Source Code and Build¶
| Task | Status | Details | Validated By | Date |
|---|---|---|---|---|
| ☑ Clone Repository | ✅ Complete | Branch: release/3.5.0 Commit: abc123def456 | James Wilson | 2024-01-23 |
| ☑ Install Dependencies | ✅ Complete | npm ci executed successfully | James Wilson | 2024-01-23 |
| ☑ Build Frontend | ✅ Complete | React production build Output: /dist folder | James Wilson | 2024-01-23 |
| ☑ Build Backend | ✅ Complete | TypeScript compilation Output: /build folder | James Wilson | 2024-01-23 |
Build Artifacts: - Frontend Build: /opt/shopflow/frontend/dist/ - Backend Build: /opt/shopflow/backend/build/ - Version File: /opt/shopflow/VERSION (contains: 3.5.0-RC1)
3.2 Application Configuration¶
| Configuration File | Status | Location | Owner | Date |
|---|---|---|---|---|
| ☑ Backend Config (QA) | ✅ Complete | /opt/shopflow/backend/config/qa.json | James Wilson | 2024-01-23 |
| ☑ Frontend Config (QA) | ✅ Complete | /opt/shopflow/frontend/.env.qa | James Wilson | 2024-01-23 |
| ☑ Logging Config | ✅ Complete | /opt/shopflow/backend/config/winston.config.js | James Wilson | 2024-01-23 |
| ☑ PM2 Ecosystem File | ✅ Complete | /opt/shopflow/ecosystem.config.js | James Wilson | 2024-01-23 |
Key Configuration Parameters:
Backend Config (qa.json):
{
"env": "qa",
"port": 3000,
"database": {
"host": "10.50.10.111",
"port": 5432,
"database": "shopflow_qa",
"pool": {"min": 5, "max": 20}
},
"redis": {
"host": "10.50.10.121",
"port": 6379,
"ttl": 3600
},
"session": {
"secret": "[REDACTED]",
"timeout": 900000
},
"payment": {
"paypal_mode": "sandbox",
"stripe_mode": "test"
}
}
Frontend Config (.env.qa):
REACT_APP_API_URL=https://qa-api.shopflow.example.com
REACT_APP_ENV=qa
REACT_APP_GOOGLE_PAY_MERCHANT_ID=[TEST_MERCHANT_ID]
REACT_APP_APPLE_PAY_MERCHANT_ID=[TEST_MERCHANT_ID]
3.3 Application Services¶
| Service | Status | Port | Auto-Start | Health Check URL | Validated By | Date |
|---|---|---|---|---|---|---|
| ☑ Backend API | ✅ Running | 3000 | Yes | http://localhost:3000/health | James Wilson | 2024-01-23 |
| ☑ Frontend (Nginx) | ✅ Running | 80, 443 | Yes | https://qa.shopflow.example.com | James Wilson | 2024-01-23 |
| ☑ Background Workers | ✅ Running | N/A | Yes | PM2 status check | James Wilson | 2024-01-23 |
Service Management:
# Check service status
pm2 status
pm2 logs shopflow-api
pm2 logs shopflow-workers
# Service restart
pm2 restart shopflow-api
pm2 restart shopflow-workers
4. Database Setup¶
4.1 Database Creation and Schema¶
| Task | Status | Details | Validated By | Date |
|---|---|---|---|---|
| ☑ Create Database | ✅ Complete | Database: shopflow_qa Owner: shopflow_app | Maria Garcia | 2024-01-22 |
| ☑ Create User/Roles | ✅ Complete | Users: shopflow_app, shopflow_readonly | Maria Garcia | 2024-01-22 |
| ☑ Run Schema Migration | ✅ Complete | Migration version: V3.5.0 Tables: 47 | Maria Garcia | 2024-01-23 |
| ☑ Create Indexes | ✅ Complete | All required indexes created | Maria Garcia | 2024-01-23 |
| ☑ Verify Constraints | ✅ Complete | Foreign keys, unique constraints validated | Maria Garcia | 2024-01-23 |
Database Connection Details: - Host: qa-db-01.internal (10.50.10.111) - Port: 5432 - Database: shopflow_qa - Application User: shopflow_app - Read-Only User: shopflow_readonly - Schema Version: 3.5.0 (verified via schema_version table)
4.2 Database Configuration¶
| Configuration | Status | Value | Validated By | Date |
|---|---|---|---|---|
| ☑ Max Connections | ✅ Complete | 200 | Maria Garcia | 2024-01-22 |
| ☑ Shared Buffers | ✅ Complete | 16GB | Maria Garcia | 2024-01-22 |
| ☑ Work Memory | ✅ Complete | 64MB | Maria Garcia | 2024-01-22 |
| ☑ Maintenance Work Mem | ✅ Complete | 2GB | Maria Garcia | 2024-01-22 |
| ☑ Checkpoint Settings | ✅ Complete | Optimized for performance | Maria Garcia | 2024-01-22 |
| ☑ Autovacuum | ✅ Complete | Enabled with custom settings | Maria Garcia | 2024-01-22 |
4.3 Database Replication¶
| Task | Status | Details | Validated By | Date |
|---|---|---|---|---|
| ☑ Configure Primary | ✅ Complete | Streaming replication enabled | Maria Garcia | 2024-01-22 |
| ☑ Configure Replica | ✅ Complete | Connected to primary | Maria Garcia | 2024-01-22 |
| ☑ Verify Replication | ✅ Complete | Replication lag: <2 seconds | Maria Garcia | 2024-01-23 |
| ☑ Test Failover | ✅ Complete | Manual failover successful | Maria Garcia | 2024-01-23 |
Replication Verification:
-- On Primary
SELECT client_addr, state, sync_state, replay_lag
FROM pg_stat_replication;
-- Expected: Replica IP, streaming, async, <5 seconds
5. Network Configuration¶
5.1 Load Balancer Setup¶
| Task | Status | Details | Validated By | Date |
|---|---|---|---|---|
| ☑ Install HAProxy | ✅ Complete | Version 2.6.6 | John Smith | 2024-01-22 |
| ☑ Configure Backend Servers | ✅ Complete | qa-app-01, qa-app-02 | John Smith | 2024-01-22 |
| ☑ Health Checks | ✅ Complete | HTTP /health every 5s | John Smith | 2024-01-22 |
| ☑ SSL/TLS Configuration | ✅ Complete | Certificate installed | John Smith | 2024-01-22 |
| ☑ Session Persistence | ✅ Complete | Sticky sessions enabled | John Smith | 2024-01-22 |
Load Balancer Configuration: - Frontend: https://qa.shopflow.example.com (10.50.10.200:443) - Backend Pool: - qa-app-01:3000 (Active) - qa-app-02:3000 (Active) - Algorithm: Least connections with sticky sessions - Health Check: GET /health every 5s, 2 failures trigger removal
5.2 DNS Configuration¶
| Record | Status | Value | TTL | Validated By | Date |
|---|---|---|---|---|---|
| ☑ qa.shopflow.example.com | ✅ Complete | 10.50.10.200 | 300 | John Smith | 2024-01-22 |
| ☑ qa-api.shopflow.example.com | ✅ Complete | 10.50.10.200 | 300 | John Smith | 2024-01-22 |
DNS Verification:
nslookup qa.shopflow.example.com
# Expected: 10.50.10.200
curl -I https://qa.shopflow.example.com
# Expected: HTTP/2 200
5.3 Firewall Rules¶
| Rule | Status | Source | Destination | Port | Protocol | Validated By | Date |
|---|---|---|---|---|---|---|---|
| ☑ QA Network to App Servers | ✅ Complete | 10.50.0.0/16 | qa-app-* | 3000 | TCP | Security Team | 2024-01-22 |
| ☑ App Servers to Database | ✅ Complete | qa-app-* | qa-db-01 | 5432 | TCP | Security Team | 2024-01-22 |
| ☑ App Servers to Redis | ✅ Complete | qa-app-* | qa-cache-01 | 6379 | TCP | Security Team | 2024-01-22 |
| ☑ App Servers to RabbitMQ | ✅ Complete | qa-app-* | qa-mq-01 | 5672 | TCP | Security Team | 2024-01-22 |
| ☑ Internet to Load Balancer | ✅ Complete | 0.0.0.0/0 | qa-lb-01 | 443 | TCP | Security Team | 2024-01-22 |
| ☑ Test Clients to Environment | ✅ Complete | QA VLAN | All QA servers | Various | TCP | Security Team | 2024-01-23 |
6. Third-Party Integrations¶
6.1 Payment Gateway - PayPal¶
| Task | Status | Details | Validated By | Date |
|---|---|---|---|---|
| ☑ Sandbox Account Created | ✅ Complete | Account: sandbox-shopflow@paypal.com | Emily Rodriguez | 2024-01-23 |
| ☑ API Credentials Obtained | ✅ Complete | Client ID and Secret stored in vault | Emily Rodriguez | 2024-01-23 |
| ☑ Configure Webhook | ✅ Complete | URL: https://qa-api.shopflow.example.com/webhooks/paypal | Emily Rodriguez | 2024-01-23 |
| ☑ Test Buyer Account | ✅ Complete | testbuyer@paypal.com (sandbox) | Emily Rodriguez | 2024-01-23 |
| ☑ Connection Test | ✅ Complete | Test payment successful | Emily Rodriguez | 2024-01-23 |
PayPal Configuration: - Environment: Sandbox - API Endpoint: https://api.sandbox.paypal.com - Client ID: [Stored in secrets vault] - Test Accounts: - Buyer: testbuyer@paypal.com / test1234 - Seller: sandbox-shopflow@paypal.com
6.2 Payment Gateway - Apple Pay¶
| Task | Status | Details | Validated By | Date |
|---|---|---|---|---|
| ☑ Merchant ID Registration | ✅ Complete | merchant.com.shopflow.qa | Emily Rodriguez | 2024-01-23 |
| ☑ Domain Verification | ✅ Complete | qa.shopflow.example.com verified | Emily Rodriguez | 2024-01-23 |
| ☑ Certificate Generation | ✅ Complete | Payment processing cert installed | Emily Rodriguez | 2024-01-23 |
| ☑ Test Card Configuration | ✅ Complete | Test cards configured in Wallet | Emily Rodriguez | 2024-01-23 |
| ☑ Integration Test | ✅ Complete | Test payment successful on Safari/iOS | Lisa Patel | 2024-01-23 |
Apple Pay Configuration: - Merchant ID: merchant.com.shopflow.qa - Verified Domains: qa.shopflow.example.com - Test Environment: Sandbox - Supported Networks: Visa, Mastercard, Amex
6.3 Payment Gateway - Google Pay¶
| Task | Status | Details | Validated By | Date |
|---|---|---|---|---|
| ☑ Merchant Account Setup | ✅ Complete | Test merchant account | Emily Rodriguez | 2024-01-23 |
| ☑ Merchant ID Configuration | ✅ Complete | Merchant ID: 12345678901234567890 | Emily Rodriguez | 2024-01-23 |
| ☑ Test Card Setup | ✅ Complete | Test cards added | Emily Rodriguez | 2024-01-23 |
| ☑ Integration Test | ✅ Complete | Test payment successful on Chrome/Android | David Kim | 2024-01-23 |
Google Pay Configuration: - Environment: TEST - Merchant ID: 12345678901234567890 - Gateway: stripe (test mode) - Allowed Card Networks: MASTERCARD, VISA, AMEX
6.4 Shipping Carriers¶
| Carrier | Status | Details | Validated By | Date |
|---|---|---|---|---|
| ☑ FedEx Test API | ✅ Complete | Test account credentials configured Rate calculation working | Emily Rodriguez | 2024-01-23 |
| ☑ UPS Test API | ✅ Complete | Test account credentials configured Rate calculation working | Emily Rodriguez | 2024-01-23 |
| ☑ USPS Test API | ✅ Complete | Test account credentials configured Rate calculation working | Emily Rodriguez | 2024-01-23 |
Shipping API Configuration: - FedEx: - Environment: Test - API Endpoint: https://wsbeta.fedex.com - Account: [Test Account] - Meter: [Test Meter]
- UPS:
- Environment: Test
- API Endpoint: https://wwwcie.ups.com
- Access Key: [Test Key]
-
Account: [Test Account]
-
USPS:
- Environment: Test
- API Endpoint: https://stg-secure.shippingapis.com
- User ID: [Test User]
6.5 Email Service¶
| Task | Status | Details | Validated By | Date |
|---|---|---|---|---|
| ☑ SMTP Server Configuration | ✅ Complete | Mailhog (test email server) Host: qa-mail-01:1025 | James Wilson | 2024-01-23 |
| ☑ Email Templates Deployed | ✅ Complete | 8 templates deployed | James Wilson | 2024-01-23 |
| ☑ Test Email Sending | ✅ Complete | Order confirmation email sent successfully | Emily Rodriguez | 2024-01-23 |
| ☑ Email Web Interface | ✅ Complete | Mailhog UI: http://qa-mail-01:8025 | James Wilson | 2024-01-23 |
Email Configuration: - SMTP Host: qa-mail-01.internal (10.50.10.130) - SMTP Port: 1025 - Authentication: None (test environment) - Web Interface: http://10.50.10.130:8025 - From Address: noreply@shopflow.example.com
7. Test Data Preparation¶
7.1 User Accounts¶
| Data Type | Status | Count | Details | Validated By | Date |
|---|---|---|---|---|---|
| ☑ Test User Accounts | ✅ Complete | 500 | Various customer profiles | Maria Garcia | 2024-01-23 |
| ☑ Admin Accounts | ✅ Complete | 5 | QA team admin access | Maria Garcia | 2024-01-23 |
| ☑ Guest Checkout Test Data | ✅ Complete | 100 | Email addresses for testing | Maria Garcia | 2024-01-23 |
Sample Test Accounts: - Regular User: testuser001@example.com / TestPass123! - Premium User: premium001@example.com / TestPass123! - Admin User: admin.qa@shopflow.example.com / AdminQA2024!
Test Data Files: - /test-data/user-accounts.csv - 500 user credentials - /test-data/guest-emails.txt - 100 guest email addresses
7.2 Product Catalog¶
| Data Type | Status | Count | Details | Validated By | Date |
|---|---|---|---|---|---|
| ☑ Products | ✅ Complete | 150 | Various categories and prices | Maria Garcia | 2024-01-23 |
| ☑ Product Images | ✅ Complete | 450 | 3 images per product | Maria Garcia | 2024-01-23 |
| ☑ Product Inventory | ✅ Complete | All products | Stock levels configured | Maria Garcia | 2024-01-23 |
| ☑ Out-of-Stock Items | ✅ Complete | 10 products | For testing unavailability | Maria Garcia | 2024-01-23 |
Product Categories: - Electronics (40 products) - Clothing (35 products) - Home & Garden (30 products) - Sports & Outdoors (25 products) - Books & Media (20 products)
Price Ranges: - Low: $5.99 - $29.99 (50 products) - Medium: $30.00 - $99.99 (60 products) - High: $100.00 - $999.99 (40 products)
7.3 Promotional Codes¶
| Promo Code | Status | Type | Discount | Valid From | Valid To | Validated By | Date |
|---|---|---|---|---|---|---|---|
| ☑ SAVE20 | ✅ Active | Percentage | 20% off | 2024-01-01 | 2024-12-31 | Maria Garcia | 2024-01-23 |
| ☑ FIRST10 | ✅ Active | Percentage | 10% off first order | 2024-01-01 | 2024-12-31 | Maria Garcia | 2024-01-23 |
| ☑ FREESHIP | ✅ Active | Free Shipping | $0 shipping | 2024-01-01 | 2024-12-31 | Maria Garcia | 2024-01-23 |
| ☑ 50OFF | ✅ Active | Fixed Amount | \(50 off orders >\)200 | 2024-01-01 | 2024-12-31 | Maria Garcia | 2024-01-23 |
| ☑ EXPIRED10 | ✅ Expired | Percentage | 10% off | 2023-01-01 | 2023-12-31 | Maria Garcia | 2024-01-23 |
| ☑ LIMIT5 | ✅ Active | Percentage | 15% off (5 uses max) | 2024-01-01 | 2024-12-31 | Maria Garcia | 2024-01-23 |
Promo Code File: /test-data/promo-codes.xlsx
7.4 Address Data¶
| Data Type | Status | Count | Details | Validated By | Date |
|---|---|---|---|---|---|
| ☑ US Addresses | ✅ Complete | 100 | All 50 states represented | Maria Garcia | 2024-01-23 |
| ☑ International Addresses | ✅ Complete | 50 | 20 countries | Maria Garcia | 2024-01-23 |
| ☑ Invalid Addresses | ✅ Complete | 20 | For negative testing | Maria Garcia | 2024-01-23 |
Address File: /test-data/addresses.json
7.5 Payment Test Data¶
| Data Type | Status | Details | Validated By | Date |
|---|---|---|---|---|
| ☑ Test Credit Cards | ✅ Complete | Visa, Mastercard, Amex test cards | Emily Rodriguez | 2024-01-23 |
| ☑ PayPal Test Accounts | ✅ Complete | 5 buyer accounts | Emily Rodriguez | 2024-01-23 |
| ☑ Invalid Card Numbers | ✅ Complete | For negative testing | Emily Rodriguez | 2024-01-23 |
| ☑ Expired Cards | ✅ Complete | For validation testing | Emily Rodriguez | 2024-01-23 |
Test Credit Cards (from payment gateway): - Visa: 4111 1111 1111 1111 (CVV: any 3 digits, any future date) - Mastercard: 5555 5555 5555 4444 (CVV: any 3 digits, any future date) - Amex: 3782 822463 10005 (CVV: any 4 digits, any future date) - Declined: 4000 0000 0000 0002 - Insufficient Funds: 4000 0000 0000 9995
8. Security Configuration¶
8.1 SSL/TLS Certificates¶
| Certificate | Status | Type | Expiry | Validated By | Date |
|---|---|---|---|---|---|
| ☑ qa.shopflow.example.com | ✅ Complete | Wildcard (*.shopflow.example.com) | 2025-01-20 | John Smith | 2024-01-22 |
| ☑ Certificate Chain | ✅ Complete | Intermediate + Root CA | N/A | John Smith | 2024-01-22 |
SSL Configuration: - TLS Version: TLS 1.2, TLS 1.3 - Cipher Suites: Strong ciphers only (A+ rating target) - HSTS: Enabled - Certificate Type: DigiCert Test Certificate
8.2 Security Hardening¶
| Security Control | Status | Details | Validated By | Date |
|---|---|---|---|---|
| ☑ Firewall Rules | ✅ Complete | Only required ports open | Security Team | 2024-01-22 |
| ☑ SSH Key-Based Auth | ✅ Complete | Password auth disabled | Security Team | 2024-01-22 |
| ☑ Fail2ban | ✅ Complete | Brute-force protection | Security Team | 2024-01-22 |
| ☑ Security Groups | ✅ Complete | Network isolation configured | Security Team | 2024-01-22 |
| ☑ Database Encryption | ✅ Complete | Encryption at rest enabled | Security Team | 2024-01-22 |
| ☑ Secrets Management | ✅ Complete | Vault integration configured | Security Team | 2024-01-22 |
8.3 Access Controls¶
| Control | Status | Details | Validated By | Date |
|---|---|---|---|---|
| ☑ RBAC Implemented | ✅ Complete | Role-based access control | Security Team | 2024-01-23 |
| ☑ VPN Requirement | ✅ Complete | VPN required for admin access | Security Team | 2024-01-22 |
| ☑ Audit Logging | ✅ Complete | All access logged | Security Team | 2024-01-23 |
| ☑ Session Management | ✅ Complete | 15-minute timeout | Security Team | 2024-01-23 |
9. Monitoring and Logging¶
9.1 Application Monitoring¶
| Component | Status | Tool | Dashboard URL | Validated By | Date |
|---|---|---|---|---|---|
| ☑ Application Metrics | ✅ Complete | Prometheus | http://qa-mon-01:9090 | DevOps Team | 2024-01-23 |
| ☑ Metrics Visualization | ✅ Complete | Grafana | http://qa-mon-01:3001 | DevOps Team | 2024-01-23 |
| ☑ Alerting | ✅ Complete | Alertmanager | http://qa-mon-01:9093 | DevOps Team | 2024-01-23 |
| ☑ Uptime Monitoring | ✅ Complete | Healthchecks | Internal | DevOps Team | 2024-01-23 |
Monitored Metrics: - CPU usage (per server) - Memory usage (per server) - Disk I/O - Network traffic - API response times - Error rates - Active sessions - Database connections
9.2 Logging Configuration¶
| Log Type | Status | Location | Retention | Validated By | Date |
|---|---|---|---|---|---|
| ☑ Application Logs | ✅ Complete | /var/log/shopflow/app.log | 30 days | James Wilson | 2024-01-23 |
| ☑ Access Logs | ✅ Complete | /var/log/nginx/access.log | 30 days | James Wilson | 2024-01-23 |
| ☑ Error Logs | ✅ Complete | /var/log/shopflow/error.log | 90 days | James Wilson | 2024-01-23 |
| ☑ Database Logs | ✅ Complete | /var/log/postgresql/ | 30 days | Maria Garcia | 2024-01-23 |
| ☑ Centralized Logging | ✅ Complete | ELK Stack (Elasticsearch) | 30 days | DevOps Team | 2024-01-23 |
Log Management: - Format: JSON (structured logging) - Level: INFO (can be changed to DEBUG) - Rotation: Daily, compressed after 7 days - Centralized: All logs shipped to ELK stack
9.3 Database Monitoring¶
| Metric | Status | Threshold | Alert | Validated By | Date |
|---|---|---|---|---|---|
| ☑ Connection Count | ✅ Complete | <150 connections | >180 warning | Maria Garcia | 2024-01-23 |
| ☑ Query Performance | ✅ Complete | <100ms avg | >500ms warning | Maria Garcia | 2024-01-23 |
| ☑ Replication Lag | ✅ Complete | <5 seconds | >10s warning | Maria Garcia | 2024-01-23 |
| ☑ Disk Space | ✅ Complete | >20% free | <15% warning | Maria Garcia | 2024-01-23 |
10. Test Tool Configuration¶
10.1 Test Management Tools¶
| Tool | Status | Version | URL | Validated By | Date |
|---|---|---|---|---|---|
| ☑ TestRail | ✅ Complete | 7.9.1.1003 | https://testrail.shopflow.example.com | Sarah Johnson | 2024-01-23 |
| ☑ Jira (Defect Tracking) | ✅ Complete | 9.12.0 | https://jira.shopflow.example.com | Sarah Johnson | 2024-01-23 |
TestRail Configuration: - Project: ShopFlow Checkout Enhancement v3.5 - Test Suites: Imported and organized - Integrations: Jira integration configured - Users: All QA team members added with appropriate roles
10.2 Automation Tools¶
| Tool | Status | Version | Location | Validated By | Date |
|---|---|---|---|---|---|
| ☑ Selenium WebDriver | ✅ Complete | 4.16.1 | npm package | James Wilson | 2024-01-23 |
| ☑ Cypress | ✅ Complete | 13.6.2 | npm package | James Wilson | 2024-01-23 |
| ☑ Postman/Newman | ✅ Complete | 6.4.0 | npm package | James Wilson | 2024-01-23 |
| ☑ JMeter | ✅ Complete | 5.6.3 | /opt/jmeter | Anna Kowalski | 2024-01-23 |
Automation Framework: - Location: /opt/shopflow-automation/ - Framework: Page Object Model (POM) - CI Integration: Jenkins configured - Test Reports: Allure reports configured
10.3 API Testing Tools¶
| Tool | Status | Version | Validated By | Date |
|---|---|---|---|---|
| ☑ Postman Collections | ✅ Complete | Latest | Emily Rodriguez | 2024-01-23 |
| ☑ Newman CLI | ✅ Complete | 6.4.0 | James Wilson | 2024-01-23 |
| ☑ Swagger UI | ✅ Complete | Available | James Wilson | 2024-01-23 |
API Documentation: - Swagger URL: https://qa-api.shopflow.example.com/api-docs - Postman Collections: Imported and organized - Environment: QA environment variables configured
10.4 Performance Testing Tools¶
| Tool | Status | Version | Configuration | Validated By | Date |
|---|---|---|---|---|---|
| ☑ Apache JMeter | ✅ Complete | 5.6.3 | Test plans ready | Anna Kowalski | 2024-01-23 |
| ☑ Load Generators | ✅ Complete | 3 VMs | Distributed testing ready | Anna Kowalski | 2024-01-23 |
Load Testing Configuration: - Test Plans: 5 scenarios prepared - Load Generators: 3 VMs (qa-load-01, 02, 03) - Capacity: Up to 5,000 concurrent users
10.5 Security Testing Tools¶
| Tool | Status | Version | Validated By | Date |
|---|---|---|---|---|
| ☑ OWASP ZAP | ✅ Complete | 2.14.0 | Tom Anderson | 2024-01-23 |
| ☑ Burp Suite | ✅ Complete | Community Ed. | Tom Anderson | 2024-01-23 |
11. Environment Validation¶
11.1 Smoke Tests¶
| Test | Status | Result | Executed By | Date |
|---|---|---|---|---|
| ☑ Homepage Load | ✅ Pass | Page loads in <2s | Emily Rodriguez | 2024-01-23 |
| ☑ User Login | ✅ Pass | Login successful | Emily Rodriguez | 2024-01-23 |
| ☑ Product Search | ✅ Pass | Results display correctly | Emily Rodriguez | 2024-01-23 |
| ☑ Add to Cart | ✅ Pass | Item added successfully | Emily Rodriguez | 2024-01-23 |
| ☑ Guest Checkout | ✅ Pass | Can initiate checkout | Emily Rodriguez | 2024-01-23 |
| ☑ Payment Page Load | ✅ Pass | Payment options display | Emily Rodriguez | 2024-01-23 |
| ☑ API Health Check | ✅ Pass | All endpoints respond | James Wilson | 2024-01-23 |
| ☑ Database Connectivity | ✅ Pass | Queries execute correctly | Maria Garcia | 2024-01-23 |
11.2 Integration Tests¶
| Integration | Status | Result | Validated By | Date |
|---|---|---|---|---|
| ☑ PayPal Sandbox | ✅ Pass | Payment successful | Emily Rodriguez | 2024-01-23 |
| ☑ Apple Pay Test | ✅ Pass | Payment successful | Lisa Patel | 2024-01-23 |
| ☑ Google Pay Test | ✅ Pass | Payment successful | David Kim | 2024-01-23 |
| ☑ FedEx Rate API | ✅ Pass | Rates retrieved | Emily Rodriguez | 2024-01-23 |
| ☑ UPS Rate API | ✅ Pass | Rates retrieved | Emily Rodriguez | 2024-01-23 |
| ☑ USPS Rate API | ✅ Pass | Rates retrieved | Emily Rodriguez | 2024-01-23 |
| ☑ Email Delivery | ✅ Pass | Email sent and received | James Wilson | 2024-01-23 |
11.3 Performance Baseline¶
| Metric | Status | Target | Actual | Validated By | Date |
|---|---|---|---|---|---|
| ☑ Homepage Load Time | ✅ Pass | <2s | 1.4s | Anna Kowalski | 2024-01-23 |
| ☑ API Response Time | ✅ Pass | <200ms | 145ms | Anna Kowalski | 2024-01-23 |
| ☑ Checkout Flow Time | ✅ Pass | <5s | 3.8s | Anna Kowalski | 2024-01-23 |
| ☑ Database Query Time | ✅ Pass | <100ms | 62ms | Maria Garcia | 2024-01-23 |
| ☑ Concurrent Users (baseline) | ✅ Pass | 100 users | No errors | Anna Kowalski | 2024-01-23 |
12. Access and Credentials¶
12.1 Environment URLs¶
| Resource | URL | Notes |
|---|---|---|
| Frontend Application | https://qa.shopflow.example.com | Main application URL |
| API Endpoint | https://qa-api.shopflow.example.com | REST API |
| API Documentation | https://qa-api.shopflow.example.com/api-docs | Swagger UI |
| TestRail | https://testrail.shopflow.example.com | Test management |
| Jira | https://jira.shopflow.example.com | Defect tracking |
| Grafana | http://qa-mon-01:3001 | Metrics dashboard |
| Mailhog | http://qa-mail-01:8025 | Email testing interface |
12.2 Test Accounts¶
Note: All passwords should be obtained from the shared password manager (LastPass Enterprise). The following are account usernames only.
| Account Type | Username/Email | Purpose |
|---|---|---|
| QA Team Admin | admin.qa@shopflow.example.com | Full admin access |
| Test User (Regular) | testuser001@example.com | Regular customer testing |
| Test User (Premium) | premium001@example.com | Premium customer testing |
| PayPal Buyer | testbuyer@paypal.com | PayPal payment testing |
| Shipping Test | shipping.test@example.com | Shipping calculation testing |
12.3 Server Access¶
SSH Access: Key-based authentication only
| Server | Hostname | Access Method | Access Group |
|---|---|---|---|
| App Servers | qa-app-01, qa-app-02 | SSH (port 22) | qa-team, devops |
| Database | qa-db-01 | SSH (port 22) | dba, devops |
| Load Balancer | qa-lb-01 | SSH (port 22) | devops |
VPN Required: All SSH access requires connection to QA VPN (OpenVPN)
12.4 Database Access¶
| Access Type | Connection String | Purpose |
|---|---|---|
| Application | postgresql://shopflow_app:[PASSWORD]@qa-db-01:5432/shopflow_qa | Application access |
| Read-Only | postgresql://shopflow_readonly:[PASSWORD]@qa-db-01:5432/shopflow_qa | Query and reporting |
| Admin | postgresql://postgres:[PASSWORD]@qa-db-01:5432/shopflow_qa | Database administration |
Database Tools: - pgAdmin 4: Installed on QA workstations - psql CLI: Available on all database servers
13. Sign-Off¶
13.1 Environment Readiness Confirmation¶
| Component | Ready | Sign-Off | Date |
|---|---|---|---|
| Infrastructure | ✅ Yes | John Smith, DevOps Lead | 2024-01-23 |
| Application Deployment | ✅ Yes | James Wilson, Dev Lead | 2024-01-23 |
| Database | ✅ Yes | Maria Garcia, DBA | 2024-01-23 |
| Third-Party Integrations | ✅ Yes | Emily Rodriguez, Sr. Test Engineer | 2024-01-23 |
| Test Data | ✅ Yes | Maria Garcia, DBA | 2024-01-23 |
| Security | ✅ Yes | Security Team | 2024-01-23 |
| Monitoring | ✅ Yes | DevOps Team | 2024-01-23 |
| Test Tools | ✅ Yes | James Wilson, Automation Lead | 2024-01-23 |
| Smoke Tests | ✅ Pass | Emily Rodriguez, Sr. Test Engineer | 2024-01-23 |
13.2 Overall Environment Status¶
Status: ✅ READY FOR TESTING
Environment Readiness Date: January 23, 2024
Testing Start Date: January 29, 2024
Final Approval:
| Name | Role | Signature | Date |
|---|---|---|---|
| Sarah Johnson | Test Manager | /s/ S. Johnson | Jan 23, 2024 |
| James Wilson | Development Lead | /s/ J. Wilson | Jan 23, 2024 |
| John Smith | DevOps Lead | /s/ J. Smith | Jan 23, 2024 |
14. Known Issues and Limitations¶
14.1 Known Issues¶
| Issue | Severity | Impact | Workaround | Status |
|---|---|---|---|---|
| PayPal sandbox occasional timeouts | Low | Payment testing may experience delays | Retry transaction | Monitored |
| Mobile device pool limited | Low | Limited concurrent mobile testing | Schedule device usage | Accepted |
14.2 Environment Limitations¶
- Performance: QA environment has 50% capacity of production
- Data Volume: Test data set smaller than production
- Geographic Distribution: Single data center (production is multi-region)
- External Services: Test/sandbox modes only
- Email: Test SMTP server (no actual email delivery to external addresses)
15. Support and Escalation¶
15.1 Environment Support Contacts¶
| Issue Type | Contact | Response Time |
|---|---|---|
| Infrastructure Issues | DevOps Team (devops@shopflow.example.com) | 1 hour |
| Application Issues | Development Team (dev-support@shopflow.example.com) | 2 hours |
| Database Issues | Maria Garcia (maria.garcia@shopflow.example.com) | 1 hour |
| Security Issues | Security Team (security@shopflow.example.com) | 30 minutes |
| Test Tool Issues | James Wilson (james.wilson@shopflow.example.com) | 2 hours |
15.2 Escalation Path¶
- Level 1: Team Lead (immediate)
- Level 2: Department Manager (within 1 hour)
- Level 3: Director (critical issues, within 2 hours)
Document End
Last Updated: January 23, 2024
Next Review: As needed during testing phase or upon environment changes