hmmm, not sure. Maybe your timing is mismatched?
setTimer(function ()
local mysqlResource = getResourceFromName ( "mysql" )
if getResourceState(mysqlResource) == "running" then
local con = call ( mysqlResource, "getConnection")
iprint("connection", con)
else
iprint("running state", getResourceState(mysqlResource))
end
end, 1000, 1)
This is how I handle MySQL failures:
function connectMysql()
con = dbConnect( "mysql", "dbname="..dbname..";host="..host..";charset=utf8", username, password, "share=1" );
if (con) then
outputChatBox("#FFFFFFMySQL connection#00AA00 successful#FFFFFF!", root, 0, 0, 0, true);
return true
end
return false
end
addEventHandler("onResourceStart", resourceRoot,
function ()
if not connectMysql() then
cancelEvent (true, "Can't connect to MySQL server" )
end
end)