EQemu server related

[Capricci]

Okay, I did exactly as I was told in the readme. I can play normally but when I try to set up my own server I get errors in my minilogin, world, and boot5zones and I followed the instructions. I even re-installed everytihng for the 5th time now trying to figure it out.

my minilog file-

[LoginConfig] block not found in LoginServer.ini.
Server mode: Standalone
Login server listening on port:5999
New TCP connection: 127.0.0.1:1606
86840 New client from ip: 127.0.0.1 port:1627
Client disconnected
Removing client from ip: 127.0.0.1, port: 1627
119030 New client from ip: 127.0.0.1 port:1631
Client timeout
Removing client from ip: 127.0.0.1, port: 1631

----

World file--

.1' like host' #2006: MySQL server has gone away
Zoneserver auth failed: 127.0.0.1:1680
Removing console from ip: 127.0.0.1 port:1680
New TCP connection: 127.0.0.1:1681
DB Query Error
Error #2006: MySQL server has gone away
Error in CheckZoneserverAuth query 'SELECT * FROM zoneserver_auth WHERE '127.0.0
.1' like host' #2006: MySQL server has gone away
Zoneserver auth failed: 127.0.0.1:1681
Removing console from ip: 127.0.0.1 port:1681
New TCP connection: 127.0.0.1:1682
DB Query Error
Error #2006: MySQL server has gone away
Error in CheckZoneserverAuth query 'SELECT * FROM zoneserver_auth WHERE '127.0.0
.1' like host' #2006: MySQL server has gone away
Zoneserver auth failed: 127.0.0.1:1682
New TCP connection: 127.0.0.1:1683
Removing console from ip: 127.0.0.1 port:1682
DB Query Error
Error #2006: MySQL server has gone away
Error in CheckZoneserverAuth query 'SELECT * FROM zoneserver_auth WHERE '127.0.0
.1' like host' #2006: MySQL server has gone away
Zoneserver auth failed: 127.0.0.1:1683
Removing console from ip: 127.0.0.1 port:1683

-----

boot5zones file

f "YourIP" when you are connecting

C:\eqemu\eqemu-0.3.1.1-win32>REM: To the EQEmu Loginserver.

C:\eqemu\eqemu-0.3.1.1-win32>
C:\eqemu\eqemu-0.3.1.1-win32>REM: When you are using minilogin, Replace all IP A
ddresses to say 127.0.0.1

C:\eqemu\eqemu-0.3.1.1-win32>
C:\eqemu\eqemu-0.3.1.1-win32>REM: If you still get errors try using localhost in
stead of 127.0.0.1

C:\eqemu\eqemu-0.3.1.1-win32>
C:\eqemu\eqemu-0.3.1.1-win32>REM: zone9x.exe is for use with Windows 98 and ME o
nly.

C:\eqemu\eqemu-0.3.1.1-win32>REM: If you are running Windows NT/2000 or XP use Z
oneNT.exe

C:\eqemu\eqemu-0.3.1.1-win32>
C:\eqemu\eqemu-0.3.1.1-win32>REM:--------------Start-----------------------

C:\eqemu\eqemu-0.3.1.1-win32>
C:\eqemu\eqemu-0.3.1.1-win32>

--

zoneNT file

has gone away
DB Query Error
Error #2006: MySQL server has gone away
Error in LoadNPCTypes query 'SELECT MAX(id) FROM npc_types' #2006: MySQL server
has gone away
DB Query Error
Error #2006: MySQL server has gone away
done.
Spells loaded from 'spdat.eff'.
Loading guild ranks...DB Query Error
Error #2006: MySQL server has gone away
Error in GetGuildRank query 'SELECT id, eqid, name, leader, rank0title, rank1, r
ank1title, rank2, rank2title, rank3, rank3title, rank4, rank4title, rank5, rank5
title from guilds' #2006: MySQL server has gone away
done.
Loading faction data...DB Query Error
Error #2006: MySQL server has gone away
Error in LoadFactionData 'SELECT MAX(id) FROM faction_list' #2006: MySQL server
has gone away
DB Query Error
Error #2006: MySQL server has gone away
done.
InitWorldServer failed
Entering sleep mode

---

db.ini file

# READ README.TXT!

[Database]
host=localhost
user=yourMYSQLusername
password=yourMYSQLpassword
database=eq


### --- This file tells world.exe what computer mySQL is on. Host should
### --- be left as localhost unless mysql is
### --- on a differant computer than world.exe.

-----

loginserver.ini file

### --- This file tells world.exe what loginserver to connect to.
### --- do not add an account and password unless a EQEmu Dev member has created an account for you.
### --- adding an account and password only grants the server a green name and is not needed.

# READ README.TXT

[LoginServer]
loginserver=localhost
worldname=Testing Server
locked=false
account=
password=
worldaddress=localhost
loginport=5999

-----

eqhost.txt file

[Registration Servers]
{
"localhost:5999"
}
[Login Servers]
{
"localhost:5999"
}

-----

everything goes fine till I reach the part were I need to run minilog, then world, then boot5zones and in there somewhere is where it gets all fuked up. Anyone have any idea what I am doing wrong?? Thanks.

[Shawn319]

(i'm gonna add this to the readme)

Dont ever ever ever go on to the next step if you run into errors (like you ran world.exe with errors then ran boot5zones.bat anyway).

your problem is mysql. is winmysqladmin.exe running in the backround? if not try running it and trying again.

[Capricci]

I've ran running mysqladmin in background and also tried it without, still get the same error.

[Shawn319]

Try this (also note the topic hehe)

http://www.eqemu.net/forums/showthread.php?s=&threadid=1169

[Lurker_005]

I thought I had posted this, but...

your db.ini file

user=yourMYSQLusername
password=yourMYSQLpassword


I am quessing you didn't change these 2 lines. They should have your actual mysql username and password. See if that fixes things for you.

[Capricci]

I changed those, just changed them for posting.