scan_wordpress.js

Go to the documentation of this file.

#!/usr/bin/env node
 
const { exec } = require('child_process');
const fs = require('fs');
const path = require('path');
const util = require('util');
const execPromise = util.promisify(exec);
 
const SSH_KEY = `${process.env.HOME}/PreciseITServices.pem`;
const SSH_USER = 'centos';
const WHM_HOST = 'precisewebhosting.com.au';
const OUTPUT_DIR = 'exports/wordpress-inventory';
 
if (!fs.existsSync(OUTPUT_DIR)){
    fs.mkdirSync(OUTPUT_DIR, { recursive: true });
}
 
console.log('========================================');
console.log('WordPress Site Inventory Scanner');
console.log('========================================\n');
 
/**
 *
 */
async function scanWordPressSites() {
    console.log('🔍 Scanning for WordPress installations...\n');
    
    // Get list of WordPress installations
    const findCmd = `ssh -i "${SSH_KEY}" ${SSH_USER}@${WHM_HOST} "ls /home/*/public_html/wp-config.php 2>/dev/null"`;
    
    let wpConfigPaths;
    try {
        const { stdout } = await execPromise(findCmd);
        wpConfigPaths = stdout.trim().split('\n').filter(p => p);
    } catch (error) {
        console.error('❌ Failed to find WordPress sites:', error.message);
        process.exit(1);
    }
    
    console.log(`   Found ${wpConfigPaths.length} WordPress installations\n`);
    
    const sites = [];
    let processed = 0;
    
    for (const wpConfigPath of wpConfigPaths) {
        const wpPath = path.dirname(wpConfigPath);
        const username = wpPath.split('/')[2];
        
        processed++;
        console.log(`   [${processed}/${wpConfigPaths.length}] ${username} (${wpPath})`);
        
        try {
            // Single SSH command to extract all data (using sudo for file access)
            const cmd = `ssh -i "${SSH_KEY}" ${SSH_USER}@${WHM_HOST} sudo bash -c '
WP_PATH="${wpPath}"
WP_CONFIG="${wpConfigPath}"
 
# Extract database credentials
DB_NAME=$(cat "$WP_CONFIG" 2>/dev/null | grep "define.*DB_NAME" | head -1 | sed "s/.*[\\x27\\x22]\\‍([^\\x27\\x22]*\\‍)[\\x27\\x22].*/\\1/")
DB_USER=$(cat "$WP_CONFIG" 2>/dev/null | grep "define.*DB_USER" | head -1 | sed "s/.*[\\x27\\x22]\\‍([^\\x27\\x22]*\\‍)[\\x27\\x22].*/\\1/")
DB_PASS=$(cat "$WP_CONFIG" 2>/dev/null | grep "define.*DB_PASSWORD" | head -1 | sed "s/.*[\\x27\\x22]\\‍([^\\x27\\x22]*\\‍)[\\x27\\x22].*/\\1/")
DB_HOST=$(cat "$WP_CONFIG" 2>/dev/null | grep "define.*DB_HOST" | head -1 | sed "s/.*[\\x27\\x22]\\‍([^\\x27\\x22]*\\‍)[\\x27\\x22].*/\\1/" || echo "localhost")
TABLE_PREFIX=$(cat "$WP_CONFIG" 2>/dev/null | grep "table_prefix" | sed "s/.*[\\x27\\x22]\\‍([^\\x27\\x22]*\\‍)[\\x27\\x22].*/\\1/" || echo "wp_")
 
# Get WordPress version
WP_VERSION=$(cat "$WP_PATH/wp-includes/version.php" 2>/dev/null | grep "\\$wp_version" | head -1 | sed "s/.*[\\x27\\x22]\\‍([^\\x27\\x22]*\\‍)[\\x27\\x22].*/\\1/" || echo "unknown")
 
# Get directory size
SIZE=$(du -sh "$WP_PATH" 2>/dev/null | cut -f1 || echo "unknown")
 
# Get site URL from database (with error handling)
SITE_URL=$(mysql -h"$DB_HOST" -u"$DB_USER" -p"$DB_PASS" -D"$DB_NAME" -N -B -e "SELECT option_value FROM ${TABLE_PREFIX}options WHERE option_name=\\x27siteurl\\x27 LIMIT 1" 2>/dev/null | head -1 || echo "unknown")
 
# Check if multisite
IS_MULTISITE=false
cat "$WP_CONFIG" 2>/dev/null | grep -q "MULTISITE" && IS_MULTISITE=true
 
echo "$DB_NAME|||$DB_USER|||$DB_PASS|||$DB_HOST|||$TABLE_PREFIX|||$WP_VERSION|||$SIZE|||$SITE_URL|||$IS_MULTISITE"
'`;
            
            const { stdout } = await execPromise(cmd, { maxBuffer: 1024 * 1024 * 10 });
            const parts = stdout.trim().split('|||');
            
            if (parts.length >= 9) {
                const siteData = {
                    username,
                    path: wpPath,
                    location: 'public_html',
                    version: parts[5] || 'unknown',
                    site_url: parts[7] || 'unknown',
                    size: parts[6] || 'unknown',
                    multisite: parts[8] === 'true',
                    database: {
                        db_name: parts[0] || '',
                        db_user: parts[1] || '',
                        db_password: parts[2] || '',
                        db_host: parts[3] || 'localhost',
                        table_prefix: parts[4] || 'wp_'
                    }
                };
                
                sites.push(siteData);
                console.log(`      ✅ ${siteData.site_url} (${siteData.version}) - ${siteData.size}`);
            } else {
                console.log(`      ⚠️  Incomplete data extracted`);
            }
            
        } catch (error) {
            console.log(`      ❌ Error: ${error.message}`);
        }
    }
    
    // Save results
    const outputFile = path.join(OUTPUT_DIR, 'wordpress_sites.json');
    fs.writeFileSync(outputFile, JSON.stringify(sites, null, 2));
    
    console.log('\n========================================');
    console.log(`✅ WordPress inventory saved: ${outputFile}`);
    console.log('========================================\n');
    console.log(`📊 Sites found: ${sites.length}/${wpConfigPaths.length}\n`);
    
    if (sites.length > 0) {
        console.log('Ready for migration!\n');
        console.log('Next step: ./migration-scripts/migrate_wordpress_to_github.sh\n');
    }
}
 
scanWordPressSites().catch(error => {
    console.error('\n❌ Error:', error.message);
    process.exit(1);
});