Troubleshooting Guide

Common issues and solutions for container management

Installation Issues

Problem: Docker containers won't start

Containers fail to start or exit immediately after starting.

Solutions:

  1. Check port conflicts:
    docker ps -a ss -tulpn | grep :8181
  2. Review container logs:
    docker logs ai_container_apache docker logs ai_container_mysql
  3. Restart containers:
    docker-compose down docker-compose up -d
  4. Check disk space:
    df -h docker system df

Database Issues

Problem: Database connection failed

Application cannot connect to MySQL database.

Solutions:

  1. Verify MySQL container status:
    docker ps | grep mysql docker logs ai_container_mysql
  2. Test database connection:
    docker exec ai_container_mysql mysql -u root -pulik9910 -e "SHOW DATABASES;"
  3. Check network connectivity:
    docker network ls docker inspect docker_ai_container_network
  4. Recreate database if needed:
    docker exec ai_container_mysql mysql -u root -pulik9910 < sql/init.sql

Problem: Tables don't exist

Database exists but tables are missing.

Solutions:

  1. Run initialization script:
    docker cp sql/init.sql ai_container_mysql:/tmp/init.sql docker exec ai_container_mysql mysql -u root -pulik9910 -e "SOURCE /tmp/init.sql;"
  2. Verify tables created:
    docker exec ai_container_mysql mysql -u root -pulik9910 ai_container_manager -e "SHOW TABLES;"

SSH Connection Issues

Problem: Cannot connect to container via SSH

SSH connection test fails when registering containers.

Solutions:

  1. Check network connectivity:
    ping target-container-ip telnet target-container-ip 22
  2. Verify SSH service on target:
    ssh user@target-container-ip systemctl status ssh
  3. Check firewall settings:
    ufw status iptables -L
  4. Verify credentials:
    • Ensure username and password are correct
    • Check if root login is enabled
    • Verify SSH key authentication if used

AI Chat Issues

Problem: AI chat not responding

Chat interface shows but AI doesn't respond to messages.

Solutions:

  1. Check GPT API key:
    curl -s -o /dev/null -w "%{http_code}" http://localhost:8181/api/check-api-status.php
  2. Verify API endpoint:
    curl -X POST http://localhost:8181/api/chat.php \ -H "Content-Type: application/json" \ -d '{"message":"test","user_type":"frontend"}'
  3. Check chat session creation:
    docker exec ai_container_mysql mysql -u root -pulik9910 ai_container_manager -e "SELECT * FROM chat_sessions LIMIT 5;"
  4. Review JavaScript console:

    Open browser developer tools and check for JavaScript errors

Authentication Issues

Problem: Cannot login to admin panel

Admin login page rejects valid credentials.

Solutions:

  1. Verify admin user exists:
    docker exec ai_container_mysql mysql -u root -pulik9910 ai_container_manager -e "SELECT username FROM admin_users;"
  2. Reset admin password:
    docker exec ai_container_mysql mysql -u root -pulik9910 ai_container_manager -e "UPDATE admin_users SET password_hash = '\$2y\$10\$92IXUNpkjO0rOQ5byMi.Ye4oKoEa3Ro9llC/.og/at2.uheWG/igi' WHERE username = 'jeff';"
  3. Check session configuration:

    Ensure PHP sessions are working properly

  4. Clear browser cache:

    Clear cookies and local storage for the site

Performance Issues

Problem: Slow page loading

Application takes too long to load or respond.

Solutions:

  1. Check system resources:
    docker stats htop free -h
  2. Optimize database:
    docker exec ai_container_mysql mysql -u root -pulik9910 ai_container_manager -e "OPTIMIZE TABLE managed_containers;"
  3. Review error logs:
    docker logs ai_container_apache --tail 50 tail -f /var/log/apache2/error.log
  4. Check container limits:

    Ensure containers have adequate CPU and memory limits

General Debugging

Useful Commands for Troubleshooting:

# Check all container status docker-compose ps # View all container logs docker-compose logs # Restart specific service docker-compose restart apache-php # Enter container for debugging docker exec -it ai_container_apache bash # Check database connectivity docker exec ai_container_mysql mysqladmin -u root -pulik9910 ping # Monitor real-time logs docker-compose logs -f # Check container resource usage docker stats --no-stream # Inspect network configuration docker network inspect docker_ai_container_network
Important Notes:
  • Always backup your data before making significant changes
  • Keep container logs for debugging purposes
  • Monitor system resources during peak usage
  • Regularly update container images for security

Getting Additional Help

  • Use the AI chat assistant for real-time troubleshooting guidance
  • Check container logs for detailed error messages
  • Review the configuration guide for advanced settings
  • Consult Docker documentation for container-specific issues
  • Monitor system metrics for performance-related problems