Files
geutebruck/geutebruck-api/tools/Check-DatabaseHeader.ps1
Administrator 14893e62a5 feat: Geutebruck GeViScope/GeViSoft Action Mapping System - MVP
This MVP release provides a complete full-stack solution for managing action mappings
in Geutebruck's GeViScope and GeViSoft video surveillance systems.

## Features

### Flutter Web Application (Port 8081)
- Modern, responsive UI for managing action mappings
- Action picker dialog with full parameter configuration
- Support for both GSC (GeViScope) and G-Core server actions
- Consistent UI for input and output actions with edit/delete capabilities
- Real-time action mapping creation, editing, and deletion
- Server categorization (GSC: prefix for GeViScope, G-Core: prefix for G-Core servers)

### FastAPI REST Backend (Port 8000)
- RESTful API for action mapping CRUD operations
- Action template service with comprehensive action catalog (247 actions)
- Server management (G-Core and GeViScope servers)
- Configuration tree reading and writing
- JWT authentication with role-based access control
- PostgreSQL database integration

### C# SDK Bridge (gRPC, Port 50051)
- Native integration with GeViSoft SDK (GeViProcAPINET_4_0.dll)
- Action mapping creation with correct binary format
- Support for GSC and G-Core action types
- Proper Camera parameter inclusion in action strings (fixes CrossSwitch bug)
- Action ID lookup table with server-specific action IDs
- Configuration reading/writing via SetupClient

## Bug Fixes
- **CrossSwitch Bug**: GSC and G-Core actions now correctly display camera/PTZ head parameters in GeViSet
- Action strings now include Camera parameter: `@ PanLeft (Comment: "", Camera: 101028)`
- Proper filter flags and VideoInput=0 for action mappings
- Correct action ID assignment (4198 for GSC, 9294 for G-Core PanLeft)

## Technical Stack
- **Frontend**: Flutter Web, Dart, Dio HTTP client
- **Backend**: Python FastAPI, PostgreSQL, Redis
- **SDK Bridge**: C# .NET 8.0, gRPC, GeViSoft SDK
- **Authentication**: JWT tokens
- **Configuration**: GeViSoft .set files (binary format)

## Credentials
- GeViSoft/GeViScope: username=sysadmin, password=masterkey
- Default admin: username=admin, password=admin123

## Deployment
All services run on localhost:
- Flutter Web: http://localhost:8081
- FastAPI: http://localhost:8000
- SDK Bridge gRPC: localhost:50051
- GeViServer: localhost (default port)

Generated with Claude Code (https://claude.com/claude-code)

Co-Authored-By: Claude Sonnet 4.5 <noreply@anthropic.com>
2025-12-31 18:10:54 +01:00

44 lines
1.6 KiB
PowerShell

# Check database file header
$dbPath = "C:\Users\ADMINI~1\AppData\Local\Temp\3\GeViDB_shadow_copy.mdb"
if (-not (Test-Path $dbPath)) {
Write-Host "[ERROR] Database file not found at: $dbPath" -ForegroundColor Red
exit 1
}
Write-Host "Reading database file header..." -ForegroundColor Yellow
Write-Host "File: $dbPath" -ForegroundColor Gray
Write-Host ""
try {
$bytes = [System.IO.File]::ReadAllBytes($dbPath) | Select-Object -First 64
Write-Host "First 64 bytes (hex):" -ForegroundColor Cyan
$hex = ($bytes | ForEach-Object { $_.ToString("X2") }) -join " "
Write-Host $hex -ForegroundColor White
Write-Host ""
Write-Host "As ASCII:" -ForegroundColor Cyan
$ascii = [System.Text.Encoding]::ASCII.GetString($bytes)
Write-Host $ascii -ForegroundColor White
Write-Host ""
# Check for common database signatures
$signature = [System.Text.Encoding]::ASCII.GetString($bytes[0..15])
if ($signature -match "Standard Jet DB") {
Write-Host "[INFO] Detected: Microsoft Jet Database (Access 97-2003)" -ForegroundColor Green
} elseif ($signature -match "Standard ACE DB") {
Write-Host "[INFO] Detected: Microsoft ACE Database (Access 2007+)" -ForegroundColor Green
} elseif ($bytes[0] -eq 0x00 -and $bytes[1] -eq 0x01 -and $bytes[2] -eq 0x00 -and $bytes[3] -eq 0x00) {
Write-Host "[INFO] Detected: Encrypted or protected database" -ForegroundColor Yellow
} else {
Write-Host "[WARN] Unknown database format" -ForegroundColor Yellow
}
} catch {
Write-Host "[ERROR] Failed to read file: $($_.Exception.Message)" -ForegroundColor Red
exit 1
}