Erro SQL ao iniciar

[henrique10 2]

*OBS SENHA ESTA CORRETA

* WINDOWS

*8.60

JÁ TENTEI MUITOS TUTORIAIS E NAO ESTA DANDO CERTO

 

>> Starting MySQL connection
 Failed connecting to database - MYSQL ERROR: Can't connect to MySQL server on 'localhost' (10061) (2003)

 ERROR: Couldn't estabilish connection to SQL database!

 

MINHA CONFIG LUA

accountManager = true

namelockManager = true

newPlayerChooseVoc = true

newPlayerSpawnPosX = 405

newPlayerSpawnPosY = 16

newPlayerSpawnPosZ = 4

newPlayerTownId = 1

newPlayerLevel = 8

newPlayerMagicLevel = 10

generateAccountNumber = false

 

 

redSkullLength = 1 * 24 * 60 * 60

blackSkullLength = 2 * 24 * 60 * 60

dailyFragsToRedSkull = 20

weeklyFragsToRedSkull = 80

monthlyFragsToRedSkull = 100

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

 

 

worldType = "open"

protectionLevel = 30

pvpTileIgnoreLevelAndVocationProtection = true

pzLocked = 1000 * 10

huntingDuration = 1000 * 10

criticalHitChance = 7

criticalHitMultiplier = 1

displayCriticalHitNotify = true

removeWeaponAmmunition = false

removeWeaponCharges = false

removeRuneCharges = false

whiteSkullTime = 10 * 60 * 1000

noDamageToSameLookfeet = false

showHealingDamage = false

showHealingDamageForMonsters = false

fieldOwnershipDuration = 2 * 60 * 1000

stopAttackingAtExit = false

oldConditionAccuracy = false

loginProtectionPeriod = 15 * 1000

deathLostPercent = 10

stairhopDelay = 2 * 1000

pushCreatureDelay = 2 * 1000

deathContainerId = 1993

gainExperienceColor = 215

addManaSpentInPvPZone = true

squareColor = 22

allowFightback = true

 

 

worldId = 0

ip = "styller-show.servegame.com"

bindOnlyConfiguredIpAddress = false

loginPort = 7171

gamePort = 7172

adminPort = 7171

statusPort = 7171

loginTries = 10

retryTimeout = 5 * 1000

loginTimeout = 60 * 1000

maxPlayers = 500

motd = "Welcome to the Styller , Confiram as Novidades."

displayOnOrOffAtCharlist = false

onePlayerOnlinePerAccount = true

allowClones = false

serverName = "Styller"

loginMessage = "Welcome to the Styller , Confiram as Novidades."

statusTimeout = 5 * 60 * 1000

replaceKickOnLogin = true

forceSlowConnectionsToDisconnect = false

loginOnlyWithLoginServer = false

premiumPlayerSkipWaitList = false

 

 

sqlType = "sqlite"

sqlHost = "localhost"

sqlPort = 3306

sqlUser = "root"

sqlPass = "Giovanoni10"

sqlDatabase = "otserv"

sqlFile = "otserv.s3db"

sqlKeepAlive = 0

mysqlReadTimeout = 10

mysqlWriteTimeout = 10

encryptionType = "sha1"

 

 

deathListEnabled = true

deathListRequiredTime = 1 * 60 * 1000

deathAssistCount = 19

maxDeathRecords = 20

 

 

ingameGuildManagement = true

levelToFormGuild = 50

premiumDaysToFormGuild = 0

guildNameMinLength = 4

guildNameMaxLength = 20

 

 

highscoreDisplayPlayers = 50

updateHighscoresAfterMinutes = 3

 

 

buyableAndSellableHouses = true

houseNeedPremium = true

bedsRequirePremium = true

levelToBuyHouse = 60

housesPerAccount = 0

houseRentAsPrice = false

housePriceAsRent = false

housePriceEachSquare = 5000

houseRentPeriod = "never"

houseCleanOld = 0

guildHalls = false

 

 

timeBetweenActions = 200

timeBetweenExActions = 1000

checkCorpseOwner = true

hotkeyAimbotEnabled = true

maximumDoorLevel = 500

 

 

mapName = "Styller.otbm"

mapAuthor = "Vinicius"

randomizeTiles = true

useHouseDataStorage = false

storeTrash = true

cleanProtectedZones = true

mailboxDisabledTowns = "-1"

 

 

defaultPriority = "high"

niceLevel = 5

coresUsed = "-1"

optimizeDatabaseAtStartup = true

removePremiumOnInit = true

confirmOutdatedVersion = false

 

 

maxMessageBuffer = 6

bufferMutedOnSpellFailure = false

 

 

dataDirectory = "data/"

allowChangeOutfit = true

allowChangeColors = true

allowChangeAddons = true

disabutfitsForPrivilegedPlayers = 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 = 30 * 60 * 1000

idleKickTime = 60 * 60 * 1000

expireReportsAfterReads = 1

playerQueryDeepness = 2

maxItemsPerPZTile = 0

maxItemsPerHouseTile = 0

 

 

freePremium = true

premiumForPromotion = true

 

 

blessingOnlyPremium = False

blessingReductionBase = 30

blessingReductionDecreament = 5

eachBlessReduction = 8

 

 

experienceStages = true

rateExperience = 900

rateExperienceFromPlayers = 2

rateSkill = 80

rateMagic = 85

rateLoot = 3.5

rateSpawn = 2.5

 

 

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

shutdownAtGlobalSave = false

cleanMapAtGlobalSave = true

 

 

deSpawnRange = 2

deSpawnRadius = 50

 

 

maxPlayerSummons = 2

teleportAllSummons = True

teleportPlayerSummons = True

 

 

ownerName = "King Styller"

ownerEmail = ""

url = ""

location = "Brazil"

displayGamemastersWithOnlineCommand = false

 

 

adminLogsEnabled = false

displayPlayersLogging = true

prefixChannelLogs = ""

runFile = ""

outLogName = ""

errorLogName = ""

truncateLogsOnStartup = false

 

[Rusherzin 527]

Seu servidor é com site?

[Lucas MS. 7]

Se estiver usando via site o erro é aqui

sqlType = "sqlite"

tem de mudar para mysql ficando assim

sqlType = "mysql"

[join 112]

Se vc estiver usando Mysql precisa retirar a seguinte linha

sqlFile = "otserv.s3db"

 

e trocar essa

sqlType = "sqlite"

 

por

sqlType = "MySql"

 

Precisa liberar a porta sqlPort = 3306 no firewall do windows

se continuar dando erros poste novamente

[henrique10 2]

  Em 20/06/2014 em 02:18, Rusherzin disse:

 

Seu servidor é com site?

 

Mostrar mais  

É com site...

  Em 20/06/2014 em 02:54, join disse:

 

Se vc estiver usando Mysql precisa retirar a seguinte linha

sqlFile = "otserv.s3db"

 

e trocar essa

sqlType = "sqlite"

 

por

sqlType = "MySql"

 

Precisa liberar a porta sqlPort = 3306 no firewall do windows

se continuar dando erros poste novamente

 

Expand   Mostrar mais  

 

Então liberei a port 3306

 

Retirei a linha

 

E voltei para Mysql... Mas o erro continua