Ir para conteúdo
  • Cadastre-se

(Resolvido)(Resolvido) Erro SQL Datebase.


Ir para solução Resolvido por Gustavo Ferreira,

Posts Recomendados

Eu temto abrir meu server e esse erro acontece :

[23/07/2012 22:43:10] >> Loading config (config.lua)

[23/07/2012 22:43:10] > Encryption: PLAIN

[23/07/2012 22:43:10] >> Checking console version... outdated, please consider updating!

[23/07/2012 22:43:11] > Current: 0.1.7> Latest: 0.3.6>> Fetching blacklist

[23/07/2012 22:43:14] >> Loading RSA key

[23/07/2012 22:43:14] >> Starting MySQL connection

[23/07/2012 22:43:15] Failed connecting to database - MYSQL ERROR: Can't connect to MySQL server on 'localhost' (10061) (2003)

[23/07/2012 22:43:15] > ERROR: Couldn't estabilish connection to SQL database!

por favor me ajudem

aki esta meu config.lua :

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

monthlyFragsToRedSkull = 10

dailyFragsToBlackSkull = dailyFragsToRedSkull

weeklyFragsToBlackSkull = weeklyFragsToRedSkull

monthlyFragsToBlackSkull = monthlyFragsToRedSkull

dailyFragsToBanishment = dailyFragsToRedSkull

weeklyFragsToBanishment = weeklyFragsToRedSkull

monthlyFragsToBanishment = monthlyFragsToRedSkull

blackSkulledDeathHealth = 40

blackSkulledDeathMana = 0

useBlackSkull = true

advancedFragList = false

-- Banishments

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

-- Battle

worldType = "pvp"

protectionLevel = 80

pvpTileIgnoreLevelAndVocationProtection = true

pzLocked = 60 * 1000

huntingDuration = 60 * 1000

criticalHitChance = 7

criticalHitMultiplier = 1

displayCriticalHitNotify = false

removeWeaponAmmunition = false

removeWeaponCharges = false

removeRuneCharges = true

whiteSkullTime = 15 * 60 * 1000

noDamageToSameLookfeet = false

showHealingDamage = false

showHealingDamageForMonsters = false

fieldOwnershipDuration = 5 * 1000

stopAttackingAtExit = false

loginProtectionPeriod = 10 * 1000

deathLostPercent = 10

stairhopDelay = 2 * 1000

pushCreatureDelay = 2 * 1000

deathContainerId = 1987

gainExperienceColor = 215

addManaSpentInPvPZone = true

squareColor = 0

allowFightback = true

fistBaseAttack = 7

-- Connection config

worldId = 0

ip = "127.0.0.1"

loginPort = 7171

gamePort = 7172

loginTries = 10

retryTimeout = 5 * 1000

loginTimeout = 60 * 1000

maxPlayers = 1000

motd = "Welcome to the Global Server!"

displayOnOrOffAtCharlist = false

onePlayerOnlinePerAccount = true

allowClones = false

serverName = "World"

loginMessage = "Welcome to the Global Server!"

statusTimeout = 5 * 60 * 1000

replaceKickOnLogin = true

forceSlowConnectionsToDisconnect = false

loginOnlyWithLoginServer = false

premiumPlayerSkipWaitList = false

-- Database

sqlType = "mysql"

sqlHost = "localhost"

sqlPort = 3306

sqlUser = "root"

sqlPass = "8937359"

sqlDatabase = "Tunderia"

sqlFile = "realserver.sql"

sqlKeepAlive = 0

mysqlReadTimeout = 10

mysqlWriteTimeout = 10

encryptionType = "plain"

-- Deathlist

deathListEnabled = false

deathListRequiredTime = 1 * 60 * 1000

deathAssistCount = 19

maxDeathRecords = 5

-- Guilds

ingameGuildManagement = true

levelToFormGuild = 8

premiumDaysToFormGuild = 0

guildNameMinLength = 4

guildNameMaxLength = 20

-- Highscores

highscoreDisplayPlayers = 15

updateHighscoresAfterMinutes = 60

-- Houses

buyableAndSellableHouses = true

houseNeedPremium = true

bedsRequirePremium = true

levelToBuyHouse = 1

