uprightbass360
|
5c9f1d7389
|
feat: comprehensive module system and database management improvements
This commit introduces major enhancements to the module installation system,
database management, and configuration handling for AzerothCore deployments.
## Module System Improvements
### Module SQL Staging & Installation
- Refactor module SQL staging to properly handle AzerothCore's sql/ directory structure
- Fix SQL staging path to use correct AzerothCore format (sql/custom/db_*/*)
- Implement conditional module database importing based on enabled modules
- Add support for both cpp-modules and lua-scripts module types
- Handle rsync exit code 23 (permission warnings) gracefully during deployment
### Module Manifest & Automation
- Add automated module manifest generation via GitHub Actions workflow
- Implement Python-based module manifest updater with comprehensive validation
- Add module dependency tracking and SQL file discovery
- Support for blocked modules and module metadata management
## Database Management Enhancements
### Database Import System
- Add db-guard container for continuous database health monitoring and verification
- Implement conditional database import that skips when databases are current
- Add backup restoration and SQL staging coordination
- Support for Playerbots database (4th database) in all import operations
- Add comprehensive database health checking and status reporting
### Database Configuration
- Implement 10 new dbimport.conf settings from environment variables:
- Database.Reconnect.Seconds/Attempts for connection reliability
- Updates.AllowedModules for module auto-update control
- Updates.Redundancy for data integrity checks
- Worker/Synch thread settings for all three core databases
- Auto-apply dbimport.conf settings via auto-post-install.sh
- Add environment variable injection for db-import and db-guard containers
### Backup & Recovery
- Fix backup scheduler to prevent immediate execution on container startup
- Add backup status monitoring script with detailed reporting
- Implement backup import/export utilities
- Add database verification scripts for SQL update tracking
## User Import Directory
- Add new import/ directory for user-provided database files and configurations
- Support for custom SQL files, configuration overrides, and example templates
- Automatic import of user-provided databases and configs during initialization
- Documentation and examples for custom database imports
## Configuration & Environment
- Eliminate CLIENT_DATA_VERSION warning by adding default value syntax
- Improve CLIENT_DATA_VERSION documentation in .env.template
- Add comprehensive database import settings to .env and .env.template
- Update setup.sh to handle new configuration variables with proper defaults
## Monitoring & Debugging
- Add status dashboard with Go-based terminal UI (statusdash.go)
- Implement JSON status output (statusjson.sh) for programmatic access
- Add comprehensive database health check script
- Add repair-storage-permissions.sh utility for permission issues
## Testing & Documentation
- Add Phase 1 integration test suite for module installation verification
- Add comprehensive documentation for:
- Database management (DATABASE_MANAGEMENT.md)
- Module SQL analysis (AZEROTHCORE_MODULE_SQL_ANALYSIS.md)
- Implementation mapping (IMPLEMENTATION_MAP.md)
- SQL staging comparison and path coverage
- Module assets and DBC file requirements
- Update SCRIPTS.md, ADVANCED.md, and troubleshooting documentation
- Update references from database-import/ to import/ directory
## Breaking Changes
- Renamed database-import/ directory to import/ for clarity
- Module SQL files now staged to AzerothCore-compatible paths
- db-guard container now required for proper database lifecycle management
## Bug Fixes
- Fix module SQL staging directory structure for AzerothCore compatibility
- Handle rsync exit code 23 gracefully during deployments
- Prevent backup from running immediately on container startup
- Correct SQL staging paths for proper module installation
|
2025-11-20 18:26:00 -05:00 |
|
uprightbass360
|
a18e315f1f
|
refactor: reorganize scripts under bash/python
|
2025-11-09 02:49:26 -05:00 |
|
uprightbass360
|
622fd518d2
|
Introduce dynamic overrides and rename module manifest
|
2025-11-08 01:50:30 -05:00 |
|
uprightbass360
|
d99dad025a
|
feat: add mysql exposure toggle and client data bind
|
2025-11-07 22:29:13 -05:00 |
|
uprightbass360
|
303bda4c6e
|
fix: color format in status
|
2025-10-26 21:12:33 -04:00 |
|
uprightbass360
|
39ac59d641
|
automation tweaks
|
2025-10-26 19:12:56 -04:00 |
|
uprightbass360
|
f46b88bd93
|
variable cleanup
|
2025-10-26 04:49:25 -04:00 |
|
Deckard
|
b1ec4a90d6
|
update status message and update migration
|
2025-10-20 01:08:53 -04:00 |
|
Deckard
|
afc24fc9ec
|
Enhance status dashboard: atomic refresh, user metrics, default watch mode
|
2025-10-19 06:07:20 -04:00 |
|
Deckard
|
b62a55c47b
|
deployment updates
|
2025-10-19 03:39:51 -04:00 |
|
Deckard
|
859a214e12
|
refactoring and adding automations
|
2025-10-17 01:40:50 -04:00 |
|