worldserver.exe No se conecta a MySQL

[MurderPatrol]

 

[Sargero]

View attachment 3565

Revisa si el puerto, usuario, contrase;a o nombre de la db estan bien en el .conf del worldserver.

 

[MurderPatrol]

Hola todas las claves de usuarios en SQLyoj están definidas en "trinity eh visto que me así viene en el archivo del emulador.

Tengo instalado:
MySQL Workbench 8.xxx (me da un error la ventana se cierra sin mensaje solo desaparece )

XAMPP CONTROL PANEL 3.3.0

SQLYOJ (Con éste puedo conectar a la base de datos)

--------------------------------------------------------------------------------------------------------------------------------------------------------

Server (bloc de notas) :
TrinityCore rev. 3306a4d06cc5+ 2022-09-05 18:22:39 +0200 (3.3.5 branch) (Win64, Release, Static) (worldserver-daemon)
<Ctrl-C> to stop.

Repack Wrath of the Lich King. Compilado GRATIS para WoWCreador.com

______ __
/\__ _\ __ __/\ \__
\/_/\ \/ _ __ /\_\ ___ /\_\ \, _\ __ __
\ \ \/\`'__\/\ \ /' _ `\/\ \ \ \/ /\ \/\ \
\ \ \ \ \/ \ \ \/\ \/\ \ \ \ \ \_\ \ \_\ \
\ \_\ \_\ \ \_\ \_\ \_\ \_\ \__\\/`____ \
\/_/\/_/ \/_/\/_/\/_/\/_/\/__/ `/___/> \
C O R E /\___/
http://trinitycore.org \/__/

WoWCreador

Comunidad MMO definitiva. Explora información, tutoriales y soporte para diversos juegos, con World of Warcraft como foco principal. Únete para potenciar tu experiencia de juego con una comunidad apasionada.

wowcreador.com

Using configuration file C:/Users/Proyecto SD/Downloads/Trinity/worldserver.conf.
Using SSL version: OpenSSL 1.1.1m 14 Dec 2021 (library: OpenSSL 1.1.1m 14 Dec 2021)
Using Boost version: 1.78.0

DatabasePool Login NOT opened. There were errors opening the MySQL connections. Check your SQLDriverLogFile for specific errors. Read wiki at http://www.trinitycore.info/display/tc/TrinityCore+Home

-----------------------------------------------------------------------------------------------------------------------------------------------------------

Auth ( Bloc de Notas):

TrinityCore rev. 3306a4d06cc5+ 2022-09-05 18:22:39 +0200 (3.3.5 branch) (Win64, Release, Static) (authserver)
<Ctrl-C> to stop.

Repack Wrath of the Lich King. Compilado GRATIS para WoWCreador.com

______ __
/\__ _\ __ __/\ \__
\/_/\ \/ _ __ /\_\ ___ /\_\ \, _\ __ __
\ \ \/\`'__\/\ \ /' _ `\/\ \ \ \/ /\ \/\ \
\ \ \ \ \/ \ \ \/\ \/\ \ \ \ \ \_\ \ \_\ \
\ \_\ \_\ \ \_\ \_\ \_\ \_\ \__\\/`____ \
\/_/\/_/ \/_/\/_/\/_/\/_/\/__/ `/___/> \
C O R E /\___/
http://trinitycore.org \/__/

WoWCreador

Comunidad MMO definitiva. Explora información, tutoriales y soporte para diversos juegos, con World of Warcraft como foco principal. Únete para potenciar tu experiencia de juego con una comunidad apasionada.

wowcreador.com

Using configuration file C:/Users/Proyecto SD/Downloads/Trinity/authserver.conf.
Using SSL version: OpenSSL 1.1.1m 14 Dec 2021 (library: OpenSSL 1.1.1m 14 Dec 2021)
Using Boost version: 1.78.0
Automatic database updates are disabled for all databases!
Opening DatabasePool 'auth'. Asynchronous connections: 1, synchronous connections: 1.
MySQL client library: 8.0.28
MySQL server ver: 5.5.5-10.4.24-MariaDB
Connected to MySQL database at 127.0.0.1
TrinityCore does not support MySQL versions below 5.7 (found id 50505, need id >= 50700), please update your MySQL server

