Não Consigo abrir meu Ot : ERROR: Couldn't estabilish connection to SQL database!

[eln789 0]

galera me ajudem eu tento abrir meu ot mas aparece a seguinte mensagem Couldn't estabilish connection to SQL database!

 

minha config lua esta abaixo

 

accountManager = true

namelockManager = true

newPlayerChooseVoc = true

newPlayerSpawnPosX = 1150

newPlayerSpawnPosY = 848

newPlayerSpawnPosZ = 7

newPlayerTownId = 1

newPlayerLevel = 8

newPlayerMagicLevel = 0

generateAccountNumber = false

 

redSkullLength = 1 * 60 * 1000

blackSkullLength = 1 * 60 * 1000

dailyFragsToRedSkull = 10

weeklyFragsToRedSkull = 9999999

monthlyFragsToRedSkull = 9999999

dailyFragsToBlackSkull = dailyFragsToRedSkull

weeklyFragsToBlackSkull = weeklyFragsToRedSkull

monthlyFragsToBlackSkull = monthlyFragsToRedSkull

dailyFragsToBanishment = dailyFragsToRedSkull

weeklyFragsToBanishment = weeklyFragsToRedSkull

monthlyFragsToBanishment = monthlyFragsToRedSkull

blackSkulledDeathHealth = 40

blackSkulledDeathMana = 40

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 = 4 * 24 * 60 * 60

broadcastBanishments = true

maxViolationCommentSize = 200

violationNameReportActionType = 2

autoBanishUnknownBytes = false

 

worldType = "pvp"

protectionLevel = 8

pvpTileIgnoreLevelAndVocationProtection = true

pzLocked = 1 * 40 * 1000

huntingDuration = 90 * 2000

criticalHitChance = 7

criticalHitMultiplier = 1

displayCriticalHitNotify = true

removeWeaponAmmunition = false

removeWeaponCharges = false

removeRuneCharges = "no"

whiteSkullTime = 1 * 10 * 1000

noDamageToSameLookfeet = false

showHealingDamage = true

showHealingDamageForMonsters = false

fieldOwnershipDuration = 5 * 1000

stopAttackingAtExit = false

oldConditionAccuracy = false

loginProtectionPeriod = 0 * 0

stairhopDelay = 2 * 1000

pushCreatureDelay = 2 * 1000

deathLostPercent = 10

deathContainerId = 1987

gainExperienceColor = 215

addManaSpentInPvPZone = true

squareColor = 0

allowFightback = true

 

worldId = 0

ip = "noobwargudy.servegame.com"

bindOnlyConfiguredIpAddress = false

loginPort = 7171

gamePort = 7172 -- Não mude

adminPort = 7171

statusPort = 7171

loginTries = 10

retryTimeout = 5 * 1000

loginTimeout = 60 * 1000

maxPlayers = 100

motd = "MataNoob"

displayOnOrOffAtCharlist = false

onePlayerOnlinePerAccount = true

allowClones = false

serverName = "MataNoob"

loginMessage = ".:: MataNoob ::. 8.60 !"

statusTimeout = 5 * 60 * 1000

replaceKickOnLogin = true

forceSlowConnectionsToDisconnect = false

loginOnlyWithLoginServer = false

premiumPlayerSkipWaitList = false

 

sqlType = "sqlite"

sqlHost = "localhost"

sqlPort = 3306

sqlUser = "root"

sqlPass = "m9l7j9"

sqlDatabase = "MataNoob"

sqlFile = "matanoob.s3db"

sqlKeepAlive = 0

mysqlReadTimeout = 10

mysqlWriteTimeout = 10

encryptionType = "plain"

 

deathListEnabled = true

deathListRequiredTime = 1 * 60 * 1000

deathAssistCount = 19

maxDeathRecords = 5

 

ingameGuildManagement = true

levelToFormGuild = 45

premiumDaysToFormGuild = 0

guildNameMinLength = 4

guildNameMaxLength = 30

 

highscoreDisplayPlayers = 10

updateHighscoresAfterMinutes = 2

 

buyableAndSellableHouses = true

houseNeedPremium = true

bedsRequirePremium = true

levelToBuyHouse = 45

housesPerAccount = 2

houseRentAsPrice = false

housePriceAsRent = false

housePriceEachSquare = 1000

houseRentPeriod = "never"

houseCleanOld = 0

guildHalls = true

 

timeBetweenActions = 200

timeBetweenExActions = 1000

checkCorpseOwner = true

hotkeyAimbotEnabled = true

maximumDoorLevel = 500

 

