Jump to content

Suporte Failed connecting to database - MYSQL ERROR: Can't connect to MySQL server on 'localhost' (10061) (2003)


Recommended Posts

 

Peguei uma base pra por on e editar umas coisas e olha o que aparece

 

[24/05/2022 23:20:42] Pokemon Dash Advanced, version 0.3.6 (PDA)
[24/05/2022 23:20:42] Compiled with GNU C++ version 4.4.0 at Nov 15 2020, 13:28:38.
[24/05/2022 23:20:42] Matheus alves de toledo.
[24/05/2022 23:20:42] Site Em breve.

[24/05/2022 23:20:42] >> Loading config (config.lua)
[24/05/2022 23:20:42] > Using SHA1 encryption
[24/05/2022 23:20:42] >> Loading RSA key
[24/05/2022 23:20:42] >> Starting SQL connection
[24/05/2022 23:20:43] Failed connecting to database - MYSQL ERROR: Can't connect to MySQL server on 'localhost' (10061) (2003)

[24/05/2022 23:20:43] > ERROR: Couldn't estabilish connection to SQL database!
 

Meu config.lua

accountManager = false
accountManager = false
namelockManager = true
newPlayerChooseVoc = false
newPlayerSpawnPosX = 1007
newPlayerSpawnPosY = 1042
newPlayerSpawnPosZ = 8
newPlayerTownId = 1
newPlayerLevel = 12
newPlayerMagicLevel = 0
generateAccountNumber = false
lightInterval = 7500
lightChange = 1
startupTime = 351
startupLight = 100
limitPokeballs = 6
happyDropTime = 12
minHappinessEffectDelay = 25
maxHappinessEffectDelay = 40
PokemonStageVeryHappy = 215
PokemonStageHappy = 160
PokemonStageOK = 110
PokemonStageSad = 50
PokemonStageMad = 0
maximumHunger = 120
stateHunger = 100
increaseHunger = 7
decreaseHappy = 1
decreaseHungryHappy = 4
useTeleportWithFly = false
dropHappyDuringBattles = true
allowBlockSpawn = false
rateGymSpellInterval = 0.68
redSkullLength = 30 * 24 * 60 * 60
blackSkullLength = 45 * 24 * 60 * 60
dailyFragsToRedSkull = 3
weeklyFragsToRedSkull = 5
monthlyFragsToRedSkull = 10
dailyFragsToBlackSkull = dailyFragsToRedSkull
weeklyFragsToBlackSkull = weeklyFragsToRedSkull
monthlyFragsToBlackSkull = monthlyFragsToRedSkull
dailyFragsToBanishment = dailyFragsToRedSkull
weeklyFragsToBanishment = weeklyFragsToRedSkull
monthlyFragsToBanishment = monthlyFragsToRedSkull
blackSkulledDeathHealth = 40
blackSkulledDeathMana = 0
useBlackSkull = false
useFragHandler = true
advancedFragList = false
notationsToBan = 3
warningsToFinalBan = 4
warningsToDeletion = 5
banLength = 7 * 24 * 60 * 60
killsBanLength = 7 * 24 * 60 * 60
finalBanLength = 30 * 24 * 60 * 60
ipBanishmentLength = 1 * 24 * 60 * 60
broadcastBanishments = false
maxViolationCommentSize = 200
violationNameReportActionType = 2
autoBanishUnknownBytes = false
worldType = "1"
protectionLevel = 1
pvpTileIgnoreLevelAndVocationProtection = true
pzLocked = 18 * 1000
huntingDuration = 60 * 1000
criticalHitChance = 7
criticalHitMultiplier = 1
displayCriticalHitNotify = false
removeWeaponAmmunition = true
removeWeaponCharges = true
removeRuneCharges = true
whiteSkullTime = 15 * 60 * 1000
noDamageToSameLookfeet = false
showHealingDamage = false
showHealingDamageForMonsters = true
fieldOwnershipDuration = 5 * 1000
stopAttackingAtExit = false
oldConditionAccuracy = false
loginProtectionPeriod = 10 * 1000
deathLostPercent = 1
stairhopDelay = 0 * 1000
pushCreatureDelay = 1 * 1000
deathContainerId = 0
addonsOnlyPremium = false
gainExperienceColor = 215
addManaSpentInPvPZone = true
squareColor = 0
allowFightback = true
ip = "127.0.0.1"
bindOnlyConfiguredIpAddress = false
loginPort = 7171
gamePort = 7172
adminPort = 7171
statusPort = 7171
loginTries = 10
retryTimeout = 5 * 1000
loginTimeout = 60 * 1000
maxPlayers = 100
motd = "[BR] Bem-vindo(a) ao PokÔŅĹ naja, por favor logue em seu personagem.\n[EN] Welcome to PokÔŅĹ Naja, please log in your character.\n[ES] Bienvenido(a) a PokÔŅĹ Naja, por favor, acceda a su carÔŅĹcter."
displayOnOrOffAtCharlist = false
onePlayerOnlinePerAccount = false
allowClones = true
serverName = "PokeNaja"
loginMessage = "PokÔŅĹ Naja | Patch Version: 3.1"
statusTimeout = 5 * 60 * 1000
replaceKickOnLogin = true
forceSlowConnectionsToDisconnect = false
loginOnlyWithLoginServer = false
premiumPlayerSkipWaitList = false
sqlType = "mysql"
sqlHost = "localhost"
sqlPort = 3306
sqlUser = "root"
sqlPass = ""
sqlDatabase = "test"
sqlFile = "forgottenserver.s3db"
sqlKeepAlive = 0
sqlRemyadTimeout = 10
mysqlWriteTimeout = 10
encryptionType = "sha1"
deathListEnabled = true
deathListRequiredTime = 1 * 60 * 1000
deathAssistCount = 19
maxDeathRecords = 10
ingameGuildManagement = true
levelToFormGuild = 80
premiumDaysToFormGuild = 0
guildNameMinLength = 2
guildNameMaxLength = 25
highscoreDisplayPlayers = 15
updateHighscoresAfterMinutes = 60
buyableAndSellableHouses = true
houseNeedPremium = true
bedsRequirePremium = true
levelToBuyHouse = 100
housesPerAccount = 1
houseRentAsPrice = false
housePriceAsRent = false
housePriceEachSquare = 19275
houseRentPeriod = "never"
houseCleanOld = 0
guildHalls = false
timeBetweenActions = 500
timeBetweenExActions = 500
hotkeyAimbotEnabled = true
mapName = "PokeNaja"
mapAuthor = "Matheus alves de toledo"
randomizeTiles = true
storeTrash = false
cleanProtectedZones = true
mailboxDisabledTowns = "1"
defaultPriority = "high"
niceLevel = 5
coresUsed = "-1"
optimizedatapackbaseAtStartup = true
removePremiumOnInit = true
confirmOutdatedVersion = false
formulaLevel = 5.0
formulaMagic = 1.0
bufferMutedOnSpellFailure = false
spellNameInsteadOfWords = false
emoteSpells = true
hideSpellWords = false
allowChangeOutfit = true
allowChangeColors = true
allowChangeAddons = true
disableOutfitsForPrivilegedPlayers = false
dataDirectory = "datapack/"
bankSystem = true
displaySkillLevelOnAdvance = false
promptExceptionTracerErrorBox = true
separateViplistPerCharacter = false
maximumDoorLevel = 500
maxMessageBuffer = 4
saveGlobalStorage = false
useHousedatapackStorage = false
storePlayerDirection = false
checkCorpseOwner = true
monsterLootMessage = 3
monsterLootMessageType = 25
ghostModeInvisibleEffect = true
ghostModeSpellEffects = true
idleWarningTime = 14 * 60 * 1000
idleKickTime = 15 * 60 * 1000
expireReportsAfterReads = 1
playerQueryDeepness = 2
maxItemsPerPZTile = 0
maxItemsPerHouseTile = 0
freePremium = false
premiumForPromotion = false
blessingOnlyPremium = true
blessingReductionBase = 30
blessingReductionDecreament = 5
eachBlessReduction = 8
experienceStages = true
rateExperience = 2
rateExperienceFromPlayers = 0
rateSkill = 1.0
rateMagic = 1.0
rateLoot = 5
rateSpawn = 2
rateMonsterHealth = 1.0
rateMonsterMana = 1.0
rateMonsterAttack = 1.5
rateMonsterDefense = 1.0
minLevelThresholdForKilledPlayer = 0.9
maxLevelThresholdForKilledPlayer = 1.1
rateStaminaLoss = 1
rateStaminaGain = 3
rateStaminaThresholdGain = 12
staminaRatingLimitTop = 41 * 60
staminaRatingLimitBottom = 14 * 60
rateStaminaAboveNormal = 1.0
rateStaminaUnderNormal = 1.0
staminaThresholdOnlyPremium = true
experienceShareRadiusX = 30
experienceShareRadiusY = 30
experienceShareRadiusZ = 1
experienceShareLevelDifference = 200 * 200
extraPartyExperienceLimit = 20
extraPartyExperiencePercent = 20
experienceShareActivity = 2 * 60 * 1000
globalSaveEnabled = false
globalSaveHour = 8
shutdownAtGlobalSave = false
cleanMapAtGlobalSave = false
deSpawnRange = 2
deSpawnRadius = 25
maxPlayerSummons = 1
teleportAllSummons = true
teleportPlayerSummons = true
ownerName = "Zoom/PokeDW"
ownerEmail = "matheustoledo01@outlook.com"
url = ""
location = "Brazil"
displayGamemastersWithOnlineCommand = false
adminLogsEnabled = false
displayPlayersLogging = true
prefixChannelLogs = ""
runFile = ""
outLogName = ""
errorLogName = ""
truncateLogsOnStartup = false
accountSize = 5
attackSpeed = 30
capsystem = "no"
 