DatabasePool Login NOT opened. There were errors opening the MySQL connections. Check your SQLDriverLogFile for specific errors. Read wiki at http://www.trinitycore.info/display/tc/TrinityCore+Home

--------------------------------------------------------------------------------------------------------------------------------------------------------

DBErrors ( bloc de notas) :


Could not connect to MySQL database at 127.0.0.1: Access denied for user 'root'@'localhost' (using password: YES)
Could not connect to MySQL database at 127.0.0.1: Access denied for user 'root'@'localhost' (using password: YES)

 

[Elperro]

Estás usando MySQL de Apache?? Quizá sea eso, intenta detener ese servicio en apache.

 

[MurderPatrol]

Como inicio la base de datos, sin el Xampp?

 

[Syrus]

Hola todas las claves de usuarios en SQLyoj están definidas en "trinity eh visto que me así viene en el archivo del emulador.

Tengo instalado:
MySQL Workbench 8.xxx (me da un error la ventana se cierra sin mensaje solo desaparece )

XAMPP CONTROL PANEL 3.3.0

SQLYOJ (Con éste puedo conectar a la base de datos)

View attachment 3566

View attachment 3567


View attachment 3568

--------------------------------------------------------------------------------------------------------------------------------------------------------

Server (bloc de notas) :
TrinityCore rev. 3306a4d06cc5+ 2022-09-05 18:22:39 +0200 (3.3.5 branch) (Win64, Release, Static) (worldserver-daemon)
<Ctrl-C> to stop.

Repack Wrath of the Lich King. Compilado GRATIS para WoWCreador.com

______ __
/\__ _\ __ __/\ \__
\/_/\ \/ _ __ /\_\ ___ /\_\ \, _\ __ __
\ \ \/\`'__\/\ \ /' _ `\/\ \ \ \/ /\ \/\ \
\ \ \ \ \/ \ \ \/\ \/\ \ \ \ \ \_\ \ \_\ \
\ \_\ \_\ \ \_\ \_\ \_\ \_\ \__\\/`____ \
\/_/\/_/ \/_/\/_/\/_/\/_/\/__/ `/___/> \
C O R E /\___/
http://trinitycore.org \/__/

WoWCreador

Comunidad MMO definitiva. Explora información, tutoriales y soporte para diversos juegos, con World of Warcraft como foco principal. Únete para potenciar tu experiencia de juego con una comunidad apasionada.

wowcreador.com

Using configuration file C:/Users/Proyecto SD/Downloads/Trinity/worldserver.conf.
Using SSL version: OpenSSL 1.1.1m 14 Dec 2021 (library: OpenSSL 1.1.1m 14 Dec 2021)
Using Boost version: 1.78.0

DatabasePool Login NOT opened. There were errors opening the MySQL connections. Check your SQLDriverLogFile for specific errors. Read wiki at http://www.trinitycore.info/display/tc/TrinityCore+Home

-----------------------------------------------------------------------------------------------------------------------------------------------------------

Auth ( Bloc de Notas):

TrinityCore rev. 3306a4d06cc5+ 2022-09-05 18:22:39 +0200 (3.3.5 branch) (Win64, Release, Static) (authserver)
<Ctrl-C> to stop.

Repack Wrath of the Lich King. Compilado GRATIS para WoWCreador.com

______ __
/\__ _\ __ __/\ \__
\/_/\ \/ _ __ /\_\ ___ /\_\ \, _\ __ __
\ \ \/\`'__\/\ \ /' _ `\/\ \ \ \/ /\ \/\ \
\ \ \ \ \/ \ \ \/\ \/\ \ \ \ \ \_\ \ \_\ \
\ \_\ \_\ \ \_\ \_\ \_\ \_\ \__\\/`____ \
\/_/\/_/ \/_/\/_/\/_/\/_/\/__/ `/___/> \
C O R E /\___/
http://trinitycore.org \/__/

WoWCreador

Comunidad MMO definitiva. Explora información, tutoriales y soporte para diversos juegos, con World of Warcraft como foco principal. Únete para potenciar tu experiencia de juego con una comunidad apasionada.

wowcreador.com

