#!/bin/bash

###############################################################################
# Check and Setup phpMyAdmin on NEW Server
# Run this on: NEW server (vps2.scala4.com)
###############################################################################

echo "=========================================="
echo "Checking phpMyAdmin on NEW Server"
echo "=========================================="
echo ""

# Check if running as root
if [ "$EUID" -ne 0 ]; then 
    echo "ERROR: Please run as root (use sudo)"
    exit 1
fi

# Check if phpMyAdmin is installed
echo "Checking if phpMyAdmin is installed..."
if dpkg -l | grep -q phpmyadmin; then
    echo "✓ phpMyAdmin is installed"
    PHPMYADMIN_VERSION=$(dpkg -l | grep phpmyadmin | awk '{print $3}')
    echo "  Version: $PHPMYADMIN_VERSION"
else
    echo "✗ phpMyAdmin is NOT installed"
    echo ""
    echo "To install, run:"
    echo "  apt-get update"
    echo "  apt-get install -y phpmyadmin"
    exit 1
fi

echo ""

# Check if accessible via web
echo "Checking phpMyAdmin locations..."
if [ -d "/usr/share/phpmyadmin" ]; then
    echo "✓ Found: /usr/share/phpmyadmin"
fi

if [ -d "/var/www/html/phpmyadmin" ]; then
    echo "✓ Found: /var/www/html/phpmyadmin"
    echo "  Access at: http://$(hostname -I | awk '{print $1}')/phpmyadmin"
elif [ -L "/var/www/html/phpmyadmin" ]; then
    echo "✓ Found symlink: /var/www/html/phpmyadmin"
    echo "  Access at: http://$(hostname -I | awk '{print $1}')/phpmyadmin"
else
    echo "⚠ phpMyAdmin not accessible via web"
    echo ""
    echo "Creating symlink..."
    ln -s /usr/share/phpmyadmin /var/www/html/phpmyadmin
    chown -R www-data:www-data /var/www/html/phpmyadmin
    echo "✓ Symlink created"
    echo "  Access at: http://$(hostname -I | awk '{print $1}')/phpmyadmin"
fi

echo ""

# Check Apache configuration
echo "Checking Apache configuration..."
if apache2ctl -S 2>/dev/null | grep -q phpmyadmin; then
    echo "✓ phpMyAdmin configured in Apache"
else
    echo "⚠ phpMyAdmin may need Apache configuration"
fi

echo ""

# Get server IP
SERVER_IP=$(hostname -I | awk '{print $1}')
echo "=========================================="
echo "phpMyAdmin Access Information"
echo "=========================================="
echo ""
echo "URL: http://$SERVER_IP/phpmyadmin"
echo ""
echo "Login credentials:"
echo "  Username: root"
echo "  Password: (try empty first, or check /root/.my.cnf)"
echo ""
echo "To check MySQL root password:"
echo "  cat /root/.my.cnf"
echo ""