search

diff3 / pandaria_5.4.8_docker

pandaria_5.4.8_docker
13 stars 5 forks source link

Mysql repo signing key expired, container will not build #2

Open Fijahh opened 7 months ago

Fijahh commented 7 months ago

The mysql repro signing pubkey used in the containers/compile, containers/authserver and containers/worldserver Dockerfiles expired at the end of 2023, and it keeps the container from building. Had to hand-edit this line in the files with the new pubkey fingerprint (B7B3B788A8D3785C) to fix it:

apt-key adv --keyserver keyserver.ubuntu.com --recv-keys B7B3B788A8D3785C && \

diff3 commented 7 months ago

I added it, thanks, but I need to switch to and older version of Pandaria git because it does not run at the moment.

Fijahh commented 7 months ago

I did notice that, yeah - I ran out of time to tinker with it further yesterday, I figured it was something I was doing wrong. :)

-Joost

'The difference between America and England is that the English think 100 miles is a long distance and the Americans think 100 years is a long time.' -- Unknown

On Tue, Apr 16, 2024 at 00:23 Magnus Pettersson @.***> wrote:

I added it, thanks, but I need to switch to and older version of Pandaria git because it does not run at the moment.

— Reply to this email directly, view it on GitHub https://github.com/diff3/pandaria_5.4.8_docker/issues/2#issuecomment-2058409779, or unsubscribe https://github.com/notifications/unsubscribe-auth/BH3FH3X4TZM6UQMYSSVKDJDY5TGY5AVCNFSM6AAAAABGICONOCVHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMZDANJYGQYDSNZXHE . You are receiving this because you authored the thread.Message ID: @.***>

diff3 commented 7 months ago

I added a way to compile branches, and it's on by default. So it does compile, but it's some strange bug so the server crashes after a few seconds after fully loaded.

Fijahh commented 7 months ago

I was getting error messages in the log stating the authserver start script could not be found as well as some sql server errors. I did see a variable ‘WOW_PATH’ invoked in the docker compose file that doesn’t appear to be declared anywhere. Is that something that has to be set outside of the docker environment? Sorry, I’m a relative newb when it comes to container environments.

-Joost

'The difference between America and England is that the English think 100 miles is a long distance and the Americans think 100 years is a long time.' -- Unknown

On Tue, Apr 16, 2024 at 12:23 Magnus Pettersson @.***> wrote:

I added a way to compile branches, and it's on by default. So it does compile, but it's some strange bug so the server crashes after a few seconds after fully loaded.

— Reply to this email directly, view it on GitHub https://github.com/diff3/pandaria_5.4.8_docker/issues/2#issuecomment-2059778880, or unsubscribe https://github.com/notifications/unsubscribe-auth/BH3FH3RPME2NVQ3FOMDM62TY5V3CXAVCNFSM6AAAAABGICONOCVHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMZDANJZG43TQOBYGA . You are receiving this because you authored the thread.Message ID: @.***>

diff3 commented 7 months ago

I have to error check it tomorrow then.

No worry, it's fun to learn =)

diff3 commented 7 months ago

got it working, just need some cleanup

Fijahh commented 5 months ago

Hi Magnus,

Had a busy few weeks so didn't have the chance to get back to this until yesterday. After a couple hours of fighting it I got further than previously but I still can't get the server up and running. Couple notes:

After setting the WOW_PATH variable to something random I was able to compile successfully. However when bringing the server up, after waiting for the database import to complete I started getting this on both auth and world servers (server banners removed for clarity):

