Windows Server Setup Guide, 64bit

[Ikeren]

I'm looking at this guide: http://www.eqemulator.net/wiki/wikka.php?wakka=WindowsServerSetupGuide

I am interested in setting up a server to play offline (I work in a remote area and get internet 1-2 hours once or twice per week). I run a 64 bit windows 7. Can I still run the 32 bit server and play in it?

[wolfwalkereci]

Yes, you can run it using 32bit apps.
You could also run 64bit but its not really worth it and can be a pita esp if you only have net for limited periods of time.

[sorvani]

Make sure you select the login server in the cmake section so you can authenticate locally

[Ikeren]

@Sorvani: was that in my Cmake install? If so, I already did a default install, which is probably a mistake? Can I uninstall/reinstall just Cmake, or do I need to restart the whole process? Hmmm, looked at my install, that seems wrong. Going to try it in the next Cmake section.
"Use CMake to build the required Visual Studio Solution and Project files"

In the CMake section I see "EQEMU_BUILD_LOGIN". It's ticked off. I tick on, and hit generate/configure again. I'm hoping this is what I'm supposed to do.

[Ikeren]

The guide wrote:
========== Build: 9 succeeded, 0 failed, 0 up-to-date, 0 skipped ==========

My copy of Visual Studio wrote:

========== Build: 10 succeeded, 0 failed, 0 up-to-date, 0 skipped ==========

I imagine that I did something hideously wrong at this point.

[Ikeren]

Also, how fatal is it if the maps thing gets interrupted? My download times are limited chunks...and how big is the whole maps thing? I'm at 50mbs...is it 1 gig? 10gigs? 100 gigs?

[Uleat]

1.89 GB (2,030,268,416 bytes) for maps, then whatever for svn data.


I had issues with broken downloads at one point. It said something about the repository being locked.

I believe what I did was to select 'Clean up' from the TortoiseSVN sub-menu..let it do its thing..then update again.

[Ikeren]

Yep, the locked + cleanup thing happened for me, too.

Just looking for some clarification if the 10 successes rather than 9 means I did something wrong, and if I got the right thing in the CMake install at the moment, but I'm sure given my competence level, I'll have more trouble as I go on :P

[Derision]

You got 10 instead of 9 because you told CMake to build the login server.

The guide assumes you are going to be using the EQEmu Public login server because that is the easiest way to get started. There are some more steps required for setting up your own private login server, which are not covered by that guide.

[Ikeren]

I don't think I can use the public EQEmu server while Offline?

Is there a guide that is equally awesome and useful for someone marginally competent like myself for setting up my own private login server?

[KLS]

under loginserver/login_util there are the opcode.confs, login.ini, and EQEmuLoginServerDBInstall.sql for installing the login server.

I don't think anyone has written a guide for that per se but if you can understand all of those files it's enough to get off the ground. Otherwise we're always answering questions.

[lerxst2112]

This guide explained it enough for me to figure it out. It's pretty much source the install sql, edit as necessary to for accounts and such, put 127.0.0.1 in all the right places in the config file, and be happy.

http://www.eqemulator.org/forums/showthread.php?t=31783

[sorvani]

Also, how fatal is it if the maps thing gets interrupted? My download times are limited chunks...and how big is the whole maps thing? I'm at 50mbs...is it 1 gig? 10gigs? 100 gigs?

Assuming you click the stop or cancel button in Tortoise, next time you get online to do it it will pick up on the next file.

[Ikeren]

Maps thing seems to be working with interrupts, but given my limited times, this will be the major slowdown for the moment. I'll read the thread you linked Lerxst, thank you.

[wolfwalkereci]

If you really really wanted to use the eqemulogin you could. Have to make a few small changes in the source and there really is zero documentation about it.
Just dont use it.

[lerxst2112]

There aren't any c++ changes necessary to use your own local eqemuloginserver. Just an additional database for server/account information that is easy to create from the template file listed above.

[wolfwalkereci]

\source-github\loginserver
Go play with that then and tell me it works 100% for what you would expect it to do.
Now last time I compiled was second pull from git ripo so maybe someone out of the blue decided to work on it. Doubt that.
Expectations, maybe you have much lower ones then I do.

[lerxst2112]

\source-github\loginserver
Go play with that then and tell me it works 100% for what you would expect it to do.
Now last time I compiled was second pull from git ripo so maybe someone out of the blue decided to work on it. Doubt that.
Expectations, maybe you have much lower ones then I do.

Or perhaps, I'm willing to do a little research to get it working rather than just give up. Sourcing loginserver/login_util/EQEmuLoginServerDBInstall.sql creates all the tables and example entries you need to get it working.

This guide explains what they are for and how to set it up with your preferred values rather than the default: http://www.eqemulator.org/forums/showthread.php?t=31783

Since you didn't say anything in your posts about what particular problems you had other than "wah, it doesn't work" we can't help you with anything specific.

[Ikeren]

