[Dúvida] Can't Connect To Mysql Database.

[jeandoido 7]

Galera estou com uma dúvida triste

 

Eu uso internet compartilhada já desbloquiei as portas 80,7171,7172 no router e no firewall.

 

Os Steps vão normal.

 

 

STEP 1

 

Check server configuration

File config.lua loaded from C:/Documents and Settings/Ishine/Meus documentos/Downloads/New Styller Yourots 0.6.2 (8.50-8.52)/config.lua and looks like fine server config file. Now you can check database(mysql) connection: STEP 2 - check database connection

 

 

 

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.

 

 

E Quando vai no STEP 3 aparece isso :

 

Can't connect to MySQL database.

 

 

Meu Config.LUA

 

 

-- LeozeraRox Server Config

 

-- Account manager

accountManager = "yes"

namelockManager = "no"

newPlayerChooseVoc = "yes"

newPlayerSpawnPosX = 160

newPlayerSpawnPosY = 51

newPlayerSpawnPosZ = 7

newPlayerTownId = 1

newPlayerLevel = 8

newPlayerMagicLevel = 0

generateAccountNumber = "no"

 

-- Unjustified kills

redSkullLength = 1 * 24 * 60 * 60

blackSkullLength = 2 * 24 * 60 * 60

dailyFragsToRedSkull = 3

weeklyFragsToRedSkull = 5

monthlyFragsToRedSkull = 10

dailyFragsToBlackSkull = dailyFragsToRedSkull

weeklyFragsToBlackSkull = weeklyFragsToRedSkull

monthlyFragsToBlackSkull = monthlyFragsToRedSkull

dailyFragsToBanishment = dailyFragsToRedSkull

weeklyFragsToBanishment = weeklyFragsToRedSkull

monthlyFragsToBanishment = monthlyFragsToRedSkull

blackSkulledDeathHealth = 40

blackSkulledDeathMana = 0

useBlackSkull = "yes"

advancedFragList = "no"

 

-- Banishments

notationsToBan = 3

warningsToFinalBan = 4

warningsToDeletion = 5

banLength = 1 * 24 * 60 * 60

finalBanLength = 1 * 24 * 60 * 60

ipBanishmentLength = 1 * 24 * 60 * 60

broadcastBanishments = "yes"

maxViolationCommentSize = 200

autoBanishUnknownBytes = "no"

 

-- Battle

worldType = "pvp"

protectionLevel = 20

pvpTileIgnoreLevelAndVocationProtection = "yes"

pzLocked = 60 * 1000

criticalHitChance = 7

criticalHitMultiplier = 1

displayCriticalHitNotify = "yes"

removeWeaponAmmunition = "no"

removeWeaponCharges = "yes"

removeRuneCharges = "no"

whiteSkullTime = 5 * 60 * 1000

noDamageToSameLookfeet = "no"

showHealingDamage = "no"

showHealingDamageForMonsters = "no"

fieldOwnershipDuration = 5 * 1000

stopAttackingAtExit = "no"

oldConditionAccuracy = "no"

loginProtectionPeriod = 10 * 1000

deathLostPercent = 10

stairhopDelay = 2 * 1000

pushCreatureDelay = 2 * 1000

deathContainerId = 1987

gainExperienceColor = 215

addManaSpentInPvPZone = "yes"

squareColor = 0

 

-- Experience from players

experienceFromKilledPlayers = "no"

minLevelThresholdForKilledPlayer = 0.9

maxLevelThresholdForKilledPlayer = 1.1

 

-- Connection config

worldId = 0

ip = "armagedonstyller.servegame.com"

bindOnlyConfiguredIpAddress = "no"

loginPort = 7171

gamePort = 7172

adminPort = 7171

statusPort = 7171

loginTries = 1

retryTimeout = 2 * 1000

loginTimeout = 2 * 1000

maxPlayers = 210

motd = "Welcome to the ArmagedonStyller!"

displayOnOrOffAtCharlist = "no"

onePlayerOnlinePerAccount = "yes"

allowClones = "no"

serverName = "Styller"

loginMessage = "Welcome to the ArmagedonStyller!"

statusTimeout = 5 * 60 * 1000

replaceKickOnLogin = "yes"

forceSlowConnectionsToDisconnect = "no"

loginOnlyWithLoginServer = "no"

premiumPlayerSkipWaitList = "no"

 

-- Database

sqlType = "mysql"

sqlHost = "localhost"

sqlPort = 3306

sqlUser = "root"

sqlPass = "******"

sqlDatabase = "Open Tibia Server"

sqlFile = "Styller.s3db"

sqlKeepAlive = 0

mysqlReadTimeout = 10

mysqlWriteTimeout = 10

passwordType = "sha1"

 

-- Deathlist

deathListEnabled = "yes"

