Zone Errors HELP!!!

[TenabrousGM]

Ok Im new to this whole thing but work with me. Ok I've got my server set up so i can see it on the Eqemu Servers list everything seems to be right but im still getting errors Jezzbel has been helping me but we just run into a new problem each time.

Ok here are the errors and my Eqemu .bats,.exe's...ect

db.ini looks like this

# READ README.TXT!

[Database]
host=127.0.0.1
user=supermicclick
password=akvivi
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.

Here's Login Server

# READ README.TXT
[LoginServer]
loginserver=eqlogin1.eqemulator.net
loginserver2=eqlogin2.eqemulator.net
loginserver3=eqlogin3.eqemulator.net
loginport=5997
loginport=5997
loginport=5997
worldname=Rathe Mountain Test
worldaddress=68.3.182.184
locked=false

[WorldServer]
Defaultstatus=0
Unavailzone=

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

[ChatChannelServer]
ChatChannelServer=192.168.1.101

Boot5zones.bat
(note i have 10 zones running)

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 . 68.3.182.184 7990 192.168.1.101
start zone . 68.3.182.184 7991 192.168.1.101
start zone . 68.3.182.184 7992 192.168.1.101
start zone . 68.3.182.184 7993 192.168.1.101
start zone . 68.3.182.184 7994 192.168.1.101
start zone . 68.3.182.184 7995 192.168.1.101
start zone . 68.3.182.184 7996 192.168.1.101
start zone . 68.3.182.184 7997 192.168.1.101
start zone . 68.3.182.184 7998 192.168.1.101
start zone . 68.3.182.184 7999 192.168.1.101
exit
cls

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

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

And Here's the output

World.exe

