Could an invalid db cause 1017 error? --- getting somewhere

[Astartae]

Hi. I set up EQemu as a mini server on my computer. I am using an XP. I don't have this set up on two different computers, just the one.

I had everything working. Got in the game just fine. Added some databases that added the npcs, books and items and got in again just fine. Played with EQ for awhile and had a load of fun.

Then I downloaded and sourced another database. After that I started getting the 1017 error and haven't been able to get back in the game.

The eqhost.txt, db.ini, LoginServer.ini and Boot5zones.bat are all set up as localhost. When I start the MiniLogin.exe, World.exe and Login.exe (Boot5zones.bat) they all seem to start fine.

It is just when I try to login to the world server that I am getting 1017 errors. I've read all the stickies and followed the suggestions that applied all to no avail. That's why I'm posting this now.

It seems odd that a db could cause this error but it's the only thing I changed. I've even tried deleting and reinstalling everything. Not even that worked.

I'll keep plucking away at this problem but if anyone has any ideas I'd appreciate hearing them.

- Astartae

[Merth]

Having a funky database can cause 1017 errors. Fortunately, these errors are usually spit out in the console of world.exe and you can analyze them.

Since your database is brand new with no essential user data in it, don't be shy about scrapping it and starting from scratch. drop database eq; is the SQL command to get rid of the database, and you can start over from there. I recall having to start over several times until I found a database script that worked.

However, you should be able to run just fine with db.sql by itself. This is just database structure with no world data. You'll have a lifeless world, but it should prove that the external mechanics of your setup are in order.

[Astartae]

Thanks, I'll try that. Crossing my fingers...

One other thing. I've got the following databases, do you know if any of these have problems?

Came with 4.4:
db.sql, books.sql, dbinstall.sql

Came with 4.4DR1:
db.sql, planesofpower.sql

Got seperately off this forum:
eq_044.sql, items.sql, books.sql, npcmov_alpha_0_0_3.sql, and worlddata1 (which has too many files to list here).

Thanks again.

[Astartae]

I've now tried deleting everything, even the my.ini for mysql, and starting from scratch. I don't know what I did to get this error but even after all this, following the install step by step, I can't get it to work. Ok, I'm off to play around with it again until I feel like banging my head into the keyboard..... or get it working.

[Astartae]

Well, I've gotten past the 1017 error finally. It seems that my files all had to have 127.0.0.1 instead of local host. I had changed all my files to that local ip number, except db.ini, and it still had the error. Finally I changed the db.ini to 127.0.0.1 and I got in.

But now I'm getting a zone not up error when I try to get past the char creation screen. Oh well. At least I'm closer to playing again. Lol.

[Memener]

how many zones are you running and some zones dont work try make a DE toll catperson wool elf try them all and see and see if you get the same error now if one of your zones crashes with the nice windows 98 error >this progrem has.... or if you get thw windows lovely error > send bug report.... then you have something wrong in your database.

[Astartae]

I'm running the default 5zones bat file with host as 127.0.0.1, so five zones even though I probably only need one. My problem now does indeed seem to be database involved. I've discovered that if I source just the default database from 4.4 (not dr1) I can get into the empty version of the eq world. Once I start adding other databases, I start having problems.

My problem now isn't that I get a zone not found error but that I get dropped back to the server screen after I select my char and try entering the world.

Here are snippets from my world and zone exe's:

world.exe:
Logged in: Local: eqemu
Sending list of guilds
Unknown opcode: 0x3451 size:2056
Unknown opcode: 0x3941 size:2056
error: InflatePacket: inflate<> -3 'unknown compression method'
Packet contents: Astartaelon
Attempting autobootup of gfaydark (54) for Astartaelon
Zoneserver SetAone: 127.0.0.1:7995 gfaydark (54)
Client disconnected

zone.exe:
[Status] 177305 New client from ip:127.0.0.1 port:2227
[Error] HandlePacket<> Opcode error: Unexpected packet during CLIENT_CONNECTING2: opcode: 0xe841, size:4

that error was repeated 19 times, then:
Client linkdead: No name
Client disconnected <cs=d>: No name

I'm going to try sourcing each database one at a time and try logging in after each one and see if that will point to the problem. But if I'm looking in the wrong direction feel free to let me know.

(God to top everything off I've got a horrible toothache, argh - makes concentrating right now really interesting - lol)

[Astartae]

Ok, I sourced the databaes db.sql from 4.4 (not dr1), boats.sql, books.sql, and items.sql. I've got loaded into an empty world with items on me, lol. Now I need to find out what npc database is giving me a problem. I currently have eq_044.sql, npcmov_alpha.sql and worlddata1. Does anyone happen to know if one of these works better than the others? I've tried the first two so I'm going to try the worlddata1 and see what happens. I'll post the results later.

[Astartae]

Final Update:

I got everything workinig! Yeah!

It seems that npcmov_alpha.sql and eq_044.sql databases don't work for me. I installed the worlddata1 set, using reloaddb.sql, and got everything working fine for me.

Also, if you don't want to lose your start items, edit the reloaddb.sql and delete all references to starting items (two lines).

I sourced databases in this order: db.sql, boats.sql, books.sql, items.sql, and finally reloaddb.sql (from worlddata1).

That's what worked for me. I hope this helps others with similair problems. Thanks for the help guys!