deathListRequiredTime = 1 * 60 * 1000

deathAssistCount = 20

maxDeathRecords = 5

 

-- Guilds

ingameGuildManagement = "yes"

levelToFormGuild = 20

premiumDaysToFormGuild = 0

guildNameMinLength = 4

guildNameMaxLength = 20

 

-- Highscores

highscoreDisplayPlayers = 10

updateHighscoresAfterMinutes = 3

 

-- Houses

buyableAndSellableHouses = "yes"

houseNeedPremium = "yes"

bedsRequirePremium = "yes"

levelToBuyHouse = 60

housesPerAccount = 0

houseRentAsPrice = "no"

housePriceAsRent = "no"

housePriceEachSquare = 5000

houseRentPeriod = "never"

guildHalls = "no"

 

-- Item usage

timeBetweenActions = 200

timeBetweenExActions = 1000

checkCorpseOwner = "yes"

hotkeyAimbotEnabled = "yes"

maximumDoorLevel = 500

 

-- Map

mapName = "Styller"

mapAuthor = "Léo"

randomizeTiles = "yes"

useHouseDataStorage = "yes"

storeTrash = "no"

cleanProtectedZones = "yes"

mailboxDisabledTowns = "-1"

 

-- Startup

defaultPriority = "high"

niceLevel = 5

coresUsed = "-1"

optimizeDatabaseAtStartup = "yes"

removePremiumOnInit = "yes"

confirmOutdatedVersion = "no"

 

-- Muted buffer

maxMessageBuffer = 4

bufferMutedOnSpellFailure = "no"

 

-- Miscellaneous

dataDirectory = "data/"

allowChangeOutfit = "yes"

allowChangeColors = "yes"

allowChangeAddons = "yes"

disableOutfitsForPrivilegedPlayers = "no"

bankSystem = "yes"

saveGlobalStorage = "yes"

displaySkillLevelOnAdvance = "no"

spellNameInsteadOfWords = "no"

emoteSpells = "yes"

promptExceptionTracerErrorBox = "yes"

storePlayerDirection = "no"

 

-- Ghost mode

ghostModeInvisibleEffect = "no"

ghostModeSpellEffects = "yes"

 

-- Limits

idleWarningTime = 59 * 60 * 1000

idleKickTime = 60 * 60 * 1000

expireReportsAfterReads = 1

playerQueryDeepness = 2

maxItemsPerPZTile = 0

maxItemsPerHouseTile = 0

 

-- Premium-related

freePremium = "no"

premiumForPromotion = "yes"

 

-- Blessings

blessingsOnlyPremium = "yes"

blessingReductionBase = 30

blessingReductionDecreament = 5

eachBlessReduction = 8

 

-- Rates

experienceStages = "no"

rateExperience = 888

rateSkill = 100

rateMagic = 100

rateLoot = 30

rateSpawn = 5

 

-- Stamina

rateStaminaLoss = 1

rateStaminaGain = 1000 / 3

rateStaminaThresholdGain = 4

staminaRatingLimitTop = 41 * 60

staminaRatingLimitBottom = 14 * 60

rateStaminaAboveNormal = 1.5

rateStaminaUnderNormal = 0.5

staminaThresholdOnlyPremium = "yes"

 

-- Party

experienceShareRadiusX = 30

experienceShareRadiusY = 30

experienceShareRadiusZ = 1

experienceShareLevelDifference = 2 / 3

extraPartyExperienceLimit = 20

extraPartyExperiencePercent = 20

experienceShareActivity = 2 * 60 * 1000

 

-- Global save

globalSaveEnabled = "no"

globalSaveHour = 3

shutdownAtGlobalSave = "yes"

cleanMapAtGlobalSave = "no"

 

-- Spawns

deSpawnRange = 2

deSpawnRadius = 50

 

-- Summons

maxPlayerSummons = 2

teleportAllSummons = "no"

teleportPlayerSummons = "no"

 

-- Status

ownerName = "ArmagedonStyller"

ownerEmail = ""

url = ""

location = "Brazil"

displayGamemastersWithOnlineCommand = "no"

 

-- Logs

adminLogsEnabled = "no"

displayPlayersLogging = "yes"

prefixChannelLogs = ""

runFile = ""

outLogName = ""

errorLogName = ""

truncateLogsOnStartup = "no"

 

 

 

Só não coloquei a senha na database e.e

[jajazinn 37]

primeiramente, nao presisa criar 2 topicos...

vamos la:

o erro se da pq nao se consegue ligar a database..

la no teu config.lua, nesse lugar:

-- Database

sqlType = "mysql"

sqlHost = "localhost"

sqlPort = 3306

sqlUser = "root"

sqlPass = "******"

sqlDatabase = "Open Tibia Server"

