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 = "la_noche_larga@hotmail.com"

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

  • 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 = "la_noche_larga@hotmail.com"

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
  Em 26/08/2012 em 09:34, kleiton nascimento disse:

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

Expand   Mostrar mais  

Só baixar e jogar dentro da pasta do seu ot

Hidden Content

    Give reaction to this post to see the hidden content.

Link para o post
Compartilhar em outros sites

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

    96842
    Tópicos
    519603
    Posts



×
×
  • Criar Novo...

Informação Importante

Confirmação de Termo