Note; Since this guide was originally written, it has been added to the EQEmu Wiki and is more current there. So, please see the Wiki page here for the most updated version of these instructions:
http://www.eqemulator.net/wiki/wikka.php?wakka=ValesEQ


Those are SVN addresses. Basically you use something like TortoiseSVN to download the stuff as the developers update them.

If you follow this guide, it shows you how to download and compile your own server. I'll see if I can make a guide with pictures so it can be explained better, but for now, I can walk you through the basic stuff. This guide is to use the latest stuff without compiling your own source.

I'm assuming you already have MySQL and Perl (version 5.10) installed, so I'll skip those parts. If you haven't follow Steps 2-3 from the link above.

This should allow you to run the latest binaries with Bots, database and the new EQEMuLoginServer. The new EQEMuLoginServer is like a mini-login server, so it should probably used over the old and outdated MiniLogin server.

This will be for a completely new install, so back up your database just in case before you start.

I'll try to make this super-easy.


First, download the compiled server binaires.

Download Revision 774 with Bots here. Extract it. You should see a folder after you've extracted it called build - all your files are in there. This will be referred to as the server folder for this tutorial.



Preface - Checking out the latest sources.

1.) Download and install Tortoise SVN. After it's installed, navigate to your MySQL installation folder. In that directory, you should see a folder named bin - this is where you'll download the database to.


2.) Right-click the folder and select SVN Checkout. In the new window that pops up, where it says URL of Repository at the top, paste in: http://projecteqdb.googlecode.com/svn/trunk. The line under that where it says Checkout directory: is the location of the folder you are downloading it to - keep an eye on that to make sure it's the correct folder.


3.) Click "OK", and let it update. Once this is done, navigate to the folder and you should see a file called: peqdb_Rev781.sql.gz. Extract it with 7-zip (freeware) or something similar like WinRAR (30-day trial). This is the "bulk" of the database. Now keep an eye on the revision number as it signifies the coalation between the server number. In this case, it's: peqdb_Rev781.sql. This means that you can run it since it's compatible with the server revision which is Rev774. If you update to a newer server rev, then you need to update the database if the rev version of the server surpasses the database.

Now to source the database in.



Setup - Importing the Database.

4.) Start MySQL by: Start > MySQL > MySQL Server 5.0 > MySQL Command Line Client. If there's a password for your database, enter it and hit Enter.
You should see: mysql> _.

Since this is a new installation, you can type: CREATE DATABASE [name];, where [name] is the name you want for the database (exclude the [brackets]). I'll use PEQ as an example. So it would be: CREATE DATABSE PEQ;

Then type: use PEQ (or whatever siginifies your database.) It should then say: Database changed.

Then type: source peqdb_Rev781.sql;

Then type: source load_player.sql;

And lastly: source load_bots.sql;

Once it's done, you're all set! Now all that's left is to double-check the revisions and set up the new EQEMuLoginServer.


5.) Download the EQEMuLoginServer files here. Once downloaded, extract it. Copy the EQEMuLoginServer.exe to your server folder.


6.) As explained above in Step 2, create a new folder and name it something easy to remember like EQEmu Server Files or something.
Right-click that folder, and paste in the SVN address: http://projecteqemu.googlecode.com/svn.


7.) Go to the folder where you downloaded the server sources and navigate to: trunk > EQEmuServer > EQEmuLoginServer > login_util.

Then copy: eqemulogin.ini, login_opcodes.conf to your server folder.

And finally, go to login_util > ms > debug and copy the EQEmuAuthCrypto.dll file to your server folder.


8.) Download and install HeidiSQL or something to make it much easier for this part.

Launch HeidiSQL and use your MySQL credentials to login (click Save + Connect to remember your login info - not recommended on public computers for obvious reasons).


9.) In the upper-left panel, you should see the name of your database (PEQ). Right-click somewhere in the panel and choose Create Database from the menu. Give it a name like: PEQLoginDB then click OK.

Click your database name (PEQLoginDB) in the upper-left panel so it's yellow to make sure it's selected. Now press CTRL+O (or from the top menu: Import > Load SQL file...). Then navigate to the folder where you downloaded the server files: trunk > EQEmuServer > EQEmuLoginServer > login_util. Then select: EQEmuLoginServerDBInstall.sql and click Open.

In the Query window at the center of the screen, you should see the SQL entry. Above that, you should see a left-most blue arrow pointing to the right. Press that to execute the query. Or press F9.

Almost there! Now to make accounts and set up the server to log in.


