• 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!

MySQL How to setup a MySQL Database (screenshots included) - Last update: 16/7/2009

Did it work? Remember that you must cd to the folder where your forgottenserver.sql is located before you do this.
 
triggers.sql and forgottenserver.sql are the same file really it just depends on what you feel like naming it right?
 
when i do all that to get to my player to make him a gm it wont show my player. any one can help plz?
 
i made all and when i try to search for accs made with acc manager they just dont appear but i login with them and they work
and i try to change acc/pas from the acc manager and it doesnt works
any1 have a clue what i could made wrong
i already made all the steps twice
 
Last edited:
gettog get said:
when i do all that to get to my player to make him a gm it wont show my player. any one can help plz?
Click to expand...


using the drop down box, click the database that you made for your server (mine is TFS) then a list will appear on the left, this is the items in your DB, select Players.

now on the right a new list will appear, at the top click on the Browse tab.

now the list of created players will appear.

arestides said:
i made all and when i try to search for accs made with acc manager they just dont appear but i login with them and they work
and i try to change acc/pas from the acc manager and it doesnt works
any1 have a clue what i could made wrong
i already made all the steps twice
Click to expand...


the same thing happened to me.

Question, when you log off your character and reboot the server, does it save the character info?

If no then you need to update the path in your config, likely it has a path to the first time you tried it.

what this means is that you are running off of two databases.

check your paths in config and/or delete both databases and start again.

double posts ... forum doesn't have a delete option sorry
 
Last edited by a moderator:
>> Loading config
>> loading RSA key
>> Testing sql connection.. MySQL
MySQL ERROR mysql_real_connect unkown database 'the forgottenserver'
ERROR: failed to connect to database read doc/MYSQL_HELP for information
or try sqlite which doesn't require any cnnection
 
Im getting this Error :[16/07/2008 11:13:09] Failed to connect to database. MYSQL ERROR: Access denied for user 'root'@'localhost' (using password: YES)
[16/07/2008 11:13:09] > ERROR: Couldn't estabilish connection to SQL database!
 
Does MySQL (NOT SQLite) have a problem loading attributes for items (using TFS)?

This is an error I get loading item attributes with SQLite, if they load properly with MySQL I will switch! :p

Failed to unserialize attr_type: 16 for item: 6132
WARNING: Serialize error in IOLoginData::loadItems
 
[17/07/2008 22:48:14] The Forgotten Server - Version 0.3rc? (-).
[17/07/2008 22:48:14] A server developed by Talaturen, Kiper, Kornholijo, Jonern, Lithium, slawkens & Elf.
[17/07/2008 22:48:14] Visit our forum for updates, support and resources: http://otland.net/.

[17/07/2008 22:48:14] >> Loading config
[17/07/2008 22:48:14] > ERROR: Unable to load config.lua!


I dont get this when im starting up the server?!?

my config file is currently..
Code: 
-- The Forgotten Server Config

	-- Account Manager
	accountManager = "yes"
	namelockManager = "yes"
	newPlayerChooseVoc = "no"
	newPlayerSpawnPosX = 32097
	newPlayerSpawnPosY = 32219
	newPlayerSpawnPosZ = 7
	newPlayerTownId = 1
	newPlayerLevel = 1
	newPlayerMagicLevel = 1
	generateAccountNumber = "no"

	-- Banishments
	notationsToBan = 3
	warningsToFinalBan = 4
	warningsToDeletion = 5
	banLenght = 7 * 24 * 60 * 60
	finalBanLenght = 30 * 24 * 60 * 60
	ipBanishmentLenght = 1 * 24 * 60 * 60
	broadcastBanishments = "yes"
	killsToBan = 5
	maxViolationCommentSize = 200

	-- Battle
	worldType = "pvp"
	hotkeyAimbotEnabled = "yes"
	protectionLevel = 30
	killsToRedSkull = 3
	pzLocked = 60 * 1000
	--[[ 
	*** temporally(?) deprected ***
	deathLosePercent = 10
	]]--
	criticalHitChance = 7
	removeAmmoWhenUsingDistanceWeapon = "yes"
	removeChargesFromRunes = "yes"
	timeToDecreaseFrags = 24 * 60 * 60 * 1000
	whiteSkullTime = 15 * 60 * 1000
	displayOnOrOffAtCharlist = "no"
	allowChangeOutfit = "yes"
	noDamageToSameLookfeet = "no"
	experienceByKillingPlayers = "no"

	-- Connection Config
	ip = "************"
	port = 7272
	loginTries = 5
	retryTimeout = 30 * 1000
	loginTimeout = 60 * 1000
	maxPlayers = "100"
	motd = "Welcome to Eclipse 0.4 Real Map."
	onePlayerOnlinePerAccount = "yes"
	allowClones = 0
	serverName = "Eclipse 0.4"
	loginMessage = "Welcome to Eclipse 0.4 Real Map."
	adminLogsEnabled = "no"
	statusTimeout = 5 * 60 * 1000

	-- Guilds
	inGameGuildManagement = "yes"
	levelToFormGuild = 8
	guildNameMinLength = 4
	guildNameMaxLength = 20

	-- Highscores and Deathlist
	highscoreDisplayPlayers = 15
	updateHighscoresAfterMinutes = 60
	deathListEnabled = "yes"
	maxDeathRecords = 5

	-- Houses
	buyableAndSellableHouses = "yes"
	housesPerAccount = 0 -- 0 = no limit
	levelToBuyHouse = 1
	houseRentAsPrice = "no"
	housePriceAsRent = "no"
	housePriceEachSQM = 1000
	houseRentPeriod = "never"
	houseNeedPremiumAccount = "yes"	

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

	-- Miscellaneous
	kickIdlePlayerAfterMinutes = 15
	maxMessageBuffer = 4
	displayGamemastersWithOnlineCommand = "no"
	defaultPriority = "high"
	bankSystem = "yes"

	-- Item Usage
	timeBetweenActions = 200
	timeBetweenExActions = 1000

	-- Map
	mapName = "world"
	mapAuthor = "Gregor"
	randomizeTiles = "yes"
	
	-- Database
	passwordType = "plain"
	sqlType = "mysql"
	mysqlHost = "localhost"
	mysqlUser = "root"
	mysqlPass = "*********"
	mysqlDatabase = "paradisal"
	mysqlPort = 3306

	-- Rates
	rateExp = 5
	rateSkill = 50
	rateLoot = 10
	rateMagic = 50
	rateSpawn = 1

	-- Server Save
	serverSaveEnabled = "yes"
	serverSaveHour = 1
	shutdownAtServerSave = "yes"
	cleanMapAtServerSave = "yes"

	-- Spawns
	deSpawnRange = 2
	deSpawnRadius = 50

	-- Status
	ownerName = "Gregor"
	ownerEmail = "@otland.net"
	url = "http://otland.net/"
	location = "Poland"


