# Switch to postgres user
sudo -u postgres psql

# Create database and user
CREATE DATABASE agentlabs;
CREATE USER agentlabs_user WITH PASSWORD 'your_secure_password';
GRANT ALL PRIVILEGES ON DATABASE agentlabs TO agentlabs_user;

# Exit PostgreSQL
\q

# Test database connection
psql -h localhost -U agentlabs_user -d agentlabs

# Navigate to your web directory
cd /var/www/

# Extract agentlabs package (replace with your actual package)
sudo unzip agentlabs.zip
sudo mv agentlabs-main agentlabs
sudo chown -R $USER:$USER agentlabs
cd agentlabs

# Install dependencies
npm install

# Set proper permissions
sudo chown -R $USER:$USER node_modules
chmod -R 755 .

# Copy environment template
cp .env.example .env

# Edit environment file
nano .env

# Server Configuration
# =========================================
# AgentLabs - Environment Variables Template
# =========================================
# Copy this file to .env and fill in your actual values
# NEVER commit .env to version control!

# =========================================
# Database Configuration
# =========================================
PGHOST=postgres
PGPORT=5432
PGUSER=agentlabs
PGPASSWORD=your_secure_database_password_here
PGDATABASE=agentlabs
DATABASE_URL=postgresql://postgres:admin@localhost:5432/agentlabs_new


# =========================================
# Application Configuration
# =========================================
NODE_ENV=production
PORT=5000
APP_PORT=5000
APP_URL=https://yourdomain.com

# Session secret (generate with: openssl rand -base64 32)
SESSION_SECRET=your_session_secret_here_minimum_32_characters

# =========================================
# Twilio Configuration
# =========================================
# Get these from: https://console.twilio.com
TWILIO_ACCOUNT_SID=AC86dfe6f7f06d80fa095f748c0602f295
TWILIO_AUTH_TOKEN=325680266beffe69bc0f15135c32dd34

# =========================================
# ElevenLabs Configuration
# =========================================
# Get from: https://elevenlabs.io/app/settings/api-keys
# Note: You can add multiple keys via the admin panel after installation
ELEVENLABS_API_KEY=8744a05349c6a45dc4a9df8bae38efe79cad10a1d65d28b4be97468c1d4ce359

# =========================================
# Stripe Configuration (Production)
# =========================================
# Get from: https://dashboard.stripe.com/apikeys
STRIPE_SECRET_KEY=sk_test_tR3PYbcVNZZ796tH88S4VQ2u
VITE_STRIPE_PUBLIC_KEY=pk_test_51BTUDGJAJfZb9HEBwDg86TN1KNprHjkfipXmEDMb0gSCassK5T3ZfxsAbcgKVmAIXF7oZ6ItlZZbXO6idTHE67IM007EwQ4uN3

# =========================================
# Stripe Configuration (Testing - Optional)
# =========================================
# For testing in production environment
TESTING_STRIPE_SECRET_KEY=sk_test_xxxxxxxxxxxxxxxxxxxxxxxxxxxxx
TESTING_VITE_STRIPE_PUBLIC_KEY=pk_test_xxxxxxxxxxxxxxxxxxxxxxxxxxxxx

# =========================================
# Installation Configuration
# =========================================
# These are automatically managed by the installer
# Do not modify manually unless you know what you're doing
INSTALLER_COMPLETED=false
INSTALLER_VERSION=1.0.0


JWT_SECRET=dev-secret-key-change-in-production-123456789

# Generate SSL certificate using Certbot
sudo certbot --nginx -d your-domain.com

# Configure Nginx for agentlabs
sudo nano /etc/nginx/sites-available/agentlabs

server {
    listen 80;
    server_name your-domain.com;
    return 301 https://$server_name$request_uri;
}

server {
    listen 443 ssl;
    server_name your-domain.com;
    
    ssl_certificate /etc/letsencrypt/live/your-domain.com/fullchain.pem;
    ssl_certificate_key /etc/letsencrypt/live/your-domain.com/privkey.pem;
    
    location / {
        proxy_pass http://localhost:5000;
        proxy_http_version 1.1;
        proxy_set_header Upgrade $http_upgrade;
        proxy_set_header Connection 'upgrade';
        proxy_set_header Host $host;
        proxy_set_header X-Real-IP $remote_addr;
        proxy_set_header X-Forwarded-For $proxy_add_x_forwarded_for;
        proxy_set_header X-Forwarded-Proto $scheme;
        proxy_cache_bypass $http_upgrade;
    }
}

# Enable site and restart Nginx
sudo ln -s /etc/nginx/sites-available/agentlabs /etc/nginx/sites-enabled/
sudo nginx -t
sudo systemctl restart nginx

# Navigate to agentlabs directory
cd /var/www/agentlabs

# Run database generate
npm run db:generate

# Run database migrations
npm run db:push

# Verify database tables created
psql -h localhost -U agentlabs_user -d agentlabs -c "\dt"

# Build the application
npm run build

# Start with PM2 (Production)
pm2 start ecosystem.config.js

# Or start directly (Development)
npm run dev

# Check PM2 status
pm2 status
pm2 logs agentlabs

# Setup PM2 to start on boot
pm2 startup
pm2 save