(Resolvido)[URGENTE] ERROR : Couldn't estabilish...

[Luiz Souza 1]

Por favor alguem me ajuda, todo servidor que estou baixando aqui do tibia king esta ficando com esse erro "ERROR : Couldn't estabilish connection to sql database!", Como eu resolvo ? Os otserv estao bugados ou e algo no meu pc ? Oque faço pros servers abrirem ?

[Danihcv 606]

Posta o config.lua que vc ta usando.

[vpa1 4]

Isso é no config.lua e esta dando erro porque está configurado para entrar em algum Banco de dados.. no caso os dados estão incorretos

 

Não estou no computador mas tenta achar algo parecido com isso

 

 

vai ta escrito Mysql algo assim

 

no namehost coloca "sqlite"

em senha deixa em branco tipo ""

e em baixo vai ter algo .ds3db algo assim

na sua pasta vai ter o nome parecido tambem

entao deixa o nome q ta na sua pasta tipo a maioria vem com um forgotten.s3db ai voce coloca esse nome la...

 

se der errado manda essa parte do config.lua que dai eu lembro e arrumo para você.

(Sem querer foi duas vezes)

Editado Janeiro 7, 2015 por vpa1 (veja o histórico de edições)

[Luiz Souza 1]

accountManager = "no"

namelockManager = "no"

newPlayerChooseVoc = "yes"

newPlayerSpawnPosX = 148

newPlayerSpawnPosY = 53

newPlayerSpawnPosZ = 8

newPlayerTownId = 1

newPlayerLevel = 8

newPlayerMagicLevel = 2

generateAccountNumber = "no"

 

redSkullLength = 1 * 60 * 60

blackSkullLength = 1 * 60 * 60

dailyFragsToRedSkull = 70

weeklyFragsToRedSkull = 200

monthlyFragsToRedSkull = 400

dailyFragsToBlackSkull = dailyFragsToRedSkull

weeklyFragsToBlackSkull = weeklyFragsToRedSkull

monthlyFragsToBlackSkull = monthlyFragsToRedSkull

dailyFragsToBanishment = dailyFragsToRedSkull

weeklyFragsToBanishment = weeklyFragsToRedSkull

monthlyFragsToBanishment = monthlyFragsToRedSkull

blackSkulledDeathHealth = 40

blackSkulledDeathMana = 0

useBlackSkull = true

useFragHandler = true

advancedFragList = false

 

notationsToBan = 3

warningsToFinalBan = 4

warningsToDeletion = 5

banLength = 7 * 24 * 60 * 60

killsBanLength = 8 * 24 * 60 * 60

finalBanLength = 30 * 24 * 60 * 60

ipBanishmentLength = 1 * 24 * 60 * 60

broadcastBanishments = true

maxViolationCommentSize = 200

violationNameReportActionType = 2

autoBanishUnknownBytes = false

 

worldType = "open"

protectionLevel = 60

pvpTileIgnoreLevelAndVocationProtection = true

pzLocked = 1 * 20 * 500

huntingDuration = 1 * 60 * 1000

criticalHitChance = 7

criticalHitMultiplier = 1

displayCriticalHitNotify = false

removeWeaponAmmunition = false

removeWeaponCharges = false

removeRuneCharges = false

whiteSkullTime = 2 * 60 * 1000

noDamageToSameLookfeet = false

showHealingDamage = true

showHealingDamageForMonsters = true

fieldOwnershipDuration = 5 * 1000

stopAttackingAtExit = false

oldConditionAccuracy = false

loginProtectionPeriod = 10 * 1000

deathLostPercent = 10

stairhopDelay = 2 * 1000

pushCreatureDelay = 1 * 204

deathContainerId = 1987

gainExperienceColor = 180

addManaSpentInPvPZone = true

squareColor = 0

allowFightback = true

 

enableCast = true

 

healthHealingColor = COLOR_BLUE

 

worldId = 0

ip = "baiakfast.no-ip.info"

bindOnlyConfiguredIpAddress = false

loginPort = 7171

gamePort = 7172

adminPort = 7171

statusPort = 7171

loginTries = 10

retryTimeout = 5 * 1000

loginTimeout = 60 * 1000

maxPlayers = 1000

motd = "Bem vindo ao BaiakFast, Digite !notice"

displayOnOrOffAtCharlist = false

onePlayerOnlinePerAccount = true

allowClones = false

serverName = "BaiakFast"

loginMessage = "Bem vindo ao BaiakFast"

statusTimeout = 5 * 60 * 1000

replaceKickOnLogin = true

forceSlowConnectionsToDisconnect = false

loginOnlyWithLoginServer = false

premiumPlayerSkipWaitList = false

 

sqlType = "mysql"

sqlHost = "127.0.0.1"

