|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Support::Windows Servers Support forum for Windows EQEMu users. |
|
|
|
12-01-2004, 10:36 AM
|
Sarnak
|
|
Join Date: Nov 2004
Posts: 35
|
|
(Blank screen) after server list. full info help.
Now this has been a bumpy ride.
Problem and clarified situation.
Error : Trying to access my server on the server list (EQemulator) screen goes black nothing happens. this has happened from 2 different home pc's and a friend in the USA.
Windows XP professional clean install.
Perl installed and working.
Mysql installed and working.
No visible errors when World exe is run.
Log
Code:
[Status] CURRENT_WORLD_VERSION:EQEMu 0.6.0-DR2
[Status] Loading variables..
[Status] Loading zones..
[Status] Clearing groups..
[Status] Loading items..
[Status] EMuShareMem loaded
[Status] Loading items from database: count=36965
[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
Warning: You need to get laid...
TCP listening on: edgeofmidnight.kicks-ass.net:9000
World server listening on: edgeofmidnight.kicks-ass.net:9000
Connected to LoginServer: newlogin1.eqemulator.net:5994
38297 New TCP connection: 10.0.0.3:1129
New zoneserver: #1 10.0.0.3:1129
Zoneserver SetConnectInfo: 10.0.0.3:1129: edgeofmidnight.kicks-ass.net:7999
38781 New TCP connection: 10.0.0.3:1130
38781 New TCP connection: 10.0.0.3:1131
38781 New TCP connection: 10.0.0.3:1132
New zoneserver: #2 10.0.0.3:1131
New zoneserver: #3 10.0.0.3:1130
38812 New TCP connection: 10.0.0.3:1133
New zoneserver: #4 10.0.0.3:1133
New zoneserver: #5 10.0.0.3:1132
Zoneserver SetConnectInfo: 10.0.0.3:1130: edgeofmidnight.kicks-ass.net:7996
Zoneserver SetConnectInfo: 10.0.0.3:1131: edgeofmidnight.kicks-ass.net:7995
Zoneserver SetConnectInfo: 10.0.0.3:1132: edgeofmidnight.kicks-ass.net:7998
Zoneserver SetConnectInfo: 10.0.0.3:1133: edgeofmidnight.kicks-ass.net:7997
Zone boot up looks fine too
Code:
[Status] CURRENT_ZONE_VERSION: EQEMu 0.6.0-DR2
[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: 6299
[Status] Loading guilds
[Status] Loading factions
[Status] Loading AA effects
[Status] Loading swarm spells
[Status] Loading tributes
[Status] Loading corpse timers
[Status] Loading what ever is left
[Status] Loading commands
[Status] 176 commands loaded
[Status] Loading embedded perl XS
[Quest] Loading perlemb plugins.
[Quest] Loading perl commands...
[Error] Starting command queue Mapping...
[Quest] Loading perlemb plugins.
[Quest] Loading perl commands...
[Status] Entering sleep mode
Connected to worldserver: 10.0.0.3:9000
Loginserver.ini (incase you can see an error.
Code:
### --- 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 reccomend using the EQEmu.net Loginserver ALWAYS.
### --- NOTE: Starting 6-1-2002, you can no longer use the word "Server" in worldname.
### --- NOTE2: the word "Server" is added to each server automaticly.
# READ README.TXT
[LoginServer]
loginserver=newlogin1.eqemulator.net
loginport=5994
worldname=Edge of insanity
worldaddress=edgeofmidnight.kicks-ass.net
locked=false
account=
password=
[WorldServer]
Defaultstatus=0
Unavailzone=
[ChatChannelServer]
worldshortname=
chataddress=
chatport=
Boot5zones.bat
Code:
REM: ****Read this first!!!****
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 . edgeofmidnight.kicks-ass.net 7995 10.0.0.3
start zone . edgeofmidnight.kicks-ass.net 7996 10.0.0.3
start zone . edgeofmidnight.kicks-ass.net 7997 10.0.0.3
start zone . edgeofmidnight.kicks-ass.net 7998 10.0.0.3
start zone . edgeofmidnight.kicks-ass.net 7999 10.0.0.3
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------------------------
My router config
Code:
11 7995 7995 TCP 10.0.0.3
12 7996 7996 TCP 10.0.0.3
13 7997 7997 TCP 10.0.0.3
14 7998 7998 TCP 10.0.0.3
15 7999 7999 TCP 10.0.0.3
16 9000 9000 TCP 10.0.0.3
Now for 4 mins I thought I had it working, I was just trying to log in again and it loaded I created a char logged into neriak, no npc's and when I zoned it went black screen and stayed that way.
but its not letting me now, the above is the furthest i've gotten.
|
|
|
|
12-01-2004, 10:42 AM
|
Sarnak
|
|
Join Date: Nov 2004
Posts: 35
|
|
I've been working on this from about 6am till 11pm only stopping for sleep and eat/cook/walk dog for 3 days
I've fixed my perl errors my scalar error, the mysql error
but now i'm stuck i've read everything I can.
I am desperate.
If someone can walk me through this or help me fix it i will be more than greatful.
its now 22:41pm gotta sleep.
|
12-01-2004, 11:31 AM
|
Developer
|
|
Join Date: Feb 2004
Location: UK
Posts: 1,540
|
|
Re: (Blank screen) after server list. full info help.
Quote:
Originally Posted by calranthe
My router config
Code:
11 7995 7995 TCP 10.0.0.3
12 7996 7996 TCP 10.0.0.3
13 7997 7997 TCP 10.0.0.3
14 7998 7998 TCP 10.0.0.3
15 7999 7999 TCP 10.0.0.3
16 9000 9000 TCP 10.0.0.3
|
I am assuming the 'TCP' parameter you have there is forwarding TCP ports. EQClient uses UDP, so if your router supports it, try forwarding both (though you say you got in once, so this has likely has nothing to do with your problem.
|
|
|
|
12-01-2004, 11:58 AM
|
Sarnak
|
|
Join Date: Nov 2004
Posts: 35
|
|
Re: (Blank screen) after server list. full info help.
Quote:
Originally Posted by Derision
Quote:
Originally Posted by calranthe
My router config
Code:
11 7995 7995 TCP 10.0.0.3
12 7996 7996 TCP 10.0.0.3
13 7997 7997 TCP 10.0.0.3
14 7998 7998 TCP 10.0.0.3
15 7999 7999 TCP 10.0.0.3
16 9000 9000 TCP 10.0.0.3
|
I am assuming the 'TCP' parameter you have there is forwarding TCP ports. EQClient uses UDP, so if your router supports it, try forwarding both (though you say you got in once, so this has likely has nothing to do with your problem.
|
Can anyone confirm which ports are TCP and which UDP
because as above "38297 New TCP connection: 10.0.0.3:1129 "
it looks for tcp.
okay okay definetly to bed with me or i will be facing a divorce lol.
i messed with some settings changed afew to UDP in my router
this is what i got
Code:
[Status] CURRENT_WORLD_VERSION:EQEMu 0.6.0-DR2
[Status] Loading variables..
[Status] Loading zones..
[Status] Clearing groups..
[Status] Loading items..
[Status] EMuShareMem loaded
[Status] Loading items from database: count=36965
[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
Formatting drive C:
TCP listening on: edgeofmidnight.kicks-ass.net:9000
World server listening on: edgeofmidnight.kicks-ass.net:9000
Error: LoginServer::Connect: Resolving IP address: 'Unable to get the host name.
Error: 11004'
54344 New TCP connection: 10.0.0.3:1038
54344 New TCP connection: 10.0.0.3:1039
54344 New TCP connection: 10.0.0.3:1040
New zoneserver: #1 10.0.0.3:1039
New zoneserver: #2 10.0.0.3:1038
Zoneserver SetConnectInfo: 10.0.0.3:1038: edgeofmidnight.kicks-ass.net:7995
54453 New TCP connection: 10.0.0.3:1041
54453 New TCP connection: 10.0.0.3:1042
New zoneserver: #3 10.0.0.3:1042
New zoneserver: #4 10.0.0.3:1041
New zoneserver: #5 10.0.0.3:1040
Zoneserver SetConnectInfo: 10.0.0.3:1039: edgeofmidnight.kicks-ass.net:7998
Zoneserver SetConnectInfo: 10.0.0.3:1040: edgeofmidnight.kicks-ass.net:7996
Zoneserver SetConnectInfo: 10.0.0.3:1041: edgeofmidnight.kicks-ass.net:7999
Zoneserver SetConnectInfo: 10.0.0.3:1042: edgeofmidnight.kicks-ass.net:7997
Connected to LoginServer: newlogin1.eqemulator.net:5994
196515 New client from ip: 68.239.160.254 port: 3014
Account Attempting to be created:Anthony 0
Logged in: FirstLogin LS#35479: Anthony
207.36.180.194:5994: TCPConnection::RecvData(): Error: 10054
Client disconnected
Removing client from ip:68.239.160.254 port:3014
Error: LoginServer::Connect: 'TCPConnection::Connect(): connect() failed. Error:
10065'
Connected to LoginServer: newlogin1.eqemulator.net:5994
448094 New client from ip: 68.239.160.254 port: 3395
Logged in: FirstLogin LS#35479: Anthony
Received unknown opcode: 0x02eb size:0 bytes
552375 New client from ip: 68.44.222.95 port: 64565
Account Attempting to be created:karaluven 0
Logged in: FirstLogin LS#44698: karaluven
Received unknown opcode: 0x02eb size:0 bytes
Name approval request for:Caveroamer race:130 class:15
Character creation request from Anthony LS#35479 (68.239.160.254:3395) :
Name: Caveroamer
Race: 130 Class: 15 Gender: 0 Deity: 396 Start zone: 13
STR STA AGI DEX WIS INT CHA Total
100 95 95 70 80 65 70 575
Face: 0 Eye colors: 9 9
Hairstyle: 0 Haircolor: 255
Beard: 255 Beardcolor: 255
Validating char creation info...
Found 0 errors in character creation request
[Status] Start zone query: SELECT x,y,z,zone_id,bind_id FROM start_zones WHERE p
layer_choice=13 AND player_class=15 AND player_deity=396 AND player_race=130
[Status] Found starting location in start_zones
Current location: (null) 0.75, -112.38, -181.62
Bind location: (null) 0.75, -112.38, -181.62
Starting Items Query: SELECT itemid, item_charges FROM starting_items WHERE (rac
e = 130 or race = 0) AND (class = 15 or class = 0) AND (deityid = 396 or deityid
=0) AND (zoneid = 155 or zoneid = 0) AND gm <= 0 ORDER BY id
Character creation successful: Caveroamer
Read group ID for 'Caveroamer': 0
0: 2C 30 2C 2E 43 61 76 65 - 72 6F 61 6D 65 72 2C 30 | ,0,.Caveroamer,0
16: 36 37 61 37 39 64 34 00 | 67a79d4.
Attempting autobootup of Qeynos (1) for Caveroamer
Zoneserver SetZone: edgeofmidnight.kicks-ass.net:7996 Qeynos (1)
Enter world: Caveroamer: Qeynos (1)
Zoneserver SetZone: edgeofmidnight.kicks-ass.net:7996 Qeynos (1)
Received unknown opcode: 0x0376 size:0 bytes
Name approval request for:Sweetie race:74 class:1
Character creation request from karaluven LS#44698 (68.44.222.95:64565) :
Name: Sweetie
Race: 330 Class: 1 Gender: 1 Deity: 208 Start zone: 6
STR STA AGI DEX WIS INT CHA Total
90 100 110 100 75 75 50 600
Face: 5 Eye colors: 8 8
Hairstyle: 255 Haircolor: 255
Beard: 255 Beardcolor: 255
Validating char creation info...
Found 0 errors in character creation request
[Status] Start zone query: SELECT x,y,z,zone_id,bind_id FROM start_zones WHERE p
layer_choice=6 AND player_class=1 AND player_deity=208 AND player_race=330
No start_zones entry in database, using defaults
Current location: gukta 0.00, 0.00, 0.00
Bind location: innothule 0.00, 0.00, 0.00
Starting Items Query: SELECT itemid, item_charges FROM starting_items WHERE (rac
e = 330 or race = 0) AND (class = 1 or class = 0) AND (deityid = 208 or deityid=
0) AND (zoneid = 52 or zoneid = 0) AND gm <= 0 ORDER BY id
Character creation successful: Sweetie
Read group ID for 'Sweetie': 0
0: 2C 30 2C 2E 53 77 65 65 - 74 69 65 2C 30 36 37 61 | ,0,.Sweetie,067a
16: 37 39 64 34 00 | 79d4.
Attempting autobootup of gukta (52) for Sweetie
Zoneserver SetZone: edgeofmidnight.kicks-ass.net:7999 gukta (52)
Enter world: Sweetie: gukta (52)
Zoneserver SetZone: edgeofmidnight.kicks-ass.net:7999 gukta (52)
Client disconnected
Removing client from ip:68.239.160.254 port:3395
Client disconnected
Removing client from ip:68.44.222.95 port:64565
|
|
|
|
12-01-2004, 11:59 AM
|
Sarnak
|
|
Join Date: Nov 2004
Posts: 35
|
|
oh btw the 207.36.180.194:5994: TCPConnection::RecvData(): Error: 10054 error is just when i reboot my router
|
|
|
|
12-01-2004, 06:43 PM
|
Sarnak
|
|
Join Date: Nov 2004
Posts: 35
|
|
Error I didn't notice last night.
At the same time as the above connection was happening and this leads me to believe it may not be a router problem
I've edited it down slightly to stip it been too big
Quote:
[Status] CURRENT_ZONE_VERSION: EQEMu 0.6.0-DR2
[Status] Loading Variables
[Status] Loading zone names
[Status] Loading items
[Status] EMuShareMem loaded
[Status] Loading npcs
[Status] Loading npc faction lists
[Status] Loading NPC Faction Lists from database...
[Status] Loading loot tables
[Status] Loading doors
[Status] Loading guilds
[Status] Loading factions
[Status] Loading AA effects
[Status] Loading swarm spells
[Status] Loading tributes
[Status] Loading corpse timers
[Status] Loading what ever is left
[Status] Loading commands
[Status] 176 commands loaded
[Status] Loading embedded perl XS
[Quest] Loading perlemb plugins.
[Quest] Loading perl commands...
[Error] Starting command queue Mapping...
[Quest] Loading perlemb plugins.
[Quest] Loading perl commands...
[Status] Entering sleep mode
Connected to worldserver: 10.0.0.3:9000
Map header: 26688 faces, 1176 nodes, 56225 facelists
Loaded map: 80064 vertices, 26688 faces
Map BB: (-877.19 -> 2041.69, -2974.91 -> 2763.34, -97.44 -> 805.50)
Map ./Maps/innothule.map loaded.
[Status] Weather should change in 11004 seconds
Error loading NPCs from database. Bad query.
Init: Loading zone lists, zone state or spawn list, player corpses, traps
, timezone data - Done. ZoneID = 46; Time Offset = 0
Successfully loaded Zone Config.
[Status] Loading Objects from DB...
[Status] Loading Ground Spawns from DB...
[Status] Loading doors for innothule ...
[Status] Done loading doors for innothule ...
[Status] Loading AA information...
[Status] Loading Merchant Lists...
[Status] Loading Temporary Merchant Lists...
Error in LoadTempMerchantData query 'select ml.npcid,ml.slot,ml.itemid,ml.charge
s from merchantlist_temp ml, npc_types nt, spawnentry se, spawn2 s2 where nt.id=
ml.npcid and nt.id=se.npcid and se.spawngroupid=s2.spawngroupid and s2.zone='inn
othule' group by ml.npcid,slot order by npcid,slot asc' #1146: Table 'eq.merchan
tlist_temp' doesn't exist
[Status] Zone Bootup: innothule (46)
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
(many many of this line)
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
[Status] 679219 New client from ip:68.44.222.95 port:64689
Read group ID for 'Sweetie': 0
Client linkdead: Sweetie
Dropping client: Process=false, ip=68.44.222.95, port=64689
[Status] Zone Shutdown: innothule (46)
|
|
|
|
|
|
|
|
12-02-2004, 08:26 AM
|
Hill Giant
|
|
Join Date: Dec 2003
Posts: 166
|
|
Quote:
Originally Posted by calranthe
Error loading NPCs from database. Bad query.
(many many of this line)
Error loading NPCs from database. Bad query.
|
That is probably happening because the server is having trouble reading from your npc_types table. If I remember correctly, it should not stop you from zoning in. Someone should probably add code to take out some redundant messages, al la syslog ("last message repeated 5 times").
For your testing purposes, this should be the query that the eqemu server is running on your DB that causes this error:
Code:
SELECT npc_types.id,npc_types.name,npc_types.level,
npc_types.race,npc_types.class,npc_types.hp,
npc_types.gender,npc_types.texture,npc_types.helmtexture,
npc_types.size,npc_types.loottable_id,
npc_types.merchant_id,npc_types.banish,npc_types.mindmg,
npc_types.maxdmg,npc_types.npcspecialattks,
npc_types.npc_spells_id,npc_types.d_meele_texture1,
npc_types.d_meele_texture2,npc_types.walkspeed,
npc_types.runspeed,npc_types.fixedz,
npc_types.hp_regen_rate,npc_types.mana_regen_rate,
npc_types.aggroradius,npc_types.bodytype,
npc_types.npc_faction_id,npc_types.face,
npc_types.see_invis,npc_types.see_invis_undead,
npc_types.lastname,npc_types.qglobal,npc_types.AC,npc_types.npc_aggro
FROM npc_types,spawn2 WHERE spawn2.zone='innothule'
AND npc_types.id=spawn2.id
|
|
|
|
12-02-2004, 09:18 AM
|
Sarnak
|
|
Join Date: Nov 2004
Posts: 35
|
|
All fixed thankyou for your help
|
Posting Rules
|
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
HTML code is Off
|
|
|
All times are GMT -4. The time now is 06:37 AM.
|
|
|
|
|
|
|
|
|
|
|
|
|