Using configuration file C:/Users/Proyecto SD/Downloads/Trinity/authserver.conf.
Using SSL version: OpenSSL 1.1.1m 14 Dec 2021 (library: OpenSSL 1.1.1m 14 Dec 2021)
Using Boost version: 1.78.0
Automatic database updates are disabled for all databases!
Opening DatabasePool 'auth'. Asynchronous connections: 1, synchronous connections: 1.
MySQL client library: 8.0.28
MySQL server ver: 5.5.5-10.4.24-MariaDB
Connected to MySQL database at 127.0.0.1
TrinityCore does not support MySQL versions below 5.7 (found id 50505, need id >= 50700), please update your MySQL server

DatabasePool Login NOT opened. There were errors opening the MySQL connections. Check your SQLDriverLogFile for specific errors. Read wiki at http://www.trinitycore.info/display/tc/TrinityCore+Home

--------------------------------------------------------------------------------------------------------------------------------------------------------

DBErrors ( bloc de notas) :


Could not connect to MySQL database at 127.0.0.1: Access denied for user 'root'@'localhost' (using password: YES)
Could not connect to MySQL database at 127.0.0.1: Access denied for user 'root'@'localhost' (using password: YES)

Primero señalar esto:
"TrinityCore does not support MySQL versions below 5.7 (found id 50505, need id >= 50700), please update your MySQL server".

Eso significa que la versión de MySQL que usa tu versión de XAMPP está por debajo de la versión 5.7, específicamente tienes la 50505 (v5.5) y es necesario la versión 50700 (v5.7) o mayor. Es decir debes o descargar una versión más actualizada de XAMPP o descargar la v5.7 o mayor del servicio de MySQL e instalarlo de forma independiente.

Además también señalar esto:
"Could not connect to MySQL database at 127.0.0.1: Access denied for user 'root'@'localhost' (using password: YES)".

Revisa en tu carpeta del servidor el "worldserver.conf " que tengas los credenciales (usuario y contraseña) y el puerto correcto, estos datos anteriores debes modificarlos a tus credenciales de MySQL, si lo tienes por default como lo instala XAMPP sería algo así:

user: root
password: (sin contraseña)
port: 3306

 

[MurderPatrol]

Primero señalar esto:
"TrinityCore does not support MySQL versions below 5.7 (found id 50505, need id >= 50700), please update your MySQL server".

Eso significa que la versión de MySQL que usa tu versión de XAMPP está por debajo de la versión 5.7, específicamente tienes la 50505 (v5.5) y es necesario la versión 50700 (v5.7) o mayor. Es decir debes o descargar una versión más actualizada de XAMPP o descargar la v5.7 o mayor del servicio de MySQL e instalarlo de forma independiente.

Además también señalar esto:
"Could not connect to MySQL database at 127.0.0.1: Access denied for user 'root'@'localhost' (using password: YES)".

Revisa en tu carpeta del servidor el "worldserver.conf " que tengas los credenciales (usuario y contraseña) y el puerto correcto, estos datos anteriores debes modificarlos a tus credenciales de MySQL, si lo tienes por default como lo instala XAMPP sería algo así:

user: root
password: (sin contraseña)
port: 3306

Hola el buscado mucho ese sevicio pero encuentro muchas applicaciones de MySql tengo Server2019, MySql Workbench 8.0, podrías especificarme la descarga que necesito?

 

[Syrus]

Hola el buscado mucho ese sevicio pero encuentro muchas applicaciones de MySql tengo Server2019, MySql Workbench 8.0, podrías especificarme la descarga que necesito?

Acá el link oficial, puedes descargar la versión que prefieras pero recuerda 5.7 o superior... Cuando vayas a instalarlo si le pones que inicio el servicio automático recuerda primero detener el servicio del XAMPP ya que si no lo haces te dará conflicto y no iniciará porque el puerto ya está en uso.

 

[MurderPatrol]

Acá el link oficial, puedes descargar la versión que prefieras pero recuerda 5.7 o superior... Cuando vayas a instalarlo si le pones que inicio el servicio automático recuerda primero detener el servicio del XAMPP ya que entonces te dará conflicto y no iniciará porque el puerto ya está en uso.

Hola Instale MySql server, Shell, y Workbench, me sigue dando un error.

AUTH :

Opening DatabasePool 'auth'. Asynchronous connections: 1, synchronous connections: 1.
Could not connect to MySQL database at 127.0.0.1: Unknown database 'auth'

DatabasePool Login NOT opened. There were errors opening the MySQL connections. Check your SQLDriverLogFile for specific errors. Read wiki at http://www.trinitycore.info/display/tc/TrinityCore+Home

