🛠️ Troubleshooting Guide

# Check server status
sudo systemctl status fivem
 
# View recent logs
tail -f /path/to/server/logs/server.log
 
# Check resource status in server console
resmon
status
 
# Test database connection
mysql -u username -p -h localhost qbcore

# Check configuration syntax
cat server.cfg | grep -E "^(ensure|start)"
 
# Verify port availability
netstat -tuln | grep 30120
 
# Check file permissions
ls -la /path/to/server/

# In FiveM console
restart resource-name
ensure resource-name
refresh
resmon

-- Test database connection
mysql -u qbuser -p qbcore
 
-- Check connection limits
SHOW VARIABLES LIKE 'max_connections';
SHOW STATUS LIKE 'Connections';
 
-- Verify user permissions
SELECT User, Host FROM mysql.user WHERE User = 'qbuser';

# Resource monitoring
resmon                  # Resource usage stats
status                  # Server and player status
citizens               # Player list and IDs
 
# Resource management
start resource-name     # Start a resource
stop resource-name      # Stop a resource
restart resource-name   # Restart a resource
refresh                # Refresh resource cache
 
# Debugging
strdbg                 # String debugging info
rdrdbg                 # Render debugging

-- Server health check resource
RegisterCommand('healthcheck', function(source, args, rawCommand)
    if source ~= 0 then return end -- Console only
    
    print("^2=== QBCore Health Check ===^7")
    
    -- Check QBCore status
    local qbCore = exports['qb-core']:GetCoreObject()
    if qbCore then
        print("^2✓^7 QBCore loaded successfully")
    else
        print("^1✗^7 QBCore not loaded")
    end
    
    -- Check database connection
    local success = pcall(function()
        MySQL.query.await('SELECT 1', {})
    end)
    
    if success then
        print("^2✓^7 Database connection OK")
    else
        print("^1✗^7 Database connection failed")
    end
    
    -- Check player count
    local playerCount = #GetPlayers()
    print("^3ℹ^7 Players online: " .. playerCount)
    
    -- Check resource status
    local resources = {'qb-core', 'qb-multicharacter', 'qb-spawn', 'qb-inventory'}
    for _, resource in ipairs(resources) do
        local state = GetResourceState(resource)
        if state == 'started' then
            print("^2✓^7 " .. resource .. " - " .. state)
        else
            print("^1✗^7 " .. resource .. " - " .. state)
        end
    end
    
    print("^2=== Health Check Complete ===^7")
end, true)

# In server console
resmon
 
# Look for resources using high CPU/memory
# Check for infinite loops or excessive threading

-- Check slow queries
SHOW PROCESSLIST;
 
-- Check for long-running queries
SELECT * FROM information_schema.processlist 
WHERE time > 30;
 
-- Review slow query log
SHOW VARIABLES LIKE 'slow_query_log%';

# System monitoring
htop
iostat -x 1
netstat -i
 
# Check disk space
df -h
 
# Check memory usage
free -h

# Check port accessibility
nmap -p 30120 your-server-ip
 
# Test from client machine
telnet your-server-ip 30120

# Check firewall rules
sudo ufw status
sudo iptables -L
 
# Common ports needed
# 30120/tcp - FiveM server
# 30120/udp - FiveM server

# Verify server.cfg settings
sv_maxclients 128
sv_hostname "Your Server Name"
endpoint_add_tcp "0.0.0.0:30120"
endpoint_add_udp "0.0.0.0:30120"

# Test basic connection
mysql -u qbuser -p -h localhost qbcore
 
# Test from application
mysql -u qbuser -p -h localhost -e "SELECT VERSION();"

-- Check user permissions
SHOW GRANTS FOR 'qbuser'@'%';
SHOW GRANTS FOR 'qbuser'@'localhost';
 
-- Grant necessary permissions if missing
GRANT ALL PRIVILEGES ON qbcore.* TO 'qbuser'@'%';
FLUSH PRIVILEGES;

-- Check for table locks
SHOW OPEN TABLES WHERE In_use > 0;
 
-- Analyze table performance
EXPLAIN SELECT * FROM players WHERE citizenid = 'ABC123';
 
-- Check index usage
SHOW INDEX FROM players;

-- Memory monitoring script
local memoryStats = {}
 
CreateThread(function()
    while true do
        Wait(30000) -- Check every 30 seconds
        
        local currentMem = collectgarbage("count")
        table.insert(memoryStats, {
            timestamp = os.time(),
            memory = currentMem
        })
        
        -- Keep only last hour of data
        if #memoryStats > 120 then
            table.remove(memoryStats, 1)
        end
        
        -- Check for potential memory leak
        if #memoryStats >= 10 then
            local oldMem = memoryStats[#memoryStats - 9].memory
            local growth = currentMem - oldMem
            
            if growth > 10240 then -- 10MB growth in 5 minutes
                print("^1[WARNING] Potential memory leak detected. Growth: " .. 
                      math.floor(growth/1024) .. "MB in 5 minutes^7")
            end
        end
    end
end)
 
-- Export memory stats
RegisterNetEvent('debug:getMemoryStats', function()
    TriggerClientEvent('debug:receiveMemoryStats', source, memoryStats)
end)

-- Check for conflicting exports
RegisterCommand('checkconflicts', function()
    local resources = {}
    local conflicts = {}
    
    for i = 0, GetNumResources() - 1 do
        local resource = GetResourceByFindIndex(i)
        if GetResourceState(resource) == 'started' then
            local metadata = GetResourceMetadata(resource, 'exports', 0)
            if metadata then
                for export in metadata:gmatch('([^,]+)') do
                    export = export:trim()
                    if resources[export] then
                        table.insert(conflicts, {
                            export = export,
                            resources = {resources[export], resource}
                        })
                    else
                        resources[export] = resource
                    end
                end
            end
        end
    end
    
    if #conflicts > 0 then
        print("^1Export conflicts detected:^7")
        for _, conflict in ipairs(conflicts) do
            print("  " .. conflict.export .. " - " .. table.concat(conflict.resources, ", "))
        end
    else
        print("^2No export conflicts detected^7")
    end
end, true)

Error: ER_NO_SUCH_TABLE: Table 'qbcore.players' doesn't exist
Error: ER_ACCESS_DENIED_ERROR: Access denied for user 'qbuser'@'localhost'

Error loading script server/main.lua in resource qb-example: 
syntax error near 'end'

Failed to establish connection to 127.0.0.1:3306
Connection refused (os error 111)

#!/bin/bash
# log-monitor.sh
 
LOG_FILE="/path/to/server/logs/server.log"
ALERT_EMAIL="admin@yourserver.com"
 
tail -F "$LOG_FILE" | while read line; do
    # Check for critical errors
    if echo "$line" | grep -E "(ERROR|CRITICAL|FATAL)" > /dev/null; then
        echo "$(date): ALERT - $line" >> /tmp/server_alerts.log
        
        # Send email alert for critical issues
        if echo "$line" | grep -E "(FATAL|database.*error)" > /dev/null; then
            echo "Critical server error detected: $line" | mail -s "Server Alert" "$ALERT_EMAIL"
        fi
    fi
    
    # Check for memory warnings
    if echo "$line" | grep "memory.*high\|out of memory" > /dev/null; then
        echo "$(date): MEMORY WARNING - $line" >> /tmp/server_alerts.log
    fi
done