TFS 1.X+ MySQL Error (VPS debian 8)

[nurgiel]

I installed LAMP and php on VPS. compiled TFS, edited config.lua, but after i play server by screen command i get this msg.

>> Loading config
>> establishing database connection...
MySQL Error Message: Can't conntect to MySQL server on 'my server ip' (111)
> ERROR: Failed to connect to database
>> No services running. The server is NOT online

about config.lua

-- Connection Config
-- NOTE: maxPlayers set to 0 means no limit
ip = "144.xx.xxx.xx"
bindOnlyGlobalAddress = false
loginProtocolPort = 7171
gameProtocolPort = 7172
statusProtocolPort = 7171
maxPlayers = 0

-- MySQL
mysqlHost = "144.xx.xxx.xx"
mysqlUser = "xxx"
mysqlPass = "xxxxxxxxxxx"
mysqlDatabase = "ots"
mysqlPort = 3306
mysqlSock = ""
passwordType = "sha1"

Im sure i added correctly data, because i can use it to login to phpmyadmin.
I dont know where problem is.

PS.
firewall on debian is disabled
Status: inactive

 

[samco]

Do you have a database called ots?

 

[Tibiaisfun]

you need to make a database and name it ots

 

[nurgiel]

have it.

 

[Tibiaisfun]

try this one put ur information when u restart

-- MySQL
mysqlHost = "144.xx.xxx.xx"
mysqlUser = "root"
mysqlPass = "xxxxxxxxxxx"
mysqlDatabase = "Ots"
mysqlPort = 3306
passwordType = "sha1"

 

[bayview]

I installed LAMP and php on VPS. compiled TFS, edited config.lua, but after i play server by screen command i get this msg.

>> Loading config
>> establishing database connection...
MySQL Error Message: Can't conntect to MySQL server on 'my server ip' (111)
> ERROR: Failed to connect to database
>> No services running. The server is NOT online

about config.lua

-- Connection Config
-- NOTE: maxPlayers set to 0 means no limit
ip = "144.xx.xxx.xx"
bindOnlyGlobalAddress = false
loginProtocolPort = 7171
gameProtocolPort = 7172
statusProtocolPort = 7171
maxPlayers = 0

-- MySQL
mysqlHost = "144.xx.xxx.xx"
mysqlUser = "xxx"
mysqlPass = "xxxxxxxxxxx"
mysqlDatabase = "ots"
mysqlPort = 3306
mysqlSock = ""
passwordType = "sha1"

Im sure i added correctly data, because i can use it to login to phpmyadmin.
I dont know where problem is.

PS.
firewall on debian is disabled
Status: inactive

Try using localhost or 127.0.0.1

ip = "127.0.0.1"
bindOnlyGlobalAddress = false

 

[nurgiel]

127.0.0.01 works, lol. Tutorials mistaked me with that.
Thx mate. If someone can answer me for few basic questions, because after back everything is new for me.

What version is TFS? That newest. Tried to find some file with info, credits etc.
Also i dont know TFS ver so i dont know what client i should use for the latest TFS ver.

 

[samco]

127.0.0.01 works, lol. Tutorials mistaked me with that.
Thx mate. If someone can answer me for few basic questions, because after back everything is new for me.

What version is TFS? That newest. Tried to find some file with info, credits etc.
Also i dont know TFS ver so i dont know what client i should use for the latest TFS ver.

The latests stable release is 1.2. The latest version in development is 1.3

You can get those versions from the official github of TFS. About the version, i think they are up to 10.98 but i cant really tell.

 

[nurgiel]

Yeah i done that, but i dont see info in gifgub, albo in downloaded server files about version of server and for what client is.
For newbies is not transparent to start

 

[samco]

Yeah i done that, but i dont see info in gifgub, albo in downloaded server files about version of server and for what client is.
For newbies is not transparent to start

That's because you dont have a specific client version. TFS have compatibility to multiple clients versions

 

[nurgiel]

checked ver that u recommend and 10.98 works! I thought now i can finally login to server, but when i picked created character (so connection to server and database works if i see my characters in list) i get
"failed to establish connection to the server".
but maybe i will just close this topic and created another, because topic is about mysql problem.
thx everyone for help in this issue!