Hi guys,
I’ve been following this amazing guide https://trinitycore.atlassian.net/wiki/spaces/tc/pages/2130077/Installation+Guide thus far to setup latest master build on ubuntu 20.04, everything is working, I created account using gm command from worldserver console :
[FONT=‘Courier New’]bnetaccount create test@test test[/FONT]
the acccount is successfully created, however it fails with BLZ51900003 error code when I try to login from wow client on another windows machine on my local network (192.168.1.146)
I turned on trace mode and the only log from bnet server as below when I login:
[FONT=‘Courier New’][192.168.1.146:55432] Accepted connection[/FONT]
[FONT=‘Courier New’][0 ms] SQL(p): DELETE FROM ip_banned WHERE unbandate<>bandate AND unbandate<=UNIX_TIMESTAMP()[/FONT]
[FONT=‘Courier New’][1 ms] SQL(p): SELET unbandate > UNIX_TIIMESTAMP() OR unbandate = bandate AS banned, NULL as country from ip_banned WHERE ip = ‘192.168.1.146’ [/FONT]
I’ve confirmed that my network and database all correctly set and permission granted. What should I look into to resolve this problem?