New Server issues
ok so i followed everything down to the T
i start my BAT file to start server BUT i get some erros telling me some peqdb files are missing my server shows on the server list and is listed as locked when i try to load i get blank screen and it seems to freeze |
Please post the error log so we can help you.
|
You might also describe the steps you followed.
|
I followed wiki steps.... Can't post log as I had hardware issues that screwed windows up so going to try again
|
Log files
Still having same problems... here are the log files
|
LOG 2
[09.24. - 19:19:37] Starting Log: logs/eqemu_debug_queryserv_2920.log [09.24. - 19:19:37] [QUERYSERV__INIT] Starting EQEmu QueryServ. [09.24. - 19:19:37] [QUERYSERV__INIT] Log settings loaded from log.ini [09.24. - 19:19:37] [QUERYSERV__INIT] Connecting to MySQL... [09.24. - 19:19:37] [QUERYSERV__ERROR] Failed to load LFGuild info from database. SELECT `type`,`name`,`comment`, `fromlevel`, `tolevel`, `classes`, `aacount`, `timezone`, `timeposted` FROM `lfguild` #1146: Table 'peq.lfguild' doesn't exist [09.24. - 19:19:37] [QUERYSERV__INIT] Connected to World. [09.24. - 19:19:37] [NET__WORLD] Connected to World: 127.0.0.1:9000 |
Log 3
[09.24. - 19:19:37] Starting Log: logs/eqemu_debug_ucs_5012.log [09.24. - 19:19:37] [UCS__INIT] Starting EQEmu Universal Chat Server. [09.24. - 19:19:37] [UCS__INIT] Log settings loaded from log.ini [09.24. - 19:19:37] [UCS__INIT] Connecting to MySQL... [09.24. - 19:19:37] [UCS__ERROR] Unable to get message count from database. select `value` from `variables` where `varname`='RuleSet' #1146: Table 'peq.variables' doesn't exist [09.24. - 19:19:37] [UCS__INIT] No rule set configured, using default rules [09.24. - 19:19:37] [UCS__INIT] Expiring mail... [09.24. - 19:19:37] [UCS__ERROR] Unable to get message count from database. select COUNT(*) from `mail` #1146: Table 'peq.mail' doesn't exist [09.24. - 19:19:37] [UCS__INIT] Client (UDP) Chat listener started on port 7778. [09.24. - 19:19:37] [UCS__INIT] Loading chat channels from the database. [09.24. - 19:19:37] [UCS__ERROR] Failed to load channels. select `name`,`owner`,`password`, `minstatus` from `chatchannels` #1146: Table 'peq.chatchannels' doesn't exist [09.24. - 19:19:37] [UCS__INIT] Connected to World. [09.24. - 19:19:37] [NET__WORLD] Connected to World: 127.0.0.1:9000 |
LOG 4
[09.24. - 19:19:28] Starting Log: logs/eqemu_debug_world_4756.log [09.24. - 19:19:28] [WORLD__INIT] Loading server configuration.. [09.24. - 19:19:28] [WORLD__INIT] Log settings loaded from log.ini [09.24. - 19:19:28] [WORLD__INIT] CURRENT_VERSION: 1.0.0 [09.24. - 19:19:28] [WORLD__INIT] Added loginserver eqemulator.net:5998 [09.24. - 19:19:28] [WORLD__INIT] Connecting to MySQL... [09.24. - 19:19:28] [WORLD__INIT] HTTP world service disabled. [09.24. - 19:19:28] [WORLD__INIT] Loading variables.. [09.24. - 19:19:28] [WORLD__INIT] Loading zones.. [09.24. - 19:19:28] [WORLD__INIT] Clearing groups.. [09.24. - 19:19:28] [WORLD__INIT] Clearing raids.. [09.24. - 19:19:28] [WORLD__INIT] Loading items.. [09.24. - 19:19:28] [WORLD__INIT_ERR] Error: Could not load item data. But ignoring [09.24. - 19:19:28] [WORLD__INIT] Loading guilds.. [09.24. - 19:19:28] [GUILDS__ERROR] Error loading guilds 'SELECT id, name, leader, minstatus, motd, motd_setter,channel,url FROM guilds': #1146: Table 'peq.guilds' doesn't exist [09.24. - 19:19:28] [WORLD__INIT] No rule set configured, using default rules [09.24. - 19:19:28] [WORLD__INIT] Clearing temporary merchant lists.. [09.24. - 19:19:28] [WORLD__INIT] Loading EQ time of day.. [09.24. - 19:19:28] [WORLD__INIT_ERR] Unable to load eqtime.cfg [09.24. - 19:19:28] [WORLD__INIT] Loading launcher list.. [09.24. - 19:19:28] [WORLD__INIT] Reboot zone modes OFF [09.24. - 19:19:28] [WORLD__INIT] Deleted -1 stale player corpses from database [09.24. - 19:19:28] [WORLD__INIT] Deleted -1 stale player backups from database [09.24. - 19:19:28] [WORLD__INIT] Loading adventures... [09.24. - 19:19:28] [WORLD__INIT_ERR] Unable to load adventure templates. [09.24. - 19:19:28] [WORLD__INIT_ERR] Unable to load adventure templates. [09.24. - 19:19:28] [WORLD__INIT] Purging expired instances [09.24. - 19:19:28] [WORLD__INIT] Loading char create info... [09.24. - 19:19:28] [WORLD__INIT] Zone (TCP) listener started. [09.24. - 19:19:28] [WORLD__INIT] Client (UDP) listener started. [09.24. - 19:19:28] [NET__IDENTIFY] Registered patch 6.2 [09.24. - 19:19:28] [NET__IDENTIFY] Registered patch Titanium [09.24. - 19:19:28] [NET__IDENTIFY] Registered patch SoF [09.24. - 19:19:28] [NET__IDENTIFY] Registered patch SoD [09.24. - 19:19:28] [NET__IDENTIFY] Registered patch Underfoot [09.24. - 19:19:28] [NET__IDENTIFY] Registered patch RoF [09.24. - 19:19:28] [WORLD__LS] Connecting to login server: eqemulator.net:5998 [09.24. - 19:19:28] [WORLD__LS] Connected to Loginserver: eqemulator.net:5998 [09.24. - 19:19:29] [WORLD__LS] Loginserver provided 81.174.173.133 as world address [09.24. - 19:19:37] [WORLD__ZONE] New TCP connection from 127.0.0.1:49751 [09.24. - 19:19:37] [WORLD__CONSOLE] New launcher from 127.0.0.1:49751 [09.24. - 19:19:37] [WORLD__LAUNCH] Adding pending launcher 1 [09.24. - 19:19:37] [WORLD__LAUNCH] Unknown launcher 'zone' connected. Disconnecting. [09.24. - 19:19:37] [WORLD__LAUNCH] Removing pending launcher 1. Adding zone to active list. [09.24. - 19:19:37] [WORLD__LAUNCH] Removing launcher zone (1) [09.24. - 19:19:37] [WORLD__ZONE] New TCP connection from 127.0.0.1:49753 [09.24. - 19:19:37] [WORLD__CONSOLE] New QS Connection from 127.0.0.1:49753 [09.24. - 19:19:37] [WORLD__ZONE] New TCP connection from 127.0.0.1:49755 [09.24. - 19:19:37] [WORLD__CONSOLE] New UCS Connection from 127.0.0.1:49755 [09.24. - 19:19:47] [WORLD__ZONE] New TCP connection from 127.0.0.1:49756 [09.24. - 19:19:47] [WORLD__CONSOLE] New launcher from 127.0.0.1:49756 [09.24. - 19:19:47] [WORLD__LAUNCH] Adding pending launcher 2 [09.24. - 19:19:52] [WORLD__LAUNCH] Unknown launcher 'zone' connected. Disconnecting. [09.24. - 19:19:52] [WORLD__LAUNCH] Removing pending launcher 2. Adding zone to active list. [09.24. - 19:19:52] [WORLD__LAUNCH] Removing launcher zone (2) [09.24. - 19:19:57] [WORLD__ZONE] New TCP connection from 127.0.0.1:49757 [09.24. - 19:19:57] [WORLD__CONSOLE] New launcher from 127.0.0.1:49757 [09.24. - 19:19:57] [WORLD__LAUNCH] Adding pending launcher 3 [09.24. - 19:20:02] [WORLD__LAUNCH] Unknown launcher 'zone' connected. Disconnecting. [09.24. - 19:20:02] [WORLD__LAUNCH] Removing pending launcher 3. Adding zone to active list. [09.24. - 19:20:02] [WORLD__LAUNCH] Removing launcher zone (3) [09.24. - 19:20:07] [WORLD__ZONE] New TCP connection from 127.0.0.1:49764 [09.24. - 19:20:07] [WORLD__CONSOLE] New launcher from 127.0.0.1:49764 [09.24. - 19:20:07] [WORLD__LAUNCH] Adding pending launcher 4 [09.24. - 19:20:12] [WORLD__LAUNCH] Unknown launcher 'zone' connected. Disconnecting. [09.24. - 19:20:12] [WORLD__LAUNCH] Removing pending launcher 4. Adding zone to active list. [09.24. - 19:20:12] [WORLD__LAUNCH] Removing launcher zone (4) [09.24. - 19:20:17] [WORLD__ZONE] New TCP connection from 127.0.0.1:49765 [09.24. - 19:20:17] [WORLD__CONSOLE] New launcher from 127.0.0.1:49765 [09.24. - 19:20:17] [WORLD__LAUNCH] Adding pending launcher 5 [09.24. - 19:20:22] [WORLD__LAUNCH] Unknown launcher 'zone' connected. Disconnecting. [09.24. - 19:20:22] [WORLD__LAUNCH] Removing pending launcher 5. Adding zone to active list. [09.24. - 19:20:22] [WORLD__LAUNCH] Removing launcher zone (5) [09.24. - 19:20:27] [WORLD__ZONE] New TCP connection from 127.0.0.1:49766 [09.24. - 19:20:27] [WORLD__CONSOLE] New launcher from 127.0.0.1:49766 [09.24. - 19:20:27] [WORLD__LAUNCH] Adding pending launcher 6 [09.24. - 19:20:32] [WORLD__LAUNCH] Unknown launcher 'zone' connected. Disconnecting. [09.24. - 19:20:32] [WORLD__LAUNCH] Removing pending launcher 6. Adding zone to active list. [09.24. - 19:20:32] [WORLD__LAUNCH] Removing launcher zone (6) [09.24. - 19:20:37] [WORLD__ZONE] New TCP connection from 127.0.0.1:49767 [09.24. - 19:20:37] [WORLD__CONSOLE] New launcher from 127.0.0.1:49767 [09.24. - 19:20:37] [WORLD__LAUNCH] Adding pending launcher 7 [09.24. - 19:20:42] [WORLD__LAUNCH] Unknown launcher 'zone' connected. Disconnecting. [09.24. - 19:20:42] [WORLD__LAUNCH] Removing pending launcher 7. Adding zone to active list. [09.24. - 19:20:42] [WORLD__LAUNCH] Removing launcher zone (7) [09.24. - 19:20:47] [WORLD__ZONE] New TCP connection from 127.0.0.1:49774 [09.24. - 19:20:47] [WORLD__CONSOLE] New launcher from 127.0.0.1:49774 [09.24. - 19:20:47] [WORLD__LAUNCH] Adding pending launcher 8 [09.24. - 19:20:52] [WORLD__LAUNCH] Unknown launcher 'zone' connected. Disconnecting. [09.24. - 19:20:52] [WORLD__LAUNCH] Removing pending launcher 8. Adding zone to active list. [09.24. - 19:20:52] [WORLD__LAUNCH] Removing launcher zone (8) [09.24. - 19:20:57] [WORLD__ZONE] New TCP connection from 127.0.0.1:49775 [09.24. - 19:20:57] [WORLD__CONSOLE] New launcher from 127.0.0.1:49775 [09.24. - 19:20:57] [WORLD__LAUNCH] Adding pending launcher 9 [09.24. - 19:21:02] [WORLD__LAUNCH] Unknown launcher 'zone' connected. Disconnecting. [09.24. - 19:21:02] [WORLD__LAUNCH] Removing pending launcher 9. Adding zone to active list. [09.24. - 19:21:02] [WORLD__LAUNCH] Removing launcher zone (9) [09.24. - 19:21:07] [WORLD__ZONE] New TCP connection from 127.0.0.1:49776 [09.24. - 19:21:07] [WORLD__CONSOLE] New launcher from 127.0.0.1:49776 [09.24. - 19:21:07] [WORLD__LAUNCH] Adding pending launcher 10 [09.24. - 19:21:12] [WORLD__LAUNCH] Unknown launcher 'zone' connected. Disconnecting. [09.24. - 19:21:12] [WORLD__LAUNCH] Removing pending launcher 10. Adding zone to active list. [09.24. - 19:21:12] [WORLD__LAUNCH] Removing launcher zone (10) [09.24. - 19:21:17] [WORLD__ZONE] New TCP connection from 127.0.0.1:49783 [09.24. - 19:21:17] [WORLD__CONSOLE] New launcher from 127.0.0.1:49783 [09.24. - 19:21:17] [WORLD__LAUNCH] Adding pending launcher 11 [09.24. - 19:21:22] [WORLD__LAUNCH] Unknown launcher 'zone' connected. Disconnecting. [09.24. - 19:21:22] [WORLD__LAUNCH] Removing pending launcher 11. Adding zone to active list. [09.24. - 19:21:22] [WORLD__LAUNCH] Removing launcher zone (11) [09.24. - 19:21:27] [WORLD__ZONE] New TCP connection from 127.0.0.1:49784 [09.24. - 19:21:27] [WORLD__CONSOLE] New launcher from 127.0.0.1:49784 [09.24. - 19:21:27] [WORLD__LAUNCH] Adding pending launcher 12 [09.24. - 19:21:32] [WORLD__LAUNCH] Unknown launcher 'zone' connected. Disconnecting. [09.24. - 19:21:32] [WORLD__LAUNCH] Removing pending launcher 12. Adding zone to active list. [09.24. - 19:21:32] [WORLD__LAUNCH] Removing launcher zone (12) [09.24. - 19:21:37] [WORLD__ZONE] New TCP connection from 127.0.0.1:49785 [09.24. - 19:21:37] [WORLD__CONSOLE] New launcher from 127.0.0.1:49785 [09.24. - 19:21:37] [WORLD__LAUNCH] Adding pending launcher 13 [09.24. - 19:21:42] [WORLD__LAUNCH] Unknown launcher 'zone' connected. Disconnecting. [09.24. - 19:21:42] [WORLD__LAUNCH] Removing pending launcher 13. Adding zone to active list. [09.24. - 19:21:42] [WORLD__LAUNCH] Removing launcher zone (13) [09.24. - 19:21:47] [WORLD__ZONE] New TCP connection from 127.0.0.1:49792 [09.24. - 19:21:47] [WORLD__CONSOLE] New launcher from 127.0.0.1:49792 [09.24. - 19:21:47] [WORLD__LAUNCH] Adding pending launcher 14 [09.24. - 19:21:52] [WORLD__LAUNCH] Unknown launcher 'zone' connected. Disconnecting. [09.24. - 19:21:52] [WORLD__LAUNCH] Removing pending launcher 14. Adding zone to active list. [09.24. - 19:21:52] [WORLD__LAUNCH] Removing launcher zone (14) [09.24. - 19:21:57] [WORLD__ZONE] New TCP connection from 127.0.0.1:49794 [09.24. - 19:21:57] [WORLD__CONSOLE] New launcher from 127.0.0.1:49794 [09.24. - 19:21:57] [WORLD__LAUNCH] Adding pending launcher 15 |
[09.24. - 19:19:27] Starting Log: logs/eqemu_error_shared_memory_4336.log
[09.24. - 19:19:27] Error in GetItemsCount 'SELECT MAX(id), count(*) FROM items': '#1146: Table 'peq.items' doesn't exist' [09.24. - 19:19:27] EQEmu Exception (Shared Memory) in ..\..\shared_memory\items.cpp at line (35): Unable to get any items from the database. |
[09.24. - 19:19:37] Starting Log: logs/eqemu_error_ucs_5012.log
[09.24. - 19:19:37] Error in LoadRules query SELECT ruleset_id FROM rule_sets WHERE name='default': #1146: Table 'peq.rule_sets' doesn't exist |
[09.24. - 19:19:28] Starting Log: logs/eqemu_error_world_4756.log
[09.24. - 19:19:28] Error Loading Items: EQEmu Exception (Shared Memory) in ..\..\common\memory_mapped_file.cpp at line (112): Could not open the file to find the existing file size. [09.24. - 19:19:28] Error in LoadRules query SELECT ruleset_id FROM rule_sets WHERE name='default': #1146: Table 'peq.rule_sets' doesn't exist [09.24. - 19:19:28] Could not load EQTime file eqtime.cfg [09.24. - 19:19:28] WorldDatabase::GetLauncherList: #1146: Table 'peq.launcher' doesn't exist [09.24. - 19:19:28] Error in AdventureManager:::LoadAdventures: SELECT id, zone, zone_version, is_hard, min_level, max_level, type, type_data, type_count, assa_x, assa_y, assa_z, assa_h, text, duration, zone_in_time, win_points, lose_points, theme, zone_in_zone_id, zone_in_x, zone_in_y, zone_in_object_id, dest_x, dest_y, dest_z, dest_h, graveyard_zone_id, graveyard_x, graveyard_y, graveyard_z, graveyard_radius FROM adventure_template (#1146: Table 'peq.adventure_template' doesn't exist) [09.24. - 19:19:28] Error in AdventureManager:::LoadAdventureEntries: SELECT id, template_id FROM adventure_template_entry (#1146: Table 'peq.adventure_template_entry' doesn't exist) [09.24. - 19:19:28] Error in AdventureManager:::GetLeaderboardInfo: select ch.name, ch.id, adv_stats.* from adventure_stats AS adv_stats left join character_ AS ch on adv_stats.player_id = ch.id; (#1146: Table 'peq.adventure_stats' doesn't exist) |
those are all the ones with erros
|
Quote:
Anyways, additional information is needed: Which wiki guide did you follow? (post link) Are you running your own login server, or are you connecting to the main login server? Can you post your eqemu_config.xml (with login/sql info censored)? Have you gone through the steps to forward the appropriate ports for running an EQEmu server? By the way, you may want to keep log/config files in one post under separate code tags. Posting them individually as you have done makes it relatively difficult to read. |
http://www.eqemulator.net/wiki/wikka...rverSetupGuide
wiki guide I followed ^^ connecting to main login all ports on outer are open as standard but yes I double checked (server shows on eqemu main server ist ... but it list as locked and gives me blank screen when I try to load) config file blow <?xml version="1.0"> <server> <world> <!-- Set the shortname to ONE word. The longname is what shows up on server list --> <shortname>Warville</shortname> <longname>Warville's legit server</longname> <!-- DO NOT EDIT ANY LINES BETWEEN HERE AND THE DATABASE SECTION --> <!-- <address>do.not.edit</address> --> <!-- <localaddress>do.not.edit</localaddress> --> <!-- Loginserver information. DO NOT EDIT --> <loginserver> <host>eqemulator.net</host> <port>5998</port> <account></account> <password></password> </loginserver> <!-- Server status. Default is unlocked DO NOT EDIT RIGHT NOW --> <!--<locked/>--> <!-- <unlocked/> --> <!-- Sets the ip/port for the tcp connections. DO NOT EDIT --> <tcp ip="127.0.0.1" port="9000" telnet="disable"/> <!-- Sets the shared key used by zone/launcher to connect to world --> <key>somelongrandomstring12345</key> <!-- Enable and set the port for the HTTP service. Defaults are shown --> <http port="9080" enabled="false" mimefile="mime.types" /> </world> <!-- Chatserver (channels) information. DO NOT EDIT --> <chatserver> <host>192.168.1.4</host> <port>7778</port> </chatserver> <!-- Mailserver (in-game mail) information. DO NOT EDIT --> <mailserver> <host>192.168.1.4</host> <port>7778</port> </mailserver> <zones> <!-- The defaultstatus is what status the new toons will have on your server --> <defaultstatus>0</defaultstatus> <!-- Sets port range for world to use to auto configure zones DO NOT EDIT RIGHT NOW--> <ports low="7000" high="7100"/> </zones> <!-- Set username to root and password is your MySQL password and db to peq --> <database> <host>127.0.0.1</host> <port>3306</port> <username>*********</username> <password>********</password> <db>peq</db> </database> <qsdatabase> <host>127.0.0.1</host> <port>3306</port> <username>root</username> <password>nutmeg19</password> <db>peq</db> </qsdatabase> <!-- Launcher Configuration DO NOT EDIT--> <launcher> <!-- <logprefix>logs/zone-</logprefix> --> <!-- <logsuffix>.log</logsuffix> --> <!-- <exe>zone.exe</exe> --> <!-- <timers restart="10000" reterminate="10000"> --> </launcher> <!-- File locations. DO NOT EDIT --> <files> <!-- <spells>spells_us.txt</spells> --> <!-- <opcodes>opcodes.conf</opcodes> --> <!-- <logsettings>log.ini</logsettings> --> <!-- <eqtime>eqtime.cfg</eqtime> --> </files> <!-- Directory locations. DO NOT EDIT --> <directories> <!-- <maps>Maps</maps> --> <!-- <quests>quests</quests> --> <!-- <plugins>plugins</plugins> --> </directories></server> |
Well, it looks like your database is quite broken. You might want to check those steps again.
|
| All times are GMT -4. The time now is 06:12 PM. |
Powered by vBulletin®, Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.