Server Connect, Client connected until...

[Makwa]

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]

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

Thanks,

Makwa

[Arag]

Originally Posted by Makwa

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

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>

<!-- Only specify these two if you really think you need to. -->
<address>127.0.0.1</address>
<localaddress>127.0.0.1</localaddress>

<!-- Loginserver information. -->
<loginserver>
<host>127.0.0.1</host>
<port>5999</port>
<account></account>
<password></password>
</loginserver>

<!-- Sets the shared key used by zone/launcher to connect to world -->
<key>some long random string</key>

<!-- Enable and set the port for the HTTP service. -->
<http port="9080" enabled="true" mimefile="mime.types" />
</world>

<zones>
<defaultstatus>20</defaultstatus>

<!-- Sets port range for world to use to auto configure zones -->
<ports low="7000" high="7100"/>
</zones>

<!-- Database configuration, replaces db.ini. -->
<database>
<host>127.0.0.1</host>
<port>3306</port>
<username>eq</username>
<password>eq</password>
<db>eq</db>
</database>

<launcher>
<!-- <logprefix>logs/zone-</logprefix> -->
<!-- <logsuffix>.log</logsuffix> -->
<!-- <exe>zone.exe or ./zone</exe> -->
<!-- <timers restart="10000" reterminate="10000" initial="20000" interval="2000"> -->
</launcher>

<files>
<!-- <spells>spells_us.txt</spells> -->
<!-- <opcodes>opcodes.conf</opcodes> -->
<!-- <logsettings>log.ini</logsettings> -->
<!-- <eqtime>eqtime.cfg</eqtime> -->
</files>

<directories>
<!-- <maps>Maps</maps> -->
<!-- <quests>quests</quests> -->
<!-- <plugins>plugins</plugins> -->
</directories>

[Makwa]

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]

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]

Ok, i sent you a PM.

Makwa

[bushman77]

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