Outro ERROR: Couldn t estabilish connection to SQL database!

[Hokograma 57]

Diga em poucas palavras a base utilizada (Nome do servidor ou nome do website).

TFS 0.4;

 

Qual erro está surgindo/O que você procura?

Erro ao conectar com a database, não sei oq esta errado..  por sqlite esta normal.. site tbm esta funcionando 100%, no bugs

 

Você tem o código disponível? Se tiver publique-o aqui:

config.lua

 accountManager = true
namelockManager = false
newPlayerChooseVoc = true
newPlayerSpawnPosX = 160
newPlayerSpawnPosY = 54
newPlayerSpawnPosZ = 7
newPlayerTownId = 1
newPlayerLevel = 8
newPlayerMagicLevel = 0
generateAccountNumber = false

redSkullLength = 50 * 62 * 70 * 90
blackSkullLength = 64 * 72 * 80 * 95
dailyFragsToRedSkull = 25
weeklyFragsToRedSkull = 50
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 = 7 * 24 * 60 * 60
killsBanLength = 8 * 24 * 60 * 60
finalBanLength = 30 * 24 * 60 * 60
ipBanishmentLength = 1 * 24 * 60 * 60
broadcastBanishments = true
maxViolationCommentSize = 200
violationNameReportActionType = 2
autoBanishUnknownBytes = false

worldType = "open"
protectionLevel = 50
pvpTileIgnoreLevelAndVocationProtection = true
pzLocked = 20 * 700
huntingDuration = 60 * 1000
criticalHitChance = 7
criticalHitMultiplier = 1
displayCriticalHitNotify = true
removeWeaponAmmunition = false
removeWeaponCharges = false
removeRuneCharges = "no"
whiteSkullTime = 5 * 10 * 100
noDamageToSameLookfeet = false
showHealingDamage = false
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 = "177.156.95.29"
bindOnlyConfiguredIpAddress = false
loginPort = 7171
gamePort = 7172
adminPort = 7171
statusPort = 7171
loginTries = 10
retryTimeout = 5 * 1000
loginTimeout = 60 * 1000
maxPlayers = 999
motd = "Bem Vindo ao Legedary Crazy Server!"
displayOnOrOffAtCharlist = false
onePlayerOnlinePerAccount = true
allowClones = false
serverName = "Legendary Crazy Server"
loginMessage = "Bem-Vindo ao Legendary Crazy. Chame seus amigos e divirta-se."
statusTimeout = 5 * 60 * 1000
replaceKickOnLogin = true
forceSlowConnectionsToDisconnect = false
loginOnlyWithLoginServer = false
premiumPlayerSkipWaitList = false
enableCast = true

sqlType = "mysql"
sqlHost = "localhost"
sqlPort = 3306
sqlUser = "root"
sqlPass = "ntoelite123"
sqlDatabase = "database"
sqlFile = "forgottenserver.s3db"
sqlKeepAlive = 0
mysqlReadTimeout = 10
mysqlWriteTimeout = 10
encryptionType = "sha1"

deathListEnabled = true
deathListRequiredTime = 1 * 60 * 1000
deathAssistCount = 19
maxDeathRecords = 5

ingameGuildManagement = false
levelToFormGuild = 8
premiumDaysToFormGuild = 0
guildNameMinLength = 4
guildNameMaxLength = 20

highscoreDisplayPlayers = 100
updateHighscoresAfterMinutes = 2

buyableAndSellableHouses = true
houseNeedPremium = true
bedsRequirePremium = true
levelToBuyHouse = 500
housesPerAccount = 0
houseRentAsPrice = false
housePriceAsRent = false
housePriceEachSquare = 90000
houseRentPeriod = "never"
houseCleanOld = 0
guildHalls = false

timeBetweenActions = 200
timeBetweenExActions = 1000
checkCorpseOwner = true
hotkeyAimbotEnabled = true
maximumDoorLevel = 500

mapName = "database.otbm"
mapAuthor = "Baiak Lula"
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 = 1000 * 1000 * 10000
expireReportsAfterReads = 1
playerQueryDeepness = 2
maxItemsPerPZTile = 0
maxItemsPerHouseTile = 0

freePremium = true
premiumForPromotion = true

blessingOnlyPremium = true
blessingReductionBase = 30
blessingReductionDecreament = 5
eachBlessReduction = 8

experienceStages = true
rateExperience = 999
rateExperienceFromPlayers = 0
rateSkill = 20
rateMagic = 10
rateLoot = 2
rateSpawn = 2

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 = true
cleanMapAtGlobalSave = false

deSpawnRange = 2
deSpawnRadius = 50

maxPlayerSummons = 2
teleportAllSummons = false
teleportPlayerSummons = false

ownerName = "[ADM] Rasthegue"
ownerEmail = "[email protected]"
url = "http://www.tibiastaff.tk/"
location = "Brazil"
displayGamemastersWithOnlineCommand = false

adminLogsEnabled = false
displayPlayersLogging = true
prefixChannelLogs = ""
runFile = ""
outLogName = ""
errorLogName = ""
truncateLogsOnStartup = false

 

Você tem alguma imagem que possa auxiliar no problema? Se sim, coloque-a aqui.

[Mark Ackerman 16]

@Hokograma qual tipo de site ? verificou se o nome da database está o mesmo que o do config ?

[Hokograma 57]

@bismarkzika xampp, e sim o nome da minha database é > database < mesmo .. kk ta certinho

[Mark Ackerman 16]

@Hokograma em accountManager = true mude para false

ficando: accountManager = false

Editado Junho 29, 2018 por bismarkzika
dsg (veja o histórico de edições)

[Hokograma 57]

@bismarkzika isso n altera em nada n, mas mesmo assim tentei, porem nada aconteceu

[Mark Ackerman 16]

@Hokograma no config.lua muda o ip pra "127.0.0.1" e vê  oque acontece

[Hokograma 57]

@bismarkzika ja tentei tbm, mas fica na mesma

 

[Sueter 0]

sqlType = "mysql"
sqlHost = "coloque o ip aqui" -- tipo o ipv4 ou algo do tipo
sqlPort = 3306
sqlUser = "root"
sqlPass = "ntoelite123" -- tem senha para acessar sua base? não ache que isso coloca senha
sqlDatabase = "database" -- ctz q é esse nome da base?
sqlFile = "forgottenserver.s3db" -- isso não é para os que tem sqlite operando?
sqlKeepAlive = 0
mysqlReadTimeout = 10
mysqlWriteTimeout = 10

[Hokograma 57]

@Sueter  as info ta td certa, e a parada do ip tentei mudar pro ipv4 do meu no-ip tbm mas ainda assim o erro persiste

[Sueter 0]

No caso tenta ver se o teu xampp tem algum ip se tiver coloque ali, se n pegar coloca localhost

ve tb se a porta ta aberta no firewall, se o teu modem abre ela etc...

no caso a sqlPort = 3306

@Hokograma

n entendo muito de mysql...

[jppc2 0]

Verificou se não é nenhum problema na configuração do mysql?

 

 

Veja se está nesse estilo aqui. Se tem todos os privilégios e se é necessário  "fazer login".