Agrikk

Figured it out: the more powerful GM spells can only be used while in GM mode. In hindsight it seems obvious.

Once upon a time I was messing about on my 3.3.5A server and turned a character into a GM to mess about with the commands available. I was having fun with the "Area Death (TEST)" spell and then moved on to other things. Now months later, I started another character for ~reasons~ and I ran ".learn all gm" to give myself the BLIZZARD tab in my spellbook. While I am able to cast the buffs ("Master Magic" "LeCraft Test Spell" "Master Ranged Buff") as well as "dmg9", etc, I cannot cast "Area Death (TEST)". When I try I get "The Spell is not available to you". This is weird because I can cast it on the old character (Level 21 Draenei Mage) which is in the same account as this new character (Level 21 Dranei Mage). Why would this be? What setting have I missed?

As I suspected, it turned out that the hosts file edits were unnecessary. The real issue was a recursive rule in my firewall not configured correctly. Once I fixed my mistake I'm not able to connect to my server internally and externally.

I suppose I should have mentioned that my firewall is a Sonicwall NSA4500. It's not a consumer router but an enterprise-grade firewall appliance. Nevertheless... I edited the hosts file and added these lines: 127.0.0.1 wow.mydomain.com 192.168.x.y wow.mydomain.com 50.251.a.b wow.mydomain.com and then restarted both authserver and worldserver but I still cannot connect to it.

I have a virtual server on my home LAN that I am attempting to turn public, but I'm having trouble with the configuration. My original, private server configuration works just fine but when I make the configuration changes to turn it public, I can't connect. Windows Server 2016 server hostname: wow1 TrinityCore 3.3.5a wow1 Private IP: 192.168.x.y Firewall Public IP: 50.251.a.b Firewall ports opened: TCP&UDP 3724,8085 public DNS A record: wow.mydomain.com I have: poked holes in the firewall for UDP and TCP for 3724 and 8085 registered the A record for my DNS domain wow.mydomain.com for IP 50.251.a.b created NAT entries in the firewall forwarding 3724 and 8085 from the public IP (50.251.a.b) to the private host wow1 (192.168.x.y) altered the realmlist entry in the auth database, changing the address entry from 'wow1' to 'wow.mydomain.com' in my client on a remote, external network network, I edited C:\WoW\Data\enGB\realmlist.wtf changing 'set realmlist wow1' to set realmlist wow.mydomain.com' I intentionally skipped configuring host files and/or configuring dynamic DNS since I have a registered domain name and static public IP addresses. Eventually I'd like to have it set up so I can connect internally and externally to wow1, but for now I'd like to simply get the external access working properly. What have I missed?

I am using MySQL 5.6. Can you tell me more about how to apply the updates? In the four folders (auth, world, characters and hotfixes) there are over three hundred files. I can't imagine that I'm supposed to execute each file one at a time in MySQL Workbench. How am I supposed to apply these?

How do I apply the SQL update files located in SQL\updates to bring my server up from 7.3.5 to 8.1.5? I have downloaded the current master branch(8.1.5.30706), compiled it using vmaps, mmaps, gt, dbc and cameras files extracted from the latest retail client (8.1.5 30706). When I launch worldserver.exe I see it populating the databases from the included SQL files (TDB_world_735.00_2018_02_19.sql and TDB_hotfixes_735.00_2018_02_19.sql). The problem is that when I then exit and restart worldserver.exe I get about 80,000 errors like the following: SmartAIMgr::LoadSmartAIFromDB: Entry 18931 SourceType 0, Event 3, Link Source Event not found or invalid. Event will never trigger. SmartAIMgr: Entry 2225800 SourceType 9 Event 7 Action 11 uses non-existent Spell entry 38679, skipped. TSCR: DB table script_waypoint has waypoint for creature entry 17238, but creature does not have ScriptName defined and then useless. Table `waypoint_scripts` uses deprecated direct updatefield modify command SCRIPT_COMMAND_FIELD_SET_DEPRECATED for script id 463 Scriptname: `spell_hun_improved_mend_pet` spell (Id: -19572) does not exist. etc I can log in to the server and create a new character, but the game is broken (no exclamation points showing for quests, can't cast spells, etc). When I run SELECT * FROM 'VERSION' my database version is still 7.3.5 even though I see in the SQL\updates folders there are .sql files that look like they'll update the version of my databases to 8.1.5. But when I attempt to execute them I get SQL errors so I don't think I am applying these update files correctly. Help, please?

I figured it out. I still had 127.0.0.1 set in a couple of places. I had to change the IP address in the following locations: Database: auth.realmlist.address and auth.realmlist.localaddress to 10.x.y.z bnetserver.conf: LoginREST.ExternalAddress=10.x.y.z LoginREST.LocalAddress=10.x.y.z Client: World of Warcraft\ _retail_\WTF\Config.wtf SET portal "10.x.y.z"

Hello all, I have stood up a Master server based on the 8.1.5 (30706 x64) retail client, but I cannot figure out how to connect to it. The installation documents say "you will need a custom client launcher (not provided) to connect to master branch server." but I'm stuck. I found the Arctium WoW Client Launcher but when I put it in the root directory and execute it, it launches the game client and get a "You have been disconnected" error when I type in my credentials. What am I doing wrong? What step(s) have I missed?

nevermind. figured it out.

Quick question: Is the Trinity application stateless? Not so quick question: If I have the MySQL database on a highly available cluster, and install the executable on an application server, could I clone the application server and put all of the app server nodes behind a load balancer? I'm thiking about building a server on AWS and my design would be: internet --> elastic load balancer -- application server pool -- RDS MySQL Has anyone had any success with building a highly-available and highly scaleable Trinity Core install?