sqlPort = 3306

sqlUser = "root"

sqlPass = "32960511"

sqlDatabase = "otserver"

sqlFile = "otserver.s3db"

sqlKeepAlive = 0

mysqlReadTimeout = 10

mysqlWriteTimeout = 10

encryptionType = "sha1"

 

deathListEnabled = true

deathListRequiredTime = 1 * 60 * 1000

deathAssistCount = 19

maxDeathRecords = 5

 

ingameGuildManagement = false

levelToFormGuild = 8

premiumDaysToFormGuild = 0

guildNameMinLength = 4

guildNameMaxLength = 20

 

highscoreDisplayPlayers = 15

updateHighscoresAfterMinutes = 2

 

buyableAndSellableHouses = true

houseNeedPremium = true

bedsRequirePremium = true

levelToBuyHouse = 1

housesPerAccount = 0

houseRentAsPrice = false

housePriceAsRent = false

housePriceEachSquare = 1000

houseRentPeriod = "never"

houseCleanOld = 0

guildHalls = false

 

timeBetweenActions = 200

timeBetweenExActions = 1000

checkCorpseOwner = true

hotkeyAimbotEnabled = true

maximumDoorLevel = 500

 

mapName = "baiak yurots.otbm"

mapAuthor = "ADM TNT"

randomizeTiles = true

useHouseDataStorage = false

storeTrash = true

cleanProtectedZones = true

mailboxDisabledTowns = "-1"

 

defaultPriority = "high"

niceLevel = 5

coresUsed = "-1"

optimizeDatabaseAtStartup = true

removePremiumOnInit = true

confirmOutdatedVersion = false

 

maxMessageBuffer = 4

bufferMutedOnSpellFailure = false

 

dataDirectory = "data/"

allowChangeOutfit = true

allowChangeColors = true

allowChangeAddons = true

disableOutfitsForPrivilegedPlayers = false

bankSystem = true

saveGlobalStorage = true

displaySkillLevelOnAdvance = false

spellNameInsteadOfWords = false

emoteSpells = true

promptExceptionTracerErrorBox = true

storePlayerDirection = false

monsterLootMessage = 1

monsterLootMessageType = 25

separateViplistPerCharacter = false

 

ghostModeInvisibleEffect = false

ghostModeSpellEffects = true

 

idleWarningTime = 14 * 60 * 1000

idleKickTime = 30 * 60 * 1000

expireReportsAfterReads = 1

playerQueryDeepness = 2

maxItemsPerPZTile = 0

maxItemsPerHouseTile = 0

 

freePremium = true

premiumForPromotion = true

 

blessingOnlyPremium = true

blessingReductionBase = 30

blessingReductionDecreament = 5

eachBlessReduction = 8

 

experienceStages = "yes"

rateExperience = 500

rateExperienceFromPlayers = 0

rateSkill = 80

rateMagic = 60

rateLoot = 12

rateSpawn = 2

 

rateMonsterHealth = 1.0

rateMonsterMana = 1.0

rateMonsterAttack = 1.0

rateMonsterDefense = 1.1

 

minLevelThresholdForKilledPlayer = 0.9

maxLevelThresholdForKilledPlayer = 1.1

 

rateStaminaLoss = 1

rateStaminaGain = 3

rateStaminaThresholdGain = 12

staminaRatingLimitTop = 41 * 60

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

shutdownAtGlobalSave = true

cleanMapAtGlobalSave = false

 

deSpawnRange = 2

deSpawnRadius = 50

 

maxPlayerSummons = 0

teleportAllSummons = false

teleportPlayerSummons = false

 

ownerName = "ADM HellBaiak"

ownerEmail = ""

url = ""

location = "Brasil"

displayGamemastersWithOnlineCommand = false

 

adminLogsEnabled = false

displayPlayersLogging = true

prefixChannelLogs = ""

runFile = ""

outLogName = ""

errorLogName = ""

truncateLogsOnStartup = false

tipo nao e so um servidor, sao 90% deles esta assim, Alguem poderia me explciar ql diferença entre Mysql e sqlite ? e como mudo de um pro outro ?

[vpa1 4]

Tenta substituir essa parte assim.

 

 

sqlType = "sqlite"

sqlHost = "127.0.0.1"

sqlPort = 3306

sqlUser = "root"

sqlPass = ""

sqlDatabase = "otserver"  --  seuarquivo  sem o .s3db

sqlFile = "otserver.s3db" -- Ve se é esse o arquivo que voce tem na pasta do seu servidor ai voce substitui se nao for tipo   o nome do " seuarquivo.s3db"

sqlKeepAlive = 0

mysqlReadTimeout = 10

mysqlWriteTimeout = 10

encryptionType = "sha1"