10.) Here's an SQL file to make accounts. Make sure your PEQLoginDB is selected, and import this query. You can save this as an .sql file, or copy/paste it in the Query window in HeidiSQL and import it.
The red text is where you would enter your account info to log in.

For security purposes, you can delete the Admin account that's entered by default in tlbloginserveraccounts by left-clicking on it so it's yellow, and then pressing CTRL+DEL.


11.) Setting up the world server. Here's the sql file to make the world server entry.
Again, the red text is what you want to modify with your server name.
NameOfServer is the actual name of the server.
ShortNameOfServer is the shortname for client files in your game directory (i.e. UI_Soandso_ShortNameOfServer.ini).
ServerTagDescription is what you will see in parenthesis after the server's name - i.e. NameOfServer(Come and have fun!)
The green number 2 signifies what kind of server it is. 1 = Legends, 2 = Preferred, 3 = Standard.



Finalizing - Setting up for launch and connections.

Now the last part is to make sure everything is set up so you can connect. I'll be using an example of setting up the server on the same LAN connection while letting people outside of your LAN to be able to connect to your server.


12.) First of all, lets open up the eqemu_config.xml file in your server directory.

Up at the top of the file, you should see:
The red text should match with what you put in Step 11 above.


server.dyndns.org should be your dyndns address, and the 192.168.0.1 should be the LAN IP of the server's PC.


server.dyndns.org should be your dyndns name.


MySQL Account and Password is self explanitory. It's the login information you used for HeidiSQL. peq is the name of the database.



13.) Save your changes and open up eqemulogin.ini.

PEQLoginDB is the name of the Login Database in Step 9. MySQL Login and Password is the same as in Step 8.



Maps, Quests and Spells - Keeping them updated.

This is how to keep all of your maps and quests updated.

MAPS
14.) In your server folder, right-click the Maps folder and select SVN Checkout. In the URL of Repository section, paste: http://eqemumaps.googlecode.com/svn/trunk/Maps
This can take a very long time to download as the map files are pretty large. 3.37 GB as of now.


QUESTS
15.) In your server folder, right-click the quests folder and select SVN Checkout. In the URL of Repository section, paste: http://projecteqquests.googlecode.com/svn/trunk/quests
This keeps your quests updated, and is highly recommended to maintain as it's updated regularly!


SPELLS
16.) In your EverQuest installation directory, find: spells_en.txt and spells_us.txt. Copy them to your server folder. This allows the server to read data from these files to ensure that the spells work as they should. You do not need to copy these files everytime you update, but do make sure they're there before reporting any bugs about spells.




Setting up a .batch file.

17.) Make a .bat file to launch the server if you haven't already. Just make a new text file called startup.bat (you may need to change the extension from .txt to .bat). Then copy this text:

Now you can launch the startup.bat file and it should launch all of the server executables so you can play.



Connecting - Changing your eqhost.txt file

18.) Since you are on the same LAN, your eqhost.txt file should be as follows:
or
The red text should reflect the LAN IP of the server's PC (i.e. 192.168.1.0). It would depend on your router/firewall setup, so I won't go into details here since there's plenty of topics on the forum about this.


If other people outside of your LAN are trying to connect, their eqhost.txt file should read:
server.dyndns.org should be the name of your dyndns service.



-=-=-=- End tutorial! -=-=-=-



This should cover anyone wanting to set up a server. Hope it's informative as I have blisters on my fingers from typing all of this. ;) If there's anything missing, let me know as I'll gladly update this topic with relevant information as soon as I give my carpal tunnel a rest.

Now go play! :grin:

Wow vales this is awesome! I've been looking for a complete updated fresh install guide. Thank you!

Feel free to create a new wiki page for this guide or combine it with the existing one for Windows in the Wiki. That will make it easy for anyone to update it if anything changes or add more to it to make it more complete. Thanks for the Guide, Vales. I copied this out of the thread you posted it in and made it into a sticky since it definitely has some good info.

Oh snap! It's a sticky! :shock:

Yep will add it to the wikki when I get a chance. I was going to grab some screenshots as well, but will also need people to verify it works to make sure the changes go in the first time around.

Thanks again! :)

I tried a reinstall of mysql so I could do this fresh, and it won't continue the setup wizard without my old password. I did the first setup yesterday, and still can't seem to remember what I used as a password. Is there a way to find out in a file somewhere?

