Setting up local EQEMu Server v0.4.4-DR1

[rein]

WOW!! Thanks!!! This has been the most helpful post for idiot's such as myself. <--hehe just a joke there guys.

I got the server up and running with no problems following this guide. Well, I had a few minor setbacks, like MySQL still not letting me in, but I managed to work around it. I just had to thank you and everyone else who has put together these guides for us newbies.

[IAjinxlock]

Thanks!!!!!!!!!!!

Works great now!

[tekhnodreamz]

how do u open command prompt in EQEmu folder?

[wildcatts29]

i just want to say great job!!

i have completed all steps i cant flag the wrold.exe but not worry about that at the moment.

i have logged in and have a server showing i can create a character but when i goto log in a iget the next picture just like you always do but after that i go back to server screen.

any ideas on what might be causing this???

thanks in advance :lol:

ok i figured my problem out!!!!

ok not i cant zone it just kicks me back to the zone i was in and if i use #zone i get zone is not ready??

any ideas in advance??

[IACopperm0e]

Just curious if this will still work in a modified manner, if I dont have all of the expansions. Let's just say I want to run it with the original game with no expansions, will this still work with the database suplied?

I did get it to work with the instructions given with expansions up to Shadows of Luclin, and a few more trips around the forums, to get the mysql commands right, just curious about not using all of my expansions, thats all.

[Roman215]

I used this to set up a server that appears on the list and it worked pretty well.

[SamTheMan67]

Im getting zoneboot5 errors every time for somr reason bad items or something?? can anyone help aim=samtheman677
email=sam_the_man67@yahoo.com

[Aggie1]

This guide worked nearly flawlessly. The only trouble was in your Grant Options. *.* would never work.

I changed to eq.* and started up fine. Just one more question remains. I posted at the following link, but perhaps you may be able to provide some insight better as I used your database. Thanks!

http://forums.eqemu.net/viewtopic.php?t=8766

To all you people who can't get world.exe flag... to work. It won't until you get Grant Options to work as far as I can tell. Try "(databasename).*" instead of "*.*". In the case of this guide, mine was "eq.*" without the quotes.

Thanks in advance Devlor!

[mamba666]

I wanted to post some usefull info.

I am close to getting my server working. Here are some problems and fixes that I have.

I had problems with the access denied when trying grant privileges. One problem I noticed in the mYSQL startup info was that it said my.ini was missing. I searched my windows directory and found it./ I then pasted it into the c:\Mysql directory as well as c:\mysql\bin directory. It then was able to find the my.ini file in the startup info of mysql. So the usrname and password started working externally.

I then noticed that when I dialed up I lost connectivity to MYSQL when running world.exe. I am running XP. First problem was the firewall which was running on a different network connection, but was nevertheless causing the disconnect from MYSQL. I ran a search on firewall in XP and fugured out how to turn it off on all network connections.

Ohh also when connecting through dialup, all references to localhost stopped working. I changed them to 127.0.0.1 and they started working. this seems to be soem kind of DNS problem with my dialup-thats my best guess.



Now world.exe runs fine and connects to the database. Boot5zones.bat comes up without error.

Only problem I have now is that I cannot login to the server with the everquest gaem either through the local setup or the normal setup that connects to the eqemu servers. I shoudl have this nailed down pretty soon.

I hope. /crosses fingers.

I hope this was able to help anybody else out there.

good luck

[Bensaret]

When i go to start up world.exe i get the following message:

Failed to connect to database: Error: #1045: Access denied for user: 'MySQL_user@localhost' <using password: YES>
[Status] CURRENT_WORLD_VERSION:EQEMu 0.4.4-DR1
[Error] CURRENT_WORLD_VERSION:EQEMu 0.4.4-DR1
Loading variables, zone names & items. . .
Database Error: Lost connection, attempting to recover. . . .
DB Query Error #2006: MySQL server has gone away
Error in LoadVariables query 'SELECT varname, value, unix_timestamp<> FROM variables where unix_timestamp<ts> >= 0' #2006: MySQL server has gone away
Database Error: Lost connection, attemption to recover. . . .
DB Query Error #2006: MySQL server has gone away
Error in LoadZoneNames query 'SELECT MAX<zoneidnumber> FROM zone' #2006: MySQL server has gone away
EMushareMem.dll loaded.
Database Error: Lost connection, attempting to recover. . . .
DB Query Error #2006: MySQL server has gone away
Error in GetItemsCount query 'SELECT MAX<id>, count<*> FROM items' #2006: MySQL server has gone away
Error: Database::LoadItems<> <sharemem>: GetItemsCount<> returned -1
Error: Could not load item data



______________________________________

Any help would be nice on this plz.

[mamba666]

Hi,
For this specific error you must do the Grant All Privileges command.
Specifically grant the permission for the user that you use to connect to the MYSQL database.

Here is the command that I used. My username is "mysql" that I access my mysql database with.

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


This eliminated that acess denied error.

When I did the generic command :

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

This did not work for me.


I hope this gets you going.

[kertunkulous]

Here are the files as i have them:

[Database]
host=127.0.0.1
user=something with no spaces
password=something with no spaces
database=eq
compression=off

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

[WorldServer]
Defaultstatus=
Unavailzone=

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

[Boot5zones.bat]
start zone . 127.0.0.1 7995 127.0.0.1
start zone . 127.0.0.1 7996 127.0.0.1
start zone . 127.0.0.1 7997 127.0.0.1
start zone . 127.0.0.1 7998 127.0.0.1
start zone . 127.0.0.1 7999 127.0.0.1
exit
cls

[MiniLoginAccounts.ini]
localhost something something

[EqHost.txt]
[Registration Servers]
{
"localhost:5999"
}
[Login Servers]
{
"localhost:5999"
}

[datarate.txt]
10.0

i have to type this into mysql to get it to accept the grant:
c:\>mysql.exe --user=root eq
mysql>GRANT ALL PRIVILEGES ON *.* TO '%'@127.0.0.1 IDENTIFIED BY '%' WITH GRANT OPTION;

and yet, i'm still getting "error #1045 access denied" i found something in the forums about internal addressing, but didn't understand it at all. i can log on and everyting, but "world.exe" just isn't loading or working at all. i've gone through the readme.txt file at least twenty times trying to find a solution. any help would be greatly appreciated.

[Bensaret]

When it says to install all expansions, does it really matter to have all the expansions installed, because I only have all the expansions up to Luclin, i never got plains of power.

[Bigpull]

Originally Posted by Bensaret

When it says to install all expansions, does it really matter to have all the expansions installed, because I only have all the expansions up to Luclin, i never got plains of power.

when it says "install all expansions" ir should read "install all of your expansions"

[a_Guest03]

If you don't have the files to go somewhere, don't. But the game will let you go to any zone. You can get trapped there and may need to drag your butt out of there using the database.