pandaria-authserver | Using configuration file /opt/server/etc/authserver.conf. pandaria-authserver | OpenSSL 1.1.1w 11 Sep 2023 (Library: OpenSSL 1.1.1w 11 Sep 2023) pandaria-authserver | Opening DatabasePool 'auth'. Asynchronous connections: 1, synchronous connections: 1. pandariadb | 2024-05-24 2:14:42 3 [Warning] Access denied for user 'pandaria'@'192.168.192.3' (using password: YES) pandaria-authserver | Could not connect to MySQL database at pandariadb: Access denied for user 'pandaria'@'192.168.192.3' (using password: YES) pandaria-authserver | pandariadb | 2024-05-24 2:14:42 4 [Warning] Access denied for user 'pandaria'@'192.168.192.3' (using password: YES) pandaria-authserver | Could not connect to MySQL database at pandariadb: Access denied for user 'pandaria'@'192.168.192.3' (using password: YES) pandaria-authserver | pandaria-authserver | DatabasePool auth NOT opened. There were errors opening the MySQL connections. Check your SQLDriverLogFile for specific errors. pandaria-authserver | Cannot connect to database

I fired up phpmyadmin after fixing the typo in the dockerfile and had a look in the user records in the database, and it turns out that while the 'pandaria' user was created on the database it had no password set. So I gave it the password 'pandaria' manually as specified in the auth/worldserver conf files, and then the authserver started up correctly but on worldserver startup I started getting this:

pandariadb | 2024-05-24 2:20:49 47 [ERROR] mariadbd: Table './world/linked_respawn' is marked as crashed and should be repaired pandariadb | 2024-05-24 2:20:49 47 [Warning] Checking table: './world/linked_respawn' pandariadb | 2024-05-24 2:20:49 47 [ERROR] mariadbd: Table './world/gameobject' is marked as crashed and should be repaired pandariadb | 2024-05-24 2:20:49 47 [Warning] Checking table: './world/gameobject' pandariadb | 2024-05-24 2:20:49 47 [ERROR] mariadbd: Table './world/game_event_gameobject' is marked as crashed and should be repaired pandariadb | 2024-05-24 2:20:49 47 [Warning] Checking table: './world/game_event_gameobject' pandariadb | 2024-05-24 2:20:49 47 [ERROR] mariadbd: Table './world/game_graveyard_zone' is marked as crashed and should be repaired pandariadb | 2024-05-24 2:20:49 47 [Warning] Checking table: './world/game_graveyard_zone' pandariadb | 2024-05-24 2:20:49 47 [ERROR] mariadbd: Table './world/game_tele' is marked as crashed and should be repaired pandariadb | 2024-05-24 2:20:49 47 [Warning] Checking table: './world/game_tele' pandariadb | 2024-05-24 2:20:49 47 [ERROR] mariadbd: Table './world/creature' is marked as crashed and should be repaired pandariadb | 2024-05-24 2:20:49 47 [Warning] Checking table: './world/creature' pandariadb | 2024-05-24 2:20:49 47 [ERROR] mariadbd: Table './world/creature_template' is marked as crashed and should be repaired pandariadb | 2024-05-24 2:20:49 47 [Warning] Checking table: './world/creature_template' pandariadb | 2024-05-24 2:20:49 47 [ERROR] mariadbd: Table './world/creature_formations' is marked as crashed and should be repaired pandariadb | 2024-05-24 2:20:49 47 [Warning] Checking table: './world/creature_formations' pandariadb | 2024-05-24 2:20:49 47 [ERROR] mariadbd: Table './world/waypoint_data' is marked as crashed and should be repaired pandariadb | 2024-05-24 2:20:49 47 [Warning] Checking table: './world/waypoint_data' pandariadb | 2024-05-24 2:20:49 47 [ERROR] mariadbd: Table './world/creature_addon' is marked as crashed and should be repaired pandariadb | 2024-05-24 2:20:49 47 [Warning] Checking table: './world/creature_addon' pandariadb | 2024-05-24 2:20:49 47 [ERROR] mariadbd: Table './world/waypoint_scripts' is marked as crashed and should be repaired pandariadb | 2024-05-24 2:20:49 47 [Warning] Checking table: './world/waypoint_scripts' pandariadb | 2024-05-24 2:20:49 47 [ERROR] mariadbd: Table './world/game_event_creature' is marked as crashed and should be repaired pandariadb | 2024-05-24 2:20:49 47 [Warning] Checking table: './world/game_event_creature' pandariadb | 2024-05-24 2:20:49 47 [ERROR] mariadbd: Table './world/game_event_model_equip' is marked as crashed and should be repaired pandariadb | 2024-05-24 2:20:49 47 [Warning] Checking table: './world/game_event_model_equip' pandariadb | 2024-05-24 2:20:49 47 [ERROR] mariadbd: Table './world/disables' is marked as crashed and should be repaired pandariadb | 2024-05-24 2:20:49 47 [Warning] Checking table: './world/disables' pandariadb | 2024-05-24 2:20:49 48 [ERROR] mariadbd: Table './world/creature_text' is marked as crashed and should be repaired pandariadb | 2024-05-24 2:20:49 48 [Warning] Checking table: './world/creature_text' pandariadb | 2024-05-24 2:20:49 48 [ERROR] mariadbd: Table './world/smart_scripts' is marked as crashed and should be repaired pandariadb | 2024-05-24 2:20:49 48 [Warning] Checking table: './world/smart_scripts' pandariadb | 2024-05-24 2:20:49 48 [ERROR] mariadbd: Table './world/waypoints' is marked as crashed and should be repaired pandariadb | 2024-05-24 2:20:49 48 [Warning] Checking table: './world/waypoints' pandariadb | 2024-05-24 2:20:49 48 [ERROR] mariadbd: Table './world/command' is marked as crashed and should be repaired pandariadb | 2024-05-24 2:20:49 48 [Warning] Checking table: './world/command' pandariadb | 2024-05-24 2:20:49 48 [ERROR] mariadbd: Table './world/item_template' is marked as crashed and should be repaired pandariadb | 2024-05-24 2:20:49 48 [Warning] Checking table: './world/item_template' pandariadb | 2024-05-24 2:20:49 48 [ERROR] mariadbd: Table './world/player_xp_for_level' is marked as crashed and should be repaired pandariadb | 2024-05-24 2:20:49 48 [Warning] Checking table: './world/player_xp_for_level' pandariadb | 2024-05-24 2:20:49 48 [ERROR] mariadbd: Table './world/blackmarket_template' is marked as crashed and should be repaired pandariadb | 2024-05-24 2:20:49 48 [Warning] Checking table: './world/blackmarket_template' pandaria-worldserver | In mysql_stmt_prepare() id: 59, sql: "SELECT creatorGuid, giftCreatorGuid, count, duration, charges, flags, enchantments, randomPropertyId, reforgeID, iit.transmogrifyId, upgradeID, durability, playedTime, text, pet_species, pet_breed, pet_quality, pet_level, bag, slot, item, itemEntry FROM character_inventory ci JOIN item_instance ii ON ci.item = ii.guid LEFT JOIN item_instance_transmog iit ON ii.guid = iit.itemGuid WHERE ci.guid = ? ORDER BY bag, slot" pandaria-worldserver | Table 'characters.item_instance_transmog' doesn't exist pandaria-worldserver | In mysql_stmt_prepare() id: 112, sql: "INSERT INTO item_instance_transmog (itemGuid, transmogrifyId) VALUES (?, ?)" pandaria-worldserver | Table 'characters.item_instance_transmog' doesn't exist pandaria-worldserver | In mysql_stmt_prepare() id: 113, sql: "DELETE FROM item_instance_transmog WHERE itemGuid = ?" pandaria-worldserver | Table 'characters.item_instance_transmog' doesn't exist pandaria-worldserver | In mysql_stmt_prepare() id: 114, sql: "DELETE iit FROM item_instance_transmog iit LEFT JOIN item_instance ii ON iit.itemGuid = ii.guid WHERE ii.owner_guid = ?" pandaria-worldserver | Table 'characters.item_instance_transmog' doesn't exist pandaria-worldserver | In mysql_stmt_prepare() id: 84, sql: "SELECT creatorGuid, giftCreatorGuid, count, duration, charges, flags, enchantments, randomPropertyId, reforgeId, iit.transmogrifyId, upgradeID, durability, playedTime, text, pet_species, pet_breed, pet_quality, pet_level, item_guid, itemEntry, owner_guid FROM mail_items mi JOIN item_instance ii ON mi.item_guid = ii.guid LEFT JOIN item_instance_transmog iit ON ii.guid = iit.itemGuid WHERE mail_id = ?" pandaria-worldserver | Table 'characters.item_instance_transmog' doesn't exist pandaria-worldserver | In mysql_stmt_prepare() id: 85, sql: "SELECT creatorGuid, giftCreatorGuid, count, duration, charges, flags, enchantments, randomPropertyId, reforgeId, iit.transmogrifyId, upgradeID, durability, playedTime, text, pet_species, pet_breed, pet_quality, pet_level, ah.itemguid, itemEntry FROM auctionhouse ah JOIN item_instance ii ON ah.itemguid = ii.guid LEFT JOIN item_instance_transmog iit ON ii.guid = iit.itemGuid" pandaria-worldserver | Table 'characters.item_instance_transmog' doesn't exist pandaria-worldserver | In mysql_stmt_prepare() id: 84, sql: "SELECT creatorGuid, giftCreatorGuid, count, duration, charges, flags, enchantments, randomPropertyId, reforgeId, iit.transmogrifyId, upgradeID, durability, playedTime, text, pet_species, pet_breed, pet_quality, pet_level, item_guid, itemEntry, owner_guid FROM mail_items mi JOIN item_instance ii ON mi.item_guid = ii.guid LEFT JOIN item_instance_transmog iit ON ii.guid = iit.itemGuid WHERE mail_id = ?" pandaria-worldserver | Table 'characters.item_instance_transmog' doesn't exist pandaria-worldserver | In mysql_stmt_prepare() id: 85, sql: "SELECT creatorGuid, giftCreatorGuid, count, duration, charges, flags, enchantments, randomPropertyId, reforgeId, iit.transmogrifyId, upgradeID, durability, playedTime, text, pet_species, pet_breed, pet_quality, pet_level, ah.itemguid, itemEntry FROM auctionhouse ah JOIN item_instance ii ON ah.itemguid = ii.guid LEFT JOIN item_instance_transmog iit ON ii.guid = iit.itemGuid" pandaria-worldserver | Table 'characters.item_instance_transmog' doesn't exist pandaria-worldserver | DatabasePool characters NOT opened. There were errors opening the MySQL connections. Check your SQLDriverLogFile for specific errors. pandaria-worldserver | Cannot connect to Character database pandariadb;3306;pandaria;pandaria;characters pandariadb | 2024-05-24 2:20:49 50 [Warning] Aborted connection 50 to db: 'characters' user: 'pandaria' host: '192.168.192.5' (Got an error reading communication packets) pandariadb | 2024-05-24 2:20:49 51 [Warning] Aborted connection 51 to db: 'characters' user: 'pandaria' host: '192.168.192.5' (Got an error reading communication packets) pandariadb | 2024-05-24 2:20:49 47 [Warning] Aborted connection 47 to db: 'world' user: 'pandaria' host: '192.168.192.5' (Got an error reading communication packets) pandariadb | 2024-05-24 2:20:49 48 [Warning] Aborted connection 48 to db: 'world' user: 'pandaria' host: '192.168.192.5' (Got an error reading communication packets) pandariadb | 2024-05-24 2:20:49 49 [Warning] Aborted connection 49 to db: 'characters' user: 'pandaria' host: '192.168.192.5' (Got an error reading communication packets)

And that's where I'm stuck. It looks like the db import isn't happening cleanly but I have no idea how to fix that. Any suggestions would be greatly appreciated!

Thanks!