worldserver :


Using configuration file C:/Users/Proyecto SD/Downloads/Trinity/worldserver.conf.
Using SSL version: OpenSSL 1.1.1m 14 Dec 2021 (library: OpenSSL 1.1.1m 14 Dec 2021)
Using Boost version: 1.78.0

DatabasePool Login NOT opened. There were errors opening the MySQL connections. Check your SQLDriverLogFile for specific errors. Read wiki at http://www.trinitycore.info/display/tc/TrinityCore+Home

 

[Syrus]

Hola Instale MySql server, Shell, y Workbench, me sigue dando un error.

AUTH :

Opening DatabasePool 'auth'. Asynchronous connections: 1, synchronous connections: 1.
Could not connect to MySQL database at 127.0.0.1: Unknown database 'auth'

DatabasePool Login NOT opened. There were errors opening the MySQL connections. Check your SQLDriverLogFile for specific errors. Read wiki at http://www.trinitycore.info/display/tc/TrinityCore+Home

worldserver :


Using configuration file C:/Users/Proyecto SD/Downloads/Trinity/worldserver.conf.
Using SSL version: OpenSSL 1.1.1m 14 Dec 2021 (library: OpenSSL 1.1.1m 14 Dec 2021)
Using Boost version: 1.78.0

DatabasePool Login NOT opened. There were errors opening the MySQL connections. Check your SQLDriverLogFile for specific errors. Read wiki at http://www.trinitycore.info/display/tc/TrinityCore+Home

Si puedes pon una foto del worldserver.conf a ver como te quedó, y el authserver.conf ya le configuraste también usuario, contraseña y puerto al igual que al worlserver.conf?

 

[MurderPatrol]

# MYSQL SETTINGS
#
# LoginDatabaseInfo
# Description: Database connection settings for the realm server.
# Example: "hostname;port;username;password;database;ssl"
# ".;some_number;username;password;database" - (Use named pipes on Windows
# "enable-named-pipe" to [mysqld]
# section my.ini)
# ".;/path/to/unix_socket;username;password;database" - (use Unix sockets on
# Unix/Linux)
# Default: "127.0.0.1;3306;trinity;trinity;auth"
#
# The SSL option will enable TLS when connecting to the specified database. If not provided or
# any value other than 'ssl' is set, TLS will not be used.

LoginDatabaseInfo = "127.0.0.1;3306;root;trinity;auth"


C:\Users\Proyecto SD\Downloads\Trinity>authserver.exe
TrinityCore rev. 3306a4d06cc5+ 2022-09-05 18:22:39 +0200 (3.3.5 branch) (Win64, Release, Static) (authserver)
<Ctrl-C> to stop.

Repack Wrath of the Lich King. Compilado GRATIS para WoWCreador.com

______ __
/\__ _\ __ __/\ \__
\/_/\ \/ _ __ /\_\ ___ /\_\ \, _\ __ __
\ \ \/\`'__\/\ \ /' _ `\/\ \ \ \/ /\ \/\ \
\ \ \ \ \/ \ \ \/\ \/\ \ \ \ \ \_\ \ \_\ \
\ \_\ \_\ \ \_\ \_\ \_\ \_\ \__\\/`____ \
\/_/\/_/ \/_/\/_/\/_/\/_/\/__/ `/___/> \
C O R E /\___/
http://trinitycore.org \/__/

WoWCreador

Comunidad MMO definitiva. Explora información, tutoriales y soporte para diversos juegos, con World of Warcraft como foco principal. Únete para potenciar tu experiencia de juego con una comunidad apasionada.

wowcreador.com

