Problem with TLS/SSL error when starting server

[atom114]

Hey. I got a problem when i try to start server i get :
">> Establishing database connection...
MySQL Error Message: TLS/SSL error: SSL is required, but the server does not support it

ERROR: Failed to connect to database."

Im using Nekiro 8.0 downgrade, and Xampp phpmyadmin MySql as database. Anyone may have a clue, how to disable it?

 

[Demoncrawler]

Usually you turn that off in config.lua there is a line that is called sha1 and you change that. But I have no clue if that works for your specific server.

 

[Gesior.pl]

Hey. I got a problem when i try to start server i get :
">> Establishing database connection...
MySQL Error Message: TLS/SSL error: SSL is required, but the server does not support it


Im using Nekiro 8.0 downgrade, and Xampp phpmyadmin MySql as database. Anyone may have a clue, how to disable it?

IDK how you compiled it, but it looks like your C++ MySQL library requires SSL by default and your database configuration in XAMPP does not support it.

Someone else reported the same problem - XAMPP + running TFS 1.3 on Windows (Nekiro 1.5 is based on TFS 1.3):

2

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

Oct 4, 2024

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...

• 2057623
• Replies: 12
• Forum: Support

 

[atom114]

It's strange because i downloaded another datapack of 8.0 that come with compiled .exe and it works fine ( i dont know why it not require key.pem) but when i compile from vc17 -> theforgottenserver.sln it's (im using visual 2022) and try to use .exe first is asking for config.lua, then for key.pem and then i get same error even with same config. I was using Xampp for apache and mysql, now i will try with normal mysql.

Post automatically merged: Jan 30, 2025

So i have change all to normal MySql db, now i geting other error
"

> Establishing database connection...

MySQL Error Message: Plugin caching_sha2_password could not be loaded: Nie mo┐na odnalečŠ okreťlonego modu│u. Library path is 'caching_sha2_password.dll'

ERROR: Failed to connect to database."

 

[Error 502]

MySQL Error Message: Plugin caching_sha2_password could not be loaded: Nie mo┐na odnalečŠ okreťlonego modu│u. Library path is 'caching_sha2_password.dll'

ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'MYPASSWORD';

 

[Glaszcz Koldre]

Had the same issue with Nekiro 1.5 using latest xampp instalation with mariadb.

In database.cpp i had to change:

// automatic reconnect
  bool reconnect = true;
  mysql_options(handle, MYSQL_OPT_RECONNECT, &reconnect);

into

  // automatic reconnect
  bool reconnect = true;
  mysql_options(handle, MYSQL_OPT_RECONNECT, &reconnect);

  // Disable SSL/TLS - required for XAMPP's MariaDB which doesn't have SSL
  // configured. MariaDB Connector/C 3.4+ enforces TLS by default. Disable for local development.
  my_bool ssl_enforce = 0;
  my_bool ssl_verify = 0;
  mysql_options(handle, MYSQL_OPT_SSL_ENFORCE, &ssl_enforce);
  mysql_options(handle, MYSQL_OPT_SSL_VERIFY_SERVER_CERT, &ssl_verify);

Im also using vcpkg.json for package managment, in which I had to get libmariadb without defaults.

        {
            "name": "libmariadb",
            "default-features": false,
            "features": [
                "iconv"
            ]
        },

 

[Terotrificy]

Had the same issue with Nekiro 1.5 using latest xampp instalation with mariadb.

In database.cpp i had to change:

// automatic reconnect
  bool reconnect = true;
  mysql_options(handle, MYSQL_OPT_RECONNECT, &reconnect);

into

  // automatic reconnect
  bool reconnect = true;
  mysql_options(handle, MYSQL_OPT_RECONNECT, &reconnect);

  // Disable SSL/TLS - required for XAMPP's MariaDB which doesn't have SSL
  // configured. MariaDB Connector/C 3.4+ enforces TLS by default. Disable for local development.
  my_bool ssl_enforce = 0;
  my_bool ssl_verify = 0;
  mysql_options(handle, MYSQL_OPT_SSL_ENFORCE, &ssl_enforce);
  mysql_options(handle, MYSQL_OPT_SSL_VERIFY_SERVER_CERT, &ssl_verify);

Im also using vcpkg.json for package managment, in which I had to get libmariadb without defaults.

        {
            "name": "libmariadb",
            "default-features": false,
            "features": [
                "iconv"
            ]
        },

Its related to the mariadb or mysql server version installed in your machine.
There is no need to change sources, just install the correct mariadb server and client.