[ERRO] couldn't establish connection to SQL database

[JonatasLucasf 75]

então galera configurei minha database e site tudo certo mais quando vou abrir meu ot da o seguinte error

 

 

 

 

 

[Rusherzin 527]

Botou a senha do phpMyAdmin no config.lua ?

[slyton 51]

fas assim meu querido manda o config.lua do ot e o config.php para agente editar para ficar mais fácil, se não você coloco a senha diferente do seu config.php no config.lua ou fez ao contrario

[JonatasLucasf 75]

minha config.lua

-- The Forgotten Server Config

 

-- Account manager

accountManager = "yes"

namelockManager = "yes"

newPlayerChooseVoc = "yes"

newPlayerSpawnPosX = 143

newPlayerSpawnPosY = 61

newPlayerSpawnPosZ = 8

newPlayerTownId = 1

newPlayerLevel = 8

newPlayerMagicLevel = 1

generateAccountNumber = "no"

 

redSkullLength = 24 * 60 * 60

blackSkullLength = 48 * 60 * 60

dailyFragsToRedSkull = 7

weeklyFragsToRedSkull = 30

monthlyFragsToRedSkull = 70

dailyFragsToBlackSkull = dailyFragsToRedSkull

weeklyFragsToBlackSkull = weeklyFragsToRedSkull

monthlyFragsToBlackSkull = monthlyFragsToRedSkull

dailyFragsToBanishment = dailyFragsToRedSkull

weeklyFragsToBanishment = weeklyFragsToRedSkull

monthlyFragsToBanishment = monthlyFragsToRedSkull

blackSkulledDeathHealth = 40

blackSkulledDeathMana = 0

useBlackSkull = true

useFragHandler = true

advancedFragList = false

 

-- Banishments

notationsToBan = 3

warningsToFinalBan = 4

warningsToDeletion = 5

banLength = 1 * 24 * 60 * 60

killsBanLength = 1 * 24 * 60 * 60

finalBanLength = 1 * 24 * 60 * 60

ipBanishmentLength = 1 * 24 * 60 * 60

broadcastBanishments = true

maxViolationCommentSize = 200

violationNameReportActionType = 2

autoBanishUnknownBytes = false

 

-- Battle

worldType = "open"

protectionLevel = 80

pvpTileIgnoreLevelAndVocationProtection = true

pzLocked = 2 * 60 * 1000

huntingDuration = 1 * 60 * 1000

criticalHitChance = 7

criticalHitMultiplier = 1

displayCriticalHitNotify = true

removeWeaponAmmunition = false

removeWeaponCharges = true

removeRuneCharges = false

whiteSkullTime = 3 * 60 * 1000

noDamageToSameLookfeet = false

showHealingDamage = true

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

 

-- Connection config

worldId = 0

ip = "187.57.92.128"

bindOnlyConfiguredIpAddress = false

loginPort = 7171

gamePort = 7172

adminPort = 7171

statusPort = 7171

loginTries = 10

retryTimeout = 5 * 1000

loginTimeout = 60 * 1000

maxPlayers = 109

motd = "Bem vindo ao Baiak Barao o Melhor Totalmente Dedicado Varias Novas Coisa Confira"

displayOnOrOffAtCharlist = false

onePlayerOnlinePerAccount = true

allowClones = false

serverName = "Baiak Barao"

loginMessage = "Quer Se Tornar o Mais FODA? entao compre Donote,Baiak Editado por DeathRocks"

statusTimeout = 5 * 60 * 1000

replaceKickOnLogin = true

forceSlowConnectionsToDisconnect = false

loginOnlyWithLoginServer = false

premiumPlayerSkipWaitList = false

 

-- Database

sqlType = "mysql"

sqlHost = "localhost"

sqlPort = 3306

sqlUser = "root"

sqlPass = "12345678"

sqlDatabase = "baiak"

sqlFile = "Baiak.s3db"

sqlKeepAlive = 0

mysqlReadTimeout = 10

mysqlWriteTimeout = 10

encryptionType = "sha1"

 

-- Deathlist

deathListEnabled = true

