Server Trouble...LAN Style

[GentleIksar]

Well, here's my problem. I've tried over and over and over again and I just can't seem to get it to work, it's probably some stupid thing I overlooked, I dunno.

Here's what's going on. I'm trying to run a LAN server for my little brother and me, because my parents have taken our network's internet away. I've got all the updated files, and I've reinstalled MYSQL so many times I can't handle it anymore! None of the tutorials work in my case...I'm thinking it might be an outdated database...but I used the newest version, so I dunno. Anyway, here's my info.

After running through every single LAN server tutorial, I get these windows trying to boot up the server:

MiniLogin.exe
[LoginConfig] block not found in LoginServer.ini.
MiniLogin Accounts.ini read.
Server mode: Standalone
Login server listening on port:5999

World.exe
Got signal 0
[Status] CURRENT_WORLD_VERSION:EQEMu 0.5.6
[Status] Loading variables..
Database Error: Lost connection, attempting to recover....
DB Query Error #2006: MySQL server has gone away
Error in LoadVariables query 'SELECT varname, value, unix_timestamp() FROM variables where unix_timestamp(ts) >= 0" #2006: MySQL server has gone away
[Status] Loading zones..
Database Error: Lost connection, attempting to recover....
DB Query Error #2006: MySQL server has gone away
Error in GetItemsCount query 'SELECT MAX(id),count(*) FROM items' #2006: MySQL server has gone away
Error: Database::LoadItems() (sharemem): GetItemsCount() returned -1
[Error] Error: Could not load item data. But ignoring
[LoginServer] block not found in './LoginServer.ini'.
[Status] Loading guild ranks..
Database Error: Lost connection, attempting to recover....
DB Query Error #2006: MySQL server has gone away
Error in LoadGuilds query 'SELECT id, eqid, name, leader, minstatus, rank0title, rank1, rank1title, rank2, rank2title, rank3, rank3title, rank4, rank4title, rank5, rank5title from guilds' #2006 MySQL server has gone away
[Status] Loading ./addon.ini..
[Status] Loading EQ time of day..
Database Error: Lost connection, attempting to recover....
DB Query Error #2006: MySQL server has gone away
[Status] Deleted -1 stale player corpses from database
Database Error: Lost connection, attempting to recover....
DB Query Error #2006: MySQL server has gone away
[Status] Deleted -1 stale player corpses from database
Assassinating people that whine about horses...done
TCP listening on: port 9000
World server listening on: port 9000
================================
Runtime errors:

MySQL error #2005 means you there are too many connections on the mysql server. The server is overloaded.
For more information on this error, visit http://www.eqemu.net/eqemuerror.php?id=3

Hit any key to exit

Note: I tried that link, and it's dead.

Zone.exe basically does the same thing, mainly because World.exe wont load.

My db.ini file says:
[Database]
host=localhost
user=Cekle
password=*****
database=eq
compression=off

My loginserver.ini says:
# READ README.TXT
[LoginServer]
loginserver=192.168.1.1
loginport=5999
worldname=my minilogin test
worldaddress=192.168.1.1
locked=false
account=eqemu
password=eqemu


[WorldServer]
Defaultstatus=0
Unavailzone=

[LoginConfig]
ServerMode=Standalone
ServerPort=5999
UplinkAddress=
UplinkPort=
UplinkAccount=
UplinkPassword=

Note: I've tried both 'localhost' and '192.168.1.1' for the IP addresses and neither worked.


So, there you have it. I've tried everything in the book and I can't seem to get this darned server to work. Anyone help?

[GentleIksar]

Yes! I actually got my server running! The entire problem was that the IP addresses (localhost), usernames, and passwords all had one single space after it! I'm such a stupid moron! =P