Windows Server Installer :: Modular & Scripted

[goddest]

I had not input my IP in login.ini, it was not in Akka's instructions :(. Unfortunately after changing that my client still freezes after hitting enter world. This is not a clean install of windows and I am using Windows 10 x64.

eqemu_config.xml
<server>
<world>
<shortname>ZZZdev</shortname>
<longname>ZZ In DEV ZZ</longname>

<address>192.168.1.107</address>
<localaddress>127.0.0.1</localaddress>

<loginserver1>
<host>login.eqemulator.net</host>
<port>5998</port>
<account></account>
<password></password>
</loginserver1>
<loginserver2>
<host>192.168.1.107</host>
<port>5998</port>
<account></account>
<password></password>
</loginserver2>

<address>192.168.1.107</address>
<localaddress>127.0.0.1</localaddress> Moved these 2 lines where needed to be all most be in line!
[/COLOR]<tcp ip="127.0.0.1" port="9000" telnet="enable"/>

<key>BgxCRMpLgJaEalzmIiGySCcKTAUQzIJ</key>

<http port="9080" enabled="true" mimefile="mime.types" />
</world>

<chatserver>
<host></host>
<port>7500</port>
</chatserver>

<mailserver>
<host></host>
<port>7500</port>
</mailserver>

<zones>
<defaultstatus>0</defaultstatus>

<ports low="7000" high="7400"/>
</zones>

<database>
<host>localhost</host>
<port>3306</port>
<username>root</username>
<password>eqemu</password>
<db>peq</db>
</database>

<qsdatabase>
<host>localhost</host>
<port>3306</port>
<username>root</username>
<password>eqemu</password>
<db>peq</db>
</qsdatabase>

<webinterface>
<port>9081</port>
</webinterface>

<launcher>
</launcher>

<files>
</files>
<directories>
</directories>
</server>


login.ini

[database]
host = localhost
port = 3306
db = peq
user = root
password = eqemu
subsystem = MySQL

[options]
unregistered_allowed = TRUE
reject_duplicate_servers = FALSE
trace = TRUE
world_trace = FALSE
dump_packets_in = FALSE
dump_packets_out = FALSE
listen_port = 5998
local_network = 192.168.1.107
auto_create_accounts = TRUE

[security]
plugin = EQEmuAuthCrypto
mode = 5

[Titanium]
port = 5998
opcodes = login_opcodes.conf

[SoD]
port = 5999
opcodes = login_opcodes_sod.conf

[schema]
account_table = loginserver_server_accounts
world_registration_table = loginserver_world_server_registration
world_admin_registration_table = loginserver_server_admin_registration
world_server_type_table = loginserver_server_list_type

Changed couple thins for you if you are still having issues it may be because you had a previous install of msql, and such all paths must be deleted! Be sure to change the eqhost.txt to 127.0.0.1:5998 other users use 192.168.1.107:5998 5998 ports if not using sof if you are change the port to 5999 in the eqhost.text in the eq folder

Also when you downloaded the installer did you first create a folder called EQEmuServer and did you open the installer.rar file & extract all the files to this folder?

[goddest]

http://imageshack.com/a/img923/7443/7wpvO6.png

this is what your folder should look like after u have run the eqemu_install.bat file as administrator one more thing make sure to right click folder properties and uncheck read only before running the eqemu_install.bat

[Five]

I don't think my database is being installed in the correct directory. After starting the start batch, it shows World: UP Zones (counts from 1 to 30) then shows World: Down. This repeats infinitely and the server never appears on the server select. Additionally I cannot find hte DB in HeidiSQL
What is the default install directory for the database?

Edit: It seems everything located at raw.githubusercontent.com/EQEmu/Server/Master... fails to find the path specified and does not install, which looks like is pretty much the entire database
Edit2: I was able to find the database from the manual installation and get it installed, Now when i try to load the server, world.exe spams Missing update XXXX Cannot find path to file specified over and over for many different files. This evenually ceases and server appears on server select however always CTD when trying to enter the world.

https://s29.postimg.org/4rggjovtj/Capture.png


Can anyone point me to where I can find all the missing files? Thanks!

[Akkadius]

Your guys' MySQL/MariaDB installation is not having a path reference in the installer, what version of Windows are you using

[Five]

Hey Akka - Win 10 here. Thanks for the installers and all the hard work. I will check around and try a few different things with MariaDB today and see if I can get it going.

[Maze_EQ]

FYI

Windows 2016 test today.

Noticed a few things that were funky.

I'm completely familiar with the manual setup of EQ, as I've done this a few hundred times.

https://i.imgur.com/hYUgHnw.png

During the automated install I noticed the database didn't have the correct player_tables sourced in.

I manually sourced the player tables in the zip that the installer pulls, still didn't contain the correct data.

I then grabbed the weekly from PEQ directly (peqbeta_2017-02-22-02-01.tar.gz) and sourced everything manually.

The correct tables showed.

Not sure if I made a mistake somewhere (Possible) but wanted to bring this to akkadius' attention.

See below: Akka's installer .zip sourced.

https://i.imgur.com/WgdLikG.png


See below: PEQ Weekly manually downloaded and sourced.

https://i.imgur.com/C7afkip.png


Can see there's missing tables in peqbeta.sql/player_tables.sql as compared to peqbeta_2017-02-22-02:01.sql/player_tables_2017-02-22-02:01.sql

Just an observation, is anyone else having this issue or just me?

[joligario]

Does https://github.com/EQEmu/Server/commit/e0988369349c5984f1e6ca16942dea91630b4cbd get after the issue?

[Maze_EQ]

Guess he already caught it.

Well disregard lol.

Was a fresh install using the script this morning.

Figured I'd bring it to attention.

[McMayhem88]

Okay so I've been trying to setup a server since yesterday. Went through the link shown in the Getting Started Guide that is shown on the main page (which is the Complete Windows-based Server Setup Guide, but that broke down at the SVN Checkout phase. Then I found the Akka Server Setup Install linked here and that actually got everything setup in just a few moments (great work on that).

My issue now is when I run the t_start_server.bat or the t_start_server_with_login_server.bat I'm getting this weird loop where it starts out at 0/30 zones then gets to 30/30 zones and then restarts the process over and over. I see a few windows pop up but nothing else. I went through every step outlined in the guide even though I guess eqemu_update.pl has been replaced with eqemu_server.pl? I didn't see that mentioned in the guide :/.

Anyway, I'm currently stuck in this loop. Hoping someone else has dealt with this and figured it out.

Any help would be greatly appreciated. Sorry if this has been asked before, but there are so many "guides" and "wiki pages" that seem to be out of date now that I was hoping to get some info straight from the source.

[Akkadius]

Installer is broken due to PEQ being moved recently. Have patience and I'll fix it when I have a moment, I've been on vacation and I'll update when it's fixed

[McMayhem88]

Thanks Akkadius. I appreciate the quick response. Just wanted to make sure I didn't skip something important. Certainly no rush on my account. Please, enjoy your vacation!

[Akkadius]

I fixed the PEQ dumps.

I've also tested the installer again, it seems to be happy now.

http://i.imgur.com/WA01oZa.png

Let me know if you guys run into anything else.

[Maze_EQ]

Well, just for verification purposes, I spun up a new VM (2k12) and it installed just fine.

No issues I can see.

https://i.imgur.com/TxElYfH.png

thanks bruh

[McMayhem88]

I can confirm all my issues have now been fixed. Thank you so much for the speedy fix Akkadius!

[Ruldain]

Good evening -

Details:
- In-house Server (only for local lan play)
- ROF2 client
- Windows 10 x64 Pro Server
- Using latest PEQ database

I'm wondering if anyone using Akka's Win Server installer has Mercenaries working? Upon trying initially I was unable to get the Mercenary Vendors to even acknowledge a right click to bring up a vendor window. I ran the SQL against PEQ and was able to get the merchant window to appear
<code>UPDATE `peq`.`npc_types` SET `class`='71' WHERE `lastname` LIKE '%Mercenary Liaison'; </code>
Needless to say I see posts that it is possible to do this but I'm looking for a step by step or hyperlink that addresses this further as I've so far been unable to find one that directly applies.
To those that ask why not use BOTS is that I'm wanting the ability to generate Mercs instead of Bots...
Originally I found this site http://www.eqemulator.org/forums/showthread.php?t=40713 and only the last statement worked against the database.

TIA,

Ruldain

P.S. - Love the work done so far on this - 17 year fan of EQ

[ChaosSlayerZ]

Question.

I am trying to use Akkadius sever self-install on friends PC which runs Windows Vista and install doesn't seem to ever finish - even after an hour of running.
I know Vista is a crapy os, but this what I have to work with, does self-install even works on Vista?

Thanks!

[Uleat]

I honestly don't know...

Have you tried downloading newer runtimes?

[ChaosSlayerZ]

Sorry no, I will try. ;)
I didn't had much time to play with it, was hopping auto-installer to take care of that ;)

I do realize Vista probably wasn't even considered as server platform ;)

[drelk001]

After running the t_start_server.BAT
I got this error.
http://i.imgur.com/FjI6a93.png


I installed everything at some point while running the Server setup I got this error

http://i.imgur.com/88UUafO.png

Help?
What do I do?

[drelk001]

Imma just uninstall everything and retry. ill let you guys know if anything changes.

[Akkadius]

Imma just uninstall everything and retry. ill let you guys know if anything changes.

Are you running Windows XP?

It looks like you are, it is not supported by the launcher.

Compatibility:

- Windows 7 - x64
- Windows 8 - x64
- Windows Server 2012 - x64

[drelk001]

Are you running Windows XP?

It looks like you are, it is not supported by the launcher.

Compatibility:

- Windows 7 - x64
- Windows 8 - x64
- Windows Server 2012 - x64

im using windows 7
I got a server up and running now. Thanks a ton. this is super cool.

[Akkadius]

I have been looking around and still cant find it. is there a way to have GM commands for my server?

That is beyond the scope of this thread, you can use the wiki or forums search to find most answers to your questions

[Uleat]

Windows binaries have been updated to include the glm library update.

[Greenlantern78]

I am a mere mortal who does not understand networking at all. I have followed the instructions to the letter and read all of these replies. I can't get my Titanium client to connect to the server. It just stays on "patching..." Any help is appreciated.

I have created a shortcut with patchme after the target. I also attempted to add those address lines to my config.xml but it caused some kind of weird loop error when starting the server. The address lines were not there without me adding them (as you will see below).

Here are my files as of right now:

login ini:

[database]
host = localhost
port = 3306
db = peq
user = root
password = eqemu
subsystem = MySQL

[options]
unregistered_allowed = TRUE
reject_duplicate_servers = FALSE
trace = TRUE
world_trace = FALSE
dump_packets_in = FALSE
dump_packets_out = FALSE
listen_port = 5998
local_network = 10.0.0.24
auto_create_accounts = TRUE

[security]
plugin = EQEmuAuthCrypto
mode = 5

[Titanium]
port = 5998
opcodes = login_opcodes.conf

[SoD]
port = 5999
opcodes = login_opcodes_sod.conf

[schema]
account_table = loginserver_server_accounts
world_registration_table = loginserver_world_server_registration
world_admin_registration_table = loginserver_server_admin_registration
world_server_type_table = loginserver_server_list_type

eqemu_config:

<?xml version="1.0">
<server>
<world>
<shortname>Widowmaker</shortname>
<longname>Widowmakers Realm</longname>


<loginserver1>
<host>login.eqemulator.net</host>
<port>5998</port>
<account></account>
<password></password>
</loginserver1>
<loginserver2>
<host>10.0.0.24</host>
<port>5998</port>
<account></account>
<password></password>
</loginserver2>



<tcp ip="127.0.0.1" port="9000" telnet="enable"/>

<key>l6ZkKz74UcNqp1oo6i0JjPyYU5GCLGp</key>

<http port="9080" enabled="true" mimefile="mime.types" />
</world>

<chatserver>
<host></host>
<port>7500</port>
</chatserver>

<mailserver>
<host></host>
<port>7500</port>
</mailserver>

<zones>
<defaultstatus>0</defaultstatus>

<ports low="7000" high="7400"/>
</zones>

<database>
<host>localhost</host>
<port>3306</port>
<username>root</username>
<password>eqemu</password>
<db>peq</db>
</database>

<qsdatabase>
<host>localhost</host>
<port>3306</port>
<username>root</username>
<password>eqemu</password>
<db>peq</db>
</qsdatabase>

<webinterface>
<port>9081</port>
</webinterface>

<launcher>
</launcher>

<files>
</files>
<directories>
</directories>
</server>

EQ Host:

[LoginServer]
Host=10.0.0.24:5999 (I have also tried 5998)

I am using the downloadable installer that was updated as of today. But I also had this same issue with the one available yesterday.

No errors are reported when I run the server with login, except this one in EQEmu Login Server: "[Error HandleNewLSInfo error, remote address was null, defaulting to stream address 10.0.0.24."

The address lines I tried (from earlier posts in here) was:

<address>10.0.0.24</address>
<localaddress>127.0.0.1</localaddress>

I started to have the weird loop problem after I added this. Did not seem to matter where I added it.

Any help is appreciated. I would love to play EQ in my own server.

[Uleat]

If it says `patching,` then this part of the problem isn't in your config.

http://wiki.eqemulator.org/p?Play_Guide:_Getting_Started&frm=Main--Frequently_Asked_Questions#step-5-creating-shortcut

[Greenlantern78]

Thank you. I knew I was missing something simple. I was trying to run the game from the everquest.exe, not eqgame.exe (in my defense it has been like 10 years since I played). I switched and then connected but could not see my server in the realmlist. Then I switched the eqhost to 5998. It appears to be working now. Appreciate your help!

[Uleat]

If the game actually did patch, you will need to re-install the game client.

You can try the shortcut before going through all of that, though.

[Greenlantern78]

It never actually patched, so no problem there. Thank you again for making me see my problem. Also, thanks to Akkadius for making this sweet, sweet installer.

[bkiv]

TLDR; I probably just need to be pointed to a beginners guide for dummies, but can't find one.

I am a long-time EQ player who is now an EQ emulator player, and hope to create a custom server as an artistic outlet. I have zero experience with anything related to what's needed to begin creating.

I got the server up and running (Windows 7, 64 bit), and after a little fumbling I was able to get a fresh titanium install connected to my server via EQemulator (couldn't figure out LAN, but not 100% sure why I'd need it at this point). This process was well-written and I really appreciate it! The game looks and feels excellent.

Now I feel I am kind of on a wild goose chase. There is a ton of information out there, but I don't know how to take the first step toward creating. Working on making my char a GM, and getting connected to EQEmu Operations Center for Development. Slowly discovering more and more though. Thank you again for all your hard work!

[jpyou127]

Akkadius, is your installer expedition ready? Or do we need to follow he procedure to make expeditions usable?

[Akkadius]

Akkadius, is your installer expedition ready? Or do we need to follow he procedure to make expeditions usable?

It is not, and the current code on the Wiki for expeditions is old.

I'll look at releasing expeditions at a later date. There's quite a few things I have to do before that point.

[jpyou127]

No problem, instancing and task system works?

[bcvoyager]

Installed on a clean Windows 7 install.

I'm able to see the server in the public list and get to the character creation screen, however, when I try and enter the zone, I disconnect.

Anything I should check first?

Edit: Okay, so I figured out that it was necessary to change my address in eqhost to the ip of the server. Apparently you cannot connect through eqemu server list name? Not a big deal I suppose! Great, got the install, off to Crushbone!

