TFS 1.X+ Server does not open tls/ssl problem

[2057623]

Hey guys, I have a Baiak Thunger 1.3x server, I compiled the source code and everything is ok. When I try to open it, it won't open. This appears

> Loading configurations
> Establishing connection to the database...

MySQL Error Message: TLS/SSL error: SSL is required, but the server does not support it

ERROR: Failed to connect to database.

This is the first time I've been messing with otserv and I see something with SSL. I use Xampp 3.3.0 PHP 8.1. I installed the normal Myacc site. I went to open the server and it won't open. It looks like this. In config.lua, it's already configured correctly.

mysqlHost = "localhost"
mysqlUser = "root"
mysqlPass = ""
mysqlDatabase = "otserv"
mysqlPort = 3306
mysqlSock = ""
passwordType = "sha1"
sqlType = "mysql"

I have already tried changing the mysqlhost to 127.0.0.1 but without any success. If anyone can help me out, please let me know.

 

[2057623]

someone please help me

 

[sharinn]

you are using custom server... as far as i know tfs is not using tls/ssl for db connection

 

[n3crozzy]

Disable SSL requirement in MySQL:
Open the my.cnf or my.ini file.
Add the following under the [mysqld] section:

require_secure_transport = OFF

Save and restart MySQL.
Disable SSL in config.lua:

mysqlHost = "localhost"
mysqlUser = "root"
mysqlPass = ""
mysqlDatabase = "otserv"
mysqlPort = 3306
mysqlSock = ""
passwordType = "sha1"
sqlType = "mysql"

Add the line:

mysqlFlags = "CLIENT_SSL=0"

Restart the server and check the connection.

Test the connection directly from the terminal:

mysql -u root -p --host=localhost --ssl-mode=DISABLED

If the connection succeeds, the issue is likely with the otserv configuration.

Let me know if it helped, I'm learning myself. We'll figure it out

 

[caetano157]

Disable SSL requirement in MySQL:
Open the my.cnf or my.ini file.
Add the following under the [mysqld] section:

require_secure_transport = OFF

Save and restart MySQL.
Disable SSL in config.lua:

mysqlHost = "localhost"
mysqlUser = "root"
mysqlPass = ""
mysqlDatabase = "otserv"
mysqlPort = 3306
mysqlSock = ""
passwordType = "sha1"
sqlType = "mysql"

Add the line:

mysqlFlags = "CLIENT_SSL=0"

Restart the server and check the connection.

Test the connection directly from the terminal:

mysql -u root -p --host=localhost --ssl-mode=DISABLED

If the connection succeeds, the issue is likely with the otserv configuration.

Let me know if it helped, I'm learning myself. We'll figure it out

i having same problem, i tried to use this solution but dind't worked, ssl certificate already off but still having a mysql connection error.

 

[pewpew]

i having same problem, i tried to use this solution but dind't worked, ssl certificate already off but still having a mysql connection error.

View attachment 87940

u found any solution? I have the same problem

 

[diegoknight95]

same here

 

[chucky91]

Hey guys, I have a Baiak Thunger 1.3x server, I compiled the source code and everything is ok. When I try to open it, it won't open. This appears


MySQL Error Message: TLS/SSL error: SSL is required, but the server does not support it


This is the first time I've been messing with otserv and I see something with SSL. I use Xampp 3.3.0 PHP 8.1. I installed the normal Myacc site. I went to open the server and it won't open. It looks like this. In config.lua, it's already configured correctly.

mysqlHost = "localhost"
mysqlUser = "root"
mysqlPass = ""
mysqlDatabase = "otserv"
mysqlPort = 3306
mysqlSock = ""
passwordType = "sha1"
sqlType = "mysql"

I have already tried changing the mysqlhost to 127.0.0.1 but without any success. If anyone can help me out, please let me know.

Add more mysql_options for new version +3.5.x libmariadb from vcpkg.
It seems like they enabled it without specifying the ssl setting.
That's really annoying. security standards maybe.

In database.cpp, bool Database::connect()
after

mysql_options(handle, MYSQL_OPT_RECONNECT, &reconnect);

add

my_bool ssl_enforce = 0;
my_bool ssl_verify = 0;
unsigned int ssl_mode = 0;
mysql_options(handle, MYSQL_OPT_SSL_ENFORCE, &ssl_enforce);
mysql_options(handle, MYSQL_OPT_SSL_VERIFY_SERVER_CERT, &ssl_verify);
mysql_options(handle, MYSQL_OPT_SSL_ENFORCE, &ssl_mode);
mysql_ssl_set(handle, nullptr, nullptr, nullptr, nullptr, nullptr);

 

[Gesior.pl]

Add more mysql_options for new version +3.5.x libmariadb from vcpkg.
It seems like they enabled it without specifying the ssl setting.
That's really annoying. security standards maybe.

In database.cpp, bool Database::connect()
after

mysql_options(handle, MYSQL_OPT_RECONNECT, &reconnect);

add

my_bool ssl_enforce = 0;
my_bool ssl_verify = 0;
unsigned int ssl_mode = 0;
mysql_options(handle, MYSQL_OPT_SSL_ENFORCE, &ssl_enforce);
mysql_options(handle, MYSQL_OPT_SSL_VERIFY_SERVER_CERT, &ssl_verify);
mysql_options(handle, MYSQL_OPT_SSL_ENFORCE, &ssl_mode);
mysql_ssl_set(handle, nullptr, nullptr, nullptr, nullptr, nullptr);

TFS 1.6+ has the same problem on Linux Ubuntu, if you compile engine using vcpkg.
To fix it, above this line:

forgottenserver/src/database.cpp at e80e40875f305b34ac496deb443c58090afa9069 · otland/forgottenserver

A free and open-source MMORPG server emulator written in C++ - otland/forgottenserver

github.com

add:

    bool ssl_enforce = false;
    bool ssl_verify = false;

and above this if:

forgottenserver/src/database.cpp at e80e40875f305b34ac496deb443c58090afa9069 · otland/forgottenserver

A free and open-source MMORPG server emulator written in C++ - otland/forgottenserver

github.com

add:

    mysql_options(handle.get(), MYSQL_OPT_SSL_ENFORCE, &ssl_enforce);
    mysql_options(handle.get(), MYSQL_OPT_SSL_VERIFY_SERVER_CERT, &ssl_verify);
    mysql_ssl_set(handle.get(), nullptr, nullptr, nullptr, nullptr, nullptr);

EDIT:
I will test if it works fine on Windows and make PR.

 

[Error 502]

Remove the SSL connection verification · opentibiabr/canary@77f2f71

Canary Server 14.x for OpenTibia community. . Contribute to opentibiabr/canary development by creating an account on GitHub.

github.com