EQEmulator Forums - need some help with configuration

EQEmulator Forums (https://www.eqemulator.org/forums/index.php)

- Support::Windows Servers (https://www.eqemulator.org/forums/forumdisplay.php?f=587)

- - need some help with configuration (https://www.eqemulator.org/forums/showthread.php?t=39868)

need some help with configuration

Simple version:
i updated my db and codebase to current code. now people can't login to my server

Explanation:
If I connect from inside the lan pretending im going to the internet. I can
1. connect to char select
2. connect to zone and play around in game

If i connect purely from outside the lan I can
1. connect to char select
2. free ride back to login screen, do not pass go.
3. server doesn't tell me aynthing useful, it thinks everything is good.

the catch:
just before i updated my db and codebase, people were abel to connect to my server. i have not changed my configs on router, and my internal and external ips are the same

i'm out of research options, i need expert advice please!

Are your zones still using the same ports in the database? Sounds like a port forwarding issue on your router.

just an update, as of 12:32am PST (Monday, July 20th), it still has issues connecting. Same old "Server is not responding" and a quick "You have been disconnected from the server"

Quote:

Originally Posted by N0ctrnl (Post 241878)

Are your zones still using the same ports in the database? Sounds like a port forwarding issue on your router.

yes nothing in the DB for launcher_zones has changed.

the config xml file has the same ports as before and router is setup the same as before

here are my configs

windows 7x64 is server os, firewall is disabled.
server is ip address 192.168.1.107 internally and
99.248.99.238 externally

router
http://www.alakamin.com/asdfasdf.png

xml

Code:

<?xml version="1.0">

<server>

        <world>

                <shortname>MDB</shortname>

<!--                <longname>[FV]Alakamin-UBERCRAWL-150Races/BOTS/L100/50Tier</longname> !-->

                    <longname>[FV]Alakamin-UBERCRAWL-50tier-572Zones-150Races</longname>

   <!-- <longname>[FV] Alakamin-Progression-50+ Custom Races- NO DL<--- max length -->

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

                <address>99.248.99.238</address>

                <localaddress>192.168.1.107</localaddress>



                <!-- Loginserver information.  Defaults shown -->

                <loginserver>

                        <host>eqemulator.net</host>

                        <port>5998</port>

                        <account>NOT THE REAL INFO</account>

                        <password>NOT THE REAL INFO</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="enabled"/>



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

                <key>NOT THE REAL INFO</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>99.248.99.238</host>

                <port>7778</port>

        </chatserver>



        <!-- Mailserver (in-game mail) information.  Defaults shown -->

        <mailserver>

                <host>99.248.99.238</host>

                <port>7778</port>

        </mailserver>



        <zones>

                <defaultstatus>0</defaultstatus>



                <!-- Sets port range for world to use to auto configure zones -->

                <ports low="7050" high="7600"/>

        </zones>



        <!-- Database configuration, replaces db.ini.  Defaults shown -->

        <database>

                <host>127.0.0.1</host>

                <port>3306</port>

                <username>NOT THE REAL INFO</username>

                <password>NOT THE REAL INFO</password>

                <db>NOT THE REAL INFO</db>

        </database>

        

        <qsdatabase>

                <host>127.0.0.1</host>

                <port>3306</port>

                <username>NOT THE REAL INFO</username>

                <password>NOT THE REAL INFO</password>

                <db>NOT THE REAL INFO</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> -->

        </directories>

</server>

also i agree something is weird with teh zoner server(s) it (they) can't connect to the outside internet anymore

zone status
http://www.alakamin.com/asdf.png

ports seem to be correct?

added ports 5998 to 6000 to the pass through to 192.168.1.107 just now. didn't help
tried DMZ to 192.168.1.107 as well to see if there were some magic ports i forgot, also didn't help.

seems i can still only connect to zone servers from inside the network and not outside.
it has to be some simple stupid configuration slipup that somehow made its way in with the code and db updates. is there some db setting that locks the zone servers that was added in the last year that i dont know about?

I recall this happening on other servers after a big update. I cant recall the exact fix but it was some small line of code that made it so no external could log in. Ill try to find the old posts talking about it.

tried setting eqemu xml to listen at port 5999 - didnt appear in server list, so changed back to 5998

then tried also changing the passthrough to route 5998 to 6000 to local port of 5998, same problem of not connecting to zone server. so i changed it back

latest bit of testing:
if i connect locally and watch the command window box, the clients immediately goes from 0 to 1 when i zone into game. if i conenct remotely it stays at 0 when i click enter world... so there is something blocking me from accessing the zone server. but what is it?!?!?!?!???????????????? i feel like a nuub

For some reason I think it has to do with flagging as admin vs normal accounts. It is how some "beta" test without the general public getting full access also when the server is up.

well my status 250 account has the same problem as my status 0 account. checked that just now

flagging account from command line seems to not help

Has your server always functioned with these values defined?

Code:

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

                <address>99.248.99.238</address>

                <localaddress>192.168.1.107</localaddress>

I've had situations where port/IP changes take a while to replicate. But I assume you've accounted for that.

Can you actually get to character select? As in see characters? If not it's definitely a port or firewall issue. I had an issue with my 2012R2 server where I had to manually reinstall every instance of the firewall service because it was preventing incoming connections (even though I had it disabled).

Something to think about.

Quote:

Originally Posted by chrsschb (Post 241896)

Has your server always functioned with these values defined?

Code:

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

                <address>99.248.99.238</address>

                <localaddress>192.168.1.107</localaddress>

i can get to char select from "the outside" of the lan
I can get to char select AND into the game from "the inside" of the lan
and yes i've always used these settings

should i unspecify them? generally that causes a lack of being able to connect. I will try that now.
booting
connecting (from external ip)
char select success (wtf.. im excited!)
trying to enter world
success.

wtf that was simple
"chrsschb" i am a big retard. thank you for pointing out the obvious haha... how come it worked perfectly fine for years?!?!?!

looks like other people still can't connect. i see people in limbo trying to get in

nah must be someone on dialup i see a bunch of people successfully in world

I made a character....actually 4.

justzone loops in Crescent.

I got into the guildhall just now logging on my main.

ZOnes in kunark seem to have no mobs spawned in them.

NM, zone crashed and now mobs are back.

Glad to see your working on this, i sent a PM, i get the crescent loop -> Arena every time i login.

You may want to check your zone files, i believe you where using the SoF/Tritanium source code prior to updating? I believe the Arena was updated post SoF, effectively replacing the old files, i'm wondering if that is what is causing the repetitive zoning loop. I have tried in both UF and RoF2 clients (patching Rof2 with the missing UF arena1 zone files). Both clients appear to have the same issue.

As a side note, you may want to check your forum host also, the Caphca image seems to be miss-placed for registering.

1. ok maybe i'll reboot the forums
2. going to look into the zoning loop now, that sounds nasty

You are in a loop because a lvl 1 cant be in either of those zones. You need to get your toon moved to guild hall.

Also, vet AA's are not purchasable now either.

got it.

zone points and safe coords might be broken..... there were 1000s of updates to teh DB in teh last 1.2 years that i tried to cram in yesterday

I will compare everything to the current peq and see

Quote:

Originally Posted by Lodor (Post 241911)

You are in a loop because a lvl 1 cant be in either of those zones. You need to get your toon moved to guild hall.

aha!

shit. why is it sending them there. is that the "client overriding server values for starting zone" problem i had before?

OK i have a simple fix for that

I can just open up those zones and let people in then boot htem if they aren't flagged by sending them to teh right zone. the underlying problem ill tackle later

Are you not seeing errors in your logs for any of this stuff? Sounds like you need to adjust your logging system if not. It should be showing entries for a lot of this stuff.

seems to be a starting zone problem. nobody should be sent to crescent reach. that is plain incorrect. why does it default there.

ok i figured it out.

the way start zones table works now is a single query looking for a specific result instead of taking the default value from the table itself.

i only had 1 entry in there assigned to no race, deity or class, and the server wasn't liking it.

that means i need like

15 races
*
17 deities
*
16 classes

= 4080 entries that will all point to the same exact place :P

Well, if you're opening up all races to be all classes and start in the same zone, yeah, but at least it's easy to make them all the same.

Hi Davood,

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

That apepars to have information on how to mass update it

ok its done 4300 or so entries. wrote a litlte script to generate iteratively . very stupid but it shoudl work.

also i moved all level 1 players to the guild hall

ok stuck in zone loop on new toon creation.

ok i found it

my char_create_combinations table was overwritten by something from the last 100 updates (annoyedface) ill fix that and reboot server rq

Also, the chars you moved, they are stuck under the stairs int he guild hall, tying to message you in game but i think i keep misisng you in the reboots

In case it has not been stated (didn't see it, but wasn't super thorough)

There is a rule for this exact scenario. Iirc it's client-based, and will be determined by whichever client the user is using.

I don't have access to my DB right now for a screenshot or anything, but it's in the rules table and it's something like 'StartZoneForNewClients' or something, and it's generally the zone# (or ID) for CR. I'd go ahead and make that your initial hubzone if you have not already.

Quote:

Originally Posted by archdragon24 (Post 241923)

Also, the chars you moved, they are stuck under the stairs int he guild hall, tying to message you in game but i think i keep misisng you in the reboots

oops hehe. ill fix that pronto

Quote:

Originally Posted by Leetsauce (Post 241924)

great fixing that pronto.. thanks leetsauce.

going to lay low on the rebooting for now, play away guys. im going to hvae another slew of updates tonight. i'm going to try and modernize all of my scripts that previously were tinkering with character_ . now thanks to the eqemu devs i dont have to pick apart the char blob. but it also means alot of new code :(

new code isn't always a bad thing =p