[Resolvido] Can't connect to MySQL database.Help

[zamurai 30]

STEP 2

Check database connection

If you don't see any errors press link to STEP 3 - Add tables and columns to DB. If you see some errors it mean server has wrong configuration. Check FAQ or ask author of acc. maker.Can't connect to MySQL database.

Olhe Minha Config.

accountManager = false

namelockManager = true

newPlayerChooseVoc = true

newPlayerSpawnPosX = 1000

newPlayerSpawnPosY = 1000

newPlayerSpawnPosZ = 10

newPlayerTownId = 1

newPlayerLevel = 100

newPlayerMagicLevel = 0

generateAccountNumber = false

redSkullLength = 24 * 60 * 60

blackSkullLength = 24 * 60 * 60

dailyFragsToRedSkull = 50

weeklyFragsToRedSkull = 100

monthlyFragsToRedSkull = 150

dailyFragsToBlackSkull = dailyFragsToRedSkull

weeklyFragsToBlackSkull = weeklyFragsToRedSkull

monthlyFragsToBlackSkull = monthlyFragsToRedSkull

dailyFragsToBanishment = dailyFragsToRedSkull

weeklyFragsToBanishment = weeklyFragsToRedSkull

monthlyFragsToBanishment = monthlyFragsToRedSkull

blackSkulledDeathHealth = 1

blackSkulledDeathMana = 0

useBlackSkull = true

useFragHandler = true

advancedFragList = true

notationsToBan = 999

warningsToFinalBan = 999

warningsToDeletion = 999

banLength = 7 * 24 * 60 * 60

killsBanLength = 24 * 60 * 60

finalBanLength = 30 * 24 * 60 * 60

ipBanishmentLength = 1 * 24 * 60 * 60

broadcastBanishments = true

maxViolationCommentSize = 200

violationNameReportActionType = 2

autoBanishUnknownBytes = false

worldType = "pvp-enforced"

protectionLevel = 1

pvpTileIgnoreLevelAndVocationProtection = true

pzLocked = 40 * 1000

huntingDuration = 60 * 1000

criticalHitChance = 7

criticalHitMultiplier = 1

displayCriticalHitNotify = true

removeWeaponAmmunition = false

removeWeaponCharges = false

removeRuneCharges = false

whiteSkullTime = 9 * 60 * 1000

noDamageToSameLookfeet = true

showHealingDamage = false

showHealingDamageForMonsters = false

fieldOwnershipDuration = 5 * 1000

stopAttackingAtExit = false

oldConditionAccuracy = false

loginProtectionPeriod = 1000

deathLostPercent = 1

stairhopDelay = 1000

pushCreatureDelay = 1000

deathContainerId = 1987

gainExperienceColor = 215

addManaSpentInPvPZone = true

squareColor = 0

allowFightback = true

worldId = 0

ip = "facanatesoura.servegame.com"

bindOnlyConfiguredIpAddress = false

loginPort = 7171

gamePort = 7172

adminPort = 7171

statusPort = 7171

loginTries = 5

retryTimeout = 2 * 1000

loginTimeout = 30 * 1000

maxPlayers = 977

motd = "Welcome to the Facanatesoura! 8.60"

displayOnOrOffAtCharlist = false

onePlayerOnlinePerAccount = false

allowClones = false

serverName = "RookWar 8.60"

loginMessage = "Welcome to the Facanatespira! 8.60"

statusTimeout = 5 * 60 * 1000

replaceKickOnLogin = true

forceSlowConnectionsToDisconnect = false

loginOnlyWithLoginServer = false

premiumPlayerSkipWaitList = false

sqlType = "mysql"

sqlHost = "127.0.0.1"

sqlPort = 3306

sqlUser = "root"

sqlPass = "33472544"

sqlDatabase = "otserv"

sqlFile = "forgottenserver.s3db"

sqlKeepAlive = 1

mysqlReadTimeout = 10

mysqlWriteTimeout = 10

encryptionType = "plain"

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

bedsRequirePremium = true

levelToBuyHouse = 1

housesPerAccount = 0

houseRentAsPrice = false

housePriceAsRent = false

housePriceEachSquare = 1000

houseRentPeriod = "never"

houseCleanOld = 0

guildHalls = false

timeBetweenActions = 200

timeBetweenExActions = 1000

hotkeyAimbotEnabled = true

mapName = "rookwar"

mapAuthor = "Morrison"

randomizeTiles = true

storeTrash = true

cleanProtectedZones = true

mailboxDisabledTowns = "-1"

defaultPriority = "high"

niceLevel = 5

coresUsed = "-1"

optimizeDatabaseAtStartup = true

removePremiumOnInit = false

confirmOutdatedVersion = false

formulaLevel = 5.0

formulaMagic = 1.0

bufferMutedOnSpellFailure = false

spellNameInsteadOfWords = True

emoteSpells = true

allowChangeOutfit = true

allowChangeColors = false

allowChangeAddons = true

disableOutfitsForPrivilegedPlayers = false

addonsOnlyPremium = true

