Completely stumped and would appreciate any help

[Magick]

For the life of me I haven't been able to get EQEmu to work... period. And this extends back to months before I even registered on the site. Lately I've been more pressed to try to get it to work and I'm coming up empty-handed. Hopefully one of you fine folks can spot a problem I am missing.

There are a few things to note before I get into the specifics of potential problems:

1. I'm trying to run a server locally... no luck thus far (1017)
2. I've tried running the server using the eqemu login servers... no luck (1017)
3. I can't even connect to another hosted server without a 1017.

Also note that the following information has been adjusted every which way but loose. So if your suggestion is to change an IP address here or there, could you please also say "why" you think that may fix it. I've done 127.0.0.1's, localhosts, my actual IP, a domain registered to my IP and internal IP's (which is what the following is of) and nothing seems to work.

Now for the info....

OS: Win XP SP1
RAM: 768megs ECC Rambus
CPU: 1.7GHz P4
EMU: EQEmu 0.4.4-DR1
DB: Telmet DB Addon
EQ Client: Use Patcher (est. 01/04/03)

In my latest try, Computer #1 in running an internal IP of 192.168.0.5 and is runs Minilogin.exe and eqgame.exe (by the way, it doesn't work with minilogin on Comp #2 either). Computer #2 (Win98 SE / P3 750 / 192megs) is hosting World.exe as well as the zones. It runs on an internal IP of 192.168.0.79. Both systems connected with a Linksys workgroup hub. No firewall is running on either system and all ports are accessible between the two.

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 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=192.168.0.5 (Computer 1 IP)
loginserver2=192.168.0.5
loginport=5999
loginport2=5999
worldname=EqTest
worldaddress=192.168.0.79 (Computer 2 IP)
locked=false
account=
password=

[WorldServer]
Defaultstatus=
Unavailzone=

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

MINILOGINACCOUNTS.INI

# Max 200 lines total (including comments and blank lines)
# Blank lines may mess up the line # reported in error messages

127.0.0.1 eqemu eqemu
192.168.0.79 eqemu eqemu
192.168.0.5 eqemu eqemu

I've seen various posts. Some say this file is still needed, others say the database should be handling it. /shrug I used it just in case and used any possible IP it might see eqgame.exe as coming from.

DB.INI

DB.INI

# READ README.TXT!

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

BOOT2ZONES.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_en.txt goto NOSPELL

start zone freportw 192.168.0.79 7995 localhost
start zone freportn 192.168.0.79 7996 localhost
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------------------------

I only booted 2 zones for my testing (hence the unusual *.bat name). Also, I did try using 127.0.0.1 as the second address in one testing. As you'll note later, the problem seems to occur before this could even present a problem.

WORLD.EXE

Loading Variables, zone names & items...
EMuShareMem.dll loaded.
Using database 'eq' at localhost
[Status] CURRENT_WORLD_VERSION:EQEMu 0.4.4-DR1
[Error] CURRENT_WORLD_VERSION:EQEMu 0.4.4-DR1
Loading Variables, zone names & items...
EMuShareMem.dll loaded.
Loading items from database...
...done.
LoginServer.ini read.
Loading guild ranks...done.
Loading EQ time of day..."./eqtime.cfg" is NOT a vaild EQTime file. File version
 is 0; EQTime version is 1000 - failed.
Deleted 1 stale player corpses from database.
Deleted -1 stale player backups from database.
You may already be a winner... of the darwin award.
TCP listening on: 192.168.0.79:9000
World server listening on: 192.168.0.79:9000
Connected to LoginServer: 192.168.0.5:5999
109140 New TCP connection: 127.0.0.1:1175
109140 New TCP connection: 127.0.0.1:1176
New zoneserver: #1 127.0.0.1:1176
New zoneserver: #2 127.0.0.1:1175
Zoneserver SetConnectInfo: 127.0.0.1:1175: 192.168.0.79:7996
Zoneserver SetZone: 192.168.0.79:7996 freportn (8) Static
Zoneserver SetConnectInfo: 127.0.0.1:1176: 192.168.0.79:7995
Zoneserver SetZone: 192.168.0.79:7995 freportw (9) Static

Looks good to me?

