Olá Galera do TibiaKing eu estouu com uma grande dúvida e não consigo achar a respostas exata por aqui...

 

Estou com um Servidor só que ele está MYSQL e queria passar para SQLITE , mais já fiz de tudo no config.lua e não consigo 

Sempre dano erro....

 

 

ERROR: Couldn't estabilish connection to SQL database !  

 

Alguém poderia ajudar ? Dou +REP

amigo verifique essa parte do seu config.lua

 

sqlType = "sqlite"  -- tipo de conexão mysql (com database e site) // sqlite ( account manager salva contas no arquivo .s3db)

sqlHost = "localhost" -- ip que conecta quando usa mysql (localhost = ip da maquina que esta executando)

sqlPort = 3306 -- porta usada para checar conexão

sqlUser = "root" -- usuario usado para conectar database "mysql"

sqlPass = "" -- senha  usada para conectar database "mysql"

sqlDatabase = "theforgottenserver" -- nome da database "mysql"

sqlFile = "forgottenserver.s3db" -- nome da database sqlite "fica dentro da pasta do ot"

sqlKeepAlive = 0 -- nao sei kkk

mysqlReadTimeout = 10 -- sei que tem a haver com tempo limite de conexão "mysql"

mysqlWriteTimeout = 10 -- sei que tem a haver com tempo limite de conexão "mysql"

encryptionType = "plain" -- tipo de encryp da database "plain" ou "sha1"

OLHA COMO ESTÁ !

 

 

 

accountManager = "yes"

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 = "127.0.0.1"

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 = "sqlite"

sqlHost = "127.0.0.1"

sqlPort = 3306

sqlUser = "root"

sqlPass = ""

sqlDatabase = "otserver"

sqlFile = "otserver.s3db"

sqlKeepAlive = 0

mysqlReadTimeout = 10

mysqlWriteTimeout = 10

encryptionType = "plain"

 

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

esta configurado para sqlite corretamente, verifique se dentro da pasta do ot tem um arquivo chamado otserver.s3db pode estar assim tambem forgottenserver.s3db renomeie ele para otserver caso esteja forgottenserver.

Se no config.lua está Sqlite e não está funcionando, quer dizer que a distro do servidor ignora essa opção, assim deixando apenas como Mysql...

 

Tente usar outra distro =)