8.3 トラブルシューティング ​

#!/bin/bash
# Zabbix統合診断スクリプト

SCRIPT_NAME="zabbix-diagnostic"
VERSION="2.1"
LOG_FILE="/var/log/zabbix/diagnostic_$(date +%Y%m%d_%H%M%S).log"
REPORT_FILE="/tmp/zabbix_diagnostic_report.txt"
CONFIG_FILE="/etc/zabbix/zabbix_server.conf"

# カラー出力設定
RED='\033[0;31m'
GREEN='\033[0;32m'
YELLOW='\033[1;33m'
BLUE='\033[0;34m'
NC='\033[0m' # No Color

# ログ関数
log_message() {
    local level="$1"
    local message="$2"
    local timestamp=$(date '+%Y-%m-%d %H:%M:%S')
    
    echo "[$timestamp] [$level] $message" | tee -a "$LOG_FILE"
    
    case "$level" in
        "ERROR")   echo -e "${RED}✗ $message${NC}" ;;
        "WARNING") echo -e "${YELLOW}⚠ $message${NC}" ;;
        "SUCCESS") echo -e "${GREEN}✓ $message${NC}" ;;
        "INFO")    echo -e "${BLUE}ℹ $message${NC}" ;;
        *)         echo "$message" ;;
    esac
}

# システム情報収集
collect_system_info() {
    log_message "INFO" "Collecting system information..."
    
    cat > "$REPORT_FILE" << EOF
# Zabbix Diagnostic Report

Generated: $(date)
Hostname: $(hostname)
OS: $(cat /etc/os-release | grep PRETTY_NAME | cut -d'"' -f2)
Kernel: $(uname -r)
Uptime: $(uptime)

## System Resources

### CPU Information
$(lscpu | grep -E "(Architecture|CPU|Thread|Socket)")

### Memory Information
$(free -h)

### Disk Usage
$(df -h | grep -E '^/dev/')

### Network Interfaces
$(ip addr show | grep -E '^[0-9]|inet ')

EOF
}

# Zabbixプロセス状況確認
check_zabbix_processes() {
    log_message "INFO" "Checking Zabbix processes..."
    
    echo "## Zabbix Process Status" >> "$REPORT_FILE"
    
    # Zabbixサーバープロセス確認
    if pgrep -f zabbix_server > /dev/null; then
        log_message "SUCCESS" "Zabbix server process is running"
        
        local server_pid=$(pgrep -f zabbix_server)
        local server_threads=$(ps -o thcount -p "$server_pid" | tail -1)
        
        echo "### Zabbix Server" >> "$REPORT_FILE"
        echo "- Status: Running" >> "$REPORT_FILE"
        echo "- PID: $server_pid" >> "$REPORT_FILE"
        echo "- Threads: $server_threads" >> "$REPORT_FILE"
        
        # プロセス詳細情報
        echo "- Process Details:" >> "$REPORT_FILE"
        ps aux | grep zabbix_server | grep -v grep >> "$REPORT_FILE"
        
    else
        log_message "ERROR" "Zabbix server process is not running"
        echo "### Zabbix Server" >> "$REPORT_FILE"
        echo "- Status: NOT RUNNING" >> "$REPORT_FILE"
        
        # サービス状況確認
        if systemctl is-enabled zabbix-server >/dev/null 2>&1; then
            local service_status=$(systemctl is-active zabbix-server)
            echo "- Service Status: $service_status" >> "$REPORT_FILE"
        fi
    fi
    
    # Zabbixエージェントプロセス確認
    if pgrep -f zabbix_agentd > /dev/null; then
        log_message "SUCCESS" "Zabbix agent process is running"
        echo "### Zabbix Agent" >> "$REPORT_FILE"
        echo "- Status: Running" >> "$REPORT_FILE"
        ps aux | grep zabbix_agentd | grep -v grep >> "$REPORT_FILE"
    else
        log_message "WARNING" "Zabbix agent process is not running"
        echo "### Zabbix Agent" >> "$REPORT_FILE"
        echo "- Status: NOT RUNNING" >> "$REPORT_FILE"
    fi
}