deathListRequiredTime = 1 * 60 * 1000

deathAssistCount = 19

maxDeathRecords = 5

 

-- Guilds

ingameGuildManagement = true

levelToFormGuild = 8

premiumDaysToFormGuild = 0

guildNameMinLength = 4

guildNameMaxLength = 20

 

-- Highscores

highscoreDisplayPlayers = 15

updateHighscoresAfterMinutes = 2

 

-- Houses

buyableAndSellableHouses = true

houseNeedPremium = true

bedsRequirePremium = true

levelToBuyHouse = 150

housesPerAccount = 0

houseRentAsPrice = false

housePriceAsRent = false

housePriceEachSquare = 1000

houseRentPeriod = "never"

houseCleanOld = 0

guildHalls = false

 

-- Item usage

timeBetweenActions = 200

timeBetweenExActions = 1000

checkCorpseOwner = true

hotkeyAimbotEnabled = true

maximumDoorLevel = 500

 

-- Map

mapName = "Baiak Barao.otbm"

mapAuthor = "Ygnus"

randomizeTiles = true

useHouseDataStorage = false

storeTrash = true

cleanProtectedZones = true

mailboxDisabledTowns = "-1"

 

-- Startup

defaultPriority = "high"

niceLevel = 5

coresUsed = "-1"

optimizeDatabaseAtStartup = true

removePremiumOnInit = true

confirmOutdatedVersion = false

 

-- Muted buffer

maxMessageBuffer = 4

bufferMutedOnSpellFailure = false

 

-- Miscellaneous

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

 

-- Ghost mode

ghostModeInvisibleEffect = false

ghostModeSpellEffects = true

 

-- Limits

idleWarningTime = 14 * 60 * 1000

idleKickTime = 15 * 60 * 1000

expireReportsAfterReads = 1

playerQueryDeepness = 2

maxItemsPerPZTile = 0

maxItemsPerHouseTile = 0

 

-- Premium-related

freePremium = true

premiumForPromotion = true

 

-- Blessings

blessingOnlyPremium = true

blessingReductionBase = 30

blessingReductionDecreament = 5

eachBlessReduction = 8

 

-- Rates

experienceStages = "yes"

rateExperience = 45

rateExperienceFromPlayers = 0

rateSkill = 60

rateMagic = 40

rateLoot = 20

rateSpawn = 20

 

-- Monster rates

rateMonsterHealth = 1.0

rateMonsterMana = 1.0

rateMonsterAttack = 1.0

rateMonsterDefense = 1.0

 

-- Experience from players

minLevelThresholdForKilledPlayer = 0.9

maxLevelThresholdForKilledPlayer = 1.1

 

-- Stamina

rateStaminaLoss = 1

rateStaminaGain = 3

rateStaminaThresholdGain = 12

staminaRatingLimitTop = 41 * 60

staminaRatingLimitBottom = 14 * 60

rateStaminaAboveNormal = 1.5

rateStaminaUnderNormal = 0.5

staminaThresholdOnlyPremium = true

 

-- Party

experienceShareRadiusX = 30

experienceShareRadiusY = 30

experienceShareRadiusZ = 1

experienceShareLevelDifference = 2 / 3

extraPartyExperienceLimit = 20

extraPartyExperiencePercent = 5

experienceShareActivity = 2 * 60 * 1000

 

-- Global save

globalSaveEnabled = false

globalSaveHour = 1

shutdownAtGlobalSave = false

cleanMapAtGlobalSave = false

 

-- Spawns

deSpawnRange = 2

deSpawnRadius = 50

 

-- Summons

maxPlayerSummons = 2

teleportAllSummons = false

teleportPlayerSummons = false

 

-- Status

ownerName = "Styller Premium"

ownerEmail = "[email protected]"

url = ""

location = "Brazil"

displayGamemastersWithOnlineCommand = false

 

-- Logs

adminLogsEnabled = false

displayPlayersLogging = true

prefixChannelLogs = ""

runFile = ""

outLogName = ""

errorLogName = ""

truncateLogsOnStartup = false

 

 

meu config.php

