Setting up server for Offline play

[Ikeren]

That laptop was overheating something bad so I sent it off for repairs, so unfortunately this is going to get delayed a little.

[PallbearerX]

I just got my server installed successfully today. For similar reasons I also needed to run my server as a local login machine as opposed to using eqemulator.net. Here are the steps I followed to get the login server working.

These are additional steps as an addendum to the wonderful server walkthrough found here.

1. Section "Use CMake to build the required Visual Studio Solution and Project files"

Click the box next to EQEMU_BUILD_LOGIN and then click Configure.

2. Section "Build the executables using Visual Studio"

You should see the results as follows.

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

Or if you're re-compiling you should see results similar to the following

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

3. Section "Copying the executables to your server directory"

Also copy the loginserver.exe (and loginserver.pdb optionally) from the \EQ\Source\Build\Bin\Debug directory into the \EQ\EQEmuServer directory.

4. Section "Downloading, installing and updating the PEQ database"

Also 'source in' the load_login.sql file.

5. Section "Editing your server confiugration - eqemu_config.xml"

Edit the login server section to point to the local server.

<loginserver>
  <host>127.0.0.1</host>
  <port>5998</port>
  <account></account>
  <password></password>
</loginserver>

6. Section "Creating a batch file to launch the server"

Add a line to the batch file to start the login server before the world.

@echo off
shared_memory.exe
start loginserver.exe
start world.exe
echo Waiting for the world to finish loading before starting zones...
ping -n 10 127.0.0.1 > nul
start queryserv.exe
start ucs.exe
start eqlaunch.exe zone
exit

Additional steps required:

1. Download the file "Windows_LoginServerCrypto_x86.zip" from github and extract its contents.

2. Copy the "EQEmuAuthCrypto.dll" file from the extracted archive (release folder) into the \EQ\EQEmuServer folder.

3. In the \EQ\Source\loginserver\login_util folder, edit the login.ini file and provide DB access information.

[database]
host = localhost
port = 3306
db = peq
user = root
password = <your_password>
subsystem = MySQL

4. Copy the following files from the \EQ\Source\loginserver\login_util folder to the \EQ\EQEmuServer folder.

login.ini
login_opcodes.conf
login_opcodes_sod.conf

After the above steps I was able to successfully log onto my server locally.

YMMV...

PbX

[purpose]

This guide helped ALOT!

Thank you.

Have you had any issues with login accounts using this? I am unable to get mine to work, and the Admin/Password does not work as well.

[Fatmaneric]

Originally Posted by PallbearerX

3. In the \EQ\Source\loginserver\login_util folder, edit the login.ini file and provide DB access information.

[database]
host = localhost
port = 3306
db = peq
user = root
password = <your_password>
subsystem = MySQL

I followed all of the steps you listed, but for some reason the loginserver crashes each time. The log says it can't connect to the MySQL database though I've checked and rechecked to make sure I was spelling peq, root, and my password correctly and there were no typos. I've tried with and without the greater than/less than signs on my password (which was typed case sensitive), and I even tried changing localhost to 127.0.0.1, though I doubted that would work anyway. Any idea? The worst part is that the error message I get is just an accented upper case Y repeated a few hundred time. ÝÝÝÝÝÝ. So I can't even look that up. Any ideas what I'm doing wrong? The rest of the server EXEs work fine and have no problem connecting to peq.

In the threads I've looked in so far, people point to a different install guide than the one that is stickied. I tried doing just the log in server portion but ran into troubles with that, and just want to get this one step working.