Zone server disconnect

[Sarkamen]

ok I can get into the char select screen but when I try to go into the zone it first said zone unavailable, then it crashed with a bunch of disconnected text over itself. When I boot the zones.bat they go to sleep.... are they supposed to?

[Windcatcher]

That's right, they go to sleep until the world server detects a player entering a zone. Then they tell the zone server which zone to boot up.

I'm sure other people can answer your questions far better than I, but one "gotcha" I found was router settings. I run behind a Linksys router/firewall, and I had to make sure that ports 7995-7999 (one for each of the zone servers) was being redirected to the IP of the PC running the server. If they're not, then the client will crash when you try to zone in. If you add more zone servers (like me -- I'm running ten at the moment) then you need to make sure that all the ports you use are being redirected (like 7990-7999 in my case).

WC

[Sarkamen]

ok thanks for the info, and I am pretty sure I am not behind a firewall. any help would be appreciated

[Sarkamen]

Ok, I am going to clarify alittle. I go to the char select screen and pick one of the 3 chars I made. and with all 3 when I try to enter I immediately get a something is not reoding and you have been disconnected text over itself. I am guessing thi means my zone servers arent connecting. This is on my own server by the way.

[nilar]

you need to post your loginserver.ini, boot5zones.bat, and world.exe and zones.bat output

[Sarkamen]

to post my boot5zones.bat I am guessing I need notepad which mine is corrupt I will try to associate it with wordpad, and I have tryed fixing this problem many times but Microsoft just screws me over.

[Sarkamen]

when I close the world and zones it has a odd memory error but it is system related and doesnt seem to effect anything as far as I can tell.
[LoginServer]
loginserver=127.0.0.1
loginport=5997
worldname=sarkamen eq
worldaddress=127.0.0.1
locked=false

[WorldServer]
Defaultstatus=0
Unavailzone=

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

[Status] Using database 'eq' at localhost
[Status] CURRENT_WORLD_VERSION:EQEMu 0.5.5-DR1
[Status] Loading variables..
[Status] Loading zones..
[Status] Loading items..
[Status] EMuShareMem loaded
[Status] Loading items from database: count=26701, max id=68199
[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] Reboot zone modes ON
[Status] Deleted 0 stale player corpses from database
[Status] Deleted 0 stale player backups from database
Please don't make me a levelme server. :(
TCP listening on: 127.0.0.1:9000
World server listening on: 127.0.0.1:9000
Connected to LoginServer: 127.0.0.1 :5997

[Status] Using database 'eq' at localhost
[Status] CURRENT_ZONE_VERSION: EQEMu 0.5.5-DR1
[Status] Loading Variables
[Status] Loading zone names
[Status] Loading items
[Status] EMuShareMem loaded
[Status] Loading npcs
[Status] Loading NPCTypes from database...
NPCs loaded - using old database format
[Status] Loading npc faction lists
[Status] Loading NPC Faction Lists from database...
[Status] Loading loot tables
[Status] Loading Loot tables from database...
[Status] Loading doors
[Status] Loading Doors from database...
[Status] FileLoadSPDat() Loading spells from ./spells_us.txt
[Status] FileLoadSPDat() spells loaded: 5002
[Status] Loading guilds
[Status] Loading factions
[Status] Loading corpse timers
[Status] Loading what ever is left
[Status] Loading commands
[Status] command_init(): Warning: Command 'help' defaulting to access level 0!
[Status] command_init(): Warning: Command 'version' defaulting to access level 0
!
[Status] command_init(): Warning: Command 'serversidename' defaulting to access
level 0!
[Status] command_init(): Warning: Command 'loc' defaulting to access level 0!
[Status] command_init(): Warning: Command 'flag' defaulting to access level 0!
[Status] command_init(): Warning: Command 'si' defaulting to access level 0!
[Status] 157 commands loaded
[Status] Entering sleep mode
Connected to worldserver: localhost:9000

hmm the end of my zone looks diffrent than normal, I will run it again to see if it does that again

[Jezebell]

It all looks fine to me, can you post your miniloginserver.ini and db.ini also?

[Sarkamen]

[Database]
host=localhost
user=sarkamen
password=thief
database=eq
compression=off

I dont know what you mean by miniloginserver.ini but here is the miniloginaccounts please clarify...
127.0.0.1 sarkamen thief

[Jezebell]

Sorry I am at work and forgot the name, lol, thats what I wanted. Everything looks fine, don't know what your problem could be :(

[Jezebell]

Actually I just noticed you posted the fresh World.exe and Zone.exe files, we need you to post the output of the files after you try to login and get the errors. Also you can try deletign your account from the database and logging in again.

[Sarkamen]

ok brb with that I just posted a little more info on nilars general support thread

[Sarkamen]

only the world server had any changes I have to leave for like 3 hours though and dont have time to read it but here it is
[Status] Using database 'eq' at localhost
[Status] CURRENT_WORLD_VERSION:EQEMu 0.5.5-DR1
[Status] Loading variables..
[Status] Loading zones..
[Status] Loading items..
[Status] EMuShareMem loaded
[Status] Loading items from database: count=26701, max id=68199
[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] Reboot zone modes ON
[Status] Deleted 0 stale player corpses from database
[Status] Deleted 0 stale player backups from database
Liberating a country that despises us...
TCP listening on: 127.0.0.1:9000
World server listening on: 127.0.0.1:9000
Connected to LoginServer: 127.0.0.1 :5997
5421 New TCP connection: 127.0.0.1:3625
New zoneserver: #1 127.0.0.1:3625
5453 New TCP connection: 127.0.0.1:3626
New zoneserver: #2 127.0.0.1:3626
Zoneserver SetConnectInfo: 127.0.0.1:3625: YourIP:7999
Zoneserver SetConnectInfo: 127.0.0.1:3626: YourIP:7996
5562 New TCP connection: 127.0.0.1:3627
5562 New TCP connection: 127.0.0.1:3628
5562 New TCP connection: 127.0.0.1:3629
New zoneserver: #3 127.0.0.1:3629
New zoneserver: #4 127.0.0.1:3628
New zoneserver: #5 127.0.0.1:3627
Zoneserver SetConnectInfo: 127.0.0.1:3627: YourIP:7995
Zoneserver SetConnectInfo: 127.0.0.1:3628: YourIP:7998
Zoneserver SetConnectInfo: 127.0.0.1:3629: YourIP:7997
37656 New client from ip: 127.0.0.1 port: 3632
Logged in: Local: eqemu
Received unknown opcode: 0x02ee size:0 bytes
Unable to get group id: #1054: Unknown column 'groupid' in 'field list'
Attempting autobootup of neriaka (40) for Drizzt
Zoneserver SetZone: YourIP:7995 neriaka (40)
Enter world: Drizzt: neriaka (40)
Broadcasting a world time update
Zoneserver SetZone: YourIP:7995 neriaka (40)
Client disconnected
Removing client from ip:127.0.0.1 port:3632
Zoneserver SetZone: YourIP:7995 (0)
Zoneserver SetZone: YourIP:7995 (0)

[nilar]

Hmm darn minilogin.... lol

I'm not real sure what to tell you. But if you wanted to make your server private (without having to fool with minilogin) all you would have to do is use the EqEmu login servers and set all of your IPs in loginserver and boot5zone to localhost and you would be the only one able to connect. Maybe this would fix the problem if you minilogin settings arn't right.

[Jezebell]

Zoneserver SetConnectInfo: 127.0.0.1:3625: YourIP:7999
Zoneserver SetConnectInfo: 127.0.0.1:3626: YourIP:7996

This is one problem....looks like your boot5zones.bat is not setup right. "YourIP" needs to be 127.0.0.1

[Sarkamen]

hmm any idea on how to take that last part off?

[Jezebell]

you need to edit it, since your notepad.exe is trashed try opening command prompt and typing edit

[Sarkamen]

hmm my ip is set to localhost and thanks for the tip i forgot about edit command I am just getting the hang of dos again. I will change it from localhost to 127.0.0.1 and see how it works

[Jezebell]

You don't need to do that, localhost and 127.0.0.1 are basically the same thing.


I don't think you understand what I am saying.

Inside your boot5zones.bat it should look like this

start zone . 127.0.0.1 7995 127.0.0.1

not like this:

start zone . 127.0.0.1 7995 YourIP

[Sarkamen]

ahah it looks like this your ip 7995 127.0.0.1 gonna try again thanks

[Sarkamen]

well now my problam matchs my thread title *sigh* thankfully what you said got me past the error messages to the load screen then it crashed and this is what the zone server said
[Status] Using database 'eq' at localhost
[Status] CURRENT_ZONE_VERSION: EQEMu 0.5.5-DR1
[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] Loading Doors from database...
[Status] Loading guilds
[Status] Loading factions
[Status] Loading corpse timers
[Status] Loading what ever is left
[Status] Loading commands
[Status] command_init(): Warning: Command 'help' defaulting to access level 0!
[Status] command_init(): Warning: Command 'version' defaulting to access level 0
!
[Status] command_init(): Warning: Command 'serversidename' defaulting to access
level 0!
[Status] command_init(): Warning: Command 'loc' defaulting to access level 0!
[Status] command_init(): Warning: Command 'flag' defaulting to access level 0!
[Status] command_init(): Warning: Command 'si' defaulting to access level 0!
[Status] 157 commands loaded
[Status] Entering sleep mode
Connected to worldserver: 127.0.0.1:9000
[Status] Weather should change in 3994 seconds
Init: Loading zone lists, zone state or spawn list, player corpses
Zonepoints loaded into memory
, timezone data - Done. ZoneID = 9; Time Offset = 0
Reading zhdr file './cfg/freportw.cfg'
Using database for safe coords.
Zone safe coords are x = 181; y = 335; z= -248
[Status] Loading Objects from DB...
[Status] Loading Ground Spawns from DB...
[Status] Loading doors for freportw ...
[Status] Done loading doors for freportw ...
[Status] Zone Bootup: freportw (9)
Received Message SyncWorldTime
Time Broadcast Packet: EQTime [10:08 am]
[Status] 191906 New client from ip:127.0.0.1 port:3272
Error in FinishConnState2(): !dbaq[1]->GetAnswer(): #1054: Unknown column 'revok
ed' in 'field list'
Client disconnected (cs=e): Sark
Dropping client: Process=false, ip=127.0.0.1, port=3272
[Status] Zone Shutdown: freportw (9)

[Jezebell]

that looks like a database error, looks like all your .ini and .exe files are ok now though. Sorry i don't know much about MySQL :)

Maybe someone else will post a possible solution to this, one thing you might try is to delete your "eq" database and recreate it again.

[Sarkamen]

*sigh* ok I will give it a try so all I need to do is repeat the steps of setting up a server but just the database right?
Or do I just need to recreate the mysql db that I made with the cmd line?

(Arg guess I will have to recreate my items, oh well)

[Jezebell]

Go into c:\mysql\data and delete the "eq" folder, then follow the steps here http://www.eqemulator.net/forums/viewtopic.php?t=13403 from where it says:

create database eq;

for creating the database

[Sarkamen]

sorry for asking so many questions but I know there are alot of Dbs out there to create the mysql one with which do you use?

[Jezebell]

This is the one I use.

http://mwnpcmovdb.myftp.org/MW055_alpha_02.zip

[Sarkamen]

now I am getting a 1017 error, I believe this is a problem with loading the db I just loaded but before I try loading the one you gave me maybe you could confirm it for me here is what happens that I believe causes the 1017 [Status] Using database 'eq' at localhost
[Status] CURRENT_WORLD_VERSION:EQEMu 0.5.5-DR1
[Status] Loading variables..
[Status] Loading zones..
[Status] Loading items..
[Status] EMuShareMem loaded
[Status] Loading items from database: count=26679, max id=68199
[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] Reboot zone modes ON
[Status] Deleted 0 stale player corpses from database
[Status] Deleted 0 stale player backups from database
Screwing up windows compiles...
TCP listening on: 127.0.0.1:9000
World server listening on: 127.0.0.1:9000
Connected to LoginServer: 127.0.0.1 :5997
4985 New TCP connection: 127.0.0.1:4006
New zoneserver: #1 127.0.0.1:4006
5047 New TCP connection: 127.0.0.1:4007
5047 New TCP connection: 127.0.0.1:4008
New zoneserver: #2 127.0.0.1:4008
New zoneserver: #3 127.0.0.1:4007
Zoneserver SetConnectInfo: 127.0.0.1:4006: 127.0.0.1:7996
Zoneserver SetConnectInfo: 127.0.0.1:4007: 127.0.0.1:7997
Zoneserver SetConnectInfo: 127.0.0.1:4008: 127.0.0.1:7995
5141 New TCP connection: 127.0.0.1:4009
5141 New TCP connection: 127.0.0.1:4010
New zoneserver: #4 127.0.0.1:4010
New zoneserver: #5 127.0.0.1:4009
Zoneserver SetConnectInfo: 127.0.0.1:4009: 127.0.0.1:7999
Zoneserver SetConnectInfo: 127.0.0.1:4010: 127.0.0.1:7998
39985 New client from ip: 127.0.0.1 port: 4013
Error in CheckLogin query 'SELECT id, status FROM account WHERE name='eqemu' AND
(password='eqemu' or password=MD5('eqemu'))' #1146: Table 'eq.account' doesn't
exist
127.0.0.1: Wrong name/pass: name='eqemu'
Removing client from ip:127.0.0.1 port:4013
error

[Jezebell]

I would try manually adding your account into the db if it is not in there and if it is then delete your account.

[Sarkamen]

um I wouldnt know how to do that so i am trying the Db you gave me, do you have any Idea where that thread is that lists the best Dbs for now? I am looking for 1 that has items on merchants and other such things, I know some servers have that and some dont does this one have that in it?

[nilar]

The one she gave you is the best one you will find at the moment

[Sarkamen]

hmm are you sure? ok the one I had was bigger i thought bigger was better lol but ok thanks hmm well trying this one didnt help with that anyway....I will try manully adding my account but I am not sure how to do it but I think I might.....be able to figure it out real quick.

[nilar]

Yep thats the best DB atm trust me.

As for adding your account manually. Go into 3rd Party Tools forum and download EQAdmin. It is a program used to edit databases and very easy to use. You can add your account from there.

[Sarkamen]

well I just got through adding it through my command line but, that prog sounds nice I will go grab it for the future, problem is I dont think it did anything after adding it.

[Sarkamen]

wee I must 'ave done something with that command line, or It might have been deleting the chars from the old account....doesnt matter to me never got to use em, but nilar I was wondering do you know if eqadmin has a tutorial it looks real nice and all but it doesnt seem to see my eq directory and I must be setting the preferences up wrong. but what i really wanted to ask was how you know jezebell is female lol thanks alot guys

[nilar]

Under FQadmin.ini

[GENERAL]
DBNAME=eq (assuming your databases name is eq)
DBHOST=localhost
DBUSERNAME=Mysqlusername
DBPASSWORD=Mysqlpassword
EQPATH=C:\Everquest (this is your everquest directory)
MAPSPATH=C:\EqEmu\icones
I got the icones folder from Sandy's Loot Editor. They were included. Download it here (http://www.eqemulator.net/forums/viewtopic.php?t=12851)


but what i really wanted to ask was how you know jezebell is female

Erm I was just assuming that jezebell is a female since it sounds more feminine than masculine, I guess i could be wrong :D

[Sarkamen]

yeah I guess the only thing i was missing was icons heh thanks

[RexChaos]

but what i really wanted to ask was how you know jezebell is female

Erm I was just assuming that jezebell is a female since it sounds more feminine than masculine, I guess i could be wrong :D

I would have thought so too...or maybe it's a character's name from EQ that a guy played or something (hehe)...
8)

