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

Solved Sql Connection error

You need to configure config.lua correctly, maybe is the reason that you're MySQL connection isn't working.

LUA:
	sqlType = "mysql"
	sqlHost = "127.0.0.1"
	sqlPort = 3306
	sqlUser = "root"
	sqlPass = "password123"
	sqlDatabase = "dbname"
	sqlFile = "theforgottenserver.s3db"
	sqlKeepAlive = 0
	mysqlReadTimeout = 10
	mysqlWriteTimeout = 10
	encryptionType = "sha1"
 
You need to configure config.lua correctly, maybe is the reason that you're MySQL connection isn't working.

LUA:
	sqlType = "mysql"
	sqlHost = "127.0.0.1"
	sqlPort = 3306
	sqlUser = "root"
	sqlPass = "password123"
	sqlDatabase = "dbname"
	sqlFile = "theforgottenserver.s3db"
	sqlKeepAlive = 0
	mysqlReadTimeout = 10
	mysqlWriteTimeout = 10
	encryptionType = "sha1"


on the EncryptionType would it not be best to use "plain" not "sha1"

Just Thought I Would Mention It :)
 
on the EncryptionType would it not be best to use "plain" not "sha1"

Just Thought I Would Mention It :)

Don't mention things that you don't have any clue about. :p

Lets say we are using test123 as password, do you see the difference?

sha1: 7288edd0fc3ffcbe93a0cf06e3568e28521687bc

plain: test123
 
Now I've a doubt. For the that we will use sha1 itself the face that invade to database is going to have access the soul of the server? Plain he will have access the straight bill and ecrypted sha1 also! Barely its not going to visualize the password?

im confuse, can explain me?
 
Back
Top