housesPerAccount = 0

houseRentAsPrice = false

housePriceAsRent = false

housePriceEachSquare = 1000

houseRentPeriod = "never"

houseCleanOld = 0

guildHalls = false

-- Item usage

timeBetweenActions = 200

timeBetweenExActions = 1000

hotkeyAimbotEnabled = true

-- Map

mapName = "World"

mapAuthor = "Killer"

randomizeTiles = true

storeTrash = true

cleanProtectedZones = true

mailboxDisabledTowns = ""

-- Process

defaultPriority = "high"

niceLevel = 5

coresUsed = "-1"

-- Startup

startupDatabaseOptimization = true

updatePremiumStateAtStartup = true

confirmOutdatedVersion = false

-- Spells

formulaLevel = 5.0

formulaMagic = 1.0

bufferMutedOnSpellFailure = false

spellNameInsteadOfWords = false

emoteSpells = false

-- Outfits

allowChangeOutfit = true

allowChangeColors = true

allowChangeAddons = true

disableOutfitsForPrivilegedPlayers = false

addonsOnlyPremium = true

-- Miscellaneous

dataDirectory = "data/"

logsDirectory = "data/logs/"

bankSystem = true

displaySkillLevelOnAdvance = false

promptExceptionTracerErrorBox = true

maximumDoorLevel = 500

maxMessageBuffer = 4

-- VIP list

separateVipListPerCharacter = false

vipListDefaultLimit = 20

vipListDefaultPremiumLimit = 100

-- Saving-related

saveGlobalStorage = true

useHouseDataStorage = false

storePlayerDirection = false

-- Loot

checkCorpseOwner = true

monsterLootMessage = 3

monsterLootMessageType = 25

-- Ghost mode

ghostModeInvisibleEffect = false

ghostModeSpellEffects = true

-- Limits

idleWarningTime = 59 * 60 * 1000

idleKickTime = 60 * 60 * 1000

reportsExpirationAfterReads = 1

playerQueryDeepness = 2

tileLimit = 0

protectionTileLimit = 0

houseTileLimit = 0

-- Premium-related

freePremium = true

premiumForPromotion = true

-- Blessings

blessings = true

blessingOnlyPremium = true

blessingReductionBase = 30

blessingReductionDecrement = 5

eachBlessReduction = 8

-- Rates

experienceStages = true

rateExperience = 5.0

rateExperienceFromPlayers = 0

rateSkill = 30.0

rateMagic = 25.0

rateLoot = 6.5

rateSpawn = 2.0

-- Monster rates

rateMonsterHealth = 1.0

rateMonsterMana = 1.0

rateMonsterAttack = 1.0

rateMonsterDefense = 1.0

-- Experience from players

minLevelThresholdForKilledPlayer = 0.9

maxLevelThresholdForKilledPlayer = 1.1

-- Stamina

rateStaminaLoss = 1

rateStaminaGain = 3

rateStaminaThresholdGain = 12

staminaRatingLimitTop = 40 * 60

staminaRatingLimitBottom = 14 * 60

staminaLootLimit = 14 * 60

rateStaminaAboveNormal = 1.5

rateStaminaUnderNormal = 0.5

staminaThresholdOnlyPremium = true

-- Party

experienceShareRadiusX = 30

experienceShareRadiusY = 30

experienceShareRadiusZ = 1

experienceShareLevelDifference = 2 / 3

extraPartyExperienceLimit = 20

extraPartyExperiencePercent = 5

experienceShareActivity = 2 * 60 * 1000

-- Global save

globalSaveEnabled = false

globalSaveHour = 8

globalSaveMinute = 0

shutdownAtGlobalSave = true

cleanMapAtGlobalSave = false

-- Spawns

deSpawnRange = 2

deSpawnRadius = 50

-- Summons

maxPlayerSummons = 2

teleportAllSummons = false

teleportPlayerSummons = false

-- Status

statusPort = 7171

ownerName = "Shadow"

ownerEmail = "[email protected]"

url = ""

location = "Mexico"

displayGamemastersWithOnlineCommand = false

-- Logs

displayPlayersLogging = true

prefixChannelLogs = ""

runFile = ""

outputLog = ""