# 設定ファイル検証
verify_configuration() {
    log_message "INFO" "Verifying Zabbix configuration..."
    
    echo "## Configuration Verification" >> "$REPORT_FILE"
    
    # Zabbixサーバー設定検証
    if [ -f "$CONFIG_FILE" ]; then
        log_message "INFO" "Found Zabbix server configuration file"
        
        # 設定テスト実行
        local config_test=$(zabbix_server -t 2>&1)
        local test_result=$?
        
        echo "### Server Configuration Test" >> "$REPORT_FILE"
        if [ $test_result -eq 0 ]; then
            log_message "SUCCESS" "Zabbix server configuration is valid"
            echo "- Result: PASSED" >> "$REPORT_FILE"
        else
            log_message "ERROR" "Zabbix server configuration has errors"
            echo "- Result: FAILED" >> "$REPORT_FILE"
            echo "- Errors:" >> "$REPORT_FILE"
            echo "$config_test" >> "$REPORT_FILE"
        fi
        
        # 重要設定項目確認
        echo "### Key Configuration Parameters" >> "$REPORT_FILE"
        grep -E "^(DBHost|DBName|DBUser|LogFile|PidFile|ListenPort|StartPollers)" "$CONFIG_FILE" >> "$REPORT_FILE"
        
    else
        log_message "ERROR" "Zabbix server configuration file not found: $CONFIG_FILE"
        echo "### Server Configuration" >> "$REPORT_FILE"
        echo "- Status: Configuration file not found" >> "$REPORT_FILE"
    fi
    
    # エージェント設定確認
    local agent_config="/etc/zabbix/zabbix_agentd.conf"
    if [ -f "$agent_config" ]; then
        echo "### Agent Configuration" >> "$REPORT_FILE"
        grep -E "^(Server|ServerActive|Hostname|ListenPort)" "$agent_config" >> "$REPORT_FILE"
    fi
}

# データベース接続確認
check_database_connectivity() {
    log_message "INFO" "Checking database connectivity..."
    
    echo "## Database Connectivity" >> "$REPORT_FILE"
    
    # 設定からDB情報抽出
    local db_host=$(grep "^DBHost=" "$CONFIG_FILE" | cut -d'=' -f2)
    local db_name=$(grep "^DBName=" "$CONFIG_FILE" | cut -d'=' -f2)
    local db_user=$(grep "^DBUser=" "$CONFIG_FILE" | cut -d'=' -f2)
    local db_password=$(grep "^DBPassword=" "$CONFIG_FILE" | cut -d'=' -f2)
    
    if [ -n "$db_host" ] && [ -n "$db_name" ] && [ -n "$db_user" ]; then
        # データベース接続テスト
        if mysql -h "$db_host" -u "$db_user" -p"$db_password" -e "SELECT 1;" "$db_name" >/dev/null 2>&1; then
            log_message "SUCCESS" "Database connection successful"
            echo "- Connection: SUCCESS" >> "$REPORT_FILE"
            
            # データベース統計情報
            echo "### Database Statistics" >> "$REPORT_FILE"
            mysql -h "$db_host" -u "$db_user" -p"$db_password" -e "
                SELECT 
                    ROUND(SUM(data_length + index_length) / 1024 / 1024, 2) AS 'DB Size (MB)',
                    COUNT(*) AS 'Total Tables'
                FROM information_schema.tables 
                WHERE table_schema='$db_name';" "$db_name" >> "$REPORT_FILE"
            
            # 接続数情報
            echo "### Connection Information" >> "$REPORT_FILE"
            mysql -h "$db_host" -u "$db_user" -p"$db_password" -e "
                SHOW STATUS LIKE 'Threads_connected';
                SHOW STATUS LIKE 'Max_used_connections';
                SHOW VARIABLES LIKE 'max_connections';" >> "$REPORT_FILE"
            
        else
            log_message "ERROR" "Database connection failed"
            echo "- Connection: FAILED" >> "$REPORT_FILE"
        fi
    else
        log_message "ERROR" "Database configuration parameters not found"
        echo "- Configuration: INCOMPLETE" >> "$REPORT_FILE"
    fi
}

