PDA

View Full Version : Zone problem, can't create more then 2 zones


LordManiac
06-12-2002, 02:46 AM
I can't create more then 2 zones, the first to windows are error free but after it i get this:

Failed to connect to database: Error: Can't connect to MySQL server on 'localhost' <10055>
Loading zone names, items & NPCs...Error in LoadZoneNames query 'SELECT MAX(zoneidnumber) FROM zone' #2006 MySQL server has gone away
blablala, just a couple of more errors like above and then:
done.
WorldServer connect: Connecting to the server failed. Error: 10055
InitWorldServer failed
Entering sleep mode

it doesn't mather which ip adress it uses, just the first two connecctions work. I have the problem with the EQEmu Public Login server and with the MiniLogin server.

My Loginserver.ini:

[LoginServer]
loginserver=localhost
loginserver2=localhost
loginport=5999
loginport2=5999
worldname=Unnamed server
locked=false
account=
password=
worldaddress=localhost

[LoginConfig]
ServerMode=Standalone
ServerPort=5999

my db.ini

# READ LOGINREADME.TXT!

[Database]
host=localhost
user=eqemu
password=eqemu
database=eq

my boot5zones.win9x.bat:

@echo off
start zone9x . 127.0.0.1 7995 127.0.0.1
start zone9x . 127.0.0.1 7996 127.0.0.1
start zone9x . 127.0.0.1 7997 127.0.0.1
start zone9x . 127.0.0.1 7998 127.0.0.1
start zone9x . 127.0.0.1 7999 127.0.0.1
exit
cls

Does anyone knows a solution?

my OS: Windows 98 Second Edition
EMU version: 0.3.3.1

Trumpcard
06-12-2002, 02:55 AM
Try starting a few extra ones manually after the boot file finishes.

Open a cmd window, cd to the eqemu directory, and manually type the zoneNT.exe blah commands into it.

It could be a performance issue from several process opening a persistant connection at one time (I dont see why though)

If you can manual create connections after the fact, you might need to throw a few sleeps in your .bat file.

LordManiac
06-12-2002, 03:17 AM
Nope, that isn't working, still get the same error

Trumpcard
06-12-2002, 03:27 AM
Did you do anything funky to your mysql instance, like alter the number of max_connections?

LordManiac
06-12-2002, 06:07 AM
no, i thought i may has to do with this and i even reinstalled mysql but it still won't work. i will try it on my other pc first

LordManiac
06-12-2002, 08:00 AM
Well, i think i leaf this problem alone, i have another computer on which it works and this computers is getting really buggie, i have to install windows again, explorer errors after closing a window isn't normal and then i will try again with the server

Mori
06-13-2002, 05:24 AM
There could possibly be an error in the zone files themselves. Only way to fix that would be to reinstall EQ :-\.