Please help me get my Local Lan Server going

[johnny5]

:(

I have followed the instructions from http://forums.eqemu.net/viewtopic.php?t=6761 EXACTLY and have tried some of the other tutorials but get the same problem all the time.

When I open up Everquest I log in fine but there are no servers listed. I ran through all the start up files step by step and opened world exe in dos so I could read the errors. I get told :

Failed to cnnect to database error 1045 access denied for johnny@localhost using password (yes)

I have read through everything I have found on this and havent seen any solid answers on this problem. I have added the lines:

INSERT INTO account SET name='eqemu', password='eqemu', status=200;
GRANT ALL PRIVILEGES ON *.* to '%'@localhost IDENTIFIED BY '%';

and this worked fine...


Why cant I get access??


Please help


Johnny5

[devlor]

Quick question: in your LoginServer.ini file, where:

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

[WorldServer]
Defaultstatus=
Unavailzone=

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

... should be, did you include everything there in my instructions as-is? You didn't, perhaps, insert an account name & password did you? I did this once when I first started, & only after removing them did I get it working. If not, then the standard procedure for those asking for help is that you post the entire contents (verbatim) of the following files:

db.ini
LoginServer.ini
Boot5zones.bat
MiniLoginAccounts.ini
eqhost.txt
datarate.txt

If you fail to do this, you will likely not get much help from people here. So do yourself a favor & grab that info & post it in here, then maybe you'll get some help. :)

[johnny5]

yay Got it working :P

I was using notepad to edit the files so they werent wrapping correctly so i had to put in some spaces and hit enter after every line so it wasnt all one big line.

One thing though

I set the data rate to 10 but I keep going Link Dead and its bloody laggy as hell. When it takes me 10 minutes to load up the world and when I cast spells it takes about a minute for the spell to appear. Also I just got a loadrer.exe error and crashed to desktop when I cast a spell :(

[devlor]

Glad you got it working (well, from the sounds of it, sort of working anyway). :)

Hmm, what are the specs of the computer you're running this on? If it's as slow as you say, you may be running out of memory here. One thing you might want to try would be to REM out (add REM in front of the lines) 3 of the 5 zone servers booting up (leaving you with two running) in your Boot5zones.bat file. If you're just playing this solo, I don't see much need for running more than two (it's not like you can be in five places at once ;) ). You may actually be able to get away with only one (I haven't tested this; two works fine for me), but I chose two just in case of some swapping needed.

You might also want to try some basic system optimization on your computer (clean up your hard disk, defrag, etc.) which may help some.

As far as the crashes to desktop are concerned, I can't say. Someone more knowledgable about the guts of the program itself may need to answer that. However, I can suggest that if you're not already using Telmet's EQEmu-0.4.4-DR1 binaries (as mentioned in my instructions you referred to), you should.

[Velenos]

Hello guys, read the post, having the same problem with the server loading world.exe on the computer. mySQL running on same system, of course. name/password's match on db.ini and sql but getting same problem.

# READ README.TXT!

--db.ini--
[Database]
host=localhost
user=kabob
password=password
database=eq
compression=off

--LoginServer.ini--
[LoginServer]
loginserver=eqlogin1.eqemu.net
loginserver2=eqlogin2.eqemu.net
loginport=5999
loginport2=5999
worldname=Veleno's
worldaddress=65.162.104.218
locked=false
account=
password=

[WorldServer]
Defaultstatus=
Unavailzone=

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

None of the other files listed were modified. Any tips?

[devlor]

From the looks & sounds of it, you're trying to run a server of your own locally (on your own computer), right? Then take a look at what you posted:

--LoginServer.ini--
[LoginServer]
loginserver=eqlogin1.eqemu.net
loginserver2=eqlogin2.eqemu.net
loginport=5999
loginport2=5999
worldname=Veleno's
worldaddress=65.162.104.218
locked=false
account=
password=

See the problem? If you want to host the server locally, you'll need to change the loginserver & worldaddress to match the entries I have listed in my post: http://forums.eqemu.net/viewtopic.php?p=34617&highlight=#34617 , copied here for convenience:

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

As stated in the EQEmu documentation, if "localhost" doesn't work for you, use 127.0.0.1 instead.

All of the files listed there must match exactly what I have there (with the exception of "worldname=MyWorld" in your LoginServer.ini file & user=MySQL_user, password=MySQL_pass in your db.ini file, which you can specify according to taste; the latter two need to match whatever user name & password you specified for MySQL though).

[johnny5]

Devlor

Kudos to you for your great help and support :)
suggesting to rem out 3 of the 5 zones has made my EQ run 100 times faster!!

