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:

Originally Posted by Velenos

--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.ph...ghlight=#34617 , copied here for convenience:

Originally Posted by devlor

[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 ), 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 ).

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

[johnny5]

The ones you told me to use

[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.ph...ghlight=#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

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.