[HELP] SQL Error/Login

[AndrewC]

I have a connection.lua script for connecting to the Database, hosted on a web server. The connection is not correct, because it can't query anyything (MTA Server) and the login GUI won't create accounts. Any ideas? I know that the connection details are correct, except possibly the hostname. I can post the connection.lua code if you'd like. If you want anything, please post on this forum, as I'd really appreciate any help.

Andrew

[xXMADEXx]

Show your code.

[AndrewC]

Show your code.

Connection.lua:

-- connection settings 
local hostname = get( "hostname" ) or "198.57.247.179" 
local username = get( "username" ) or "dbuser" 
local password = get( "password" ) or "*******" 
local database = get( "database" ) or "db" 
local port = tonumber( get( "port" ) ) or 3306 
  
-- external mysql connection settings 
local externalhostname = "198.57.247.179" 
local externalusername = "dbuser (same as above)" 
local externalpassword = "*********" 
local externaldatabase = "(same as above)" 
local externalport = 3306 
  
-- global things 
local MySQLConnection = nil 
local forumConnection = nil 
local resultPool = { } 
local queryPool = { } 
local sqllog = false 
local countqueries = 0 
  
--Debug 
function tellMeMySQLStates(thePlayer) 
    if exports.global:isPlayerScripter(thePlayer) then 
        if forumConnection then 
            if mysql_ping(forumConnection) then 
                outputChatBox("Forum Connection is online.", thePlayer, 0, 255, 0) 
            else 
                outputChatBox("Main DB is offline.", thePlayer, 255, 0, 0) 
            end 
        else 
            outputChatBox("Forum Connection is offline.", thePlayer, 255, 0, 0) 
        end 
        if MySQLConnection then 
            if mysql_ping(MySQLConnection) then 
                outputChatBox("Main DB is online.", thePlayer, 0, 255, 0) 
            else 
                outputChatBox("Main DB is offline.", thePlayer, 255, 0, 0) 
            end 
        else 
            outputChatBox("Main DB is offline.", thePlayer, 255, 0, 0) 
        end 
    end 
end 
addCommandHandler("testdb", tellMeMySQLStates, false, false) 
  
--Forum settings 
function openForumDatabase(res) 
    forumConnection = mysql_connect(externalhostname, externalusername, externalpassword, externaldatabase, externalport) 
    if (not forumConnection) then 
        if (res == getThisResource()) then 
            outputDebugString("Cannot connect to the forum database.") 
        end 
        return nil 
    end 
    return nil 
end 
addEventHandler("onResourceStart", getResourceRootElement(getThisResource()), openForumDatabase, false) 
  
function destroyForumConnection() 
    if (not forumConnection) then 
        return nil 
    end 
    mysql_close(forumConnection) 
    return nil 
end 
addEventHandler("onResourceStop", getResourceRootElement(getThisResource()), destroyForumConnection, false) 
  
function forumPing() 
    if (mysql_ping(forumConnection) == false) then 
        -- FUU, NO MOAR CONNECTION 
        destroyForumConnection() 
        openForumDatabase(nil) 
        if (mysql_ping(forumConnection) == false) then 
            logForumSQLError() 
            return false 
        end 
        return true 
    end 
  
    return true 
end 
  
function forumQuery(str) 
    if sqllog then 
        exports['logs']:logMessage(str, 24) 
    end 
    countqueries = countqueries + 1 
     
    if (forumPing()) then 
        local result = mysql_query(forumConnection, str) 
        if (not result) then 
            logForumSQLError(str) 
            return false 
        end 
  
        local resultid = getFreeResultPoolID() 
        resultPool[resultid] = result 
        queryPool[resultid] = str 
        return resultid 
    end 
    return false 
end 
  
function forum_query_insert_free(str) 
    local queryresult = forumQuery(str) 
    if  not (queryresult == false) then 
        local result = forum_insert_id() 
        free_result(queryresult) 
        return result 
    end 
    return false 
end 
  
function forum_insert_id() 
    return mysql_insert_id(forumConnection) or false 
