World not loading zones (?)

[blastadune]

My friends and I were very happy to find this community and have a chance to relive some fun times. Being that I am the one with a spare pc and the best connection I volunteered to set up the server.

I have followed the pdf guide step by step on my winxp machine. World cannot seem to get past loading zones. It says it is adding it to the launcher, makes note of the internal IP, then removes it from the active list. It would continue down this road if I did not stop it. I have searched the forums for this problem, and found some problems close to mine. Based on those recomendations I have tried: editing the start.bat file to say "zone", adding in 5 in the sql database for zones, utilizing the full eqemu_config.xml file, adding the fix for eqtime. Please note that server will appear on the server list, however locked. I have not, as yet been able to get the server succesfully up and running.


World error log:
---------------------------------------------
[02.29. - 14:37:37] Starting Log: logs/eqemu_debug_world_2112.log
[02.29. - 14:37:37] [WORLD__INIT] Loading server configuration..
[02.29. - 14:37:37] [WORLD__INIT] Log settings loaded from log.ini
[02.29. - 14:37:37] [WORLD__INIT] CURRENT_WORLD_VERSION:EQEMu 0.7.0
[02.29. - 14:37:37] [WORLD__INIT] Connecting to MySQL...
[02.29. - 14:37:37] [WORLD__INIT] HTTP world service disabled.
[02.29. - 14:37:37] [WORLD__INIT] Loading variables..
[02.29. - 14:37:37] [WORLD__INIT] Loading zones..
[02.29. - 14:37:37] [WORLD__INIT] Clearing groups..
[02.29. - 14:37:37] [WORLD__INIT] Clearing temporary merchant lists..
[02.29. - 14:37:37] [WORLD__INIT] Loading items..
[02.29. - 14:37:41] [WORLD__INIT] Loading guilds..
[02.29. - 14:37:41] [RULES__CHANGE] Loading rule set 'default' (2)
[02.29. - 14:37:41] [WORLD__INIT] Loaded default rule set 'default'
[02.29. - 14:37:41] [WORLD__INIT] Loading EQ time of day..
[02.29. - 14:37:41] [WORLD__INIT] Loading launcher list..
[02.29. - 14:37:41] [WORLD__INIT] Reboot zone modes ON
[02.29. - 14:37:41] [WORLD__INIT] Deleted 0 stale player corpses from database
[02.29. - 14:37:41] [WORLD__INIT] Deleted 0 stale player backups from database
[02.29. - 14:37:41] [WORLD__INIT] Zone (TCP) listener started.
[02.29. - 14:37:41] [WORLD__INIT] Client (UDP) listener started.
[02.29. - 14:37:41] [NET__IDENTIFY] Registered patch 6.2
[02.29. - 14:37:41] [NET__IDENTIFY] Registered patch Titanium
[02.29. - 14:37:41] [NET__IDENTIFY] Registered patch Anniversary
[02.29. - 14:37:41] [NET__IDENTIFY] Registered patch Live
[02.29. - 14:37:41] [WORLD__LS] Connecting to login server...
[02.29. - 14:37:41] [WORLD__LS] Connected to Loginserver: eqemulator.net:5998
[02.29. - 14:37:41] [WORLD__LS] Loginserver provided 71.187.24.238 as world address
[02.29. - 14:37:58] [WORLD__ZONE] New TCP connection from 127.0.0.1:3719
[02.29. - 14:37:58] [WORLD__CONSOLE] New launcher from 127.0.0.1:3719
[02.29. - 14:37:58] [WORLD__LAUNCH] Adding pending launcher 1
[02.29. - 14:37:58] [WORLD__LAUNCH] Unknown launcher 'zones' connected. Disconnecting.
[02.29. - 14:37:58] [WORLD__LAUNCH] Removing pending launcher 1. Adding zones to active list.
[02.29. - 14:37:58] [WORLD__LAUNCH] Removing launcher zones (1)
[02.29. - 14:38:13] [WORLD__ZONE] New TCP connection from 127.0.0.1:3720
[02.29. - 14:38:13] [WORLD__CONSOLE] New launcher from 127.0.0.1:3720
[02.29. - 14:38:13] [WORLD__LAUNCH] Adding pending launcher 2
[02.29. - 14:38:18] [WORLD__LAUNCH] Unknown launcher 'zones' connected. Disconnecting.
[02.29. - 14:38:18] [WORLD__LAUNCH] Removing pending launcher 2. Adding zones to active list.
[02.29. - 14:38:18] [WORLD__LAUNCH] Removing launcher zones (2)
-------------------------------------
eqemu_config.xml
<?xml version="1.0">
<server>
<world>
<shortname>Test</shortname>
<longname>This-Is-My-TEST</longname>

