Postado Dezembro 9, 2015 9 anos Olá galera do TIBIAKING, estou com um problema ao iniciar meu servidor de Tibia , quando vou iniciar o server aparece este erro - Failed connecting to database - MYSQL ERROR: Can't connect to MySQL server on 'localhost' <10061> <2003> ERROR: Couldn't estabilish connection to SQL database! Já olhei vários posts aqui sobre isso e não consegui resolver. Se alguém poder me ajudar com esse problema ficarei grato ! Segue abaixo minha config.lua .. \/ accountManager = "yes" namelockManager = "yes" newPlayerChooseVoc = "yes" newPlayerSpawnPosX = 143 newPlayerSpawnPosY = 61 newPlayerSpawnPosZ = 8 newPlayerTownId = 1 newPlayerLevel = 8 newPlayerMagicLevel = 1 generateAccountNumber = "no" redSkullLength = 24 * 60 * 60 blackSkullLength = 48 * 60 * 60 dailyFragsToRedSkull = 7 weeklyFragsToRedSkull = 30 monthlyFragsToRedSkull = 70 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 = 1 * 24 * 60 * 60 killsBanLength = 1 * 24 * 60 * 60 finalBanLength = 1 * 24 * 60 * 60 ipBanishmentLength = 1 * 24 * 60 * 60 broadcastBanishments = true maxViolationCommentSize = 200 violationNameReportActionType = 2 autoBanishUnknownBytes = false worldType = "open" protectionLevel = 100 pvpTileIgnoreLevelAndVocationProtection = true pzLocked = 2 * 60 * 1000 huntingDuration = 1 * 60 * 1000 criticalHitChance = 7 criticalHitMultiplier = 1 displayCriticalHitNotify = true removeWeaponAmmunition = false removeWeaponCharges = true removeRuneCharges = false whiteSkullTime = 3 * 60 * 1000 noDamageToSameLookfeet = false showHealingDamage = true showHealingDamageForMonsters = false fieldOwnershipDuration = 5 * 1000 stopAttackingAtExit = false oldConditionAccuracy = false loginProtectionPeriod = 10 * 1000 deathLostPercent = 10 stairhopDelay = 2 * 1000 pushCreatureDelay = 2 * 1000 deathContainerId = 1987 gainExperienceColor = 215 addManaSpentInPvPZone = true squareColor = 0 allowFightback = true worldId = 0 ip = "198.69.86.32" bindOnlyConfiguredIpAddress = false loginPort = 7171 gamePort = 7172 adminPort = 7171 statusPort = 7171 loginTries = 10 retryTimeout = 5 * 1000 loginTimeout = 60 * 1000 maxPlayers = 109 motd = "Bem Vindo ao Baiak criado por Absolute" displayOnOrOffAtCharlist = false onePlayerOnlinePerAccount = true allowClones = false serverName = "Baiak Absolute" loginMessage = "Bem Vindo ao Baiak criado por Absolute" statusTimeout = 5 * 60 * 1000 replaceKickOnLogin = true forceSlowConnectionsToDisconnect = false loginOnlyWithLoginServer = false premiumPlayerSkipWaitList = false sqlType = "mysql" sqlHost = "127.0.0.1" sqlPort = 3306 sqlUser = "root" sqlPass = "strop123" sqlDatabase = "otserv" sqlFile = "Baiak.s3db" sqlKeepAlive = 0 mysqlReadTimeout = 10 mysqlWriteTimeout = 10 encryptionType = "sha1" deathListEnabled = true deathListRequiredTime = 1 * 60 * 1000 deathAssistCount = 19 maxDeathRecords = 5 ingameGuildManagement = true levelToFormGuild = 150 premiumDaysToFormGuild = 0 guildNameMinLength = 4 guildNameMaxLength = 20 highscoreDisplayPlayers = 15 updateHighscoresAfterMinutes = 2 buyableAndSellableHouses = true houseNeedPremium = true bedsRequirePremium = true levelToBuyHouse = 150 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 Barao.otbm" mapAuthor = "Absolute" 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 = 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 = "yes" rateExperience = 900 rateExperienceFromPlayers = 0 rateSkill = 200 rateMagic = 80 rateLoot = 10 rateSpawn = 2 rateMonsterHealth = 1.0 rateMonsterMana = 1.0 rateMonsterAttack = 1.0 rateMonsterDefense = 1.0 -- Experience from players 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 = 1 shutdownAtGlobalSave = false cleanMapAtGlobalSave = false deSpawnRange = 2 deSpawnRadius = 50 maxPlayerSummons = 2 teleportAllSummons = false teleportPlayerSummons = false ownerName = "Absolute on Tibiaking" ownerEmail = "[email protected]" url = "www.tibiaking.com" location = "Brazil" displayGamemastersWithOnlineCommand = false adminLogsEnabled = false displayPlayersLogging = true prefixChannelLogs = "" runFile = "" outLogName = "" errorLogName = "" truncateLogsOnStartup = false
Postado Dezembro 9, 2015 9 anos sqlDatabase tem que ser o mesmo nome da database que voce criou no xampp sqlPassword tem que ser a mesma do phpmyadmin do xampp
Postado Dezembro 9, 2015 9 anos Autor 5 minutos atrás, Sekk disse: sqlDatabase tem que ser o mesmo nome da database que voce criou no xampp sqlPassword tem que ser a mesma do phpmyadmin do xampp Não estou usando XAMPP , somente o servidor , não quero meu ot com site por enquanto , mais pra frente talvez ..
Postado Dezembro 9, 2015 9 anos sqlite? Se for... tem que mudar a parte "mysql" pra "sqlite" ne cara -'-
Postado Dezembro 9, 2015 9 anos Autor 25 minutos atrás, Sekk disse: sqlite? Se for... tem que mudar a parte "mysql" pra "sqlite" ne cara -'- Valeu mano haha'
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.