EQEmulator Forums

EQEmulator Forums (https://www.eqemulator.org/forums/index.php)
-   Archive::Windows Servers (https://www.eqemulator.org/forums/forumdisplay.php?f=617)
-   -   New Server Problem (https://www.eqemulator.org/forums/showthread.php?t=15444)

Cari_Moon 08-21-2004 04:44 AM
New Server Problem
 
I can get all the way to the Character Select screen. I can even create a character. but when I try to login with any character it says Zone is unavailable.

*Note: 99.99.999.999 is not my real ip address it is just a example ip address.*


This is my World.exe output:

[Status] CURRENT_WORLD_VERSION:EQEMu 0.5.7-DR6
[Status] Loading variables..
[Status] Loading zones..
[Status] Loading items..
[Status] EMuShareMem loaded
[Status] Loading items from database: count=28731, max id=69304
[Status] ./LoginServer.ini read.
[Status] Loading guild ranks..
[Status] Loading ./addon.ini..
[Status] Loading EQ time of day..
[Error] Could not load EQTime file ./eqtime.cfg
[Error] Unable to load ./eqtime.cfg
[Status] Deleted 0 stale player corpses from database
[Status] Deleted 0 stale player backups from database
You may already be a winner... of the darwin award.
TCP listening on: 99.99.999.999:9000
World server listening on: 99.99.999.999:9000
Connected to LoginServer: eqemulator.net:5995

my loginserver.ini:

### --- This file tells world.exe what loginserver to connect to.
### --- Leave the account and password field BLANK.

### --- Public Login is un-supported as is LAN playing. We recommend using the eqemulator.net Loginserver ALWAYS.

### --- NOTE: You can NOT use the word 'Server' in worldname.
### --- NOTE2: the word 'Server' is added to each server automatically.

### --- READ README.TXT
[LoginServer]
loginserver=eqemulator.net
loginport=5995
worldname=red dragon brigade's
worldaddress=99.99.999.999
locked=False

[WorldServer]
Defaultstatus=0
Unavailzone=

[LoginConfig]
ServerMode=Standalone
ServerPort=5999
UplinkAddress=
UplinkPort=
UplinkAccount=
UplinkPassword=

[ChatChannelServer]
server=localhost

this is my db.ini:

# READ README.TXT!

[Database]
host=localhost
user=username
password=password
Database=eq
compression=off

### --- This file tells world.exe what computer mySQL is on. Host should
### --- be left 'localhost' unless mysql is on a differant computer than world.exe.

this is my boot5zones.bat:

REM: ****Read this first!!!****

REM: This file requires your real IP in the place of 'YourIP' when you are connecting
REM: To the EQEmu Loginserver.

REM: When you are using minilogin, Replace all IP Addresses to say 127.0.0.1

REM: If you still get errors try using localhost instead of 127.0.0.1

REM:--------------Start-----------------------
@echo off

if NOT exist spells_us.txt goto NOSPELL

start zone . 99.99.999.999 7995 127.0.0.1
start zone . 99.99.999.999 7996 127.0.0.1
start zone . 99.99.999.999 7997 127.0.0.1
start zone . 99.99.999.999 7998 127.0.0.1
start zone . 99.99.999.999 7999 127.0.0.1
exit
cls

:NOSPELL
echo You did not copy the spells_us.txt from your everquest directory to this one. Please do so or zones will crash on startup.
PAUSE

REM:---------------END------------------------

this is my boot5zones.bat output:

[Status] CURRENT_ZONE_VERSION: EQEMu 0.5.7-DR6
[Status] Loading Variables
[Status] Loading zone names
[Status] Loading items
[Status] EMuShareMem loaded
[Status] Loading npcs
[Status] Loading npc faction lists
[Status] Loading loot tables
[Status] Loading doors
[Status] FileLoadSPDat() Loading spells from ./spells_us.txt
[Status] FileLoadSPDat() spells loaded: 5583
[Status] Loading guilds
[Status] Loading factions
[Status] Loading corpse timers
[Status] Loading what ever is left
[Status] Loading commands
[Status] 165 commands loaded
[Status] Entering sleep mode
Connected to worldserver: 127.0.0.1:9000

Cisyouc 08-21-2004 06:04 AM
If you are running the server on the same comp as the EQ box it will take a minute for the zone to boot up. Just continue hitting Enter World and it should work eventually.

Darkwaters 08-21-2004 07:27 AM
Re: New Server Problem
 
Quote:
Originally Posted by Cari_Moon
I can get all the way to the Character Select screen. I can even create a character. but when I try to login with any character it says Zone is unavailable.

This is my World.exe output:

[Status] Loading items from database: count=28731, max id=69304
I hate to be the one to point this out. You have not finished your database sourcing as the instructions metioned. You will notice that your world.exe output says that you've loaded count=28,731 items. Well that means your only using MW_57DR2_alpha1 at the moment as far as items.
But it also means you've propably not added the following sql files and commands.
Code:
itemtablechanges.sql
MW_ZONEPATCH.sql
loot_update.sql
npc_types_update.sql
loottable_entries SET probability = '15'
newFactionList.sql
add_factions.sql
npc_faction_update.sql
ALTER TABLE `npc_types` ADD `AC` smallint(5) not null default 0
UPDATE npc_types SET AC=(((level*level)/1.75)+15) where AC=0
UPDATE variables SET value=0 WHERE varname='PersistentZoneState'
UPDATE variables SET value=0 WHERE varname='MerchantsKeepItems'
UPDATE variables SET value=0 WHERE varname='holdzones'
*** Added unknown008 column in 'items' with value 1
Just a hunch but I definitely found issues logging in since it was posted that the MW_57DR2_alpha_1.sql file had corrupt or missing zone data which is why the post mentioned somewhere on this site to go to a page and add them in. I'll have to search it after my morning coffee and see which post it was, but I'm betting with 10:1 odds that this is why.
Darkwaters

Darkwaters 08-21-2004 07:37 AM
Hey just curious have you patched to live recently and if so have you patched with S2K's patcher? Search the forum for it because its about as much as I feel comfortable posting if you did patch to live.
Darkwaters

Cisyouc 08-21-2004 11:03 AM
Re: New Server Problem
 
Quote:
Originally Posted by Darkwaters
Quote:
Originally Posted by Cari_Moon
I can get all the way to the Character Select screen. I can even create a character. but when I try to login with any character it says Zone is unavailable.

This is my World.exe output:

[Status] Loading items from database: count=28731, max id=69304
I hate to be the one to point this out. You have not finished your database sourcing as the instructions metioned. You will notice that your world.exe output says that you've loaded count=28,731 items. Well that means your only using MW_57DR2_alpha1 at the moment as far as items.
But it also means you've propably not added the following sql files and commands.
Code:
itemtablechanges.sql
MW_ZONEPATCH.sql
loot_update.sql
npc_types_update.sql
loottable_entries SET probability = '15'
newFactionList.sql
add_factions.sql
npc_faction_update.sql
ALTER TABLE `npc_types` ADD `AC` smallint(5) not null default 0
UPDATE npc_types SET AC=(((level*level)/1.75)+15) where AC=0
UPDATE variables SET value=0 WHERE varname='PersistentZoneState'
UPDATE variables SET value=0 WHERE varname='MerchantsKeepItems'
UPDATE variables SET value=0 WHERE varname='holdzones'
*** Added unknown008 column in 'items' with value 1
Just a hunch but I definitely found issues logging in since it was posted that the MW_57DR2_alpha_1.sql file had corrupt or missing zone data which is why the post mentioned somewhere on this site to go to a page and add them in. I'll have to search it after my morning coffee and see which post it was, but I'm betting with 10:1 odds that this is why.
Darkwaters
You don't need a full item db to run EQEMu, heck all you need is zone, character_ and account (and a portion of variables but that comes with peq) to login I believe.

-edit- Err, if it was just the MW_57DR2_Alpha_1 you would not see that message you'd see something like this:
http://members.shaw.ca/aceed/Myradbsourcecmd.jpg


All times are GMT -4. The time now is 03:28 AM.

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