Yeraze/meshmonitor v3.0.0-beta9

v3.0.0-beta9 - PostgreSQL/MySQL Sync Method Fixes

on GitHub

What's Changed

This release fixes several sync database methods that were missing PostgreSQL/MySQL support, which could cause errors when using the PostgreSQL or MySQL backends.

Bug Fixes

• fix: Add PostgreSQL/MySQL support to several sync database methods (#1440)

  • Fixed getNodesWithKeySecurityIssues() - now uses nodesCache
  • Fixed getMessage() - now uses _messagesCache
  • Fixed getMessageByRequestId() - now uses _messagesCache
  • Fixed getMessageCount() - now returns _messagesCache.length
  • Fixed getMessagesAfterTimestamp() - now filters _messagesCache

• fix: Add async methods for PostgreSQL/MySQL traceroute log and audit search (#1438)

  • Added logAutoTracerouteAttemptAsync() for PostgreSQL/MySQL traceroute logging
  • Added updateAutoTracerouteResultByNodeAsync() for traceroute result updates
  • Added getAuditLogsAsync() with full filtering support (search, userId, action, resource, dates)
  • Fixed audit log column name mismatches for PostgreSQL/MySQL schemas

Migration

The SQLite to PostgreSQL/MySQL migration tool has been tested and verified working with production data (412,965 rows migrated successfully).

npm run migrate-db -- \
  --from sqlite:/data/meshmonitor.db \
  --to postgres://user:pass@localhost:5432/meshmonitor

Full Changelog: v3.0.0-beta8...v3.0.0-beta9

Proxmox LXC Template

This release includes a Proxmox-compatible LXC container template for MeshMonitor.

Installation

1. Download the .tar.gz template file
2. Verify the SHA256 checksum (optional but recommended)
3. Upload to your Proxmox server: scp meshmonitor-*.tar.gz root@proxmox:/var/lib/vz/template/cache/
4. Create a new LXC container from the template via Proxmox web UI
5. Configure /etc/meshmonitor/meshmonitor.env with your Meshtastic node IP
6. Start the container and access the web UI on port 8080

Documentation

See the Proxmox LXC Deployment Guide for detailed instructions.

Limitations

• Auto-upgrade feature is not supported in LXC deployments
• Manual updates required (download new template for each version)
• Community-supported (Docker remains the primary deployment method)

🚀 MeshMonitor v3.0.0-beta9

📦 Installation

Docker (recommended):

docker run -d \
  --name meshmonitor \
  -p 8080:3001 \
  -v meshmonitor-data:/data \
  ghcr.io/Yeraze/meshmonitor:3.0.0-beta9

🧪 Testing

✅ All tests passed
✅ TypeScript checks passed
✅ Docker images built for linux/amd64, linux/arm64, linux/arm/v7

📋 Changes

See commit history for detailed changes.