To anyone using this guide as a fresh/new server install. I have never setup a server before and I followed this guide to a T and was able to get my server and client running on the same machine with no problem. As of this writing I also used the two most brand spanking new versions of MySQL and ActivPerl installations.

I didn't use the bot installation as vales suggested so I get a couple of errors in my launcher but I'm not concerned with these and they do not effect gameplay if you're not using them. The one mistake I made was installing/checking out (with SVN) the quests and maps into a subfolder OF quests and maps; thus, build/quests/quests and build/maps/maps which is wrong; it should just be build/maps and build/quests. Otherwise when you log into your server the NPCs won't respond to hails for quest info and pathing is jacked up.

My client crashed on the first launch because my resolution is so high on my LCD monitor (1920x). After setting my res. down to 1400x the client loaded and I went to options and bumped the res to 1600. I logged out and then relaunched in a screen res of 1920 and then it worked fine.

I also started very light with the eqemu_config.xml file. I used the bare minimum configuration to enable my local client login. I didn't use the FULL version because I'm getting some odd heap dump CRT errors. I will slowly add the additional configuration lines to troubleshoot where the crashes are coming from.

I hope this helps other noobs like myself getting a server going for the first time.

-Shiny

Updated the tutorial on the wikki! :D

So if there's anything people need help with, I guess they can ask here. The wikki version allows me or anyone to edit it if there's anything wrong, so it's much easier to maintain. Be warned though, the formatting for the wikki was pretty tough as I had to reformat ALL of the text from this post to gel with the wikki. I spent the whole day yesterday doing that.

I know there may be some stuff I might have missed, so feel free to post any discrepancies.

Oh yeah, link in my signature! ;)

Thank you for this excellent guide! I have a system that is up & running (again), with the new EQEmuLoginServer.exe =P

How can I set my account to be an admin on the server? I've tried to look for the old "level" in the PEQLoginDB database, but it doesn't exist. I've also tried sticking my same account information into tblserveradminregistration. It's just going to be me on this server & I'll get the living snot kicked outta me without good gear =).

I know I am drudging this up from god knows how long ago, however I am having one small problem, and this guide is extremely well written.

On step 10 and 11 where it says to copy the text or Import as SQL files I am a bit lost. I do not know where to paste these lines in at, and the import function seems off to me as simple as the rest of this was. Everything else is smooth as silk. Also after you do step 10 and 11 is there a save button? I cannot seem to find one and don't want to mess things up by redoing steps that may force this not to work.

All I really need is clarification of step 10 and 11 and I should be fine, Sorry to bother you with such trivial questions but I am 100% new at this and this guide is quite amazing, just had one question.

Jobe,

I used a CL (command line) input into mysql for this:

Click on START

Then choose RUN and type CMD, this will pull up a command line interface

Next, type (without quotes): "mysql -u root -p"
Enter your password when prompted

Type "\u peq" and hit ENTER

Then you are able to type in the sql query, hit ENTER and it should work. Hope that helps =)...

Just to add on.. You can specify the database in the command line also.

thanks, also if anyone wants to feel free to answer a few more questions... what do I set my dydns to so I am able to get it connected to the loginserver? is it my IP address?

Total newbie to this sort of thing, but not a complete idiot and easily trainable. Having trouble with logging into my server.

Not quite sure what I'm doing wrong here. I've completed all steps exactly (to my knowledge) yet when I try to connect my client (using the account name and password I created in tblloginserveraccounts), I keep getting the username and password does not exist error.

EQEmu Login Server window shows that my client is trying to connect but shows "could not find user 0". Not sure what to do for this...looked around on the forums for an hour or so and can't quite figure it out.

Obviously my settings are correct (I think) just something missing somewhere that recognizes the correct username and password. I've tried deleting and re-entering (in heidisql) the sql entry for tblloginserveraccount multiple times with different usernames and passwords, but nothing seems to work. The data tab definitely shows the same user and pass as I'm entering in.

I'm sure it's something simple, but I'm just not familiar enough with this to understand why it's not working. Any help is appreciated.

You guys are free to discuss support for the server setup guide, but I won't be updating it here anymore (since I can't). I hightly recommend checking out the revised guide in my signature - now hosted on the wikki.

If there's anything as far as support questions go, feel free to post here and and someone is bound to offer some help when they can. :)

I'm guessing you don't know the answer to my problem, Vales? Lol. I've gone back and run the setup again from the guide in your sig and still same result.

i do not get step 9 in this guild about creating another database called peqlogindb? as far as i have tried and messed arouind with this, nothing uses that database, it is using the account section in peq database and i think that is why i am having issues. i have a server up and runing but no one can log in and create their own account. only can log in if i create them an account in peq/account myself. so what is step 9 actually doing?