Link to post
Share on other sites

vc precisa de um programa pra iniciar a database, geralmente no windows usam o xampp.

vc vai precisr da database pra colocar no xampp.

deve estar na pasta do ot q vc baixou

Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

  • Recently Browsing ¬†¬†0 members

    No registered users viewing this page.


  • Similar Content

    • By Carlinhous1996
      galera do tk alguem poderia me ajudar a colocar um tempo nessa storage por favor?
      queria que ela a cada 6 dias expirasse a storage
      script:
       
    • By SonGean
      [27/06/2022 21:18:40] [Error - CreatureScript Interface] 
      [27/06/2022 21:18:40] data/creaturescripts/scripts/login.lua:onLogin
      [27/06/2022 21:18:40] Description: 
      [27/06/2022 21:18:40] (luaGetPlayerSlotItem) Player not found
      [27/06/2022 21:18:40] [Error - CreatureScript Interface] 
      [27/06/2022 21:18:40] data/creaturescripts/scripts/login.lua:onLogin
      [27/06/2022 21:18:40] Description: 
      [27/06/2022 21:18:40] (luaGetPlayerSlotItem) Player not found
       
       
       

       
      se alguem tiver como ajudar s2

    • By Scorpiondaniel
      .Qual servidor ou website você utiliza como base? 
      TFS 1.3
      Qual o motivo deste tópico? 
      Ajuda
      Está surgindo algum erro? Se sim coloque-o aqui. 
       
      Você tem o código disponível? Se tiver publique-o aqui: 
       function getPlayerCap(cid) local query = db.getResult("SELECT cap FROM players WHERE id = " .. getPlayerGUID(cid)) if query:getID() ~= -1 then return tonumber(query:getDataString("cap")) end return 0 end local capacidade = 5000 -- aqui coloca quanto que vai aumentar function onEquip(cid, item, slot) if getPlayerSlotItem(cid, slot).itemid == item.itemid then doPlayerSetMaxCapacity(cid, (getPlayerCap(cid) + capacidade)) doPlayerSave(cid) end return true end function onDeEquip(cid, item, slot) doPlayerSetMaxCapacity(cid,getPlayerCap(cid) - capacidade) doPlayerSave(cid) return true end  
      Você tem alguma imagem que possa auxiliar no problema? Se sim, coloque-a aqui. 
       
    • By megatibiano
      Está surgindo algum erro? Se sim coloque-o aqui. 
       
      Você tem o código disponível? Se tiver publique-o aqui: 
       local config = { lottery_hour = "2 hours", -- Tempo ate a proxima loteria (Esse tempo vai aparecer somente como broadcast message) rewards_id = {2494, 2472, 2514, 2160}, -- ID dos Itens Sorteados na Loteria crystal_counts = 10, -- Usado somente se a rewards_id for crystal coin (ID: 2160). website = "yes", -- Only if you have php scripts and table `lottery` in your database! days = { "Monday-08:00", "Monday-13:00", "Monday-19:30", "Tuesday-08:00", "Tuesday-13:00", "Tuesday-19:30", "Wednesday-08:00", "Wednesday-13:00", "Wednesday-19:30", "Thursday-08:00", "Thursday-13:00", "Thursday-19:30", "Friday-01:22", "Friday-13:00", "Friday-18:15", "Saturday-21:27", "Saturday-21:28", "Saturday-21:29", "Sunday-08:00", "Sunday-13:00", "Sunday-19:30" } } local function getPlayerWorldId(cid) if not(isPlayer(cid)) then return false end local pid = getPlayerGUID(cid) local worldPlayer = 0 local result_plr = db.getResult("SELECT * FROM `players` WHERE `id` = "..pid..";") if(result_plr:getID() ~= -1) then worldPlayer = tonumber(result_plr:getDataInt("world_id")) result_plr:free() return worldPlayer end return false end local function getOnlineParticipants() local players = {} for _, pid in pairs(getPlayersOnline()) do if getPlayerAccess(pid) <= 2 and getPlayerStorageValue(pid, 281821) <= os.time() then table.insert(players, pid) end end if #players > 0 then return players end return false end function onThink(cid, interval) if table.find(config.days, os.date("%A-%H:%M")) then if(getWorldCreatures(o) <= 0)then return true end local query = db.query or db.executeQuery local random_item = config.rewards_id[math.random(1, #config.rewards_id)] local item_name = getItemNameById(random_item) local data = os.date("%d/%m/%Y - %H:%M:%S") local online = getOnlineParticipants() if online then local winner = online[math.random(1, #online)] local world = tonumber(getPlayerWorldId(winner)) if(random_item == 2160) then doPlayerSetStorageValue(winner, 281821, os.time() + 3600 * 24) doPlayerAddItem(winner, random_item, config.crystal_counts) doBroadcastMessage("[LOTTERY SYSTEM] Winner: " .. getCreatureName(winner) .. ", Reward: " .. config.crystal_counts .." " .. getItemNameById(random_item) .. "s! Congratulations! (Next lottery in " .. config.lottery_hour .. ")") else doPlayerSetStorageValue(winner, 281821, os.time() + 3600 * 24) doBroadcastMessage("[LOTTERY SYSTEM] Winner: " .. getCreatureName(winner) .. ", Reward: " ..getItemNameById(random_item) .. "! Congratulations! (Next lottery in " .. config.lottery_hour .. ")") doPlayerAddItem(winner, random_item, 1) end if(config.website == "yes") then query("INSERT INTO `lottery` (`name`, `item`, `world_id`, `item_name`, `date`) VALUES ('".. getCreatureName(winner).."', '".. random_item .."', '".. world .."', '".. item_name .."', '".. data .."');") end else print("Ninguem OnLine pra ganhar na loteria") end end return true end  
      Você tem alguma imagem que possa auxiliar no problema? Se sim, coloque-a aqui. 
       

    • By megatibiano
      Qual o motivo deste tópico? 
       
      Está surgindo algum erro? Se sim coloque-o aqui. 
       
      Você tem o código disponível? Se tiver publique-o aqui: 
         
      Você tem alguma imagem que possa auxiliar no problema? Se sim, coloque-a aqui. 
       

√ó
√ó
  • Create New...

Important Information

Confirmação de Termo