I'm not very smart or experienced with this, and my online time is really strongly limited to 1-2 hours every 3-4 days, so I'm having a bit of trouble following this argument.

In this section:

Verifying that you have copied all the files into your server directory

In your eqemu (server folder) there should be 7 folders.

1. logs (this will be empty right now)

2. Maps (full of all the map files you downloaded)

3. plugins (has all the plugin files you copied from /quests/plugins folder)

4. quests (has all the quests you downloaded.)

5. templates

6. updated_templates

7. worldui

Aside from those 7 folders, you should have 21 other files in your server folder.

I am missing the worldui folder. I have worldui.pl. I'm curious as to what I screwed up here? --- I imagine I forgot to copy it from somewhere, but when I run a search function on my laptop, I can't find the folder, either.


With regards to setting up the personal offline login server:
wolfwalkereci; are you saying there is another option to set up an offline login server aside from the EQEmulator server? Some sort of private program? I'm uncertain what you mean by "just don't use it."

@lerxst2112: I tried reading the first page of the thread you linked and it wasn't super effective on my brain. I got confused between the stuff I'd already done but he put in different places and the things for setting up the private server? I tried to do a line by line comparison of the guides but then got lost again, too. I don't suppose you could point to the sections he wrote specifically about setting up the offline EQEmulator Loginserver for personal use? Or is the problem that I've only read the 1st page and some of the material is on pages 2-8?

[Ikeren]

Alright. I went ahead; my revision (2506) is higher than any of the required updates in the cd C:\EQ\Source\utils\sql\svn folder

Then

There may be further updates to apply in the following folder:
C:\EQ\Source\utils\sql\git folder


I go to the required sub-folder.


There is an error in sourcing the mercenaries;
source 2013_03_01_Merc_Rules_and_Equipment.sql

ERROR 1005 <HY000>: Can't create table 'peq.merc_inventory' <errorno: 150>
ERROR 1146 <42S02>: Table 'peq.merc_inventory' doesn't exist.

Also, I stupidly sourced the next one after that (2013_03_23_Escape_FadingMemories)...

So I'm close to done, but 4 problems:
1) No Worldutils folder
2) source 2013_03_01_Merc_Rules_and_Equipment.sql at all
3) source 2013_03_23_Escape_FadingMemories.sql too early
4) No idea how to get the private server going yet...

Will keep working and keep everyone posted. Thanks for all the help, and sorry for being dumb.

[lerxst2112]

@lerxst2112: I tried reading the first page of the thread you linked and it wasn't super effective on my brain. I got confused between the stuff I'd already done but he put in different places and the things for setting up the private server? I tried to do a line by line comparison of the guides but then got lost again, too. I don't suppose you could point to the sections he wrote specifically about setting up the offline EQEmulator Loginserver for personal use? Or is the problem that I've only read the 1st page and some of the material is on pages 2-8?

The "Gather EQEmuLoginServer files", "Setup PEQLoginDB DB and Logins", and "Finalize Connection Settings" sections explain how to setup the login server for local use. Ignore everything else.

[Ikeren]

Sweet, thanks, that helps clear things up a lot.

[Uleat]

loginserver worked at one point in time, then was broken for Windows due to some unfinished upgrades.

A fix for that is posted on the forums, but it is all a moot point now because cmake generates the sln with proper configurations.


As far as Mercs, read this thread: http://www.eqemulator.org/forums/showthread.php?t=36676

[Ikeren]

I don't want to use mercs. Can I run without the mercs database update working?

Also, anyone have any idea why the worldui folder is missing?

[Ikeren]

Alright! I got the merc thing sourced, though with errors. I think I am good to launch my server and log in (the 4 windows popped up and they only seemed annoyed about me not being online).

I'm still worried about missing the worldui folder --- what does that mean?


I'm trying to follow that private server guide that was linked earlier by lerxst, but having a lot of trouble. In the first set of steps, for example:

Gather EQEmuLoginServer files (.ini, .conf, .dll) from EQEmu Build
• Go to the folder where you downloaded the server sources (C:\EQEmuSVNFiles\EQEmu) and navigate to:
o trunk > EQEmuServer > EQEmuLoginServer > login_util.
 Then copy: eqemulogin.ini and login_opcodes.conf to your server folder (C:\EQEmu).

I don't have these files. In C:\EQ\Source\loginserver\login_util, I have:
login.ini (is this = to eqemulogin.ini?) and login_opcodes.conf and login_opcodes_sod.conf.

I also don't have a C:\EQEmu folder. Is this the same as the C:\EQ\EQEmuServer folder ?

• Next, navigate to:
• trunk > EQEmuServer > EQEmuLoginServer > login_util > ms >debug

My login_util folder does not have ms or debug folders. A search on my computer doesn't reveal an EQEmuAuthCrypto.dll file.

• Then copy: EQEmuAuthCrypto.dll to your server folder (C:\EQEmu)


I'm wondering what I'm doing wrong here.