debug.js

// Debug script - NO .env loading, only Hostinger environment variables
import express from 'express';
import { fileURLToPath } from 'url';
import { dirname, join } from 'path';
import { readdirSync, existsSync } from 'fs';

const __filename = fileURLToPath(import.meta.url);
const __dirname = dirname(__filename);

const app = express();
const PORT = process.env.PORT || 8080;

app.get('/', (req, res) => res.json({ status: 'base ok' }));
app.get('/health', (req, res) => res.json({ status: 'ok' }));

let errors = [];

app.get('/debug', async (req, res) => {
  // List files starting with . or env
  let dotFiles = [];
  try {
    dotFiles = readdirSync(__dirname).filter(f => f.startsWith('.') || f.includes('env'));
  } catch (e) {
    dotFiles = ['error: ' + e.message];
  }

  const results = {
    note: 'NO .env file loaded - these are ONLY from Hostinger environment variables',
    node: process.version,
    cwd: process.cwd(),
    dirname: __dirname,
    dotFiles: dotFiles,
    envKeys: Object.keys(process.env).filter(k => !k.startsWith('npm_')).sort(),
    env: {
      NODE_ENV: process.env.NODE_ENV || 'NOT SET',
      DB_ADAPTER: process.env.DB_ADAPTER || 'NOT SET',
      MYSQL_HOST: process.env.MYSQL_HOST || 'NOT SET',
      MYSQL_USER: process.env.MYSQL_USER || 'NOT SET',
      MYSQL_DATABASE: process.env.MYSQL_DATABASE || 'NOT SET',
      MYSQL_PORT: process.env.MYSQL_PORT || 'NOT SET',
      PORT: process.env.PORT || 'NOT SET',
      SASSY_ALLOWED_ORIGINS: process.env.SASSY_ALLOWED_ORIGINS || 'NOT SET',
      SASSY_ISSUER: process.env.SASSY_ISSUER || 'NOT SET',
      SASSY_AUDIENCE: process.env.SASSY_AUDIENCE || 'NOT SET',
      SASSY_APP_NAME: process.env.SASSY_APP_NAME || 'NOT SET',
      SASSY_APP_URL: process.env.SASSY_APP_URL || 'NOT SET',
    },
    errors: errors
  };

  res.json(results);
});

process.on('uncaughtException', (err) => {
  errors.push({ type: 'uncaughtException', message: err.message, stack: err.stack });
});

process.on('unhandledRejection', (reason) => {
  errors.push({ type: 'unhandledRejection', message: String(reason) });
});

app.listen(PORT, () => {
  console.log(`Debug server running on port ${PORT}`);
  console.log(`DB_ADAPTER: ${process.env.DB_ADAPTER || 'not set'}`);
});