Using configuration file C:/Users/Proyecto SD/Downloads/Trinity/authserver.conf.
Using SSL version: OpenSSL 1.1.1m 14 Dec 2021 (library: OpenSSL 1.1.1m 14 Dec 2021)
Using Boost version: 1.78.0
Automatic database updates are disabled for all databases!
Opening DatabasePool 'auth'. Asynchronous connections: 1, synchronous connections: 1.
MySQL client library: 8.0.28
MySQL server ver: 8.0.30
Connected to MySQL database at 127.0.0.1
MySQL client library: 8.0.28
MySQL server ver: 8.0.30
Connected to MySQL database at 127.0.0.1
DatabasePool 'auth' opened successfully. 2 total connections running.
In mysql_stmt_prepare() id: 1, sql: "DELETE FROM ip_banned WHERE unbandate<>bandate AND unbandate<=UNIX_TIMESTAMP()"
Table 'auth.ip_banned' doesn't exist
In mysql_stmt_prepare() id: 2, sql: "UPDATE account_banned SET active = 0 WHERE active = 1 AND unbandate<>bandate AND unbandate<=UNIX_TIMESTAMP()"
Table 'auth.account_banned' doesn't exist
In mysql_stmt_prepare() id: 3, sql: "SELECT unbandate > UNIX_TIMESTAMP() OR unbandate = bandate AS banned, NULL as country FROM ip_banned WHERE ip = ?"
Table 'auth.ip_banned' doesn't exist
In mysql_stmt_prepare() id: 4, sql: "INSERT INTO ip_banned (ip, bandate, unbandate, bannedby, banreason) VALUES (?, UNIX_TIMESTAMP(), UNIX_TIMESTAMP()+?, 'Trinity Auth', 'Failed login autoban')"
Table 'auth.ip_banned' doesn't exist
In mysql_stmt_prepare() id: 8, sql: "INSERT INTO account_banned (id, bandate, unbandate, bannedby, banreason, active) VALUES (?, UNIX_TIMESTAMP(), UNIX_TIMESTAMP()+?, 'Trinity Auth', 'Failed login autoban', 1)"
Table 'auth.account_banned' doesn't exist
In mysql_stmt_prepare() id: 9, sql: "DELETE FROM account_banned WHERE id = ?"
Table 'auth.account_banned' doesn't exist
In mysql_stmt_prepare() id: 10, sql: "UPDATE account SET salt = ?, verifier = ? WHERE id = ?"
Table 'auth.account' doesn't exist
In mysql_stmt_prepare() id: 12, sql: "SELECT a.id, a.username, a.locked, a.lock_country, a.last_ip, a.failed_logins, ab.unbandate > UNIX_TIMESTAMP() OR ab.unbandate = ab.bandate, ab.unbandate = ab.bandate, aa.SecurityLevel, a.totp_secret, a.salt, a.verifier FROM account a LEFT JOIN account_access aa ON a.id = aa.AccountID LEFT JOIN account_banned ab ON ab.id = a.id AND ab.active = 1 WHERE a.username = ?"
Table 'auth.account' doesn't exist
In mysql_stmt_prepare() id: 13, sql: "SELECT a.id, UPPER(a.username), a.locked, a.lock_country, a.last_ip, a.failed_logins, ab.unbandate > UNIX_TIMESTAMP() OR ab.unbandate = ab.bandate, ab.unbandate = ab.bandate, aa.SecurityLevel, a.session_key_auth FROM account a LEFT JOIN account_access aa ON a.id = aa.AccountID LEFT JOIN account_banned ab ON ab.id = a.id AND ab.active = 1 WHERE a.username = ? AND a.session_key_auth IS NOT NULL"
Table 'auth.account' doesn't exist
In mysql_stmt_prepare() id: 14, sql: "UPDATE account SET failed_logins = failed_logins + 1 WHERE username = ?"
Table 'auth.account' doesn't exist
In mysql_stmt_prepare() id: 17, sql: "SELECT a.id, a.session_key_auth, a.last_ip, a.locked, a.lock_country, a.expansion, a.mutetime, a.locale, a.recruiter, a.os, aa.SecurityLevel, ab.unbandate > UNIX_TIMESTAMP() OR ab.unbandate = ab.bandate, r.id FROM account a LEFT JOIN account_access aa ON a.id = aa.AccountID AND aa.RealmID IN (-1, ?) LEFT JOIN account_banned ab ON a.id = ab.id AND ab.active = 1 LEFT JOIN account r ON a.id = r.recruiter WHERE a.username = ? AND a.session_key_auth IS NOT NULL ORDER BY aa.RealmID DESC LIMIT 1"
Table 'auth.account' doesn't exist
In mysql_stmt_prepare() id: 19, sql: "SELECT realmid, numchars FROM realmcharacters WHERE acctid = ?"
Table 'auth.realmcharacters' doesn't exist
In mysql_stmt_prepare() id: 21, sql: "INSERT INTO ip_banned (ip, bandate, unbandate, bannedby, banreason) VALUES (?, UNIX_TIMESTAMP(), UNIX_TIMESTAMP()+?, ?, ?)"
Table 'auth.ip_banned' doesn't exist
In mysql_stmt_prepare() id: 22, sql: "DELETE FROM ip_banned WHERE ip = ?"
Table 'auth.ip_banned' doesn't exist
In mysql_stmt_prepare() id: 26, sql: "INSERT INTO account_banned (id, bandate, unbandate, bannedby, banreason, active) VALUES (?, UNIX_TIMESTAMP(), UNIX_TIMESTAMP()+?, ?, ?, 1)"
Table 'auth.account_banned' doesn't exist
In mysql_stmt_prepare() id: 27, sql: "UPDATE account_banned SET active = 0 WHERE id = ? AND active != 0"
Table 'auth.account_banned' doesn't exist
In mysql_stmt_prepare() id: 28, sql: "DELETE FROM realmcharacters WHERE acctid = ?"
Table 'auth.realmcharacters' doesn't exist
In mysql_stmt_prepare() id: 29, sql: "REPLACE INTO realmcharacters (numchars, acctid, realmid) VALUES (?, ?, ?)"
Table 'auth.realmcharacters' doesn't exist
In mysql_stmt_prepare() id: 30, sql: "SELECT SUM(numchars) FROM realmcharacters WHERE acctid = ?"
Table 'auth.realmcharacters' doesn't exist
In mysql_stmt_prepare() id: 32, sql: "INSERT INTO realmcharacters (realmid, acctid, numchars) SELECT realmlist.id, account.id, 0 FROM realmlist, account LEFT JOIN realmcharacters ON acctid = account.id WHERE acctid IS NULL"
Table 'auth.realmcharacters' doesn't exist
In mysql_stmt_prepare() id: 33, sql: "UPDATE account SET expansion = ? WHERE id = ?"
Table 'auth.account' doesn't exist
In mysql_stmt_prepare() id: 34, sql: "UPDATE account SET locked = ? WHERE id = ?"
Table 'auth.account' doesn't exist
In mysql_stmt_prepare() id: 35, sql: "UPDATE account SET lock_country = ? WHERE id = ?"
Table 'auth.account' doesn't exist
In mysql_stmt_prepare() id: 36, sql: "INSERT INTO logs (time, realm, type, level, string) VALUES (?, ?, ?, ?, ?)"
Table 'auth.logs' doesn't exist
In mysql_stmt_prepare() id: 37, sql: "UPDATE account SET username = ? WHERE id = ?"
Table 'auth.account' doesn't exist
In mysql_stmt_prepare() id: 38, sql: "UPDATE account SET email = ? WHERE id = ?"
Table 'auth.account' doesn't exist
In mysql_stmt_prepare() id: 39, sql: "UPDATE account SET reg_mail = ? WHERE id = ?"
Table 'auth.account' doesn't exist
In mysql_stmt_prepare() id: 40, sql: "UPDATE account SET mutetime = ? , mutereason = ? , muteby = ? WHERE id = ?"
Table 'auth.account' doesn't exist
In mysql_stmt_prepare() id: 41, sql: "UPDATE account SET mutetime = ? WHERE id = ?"
Table 'auth.account' doesn't exist
In mysql_stmt_prepare() id: 42, sql: "UPDATE account SET last_ip = ? WHERE username = ?"
Table 'auth.account' doesn't exist
In mysql_stmt_prepare() id: 43, sql: "UPDATE account SET last_attempt_ip = ? WHERE username = ?"
Table 'auth.account' doesn't exist
In mysql_stmt_prepare() id: 44, sql: "UPDATE account SET online = 1 WHERE id = ?"
Table 'auth.account' doesn't exist
In mysql_stmt_prepare() id: 45, sql: "UPDATE uptime SET uptime = ?, maxplayers = ? WHERE realmid = ? AND starttime = ?"
Table 'auth.uptime' doesn't exist
In mysql_stmt_prepare() id: 46, sql: "DELETE FROM logs WHERE (time + ?) < ? AND realm = ?"
Table 'auth.logs' doesn't exist
In mysql_stmt_prepare() id: 47, sql: "DELETE FROM account_access WHERE AccountID = ?"
Table 'auth.account_access' doesn't exist
In mysql_stmt_prepare() id: 48, sql: "DELETE FROM account_access WHERE AccountID = ? AND (RealmID = ? OR RealmID = -1)"
Table 'auth.account_access' doesn't exist
In mysql_stmt_prepare() id: 49, sql: "INSERT INTO account_access (AccountID, SecurityLevel, RealmID) VALUES (?, ?, ?)"
Table 'auth.account_access' doesn't exist
In mysql_stmt_prepare() id: 51, sql: "SELECT SecurityLevel FROM account_access WHERE AccountID = ? AND (RealmID = ? OR RealmID = -1) ORDER BY RealmID DESC"
Table 'auth.account_access' doesn't exist
In mysql_stmt_prepare() id: 63, sql: "DELETE FROM account WHERE id = ?"
Table 'auth.account' doesn't exist
In mysql_stmt_prepare() id: 68, sql: "INSERT INTO logs_ip_actions (account_id, character_guid, realm_id, type, ip, systemnote, unixtime, time) VALUES (?, ?, ?, ?, (SELECT last_ip FROM account WHERE id = ?), ?, unix_timestamp(NOW()), NOW())"
Table 'auth.logs_ip_actions' doesn't exist
In mysql_stmt_prepare() id: 69, sql: "INSERT INTO logs_ip_actions (account_id, character_guid, realm_id, type, ip, systemnote, unixtime, time) VALUES (?, ?, ?, ?, (SELECT last_attempt_ip FROM account WHERE id = ?), ?, unix_timestamp(NOW()), NOW())"
Table 'auth.logs_ip_actions' doesn't exist
In mysql_stmt_prepare() id: 70, sql: "INSERT INTO logs_ip_actions (account_id, character_guid, realm_id, type, ip, systemnote, unixtime, time) VALUES (?, ?, ?, ?, ?, ?, unix_timestamp(NOW()), NOW())"
Table 'auth.logs_ip_actions' doesn't exist
In mysql_stmt_prepare() id: 71, sql: "INSERT INTO logs_ip_actions (account_id, character_guid, realm_id, type, ip, systemnote, unixtime, time) VALUES (?, 0, 0, 1, ?, ?, unix_timestamp(NOW()), NOW())"
Table 'auth.logs_ip_actions' doesn't exist
In mysql_stmt_prepare() id: 73, sql: "SELECT permissionId, granted FROM rbac_account_permissions WHERE accountId = ? AND (realmId = ? OR realmId = -1) ORDER BY permissionId, realmId"
Table 'auth.rbac_account_permissions' doesn't exist
In mysql_stmt_prepare() id: 74, sql: "INSERT INTO rbac_account_permissions (accountId, permissionId, granted, realmId) VALUES (?, ?, ?, ?) ON DUPLICATE KEY UPDATE granted = VALUES(granted)"
Table 'auth.rbac_account_permissions' doesn't exist
In mysql_stmt_prepare() id: 75, sql: "DELETE FROM rbac_account_permissions WHERE accountId = ? AND permissionId = ? AND (realmId = ? OR realmId = -1)"
Table 'auth.rbac_account_permissions' doesn't exist
In mysql_stmt_prepare() id: 76, sql: "INSERT INTO account_muted VALUES (?, UNIX_TIMESTAMP(), ?, ?, ?)"
Table 'auth.account_muted' doesn't exist
In mysql_stmt_prepare() id: 78, sql: "DELETE FROM account_muted WHERE guid = ?"
Table 'auth.account_muted' doesn't exist
In mysql_stmt_prepare() id: 80, sql: "INSERT INTO secret_digest (id, digest) VALUES (?,?)"
Table 'auth.secret_digest' doesn't exist
In mysql_stmt_prepare() id: 81, sql: "DELETE FROM secret_digest WHERE id = ?"
Table 'auth.secret_digest' doesn't exist
In mysql_stmt_prepare() id: 83, sql: "UPDATE account SET totp_secret = ? WHERE id = ?"
Table 'auth.account' doesn't exist
Closing down DatabasePool 'auth'.
Asynchronous connections on DatabasePool 'auth' terminated. Proceeding with synchronous connections.
All connections on DatabasePool 'auth' closed.
Could not prepare statements of the Login database, see log for details.
Closing down DatabasePool 'auth'.
Asynchronous connections on DatabasePool 'auth' terminated. Proceeding with synchronous connections.
All connections on DatabasePool 'auth' closed.