Though I still get lag and it crashing out to desktop after a couple of minutes. If I do anything like cast a spell or use any # commands it takes about 1 minute to respond or takes about 1 minute to start attacking something. Its like a really slow delay and then the ping just rockets up and I crash to desktop. I am now located in the bazaar with about a 2 minute lifeline. If I fart i Crash if i do anything i crash, if i stand still i crash.. Its the same error all the time..

Loader.exe cause a general protection fault

[devlor]

I'm not quite sure what's causing this. Does this only occur when trying to enter certain zones? Did you test any other zones to see if they work? Some zones are known to cause problems (such as my qeynos zone post which I'd eventually deleted when no one answered :? ; I have never once received a single answer to any of my questions as yet, though I've done my best to help others, but I digress :wink: ), though, like Qeynos, Greater Faydark would be a bit of a problem if it's unaccessible (I haven't gone there yet in the emulator, so I can't say).

I suspect this may be a database-specific error in dealing with zone safe points. In other words, some databases don't have correctly-defined zone-in or safe points, so when you try zoning in, it causes an error & crashes. I may be wrong, but I'm quite sure Qeynos was working for me awhile back when I was using one of my older database builds ("older" as in a week ago :wink: ).

So the question is: what database files are you using?

[johnny5]

The ones you told me to use :wink:

[devlor]

OK then, it seems to be a database problem. For some reason, starting out with Telmet's DB & then installing Drawde's seems to be messing up some zones. This is especially strange since I didn't have this problem previously, when I first installed them this way. I'd had to re-download both of those databases recently & upon installing them again, qeynos became unavailable (have these files changed unannounced?). If you're using the same files, then it would seem Greater Faydark (& possibly others) are as well.

This is the database I'm using now: http://forums.eqemu.net/viewtopic.php?p=34522&highlight=#34522

Try that. So far I'm not having any problems with it.

[johnny5]

Mmmm o.k

I have downloaded but dont want to screw up my setup too much.

Shall i just do the: use database command or shall i add in all the other ones again as well?

Will i have to do the file permissions again? You know the GET INTO bit ?

Thanks

Johnny5

[johnny5]

Sorry to be a nag :cry:

Its just you are the only one on this forum that i seem to understand. Everyone else talks in a funny everquest/programmer language :shock:

Your Help has been great :)

[devlor]

Oh, well if you want to back up your characters in your old database & import them into the new one, then do this (before dropping the old one):

Go to the mysql\bin directory from a command prompt window & type:
mysqldump.exe -t eq account character_ character_backup > charbackup.sql

When that's done, Drop your existing database with (assuming your database name is "eq"):
drop database eq;

Create the database again:
create database eq;

... and then source the database with your file...

use eq;
source drdb2_2.sql;
INSERT INTO account SET name='eqemu', password='eqemu', status=200;
GRANT ALL PRIVILEGES ON *.* TO '%'@127.0.0.1 IDENTIFIED BY '%' WITH GRANT OPTION;

(if the last step, the GRANT... command, gives you an access denied error, exit out of mysql.exe & open it again via the command prompt with mysql.exe --user=root eq)

Then source in your character backup (using mysql.exe command prompt):