# ネットワーク接続確認
check_network_connectivity() {
    log_message "INFO" "Checking network connectivity..."
    
    echo "## Network Connectivity" >> "$REPORT_FILE"
    
    # ポート使用状況確認
    echo "### Port Usage" >> "$REPORT_FILE"
    
    # Zabbixサーバーポート確認
    if netstat -ln | grep -q ":10051.*LISTEN"; then
        log_message "SUCCESS" "Zabbix server port 10051 is listening"
        echo "- Server Port 10051: LISTENING" >> "$REPORT_FILE"
    else
        log_message "ERROR" "Zabbix server port 10051 is not listening"
        echo "- Server Port 10051: NOT LISTENING" >> "$REPORT_FILE"
    fi
    
    # Zabbixエージェントポート確認
    if netstat -ln | grep -q ":10050.*LISTEN"; then
        log_message "SUCCESS" "Zabbix agent port 10050 is listening"
        echo "- Agent Port 10050: LISTENING" >> "$REPORT_FILE"
    else
        log_message "WARNING" "Zabbix agent port 10050 is not listening"
        echo "- Agent Port 10050: NOT LISTENING" >> "$REPORT_FILE"
    fi
    
    # 全ポート使用状況
    echo "### Active Zabbix Ports" >> "$REPORT_FILE"
    netstat -ln | grep -E ":(10050|10051)" >> "$REPORT_FILE"
    
    # エージェント接続テスト
    echo "### Agent Connectivity Test" >> "$REPORT_FILE"
    if command -v zabbix_get >/dev/null; then
        local agent_test=$(zabbix_get -s localhost -k agent.ping 2>&1)
        if [ "$agent_test" = "1" ]; then
            log_message "SUCCESS" "Local agent connectivity test passed"
            echo "- Local Agent Test: SUCCESS" >> "$REPORT_FILE"
        else
            log_message "WARNING" "Local agent connectivity test failed"
            echo "- Local Agent Test: FAILED" >> "$REPORT_FILE"
            echo "- Error: $agent_test" >> "$REPORT_FILE"
        fi
    else
        log_message "WARNING" "zabbix_get command not available"
        echo "- Agent Test: TOOL NOT AVAILABLE" >> "$REPORT_FILE"
    fi
}

# ログファイル解析
analyze_log_files() {
    log_message "INFO" "Analyzing Zabbix log files..."
    
    echo "## Log File Analysis" >> "$REPORT_FILE"
    
    # Zabbixサーバーログ解析
    local server_log="/var/log/zabbix/zabbix_server.log"
    if [ -f "$server_log" ]; then
        echo "### Server Log Analysis" >> "$REPORT_FILE"
        
        # 最近のエラー
        echo "#### Recent Errors (Last 24 hours)" >> "$REPORT_FILE"
        grep -i error "$server_log" | tail -20 >> "$REPORT_FILE"
        
        # 警告メッセージ
        echo "#### Recent Warnings (Last 100 lines)" >> "$REPORT_FILE"
        grep -i warning "$server_log" | tail -10 >> "$REPORT_FILE"
        
        # データベース関連エラー
        echo "#### Database Related Issues" >> "$REPORT_FILE"
        grep -i -E "(database|mysql|postgresql|connection)" "$server_log" | tail -10 >> "$REPORT_FILE"
        
        # 統計情報
        echo "#### Error Statistics (Last 1000 lines)" >> "$REPORT_FILE"
        tail -1000 "$server_log" | grep -c -i error > /tmp/error_count
        tail -1000 "$server_log" | grep -c -i warning > /tmp/warning_count
        echo "- Errors: $(cat /tmp/error_count)" >> "$REPORT_FILE"
        echo "- Warnings: $(cat /tmp/warning_count)" >> "$REPORT_FILE"
        
    else
        log_message "WARNING" "Zabbix server log file not found: $server_log"
        echo "### Server Log" >> "$REPORT_FILE"
        echo "- Status: LOG FILE NOT FOUND" >> "$REPORT_FILE"
    fi
    
    # システムログ確認
    echo "### System Log Analysis" >> "$REPORT_FILE"
    echo "#### Recent Zabbix Related System Messages" >> "$REPORT_FILE"
    journalctl -u zabbix-server --since "1 hour ago" --no-pager | tail -20 >> "$REPORT_FILE"
}