Thanks

[gracks]

I was able to get the server up and running on a Win7 virtual machine, but I can't connect to it.

I get this message:

http://imgur.com/pTogNwG

I read and re-read Akkas' guide several times and tried different ips, but no luck. Is a VM's ip for sure the IPv4 Address that comes up in ipconfig? I'm trying to figure out whether I've somehow got the ip of my VM wrong, or whether the issue is something else.

Also, just to confirm: I should be able to connect with vanilla EQ Titanium, right?

[Gamist]

Love the ease of this pack, it's worked very smoothly so far. But unfortunately I can't seem to run my server offline. The instructions for this pack says that I didn't need internet after the install was done. But I tried afterwards and it doesn't want to load the server without an internet connection. I followed all the steps for a LAN setup. And it tested fine with the internet on, but not without. Am I missing something here?

[Akkadius]

Love the ease of this pack, it's worked very smoothly so far. But unfortunately I can't seem to run my server offline. The instructions for this pack says that I didn't need internet after the install was done. But I tried afterwards and it doesn't want to load the server without an internet connection. I followed all the steps for a LAN setup. And it tested fine with the internet on, but not without. Am I missing something here?

What do you mean it doesn't want to load the server without an internet connection?

Can you give more detail on this

[Gamist]

What do you mean it doesn't want to load the server without an internet connection?

Can you give more detail on this

Augh! I'm the idiot here. I looked back over my eqemu_config.xml, and there was one place where I didn't enter my ip correctly, so that was why my server wasn't connecting offline! But I just tested it and it works perfectly now!

Seriously though, you've saved me hours of headache with this pack!

Just one other question, no big deal if you don't know it, but when I start Everquest, it always defaults to a window instead of Fullscreen. I've tried changing it in-game to fullscreen and even used alt-enter, but as soon as I click in the game it switches it back to a small window. The game is still playable, but playing in window mode is just annoying. Thanks again!:D

[Hao3w]

Nice job,just come here to say 'thanks'!

Installed fluently on WINDOWS 7 and WINDOWS 2012 R2 ,also played successfully both on LAN and Internet,perfect and amazing!

[Fridgecritter]

Deleted comment. My error

[StrangeBrew]

Hello, I decided to try running my own server. I read the instructions and downloaded eqemu_installer_files.zip extracted and proceeded to run eqemu_install.bat as administrator. The install did not finished though as I received the following error.

--------------------------------------