source charbackup.sql;
(Yes, it will give a 1 line duplicate entry, but don't worry about it)

Exit out of that when its done & you should be ready to go! :) Once you get the hang of it, you should become fairly comfortable backing up, dropping, & sourcing in new databases for experimentation. You're only messing with the database after all, & that can easily be fixed by going back to your backups. Speaking of which, here's how to backup a solid, working (complete) database when you want to try a new one:

Go to the mysql\bin directory from a command prompt window & type:
mysqldump eq > eqbackup00.sql;
(I number my database backups starting with "eqbackup00.sql", then "eqbackup01.sql, etc.)

If you have problems with the new database, just restore your old one by dropping the current one & sourcing in your backup. After awhile, this should become fairly routine (I've dropped & sourced in new databases well over a dozen times now). :P

[MagicalRage]

how long should it take to create the eq database that is in your directions?

thanks

[devlor]

Well this whole process (minus the download times) takes me roughly about 15 minutes (at most) on an AthlonXP 1800 machine with 512 DDR RAM. If you're computer's specs are les than these, it may take a few minutes longer, depending on the difference.

EDIT: Of course, I'm referring to the full set of instructions I posted for setting up a local server (see my signature for link). If you're referring to the amount of time it takes to backup & source in a new database, then 2-5 minutes at most.

[johnny5]

Devlor you are a Star *

Kudos to you fo rthe great help you gave me : )

Much appreciated, its working now! I can zone and stuff but still have a few minor problems.

Lagometer still spiking whenever I do anything like cast a spell or view my inventory and sometimes kicks me to desktop or disconnects me so I have to relog.

Also I think the Spawn database we are suing is a bit screwed. I enter a zone and see no mobs then I see the whole zones mobs in a corner somewhere :shock: I ask one of them why they are all facing the wall in a huddle but they dont reply.

If I attack any mobs, the rest of the mobs in the zone seem to get aggro too and I end up with one hell of a fight in my hands hahaha

I have a decent spec PC so I cant understand where the lag is comming from. It can sometimes take a minute to get a response when I use the # command. I have 512mb DDR ram xp2100 cpu and a Gforce 4 card. EQ runs like a dream on any other server, just not my own. Maybe I will move all the eqemu files and the sql database to my server and use it through the network.

Also with this current setup. If I am connected to the net, can a friend connect to my server if I give him an eqhost file with my ip address on it?

How do I load up the PoP zones? I tried #loadzone 1 povalor but couldnt get it to work and couldnt get a guild working either cause it kept saying it couldnt find the guild leader??

Johnny 5

[devlor]

Thanks johnny5. :) However, I'm far from being an expert on all this. I actually just got started about 3 weeks ago myself. After much experimentation, trial & error, I've pretty much got the setup routine down, as well as swapping out new databases, etc. I do have my limits though, & what you're asking here may be testing them. ;)

First off, as far as the database (DB) goes, you might want to swap out your current DB & source in Drawde's newest updated DB (http://forums.eqemu.net/viewtopic.php?t=6912&highlight=). I've been testing this out myself the last couple of days & it works great so far. Still some problems in certain zones (like Mistmoore: it's raining mobs! :lol: ), but otherwise very playable.

The thing that immediately springs to mind with the lag you're reporting here is to check to see if you created a datarate.txt file in your C:\Games\EQEmu\EQGame\ directory, & that it says: 10.0 (only)?

Your system specs outweigh my own (AthlonXP 1800, 512 DDR, GeForce 3 Ti200) & my game runs as smooth as silk hosted on my local machine, so if the problem doesn't lie there, then I'm not sure what the problem is exactly. Are you using Internet Connection Sharing, or otherwise hosting a shared network connection with other computers on your LAN? If so, perhaps :?: that may be a source for some lag (I'm not on a LAN myself), since the I/O resources are being shared. Just a thought...

Perhaps someone else here familiar with running EQEmu on a computer hosting a LAN might be able to shed some more light on this? Anyone?