truncateLogsOnStartup = false

-- Manager

managerPort = 7171

managerLogs = true

managerPassword = ""

managerLocalhostOnly = true

managerConnectionsLimit = 1

-- Admin

adminPort = 7171

adminLogs = true

adminPassword = ""

adminLocalhostOnly = true

adminConnectionsLimit = 1

adminRequireLogin = true

adminEncryption = ""

adminEncryptionData = ""

Link para o post
Compartilhar em outros sites
  • Solução

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

monthlyFragsToRedSkull = 10

dailyFragsToBlackSkull = dailyFragsToRedSkull

weeklyFragsToBlackSkull = weeklyFragsToRedSkull

monthlyFragsToBlackSkull = monthlyFragsToRedSkull

dailyFragsToBanishment = dailyFragsToRedSkull

weeklyFragsToBanishment = weeklyFragsToRedSkull

monthlyFragsToBanishment = monthlyFragsToRedSkull

blackSkulledDeathHealth = 40

blackSkulledDeathMana = 0

useBlackSkull = true

advancedFragList = false

-- Banishments

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

-- Battle

worldType = "pvp"

protectionLevel = 80

pvpTileIgnoreLevelAndVocationProtection = true

pzLocked = 60 * 1000

huntingDuration = 60 * 1000

criticalHitChance = 7

criticalHitMultiplier = 1

displayCriticalHitNotify = false

removeWeaponAmmunition = false

removeWeaponCharges = false

removeRuneCharges = true

whiteSkullTime = 15 * 60 * 1000

noDamageToSameLookfeet = false

showHealingDamage = false

showHealingDamageForMonsters = false

fieldOwnershipDuration = 5 * 1000

stopAttackingAtExit = false

loginProtectionPeriod = 10 * 1000

deathLostPercent = 10

stairhopDelay = 2 * 1000

pushCreatureDelay = 2 * 1000

deathContainerId = 1987

gainExperienceColor = 215

addManaSpentInPvPZone = true

squareColor = 0

allowFightback = true

fistBaseAttack = 7

-- Connection config

worldId = 0

ip = "127.0.0.1"

loginPort = 7171

gamePort = 7172

loginTries = 10

retryTimeout = 5 * 1000

loginTimeout = 60 * 1000

maxPlayers = 1000

motd = "Welcome to the Global Server!"

displayOnOrOffAtCharlist = false

onePlayerOnlinePerAccount = true

allowClones = false

serverName = "World"

loginMessage = "Welcome to the Global Server!"

statusTimeout = 5 * 60 * 1000

replaceKickOnLogin = true

forceSlowConnectionsToDisconnect = false

loginOnlyWithLoginServer = false

premiumPlayerSkipWaitList = false

-- Database

sqlType = "sqlite"

sqlHost = "localhost"

sqlPort = 3306

sqlUser = "root"

sqlPass = "8937359"

sqlDatabase = "Tunderia"

sqlFile = "realserver.sql"

sqlKeepAlive = 0

mysqlReadTimeout = 10

mysqlWriteTimeout = 10

encryptionType = "plain"

-- Deathlist

deathListEnabled = false

deathListRequiredTime = 1 * 60 * 1000

deathAssistCount = 19

maxDeathRecords = 5

-- Guilds

ingameGuildManagement = true

levelToFormGuild = 8

premiumDaysToFormGuild = 0

guildNameMinLength = 4

guildNameMaxLength = 20

-- Highscores

highscoreDisplayPlayers = 15

updateHighscoresAfterMinutes = 60

-- Houses

buyableAndSellableHouses = true

houseNeedPremium = true

bedsRequirePremium = true

levelToBuyHouse = 1

housesPerAccount = 0

houseRentAsPrice = false

housePriceAsRent = false

housePriceEachSquare = 1000

houseRentPeriod = "never"

houseCleanOld = 0

guildHalls = false

-- Item usage

timeBetweenActions = 200

timeBetweenExActions = 1000

hotkeyAimbotEnabled = true

-- Map

mapName = "World"

mapAuthor = "Killer"

randomizeTiles = true

storeTrash = true

cleanProtectedZones = true

mailboxDisabledTowns = ""

-- Process

defaultPriority = "high"

