Server Not Showing

[Darkv1]

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]

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]

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]

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

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

[Darkv1]

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]

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

[Darkv1]

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]

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

[Darkv1]

Ohh with the world.exe error right?

[provocating]

World, Zone, whichever was giving you a missing SQL error.

[Darkv1]

ohh i fixed it all i did was dropped the peq database and reuploaded it.

[provocating]

Okay, so all is working ?

[Darkv1]

it is so far but i cant create a character just for the fact that i dont have the character_.sql file uploaded to the database but when i try uploading it it gives me and error.If i can get it to upload i may have no problems

[provocating]

If you sourced peq then you should have the character_ table, or at least I really thought you would. If you look in Heidi at the PEQ database, are you not seeing character_ ?

If not here you go.

/*
MySQL Data Transfer
Source Host: localhost
Source Database: cvs
Target Host: localhost
Target Database: cvs
Date: 2008-09-30 7:12:28 PM
*/

SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for character_
-- ----------------------------
CREATE TABLE `character_` (
`id` int(11) NOT NULL auto_increment,
`account_id` int(11) NOT NULL default '0',
`name` varchar(64) NOT NULL default '',
`profile` blob,
`timelaston` int(11) unsigned default '0',
`x` float NOT NULL default '0',
`y` float NOT NULL default '0',
`z` float NOT NULL default '0',
`zonename` varchar(30) NOT NULL default '',
`alt_adv` blob,
`zoneid` smallint(6) NOT NULL default '0',
`instanceid` SMALLINT UNSIGNED DEFAULT '0' NOT NULL,
`pktime` int(8) NOT NULL default '0',
`inventory` blob,
`groupid` int(10) unsigned NOT NULL default '0',
`extprofile` blob,
`class` tinyint(4) NOT NULL default '0',
`level` mediumint(8) unsigned NOT NULL default '0',
`lfp` tinyint(1) unsigned NOT NULL default '0',
`lfg` tinyint(1) unsigned NOT NULL default '0',
`mailkey` CHAR(16) NOT NULL default '0',
PRIMARY KEY (`id`),
UNIQUE KEY `name` (`name`),
KEY `account_id` (`account_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- ----------------------------
-- Records
-- ----------------------------

[Darkv1]

If you sourced peq then you should have the character_ table, or at least I really thought you would. If you look in Heidi at the PEQ database, are you not seeing character_ ?

If not here you go.

/*
MySQL Data Transfer
Source Host: localhost
Source Database: cvs
Target Host: localhost
Target Database: cvs
Date: 2008-09-30 7:12:28 PM
*/

SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for character_
-- ----------------------------
CREATE TABLE `character_` (
`id` int(11) NOT NULL auto_increment,
`account_id` int(11) NOT NULL default '0',
`name` varchar(64) NOT NULL default '',
`profile` blob,
`timelaston` int(11) unsigned default '0',
`x` float NOT NULL default '0',
`y` float NOT NULL default '0',
`z` float NOT NULL default '0',
`zonename` varchar(30) NOT NULL default '',
`alt_adv` blob,
`zoneid` smallint(6) NOT NULL default '0',
`instanceid` SMALLINT UNSIGNED DEFAULT '0' NOT NULL,
`pktime` int(8) NOT NULL default '0',
`inventory` blob,
`groupid` int(10) unsigned NOT NULL default '0',
`extprofile` blob,
`class` tinyint(4) NOT NULL default '0',
`level` mediumint(8) unsigned NOT NULL default '0',
`lfp` tinyint(1) unsigned NOT NULL default '0',
`lfg` tinyint(1) unsigned NOT NULL default '0',
`mailkey` CHAR(16) NOT NULL default '0',
PRIMARY KEY (`id`),
UNIQUE KEY `name` (`name`),
KEY `account_id` (`account_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- ----------------------------
-- Records
-- ----------------------------


Ok,when i insert it i get an error that says theres an error in the MYSQL syntax

[provocating]

Well take what I just posted in the code block and just put it into your query window in Heidi and click the blue execute SQL button.

[Darkv1]

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

[provocating]

Rocking.

Let us know how you like it.

[Darkv1]

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]

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

[Darkv1]

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

[Darkv1]

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)

[lerxst2112]

Look at the zone log.

[Darkv1]

Look at the zone log.
very sorry for my newbness but how might i do that? >.<

[lerxst2112]

In your server directory there should be a logs directory with a bunch of files in it. If there isn't a logs directory you should make one.

The best way to track down an issue like this is to stop your server, delete all the files in that logs directory, and then start the server and try to reproduce the problem. Then you can look at those logs to see if there are any errors.

The file you're looking for will be named eqemu_debug_zone_xxxx.log where xxxx is some number.

[Darkv1]

i dont have it how do i make one?

[lerxst2112]

i dont have it how do i make one?

You're never made a directory before? Right-click in an empty area of the server folder window and select New->Folder, then name it logs.

[Darkv1]

lol is there anything else besides that like codes and whatnot?

[provocating]

No, just make the directory logs. When server and zone run they look to see if that directory is there, if it exist then they start producing logs. Are you using a guide ? It should be in the step by step instructions.

[warlorn81]

if you are using the newest peq database and yer having problems getting into the game once u make a character run this querry

ALTER TABLE `account` ADD `time_creation` INT UNSIGNED DEFAULT '0' NOT NULL AFTER `suspendeduntil`;
UPDATE `account` SET `time_creation` = UNIX_TIMESTAMP() WHERE `time_creation` = 0;

i was having the same issue and that fixed it for me

[Darkv1]

didnt work,says same thing.i wonder if theres any other options

[provocating]

Are you just wanting to play ? If that is true and this is kicking your rear then why not just do something like these one click installs, or like maybe AX Classic who has a one click install ?

[Darkv1]

you mean i could have done that this whole time? -_-

[Darkv1]

there a link?

[Caryatis]

Here's a link (http://eqemulator.org/forums/search.php)

[Darkv1]

thats just the forum search

[provocating]

Sure you can do the AX Classic server and such but you learn a lot through trouble-shooting and doing it yourself going this route.

http://www.axclassic.com/

http://axclassic.com/links/axclassic224a

[Darkv1]

so how does this work exactly?

[provocating]

Dude read the instructions.