Files
myron dbc5a01de9 Fix #4-#8: mail virtual domains, DNS verified, reseller isolation, missing DB tables
#4: Postfix virtual mailbox config (virtual_mailbox_domains/maps, vmail user, maildir
    at /var/mail/vhosts/%d/%n). Dovecot SQL backend pointed at novacpx.email_accounts
    with SHA512-CRYPT passdb and per-domain Maildir userdb.

#5: BIND9 confirmed working — dig @localhost resolves testdomain1.com correctly.

#6: Certbot 2.9.0 confirmed installed; domains.document_root wired; infrastructure
    ready for live domain issuance (testdomain1.com not publicly resolvable so
    dry-run expected to fail).

#7: Fixed all broken user-panel API queries — missing tables (databases, ftp_accounts,
    ssl_certs, cron_jobs, php_configs, notifications) created; `databases` reserved-word
    backtick-quoted across DatabaseManager+endpoints; domains.php is_primary→type=main,
    doc_root→document_root column fixes; DNSManager::createZone call signature fixed;
    stats/account auto-resolves account_id for user role.

#8: assert_account_access() helper added to api/index.php; reseller ownership check
    wired into email, ftp, databases, domains, dns, ssl endpoints.

Co-Authored-By: Claude Sonnet 4.6 <noreply@anthropic.com>
2026-06-08 03:31:30 +00:00

25 lines
806 B
Bash
Executable File

#!/usr/bin/env bash
# nova-push.sh — Push a local file to the NovaCPX VM via double-hop
# Usage: bash nova-push.sh <local_file> <remote_path>
# Example: bash nova-push.sh panel/api/index.php /srv/novacpx/public/api/index.php
set -euo pipefail
PVE1_HOST="orbisne.fortiddns.com"
PVE1_PASS="Joker1974!!!"
VM_IP="10.48.200.110"
VM_PASS="Joker1974!!!"
SSH_OPTS="-o StrictHostKeyChecking=no -o ConnectTimeout=10"
LOCAL="$1"
REMOTE="$2"
[[ -f "$LOCAL" ]] || { echo "Error: $LOCAL not found"; exit 1; }
echo "Pushing $LOCAL → VM:$REMOTE"
CONTENT=$(base64 -w0 "$LOCAL")
sshpass -p "$PVE1_PASS" ssh $SSH_OPTS root@$PVE1_HOST \
"sshpass -p '$VM_PASS' ssh $SSH_OPTS root@$VM_IP \
\"mkdir -p \$(dirname $REMOTE) && echo '$CONTENT' | base64 -d > $REMOTE && chown www-data:www-data $REMOTE\""
echo "Done."