<?PHP

$link_down = "http://www.tibiaclient.com/files/tibia860.exe"; ## Link de download do cliente proprio ##

$config['site']['SocialFacebook'] = "VictorRaful";

$config['site']['SocialTweet'] = "victor__fasano";

 

###############################

###### Bônus Points ###########

###############################

 

################################

## Ex: 1x = Points normais #####

# Ex: 2x = Compra 1 e recebe 2 #

################################

################################

# 5x double points os pontos ###

# são extreme points ###########

################################

 

$config['site']['bonusPoints'] = 1; #! Quantidade de vezes a ser multiplicados os points !#

 

 

###################################

###### CONFIGURAÇÕES DO SITE ######

###################################

 

$config['site']['check_titles']= false; #! Não mecha !#

$config['site']['allowed_titles'] = array(); #! Não mecha !#

 

$config['site']['worlds'] = array(0 => 'Styller-Cores'); #! NOME DO SERVIDOR !#

$config['site']['one_email'] = 1; #! 1 email por account 1 = sim, 0 = não !#

$config['site']['verify_code'] = 1;

$config['site']['email_days_to_change'] = 7;

$config['site']['newaccount_premdays'] = 10; ## DIAS DE PREMIUM QUE JOGADOR RECEBE QUANDO CRIA CHARACTER ##

$config['site']['create_account_verify_mail'] = 0; #! Verificar conta com link enviado no email !#

$config['site']['generate_new_reckey'] = "1"; #! POSSIBILIDADE DE GERAÇÃO NOVA DE RECOVERY KEY 1 = sim || 0 = não !# 

$config['site']['generate_new_reckey_price'] = 5; #! Preço em 'points' de nova recovery key !#

$config['site']['send_mail_when_change_password'] = 0; #! Enviar novo password sempre que for alterado para o email !#

$config['site']['send_mail_when_generate_reckey'] = 1; #! Enviar nova recovery key para o email !#

$config['site']['send_register_email'] = 0; #! Enviar email de boas vindas quando account é criada !#

 

##############################################

####### CONFIGURAÇÃO DAS VOCAÇÕES ############

##############################################

$config['site']['newchar_vocations'][0] = array(1 => 'Sorcerer Sample', 2 => 'Druid Sample', 3 => 'Paladin Sample', 4 => 'Knight Sample');

$config['site']['newchar_vocations'][1] = array(1 => 'Sorcerer Sample', 2 => 'Druid Sample', 3 => 'Paladin Sample', 4 => 'Knight Sample');

 

$config['site']['newchar_towns'][0] = array(1);

$config['site']['newchar_towns'][1] = array(1);

 

$vocation_name[0][0] = array(0 => 'None', 1 => 'Sorcerer', 2 => 'Druid', 3 => 'Paladin', 4 => 'Knight'); 

$vocation_name[0][1] = array(1 => 'Master Sorcerer', 2 => 'Elder Druid', 3 => 'Royal Paladin', 4 => 'Elite Knight'); 

$vocation_name[1][0] = array(0 => 'None', 1 => 'Sorcerer', 2 => 'Druid', 3 => 'Paladin', 4 => 'Knight'); 

$vocation_name[1][1] = array(1 => 'Master Sorcerer', 2 => 'Elder Druid', 3 => 'Royal Paladin', 4 => 'Elite Knight'); 

 

#######################################

######### Cidades do Servidor #########

#######################################

$towns_list[0] = array(1 => 'Styller-Orion');

 

