Couldn't estabilish connection to SQL database

[Liimpiish]

Failed connecting to database - MYSQL ERROR: Can't connect to MYSQL server on 'localhost' <10061> <2003>
It would be awesome if someone could help me with this.

 

[Szka]

I think you need to go to config.lua and search something like this:

-- Database
    -- NOTE: sqlFile is used only by sqlite database, and sqlKeepAlive by mysql database.
    -- To disable sqlKeepAlive such as mysqlReadTimeout use 0 value.
    sqlType = "sqlite"
    sqlHost = "localhost"
    sqlPort = 3306
    sqlUser = "root"
    sqlPass = "mysexypassword"
    sqlDatabase = "testowyots" -- in polish, some of you may not understand it
    sqlFile = "forgottenserver.s3db"
    sqlKeepAlive = 0
    mysqlReadTimeout = 10
    mysqlWriteTimeout = 10
    encryptionType = "plain"

Make sure you have the right configuration written for sqlType = "sqlite"

 

[Zoe Skandinavia]

You have to say which TFS are you using. Anyway, if you are using webpage, make sure that you have in your config.lua in sqlType = "mysql", sqlHost = "localhost", sqlPort = 3306, sqlUser = "root" (as default), sqlPass = "WRITE HERE YOUR PASSWORD", sqlDatabase = "WRITE HERE YOUR DB NAME" and thats it.

 

[medo9292]

hey change localhost to 127.0.01

 

[medo9292]

if you wanted it to work as sqltype sqlite keep it localhost but if u wanted to run MYSQL then change localhost to 127.0.01

 

[Zoe Skandinavia]

hey change localhost to 127.0.01

localhost is the same than 127.0.0.1

 

[Smokiee Jo]

@Zoe Skandinavia yeah it is mate but it depends on which TFS Web Acc you use mate as the config.php is different also depends on which TFS platform he is using also

 

[Zoe Skandinavia]

@Zoe Skandinavia yeah it is mate but it depends on which TFS Web Acc you use mate as the config.php is different also depends on which TFS platform he is using also

I see. Well, normally im working on TFS 1.2, so for me it's the same xd

 

[Smokiee Jo]

yeah i saw your OT and website pretty Decent Looks stable but yea tfs 1.1x is the same really if you are using Gesior, if you use Znote then you have to go into the config.php and change it to TFS_10 for it to work thats why i asked what platform he is using

Thanks
SJ

 

[Zoe Skandinavia]

yeah i saw your OT and website pretty Decent Looks stable but yea tfs 1.1x is the same really if you are using Gesior, if you use Znote then you have to go into the config.php and change it to TFS_10 for it to work thats why i asked what platform he is using

Thanks
SJ

Really? Wow thanks , and yup, it's different in gesior and znote.

 

[Liimpiish]

Thank you guys for helping me out i fixed the problem