Public Server help

[Racerx719]

Hey guys, I've been trolling the fourms looking for an answer to this for quite some time now.. and if I passed it up I am totally sorry..

This is my first attempt to make a Public EQ server.. I followed the instructions in the Wiki down to the T. 2 things occuring though and causing me problems..

1. When I start the batch file I notice that at the end it will only open ports up to 7004.. I do not see 7005 come up? I have the ports open? Any suggestions on what is causing this?

2. When I go to log in to EQemu client I DO see my server on the select screen. I try to connect to it and I get booted back to the login window. Below is my .xml config file and also the error I am recieving


<?xml version="1.0">
<server>
<world>
<shortname>Collective</shortname>
<longname>The Collective of 813</longname>

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

<!-- Loginserver information. -->
<loginserver>
<host>eqemulator.net</host>
<port>5998</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>

<!-- Database configuration, replaces db.ini. -->
<database>
<host>localhost</host>
<port>3306</port>
<username>root</username>
<password>******</password>
<db>peq</db>
</database>
</server>

[Debug] [WORLD__CLIENT] New connection from 192.168.1.106:63042
[Debug] [NET__IDENT_TRACE] 192.168.1.106:63042: First opcode 0x4dd0 did not matc
h expected 0x2792
[Debug] [NET__IDENT_TRACE] 192.168.1.106:63042: Tried patch 6.2_world, and it di
d not match.
[Debug] [NET__IDENT_TRACE] 192.168.1.106:63042: First opcode 0x4dd0 did not matc
h expected 0x2ec9
[Debug] [NET__IDENT_TRACE] 192.168.1.106:63042: Tried patch 6.2_zone, and it did
not match.
[Debug] [NET__IDENT_TRACE] 192.168.1.106:63042: First opcode matched 0x4dd0 and
length matched 464
[Debug] [NET__IDENTIFY] Identified stream 192.168.1.106:63042 with signature Tit
anium_world
[Debug] [WORLD__CLIENT] Checking inbound connection 192.168.1.106 against Banned
IPs table
[Debug] [WORLD__CLIENT] Connection 192.168.1.106 PASSED banned IPs check. Proce
ssing connection.
Account Attempting to be created:racerx719 0
Error in CreateAccount query 'INSERT INTO account SET name='racerx719', status=0
, lsaccount_id=104991;' #1364: Field 'minilogin_ip' doesn't have a default value

[Debug] [WORLD__CLIENTLIST_ERR] Error adding local account for LS login: 'racerx
719', duplicate name?
[Debug] [WORLD__CLIENT_ERR] NOCLE: Bad/Expired session key '104991'

[Sylaei]

Well, without knowing a little more, I'd say your problem #1 isn't. When the zones are started the start at port 7000. So you have 7000, 7001, 7002, 7003, and 7004 your 5th and final dynamic zone.

As for problem #2, based on the error it isn't creating your account. I'm guessing that you haven't attempted to setup minilogin. If you have then you probably already have an account named racerx719. If not then the issue seems to be related to the minilogin_ip field in your database. I'm not sure how to fix that error but you can manually add the account racerx719 to your database and that should allow you to login. It may not help others but.....

You can use this sql statement:
insert into account (name,status,lsaccount_id,minilogin_ip)
values ("racerx719",250,"104991","192.168.0.100");

status = 250 if you want to be a GM on your server, 0 to be normal char.
lsaccount_id=104991 Taken from your error message, should be correct.
minilogin_ip=192.168.0.100 is made up. This should be your ip address, it won't matter until you attempt to use minilogin so it could be anything but should probably make it match your ip

HTH