Nao consigo conectar database com otserver

[Rodrigo1521 0]

Bom galera não sei se é aqui esse tipo de reclamação

Mais to com um problema serio eu configurei o mysql no xampp e fiz funcionar o site tudo normal e tabem consegui conectar o ot server tranquilo ou seja o site ta rodando tirei os bugs so que eu nao consigo fazer algo eu crio o char no site mais nao consigo jogar com ele tipo nao faz a conexão eu tenho o ipchanger e o tibia com a versao correta mais ele nao reconheçe o char criado no site........ se alguem puder me ajudar agradeço

[Kranzix 47]

você colocou sha1 no config.lua?

Caso não, edite essa tab do config.lua do seu otserv:

 

 

 

encryptionType = "plain"

 

para:

 

 

 

encryptionType = "sha1"

 

Editado Abril 3, 2014 por Kranzix

[Rodrigo1521 0]

bem ta encryptionType = "sha1"

Editado Abril 3, 2014 por Rodrigo1521

[Kranzix 47]

você tirou todas as linhas ---- ??

[Rodrigo1521 0]

esta igualzinho ao que vc postou no spolier

[Kranzix 47]

você pode postar seu config.lua aqui para eu dar um olhada?

[Rodrigo1521 0]

AccountManager = false

namelockManager = true

newPlayerChooseVoc = true

newPlayerSpawnPosX = 32360

newPlayerSpawnPosY = 31782

newPlayerSpawnPosZ = 7

newPlayerTownId = 1

newPlayerLevel = 8

newPlayerMagicLevel = 0

generateAccountNumber = false

generateAccountSalt = false

useRookSystem = false

rookTownId = 1

rookLevelToGetRooked = 5

rookLevelToLeaveRook = 8

useFragHandler = true

redSkullLength = 3 * 24 * 60 * 60

blackSkullLength = 5 * 24 * 60 * 60

fragsLimit = 24 * 60 * 60

fragsSecondLimit = 7 * 24 * 60 * 60

fragsThirdLimit = 30 * 24 * 60 * 60

fragsToRedSkull = 10

fragsSecondToRedSkull = 40

fragsThirdToRedSkull = 60

fragsToBlackSkull = fragsToRedSkull

fragsSecondToBlackSkull = fragsSecondToRedSkull

fragsThirdToBlackSkull = fragsThirdToRedSkull

fragsToBanishment = fragsToRedSkull

fragsSecondToBanishment = fragsSecondToRedSkull

fragsThirdToBanishment = fragsThirdToRedSkull

blackSkulledDeathHealth = 40

blackSkulledDeathMana = 0

useBlackSkull = true

advancedFragList = false

notationsToBan = 3

warningsToFinalBan = 4

warningsToDeletion = 5

do Ban = 7 * 24 * 60 * 60

killsBanLength = 7 * 24 * 60 * 60

finalBanLength = 30 * 24 * 60 * 60

ipBanLength = 1 * 24 * 60 * 60

allowedMaxSizePackets = 20

WorldType = "open"

protectionLevel = 50

pvpTileIgnoreLevelAndVocationProtection = true

pzLocked = 60 * 1000

huntingDuration = 60 * 1,000

criticalHitChance = 7

criticalHitMultiplier = 1

displayCriticalHitNotify = false

removeWeaponAmmunition = false

removeWeaponCharges = true

removeRuneCharges = false

whiteSkullTime = 15 * 60 * 1000

noDamageToSameLookfeet = false

showHealthChange = true

showManaChange = true

showHealthChangeForMonsters = false

showManaChangeForMonsters = false

fieldOwnershipDuration = 5 * 1000

stopAttackingAtExit = false

loginProtectionPeriod = 10 * 1000

deathLostPercent = 10

stairhopDelay = 2 * 1000

pushCreatureDelay = 2 * 1000

deathContainerId = 1987

gainExperienceColor = 215

addManaSpentInPvPZone = true

recoverManaAfterDeathInPvPZone = false

squareColor = 0

allowFightback = true

fistBaseAttack = 7

= true useFairfightReduction

optionalWarAttackableAlly = false

worldId = 0

ip = "127.0.0.1"

bindOnlyGlobalAddress = false

loginPort = 7171

porta de jogos = "7172"

loginTries = 3

RetryTimeout = 5 * 1000

loginTimeout = 60 * 1000

maxplayers = 1000

motd = "Bem-vindo ao Ot-Soft Global, Voce esta utilizando hum servico pago Ot-Soft!"

displayOnOrOffAtCharlist = false

onePlayerOnlinePerAccount = true

allowClones = 0

serverName = "OTServer"

loginMessage = "Welcome to the Ot!"

statusTimeout = 5 * 60 * 1000

= true replaceKickOnLogin

forceSlowConnectionsToDisconnect = false

loginOnlyWithLoginServer = false

premiumPlayerSkipWaitList = false

rsaPrime1 = "14299623962416399520070177382898895550795403345466153217470516082934737582776038882967213386204600674145392845853859217990626450972452084065728686565928113"

rsaPrime2 = "7630979195970404721891201847792002125535401292779123937207447574596692788513647179235335529307251350570728407373705564708871762033017096809910315212884101"

rsaPublic = "65537"