niceLevel = 5

coresUsed = "-1"

-- Startup

startupDatabaseOptimization = true

updatePremiumStateAtStartup = true

confirmOutdatedVersion = false

-- Spells

formulaLevel = 5.0

formulaMagic = 1.0

bufferMutedOnSpellFailure = false

spellNameInsteadOfWords = false

emoteSpells = false

-- Outfits

allowChangeOutfit = true

allowChangeColors = true

allowChangeAddons = true

disableOutfitsForPrivilegedPlayers = false

addonsOnlyPremium = true

-- Miscellaneous

dataDirectory = "data/"

logsDirectory = "data/logs/"

bankSystem = true

displaySkillLevelOnAdvance = false

promptExceptionTracerErrorBox = true

maximumDoorLevel = 500

maxMessageBuffer = 4

-- VIP list

separateVipListPerCharacter = false

vipListDefaultLimit = 20

vipListDefaultPremiumLimit = 100

-- Saving-related

saveGlobalStorage = true

useHouseDataStorage = false

storePlayerDirection = false

-- Loot

checkCorpseOwner = true

monsterLootMessage = 3

monsterLootMessageType = 25

-- Ghost mode

ghostModeInvisibleEffect = false

ghostModeSpellEffects = true

-- Limits

idleWarningTime = 59 * 60 * 1000

idleKickTime = 60 * 60 * 1000

reportsExpirationAfterReads = 1

playerQueryDeepness = 2

tileLimit = 0

protectionTileLimit = 0

houseTileLimit = 0

-- Premium-related

freePremium = true

premiumForPromotion = true

-- Blessings

blessings = true

blessingOnlyPremium = true

blessingReductionBase = 30

blessingReductionDecrement = 5

eachBlessReduction = 8

-- Rates

experienceStages = true

rateExperience = 5.0

rateExperienceFromPlayers = 0

rateSkill = 30.0

rateMagic = 25.0

rateLoot = 6.5

rateSpawn = 2.0

-- Monster rates

rateMonsterHealth = 1.0

rateMonsterMana = 1.0

rateMonsterAttack = 1.0

rateMonsterDefense = 1.0

-- Experience from players

minLevelThresholdForKilledPlayer = 0.9

maxLevelThresholdForKilledPlayer = 1.1

-- Stamina

rateStaminaLoss = 1

rateStaminaGain = 3

rateStaminaThresholdGain = 12

staminaRatingLimitTop = 40 * 60

staminaRatingLimitBottom = 14 * 60

staminaLootLimit = 14 * 60

rateStaminaAboveNormal = 1.5

rateStaminaUnderNormal = 0.5

staminaThresholdOnlyPremium = true

-- Party

experienceShareRadiusX = 30

experienceShareRadiusY = 30

experienceShareRadiusZ = 1

experienceShareLevelDifference = 2 / 3

extraPartyExperienceLimit = 20

extraPartyExperiencePercent = 5

experienceShareActivity = 2 * 60 * 1000

-- Global save

globalSaveEnabled = false

globalSaveHour = 8

globalSaveMinute = 0

shutdownAtGlobalSave = true

cleanMapAtGlobalSave = false

-- Spawns

deSpawnRange = 2

deSpawnRadius = 50

-- Summons

maxPlayerSummons = 2

teleportAllSummons = false

teleportPlayerSummons = false

-- Status

statusPort = 7171

ownerName = "Shadow"

ownerEmail = "[email protected]"

url = ""

location = "Mexico"

displayGamemastersWithOnlineCommand = false

-- Logs

displayPlayersLogging = true

prefixChannelLogs = ""

runFile = ""

outputLog = ""

truncateLogsOnStartup = false

-- Manager

managerPort = 7171

managerLogs = true

managerPassword = ""

managerLocalhostOnly = true

managerConnectionsLimit = 1

-- Admin

adminPort = 7171

adminLogs = true

adminPassword = ""

adminLocalhostOnly = true

adminConnectionsLimit = 1

adminRequireLogin = true

adminEncryption = ""

adminEncryptionData = ""

Use Este!!

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

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 ;D ajuda ai até .

Link para o post
Compartilhar em outros sites

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 ;D ajuda ai até .

