EQEmulator Forums - Howto : Minilogin with 5.7 Dr-4 [06.03]

EQEmulator Forums (https://www.eqemulator.org/forums/index.php)

- Archive::Tutorials/Howto's (https://www.eqemulator.org/forums/forumdisplay.php?f=619)

- - Howto : Minilogin with 5.7 Dr-4 [06.03] (https://www.eqemulator.org/forums/showthread.php?t=14067)

Howto : Minilogin with 5.7 Dr-4 [06.03]

Ok a little guide how to set a Server with Minilogin with Eqemu-Version 5.7 DR-4:

Part 1 : Setting up MYSQL
Part 2 : Sourcing Databases
Part 3 : Setting up the Server
Part 4 : Working in Everquest-Folder
Part 5 : Starting the Server
Part 6 : Fixing Errors
Part 7 : EQEmu with EQ-Europe

This guide will be updated with every new version released.

In a few hours i gonna release a ready-to-use Version.You only need to do 3 things

Part 1 : Setting up MYSQL

1.Download MySQL from www.mysql.com

2.Install it and set Username and Password

3.run \mysql\bin\winmysqladmin.exe and look for the green light.
If it is green everything is all right.

Part 2 : Sourcing Databases

1.Download the SQL-Package (use rightclick->Save target as)

2.Open the *.rar file (You can get winrar from www.winrar.de) and
look for "itemtablechanges.sql"

3.Copy All Files to \mysql\bin

4.Start -> Run -> CMD

5.Type

Code:

cd <drive>:\mysql\bin

Instead of drive c or d , without "<>"

6.Type

Code:

mysql -u root mysql

This gives you the highest Access-Level (also called Admin)

7.Type

Code:

grant all privileges on *.* to user@localhost identified by 'password' with grant option;

This Command gives you the same rights as root

8.Type

Code:

create database eq;

You create the db "eq"

9.Type

Code:

use eq;

Now you can work with this db

10.Type

Code:

source MW_057DR2_alpha_1.sql;

You load the .sql file in the db , sourcing can take a while

11.Type

Code:

source loot_update.sql;

Same as above

12.Type

Code:

source npc_types_update.sql;

This may take a while (15-45 mins)

13.Type

Code:

source itemtablechanges.sql;

Same as above

14. If Everything is done

Code:

Exit

Part 3 : Setting up the Server

1.Now you can compile the Sources or simply take my precompiled one (use rightclick->Save target as)

2.Now put "EmuShareMem.dll" , "World.exe" and "Zone.exe" in a folder called "EQEmu"

3.Now download The missing files and put them in EQEmu-Folder

4.Download The Config files and put them in EQEmu-Folder

5.Change folder to "EQEmu" and look for "db.ini"

6.Edit it like this

Code:

[Database]

host=localhost

user=Pyrix

password=*Edited by Virus, Don't post your password for everyone to see :-)

database=eq

compression=off

I gonna explain this to You

Code:

[Database]

host=The Server where ur Database is saved on (On your PC= localhost , on another PC=IP)

user=Your MySQL-Username

password=Your MySQL-Password

database=The Name of DB (If you followed the Instructions "eq")

compression=off

7.Now look for LoginServer.ini . The following Part is very important

Code:

# READ README.TXT

[LoginServer]

loginserver=127.0.0.1

loginport=5999

worldname=German [Legit] Test-

worldaddress=127.0.0.1

locked=false

On Default there are 3 entries for loginserver and loginport.
You only need one.
The Defaultport is 5997 , but the Loginserverport of Minilogin is 5999.
Change it to 5999!
Do not But the phrase "Server" in worldname" !
The ip 127.0.0.1 specifies your PC , its like localhost.
You can use localhost instead of 127.0.0.1!

8.Open Boot5zones.bat (with the editor , simply rightclick and edit).

Code:

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

You can replace 127.0.0.1 with localhost!

Part 4 : Working in Everquest-Folder

1.Go to Everquest-Folder and open eqhost.txt.
Replace EVERYTHING with the following entry.

If you got EQ-Europe

Code:

[Login Servers] 

{ 

"localhost:5999" 

}

If you got normal EQ

Code:

[Login Servers]

Host=localhost:5999

2. Now rightclick on "eqgame.exe" and "create shortcut"
Rightclick on the shortcut and add in "target" after the ' " ' patchme.
It looks like :

Code:

"D:\EverQuest\eqgame.exe" patchme

Part 5 : Starting the Server

1.Go to EQEmu-Folder and start minilogin first , than world.exe and last but not least boot5zones.exe.

2.Sometimes you have to wait a bit for the zones loading into world.

3.If you got an output in World.exe Window like "#1 New Zoneserver..." run the special shortcut of everquest.

4.Login as "eqemu" with password "eqemu" .

5.If the Server is locked wait a few mins and connect to the server.

6.If you are rejected from the server , saying you should re-run update ..... and you got newest (26.05.) version of eq the username wasnt added to your db.
Got to next Part to Fix it.

Part 6 : Fixing Errors

1.Ingame Message :" Rerun your patcher...." and in World.exe-Window "Wrong password" or "Unknown Username".

Start -> Run -> Cmd
Use command from Part 1 No.6 , Part 1 No.7 and Part 1 No.10 .
Type

Code:

INSERT INTO account (id, name, charname, packencrypt, sharedplat, password, 

status, lsaccount_id, gmspeed, revoked) VALUES (1, 'eqemu', '', '', 0, 'eqemu', 250, NULL, 0, 0);

2.Minilogin doesnt loads into World.

Simply fix it by editing LoginServer.ini .
Change the Loginserverport from "5997" to "5999" .

3.The Server is locked , I can enter it and create a char.But i cant enter the world.

The Zones havent load into world.exe. Look in World.exe for Errors.
If you havent run the "itemtablechanges.sql" this may be the fault.
The most errors in world.exe are caused by wrong Database-entries or wrong *.ini settings.
Only recreate a db and reload the sql-files into it.

4.You cant attack.

I didnt figure out what it is.
But its defenetly an fault in the source (perhaps attack.cpp or opcodes.h).
The interesting thing is that your enemy loses hp.
Reason : You have no animation for attacking or the target (dunno how) attacks itself.

5.No NPC ingame.
You need to load a .sql into your db.
look part 2.

Part 7 : EQEmu with EQ-Europe

If you wanna play with EQ-Europe on Eqemu-Servers you have to do following.

1.

Patch ur Version to "English" (under Advanced , Erweitert) .

2.

Now there are some diffrents between the format of "eqhost.txt" (stored in your EQ-Folder)

USA-Version:

Code:

[Login Servers]

Host=eqemulator.net:5995

But This format isnt working with Eq-Europe

Try this

EQ-Europe:

Code:

[Login Servers]

{

"eqemulator.net:5995"

}

Last changed on 06.03.04

not bad.. though the corect address for MW databases is: http://www.projecteq.net/modules.php?name=Downloads . may also want to use an updated spells file(3-16-04 is kinda old)

hehe thanks for the link gonna fix it

Thank you and a question

First I want to thank you for your very easy to use walkthrough. I was able to create my database the first time without any problems.

I did have one problem with a download you mentioned in your post.

Quote:

1.Now you can compile the Sources or simply take my precompiled one

I was unable to download your compiled database using the link you have. Is the site down? reached its max? broken?

I tried to compile hte DR4 source files myself following this tutorial

http://www.eqemulator.net/forums/viewtopic.php?t=14719

But had no luck getting the VS.NET to work properly.

Thanks in advance,

Farmer Ted

good guide...i think it should be stickied. i think you should change some of the colors tho...namely the dark reds and blues. kills my eyes.
but a very good guide

/nod

I agree on both points. It is a well written, concise guide and it should be stickied.

But the colors should be changed or should just go... That red is hard on my eyes, but the d.blue makes my eyes want to cross.

Just wanted to second x-scythe so that you know more than 1 person is having trouble with the colors.

Keep up the awesome work!

~Gandar

thx gandar i gonna change color and add a few errors !

I'm using v0.5.7 on XP SP-1. I cannot login to the minilogin server. I've tried adding the eqemu account by manually typing it at the mysql prompt, by using the world adduser command, and with EQAdmin. The problem, though, appears to be that the client can't even connect to the minilogin server.

Here are my files:

loginserver.ini:

[LoginServer]
loginserver=localhost
loginport=5999
worldname=legit alpha -sianyde-
worldaddress=localhost
locked=false

[WorldServer]
Defaultstatus=0
Unavailzone=

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

[ChatChannelServer]
ChatChannelServer=localhost
-------------

miniloginaccounts.ini:

localhost eqemu eqemu
--------------
yes, the space is the end

boot5zones.bat:

if NOT exist spells_us.txt goto NOSPELL

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

:NOSPELL
echo You did not copy the spells_us.txt from your everquest directory to this one. Please do so or zones will crash on startup.
PAUSE

REM:---------------END------------------------

eqhost.txt:

[LoginServer]
Host=localhost:5999
---------------------------

world.exe and zone.exe give normal outputs, with no errors.

I am using an SMC router, but all the apps and the client are running on the same machine.

The eqemu account is account #2 in the eq db, if that means anything.

You posted your password on db.ini, I edited it for you, so don't worry. Not smart to use your real db.ini with everything showing :-p

Thanks... don't remember even posting db.ini, cuz I didn't think it was relevant... but it's late =)

plz post ur world.exe output !

I dunno maybe someone can tell me why this is.

Hello all, Thank your for posting guides like this they help out alot. Only thing is, I know that this is a DR release and things can go wrong. I just found an error that I have never seen before running eqemu earlier versions such as 5.6, 5.7 DR2, Dr3 versions etc. Here is the error below.

[Error] Client error:
[Error] Error message:
[Error] Client error:
[Error] Error message:
[Error] Client error:
[Error] Error message:
[Error] Client error:
[Error] Error message:
[Error] Client error:
[Error] Error message:
[Error] Client error:
[Error] Error message:
[Error] Client error:
[Error] Error message:
[Error] Client error:
[Error] Error message:
CLient linkdead: Sasuke
Dropping client: Process=false, ip=*.*.*.*
[Status] Zone Shutdown: neriaka (40)

This happens for everyone not just certain people. And it is endless too it just keeps on and on until they LD and get dropped. This is not seen in world.exe but in the zones that people are in.

Any ideas on what causes this? Server? Database?, Client side?

Laters,

Server Admin for Frozen Shadows Server

Every time I try to source npc_types_update, all I see is a ton of error messages. I've tried Pyrix's file and an updated one and it's the same for both. All the other files source fine. Is it supposed to be like that?

Everything is up and running and error-free, but when I type in eqemu:eqemu for login:password, it just closes EQ. Any reason why?

Possibly a bad IP Address and/or port number Merq.

Having same issue, everything compiled perfectly, got everything running with no errors, but when I went to run everquest, and after i typed eqemu:eqemu for username:password, and hit login, it just crashes to desktop. What now? And what do you mean by bad IP or port? they are local, should that matter?

Man I wish this would be answered so I could play already :(

tried to "insert" account eqemu ?

Quote:

Originally Posted by Merq

Everything is up and running and error-free, but when I type in eqemu:eqemu for login:password, it just closes EQ. Any reason why?

Is there a space at the end of the line in miniloginaccounts.ini?

It should read, "localhost eqemu eqemu_", where that underscore represents a space.

Quote:

Originally Posted by cloud2276

Read my response to Merq regarding the space in the file.

Ports do matter. Even though you are connecting to your local machine, you still need to listen and connect to the correct ports. post your loginserver.ini and boot5zones.bat.

minilogin ist listening on 5999

Quote:

Originally Posted by Pyrix

plz post ur world.exe output !

I'll post all the outputs :D

minilogin.exe output:

loginserver.ini read.
miniloginaccounts.ini read.
server mode: standalone
loginserver listening on port:5999
-----------------------

world.exe output:

[status] current_world_version: eqemu 0.5.7-DR4
[status] loading variables...
[status] losfing zones...
[status] items...
[status] emusharemem loaded
[status] loading items from database count=28731, max=69304
[status] ./loginserver.ini read.
[status] loading guild ranks...
[status] loading ./addon.ini...
[status] loading eq time of day...
[status] renoot zone modes ON
[status] deleted 0 stale player corpses from database
[status] deleted 0 stale player backups from database
Breaking bards....done
TCP listening on: localhost:9000
World Server listening on: localhost:9000
connected to loginserver: localhost:5999
------------------------------------------
notice that, in this instance, the chatserver didn't connect, whereas it does when i connect to eqemulator.net login

zone.exe

[status] current_zone_version: eqemu 0.5.7-DR4
[status] loading variables
[status] loading zone names
[status] loading items
[status] emusharemem loaded
[status] loading npcs
[status] loading npc faction lists
[status] loading loot tables
[status] loading doors
[status] loading doors from database...
[status] fileloadspdat<> loading spells from ./spellus.txt
[status] fileloadspdat<> spells loaded: 5415
[status] loading guilds
[status] loading factions
[status] loading corpse timers
[status] loading what ever is left
[status] loading commands
[status] 161 commands loaded
[status] entering sleep mode
connected to worldserver: localhost:9000

Here's my minilogin output:
Microsoft Windows XP [Version 5.1.2600]

LoginServer.ini read.
MiniLoginAccounts.ini read.
Server mode: Standalone
Login server listening on port:5999

Heres my world.exe output

[Status] CURRENT_WORLD_VERSION:EQEMu 0.5.7-DR4
[Status] Loading variables..
[Status] Loading zones..
[Status] Loading items..
[Status] EMuShareMem loaded
[Status] Loading items from database: count=28731, max id=69304
[Status] ./LoginServer.ini read.
[Status] Loading guild ranks..
[Status] Loading ./addon.ini..
[Status] Loading EQ time of day..
[Status] Reboot zone modes ON
[Status] Deleted 0 stale player corpses from database
[Status] Deleted 0 stale player backups from database
Formatting drive C:
TCP listening on: 127.0.0.1:9000
World server listening on: 127.0.0.1:9000
Connected to LoginServer: 127.0.0.1:5999

and finally, one of my boot5zones.bat outputs

[Status] CURRENT_ZONE_VERSION: EQEMu 0.5.7-DR4
[Status] Loading Variables
[Status] Loading zone names
[Status] Loading items
[Status] EMuShareMem loaded
[Status] Loading npcs
[Status] Loading npc faction lists
[Status] Loading loot tables
[Status] Loading doors
[Status] FileLoadSPDat() Loading spells from ./spells_us.txt
[Status] FileLoadSPDat() spells loaded: 5415
[Status] Loading guilds
[Status] Loading factions
[Status] Loading corpse timers
[Status] Loading what ever is left
[Status] Loading commands
[Status] command_init(): Warning: Command 'help' defaulting to access level 0!
[Status] command_init(): Warning: Command 'version' defaulting to access level 0
!
[Status] command_init(): Warning: Command 'serversidename' defaulting to access
level 0!
[Status] command_init(): Warning: Command 'loc' defaulting to access level 0!
[Status] command_init(): Warning: Command 'flag' defaulting to access level 0!
[Status] command_init(): Warning: Command 'si' defaulting to access level 0!
[Status] 161 commands loaded
[Status] Entering sleep mode
Connected to worldserver: 127.0.0.1:9000

hmm, well, the command warnings are the only difference between your zone.exe and mine, how do i fix that? i did a world add user name password 250. That just might be the issue.

try to change the "localhost" in *.ini and *.bat files to "127.0.0.1"

That was the first thing I tried, still no go, its just strange to me that on the boot5zones.bat that he got no command defaulting errors like I did, I followed the guide exactly. could that be causing that?

Here is all my .ini files as of now:

db.ini:
[Database]
host=127.0.0.1
user=eqemu
password=eqemu
database=eq
compression=off

Loginserver.ini:
# READ README.TXT
[LoginServer]
loginserver=127.0.0.1
loginport=5999
worldname=blah blah blah
worldaddress=127.0.0.1
locked=false

[WorldServer]
Defaultstatus=0
Unavailzone=

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

[chatchannelserver]
chatserver=127.0.0.1

Miniloginaccounts.ini:
127.0.0.1 eqemu eqemu_<-the space is there

Thanks for all the help.

oops, heres my boot5zones.bat too

REM:--------------Start-----------------------
@echo off

if NOT exist spells_us.txt goto NOSPELL

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

:NOSPELL
echo You did not copy the spells_us.txt from your everquest directory to this one. Please do so or zones will crash on startup.
PAUSE

REM:---------------END------------------------

Quote:

Originally Posted by sianyde

Quote:

Originally Posted by Merq

Everything is up and running and error-free, but when I type in eqemu:eqemu for login:password, it just closes EQ. Any reason why?

Is there a space at the end of the line in miniloginaccounts.ini?

It should read, "localhost eqemu eqemu_", where that underscore represents a space.

Well NOW it says trying to connect to server, but then says check your internet connection. EVerything connects and listens, but now it just can't connect to my computer. Any reason why? =(

I'm referring to when you press "Login" in EQ, that's where it says connecting, then doesn't work.

yeah im just kinda curious WHY when i do this and try and get on eqgame.exe crashes??????????!!!!!!!!!!!!! lol.. any help is appreciated

Quote:

Now you're where I am. When you get that part of the problem fixed, let me know =)

Quote:

Originally Posted by Virus

You posted your password on db.ini, I edited it for you, so don't worry. Not smart to use your real db.ini with everything showing :-p

That was towards Pyrix.

ok.. ive got server to where it is all connecting.. done this guide all the way throught.. everything works out with no errors.. sept when i try and log in .. once i enter eqemu in as name and pass it says eqgame.exe has crashed.. performed illegal operation whichever.. i have tried to log in through a different computer.. with eqhost.txt like this....

[Registration Servers]
{
"serversinternalip:5999"
}
[LoginServers]
{
"serversinternalip:5999"
}

from what ive checked ports are right .. same as my login.ini (so should work) ever other file.. db.ini, boot5zones.ini all set up to what this guide says.. have downloaded everything.. dunno what to do next.. am on xp.. other comp is on 98.. if that helps..

any help at all is GREATLY appreciated thanx!!

You can just set everything to localhost.

ok.. for 1.. why would it matter if i used internal ip or localhost. or 127.0.0.1 , 2 im talkin about another computer trying to log into the server.. the server computer is set to localhost, 3 how in the world does that have anything to do with what i was asking for??

come on man u wrote the guide.. help me out a lil?...

If another pc tries to login into yours you

what if i don't have a lan ip?.. im on a hub =/

plz no automatic ip ... plz change it to 192.168.1.20 or so on on both pcs and do subnetmask 255.255.255.0

im completely confused on what your talkin about.. lmao .. please translate to , dumbass english version =) lmao

ok .. tyo many problems going on at once lol.. ok im going to explain as best i can so that u understand and maybe can help me out :wink:

on this computer i went through and did this guide to the T .. everytyhing exact.. yet when i try and login my eqgame.exe crashes.. plz if anybody knows why please help / pyrix/ virus especially considering u guys are smart =P..

my other thing i tryed tho i was talkin about is on my other comp i put in the server's internal ip to try and connect to the server as the eqhost.txt.. can't remember exactly but i think its

[registration servers]
{
"host=internalip:5999"
}

[loginservers]
{
"host=internalip:5999"
}

yes the 5999/port is same as the servers login.ini port is set to.. but when i tryed to login it said connecting to server, and then said could not connect may need to chekc internet connectivity. also if u know anything about problem 2 plz help :D

Quote:

[registration servers]
{
"host=internalip:5999"
}

[loginservers]
{
"host=internalip:5999"
}

Completly Wrong!

There are 2 possibilities:

You have Everquest-Europe :

[Login Servers]
{
"eqemulator.net:5995"
}

You have Everquest-Normal:

[Login Servers]
Host=eqemulator.net:5995

I just acquired a copy of the pre-May 18th patch eqmain.dll. I can login to my server and access the accounts w/o issue. When I attempt to create a character, world.exe crashes with "This character is not a valid Guild Wars Character". Is there a workaround for this.