Windows Server Installer :: Modular & Scripted

[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...r-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...

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