Só baixar e jogar dentro da pasta do seu ot

http://speedy.sh/ar3wR/forgottenserver.s3db

Link para o post
Compartilhar em outros sites
  • 4 weeks later...

@merfaryus

Esta rodando o mysql no seu computador? Esta com a senha do root certa?

# Regras Gerais - TibiaKing.com #
Contato: [email protected]
Não respondo dúvidas via MP.


1C2tu.png4Tlqo.png1C2tu.png


 

Link para o post
Compartilhar em outros sites
  • 2 months later...

Olá estou com um leve problema não consigo abrir meu ot mesma coisa que o mlk la em cima..

Failed connecting to database - MYSQL ERROR: Can't connect to MySQL server on 'localhost' (10061) (2003) .. estou com o xammp aberto e tudo mais

senha direitinho e tudo só q mesmo assim segue dando isso , o meu vai ter site e tudo por isso não posso por sqlite.

Atenciosamente DiihKA ..

Link para o post
Compartilhar em outros sites
  • 2 weeks later...

Alguém me ajuda? estou com o mesmo problema, olha meu config.lua

só tem uma observação, eu ainda estou bem no começo do ot então não montei site nem nada, só queria ir ajeitando o ot pra botar o dedicado e o site mais tarde, mais não consigo entrar, quando vou abrir o mapa da: ERROR: Couldn't estabilish connection to SQL database!

Segue Config.lua :

accountManager = false

namelockManager = true

newPlayerChooseVoc = true

newPlayerSpawnPosX = 32369

newPlayerSpawnPosY = 32241

newPlayerSpawnPosZ = 7

newPlayerTownId = 1

newPlayerLevel = 10

newPlayerMagicLevel = 0

generateAccountNumber = false

generateAccountSalt = false

useFragHandler = true

redSkullLength = 2 * 24 * 60 * 60

blackSkullLength = 3 * 24 * 60 * 60

dailyFragsToRedSkull = 12

weeklyFragsToRedSkull = 25

monthlyFragsToRedSkull = 100

dailyFragsToBlackSkull = 50

weeklyFragsToBlackSkull = 60

monthlyFragsToBlackSkull = 200

dailyFragsToBanishment = dailyFragsToRedSkull

weeklyFragsToBanishment = weeklyFragsToRedSkull

monthlyFragsToBanishment = monthlyFragsToRedSkull

blackSkulledDeathHealth = 40

blackSkulledDeathMana = 0

useBlackSkull = 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 = false

maxViolationCommentSize = 200

violationNameReportActionType = 2

autoBanishUnknownBytes = false

worldType = "open"

protectionLevel = 50

pvpTileIgnoreLevelAndVocationProtection = true

pzLocked = 60 * 1000

huntingDuration = 60 * 1000

criticalHitChance = 7

criticalHitMultiplier = 1

displayCriticalHitNotify = false

removeWeaponAmmunition = false

removeWeaponCharges = true

removeRuneCharges = true

whiteSkullTime = 10 * 60 * 1000

noDamageToSameLookfeet = false

showHealingDamage = false

showHealingDamageForMonsters = false

fieldOwnershipDuration = 5 * 1000

stopAttackingAtExit = false

loginProtectionPeriod = 10 * 1000

deathLostPercent = 10

stairhopDelay = 2 * 1000

pushCreatureDelay = 2 * 500

deathContainerId = 1987

gainExperienceColor = 215

addManaSpentInPvPZone = true

squareColor = 0

allowFightback = true

fistBaseAttack = 7

worldId = 0

ip = "25.225.198.68"

bindOnlyGlobalAddress = false

loginPort = 7171

gamePort = 7172

loginTries = 10

retryTimeout = 5 * 1000

loginTimeout = 60 * 1000

maxPlayers = 400

motd = "*Welcome to Necrophus OTserv.*"

displayOnOrOffAtCharlist = false

onePlayerOnlinePerAccount = true

allowClones = false

serverName = "Necrophus OTserv"

loginMessage = "Welcome to Necrophus OTserv."

statusTimeout = 5 * 60 * 1000

replaceKickOnLogin = true

forceSlowConnectionsToDisconnect = false

loginOnlyWithLoginServer = false

