Programação [AJUDA] COLOCANDO SERVIDOR EM MYSQL

[FiNub 22]

@KotZletY @DboHere @edusorcer eu achei o problema, é que minha distro nao ta compilado para rodar em mysql, eu baixei um servidor mysql, peguei a distro dele botei na pasta do meu e abri, veio um monte de erro quando abri mais deixo online, como eu faço para compilar a distro pra rodar em mysql?

[DboHere 16]

 

na aba Parameters em C++ compiler adicione os seguinte 

 

 

-D__USE_MYSQL__

 

E em Linker adicione as seguinte lib

 

 

-lmysql

[FiNub 22]

@DboHere cara pf me explica pq minha distro ja esta compilada e nao esta rodando em mysql, ja esta tudo certo,

 

  Mostrar conteúdo oculto

    ownerName = "Werner"
    ownerEmail = ""
    url = "werner.com"
    location = "Brazil"

    motd = "Divirta-se"
    serverName = "Tibia Alpha"
    loginMessage = "Bem vindo Ao Tibia Alpha."
    displayGamemastersWithOnlineCommand = false

    sqlType = "mysql"
    sqlHost = "localhost"
    sqlPort = 3306
    sqlUser = "root"
    sqlPass = ""
    sqlDatabase = "Tibia Alpha"
    sqlFile = "forgottenserver.s3db"
    sqlKeepAlive = 0
    mysqlReadTimeout = 1000
    mysqlWriteTimeout = 1000
    mysqlReconnectionAttempts = 5
    encryptionType = "sha1"

    worldId = 0
    ip = "127.0.0.1"
    worldType = "open"
    bindOnlyGlobalAddress = false
    loginPort = 7171
    gamePort = "7172"
    statusPort = 7171
    loginOnlyWithLoginServer = false

    accountManager = true
    namelockManager = true
    newPlayerChooseVoc = true
    newPlayerSpawnPosX = 331
    newPlayerSpawnPosY = 44
    newPlayerSpawnPosZ = 6
    newPlayerTownId = 1
    newPlayerLevel = 15
    newPlayerMagicLevel = 0
    generateAccountNumber = false
    generateAccountSalt = false

    fragsLimit = 12 * 60 * 60
    fragsSecondLimit = 1 * 24 * 60 * 60
    fragsThirdLimit = 1 * 24 * 60 * 60

    fragsToRedSkull = 100
    fragsSecondToRedSkull = 700
    fragsThirdToRedSkull = 3800
    redSkullLength = 1 * 24 * 60 * 60

    fragsToBlackSkull = 200
    fragsSecondToBlackSkull = 3500
    fragsThirdToBlackSkull = 14000
    blackSkulledDeathHealth = 40
    blackSkulledDeathMana = 0
    blackSkullLength = 2 * 24 * 60 * 60
    useBlackSkull = true

    notationsToBan = 3
    warningsToFinalBan = 4
    warningsToDeletion = 5
    banLength = 7 * 24 * 60 * 60
    killsBanLength = 7 * 24 * 60 * 60
    finalBanLength = 30 * 24 * 60 * 60
    ipBanLength = 2 * 24 * 60 * 60
    fragsToBanishment = 7
    fragsSecondToBanishment = 21
    fragsThirdToBanishment = 41

    protectionLevel = 100
    pvpTileIgnoreLevelAndVocationProtection = true
    pzLocked = 1 * 30 * 1000
    huntingDuration = 1 * 60 * 1000
    criticalHitMultiplier = 1
    displayCriticalHitNotify = false
    removeWeaponAmmunition = false
    removeWeaponCharges = false
    removeRuneCharges = false
    whiteSkullTime = 4 * 60 * 1000
    advancedFragList = false
    useFragHandler = true
    noDamageToSameLookfeet = false
    showHealthChange = true
    showManaChange = false
    showHealthChangeForMonsters = false
    showManaChangeForMonsters = false
    fieldOwnershipDuration = 3 * 1000
    stopAttackingAtExit = true
    loginProtectionPeriod = 1 * 1000
    deathLostPercent = 7
    stairhopDelay = 0.5 * 1000
    pushCreatureDelay = 0.1 * 1000
    deathContainerId = 1987
    gainExperienceColor = 210
    addManaSpentInPvPZone = true
    recoverManaAfterDeathInPvPZone = true
    squareColor = 0
    broadcastBanishments = false
    maxViolationCommentSize = 60
    violationNameReportActionType = 2

    rsaPrime1 = "14299623962416399520070177382898895550795403345466153217470516082934737582776038882967213386204600674145392845853859217990626450972452084065728686565928113"
    rsaPrime2 = "7630979195970404721891201847792002125535401292779123937207447574596692788513647179235335529307251350570728407373705564708871762033017096809910315212884101"
    rsaPublic = "65537"
    rsaModulus = "109120132967399429278860960508995541528237502902798129123468757937266291492576446330739696001110603907230888610072655818825358503429057592827629436413108566029093628212635953836686562675849720620786279431090218017681061521755056710823876476444260558147179707119674283982419152118103759076030616683978566631413"
    rsaPrivate = "46730330223584118622160180015036832148732986808519344675210555262940258739805766860224610646919605860206328024326703361630109888417839241959507572247284807035235569619173792292786907845791904955103601652822519121908367187885509270025388641700821735345222087940578381210879116823013776808975766851829020659073"

        optionalWarAttackableAlly = true
        fistBaseAttack = 7
        criticalHitChance = 7
        noDamageToGuildMates = false
        noDamageToPartyMembers = false

        rookLevelTo = 5
        rookLevelToLeaveRook = 8
        rookTownId = 1
        useRookSystem = true

        paralyzeDelay = 1400

        premiumDaysToAddByGui = 0

        useCapacity = true
        defaultDepotSize = 500
        defaultDepotSizePremium = 1000
        enableProtectionQuestForGM = true
        cleanItemsInMap = false
        playerFollowExhaust = 1000

        monsterSpawnWalkback = true
        allowBlockSpawn = true
        classicEquipmentSlots = true

        NoShareExpSummonMonster = false

        enableLootBagDisplay = false
        highscoreDisplayPlayers = 10
        updateHighscoresAfterMinutes = 30
        attackImmediatelyAfterLoggingIn = false
        exhaustionNPC = false
        exhaustionInSecondsNPC = 0.5

        manualVersionConfig = false
        versionMin = 860
        versionMax = 860
        versionMsg = "Only clients with protocol 8.60 allowed!"

    loginTries = 10
    retryTimeout = 5 * 1000
    loginTimeout = 30 * 1000
    maxPlayers = 200
    displayOnOrOffAtCharlist = false
    onePlayerOnlinePerAccount = true
    allowClones = 0
    statusTimeout = 10
    replaceKickOnLogin = true
    forceSlowConnectionsToDisconnect = false
    premiumPlayerSkipWaitList = true
    packetsPerSecond = 1000
    loginProtectionTime = 1

    deathListEnabled = true
    deathListRequiredTime = 1 * 60 * 1000
    maxDeathRecords = 5
    multipleNames = false

        retroPVP = false
        deathAssistCount = 20

        blessings = true
        blessingOnlyPremium = true
        blessingReductionBase = 30
        blessingReductionDecrement = 5
        eachBlessReduction = 8
            useFairfightReduction = true
            fairFightTimeRange = 60
            pvpBlessingThreshold = 40

    externalGuildWarsManagement = false
    ingameGuildManagement = false
    levelToFormGuild = 100
    premiumDaysToFormGuild = 0
    guildNameMinLength = 4
    guildNameMaxLength = 20

    buyableAndSellableHouses = true
    houseNeedPremium = false
    bedsRequirePremium = false
    levelToBuyHouse = 200
    housesPerAccount = 1
    houseRentAsPrice = false
    housePriceAsRent = false
    housePriceEachSquare = 1000
    houseRentPeriod = "weekly"
    houseCleanOld = 8 * 24 * 60 * 60
    guildHalls = false
    houseSkipInitialRent = true
    houseProtection = true

    timeBetweenActions = 200
    timeBetweenExActions = 1000
    timeBetweenCustomActions = 0
    checkCorpseOwner = true
    hotkeyAimbotEnabled = true
    maximumDoorLevel = 999
    tradeLimit = 100
    canOnlyRopePlayers = false

    mapAuthor = "Johnao"
    randomizeTiles = true
    houseDataStorage = "binary-tilebased"
    storeTrash = true
    cleanProtectedZones = true
    mapName = "Baiak Barao.otbm"

    mailMaxAttempts = 5
    mailBlockPeriod = 30 * 60 * 1000
    mailAttemptsFadeTime = 5 * 60 * 1000
    mailboxDisabledTowns = ""

    daemonize = false
    defaultPriority = "higher"
    niceLevel = 5
    serviceThreads = 1
    coresUsed = "-1" 
    startupDatabaseOptimization = true
    removePremiumOnInit = true
    confirmOutdatedVersion = false
    skipItemsVersionCheck = true

    maxMessageBuffer = 9

    dataDirectory = "data/"
    logsDirectory = "data/logs/"
    disableOutfitsForPrivilegedPlayers = false
    bankSystem = false
    spellNameInsteadOfWords = false
    emoteSpells = true
    unifiedSpells = false
    promptExceptionTracerErrorBox = true
    storePlayerDirection = false
    savePlayerData = true
    monsterLootMessage = 3
    monsterLootMessageType = 25
    separateViplistPerCharacter = false
    vipListDefaultLimit = 50
    vipListDefaultPremiumLimit = 100

    allowChangeOutfit = true
    allowChangeColors = true
    allowChangeAddons = true
    addonsOnlyPremium = true

    ghostModeInvisibleEffect = true
    ghostModeSpellEffects = true

    idleWarningTime = 14 * 60 * 1000
    idleKickTime = 15 * 60 * 1000
    expireReportsAfterReads = 1
    playerQueryDeepness = -1
    protectionTileLimit = 20
    houseTileLimit = 4
    tileLimit = 10

    freePremium = false
    premiumForPromotion = true
    updatePremiumStateAtStartup = true

    experienceStages = true
    rateExperience = 350
    rateExperienceFromPlayers = 0
    levelToOfflineTraining = 8
    rateSkill = 25
    rateSkillOffline = 0.5
    rateMagic = 10
    rateMagicOffline = 0.5
    rateLoot = 8.0
    rateSpawnMin = 1
    rateSpawnMax = 2
    formulaLevel = 5.0
    formulaMagic = 1.0

        rateMonsterHealth = 1.0
        rateMonsterMana = 1.0
        rateMonsterAttack = 1.0
        rateMonsterDefense = 1.0

    minLevelThresholdForKilledPlayer = 0.9
    maxLevelThresholdForKilledPlayer = 1.1

    rateStaminaLoss = 1
    rateStaminaGain = 3
    rateStaminaThresholdGain = 12
    staminaRatingLimitTop = 40 * 60
    staminaRatingLimitBottom = 14 * 60
    staminaLootLimit = 14 * 60
    rateStaminaAboveNormal = 1.5
    rateStaminaUnderNormal = 0.5
    staminaThresholdOnlyPremium = true

    experienceShareRadiusX = 30
    experienceShareRadiusY = 30
    experienceShareRadiusZ = 1
    experienceShareLevelDifference = 2 / 3
    extraPartyExperienceLimit = 20
    extraPartyExperiencePercent = 5
    experienceShareActivity = 2 * 60 * 1000

    globalSaveEnabled = false
    globalSaveHour = 8
    globalSaveMinute = 0
    shutdownAtGlobalSave = true
    cleanMapAtGlobalSave = false

    minRateSpawn = 1
    maxRateSpawn = 3
    deSpawnRange = 2
    deSpawnRadius = 50

    maxPlayerSummons = 2
    teleportAllSummons = true
    teleportPlayerSummons = true

    disableLuaErrors = false
    adminLogs = true
    displayPlayersLogging = true
    prefixChannelLogs = ""
    runFile = "server/run.log"
    outputLog = "server/out.log"
    truncateLogOnStartup = false
    logPlayersStatements = false

    managerPort = 7171
    managerLogs = true
    managerPassword = ""
    managerLocalhostOnly = true
    managerConnectionsLimit = 1

    adminPort = 7171
    adminPassword = ""
    adminLocalhostOnly = true
    adminConnectionsLimit = 1
    adminRequireLogin = true
    adminEncryption = ""
    adminEncryptionData = ""

    saveGlobalStorage = false
    bufferMutedOnSpellFailure = false
 

esse é meu config.lua, e quando eu abro a distro acontece isso, eu mudei de xampp, entao eu acredito que a senha também resetou

 

[J.L 33]

Aconselho a mudas de distro  erros relacionados a Database não dão crash só spam de erro...

isso deve estar ocorrendo por outro motivo...

[FiNub 22]

@J.L ta bllz, voce conhece um server 8.6 bom com uma distro versao 0.4?