Database Connection Problem

[xx Kami xx]

hey i got this problem, and idk how to fix it...can anyone help me?

will Rep++

 

[Bouczas]

1. Have you got database ?
If no, u must find tutorial in google how to make database with tfs.. I prefer uniform server for database but big couple of ppl using xampp
If yes, check it
sqlType = "mysql"
sqlHost = "localhost" <-- phpmyadmin > User > look on your user, probably it's root and check host it's on the right from the user name.
sqlPort = 3306
sqlUser = "root" <-- Check your sql user, many times it's your name which u using to log into phpmyadmin
sqlPass = "" <-- password which have u set.
sqlDatabase = "theforgottenserver" <-- check the name of database in phpmyadmin, it's must be the same us like in config ( config is in your server folder xd ).

 

[Mesmeroo]

post your config.lua

 

[xx Kami xx]

post your config.lua

        sqlType = "mysql"
	sqlHost = "localhost"
	sqlPort = 3306
	sqlUser = ""
	sqlPass = ""
	sqlDatabase = "outlaww"
	sqlFile = "forgottenserver.s3db"
	sqlKeepAlive = 0
	mysqlReadTimeout = 10
	mysqlWriteTimeout = 10
	encryptionType = "sha1"

got server from here
http://otland.net/f18/pheonixia-ot-8-6-new-everything-enjoy-173258/

 

[Bouczas]

sqlUser = "" <-- Empty \ write here root
sqlPass = "" <--Empty / and here your password to phpymyadmin
Have you got done database in xampp or something like that ?!

 

[Mesmeroo]

        sqlType = "mysql"
	sqlHost = "127.0.0.1"
	sqlPort = 3306
	sqlUser = ""
	sqlPass = ""
	sqlDatabase = "outlaww"
	sqlFile = "forgottenserver.s3db"
	sqlKeepAlive = 0
	mysqlReadTimeout = 10
	mysqlWriteTimeout = 10
	encryptionType = "sha1"

try this.
add your user and pass ofc.

 

[xx Kami xx]

        sqlType = "mysql"
	sqlHost = "127.0.0.1"
	sqlPort = 3306
	sqlUser = ""
	sqlPass = ""
	sqlDatabase = "outlaww"
	sqlFile = "forgottenserver.s3db"
	sqlKeepAlive = 0
	mysqlReadTimeout = 10
	mysqlWriteTimeout = 10
	encryptionType = "sha1"

try this.
add your user and pass ofc.

i tried with 127.0.0.1 and i dont need to but password, i did it before its just not working

 

[Bouczas]

Just change
sqltype = "sqlite"
sqlhost = "localhost"
U don't want to do database with mysql, u just want to run ots. But don't forget if u really want do something with server u must use mysql and do database in uniform server or xampp or webserv omg..
If it WON'T work change encryptiontype = "plain"

 

[xx Kami xx]

Just change
sqltype = "sqlite"
sqlhost = "localhost"
U don't want to do database with mysql, u just want to run ots. But don't forget if u really want do something with server u must use mysql and do database in uniform server or xampp or webserv omg..
If it WON'T work change encryptiontype = "plain"

i want a site...