EQEmulator Forums - Akka's server repack suddenly not working anymore

EQEmulator Forums (https://www.eqemulator.org/forums/index.php)

- Support::Windows Servers (https://www.eqemulator.org/forums/forumdisplay.php?f=587)

- - Akka's server repack suddenly not working anymore (https://www.eqemulator.org/forums/showthread.php?t=41171)

Akka's server repack suddenly not working anymore

Hi, one week ago, i started a private everquest server using the "Akka's server repack", everything worked fine and i could join my server without any problem.
But yesterday, after deleting my server folder unintentionally ( oh joy ) I tried to recreate a fresh one using the same tool ( after of course deleting everything related to the old one, like maria db files perl etc ) But surprise, i keep getting an "error 1146" like this everytime i try to start the server :

[World Server] Loading server configuration..
[World Server] CURRENT_VERSION: 1.1.3
[World Server] Added loginserver 127.0.0.1:5998
[World Server] Added loginserver login.eqemulator.net:5998
[World Server] Connecting to MySQL...
[Status] Starting File Log 'logs/world_5736.log'
[World Server] Starting HTTP world service...
[World Server] Checking Database Conversions..
[MySQL Error] 1146: Table 'peq.character_corpses' doesn't exist
SHOW COLUMNS FROM `character_corpses` LIKE 'data'
[Update] No script update necessary...
[Info] For EQEmu Server management utilities - run eqemu_server.pl
[Update] Database not up to date with binaries... Automatically updating...
[Update] Issuing database backup first...
[Update] No script update necessary...
[Database] Performing database backup....

Todays Date: 02_26_2017
Operating System is: MSWin32
[db_dumper.pl] Database is peq
[db_dumper.pl] Backup Directory: backups
[db_dumper.pl] Compression SET
[db_dumper.pl] Directory currently exists... Adding files to it...
[db_dumper.pl] Backing up Database peq...
[db_dumper.pl] Command [mysqldump -uroot --host localhost --max_allowed_packet=512M --password="eqemu" peq > "backups\peq_02_26_2017.sql"]
[db_dumper.pl] Backup DONE... DB Backup File Size '226380869' (215.89 MiB)
[db_dumper.pl] ::: You have WinRAR installed as 64 Bit...
[db_dumper.pl] Compressing Database with WinRAR...
[db_dumper.pl] Command ["C:\Program Files\WinRAR\rar" a "backups\peq_02_26_2017.rar" "backups\peq_02_26_2017.sql" ]

RAR 5.11 Copyright (c) 1993-2014 Alexander Roshal 27 Aoû 2014
Version de démonstration Pour obtenir de l'aide, saisissez RAR -?

Version d'évaluation. Merci de vous enregistrer.

Création de l'archive backups\peq_02_26_2017.rar

Ajout de backups\peq_02_26_2017.sql OK
Terminé
[db_dumper.pl]
Deleting RAW .sql Dump...
[db_dumper.pl] Command [del "backups\peq_02_26_2017.sql" ]
[db_dumper.pl] Final file located: backups\peq_02_26_2017.rar
[Update] Updating database...
[Database] Retrieving latest database manifest...
[Copy] folder doesn't exist, creating 'db_update/'
[Download] Saved: (db_update/db_update_manifest.txt) from https://raw.githubusercontent.com/EQ...e_manifest.txt
[Database] Reading manifest...
[Database] has update: 9100 - '2016_08_27_object_display_name.sql'

[Database] Retrieving latest database manifest...
[Download] Saved: (db_update/db_update_manifest.txt) from https://raw.githubusercontent.com/EQ...e_manifest.txt
[Database] has update: 9100 - '2016_08_27_object_display_name.sql'

[Database] No updates need to be run...
[Database] Setting Database to Binary Version (9100) if not already...

[Update] Continuing bootup
[World Server] Loading variables..
[World Server] Loading zones..
[World Server] Clearing groups..
[MySQL Error] 1146: Table 'peq.group_leaders' doesn't exist
DELETE from group_leaders
Unable to clear group leaders: #1146: Table 'peq.group_leaders' doesn't exist
[MySQL Error] 1146: Table 'peq.group_id' doesn't exist
DELETE FROM `group_id`
[World Server] Clearing raids..
[MySQL Error] 1146: Table 'peq.raid_members' doesn't exist
delete from raid_members
Unable to clear raids: #1146: Table 'peq.raid_members' doesn't exist
[MySQL Error] 1146: Table 'peq.raid_details' doesn't exist
delete from raid_details
Unable to clear raid details: #1146: Table 'peq.raid_details' doesn't exist
[World Server] Clearing inventory snapshots..
[World Server] Loading items..
[World Server] Loading skill caps..
[World Server] Loading guilds..
[MySQL Error] 1146: Table 'peq.guilds' doesn't exist
SELECT id, name, leader, minstatus, motd, motd_setter,channel,url FROM guilds
[World Server] Loaded default rule set 'default'
[World Server] Loading EQ time of day..
[World Server] Loading launcher list..
[MySQL Error] 1146: Table 'peq.launcher_zones' doesn't exist
SELECT zone, port FROM launcher_zones WHERE launcher = 'peq'
[Error] EQLConfig::LoadSettings: #1146: Table 'peq.launcher_zones' doesn't exist
[MySQL Error] 1146: Table 'peq.launcher_zones' doesn't exist
SELECT zone, port FROM launcher_zones WHERE launcher = 'zone'
[Error] EQLConfig::LoadSettings: #1146: Table 'peq.launcher_zones' doesn't exist
[World Server] Reboot zone modes OFF
[MySQL Error] 1146: Table 'peq.character_corpses' doesn't exist
UPDATE `character_corpses` SET `is_buried` = 1 WHERE `is_buried` = 0 AND (UNIX_TIMESTAMP() - UNIX_TIMESTAMP(time_of_death)) > 43200 AND NOT time_of_death = 0
[World Server] Deleted -1 stale player corpses from database
[World Server] Loading adventures...
[MySQL Error] 1146: Table 'peq.character_data' doesn't exist
SELECT ch.name, ch.id, adv_stats.* FROM adventure_stats AS adv_stats LEFT JOIN `character_data` AS ch ON adv_stats.player_id = ch.id;
[World Server] Purging expired instances
[MySQL Error] 1146: Table 'peq.instance_list_player' doesn't exist
DELETE FROM instance_list_player WHERE id=16089
[MySQL Error] 1146: Table 'peq.character_corpses' doesn't exist
UPDATE `character_corpses` SET `is_buried` = 1, `instance_id` = 0 WHERE `instance_id` = 16089
[MySQL Error] 1146: Table 'peq.instance_list_player' doesn't exist
DELETE FROM instance_list_player WHERE id=16090
[MySQL Error] 1146: Table 'peq.character_corpses' doesn't exist
UPDATE `character_corpses` SET `is_buried` = 1, `instance_id` = 0 WHERE `instance_id` = 16090
[MySQL Error] 1146: Table 'peq.instance_list_player' doesn't exist
DELETE FROM instance_list_player WHERE id=16091
[MySQL Error] 1146: Table 'peq.character_corpses' doesn't exist
UPDATE `character_corpses` SET `is_buried` = 1, `instance_id` = 0 WHERE `instance_id` = 16091
[MySQL Error] 1146: Table 'peq.instance_list_player' doesn't exist
DELETE FROM instance_list_player WHERE id=16093
[MySQL Error] 1146: Table 'peq.character_corpses' doesn't exist
UPDATE `character_corpses` SET `is_buried` = 1, `instance_id` = 0 WHERE `instance_id` = 16093
[MySQL Error] 1146: Table 'peq.instance_list_player' doesn't exist
DELETE FROM instance_list_player WHERE id=16094
[MySQL Error] 1146: Table 'peq.character_corpses' doesn't exist
UPDATE `character_corpses` SET `is_buried` = 1, `instance_id` = 0 WHERE `instance_id` = 16094
[MySQL Error] 1146: Table 'peq.instance_list_player' doesn't exist
DELETE FROM instance_list_player WHERE id=16097
[MySQL Error] 1146: Table 'peq.character_corpses' doesn't exist
UPDATE `character_corpses` SET `is_buried` = 1, `instance_id` = 0 WHERE `instance_id` = 16097
[MySQL Error] 1146: Table 'peq.instance_list_player' doesn't exist
DELETE FROM instance_list_player WHERE id=16099
[MySQL Error] 1146: Table 'peq.character_corpses' doesn't exist
UPDATE `character_corpses` SET `is_buried` = 1, `instance_id` = 0 WHERE `instance_id` = 16099
[MySQL Error] 1146: Table 'peq.instance_list_player' doesn't exist
DELETE FROM instance_list_player WHERE id=16102
[MySQL Error] 1146: Table 'peq.character_corpses' doesn't exist
UPDATE `character_corpses` SET `is_buried` = 1, `instance_id` = 0 WHERE `instance_id` = 16102
[MySQL Error] 1146: Table 'peq.instance_list_player' doesn't exist
DELETE FROM instance_list_player WHERE id=16124
[MySQL Error] 1146: Table 'peq.character_corpses' doesn't exist
UPDATE `character_corpses` SET `is_buried` = 1, `instance_id` = 0 WHERE `instance_id` = 16124
[MySQL Error] 1146: Table 'peq.instance_list_player' doesn't exist
DELETE FROM instance_list_player WHERE id=16127
[MySQL Error] 1146: Table 'peq.character_corpses' doesn't exist
UPDATE `character_corpses` SET `is_buried` = 1, `instance_id` = 0 WHERE `instance_id` = 16127
[MySQL Error] 1146: Table 'peq.instance_list_player' doesn't exist
DELETE FROM instance_list_player WHERE id=16129
[MySQL Error] 1146: Table 'peq.character_corpses' doesn't exist
UPDATE `character_corpses` SET `is_buried` = 1, `instance_id` = 0 WHERE `instance_id` = 16129
[MySQL Error] 1146: Table 'peq.instance_list_player' doesn't exist
DELETE FROM instance_list_player WHERE id=16130
[MySQL Error] 1146: Table 'peq.character_corpses' doesn't exist
UPDATE `character_corpses` SET `is_buried` = 1, `instance_id` = 0 WHERE `instance_id` = 16130
[MySQL Error] 1146: Table 'peq.instance_list_player' doesn't exist
DELETE FROM instance_list_player WHERE id=16131
[MySQL Error] 1146: Table 'peq.character_corpses' doesn't exist
UPDATE `character_corpses` SET `is_buried` = 1, `instance_id` = 0 WHERE `instance_id` = 16131
[MySQL Error] 1146: Table 'peq.instance_list_player' doesn't exist
DELETE FROM instance_list_player WHERE id=16132
[MySQL Error] 1146: Table 'peq.character_corpses' doesn't exist
UPDATE `character_corpses` SET `is_buried` = 1, `instance_id` = 0 WHERE `instance_id` = 16132
[MySQL Error] 1146: Table 'peq.instance_list_player' doesn't exist
DELETE FROM instance_list_player WHERE id=16133
[MySQL Error] 1146: Table 'peq.character_corpses' doesn't exist
UPDATE `character_corpses` SET `is_buried` = 1, `instance_id` = 0 WHERE `instance_id` = 16133
[World Server] Loading char create info...
[World Server] Zone (TCP) listener started.
[World Server] Client (UDP) listener started.
[World Server] New Zone Server from 127.0.0.1:53491
[World Server] New Zone Server from 127.0.0.1:53492
[World Server] New Zone Server from 127.0.0.1:53493
[World Server] New Zone Server from 127.0.0.1:53494
[World Server] New Zone Server from 127.0.0.1:53495
[World Server] New Zone Server from 127.0.0.1:53496
[World Server] New Zone Server from 127.0.0.1:53497
[World Server] New Zone Server from 127.0.0.1:53498
[World Server] New Zone Server from 127.0.0.1:53499
[World Server] New Zone Server from 127.0.0.1:53500
[World Server] New Zone Server from 127.0.0.1:53501
[World Server] New Zone Server from 127.0.0.1:53503
[World Server] New Zone Server from 127.0.0.1:53504
[World Server] New Zone Server from 127.0.0.1:53505
[World Server] New Zone Server from 127.0.0.1:53506
[World Server] New Zone Server from 127.0.0.1:53508
[World Server] New Zone Server from 127.0.0.1:53507
[World Server] New Zone Server from 127.0.0.1:53509
[World Server] New Zone Server from 127.0.0.1:53510
[World Server] New Zone Server from 127.0.0.1:53511
[World Server] New Zone Server from 127.0.0.1:53512
[World Server] New Zone Server from 127.0.0.1:53513
[World Server] New Zone Server from 127.0.0.1:53514
[World Server] New Zone Server from 127.0.0.1:53515
[World Server] New Zone Server from 127.0.0.1:53516
[World Server] New Zone Server from 127.0.0.1:53517
[World Server] New Zone Server from 127.0.0.1:53518
[World Server] New UCS Connection from 127.0.0.1:53519
[World Server] New Zone Server from 127.0.0.1:53520
[World Server] New Zone Server from 127.0.0.1:53521
[World Server] New QS Connection from 127.0.0.1:53522

I don't really know what to do right now, i tried doing fresh installs, restarts, deleting every files related to this, but it's still giving me the same message again and again :\

I forgot to mention that i cannot connect to the server at all, but it is detected in the server browser

Are you talking about the super old repack that was retired a long time ago or the installer?

I'm talking about the one located on this page : http://wiki.eqemulator.org/p?Akkas_PEQ_Server_Installer

I'll have to check into it here, there is some migration that I did with PEQ which is that database used in this.

I'm on vacation so it will be a bit before I can look into this

Oh, so you think the problem is not on my side ?
Well, anyway, thanks for your time, and enjoy your vacations :-)

http://www.eqemulator.org/forums/sho...=40299&page=18

The installer is not correctly pulling the weekly from PEQ.

Akka will fix it whenever he's off vacation I bet.

But download this one: http://edit.peqtgc.com/weekly/peqbeta_2017-02-22-02:01.tar.gz

Code:

1. Copy data_tables_2017-02-22-02:01.sql, Peqbeta_2017-02-22-02:01.sql, player_tables_2017-02-22-02:01.sql to C:\Program Files\MariaDB 10.0\bin.



2. Rename data_tables_2017-02-22-02:01.sq to data_tables.sql, Rename Peqbeta_2017-02-22-02:01.sql to peqbeta.sql, rename player_tables_2017-02-22-02:01.sql to player_tables.sql.



3. run->cmd.exe



4. cd C:\Program Files\MariaDB 10.0\bin



5. mysql -u root -peqemu



6. DROP DATABASE peq;



7. CREATE DATABASE peq;



8. USE peq;



9. source peqbeta.sql



10. source player_tables.sql



11. source data_tables.sql

Should work now.

Thanks a lot for your help, and for your time.

So, now setting up a public server is working perfectly, no more errors or anything, but whenever i start the login server, i get a lot of errors, then this when i try to join ( i replaced my real ip with "thisismyip") :

[Login Server] Logging System Init.
[Login Server] Config System Init.
[Login Server] MySQL Database Init.
[Login Server] Encryption Initialize.
[Login Server] Encryption Loaded Successfully.
[Login Server] Server Manager Initialize.
[Login Server] ServerManager listening on port 5999
[Login Server] Client Manager Initialize.
[Login Server] ClientManager listening on Titanium stream.
[Login Server] ClientManager listening on SoD stream.
[Login Server] Server Started.
[Login Server] New world server connection from thisismyip:52883
[Login Server] New world server connection from thisismyip:52884
[Login Server] World server already existed for thisismyip, removing existing connection and updating current.
[Error] Mysql query failed: SELECT ifnull(WSR.ServerID,999999) AS ServerID, WSR.ServerTagDescription, ifnull(WSR.ServerTrusted,0) AS ServerTrusted, ifnull(SLT.ServerListTypeID,3) AS ServerListTypeID, SLT.ServerListTypeDescription, ifnull(WSR.ServerAdminID,0) AS ServerAdminID FROM loginserver_world_server_registration AS WSR JOIN loginserver_server_list_type AS SLT ON WSR.ServerListTypeID = SLT.ServerListTypeID WHERE WSR.ServerShortName = 'Gougnafierlelache'
[World Server] Server Gougnafieraxe (lNW9D0)(Gougnafierlelache) attempted to log in but database couldn't find an entry but unregistered servers are allowed.
[Error] Mysql query failed: SELECT ifnull(max(ServerID),0) FROM loginserver_world_server_registration
[Error] Mysql query failed: UPDATE loginserver_world_server_registration SET ServerLastLoginDate = now(), ServerLastIPAddr = 'thisismyip', ServerLongName = 'Gougnafieraxe (lNW9D0)' WHERE ServerID = 0
[Login Server] New world server connection from thisismyip:52906
[Login Server] World server already existed for thisismyip, removing existing connection and updating current.
[Error] Mysql query failed: SELECT ifnull(WSR.ServerID,999999) AS ServerID, WSR.ServerTagDescription, ifnull(WSR.ServerTrusted,0) AS ServerTrusted, ifnull(SLT.ServerListTypeID,3) AS ServerListTypeID, SLT.ServerListTypeDescription, ifnull(WSR.ServerAdminID,0) AS ServerAdminID FROM loginserver_world_server_registration AS WSR JOIN loginserver_server_list_type AS SLT ON WSR.ServerListTypeID = SLT.ServerListTypeID WHERE WSR.ServerShortName = 'Gougnafierlelache'
[World Server] Server Gougnafieraxe (lNW9D0)(Gougnafierlelache) attempted to log in but database couldn't find an entry but unregistered servers are allowed.
[Error] Mysql query failed: SELECT ifnull(max(ServerID),0) FROM loginserver_world_server_registration
[Error] Mysql query failed: UPDATE loginserver_world_server_registration SET ServerLastLoginDate = now(), ServerLastIPAddr = 'thisismyip', ServerLongName = 'Gougnafieraxe (lNW9D0)' WHERE ServerID = 0
[Login Server] New SoD client connection from thisismyip:56265
[Login Server] Application packet received from client (size 14)
[Login Server] Session ready received from client.
[Login Server] Application packet received from client (size 36)
[Login Server] Login received from client.
[Error] Mysql query failed: SELECT LoginServerID, AccountPassword FROM loginserver_server_accounts WHERE AccountName = 'Admin'
[Error] Mysql query failed: INSERT INTO loginserver_server_accounts (AccountName, AccountPassword, AccountEmail, LastLoginDate, LastIPAddress) VALUES('Admin', '5baa61e4c9b93f3f0682250b6cf8331b7ee68fd8', 'local_creation', NOW(), '127.0.0.1');
[Error] Error logging in, user Admin does not exist in the database.
[Login Server] New world server connection from thisismyip:52907
[Login Server] World server already existed for thisismyip, removing existing connection and updating current.
[Error] Mysql query failed: SELECT ifnull(WSR.ServerID,999999) AS ServerID, WSR.ServerTagDescription, ifnull(WSR.ServerTrusted,0) AS ServerTrusted, ifnull(SLT.ServerListTypeID,3) AS ServerListTypeID, SLT.ServerListTypeDescription, ifnull(WSR.ServerAdminID,0) AS ServerAdminID FROM loginserver_world_server_registration AS WSR JOIN loginserver_server_list_type AS SLT ON WSR.ServerListTypeID = SLT.ServerListTypeID WHERE WSR.ServerShortName = 'Gougnafierlelache'
[World Server] Server Gougnafieraxe (lNW9D0)(Gougnafierlelache) attempted to log in but database couldn't find an entry but unregistered servers are allowed.
[Error] Mysql query failed: SELECT ifnull(max(ServerID),0) FROM loginserver_world_server_registration
[Error] Mysql query failed: UPDATE loginserver_world_server_registration SET ServerLastLoginDate = now(), ServerLastIPAddr = 'thisismyip', ServerLongName = 'Gougnafieraxe (lNW9D0)' WHERE ServerID = 0
[Login Server] Client disconnected from the server, removing client.
[Login Server] New world server connection from thisismyip:52908
[Login Server] World server already existed for thisismyip, removing existing connection and updating current.
[Error] Mysql query failed: SELECT ifnull(WSR.ServerID,999999) AS ServerID, WSR.ServerTagDescription, ifnull(WSR.ServerTrusted,0) AS ServerTrusted, ifnull(SLT.ServerListTypeID,3) AS ServerListTypeID, SLT.ServerListTypeDescription, ifnull(WSR.ServerAdminID,0) AS ServerAdminID FROM loginserver_world_server_registration AS WSR JOIN loginserver_server_list_type AS SLT ON WSR.ServerListTypeID = SLT.ServerListTypeID WHERE WSR.ServerShortName = 'Gougnafierlelache'
[World Server] Server Gougnafieraxe (lNW9D0)(Gougnafierlelache) attempted to log in but database couldn't find an entry but unregistered servers are allowed.
[Error] Mysql query failed: SELECT ifnull(max(ServerID),0) FROM loginserver_world_server_registration
[Error] Mysql query failed: UPDATE loginserver_world_server_registration SET ServerLastLoginDate = now(), ServerLastIPAddr = 'Thisismyip', ServerLongName = 'Gougnafieraxe (lNW9D0)' WHERE ServerID = 0

If you read closely, that's saying the user Admin doesn't exist for your loginserver.

I assume you're trying to have a private loginserver as well as joining the public?

I don't know exactly what's happening, just trying to join a local login server ( that i made myself ), i followed the instructions on the Akka's server repack page, but it's not working like it used to do some days ago :\