[Status] CURRENT_WORLD_VERSION:EQEMu 0.5.3-DR3
[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
Breaking bards...done
TCP listening on: 68.3.182.184:9000
World server listening on: 68.3.182.184:9000
Connected to LoginServer: eqlogin2.eqemulator.net:5997


5zone.bat

[Status] CURRENT_ZONE_VERSION: EQEMu 0.5.3-DR3
[Status] Loading Variables
[Status] Loading zone names
[Status] Loading items
[Status] EMuShareMem loaded
[Status] Loading npcs
[Status] Loading NPCTypes from database...
[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] Loading guilds
[Status] Loading factions
[Status] Loading corpse timers
[Status] Loading what ever is left
[Status] Loading commands
[Status] 153 commands loaded
WorldServer connect: Connecting to the server failed: TCPConnection::Connect():
connect() failed. Error: 10060
[Error] worldserver.Connect() FAILED!
[Status] Entering sleep mode

My server shows up on the list like this but when i try to log in unlock it and well just log on I get the 1017 error.... Any help is appreciated

[samandhi]

If you are patched from the 18th of Feb, you will NOT be able to log into this server. The server version 0.5.3 was broken by that patch and later ones..

[TenabrousGM]

I have the Feb 20th update is that what you meant?

[TenabrousGM]

Ok wait dua and later ones....hehe so how can i fix this?

[samandhi]

Yes, you will NOT be able to log into your 0.5.3 server from the 10th of Feb on, the onely compatible server version is 0.5.5 DR 1

[TenabrousGM]

So If i pop 0.5.5 DR 1 into my eq database in MySqL will it be ok or do i need to remove the old files?

[TenabrousGM]

Well i Replaced World.exe, and Zone.exe of the old bins with the new ones and now the same error is coming up in the zones

This is what it looks like now

[Status] Using database 'eq' at 127.0.0.1
[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 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
WorldServer connect: Connecting to the server failed: TCPConnection::Connect():
connect() failed. Error: 10060
[Error] worldserver.Connect() FAILED!
[Status] Entering sleep mode

[Jezebell]

Here is one problem:

loginport=5997
loginport=5997
loginport=5997

needs to be:

loginport=5997
loginport2=5997
loginport3=5997

Secondly:

worldaddress=68.3.182.184

needs to be:

worldaddress=192.168.1.101

[TenabrousGM]

Ok thats all fixed thx Jezz now that, that stuff is all right, my server is unlocked but im geting the 1017 error in world.exe i get this....

[Status] Using database 'eq' at 127.0.0.1
[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
Breaking bards...done
TCP listening on: 192.168.1.101:9000
World server listening on: 192.168.1.101:9000
Connected to LoginServer: eqlogin2.eqemulator.net:5997
39887 New TCP connection: 192.168.1.101:3142
39887 New TCP connection: 192.168.1.101:3145
39887 New TCP connection: 192.168.1.101:3144
39887 New TCP connection: 192.168.1.101:3151
39887 New TCP connection: 192.168.1.101:3146
New zoneserver: #1 192.168.1.101:3146
New zoneserver: #2 192.168.1.101:3151
New zoneserver: #3 192.168.1.101:3144
New zoneserver: #4 192.168.1.101:3145
New zoneserver: #5 192.168.1.101:3142
Zoneserver SetConnectInfo: 192.168.1.101:3142: 68.3.182.184:7999
Zoneserver SetConnectInfo: 192.168.1.101:3145: 68.3.182.184:7993
Zoneserver SetConnectInfo: 192.168.1.101:3144: 68.3.182.184:7995
Zoneserver SetConnectInfo: 192.168.1.101:3151: 68.3.182.184:7992
Zoneserver SetConnectInfo: 192.168.1.101:3146: 68.3.182.184:7996
40278 New TCP connection: 192.168.1.101:3147
40278 New TCP connection: 192.168.1.101:3143
40278 New TCP connection: 192.168.1.101:3148
40278 New TCP connection: 192.168.1.101:3149
40278 New TCP connection: 192.168.1.101:3150
New zoneserver: #6 192.168.1.101:3150
New zoneserver: #7 192.168.1.101:3149
New zoneserver: #8 192.168.1.101:3148
New zoneserver: #9 192.168.1.101:3143
New zoneserver: #10 192.168.1.101:3147
Zoneserver SetConnectInfo: 192.168.1.101:3147: 68.3.182.184:7991
Zoneserver SetConnectInfo: 192.168.1.101:3143: 68.3.182.184:7997
Zoneserver SetConnectInfo: 192.168.1.101:3148: 68.3.182.184:7990
Zoneserver SetConnectInfo: 192.168.1.101:3149: 68.3.182.184:7994
Zoneserver SetConnectInfo: 192.168.1.101:3150: 68.3.182.184:7998
106042 New client from ip: 192.168.1.101 port: 3152
Account Attempting to be created:TenabrousGM 0
Error in CreateAccount query 'INSERT INTO account SET name='TenabrousGM', status
=0, lsaccount_id=48767;' #1062: Duplicate entry 'TenabrousGM' for key 2
Error adding local account for LS login: 'TenabrousGM', duplicate name?
Bad/expired session key: ls#48767
Removing client from ip:192.168.1.101 port:3152
274224 New client from ip: 192.168.1.101 port: 3157
Account Attempting to be created:TenabrousGM 0
Error in CreateAccount query 'INSERT INTO account SET name='TenabrousGM', status
=0, lsaccount_id=48767;' #1062: Duplicate entry 'TenabrousGM' for key 2
Error adding local account for LS login: 'TenabrousGM', duplicate name?
Bad/expired session key: ls#48767
Removing client from ip:192.168.1.101 port:3157


I tryed it two times thats why it came up two times....

[Jezebell]

You need to delete your account in the database and then login again.

[TenabrousGM]

ok how?

lol

[Jezebell]

download this http://aleron.dl.sourceforge.net/sourceforge/eqemu/eqemu-admin-tool-5.2.zip

install it and go tot he accounts tab, highlight your account and click Delete

[TenabrousGM]

Ok now errors with Eq Admin!!! Could Not Locate all item icons...

Unable to connect to eq database at host 127.0.0.1

i changed all the info to what i thought was correct and am getting those errors.

[Jezebell]

Ok, try this

http://www.mysql-front.com

[TenabrousGM]

Have it...

[Jezebell]

ok, delete it in there

[nilar]

Looks like you have a router. This is a common cause of 1017. You need to forward the EQEmu ports. Check under tutorials and howtos: The Big LAN Book.

As for EqAdmin errors.... look in here. I posted it somewhere in that topic.

http://www.eqemulator.net/forums/viewtopic.php?t=13423

[Jezebell]

Hehe, he is not getting 1017 errors anymore Nilar. He is getting:

Account Attempting to be created:TenabrousGM 0
Error in CreateAccount query 'INSERT INTO account SET name='TenabrousGM', status
=0, lsaccount_id=48767;' #1062: Duplicate entry 'TenabrousGM' for key 2
Error adding local account for LS login: 'TenabrousGM', duplicate name?
Bad/expired session key: ls#48767

Its an account error in the db, he needs to delete it and log in so that EQEmu can create the account. Then he can change status and stuff after.

[nilar]

Also..

Secondly:

Code:
worldaddress=68.3.182.184


needs to be:

Code:
worldaddress=192.168.1.101


This is wrong. Your worldaddress needs to be 68.3.182.184 (your external IP) otherwise people won't be able to connect to your server. 192.168.1.101 is your internal IP (local IP) which other people wont be able to connect to.

So...

under loginserver.ini
worldaddress=68.3.182.184

and boot5zones.bat

start zone . 68.3.182.184 7995 192.168.1.101

Just for some info the worldaddress is the World Server that is connecting to the loginservers. The first IP in boot5zones.bat is the IP that tells the zone servers where to connect to the world.exe at. The second IP is the database location (which is 192.168.1.101 for you)

[Jezebell]

I have it set up like I told him and it works fine, people connect to my server with no problems.


****EDIT****

There is a slight possibility I have them backwards cause I am at work, but I am almost 100% sure I have it set up that way. Anyway even if I am mistaken, it is a simple thing to change to get it switched :)

[nilar]

Hmmm...weird. I've always set it up the other way. It even says so in your guide that thats how you set it up. :) But I guess thats fine if it works. Only thing is have other people been able to connect?