EQEmulator Forums

Hopefully someone can help with this. I'm running a LAN setup (two computers) following everthing to the letter on the instructions. Everything works great with the D/T combined working database (I like the populated expansion zones). I sourced in NPC faction, faction values, NPC spell table with values with no problem. When I open FQAdmin everything is there as it should be.

Now on to the problem. After sourcing in the tables, it seems as though my host doesn't have enought memory. I can log in just fine on either the host or the client getting to the character select screen. Whenever I enter world on either computer, I get several ZONE NOT AVAILABLE messages no matter which one I try to zone in on. After about 15 attempts with the same error it finally lets me in to the world (after it seems to have eaten up all memory). Now I'm in the world (doesn't matter which zone, I've tried several with same effect) and I try to zone either using the #zone <shortzonename> or at the zoneline I once again find myself at the character select screen having to go through the same thing all over again.

EDIT: Since the problem above, I've tried dumping and resourcing in the old database without the tables that I sourced in earlier, so in other words, back to to the basics. Here's what my files look like, edited of course from the brackets:

MiniLogin.ini

localhost <myusername> <mypassword>

LoginServer.ini

[LoginServer]
loginserver=localhost
loginserver2=localhost
loginport=5999
loginport2=5999
worldname=<My World>
worldaddress=localhost
locked=false
account=
password=

[WorldServer]
Defaultstatus=
Unavailzone=

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

Boot5Zones.bat

start zone . localhost 7995 localhost
start zone . localhost 7996 localhost
start zone . localhost 7997 localhost
start zone . localhost 7998 localhost
start zone . localhost 7999 localhost

exit
cls

eqhost.txt

[Registration Servers]
{
"localhost:5999"
}
[Login Servers]
{
"localhost:5999"
}
Here's the procedure I used when sourcing in the original database:

Using MySqlBin...

drop database eq;
create database eq;
use eq;
source Working_Database.sql

....and of course about 5 minutes later I come back to the prompt, no errors at all during sourcing.

INSERT INTO account SET name='<my user name>', password='<my password>', status=200;

....I get the correct "1 row effected, etc..."...no error.

GRANT ALL PRIVILEGES ON *.* TO '%' @127.0.0.1 IDENTIFIED BY '%' WITH GRANT OPTION;

....another "1 row effected, etc..." ....no error.

But now a new problem....I log in using the account name and password that I used on the INSERT INTO command but yet when I get to the server select screen, I notice at the top it scrolls.... WELCOME:eqemu! instead of my normal user name and password that I logged in with. I select my server and hit the play button but it comes back with YOU MAY NEED TO REPATCH...etc. I'm assuming because it still thinks I'm trying to use eqemu as a login but yet there's no account created locally with eqemu being used. Any ideas??