# パフォーマンス分析
analyze_performance() {
    log_message "INFO" "Analyzing system performance..."
    
    echo "## Performance Analysis" >> "$REPORT_FILE"
    
    # システムリソース使用状況
    echo "### Resource Utilization" >> "$REPORT_FILE"
    
    # CPU使用率
    local cpu_usage=$(top -bn1 | grep "Cpu(s)" | awk '{print $2}' | sed 's/%us,//')
    echo "- CPU Usage: ${cpu_usage}%" >> "$REPORT_FILE"
    
    # メモリ使用率
    local mem_info=$(free | grep Mem)
    local total_mem=$(echo $mem_info | awk '{print $2}')
    local used_mem=$(echo $mem_info | awk '{print $3}')
    local mem_usage=$(echo "scale=2; $used_mem * 100 / $total_mem" | bc)
    echo "- Memory Usage: ${mem_usage}%" >> "$REPORT_FILE"
    
    # ディスクI/O
    echo "### Disk I/O Statistics" >> "$REPORT_FILE"
    if command -v iostat >/dev/null; then
        iostat -x 1 3 | tail -10 >> "$REPORT_FILE"
    else
        echo "- iostat not available" >> "$REPORT_FILE"
    fi
    
    # Zabbixプロセス性能
    echo "### Zabbix Process Performance" >> "$REPORT_FILE"
    if pgrep -f zabbix_server > /dev/null; then
        local server_pid=$(pgrep -f zabbix_server)
        echo "#### Server Process Resource Usage" >> "$REPORT_FILE"
        ps -p "$server_pid" -o pid,pcpu,pmem,vsz,rss,etime,cmd >> "$REPORT_FILE"
        
        # プロセス別CPU使用率
        echo "#### Zabbix Process Details" >> "$REPORT_FILE"
        ps aux | grep zabbix | grep -v grep | sort -k3 -nr >> "$REPORT_FILE"
    fi
}

