Vell

I can communicate on 3724 port so my forward is good i think, and i've the same config for 8085. When i check netstat tape, i see that 8085 port is listenning. And my 3724 Listen + etablished. I really don't understand.

When i delete this line, same problem, works on LAN but still not works on net.

I read it and apply it, so what's wrong concretely. :/ I may have misunderstood some things but I do not think so.

Well. My you could help me if i screen ALL. ROOTER DHCP : ROOTER : NAT/PAT : DATABASE Struct realmlist : DATABASE Content realmlist : My hosts file (etc/hosts) : 127.0.0.1 localhost 127.0.1.1 my_pc_name-UBUNTU 192.168.1.78 *******.ddns.net Realmlist : Try with : set realmlist ******.ddns.net and with : set host *******.ddns.net LAN OK but not ext for BOTH. Test : - LAN ping : OK - EXT ping : OK - Check port : OK for both - LAN client : OK - WAN clien : Ok for auth but still stuck on realm

Hello 1 & 2 . I tried it before swaping : 0.0.0.0 to mynoip.ddns.net in conf file 127.0.0.1 to 192.168.1.78 But i put the default file so now 0.0.0.0 in two files. 2. I switched localAddress : 127.0.0.1 to "80.my.wan.ip" 3.That works for 3724 port, why will not it work for 8085 port. I have the same configuration for both. :/ After all the changes : It still doesn't work, always the same problem. I am disappointed. :/

Hello I'm coming back here because I'm trying to mount my server again. I tried a lot of things since the last time Config OS : Ubuntu 17.10 artful (x86-64) (CORE & DB on it) TrinityCore : 3.3.5a Branch Worldconf & authconf Try with : default Try with : bind IP 192.168.1.78 (my local IP) Database realmlist.address : mynoip.ddns.net realmlist.localAddress Try with : 192.168.1.78 Try with : 127.0.0.1 Rooter Try with : Firewall middle security + 3724 & 8085 NAT/PAT Try with : Firewall low security + 3724 & 8085 NAT/PAT Try with : Firewall low security + 3724 & 8085 NAT/PAT + DMZ on my server Hosts file 127.0.0.1 localhost 127.0.1.1 my_server_name 192.168.1.78 mynoip.ddns.net Realmlist client : set realmlist mynoip.ddns.net Firewall : ufw status return Disable Result on LAN client : Connected and play Result on WAN client : stay on realm list, show my realm online but i can't join it Test when distant client try to connect : netstat -tape mynoip:3724 to 0.0.0.0 LISTEN mynoip:3724 to client_ip:random_port ETABLISHED mynoip:8085 to 0.0.0.0 LISTEN No more with 8085 port Conclusion Do you have any ideas on the cause of this problem because I am exhausted ? Thank you in advance !

In fact, in try to upload all time ... so i changed name of folder and worldserver can't found update and so, it doesn't crash. I don't know why it doesn't like it x)

That's ok !!!! So : I applied TDB ... sql with HeidiSQL ... because with worldserver that didn't work. AND ! after new error i renamed : C:\Users\****\Desktop\Trinity\Source\sql\updates\auth C:\Users\****\Desktop\Trinity\Source\sql\updates\characters C:\Users\****\Desktop\Trinity\Source\sql\updates\world to : C:\Users\****\Desktop\Trinity\Source\sql\updates\_auth C:\Users\****\Desktop\Trinity\Source\sql\updates\_characters C:\Users\****\Desktop\Trinity\Source\sql\updates\_world And serv is up !!! Thx Magnuss and Rochet2 ! ^^

Oh, i'm so sorry, i didn't see .... -.- But now : worldserver : Database World is empty, auto populating it... >> Applying 'TDB_full_world_335.60_2015_11_07.sql'... Applying of file 'TDB_full_world_335.60_2015_11_07.sql' to database 'world' failed! If you are an user pull the latest revision from the repository. If you are a developer fix your sql query. Could not populate the World database Maybe one day that will work ><

I try again but i download (.7z) it before, it contains : updates_tdb_33559_to_33560_only (folder) which contains : auth_2015_08_21.sql characters_2015_08_26_2015_11_03.sql world_2015_07_14_2015_11_07.sql not TDB_full_world_335.60_2015_11_07.sql And Source code zip = my source folder I really don't understand ... I have NO file named TDB_full_world_335.60_2015_11_07.sql Must i rename "world_2015_07_14_2015_11_07" in "TDB_full_world_335.60_2015_11_07.sql " ???

And when i apply create_mysql and auth_database + characters_database Worldserver : >> File "TDB_full_world_335.60_2015_11_07.sql" is missing, download it from "http://www.trinitycore.org/f/files/category/1-database/" and place it in your server directory. Could not populate the World database, see log for details. but in : https://github.com/TrinityCore/TrinityCore/tree/3.3.5/sql I have no file named : TDB_full_world_335.60_2015_11_07.sql .... And in : http://www.trinitycore.org/f/files/category/1-database/ There are no files ..

Ok, so, i deleted all. Updates.AutoSetup = 1 Updates.EnableDatabases = 7 (<=> ALL) LoginDatabaseInfo = "127.0.0.1;3306;trinity;trinity;auth" WorldDatabaseInfo = "127.0.0.1;3306;trinity;trinity;world" CharacterDatabaseInfo = "127.0.0.1;3306;trinity;trinity;characters" In HeidiSQL, i created a new user : user name : trinity user password : trinity Privileges : ALL Now, when i started worldserver : Applying of file 'create_table.sql' to database 'auth' failed! If you are an user pull the latest revision from the repository. If you are a developer fix your sql query. Failed to create database auth! Has the user `CREATE` priviliges? DatabasePool Login NOT opened. There were errors opening the MySQL connections. Check your SQLDriverLogFile for specific errors. Read wiki at http://www.trinitycore.info/display/tc/TrinityCore+Home However user exist and privileges too ... ps : In past, with wamp it was really simple ... now not really

I have just problem with .sql so like i said, i created DB with create_mysql + auth_database + characters_databaselike all tutorial said. After that, all tutorial says : Apply TDB full 335, so i dowloaded last relaese : see in first topic. And when i applyed that : world_2015_07_14_2015_11_07 => Erreur SQL (1146) : Table 'world.version' doesn't exist characters_2015_08_26_2015_11_03 => Erreur SQL (1054) : Unknown column 'corpseGuid' in 'field list'

Hello, I have some problems with database 3.3.5. What i did : create_mysql / auth_database / characters_database Now i DL : TDB_full_world_335.60_2015_11_07.sql and i start : world_2015_07_14_2015_11_07 => error characters_2015_08_26_2015_11_03 => error auth_2015_08_21 => error all for missing table .. However, i follow 2 tutorials ... and i can't follow it : https://trinitycore.atlassian.net/wiki/display/tc/Databases+Installation Because : Someone can help me to explain what i forgot. Thx Sorry for my bad english ps : I search and any time "apply update" That not work