Public server help!

[giovanyac]

Hello guys, I need some help with my server.
So, I have this compiled SkyFire Emu 4.0.6a server and while trying to make it public, didn't suceed.
I changed the hosts file in windows:
127.0.0.1 localhost
192.168.0.177 unknownserver.zapto.org
186.207.65.11 unknownserver.zapto.org
192.168.0.1 unknownserver.zapto.org
I changed the realmlist to the no-ip I created and I can't log on. I have also tried, because I am in the same wi-fi as the host to use his local ip address to acess as well. I can at times, see the realms but not enter.
The host can log on, no matter the ip on mysql.
There are 2 lines on the realmlist table on mysql, one is with the no-ip and the other with 127.0.0.1
And when the host enters there are just some npcs with the name "Unknown", there are no quests, no spawns to kill as well.
We are currently using the same wi-fi. But also when our friend tried to enter he had no sucess.
We have all these ports liberated:8080-8100,3724,80,3306,8129,8093,6112,6881-6999,3036,8050
How can I fix this?

Thanks in advance.

[Nyarly]

Oh i was about to make a thread but we have almost the same issue so i'm posting it here.

Nothing seems wrong when i'm lauching worldserver and authserver. It is installed on a remote ubuntu server. I do not share the same connection and all the ports on my pc are opened.
Here is what i get when i'm trying to connect to the server :
http://img705.imageshack.us/img705/7...1511172653.jpg
The dialog disappear after 1sc and i'm stuck here :/

I checked my .conf files but i can't find what i did wrong, any idea ?

(i can provide logs and/or more screenshots)

[Namor]

Is there not any errors on the console or anything?

[Nyarly]

Is there not any errors on the console or anything?

If you were replying to me, i got some errors with the database (as usual) and vmaps (some are missing, i'm uploading them on the server atm) but nothing critical.

[Namor]

If you were replying to me, i got some errors with the database (as usual) and vmaps (some are missing, i'm uploading them on the server atm) but nothing critical.

What is the error on the database? That's important, you know.

[Nyarly]

I really don't think they're relevant but i can be wrong, so here is my Server.log : http://pastebin.com/aFZkRNWN

And thanks for helping

[Namor]

I'm not seeing any error in your DB that would affect your log-in state. Tell us how it goes when you get the vmaps in there. I'm not sure how TrinityCore/Skyfire work, but in ArcEmu you can still login with the vmaps not being there. But it could make a difference.
And you're getting DBC errors. Your DBCs are from the right version, right?

[Nyarly]

I finished the upload so i got no more vmaps errors but with skyfire too you can login without any vmaps.
DBC, Maps and Vmaps are from a window 4.0.6 version :/

Last lines are :

1. 2011-07-15 17:18:45 WORLD: World initialized in 1 minuntes 0 seconds
2. 2011-07-15 17:18:45
3. 2011-07-15 17:18:45 Max allowed socket connections 1024
   
   

So my guess is that the worldserver works but it cannot accept my connection, but i don't see why :/

[Namor]

Check the configs again is really the only thing left that I can think of.

[Nyarly]

After some reflexions, i think it might be because my server is doesn't have enough ports open.
I ran a netstat : http://pastebin.com/tfjFMuRP
Should i add more ports ? Do you know which ones ?

Anyway, +2 rep for you

[Namor]

Well really it depends on the realm ports you're using in your config files. Whichever one's you're using, you should open.
I know in ArcEmu it's like this:

<Realm1 Name = "Test Realm"
        Address = "127.0.0.1:8129"
        Icon = "PVP"
        Population = "1.0"
        TimeZone = "1">

8129 is the port that needs to be open, and the logonserver's port defaults to 3742, but can still be changed.
Just check your configs and open the ports accordingly.