What's new

Problem z odpaleniem silnika (b??d w ??czeniu z baz? MySQL)

Status
Not open for further replies.

divxdivine

User
Joined
Jan 18, 2010
Messages
11
Reaction score
0
Witam. Pobra?em silnik forrgoten server 0.3.6.
Postawi?em now? baz? theforgottenserver, dodalem tabele mysql.sql, jednak przy wl?czaniu silnika mam problem:
35568506.jpg

No i nie wiem co zrobi?, prosz? o pomoc, bo w tych klimatach jestem newbie, lub jak kto woli - noob.
A i dorzucam zawarto?? pliku config.lua:
-- The Forgotten Server Config
-- Credits FrankFarmer @ Otland
-- Account manager
accountManager = false
namelockManager = true
newPlayerChooseVoc = false
newPlayerSpawnPosX = 95
newPlayerSpawnPosY = 117
newPlayerSpawnPosZ = 7
newPlayerTownId = 1
newPlayerLevel = 1
newPlayerMagicLevel = 0
generateAccountNumber = false
-- Unjustified kills
redSkullLength = 2 * 24 * 60 * 60
blackSkullLength = 3 * 24 * 60 * 60
dailyFragsToRedSkull = 10
weeklyFragsToRedSkull = 20
monthlyFragsToRedSkull = 30
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 = 10
banLength = 1 * 24 * 60 * 60
killsBanLength = 1 * 12 * 60 * 60
finalBanLength = 2 * 24 * 60 * 60
ipBanishmentLength = 2 * 24 * 60 * 60
broadcastBanishments = true
maxViolationCommentSize = 200
violationNameReportActionType = 2
autoBanishUnknownBytes = false
-- Battle
worldType = "pvp"
protectionLevel = 8
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 = 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 = "project-society.com"
bindOnlyConfiguredIpAddress = false
loginPort = 7171
gamePort = 7172
adminPort = 7171
statusPort = 7171
loginTries = 10
retryTimeout = 5 * 1000
loginTimeout = 60 * 1000
maxPlayers = 300
motd = "Welcome to the new release of Project Society!"
displayOnOrOffAtCharlist = false
onePlayerOnlinePerAccount = false
allowClones = false
serverName = "Project Society"
loginMessage = "Project Society is here, remember that friends is more powerful then having a high level."
statusTimeout = 5 * 60 * 1000
replaceKickOnLogin = true
forceSlowConnectionsToDisconnect = false
loginOnlyWithLoginServer = false
premiumPlayerSkipWaitList = false
-- Database
sqlType = "mysql"
sqlHost = "localhost"
sqlPort = 7171
sqlUser = "root"
sqlPass = "toor"
sqlDatabase = "project-society"
sqlFile = "forgottenserver.s3db"
sqlKeepAlive = 0
mysqlReadTimeout = 10
mysqlWriteTimeout = 10
encryptionType = "plain"
-- Deathlist
deathListEnabled = true
deathListRequiredTime = 1 * 60 * 1000
deathAssistCount = 2
maxDeathRecords = 5
-- Guilds
ingameGuildManagement = false
levelToFormGuild = 8
premiumDaysToFormGuild = 0
guildNameMinLength = 4
guildNameMaxLength = 20
-- Highscores
highscoreDisplayPlayers = 20
updateHighscoresAfterMinutes = 60
-- Houses
buyableAndSellableHouses = true
houseNeedPremium = true
bedsRequirePremium = true
levelToBuyHouse = 8
housesPerAccount = 1
houseRentAsPrice = false
housePriceAsRent = true
housePriceEachSquare = 500
houseRentPeriod = "weekly"
houseCleanOld = 0
guildHalls = true
-- Item usage
timeBetweenActions = 200
timeBetweenExActions = 1000
checkCorpseOwner = true
hotkeyAimbotEnabled = true
maximumDoorLevel = 500
-- Map
mapName = "project-society"
mapAuthor = "frankfarmer"
randomizeTiles = true
useHouseDataStorage = true
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 = false
storePlayerDirection = false
monsterLootMessage = 3
monsterLootMessageType = 25
separateViplistPerCharacter = false
-- Ghost mode
ghostModeInvisibleEffect = true
ghostModeSpellEffects = true
-- Limits
idleWarningTime = 14 * 60 * 1000
idleKickTime = 9999 * 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 = true
rateExperience = 6.0
rateExperienceFromPlayers = 0
rateSkill = 25.0
rateMagic = 15.0
rateLoot = 4.5
rateSpawn = 1
-- 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 = 0
rateStaminaGain = 1000 / 2
rateStaminaThresholdGain = 4
staminaRatingLimitTop = 41 * 60
staminaRatingLimitBottom = 14 * 60
rateStaminaAboveNormal = 1.0
rateStaminaUnderNormal = 1.0
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 = 8
shutdownAtGlobalSave = true
cleanMapAtGlobalSave = false
-- Spawns
deSpawnRange = 2
deSpawnRadius = 50
-- Summons
maxPlayerSummons = 2
teleportAllSummons = false
teleportPlayerSummons = false
-- Status
ownerName = "frankfarmer"
ownerEmail = ""
url = ""
location = "Sweden"
displayGamemastersWithOnlineCommand = false
-- Logs
adminLogsEnabled = true
displayPlayersLogging = true
prefixChannelLogs = ""
runFile = ""
outLogName = ""
errorLogName = ""
truncateLogsOnStartup = false
-- Credits FrankFarmer @ Otland
 

Eturl

We shall know no fear!
Joined
May 21, 2008
Messages
2,280
Reaction score
463
Age
32
Odp: Problem z odpaleniem silnika (b??d w ??czeniu z baz? MySQL)

tutaj masz ustawi? w?asne dane
Code:
-- Database
sqlType = "mysql"
sqlHost = "localhost"
sqlPort = 7171
sqlUser = "root"
sqlPass = ""             [COLOR="Red"]<< has?o do bazy[/COLOR]
sqlDatabase = ""  [COLOR="Red"]<< nazwa bazy, kt?r? utworzy?e?[/COLOR]
sqlFile = "forgottenserver.s3db"
 

divxdivine

User
Joined
Jan 18, 2010
Messages
11
Reaction score
0
Odp: Problem z odpaleniem silnika (b??d w ??czeniu z baz? MySQL)

A faktycznie, zapomnia?em o podaniu nazwy bazy, jednak teraz nasuwa si? drugi problem:

17871997.jpg



A i dzi?kuj? za tak szybkie odpisanie ;)
 

Eturl

We shall know no fear!
Joined
May 21, 2008
Messages
2,280
Reaction score
463
Age
32
Odp: Problem z odpaleniem silnika (b??d w ??czeniu z baz? MySQL)

Czy aby na pewno masz ustawion? dobr? nazw? i has?o do bazy?

Czasem nie zmieniaj tego
Code:
-- Database
sqlType = "mysql"
sqlHost = "localhost"     [COLOR="Red"]<<tu ma by? tak jak jest[/COLOR]
 

divxdivine

User
Joined
Jan 18, 2010
Messages
11
Reaction score
0
Odp: Problem z odpaleniem silnika (b??d w ??czeniu z baz? MySQL)

Czy aby na pewno masz ustawion? dobr? nazw? i has?o do bazy?
Czasem nie zmieniaj tego
Code:
-- Database
sqlType = "mysql"
sqlHost = "localhost"     [COLOR="Red"]<<tu ma by? tak jak jest[/COLOR]

Tak, tego nie rusza?em.
Na dodatek usun??em has?a z root?w i po ponownym uruchomieniu silnika sytuacja si? nie zmienia.

Kawa?ek z pliku config.lua:
-- Database
sqlType = "mysql"
sqlHost = "localhost"
sqlPort = 7171
sqlUser = "root"
sqlPass = ""
sqlDatabase = "forgottenserver"
sqlFile = "forgottenserver.s3db"
sqlKeepAlive = 0
mysqlReadTimeout = 10
mysqlWriteTimeout = 10
encryptionType = "plain"
 

ErMex

Egzekucja
Joined
Dec 1, 2010
Messages
574
Reaction score
181
Odp: Problem z odpaleniem silnika (b??d w ??czeniu z baz? MySQL)

Tak, tego nie rusza?em.
Na dodatek usun??em has?a z root?w i po ponownym uruchomieniu silnika sytuacja si? nie zmienia.
Kawa?ek z pliku config.lua:

Ostatnia opcja: Mo?liwe, ?e wpisujesz z?? nazw? bazy danych. Skoro m?wisz, ?e login/has?o jest ok to tylko to pozosta?o...

Chodzi mi o t? linijk?:
Code:
sqlDatabase = "forgottenserver"
 

divxdivine

User
Joined
Jan 18, 2010
Messages
11
Reaction score
0
Odp: Problem z odpaleniem silnika (b??d w ??czeniu z baz? MySQL)

Ostatnia opcja: Mo?liwe, ?e wpisujesz z?? nazw? bazy danych. Skoro m?wisz, ?e login/has?o jest ok to tylko to pozosta?o...
Chodzi mi o t? linijk?:
Code:
sqlDatabase = "forgottenserver"
Nazwa bazy jednak Tw?j tok my?lenia doprowadzi? mnie do odpowiedzi - zapomnia?em wcze?niej, ?e zmieni?em port 3306 na 7171.
Hmm, teraz pozostaje tylko zrobi? konto God'a, w bazie danych, tylko nie za bardzo wiem jak xD
 

ErMex

Egzekucja
Joined
Dec 1, 2010
Messages
574
Reaction score
181
Odp: Problem z odpaleniem silnika (b??d w ??czeniu z baz? MySQL)

teraz pozostaje tylko zrobi? konto God'a, w bazie danych, tylko nie za bardzo wiem jak xD

Wchodzisz na stron? a nast?pnie klikasz na swoj? nazw? bazy danych. Gdy ju? to zrobisz szukasz po lewej stronie zak?adki "Players". Po klikni?ciu w t? zak?adk? szukasz na g?rze przycisku "przegl?daj" a nast?pnie go klikasz. Potem wystarczy poszuka? swojego nicku > da? edytuj > ustawi? group_id 6. To tyle. Powodzenia!

Pozdrawiam,
ErMex



Notka moderatorska:
OT Expert, + 1pkt
 
Last edited by a moderator:

divxdivine

User
Joined
Jan 18, 2010
Messages
11
Reaction score
0
Odp: Problem z odpaleniem silnika (b??d w ??czeniu z baz? MySQL)

Wchodzisz na stron? a nast?pnie klikasz na swoj? nazw? bazy danych. Gdy ju? to zrobisz szukasz po lewej stronie zak?adki "Players". Po klikni?ciu w t? zak?adk? szukasz na g?rze przycisku "przegl?daj" a nast?pnie go klikasz. Potem wystarczy poszuka? swojego nicku > da? edytuj > ustawi? group_id 6. To tyle. Powodzenia!

Pozdrawiam,
ErMex
Tak, ju? teraz wszystko jasne. Pozostaje mi tylko rl mapk? znale??, a dla was Panowie lec? pochwa?y, piwko, czy jak to si? tam zwie.. ;D

Notka moderatorska:
Zamykam
 
Status
Not open for further replies.
Top