Ronin825

i have 4 fowarded 1119,8081,8085,8086. but locally i shoudnt have to, especially since im directly addressing it by its LAN address and not hostname or or through url. Ports are open and listening on the machine and i still cant login UPDATE : Fixed the issue by changing the Mysql value in auth.realmlist.LocalAddress to my 192.168.2.55 even tho the tutorial say's not to change it. Might wanna change that. By reading the documentation i figured out that the values in the Mysql Db are the values sent back after a person has been authenticated by the bnet server.

Right now my set up has this structure and theses settings : (Modem) IP : Internal interface : 192.168.2.1 External interface : 70.X.X.X Port Fowarded 8085 ---> 8085 8086 --> 8086 (LINUX Ubuntu 17.10 Server) IP : 192.168.2.55 - bnetServer : created realm 1 at 70.X.X.X : 8085 login service bound to http://0.0.0.0:8081 - WorldServer : does seem to have a lot of load errors, error log file is enormous. dont know if thats normal atm, but seems to be executing normally, account commands and lookup works perfectly. - Mysql server : auth.realmlist value : address : 70.X.X.X localAddress : 127.0.0.1 ( im assuming this is for the auth server to find the sql db or something) (Windows 10 Client Machine) IP : 192.168.2.38 - WoW64-patched.exe ( made with connectionPatcher.exe, compile on this machine, does not have vmaps, or maps etc.) - config.wtf file portal value : i tried both 192.168.2.55 and the 70.X.X.X (both dont work and i get blz51914001 or blz51910002 error) (Friend Windows 10 Client ) IP : External - With same config (wow64-patched.exe with connection patcher) as my machine. config.wtf file is set to my 70.X.X.X IP of course. i nmaped my network from the outside and the inside, port all seem to be proprely open and fowarded, firewall on linux box allows traffic. What am i missing ?

i already run a minecraft server using my IP, and i have a system to share the IP and i have had no problem so far with it. inside the network, the server has a static IP. Just for testing i reset everything to simply LAN values (192.168.X.X) and i still cant connect to the server. - i changed the Mysql realmlist entry address to the LAN IP address -restarted both server's (bnet and world) -re-run the connection patcher on the WoW64.exe -double and triple checked the ports are open on the server and modem. still cant connect from within the network. Edit : Also i noticed i was editing the config.wtf file present in my original C:\World of Warcrfaft\WTF folder and that there one config.wtf folder present in the build file, is that the one i shoudl have been editing before using connection patcher or is it there only for backup purposes ? because its almost empty and has no value under portal. Also i am currently at school to become I.T. and also a decent C++ programmer but this is putting me to shame and making me feel like an idiot, i woudl like to understand the structure of how the DB, the bnet server and world server use the realmlist / config file to communicate. Because i am confused has to how the bnet server and DB need my external IP from within the network, shoudnt they only need the internal one and only the config file of the client outside the network need it to route itself to my server ? Shoudnt i be able to address the internal IP of the server with my client sitting in the network and be able to connect to it ? edit 2: It just occurred to me. Do i need to have the maps,vmaps,mmaps,gt.cameras,dbc files extracted in the client folder on my windows machine or only on the server side ? i looked in the documentation for the Database auth.realmlist and the LocalAddress field has no definition. Shoudl it always stay on 127.0.0.1 or shoudl i put this field to my server internal address so it can accept lan connection ?

1. i modified my DB to have thoses entry's on my linux server. mysql> select * from realmlist; +----+--------------+---------------+--------------+-----------------+------+------+------+----------+----------------------+------------+-----------+--------+-------------+ | id | name | address | localAddress | localSubnetMask | port | icon | flag | timezone | allowedSecurityLevel | population | gamebuild | Region | Battlegroup | +----+--------------+---------------+--------------+-----------------+------+------+------+----------+----------------------+------------+-----------+--------+-------------+ | 1 | WoW-SERVER1 |<MY EXTERNAL IP> | 127.0.0.1 | 255.255.255.0 | 8085 | 0 | 0 | 1 | 0 | 0 | 25996 | 2 | 1 | +----+--------------+---------------+--------------+-----------------+------+------+------+----------+----------------------+------------+-----------+--------+-------------+ 1 row in set (0.00 sec) 2. I compiled the Core Tools on my Windows machine and used the connection patcher on my Wow64.exe and got the Wow64-patched.exe 3. modified the . / WTF/config.wtf file portal field from portal="EN-US" to portal="<MY EXTERNAL IP>" <-- Same as in the DB 4. I port fowarded Both port 8085 and 8086 on my Modem to point to the linux server. ( shoudl not be a concern for me to log in from within my own network, but did for further testing) 5. started my bnetserver and worldserver but i still get error : BLZ51914001 when trying to log in with the account i made in the world console. ( i double checked that its present in the MySql DB). My Modem does not support IP mirroring so i cannot call my own External IP from within the network. shoudl i change the config.wtf portal for my own machine to the internal IP of the server and add in the DB under the localAddress field the internal IP address of the server ?