$config['site']['monsters'] = array("amazon","valkyrie","carrion worm","rotworm","rotworm queen","cockroach","kongra","merlkin","sibang","crystal spider","giant spider","poison spider","scorpion","spider","tarantula","achad","axeitus headbanger","bloodpaw","bovinus","colerian the barbarian","cursed gladiator","frostfur","orcus the cruel","rocky","the hairy one","avalanche","drasilla","grimgor guteater","kreebosh the exile","slim","spirit of earth","spirit of fire","spirit of water","the dark dancer","the hag","darakan the executioner","deathbringer","fallen mooh'tah master ghar","gnorre chyllson","norgle glacierbeard","svoren the mad","the masked marauder","the obliverator","the pit lord","webster","barbarian bloodwalker","barbarian brutetamer","barbarian headsplitter","barbarian skullhunter","bear","panda","polar bear","braindeath","beholder","elder beholder","gazer","chicken","dire penguin","flamingo","parrot","penguin","seagull","terror bird","bazir","infernatil","thul","munster","son of verminor","xenia","zoralurk","big boss trolliver","foreman kneebiter","mad technomancer","man in the cave","lord of the elements","the count","the plasmother","dracola","the abomination","the handmaiden","mr. punish","the countess sorrow","the imperor","massacre","apocalypse","brutus bloodbeard","deadeye devious","demodras","dharalion","fernfang","ferumbras","general murius","ghazbaran","grorlam","lethal lissy","morgaroth","necropharus","orshabaal","ron the ripper","the evil eye","the horned fox","the old widow","tiquandas revenge","apprentice sheng","dog","hellhound","war wolf","winter wolf","wolf","chakoya toolshaper","chakoya tribewarden","chakoya windcaller","blood crab","crab","frost giant","frost giantess","ice golem","yeti","acolyte of the cult","adept of the cult","enlightened of the cult","novice of the cult","ungreez","dark torturer","demon","destroyer","diabolic imp","fire devil","fury","hand of cursed fate","juggernaut","nightmare","plaguesmith","blue djinn","efreet","green djinn","marid","frost dragon","wyrm","sea serpent","dragon lord","dragon","hydra","dragon hatchling","dragon lord hatchling","frost dragon hatchling","dwarf geomancer","dwarf guard","dwarf soldier","dwarf","dworc fleshhunter","dworc venomsniper","dworc voodoomaster","elephant","mammoth","elf arcanist","elf scout","elf","charged energy elemental","energy elemental","massive energy elemental","overcharged energy elemental","energy overlord","cat","lion","tiger","azure frog","coral frog","crimson frog","green frog","orchid frog","toad","jagged earth elemental","muddy earth elemental","earth elemental","massive earth elemental","earth overlord","gargoyle","stone golem","ghost","phantasm","phantasm","pirate ghost","spectre","cyclops smith","cyclops drone","behemoth","cyclops","slick water elemental","roaring water elemental","ice overlord","water elemental","massive water elemental","ancient scarab","butterfly","bug","centipede","exp bug","larva","scarab","wasp","lizard sentinel","lizard snakecharmer","lizard templar","minotaur archer","minotaur guard","minotaur mage","minotaur","squirrel","goblin demon","badger","bat","deer","the halloween hare","hyaena","pig","rabbit","silver rabbit","skunk","wisp","dark monk","monk","tha exp carrier","necromancer","priestess","orc berserker","orc leader","orc rider","orc shaman","orc spearman","orc warlord","orc warrior","orc","goblin leader","goblin scavenger","goblin","goblin assassin","assasin","bandit","black knight","hero","hunter","nomad","smuggler","stalker","poacher","wild warrior","ashmunrah","dipthrah","mahrdis","morguthis","omruc","rahemos","thalas","vashresamun","pirate buccaneer","pirate corsair","pirate cutthroat","pirate marauder","carniphila","spit nettle","fire overlord","massive fire elemental","blistering fire elemental","blazing fire elemental","fire elemental","hellfire fighter","quara constrictor scout","quara hydromancer scout","quara mantassin scout","quara pincher scout","quara predator scout","quara constrictor","quara hydromancer","quara mantassin","quara pincher","quara predator","cave rat","rat","cobra","crocodile","serpent spawn","snake","wyvern","black sheep","sheep","mimic","betrayed wraith","bonebeast","demon skeleton","lost soul","pirate skeleton","skeleton","skeleton warrior","undead dragon","defiler","slime2","slime","bog raider","ice witch","warlock","witch","bones","fluffy","grynch clan goblin","hacker","minishabaal","primitive","tibia bug","undead minion","annihilon","hellgorak","latrivan","madareth","zugurosh","ushuriel","golgordan","thornback tortoise","tortoise","eye of the seven","deathslicer","flamethrower","magicthrower","plaguethrower","poisonthrower","shredderthrower","troll champion","frost troll","island troll","swamp troll","troll","banshee","blightwalker","crypt shambler","ghoul","lich","mummy","vampire","grim reaper","trainer","forest dragon","knight","paladin","druid","sorcerer","guard","mercenary","thief","toxiros","pyramo","lazarus","zathroth","goshnar","durin","demora","orc champion","lumenia","dracula","alezzo","prince almirith","elf warlord","random noob","magebomb");

