need some help with configuration [Archive]

View Full Version : need some help with configuration

Davood

07-20-2015, 02:40 AM

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!

N0ctrnl

07-20-2015, 02:54 AM

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

Kailow

07-20-2015, 03:28 AM

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"

Davood

07-20-2015, 09:27 AM

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

<?xml version="1.0">
<server>
<world>
<shortname>MDB</shortname>

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


<address>99.248.99.238</address>
<localaddress>192.168.1.107</localaddress>


<loginserver>
<host>eqemulator.net</host>
<port>5998</port>
<account>NOT THE REAL INFO</account>
<password>NOT THE REAL INFO</password>
</loginserver>






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


<key>NOT THE REAL INFO</key>


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


<chatserver>
<host>99.248.99.238</host>
<port>7778</port>
</chatserver>


<mailserver>
<host>99.248.99.238</host>
<port>7778</port>
</mailserver>

<zones>
<defaultstatus>0</defaultstatus>


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


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




</launcher>


<files>




</files>

<directories>



</directories>
</server>

Davood

07-20-2015, 09:29 AM

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

Davood

07-20-2015, 09:40 AM

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

ports seem to be correct?

Davood

07-20-2015, 10:05 AM

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?

Lodor

07-20-2015, 10:10 AM

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.

Davood

07-20-2015, 10:21 AM

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

Lodor

07-20-2015, 10:25 AM

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.

Davood

07-20-2015, 10:26 AM

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

Lodor

07-20-2015, 10:27 AM

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

Check this thread

Davood

07-20-2015, 10:41 AM

flagging account from command line seems to not help

chrsschb

07-20-2015, 10:42 AM

Davood

07-20-2015, 11:09 AM

Has your server always functioned with these values defined?


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

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?!?!?!

Davood

07-20-2015, 11:21 AM

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

Davood

07-20-2015, 11:28 AM

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

Maze_EQ

07-20-2015, 11:46 AM

I made a character....actually 4.

justzone loops in Crescent.

Davood

07-20-2015, 12:16 PM

back to square 1?

Lodor

07-20-2015, 01:08 PM

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

Lodor

07-20-2015, 01:21 PM

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

NM, zone crashed and now mobs are back.

archdragon24

07-20-2015, 01:40 PM

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.

Davood

07-20-2015, 02:16 PM

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

Lodor

07-20-2015, 02:17 PM

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.

Lodor

07-20-2015, 02:18 PM

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

Davood

07-20-2015, 02:18 PM

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

Davood

07-20-2015, 02:24 PM

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

N0ctrnl

07-20-2015, 02:43 PM

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.

Davood

07-20-2015, 02:46 PM

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

Davood

07-20-2015, 02:56 PM

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

N0ctrnl

07-20-2015, 03:02 PM

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.

archdragon24

07-20-2015, 03:29 PM

Hi Davood,

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

That apepars to have information on how to mass update it

Davood

07-20-2015, 03:34 PM

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.

Davood

07-20-2015, 03:41 PM

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

archdragon24

07-20-2015, 03:50 PM

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

Leetsauce

07-20-2015, 04:11 PM

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.

Davood

07-20-2015, 05:11 PM

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

Davood

07-20-2015, 05:12 PM

Davood

07-20-2015, 05:17 PM

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 :(

Nightrider84

07-20-2015, 10:23 PM

new code isn't always a bad thing =p