Ir para conteúdo
  • Cadastre-se

(Resolvido)(Resolvido) Erro SQL Datebase.


Ir para solução Resolvido por Gustavo Ferreira,

Posts Recomendados

pessoal desculpem caso eu esteja revivendo o topico porém estou tentando rodar meu otserv em linux e está dando erro na hora de carregar a database compilei meu ot para linux porém quando vou abrir da erro.  segue a imagem e meu config.lua.

 

-- The Global Server Config

    -- Owner Data
    ownerName = ""
    ownerEmail = ""
    url = ""
    location = ""

    -- Messages
    motd = "Bem vindo ao Global Server!"
    serverName = "Global"
    loginMessage = "Bem vindo ao Server de tibia Global!"
    displayGamemastersWithOnlineCommand = false

    -- MySql
    sqlType = "MYSQL"
    sqlHost = "127.0.0.1"
    sqlPort = 3306
    sqlUser = "root"
    sqlPass = ""
    sqlDatabase = ""
    sqlFile = "schemas/otxserver.s3db"
    sqlKeepAlive = 0
    mysqlReadTimeout = 10
    mysqlWriteTimeout = 10
    mysqlReconnectionAttempts = 3
    encryptionType = "sha1"

    -- World / Ip / Port
    worldId = 0
    ip = "ainda vou escolher"
    worldType = "open"
    bindOnlyGlobalAddress = false
    loginPort = 7171
    gamePort = "7172"
    statusPort = 7171
    loginOnlyWithLoginServer = false

 

Erro de database.png

Editado por xdwilliam
falta de informações (veja o histórico de edições)
Link para o post
Compartilhar em outros sites
  • 1 year later...
  • Respostas 12
  • Created
  • Última resposta

Top Posters In This Topic

Top Posters In This Topic

Popular Posts

-- Global Server Config -- Account manager accountManager = true namelockManager = true newPlayerChooseVoc = true newPlayerSpawnPosX = 32369 newPlayerSpawnPosY = 32246 newPlayerSpawnPosZ = 6 newPlayerTownId = 1 newPlayerLevel = 20 newPlayerMagicLevel = 8 generateAccountNumber = false -- Unjustified kills useFragHandler = true redSkullLength = 30 * 24 * 60 * 60 blackSkullLength = 45 * 24 * 60 * 60 dailyFragsToRedSkull = 3 weeklyFragsToRedSkull = 5 monthly

vlw !!! brigadão kra deu certo aki

Gustavo Ferreira , Primeiramente obrigado por te postado seu config.lua Já me ajudou muito estava dando 1 erro mais agora o erro sumiu e so fikou 1 >>>>> > Error: couldn't estabilish connection to SQL database! Se poder ajudar fikarei grato e creio que tem muita gente com esse error ajuda ai até .

Posted Images

Alguém pode me ajudar ?

16/01/2018 14:54:08] The Forgotten Server, version 0.3.6 (Crying Damson)
[16/01/2018 14:54:08] PokeDG 1.0 by Taiger/Dudu
[16/01/2018 14:54:08] >> Carregando config (config.lua)
[16/01/2018 14:54:08] > Using SHA1 encryption
[16/01/2018 14:54:08] >> Carregando RSA key
[16/01/2018 14:54:08] >> Iniciando conexão com banco de dados
[16/01/2018 14:54:10] Failed connecting to database - MYSQL ERROR: Can't connect to MySQL server on 'localhost' (10061) (2003)

[16/01/2018 14:54:10] > ERROR: Couldn't estabilish connection to SQL database!
 
Cofing lua

accountManager = false
namelockManager = true
newPlayerChooseVoc = false
newPlayerSpawnPosX = 1021
newPlayerSpawnPosY = 1019
newPlayerSpawnPosZ = 7
newPlayerTownId = 1
newPlayerLevel = 30
newPlayerMagicLevel = 0
generateAccountNumber = false

lightInterval = 7500
lightChange = 1
startupTime = 351
startupLight = 40

limitPokeballs = 7                
minHappinessEffectDelay = 25    
maxHappinessEffectDelay = 40    
PokemonStageVeryHappy = 0            
maximumHunger = -1        
stateHunger = -1            
useTeleportWithFly = false
dropHappyDuringBattles = false    

    --adicionadas
      ghostPokemonNames = "Gastly, Haunter, Gengar"

allowBlockSpawn = false
    
rateGymSpellInterval = 0.10

redSkullLength = 30000 * 24 * 60 * 60
blackSkullLength = 45000 * 24 * 60 * 60
dailyFragsToRedSkull = 3
weeklyFragsToRedSkull = 5
monthlyFragsToRedSkull = 10
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 = 7 * 24 * 60 * 60
finalBanLength = 30 * 24 * 60 * 60
ipBanishmentLength = 1 * 24 * 60 * 60
broadcastBanishments = true
maxViolationCommentSize = 200
violationNameReportActionType = 2
autoBanishUnknownBytes = false

worldType = "pvp"
protectionLevel = 1000
pvpTileIgnoreLevelAndVocationProtection = true
pzLocked = 5 * 1000
huntingDuration = 60 * 1000
criticalHitChance = 7
criticalHitMultiplier = 1
displayCriticalHitNotify = false
removeWeaponAmmunition = true
removeWeaponCharges = true
removeRuneCharges = true
whiteSkullTime = 150000 * 60 * 1000
noDamageToSameLookfeet = false
showHealingDamage = false
showHealingDamageForMonsters = false
fieldOwnershipDuration = 5 * 1000
stopAttackingAtExit = false
oldConditionAccuracy = false
loginProtectionPeriod = 10 * 1000
deathLostPercent = 1
stairhopDelay = 0 * 1000
pushCreatureDelay = 1 * 1000
deathContainerId = 0
gainExperienceColor = 215
addManaSpentInPvPZone = true
squareColor = 0
allowFightback = true