$config['site']['npc'] = array('alice', 'oarkhal', 'equer', 'parkhal', 'leoric', 'sarkhal', 'pallo', 'riona', 'her miona', 'varkhal', 'eura', 'blitz', 'markhal', 'wengo', 'larkhal');

 

 

$config['site']['max_players_per_account'] = 5; #! Personagens por account !#

$config['site']['guild_need_level'] = 8; #! Level minimo para criar uma nova guild !#

$config['site']['guild_need_pacc'] = 0; #! Para criar guild necessario premium? 1 = sim || 0 = não !#

$config['site']['guild_image_size_kb'] = 200; #! Tamanho da imagem para logo da guild !#

$config['site']['guild_description_chars_limit'] = 1000;

$config['site']['guild_description_lines_limit'] = 6;

$config['site']['guild_motd_chars_limit'] = 150;

 

###########################################

########## CONFIGURAÇÃO DE SMTP ###########

## Insira todas as informações de email ###

## para que possa funcionar o smtp ########

###########################################

$config['site']['send_emails'] = 1;

$config['site']['mail_address'] = "[email protected]";

$config['site']['smtp_enabled'] = "yes";

$config['site']['smtp_host'] = "smtp.site1380033556.provisorio.ws";

$config['site']['smtp_port'] = 587;

$config['site']['smtp_auth'] = true;

$config['site']['smtp_user'] = "[email protected]";

$config['site']['smtp_pass'] = "123123123a";

 

#! Opções, paginas e etc a serem exibidos !#

$config['site']['access_news'] = 6;

$config['site']['access_admin_panel'] = 6;

$config['site']['news_big_limit'] = 3;

$config['site']['news_ticks_limit'] = 5;

$config['site']['show_creationdate'] = 1;

$config['site']['last_deaths_limit'] = 40;

$config['site']['players_group_id_block'] = 4;

$config['site']['support_group_id'] = 2;

$config['site']['shop_system'] = 1;

$config['site']['serverinfo_page'] = 1;

$config['site']['email_lai_sec_interval'] = 180;

$config['site']['screenoftheday'] = 1;

 

#############

## Layouts ##

#############

$config['site']['layout'] = 'tibiacom';

 

############################

## PagSeguro/Paypal Email ##

############################

$config['pagseguro']['email'] = '[email protected]'; ## EMAIL PAGSEGURO ##

$config['paypal']['email'] = '[email protected]'; ## EMAIL PAYPAL ##

 

## Formas de pagamento [1 = ativo | 0 = inativo] ##

$config['site']['caixa'] = 1;

$config['site']['pagseguro'] = 1;

$config['site']['paypal'] = 1;

 

#####################

## Nome do Produto ##

#####################

$config['pagseguro']['produtoNome'] = 'Premium Points';

 

#############################

######### C A I X A ########

#############################

#! Informações do pagamento com caixa economica federal !#

$config['site']['CaixaCont'] = "

C/C:

Ag:

etc..

"; 

?>

 

 

@Rusherzin

SIM!

Editado Junho 22, 2014 por JonatasLucasf (veja o histórico de edições)

[Absolute 0]

A imagem não aparece aqui.

[JonatasLucasf 75]

http://s22.postimg.org/csshm7l8f/erroor.png  troca de navegador se não der porque aqui ta dando pra ver

[Absolute 0]

Está usando xampp ou database sqlite?

[flaviofelipezik 6]

eu notei q vc removeu os espaço do config.lua mais vc tem q remover tambem as linha que tem um traçinho tipo -- Account manager ; -- The Forgotten ServerConfig

