Solved database connection issue

[Steven92]

Using UniServer Zero XV, ZNote ACC, and TFS 1.2, trying to run a private server but at "establishing database connection", the window just closes.

I did a command prompt and found out that it was:

>> Establishing database connection...
MySQL Error Message: Authentication plugin 'caching_sha2_password' cannot be loaded: The specified module could not be found.


> ERROR: Failed to connect to database.
>> No services running. The server is NOT online.

some of my config.php from www folder:

// Path to server folder without "\" (or "/") at the end, ex: C:\Users\Username\Documents\GitHub\forgottenserver
    $config['server_path'] = 'C:\StevarooServer3';


    // ------------------------ \\
    // MYSQL CONNECTION DETAILS \\
    // ------------------------ \\


    // phpmyadmin username for OT server: (DONT USE "root" if you are hosting to public).
    $config['sqlUser'] = 'root';


    // phpmyadmin password for OT server:
    $config['sqlPassword'] = 'root';


    // The database name to connect to. (This is usually same as username).
    $config['sqlDatabase'] = 'tfsog';


    // Hostname is usually localhost or 127.0.0.1.
    $config['sqlHost'] = 'localhost';

some of my config.lua from TFS:

-- MySQL
mysqlHost = "localhost"
mysqlUser = "root"
mysqlPass = "root"
mysqlDatabase = "tfsog"
mysqlPort = 3306
mysqlSock = ""
--passwordType = "sha1"

Any help is greatly appreciated!

EDIT -- Started looking around more and found this fix to the issue, although it is not tibia related. Running in windows, I just did the fix in the PHPmyadmin SQL prompt and it worked!

 

[BruhMan21]

What exactly did you type into the SQL prompt? I believe I am suffering from the same issue

 

[highsanta]

What exactly did you type into the SQL prompt? I believe I am suffering from the same issue

Click the link. Most important is to press cancel anytime u run uniserver to not change the mysql pass as it will reset all privileges and access

 

[Roan Holler]

Usando UniServer Zero XV, ZNote ACC y TFS 1.2, intento ejecutar un servidor privado, pero en "establecer conexión a la base de datos", la ventana simplemente se cierra.

Hice un símbolo del sistema y descubrí que era:

[CÓDIGO]>> Estableciendo conexión a la base de datos...
Mensaje de error de MySQL: No se puede cargar el complemento de autenticación 'caching_sha2_password': no se pudo encontrar el módulo especificado.

ERROR: Error al conectar a la base de datos.

No hay servicios en ejecución. El servidor NO está en línea.[/CODE]

Algunos de mis config.php de la carpeta www:

// Ruta a la carpeta del servidor sin "\" (o "/") al final, ej: C:\Users\Username\Documents\GitHub\forgottenserver
    $config['ruta_del_servidor'] = 'C:\StevarooServer3';


    // ------------------------ \\
    // DETALLES DE LA CONEXIÓN MYSQL \\
    // ------------------------ \\


    // Nombre de usuario phpmyadmin para el servidor OT: (NO USE "root" si está alojando en público).
    $config['sqlUser'] = 'raíz';


    // Contraseña de phpmyadmin para el servidor OT:
    $config['sqlPassword'] = 'raíz';


    // El nombre de la base de datos a la que conectarse. (Suele ser el mismo que el nombre de usuario).
    $config['sqlDatabase'] = 'tfsog';


    // El nombre de host normalmente es localhost o 127.0.0.1.
    $config['sqlHost'] = 'localhost';[/CÓDIGO]

Algunos de mis config.lua de TFS:

[CÓDIGO=lua]-- MySQL
mysqlHost = "host local"
mysqlUser = "raíz"
mysqlPass = "raíz"
base de datos mysql = "tfsog"
puertomysql = 3306
mysqlSock = ""
--passwordType = "sha1"[/CÓDIGO]

¡Cualquier ayuda será muy apreciada!

EDITAR: comencé a buscar más y encontré [URL='https://chrisshennan.com/blog/fixing-authentication-plugin-cachingsha2password-cannot-be-loaded-errors']esta[/URL] solución al problema, aunque no está relacionado con Tibia. Al ejecutarlo en Windows, simplemente realicé la corrección en el símbolo del sistema SQL de PHPmyadmin y funcionó.
[/QUOTE]
No entendí donde hay que hacer las modificaciones alguien con el mismo error?

Post automatically merged: Sep 19, 2024

yoroblema pero no se donde hacer los cambios

 

[murphy]

TARTING
Nostalrius - Version 3.0
Compiled with Microsoft Visual C++ version 14.3
Compiled on Jul 1 2024 20:32:59 for platform x64

A server developed by Alejandro Mujica
Visit our forum for updates, support, and resources: OTLand (http://otland.net/).
Re-edited by Roberto Carlos Preguica, GitHub Project: GitHub - RCP91/TibiaCore (https://github.com/RCP91/TibiaCore)

> Loading config
> Establishing database connection...

MySQL Error Message: Plugin caching_sha2_password could not be loaded: NÒo foi possÝvel encontrar o m¾dulo especificado. Library path is 'caching_sha2_password.dll'

ERROR: Failed to connect to database.
> No services running. The server is NOT online.

:: Restarting...

 

[El Bringy]

TARTING
Nostalrius - Version 3.0
Compiled with Microsoft Visual C++ version 14.3
Compiled on Jul 1 2024 20:32:59 for platform x64

A server developed by Alejandro Mujica
Visit our forum for updates, support, and resources: OTLand (http://otland.net/).
Re-edited by Roberto Carlos Preguica, GitHub Project: GitHub - RCP91/TibiaCore (https://github.com/RCP91/TibiaCore)


MySQL Error Message: Plugin caching_sha2_password could not be loaded: NÒo foi possÝvel encontrar o m¾dulo especificado. Library path is 'caching_sha2_password.dll'

:: Restarting...

Why passwordType="sha1" is commented in config.lua ?