[Update] Fetched latest plugins
format error: file is too short
at C:/Perl/lib/Archive/Zip/Archive.pm line 667
Archive::Zip::Archive::_findEndOfCentralDirectory( 'Archive::Zip::Archive=HASH(0x3c9ffb4)', 'IO::File=GLOB(0x3ea401c)') called at C:/Perl/lib/A
rchive/Zip/Archive.pm line 581
Archive::Zip::Archive::readFromFileHandle('Archive ::Zip::Archive=HASH(0x3c9ffb4)', 'IO::File=GLOB(0x3ea401c)', 'updates_staged/Quests-Plugins-
master.zip') called at C:/Perl/lib/Archive/Zip/Archive.pm line 548
Archive::Zip::Archive::read('Archive::Zip::Archive =HASH(0x3c9ffb4)', 'updates_staged/Quests-Plugins-master.zip') called at eqemu_server.pl lin
e 1700
main::unzip('updates_staged/Quests-Plugins-master.zip', 'updates_staged/') called at eqemu_server.pl line 1628
main::plugins_fetch() called at eqemu_server.pl line 382
main::do_installer_routines() called at eqemu_server.pl line 271
main::new_server() called at eqemu_server.pl line 765
main::show_menu_prompt() called at eqemu_server.pl line 483
main::check_for_world_bootup_database_update() called at eqemu_server.pl line 71
read error at eqemu_server.pl line 1701.
Press any key to continue . . .
------------------------------------------------------

I tried downloading the file 'https://github.com/EQEmu/Quests-Plugins/archive/master.zip' manually but received a 404 error from the github site. Is there a new location where this file is obtained?

Thanks in advance for any help!

[klipche]

Will this run on Win10? I installed it under win10 and it all seems to run but when I try to connect with my eq client the login just stays trying to log in. Never says could not connect or never does connect just paused in the state of trying.

[Fridgecritter]

I did a search for the error I'm having, and it seems it was happening to a few other people in the past, once when peq was moved for some reason? Anyhow what's happening now is after starting the start batch, it shows World: UP Zones (counts from 1 to 30) then shows World: Down. This repeats infinitely and the server never appears on the server select. Nothing shows in the logs except the last data from when I logged in with my eq client.

After reinstalling the server, I edited the config file and added </locked> to it, but apparently I'm adding it in the wrong spot in the config. That was the issue that was causing the loop. I deleted that </locked> part and it ran perfectly. Now I just need to know where to put the </locked> part so the server starts up locked by default while I develop it.

[Drakiyth]

How's it going Akkadius?

This new installer you created looks pretty amazing and I hope I can get it to work on Windows 10. I have been gone for a good while after I decided to cancel my last project before ever being released. I want to get back on EQemu and see what I can brew up again but I am rusty as old nails. I ran into an issue with the installer files that are directly from the wiki. It doesn't appear to be pulling the database correctly. Any help would be awesome. Thank you.


https://image.prntscr.com/image/vBEZWu8FQke4Lq5v7EwIvg.png

[Akkadius]

How's it going Akkadius?

This new installer you created looks pretty amazing and I hope I can get it to work on Windows 10. I have been gone for a good while after I decided to cancel my last project before ever being released. I want to get back on EQemu and see what I can brew up again but I am rusty as old nails. I ran into an issue with the installer files that are directly from the wiki. It doesn't appear to be pulling the database correctly. Any help would be awesome. Thank you.




This means you're missing the path to your MySQL bin folder - which the installer adds. Usually this is because someone already has had a database engine installed prior when the installer clearly mentions 'clean install'.

Uninstall MariaDB, remove the folder from program files.

Download the installer fresh - run as admin

[Drakiyth]

This means you're missing the path to your MySQL bin folder - which the installer adds. Usually this is because someone already has had a database engine installed prior when the installer clearly mentions 'clean install'.

Uninstall MariaDB, remove the folder from program files.

Download the installer fresh - run as admin

Nevermind.. This is too stressful trying without a fresh install. I might just reformat tomorrow.

[rixcraven]

Just tried the installer on a brand new Win7pro (using VMware)
installer ran through noting a few errors that did not stop it completing.
However, when I try to run it (either just the server OR the server with login) the window opens then disappears immediately.
Trying to launch World.exe brings up "api-ms-win-crt-runtime-l1-1-0.dll" missing, So I got the .dll and dropped it into the install folder, retrying the server start and got the same immediate closure, starting world.exe reports
"The app was unable to start correctly (0xc00007b)"
I really need some advice on this... I'm not a beginner, but this is perplexing me.

[Akkadius]

I've never heard of that DLL issue before and doesn't sound right at all - I guess is start over from a fully updated win7 box

[The_Beast]

I run into that once, was no big deal, just a bad install : Visual C++ Redistributable for Visual Studio 2015

[rixcraven]

I did the c++ redist install... was reported as ok.
on server restart I now get "The procedure entry point ucrtbase.terminate could not be located in the dynamic link library api-ms-win-crt-runtime"
Would this be easier like Akka suggested, just remove it all and do a new full install?

BTW, a big thanks for the help so far!!!

[The_Beast]

I was only indicating my issue, with that same error, but there could be many causes. I did read a very common one is TortoiseSVN 1.9
I don't use that myself, but it's another option to look at if you do use, otherwise, ya, just do a wipe and reinstall, lol

[wimwickett]

Hello,

First time setting this up. I am able to login no problem but I can't find the database in the install folder.

Where can I find the database files? (.sql) I want to tweak some of the exp entries.

Thank you for this easy set-up btw. Very helpful.

[Toony]

Hello,

First time setting this up. I am able to login no problem but I can't find the database in the install folder.

Where can I find the database files? (.sql) I want to tweak some of the exp entries.

Thank you for this easy set-up btw. Very helpful.

Open the included HeidiSQL app, login with the credentials found in your eqemu_config file and select the PEQ database.

[wimwickett]

I'm in! Thank you so much.

[The_Beast]

I can't find the database in the install folder.


There is no "folder" for the database. The whole database is on a server created which has to be accessed with a program like Toony suggested.
Just sayin ...... :P

[marianoryu]

Greetings!

Please forgive the inconvenience - I am new to EQEmu, and I will admit things get a little complex for me sometimes.

I am interested in setting up a private server, I am running Everquest Titanium in Windows 10 x64.

I am trying to follow this guide (http://wiki.eqemulator.org/p?Akkas_PEQ_Server_Installer&frm=Main#from-scratch-installation-instructions-windows).

I have just ran eqemu_install.bat as Administrator. What should I do once the process is finished?

[rixcraven]

Thanks fot the previous answers!.. a quick wipe and the installer is great under 2012r2 server.
There are just Two things, one is whenever I try to run the server updater (eqemu_server.pl) I get the following message :- "wget is not recognised as an internal or external command". world is not recognised either. And finally,
no database connection found...running without.
Everything else works great, stable under 2012.
I have tried setting the path for wget, no luck, tried running wget as admin, no luck, DL'd the latest version of wget, no luck.
I'd really like to get this working!!!... please let me know your thoughts.

[Toony]

Thanks fot the previous answers!.. a quick wipe and the installer is great under 2012r2 server.
There are just Two things, one is whenever I try to run the server updater (eqemu_server.pl) I get the following message :- "wget is not recognised as an internal or external command". world is not recognised either. And finally,
no database connection found...running without.
Everything else works great, stable under 2012.
I have tried setting the path for wget, no luck, tried running wget as admin, no luck, DL'd the latest version of wget, no luck.
I'd really like to get this working!!!... please let me know your thoughts.

Did you install the server as admin? is this a VM server? if so did you give it enough resources to operate with?

[rixcraven]

Yep, its on VMware, installed with admin level security.
its got resources to spare... 80gb drive (60% spare right now), 8gb mem.
the host is VR ready, so we're not short of computing power!.

[nes76_4]

Install went ok I think, but when I run t_start_server_with_login_server.bat it tries to start up then just says Windows cannot find 'perl' Any clue ?

[marianoryu]

Everything seems to install fine, as well as the HeidiSQL database starts too, but somehow the client gets stuck on "Patching EverQuest...", and then tells me it couldn't establish a connection.

Help please and thank you!

[The_Beast]

When you setup your "client" did you read Step 5 - Creating Shortcut on the setup guide ?

http://wiki.eqemulator.org/p?Play_Guide:_Getting_Started

[marianoryu]

When you setup your "client" did you read Step 5 - Creating Shortcut on the setup guide ?

http://wiki.eqemulator.org/p?Play_Guide:_Getting_Started

I get in, but I don't know what the account name and password are. I tried using the ones in the MySQL database, but no go.

[phentop]

Following up from yesterday, today I installed Everquest Titanium and did some testing:

My own login server (eqhosts.txt = localhost:5998) fails to load the character select screen. The error is

Error 1017: Cannot login to the EverQuest server. You may need to re-run the Update Patch. Repeatedly seeing this message indicates a loss of connectivity to the Patch Server. This is usually temporary.

Using the official log in server, I can connect and play as normal.

I'm getting this same error.

[The_Beast]

Check your login.ini file. This setup is fail proof (if your loginserver.exe binary is working)


[database]
host = 127.0.0.1
port = 3306
db = peq <--edit database name to yours
user = user <--edit database username to yours
password = password <--edit database password to yours
subsystem = MySQL

[options]
unregistered_allowed = TRUE
reject_duplicate_servers = FALSE
trace = TRUE
world_trace = FALSE
dump_packets_in = FALSE
dump_packets_out = FALSE
listen_port = 5998
local_network = 127.0.0.
auto_create_accounts = TRUE

[security]
plugin = EQEmuAuthCrypto
mode = 5

[Titanium]
port = 5998
opcodes = login_opcodes.conf

[SoD]
port = 5999
opcodes = login_opcodes_sod.conf

[schema]
account_table = tblLoginServerAccounts
world_registration_table = tblWorldServerRegistration
world_admin_registration_table = tblServerAdminRegistration
world_server_type_table = tblServerListType

[The_Beast]

Also, this type of eqemu_config.xml works good for local (same puter as client)
Edit the values in RED to whatever your user/names/passwords are.

<?xml version="1.0"?>
<server>
<world>
<shortname>Server Name</shortname>
<longname>servername</longname>

<!-- Only specify these two if you really think you need to. (read: You don't) -->
<address>127.0.0.1</address>
<localaddress>127.0.0.1</localaddress>

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

<!-- Server status. Default is unlocked -->
<!--<locked/>-->
<!-- <unlocked/> -->

<!-- Sets the ip/port for the tcp connections. Both zones and console (if enabled). Defaults are shown -->
<tcp ip="127.0.0.1" port="9000" telnet="disable"/>

<!-- Sets the shared key used by zone/launcher to connect to world -->
<key>somerandomstringofcharacters</key>

<!-- Enable and set the port for the HTTP service. Defaults are shown -->
<http port="9080" enabled="false" mimefile="mime.types" />
</world>

<!-- Chatserver (channels) information. Defaults shown -->
<chatserver>
<host>127.0.0.1</host>
<port>7778</port>
</chatserver>

<!-- Mailserver (in-game mail) information. Defaults shown -->
<mailserver>
<host>127.0.0.1</host>
<port>7778</port>
</mailserver>

<zones>
<defaultstatus>0</defaultstatus>

<!-- Sets port range for world to use to auto configure zones -->
<ports low="7100" high="7500"/>
</zones>

<!-- Database configuration, replaces db.ini. Defaults shown -->
<database>
<host>127.0.0.1</host>
<port>3306</port>
<username>user</username>
<password>pass</password>
<db>peq</db>
</database>

<qsdatabase>
<host>127.0.0.1</host>
<port>3306</port>
<username>user</username>
<password>pass</password>
<db>peq</db>
</qsdatabase>

<!-- Launcher Configuration -->
<launcher>
<!-- <logprefix>logs/zone-</logprefix> -->
<!-- <logsuffix>.log</logsuffix> -->
<!-- <exe>zone.exe or ./zone</exe> -->
<!-- <timers restart="10000" reterminate="10000"> -->
</launcher>

<!-- File locations. Defaults shown -->
<files>
<!-- <spells>spells_us.txt</spells> -->
<!-- <opcodes>opcodes.conf</opcodes> -->
<!-- <logsettings>log.ini</logsettings> -->
<!-- <eqtime>eqtime.cfg</eqtime> -->
</files>
<!-- Directory locations. Defaults shown -->
<directories>
<maps>maps/</maps>
<quests>quests/</quests>
<plugins>plugins/</plugins>
<lua_modules>lua_modules/</lua_modules>
<patches>./</patches>
<shared_memory>shared/</shared_memory>
<logs>logs/</logs>
</directories>
</server>

[marianoryu]

I have two further questions:

1- When opening t_start_with_login_server, I get the following.

http://i.imgur.com/5FIPnG8.png

Is this meant to happen or am I doing something wrong?

2 - The second has to do with not being able to create or login with any name or password I input in the launcher (I'm trying to set this up in a local LAN). How do I get past that?

[jia_jacky]

I think records of tblWorldServerRegistration table in your database are not consistent with your eqemu_config.xml.
But it shouldn't affect playing. You can still login and play, can't you?

[marianoryu]

I think records of tblWorldServerRegistration table in your database are not consistent with your eqemu_config.xml.
But it shouldn't affect playing. You can still login and play, can't you?

I have tried using the account name and password I have created here, but it tells me it doesn't exist in the database; which leads me to ask how I get past that.

[jedder1977]

Hello,

I am curious if anyone else has noticed this problem after using this installer.

If I try to use any warrior discs like Defensive etc, I get an error that I am too distracted to use a skill. After receiving that error I can no longer click anything or attack anything as it just says I am too distracted. I have been running for almost a year and it is a recent development without any changes to the server.

Using Windows 2012 R2 as server
Using SOD Client.

[jedder1977]

Just as an update, I did a completely fresh install with the newest package on a new VM and it is doing the same thing. Warrior discs don't seem to work.

[Akkadius]

Just as an update, I did a completely fresh install with the newest package on a new VM and it is doing the same thing. Warrior discs don't seem to work.

Issue a binary update, and let me know what you find

Single command

perl eqemu_server.pl windows_server_latest

Interactive mode

C:\EQEmu\servers\peq_server>perl eqemu_server.pl

>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
>>> EQEmu Server Main Menu >>>>>>>>>>>>
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>

[database] Enter database management menu
[assets] Manage server assets
[new_server] New folder EQEmu/PEQ install - Assumes MySQL/Perl installed
[setup_bots] Enables bots on server - builds code and database requirements

exit

Enter a command #> assets

>>> Server Assets Menu

[maps] Download latest maps
[opcodes] Download opcodes (Patches for eq clients)
[quests] Download latest quests
[plugins] Download latest plugins
[lua_modules] Download latest lua_modules
[utility_scripts] Download utility scripts to run and operate the EQEmu Server
>>> Windows
[windows_server_download] Updates server via latest 'stable' code
[windows_server_latest] Updates server via latest commit 'unstable'
[windows_server_download_bots] Updates server (bots) from latest 'stable'
[fetch_dlls] Grabs dll's needed to run windows binaries
[setup_loginserver] Sets up loginserver for Windows

> main - go back to main menu
Enter a command #> windows_server_latest
[Update] Fetching Latest Windows Binaries (unstable) from Appveyor...
[Copy] folder doesn't exist, creating 'updates_staged/'
[Download] Saved: (updates_staged/master_windows_build_pdb.zip) from https://ci.appveyor.com/api/projects/KimLS/server/artifacts/build_x86_pdb.zip
[Download] Saved: (updates_staged/master_windows_build.zip) from https://ci.appveyor.com/api/projects/KimLS/server/artifacts/build_x86.zip
[Update] Fetched Latest Windows Binaries (unstable) from Appveyor...
[Update] Extracting... ---
[Unzip] Extracting...
[Unzip] Extracting...
[Update] Installing :: eqlaunch.exe
[Update] Installing :: eqlaunch.pdb
[Update] Installing :: export_client_files.exe
[Update] Installing :: export_client_files.pdb
[Update] Installing :: import_client_files.exe
[Update] Installing :: import_client_files.pdb
[Update] Installing :: loginserver.exe
[Update] Installing :: loginserver.pdb
[Update] Installing :: queryserv.exe
[Update] Installing :: queryserv.pdb
[Update] Installing :: shared_memory.exe
[Update] Installing :: shared_memory.pdb
[Update] Installing :: tests.exe
[Update] Installing :: tests.pdb
[Update] Installing :: ucs.exe
[Update] Installing :: ucs.pdb
[Update] Installing :: world.exe
[Update] Installing :: world.pdb
[Update] Installing :: zone.exe
[Update] Installing :: zone.pdb
[Update] Done

[jedder1977]

Sorry, I should have stated that. I tried the most updated(unstable) version as well in testing. Same result.

[Akkadius]

Sorry, I should have stated that. I tried the most updated(unstable) version as well in testing. Same result.

My next thing for you to try would be exporting client data from the server so that your spells line up with what the server has in its database.

These errors your getting could be client sided

Copy the files generated in export into your client directory and get back to me

C:\EQEmu\servers\peq_server>mkdir export

C:\EQEmu\servers\peq_server>export_client_files.exe
[Status] Exporting Spells...
[Status] Exporting Skill Caps...
[Status] Exporting Base Data...
[Status] Exporting DB Strings...

C:\EQEmu\servers\peq_server>dir export
Volume in drive C has no label.
Volume Serial Number is 3A3D-1AE4

Directory of C:\EQEmu\servers\peq_server\export

09/08/2017 10:01 AM <DIR> .
09/08/2017 10:01 AM <DIR> ..
09/08/2017 10:01 AM 51,971 BaseData.txt
09/08/2017 10:01 AM 25 dbstr_us.txt
09/08/2017 10:01 AM 901,425 SkillCaps.txt
09/08/2017 10:01 AM 28,551,278 spells_us.txt
4 File(s) 29,504,699 bytes
2 Dir(s) 153,949,364,224 bytes free

[jedder1977]

Generated files, copied to SOD client folder, overwrote files, same result:(

[Akkadius]

Generated files, copied to SOD client folder, overwrote files, same result:(

Next thing is - updating your client - SoD is way too old, I would recommend getting RoF2

Older clients are hard-coded to only read up to so many Spell ID's - they're also not going to understand how to handle newer spell data

[jedder1977]

*sigh* it actually doesn't work on PEQ with my client. I just tested. Has anything changed in the past year that would cause it to no longer work with the SOD client?

The reason I haven't upgraded is because all of my macros are made for SOD and it would take a lot of work to change them. I box 40+ characters.

[Akkadius]

Hmm - let me think of some other things, I am fighting some fires at work atm so it will have to be a bit.

Also - the installer uses the same DB as PEQ, so something else has to be going on

[marianoryu]

I have tried using the account name and password I have created here, but it tells me it doesn't exist in the database; which leads me to ask how I get past that.

I am still stumped in this - any help will be most welcome.

[Akkadius]

I am still stumped in this - any help will be most welcome.

Stumped by what - there's not a whole lot of information here

Shoot me some more information and I can try to help

[marianoryu]

Stumped by what - there's not a whole lot of information here

Shoot me some more information and I can try to help

How do I create an account so that I can log in?

[The_Beast]

I am still stumped in this - any help will be most welcome.

First of all, just to verify, look in your database to make sure these 4 tables are there :

tblloginserveraccounts
tblserveradministration
tblserverlisttype
tblworldserverregistration

If those tables are there, the server "long name" and server "shortname" (in tblworldserverregistration) have to match
what is in your eqemu_config.xml file.

Second of all, there should be a file called login.ini, if you make sure the following line is set to TRUE, the user name and
password you first enter in your client login window, will automatically be created.

auto_create_accounts = TRUE

[marianoryu]

First of all, just to verify, look in your database to make sure these 4 tables are there :

tblloginserveraccounts
tblserveradministration
tblserverlisttype
tblworldserverregistration

If those tables are there, the server "long name" and server "shortname" (in tblworldserverregistration) have to match
what is in your eqemu_config.xml file.

Second of all, there should be a file called login.ini, if you make sure the following line is set to TRUE, the user name and
password you first enter in your client login window, will automatically be created.

auto_create_accounts = TRUE

I just looked - unless I'm looking at the wrong place (I assume the database I want to look is "peq"), they're not there.

In the case you need to see, here's how everything looks before starting the client.

https://i.imgur.com/T8dmKhI.png

[The_Beast]

You definately got some things going on there. World is not loading a few things, it's also not connecting to the login server and
you should have another window for zone server. Have no idea whats happening on your end.

[marianoryu]

You definately got some things going on there. World is not loading a few things, it's also not connecting to the login server and
you should have another window for zone server. Have no idea whats happening on your end.

Nor I, unfortunately. All I've done was run the installer in Admin mode, log into HeidiSQL, edit the shortcut and run "t_start_with_loginserver".

[drelk001]

is there a way to change the stat caps granted to each level?

[gimpel333]

I was near done downloading the latest winserver install when my firewall aborted.

Now it claims that link/file has a trojan and won't allow me to download.

Is there a mirror?

gimpel

[Garudan]

When I did the whole installer thing, no errors come up, I end with a folder which looks like its suppost to do.

When I start t_start_server.bat a window pops up, as it is supposed to.

World: changes from down to UP, you can watch it going from 0/30 to 30/30.
When its there, another window pops up, immediately closes and World: changes to down again.
Then the loop restarts. This goes on forever, nothing else happening.

Any ideas? Any questions? Log is empty.

[marianoryu]

Okay, I got it working.

The problem now is that I have another service using the MySQL 3306 port.

Is there any way to change this one to something else?

Thank you very much in advance.

[sklead]

Okay, I got it working.

The problem now is that I have another service using the MySQL 3306 port.

Is there any way to change this one to something else?

Thank you very much in advance.

I was having the same issue and made a little progress

I just opened up my task manager and ended the mysql process and service and then tried to boot my world server. Now a couple of different windows pop up and it starts booting world zones, then it boots the UCS which changes from DOWN to UP, then it boots the Queryserv, but after it boots that the UCS goes down again. It basically then ping pongs and boots one but knocks the other down over and over again.

[Yard Dogg]

Do have Microsoft SQL Server installed and possibly running at same time ?
(see programs and features in Control Panel)

[sklead]

Do have Microsoft SQL Server installed and possibly running at same time ?
(see programs and features in Control Panel)

In my case I don't have anything by that name. Just a bunch of Visual C++ Redistributable files and the .NET framework. I didn't appear to have any other MySQL or Microsoft SQL services running in Task Manager.

[Garudan]

When I did the whole installer thing, no errors come up, I end with a folder which looks like its suppost to do.

When I start t_start_server.bat a window pops up, as it is supposed to.

World: changes from down to UP, you can watch it going from 0/30 to 30/30.
When its there, another window pops up, immediately closes and World: changes to down again.
Then the loop restarts. This goes on forever, nothing else happening.

Any ideas? Any questions? Log is empty.

Anyone? I have also used a self compiled version of the .exe's, which leads me to think of a configuration problem. But no clue where to look at.

[Yard Dogg]

Try going into the main server folder in dos (command) windows and running each .exe manually (just to test), each in it own cmd window.
Errors should showup there if there is nothing in logs, as you indicated. Do these in order: (just type the full name)
loginserver.exe
shared_memory.exe (this will run once and quit)
world.exe
(wait a few seconds for world to load)
eqlaunch.exe zone
ucs.exe
queryserv.exe

[mnewell125]

I'm very new to this. I had no trouble running the installer. Once it finished I ran the "setup_bots" command at the end. Once I started the server and logged in I was able to create a bot and group but the cleric bot did not cast. I looked through the forums and read a post or two about this. I was not able to find a fix. I have reran the "Setup_bots" from a command prompt and still no casting.

From what I can tell, my DB is missing the bot_spells_entries. There are alot of other bot tables just no spells.

Can anyone tell me how to get that table installed. I know very little about doing this. I can access the DB with heidi SQL and make minor changes to char xp ect... I would need specific instruction on adding the bot_spells_entries table if someone has one or can tell me where to find it.

Thanks for the work on the installer Akkadius!!

[mnewell125]

I was able to resolve this issue. I found a post with the code to add the bot_spells_entries.

Thanks!

[kfsone]

Nice installer; worked like a charm with one caveat: the local server doesn't show up in the realm list when I use the local login server. I can log into the server via the public login server, and I can log in to the local login server.

I've tried tons of stuff based on various interpretations of about a dozen sets of instructions and I'm kind of at a loss.

Running on a clean Windows Server 2016 64bit vm on an ESXi host.

[kfsone]

I'd set it up as per the Wiki instructions, even adding the <address/> tag that's no-longer there by default.

It didn't work with just my server as <loginserver1/>, or with loginserver1 being mine and loginserver2 being eqemu, or vice-versa, even though World reported "Added loginserver 192.168.86.29:5998 in each case.

Solution: Remove the eqemu server but use <loginserver>...</loginserver> instead of <loginserver1>.

[kfsone]

Ha, spoke too soon. My server now shows up in the server list, but the client locks up if I try to log into it until I eventually get a 1017.

If I login via eqemulator.net, the server works fine. Hunch is I have the local login server serving a local IP for the server when I go to it, vs the 192.168 address I get when I go via eqemulator.

[edit]

<?xml version="1.0">
<server>
<world>
<shortname>Smith</shortname>
<longname>Chez Smith Server</longname>

<address>192.168.86.29</address>

<loginserver1>
<host>login.eqemulator.net</host>
<port>5998</port>
<account></account>
<password></password>
</loginserver1>

<loginserver2>
<host>192.168.86.29</host>
<port>5998</port>
<account></account>
<password></password>
</loginserver2>

<tcp ip="127.0.0.1" port="9001"/>
<telnet ip="0.0.0.0" port="9000" enabled="true"/>


And


[options]
unregistered_allowed = TRUE
reject_duplicate_servers = FALSE
trace = TRUE
world_trace = FALSE
dump_packets_in = FALSE
dump_packets_out = FALSE
listen_port = 5998
local_network = 192.168.86.29
auto_create_accounts = TRUE

[Uleat]

I remember <Prophecy> - I was in <Phantom Raiders> for a short stint.

They had their raiding a-listers - which I was not one .. but, I could out-mez their enchanter any day!

[Shiny151]

I've done this installation a number of times and from memory it should be option #3 that you go with after a fresh installation; I think you have to do it twice so it gets everything from the database that has been updated.

[Akkadius]

ok, so I have finally solved this and am posting a follow up in case others run into this. I wound up forwarding the list of ports listed on one of the wiki pages to the internal IP of my Windows Server 2012 R2 VM and now I can get into the world.

For reference, I forward the following ports to my server:
7000-7500
9000
9080

This actually perplexes me a bit because network traffic from my client was originating from 192.168.0.31 and the destination server was at 192.168.0.153 so there is absolutely no reason that I can see (and I'm a cisco certified network nerd) that the traffic should be touching the outside interface and the forward should never get used. In fact, none of the private IP ranges, including my 192.168.0.0/24 network are allowed to be routed out onto the internet, so I don't see how it's possible.

I use a Motorola Surfboard SBG6580

I've been in the Cisco world for 8 or so years myself.

One of the things with this is that what the loginserver sees is your outside address, which is what the loginserver will default to tell the client to use to login to the server.

You can set your local address to avoid this

<localaddress></localaddress>

This will keep traffic from going out/in - but if it works, it works and in the end does it really matter

HTH

[kuahara]

Will do that. Thanks.

I understand that most of the time it probably doesn't matter. This morning, it was noticeable because I was having trouble with my connection (ISPs end) and wound up having to reset their equipment, which I think is failing and in need of replacement. Actually... that's not a very convincing argument that things would have been different if I had a local address specified. I'll play around with it.


Thanks again.

[Akkadius]

Will do that. Thanks.

I understand that most of the time it probably doesn't matter. This morning, it was noticeable because I was having trouble with my connection (ISPs end) and wound up having to reset their equipment, which I think is failing and in need of replacement. Actually... that's not a very convincing argument that things would have been different if I had a local address specified. I'll play around with it.


Thanks again.

Hmm? Not sure I'm understanding.

Either way I hope you got it sorted sir

[kuahara]

Does it matter where in the eqeqmu_config.xml file that <localaddress> tag goes?

Also, do you know of any reason my spells or dbstr files might not be correct? I referred to your response in another thread where you told someone to run

export_client_files .\exports

to acquire those files. I've done this and it spits out the 4 files I'm expecting. When I drop these in my eq folder, the behavior I observed was what I might expect if the spells file was wrong. When I right click a gem in game, the spell categories all read "unknown DB string xxx" and so did all the subcategories. If I follow the menu path down to the spell itself, the spell names were fine. Just the categories leading to them all say that. Issuing a /who command in game returns good information for all but the player races. Races still come up "unknown DB string xxx".

Yesterday, that was all fine and good. It didn't stop me from playing the game, but today I'm just experiencing one crash after another. I can get my GM character into the world, but after a minute or so, it crashes. When I pick items up from my inventory or from the equipment slots on the character, they never appear on the cursor. The game partially behaves as if the item is there, but never does what it is supposed to do when I try to re-equip it, drop it into an inventory slot, etc... and then I crash a second later. If I try to use #zone, I crash. Yesterday, I did not have these problems.

Am having all the trouble in the world resolving this today. Any advice is appreciated.

Thanks.




Edit: restarting the server partially resolved this. I'm not crashing anymore and I can pick up items. Still can't figure out the unknown DB string non-sense, though.

Edit2: The crash and cursor issues seem to be specific only to MQ2 + GM Characters. If I start MQ2 and log in using a GM, I can't pick up items anymore. The items disappear. /gate #zone, etc... will crash the GM. Also using F1 to target self with the GM character logged in will crash the GM toon if MQ2 is running. I can log a regular toon in while MQ2 is running and pick up items, /gate, /zone, etc... just fine.

Edit3: Ok... so what I've determined with the GM account is this: If MQ had been running at any time on the client PC, even if I turn it back off before I log in a GM account, all of the problems with picking up items, targeting self, and crashing recur. Even with MQ turned off, if I log in a GM account and hit F1 to target self, I can cause an immediate crash. This issue does not go away until I restart the server (t_stop_server, not actually rebooting the VM my server runs in). Once I restart the server, if I leave MQ turned off, I can log in a GM, target self, pick up items, etc... This is not too big of a deal. I just need to remain aware that there are certain things the GM simply can't do. I can still utilize him for all my GM needs #leveling toons, #gi , etc... MQ2 and regular players all seem to work as intended.

Out of all this, I'm still most interested in trying to resolve the unknown DB string business. Forgot to mention that when I click the Alt Advancement button, I can't see what AAs I'm purchasing either. Those all say "Unknown DB string xxx" as well.

[kuahara]

Update: fixed the "Unknown DB string xxx" problem. I wound up using the server files from agnarr-eq.com

I thought I'd tried the dbstr and spells_us files already (I use the underfoot client), but there were also 2 files that needed to go into the resources folder. I don't remember doing anything that would have changed these from when I actually played on the agnarr emu server, but apparently something was changed along the way. Using all their files with the exception of eqhosts.txt resolved the issue I was having.

Also, someone messaged me and said that MQ2 discussion might not be permitted. My apologies. I thought it was condoned here since most of the servers allow it with varying sets of rules to make multiboxing easier.

I also stuck <localaddress>ip</localaddress> just below <loginserver2></loginserver2>. Will give that a try and report back.

Edit: Was trying the <localaddress> thing because after a while, my response time with the server increases from 30ms to nearly 30,000ms (full 30 second delay). I usually have 21 characters logged in. This happened even with the <localaddress> bit in the eqemu_config.xml file in the place I specified above. The response time sits at about 100ms with 21 toons logged in, but after a while, will suddenly start climing from 100 to 900, then 1500, 5000, 19000, and usually stop climbing somewhere between 27000 and 29000. I am not sure if I am triggering this problem or not. The last time it happened, I had just issued an MQ2 command on the GM character. This could have triggered it or it could have been nothing but a coincidence. Won't know without experimenting further. Just updating here in case someone already has an answer.

Edit2: I issued a /bcaa //gate command to make 20 toons all try to gate at once. Usually this is broken in such a way that it just causes the toon to rezone to the current zone in the current location. The idea was to make them all rezone and see if that fixes the problem with the long response time to/from the server. For some reason, on the bards (bound in gfay by default), /gate actually works and sends them to gfay. All toons that were bound in PoK by the soulbinder were kicked to the server select screen when I did the mass gate. The bards wound up in gfay with 30ms response times from the server.

This is also taking up quite a bit of memory. I am not sure that that would contribute to long response times, but when I had 21 logged in, I noticed my machine was using 26.5GB of memory. I have 32GB in this machine. The server runs in a VM on the same machine. Most of the eqgame.exe instances are using about 732MB of memory. EQ instances only account for 15GB of the memory being used. The rest is other garbage running on the machine (firefox, excel, vmware, etc...) The CPU (an i5 @ 3.4GHz) is not being beaten to death or anything. With a toon zoning here and there, I was seeing 15-24% usage.

[Akkadius]

Unknown DB string is going to show up depending on the types of data you're dealing with on older clients.

if you want to minimize string related issues on the client side I would suggest using ROF2

You can grab a clean version of ROF2 and use its spells_us and dbstr files to import to the server before you try exporting. The database tables are not guaranteed to be up to date.

And yes - this is not really the place for MQ2 support - there is mqemulator.net for that.

Memory footprint from the emulator is not going to be that large

[kuahara]

ok, but what about the <localaddress> bit from the last question? Is that in the right place? Would that have anything to do with the long delay? 30s delay makes this unplayable.


Thanks.

[Akkadius]

ok, but what about the <localaddress> bit from the last question? Is that in the right place? Would that have anything to do with the long delay? 30s delay makes this unplayable.


Thanks.

localaddress just needs to be under the <world> section

As far as your delay - you're going to have to narrow down that issue, it could be anything. We have servers in production with folks with 50+ box crews who zone in seconds. I'd suggest looking at your PC's resources when the slowdown occurs.

[kuahara]

I'm getting closer to an answer on this 30,000ms delay thing. I don't think it has anything to do with MQ, but more testing is required.

Right now, I've had 18 characters logged in and all of their delays are 30-50ms. They have all been logged in for over 2 hours, which is way longer than it was taking for this 30 second response time bug to kick in yesterday. Individually, they can all change zones in 3-5 seconds (assuming the zone was already up). I zoned 18 characters all at the same time and it took 27 seconds for it to complete.

Shortly after the mass /gate, all the toons had response times from anywhere between 400ms and 1200ms. This seems to be correcting itself slowly over time while I have them sitting in place not doing anything. Many of the 500ms response times lowered down to 300ms after a minute or two. My main cleric's 1200ms response time was down to 850 and lowering. I think this will work itself out as I wait.

My current theory is that the huge lags don't really kick in until I bring the bards online and make them start twisting their songs. I have 3 total bards and when they are simultaneously twisting, it generates quite a lot of chatter in the chat windows of 20+ toons all at once. I am wondering if more is going on in the background with bard songs that might be contributing to this giant delay. Going to wait for the response times on all my toons to get back down to 100 or less, then bring them online and make them /twist. I will monitor response times both before and after issuing /twist 1 2 3 (makes them twist spells in the first 3 gem slots).

Sorry for bringing up anything MQ related in the post. I'm not seeking MQ support here at all. If I determine that to be a contributor to the problem, I will take this discussion elsewhere. I am including the information for the sake of drawing a more complete picture.


Edit: I brought the bards online. They all three had 30ms response times while in gfay. I #summoned them to PoK with the rest of the toons and they had 40-50ms response times. I left them idle there for several minutes. My response times on all toons are still gradually lowering during the several minutes. Response times on all toons were between 125ms and 135ms. They didn't seem to be lowering further than that, though perhaps it might have happened if I waited longer. I decided to make all three bards twist the songs in their first 3 gem slots. Most of the chatter is in the GM's chat box. It displays the full name of every song as soon as it is successfully cast. The other toons just have a bunch of "The elemental chorus fades" entries in their chat. If this is what triggers the problem I'm investigating, I imagine it could take 15-20 minutes or so for it to kick in. Will edit the post again if it recurs.

In the meantime, this is what my performance currently looks like. Left is the host machine where the eq clients are running. Right side is the guest machine, where the server lives.

https://i.imgur.com/MTBqHVj.png

[kuahara]

Well... I'm back to where I started. I have no idea what was causing that problem. The bards have been afk twisting, took the wife out for about an hour, came back, and everyone's response time is at 90-135ms.

Was hoping to have something useful to reply back with. Sorry for all the fruitless chatter.

[Akkadius]

It sounds like you are experiencing packet loss. These symptoms occur when the server starts having to re-transmit packets to many clients at once and the ping/latency response from the client perspective rises.

If you're doing this on the same machine through VM etc. you may want to investigate potential bottlenecks or other things going on. Again we have folks who zone 50+ toons on our higher player-base servers and there are 0 issues unless their connection is experiencing packet loss, these sorts of symptoms occur where eventually they completely desync or things get sluggish.

18 clients - my suggestion as well is to use all the filters you can on your boxes, not MQ2 filter, but the client filters. These client filters are pushed up to the server and the server will not send you the packets for those messages, that can heavily reduce spam/resends in combat scenarios etc. If you were doing lots of combat and then you tried to zone not long after something like this that would cause your problem. Another client side thing that you should make sure you're doing as well is making sure that /log is disabled - this is a huge performance hit to the client and I wouldn't ever have it enabled unless you really need to log something

HTH

Akk

[kuahara]

I'll check to see if logs are on here in a bit and disable if needed.

I did finally do something that seems to have triggered it. I created 2 new toons while 21 other toons were online and in PoK. Both DE races. They each loaded into neriak with 30ms response times to the server, but all the toons in PoK had their response times shoot from 135ish to 5000-8000.

When I created one of the toons, I hit exit > logout and quit/closed the 2nd client so I could create only one at a time. I noticed that if I ever log a character out all the way to server select, then back to char select -> unti world, that instance of EQ will have severe artifacting issues (super stretched images that don't even closely resemble what the image is supposed to be). The artifacting is resolved by closing that one client completely and restarting it.

Am going to finish creating my toons. I expect to have around 30 when completely done and then see if giving everything a fresh start resolves the issue.

What response times are your 50+ toons that are all running on the same machine looking at?

I'd be real surprised if I was experiencing loss between 2 machines in the same network. Especially if it's not touching that outside interface anymore. I will do a continuous ping from client to server and check, though. Not sure if the results are relevant to the EQ client/server relationship or not. I assume it'd be indicative.

[Akkadius]

I'll check to see if logs are on here in a bit and disable if needed.

I did finally do something that seems to have triggered it. I created 2 new toons while 21 other toons were online and in PoK. Both DE races. They each loaded into neriak with 30ms response times to the server, but all the toons in PoK had their response times shoot from 135ish to 5000-8000.

When I created one of the toons, I hit exit > logout and quit/closed the 2nd client so I could create only one at a time. I noticed that if I ever log a character out all the way to server select, then back to char select -> unti world, that instance of EQ will have severe artifacting issues (super stretched images that don't even closely resemble what the image is supposed to be). The artifacting is resolved by closing that one client completely and restarting it.

Am going to finish creating my toons. I expect to have around 30 when completely done and then see if giving everything a fresh start resolves the issue.

What response times are your 50+ toons that are all running on the same machine looking at?

I'd be real surprised if I was experiencing loss between 2 machines in the same network. Especially if it's not touching that outside interface anymore. I will do a continuous ping from client to server and check, though. Not sure if the results are relevant to the EQ client/server relationship or not. I assume it'd be indicative.

One thing I want you to do is make sure you have the most up to date binaries. The installer doesn't keep the latest bleeding edge server binaries, only approved stable releases

Open up cmd

perl eqemu_server.pl windows_server_latest

Baseline that for troubleshooting and go from there

[kuahara]

Just completed that. I also forgot to mention that the artifacting thing I described, when logging out a character and logging in a different character on the same account.... or logging one out to server select, then back in again without closing the client. That issue happens even when I play on other people's servers. I'm not terribly worried about that one particular issue because it's easily fixed by just closing that one client and reloading it.

Screenshotted the output of the command you had me run.

https://i.imgur.com/vVntfo6.png


Will post back with any changes. Going to go ahead and load up the other 20 toons for the heck of it right now, then create more and see if it causes their response times to shoot up.

[kuahara]

Not sure if it matters, but this happened when I started the server back up after the update. Not sure it effected anything as I was able to log my GM character in immediately after without any trouble. Just fyi.

https://i.imgur.com/js1x4JY.png



Edit: Checked my eqclient.ini and Log=FALSE

[kuahara]

I've had 13 existing toons parked in PoK since my last post over an hour ago. I created 11 new toons since then and have used the GM to summon some of them around. So far all their response times with the server are 30-45ms. 25 toons online and so far no sudden jumps to 5k, 10k, 20k or 30k ms.

Only new thing right now is that I can log in literally every toon except the reserve clerics. Trying to log just those toons in is causing them to autocrash for some reason, but it's probably just a bit of bad luck at this point.

If the issue recurs, I'll post back. Though I'm not sure what else can be done at this point.

I ran that continuous ping for a while, both before all the toons were online and after. Nearly all replies came in 11ms or less. One stray packet was responded to in 383ms. I'd expect that with the server running in a VM, the replies come in 1ms or less. I administer a small Windows domain at work that has about 60 machines in it spread across two buildings. As I write this message, I VPN'd into my work network, RDP'd into my work PC, then pinged a machine in the building across the street. The response times were 4ms, 3ms, 5ms, 3ms. When I ping the gateway (same building, but opposite side of the building), all replies are <1ms.

Here on my home PC, the server and clients are literally the same machine, one is just in a VM. Not sure why I can't get <1ms replies when I ping.

Pings to the gateway, which is physically separate, come back in <1ms.

If I fire up wireshark, is there some EQ specific traffic I can look at and see if that <localaddress> tag in eqeqmu_config.xml is doing what it's supposed to do or if the traffic is still being routed through the outside interface?



Edit: Every time I think I know something....
So I started having the issue with high response times again, but now I'm guessing it has something to do with what I'm doing for new toons. I have a hotkey setup on the GM to level it to 60, increase all the skills to max, hand it some plat, turn on GM speed (temporarily), give it a bunch of AA, etc... I'd moved the new 11 toons to PoK and hadn't had an issue. Unless I just needed to wait a minute for it to kick in after moving so many so quickly. As soon as I started smacking the hotkey to scribe all spells for each of the new toons, I started having this problem, so I popped open a cmd terminal and....

https://i.imgur.com/H7mDXrs.png


Also, I'm not convinced that it's the server. I left 1 toon in Neriak and his response time in game shows 31ms. I summoned him to PoK with the GM and upon zone in, he's showing 25.4k ms. Took him quite a while to zone in too.

[kuahara]

Is there any way to undo the update of those binaries? Because ever since I updated them, none of my characters can log in while MQ2 is running. If I shut it off, they can all log in fine. If it's on, they all crash trying to enter world now.

[kuahara]

ok, so I figured it out! I'm guessing my replies aren't being looked at in this thread anymore, but I'll update for the heck of it.

It probably seems obvious at this point, but I can reproduce the problem at will now. I didn't realize I was completely running out of memory. I thought I still had a pretty safe buffer. When I am nearly full and start another EQ instance, all the times shoot up from the 20-40ms range to 500+ and start climbing to nearly 30k.

I also want to point out that I created a new server using Windows Server 2008 R2 instead of Windows Server 2012 R2 and 2008 seems waaaayyyyyyyy more stable. I don't have half the problems I was having in 2012 and my setup/installation procedure was exactly the same. (only this time I took several VM snapshots in case anything breaks and I need to go back to a stable state).

Earlier, you mentioned that EQ shouldn't have this large of a memory footprint. Any chance you know how I might go about reducing the amount of memory each instance is using? Here's a screenshot of what my host machine performance looked like while everything was stable. And things were stable all day yesterday, all through the night while I slept, all morning. But at 31.5GB usage when I start a new instance and load up that last toon to push it over the edge. All in game response times shot as described above.

https://i.imgur.com/mlE4a0F.png

And here is a snapshot of the processes, showing how much memory each instance is using. How can I reduce this?
https://i.imgur.com/Ng1bUNB.png

You also mentioned something to me about possibly switching to ROF2 client and I noticed you made that recommendation to several others as well. If possible, I'd like to keep the underfoot client. It has been very stable when playing on the existing EMU servers and I like the version of MQ that I have that runs with it. MQ is causing none of these problems by the way. eqgame.exe is using about that much memory even with MQ turned off. I'm afraid that if I switch clients, I might lose some of the useful plugins that I make regular use of and playing without MQ just doesn't work for me. I'd rather quit.

If you have any advice, I'd love to hear it. Going to google this problem for now.

Thanks.



Edit: That large CPU spike you see in the first screenshot is not normal CPU usage. I just happened to be loading up another instance when I took it. Idle, the CPU sits anywhere from 4-15% depending on what it's doing, even when I have 20+ toons logged in.

[Akkadius]

You're asking me how to reduce memory footprint of your client and heaps of other questions that are now outside of the scope of this thread. Some of which I've already answered

There are MQ2 builds for ROF2 they may not have your active hacks (warping etc.) but they are there at mqemulator.net

ROF2 is a much better client and far better at memory management. You can probably find it in a big red button on PEQ's website

Please start a new thread and we'll go from there - everyone on this thread chain gets notified via E-Mail

[kuahara]

If this isn't an appropriate place for me to follow up, just delete this. It's possible I'm the only idiot that would do something like this without realizing the consequences, but I wanted to follow up anyway in case someone else ran into it.

A huge part of my memory consumption wasn't just the eqgame.exe instances. Task manager on the host machine won't show it, but if you run a server in a VM and allot it 16GB of memory, it will (at least with this sql db running) consume the entire 16GB even when it doesn't actually need it. The guest taskmgr shows it only needed 2GB of memory, but with the VM powered up, I was losing 16GB.

Fortunately, the solution is simple. I just powered it off and lowered it's available memory to 4GB, and restarted. I was operating under the assumption that the VM would only use what it needed and was trying to play it safe.

Also, I tried ROF2. It does save me about 200MB on the first few instances, but the drawbacks weren't beneficial enough for me to switch away from UF.


Thanks for all the help and sorry for the mess.

[Akkadius]

If this isn't an appropriate place for me to follow up, just delete this. It's possible I'm the only idiot that would do something like this without realizing the consequences, but I wanted to follow up anyway in case someone else ran into it.

A huge part of my memory consumption wasn't just the eqgame.exe instances. Task manager on the host machine won't show it, but if you run a server in a VM and allot it 16GB of memory, it will (at least with this sql db running) consume the entire 16GB even when it doesn't actually need it. The guest taskmgr shows it only needed 2GB of memory, but with the VM powered up, I was losing 16GB.

Fortunately, the solution is simple. I just powered it off and lowered it's available memory to 4GB, and restarted. I was operating under the assumption that the VM would only use what it needed and was trying to play it safe.

Also, I tried ROF2. It does save me about 200MB on the first few instances, but the drawbacks weren't beneficial enough for me to switch away from UF.


Thanks for all the help and sorry for the mess.

So you set your MySQL configuration to use 16GB of your memory?

What drawbacks are you talking about

[kuahara]

No, when I configured the virtual machine in vmware, I told it that it could have 16GB of memory, 50GB of disk space, access to all 4 CPU cores, etc... When it comes to disk space, it only consumes what it actually needs. I assumed the same was true with memory, but it is not.

After a reboot of this machine, I popped open taskmgr and added up the amount of memory consumed by what little was running. Less than 2GB was in use. If I go over to the performance tab right next to processes, it shows about the same thing. Almost no memory is in use. When I fire up vmware and start up the server, things change. My processes tab shows vmware uses a few hundred MB of memory, but it still adds up to less than 2GB of total memory consumption. The performance tab, however, shows that I'm using 18.6GB of memory.

I go over to the VM (server 2008 R2) and open taskmgr there to check. The performance tab there shows the server is only using 2.7GB of memory.

If I shut down the VM, the host machine gets 16GB of memory back under the performance tab. It seems pretty obvious that the VM is reserving 16GB of memory from the host simply because it is allowed to use it, whether it needs it or not.

Another assumption I made that doesn't seem to hold true is that if the performance tab showed I was using X amount of memory, then I'd be able to go over to the processes tab, which lists every running process and how much memory it is using, and be able to add that up and get approximately the same total that the performance tab shows I am using. With vmware in play, this is not even remotely close to true.

I can provide screenshots of all of this in action.



Edit: Sorry, I didn't answer the question about the drawbacks of ROF2. I have an underfoot client with an MQ2 build for UF that includes the active hacks you referred to earlier. As a workaround, I could just make all my toons GMs and use #goto instead. I also couldn't make autologin work. I referred to your instructions in the wiki, but at the field where it says "server=" there's no instructions if you are running your own private server. I tried leaving it set to EZ, blank, and a number of other things that I thought might make it work with my personal server, but when I run the shortcut to get into the game, the result is always the same. It says there's an error in the GUI XML files and to check the log. The log only contains a timestamp and no other information. I noticed the maps were far from complete. I might just be able to copy the map files from my UF build and paste them in. There were a number of other things missing (a lot just from the UF MQ2 build) that I found I'd need to come up with alternate methods of doing. In the end, it just seemed like it'd make better sense to continue working on what I'd started before downloading ROF2. I might give it another shot later if there's a persuasive enough reason to go back.

[Akkadius]

If I shut down the VM, the host machine gets 16GB of memory back under the performance tab. It seems pretty obvious that the VM is reserving 16GB of memory from the host simply because it is allowed to use it, whether it needs it or not.

You need merely < 4GB of memory for the guest if its just you.

Boot 30 dynamics in the launcher and call it a day.

Production servers as a comparison:

PEQ: http://peq.akkadius.com:19999/#menu_system_submenu_cpu;theme=slate

EZ: http://eznp.akkadius.com:19999/#menu_system_submenu_cpu;theme=slate

Both servers are using roughly 5GB and they have quite a few processes running and many players on

Sorry, I didn't answer the question about the drawbacks of ROF2. I have an underfoot client with an MQ2 build for UF that includes the active hacks you referred to earlier. As a workaround, I could just make all my toons GMs and use #goto instead.

As far as #goto - go to your commands table and set the status for the command to '0' so any of your characters can use it without special gm flags.

. I tried leaving it set to EZ, blank, and a number of other things that I thought might make it work with my personal server, but when I run the shortcut to get into the game, the result is always the same.

AutoLogin on EZ's site works if you follow it verbatim - you have to use the build listed and you have to replace the file with the contents on the guide.

To find the server name you look in eqlsPlayerData.ini

https://i.imgur.com/Yy8SIC2.png

I noticed the maps were far from complete.

Maps are simply downloaded from a 3rd party source, such as mapfiend

There were a number of other things missing (a lot just from the UF MQ2 build) that I found I'd need to come up with alternate methods of doing. In the end, it just seemed like it'd make better sense to continue working on what I'd started before downloading ROF2. I might give it another shot later if there's a persuasive enough reason to go back.

Ultimately whatever you choose to use client use is your preference, 98% of players on EZ/PEQ use ROF2 for a reason. The client is far better in so many ways, but they may not matter to you. I'm simply helping you with your issues

HTH

[kuahara]

https://i.imgur.com/AdsuWcK.png

I tried this with both server=2 and what you see in the screenshot. Both ways result in:

https://i.imgur.com/GuelPlH.png

The log file that refers to contains only a timestamp and no other information.

My ini file contains exactly what the instructions at http://wiki.ezserver.online/MQ2_Autologin_Setup say it should. It was a direct copy/paste from your post.


As an aside, any chance you know how to get rid of the SC/EQ button in the ROF2 client?

[Akkadius]

You need to make a server reference under servers

KS=Kuahara Server

Under [kuagm]

Server=KS

Error in GUI XML has nothing to do with MQ2 - changes were made to the client apparently. You can look in your UIerrors.txt file as it says to see what the issue is. You can try setting defaults in OptionsEditor.exe

And once again - let's keep this thread related to the installer please

[phentop]

Using this installer - If something goes wrong with the build, How do I create a new build?

Basis for question. I created a server with bots. When I started the server I got a lot of errors saying my bot files were out of date. Once they were "auto updated" the zones loaded. I could see the server I created in the server list but when I tried to log in all I got was a black screen for about a minute and was kicked back to the EQ start screen. Instead of messing with it I tried to create a server without bots using the same installer but all I get are errors and hang ups. If I completely format my drive - reinstall windows - and restart the server installer, the installer will work and create a new sever file. I know their has to be an easier way to do this besides reinstalling everything to get a clean version of windows running.

[phentop]

Re-installed everything on a clean copy of windows. Without adjusting any settings, but the server name, I still cannot log into the server.

I show no errors. No crash. The server is listed in the server files as open to join.

I've used this installer in the past and it worked flawlessly.

I just downloaded this installer after wiping my drive and have run into this issue. I've tried entering the server from different EQ versions and different computers. Same issue. When entering the server I never get the loading screen - it stays black for about 30 sec then kicks me to the login screen.

I can log into other servers just fine, just not the one I created of this installer.

[Akkadius]

Re-installed everything on a clean copy of windows. Without adjusting any settings, but the server name, I still cannot log into the server.

I show no errors. No crash. The server is listed in the server files as open to join.

I've used this installer in the past and it worked flawlessly.

I just downloaded this installer after wiping my drive and have run into this issue. I've tried entering the server from different EQ versions and different computers. Same issue. When entering the server I never get the loading screen - it stays black for about 30 sec then kicks me to the login screen.

I can log into other servers just fine, just not the one I created of this installer.

To be clear: this is a windows install with both the client you are trying to login with and the server running on the same instance?

[phentop]

Windows 7 64bit
Server is running on a separate PC than the one I run EQ on.

Only odd thing I see that didn't happen a few months ago when I ran a server off of this installer is when world.exe runs I see "New zone Server connection from.... at 127.0.0.1:...." about 30 times in a row. I don't recall seeing this in the past. Maybe I didn't pay attention until it didn't work though.

I however, am able to log into the server from the computer the server is running on. I still cannot log into the server from a different computer.

[phentop]

I found the issue.

My Firewall was still blocking "world" in the InBound rules. Once I set it to allow, all worked as it should.

Thank you for responding so fast Akkadius.

[Akkadius]

I found the issue.

My Firewall was still blocking "world" in the InBound rules. Once I set it to allow, all worked as it should.

Thank you for responding so fast Akkadius.

Hmmm - the installer adds rules for all ports for windows - application agnostic

[ElleAir55]

Hello. Im getting "no connection" error but Im online. btw Im trying to install from Japan..Isn't the location problem?



Administrative permissions required. Detecting permissions...
Success: Administrative permissions confirmed.
################################################## #######
#::: EverQuest Emulator Modular Installer
#::: Installer Author: Akkadius
#:::
#::: EQEmulator Server Software is developed and maintained
#::: by the EQEmulator Developement team
#:::
#::: Everquest is a registered trademark
#::: Daybreak Game Company LLC.
#:::
#::: EQEmulator is not associated or
#::: affiliated in any way with Daybreak Game Company LLC.
################################################## #######
:
################################################## #######
#::: To be installed:
################################################## #######
- Server running folder - Will be installed to the folder you ran this script
- MariaDB (MySQL) - Database engine
- Heidi SQL (Comes with MariaDB)
- Perl 5.12.3 :: Scripting language for quest engines
- LUA Configured :: Scripting language for quest engines
- Latest PEQ Database
- Latest PEQ Quests
- Latest Plugins repository
- Automatically added Firewall rules
- Maps (Latest V2) formats are loaded
- New Path files are loaded
- Optimized server binaries
################################################## #######
[Update] No connection to the internet, can't check update
[Update] Cannot check update without internet connection...
'world' は、内部コマンドまたは外部コマンド、
操作可能なプログラムまたはバッチ ファイルとして認識されていません。
[eqemu_server.pl] No database connection found... Running without
[Install] EQEmu Server Installer... LOADING... PLEASE WAIT...
[Download] Cannot download without internet connection...
[Update] Fetching Latest Windows Binaries...
[Download] Cannot download without internet connection...
[Update] Fetched Latest Windows Binaries...
[Update] Extracting... ---
IO error: opening updates_staged/master_windows_build.zip for read : No such file or directory
at C:/Perl/lib/Archive/Zip/Archive.pm line 546
Archive::Zip::Archive::read('Archive::Zip::Archive =HASH(0x65f43f4)', 'updates_staged/master_windows_build.zip') called at eqemu_server.pl line 1706
main::unzip('updates_staged/master_windows_build.zip', 'updates_staged/binaries/') called at eqemu_server.pl line 1201
main::fetch_latest_windows_binaries() called at eqemu_server.pl line 376
main::do_installer_routines() called at eqemu_server.pl line 271
main::new_server() called at eqemu_server.pl line 767
main::show_menu_prompt() called at eqemu_server.pl line 485
main::check_for_world_bootup_database_update() called at eqemu_server.pl line 71
read error at eqemu_server.pl line 1707.

[Lane]

I got my first server up and running in no time, simply awesome work. Question, though, where do I go from here? I tried reading through the wiki/forums and can't find where I should start studying on how to edit my database. I did see and watch some videos on EOC but wasn't sure if that should be my go-to for all things DB related?


Some things I'd like to learn how to do:
-Create/modify items, NPCs, spells (I saw these were options in EOC.)
-Disable certain classes (create new if possible?)

I also saw on the front page there will be a new wiki soon? (in the upcoming year I hope?)- awesome news.

[ChaosSlayerZ]

Quick question.
I just used this auto-installer for the first time on a new PC, and I completely out of touch with all things I knew about Emu.
How do I change from default DB password?

Thank you!

[phantomghost]

In the xml file it sets your MySQL user/pw automatically.

You would have set this in order to run the installer. Unless you are trying to add a secondary MySQL user ?

[ChaosSlayerZ]

well I guess it already set it to "root" and now I want to change it ;)

[phantomghost]

I have never changed user, but can try this.. copy/paste from google

Instructions

Click the Windows "Start" button and type "cmd" in the search text box. Press*Enter*to open the Windows command line.

Type "mysql" and press*Enter*to start the MySQL command line utility. Using the MySQL command line, you can update the tables on the database.

Type the following SQL code to update the root user:
UPDATE mysql.user SET user='newuser' WHERE User = 'root';
Change*newuser*with the value you want to use in place of*root

Type the following SQL code to change the default user's password:
UPDATE mysql.user SET authentication_string = password('pass') WHERE User = 'newuser';
Replace*pass*with the new password, and replace*newuser*with the name of the user you set up in the previous step.

[ChaosSlayerZ]

thanks! i will try this ;)

[jpyou127]

Install HeidiSQL and under one of the menus is "users". Edit there, much easier than running commands from cmd.

[karecalt187]

This is what I get when trying to connect to mysql. I am following the advanced guide for server setup on windows. I get this when trying to setup mysql in step 3 of the guide...am I in the wrong directory someone else mentioned restarting but I do not see a command for that or file? Thank you

C:\xampp\mysql\bin>mysql -uroot
ERROR 2003 (HY000): Can't connect to MySQL server on 'localhost' (10061 "Unknown error")

[phantomghost]

Not exactly sure which part you are at... Probably the second half of this post.

Did you launch xampp and Start Mysql

https://a.fsdn.com/con/app/proj/xampp/screenshots/Screen Shot 2016-02-19 at 16.png/1
Need to start it Everytime... You can set it to start always, but I have run into issues that it does not start.

Then when you go to CMD prompt you would type

MySQL -uroot -ppassword

Where root is your user (if user was account it would read -uaccount)

Where password is your password (if password was secret it would read -psecret)

Then you can do:
use peq;

Change peq to your database name. (If you save a SQL file from heidisql from your database it will put entries in the file to make the changes to the database you pulled it from... In the event you make multiple servers and want to copy an entire table from 1 to the other).

Or what part are you at? Looks like your trying to set password after you set the path?

If so just type
MySQL -uroot

In the CMD window. You don't need to add the exact location like you did when setting the path.

[karecalt187]

Well I skipped past the MySQL setting password at the beginning and kept going forward in the guide but it never told me to run xampp I guess....logical step. Let me try your solution I am sure it is something simple like this.:D

[Ladrone]

trying to install EQEmu on Win 7 Ultimate x64 VM, the eqemu_install.bat file is hanging after creating the maps folder. any ideas?

[Akkadius]

trying to install EQEmu on Win 7 Ultimate x64 VM, the eqemu_install.bat file is hanging after creating the maps folder. any ideas?

Be patient or re-run the batch file again

[Ladrone]

I made sure all Windows 7 updates are current, I re-ran the installer and I still get to this point:

[Install] Fetching Latest Maps... (This could take a few minutes...)
[Copy] folder doesn't exist, creating 'maps/'

it has been sitting at this point for more than 2 hours now, is that to be expected?

[kokey98]

maps can take a while... how fast is your connection, their servres etc.. more than 1 factor at play. go make lunch or something. if it's not stuck, you're just adding time if you interrupt the download. 2 hours is probably safe to start over, though. make sure there isn't a y/n prompt.

you don't need to run xampp after installed/setup. just make sure 3 services are set to 'automatic' or add it to bat file to "net start"/stop services with server. i made sure to copy/paste exact names:

apache2.4
sqlwriter
mysql

you can find them in services.msc - run that as a command or click "services" button in task manager etc.. multiple ways to get there.

net start ...
net stop ...

will start and stop any service in a bat file / cmd prompt. or set them as "automatic" and not worry about them being ready.

if you've gone from advanced self install to installer, make sure to start 100% fresh. remove everythign and start clean for installer.

[Ladrone]

thanks, i took your advice and went to lunch, when i returned it had finished! however, now that it has finished there seem to be files missing...
i do not see the eqemu_update.pl or the t_start_server or t_stop_server files.
here is the final output from the installer after the maps DL'd, this is a completely fresh install of Win7 x64.

format error: can't find EOCD signature
at C:/Perl/lib/Archive/Zip/Archive.pm line 695
Archive::Zip::Archive::_findEndOfCentralDirectory( 'Archive::Zip::Archive
=HASH(0x3414da4)', 'IO::File=GLOB(0x3dffc34)') called at C:/Perl/lib/Archive/Zip
/Archive.pm line 581
Archive::Zip::Archive::readFromFileHandle('Archive ::Zip::Archive=HASH(0x
3414da4)', 'IO::File=GLOB(0x3dffc34)', 'maps/maps.zip') called at C:/Perl/lib/Ar
chive/Zip/Archive.pm line 548
Archive::Zip::Archive::read('Archive::Zip::Archive =HASH(0x3414da4)', 'ma
ps/maps.zip') called at eqemu_server.pl line 1782
main::unzip('maps/maps.zip', 'maps/') called at eqemu_server.pl line 153
1
main::map_files_fetch_bulk() called at eqemu_server.pl line 450
main::do_installer_routines() called at eqemu_server.pl line 279
main::new_server() called at eqemu_server.pl line 818
main::show_menu_prompt() called at eqemu_server.pl line 553
main::check_for_world_bootup_database_update() called at eqemu_server.pl
line 79
read error at eqemu_server.pl line 1783.
Press any key to continue . . .

[Ladrone]

having patience and re-running the installer pays off, thanks for the help. Appears to be up and running but I don't have a client install yet, hopefully soon!

[Ladrone]

so the server is up and running and i am able to create a character but when i try to log in the server stops responding and the client either drops back to the server select screen or it just goes all black. in my World cmd window i can see where the character is zoning from character select to tutorialb... any help would be much appreciated

to check them off the list:

Windows IP Configuration
Ethernet adapter Local Area Connection 2:
Connection-specific DNS Suffix . : mshome.net
Link-local IPv6 Address . . . . . : fe80::178:14a:ba5b:
IPv4 Address. . . . . . . . . . . : 192.168.142.162
Subnet Mask . . . . . . . . . . . : 255.255.255.240

I updated my eqemu_config.json to match my IP address and set the port number for Titanium
"loginserver2" : {
"account" : "",
"host" : "168.192.142.162",
"password" : "",
"port" : "5998"
},
"longname" : "Plane of Soulree Voker",
"shortname" : "Soulree Vokers Plane",
"tcp" : {
"ip" : "127.0.0.1",
"port" : "9001"
},
"telnet" : {
"enabled" : "true",
"ip" : "0.0.0.0",
"port" : "9000"
}
},

I updated the login.ini file on the server
[options]
unregistered_allowed = TRUE
reject_duplicate_servers = FALSE
trace = TRUE
world_trace = FALSE
dump_packets_in = FALSE
dump_packets_out = FALSE
listen_port = 5998
local_network = 192.168.142.162

I updated the eqhost.txt on the client to match the Server IP and I added patchme to the shortcut for eqgame.exe

**latest update** I am able to log into the server now but other people are not able to, any ideas?

[Ladrone]

is it possible to only use my local login server and not connect to the eqemulator.net but still be able to host remote connections?

how would I need to modify the eqemu_config.json file?

when I try to remove the login server 1 info the remote clients are unable to zone into the world...

right now I have it up and running, accepting clients from both the eqemulator.net and my local login server.

[Akkadius]

For local login setup, see: https://github.com/EQEmu/Server/wiki/Windows-Server#loginserver-installation

[Ladrone]

Thanks, I appreciate the quick reply and the amazing work you have done to make this possible.

I apologize if this is something I should be able to understand easily but I am still not clear on how/if I can eliminate the public login and only use the local.

when I remove the loginserver1 info clients cannot connect to the world, maybe I am removing too much from the config.json file...

[Akkadius]

Thanks, I appreciate the quick reply and the amazing work you have done to make this possible.

I apologize if this is something I should be able to understand easily but I am still not clear on how/if I can eliminate the public login and only use the local.

when I remove the loginserver1 info clients cannot connect to the world, maybe I am removing too much from the config.json file...

Ladrone, just make your loginserver entry named "loginserver" versus "loginserverX" and it should work fine as a single entry

[uberbeans]

Hi all,

Everthing installed great. Been looking through the forums and can't figure out.

I use t_database_backup
It's saves file into the backup folder. But how do I restore it. I want to move the server from one computer to the other. Thanks.

[laxative]

Hello there,

long time admin here, after switching to the json config file, I along with Ladrone, Durinor (around page 14) seem to be stuck with allowing remote login to get past character select.

I can connect to the server without issue while on the same server (I always start my testing that way) as soon as I try with my laptop, from the same subnet, or a different subnet I cannot get past character select.

I suspect an inbound block of port 9000. Even though I can see the rules getting created.
however, this is my eqemu_config.json config

"server" : {
"chatserver" : {
"host" : "",
"port" : "7500"
},
"database" : {
"db" : "peq",
"host" : "localhost",
"password" : "eqemu",
"port" : "3306",
"username" : "root"
},
"mailserver" : {
"host" : "",
"port" : "7500"
},
"qsdatabase" : {
"db" : "peq",
"host" : "localhost",
"password" : "eqemu",
"port" : "3306",
"username" : "root"
},
"webinterface" : {
"port" : "9081"
},
"world" : {
"http" : {
"enabled" : "true",
"mimefile" : "mime.types",
"port" : "9080"
},
"key" : "MuduK65lzq6azJgrsN7kMvEjtAQuxuB",
"loginserver" : {
"account" : "",
"host" : "10.198.16.120",
"password" : "",
"port" : "5998"
},
"longname" : "Orion Everquest Server with PEQ",
"shortname" : "Orion PEQ",
"tcp" : {
"ip" : "10.198.16.120",
"port" : "9001"
},
"telnet" : {
"enabled" : "true",
"ip" : "0.0.0.0",
"port" : "9000"
}
},
"zones" : {
"defaultstatus" : "0",
"ports" : {
"high" : "7400",
"low" : "7000"
}
}
}
}

Here's the login.ini
[database]
host = localhost
port = 3306
db = peq
user = root
password = eqemu
subsystem = MySQL

[options]
unregistered_allowed = TRUE
reject_duplicate_servers = FALSE
trace = TRUE
world_trace = FALSE
dump_packets_in = FALSE
dump_packets_out = FALSE
listen_port = 5998
local_network = 10.198.16.120
auto_create_accounts = TRUE

[security]
plugin = EQEmuAuthCrypto
mode = 5

[Titanium]
port = 5998
opcodes = login_opcodes.conf

[SoD]
port = 5999
opcodes = login_opcodes_sod.conf

[schema]
account_table = loginserver_server_accounts
world_registration_table = loginserver_world_server_registration
world_admin_registration_table = loginserver_server_admin_registration
world_server_type_table = loginserver_server_list_type

Eqhosts files are right because I can login on the same box as the server.

If my files are verified to be correct for LAN access (across subnets) I'll start looking into see if the auto firewall rule creation is working right..

This is the one part I always had problems getting right, even in the prior .xml file :)

thanks
Laxa

[laxative]

Hi!

For good measure, I ran another complete fresh install (earlier today was at work)

I changed as little as possible, still can't connect from any computer other than the server.

if anyone else has resolved, I'd love to know how.
Getting the server list which is good, almost there

laxa

[laxative]

well crud,

I changed the same three entries on my home computer: (the two 127.0.0.1) entries in the eqemu_config.json and the login.ini and it's now working at home..

GO FIGURE..
lax.

[Uleat]

Did you enable 'external' access on your database?

Maybe the installer does that..not 100% sure on that one...

[laxative]

hi!

Well I'm almost all the way solved now. .. I did a lot of testing and found the issue to be centered around login.ini

See at work I can end up on multiple subnets depending on where I jack in.

If my login.ini was specific.
W.X.Y.Z -- the client can only connect from W.X.Y.Z

If I get less specific: W.X.Y. (notice no entry in last octet)
Then clients can be anything from W.X.Y.1-254

So, we have a big network I just went with W. (no following octects) now I can connect from anywhere inside our internal network.

so adjusting local_network = **** was the issue for me.

So when I would like to have clients access from outside the router (hosting a server) I may need to specifiy the outside router address..

Seems to me there should be a remote_network setting in the login.ini file to help us get that.

local_network = 192.168.1. (all clients on 192.168.1.1-255) - or whatever
remote_network= 77.67.58.58(madeup) allows the clients to connect from outside the router (assuming router is port forwarding)

this used to be done inside the xml ??

hope this helps others?

laxa.

[Skyy1999]

Hi - I ran the installer, everything looks good and where it's supposed to be.

I'm running into an issue some people further up in the thread encountered.

Using the start_server login bat files just shows the world.exe starting up then shutting down over and over.

Someone up thread suggested going into a command prompt and trying to start each exe in order, starting with loginserver.exe. When I run that separately it gives me the following message:

[Login Server] Logging System Init
[Login Server] Config System Init
[Login Server] MySQL Database Init
[Error] Failed to connect to MySQL database. Error: Unknown database 'peq'

I know my SQL login info is correct because I can log into it via the command prompt with no issues and MariaDb starts up correctly. All the MySQL login info and database name is set correctly in the required config and ini files. I'm not sure why it doesn't see the peq database though since the installer indicated it was created.

Any thoughts?

EDIT: Nevermind, I found the solution way back at the beginning of the thread - I didn't have a true clean install, previous Xampp/other programs were still installed and in the path variable - cleaned it all out, reinstalled, got it working.

[ElvenWitchQueen]

I love the new installer, and didn't know where to post this one, but is from the default database install.

Blightfire Moors - no map, but even more peculiar is the moss viper that says delete me. :)

Any thoughts? (took screen shot used as avatar...)


Edit: (Resolved)

'a_moss_viper' didn't show up in table search but did show up in whole database search. Why the last name of those vipers were 'DELETE ME', I have no idea, seemed liked perfectly healthy and functional vipers. :P

As far as the missing blightfire moors map in ROF2, I simply copied missing map files from other client versions.

[Ladrone]

the start and start with login are not working, I launch the shared_memory as admin first, then I open the launch_world file followed then by login_server as admin. that is the only way I have been able to get it to work.

[Tegila]

Couple quick questions with this before I even start (still building my server box hardware)
1. you said removed xp from list, but does that mean xp64 won't run this at all? or just don't want to list it as it's so old?. I like it for it's tiny footprint, and it's based of server 2003.

2. Is server 2012 the only windows server that will work? i.e. server 2003 or home server 2008 as long as 64bit, will they work? or at least probably?

3. how big is the total download after starting the installer? I'm assuming it's much bigger than a client eq folder, but I have no idea. My ISP is extremely slow, like dialup speed unless it's o'dark thirty, and I can only download about 30gb a night, maybe 35 before it drops back to 56k speed.

oh and ..
4. after this is fully installed on a clean untouched windows, can other things THEN be installed without messing things up? Or should I run this on a virtual machine only and leave everythign else on a different windows? The home server I'm building is for mainly a media server/software storage, but other than spanned volumes, I don't intend to do anythign but store stuff, let the devices accessing it work out the playback of the files on their own. SO basically I want to build the server, and have it also store 4-5Tb of audi/video/ebook and software files. Is that possible without messing up the emu server? (LAN server)

Thank you.

[Tegila]

Ok I finally got everything going and 99.99% ready to launch, but near end of install got error world.exe is not valid win32 application. When I closed it the installer continued.

Setup luginserver etc, then went to launch with t-start-server (same with login server) and again get not valid win32 etc. After closing this one it popped through several cms Windows, then stopped at launching the zones. (Note to self..get rest of zones)

This time every time I close the error box it pops back up with a new line. The 3rd error results in change from:
Access is denied.: 0/30 UCS: DOWN queryserve DOWN liginserver: UP
TO
Workd: UP Zones 1/30 ucs down queryserv down luginserver up

Each error increasing number of zones up and changing previous line to start with access is denied.

So I close error til I'm at 30/30 zones up. See ucs down and queryserv, so I run ucs and same error, not valid win32, yadda yadda yadda

So while I'm finally so close I can smell it, I have some barriers.

Yes I'm 64 bits os, yes fresh install though it had to be started twice, first time I again got the not connected to internet thing, but this time turning off firewall fixed it, the other pc's and os's it didnt.

So, it's possible Perl or Maria got installed twice bc they run before any download, but this error doesn't sound right for that.

Ran the scripted installer so nothing outside it got installed that shouldn't. (Read someone with this error had 64bit and 32bit Perl installed)

Any suggestions? I know I'll have to run every .exe in the folder again once fixed as it seems every exe is triggering it.


Don't mind the syntax, typing on phone not pc, no c&p or screenshots or logs to post right now.

[Arkansas]

I followed all the steps but as soon as I run the eq batch file after running a while it gives this error

[Error:eqsmu_server.pll MySQL path not found, please add the path for automatic
database upgrading to continue...

I do not se a MySWL at all in the Files I downloaded ?

[phantomghost]

I followed all the steps but as soon as I run the eq batch file after running a while it gives this error

[Error:eqsmu_server.pll MySQL path not found, please add the path for automatic
database upgrading to continue...

I do not se a MySWL at all in the Files I downloaded ?

If you did not install reference this:

http://wiki.eqemulator.org/p?Complete_Windows-based_Server_Setup_Guide

Download MySQLThere are two methods to this. One is to manually download and install MySQL, the other uses XAMPP (link) to install. The bonus for the latter method is if you want to install the Peq Database Editor tool (and most people will want to), then you will most likely need to install XAMPP anyway!

§Method 1Download the Windows (x86, 32-bit), MSI Installer version of MySQL Community Server*here**and put it in the*C:\EQ\Installs*directory.The current version as of April 2, 2014 is 5.1.73. DO NOT download the essentials version (it does not have the required developer components). Download the one called mysql-5.1.73-win32.msi . When you click on the download page it asks you to register - you do not need to. At the bottom of the page is a link that says "No thanks, just start my download". Use that link.

§Method 2Download the latest*XAMPP. This guide was written using the "7.1.1 / PHP 7.1.1" version*xampp-win32-7.1.1-0-VC14-installer.exe. Simply install XAMPP using the defaults but ensure PHP and MySQL are included, and remove Perl from the list as you will install it yourself.



If you have xampp.. run it and start MySQL. I am not familiar with any new guides, so not sure what it refers you to.

[Arkansas]

Thanks Bub, I was lost and that helped a lot! Does the MySQL or XXAMP have to be 64 bit or does it matter. I am running a 64 bit windows 8. Or is it that the 32 goes for any ?

If you did not install reference this:

http://wiki.eqemulator.org/p?Complete_Windows-based_Server_Setup_Guide

Download MySQLThere are two methods to this. One is to manually download and install MySQL, the other uses XAMPP (link) to install. The bonus for the latter method is if you want to install the Peq Database Editor tool (and most people will want to), then you will most likely need to install XAMPP anyway!

§Method 1Download the Windows (x86, 32-bit), MSI Installer version of MySQL Community Server*here**and put it in the*C:\EQ\Installs*directory.The current version as of April 2, 2014 is 5.1.73. DO NOT download the essentials version (it does not have the required developer components). Download the one called mysql-5.1.73-win32.msi . When you click on the download page it asks you to register - you do not need to. At the bottom of the page is a link that says "No thanks, just start my download". Use that link.

§Method 2Download the latest*XAMPP. This guide was written using the "7.1.1 / PHP 7.1.1" version*xampp-win32-7.1.1-0-VC14-installer.exe. Simply install XAMPP using the defaults but ensure PHP and MySQL are included, and remove Perl from the list as you will install it yourself.



If you have xampp.. run it and start MySQL. I am not familiar with any new guides, so not sure what it refers you to.

[Arkansas]

Still not working probably doesnt help that I have no clue if I am installing MySQL right or not. Any Help anyone ? I tried that site but it's not working even with there directions. It gives the same error.

[Error:eqsmu_server.pll MySQL path not found, please add the path for automatic
database upgrading to continue...

[GRUMPY]

Did you check your windows path variables to see if something like this is in there ?

C:\Program Files (x86)\MySQL\MySQL Server 5.1\bin;

Also, check your windows services to see if there is a MySQL running at all.

[Arkansas]

I dont mean to sound stupid but I dont know what you mean by variables and or path :( That's why I downloaded this pack I thought it was going to be idiot proof..lol Unfortunately for me its not.. I know very little about MySQL etc. But if I get advice how to do it I can do it.

Did you check your windows path variables to see if something like this is in there ?

C:\Program Files (x86)\MySQL\MySQL Server 5.1\bin;

Also, check your windows services to see if there is a MySQL running at all.

[GRUMPY]

Sorry Arkansas, when you mentioned MySQL, I assumed you did NOT use Akka's installer ?
since it installs
MariaDB instead of the straight MySQL. If that installer went wrong, I would recommend
uninstalling everything. MySql, perl, etc., then starting out fresh using Akka's install package.
I assume you got the install package from here? -
https://github.com/EQEmu/Server/wiki/Windows-Server

[Arkansas]

Yes thats it... I installed it 15 times now and every time says that error about MySQL then after installing mysql then it gave the last error about emu.pl path or something ?

[Arkansas]

Here is the error I get ?

https://imgur.com/S7jGDLN

[GRUMPY]

Ok, it definately looks like the installer and update script is erroring out when it reaches the
the check for mysql or mariadb path because it can't find one. Unfortunately, I have no idea
why, so you will have to have some patience and wait for someone who may have more
knowledge about that. Sorry, I tried.

[GRUMPY]

Here's a quick "easy UI" to edit your windows path, if and when you need to. Just follow the 1-2-3 steps indicated in the pic.
Control Panel > System > Advanced system settings

https://image.ibb.co/imksEx/path_edit_windows.png

[Arkansas]

Ok so I got it working finally, had to wipe my hard drive because I got a virus somehow from online. But good to go now. My thing now is its showing red error on one of the windows is this normal and if so How do I play the server ? Do you have to have EQ game downloaded as well ? I have the game EQ Titan. do I have to change files in it or logon notepad etc. ? I have only messed with WoW Private Server Repacks thats it. Never these kinds before ?

Pic of my screen - https://imgur.com/2ZogMpV

[GRUMPY]

Do you have to have EQ game downloaded as well ? I have the game EQ Titan.

It's starting to look like you are going to have a ton of reading to do on these support forums,
with both the game client and the running of the server. If you have a clean copy of EQ Titan,
(or any other supported clients), that have never been patched into EQ Live servers, then it
will work. You may want to start reading through the "Getting Started" section for playing the
game, as well many other topics dealing with errors or issues coming up on your server.
If you are using your own login server, there is config files that need to be edited to match
what's in the database login tables.

[Arkansas]

I am so confused thats what I thought this thread/download was basically a private server a unpack and play. Didnt know I would have to get a copy of the game or it wasnt included or have to change stuff :( Thought it was gonna be like a WoW Private server change a login file on your WoW folder and open and connect :( Is this pack not meant to be offline ? To use and host my own mini server for myself to play on ?

[Tegila]

You can host for yourself or publicly. The red error message was probably bc of being lan (mine always gives one while trying to connect to public login bc I turned it off) You do still have to have your own game, but titan is just fine. If it all installed as is, you just have to make the shortcut to eqgame and put in the relevant IP, then add patchme, plus put on relevant IP wherever else indicated on the page you got installer from. All this is explained in the links in the last page of posts here.

[c0ncrete]

1) it is a server emulator. private or pubic is entirely up to you.
2) you still have to have a WoW client to play on a WoW private server.
3) you have to change very little if you use one of the automated installers.
4) downloading game clients like WoW from randos off the 'net is how you get viruses.
5) EQ Titan is an emulated server, not a game client. Titanium is a client.

[Tegila]

1)
5) EQ Titan is an emulated server, not a game client. Titanium is a client.

It is? Thought he was just shortening titanium to titan.

My understanding of the situation at this point was that he had issues using the installer, but once viruses fixed everything was done to default. If he managed to customize the installation, idk why the few last setup steps would be so difficult.

[GRUMPY]

It is? Thought he was just shortening titanium to titan.


Just like rof2 means "rolling on floor twice" :P

[Uleat]

wfmaacms-anl!

[Arkansas]

bump .....

[Arkansas]

I was just trying to shorten it for Titanium. Should had just put EQ Tit. Sorry my fault.

Sorry guys wasn't trying to cause waves. I done exactly what the Installer said to do but unfortunately it does not tell you anything about changing your own client nor files for playing privately. I was trying to do it like I thought and changed the address from eqemu default one in the get started to my own but still no luck. When the game launches I have no server show up for me. When I left it like the installer says it puts me in the public access servers instead. If I am misunderstanding then my apologizes but I am new. Just wanna really get this working. Not trying to be difficult all, sorry for any inconveniences :( If anyone has pics for how my files that I need to edit with my ip and just color yours out that would help alot too. I am a visual learner, sorry :(

[GRUMPY]

No waves, no worries, just a warped sense of humour, haha.
You would need to edit the eqemu_config.json file in your server folder, wherever that was installed,
as well as the login.ini file. All references made to an IP, would have to be changed to local address,
(if you're running client on same box, locally) and a server login server was running.

[Uleat]

Go ahead and move the into its own thread, please.

I'll leave the current postings for now.

[Arkansas]

I think I see where the problem was actually. http://wiki.eqemulator.org/p?Akkas_PEQ_Server_Installer&frm=Main#from-scratch-installation-instructions-windows
When it gets to where it says Your Good to go I stopped from there. I am guessing you have to continue on too the Local Lan part as well ? Because where it says good to go mine still connects to public servers. After following the steps. It put this ip
in 192.168.197.127 and I never changed it because it never said too until after the good to go part.. So I guess I should had just followed it through. My fault for thinking the good to go was meant that I was ready to connect :( So EQ Host file needs to say

[LoginServer]
Host=127.0.0.1:5999 (except 127.0.0.1 will be my IP ?)

instead of

[LoginServer]
Host=login.eqemulator.net:5998

[Arkansas]

Quick question. Is the starting area in Gloomingdeep or however you say it or is it at the starting city's like the old days when your using EQ Tit. client ?

[GRUMPY]

Might want to start asking questions here:

http://www.eqemulator.org/forums/forumdisplay.php?f=587

(this thread is only relevant to the "installer")

[Arkansas]

ok sorry guys. Thanks for all the help.

[Uleat]

Like GRUMPY said, no need to be sorry :)

You are more than welcome to ask any questions that you need to further your gaming experience here.

We just need to ensure the questions stay focused on the thread topic.

New problems really need to be started on their own thread due to relevance and focus. A post about a server crash from 8 years ago probably wouldn't be relevant today :)

[Arkansas]

k, thanks all for your help.

[Varrin1]

I used the akka install but when i go to start my server it says world.exe and zone.exe doesn't exist.. were those supposed to be created during the install?

Edit: Nvm I found the problem

[Bleuraiven]

I recently started this process and still have a long way to go. I was meandering through the process of getting things up, making alterations where necessary. Then, I hit the wall. No matter what I tried after reading through forum post after post, I couldnt seem to get the character to load. I was getting an error regarding the not able to connect to port 7000 from the client dbg.txt so I spent way too long trying to find out why the firewall settings that were clearly in place werent working. I finally decided I must have screwed something up royally and was in the process of rolling out 2 new virtual systems to attempt a clean install with server and client when I came across this...

Originally Posted by Laxative
I did a lot of testing and found the issue to be centered around login.ini

See at work I can end up on multiple subnets depending on where I jack in.

If my login.ini was specific.
W.X.Y.Z -- the client can only connect from W.X.Y.Z

If I get less specific: W.X.Y. (notice no entry in last octet)
Then clients can be anything from W.X.Y.1-254

So, we have a big network I just went with W. (no following octects) now I can connect from anywhere inside our internal network.


I was putting this together on a large private network as well and it was like WoW!, why didnt I think of trying that.

So big thanks to Laxative for the saving me from continuing to bang my head against a wall.

And mucho thanks to those who developed the tools, the scripts, and continue to assist those of us in need.

[kris1]

I can't believe there is not a better explanation of how to use this. It's really frustrating.

[Akkadius]

I can't believe there is not a better explanation of how to use this. It's really frustrating.

What is frustrating? It would help if you give more information

Latest instructions found

https://github.com/EQEmu/Server/wiki/Windows-Server

[kris1]

I'm sure it's me, and my own lack of understanding. So, I don't mean to blame anyone.

I'm just lost.
I feel like there should be more pictures showing what you should be seeing with each step?

Once I have it installed, and I have a server in a folder...

How do I start the server so that it's ready for someone to log into it. a picture of the desktop, with all the proper windows open, and stuff happening, would probably help. I feel like every time I try I get a different result. Again, I'm sure it's me.

I feel like this isn't any more complicated than setting up your eqhost file and shortcut, but I'm still not getting it. And I feel like, just like the first time I was faced with setting up my EQ install for EQEmu servers, once I get it right, I'll be shocked at how simple it is, and it's just the instructions that seem daunting.

Anyways, I guess where I'm stuck now is, how do I make my server accessible to a player, not the IP address, I think I figured that out, or can. But rather, what do i need to do from a freshly booted computer, to put my server in the state where it's playable...what files need to be run. In fairness to you guys, it may be working fine, and I just don't know that i already did it. I'm THAT lost. LOL

I'm sure these instructions are sufficient. I'm sure it's just me. And I'm sure that when i get it, I'm going to embarrassed for not having gotten it on my own. So I apologize for coming across as I'm sure I did.

I'll keep trying, and reading. I have a day off to myself today, so perhaos when I'm not trying at the end of the day, when I only have an hour, and am already frustrated, I'll have better luck.

OR!!!

Maybe a carpenter/stone mason should not be trying such things...LOL. I'm open to that idea.

Sincerely
Kris

[kris1]

Damn it!!! EUREKA!!!!

It was so simple I was tripping over it. Sorry for my outbursts.

K

[drizzt007]

"the server you have selected is for a different language and/or locale.Please choose another server to play on" :( /help /cry ~ system is server2012

[Uleat]

You should start your own thread for this problem and provide more information surrounding the issue.

[Runehawthorne]

So I went to use the following link for the setup guide to begin setup of a server but the links do not work.
Here is the link I tried
http://wiki.eqemulator.org/p?Akkas_PEQ_Server_Installer&frm=Main#from-scratch-installation-instructions-windows

[superpally1]

So I went to use the following link for the setup guide to begin setup of a server but the links do not work.
Here is the link I tried
http://wiki.eqemulator.org/p?Akkas_PEQ_Server_Installer&frm=Main#from-scratch-installation-instructions-windows

https://github.com/EQEmu/Server/wiki/Windows-Server

[Cusser]

Everyone can find it here on main page:

https://image.ibb.co/hzUdDK/Emu_Main.png

[Runehawthorne]

Awesome, thank you!

[Akkadius]

Few folks have reported issues with the Windows install as of recent so I pulled it down and did a fresh install on a Windows VM

Things appear to be looking good

[d112112]

Weird problem here.
Server is up. I can log in and play BUT im missing every vanilla+ spell.
Everytime i try to scribe a newer spell, i get :
Spell ID: xxxx is an unknown spell and cannot be scribed.

RoF2 client, Win10 64. Any ideas?

[Akkadius]

Weird problem here.
Server is up. I can log in and play BUT im missing every vanilla+ spell.
Everytime i try to scribe a newer spell, i get :
Spell ID: xxxx is an unknown spell and cannot be scribed.

RoF2 client, Win10 64. Any ideas?

Thats not necessarily an issue with an installer, that's more we only have so many spells imported into the DB. You can import spells from a more recent client or spells file by using import_client_files.exe in the server directory. I think you need to create a folder called "import" in the server directory and put your spells_us.txt in that and then run the import. I don't remember offhand, but its a good reminder we should have a usage doc on it on Github

[d112112]

Thats not necessarily an issue with an installer, that's more we only have so many spells imported into the DB. You can import spells from a more recent client or spells file by using import_client_files.exe in the server directory. I think you need to create a folder called "import" in the server directory and put your spells_us.txt in that and then run the import. I don't remember offhand, but its a good reminder we should have a usage doc on it on Github

Thank you!
import folder created, new spell file loaded into DB, all spells available now :)

[Inchronoth]

Hello Akkadius,

Installed into Windows 10 pc, and Windows 7 under vmware workstaion 14 on Windows 10 pc

Both installs with no error reported.

Had to fiddle with local login, but got installing and login finished within 10 mins!!

TY so much Akka!!!!

[GlassDeviant]

Where would I report a bug? Not in the installer, but in the server or client.

[redwind01]

Hey guys, i was downloading this. the download seems to have stopped.
the last 2 lines in cmd window read.

install fetching latest maps this could take a few minutes
copy folder doesn't exist, creating 'maps/'

if i shut down programs, and rerun eqemu_install.bat will it have to start the whole process over?

thank you

[superpally1]

It didn't stop. It really does take a little while to download the maps. Just restart the installer and be patient.

[seaanchor]

crushed download maps file, size max is 114603kb, it's a broken zip file

i test install at win7x64 windowsserver 2012r2 x64 and win10x64 all failed on the same question

maybe rebuild install files and change a better server or offer a complete setup can fix it.

thanks

PS:my position is china

[redwind01]

hello again, after my last post the server never finished installing. i did a complete system restore and got the files downloaded.
i right clicked eqemu_install.bat , ran as admin.
everything seemed to be going great, until cmd window says

Fetching 'eqemu_server.pl'...
Installing ' vcredist_x86.exe
Installing ' Visual C++
[Update] No connection to the internet, can't check update
[Update] Cannot check update without internet connection...
'world' is not recognized as an internal or external command,
operable program or batch file'
[eqemu_server.pl] No database connection found... Running without
[Install]EQEmu Server Installer... Loading... PLEASE WAIT...
[Download] Cannot download without internet connection...
cannot open file at eqemu_server.pl line 686.
Press any key to continue. . .

pressing any key closes cmd window

have internet connection at 14mbps

[phantomghost]

Try this link for info.

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

[gnukes]

Can a version be made that doesn’t need a network connection? I work in areas without a net connection and would love to be able to load my mini server without needing a connection. I know this means I’d need to get the pew updates occasionally to keep current, but that seems easier.

[Uleat]

You don't need a an internet connection to run a server..just to install or update it.

[gnukes]

I can set up my server with a hotspot just fine, however if I want to start it away from the internet, it keeps waiting on the updating from pew portion of the script, I’d like to comment out that.

[Uleat]

My dev server is localhost since I don't have internet access at my house.

Just make sure that you have the updates installed before disconnecting the server.

Running eqemu_server.pl .. going to database management .. and check_db_updates will get you there fairly reliably.

[gnukes]

Thanks I’ll try that this weekend

[gnukes]

Just tried this and it didn’t work, I can’t get the server started without internet and I don’t know how to do this without it going. I tried editing ewrk userver.pl manually to no avail

[Uleat]

That console message always comes up..it's checking for server updates.

But, the server should start offline - if properly set up.

Start your own issue thread and post the symptoms in more detail, please.

[Jerom3]

I am trying to create a server where I can just run around in semi-GM mode and look at mobs, be invulnerable, open locked doors, etc. It's a simple concept, and I'd hoped to just find an existing server that would allow me to do this, as I have in the past (they seem to be gone now). Every search I've done for such a server seems to contain the answer of "JUST MAKE YOUR OWN, IT'S SO EASY!!!1"

So I tried that using https://github.com/EQEmu/Server/wiki/Windows-Server as I have Windows 10. I cannot get it to work. I am relatively computer illiterate compared to most on this forum, but I was able to follow the first few steps. Here's where I'm confused:

Does this installer assume that I have a fresh install of EQ Titanium? Because I do, but it's in a separate folder. Worth noting: I have a fresh EQ titanium installed to C:\Program Files\EQ Titanium and the files from Akka's installer linked above in C:\EQEmu files. Something I'm confused about is if these both need to be in the same folder, or if they're unrelated. I assume they're unrelated because the above link says it contains everything you would need.

I'm particularly confused because in the installer when it says this: "[Install] When done, make sure your EverQuest client points to your loginserver's IP (In this case it would be 127.0.0.1) in the eqhosts.txt file" BUT there is no eqhosts.txt file that is in my Eqemu files from Akka's installer.

I also had a question about this part:
"Change your server name in eqemu_config.json, shortname/longname is currently set to:

Akka's Server Installer (Change Name)"

Is this image where the above line is referring to? And do I just pick a random name out of my ass, or does it not matter? http://gdurl.com/qUQQ

Here's what happens when I run the t_start_server.bat

http://gdurl.com/PZBK


And here's what I see after Akka's installer is done running:

http://gdurl.com/y3nh

[Techungry]

Server looks up to me :). I think the part your missing is the login server. By default the install will register your server with the public EQEmu login server which without internet your client won't be able to get to. You need to create your own login server locally on your machine and point the server to that (in the server json config file) as well as your client (the eqhosts.txt file which is in your Titanium client folder, not the server).

Also, you need to run t_start_server_with_login_server.bat instead of t_start_server.bat to "create your own login server". Just point the client to 127.0.0.1 and it should work I believe (because Akkadius's work already puts everything down that is needed, awesome job there btw).

[belvino]

I'm particularly confused because in the installer when it says this: "[Install] When done, make sure your EverQuest client points to your loginserver's IP (In this case it would be 127.0.0.1) in the eqhosts.txt file" BUT there is no eqhosts.txt file that is in my Eqemu files from Akka's installer.

The eqhost.txt is in your client folder. if you have a fresh install should be able to toss that in to eqhost.txt and start server with login server bat file and should connect up.

[Jerom3]

Ok, I tried to follow what you guys were telling me. First, I went into my fresh EQ Titanium install, which is in a separate folder than my EQEmu folder, and I changed the eqhost file from saying: Host=login.eqemulator.net:5998 to say: Host=127.0.0.1

Then I slightly altered the longname/shortname in the eqemu_config to:
"longname" : "Akkas Windows (suIjmZ)",
"shortname" : "Akkas PEQ",
"tcp" : {
"ip" : "127.0.0.1",
"port" : "9001"

Then tried to run the t_start_server_with_login_server and this was the error I got:
http://gdurl.com/4hvf

So then I thought maybe the issue was that in the eqemu_config where loginserver2 looks like this:

"loginserver2" : {
"account" : "",
"host" : "127.0.0.1",
"password" : "",
"port" : "5998"

loginserver1 still had eqemulator listed as the host, so I changed it to match loginserver2. So it looked like this:

"loginserver1" : {
"account" : "",
"host" : "127.0.0.1",
"legacy" : "1",
"password" : "",
"port" : "5998"
},
"loginserver2" : {
"account" : "",
"host" : "127.0.0.1",
"password" : "",
"port" : "5998"
},
"longname" : "Akkas Windows (suIjmZ)",
"shortname" : "Akkas PEQ",
"tcp" : {
"ip" : "127.0.0.1",
"port" : "9001"
},
"telnet" : {
"enabled" : "true",
"ip" : "0.0.0.0",
"port" : "9000"

Then I again tried running t_start_server_with_login_server and I got this new error instead of the old error:
http://gdurl.com/fB3E

So what am I doing wrong now? I feel like I made some progress, but it still isn't working.

[phantomghost]

You use your IP for loginserver if you're using a loginserver. If your just using same comp to run server and play on it, you can literally start the server right from install without changing anything...

https://github.com/EQEmu/Server/wiki/Windows-Server

About halfway down it starts with:

Setting up the Loginserver for Local LANNow, assuming you've had all of the above done, you may need to do a little manual work to configure some of your network settings to get your server to properly show up.First you will need to get your local LAN IPOpen up 'cmd' by going to Start and typing in 'cmd'Type the command:ipconfig

You will need to use this address in all of the following files

EQEmuServer: (login.ini)

EQEmuServer: (eqemu_config.json)

"loginserver2" : { "account" : "", "host" : "192.168.197.129", "password" : "", "port" : "5998" },

Uncomment the address tag and put the local LAN IP

All EverQuest Clients on the local network will need this entry: (eqhost.txt)

Restart your server using*t_start_server_with_login_server*and you should be good to go!

[Lane]

Any suggestions on how I can manipulate source from this easy installer?

I know the old install method is backlogged. I had a server running use both methods years ago, but it's been ages, and when I tried to do the old way, I was having issues with the dependencies.

[Huppy]

Any suggestions on how I can manipulate source from this easy installer?

I know the old install method is backlogged. I had a server running use both methods years ago, but it's been ages, and when I tried to do the old way, I was having issues with the dependencies.

Not sure if you have old dependencies or not, but I have to use x86 dependencies. I zipped up my entire dependencies folder contents (the one I use now for compiling) if you feel like grabbing them. (includes boost)
https://tinyurl.com/dependencies-x86

[Lane]

Thank you! I shall give it another go!

[Lane]

The dependencies above fixed the build issue. Thank you!

[ZebossEQ]

Hello,
i am sure it has been said but ... i have tried 2 differents computers and installed then uninstalled, each time i got :" MySQL path not found, please add the path for automatic database upgrading to continue ...
Could i have some help please ?
Thanks in advance.
PS: i am using Win10 premium or Win10Home

[Criimson]

Hello,
i am sure it has been said but ... i have tried 2 differents computers and installed then uninstalled, each time i got :" MySQL path not found, please add the path for automatic database upgrading to continue ...
Could i have some help please ?
Thanks in advance.
PS: i am using Win10 premium or Win10Home

I am having the same issue and am also using Windows 10

EDIT: @ZebossEQ, I found the fix after some google fishing. Follow the instructions on this page: https://dev.mysql.com/doc/mysql-windows-excerpt/5.7/en/mysql-installation-windows-path.html

[phantomghost]

Make sure MySQL path is set in System>advanced settings>environmental variables.

http://www.eqemulator.org/forums/showthread.php?t=42246&highlight=MySQL+path

[Axemaster]

Hi, as someone who is not very computer literate, I downloaded the windows server files and followed the instructions to install, and am not sure if I interrupted the install, as there was a line that said "press any key to continue" but there was additional lines of text below it.. No files have appeared in the folder I was installing into, other than updates staged. I have HeidiSQL installed but cant find the folder where the file where "eqemu_config.json, shortname/longname" is located? Is there a simplier install instruction sheet for idiots lol

i have windows 10 home installed, and already run p99, ezserver and can play online but can seem to follow these instructions very well...

[betty1]

Does the installer at https://github.com/EQEmu/Server/wiki/Windows-Server still work? I downloaded and ran it as admin, but keep getting the following error during the install script:

Could Not Find C:\EQEmuServer\mariadb-10.0.21-winx64.msi

I noticed that this file is NOT in the RAR file nor is it in my folder (see image):
https://cdn1.imggmi.com/uploads/2019/8/5/513184e7679c97b7e33d8cd278a05b49-full.jpg


Below is the install script log:
https://cdn1.imggmi.com/uploads/2019/8/5/0d26826d92698c8f56d55dea41340aaf-full.jpg

From what I can see it appears I am missing files, but I am not sure where to acquire them.

Any help would be greatly appreciated.

The Bettys

[Sticz]

I believe the server is running correctly, but everquest.exe looks for updates and always times-out. Is there a setting I am missing? I updated eqhost:

[LoginServer]
Host=192.***.*.**:5998

is there another client-side change I need to make? Am I supposed to use the everquest.exe or is it eqgame? Eqgame just tells me to use everquest.exe.

Thanks,

Sticz

[Huppy]

Step 5 Here (https://eqemu.gitbook.io/server/categories/how-to-guides/client-configuration/play-guide) tells you how to setup client.

[Sticz]

Thank you, but this is for LAN play, that set of instructions is for connecting to one of the EQEMU servers. I am running into conflicts between the server (https://eqemu.gitbook.io/server/categories/how-to-guides/installation/server-installation-windows) instructions on the website and the instructions the installer tells me, basically two different IP addresses. everquest.exe never connects, it keeps looking for Sony.

Sticz

[chrsschb]

Thank you, but this is for LAN play, that set of instructions is for connecting to one of the EQEMU servers. I am running into conflicts between the server (https://eqemu.gitbook.io/server/categories/how-to-guides/installation/server-installation-windows) instructions on the website and the instructions the installer tells me, basically two different IP addresses. everquest.exe never connects, it keeps looking for Sony.

Sticz

If it's looking for Sony your eqhosts.txt is wrong or you haven't added "patchme" to the end of your eqgame.exe shortcut (described in Huppy's link). Local players will want your local IP and outside players will want your public IP.

EQEmu
[LoginServer]
Host=login.eqemulator.net:5999

Public
[LoginServer]
Host=101.202.111.222:5999
Can use https://whatismyip.com to find you public IP.

Local
[LoginServer]
Host=192.168.0.1:5999

etc...

If you're not using the public loginserver then loginserver 1 will be public IP and loginserver 2 will be local IP.

If you have no interest in public access then you only need one entry for local IP.

[Sticz]

I don't do a lot of stuff with IPs, is the local IP referenced by the IPv4 address as directed by the instructions? I did miss the patchme instructions as they were not mentioned in the instructions for LAN/Loginserver instructions, thank you.

Sticz

[chrsschb]

I don't do a lot of stuff with IPs, is the local IP referenced by the IPv4 address as directed by the instructions? I did miss the patchme instructions as they were not mentioned in the instructions for LAN/Loginserver instructions, thank you.

Sticz

If you open CMD and type ipconfig, the ipv4 address is your local IP. Most start with 192.168.x.x or 10.0.x.x.

If you use the link above, that is your public IP.

[Sticz]

It would help if I followed the actual instructions... I had a shortcut to everquest.exe not eqgame.exe. Strangely, when I finally got everything set-up correctly it worked like a charm.

Thank you all so much.

Sticz

[Huppy]

Hence, I answered your first question ;)


is there another client-side change I need to make? Am I supposed to use the everquest.exe or is it eqgame? Eqgame just tells me to use everquest.exe.



Step 5 Here (https://eqemu.gitbook.io/server/categories/how-to-guides/client-configuration/play-guide) tells you how to setup client.


I had a shortcut to everquest.exe not eqgame.exe.
Sticz

[SouthernOgre]

With the move over to gitbook, is there an updated link to download the basic installer package?

The link at https://eqemu.gitbook.io/server/categories/how-to-guides/installation/server-installation-windows never connects. Connection times out.

(http://wiki.eqemulator.org/eqemu_installer_files.zip)

Thanks!

[Akkadius]

Are you sure you're looking at the most up to date page? The updated link is in there

[SouthernOgre]

Thanks! Killed the cached content and reloaded. I now see the link directing to analytics.akkadius.com/eqemu_installer_files.zip .

[bigdaddyduergar]

I set up the server for some local screwing around, downloaded the steam everquest install, followed all the instructions afaik, and when I try to log in I get "[LoginServer] [Info] New Titanium client connection from 1678616768:55607" and it just hangs. I've not been able to find any info on this, and was hoping y'all could point me in the right direction.