<!-- Only specify these two if you really think you need to. (read: You don't) -->
<!-- <address>192.168.1.12</address> -->
<!-- <localaddress>192.168.1.12</localaddress> -->

<!-- Loginserver information. Defaults shown -->
<loginserver>
<host>eqemulator.net</host>
<port>5998</port>
<account></account>
<password></password>
</loginserver>

<!-- Server status. Default is unlocked -->
<!--<locked/>-->
<!-- <unlocked/> -->

<!-- Sets the ip/port for the tcp connections. Both zones and console (if enabled). Defaults are shown -->
<tcp ip="localhost" port="9000" telnet="disable"/>

<!-- Sets the shared key used by zone/launcher to connect to world -->
<key>some long random string</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. Defaults shown -->
<chatserver>
<host>channels.eqemulator.net</host>
<port>7778</port>
</chatserver>

<!-- Mailserver (in-game mail) information. Defaults shown -->
<mailserver>
<host>channels.eqemulator.net</host>
<port>7779</port>
</mailserver>

<zones>
<defaultstatus>20</defaultstatus>

<!-- Sets port range for world to use to auto configure zones -->
<ports low="7000" high="7100"/>
</zones>

<!-- Database configuration, replaces db.ini. Defaults shown -->
<database>
<host>localhost</host>
<port>3306</port>
<username>root</username>
<password>lamepassword</password>
<db>peq</db>
</database>

<!-- Launcher Configuration -->
<launcher>
<!-- <logprefix>logs/zone-</logprefix> -->
<!-- <logsuffix>.log</logsuffix> -->
<!-- <exe>zone.exe or ./zone</exe> -->
<!-- <timers restart="10000" reterminate="10000"> -->
</launcher>

<!-- File locations. Defaults shown -->
<files>
<!-- <spells>spells_us.txt</spells> -->
<!-- <opcodes>opcodes.conf</opcodes> -->
<!-- <logsettings>log.ini</logsettings> -->
<!-- <eqtime>eqtime.cfg</eqtime> -->
</files>
<!-- Directory locations. Defaults shown -->
<directories>
<!-- <maps>Maps</maps> -->
<!-- <quests>quests</quests> -->
<!-- <plugins>plugins</plugins> -->
</directories>
</server>
--------------------------------------------
Thank you very much for your assistance

[RamsiMage]

I'm in the exact same boat here.

Could this be a router/port issue?

[AndMetal]

[02.29. - 14:37:58] [WORLD__CONSOLE] New launcher from 127.0.0.1:3719
[02.29. - 14:37:58] [WORLD__LAUNCH] Adding pending launcher 1
[02.29. - 14:37:58] [WORLD__LAUNCH] Unknown launcher 'zones' connected. Disconnecting.
[02.29. - 14:37:58] [WORLD__LAUNCH] Removing pending launcher 1. Adding zones to active list.
[02.29. - 14:37:58] [WORLD__LAUNCH] Removing launcher zones (1)
[02.29. - 14:38:13] [WORLD__ZONE] New TCP connection from 127.0.0.1:3720
[02.29. - 14:38:13] [WORLD__CONSOLE] New launcher from 127.0.0.1:3720
[02.29. - 14:38:13] [WORLD__LAUNCH] Adding pending launcher 2
[02.29. - 14:38:18] [WORLD__LAUNCH] Unknown launcher 'zones' connected. Disconnecting.
[02.29. - 14:38:18] [WORLD__LAUNCH] Removing pending launcher 2. Adding zones to active list.
[02.29. - 14:38:18] [WORLD__LAUNCH] Removing launcher zones (2)


It looks like eqlauncher is being launched with an undefined launcher, "zones". If I remember correctly, I believe the default launcher name is "zone". However, it can be whatever you want it to be, as long as you add it to the launcher table in the database. In addition, if you want any static zones, you would need to add them to the launcher_zones table using the same launcher name.

If you can, post the start script you're using (ditto for RamsiMage).

[RamsiMage]

Pulled it from the wiki. After reading your response above, I'm sure this will be my issue, just having to play around until I figure out how it all works.

@echo off
start world.exe
cls
echo Wait for World to finish loading... Press Enter when done.
pause
start eqlaunch.exe zone
exit

...it to the launcher table in the database

This is my downfall here. I've never played with databases in the past, time to learn. I recall some program being avail to view/edit the database but I can't seem to locate it. I located GeorgeS and his tools today. I'm gonna play with those and try to figure it out.

/afk for a few hrs.

[AndMetal]

What do you use to manage your database? Software or command line?

[kiirdiir]

I have followed the pdf guide step by step on my winxp machine.

The PDF guide is out of date. I added some notes to the wiki (http://www.eqemulator.net/wiki/wikka.php?wakka=ws992mysql5) today.

World cannot seem to get past loading zones. It says it is adding it to the launcher, makes note of the internal IP, then removes it from the active list. It would continue down this road if I did not stop it. I have searched the forums for this problem, and found some problems close to mine.

Based on those recomendations I have tried: editing the start.bat file to say "zone", adding in 5 in the sql database for zones, utilizing the full eqemu_config.xml file, adding the fix for eqtime. Please note that server will appear on the server list, however locked. I have not, as yet been able to get the server succesfully up and running.


This has come up a few times and I have ran into it myself. The answer is in your search somewhere, but let me see if I can help:

(Side note for future searches: start.bat, defaults, zone is for PEQ, zones is for AX.)

World error log:
...
[02.29. - 14:37:58] [WORLD__CONSOLE] New launcher from 127.0.0.1:3719
[02.29. - 14:37:58] [WORLD__LAUNCH] Adding pending launcher 1
[02.29. - 14:37:58] [WORLD__LAUNCH] Unknown launcher 'zones' connected. Disconnecting.
[02.29. - 14:37:58] [WORLD__LAUNCH] Removing pending launcher 1. Adding zones to active list.
[02.29. - 14:37:58] [WORLD__LAUNCH] Removing launcher zones (1)


Unknown and removing launcher, so lets check your config:

eqemu_config.xml
<?xml version="1.0">
...
<!-- Sets the shared key used by zone/launcher to connect to world -->
<key>some long random string</key>
...


That <key> must match your database: variables table, ZSPassword row, value field. It is wise to change it from the default.

I've never played with databases in the past, time to learn. I recall some program being avail to view/edit the database but I can't seem to locate it.

I like the dev.mysql.com tools (http://dev.mysql.com/downloads/gui-tools/5.0.html) for (simple) browsing and editing.

[RamsiMage]

I like the dev.mysql.com tools for (simple) browsing and editing.
Thanks. That's what I was looking for.

What do you use to manage your database? Software or command line?

Well, I didn't until today. That is, last night was my first endeavor into working with any database. Today I found GeorgeS tools and thanks to kiirdiir, I now have a GUI tool.

I'll work with both for a short time and see what fits.

Kiirdiir, your response about the key having to match is likely going to be my issue. Once I learn the database tools, I'm sure I'll have it up and running.

Thanks all. I will post an update after this nasty weather were about to start having here in central Florida.

[blastadune]

Working on it as we speak

Making the easiest change yeilded some progress. I think now I will have to make the suggested changes to database tables.

I will keep you posted

THANK YOU