Bom, estou fazendo um site com XAMPP . Só que no Step 2 dá um problema :

STEP 1

Check server configuration

File config.lua loaded from C:/Users/Particular/Desktop/OtS/[8.60] HollisterOT + HTDOCS + DB/[8.60] HollisterOT Server/config.lua andlooks like fine server config file. Now you can check database(mysql) connection: STEP 2 - check database connection

Ai eu vou em Step 2 :

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.

Já procurei sobre isso, esse erro "Can't connect to MySQL database" ai falaram que não importei a database direito, ai fui, exclui o Banco de dados do phpmyadmin , e criei novamente e não adiantou nada! Então vou em Step 3 e continua o erro:

Can't connect to MySQL database.

Voce tem que por assim:

C:/Users/Particular/Desktop/OtS/[8.60] HollisterOT + HTDOCS + DB/[8.60] HollisterOT Server/

no Set Serv Patch né? eu coloco isso sim

Entao se continua o erro,talves é porque nao tenha este arquivo em sua pasta do server.

E voce mudou para yes,no config do gesior na hora de instalar?

Mudei pra yes sim

Tentei fazer com outro Ot, dá sempre a mesma coisa:

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.

ee Step 3: Can't connect to MySQL database.

confi.lua, ja configurou com a senha do root,nome da db e etc?

sim, mudei também!

o nome da dbno config.luaé o mesmo do criado no phpmyadmin e no arquivo.sql?

O problema é a estrutura do config.lua

APAGUE tudo que tenha "--" antes da palavra TUDO ! Ex:

--The Forgotten Server

--Rates

Se tiver com esses negoçinhos o Gesior não lê!

Essa solução já foi postada em diversos outros tópicos, use a barra de busca!

PiabetaMan01 : Sim, tá tudo igual !

DoGoz : já fiz isso também, olha ai meu config.lua :

accountManager = true

namelockManager = true

newPlayerChooseVoc = true

newPlayerSpawnPosX = 32360

newPlayerSpawnPosY = 31782

newPlayerSpawnPosZ = 7

newPlayerTownId = 2

newPlayerLevel = 8

newPlayerMagicLevel = 2

generateAccountNumber = false

redSkullLength = 30 * 24 * 60 * 60

blackSkullLength = 45 * 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 = 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 = 1

pvpTileIgnoreLevelAndVocationProtection = true

pzLocked = 60 * 1000

huntingDuration = 60 * 1000

criticalHitChance = 7

criticalHitMultiplier = 1

displayCriticalHitNotify = false

removeWeaponAmmunition = true

removeWeaponCharges = true

removeRuneCharges = true

whiteSkullTime = 15 * 60 * 1000

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

bindOnlyConfiguredIpAddress = false

loginPort = 7171

gamePort = 7172

adminPort = 7171

statusPort = 7171

loginTries = 10

retryTimeout = 5 * 1000

loginTimeout = 60 * 1000

maxPlayers = 1000

motd = "Welcome to Real Server"

displayOnOrOffAtCharlist = false

onePlayerOnlinePerAccount = true

allowClones = false

serverName = "Real Server"

loginMessage = "Welcome to Real Server"

statusTimeout = 5 * 60 * 1000

replaceKickOnLogin = true

forceSlowConnectionsToDisconnect = false

loginOnlyWithLoginServer = false

premiumPlayerSkipWaitList = false

sqlType = "mysql"

sqlHost = "localhost"

sqlPort = 3306

sqlUser = "root"

sqlPass = "minhasenha"

sqlDatabase = "otserver"

sqlFile = "otserver.s3db"

sqlKeepAlive = 0

mysqlReadTimeout = 10

mysqlWriteTimeout = 10

encryptionType = "plain"

deathListEnabled = true

deathListRequiredTime = 1 * 60 * 1000

deathAssistCount = 19

maxDeathRecords = 5

ingameGuildManagement = true

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

mapAuthor = "Doidin"

randomizeTiles = true

storeTrash = true

cleanProtectedZones = true

mailboxDisabledTowns = "-1"

defaultPriority = "high"

niceLevel = 5

