TFS 1.X+ VPS debian 8 - tibia client error - failed to establish connection to the server

[nurgiel]

Hi.
I can login to account and i see my characters list in tibia client so i quess there is no problem with config.lua, and database is installed properly.
"failed to establish connection to the server".
My account maker is myaac-0.7.10
I using the latest TFS ver. Tibia client 10.98
I checked listening port on VPS, and looks everything ok (right?)

Proto Recv-Q Send-Q Local Address           Foreign Address         State       PID/Program name
tcp        0      0 127.0.0.1:3306          0.0.0.0:*               LISTEN      684/mysqld
tcp        0      0 0.0.0.0:80              0.0.0.0:*               LISTEN      685/apache2
tcp        0      0 0.0.0.0:22              0.0.0.0:*               LISTEN      246/sshd
tcp        0      0 0.0.0.0:25              0.0.0.0:*               LISTEN      946/master
tcp        0      0 0.0.0.0:7171            0.0.0.0:*               LISTEN      1011/tfs
tcp        0      0 0.0.0.0:7172            0.0.0.0:*               LISTEN      1011/tfs
tcp6       0      0 :::22                   :::*                    LISTEN      246/sshd
tcp6       0      0 :::25                   :::*                    LISTEN      946/master
[code]
I dont have idea where is a problem

 

[samco]

Hi.
I can login to account and i see my characters list in tibia client so i quess there is no problem with config.lua, and database is installed properly.
"failed to establish connection to the server".
My account maker is myaac-0.7.10
I using the latest TFS ver. Tibia client 10.98
I checked listening port on VPS, and looks everything ok (right?)

Proto Recv-Q Send-Q Local Address           Foreign Address         State       PID/Program name
tcp        0      0 127.0.0.1:3306          0.0.0.0:*               LISTEN      684/mysqld
tcp        0      0 0.0.0.0:80              0.0.0.0:*               LISTEN      685/apache2
tcp        0      0 0.0.0.0:22              0.0.0.0:*               LISTEN      246/sshd
tcp        0      0 0.0.0.0:25              0.0.0.0:*               LISTEN      946/master
tcp        0      0 0.0.0.0:7171            0.0.0.0:*               LISTEN      1011/tfs
tcp        0      0 0.0.0.0:7172            0.0.0.0:*               LISTEN      1011/tfs
tcp6       0      0 :::22                   :::*                    LISTEN      246/sshd
tcp6       0      0 :::25                   :::*                    LISTEN      946/master
[code]
I dont have idea where is a problem

try this web with your VPS ip and ports 7171 7172
Open Port Check Tool - Test Port Forwarding on Your Router

 

[nurgiel]

7171,7172 are open. 3306 was closed. i removed bind-address 127.0.0.1 from /etc/mysql/my.cnf
now 3306 is open. I restarted machine and nothing changed. still cant login to character

 

[samco]

you dont really need 3306 to be open to the public, as you are connecting to your local database on the same machine.

Not sure now whats going on. What ip are you trying to use to connect to your ot?

 

[nurgiel]

(link deleted)

 

[nurgiel]

i reuploaded TFS again using 1.2 version, like also database. nothing changed.

 

[nurgiel]

Och, solution was totally ridiculous.
in "connection config" must be added IP of machine. Its funny, because in mysqhost need have 127.0.0.1. Totally crazy, when one line works and 2nd not.
Maybe this will help other in future. Oh jesus

 

[samco]

Och, solution was totally ridiculous.
in "connection config" must be added IP of machine. Its funny, because in mysqhost need have 127.0.0.1. Totally crazy, when one line works and 2nd not.
Maybe this will help other in future. Oh jesus

well one is telling the IP where the sorver is being hosted. The other one is the IP where the servers needs to connect. They dont need to be in the same computer tho.

 

[nurgiel]

yeah, but if files are on machine, and 127.0.0.1 or localhost works on mysql, that should work with server. Its strange when IP adress of machine doesnt work when is written i mysql adress connection.
Small differences doing so huge problems.