inventory_wordpress_sites.js

Go to the documentation of this file.

#!/usr/bin/env node
 
/**
 * WordPress Site Inventory Scanner
 * Scans WHM server via SSH for WordPress installations
 */
 
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';
 
// Ensure output directory exists
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 via SSH...\n');
    
    // Find all wp-config.php files
    const findCmd = `ssh -i "${SSH_KEY}" ${SSH_USER}@${WHM_HOST} "find /home*/*/public_html -maxdepth 1 -name 'wp-config.php' 2>/dev/null || true"`;
    
    let wpConfigPaths;
    try {
        const { stdout } = await execPromise(findCmd);
        wpConfigPaths = stdout.trim().split('\n').filter(p => p);
    } catch (error) {
        console.error('❌ Failed to scan for WordPress sites:', error.message);
        process.exit(1);
    }
    
    console.log(`   Found ${wpConfigPaths.length} WordPress installations\n`);
    
    if (wpConfigPaths.length === 0) {
        fs.writeFileSync(path.join(OUTPUT_DIR, 'wordpress_sites.json'), JSON.stringify([], null, 2));
        console.log('✅ No WordPress sites found\n');
        return;
    }
    
    const sites = [];
    
    for (const wpConfigPath of wpConfigPaths) {
        const wpPath = path.dirname(wpConfigPath);
        const username = wpPath.split('/')[2];
        
        console.log(`   Processing: ${username} (${wpPath})`);
        
        try {
            // Extract data using remote commands
            const extractCmd = `ssh -i "${SSH_KEY}" ${SSH_USER}@${WHM_HOST} bash << 'EOF'
WP_PATH="${wpPath}"
WP_CONFIG="\$WP_PATH/wp-config.php"
 
# Get database info
DB_NAME=\$(grep "DB_NAME" "\$WP_CONFIG" | head -1 | sed -e "s/.*['\\"]\‍(.*\‍)['\\"].*/\\1/")
DB_USER=\$(grep "DB_USER" "\$WP_CONFIG" | head -1 | sed -e "s/.*['\\"]\‍(.*\‍)['\\"].*/\\1/")
DB_PASS=\$(grep "DB_PASSWORD" "\$WP_CONFIG" | head -1 | sed -e "s/.*['\\"]\‍(.*\‍)['\\"].*/\\1/")
DB_HOST=\$(grep "DB_HOST" "\$WP_CONFIG" | head -1 | sed -e "s/.*['\\"]\‍(.*\‍)['\\"].*/\\1/" || echo "localhost")
TABLE_PREFIX=\$(grep "table_prefix" "\$WP_CONFIG" | sed -e "s/.*['\\"]\‍(.*\‍)['\\"].*/\\1/" || echo "wp_")
 
# Get WordPress version
WP_VERSION=\$(grep "wp_version" "\$WP_PATH/wp-includes/version.php" | head -1 | sed -e "s/.*['\\"]\‍(.*\‍)['\\"].*/\\1/" || echo "unknown")
 
# Get directory size
SIZE=\$(du -sh "\$WP_PATH" 2>/dev/null | cut -f1 || echo "unknown")
 
# Get site URL from database
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='siteurl' LIMIT 1" 2>/dev/null || echo "unknown")
 
# Check if multisite
IS_MULTISITE="false"
grep -q "MULTISITE" "\$WP_CONFIG" 2>/dev/null && IS_MULTISITE="true"
 
# Output JSON
cat << JSONEOF
{
  "db_name": "\$DB_NAME",
  "db_user": "\$DB_USER",
  "db_password": "\$DB_PASS",
  "db_host": "\$DB_HOST",
  "table_prefix": "\$TABLE_PREFIX",
  "wp_version": "\$WP_VERSION",
  "size": "\$SIZE",
  "site_url": "\$SITE_URL",
  "multisite": \$IS_MULTISITE
}
JSONEOF
EOF`;
            
            const { stdout } = await execPromise(extractCmd);
            const data = JSON.parse(stdout.trim());
            
            sites.push({
                username,
                path: wpPath,
                location: 'public_html',
                version: data.wp_version,
                site_url: data.site_url,
                size: data.size,
                multisite: data.multisite,
                database: {
                    db_name: data.db_name,
                    db_user: data.db_user,
                    db_password: data.db_password,
                    db_host: data.db_host,
                    table_prefix: data.table_prefix
                }
            });
            
            console.log(`      ✅ ${data.site_url} (${data.wp_version}) - ${data.size}`);
            
        } catch (error) {
            console.log(`      ⚠️  Failed to extract data: ${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 to: ${outputFile}`);
    console.log('========================================\n');
    
    console.log('📊 Summary:');
    console.log(`   WordPress sites found: ${sites.length}\n`);
    
    if (sites.length > 0) {
        console.log('Sites:');
        sites.forEach(site => {
            console.log(`   • ${site.site_url} (${site.version}) - ${site.size} - ${site.path}`);
        });
        console.log('');
    }
    
    console.log('✅ Inventory complete!');
    console.log(`📁 Output: ${OUTPUT_DIR}/\n`);
    console.log('Next steps:');
    console.log('1. Review wordpress_sites.json');
    console.log('2. Run migrate_wordpress_to_github.sh to create repos and migrate\n');
}
 
scanWordPressSites().catch(error => {
    console.error('\n❌ Error:', error.message);
    process.exit(1);
});