# 問題の特定と推奨事項
identify_issues_and_recommendations() {
    log_message "INFO" "Identifying issues and generating recommendations..."
    
    echo "## Issues Identified and Recommendations" >> "$REPORT_FILE"
    
    local issues=0
    
    # Zabbixサーバープロセス確認
    if ! pgrep -f zabbix_server > /dev/null; then
        echo "### 🚨 CRITICAL: Zabbix Server Not Running" >> "$REPORT_FILE"
        echo "**Recommendation**: Start Zabbix server service immediately" >> "$REPORT_FILE"
        echo "\`\`\`bash" >> "$REPORT_FILE"
        echo "systemctl start zabbix-server" >> "$REPORT_FILE"
        echo "systemctl status zabbix-server" >> "$REPORT_FILE"
        echo "\`\`\`" >> "$REPORT_FILE"
        echo "" >> "$REPORT_FILE"
        issues=$((issues + 1))
    fi
    
    # データベース接続確認
    local db_host=$(grep "^DBHost=" "$CONFIG_FILE" | cut -d'=' -f2)
    local db_name=$(grep "^DBName=" "$CONFIG_FILE" | cut -d'=' -f2)
    local db_user=$(grep "^DBUser=" "$CONFIG_FILE" | cut -d'=' -f2)
    local db_password=$(grep "^DBPassword=" "$CONFIG_FILE" | cut -d'=' -f2)
    
    if [ -n "$db_host" ] && [ -n "$db_name" ] && [ -n "$db_user" ]; then
        if ! mysql -h "$db_host" -u "$db_user" -p"$db_password" -e "SELECT 1;" "$db_name" >/dev/null 2>&1; then
            echo "### 🚨 CRITICAL: Database Connection Failed" >> "$REPORT_FILE"
            echo "**Recommendation**: Check database connectivity and credentials" >> "$REPORT_FILE"
            echo "- Verify database server is running" >> "$REPORT_FILE"
            echo "- Check network connectivity to database" >> "$REPORT_FILE"
            echo "- Verify database credentials in configuration" >> "$REPORT_FILE"
            echo "" >> "$REPORT_FILE"
            issues=$((issues + 1))
        fi
    fi
    
    # ポート確認
    if ! netstat -ln | grep -q ":10051.*LISTEN"; then
        echo "### ⚠️ WARNING: Zabbix Server Port Not Listening" >> "$REPORT_FILE"
        echo "**Recommendation**: Check Zabbix server configuration and firewall" >> "$REPORT_FILE"
        echo "\`\`\`bash" >> "$REPORT_FILE"
        echo "# Check if port is configured correctly" >> "$REPORT_FILE"
        echo "grep ListenPort /etc/zabbix/zabbix_server.conf" >> "$REPORT_FILE"
        echo "# Check firewall rules" >> "$REPORT_FILE"
        echo "firewall-cmd --list-ports" >> "$REPORT_FILE"
        echo "\`\`\`" >> "$REPORT_FILE"
        echo "" >> "$REPORT_FILE"
        issues=$((issues + 1))
    fi
    
    # リソース使用量確認
    local cpu_usage=$(top -bn1 | grep "Cpu(s)" | awk '{print $2}' | sed 's/%us,//')
    if (( $(echo "$cpu_usage > 80" | bc -l) )); then
        echo "### ⚠️ WARNING: High CPU Usage" >> "$REPORT_FILE"
        echo "**Current CPU Usage**: ${cpu_usage}%" >> "$REPORT_FILE"
        echo "**Recommendation**: Investigate high CPU usage" >> "$REPORT_FILE"
        echo "- Check for runaway processes" >> "$REPORT_FILE"
        echo "- Review Zabbix configuration for optimization" >> "$REPORT_FILE"
        echo "- Consider scaling resources" >> "$REPORT_FILE"
        echo "" >> "$REPORT_FILE"
        issues=$((issues + 1))
    fi
    
    # メモリ使用量確認
    local mem_info=$(free | grep Mem)
    local total_mem=$(echo $mem_info | awk '{print $2}')
    local used_mem=$(echo $mem_info | awk '{print $3}')
    local mem_usage=$(echo "scale=2; $used_mem * 100 / $total_mem" | bc)
    
    if (( $(echo "$mem_usage > 85" | bc -l) )); then
        echo "### ⚠️ WARNING: High Memory Usage" >> "$REPORT_FILE"
        echo "**Current Memory Usage**: ${mem_usage}%" >> "$REPORT_FILE"
        echo "**Recommendation**: Investigate memory usage" >> "$REPORT_FILE"
        echo "- Check for memory leaks" >> "$REPORT_FILE"
        echo "- Review Zabbix cache settings" >> "$REPORT_FILE"
        echo "- Consider adding more RAM" >> "$REPORT_FILE"
        echo "" >> "$REPORT_FILE"
        issues=$((issues + 1))
    fi
    
    # ディスク使用量確認
    local disk_usage=$(df / | awk 'NR==2 {print $5}' | sed 's/%//')
    if [ "$disk_usage" -gt 90 ]; then
        echo "### 🚨 CRITICAL: Low Disk Space" >> "$REPORT_FILE"
        echo "**Current Disk Usage**: ${disk_usage}%" >> "$REPORT_FILE"
        echo "**Recommendation**: Free up disk space immediately" >> "$REPORT_FILE"
        echo "- Clean up old log files" >> "$REPORT_FILE"
        echo "- Archive old monitoring data" >> "$REPORT_FILE"
        echo "- Check for large temporary files" >> "$REPORT_FILE"
        echo "" >> "$REPORT_FILE"
        issues=$((issues + 1))
    fi
    
    # 総合評価
    echo "### Summary" >> "$REPORT_FILE"
    if [ $issues -eq 0 ]; then
        echo "✅ **Overall Status**: HEALTHY" >> "$REPORT_FILE"
        echo "No critical issues detected. System appears to be running normally." >> "$REPORT_FILE"
        log_message "SUCCESS" "No critical issues detected"
    elif [ $issues -le 2 ]; then
        echo "⚠️ **Overall Status**: ATTENTION REQUIRED" >> "$REPORT_FILE"
        echo "Some issues detected that require attention. Please review recommendations above." >> "$REPORT_FILE"
        log_message "WARNING" "$issues issues detected requiring attention"
    else
        echo "🚨 **Overall Status**: CRITICAL" >> "$REPORT_FILE"
        echo "Multiple critical issues detected. Immediate action required." >> "$REPORT_FILE"
        log_message "ERROR" "$issues critical issues detected"
    fi
    
    echo "**Total Issues Found**: $issues" >> "$REPORT_FILE"
}

