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

Need help with connection

jesper1118

New Member
Joined
Dec 7, 2008
Messages
27
Reaction score
0
When Im starting the server the console says this
Code:
[29/11/2012 12:10:20] [ServicePort::open] Error: bind: The requested address is not valid in its context
[29/11/2012 12:10:20] [ServicePort::open] Error: bind: The requested address is not valid in its context



Anyone knows where the problem is?
 
Last edited:
At config.lua it should look like this:

bindOnlyConfiguredIpAddress = false
loginPort = 7171
gamePort = 7172
adminPort = 7171
statusPort = 7171
 
That one is open too.

It feels like the db cant connect to the tibia client, cuz now when im trying to login it says : Cannot connect to a login server.
Error: Disconnected from server. (200002)
 
Last edited:
Code:
-- The Forgotten Server Config

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

	-- Banishments
	broadcastBanishments = "yes"
	banDays = 7
	finalBanDays = 30
	killsToBan = 0

	-- Battle
	worldType = "pvp"
	hotkeyAimbotEnabled = "yes"
	protectionLevel = 1
	killsToRedSkull = 3
	killsToBlackSkull = 6
	pzLocked = 60000
	criticalHitChance = 7
	removeAmmoWhenUsingDistanceWeapon = "yes"
	removeChargesFromRunes = "yes"
	removeChargesFromWeapons = "yes"
	timeToDecreaseFrags = 24 * 60 * 60 * 1000
	whiteSkullTime = 15 * 60 * 1000
	oldConditionAccuracy = "no"
	stairJumpExhaustion = 2000

	-- Commands
	displayGamemastersWithOnlineCommand = "yes"

	-- Connection Config
	ip = "my ip"
	bindOnlyGlobalAddress = "false"
	loginProtocolPort = 7171
	gameProtocolPort = 7172
	adminProtocolPort = 7171
	statusProtocolPort = 7171
	loginTries = 20
	retryTimeout = 5 * 1000
	loginTimeout = 60 * 1000
	maxPlayers = "1000"
	motd = "Welcome to the Forgotten Server!"
	onePlayerOnlinePerAccount = "yes"
	allowClones = "no"
	serverName = "Sylera"
	loginMessage = "Welcome to the Forgotten Server!"
	adminLogsEnabled = "no"
	statusTimeout = 5 * 60 * 1000
	replaceKickOnLogin = "yes"

	-- Death
	-- note: Leave deathLosePercent as -1 if you want to use Tibia's
	-- death penalty formula. For the old formula, set it to 10. For
	-- no skill/experience loss, set it to 0.
	deathLosePercent = -1
	deathListEnabled = "yes"
	maxDeathRecords = 5

	-- Guilds
	ingameGuildSystem = "yes"
	levelToCreateGuild = 8
	minGuildNameLength = 4
	maxGuildNameLength = 20

	-- Highscores
	highscoreDisplayPlayers = 15
	updateHighscoresAfterMinutes = 60

	-- Houses
	housePriceEachSQM = 1000
	houseRentPeriod = "never"

	-- Idle
	kickIdlePlayerAfterMinutes = 15

	-- Item Usage
	timeBetweenActions = 200
	timeBetweenExActions = 1000

	-- Map
	mapName = "forgotten"
	mapAuthor = "Komic"
	randomizeTiles = "no"
	mapStorageType = "relational"

	-- Market
	marketEnabled = "yes"
	marketOfferDuration = 30 * 24 * 60 * 60
	premiumToCreateMarketOffer = "yes"
	checkExpiredMarketOffersEachMinutes = 60
	maxMarketOffersAtATimePerPlayer = 100

	-- Messaging
	maxMessageBuffer = 4

	-- MySQL
	mysqlHost = "127.0.0.1"
	mysqlUser = "dbuser"
	mysqlPass = "password"
	mysqlDatabase = "dbname"
	mysqlPort = 3306

	-- Premium Account
	freePremium = "no"

	-- PVP Server
	displayOnOrOffAtCharlist = "no"
	allowChangeOutfit = "yes"
	noDamageToSameLookfeet = "no"
	experienceByKillingPlayers = "no"

	-- Rates
	rateExp = 5
	rateSkill = 3
	rateLoot = 2
	rateMagic = 3
	rateSpawn = 1

	-- Real Server Save
	-- note: serverSaveHour means like 03:00, not that it will save every 3 hours,
	-- if you want such a system use autoSaveEachMinutes. this serversave method
	-- may be unstable, we recommend using otadmin if you want real serversaves.
	serverSaveEnabled = "no"
	serverSaveHour = 3
	shutdownAtServerSave = "yes"
	cleanMapAtServerSave = "yes"

	-- Server saving
	autoSaveEachMinutes = 15
	saveGlobalStorage = "no"

	-- Spawns
	deSpawnRange = 2
	deSpawnRadius = 50

	-- SqLite
	sqliteDatabase = "forgottenserver.s3db"

	-- SQL
	sqlType = "sqlite"
	passwordType = "sha1"

	-- Startup
	defaultPriority = "high"
	startupDatabaseOptimization = "yes"

	-- Shutdown
	freeMemoryAtShutdown = "yes"

	-- Status
	ownerName = ""
	ownerEmail = "@otland.net"
	url = "http://otland.net/"
	location = "Europe"
 
