Gesior não encontra config.lua

[M47r1x 1]

Olá, durante a instalação do gesior, ele não consegue encontrar o config.lua, mesmo quando configurado no local correto:

 

More info: ERROR: #C-2 : Class::ConfigLUA - LUA config file doesn't exist. Path: /root/forgottenserver/config.lua

File: /var/www/classes/configlua.php   Line: 24
File: /var/www/classes/configlua.php   Line: 12
File: /var/www/install.php   Line: 249

 

Já tentei usar outras versões do Gesior, retirei os comentários do config.lua, tentei mudar o caminho como /root/forgottenserver\, dei permissões tanto para a pasta do ot quanto da pasta do Gesior... O que devo fazer? :/

[Sociopata 505]

vc deve ta suar vertigo certo? mas deve ser um problema de diretórios ou nomes, veja se isso ake ajuda

 

http://www.tibiaking.com/forum/topic/14073-pedido-problema-com-configlua-ao-criar-site/

[M47r1x 1]

Olá, tentei o que foi recomendado no tópico, mas o problema persiste..

[Sociopata 505]

vou ser bem sincero amigo nunca vi config.lua em php, pensei ser um erro  no nome, mas vc ja tentou usar o xammp??

[M47r1x 1]

vou ser bem sincero amigo nunca vi config.lua em php, pensei ser um erro  no nome, mas vc ja tentou usar o xammp??

 

Não pois estou no linux...

 

Mas consegui contornar o problema copiando o config.lua no /var/, agora o tudo passa normalmente até o step 3:

Add tables and columns to DB

Installer try to add new tables and columns to database.

Could not add column key to table accounts. Already exist?

Could not add column email_new to table accounts. Already exist?

Could not add column email_new_time to table accounts. Already exist?

Could not add column rlname to table accounts. Already exist?

Could not add column location to table accounts. Already exist?

Could not add column page_access to table accounts. Already exist?

Could not add column email_code to table accounts. Already exist?

Could not add column next_email to table accounts. Already exist?

Could not add column premium_points to table accounts. Already exist?

Could not add column create_date to table accounts. Already exist?

Could not add column create_ip to table accounts. Already exist?

Could not add column last_post to table accounts. Already exist?

Could not add column flag to table accounts. Already exist?

Could not add column description to table guilds. Already exist?

Could not add column guild_logo to table guilds. Already exist?

Could not add column create_ip to table guilds. Already exist?

Could not add column balance to table guilds. Already exist?

Could not add column war to table killers. Already exist?

Could not add column deleted to table players. Already exist?

Could not add column description to table players. Already exist?

Could not add column comment to table players. Already exist?

Could not add column create_ip to table players. Already exist?

Could not add column create_date to table players. Already exist?

Could not add column hide_char to table players. Already exist?

Could not create table z_ots_comunication. Already exist?

Could not create table z_shop_offer. Already exist?

Could not create table z_shop_history_item. Already exist?

Could not create table z_forum. Already exist?

Could not create table guild_wars. Already exist?

Could not create table guild_wars_table_references. Already exist?

Could not create table guild_kills. Already exist?

Could not create table guild_kills_table_references. Already exist?

 

e no phpmyadmin, apenas estas foram criadas:

Ok, consegui contornar o problema fazendo as tabelas manualmente, agora sobre o site está beleza, mas quando vou iniciar o servidor:

>> Loading config

>> Establishing database connection...

MySQL Error Message: Access denied for user 'forgottenserver'@'localhost' (using password: NO)

> ERROR: Failed to connect to database.

>> No services running. The server is NOT online.

 

 

Meu config.lua, nessa parte:

-- Database

sqlType = "mysql"

sqlHost = "127.0.0.1"

sqlPort = 3306

sqlUser = "root"

sqlPass = "teste132"

sqlDatabase = "otserv"

sqlKeepAlive = 0

mysqlReadTimeout = 10

mysqlWriteTimeout = 10

encryptionType = "sha1"

 

 

É estranho pois em lugar algum está indicado 'forgottenserver' como usuário D:

[Sociopata 505]

sqlHost = "127.0.0.1"

 

deixe assim

 

sqlHost = "localhost"

 

e ai nao ta faltando uma linha?embaixo do sqldatabase

 

sqlFile = "forgottenserver.s3db"

[M47r1x 1]

Olá, fiz as alterações e continuo com o mesmo problema:

MySQL Error Message: Access denied for user 'forgottenserver'@'localhost' (using password: NO)
 

[Sociopata 505]

sqlType = "mysql"
sqlHost = "localhost"
sqlPort = 3306
sqlUser = "root"
sqlPass = "test132"  aki acho q vc ta erradno e digitando 123 ñ?
sqlDatabase = "otserv"
sqlFile = "forgottenserver.s3db"
sqlKeepAlive = 0
mysqlReadTimeout = 10
mysqlWriteTimeout = 10
encryptionType = "sha1"

bem se sua config.lua estiver assim ta tudo ok, verifique se senha e o nome da database do seu servidor estão certas, se o vertrigo esta rodando tudo (verdinho em tudo), mas esse erro é bem comum  quando a senha esta errada, se nao for isso procure no phpmyadmin se vc possui mais de um usuario

Editado Outubro 2, 2014 por Sociopata (veja o histórico de edições)

[M47r1x 1]

Segue no spoiler o meu config.lua completo, no phpmyadmin eu estou entrando com o root e a senha test132..

-- The Forgotten Server Config

-- Account manager
accountManager = "no"
namelockManager = "yes"
newPlayerChooseVoc = "no"
newPlayerSpawnPosX = 95
newPlayerSpawnPosY = 117
newPlayerSpawnPosZ = 7
newPlayerTownId = 1
newPlayerLevel = 1
newPlayerMagicLevel = 0
generateAccountNumber = "no"