worldId = 0
ip = "127.0.0.1" -- 25.61.53.241
bindOnlyConfiguredIpAddress = false
loginPort = 7171
gamePort = 7172
adminPort = 7171
statusPort = 7171
loginTries = 10
retryTimeout = 5 * 1000
loginTimeout = 60 * 1000
maxPlayers = 90    -- codificado e limitado para 7
motd = "Bem Vindo ao Mew Server!"
displayOnOrOffAtCharlist = false
onePlayerOnlinePerAccount = false
allowClones = true
serverName = "Mew"
loginMessage = "Bem Vindo Ao Pokemon Evolution!"
statusTimeout = 5 * 60 * 1000
replaceKickOnLogin = true
forceSlowConnectionsToDisconnect = false
loginOnlyWithLoginServer = false
premiumPlayerSkipWaitList = true

sqlType = "mysql"
sqlHost = "localhost"
sqlPort = 3306
sqlUser = "root"
sqlPass = "vertrigo"
sqlDatabase = "pxe"
sqlFile = "PAlpha.s3db"
sqlKeepAlive = 0
mysqlReadTimeout = 10
mysqlWriteTimeout = 10
encryptionType = "sha1"

deathListEnabled = true
deathListRequiredTime = 1 * 60 * 1000
deathAssistCount = 19
maxDeathRecords = 10

ingameGuildManagement = true
levelToFormGuild = 40
premiumDaysToFormGuild = 0
guildNameMinLength = 2
guildNameMaxLength = 25

highscoreDisplayPlayers = 15
updateHighscoresAfterMinutes = 60

buyableAndSellableHouses = true
houseNeedPremium = true
bedsRequirePremium = true
levelToBuyHouse = 1
housesPerAccount = 0
houseRentAsPrice = true -- 
housePriceAsRent = false
housePriceEachSquare = 2975
houseRentPeriod = "never"
houseCleanOld = 0 -- tava 0
guildHalls = false

timeBetweenActions = 500
timeBetweenExActions = 500
hotkeyAimbotEnabled = true

mapName = "Pokemon"
mapAuthor = "Three"
randomizeTiles = true
storeTrash = false
cleanProtectedZones = true
mailboxDisabledTowns = "1"

defaultPriority = "high"
niceLevel = 5
coresUsed = "-1"

optimizeDatabaseAtStartup = true
removePremiumOnInit = true
confirmOutdatedVersion = false

formulaLevel = 5.0
formulaMagic = 1.0
bufferMutedOnSpellFailure = false
spellNameInsteadOfWords = false
emoteSpells = false

allowChangeOutfit = true
allowChangeColors = true
allowChangeAddons = true
disableOutfitsForPrivilegedPlayers = false
addonsOnlyPremium = false

dataDirectory = "data/"
bankSystem = true
displaySkillLevelOnAdvance = false
promptExceptionTracerErrorBox = true
separateViplistPerCharacter = false
maximumDoorLevel = 500
maxMessageBuffer = 10000000

saveGlobalStorage = false
useHouseDataStorage = false
storePlayerDirection = false

checkCorpseOwner = true
monsterLootMessage = 3
monsterLootMessageType = 22

ghostModeInvisibleEffect = false
ghostModeSpellEffects = false

idleWarningTime = 14 * 60 * 1000
idleKickTime = 15 * 60 * 1000
expireReportsAfterReads = 1
playerQueryDeepness = 2
maxItemsPerPZTile = 0
maxItemsPerHouseTile = 0

freePremium = false
premiumForPromotion = true

blessingOnlyPremium = true
blessingReductionBase = 30
blessingReductionDecreament = 5
eachBlessReduction = 8

experienceStages = true
rateExperience = 1000
premiumrateExperience = 2000
ratePremiumExperience = 2000
rateExperienceFromPlayers = 200
rateSkill = 1
rateMagic = 1.0
rateLoot = 15
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.0
rateStaminaUnderNormal = 1.0
staminaThresholdOnlyPremium = true

experienceShareRadiusX = 30
experienceShareRadiusY = 30
experienceShareRadiusZ = 1
experienceShareLevelDifference = 20
extraPartyExperienceLimit = 30
extraPartyExperiencePercent = 20
experienceShareActivity = 2 * 60 * 1000

globalSaveEnabled = false
globalSaveHour = 8
shutdownAtGlobalSave = true
cleanMapAtGlobalSave = false

deSpawnRange = 2
deSpawnRadius = 25

maxPlayerSummons = 1
teleportAllSummons = true
teleportPlayerSummons = true

ownerName = "Taiger"
ownerEmail = ""
url = ""
location = "Brazil"
displayGamemastersWithOnlineCommand = false

adminLogsEnabled = false
displayPlayersLogging = false
prefixChannelLogs = ""
runFile = ""
outLogName = ""
errorLogName = ""
truncateLogsOnStartup = false

Link para o post
Compartilhar em outros sites
  • 1 year later...

Participe da conversa

Você pode postar agora e se cadastrar mais tarde. Se você tem uma conta, faça o login para postar com sua conta.

Visitante
Responder

×   Você colou conteúdo com formatação.   Remover formatação

  Apenas 75 emojis são permitidos.

×   Seu link foi automaticamente incorporado.   Mostrar como link

×   Seu conteúdo anterior foi restaurado.   Limpar o editor

×   Não é possível colar imagens diretamente. Carregar ou inserir imagens do URL.

  • Quem Está Navegando   0 membros estão online

    Nenhum usuário registrado visualizando esta página.

  • Estatísticas dos Fóruns

    96843
    Tópicos
    519604
    Posts



×
×
  • Criar Novo...

Informação Importante

Confirmação de Termo