🏨 Ruhondo Beach Resort HMS - Database Connection Test
Step 1: Loading Configuration
✓ config.php loaded successfully
Configuration Constants:
- BASE_URL: https://amicopos.eccellaltd.com
- BASE_PATH: /home/rugewvtw/amicopos.eccellaltd.com
- DB_HOST: localhost
- DB_NAME: rugewvtw_amicodb
- DB_USER: rugewvtw_amicouser
- DB_PASS: [set]
Step 2: Loading Database Functions
✓ database.php loaded successfully
✓ Function get_db_connection() exists
✓ Function db_query() exists
✓ Function db_fetch_all() exists
Step 3: Testing Database Connection
✓ Database connection established successfully!
Connected to database: rugewvtw_amicodb
MySQL Version: 11.4.10-MariaDB-cll-lve
Tables in database: 46
- audit_logs
- currency_rates
- folio_charges
- guest_activity
- guest_documents
- guests
- hk_tasks
- invoice_items
- invoices
- kitchen_orders
- ... and 36 more
Step 4: Testing Logging
✓ log_message() works
Log file: /home/rugewvtw/amicopos.eccellaltd.com/logs/app.log
Log file size: 1272645 bytes
Last 5 log entries:
[13-Apr-2026 19:51:34 Africa/Kigali] Revenue Stats - Total: 7, Revenue: 118000, Items: 14
[13-Apr-2026 19:51:39 Africa/Kigali] Validating session on init
[13-Apr-2026 19:51:39 Africa/Kigali] require_auth called - Checking session
[13-Apr-2026 19:51:39 Africa/Kigali] Session validated successfully
[2026-04-13 19:57:30] [INFO] Database connection test completed
Step 5: Testing db_query Function
✓ db_query() works: 1
✅ Next Steps
Database connection is working! You can now: