• There is NO official Otland's Discord server and NO official Otland's server list. The Otland's Staff does not manage any Discord server or server list. Moderators or administrator of any Discord server or server lists have NO connection to the Otland's Staff. Do not get scammed!
  • 2026 staff recruitment is open! Check it out and consider applying!

I have a SQL Error!!

MestreDaro

New Member
Joined
Nov 17, 2008
Messages
5
Reaction score
0
Hello, I was wondering if some one can help me.. i have the forgotten server-Version 0.3 (Alpha 4).
When i try to open my server.. Some kind of error apears me..
This is it..
Starting SQL connection
[28/11/2008 13:07:40] Failed connecting to database. MYSQL ERROR: Can't connect to MySQL server on 'localhost' (10061)
[28/11/2008 13:07:40] > ERROR: Couldn't estabilish connection to SQL database!
What i need to do to star my server?, some one knows?..:huh:
 
-------------------- The EldinWorld Server Config -------------------

-- Account manager
accountManager = "yes"
namelockManager = "yes"
newPlayerChooseVoc = "yes"
newPlayerSpawnPosX = 50
newPlayerSpawnPosY = 50
newPlayerSpawnPosZ = 7
newPlayerTownId = 1
newPlayerLevel = 8
newPlayerMagicLevel = 0
generateAccountNumber = "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"
killsToBan = 6
maxViolationCommentSize = 200

-- Battle
worldType = "pvp"
hotkeyAimbotEnabled = "yes"
protectionLevel = 8
pvpTileIgnoreLevelAndVocationProtection = "yes"
killsToRedSkull = 3
pzLocked = 60 * 1000
criticalHitChance = 10
displayCriticalHitNotify = "yes"
removeAmmoWhenUsingDistanceWeapon = "yes"
removeChargesFromRunes = "yes"
timeToDecreaseFrags = 24 * 60 * 60 * 1000
whiteSkullTime = 15 * 60 * 1000
noDamageToSameLookfeet = "no"
experienceByKillingPlayers = "no"
showHealingDamage = "yes"

-- Connection config
ip = "189.202.112.45"
port = 7171
loginTries = 10
retryTimeout = 5 * 1000
loginTimeout = 60 * 1000
maxPlayers = "1000"
motd = "ELDINWORLD!\nCreated by Eldin.\n\nPlease choose your character.\nLet the adventure begin...\n\nWhat would you like to see next?\[email protected]"
displayOnOrOffAtCharlist = "no"
onePlayerOnlinePerAccount = "yes"
allowClones = 0
serverName = "EldinWorld"
loginMessage = "Welcome to an EldinWorld server! Visit EldinWorld Project | The Open Tibia Server for support."
adminLogsEnabled = "no"
statusTimeout = 5 * 60 * 1000
replaceKickOnLogin = "yes"
forceSlowConnectionsToDisconnect = "no"

-- Database
-- NOTE: sqlFile is used only by sqlite database, and sqlKeepAlive by mysql database.
-- To disable sqlKeepAlive use 0 value.
sqlType = "mysql"
sqlHost = "localhost"
sqlPort = 3306
sqlUser = "root"
sqlPass = "password"
sqlDatabase = "eldinworld"
sqlFile = "eldinworld.s3db"
sqlKeepAlive = 60
passwordType = "plain"

-- Deathlist
deathListEnabled = "yes"
maxDeathRecords = 5

-- Guilds
ingameGuildManagement = "yes"
levelToFormGuild = 8
guildNameMinLength = 3
guildNameMaxLength = 30

-- Highscores
highscoreDisplayPlayers = 25
updateHighscoresAfterMinutes = 60

-- Houses
buyableAndSellableHouses = "yes"
housesPerAccount = 0
levelToBuyHouse = 1
houseRentAsPrice = "no"
housePriceAsRent = "no"
housePriceEachSQM = 100
houseRentPeriod = "weekly"
houseNeedPremiumAccount = "yes"

-- Item usage
timeBetweenActions = 200
timeBetweenExActions = 1000

-- Map
mapName = "EldinWorld"
mapAuthor = "Eldin"
randomizeTiles = "yes"
cleanProtectedZones = "yes"

-- Miscellaneous
-- NOTE: defaultPriority works only on Windows
kickIdlePlayerAfterMinutes = 15
allowChangeOutfit = "yes"
maxMessageBuffer = 4
displayGamemastersWithOnlineCommand = "no"
defaultPriority = "high"
saveGlobalStorage = "yes"
bankSystem = "no"
displaySkillLevelOnAdvance = "yes"
spellNameInsteadOfWordsOnCast = "yes"

-- Premium account
freePremium = "yes"
premiumForPromotion = "yes"
removePremiumOnInit = "yes"

-- Rates
rateExp = stages
rateSkill = 10
rateLoot = 1
rateMagic = 2
rateSpawn = 1

-- Global save
-- NOTE: globalSaveHour means like 03:00, not that it will save every 3 hours,
-- if you want such a system please check out data/globalevents directory.
globalSaveEnabled = "no"
globalSaveHour = 8
shutdownAtGlobalSave = "yes"
cleanMapAtGlobalSave = "no"

-- Spawns
deSpawnRange = 2
deSpawnRadius = 50

-- Summons
maxPlayerSummons = 2
teleportAllSummons = "no" --FIXME: Doesn't work
teleportPlayerSummons = "no" --FIXME: Doesn't work

-- Status
ownerName = "Eldin"
ownerEmail = "[email protected]"
url = "http://www.eldinworld.webs.com"
location = "Sweden"
I guess this is all
Hope you can help me..
 
-- Database
-- NOTE: sqlFile is used only by sqlite database, and sqlKeepAlive by mysql database.
-- To disable sqlKeepAlive use 0 value.
sqlType = "mysql"
sqlHost = "localhost"
sqlPort = 3306
sqlUser = "root"
sqlPass = "password"
sqlDatabase = "eldinworld"
sqlFile = "eldinworld.s3db"
sqlKeepAlive = 60
passwordType = "plain"

You Most type your MYSQL password in here sqlPass = "password"
 
ERROR: Couldn't estabilish connection to SQL database!

I think the problem is that your server can not estabilish the connection to your SQL database.

...

o.O?

Write correct information in your config.lua.
 
Back
Top