dataDirectory = "data/"

bankSystem = true

displaySkillLevelOnAdvance = false

promptExceptionTracerErrorBox = true

separateViplistPerCharacter = false

maximumDoorLevel = 500

maxMessageBuffer = 6

saveGlobalStorage = true

useHouseDataStorage = false

storePlayerDirection = true

checkCorpseOwner = true

monsterLootMessage = 0

monsterLootMessageType = 25

ghostModeInvisibleEffect = true

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

experienceStages = false

rateExperience = 10

rateExperienceFromPlayers = 10

rateSkill = 15.0

rateMagic = 12.0

rateLoot = 4.0

rateSpawn = 1

rateMonsterHealth = 1.0

rateMonsterMana = 1.0

rateMonsterAttack = 1.0

rateMonsterDefense = 1.0

minLevelThresholdForKilledPlayer = 0

maxLevelThresholdForKilledPlayer = 0

rateStaminaLoss = 1

rateStaminaGain = 3

rateStaminaThresholdGain = 12

staminaRatingLimitTop = 41 * 60

staminaRatingLimitBottom = 14 * 60

rateStaminaAboveNormal = 1.5

rateStaminaUnderNormal = 0.5

staminaThresholdOnlyPremium = true

experienceShareRadiusX = 15

experienceShareRadiusY = 15

experienceShareRadiusZ = 1

experienceShareLevelDifference = 2 / 3

extraPartyExperienceLimit = 20

extraPartyExperiencePercent = 5

experienceShareActivity = 2 * 60 * 1000

globalSaveEnabled = true

globalSaveHour = 1

shutdownAtGlobalSave = false

cleanMapAtGlobalSave = false

deSpawnRange = 2

deSpawnRadius = 30

maxPlayerSummons = 2

teleportAllSummons = false

teleportPlayerSummons = false

ownerName = "Tori Dox"

ownerEmail = "@tibiaking.com"

url = "http://tibiaking.com/"

location = "America"

displayGamemastersWithOnlineCommand = false

adminLogsEnabled = false

displayPlayersLogging = true

prefixChannelLogs = ""

runFile = ""

outLogName = ""

errorLogName = ""

truncateLogsOnStartup = false

[Kimoszin 1160]

A sua data base se chama forgottenserver.s3db ?

O password e user estão corretos?

[zamurai 30]

sim.tou usando xampp 1.7.7 pasword serto vou tirar print e mostrar como esta a database

Editado Abril 22, 2012 por zamurai (veja o histórico de edições)

[zamurai 30]

nao sei se tem erro olha ai

ow é pq ele é war serve nao aceita??como nao entendo muito

Editado Abril 22, 2012 por zamurai (veja o histórico de edições)

[ricardo3 60]

mude esta config:

sqlType = "mysql"

sqlHost = "127.0.0.1"

sqlPort = 3306

sqlUser = "root"

sqlPass = "33472544"

sqlDatabase = "otserv"

sqlFile = "forgottenserver.s3db"

sqlKeepAlive = 1

mysqlReadTimeout = 10

mysqlWriteTimeout = 10

encryptionType = "plain"

para:

sqlType = "mysql"

sqlHost = "localhost"

sqlPort = 3306

sqlUser = "root"

sqlPass = "33472544"

sqlDatabase = "otserv"

sqlFile = "otserv"

sqlKeepAlive = 1

mysqlReadTimeout = 10

mysqlWriteTimeout = 10

encryptionType = "plain"

qualquer erro reporte

Editado Abril 22, 2012 por ricardo3 (veja o histórico de edições)

[zamurai 30]

Can't connect to MySQL database.

denovo

Editado Abril 22, 2012 por zamurai (veja o histórico de edições)

[ricardo3 60]

este seu server esta com website?

[zamurai 30]

estou tentando colocar mais ele fala que nao esta conectado a database¬¬

[ricardo3 60]

pode me passar seu msn?

[zamurai 30]

[email protected]

[Onitsuk 5]

Como você configurou na hora de instalar o modern acc?

[ricardo3 60]

@Onitsuk

para remover este erro reinstale o Xampp e marque a opção Apache e MySQL.. s=em seguida do diretório de onde sera instalado

[Kimoszin 1160]

Eu vi que tem um erro no seu config.lua, aonde diz IP é o ip da sua maquina e não do servidor.

[Skydangerous 374]

poxa.

tópico está lugar errado.

irei mover para o lugar certo.

até.

[matacotoco 1]

mude esta config:

para:

qualquer erro reporte

VLWW! FIZ OQUE VC DISSE AQUI E FUNCIONOU BUNITIn!!

CARALHO TU ME SALVO HAHAAH!!!!

VLW MSM!

[ricardo3 60]

'-' dei uma dentro UHUHUHUHUH'

[zamurai 30]

ja resolvi dexa queto

[Godfather 45]

ja resolvi dexa queto

como ?

[Dornellas 59]

Como foi resolvido o problema?? @zamurai

Estou precisando de algumas soluções pra tentar fazer o meu funcionar