Try this:
Lua:
-- The Forgotten Server Config

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

	-- Banishments
	broadcastBanishments = "yes"
	banDays = 7
	finalBanDays = 30
	killsToBan = 0

	-- Battle
	worldType = "pvp"
	hotkeyAimbotEnabled = "yes"
	protectionLevel = 1
	killsToRedSkull = 3
	killsToBlackSkull = 6
	pzLocked = 60000
	criticalHitChance = 7
	removeAmmoWhenUsingDistanceWeapon = "yes"
	removeChargesFromRunes = "yes"
	removeChargesFromWeapons = "yes"
	timeToDecreaseFrags = 24 * 60 * 60 * 1000
	whiteSkullTime = 15 * 60 * 1000
	oldConditionAccuracy = "no"
	stairJumpExhaustion = 2000

	-- Commands
	displayGamemastersWithOnlineCommand = "yes"

	-- Connection Config
	ip = "my ip"
	bindOnlyGlobalAddress = "false"
	loginProtocolPort = 7171
	gameProtocolPort = 7172
	adminProtocolPort = 7171
	statusProtocolPort = 7171
	loginTries = 20
	retryTimeout = 5 * 1000
	loginTimeout = 60 * 1000
	maxPlayers = "1000"
	motd = "Welcome to the Forgotten Server!"
	onePlayerOnlinePerAccount = "yes"
	allowClones = "no"
	serverName = "Sylera"
	loginMessage = "Welcome to the Forgotten Server!"
	adminLogsEnabled = "no"
	statusTimeout = 5 * 60 * 1000
	replaceKickOnLogin = "yes"

	-- Death
	-- note: Leave deathLosePercent as -1 if you want to use Tibia's
	-- death penalty formula. For the old formula, set it to 10. For
	-- no skill/experience loss, set it to 0.
	deathLosePercent = -1
	deathListEnabled = "yes"
	maxDeathRecords = 5

	-- Guilds
	ingameGuildSystem = "yes"
	levelToCreateGuild = 8
	minGuildNameLength = 4
	maxGuildNameLength = 20

	-- Highscores
	highscoreDisplayPlayers = 15
	updateHighscoresAfterMinutes = 60

	-- Houses
	housePriceEachSQM = 1000
	houseRentPeriod = "never"

	-- Idle
	kickIdlePlayerAfterMinutes = 15

	-- Item Usage
	timeBetweenActions = 200
	timeBetweenExActions = 1000

	-- Map
	mapName = "forgotten"
	mapAuthor = "Komic"
	randomizeTiles = "no"
	mapStorageType = "relational"

	-- Market
	marketEnabled = "yes"
	marketOfferDuration = 30 * 24 * 60 * 60
	premiumToCreateMarketOffer = "yes"
	checkExpiredMarketOffersEachMinutes = 60
	maxMarketOffersAtATimePerPlayer = 100

	-- Messaging
	maxMessageBuffer = 4

	-- MySQL
	mysqlHost = "127.0.0.1"
	mysqlUser = "dbuser"
	mysqlPass = "password"
	mysqlDatabase = "dbname"
	mysqlPort = 3306

	-- Premium Account
	freePremium = "no"

	-- PVP Server
	displayOnOrOffAtCharlist = "no"
	allowChangeOutfit = "yes"
	noDamageToSameLookfeet = "no"
	experienceByKillingPlayers = "no"

	-- Rates
	rateExp = 5
	rateSkill = 3
	rateLoot = 2
	rateMagic = 3
	rateSpawn = 1

	-- Real Server Save
	-- note: serverSaveHour means like 03:00, not that it will save every 3 hours,
	-- if you want such a system use autoSaveEachMinutes. this serversave method
	-- may be unstable, we recommend using otadmin if you want real serversaves.
	serverSaveEnabled = "no"
	serverSaveHour = 3
	shutdownAtServerSave = "yes"
	cleanMapAtServerSave = "yes"

	-- Server saving
	autoSaveEachMinutes = 15
	saveGlobalStorage = "no"

	-- Spawns
	deSpawnRange = 2
	deSpawnRadius = 50

	-- SqLite
	sqliteDatabase = "forgottenserver.s3db"

	-- SQL
	sqlType = "mysql"
	passwordType = "sha1"

	-- Startup
	defaultPriority = "high"
	startupDatabaseOptimization = "yes"

	-- Shutdown
	freeMemoryAtShutdown = "yes"

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

