🔍 Guest System Diagnostic Tool

Server: Microsoft-IIS/10.0

PHP Version: 8.3.13

Document Root: C:\inetpub\Websites\GuestSystem\public

Script Path: C:\inetpub\Websites\GuestSystem\public\diagnose.php

Current Working Directory: C:\inetpub\Websites\GuestSystem\public

Step-by-Step Diagnostics

1. Logs Directory

✓ Logs directory exists and is writable: C:\inetpub\Websites\GuestSystem\public/../logs

2. Composer Autoload

✓ vendor/autoload.php exists

✓ Autoloader loaded successfully

3. Configuration Files

✓ env.php exists

✓ db.php exists

✓ pusher.php exists

4. Environment Configuration

✓ env.php loaded successfully

Array
(
    [app_env] => Development
    [debug_enabled] => 1
    [allow_http] => 1
    [timezone] => America/Los_Angeles
    [db] => Array
        (
            [host] => azsql01.sitnsleep.com
            [name] => UpSystem
            [user] => gs_admin
            [pass] => rykviN-6tyzgu-fidmip
        )

    [pusher] => Array
        (
            [app_id] => 2001987
            [key] => ecfd88d2cf76e0f19514
            [secret] => 3202895ee3509e978af0
            [cluster] => us3
        )

    [manager] => Array
        (
            [pin_hash] => 14300
        )

    [store] => Array
        (
            [override_num] => 
        )

)

5. Required PHP Extensions

✓ pdo extension loaded

✓ json extension loaded

✓ mbstring extension loaded

✓ openssl extension loaded

SQL Server extensions (required for database):

⚠ sqlsrv extension not loaded

⚠ pdo_sqlsrv extension not loaded

✓ odbc extension loaded

✓ pdo_odbc extension loaded

⚠ PDO sqlsrv driver is NOT available

✓ PDO odbc driver is available

⚠ ODBC driver available, but SQL Server ODBC drivers not detected

6. Database Configuration

✓ Database configuration loaded successfully

✓ PDO connection established

✓ Database query test successful

7. Pusher Configuration

✓ Pusher configuration loaded successfully

8. Application Directory Structure

✓ app/Controllers exists

✓ app/Middleware exists

✓ app/Repositories exists

✓ app/Services exists

✓ app/Views exists

9. Main Application Bootstrap

✓ index.php exists