[Stuck at connected / infinite loop / login issues / battle.net]

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.

[Stuck at connected / infinite loop / login issues / battle.net]

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

[Stuck at connected / infinite loop / login issues / battle.net]

I read it and apply it, so what's wrong concretely. :/

I may have misunderstood some things but I do not think so.

[Stuck at connected / infinite loop / login issues / battle.net]

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

[Stuck at connected / infinite loop / login issues / battle.net]

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

 

[Stuck at connected / infinite loop / login issues / battle.net]

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 !

[Follow Tutorial => missing table]

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)

[Follow Tutorial => missing table]

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

[Follow Tutorial => missing table]

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

[Follow Tutorial => missing table]

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

 

[Follow Tutorial => missing table]

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

[Follow Tutorial => missing table]

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

[Follow Tutorial => missing table]

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'

[Follow Tutorial => missing table]

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