Windows Server Setup Guide, 64bit

[lerxst2112]

Originally Posted by 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.

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]

Originally Posted by Ikeren

@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.