Updated Windows Server Setup Guide

[Speedz]

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.

[EQFAN2009]

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.

[Speedz]

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.

[Speedz]

You know, I had a thought...Not sure if this has been discussed before.

But what about creating a VM with the basics needed to run an up-to-date server that people can grab?

Maybe every once in a while (obviously not constantly) remake or update it.

[hybrid125]

In this guide, Perl 5.10 is used. How come it was never revised to state that 5.8.9 works and Perl 5.10 doesn't? Or are there some envirornmental factors that were not mentioned?

I'm using a fresh Windows XP Pro, SP2 install on a P4 3.2. Pretty basic rig. Windows Firewall/IC Sharing has been disabled. Antivirus protection disabled (for testing purposes right now). When I try to follow this guide exactly, I get the perl58.dll error. If I install Perl 5.8.9, I get a 1017 error and it says I own 0 of 0 expansions. And this is happening when I fire up EQ Titanium on the same box that is running ther server. I see others posting about questions beyond the initial login to their world server.

Are there some login or world server values that someone can give me that they know work. For instance, if I try U/N: usernameusername and P/W: passwordpassword, it will not let me past the login screen, but if I use U/N: myusername29 and P/W: password2370, it works? I haven't figured out a pattern there.

Also, my server shortname and longname are the same. Is that a problem? I've tried making them different but I still got the error message.

[Melcrin]

I've done everything word for word but I seem to be stuck at step 4. I keep getting wrong syntax errors. Just curious as to what I am missing here.

Edit: Derp nevermind figured it out

[Melcrin]

Ok i'm not sure why but when I put into my database:

source load_player.sql;

source load_bots.sql;

I get "failed to open file 'load_player.sql' , error: 2"
same with the bot sql.

It also did the same thing with the peq_db_rev922.sql
so I figured I would bypass the command prompt and just do it through heidisql which worked in putting the tables in my database.

I tried the same thing with the load_player and load_bots sql but it says the syntax is incorrect.

I'm positive the code was written correctly or else no one would of got it to work.

I've done everything word for word just not sure what the deal is.

[Shiny151]

Originally Posted by hybrid125

In this guide, Perl 5.10 is used. How come it was never revised to state that 5.8.9 works and Perl 5.10 doesn't? Or are there some envirornmental factors that were not mentioned?

I've actually followed this guide and installed ActivePerl-5.10.0.1005-MSWin32-x86-290470 and the only thing I can't seem to get functioning is connecting WAN clients. I'm not sure it has anything to do with Perl but just thought I'd throw that out there.

[hybrid125]

Originally Posted by Shiny151

I've actually followed this guide and installed ActivePerl-5.10.0.1005-MSWin32-x86-290470 and the only thing I can't seem to get functioning is connecting WAN clients. I'm not sure it has anything to do with Perl but just thought I'd throw that out there.

Hmmm....
I'm using
ActivePerl-5.10.0.1004-MSWin32-x86-287188.msi
EQEmu Server Rev884 w/Bots
I believe Rev 922....or 992 database, whichever is the most recent
and mysql-5.1.37-win32.msi

I'll try ActivePerl-5.10.0.1005-MSWin32-x86-290470 when I get home tonight and see if I can get that working.

If that gets it up I'll have a friend try to connect over WAN and see if I get the same result you got and let you know.

[Runeblade]

dang i wish the old guides were all still working back from 2007. I was able to make them work flawlessly.

[Speedz]

I have given up trying to get this working in this manner.
I have full success using this:

http://forums.nahunta.org/index.php

From installing this I have used it as a base to get databases working correctly from PEQ.

[EQFAN2009]

Finally I've got it working now bots and all on a Windows box. Am using the eqemulator.net login to connect. Didn't do anything different from previous compile time so my conclusion is that the compile-source available when the 922 db was the latest, was dodgy somehow leading to a bad world.exe &/or zone.exe.

Had some problems with rule_values and variables tables missing but train-smashed my 922 db with the 946 .sqls That is I updated Rev946-Bots.sql without first dropping player and bots tables. Got few errors of duplicate entries whereas was previously getting 'peq.rule_values' missing errors.

Not pretty - but functional

[yizuman]

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

What server folder?? Where?? How do I do this?

[yizuman]

now this is where I am getting lost...

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.

I can't find that file. Help?

[Speedz]

Ran into a fix for my invalid username/password issue.

If you create a account with the web page interface (at least the one I have) it hashes the password wrong. it used md5. I changed it to sha and yay it worked.....

Please post results if this works for you so others can be somewhat certain of the fix.