ZONE.EXE

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
Loading NPCTypes from database...
[Status] Loading npc faction lists
Loading NPC Faction Lists from database...
[Status] Loading loot tables
[Status] Loading doors
[Status] FileLoadSPDat() Loading spells from spells_en.txt
[Status] FileLoadSPDat() spells loaded: 3727
[Status] Loading guilds
[Status] Loading factions
[Status] Loading corpse timers
[Status] Loading what ever is left
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= 0
Petition 0 pettime = 0
-----------
Zone server 'freportw' listening on port:7995
-----------
[Status] Zone Bootup: freportw (9)
Default weather type for zone is 1
Weather changes in 3332 seconds. (weather is now 1)
Connected to worldserver: localhost:9000

And now, with comments, where it seems the problem lies - but why?

MINILOGIN.EXE


LoginServer.ini read.
MiniLoginAccounts.ini read.
Server mode: Standalone
Login server listening on port:5999
New TCP connection: 192.168.0.79:1177 **This is World.exe on Comp #2 connecting**
95317 New client from ip: 192.168.0.5 port: 3627 **This is eqgame.exe reaching server select**
Client disconnected (eqnc->GetState()=102) **The millisecond "Play EQ" is clicked**
Removing client from ip: 192.168.0.5, port: 3627
109007 New client from ip: 192.168.0.5 port: 3629 **eqgame kicked back to server with 1017 error**

Note that World.exe does not register a connection attempt. I've never got this working, but I was certain it DOES register a client connecting.

My hunch is that it may be a database problem. I've read virtually every post on this forum. I've done:

world adduser eqemu eqemu 200
- and I've manually done it in mysql after rebuilding the db -

I've seen suggestions on deleting the account with Admin Tools (did that), and I've seen suggestions on using Admin Tools to create the account (did that after deleting didn't work). I've also seen suggestions on changing the account number from 0 to 1. I tried that also.

Heck, it may not be a database issue at all? I am stumped. I want to say that if it were a database problem, World.exe would give a hint to a password or account problem, yet it seems like the problem never gets that deep into the chain. I've also considered that maybe minilogin and the client get scrambled being on the same IP but I get the same results if the login is on a different IP.


Any ideas??

[Magick]

Oh.. probably won't matter/help but I'm running version 3.23.56 of MySQL.

[grimbar]

I had this getstate() problem and my solution to this was to change lsaccount_id column in table Accounts to 0 for the account
I am trying to use.

Try it, maybe your are lucky.

[Magick]

Thanks for the tip Grimbar...

I played with it some more, changing the lsaccount_id to 0 (it was at 1) and that generated the same Client disconnected (eqnc->GetState()=102) message.

I also deleted all accounts in Admin Tools, let minilogin use the accounts.ini and attempted to log in... that also gave a Client disconnected (eqnc->GetState()=102).

I disabled the MiniLoginaccounts.ini one more time, remade an account in the database using world adduser <name> <pass> <priv> which generated a Server GM account. according to the command window.

The thing I find strange is that EQEmu Admin Tool 4.2 would not show that newly created account under "accounts" when I restarted it?? I've heard world no long worked for adding accounts, I guess this proves it. In any case, I decided to try it and same GetState() message followed by a disconnect.

I then created the same GM account in Admin Tools (assuming that world didn't actually create since Admin Tools isn't seeing it in the db) and set the lsaccount_id to 0. I then tried to connect. Yup, you guessed it.. more Client disconnected (eqnc->GetState()=102).

Last try... I delete ALL ACCOUNTS from the database (using MySQL) and I create (going according to another accounts tip I found):
INSERT INTO account SET name='eqemu', password='eqemu', status=200, lsaccount_id=0;
I try to log in and.... Client disconnected (eqnc->GetState()=102).

Now here's something that caught my eye, and perhaps it''s correct but it seemed strange:

LOGINSERVER:
Login server listening on port:5999
New TCP connection: 192.168.0.79:1177 **This is World.exe on Comp #2 connecting**
95317 New client from ip: 192.168.0.5 port: 3627 **This is eqgame.exe reaching server select**
Client disconnected (eqnc->GetState()=102) **The millisecond "Play EQ" is clicked**


It's listening on port 5999 yet when world.exe connects it lists port 1446 (Even though World says it's connected on 5999)? The Client connects and gets port 1458? Does this auto foward to a new port on each connection?

Any other ideas??

[tcsmyworld]

I run the Emu on my XP machine, I am able to log into it on the XP machine and all the other pc's on the LAN, they run win98 and win2k. If i try to run the server on any of the other machines , the XP machine can't log in, gets 1017 error.
It seems to me the 1017 error is mostly a winXP problem for clients , try running the server on your XP machine , and play from your win98 box.