Also i hope you write right information on these parts:
-- MySQL
mysqlHost = "127.0.0.1"
mysqlUser = "dbuser"
mysqlPass = "password"
mysqlDatabase = "dbname"
mysqlPort = 3306

ip = "my ip"

Also when you try login, you use ip changer?
 
Yea, I use the right sql information ^^ and I use the OTland Ip changer

after I changed the config as you posted the config says
Code:
[29/11/2012 13:23:58] mysql_real_query(): DELETE FROM `market_history` WHERE `inserted` <= 1351599838;: MYSQL ERROR: Table 'test.market_history' doesn't exist
[29/11/2012 13:23:58] mysql_real_query(): SELECT `id`, `amount`, `price`, `itemtype`, `player_id` FROM `market_offers` WHERE `sale` = 0 AND `created` <= 1351599838;: MYSQL ERROR: Table 'test.market_offers' doesn't exist
[29/11/2012 13:23:58] mysql_store_result(): SELECT `id`, `amount`, `price`, `itemtype`, `player_id` FROM `market_offers` WHERE `sale` = 0 AND `created` <= 1351599838;: MYSQL ERROR: Table 'test.market_offers' doesn't exist
[29/11/2012 13:23:58] mysql_real_query(): SELECT `id`, `amount`, `price`, `itemtype`, `player_id` FROM `market_offers` WHERE `sale` = 1 AND `created` <= 1351599838;: MYSQL ERROR: Table 'test.market_offers' doesn't exist
[29/11/2012 13:23:58] mysql_store_result(): SELECT `id`, `amount`, `price`, `itemtype`, `player_id` FROM `market_offers` WHERE `sale` = 1 AND `created` <= 1351599838;: MYSQL ERROR: Table 'test.market_offers' doesn't exist
[29/11/2012 13:23:58] mysql_real_query(): SELECT `sale` AS `sale`, `itemtype` AS `itemtype`, COUNT(`price`) AS `num`, MIN(`price`) AS `min`, MAX(`price`) AS `max`, SUM(`price`) AS `sum` FROM `market_history` WHERE `state` = 3 GROUP BY `itemtype`, `sale`;: MYSQL ERROR: Table 'test.market_history' doesn't exist
[29/11/2012 13:23:58] mysql_store_result(): SELECT `sale` AS `sale`, `itemtype` AS `itemtype`, COUNT(`price`) AS `num`, MIN(`price`) AS `min`, MAX(`price`) AS `max`, SUM(`price`) AS `sum` FROM `market_history` WHERE `state` = 3 GROUP BY `itemtype`, `sale`;: MYSQL ERROR: Table 'test.market_history' doesn't exist
[29/11/2012 13:23:58] >> Loaded all modules, server starting up...
[29/11/2012 13:23:59] >> Sylera Server Online!

and I still cant login

- - - Updated - - -

nvm the console errors, It was cuz market was enable
 
You are using mysql and not sql, thats why you get those errors. Seems that market tables is missing.

at config.lua change this:
ip = "my ip" to -> ip = "127.0.0.1"

and try login.
 
Back
Top