tem q apagar toda elas que tem isso aki --

[luanluciano93 1994]

@flaviofelipezik, os espaços não tem ligação com a conexão do servidor, apenas do website.

O Servidor se liga ao servidor mysql, e o website tbem, eles tão tem ligação ... 

 

Tem 2 possibilidades de dar esse erro: 

1 - Servidor mysql desligado.
2 - Dados para conexão mysql errados.

Os dados que o servidor usa para se conectar estão no config.lua, revise-os e veja se o mysql esta ligado!

sqlType = "mysql"
sqlHost = "localhost"
sqlPort = 3306
sqlUser = "root"
sqlPass = "senha_do_phpmyadmin"
sqlDatabase = "nome_da_database"
sqlKeepAlive = 0
mysqlReadTimeout = 10
mysqlWriteTimeout = 10
encryptionType = "sha1"

Por favor, quando for criar um tópico tente simplificar pelo tópico .. eu arrumei para você!

E também use a barra de pesquisa antes, você pode encontrar a resolução mais rápido.

• http://www.tibiaking.com/forum/topic/18650-resolvido-ajuda-error-couldnt-establish-connection-to-sql-database/

• http://www.tibiaking.com/forum/topic/15505-resolvido-erro-sql-datebase/

• http://www.tibiaking.com/forum/topic/25421-erro-ajuda-aew-d/

• http://www.tibiaking.com/forum/topic/13006-error-mysql/

 

A vida é tão simples, basta saber vive-la

 

Espero ter ajudado, abraços!

 

[JonatasLucasf 75]

Está usando xampp ou database sqlite?

XAMP

 

@topic

 

Luan o mysql ta ligado.

[luanluciano93 1994]

@JonatasLucasf, então só pode ser a configuração para conexão que está errada. 

[JonatasLucasf 75]

hum.. pode até ser será que o skype,mysql ,navicat não atrapalha?

[Rusherzin 527]

Se eu não me engano tem que desligar o skype para poder abrir o site..

[JonatasLucasf 75]

mais o site abre normal so o servidor não será que pode ser error no servidor também tou usando um baiak aqui do deathrocks

[Natanael Beckman 797]

NESSA IMAGEM MOSTRA UM ERRO QUANDO A SENHA INFORMADA NO CONFIG.LUA ESTA ERRADA:

 

NESTE OUTRA IMAGEM MOSTRA O ERRO QUANDO O NOME DA DATABASE INFORMADA NO CONFIG.LUA ESTÁ ERRADA:

 

 

NESSAS DUAS IMAGENS ABAIXO O ERRO INFORMA QUER O MYSQL ESTÁ DESATIVADO NO CASO O XAMPP:

 

ESSE ERRO MOSTRA QUE O CONFIG.LUA ESTÁ CONFIGURADO PRA SQLITE E O ARQUIVO theforgottenserver.s3db NÃO FOI ENCONTRADO NA PASTA DO OT:

 

XAMPP DESATIVADO E ATIVADO:

 

config.lua configurado para SQLITE:

sqlType = "sqlite"
sqlHost = "localhost"
sqlPort = 3306
sqlUser = "root"
sqlPass = ""
sqlDatabase = ""
sqlFile = "theforgottenserver.s3db"
sqlKeepAlive = 0
mysqlReadTimeout = 6000
mysqlWriteTimeout = 6000
mysqlReconnectionAttempts = 3
encryptionType = "plain"

config.lua configurado para MYSQL:

sqlType = "mysql"
sqlHost = "localhost"
sqlPort = 3306
sqlUser = "root"
sqlPass = "natan"
sqlDatabase = "natandb"
sqlFile = "theforgottenserver.s3db"
sqlKeepAlive = 0
mysqlReadTimeout = 6000
mysqlWriteTimeout = 6000
mysqlReconnectionAttempts = 3
encryptionType = "plain"

 

Eu acredito que após isso você encontre seu erro e solucione!

Editado Junho 26, 2014 por Natanael Beckman (veja o histórico de edições)