rsaModulus = "109120132967399429278860960508995541528237502902798129123468757937266291492576446330739696001110603907230888610072655818825358503429057592827629436413108566029093628212635953836686562675849720620786279431090218017681061521755056710823876476444260558147179707119674283982419152118103759076030616683978566631413"

rsaPrivate = "46730330223584118622160180015036832148732986808519344675210555262940258739805766860224610646919605860206328024326703361630109888417839241959507572247284807035235569619173792292786907845791904955103601652822519121908367187885509270025388641700821735345222087940578381210879116823013776808975766851829020659073"

SQLType = "mysql"

sqlhost = "localhost"

sqlPort = 3306

sqluser = "root"

sqlPass = ""

SqlDatabase = "OTServer"

SQLFile = "mysql.sql"

sqlKeepAlive = 0

mysqlReadTimeout = 10

mysqlWriteTimeout = 10

mysqlReconnectionAttempts = 3

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

housesPerAccount = 0

houseRentAsPrice = false

housePriceAsRent = false

housePriceEachSquare = 1000

houseSkipInitialRent = true

houseRentPeriod = "nunca"

houseCleanOld = 0

guildhalls = false

houseProtection = true

timeBetweenActions = 200

timeBetweenExActions = 1000

timeBetweenCustomActions = 500

hotkeyAimbotEnabled = true

tibiaClassicSlots = false

canOnlyRopePlayers = true

mapName = "realmap.otbm"

mapAuthor = "Siramix"

randomizeTiles = true

storeTrash = true

cleanProtectedZones = true

mailboxDisabledTowns = ""

mailMaxAttempts = 20

mailBlockPeriod = 60 * 60 * 1000

mailAttemptsFadeTime = 10 * 60 * 1000

marketEnabled = true

marketOfferDuration = 30 * 24 * 60 * 60

premiumToCreateMarketOffer = false

checkExpiredMarketOffersEachMinutes = 60

maxMarketOffersAtATimePerPlayer = 100

daemonize = false

DefaultPriority = "high"

niceLevel = 5

serviceThreads = 1

coresUsed = "-1"

startupDatabaseOptimization = true

updatePremiumStateAtStartup = true

confirmOutdatedVersion = false

skipItemsVersionCheck = false

formulaLevel = 5,0

formulaMagic = 2,0

bufferMutedOnSpellFailure = false

spellNameInsteadOfWords = false

emoteSpells = false

unifiedSpells = true

enableCooldowns = true

allowChangeOutfit = true

allowChangeColors = true

allowChangeAddons = true

disableOutfitsForPrivilegedPlayers = false

addonsOnlyPremium = false

DataDirectory = "data /"

logsDirectory = "data / logs /"

bankSystem = true

promptExceptionTracerErrorBox = true

maximumDoorLevel = 500

maxMessageBuffer = 4

tradeLimit = 100

useCapacity = true

playerFollowExhaust = 0

defaultDepotSizePremium = 2000

defaultDepotSize = 1000

useMounts = true

unmountPlayerInPz = true

separateVipListPerCharacter = false

vipListDefaultLimit = 20

vipListDefaultPremiumLimit = 100

houseDataStorage = "binário"

saveGlobalStorage = true

storePlayerDirection = false

savePlayerData = true

checkCorpseOwner = true

monsterLootMessage = 3

monsterLootMessageType = 29

ghostModeInvisibleEffect = false

ghostModeSpellEffects = true

idleWarningTime = 14 * 60 * 1000

idleKickTime = 60 * 60 * 1000

reportsExpirationAfterReads = 1

playerQueryDeepness = -1

tileLimit = 0

protectionTileLimit = 0

houseTileLimit = 0

freePremium = false

premiumForPromotion = false

bênçãos = true

blessingOnlyPremium = false

blessingReductionBase = 30

blessingReductionDecrement = 5

eachBlessReduction = 8

pvpBlessingThreshold = 40

fairFightTimeRange = 60

experienceStages = true

rateExperience = 50,0

rateExperienceFromPlayers = 0

rateSkill = 30,0

rateMagic = 20,0

rateLoot = 3,5

rateSpawnMin = 1

rateSpawnMax = 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 = 40 * 60

staminaRatingLimitBottom = 14 * 60

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

globalSaveMinute = 0

shutdownAtGlobalSave = true

cleanMapAtGlobalSave = false

closeInstanceOnShutdown = true

deSpawnRange = 2

deSpawnRadius = 50

monsterSpawnWalkback = true

allowBlockSpawn = true

maxPlayerSummons = 2

teleportAllSummons = false

teleportPlayerSummons = false

StatusPort = 7171

ownerName = "Ot Soft"

owneremail = "@ ot_soft Nos Siga No facebook"

url = " http://ot-soft.com "

location = "Europa"

displayGamemastersWithOnlineCommand = false

disableLuaErrors = 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 = ""

Editado Abril 3, 2014 por Rodrigo1521

[Kranzix 47]

no seu distro aparece algum erro?

[Rodrigo1521 0]

sou meio novo aqui oque e distro

Ninguem pra tentar me ajudar vou encerrar o topico

Editado Abril 3, 2014 por Rodrigo1521

[VictorWEBMaster 369]

Amigo, sem as informações básicas não da para te ajudar...

 

• Qual website utilizado (postar link se possivel)
• Qual versão do website e do servidor
• Qual programa Utilizado para hospedar o website
• Qual tutorial seguido para instalação do site??