EQEmulator Forums

EQEmulator Forums (https://www.eqemulator.org/forums/index.php)
-   Support::Windows Servers (https://www.eqemulator.org/forums/forumdisplay.php?f=587)
-   -   Windows Server Installer :: Modular & Scripted (https://www.eqemulator.org/forums/showthread.php?t=40299)

Ladrone 01-23-2018 02:08 PM

using local login server for remote sessions
 
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 01-23-2018 02:25 PM

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

Ladrone 01-23-2018 04:40 PM

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 01-23-2018 10:06 PM

Quote:

Originally Posted by Ladrone (Post 257230)
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 01-26-2018 01:56 PM

Restore server
 
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 01-29-2018 06:04 PM

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

Code:

    "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
Code:

[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 01-29-2018 11:00 PM

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 01-29-2018 11:16 PM

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 01-30-2018 12:37 AM

Did you enable 'external' access on your database?

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

laxative 01-30-2018 11:53 AM

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 02-03-2018 10:41 PM

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 02-08-2018 10:50 PM

A Moss Viper (DELETE ME)
 
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 02-09-2018 02:09 AM

start server not working
 
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 03-23-2018 11:16 PM

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 03-26-2018 03:09 AM

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 04-05-2018 07:36 AM

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 04-05-2018 08:23 AM

Quote:

Originally Posted by Arkansas (Post 258152)
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?Complet...er_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 04-05-2018 10:19 PM

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 ?

Quote:

Originally Posted by phantomghost (Post 258153)
If you did not install reference this:

http://wiki.eqemulator.org/p?Complet...er_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 04-07-2018 11:53 AM

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 04-07-2018 01:39 PM

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 04-07-2018 09:19 PM

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.

Quote:

Originally Posted by GRUMPY (Post 258165)
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 04-07-2018 09:29 PM

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 04-07-2018 09:50 PM

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 04-07-2018 10:01 PM

Here is the error I get ?

https://imgur.com/S7jGDLN

GRUMPY 04-07-2018 11:35 PM

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 04-08-2018 12:43 AM

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 04-08-2018 03:49 AM

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 04-08-2018 09:26 AM

Quote:

Originally Posted by Arkansas (Post 258182)
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 04-09-2018 12:59 AM

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 04-09-2018 06:00 AM

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 04-09-2018 02:40 PM

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 04-09-2018 03:01 PM

Quote:

Originally Posted by c0ncrete (Post 258196)
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 04-09-2018 04:03 PM

Quote:

Originally Posted by Tegila (Post 258197)
It is? Thought he was just shortening titanium to titan.

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

Uleat 04-09-2018 04:41 PM

wfmaacms-anl!

Arkansas 04-09-2018 08:21 PM

bump .....

Arkansas 04-09-2018 08:23 PM

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 04-09-2018 08:52 PM

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 04-09-2018 08:54 PM

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

I'll leave the current postings for now.

Arkansas 04-09-2018 09:13 PM

I think I see where the problem was actually. http://wiki.eqemulator.org/p?Akkas_P...ctions-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 04-09-2018 09:29 PM

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 ?


All times are GMT -4. The time now is 03:26 PM.

Powered by vBulletin®, Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.