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.

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.

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 ;)

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.

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.

I am in the same boat. I have tried for weeks with different usernames and passwords (sha and plain). I have the variable set to "Public" instead of "minilogin". I have tried various IP settings in the eqemu_config.xml and eqhost.txt (router address, lan address, server address, 127.0.0.1, dyndns address, no-ip.biz address, localhost). World.exe connects to the login server and I can watch the login command window reject my user name "Could not find user 5da4c2c" but I can't get past "Error - The username and/or password were not valid. Please check them and try again." on the EQ login screen. I am not sure if the encrypted username in the login command window means anything (it isn't encrypted in the login database).

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.

Working now with 946 build
 

:D 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 :-)

"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?

now this is where I am getting lost...

I can't find that file. Help?

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.

This may sound like a dumb question but how do you actually get into the web interface? I know it's your server addy with the port:9080 but it prompts me for a username and password. I don't ever remember setting a specific login for this access and my database login doesn't seem to work.

This sounds like it could resolve my issue as well (or at least it seems to describe my problem). Can someone (perhaps Speedz) provide more detail on the web interface? Thanks!

The web interface I use were included in the package that the installer from http://forums.nahunta.org/index.php provides.

The problem is it's not current and takes mega tweaking to use the current builds. (I would avoid trying if you are doing something completely different)

Another thing you could try is find a SHA1 tool that will spit out the hash of any entered text and copy paste that into the password field in the database.

Sometime soon I will do a sql dump of all tables involved in my ability to connect to my server. Maybe that will help some (ovbiously I'll remove my info, but I will enter info that will connect if you use them directly).

I have no time atm to do this, sorry. But I will soonish.

MySQL supports sha1 with the sha() function. If you want to change your password in the db you can just use UPDATE table_name SET password = sha('newpassword') WHERE username = 'yourusername';

(replace the fields/table name with the ones for your table).

There are also various websites that will compute a sha1 hash for you.

Tried copy paste of the hash and that didn't work (nice idea though).

I read a suggestion of changing my password to "11111111" and I was FINALLY able to get past the login screen and to the server select screen. Thank you for the suggestion.

When is the screenshots gonna be posted for each of the steps? It appears I didn't get some of the things right, arrgghh, may have to start over.

I wasn't going to post screen shots, I was going to post a sql dump of the bits in my database that handle logging in and verifying user. But, I realized this really won't be enough.

The guides are a bit old (except this one, tho I found I had issues following it to the letter, not sure why but I will retrace and figure it out) and tho they do point you in the right directions I found that I needed to do ALOT of research to get mine running in offline mode.

I will eventually post a complete current write up of how-to. But it will take me a bit as I do this in my freetime as the devs who provide us with the awsome code.

I will drop all EQEmu related things from one of my computers and reinstall everything and document in true anal fashion so as to not miss out on anything.

With the way I write up guides, if you mess up there is no hope for you :-P.

So, with that said, freetime and the nature of what I will do.....don't expect it too awful soon. But it should get you rolling in the right direction.

Speedz out

I am confuse.d.. creating the server this way --- is it now a private login setup separate from eqemulator.net?

ok I did this and now I am getting a perl error (Perl_hv_common_key_len could not be located in the dynamic link library perl58.dll any help please

I am useing ActivePerl-5.8.9.826-MSWin32-x86-290470.msi and peqdatabase-Rev946

and build Rev946-Bots.zip

I have tried to uninstall perl 5.8 and install 5.10 and I still get a can't find perl58.dll error any help please

I just got the same error using this guild i have gotten farther than any other guild so thank you for this guild now i think the only thing i need to do is fix this one error.

Using the login
 

I can get the login server to load and let me log in.. the problem I am having is that the world server does not load and it shows I have 0 of 0 expansions.

Might I get some help with this?

ok got past that problem... new problem. People connecting from the outside are not able to get past character creation.

The world server shows it is sending them to the zone, but they never get there.

ok how did you get past that error ??

okay got past the perl problem no i have a new problem and that is i can't see my server. I can login locally but see no server name.

how i got past was i uninstalled perl 5.8.8 build 822 restarted. searched for any files that had perl in their name (found none) installed perl 5.8.9 build 826 and perl error fixed i hope this will help you out.

Ok, I dont know if this problem is in this thread, as there is a lot to read through, but there is one problem I ran into just with my OS, that you might consider editing into your guide (which is great btw)......... If you are using Windows vista (not sure it 64 bit makes the difference or not), you might want to turn off UAC before attemping the "checkout SVN" step. When I tried it, it kept telling me cannot create directory blah, blah, blah... After disabling UAC (which you can do by running "msconfig" and choosing the tools tab and launching the "disable UAC"), I was able to make it happen.

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

Hi all and thanks for this guild
I have my server up but I think I am missing a few things
1) my server is not listed on the LS
2) I can connected with 2 computers on the network but am unable to connect from the internet, getting Error 1017

I am running XP Sp3 Eqemu ver 8.0 DB 946
any help would be great

got it thanks

extract it to where? ....

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.



create this folder where?

Download Revision 774 with Bots here. that link on first page dont work

Has the bots have a new link?
 

Has the bots have a new link?

Stuck on step 4 Please help
 

I am trying this install but am stuck on step 4. When I try to source the database I get:
ERROR:
Failed to open file 'peqdb_rev1038.sql' , error: 2

Read in the post where someone was having same issue and figured it out but unfortunately didn't say what to do to fix problem. If anyone can help me I would really appreciate it.

server pack link
 

You can get the server pack from:
http://code.google.com/p/projecteqemu/downloads/list
hope that helps