Server Not Showing

Darkv1 · #1 04-11-2011, 11:56 PM

Hey guys so i wanted to set up and Everquest server to screw around on and everything works great but when i login my account it doesnt show any servers ill post the stuff below.Any ideas?

Loginserver.ini
----------------------------------------------------------------------

[LoginServer]
loginserver=classicemu.dyndns.org
loginport=5999
worldname=Classic
worldaddress=classicemu.dyndns.org
locked=false
account=
password=

[WorldServer]
Defaultstatus=
Unavailzone=

[ChatChannelServer]
worldshortname=
chataddress=
chatport=

[LoginConfig]
ServerMode=StandAlone
ServerPort=5999
--------------------------------------------------------------------
EQEMU CONFIG
------------------------------------------------------------
<server>
<world>
<shortname>Classic</shortname>
<longname>Classical Everquest Server</longname>

<address>classicemu.dyndns.org</address>
<localaddress>classicemu.dyndns.org</localaddress>

<loginserver>
<host>classicemu.dyndns.org</host>
<port>5999</port>
<account></account>
<password></password>
</loginserver>

<key>make up some random string of characters here</key>

<http port="9080" enable="true" mimefile="mime.types"/>
</world>

<database>
<host>localhost</host>
<port>3306</port>
<username>root</username>
<password>******</password>
<db>peq</db>
</database>
</server>
------------------------------------------------------------------
World.exe
------------------------------------------------------------------

Failed to open log file: logs/eqemu_debug_world_6552.log
[Debug] [WORLD__INIT] Loading server configuration..
[Debug] [WORLD__INIT] Warning: Unable to read log.ini
[Debug] [WORLD__INIT] CURRENT_WORLD_VERSION:EQEmulator 0.8.0
[Debug] [WORLD__INIT] Added loginserver classicemu.dyndns.org:5999
[Debug] [WORLD__INIT] Connecting to MySQL...
Failed to open log file: logs/eqemu_world_6552.log
[Status] Using database 'peq' at localhost:3306
[Debug] [WORLD__INIT] HTTP world service disabled.
[Debug] [WORLD__INIT] Loading variables..
[Debug] [WORLD__INIT] Loading zones..
Error in LoadZoneNames query 'SELECT MAX(zoneidnumber) FROM zone' #1146: Table '
peq.zone' doesn't exist
[Debug] [WORLD__INIT] Clearing groups..
[Debug] [WORLD__INIT] Clearing raids..
[Debug] [WORLD__INIT] Loading items..
[Status] EMuShareMem loaded
[Status] Loading items from database: count=84588
[Debug] [WORLD__INIT] Loading guilds..
[Debug] [WORLD__INIT] Loaded default rule set 'default'
[Debug] [WORLD__INIT] Clearing temporary merchant lists..
[Debug] [WORLD__INIT] Loading EQ time of day..
Failed to open log file: logs/eqemu_error_world_6552.log
[Error] Could not load EQTime file eqtime.cfg
[Debug] [WORLD__INIT_ERR] Unable to load eqtime.cfg
[Debug] [WORLD__INIT] Loading launcher list..
[Debug] [WORLD__INIT] Reboot zone modes ON
[Debug] [WORLD__INIT] Deleted 0 stale player corpses from database
[Debug] [WORLD__INIT] Deleted 0 stale player backups from database
[Debug] [WORLD__INIT] Loading adventures...
[Debug] [WORLD__INIT] Purging expired instances
[Debug] [WORLD__INIT] Zone (TCP) listener started.
[Debug] [WORLD__INIT] Client (UDP) listener started.
[Debug] [NET__IDENTIFY] Registered patch 6.2
[Debug] [NET__IDENTIFY] Registered patch Titanium
[Debug] [NET__IDENTIFY] Registered patch SoF
[Debug] [NET__IDENTIFY] Registered patch SoD
[Debug] [NET__IDENTIFY] Registered patch Underfoot
[Debug] [NET__IDENTIFY] Registered patch HoT
[Debug] [WORLD__LS] Connecting to login server: classicemu.dyndns.org:5999
[Debug] [WORLD__LS] Connected to Loginserver: classicemu.dyndns.org:5999
[Debug] [WORLD__ZONE] New TCP connection from 127.0.0.1:65501
[Debug] [WORLD__CONSOLE] New launcher from 127.0.0.1:65501
[Debug] [WORLD__LAUNCH] Adding pending launcher 1
[Debug] [WORLD__LAUNCH] Launcher Identified itself as 'zone'. Loading zone list.