# レポート最終化
finalize_report() {
    echo "" >> "$REPORT_FILE"
    echo "---" >> "$REPORT_FILE"
    echo "**Report Generated**: $(date)" >> "$REPORT_FILE"
    echo "**Script Version**: $VERSION" >> "$REPORT_FILE"
    echo "**Log File**: $LOG_FILE" >> "$REPORT_FILE"
    
    log_message "INFO" "Diagnostic report saved to: $REPORT_FILE"
    log_message "INFO" "Detailed logs saved to: $LOG_FILE"
}

# メイン実行関数
main() {
    local mode="${1:-full}"
    
    echo "Zabbix Diagnostic Tool v$VERSION"
    echo "=================================="
    echo ""
    
    log_message "INFO" "Starting Zabbix diagnostic (mode: $mode)..."
    
    case "$mode" in
        "quick")
            check_zabbix_processes
            check_database_connectivity
            identify_issues_and_recommendations
            ;;
        "config")
            verify_configuration
            ;;
        "network")
            check_network_connectivity
            ;;
        "performance")
            analyze_performance
            ;;
        "logs")
            analyze_log_files
            ;;
        "full"|*)
            collect_system_info
            check_zabbix_processes
            verify_configuration
            check_database_connectivity
            check_network_connectivity
            analyze_log_files
            analyze_performance
            identify_issues_and_recommendations
            ;;
    esac
    
    finalize_report
    
    echo ""
    echo "Diagnostic completed. Report available at: $REPORT_FILE"
    
    # レポート表示（オプション）
    if [ "${2:-}" = "--show" ]; then
        echo ""
        echo "=== DIAGNOSTIC REPORT ==="
        cat "$REPORT_FILE"
    fi
}

# ヘルプ表示
show_help() {
    echo "Zabbix Diagnostic Tool v$VERSION"
    echo ""
    echo "USAGE:"
    echo "  $0 [mode] [options]"
    echo ""
    echo "MODES:"
    echo "  full        Full diagnostic (default)"
    echo "  quick       Quick health check"
    echo "  config      Configuration verification only"
    echo "  network     Network connectivity check"
    echo "  performance Performance analysis"
    echo "  logs        Log file analysis"
    echo ""
    echo "OPTIONS:"
    echo "  --show      Display report after generation"
    echo "  --help      Show this help message"
    echo ""
    echo "EXAMPLES:"
    echo "  $0                    # Full diagnostic"
    echo "  $0 quick --show       # Quick check with report display"
    echo "  $0 performance        # Performance analysis only"
}

# スクリプト実行
if [ "${1:-}" = "--help" ] || [ "${1:-}" = "-h" ]; then
    show_help
    exit 0
fi

main "$@"

#!/bin/bash
# Zabbix起動問題自動解決スクリプト

SERVICE_NAME="zabbix-server"
CONFIG_FILE="/etc/zabbix/zabbix_server.conf"
LOG_FILE="/var/log/zabbix/startup_fix.log"

# ログ関数
log_fix() {
    echo "[$(date '+%Y-%m-%d %H:%M:%S')] $1" | tee -a "$LOG_FILE"
}

