1017 error.. tried all fixes I found

[Archivis]

Been working on this for quite some time now... searched through MANY posts dealing with this problem, tried all suggestions I found, still not working... My file info is as follows:

db.ini

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

loginserver.ini

[LoginServer]
loginserver=eqlogin1.eqemulator.net
loginserver2=eqlogin2.eqemulator.net
loginserver3=eqlogin3.eqemulator.net
loginport=5997
loginport2=5997
loginport3=5997
worldname=Archivis' World
worldaddress=external ip
locked=false

boot5.exe

start zone . external ip 7995 internal ip
start zone . external ip 7996 internal ip
start zone . external ip 7997 internal ip
start zone . external ip 7998 internal ip
start zone . external ip 7999 internal ip
exit
cls

I get as far as the server select screen, when I try to log into my, or any other server, I get booted back to login screen. When I started out, everything was fine up till this point. Then I tried the fixes and my server is coming up as locked, even though as you can see from my file, it shouldn't be.

Yes all ip's are correct, edited them out for the post.

Using a linksys router, and yes I followed the guide for it, turned off my win xp fire wall.

All I can figure is that there must be more than one problem cause nothing is working. world.exe and boot5zones.exe both load up just fine with no errors.

Thanks in advance for any help/suggestions. At this point I'll try anything, even putting on a head dress and shaking a dead chicken at my computer...

Note: I tried the dead chicken all ready, all it did was get feathers everywhere, I dont suggest trying this...

[Derision]

Make sure you have:

[ChatChannelServer]
ChatChannelServer=127.0.0.1

at the end of your LoginServer.ini

If it still shows as locked, copy and paste the output of world.exe and one zone.exe process.

[Spike]

Using a linksys router... did you DMZ?

[Archivis]

still locked after adding said code to login.ini, here's the world and boot5 info:

World.exe

