Server Connect, Client connected until... [Archive]

View Full Version : Server Connect, Client connected until...

Makwa

07-17-2006, 05:07 AM

I am using fresh install of Titanium (without live patch),
Using 0.7.0-833 config files.
Using Cavedudes DB.

I can connect to the server just fine.
I can login to server select screen, but when i pick enter world, it says zone unavailable (after doing it 10 times or so), and my client connected goes from 1 (me or course) to 0.

And in that screen i get this error:

unknown packet: .4233692 [92.153.64.0:15->0.0.0.0:0]
[opcode 0x0003 (OP_Unknown) Size=11]
00000: 00 06 00 00 00 00 00 00 - 00 00 00

Anyone know what this means, or the fix?

Thanks much.

Makwa

07-17-2006, 09:53 AM

When you do this serverpack, is it downloading the latest builds, and the latest DB? So, the builds are compatible with the appropriate DB's?

Makwa

07-17-2006, 05:37 PM

so, i have been messing around with some things, and i found one problem in the DB.

When i added message to the traps table, i was able to zone, and my AA's showed up.

I am sure most of you have already figured this out, but it helped my alot.

hope this helps someone.

Arag

07-18-2006, 01:40 PM

so you did get a disconect ( world.exe crash to when tryed to zone ?)
if so can u tel me how to fix it|?
already build 20x a new Db for it :(
im using eq Db now can u help?

Makwa

07-19-2006, 03:53 AM

I am able to connect, and zone ALOT better when i open the files manually.

I click on minilogin.exe, then world, then i have to open two or more zones manually, using cmd.exe then go into your eqemu folder, and type:
zone . 127.0.0.1 7995 127.0.0.1

Let that run. then do the same thing again.

zone . 127.0.0.0 7996 127.0.0.1

By doing this, i can see errors happening, if any. This is how i found the traps DB error. Like i said, i just added the message column in the traps table. Then that error went away.

Then run your eqemu everquest.

I sometimes still have to click enter world a few times before zone can catch up.

It's still really buggy. Drops me for no reason, etc. But i can connect and get into the game.

I am an ASP.NET Web Developer and i made a site locally that will query the database and pull out the best items in the database for my classes that i choose, and insert them into the Inventory table based on my character id.

This is much easier then looking up items in Allakhazam, then doing a search for the item in the game, then summoning the item.

Work in progress.

Arag

07-20-2006, 04:26 AM

thanks!
i wil try that.
im stil not sure where i can change the trap mesage in cc..

and the zone says this ..
and when i zone to a other zone it crashes my world.exe
may this can be the error?

Microsoft Windows XP [versie 5.1.2600]
(C) Copyright 1985-2001 Microsoft Corp.

C:\Documents and Settings\Computer>cd C:\EQEmu-0.7.0-828

C:\EQEmu-0.7.0-828>zone . 127.0.0.0 7996 127.0.0.1
[Status] Using database 'eq' at localhost:3306
[Status] EMuShareMem loaded
[Quest] Tying perl output to eqemu logs
[Quest] Creating EQEmuIO=HASH(0x36657dc)
[Quest] Creating EQEmuIO=HASH(0x3671d48)
[Quest] Loading perlemb plugins.
[Quest] Loading perl commands...
[Status] Booting paineel
Map header: 60895 faces, 730 nodes, 78670 facelists
Loaded map: 182685 vertices, 60895 faces
Map BB: (-1105.56 -> 951.63, -14.00 -> 1665.34, -783.69 -> 83.97)
Map ./Maps/paineel.map loaded.
Path File ./Maps/paineel.path not found. <--------------------------------
[Status] Weather should change in 6490 seconds
[Status] Loading spawn conditions...
[Status] Loading static zone points...
[Status] Loading spawn groups...
[Status] Loading spawn2 points...
[Status] Loading player corpses...
[Status] Loading traps...
[Status] Loading ground spawns...
[Status] Loading Ground Spawns from DB...
[Status] Loading World Objects from DB...
[Status] Loading Objects from DB...
[Status] Loading doors for paineel ...
[Status] Loading Doors from database...
[Status] Loading AA information...
[Status] Loading Merchant Lists...
[Status] Loading Temporary Merchant Lists...
[Status] Successfully loaded Zone Config.
[Status] Loading timezone data...
[Status] Init Finished: ZoneID = 75, Time Offset = 0
[Status] Zone Bootup: paineel (75)
Received Message SyncWorldTime
Time Broadcast Packet: EQTime [02:23 am]
[Error] HandlePacket() Opcode error: Unexpected packet during CLIENT_CONNECTING:
opcode: OP_Unknown (#0 eq=0x0000), size: 0 <-----------|

i searched the forum 4 it but stil cant find the answers :(

and btw <--- im stil a newb in this ;-)
thanks alot 4 the help!

Makwa

07-20-2006, 04:57 AM

No, that isnt the reason for the crash when zoning. Mine says the same. Both the path error and the OpCode error. But it still runs.

I have noticed that when there are errors in some of the tables, that when i zone, it will crash.

To add the message to the traps table do this:

Open up the control panel for the DB, and connect to the DB that your using ( i have 3 ) i am playing with.

Edit the traps table, and enter a new field. Name it message, and use varchar for the datatype. At the bottom in the Field Propertied tab, enter 100 for the length.

If you dont have a control center in dos do this.

1. Change to your mysql\bin directory.
2. mysql -u root peq <- - whatever your DB is named.
3. ALTER TABLE `traps` ADD `message` varchar(100);
4. exit
5. exit

There are a lot of things that can make you not zone. This is what i did to the DB to get going.

1. I started with the PEQ DB.
2. Made the traps change.
3. Went to the download section of the main page of eqemulator, and i went into each release and started from 0.7.0 and went into each one, and made all of the DB changes all the way up to the one at the top. Some are already done, some are not.

That got me running.

The first time that i run EQ and i select my server, it hangs at the connecting to the server. I control+alt+delete that and do it again. But the next time it goes into the game. I dont know why yet, but it works.

When i get to the character selection screen, it does take a few times for it to zone in.

There are a bunch of errors on the screen, saying i have been disconnected, but it will eventually log into the game.

I no longer have to go into dos and do the zone commands. It now lets me do the icon from cavedudes, which runs, minilogin, then world, then zones.

Honostly, it is really sad to see that people dont share their working databases. They start out with help from here, and someones DB, but dont share the wealth. They want you to play on their server. Then they make rules for you to play. That's sad.

Their are a lot of people out there, that have figured things out that can help everyone else. It's a game people.

Let me know where your at after all of this.

Makwa

Arag

07-20-2006, 05:23 AM

thanks alot i wil go to the download page and get all the mysql codes from the log til the last release..
i let you know if it works when ready.
thanks alot for your help!!

btw is there a way so i can use your Db ?
if so.
may you be so kind to share it with me
?

Much Respect for your help and intrest!

Makwa

07-20-2006, 05:31 AM

Absolutely you can have mine. I am all for sharing the wealth. Let me pack it, zip it, and i will email it to you. I have to check the size of the zip file after i do it though. If its too big to email, i will give you a link to the file on my website, and you can download it there.

Makwa

Arag

07-20-2006, 05:40 AM

cool! that wil help alot~!!
i have do the comands into mysql now it ony keep saying zone unavailebel :(
so i i keep doing thing wrong or something :(
i followed the wikki for the 7.0 step by step and befor i did all the comands the mini was working 25% hahahah ,
now i cant log in anny more so there is some thing not correct :(

may you can tell me how to instal your Db correctly when i downloaded it?

thx

btw i get this in zone.exe when i try to enter world

Path File ./Maps/freportw.path not found.
[Status] Weather should change in 6728 seconds
Error loading NPCs from database. Bad query: #1054: Unknown column 'npc_types.wa
lkspeed' in 'field list'
[Status] Loading spawn conditions...
[Status] Loading static zone points...
[Status] Loading spawn groups...
Error3 in PopulateZoneLists query 'SELECT spawnentry.spawngroupID, npcid, chance
, spawnentry.spawn_limit AS gsl, npc_types.spawn_limit AS sl FROM spawnentry, s
pawn2 LEFT JOIN npc_types ON spawnentry.npcID = npc_types.id WHERE spawnentry.sp
awngroupID=spawn2.spawngroupID AND zone='freportw' ORDER by chance' #1054: Unkno
wn column 'spawnentry.spawn_limit' in 'field list'
[Error] Loading spawn groups failed.
Zone->Init failed

Makwa

07-20-2006, 06:48 AM

That error means that you dont have spawnentry table in the database.

To use this new DB that i will give you, you just do this:

1. mysql -u root
2. create database eq < - - name it whatever you want.
3. use eq;
4. source db.sql;

Let it run all the way.

5. do the grant all privileges command.
6. do the insert into account (name, status, minilogin_ip) VALUES ('mini',250,'127.0.0.1');
Make sure that the minilogin_ip is what your using everywhere else.
name is the name of the login into Everquest.

Your DB is probably good, just needs a few tweaks.

If you want to try your DB first, source this in yours:

CREATE TABLE spawnentry (
spawngroupID int(11) NOT NULL default '0',
npcID int(11) NOT NULL default '0',
chance smallint(4) NOT NULL default '0',
PRIMARY KEY (spawngroupID,npcID)
) TYPE=MyISAM;

Or type that in dos, once your in mysql, using your db.

Let me know if that works any better.

Makwa

Makwa

07-20-2006, 06:53 AM

Can you post me the contents of your eqemu_config.xml file, and your loginserver.ini?

Thanks,

Makwa

Arag

07-20-2006, 07:34 AM

Can you post me the contents of your eqemu_config.xml file, and your loginserver.ini?

Thanks,

Makwa
sure il post them first and then create the Db
when you have it ready 4 me :D

login.ini
###Your current configuration is as follows:

loginserver.ini:
[LoginServer]
loginserver=127.0.0.1
loginport=5999
worldname=My Minilogin
worldaddress=127.0.0.1
locked=false
account=
password=

[WorldServer]
Defaultstatus=
Unavailzone=
[ChatChannelServer]

worldshortname=
chataddress=
chatport=

[LoginConfig]
ServerMode=Minilogin
ServerPort=5999

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

eqeum_config

<?xml version="1.0">
<server>
<world>
<shortname>minilogin</shortname>
<longname>My Minilogin</longname>


<address>127.0.0.1</address>
<localaddress>127.0.0.1</localaddress>


<loginserver>
<host>127.0.0.1</host>
<port>5999</port>
<account></account>
<password></password>
</loginserver>


<key>some long random string</key>


<http port="9080" enabled="true" mimefile="mime.types" />
</world>

<zones>
<defaultstatus>20</defaultstatus>


<ports low="7000" high="7100"/>
</zones>


<database>
<host>127.0.0.1</host>
<port>3306</port>
<username>eq</username>
<password>eq</password>
<db>eq</db>
</database>

<launcher>




</launcher>

<files>




</files>

<directories>



</directories>

Makwa

07-20-2006, 07:46 AM

I have my DB dumped, but it's 96MB. Way to big to email. Try creating that table in your first from my last post, see if that works at all.

If not, let me know. I will post my db on my site.

I will email you the path to the file to your email address in your profile here, when it is up.

Makwa

Arag

07-20-2006, 07:53 AM

i did the ( CREATE TABLE spawnentry (
spawngroupID int(11) NOT NULL default '0',
npcID int(11) NOT NULL default '0',
chance smallint(4) NOT NULL default '0',
PRIMARY KEY (spawngroupID,npcID)
) TYPE=MyISAM;

comand in myslq whil using my Db .
it did make the tabel but it keeps saying zone unavailabel ..
did send you a Pm with my mail in it

Makwa

07-20-2006, 08:10 AM

Ok, i sent you a PM.

Makwa

bushman77

07-22-2006, 04:48 PM

I''m running the default compile of 7.0 790 and using a 6.2 client. i'm hanging just after the login screen (and never gets to server select screen), although minilogin sees me trying to log in and says my client is connected. Also when i close everquest it spits out the following:

Unknown packet: .4233692 [92.153.64.0:15->0.0.0.0:0]
[OpCode 0x0003 (OP_Unknown) Size=11]
00000: 00 02 00 00 00 00 00 00 - 00 00 00 | ...........

i'm using the opcode.conf that came packed with the minilogin that was supplied with.

#Login opcodes
OP_SessionReady=0x0001
OP_Login=0x0002
OP_ServerListRequest=0x0004
OP_PlayEverquestRequest=0x000d
OP_PlayEverquestResponse=0x0021
OP_ChatMessage=0x0016
OP_LoginAccepted=0x0017
OP_ServerListResponse=0x0018
OP_Poll=0x0029
OP_EnterChat=0x000f
OP_PollResponse=0x0011

Arag

07-23-2006, 04:38 AM

may this wil work 4 you.
http://eqemu.sesmar.net/forum/index.php?topic=137.0