It's using the new EQEmuLogin server. The database creation is for simplicity's sake. Minilogin is pretty much unsupported, afaik. I figured since the development is moving along with the new Login Server, that it would be a good idea to include it since mostly everyone is trying to run their own MiniLogin server and it's not really supported for multiple connections on the same LAN.

Sorry, missed the post since it's kinda confusing with two topics with people responding in both. :P Can we get a lock on the other one that's not a sticky, please?

Did you by any chance have a EQEmu server set up prior to this?

Nope. First time setting up a server. I've noticed I'm not the only one getting the problem, too, yet no one has explained a solution.

I've gone back, completely uninstalled all items, then re-did your guide exactly as its posted again. Same result. Obviously, everything is working properly, as i can start my world.exe with the startup.bat file, and everything connects as it should. I just keep getting told my username and password are not valid when I try to log in my client. To me, that means that the settings are correct to connect, but something is getting confused by the loginserver with my username and pass.

I've checked everything over about 20 times, peqlogindb has the correct queries imported for the tblloginserver accounts and I'm definetly trying to connect my client with the username and password entered there.

I've got to be missing something that I just don't understand. If you need me to copy and paste settings, let me know. It's pretty much exactly as you have it in your guide, but it couldn't hurt I suppose.

Trance-

I actually had a very similar problem. I would try to create an account and for no rhyme or reason that account wasn't being recognized on login. Do this: keep creating new accounts with completely different usernames and passwords and eventually one will work. Don't delete the ones that don't work until you get one that does work. I can't explain this either. It doesn't make sense. I thought maybe it was the characters I was using in some of the account creations but that wasn't the case either. I was using nothing odd.

-Shiny

I've tried following the guide and ether I'm missing a step earlier, or missing information. When I try to do step 6, it askes for a login and password, but they aren't any of the passwords I've set up.

I too am also having the same problem. I have been creating new accounts in my logindb and nothing is working (I have about 15 created accounts). Also the other thing I did different is instead of setting my server.dyndns.org im using localhost on everything so i can just solo for now. Everthing works fine except for being able to log in.

Zabooo, try this, create a login and use 11111111 for the password. There are 8 ones there. I finally got it to work for me that way, I don't know whats wrong.

Hey folks - this site is fantastic. My wife and I have played EQ since around 2000 but quit a couple of years ago due to time restrictions (read kids!) I'm looking to build and host a server so friends and family can play and eventually nephews nieces and my own kids can play in a 'safe' environment.

I've followed the Vales guide but have come up against what appears to be a very common error - yes another 1017!. Basically I can log in and play from the box running the server so I'm comfortable that the client/server match is OK and the DB is compatible with the binaries, however when I try to login from a PC on my LAN - even if directly connected to the server (ie no router in the middle) the connection drops on transfer from login to world. That is I can authenticate over the LAN/direct link, but as soon as I go to enter the world I get the old 1017. I use the exact same username and password for both local login and LAN/direct login. Local works LAN/Direct doesn't

Router is set up to forward tcp/udp 9000 to 192.168.1.8 (I'm confident this isn't an issue as there is no connectivity when directly connected to the server by a single cat5 cable)




Config files are below:

{eqemu_config.ini}
<?xml version="1.0">
<server>
<world>
<shortname>MyShortname</shortname>
<longname>MyLongname</longname>

<!-- Loginserver information. Defaults shown -->
<loginserver>
<host>myshortname.no-ip.info</host>
<port>5999</port>
<account></account>
<password></password>
</loginserver>