sqlFile = "Styller.s3db"

sqlKeepAlive = 0

mysqlReadTimeout = 10

mysqlWriteTimeout = 10

passwordType = "sha1"

onde tem:

sqlPass = "******" /// veja se a senha esta certa

sqlDatabase = "Open Tibia Server" /// veja se o nome da sua database esta correta, certamente nao vai estar..

ai tu vai em http://localhost/phpmyadmin/ ou http://localhost:8090/phpmyadmin/ ai coloque tua senha, ai vai ter:

 

onde ta de vermelho, é o nome da sua database, que no meu caso eh rajotserv, no seu vai ser outro nome(provavelmente), ai tu copia o nome de sua database e coloca em:

sqlDatabase = "COLOQUE O NOME AKI"

[k2lan 45]

uma boa dica pra vc, tente criar um banco de dados sem espaço

[lemos99 1]

Revise seu config.lua na parte 'Database', nome do sql dentro da pasta do seu otserver, nome criado dentro do phpmyadmin (deve ser o mesmo nome do sql que está na pasta de seu otserver)

 

Espero ter ajudado.

[xpert 0]

To com msm Problema q eli mais ja refins varias vezes e quando usso outro Gensior da 1 Erro nada ver.

 

 

Mais agora to com esse erro deli Can't connect to MySQL database.

 

Alguem pode me ajuda

 

Ai esta Minha Config.lua

 

 

accountManager = true

namelockManager = true

newPlayerChooseVoc = true

newPlayerSpawnPosX = 1088

newPlayerSpawnPosY = 1062

newPlayerSpawnPosZ = 7

newPlayerTownId = 1

newPlayerLevel = 8

newPlayerMagicLevel = 0

generateAccountNumber = false

 

redSkullLength = 30 * 24 * 60 * 60

blackSkullLength = 45 * 24 * 60 * 60

dailyFragsToRedSkull = 8

weeklyFragsToRedSkull = 8

monthlyFragsToRedSkull = 10

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 = 7 * 24 * 60 * 60

finalBanLength = 30 * 24 * 60 * 60

ipBanishmentLength = 1 * 24 * 60 * 60

broadcastBanishments = true

maxViolationCommentSize = 200

violationNameReportActionType = 2

autoBanishUnknownBytes = false

 

worldType = "pvp"

protectionLevel = 20

pvpTileIgnoreLevelAndVocationProtection = true

pzLocked = 2 * 60 * 1000

huntingDuration = 30 * 1000

criticalHitChance = 70

criticalHitMultiplier = 1

displayCriticalHitNotify = false

removeWeaponAmmunition = false

removeWeaponCharges = false

removeRuneCharges = false

whiteSkullTime = 4 * 60 * 1000

noDamageToSameLookfeet = false

showHealingDamage = true

showHealingDamageForMonsters = false

fieldOwnershipDuration = 5 * 1000

stopAttackingAtExit = true

oldConditionAccuracy = false

loginProtectionPeriod = 1 * 1000

deathLostPercent = 10

stairhopDelay = 1 * 1000

pushCreatureDelay = 1 * 1000

deathContainerId = 1987

gainExperienceColor = 215

addManaSpentInPvPZone = true

squareColor = 0

allowFightback = true

 

worldId = 0

ip = "201.43.179.87"

bindOnlyConfiguredIpAddress = false

loginPort = 7171

gamePort = 7172

adminPort = 7171

statusPort = 7171

loginTries = 10

retryTimeout = 5 * 1000

loginTimeout = 60 * 1000

maxPlayers = 200

motd = "Bem vindo."

displayOnOrOffAtCharlist = false

onePlayerOnlinePerAccount = true

allowClones = false

serverName = "Legue of Legends"

loginMessage = "Bem vindo."

statusTimeout = 5 * 60 * 1000

replaceKickOnLogin = true

forceSlowConnectionsToDisconnect = false

loginOnlyWithLoginServer = false

premiumPlayerSkipWaitList = true

 

sqlType = "mysql"

sqlHost = "localhost"

sqlPort = 3306

sqlUser = "root"

sqlPass = "87083875"

sqlDatabase = "legueoflegends"

sqlFile = "schemas+Database/globalcompacto.s3db"

sqlKeepAlive = 0

mysqlReadTimeout = 10

mysqlWriteTimeout = 10

encryptionType = "plain"

 

deathListEnabled = true

deathListRequiredTime = 1 * 60 * 1000

deathAssistCount = 19

maxDeathRecords = 5

 

ingameGuildManagement = true

levelToFormGuild = 50

premiumDaysToFormGuild = 0

guildNameMinLength = 4

guildNameMaxLength = 30

 

highscoreDisplayPlayers = 100

updateHighscoresAfterMinutes = 1

 

