EQEmulator Forums
Page 1 of 3 1 23
Show 40 post(s) from this thread on one page

EQEmulator Forums (https://www.eqemulator.org/forums/index.php)
-   Support::Windows Servers (https://www.eqemulator.org/forums/forumdisplay.php?f=587)
-   -   Server Not Showing (https://www.eqemulator.org/forums/showthread.php?t=33316)

Darkv1 04-11-2011 11:56 PM
Server Not Showing
 
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 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 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 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 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 04-12-2011 10:55 PM
Quote:
Originally Posted by lerxst2112 (Post 198434)
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 04-12-2011 11:02 PM
You said you found an error, please post the error.

Darkv1 04-12-2011 11:04 PM
Quote:
Originally Posted by provocating (Post 198441)
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 04-12-2011 11:06 PM
No, I was referring to the original error you had in your log file.

Darkv1 04-12-2011 11:07 PM
Ohh with the world.exe error right?

provocating 04-12-2011 11:08 PM
World, Zone, whichever was giving you a missing SQL error.

Darkv1 04-12-2011 11:10 PM
ohh i fixed it all i did was dropped the peq database and reuploaded it.

provocating 04-12-2011 11:11 PM
Okay, so all is working ?

Darkv1 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 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
-- ----------------------------


All times are GMT -4. The time now is 01:45 AM.
Page 1 of 3 1 23
Show 40 post(s) from this thread on one page

Powered by vBulletin®, Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.