[Debug] [WORLD__LAUNCH] Removing pending launcher 1. Adding zone to active list.

[Debug] [WORLD__LAUNCH] zone: dynamic_01 reported state STARTED (1 starts)
[Debug] [WORLD__ZONE] New TCP connection from 127.0.0.1:65506
[Debug] [WORLD__CONSOLE] New zoneserver #1 from 127.0.0.1:65506
[Debug] [WORLD__ZONE] [1] Zone started with name dynamic_01 by launcher zone
[Debug] [WORLD__ZONE] [1] Auto zone port configuration. Telling zone to use por
t 7000
[Debug] [WORLD__LAUNCH] zone: dynamic_02 reported state STARTED (1 starts)
[Debug] [WORLD__ZONE] New TCP connection from 127.0.0.1:65508
[Debug] [WORLD__CONSOLE] New zoneserver #2 from 127.0.0.1:65508
[Debug] [WORLD__ZONE] [2] Zone started with name dynamic_02 by launcher zone
[Debug] [WORLD__ZONE] [2] Auto zone port configuration. Telling zone to use por
t 7001
[Debug] [WORLD__LAUNCH] zone: dynamic_03 reported state STARTED (1 starts)
[Debug] [WORLD__ZONE] New TCP connection from 127.0.0.1:65510
[Debug] [WORLD__CONSOLE] New zoneserver #3 from 127.0.0.1:65510
[Debug] [WORLD__ZONE] [3] Zone started with name dynamic_03 by launcher zone
[Debug] [WORLD__ZONE] [3] Auto zone port configuration. Telling zone to use por
t 7002
[Debug] [WORLD__LAUNCH] zone: dynamic_04 reported state STARTED (1 starts)
[Debug] [WORLD__ZONE] New TCP connection from 127.0.0.1:65512
[Debug] [WORLD__CONSOLE] New zoneserver #4 from 127.0.0.1:65512
[Debug] [WORLD__ZONE] [4] Zone started with name dynamic_04 by launcher zone
[Debug] [WORLD__ZONE] [4] Auto zone port configuration. Telling zone to use por
t 7003
[Debug] [WORLD__LAUNCH] zone: dynamic_05 reported state STARTED (1 starts)
[Debug] [WORLD__ZONE] New TCP connection from 127.0.0.1:65514
[Debug] [WORLD__CONSOLE] New zoneserver #5 from 127.0.0.1:65514
[Debug] [WORLD__ZONE] [5] Zone started with name dynamic_05 by launcher zone
[Debug] [WORLD__ZONE] [5] Auto zone port configuration. Telling zone to use por
t 7004
--------------------------------------------------------------------------
Minilogin
--------------------------------------------------------------------------
LoginServer.ini read.
[Status] Loading opcodes..
Server mode: MiniLogin
Login server listening on port:5999
11042 New Server connection: xxx.xxx.x.xxx port: 56575
0: 43 6C 61 73 73 69 63 61 - 6C 20 45 76 65 72 71 75 | Classical Everqu
16: 65 73 74 20 53 65 72 76 - 65 72 00 00 00 00 00 00 | est Server......
32: 00 00 00 00 00 00 00 00 - 00 00 00 00 00 00 00 00 | ................
48: 00 00 00 00 00 00 00 00 - 00 00 00 00 00 00 00 00 | ................
64: 00 00 00 00 00 00 00 00 - 00 00 00 00 00 00 00 00 | ................
80: 00 00 00 00 00 00 00 00 - 00 00 00 00 00 00 00 00 | ................
96: 00 00 00 00 00 00 00 00 - 00 00 00 00 00 00 00 00 | ................
112: 00 00 00 00 00 00 00 00 - 00 00 00 00 00 00 00 00 | ................
128: 00 00 00 00 00 00 00 00 - 00 00 00 00 00 00 00 00 | ................
144: 00 00 00 00 00 00 00 00 - 00 00 00 00 00 00 00 00 | ................
160: 00 00 00 00 00 00 00 00 - 00 00 00 00 00 00 00 00 | ................
176: 00 00 00 00 00 00 00 00 - 00 00 00 00 00 00 00 00 | ................
192: 00 00 00 00 00 00 00 00 - 00 43 6C 61 73 73 69 63 | .........Classic
208: 00 00 00 00 00 00 00 00 - 00 00 00 00 00 00 00 00 | ................
224: 00 00 00 00 00 00 00 00 - 00 00 00 00 00 00 00 00 | ................
240: 00 00 00 00 00 00 00 00 - 00 00 00 63 6C 61 73 73 | ...........class
256: 69 63 65 6D 75 2E 64 79 - 6E 64 6E 73 2E 6F 72 67 | icemu.dyndns.org
272: 00 00 00 00 00 00 00 00 - 00 00 00 00 00 00 00 00 | ................
288: 00 00 00 00 00 00 00 00 - 00 00 00 00 00 00 00 00 | ................
304: 00 00 00 00 00 00 00 00 - 00 00 00 00 00 00 00 00 | ................
320: 00 00 00 00 00 00 00 00 - 00 00 00 00 00 00 00 00 | ................
336: 00 00 00 00 00 00 00 00 - 00 00 00 00 00 00 00 00 | ................
352: 00 00 00 00 00 00 00 00 - 00 00 00 00 00 00 00 00 | ................
368: 00 00 00 00 00 00 00 00 - 63 6C 61 73 73 69 63 65 | ........classice
384: 6D 75 2E 64 79 6E 64 6E - 73 2E 6F 72 67 00 00 00 | mu.dyndns.org...
400: 00 00 00 00 00 00 00 00 - 00 00 00 00 00 00 00 00 | ................
416: 00 00 00 00 00 00 00 00 - 00 00 00 00 00 00 00 00 | ................
432: 00 00 00 00 00 00 00 00 - 00 00 00 00 00 00 00 00 | ................
448: 00 00 00 00 00 00 00 00 - 00 00 00 00 00 00 00 00 | ................
464: 00 00 00 00 00 00 00 00 - 00 00 00 00 00 00 00 00 | ................
480: 00 00 00 00 00 00 00 00 - 00 00 00 00 00 00 00 00 | ................
496: 00 00 00 00 00 00 00 00 - 00 00 00 00 00 00 00 00 | ................
512: 00 00 00 00 00 00 00 00 - 00 00 00 00 00 00 00 00 | ................
528: 00 00 00 00 00 00 00 00 - 00 00 00 00 00 00 00 00 | ................
544: 00 00 00 00 00 00 00 00 - 00 00 00 00 00 00 00 00 | ................
560: 00 00 00 30 2E 33 2E 31 - 30 00 00 00 00 00 00 00 | ...0.3.10.......
576: 00 00 00 00 00 00 00 00 - 00 00 00 00 30 2E 38 2E | ............0.8.
592: 30 00 00 00 00 00 00 00 - 00 00 00 00 00 00 00 00 | 0...............
608: 00 00 00 00 00 00 00 00 - 00 00 00 00 00 00 00 00 | ................
624: 00 00 00 00 00 00 00 00 - 00 00 00 00 00 00 00 00 | ................
640: 00 00 00 00 00 00 00 00 - 00 00 00 00 00 | .............
0: 36 00 F2 01 00 00 00 00 - 01 00 00 00 | 6...........
0: 00 00 00 00 01 00 00 00 - 00 00 00 00 00 00 00 00 | ................
16: 00 00 00 00 00 00 00 00 - 00 00 00 00 00 00 00 00 | ................
32: 00 01 00 00 00 | .....
0: 30 00 00 00 00 00 00 00 - 02 00 00 00 | 0...........
0: 00 00 00 00 00 00 00 00 - 03 00 00 00 | ............
0: 69 6F 6E 42 00 00 00 00 - 04 00 00 00 | ionB........
0: 00 00 00 00 01 00 00 00 - 00 00 00 00 00 00 00 00 | ................
16: 00 00 00 00 00 00 00 00 - 00 00 00 00 00 00 00 00 | ................
32: 00 02 00 00 00 | .....
0: 00 00 00 00 00 00 00 00 - 05 00 00 00 | ............
0: 00 00 00 00 01 00 00 00 - 00 00 00 00 00 00 00 00 | ................
16: 00 00 00 00 00 00 00 00 - 00 00 00 00 00 00 00 00 | ................
32: 00 03 00 00 00 | .....
0: 00 00 00 00 01 00 00 00 - 00 00 00 00 00 00 00 00 | ................
16: 00 00 00 00 00 00 00 00 - 00 00 00 00 00 00 00 00 | ................
32: 00 04 00 00 00 | .....
0: 00 00 00 00 01 00 00 00 - 00 00 00 00 00 00 00 00 | ................
16: 00 00 00 00 00 00 00 00 - 00 00 00 00 00 00 00 00 | ................
32: 00 05 00 00 00 | .....