C:\Users\Proyecto SD\Downloads\Trinity>

Revisa si el puerto, usuario, contrase;a o nombre de la db estan bien en el .conf del worldserver.

LogsDir = ""

#
# LoginDatabaseInfo
# WorldDatabaseInfo
# CharacterDatabaseInfo
# Description: Database connection settings for the world server.
# Example: "hostname;port;username;password;database;ssl"
# ".;some_number;username;password;database" - (Use named pipes on Windows
# "enable-named-pipe" to [mysqld]
# section my.ini)
# ".;/path/to/unix_socket;username;password;database" - (use Unix sockets on
# Unix/Linux)
# Default: "127.0.0.1;3306;trinity;trinity;auth" - (LoginDatabaseInfo)
# "127.0.0.1;3306;trinity;trinity;world" - (WorldDatabaseInfo)
# "127.0.0.1;3306;trinity;trinity;characters" - (CharacterDatabaseInfo)
#
# Don't change hostname unless you are hosting MySQL on a different machine, if you need help
# with configuration allowing to connect from different machine than the one running server
# search for TCE00016 on forum.
# Don't open port on firewall to external connections (it belongs to MySQL, not to wow server).
# The username you choose must have permissions to create/alter/rename tables.
# The SSL option will enable TLS when connecting to the specified database. If not provided or
# any value other than 'ssl' is set, TLS will not be used.

