EQEmulator Forums

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

Darkv1 04-12-2011 11:20 PM
Quote:
Originally Posted by provocating (Post 198450)
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
-- ----------------------------
Ok,when i insert it i get an error that says theres an error in the MYSQL syntax

provocating 04-12-2011 11:21 PM
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 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 04-12-2011 11:25 PM
Rocking.

Let us know how you like it.

Darkv1 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 04-12-2011 11:31 PM
Once all of your i's are dotted and your t's crossed, it will work.

Darkv1 04-12-2011 11:33 PM
err im missing so many sql files im gonna upload realllllyyyy quick xD

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

lerxst2112 04-13-2011 12:01 AM
Look at the zone log.

Darkv1 04-13-2011 12:03 AM
Quote:
Originally Posted by lerxst2112 (Post 198461)
Look at the zone log.
very sorry for my newbness but how might i do that? >.<

lerxst2112 04-13-2011 12:42 AM
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 04-13-2011 12:44 AM
i dont have it how do i make one?

lerxst2112 04-13-2011 02:02 AM
Quote:
Originally Posted by Darkv1 (Post 198467)
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 04-13-2011 02:04 AM
lol is there anything else besides that like codes and whatnot?

provocating 04-13-2011 08:20 AM
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 04-13-2011 09:11 AM
if you are using the newest peq database and yer having problems getting into the game once u make a character run this querry

Code:
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 04-13-2011 05:36 PM
didnt work,says same thing.i wonder if theres any other options

provocating 04-13-2011 05:40 PM
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 04-13-2011 05:50 PM
you mean i could have done that this whole time? -_-

Darkv1 04-13-2011 05:56 PM
there a link?

Caryatis 04-13-2011 06:31 PM
Here's a link

Darkv1 04-13-2011 06:38 PM
thats just the forum search

provocating 04-13-2011 07:51 PM
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 04-14-2011 12:02 AM
so how does this work exactly?

provocating 04-14-2011 08:08 AM
Dude read the instructions.


All times are GMT -4. The time now is 01:16 AM.

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