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:07 PM

Ohh with the world.exe error right?

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

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

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

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

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

Okay, so all is working ?

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

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 · #15 04-12-2011, 11:15 PM

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.

Code:

/*
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 
-- ----------------------------