Couldn't estabilish connection to SQL database!

[waqmaz]

Hello.
While I want to connect to my OTS using xampp (localhost), everything works well with these parameters:

    sqlType = "mysql"
    sqlHost = "localhost"
    sqlPort = 3306
    sqlUser = "root"
    sqlPass = ""
    sqlDatabase = "ots"
    encryptionType = "sha1"

I've decided to buy a test server for my database on http://www.linuxpl.com and the OTServer throws an error: "Couldn't estabilish connection to SQL database!" while it has parameters:

    sqlType = "mysql"
    sqlHost = "213.239.198.234"
    sqlPort = 3306
    sqlUser = "john"
    sqlPass = "lol123"
    sqlDatabase = "john_db"
    encryptionType = "sha1"

Everything is okay, but it still does not work. I don't have mind for it. What am I doing wrong? Ofcourse, I've uploaded schema/mysql.sql to database (phpmyadmin). Should works well, but is not.
Please, help me.

 

[Evil Hero]

checked if the sql port is open or tried another one?

 

[Codex NG]

Try using the absolute path for the sqlDatabase.

 

[waqmaz]

All ports are opened.

 

[waqmaz]

Try using the absolute path for the sqlDatabase.

Ok, thanks, I am going to try.
Does not work.

 

[Evil Hero]

3306 is open so don't worry

sqlHost = "213.239.198.234"

change it to

sqlHost = 213.239.198.234

not sure if a direct ip is read as a string or not, so this might work

 

[waqmaz]

3306 is open so don't worry

sqlHost = "213.239.198.234"

change it to

sqlHost = 213.239.198.234

not sure if a direct ip is read as a string or not, so this might work

Without ' " ' it says: "unable to load config.lua".

 

[Evil Hero]

hmm havn't tried to use another sql host then localhost so far, let me look a bit through sources, so I might get a clue on what it could be.

 

[waqmaz]

bump

 

[waqmaz]

I've allowed IP address on external database host and still cannot connect to database.

 

[knighters god]

You could try changing your

sqlHost = "213.239.198.234"

To

sqlHost = "127.0.0.1"

Or

sqlHost = "localhost"

EDIT:
Nevermind. I did not read that you bought a server. Whoopsie

 

[waqmaz]

knighters gods Are you crazy? I host it on external database. There is not localhost, lol.

 

[waqmaz]

I have opened all ports, I have allowed my IP address on external database host, I have created tables in database from schema folder. I have put this to config.lua:

    sqlType = "mysql"
    sqlHost = "213.239.198.234" -- external database
    sqlPort = 3306
    sqlUser = "lidia92_ots"
    sqlPass = "mypass"
    sqlDatabase = "lidia92_ots"

WHAT IS THE BEST, SERVER THROWS AN ERROR, USING "LOCALHOST" LOL:

[18/05/2016 18:11:47] Failed connecting to database - MYSQL ERROR: Access denied for user 'lidia92_ots'@'localhost' (using password: TAK) (1045)

[18/05/2016 18:11:47] > ERROR: Couldn't estabilish connection to SQL database!

I've tried with 2 diffrent computers and 2 diffrent modems and diffrent databases. Everywhere the problem looks the same.

 

[waqmaz]

bump
If here is someone who started his Open Tibia Server on external database and can help?
just wondering, maybe its because of encryptionType = "sha1"? but i dont think so

 

[lunara]

Hello.
While I want to connect to my OTS using xampp (localhost), everything works well with these parameters:

    sqlType = "mysql"
    sqlHost = "localhost"
    sqlPort = 3306
    sqlUser = "root"
    sqlPass = ""
    sqlDatabase = "ots"
    encryptionType = "sha1"

I've decided to buy a test server for my database on http://www.linuxpl.com and the OTServer throws an error: "Couldn't estabilish connection to SQL database!" while it has parameters:

    sqlType = "mysql"
    sqlHost = "213.239.198.234"
    sqlPort = 3306
    sqlUser = "john"
    sqlPass = "lol123"
    sqlDatabase = "john_db"
    encryptionType = "sha1"

Everything is okay, but it still does not work. I don't have mind for it. What am I doing wrong? Ofcourse, I've uploaded schema/mysql.sql to database (phpmyadmin). Should works well, but is not.
Please, help me.

Hey man I also got the same problems.
Would you like to help me?

 

[waqmaz]

Hey man I also got the same problems.
Would you like to help me?

It is because of the host type. Linuxpl.com isn't for games. It is for www sites. That is why it doesn't work. i bought minthost.pl and works perfectly, but i've got debian. had to install ubuntu 14. now everything works very well on a screen using ubuntu.
I was the biggest dumb ever trying to start an OTS using webhosting, I was like lollolololololler, lol. 11 years of programming here, but have never had a server XD