mapName = "war"

mapAuthor = "MataNoob - War"

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

spellNameInsteadOfWords = false

emoteSpells = true

promptExceptionTracerErrorBox = true

storePlayerDirection = false

monsterLootMessage = 3

monsterLootMessageType = 25

separateViplistPerCharacter = false

 

ghostModeInvisibleEffect = false

ghostModeSpellEffects = true

 

idleWarningTime = 14 * 60 * 1000

idleKickTime = 15 * 60 * 1000

expireReportsAfterReads = 1

playerQueryDeepness = 2

maxItemsPerPZTile = 0

maxItemsPerHouseTile = 0

 

freePremium = true

premiumForPromotion = true

 

blessingOnlyPremium = true

blessingReductionBase = 30

blessingReductionDecreament = 5

eachBlessReduction = 8

 

experienceStages = false

rateExperience = 5

rateExperienceFromPlayers = 100

rateSkill = 50

rateMagic = 30

rateLoot = 4

rateSpawn = 1

 

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

teleportAllSummons = true

teleportPlayerSummons = true

 

ownerName = "Rawkz Down tibiaking EddyHavoc"

ownerEmail = "[email protected]"

url = "http://www.tibiaking.com"

location = "Europe"

displayGamemastersWithOnlineCommand = false

 

adminLogsEnabled = false

displayPlayersLogging = true

prefixChannelLogs = ""

runFile = ""

outLogName = ""

errorLogName = ""

truncateLogsOnStartup = false

 

[TioJapa 6]

Substitua:

sqlType = "sqlite"
sqlHost = "localhost"
sqlPort = 3306
sqlUser = "root"
sqlPass = "m9l7j9"
sqlDatabase = "MataNoob"
sqlFile = "matanoob.s3db"
sqlKeepAlive = 0
mysqlReadTimeout = 10
mysqlWriteTimeout = 10
encryptionType = "plain"

Por:

sqlType = "sqlite"
sqlHost = "localhost"
sqlPort = 3306
sqlUser = "root"
sqlPass = ""
sqlDatabase = ""
sqlFile = "matanoob.s3db"
sqlKeepAlive = 0
mysqlReadTimeout = 10
mysqlWriteTimeout = 10
encryptionType = "plain"

[eln789 0]

 

Substitua:

sqlType = "sqlite"
sqlHost = "localhost"
sqlPort = 3306
sqlUser = "root"
sqlPass = "m9l7j9"
sqlDatabase = "MataNoob"
sqlFile = "matanoob.s3db"
sqlKeepAlive = 0
mysqlReadTimeout = 10
mysqlWriteTimeout = 10
encryptionType = "plain"

Por:

sqlType = "sqlite"
sqlHost = "localhost"
sqlPort = 3306
sqlUser = "root"
sqlPass = ""
sqlDatabase = ""
sqlFile = "matanoob.s3db"
sqlKeepAlive = 0
mysqlReadTimeout = 10
mysqlWriteTimeout = 10
encryptionType = "plain"

 

cara nao foi.. sera que tem que mudar algo no sqlfile? eu acabei de fazer o download do mapa

[TioJapa 6]

cara nao foi.. sera que tem que mudar algo no sqlfile? eu acabei de fazer o download do mapa

Sustitua:
sqlType = "sqlite"
Por:
sqlType = "mysql"

[eln789 0]

Sustitua:
sqlType = "sqlite"
Por:
sqlType = "mysql"

Acredita que ainda nao quer abrir... esta dando o mesmo erro

[JonatasLucasf 75]

é mysql ou sqlite? pelo erro não está conseguindo estabelecer conexão com a DB

[Wend II 170]

veja se na pasta do seu servidor tem algum arquivo com o nome matanoob.s3db ou algum outro arquivo com o formato s3db

[Shio 2]

Veja o nome da DB que possui na pasta do seu servidor e substitua pela que se encontra na configuração do lua...

 

Exemplo

 

O nome da minha DB é warsoutside.s3db

 

 

sqlType = "sqlite"

sqlHost = "localhost"

sqlPort = 3306

sqlUser = "root"

sqlPass = "m9l7j9"

sqlDatabase = "MataNoob"

sqlFile = "warsoutside.s3db"

sqlKeepAlive = 0

mysqlReadTimeout = 10

mysqlWriteTimeout = 10

encryptionType = "plain"

 

 

 

 

 

Caso não resolva,tente usar a DB de algum servidor parecido...

 

 

 

 

 

Editado Junho 24, 2015 por mathdeus (veja o histórico de edições)