This may be a database problem but I'm not sure

[Robert Aught]

Hello

First, thanks for developing EQemu! I've spent the past couple of days pouring over all the info on your forums as I am setting up a server.

I can play on other people's servers (i.e. Scorpious 4.4dr1; Dark Assasin 4.4) but cannot on my own. I crash to desktop after creating/selecting a character on my server just prior to the character entering the zone from launch.

I can see this problem addressed in other posts but have yet to find a solution that works. I have a suspicion it's the UIFiles, but wouldn't know where to begin as I've been successful logging onto both 4.4 and 4.4dr1 servers. Also checking the UIErrors file and nothing shows up.

While running world I can see other people log in, create characters, interact with merchants and cast spells so it seems the server is working to some degree.

I have set up 4.4 and then 4.4dr1 on top of that with the world and the database item files from edward pinniger: http://forums.eqemu.net/viewtopic.php?t=8493&highlight=router+ports

My sql version is 4.0.13 as your readme asks to download the latest version, although your direct link points to 4.0.12 at least as of today.

Server: Windows 2000, p3 550 mHz, 128meg ram

Client: Windows 2000 with directx, p4 1.6gHz, 512meg ram

I am running a NAT router which has the server DMZ'd and zone ports as well as port 9000 are forwarded there. The server is protected by sygate personal firewall software which allows world traffic through. It's connected to a cable modem with 128 mbps upload.

The client is also on this router but doesn't have any special settings other than it gets its IP from the router's DHCP.

My server is connected to through your login server. LoginServer.ini:

[LoginServer]
loginserver=eqlogin1.eqemu.net
loginserver2=eqlogin2.eqemu.net
loginport=5999
loginport2=5999
worldname=08.ZIYA (testing)
worldaddress=24.42.150.*** (or whatever, it's not static)
locked=false
account=
password=

[WorldServer]
Defaultstatus=
Unavailzone=

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

Mysql seems to be running correctly, although I notice that occasionally I see a compression error - 3 scroll by in the world console screen.

To launch the client I use eqgame patchme from a duplicate EQ folder and the last patchdate for eqgame was December 5th 2002.

I understand that I am running a developer release although I see others running 44dr1 successfully.

Perhaps a clean install back to 4.4? I appreciate anyone's help.

[Muuss]

If other players can play on your server, mysql and your server look out of cause...
You could perhaps post more informations concerning the IP conf of your client... what expansions do u installed ? are running on your server ? try with the old interface ? try with different accounts ?
what messages are showing on the consoles when you log in/crash ?

i just try to give you a few ideas...

[Robert Aught]

If other players can play on your server, mysql and your server look out of cause...
You could perhaps post more informations concerning the IP conf of your client... what expansions do u installed ? are running on your server ? try with the old interface ? try with different accounts ?
what messages are showing on the consoles when you log in/crash ?

i just try to give you a few ideas...

My client uses the same NAT router, and cable modem connection as the server but as opposed to the server it is firewalled. However that doesn't stop me from logging onto other people's servers.

I have Kunark, Velious, Luclin and LoY installed.

Can the Dec 5 eqgame switch to the old interface? If so, how would I revert? it's been so long, can't remember.

Running client on a separate computer than server (the specs on both are in the first post).

Here are the messages from the zone console:

Using database 'eq' at localhost
[Status] CURRENT_ZONE_VERSION: EQEMu 0.4.4-DR1
[Error] CURRENT_ZONE_VERSION: EQEMu 0.4.4-DR1
[Status] Loading Variables
[Status] Loading zone names
[Status] Loading items
EMuShareMem.dll 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] Entering sleep mode
Connected to worldserver: 192.168.123.***:9000
Init: Loading zone lists, zone state or spawn list, player corpsesZonepoints loa
ded 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= -24
[Status] Loading Objects from DB...
send:
send:
send:
send:
send:
send:
send:
send:
send:
-----------
Zone server 'freportw' listening on port:7995
-----------
[Status] Zone Bootup: freportw (9)
Default weather type for zone is 1
Weather changes in 3538 seconds. (weather is now 1)
Received Message SyncWorldTime
Time Broadcast Packet: EQTime [03:20 pm]
[Status] 4495244 New client from ip:24.42.150.*** port:64731
Loaded playerprofile for Lalana - size: 8460/8460
Loaded alt_adv_table for Lalana - size: 258/258
Client linkdead: Lalana
Client disconnected (cs=d): Lalana
Dropping client: Process=false, ip=24.42.150.***, port=64731