end 
  
function forum_query_free(str) 
    local queryresult = forumQuery(str) 
    if  not (queryresult == false) then 
        free_result(queryresult) 
        return true 
    end 
    return false 
end 
  
function forum_query_fetch_assoc(str) 
    local queryresult = forumQuery(str) 
    if  not (queryresult == false) then 
        local result = fetch_assoc(queryresult) 
        free_result(queryresult) 
        return result 
    end 
    return false 
end 
--End Forum 
  
-- connectToDatabase - Internal function, to spawn a DB connection 
function connectToDatabase(res) 
    MySQLConnection = mysql_connect(hostname, username, password, database, port) 
     
    if (not MySQLConnection) then 
        if (res == getThisResource()) then 
            cancelEvent(true, "Cannot connect to the database.") 
        end 
        return nil 
    end 
     
    return nil 
end 
addEventHandler("onResourceStart", getResourceRootElement(getThisResource()), connectToDatabase, false) 
     
-- destroyDatabaseConnection - Internal function, kill the connection if theres one. 
function destroyDatabaseConnection() 
    if (not MySQLConnection) then 
        return nil 
    end 
    mysql_close(MySQLConnection) 
    return nil 
end 
addEventHandler("onResourceStop", getResourceRootElement(getThisResource()), destroyDatabaseConnection, false) 
  
-- do something usefull here 
function logSQLError(str) 
    local message = str or 'N/A' 
    outputDebugString("MYSQL ERROR "..mysql_errno(MySQLConnection) .. ": " .. mysql_error(MySQLConnection)) 
    exports['logs']:logMessage("MYSQL ERROR [QUERY] " .. message .. " [ERROR] " .. mysql_errno(MySQLConnection) .. ": " .. mysql_error(MySQLConnection), 24) 
end 
  
function logForumSQLError(str) 
    local message = str or 'N/A' 
    outputDebugString("MYSQL ERROR "..mysql_errno(forumConnection) .. ": " .. mysql_error(forumConnection)) 
    exports['logs']:logMessage("MYSQL ERROR [QUERY] " .. message .. " [ERROR] " .. mysql_errno(forumConnection) .. ": " .. mysql_error(forumConnection), 24) 
end 
  
function getFreeResultPoolID() 
    local size = #resultPool 
    if (size == 0) then 
        return 1  
    end 
    for index, query in ipairs(resultPool) do 
        if (query == nil) then 
            return index 
        end 
    end 
    return (size + 1) 
end 
  
------------ EXPORTED FUNCTIONS --------------- 
  
function ping() 
    if (mysql_ping(MySQLConnection) == false) then 
        -- FUU, NO MOAR CONNECTION 
        destroyDatabaseConnection() 
        connectToDatabase(nil) 
        if (mysql_ping(MySQLConnection) == false) then 
            logSQLError() 
            return false 
        end 
        return true 
    end 
  
    return true 
end 
  
function escape_string(str) 
    if (ping()) then 
        return mysql_escape_string(MySQLConnection, str) 
    end 
    return false 
end 
  
function query(str) 
    if sqllog then 
        exports['logs']:logMessage(str, 24) 
    end 
    countqueries = countqueries + 1 
     
    if (ping()) then 
        local result = mysql_query(MySQLConnection, str) 
        if (not result) then 
            logSQLError(str) 
            return false 
        end 
  
        local resultid = getFreeResultPoolID() 
        resultPool[resultid] = result 
        queryPool[resultid] = str 
        return resultid 
    end 
    return false 
end 
  
function unbuffered_query(str) 
    if sqllog then 
        exports['logs']:logMessage(str, 24) 
    end 
    countqueries = countqueries + 1 
     
    if (ping()) then 
        local result = mysql_unbuffered_query(MySQLConnection, str) 
        if (not result) then 
            logSQLError(str) 
            return false 
        end 
  
        local resultid = getFreeResultPoolID() 
        resultPool[resultid] = result 
        queryPool[resultid] = str 
        return resultid 

[xXMADEXx]

We don't help with stolen scripts.