premiumPlayerSkipWaitList = false

sqlType = "mysql"

sqlHost = "localhost"

sqlPort = 3306

sqlUser = "root"

sqlPass = "jr1010"

sqlDatabase = "otserv"

sqlFile = "otserv.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 = 60

buyableAndSellableHouses = true

houseNeedPremium = false

bedsRequirePremium = false

levelToBuyHouse = 100

housesPerAccount = 1

houseRentAsPrice = true

housePriceAsRent = true

housePriceEachSquare = 1000

houseRentPeriod = true

houseCleanOld = 0

guildHalls = false

timeBetweenActions = 200

timeBetweenExActions = 1000

hotkeyAimbotEnabled = true

mapName = "realmap.otbm"

mapAuthor = "Catrax"

randomizeTiles = true

storeTrash = true

cleanProtectedZones = true

mailboxDisabledTowns = ""

defaultPriority = "high"

niceLevel = 5

coresUsed = "-1"

startupDatabaseOptimization = true

updatePremiumStateAtStartup = 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/"

logsDirectory = "data/logs/"

bankSystem = true

displaySkillLevelOnAdvance = false

promptExceptionTracerErrorBox = true

maximumDoorLevel = 500

maxMessageBuffer = 4

separateVipListPerCharacter = false

vipListDefaultLimit = 20

vipListDefaultPremiumLimit = 100

saveGlobalStorage = true

useHouseDataStorage = false

storePlayerDirection = false

checkCorpseOwner = true

monsterLootMessage = 3

monsterLootMessageType = 25

ghostModeInvisibleEffect = false

ghostModeSpellEffects = true

idleWarningTime = 14 * 60 * 10000000000

idleKickTime = 14 * 60 * 10000000000

reportsExpirationAfterReads = 1

playerQueryDeepness = 2

tileLimit = 0

protectionTileLimit = 0

houseTileLimit = 0

freePremium = false

premiumForPromotion = false

blessings = true

blessingOnlyPremium = false

blessingReductionBase = 30

blessingReductionDecrement = 5

eachBlessReduction = 8

experienceStages = true

rateExperience = 80.0

rateExperienceFromPlayers = 2

rateSkill = 20.0

rateMagic = 10.0

rateLoot = 2.0

rateSpawn = 2

rateMonsterHealth = 1.0

rateMonsterMana = 1.0

rateMonsterAttack = 1.0

rateMonsterDefense = 1.0

minLevelThresholdForKilledPlayer = 0.9

maxLevelThresholdForKilledPlayer = 1.1

rateStaminaLoss = 1

rateStaminaGain = 3

rateStaminaThresholdGain = 24

staminaRatingLimitTop = 40 * 60

staminaRatingLimitBottom = 14 * 60

staminaLootLimit = 14 * 60

rateStaminaAboveNormal = 1.0

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

deSpawnRange = 2

deSpawnRadius = 50

maxPlayerSummons = 2

teleportAllSummons = false

teleportPlayerSummons = false

statusPort = 7171

ownerName = "Spectrum OTserv"

ownerEmail = "[email protected]"

url = "http://revolutionot.no-ip.org/"

location = "brazil"

displayGamemastersWithOnlineCommand = false

displayPlayersLogging = true

prefixChannelLogs = ""

runFile = ""

outputLog = ""

truncateLogonstartup = false

managerPort = 7171

managerLogs = true

managerPassword = ""

managerLocalhostOnly = true

managerConnectionsLimit = 1

adminPort = 7171

adminLogs = true

adminPassword = ""

adminLocalhostOnly = true

adminConnectionsLimit = 1

adminRequireLogin = true

adminEncryption = ""

adminEncryptionData = ""

 

6cb96129-c6fb-49ca-8267-4cbf4f41578c.gif

Link para o post
Compartilhar em outros sites
  • 2 years later...

ake ta do msm jeito e tenho 1 otserve que eu boto o meu ip e ele nao entra ainda nao descobri como rezouver ele so abri com o ip que tava antes quando boto meu ip ele nao abriu 

Link para o post
Compartilhar em outros sites
  • 10 months later...

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...

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.

×
×
  • Criar Novo...

Informação Importante

Confirmação de Termo