coresUsed = "-1"

optimizeDatabaseAtStartup = true

removePremiumOnInit = true

confirmOutdatedVersion = false

formulaLevel = 5.0

formulaMagic = 1.0

bufferMutedOnSpellFailure = false

spellNameInsteadOfWords = false

emoteSpells = false

allowChangeOutfit = true

allowChangeColors = true

allowChangeAddons = true

disableOutfitsForPrivilegedPlayers = false

addonsOnlyPremium = true

dataDirectory = "data/"

bankSystem = true

displaySkillLevelOnAdvance = false

promptExceptionTracerErrorBox = true

separateViplistPerCharacter = false

maximumDoorLevel = 500

maxMessageBuffer = 4

saveGlobalStorage = true

useHouseDataStorage = false

storePlayerDirection = false

checkCorpseOwner = true

monsterLootMessage = 3

monsterLootMessageType = 25

ghostModeInvisibleEffect = false

ghostModeSpellEffects = true

idleWarningTime = 14 * 60 * 1000

idleKickTime = 15 * 60 * 1000

expireReportsAfterReads = 1

playerQueryDeepness = 2

maxItemsPerPZTile = 0

maxItemsPerHouseTile = 0

freePremium = false

premiumForPromotion = false

blessingOnlyPremium = false

blessingReductionBase = 30

blessingReductionDecreament = 5

eachBlessReduction = 8

experienceStages = false

rateExperience = 50.0

rateExperienceFromPlayers = 0

rateSkill = 25.0

rateMagic = 10.0

rateLoot = 3.0

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

experienceShareRadiusX = 30

experienceShareRadiusY = 30

experienceShareRadiusZ = 1

experienceShareLevelDifference = 2 / 3

extraPartyExperienceLimit = 20

extraPartyExperiencePercent = 5

experienceShareActivity = 2 * 60 * 1000

globalSaveEnabled = false

globalSaveHour = 8

shutdownAtGlobalSave = false

cleanMapAtGlobalSave = false

deSpawnRange = 2

deSpawnRadius = 50

maxPlayerSummons = 2

teleportAllSummons = false

teleportPlayerSummons = false

ownerName = "Mayara"

ownerEmail = "mapomper"

url = ""

location = "Brazil"

displayGamemastersWithOnlineCommand = false

adminLogsEnabled = false

displayPlayersLogging = true

prefixChannelLogs = ""

runFile = ""

outLogName = ""

errorLogName = ""

truncateLogsOnStartup = false

sqlType = "mysql"

sqlHost = "localhost"

sqlPort = 3306

sqlUser = "root"

sqlPass = "^{VAI MOSTRA SUA SENHA MONGO? EDITA SEU POST}"

sqlDatabase = "otserver"

sqlFile = "otserver.s3db" ---- DEIXE ESSE CAMPO EM BRANCO, Você está usando MYSQL

sqlKeepAlive = 0

mysqlReadTimeout = 10

mysqlWriteTimeout = 10

encryptionType = "plain"

Organize os códigos abaixo, deixe-os em linha única, se possivel edite seu post e remova o site de outro fórum.

motd = "Welcome to Real Server"

loginMessage = "Welcome to Real Server"

Desculpa ;s

então, fiz tudo isso,

sqlFile = " " ( deixa assim né?)

e deu a mesma coisa no Step 3: Can't connect to MySQL database.

Deve ser algo simples que eu to esquecendo, sei lá, sou meio burra kk

[8.60] HollisterOT + HTDOCS + DB/[8.60] HollisterOT Server/

Vejo que isto é um diretório demasiadamente grande, renomeie-o para "Server"

Se mesmo assim não der certo algum dado de conexão está incorreto.

Peço para que edite o seu config.lua pois ainda está com o site de outro fórum.

Inclusive já reportado!

Já fiz isso também, testei 3 otservers e nenhum deu certo, agora to tentando esse Real Server que eu ja tinha no computador, e também não dá certo!

(C:\Users\Particular\Desktop\Real Server )

E Já configurei o config.lua .

Tópico movido para a seção de dúvidas e pedidos resolvidos.