<!-- Only specify these two if you really think you need to. (read: You don't) -->
<address>myshortname.no-ip.info</address>
<localaddress>192.168.1.8</localaddress>

<!-- Sets the ip/port for the tcp connections. Both zones and console (if enabled). Defaults are shown -->
<tcp ip="myshortname.no-ip.info" port="9000" telnet="enable"/>

</world>

<!-- Database configuration, replaces db.ini. Defaults shown -->
<database>
<host>localhost</host>
<port>3306</port>
<username>mydbusername</username>
<password>mydbpassword</password>
<db>peq</db>
</database>




</server>


-------------------------------
{LoginServer.ini}

### --- This file tells world.exe what loginserver to connect to.
### --- Leave the account and password field BLANK.

### --- Public Login is un-supported as is LAN playing. We reccomend using the EQEmu.net Loginserver ALWAYS.

### --- NOTE: Starting 6-1-2002, you can no longer use the word "Server" in worldname.
### --- NOTE2: the word "Server" is added to each server automaticly.

# READ README.TXT

[LoginServer]
loginserver=192.168.1.8
loginserver2=myshortname.no-ip.info
loginport=5999
loginport2=5999
worldname=myshortname.no-ip.info
worldaddress=192.168.1.8
locked=false
account=
password=

[WorldServer]
Defaultstatus=
Unavailzone=

[ChatChannelServer]
worldshortname=
chataddress=
chatport=

[LoginConfig]
ServerMode=EQEmuLoginServer
ServerPort=5999

------------------------------------------------
{hosts file in ...System32\drivers\etc\hosts}

192.168.1.8 myshortname.no-ip.info

-----------------------------------------------

{eqhosts file}
[LoginServer]
host=myshortname.no-ip.info

------------------------------

Any help would be much appreciated.

EQFAN

Ok, a little progress made with the dreaded 1017 error gone and I can now make it past the login screen (Yay!) I disabled the virtual IPs from VMware that were on both the Server and the Client machines, and the key change was to edit emu_config.ini section from this:

<!-- Loginserver information. Defaults shown -->
<loginserver>
<host>myshortname.no-ip.info</host>
<port>5999</port>
<account></account>
<password></password>
</loginserver>

to this:

<!-- Loginserver information. Defaults shown -->
<loginserver>
<host>eqemulator.net</host>
<port>5998</port>
<account></account>
<password></password>
</loginserver>

And updated eqhosts.txt accordingly


So I'm now using the global login server to get back into my own box which seems kind of clunky but might be useful for getting friends and family connected to my server.

Once again, if I log in from the same machine my server is on all is fine and I can enter the world, but if I try the same thing on a LAN box I get 'Server is not Responding' message.

My next trick will be to experiment with some portforwarding configurations for both server and client. All suggestions are most welcome.

Ultimately I'd like to use my own login server and perhaps set up a VNP if required for family and friends to login from the WAN(Internet). One step at at time though :-)
Once I can achieve connectivity from a LAN box, I'll gradually move back closer to Vales' settings for the login server which is currently sitting idle on my server!

Quick update on last post before I go to bed (work tomorrow!)
LAN client can connect to other servers listed under eqemulator.net and make it into tutorial zone so there is definitely an issue with either my server receiving non-localhost clients, or the port forwarding setup within the LAN.
Will try again tomorrow after work :-)

Hmm still no joy. Have opened up ports 5998, 5999, 7000-7500 and 9000 and dropped firewalls on both server and client. Have run out of things to try. Any assistance or suggestions would be most welcome at this stage. :-(

I enabled logging in the LAN client - message prior to 'The Server is not Responding' was zone address [192.168.1.8:23579] received

Failed to connect to the zone server 192.168.1.8:7004 result = 5 for MSG_ZONE_Address

Does this ring any bells for anyone?

Progress update - minor success!
 

Update time :)
The learning curve is beginning to level out! I've tried a few different approaches now with one semi-successful :grin: i.e. download Cavedude's PEQ-LOY Server install pack and maps. Configuration is MQSQL5.0, Active Perl 5.8 and the above packs. Still having intermittent problems with 'Server Not Responding' message when zoning in from the Character selection screen to starting zone. Sometimes it works and sometimes it doesn't. First success was achieved by bypassing my ADSL modem and LAN and going out via my Blackberry's internet connection, so it's looking more and more like a LAN-hardware/firewall/portforwarding issue. Ulitmate goal is to have Eqemulator V8.0 or greater on Gentoo 64, but will take it a step at a time. If anyone has any advice or guidance on G64 compiles for EQEmu please send a message and or links! 8-)
Have also tried Win32 compile from source - no luck - am use to Gentoo Linux compiles not Win.
Anyway I suspect some of my earlier problems was caused by confusing the advice and files provided by the PEQ site and this one!!! The directory contains minilogin, PEQ and SVN code from various locations - could be compatibility issues! Will wipe the server director and start from scratch.

I tried version 884 bots and no bots. I get a missing perl58.dll error

I insert the perl58.dll from a perl install from years ago and get "procedure entry point Perl_newXS_flags could not be located in perl58.dll

Any ideas? I followed the guide as written, I installed the perl5.10 as mentioned in guide, also uninstalled it and installed 5.8 still same issues.

