xTibia

.com
RO

Nao consigo conectar database com otserver

Por Rodrigo1521, 03 de abr. de 2014 em Archived

dúvida
tibia
otserv
10
1.2k
Rodrigo1521R
03 de abril de 2014 às 14:04

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

KranzixK
03 de abril de 2014 às 15:10

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

Rodrigo1521R
03 de abril de 2014 às 15:20

bem ta encryptionType = "sha1"

Editado Abril 3 por Rodrigo1521

KranzixK
03 de abril de 2014 às 15:22

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

Rodrigo1521R
03 de abril de 2014 às 15:25

esta igualzinho ao que vc postou no spolier

KranzixK
03 de abril de 2014 às 15:27

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

Rodrigo1521R
03 de abril de 2014 às 15:30
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"


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

KranzixK
03 de abril de 2014 às 15:37

no seu distro aparece algum erro?

Rodrigo1521R
03 de abril de 2014 às 17:01

sou meio novo aqui oque e distro


Ninguem pra tentar me ajudar vou encerrar o topico

Editado Abril 3 por Rodrigo1521

VictorWEBMasterV
03 de abril de 2014 às 17:52

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