provocating · #2 04-12-2011, 12:44 PM

Well before anything, look line by line at what you posted. There are errors, you need to fix those errors before. Then we will go through your config file and make some corrections.

**trevius** · #3 04-12-2011, 01:12 PM

Code:

Error in LoadZoneNames query 'SELECT MAX(zoneidnumber) FROM zone' #1146: Table '
peq.zone' doesn't exist

That is the first one you should check. Make sure you have the 'zone' table.

Darkv1 · #4 04-12-2011, 09:27 PM

Thanks guys i got it to come up but now whenever i create a character and login i get a world.exe error?

lerxst2112 · #5 04-12-2011, 10:13 PM

Delete all your logs, try and create the character and login, examine the logs for errors. You have most likely missed some required SQL updates.

Darkv1 · #6 04-12-2011, 10:55 PM

Quote:

Originally Posted by lerxst2112

Delete all your logs, try and create the character and login, examine the logs for errors. You have most likely missed some required SQL updates.

k did all that theres one SQL file missing and its the character_.sql and i use hediSQL for extracting them into the database and i get an error any ideas? i think this is what it is

provocating · #7 04-12-2011, 11:02 PM

You said you found an error, please post the error.

Darkv1 · #8 04-12-2011, 11:04 PM

Quote:

Originally Posted by provocating