---------------------------------------------------------------------

I tried to cut and paste from the world console as well but I keep getting the same zone data pasted. I'll probably have to shut all the consoles down and start them up again to cut and paste that info but the only error I see there is :

Error: InflatePacket: inflate() returned -3 'unknown compression method'

and then occasionally I get:

unknown opcode: 0x3541 size: 2056
Unknown opcode: 0x3941 size: 2056

and then sometimes that follows with a block of hex.

[Robert Aught]

I have isolated that this isn't likely router related as I've followed the steps from this post (great suggestion by the way if there may be a NAT router problem):

http://forums.eqemu.net/viewtopic.php?t=4177

and changed my client's system32/etc/hosts file to point to an internal IP. I get to my character selection screen so it sees the server but then crash on zone loading.

So if I can log onto other people's servers is it safe to assume the problem is likely with my server set up and not with the client?

[Bigpull]

Your almost there, now make sure you use the overidden hostname for your worldaddress and the first ip entry for the zone servers

worldaddress=my.host.foo
and
zone . my.host.foo 7995 localhost

[Robert Aught]

Your almost there, now make sure you use the overidden hostname for your worldaddress and the first ip entry for the zone servers

worldaddress=my.host.foo
and
zone . my.host.foo 7995 localhost

Thanks, it feels I'm almost there. I had already done those changes to the worldaddress= and the zone.bat so am stumped.

I'm going to revert back to a clean 4.4 install and start fresh with the database and see what that gets me.

I feel like I'm juggling jell-O.

[Bigpull]

In that case have a look at the dbg.txt in your client directory, make sure it's connecting to the right host ect there might be a crash message there also

[Robert Aught]

In that case have a look at the dbg.txt in your client directory, make sure it's connecting to the right host ect there might be a crash message there also

I never knew of this file before. There definitely is a crash message:

[Wed Jul 16 21:08:10 2003]00479:EnterZone complete.

[Wed Jul 16 21:08:10 2003]00480:ProcessGame. Beginning main loop.

[Wed Jul 16 21:08:12 2003]00481:Fatal Error Occurred in mainthread Code = c0000005 Addr = 77fcc1df

[Wed Jul 16 21:08:12 2003]00482:Process was trying to READ invalid data.

[Wed Jul 16 21:08:12 2003]00483:Invalid access occurred at virtual address 0x04cba8a0.

[Wed Jul 16 21:08:12 2003]00484:Fatal error occurred in mainthread! (#628)

[Wed Jul 16 21:08:12 2003]00485:Graphics DLL Loaded: Version 1.1.41 (DX8) Last Build Date: Nov 15 2002 14:22:52

[Wed Jul 16 21:08:12 2003]00486:Crash (char = Karan, zone = sharvahl)

[Wed Jul 16 21:08:12 2003]00487:Local Player's World location at time of crash: 0.000000, 550.000000, -104.000000.

[Wed Jul 16 21:08:12 2003]00488:Gamestate at crash = 253

[Wed Jul 16 21:08:12 2003]00489:1 processor(s) of type 586. Physical memory = 496 Megs.

[Wed Jul 16 21:08:12 2003]00490:INTEL 1597

------------------------------------------------------

So I guess is there something up with Zone.exe?

[Robert Aught]

I went and did a clean install of everything and reloaded the database and was able to log onto my server only once and never more, lol.

I'm feeling it's the database so I guess I'm going to start playing with eqadmin and getting acquainted.