buyableAndSellableHouses = true

houseNeedPremium = false

bedsRequirePremium = false

levelToBuyHouse = 150

housesPerAccount = 0

houseRentAsPrice = false

housePriceAsRent = false

housePriceEachSquare = 25000

houseRentPeriod = "never"

houseCleanOld = 0

guildHalls = true

 

timeBetweenActions = 200

timeBetweenExActions = 1000

checkCorpseOwner = true

hotkeyAimbotEnabled = true

maximumDoorLevel = 500

 

mapName = "Global Compacto"

mapAuthor = "Soldoran"

randomizeTiles = true

useHouseDataStorage = false

storeTrash = true

cleanProtectedZones = true

mailboxDisabledTowns = "-1"

 

defaultPriority = "high"

niceLevel = 5

coresUsed = "-1"

optimizeDatabaseAtStartup = true

removePremiumOnInit = true

confirmOutdatedVersion = false

 

maxMessageBuffer = 74

bufferMutedOnSpellFailure = false

 

dataDirectory = "data/"

allowChangeOutfit = true

allowChangeColors = true

allowChangeAddons = true

addonsOnlyPremium = false

disableOutfitsForPrivilegedPlayers = false

bankSystem = true

saveGlobalStorage = true

displaySkillLevelOnAdvance = true

spellNameInsteadOfWords = false

emoteSpells = true

promptExceptionTracerErrorBox = true

storePlayerDirection = false

monsterLootMessage = 3

monsterLootMessageType = 25

separateViplistPerCharacter = false

 

ghostModeInvisibleEffect = false

ghostModeSpellEffects = true

 

idleWarningTime = 14 * 60 * 1000

idleKickTime = 10 * 60 * 1000

expireReportsAfterReads = 1

playerQueryDeepness = 2

maxItemsPerPZTile = 0

maxItemsPerHouseTile = 0

 

freePremium = false

premiumForPromotion = true

 

blessingOnlyPremium = false

blessingReductionBase = 30

blessingReductionDecreament = 5

eachBlessReduction = 8

 

experienceStages = true

rateExperience = 400

rateExperienceFromPlayers = 0

rateSkill = 50

rateMagic = 60

rateLoot = 10

rateSpawn = 5

 

rateMonsterHealth = 1.0

rateMonsterMana = 1.0

rateMonsterAttack = 1.0

rateMonsterDefense = 1.0

 

minLevelThresholdForKilledPlayer = 0.9

maxLevelThresholdForKilledPlayer = 1.1

 

rateStaminaLoss = 1

rateStaminaGain = 4

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

shutdownAtGlobalSave = true

cleanMapAtGlobalSave = false

 

deSpawnRange = 2

deSpawnRadius = 50

 

maxPlayerSummons = 2

teleportAllSummons = false

teleportPlayerSummons = false

 

ownerName = ""

ownerEmail = ""

url = ""

location = "Brazil"

displayGamemastersWithOnlineCommand = false

 

adminLogsEnabled = false

displayPlayersLogging = true

prefixChannelLogs = ""

runFile = ""

outLogName = ""

errorLogName = ""

truncateLogsOnStartup = false

 

 

Me ajuda por favor

[k2lan 45]

tente ver os principais dados como mysql, senha, nome data base e sqlhost

[xpert 0]

Bom eu fiz tudo certinha com base em Video Tutorial creio q esteja tudo certo

 

Cara arrumei o anterior mais agora ta aparecendo esse vc sabe me informa o q posso fazer?

 

Set Admin Account

 

Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[42S22]: Column not found: 1054 Unknown column 'vip_time' in 'field list'' in C:\xampp\htdocs\pot\OTS_Account.php:237 Stack trace: #0 C:\xampp\htdocs\pot\OTS_Account.php(237): PDO->query('SELECT `id`, `n...') #1 C:\xampp\htdocs\install.php(572): OTS_Account->load(1) #2 {main} thrown in C:\xampp\htdocs\pot\OTS_Account.php on line 237

[PauloBriiito 3]

Não sei Qual é seu sistema vip, Não sei se tera vip, mas para resolver esse erro basta adicionar esse comnado na database.

ALTER TABLE `accounts` ADD vip_time INT(15) NOT NULL DEFAULT 0;

Caso for outro sistema vip terá que ir ate C:\xampp\htdocs\pot\OTS_Account.php,

Procure por (ctrl+f) vip_time e altere para o seu.

Qualquer duvida não hesite em postar.

 

Att,

Briito

Editado Novembro 19, 2011 por PauloBriiito

[xpert 0]

Vlw cara Rep+.

 

mais agora to com outro problema meu site num aparece pra niguem e num acessa pelo ip fixo (no-ip).

 

e aki pra mim eli ta aparecendo 1 tela pedindo login e senha.