Please help me asap,

Thank you!!!
 
Last edited by a moderator:
for me didn`t worked, i fallowed more tha 3 tutorials and no one could helped me
the error when i launch it:
[26/07/2008 22:39:09] The Forgotten Server - Version 0.3rcPre-Alpha (-).
[26/07/2008 22:39:09] A server developed by Talaturen, Kiper, Kornholijo, Jonern, Lithium, slawkens & Elf.
[26/07/2008 22:39:09] Visit our forum for updates, support and resources: http://otland.net/.

[26/07/2008 22:39:09] >> Loading config
[26/07/2008 22:39:09] >> Loading RSA key
[26/07/2008 22:39:09] >> Testing SQL connection
[26/07/2008 22:39:09] OTS_SQLITE3_PREPARE(): SQLITE ERROR: no such table: players
[26/07/2008 22:39:09] > ERROR: Couldn't estabilish connection to SQL database!
 
Last edited:
DAcs said:
for me didn`t worked, i fallowed more tha 3 tutorials and no one could helped me
the error when i launch it:
[26/07/2008 22:39:09] The Forgotten Server - Version 0.3rcPre-Alpha (-).
[26/07/2008 22:39:09] A server developed by Talaturen, Kiper, Kornholijo, Jonern, Lithium, slawkens & Elf.
[26/07/2008 22:39:09] Visit our forum for updates, support and resources: http://otland.net/.

[26/07/2008 22:39:09] >> Loading config
[26/07/2008 22:39:09] >> Loading RSA key
[26/07/2008 22:39:09] >> Testing SQL connection
[26/07/2008 22:39:09] OTS_SQLITE3_PREPARE(): SQLITE ERROR: no such table: players
[26/07/2008 22:39:09] > ERROR: Couldn't estabilish connection to SQL database!
Click to expand...

"[26/07/2008 22:39:09] OTS_SQLITE3_PREPARE(): SQLITE ERROR: no such table: players"

Do you really use SQLite? This is a MySQL tutorial...anyway check if you really want SQLite and make sure you imported the .sql file of TFS in the database.


robbieh1988 said:
[17/07/2008 22:48:14] The Forgotten Server - Version 0.3rc? (-).
[17/07/2008 22:48:14] A server developed by Talaturen, Kiper, Kornholijo, Jonern, Lithium, slawkens & Elf.
[17/07/2008 22:48:14] Visit our forum for updates, support and resources: http://otland.net/.

[17/07/2008 22:48:14] >> Loading config
[17/07/2008 22:48:14] > ERROR: Unable to load config.lua!


I dont get this when im starting up the server?!?

