You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
Failed to create a test server along with primary server.
Steps:
Copy both Azerothcore and Azeroth-Server folders, renamed to test folders.
Added to MySQL:
CREATE DATABASE acore_test_world DEFAULT CHARACTER SET UTF8MB4 COLLATE utf8mb4_general_ci;
CREATE DATABASE acore_test_characters DEFAULT CHARACTER SET UTF8MB4 COLLATE utf8mb4_general_ci;
GRANT ALL PRIVILEGES ON acore_test_world . * TO 'acore'@'localhost' WITH GRANT OPTION;
GRANT ALL PRIVILEGES ON acore_test_characters . * TO 'acore'@'localhost' WITH GRANT OPTION;
Added row in realmlist using dbeaver:
(2, Test, x.x.x.x, 192.168.x.x, 255.255.255.0, 4042, 4, 64, 1, 0, 0, 12340)
Run sudo /home/arthas/azeroth-server/bin/authserver
two servers now shown in realmlist
Run sudo /home/arthas/azeroth-server/bin/worldserver
primary server runs fine
Run sudo /home/arthas/test-azeroth-server/bin/worldserver
appears to run fine until reaching "WORLD: World Initialized In 0 Minutes 10 Seconds", afterwards it displays the following:
StartNetwork failed to bind socket acceptor
Failed to initialize network
Closing down DatabasePool 'acore_characters'.
Asynchronous connections on DatabasePool 'acore_characters' terminated. Proceeding with synchronous connections.
All connections on DatabasePool 'acore_characters' closed.
Closing down DatabasePool 'acore_world'.
Asynchronous connections on DatabasePool 'acore_world' terminated. Proceeding with synchronous connections.
All connections on DatabasePool 'acore_world' closed.
Closing down DatabasePool 'acore_auth'.
Asynchronous connections on DatabasePool 'acore_auth' terminated. Proceeding with synchronous connections.
All connections on DatabasePool 'acore_auth' closed.
The error message hint it's not using the correct mysql databases. I made futile changes in the worldserver.conf on any entries that seem related, but remain oblivious to how this works.
Server Debug Info
Ubuntu 22.04.4 LTS
AzerothCore rev. b78f83c6ecbc 2024-02-26 20:02:02 +0700 (master branch) (Unix, RelWithDebInfo, Static)
Connected players: 0. Characters in world: 0.
Connection peak: 0.
Server uptime: 37 minute(s) 43 second(s)
Update time diff: 2ms. Last 500 diffs summary:
Mean: 1ms
Median: 1ms
Percentiles (95, 99, max): 6ms, 6ms, 7ms
Using SSL version: OpenSSL 3.0.2 15 Mar 2022 (library: OpenSSL 3.0.2 15 Mar 2022)
Using Boost version: 1.74.0
Using CMake version: 3.22.1
Using MySQL version: 100616
Found MySQL Executable: /usr/bin/mysql
Compiled on: Linux 5.15.0-97-generic
Worldserver listening connections on port 4042
Realmlist (Realm Id: 1) configured in port 4042
VMAPs status: Enabled. LineOfSight: 1, getHeight: 1, indoorCheck: 1
MMAPs status: Enabled
maps directory located in /home/arthas/azeroth-server/data/maps. Total size: 291014951 bytes
vmaps directory located in /home/arthas/azeroth-server/data/vmaps. Total size: 658130721 bytes
mmaps directory located in /home/arthas/azeroth-server/data/mmaps. Total size: 2192910844 bytes
Default DBC locale: enUS.
All available DBC locales: enUS
Using World DB: ACDB 335.11-dev
Latest LoginDatabase update: 2024_01_20_00.sql
Latest CharacterDatabase update: mod_solo_craft.sql
Latest WorldDatabase update: 2024_02_25_03.sql
LoginDatabase queue size: 0
CharacterDatabase queue size: 0
WorldDatabase queue size: 0
No modules enabled
reacted with thumbs up emoji reacted with thumbs down emoji reacted with laugh emoji reacted with hooray emoji reacted with confused emoji reacted with heart emoji reacted with rocket emoji reacted with eyes emoji
-
Failed to create a test server along with primary server.
Steps:
CREATE DATABASE
acore_test_world
DEFAULT CHARACTER SET UTF8MB4 COLLATE utf8mb4_general_ci;CREATE DATABASE
acore_test_characters
DEFAULT CHARACTER SET UTF8MB4 COLLATE utf8mb4_general_ci;GRANT ALL PRIVILEGES ON
acore_test_world
. * TO 'acore'@'localhost' WITH GRANT OPTION;GRANT ALL PRIVILEGES ON
acore_test_characters
. * TO 'acore'@'localhost' WITH GRANT OPTION;(2, Test, x.x.x.x, 192.168.x.x, 255.255.255.0, 4042, 4, 64, 1, 0, 0, 12340)
two servers now shown in realmlist
primary server runs fine
appears to run fine until reaching "WORLD: World Initialized In 0 Minutes 10 Seconds", afterwards it displays the following:
The error message hint it's not using the correct mysql databases. I made futile changes in the worldserver.conf on any entries that seem related, but remain oblivious to how this works.
Server Debug Info
Beta Was this translation helpful? Give feedback.
All reactions