-- Unjustified kills
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 = "yes"
advancedFragList = "no"

-- Banishments
notationsToBan = 3
warningsToFinalBan = 4
warningsToDeletion = 5
banLength = 7 * 24 * 60 * 60
finalBanLength = 30 * 24 * 60 * 60
ipBanishmentLength = 1 * 24 * 60 * 60
broadcastBanishments = "yes"
maxViolationCommentSize = 200
violationNameReportActionType = 2
autoBanishUnknownBytes = "no"

-- Battle
worldType = "pvp"
protectionLevel = 1
pvpTileIgnoreLevelAndVocationProtection = "yes"
pzLocked = 60 * 1000
huntingDuration = 60 * 1000
criticalHitChance = 7
criticalHitMultiplier = 1
displayCriticalHitNotify = "no"
removeWeaponAmmunition = "yes"
removeWeaponCharges = "yes"
removeRuneCharges = "yes"
whiteSkullTime = 15 * 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
allowFightback = "yes"

-- Connection config
worldId = 0
ip = "ipdaminhavps"
bindOnlyConfiguredIpAddress = "no"
loginPort = 7171
gamePort = 7172
adminPort = 7171
statusPort = 7171
loginTries = 10
retryTimeout = 5 * 1000
loginTimeout = 60 * 1000
maxPlayers = 1000
motd = "Welcome to Schutzstaffel!"
displayOnOrOffAtCharlist = "no"
onePlayerOnlinePerAccount = "yes"
allowClones = "no"
serverName = "Forgotten"
loginMessage = "Welcome to Schutzstaffel!"
statusTimeout = 5 * 60 * 1000
replaceKickOnLogin = "yes"
forceSlowConnectionsToDisconnect = "no"
loginOnlyWithLoginServer = "no"
premiumPlayerSkipWaitList = "no"

-- Database
sqlType = "mysql"
sqlHost = "localhost"
sqlPort = 3306
sqlUser = "root"
sqlPass = "test132"
sqlDatabase = "otserv"
sqlFile = "forgottenserver.s3db"
sqlKeepAlive = 0
mysqlReadTimeout = 10
mysqlWriteTimeout = 10
encryptionType = "plain"

-- Deathlist
deathListEnabled = "yes"
deathListRequiredTime = 1 * 60 * 1000
deathAssistCount = 19
maxDeathRecords = 5

-- Guilds
ingameGuildManagement = "yes"
levelToFormGuild = 8
premiumDaysToFormGuild = 0
guildNameMinLength = 4
guildNameMaxLength = 20

-- Highscores
highscoreDisplayPlayers = 15
updateHighscoresAfterMinutes = 60

-- Houses
buyableAndSellableHouses = "yes"
houseNeedPremium = "yes"
bedsRequirePremium = "yes"
levelToBuyHouse = 1
housesPerAccount = 0
houseRentAsPrice = "no"
housePriceAsRent = "no"
housePriceEachSquare = 1000
houseRentPeriod = "never"
guildHalls = "no"

-- Item usage
timeBetweenActions = 200
timeBetweenExActions = 1000
checkCorpseOwner = "yes"
hotkeyAimbotEnabled = "yes"
maximumDoorLevel = 500

-- Map
mapName = "forgotten"
mapAuthor = "Komic"
randomizeTiles = "yes"
useHouseDataStorage = "no"
storeTrash = "yes"
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 = "no"
promptExceptionTracerErrorBox = "yes"
storePlayerDirection = "no"
monsterLootMessage = 3
monsterLootMessageType = 25

-- Ghost mode
ghostModeInvisibleEffect = "no"
ghostModeSpellEffects = "yes"

-- Limits
idleWarningTime = 14 * 60 * 1000
idleKickTime = 15 * 60 * 1000
expireReportsAfterReads = 1
playerQueryDeepness = 2
maxItemsPerPZTile = 0
maxItemsPerHouseTile = 0

-- Premium-related
freePremium = "yes"
premiumForPromotion = "yes"

-- Blessings
blessingsOnlyPremium = "yes"
blessingReductionBase = 30
blessingReductionDecreament = 5
eachBlessReduction = 8

-- Rates
experienceStages = "yes"
rateExperience = 5.0
rateExperienceFromPlayers = 0
rateSkill = 3.0
rateMagic = 3.0
rateLoot = 2.0
rateSpawn = 1

-- Experience from players
minLevelThresholdForKilledPlayer = 0.9
maxLevelThresholdForKilledPlayer = 1.1

-- 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 = 5
experienceShareActivity = 2 * 60 * 1000

-- Global save
globalSaveEnabled = "no"
globalSaveHour = 8
shutdownAtGlobalSave = "yes"
cleanMapAtGlobalSave = "no"

-- Spawns
deSpawnRange = 2
deSpawnRadius = 50

-- Summons
maxPlayerSummons = 2
teleportAllSummons = "no"
teleportPlayerSummons = "no"

-- Status
ownerName = ""
ownerEmail = "@otland.net"
url = "http://otland.net/"
location = "Europe"
displayGamemastersWithOnlineCommand = "no"

-- Logs
adminLogsEnabled = "no"
displayPlayersLogging = "yes"
prefixChannelLogs = ""
runFile = ""
outLogName = ""
errorLogName = ""
truncateLogsOnStartup = "no"

Editado Outubro 2, 2014 por M47r1x (veja o histórico de edições)

[Sociopata 505]

o nome da sua database é mesmo forgottenserver?

 

va em privilégios e veja se vc possui mais de um usuário, se sim exclua