You said you found an error, please post the error.

This time i decided to load it from a command prompt and this is what it says

mysql> source character_.sql
ERROR:
Failed to open file 'character_.sql', error: 2
mysql>

Thats all it tells me.

provocating · #9 04-12-2011, 11:06 PM

No, I was referring to the original error you had in your log file.

Darkv1 · #10 04-12-2011, 11:24 PM

thanks a ton it worked perfectly now im logging in the server to see if itll let me make a character

provocating · #11 04-12-2011, 11:25 PM

Rocking.

Let us know how you like it.

Darkv1 · #12 04-12-2011, 11:30 PM

k i got kicked out and it said inventory was missing so i just uploaded about 9-10 sql files that im gonna need so im trying again

provocating · #13 04-12-2011, 11:31 PM

Once all of your i's are dotted and your t's crossed, it will work.

Darkv1 · #14 04-12-2011, 11:33 PM

err im missing so many sql files im gonna upload realllllyyyy quick xD

Darkv1 · #15 04-12-2011, 11:46 PM

Alright when i log in the character it kicks me back out to loginscreen and the world.exe client says

[Debug] [WORLD__CLIENT] (Myaccount name): Attempting autobootup of erudnint (23:0)
[Debug] [WORLD__ZONE] [5] Setting to 'erudnint' (23:0)
[Debug] [WORLD__CLIENT] (Myaccount name): Entering zone erudnint (23:0)
[Debug] [WORLD__ZONE] [5] [erudnint] Broadcasting a world time update
[Debug] [WORLD__ZONE] [5] [erudnint] Setting to 'erudnint' (23:0)
[Debug] [WORLD__CLIENT] (Myaccount name): Sending client to zone erudnint (23:0) at loc
alhost:7004
[Debug] [WORLD__CLIENT] (Myaccount name): Client disconnected (not active in process)