Go Back   EQEmulator Home > EQEmulator Forums > Archives > Archive::Development > Archive::Database/World Building

Archive::Database/World Building Archive area for General Discussion's posts that were moved here after an inactivity period of 90 days.

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 05-09-2003, 02:16 PM
IANumtin
Hill Giant
 
Join Date: Apr 2003
Location: EQEmu
Posts: 121
Default LAN Help

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??
__________________
They say baldness is in the genes but I have hair in my jeans :>)
Reply With Quote
 


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

   

All times are GMT -4. The time now is 01:12 PM.


 

Everquest is a registered trademark of Daybreak Game Company LLC.
EQEmulator is not associated or affiliated in any way with Daybreak Game Company LLC.
Except where otherwise noted, this site is licensed under a Creative Commons License.
       
Powered by vBulletin®, Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Template by Bluepearl Design and vBulletin Templates - Ver3.3