Thanks, i got it working and finalised my installl. now i have to set up the client on my Windows machine. I was wondering if there was a way to only compile the connection patcher for the client since it seems to be the only thing i need to get it running. isnt there a command in the makefile like : Make connectionPatcher or something, because it seems like a hassle to build the whole core and tools if im only going to use the connection patcher. or is there somewhere i can simply download the tool ?

its the Oracle way of calling scripts....Thanks for the correction. where shoudl i run this script tho, does it matter ? i dont think it does, but i wanna be sure

Hi, im in the process of building the Mysql DB for the server ( Master Branch ) on Linux Ubuntu 17.10 i am using ssh to manage the server and so i use CLI to mange the Database. I pulled the " create_mysql.sql" script from the github page by using ""wget https://raw.githubusercontent.com/TrinityCore/TrinityCore/master/sql/create/create_mysql.sql"" i launched my mysql CLI client with ":mysql -uroot -p<password>" and attempted to run the script with "@create_mysql.sql" and it returned : mysql>@create_mysql.sql ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '@create_mysql.sql' at line 1 is it possible the script is broken ? or did i miss something ?.....again. Thanks for your help and input. also once i get it working, where am i suppossed to execute this script and unpack the TDB_FULL datbase. ? in ~/TrinityCore/sql/base or ~/server/bin

I copied via an external HDD my WoW client to my linux server. Now im facing 2 problems from what i read on the forum and my assumptions. 1) my ./mapextractor is returning this : root@S1:/media/UsbDrive/World of Warcraft# ./mapextractor TrinityCore rev. 9c417089e32e 2018-02-25 16:09:01 +0100 (master branch) (Unix, RelWithDebInfo, Static) (Map & DBC Extractor) <Ctrl-C> to stop. ______ __ /\__ _\ __ __/\ \__ \/_/\ \/ _ __ /\_\ ___ /\_\ \, _\ __ __ \ \ \/\`'__\/\ \ /' _ `\/\ \ \ \/ /\ \/\ \ \ \ \ \ \/ \ \ \/\ \/\ \ \ \ \ \_\ \ \_\ \ \ \_\ \_\ \ \_\ \_\ \_\ \_\ \__\\/`____ \ \/_/\/_/ \/_/\/_/\/_/\/_/\/__/ `/___/> \ C O R E /\___/ http://TrinityCore.org \/__/ Error opening casc storage '/media/UsbDrive/World of Warcraft/Data': FILE_CORRUPT No locales detected 2) in the WoW client folder it seems the dbc is missing but it shoudl be there since i just finished patching the client to the most recent one from Battle.net client which is (7.3.5 ) i beleive. is my Client corrupt or invalid, am i suppossed to get an older client ? If so, what exact version is the TrinityCore master repack supporting ? ------------------------------------------------- UPDATE: I fixed the problem by : - unistalling the client from my Windows machine and deleting all files associated - re-Download the fully updated client (7.3.5.25996) - Copying the Windows Client to the linux server - using the extract tool -mapextractor (proceeded 100% no errors), vmap extractor and assemblor (100% no error) -mmapgenerator is still going At the moment, but its at 50% with no error so far. -------------------------------------------------

thank you for your prompt response !

you mean copy my existing wow folder from windows to my linux machine or download a fresh WoW client on my linux server ? also i forgot to mention that i dont have gui on the linux server, i manage it trough SSH terminal

HI, i have by the past installed the trinity core once or twice, but always did it on my main machine which ran Windows and never had any major issue, btw awesome work on the core, this is some awesome coding ! But now i am building a version on my home server which runs Ubuntu linux 17.10, but i will be running the client on my windows machine. and i never aquired a WoW linux client through wine or anything like that. im at the step in the installation where i need to extract the dbc/Maps/Vmaps/Mmaps etc. from the WoW client to add them to my current ~/server/bin directory, but i since i dont have a client on my linux machine i was wondering how i coudl get thoses files. Do i have to compile a core on my Windows machine to get the tools and extract them from my windows client ? Will the files even be compatible ? I think they might, but i dont wanna go trough the process of compiling a core on my Win10 machine, extract and send the files over to my server to find out they are not proprely formated or what not. i apologise if this is a duplicate topic, i have not found anything specific for this in the forum yet. Thanks in advance for your time !