New Server issues

[warkid]

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

[Vexyl]

Please post the error log so we can help you.

[lerxst2112]

You might also describe the steps you followed.

[warkid]

I followed wiki steps.... Can't post log as I had hardware issues that screwed windows up so going to try again

[warkid]

Still having same problems... here are the log files

[warkid]

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

[warkid]

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

[warkid]

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 (
[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

[warkid]

[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.

[warkid]

[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

[warkid]

[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)

[warkid]

those are all the ones with erros

[Vexyl]

[09.24. - 19:19:28] [WORLD__INIT_ERR] Error: Could not load item data. But ignoring

That's bad, but probably not the cause of the problem you described.


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.

[warkid]

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>

[lerxst2112]

Well, it looks like your database is quite broken. You might want to check those steps again.