LoginDatabaseInfo = "127.0.0.1;3306;root;trinity;auth"
WorldDatabaseInfo = "127.0.0.1;3306;root;trinity;world"
CharacterDatabaseInfo = "127.0.0.1;3306;root;trinity;characters"

 

[MurderPatrol]

Ya no se que hacer eh instalado de todo, por favor ayuda. Parecia sencillo el post de WowCreador .

 

[Syrus]

Ya no se que hacer eh instalado de todo, por favor ayuda. Parecia sencillo el post de WowCreador .

En esos logs que pones ahí ya se conectó a las bases de datos pero no encuentra las tablas correspondientes para aplicar los cambios. Antes de abrir el authserver.exe y el worldserver.exe debe crear las base de datos (que veo en los logs que ya están creadas) pero...

1- Esas base de datos que creaste (auth, world, characters) están vacías, se usan para importar entonces los SQLs de esas mismas bases de datos pero que contienen la estructura y la información base del servidor.

2- Debes buscar en lo que descargaste algo llamado TDB seguido de unos números, vi en el post del repack de acá de wowcreador que ya esta actualizado a TDB335.22081, pero no se si sea el repack que estas usando, si lo trae ya incluido o debes bajarlo en un link aparte ya que nunca lo he puesto.

3- Luego de que descargues (o si ya tienes las base de datos) entonces las importas en las que ya creaste y entonces ya no deberían salirte esos errores que mostraste ahora.