[Status] CURRENT_WORLD_VERSION:EQEMu 0.5.7-DR3
[Status] Loading variables..
[Status] Loading zones..
[Status] Loading items..
[Status] EMuShareMem loaded
[Status] Loading items from database: count=28731, max id=69304
[Error] DBLoadItems query 'SELECT charges,unknown002,unknown003,merchantprice,un
known005,unknown006,unknown007,itemclass,name,lore ,idfile,id,weight,norent,nodro
p,size,slots,cost,icon,unknown018,unknown019,unkno wn020,tradeskills,cr,dr,pr,mr,
fr,astr,asta,aagi,adex,acha,aint,awis,hp,mana,ac,d eity,skillmodvalue,skillmodtyp
e,banedmgrace,banedmgamt,banedmgbody,magic,casttim e2,hasteproclvl,reqlevel,bardt
ype,bardvalue,light,delay,reclevel,recskill,elemdm gtype,elemdmgamt,effecttype,ra
nge,damage,color,classes,races,unknown061,spellid, maxcharges,itemtype,material,s
ellrate,unknown067,casttime,unknown069,proc_rate_m od,focusid,combateffects,shiel
ding,stunresist,strikethrough,combatskill,combatsk illdmg,spellshield,avoidance,a
ccuracy,unknown081,factionmod1,factionmod2,faction mod3,factionmod4,factionamt1,f
actionamt2,factionamt3,factionamt4,charmfile,augty pe,augslot1type,augslot2type,a
ugslot3type,augslot4type,augslot5type,ldonpointthe me,ldonpointcost,ldonsold,bagt
ype,bagslots,bagsize,bagwr,booktype,unknown105,fil ename,banedmgamt2,augmentrestr
iction,loreflag,pendingloreflag,artifactflag,summo nedflag,tribute,gmflag,endur,d
otshielding,attackbonus,hpregen,manaregen,hasteper cent,damageshield,minstatus FR
OM items ORDER BY id', #1054: Unknown column 'charges' in 'field list'
Error: EMuShareMem: DLLLoadItems: !cbDBLoadItems
[Error] Error: Could not load item data. But ignoring
[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
HELP I WORK IN THE EQEMU SWEATSHOP, YOU'RE MY ONLY HOPE!
TCP listening on: 68.192.165.95:9000
World server listening on: 68.192.165.95:9000
Connected to LoginServer: eqlogin3.eqemulator.net:5997
97850 New client from ip: 192.168.1.1 port: 3985
[Error] Expecting OP_SendLoginInfo, got 250
Removing client from ip:192.168.1.1 port:3985

(Note here that I've run eqemu 3 times before now over the span of the emu's life, and as long as I can remember I've seen the item error and it's still worked fine so I'm not worried about that)

Boot5zones.exe

[Status] CURRENT_ZONE_VERSION: EQEMu 0.5.7-DR3
[Status] Loading Variables
[Status] Loading zone names
[Status] Loading items
[Status] EMuShareMem loaded
Error: EMuShareMem: DLLLoadItems: !ItemsMMF.IsLoaded() (timeout)
[Error] Loading items FAILED!
Failed. But ignoring error and going on...
[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] 161 commands loaded
[Status] Entering sleep mode
Connected to worldserver: 192.168.1.100:9000


Now these seem to be running and working fine in and of themselves. Knowing me I've missed some mundane detail (insert Office Space quote here) But after looking at this for so long I just can't put my finger on it, and having tried so many suggested fixes, I'm not even sure at this point what was changed and what wasn't. Hope someone out there can make more sense of this than I can atm.

[Derision]

Try sourcing itemtablechanges.sql that comes with the post 20th May source code from cvs.biosprite.net, that should add the fields you are missing.

[Archivis]

Spike,

Yes, I followed the linksys walk through, though it seems a bit out of date, I was able to find the DMZ and update it to 100 (being my IP end number) sadly, unless I missed something in translating the older screen shots into what linksys currently uses, it didn't work.

[Archivis]

Thanks Derision, downloading it now and going to give it a shot... I'll be back

[Derision]

You will probably still get a 1017

I use a linksys myself, to get it to work, I had to use my DNS name, not my external IP
in LoginServer.ini and boot5zones, i.e.

LoginServer.ini

loginserver=eqlogin1.eqemulator.net
loginserver2=eqlogin2.eqemulator.net
loginserver3=eqlogin3.eqemulator.net
loginserver4=eqlgin4.eqemulator.net
loginport=5997
worldname=Your Server Name
worldaddress=xyz.abc.co.uk
locked=false

boot5zones.bat

start zone . xyz.abc.co.uk 7995 192.168.1.100
start zone . xyz.abc.co.uk 7996 192.168.1.100
start zone . xyz.abc.co.uk 7997 192.168.1.100

And finally, in c:\windows\system32\drivers\etc\hosts on the PC I use to connect to my server (both PCs are on my local LAN behind the same router)

I had to add

192.168.1.100 xyz.abc.co.uk

One final thing to note, the server you are creating is version 5.7DR3. You cannot connect to this if your EQ client is patched up to live.

[Archivis]

Interesting... I tried to source it and got this error:

mysql> source itemtablechanges.sql;
ERROR 1146: Table 'mysql.items' doesn't exist
ERROR 1146: Table 'mysql.items' doesn't exist
ERROR 1146: Table 'mysql.items' doesn't exist
ERROR 1146: Table 'mysql.items' doesn't exist
ERROR 1146: Table 'mysql.items' doesn't exist
ERROR 1146: Table 'mysql.items' doesn't exist
ERROR 1146: Table 'mysql.items' doesn't exist
ERROR 1146: Table 'mysql.items' doesn't exist
ERROR 1146: Table 'mysql.items' doesn't exist
ERROR 1146: Table 'mysql.items' doesn't exist
ERROR 1146: Table 'mysql.items' doesn't exist
ERROR 1146: Table 'mysql.items' doesn't exist
ERROR 1146: Table 'mysql.items' doesn't exist
ERROR 1146: Table 'mysql.items' doesn't exist
ERROR 1146: Table 'mysql.items' doesn't exist
ERROR 1146: Table 'mysql.items' doesn't exist
ERROR 1146: Table 'mysql.items' doesn't exist
ERROR 1146: Table 'mysql.items' doesn't exist
ERROR 1146: Table 'mysql.items' doesn't exist
ERROR 1146: Table 'mysql.items' doesn't exist


I'll be the first person to admit, I don't know too much about sourcing these things, but I do understand how to do it. I dropped all the files from the archive you sent me to into the mysql bin folder and sourced from there, that's what I got.

[Derision]

You need to type

use eq ;

or use <whatever you called your eq db> ;

prior to

source itemtablechanges.sql

[Archivis]

doh! See mundane detail.... rofl, ok that fixed the server locked, but yes, still 1017 error... going to give myself a little break then try doing what you suggested, thanks again Derision

[Archivis]

by the by, where can I find my DNS name? lol N00B question I know... sorry in advance.

[Derision]

Originally Posted by Archivis

by the by, where can I find my DNS name? lol N00B question I know... sorry in advance.

I can logon to your server (Archivis' world) fine.

To get your dns name, in XP, go to a command prompt and type

nslookup <your external ip>

If your ISP uses DHCP, your external IP and dns name may change from time to time.

[Archivis]

Ok got the DNS, going to try that next... but if YOU can log on my server... shouldn't I be able to? logically speaking at least... lol

[Derision]

Originally Posted by Archivis

Ok got the DNS, going to try that next... but if YOU can log on my server... shouldn't I be able to? logically speaking at least... lol

Not necessarily, the problem you are seeing is very common (others can login but you can't) if you are behind a router and try to access your server via it's external rather than internal IP. The steps I outlined above should fix it (well they worked for me and several other people).