[Jezebell]

Hehe, I will tell you the story:

I got a girlfriend and she was mad all the time that I was playing EQ so I let her create a char on my account to play and then she wanted to play more than me, lol. Anyway we broke up and I just kept playing the char as a main and it kinda just stuck lol. Thats pretty much it.

[nilar]

hmmmmm

Note to Self: Jezebell IS a he :D

[Sarkamen]

hehe I thought you were male,I can tell these things some times
"Doo-dad! Hee Hee Hee"
-Pikel Boulderstone

[samandhi]

Yep thats the best DB atm trust me. That is not totally true.. While it IS an awesome DB, there is another that deserves mention. They both have their strengths and weaknesses... The one I am referring to is Myra's DB. I actually use this one mroe than I use the MW, but I DO use them both (just not at the same time) If you want to experiment with other DB's you can just go to the world building forum and find the links to download them.... Below is a short guide to adding another DB without having to delete your old one (read switching db on the fly so you can use both if you like):

Make sure you have both DB's in your \mysql\bin folder.
open dos prompt.
Now you will use basically the same commands you used to create your db in the first place, but notice there is a dfferent name for the new one you create.
If you didnt already do this before using the *.* string, you may want to do this as it will grant access to ALL your db's you create without having to re-enter the grant command... Also <new db> is where you will type the name of the DB you will want to use, without the < and > keys.... :
cd c:\mysql\bin
GRANT ALL PRIVILEGES ON *.* TO <username>@localhost IDENTIFIED BY '<password>' WITH GRANT OPTION;
CREATE DATABASE <new db>;
USE <new db>;
source <name of new db to source in ie.. myradb.sql>;
quit

Now you will have two db's created, and when you want to use the new one with your server, just edit your db.ini file and tell it which one you want to use.... eq or the new one you just created .... rinse and repeat as necessary.... :) Hope this is useful....

[Sarkamen]

thanks, yeah that was the one I had before and I couldnt remeber where the thread was so things for leading me back to it. I will need t re dl it but thanks for the info, and this current db works pretty well. One Db that rocks is the one Dil uses if anyone happens to know what it is, its probably just custom but also how can I move my char between dbs? or will I need to do that? (dont want to take the time to think lol)