PD: Acabo de ver que hay un video explicativo, lo que te digo arriba es este paso.

 

[MurderPatrol]

En esos logs que pones ahí ya se conectó a las bases de datos pero no encuentra las tablas correspondientes para aplicar los cambios. Antes de abrir el authserver.exe y el worldserver.exe debe crear las base de datos (que veo en los logs que ya están creadas) pero...

1- Esas base de datos que creaste (auth, world, characters) están vacías, se usan para importar entonces los SQLs de esas mismas bases de datos pero que contienen la estructura y la información base del servidor.

2- Debes buscar en lo que descargaste algo llamado TDB seguido de unos números, vi en el post del repack de acá de wowcreador que ya esta actualizado a TDB335.22081, pero no se si sea el repack que estas usando, si lo trae ya incluido o debes bajarlo en un link aparte ya que nunca lo he puesto.

3- Luego de que descargues (o si ya tienes las base de datos) entonces las importas en las que ya creaste y entonces ya no deberían salirte esos errores que mostraste ahora.

PD: Acabo de ver que hay un video explicativo, lo que te digo arriba es este paso.

Lo tenia armado en SQLyoj, ahora eso pasa en MySql y no entiendo MySql porque no hay guia y es otro procedimiento, con el script de world, porque pesa.

 

[MurderPatrol]

Eh conseguido que inicie el servidor. Muchas gracias por sus aportes