# 起動問題診断・修復
fix_startup_issues() {
    log_fix "Starting Zabbix startup issue diagnosis..."
    
    # 1. サービス状態確認
    local service_status=$(systemctl is-active "$SERVICE_NAME")
    local service_enabled=$(systemctl is-enabled "$SERVICE_NAME")
    
    log_fix "Service status: $service_status"
    log_fix "Service enabled: $service_enabled"
    
    if [ "$service_status" != "active" ]; then
        log_fix "Service is not active, attempting fixes..."
        
        # 2. 設定ファイル検証・修復
        if ! zabbix_server -t >/dev/null 2>&1; then
            log_fix "Configuration file has errors, attempting to fix..."
            
            # バックアップから復旧
            if [ -f "${CONFIG_FILE}.backup" ]; then
                log_fix "Restoring from backup configuration..."
                cp "${CONFIG_FILE}.backup" "$CONFIG_FILE"
                
                if zabbix_server -t >/dev/null 2>&1; then
                    log_fix "Configuration restored successfully from backup"
                else
                    log_fix "Backup configuration also has errors"
                fi
            fi
            
            # 基本的な設定エラー修正
            fix_common_config_errors
        fi
        
        # 3. 権限問題修復
        fix_permission_issues
        
        # 4. リソース問題確認・修復
        fix_resource_issues
        
        # 5. データベース接続問題修復
        fix_database_connectivity
        
        # 6. サービス再起動試行
        log_fix "Attempting to restart Zabbix server..."
        systemctl restart "$SERVICE_NAME"
        
        # 起動確認
        sleep 5
        if systemctl is-active "$SERVICE_NAME" >/dev/null; then
            log_fix "✓ Zabbix server started successfully"
            return 0
        else
            log_fix "✗ Zabbix server failed to start"
            
            # 詳細エラー情報収集
            log_fix "Error details:"
            journalctl -u "$SERVICE_NAME" --since "1 minute ago" --no-pager | tail -10 | while read line; do
                log_fix "  $line"
            done
            
            return 1
        fi
    else
        log_fix "✓ Zabbix server is already running"
        return 0
    fi
}

# 設定ファイル基本エラー修正
fix_common_config_errors() {
    log_fix "Fixing common configuration errors..."
    
    # 重複パラメータ削除
    awk '!seen[$0]++' "$CONFIG_FILE" > "${CONFIG_FILE}.tmp" && mv "${CONFIG_FILE}.tmp" "$CONFIG_FILE"
    
    # 無効な文字削除
    sed -i 's/[[:cntrl:]]//g' "$CONFIG_FILE"
    
    # 基本パラメータ確認・追加
    if ! grep -q "^LogFile=" "$CONFIG_FILE"; then
        echo "LogFile=/var/log/zabbix/zabbix_server.log" >> "$CONFIG_FILE"
        log_fix "Added missing LogFile parameter"
    fi
    
    if ! grep -q "^PidFile=" "$CONFIG_FILE"; then
        echo "PidFile=/run/zabbix/zabbix_server.pid" >> "$CONFIG_FILE"
        log_fix "Added missing PidFile parameter"
    fi
    
    # 設定テスト
    if zabbix_server -t >/dev/null 2>&1; then
        log_fix "Configuration errors fixed"
    else
        log_fix "Configuration still has errors"
    fi
}

# 権限問題修復
fix_permission_issues() {
    log_fix "Fixing permission issues..."
    
    # ディレクトリ作成・権限設定
    mkdir -p /var/log/zabbix
    mkdir -p /run/zabbix
    
    chown zabbix:zabbix /var/log/zabbix
    chown zabbix:zabbix /run/zabbix
    
    chmod 755 /var/log/zabbix
    chmod 755 /run/zabbix
    
    # 設定ファイル権限
    chown root:zabbix "$CONFIG_FILE"
    chmod 640 "$CONFIG_FILE"
    
    # SELinux設定確認
    if command -v getenforce >/dev/null && [ "$(getenforce)" = "Enforcing" ]; then
        log_fix "Checking SELinux settings..."
        
        # SELinuxコンテキスト復旧
        restorecon -R /var/log/zabbix
        restorecon -R /run/zabbix
        restorecon "$CONFIG_FILE"
        
        # 必要なSELinuxポリシー設定
        setsebool -P zabbix_can_network on 2>/dev/null || true
        setsebool -P httpd_can_network_connect on 2>/dev/null || true
    fi
    
    log_fix "Permission issues fixed"
}

