Postado Janeiro 15, 2014 11 anos Fala glr blz? Então to com um mapa bem louco, e pretendo criar meu server com ele, mas o servidor só funciona se tiver site, ou seja ele é mysql só para qm sabe mexer com xampp etc... Teria como eu mudar isso? Botar pra ser apenas por accmanager? Já mudei no config.lua e botei como modo sqlitle, no accmanager mudei para true. Mesmo assim continua dando esse error no distro\/ [19:53:13.778] >> Loading config <config.lua> [19:53:13.779] >> Opening logs [19:53:13.808] > Using plaintext encryption [19:53:13.840] > WARNING: This method is completely unsafe! [19:53:13.840] > Please set encryptiontype = "sha1' <or any other available method> in config.lua [19:53:44.351] >> Checking software version...failed checking - malformed file. [19:53:44.352] >> Loading RSA Key [19:53:44.353] >> Starting SQL connection [19:53:45.352] Failed connecting to database - MYSQL ERROR: Can't connect to MySQL server on 'localhost' [19:53:45.353] > ERROR: Couldn't estabilish connection to SQL database! Sinceramente quero resolver isso pq fiquei muito tempo atrs desse mapa e gostaria de ter um servidor com ele. Já fiz outros tópicos sobre esse error, mas sem sucesso então dei como resolvido. Agradeço desde já.. Editado Janeiro 15, 2014 11 anos por Kd meu arrozz (veja o histórico de edições)
Postado Janeiro 15, 2014 11 anos Autor accountManager = false namelockManager = true newPlayerChooseVoc = true newPlayerSpawnPosX = 160 newPlayerSpawnPosY = 50 newPlayerSpawnPosZ = 8 newPlayerTownId = 1 newPlayerLevel = 10 newPlayerMagicLevel = 1 generateAccountNumber = false redSkullLength = 10 * 24 * 60 * 60 blackSkullLength = 20 * 24 * 60 * 60 dailyFragsToRedSkull = 5 weeklyFragsToRedSkull = 10 monthlyFragsToRedSkull = 20 dailyFragsToBlackSkull = dailyFragsToRedSkull weeklyFragsToBlackSkull = weeklyFragsToRedSkull monthlyFragsToBlackSkull = monthlyFragsToRedSkull dailyFragsToBanishment = dailyFragsToRedSkull weeklyFragsToBanishment = weeklyFragsToRedSkull monthlyFragsToBanishment = monthlyFragsToRedSkull blackSkulledDeathHealth = 40 blackSkulledDeathMana = 0 useBlackSkull = true useFragHandler = true advancedFragList = true notationsToBan = 3 warningsToFinalBan = 4 warningsToDeletion = 5 banLength = 3 * 24 * 60 * 60 killsBanLength = 2 * 24 * 60 * 60 finalBanLength = 7 * 24 * 60 * 60 ipBanishmentLength = 7 * 24 * 60 * 60 broadcastBanishments = false maxViolationCommentSize = 200 violationNameReportActionType = 2 autoBanishUnknownBytes = true worldType = "2" protectionLevel = 50 pvpTileIgnoreLevelAndVocationProtection = true pzLocked = 10 * 1000 huntingDuration = 60 * 1000 criticalHitChance = 7 criticalHitMultiplier = 1 displayCriticalHitNotify = true removeWeaponAmmunition = false removeWeaponCharges = false removeRuneCharges = false whiteSkullTime = 5 * 60 * 1000 noDamageToSameLookfeet = false showHealingDamage = true showHealingDamageForMonsters = true 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 = "ipaki" bindOnlyConfiguredIpAddress = false loginPort = 7171 gamePort = 7172 adminPort = 7171 statusPort = 7171 loginTries = 10 retryTimeout = 5 * 1000 loginTimeout = 60 * 1000 maxPlayers = 300 motd = "Welcome to the VIPOT ROX Server, brevemente novidades!!!" displayOnOrOffAtCharlist = false onePlayerOnlinePerAccount = false allowClones = true serverName = "VIPOT ROX" loginMessage = "Welcome to the VIPOT ROX Server, brevemente novidades sobre VIP!!!!" statusTimeout = 5 * 60 * 1000 replaceKickOnLogin = true forceSlowConnectionsToDisconnect = false loginOnlyWithLoginServer = false premiumPlayerSkipWaitList = false sqlType = "mysql" sqlHost = "localhost" sqlPort = 3306 sqlUser = "root" sqlPass = "" sqlDatabase = "maelstrom" sqlFile = "crazy.s3db" sqlKeepAlive = 0 mysqlReadTimeout = 10 mysqlWriteTimeout = 10 encryptionType = "plain" deathListEnabled = true deathListRequiredTime = 2 * 60 * 1000 deathAssistCount = 19 maxDeathRecords = 5 ingameGuildManagement = true levelToFormGuild = 25 premiumDaysToFormGuild = 0 guildNameMinLength = 4 guildNameMaxLength = 20 highscoreDisplayPlayers = 10 updateHighscoresAfterMinutes = 15 buyableAndSellableHouses = true houseNeedPremium = true bedsRequirePremium = true levelToBuyHouse = 50 housesPerAccount = 0 houseRentAsPrice = false housePriceAsRent = false housePriceEachSquare = 5000 houseRentPeriod = "never" houseCleanOld = 0 guildHalls = true timeBetweenActions = 200 timeBetweenExActions = 1000 checkCorpseOwner = true hotkeyAimbotEnabled = true maximumDoorLevel = 500 mapName = "Hunted.otbm" mapAuthor = "CrazyBoY" 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 = false displaySkillLevelOnAdvance = true spellNameInsteadOfWords = false emoteSpells = true promptExceptionTracerErrorBox = true storePlayerDirection = false monsterLootMessage = 3 monsterLootMessageType = 25 separateViplistPerCharacter = false ghostModeInvisibleEffect = true ghostModeSpellEffects = true idleWarningTime = 14 * 60 * 1000 idleKickTime = 30 * 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 = 10.0 rateExperienceFromPlayers = 0 rateSkill = 5.0 rateMagic = 5.0 rateLoot = 1.5 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.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 = false cleanMapAtGlobalSave = false deSpawnRange = 2 deSpawnRadius = 50 maxPlayerSummons = 2 teleportAllSummons = false teleportPlayerSummons = false ownerName = "Crazy Team" ownerEmail = "crazyot_team@hotmail.com" url = "http://avesdomarcio.vai.la/" location = "Portugal" displayGamemastersWithOnlineCommand = true adminLogsEnabled = false displayPlayersLogging = true prefixChannelLogs = "" runFile = "" outLogName = "" errorLogName = "" truncateLogsOnStartup = false
Postado Janeiro 15, 2014 11 anos verifique se o nome está correto em SQL, no caso se está de acordo com o arquivo: sqlDatabase = "maelstrom" sqlFile = "crazy.s3db" E substitua no config.lua: Mostrar conteúdo oculto accountManager = false namelockManager = true newPlayerChooseVoc = true newPlayerSpawnPosX = 160 newPlayerSpawnPosY = 50 newPlayerSpawnPosZ = 8 newPlayerTownId = 1 newPlayerLevel = 10 newPlayerMagicLevel = 1 generateAccountNumber = false redSkullLength = 10 * 24 * 60 * 60 blackSkullLength = 20 * 24 * 60 * 60 dailyFragsToRedSkull = 5 weeklyFragsToRedSkull = 10 monthlyFragsToRedSkull = 20 dailyFragsToBlackSkull = dailyFragsToRedSkull weeklyFragsToBlackSkull = weeklyFragsToRedSkull monthlyFragsToBlackSkull = monthlyFragsToRedSkull dailyFragsToBanishment = dailyFragsToRedSkull weeklyFragsToBanishment = weeklyFragsToRedSkull monthlyFragsToBanishment = monthlyFragsToRedSkull blackSkulledDeathHealth = 40 blackSkulledDeathMana = 0 useBlackSkull = true useFragHandler = true advancedFragList = true notationsToBan = 3 warningsToFinalBan = 4 warningsToDeletion = 5 banLength = 3 * 24 * 60 * 60 killsBanLength = 2 * 24 * 60 * 60 finalBanLength = 7 * 24 * 60 * 60 ipBanishmentLength = 7 * 24 * 60 * 60 broadcastBanishments = false maxViolationCommentSize = 200 violationNameReportActionType = 2 autoBanishUnknownBytes = true worldType = "2" protectionLevel = 50 pvpTileIgnoreLevelAndVocationProtection = true pzLocked = 10 * 1000 huntingDuration = 60 * 1000 criticalHitChance = 7 criticalHitMultiplier = 1 displayCriticalHitNotify = true removeWeaponAmmunition = false removeWeaponCharges = false removeRuneCharges = false whiteSkullTime = 5 * 60 * 1000 noDamageToSameLookfeet = false showHealingDamage = true showHealingDamageForMonsters = true 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 = "ipaki" bindOnlyConfiguredIpAddress = false loginPort = 7171 gamePort = 7172 adminPort = 7171 statusPort = 7171 loginTries = 10 retryTimeout = 5 * 1000 loginTimeout = 60 * 1000 maxPlayers = 300 motd = "Welcome to the VIPOT ROX Server, brevemente novidades!!!" displayOnOrOffAtCharlist = false onePlayerOnlinePerAccount = false allowClones = true serverName = "VIPOT ROX" loginMessage = "Welcome to the VIPOT ROX Server, brevemente novidades sobre VIP!!!!" statusTimeout = 5 * 60 * 1000 replaceKickOnLogin = true forceSlowConnectionsToDisconnect = false loginOnlyWithLoginServer = false premiumPlayerSkipWaitList = false sqlType = "mysql" sqlHost = "localhost" sqlPort = 3306 sqlUser = "root" sqlPass = "" sqlDatabase = "maelstrom" sqlFile = "crazy.s3db" sqlKeepAlive = 0 mysqlReadTimeout = 10 mysqlWriteTimeout = 10 encryptionType = "sha1" deathListEnabled = true deathListRequiredTime = 2 * 60 * 1000 deathAssistCount = 19 maxDeathRecords = 5 ingameGuildManagement = true levelToFormGuild = 25 premiumDaysToFormGuild = 0 guildNameMinLength = 4 guildNameMaxLength = 20 highscoreDisplayPlayers = 10 updateHighscoresAfterMinutes = 15 buyableAndSellableHouses = true houseNeedPremium = true bedsRequirePremium = true levelToBuyHouse = 50 housesPerAccount = 0 houseRentAsPrice = false housePriceAsRent = false housePriceEachSquare = 5000 houseRentPeriod = "never" houseCleanOld = 0 guildHalls = true timeBetweenActions = 200 timeBetweenExActions = 1000 checkCorpseOwner = true hotkeyAimbotEnabled = true maximumDoorLevel = 500 mapName = "Hunted.otbm" mapAuthor = "CrazyBoY" 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 = false displaySkillLevelOnAdvance = true spellNameInsteadOfWords = false emoteSpells = true promptExceptionTracerErrorBox = true storePlayerDirection = false monsterLootMessage = 3 monsterLootMessageType = 25 separateViplistPerCharacter = false ghostModeInvisibleEffect = true ghostModeSpellEffects = true idleWarningTime = 14 * 60 * 1000 idleKickTime = 30 * 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 = 10.0 rateExperienceFromPlayers = 0 rateSkill = 5.0 rateMagic = 5.0 rateLoot = 1.5 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.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 = false cleanMapAtGlobalSave = false deSpawnRange = 2 deSpawnRadius = 50 maxPlayerSummons = 2 teleportAllSummons = false teleportPlayerSummons = false ownerName = "Crazy Team" ownerEmail = "crazyot_team@hotmail.com" url = "http://avesdomarcio.vai.la/" location = "Portugal" displayGamemastersWithOnlineCommand = true adminLogsEnabled = true displayPlayersLogging = true prefixChannelLogs = "" runFile = "" outLogName = "" errorLogName = "" truncateLogsOnStartup = true
Postado Janeiro 15, 2014 11 anos Autor Está correto, no sqltype já mudei de mysql para sqlitle, mas da o msm error, no próprio tk a um tópico de um dos criadores do mapa q eu estou usando, falando exatamente assim, logo abaixo\/ Este servidor é 100% baseado no OpenTibia SVN, ou sejá, este server não possui uma versão SQLite, este server não possui Account Manager, ou seja... este server é apenas para quem sabe mexer com xampp e website. É isso que quero mudar, quero que o server seja por acc manager.
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.