Tried a crackheaded idea I thought of after writing this, renamed (after backing up) the perl510.dll to perl58 and got a different error altogether (no I did not expect this to work, but hey i'm annoyedly desperate) "procedure entry point Perl_Top_ptr could not be located in perl58.dll

nvm, a search found my answer...I would have cleared that post but 5 min timer expired to edit it.

So what was the answer.
 

Great to hear that you got it sorted. What was the solution that resolved your problem?

Solution to Windows Server Problem - switch to Linux
 

Well after trying everything I could possibly think of I've still had no luck so I tried one last thing - switched to Linux. Dusting off my old Gentoo64 server, I had the source compiled within 5 minutes and was connected to the server in under 10. :D Linux 1 Windows 0.:-x
Sorry that this is no help to anyone stuck with a Windows box. I'll keep plugging away at the problem slow time and update this thread if I come up with anything.
Cheers

EQFAN :wink:

I completely uninstalled perl and deleted the folder and restarted the perl section in the guide useing perl version ActivePerl-5.8.9.825-MSWin32-x86-288577.msi

I also searched for the other perl install entries for version 5.8 that are not mentioned in this guide. I forget offhand what they are, but not too hard to find. I think I used 2 entries that are not on this guide.

Now I am fighting not being able to minilogin my server, my internet is crap WISP (wireless Internet Service Provider) and it is extremely slow and unreliable.

So I am trying to make a internet independent EQ. Tho I have scoured the forums and nothing seems to work as of yet. Tho I once was able to login through the normal eqemulator.net login server. But its time for me to search the heck out of this issue.

Thanks for the update
 

Thanks for the update Speedz. It looks like it might be time for an updated Windows server installation guide. I've started working on one, but until I can successfully build and run one I'll hold off on publishing it! There are a number of factors involved in getting the server up and running and unfortunately they're not all in the one place. Hopefully when I'm done it will be a one stop shop for server installation complete with screen shots.
From what I can gather the latest versions of Perl and MySQL are not fully compatible with the server and DB files. I also learned by trial and error about patching in the latest .sql files from the utils directory none of the present guides have these things in them. This is not a criticism of the great job others have done but I'd like to build and improve on what has been developed before.
Right now I just wish I could resolve the connection problem when trying to enter the world from the character selection screen on a LAN PC!

Well an update on my situation:

Minilogin "seems" to hate me, but I got the EQEmuLoginServer.exe to play nice with world server finally.

My hangup is, no matter what I do, I can't get past "invalid username and/or password" when trying to login.

I tried various things:

deleted the account from database to see if one will just auto populate, no luck.
tried to enter an unhashed password in the password field in the database, no luck.
tried hashed password, no luck.

I am at a loss so far as to how to play on my server. I once did successfully connect through the eqemu login servers but this is not how I want it to work. So I know my database is at least functioning well enough.

Off to more searching. Once I get this working, I will try to retrace all my steps of success and create a emulator on another machine from scratch and document the steps and all files needed to help with a guide update. But until I can actually log in to my server that isn't going to happen soon.

Any guide help I will add is for offline only steps. As I think the current guides need some help in that area. I also thank everyone so far in this community. I been a member for years and inactive for most of it. It is great to see so much work continuing to be done.

Minilogin
 

Hey Speedz,
Most of the documentation I have read suggests that Minilogin is deprecated and the Eqemuloginserver.exe is the way to go even for internal systems such as yours. I have been able to get this up and running following Vales' guide no problems. If you want to stick with the minilogin then track down the PDF guide on this website and look at the bottom of the guide.
Cheers
EQFAN

Yea I have givin up on minilogin, I get a constant issue with fatal errors in connecting in world.exe

So I am now messing with Eqemuloginserver.exe, this is where I can't get the login/passwords to work.

Eqemuloginserver passwords
 

Vales' guide sections 9 & 10 contains the following information on inserting new accounts into your local loginserver table.
insert into tblLoginServerAccounts (AccountName, AccountPassword, AccountEmail, LastLoginDate, LastIPAddress) values('Admin', sha('password'), 'admin@somewhere.com', now(), '127.0.0.1');

I've not tried multiple logins yet as I've not been successful connecting to world over LAN, but I have tried various different accounts with success. I normally restarted mysql (from cmd prompt NET STOP MYSQL then NET START MYSQL) to refresh the database once the new DB and tables have been added and updated.

Yep been there done that in various forms, tried rewriting user name/passwords and restarting mysql. I even restarted computer a few times after edits...

No go, definatly starting to wear me a little thin.