# リソース問題修復
fix_resource_issues() {
    log_fix "Checking and fixing resource issues..."
    
    # ディスク容量確認
    local disk_usage=$(df /var | awk 'NR==2 {print $5}' | sed 's/%//')
    if [ "$disk_usage" -gt 95 ]; then
        log_fix "Critical disk space issue detected (${disk_usage}%)"
        
        # ログローテーション強制実行
        logrotate -f /etc/logrotate.conf
        
        # 古いログファイル削除
        find /var/log -name "*.log.*" -mtime +7 -delete
        
        log_fix "Disk space cleanup completed"
    fi
    
    # メモリ確認
    local mem_available=$(free | grep Available | awk '{print $2}')
    if [ "$mem_available" -lt 1048576 ]; then  # 1GB未満
        log_fix "Low memory detected, clearing cache..."
        sync && echo 3 > /proc/sys/vm/drop_caches
    fi
    
    # ulimit設定確認
    local current_limit=$(ulimit -n)
    if [ "$current_limit" -lt 4096 ]; then
        log_fix "Increasing file descriptor limit..."
        echo "zabbix soft nofile 65536" >> /etc/security/limits.conf
        echo "zabbix hard nofile 65536" >> /etc/security/limits.conf
    fi
}

# データベース接続修復
fix_database_connectivity() {
    log_fix "Checking database connectivity..."
    
    # データベース設定取得
    local db_host=$(grep "^DBHost=" "$CONFIG_FILE" | cut -d'=' -f2)
    local db_name=$(grep "^DBName=" "$CONFIG_FILE" | cut -d'=' -f2)
    local db_user=$(grep "^DBUser=" "$CONFIG_FILE" | cut -d'=' -f2)
    local db_password=$(grep "^DBPassword=" "$CONFIG_FILE" | cut -d'=' -f2)
    
    if [ -n "$db_host" ] && [ -n "$db_name" ] && [ -n "$db_user" ]; then
        # データベース接続テスト
        if ! mysql -h "$db_host" -u "$db_user" -p"$db_password" -e "SELECT 1;" "$db_name" >/dev/null 2>&1; then
            log_fix "Database connection failed, attempting fixes..."
            
            # データベースサービス確認・起動
            if systemctl is-active mysql >/dev/null || systemctl is-active mariadb >/dev/null; then
                log_fix "Database service is running"
            else
                log_fix "Starting database service..."
                systemctl start mysql 2>/dev/null || systemctl start mariadb 2>/dev/null
                sleep 3
            fi
            
            # 再接続テスト
            if mysql -h "$db_host" -u "$db_user" -p"$db_password" -e "SELECT 1;" "$db_name" >/dev/null 2>&1; then
                log_fix "✓ Database connection restored"
            else
                log_fix "✗ Database connection still failing"
                
                # ネットワーク接続確認
                if [ "$db_host" != "localhost" ] && [ "$db_host" != "127.0.0.1" ]; then
                    if ! ping -c 1 "$db_host" >/dev/null 2>&1; then
                        log_fix "Network connectivity to database host failed"
                    fi
                fi
            fi
        else
            log_fix "✓ Database connection is working"
        fi
    else
        log_fix "Database configuration parameters missing"
    fi
}

# メイン実行
main() {
    echo "Zabbix Startup Issue Resolver"
    echo "============================="
    
    if fix_startup_issues; then
        echo "✓ Zabbix startup issues resolved successfully"
        exit 0
    else
        echo "✗ Failed to resolve all startup issues"
        echo "Check log file: $LOG_FILE"
        exit 1
    fi
}

# スクリプト実行
main "$@"