• There is NO official Otland's Discord server and NO official Otland's server list. The Otland's Staff does not manage any Discord server or server list. Moderators or administrator of any Discord server or server lists have NO connection to the Otland's Staff. Do not get scammed!

Error Website - Mysql

Barca Furada

New Member
Joined
Jan 27, 2021
Messages
8
Reaction score
0
hello i have a problem when i run my ot server!


I am trying to put a web site, when I put mysql. in Config.lua he gives this problem and closes the ot server. can someone help me see where the error is



error.png
 
OP
B

Barca Furada

New Member
Joined
Jan 27, 2021
Messages
8
Reaction score
0
Foreign Language
Post automatically merged:

That is mine config.lua, even changing the sqlpass password, it does not open the server!


follow the picture as it is:

error 02.png

Lua:
    ownerName = ""
    ownerEmail = ""
    url = ""
    location = ""

    motd = "Bem Vindos, A Vargally Ots:"
    serverName = "Global 7.6"
    loginMessage = "Welcome"
    displayGamemastersWithOnlineCommand = false

    sqlType = "Mysql"
    sqlHost = "127.0.0.1"
    sqlPort = 3306
    sqlUser = "root"
    sqlPass = "minhasenha"
    sqlDatabase = "vargallyOTserver"
    sqlFile = "schemas/otxserver.s3db"
    sqlKeepAlive = 0
    mysqlReadTimeout = 10
    mysqlWriteTimeout = 10
    mysqlReconnectionAttempts = 3
    encryptionType = "SHA1"

    worldId = 0
    ip = "vargallyot.servegame.com"
    worldType = "open"
    bindOnlyGlobalAddress = false
    loginPort = 7171
    gamePort = "7172"
    statusPort = 7171
    loginOnlyWithLoginServer = false

    accountManager = true
    namelockManager = true
    newPlayerChooseVoc = false
    newPlayerSpawnPosX = 32097
    newPlayerSpawnPosY = 32219
    newPlayerSpawnPosZ = 7
    newPlayerTownId = 11
    newPlayerLevel = 1
    newPlayerMagicLevel = 0
    generateAccountNumber = false
    generateAccountSalt = true

    fragsLimit = 24 * 60 * 60
    fragsSecondLimit = 7 * 24 * 60 * 60
    fragsThirdLimit = 30 * 24 * 60 * 60

    fragsToRedSkull = 6
    fragsSecondToRedSkull = 42
    fragsThirdToRedSkull = 168
    redSkullLength = 3 * 24 * 60 * 60

    fragsToBlackSkull = 9
    fragsSecondToBlackSkull = 63
    fragsThirdToBlackSkull = 252
    blackSkulledDeathHealth = 40
    blackSkulledDeathMana = 0
    blackSkullLength = 6 * 24 * 60 * 60
    useBlackSkull = false

    notationsToBan = 3
    warningsToFinalBan = 4
    warningsToDeletion = 5
    banLength = 7 * 24 * 60 * 60
    killsBanLength = 7 * 24 * 60 * 60
    finalBanLength = 30 * 24 * 60 * 60
    ipBanLength = 1 * 24 * 60 * 60
    fragsToBanishment = 9
    fragsSecondToBanishment = 63
    fragsThirdToBanishment = 252

    protectionLevel = 1
    pvpTileIgnoreLevelAndVocationProtection = true
    allowFightback = true
    pzLocked = 60 * 1000
    huntingDuration = 60 * 1000
    criticalHitMultiplier = 1
    displayCriticalHitNotify = false
    removeWeaponAmmunition = true
    removeWeaponCharges = true
    removeRuneCharges = true
    whiteSkullTime = 15 * 60 * 1000
    advancedFragList = true
    useFragHandler = false
    noDamageToSameLookfeet = false
    showHealthChange = true
    showManaChange = true
    showHealthChangeForMonsters = true
    showManaChangeForMonsters = true
    fieldOwnershipDuration = 5 * 1000
    stopAttackingAtExit = true
    loginProtectionPeriod = 10 * 1000
    deathLostPercent = 10
    stairhopDelay = 2 * 1000
    pushCreatureDelay = 2 * 1000
    deathContainerId = 1987
    gainExperienceColor = 215
    addManaSpentInPvPZone = true
    recoverManaAfterDeathInPvPZone = true
    squareColor = 0

        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 = false

        paralyzeDelay = 1500

        premiumDaysToAddByGui = 10

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

        tibiaClassicSlots = true
        monsterSpawnWalkback = true
        allowBlockSpawn = true

        NoShareExpSummonMonster = false

        enableLootBagDisplay = false

        tileHeightBlock = true
        useStamina = true
        autoStack = true
        runesHitTopCreature = false
        charlistBasicInfo = false

        noAttackHealingSimultaneus = true
        enableCooldowns = true
        classicDamageOnWeapons = true

    loginTries = 20
    retryTimeout = 5 * 1000
    loginTimeout = 60 * 1000
    maxPlayers = 1000
    displayOnOrOffAtCharlist = false
    onePlayerOnlinePerAccount = true
    allowClones = 0
    statusTimeout = 1000
    replaceKickOnLogin = true
    forceSlowConnectionsToDisconnect = false
    premiumPlayerSkipWaitList = true
    packetsPerSecond = 50

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

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

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

    timeBetweenActions = 200
    timeBetweenExActions = 1000
    timeBetweenCustomActions = 500
    checkCorpseOwner = true
    maximumDoorLevel = 999
    tradeLimit = 1000
    canOnlyRopePlayers = false

    mapAuthor = "maya"
    randomizeTiles = true
    houseDataStorage = "binary-tilebased"
    storeTrash = true
    cleanProtectedZones = true
    mapName = "world.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 = false

    maxMessageBuffer = 4

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

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

    ghostModeInvisibleEffect = false
    ghostModeSpellEffects = true

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

    freePremium = true
    premiumForPromotion = true
    updatePremiumStateAtStartup = true

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

    experienceStages = true
    rateExperience = 5.0
    rateExperienceFromPlayers = 0
    levelToOfflineTraining = 999
    rateSkill = 10.0
    rateSkillOffline = 1.5
    rateMagic = 5.0
    rateMagicOffline = 1.5
    rateLoot = 8.0
    rateSpawnMin = 1
    rateSpawnMax = 1
    formulaLevel = 1.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 = 20
    experienceShareActivity = 2 * 60 * 1000

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

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

    maxPlayerSummons = 2
    teleportAllSummons = false
    teleportPlayerSummons = true

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

    managerPort = 7171
    managerLogs = true
    managerPassword = "1111117"
    managerLocalhostOnly = true
    managerConnectionsLimit = 2

    adminPort = 7171
    adminPassword = "1111117"
    adminLocalhostOnly = true
    adminConnectionsLimit = 2
    adminRequireLogin = true
    adminEncryption = ""
    adminEncryptionData = ""

    saveGlobalStorage = false
    bufferMutedOnSpellFailure = false
 
Last edited by a moderator:
Top