(Resolvido)erro ao abrir serv em mysql

[Vim Rusha 1]

bom, na hora do download diz que o servidor roda melhor em MYSQL do que sqlite...como eu n tinha um site ainda sempre consegui abri ele em sqlite, com alguns erros de sqlite mas assim mesmo ele abria...dps que fiz um site e configurei toda a config lua pra rodar em mysql o servidor nem se quer abre mais.

da esse erro.alguem sabe me dizer porque o theforgottenserver para de funcionar quando tento abrir em mysql?

@Werner

 

Editado Abril 15, 2017 por Vim Rusha (veja o histórico de edições)

[thelifeofpbion 168]

qual é o erro que aparece atras dessa janelinha do windows?


Enviado do meu iPhone usando Tapatalk

[Vim Rusha 1]

infelizmente não aparece nenhum erro . simplesmente para de funcionar na hora de carregar o SQL

o erro não é apenas cmg pois um amigo meu tbm tento abri esse msm servidor em mysql no pc dele e deu a msm coisa.vou mandar minha config lua qualquer coisa me fala se tiver algo errado.

o ot é 8.60 e esta em 0TX 2.6

 

ownerName = ""
ownerEmail = ""
url = ""
location = "Brazil"

 

motd = "baiak araraquara"
serverName = "baiak araraquara"
loginMessage = "Bem vindo ao Baiak Araraquara."
displayGamemastersWithOnlineCommand = false

 

sqlType = "mysql"
sqlHost = "localhost"
sqlPort = 3306
sqlUser = "root"
sqlPass = "**********"
sqlDatabase = "otjebaiak"
sqlFile = "otjebaiak.sql"
sqlKeepAlive = 0
mysqlReadTimeout = 1000
mysqlWriteTimeout = 1000
mysqlReconnectionAttempts = 5
encryptionType = "sha1"

 

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

 

accountManager = true
namelockManager = false
newPlayerChooseVoc = true
newPlayerSpawnPosX = 853
newPlayerSpawnPosY = 927
newPlayerSpawnPosZ = 7
newPlayerTownId = 0
newPlayerLevel = 1
newPlayerMagicLevel = 0
generateAccountNumber = false
generateAccountSalt = false

 

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

 

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

 

fragsToBlackSkull = 500
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 = false
loginProtectionPeriod = 5 * 1000
deathLostPercent = 7
stairhopDelay = 0.5 * 1000
pushCreatureDelay = 0.7 * 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 = 9999

 

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 = 300
displayOnOrOffAtCharlist = false
onePlayerOnlinePerAccount = true
allowClones = 0
statusTimeout = 10

replaceKickOnLogin = true
forceSlowConnectionsToDisconnect = false
premiumPlayerSkipWaitList = true
packetsPerSecond = 1000
loginProtectionTime = 10

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 = 150
premiumDaysToFormGuild = 0
guildNameMinLength = 4
guildNameMaxLength = 20

 

buyableAndSellableHouses = true
houseNeedPremium = false
bedsRequirePremium = false
levelToBuyHouse = 250
housesPerAccount = 1
houseRentAsPrice = false
housePriceAsRent = false
housePriceEachSquare = 50000
houseRentPeriod = "weekly"
houseCleanOld = 8 * 24 * 60 * 60
guildHalls = true
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 = 20
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 = true
premiumForPromotion = false
updatePremiumStateAtStartup = true

 

experienceStages = true
rateExperience = 350
rateExperienceFromPlayers = 0
levelToOfflineTraining = 999
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 = false
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

config.lua

[tetheuscunha 68]

Esse erro da na hora de conecta com o MYSQL. Ver se o Apache/MySQL ta ligado.

[Vim Rusha 1]

vocÊ quis dizer do xamp? não entendi

DAS SEGUINTES PORTAS, QUAIS DEVEM ESTAR ABERTAS?