my config file is currently..
Code: 
-- The Forgotten Server Config

	-- Account Manager
	accountManager = "yes"
	namelockManager = "yes"
	newPlayerChooseVoc = "no"
	newPlayerSpawnPosX = 32097
	newPlayerSpawnPosY = 32219
	newPlayerSpawnPosZ = 7
	newPlayerTownId = 1
	newPlayerLevel = 1
	newPlayerMagicLevel = 1
	generateAccountNumber = "no"

	-- Banishments
	notationsToBan = 3
	warningsToFinalBan = 4
	warningsToDeletion = 5
	banLenght = 7 * 24 * 60 * 60
	finalBanLenght = 30 * 24 * 60 * 60
	ipBanishmentLenght = 1 * 24 * 60 * 60
	broadcastBanishments = "yes"
	killsToBan = 5
	maxViolationCommentSize = 200

	-- Battle
	worldType = "pvp"
	hotkeyAimbotEnabled = "yes"
	protectionLevel = 30
	killsToRedSkull = 3
	pzLocked = 60 * 1000
	--[[ 
	*** temporally(?) deprected ***
	deathLosePercent = 10
	]]--
	criticalHitChance = 7
	removeAmmoWhenUsingDistanceWeapon = "yes"
	removeChargesFromRunes = "yes"
	timeToDecreaseFrags = 24 * 60 * 60 * 1000
	whiteSkullTime = 15 * 60 * 1000
	displayOnOrOffAtCharlist = "no"
	allowChangeOutfit = "yes"
	noDamageToSameLookfeet = "no"
	experienceByKillingPlayers = "no"

	-- Connection Config
	ip = "************"
	port = 7272
	loginTries = 5
	retryTimeout = 30 * 1000
	loginTimeout = 60 * 1000
	maxPlayers = "100"
	motd = "Welcome to Eclipse 0.4 Real Map."
	onePlayerOnlinePerAccount = "yes"
	allowClones = 0
	serverName = "Eclipse 0.4"
	loginMessage = "Welcome to Eclipse 0.4 Real Map."
	adminLogsEnabled = "no"
	statusTimeout = 5 * 60 * 1000

	-- Guilds
	inGameGuildManagement = "yes"
	levelToFormGuild = 8
	guildNameMinLength = 4
	guildNameMaxLength = 20

	-- Highscores and Deathlist
	highscoreDisplayPlayers = 15
	updateHighscoresAfterMinutes = 60
	deathListEnabled = "yes"
	maxDeathRecords = 5

	-- Houses
	buyableAndSellableHouses = "yes"
	housesPerAccount = 0 -- 0 = no limit
	levelToBuyHouse = 1
	houseRentAsPrice = "no"
	housePriceAsRent = "no"
	housePriceEachSQM = 1000
	houseRentPeriod = "never"
	houseNeedPremiumAccount = "yes"	

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

	-- Miscellaneous
	kickIdlePlayerAfterMinutes = 15
	maxMessageBuffer = 4
	displayGamemastersWithOnlineCommand = "no"
	defaultPriority = "high"
	bankSystem = "yes"

	-- Item Usage
	timeBetweenActions = 200
	timeBetweenExActions = 1000

	-- Map
	mapName = "world"
	mapAuthor = "Gregor"
	randomizeTiles = "yes"
	
	-- Database
	passwordType = "plain"
	sqlType = "mysql"
	mysqlHost = "localhost"
	mysqlUser = "root"
	mysqlPass = "*********"
	mysqlDatabase = "paradisal"
	mysqlPort = 3306

	-- Rates
	rateExp = 5
	rateSkill = 50
	rateLoot = 10
	rateMagic = 50
	rateSpawn = 1

	-- Server Save
	serverSaveEnabled = "yes"
	serverSaveHour = 1
	shutdownAtServerSave = "yes"
	cleanMapAtServerSave = "yes"

	-- Spawns
	deSpawnRange = 2
	deSpawnRadius = 50

	-- Status
	ownerName = "Gregor"
	ownerEmail = "@otland.net"
	url = "http://otland.net/"
	location = "Poland"


Please help me asap,

Thank you!!!
Click to expand...


Are you crazy?
ip = "************"
Click to expand...
I don't think that this is your IP.

Suggestion: Try using the forgotten server and download it from Talaturen's thread



dashmaniac said:
>> Loading config
>> loading RSA key
>> Testing sql connection.. MySQL
MySQL ERROR mysql_real_connect unkown database 'the forgottenserver'
ERROR: failed to connect to database read doc/MYSQL_HELP for information
or try sqlite which doesn't require any cnnection
Click to expand...

A database with name "the forgottenserver" does not exists...that's the problem.

bakerboy said:
Im getting this Error :[16/07/2008 11:13:09] Failed to connect to database. MYSQL ERROR: Access denied for user 'root'@'localhost' (using password: YES)
[16/07/2008 11:13:09] > ERROR: Couldn't estabilish connection to SQL database!
Click to expand...

Most likely you have specified a wrong password for the user root in config.lua
 
Last edited:
Umm...So where can I find the .sql file? All that is in the DL on Talas thread is the schema files and the .s3db....
 
Yuo'r Rox Do You know that ? :p:eek:

Thanks alot man
 
Last edited by a moderator:
- Tutorial fully updated. Now pictures are included and the tutorial supports the latest TFS version. -
 

Similar threads

mar173
[13.21.13839][RLMAP] Fastest way to run Local Server
Replies
8
Views
3K
Freazy
F
222222
Don't use MySQL - use MariaDB
Replies
2
Views
735
Srnt
S
Epsilons
  • Question
OTClient Stuck on "Please wait : Connecting to login server" (ERROR: got a network message with invalid checksum)
Replies
9
Views
509
Marko999x
Marko999x
Back
Top