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

M

mujica

New Member
Joined
Feb 3, 2010
Messages
203
Reaction score
3
mysqlerror.jpg


I get this error but i am pretty sure i have mysql setup correctly is there anything i should look at that maybe alot of people overlook?
Thanks and how do i rep lol people xD
 
Sort by date Sort by votes
Like as ip in config? Okay ive tried to reload database for mysql and it didnt work its a tfs 0.4

Okay I Tried Loading on sqlite and local host phpmyadmin. Didnt work so is it my mysql file that messed up
 
Last edited by a moderator:
Upvote 0 Downvote
This or Full?

-- MySQL
mysqlHost = "localhost"
mysqlUser = "root"
mysqlPass = "****"
mysqlDatabase = "mystic"
mysqlPort = 3306
 
Upvote 0 Downvote
Code: 
-- The Forgotten Server Config

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

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

	-- Battle
	worldType = "pvp"
	hotkeyAimbotEnabled = "yes"
	protectionLevel = 25
	useBlackSkull = "yes"
	killsToBlackSkull = 5
	orangeSkullTime = 24*60*60
	killsToRedSkull = 3
	pzLocked = 60000
	deathLosePercent = 10
	criticalHitChance = 7
	removeAmmoWhenUsingDistanceWeapon = "yes"
	removeChargesFromRunes = "yes"
	removeChargesFromWeapons = "yes"
	timeToDecreaseFrags = 24 * 60 * 60 * 1000
	whiteSkullTime = 15 * 60 * 1000
	oldConditionAccuracy = "no"
	stairJumpExhaustion = 2000
	animationTextOnHeal = "yes"

	-- Commands
	displayGamemastersWithOnlineCommand = "no"

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

	-- Deathlist
	deathListEnabled = "yes"
	maxDeathRecords = 5

	-- Guilds
	ingameGuildSystem = "yes"
	levelToCreateGuild = 8

	-- 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 = "yes"
	mapStorageType = "relational"

	-- Messaging
	maxMessageBuffer = 4

	-- MySQL
	mysqlHost = "localhost"
	mysqlUser = "root"
	mysqlPass = "------"
	mysqlDatabase = "mystic"
	mysqlPort = 3306

	-- Premium Account
	freePremium = "no"

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

	-- Rates
	rateExp = 50
	rateSkill = 15
	rateLoot = 4
	rateMagic = 15
	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 = "plain"

	-- Startup
	defaultPriority = "high"

	-- Shutdown
	freeMemoryAtShutdown = "yes"

	-- Status
	ownerName = ""
	ownerEmail = "@otland.net"
	url = "http://otland.net/"
	location = "Europe"
 
Last edited by a moderator:
Upvote 0 Downvote
Ok mate!

delete this:
Code: 
-- MySQL
mysqlHost = "localhost"
mysqlUser = "root"
mysqlPass = "------"
mysqlDatabase = "mystic"
mysqlPort = 3306

And put this:

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

remember to put your password and also not forgot to said if it works!
 
Upvote 0 Downvote
Raiden said:
Ok mate!

delete this:
Code: 
-- MySQL
mysqlHost = "localhost"
mysqlUser = "root"
mysqlPass = "------"
mysqlDatabase = "mystic"
mysqlPort = 3306

And put this:

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

remember to put your password and also not forgot to said if it works!
Click to expand...

Sometimes this:
sqlType = "mysql"
sqlHost = "localhost"
sqlPort = 3306
sqlUser = "root"
sqlPass = "----"
sqlDatabase = "mystic"
sqlFile = "forgottenserver.s3db"
sqlKeepAlive = 0
mysqlReadTimeout = 10
mysqlWriteTimeout = 10
encryptionType = "plain"

wont work for old TFS.
So lets see his distro.

witch DISTRO r u using?
 
Upvote 0 Downvote
It said please set encryptionType to Sha1 so its set as plain do i change it as it says?

``````Thanks for the help so far xD````````

Oh and TFS 0.4
 
Last edited by a moderator:
Upvote 0 Downvote
Hmm Well does anyone use teamviewer or anything? its a Up to date 0.4 on phpadmin i cant load mysql database i tried to reload database to see if thats the issue and now it wont even load the database from the mysql file
 
Upvote 0 Downvote
I would take TFS 0.3.6 if i was u. There is many script for 0.3.6 and many homepage applicatiions. Its stable too.
 
Upvote 0 Downvote
Back
Top