Minyat
-
Posts
10 -
Joined
-
Last visited
Posts posted by Minyat
-
-
Evidently running the old binaries with the updated SQL updates caused a mess....
trinity@trin3:~/bin$ ./worldserver
TrinityCore rev. de4043097e31 2017-03-26 01:37:49 +0100 (3.3.5 branch) (Unix, Release, Static) (worldserver-daemon)
<Ctrl-C> to stop.
______ __
/\__ _\ __ __/\ \__
\/_/\ \/ _ __ /\_\ ___ /\_\ \, _\ __ __
\ \ \/\`'__\/\ \ /' _ `\/\ \ \ \/ /\ \/\ \
\ \ \ \ \/ \ \ \/\ \/\ \ \ \ \ \_\ \ \_\ \
\ \_\ \_\ \ \_\ \_\ \_\ \_\ \__\\/`____ \
\/_/\/_/ \/_/\/_/\/_/\/_/\/__/ `/___/> \
C O R E /\___/
http://TrinityCore.org \/__/
Using configuration file /usr/local/trinity/etc/worldserver.conf.
Using SSL version: OpenSSL 1.0.1t 3 May 2016 (library: OpenSSL 1.0.1t 3 May 2016)
Using Boost version: 1.55.0
Missing name MySQLExecutable in config file /usr/local/trinity/etc/worldserver.conf, add "MySQLExecutable = " to this file
Updating Auth database...
Missing name SourceDirectory in config file /usr/local/trinity/etc/worldserver.conf, add "SourceDirectory = " to this file
>> Auth database is up-to-date! Containing 5 new and 14 archived updates.
Missing name MySQLExecutable in config file /usr/local/trinity/etc/worldserver.conf, add "MySQLExecutable = " to this file
Updating Character database...
Missing name SourceDirectory in config file /usr/local/trinity/etc/worldserver.conf, add "SourceDirectory = " to this file
>> It seems like the update "2016_10_16_00_characters.sql" '0ACDD35' was renamed, but the old file is still there! Treating it as a new file! (It is probably an unmodified copy of the file "2015_11_07_00_characters.sql")
Missing name MySQLExecutable in config file /usr/local/trinity/etc/worldserver.conf, add "MySQLExecutable = " to this file
>> Applying update "2016_10_30_00_characters.sql" '7E2D5B2'...
Missing name MySQLExecutable in config file /usr/local/trinity/etc/worldserver.conf, add "MySQLExecutable = " to this file
ERROR 1054 (42S22) at line 1: Unknown column 'itemGuid' in 'where clause'
Applying of file '/usr/local/trinity/TrinityCore/sql/updates/characters/3.3.5/2016_10_30_00_characters.sql' to database 'characters' failed! If you are a user, please pull the latest revision from the repository. Also make sure you have not applied any of the databases with your sql client. You cannot use auto-update system and import sql files from TrinityCore repository with your sql client. If you are a developer, please fix your sql query.
Could not update the Character database, see log for details.
Okay, so what happens if I *did* apply some of the database updates? Do I need to find the particular ones and revert them? -
Okay I think I know what I did. I pulled from the repo on feb24, but my binaries are all dates jan 2016, so I pulled in all the newest db updates but still using the old binaries. I guess that'd do it. :/
-
Hey all.
I've been running 3.3.5a fpr a while (about a year) when I decided to pull the latest commit and update everything.
Everything appeared to go without problem until I started worldserver. It has taken care of applying all the database patches in the past, but this time it appears not to have.
I see:
Updating Auth database...
>> Auth database is up-to-date! Containing 4 new and 14 archived updates.
Updating Character database...
>> Character database is up-to-date! Containing 2 new and 17 archived updates.
Updating World database...
>> World database is up-to-date! Containing 439 new and 1800 archived updates.
In mysql_stmt_prepare() id: 19, sql: "SELECT c.guid, c.name, c.race, c.class, c.gender, c.playerBytes, c.playerBytes2, c.level, c.zone, c.map, c.position_x, c.position_y, c.position_z, gm.guildid, c.playerFlags, c.at_login, cp.entry, cp.modelid, cp.level, c.equipmentCache, cb.guid FROM characters AS c LEFT JOIN character_pet AS cp ON c.guid = cp.owner AND cp.slot = ? LEFT JOIN guild_member AS gm ON c.guid = gm.guid LEFT JOIN character_banned AS cb ON c.guid = cb.guid AND cb.active = 1 WHERE c.account = ? AND c.deleteInfos_Name IS NULL ORDER BY c.guid"
Unknown column 'c.playerBytes' in 'field list'There are errors for 'playerBytes' and 'playerBytes2' for auth. I have skin, face, hairStyle, facialStyle, bankSlots and restState currently, but it looks like playerBytes and playerBytes2 consolidates those?
However, in my sql/updates/characters/3.3.5 dir I only see:
trinity@trin3:~/TrinityCore/sql/updates/characters/3.3.5$ ls -l
total 1
-rw-r--r-- 1 trinity gaming 41 Feb 24 22:47 2016_10_16_00_characters.sql
-rw-r--r-- 1 trinity gaming 105 Feb 24 22:47 2016_10_30_00_characters.sql
and those don't have any changes to add playerBytes and playerBytes2I backed up characters and added those 2 tables using the template from the wiki, and those errors go away, but of course, more come after, including itemGuid in characters and world.game_graveyard_zone.this last one isn't on the wiki at all.trinity@trin3:~/bin$ ./worldserver
TrinityCore rev. d0e4f281a353 2016-01-26 20:58:09 +0100 (3.3.5 branch) (Unix, Release) (worldserver-daemon)
<Ctrl-C> to stop.
______ __
/\__ _\ __ __/\ \__
\/_/\ \/ _ __ /\_\ ___ /\_\ \, _\ __ __
\ \ \/\`'__\/\ \ /' _ `\/\ \ \ \/ /\ \/\ \
\ \ \ \ \/ \ \ \/\ \/\ \ \ \ \ \_\ \ \_\ \
\ \_\ \_\ \ \_\ \_\ \_\ \_\ \__\\/`____ \
\/_/\/_/ \/_/\/_/\/_/\/_/\/__/ `/___/> \
C O R E /\___/
http://TrinityCore.org \/__/
Using configuration file /usr/local/trinity/etc/worldserver.conf.
Using SSL version: OpenSSL 1.0.1k 8 Jan 2015 (library: OpenSSL 1.0.1t 3 May 2016)
Using Boost version: 1.55.0
Updating Auth database...
>> Auth database is up-to-date! Containing 4 new and 14 archived updates.
Updating Character database...
>> Character database is up-to-date! Containing 2 new and 17 archived updates.
Updating World database...
>> World database is up-to-date! Containing 439 new and 1800 archived updates.
Realm running as realm ID 1
Using World DB: TDB 335.62
Will clear `logs` table of entries older than 1209600 seconds every 10 minutes.
Using DataDir ../data/
WORLD: MMap data directory is: ../data/mmaps
VMap support included. LineOfSight: 1, getHeight: 1, indoorCheck: 1
VMap data directory is: ../data/vmaps
Loading Trinity strings...
>> Loaded 1047 trinity strings in 20 ms
Initialize data stores...
>> Initialized 109 data stores in 927 ms
Using enUS DBC Locale as default. All available DBC locales: enUS
Loading SpellInfo store...
>> Loaded SpellInfo store in 37 ms
Loading SpellInfo corrections...
>> Loaded SpellInfo corrections in 6 ms
Loading SkillLineAbilityMultiMap Data...
>> Loaded 10219 SkillLineAbility MultiMap Data in 1 ms
Loading SpellInfo custom attributes...
>> Loaded 214 spell custom attributes from DB in 1 ms
>> Loaded SpellInfo custom attributes in 14 ms
Loading GameObject models...
Loading Script Names...
>> Loaded 2848 ScriptNames in 1309 ms
Loading Instance Template...
>> Loaded 84 instance templates in 1 ms
Loading instances...
>> Loaded instances in 793 ms
Loading Broadcast texts...
>> Loaded 73039 broadcast texts in 284 ms
>> Loaded 73039 broadcast text locales in 769 ms
Loading Localization strings...
>> Loaded 27246 creature locale strings in 241 ms
>> Loaded 19670 gameobject_template_locale strings in 200 ms
>> Loaded 38112 Item locale strings in 237 ms
>> Loaded 2481 Item set name locale strings in 19 ms
>> Loaded 9464 Quest locale strings in 412 ms
>> Loaded 1946 PageText locale strings in 23 ms
>> Loaded 453 points_of_interest locale strings in 1 ms
>> Localization strings loaded in 1134 ms
Loading Account Roles and Permissions...
>> Loaded 646 permission definitions, 629 linked permissions and 4 default permissions in 1 ms
Loading Page Texts...
>> Loaded 1950 page texts in 73 ms
Loading Game Object Templates...
[1054] Unknown column 'faction' in 'field list'
Your database structure is not up to date. Please make sure you've executed all queries in the sql/updates folders.
Aborted
What's my best course of action at this point? I'd really hate to lose all my characters if possible.Thanks.
-
Hello. I've updated server to d0e4f281a353 and created connection_patcher for Mac and Windows.
Mac client connects fine. However Windows client doesn't.Observations:
- Update server on linux succesfully
- Built tools on Mac and created connection_patcher
- Mac: logged in to retail to get latest patches
- Ran connection_patcher on Mac client binary, completed successfully
- Changed realmlist to point to local server
- Mac: launched and connected to server OK
- Win: Updated source on windows box as per wiki
- Built connection_patcher and copied to client dir
- Win: logged in to retail to get latest patches
- Dragged Wow_64.exe onto connection_patcher
- Win: confirmed successful patching completed
- Changed realmlist to point to local server
- Launch patched Win client and observed error:
The CAS system was unable to initialize: ClientHandler: initialization error: failed fetching the CDN configuration file
tact::ClientHandler::Create failed: E_NOT_AVAILABLE
[20160702T19:52:23] {1800} ERR: [6shL:5] 23.72.94.107 HTTP error;
(/tpr/wow/config/76/ed/76ed9bd05be30c3c521a045d177c558), ver=1.1, code=404
20160702T19:52:23] {1800} INF: Got bad content response: idAny input on what I should try next?
Thanks!
-
Hey all.
So I have been building the server on linux, but then compiling also on Mac and Windows just to get the connection_patcher binary to patch the clients.
Has anyone found an easier way to be able to patch multiple platform clients?
Thanks.
-
Update: decided to patch my Windows version as well.
Connection_patcher does it's thing, says it's completed successfully.
When I try to log in, I get: "You have been disconnected. (BLZ5914001)
So, different error, same result.
BattleNet.log shows: Fatal error while logging in | result =( | code=ERROR_HTTP_COULDNT_CONNECT (14001)
| localizedMessage= | debugMessage=JSON error: ERROR_HTTP_COULDNT_CONNECT (14001) token: 1)I've confirmed I can reach the server on port 1119 via nmap. Bnetserver doesn't show any connection attempts at all, so kinda strange in that the patched WoW client says it can't connect, but the connection is up and ready at the server end.
-
Hey Shauren.
Okay thanks. I'll post some more debugging notes in case someone has time to look into it with me...
TrinityCore rev. 174a6142f405
So I re-dl'ed the retail installer just in case my local install is fubar. I'm getting success for the actual patching, but still crashing on launch. bnet log indicates that is trying to connect to my local server on 1119, just as it should. Tested the port and it's open (using netcat), so that seems okay.
I'll step through connection_patcher as it executes to see what is being done on the Mac side.
Thanks for all the work on this!
-
It might be something on the retail side. I see a lot of posts regarding this error. I can launch retail from Launcher only. If I try to launch the game itself, then even with retail I get the same error code. Going to try a reinstall of the retail game and make sure that it works properly before trying to debug the patched version.
-
I can get my Mac binary patched successfully, but I am constantly getting this error on launch:
"You have been disconnected. (BLZ51901021)"
Version 6.2.4 (21344) (Release x64)
* my Config.wtf is set to my local server
* I see a tc_bundle.txt file is created. I copied that to my WoW folder but not sure if there is anything else that needs to be done with it.
* I didn't notice any cache files being created with this patch. In the past there were 2 that were created.
Running 3.3.5 world and auth servers as a service
in Help and Support
Posted · Edited by Minyat
Have a look at supervisord. You can add both auth and world processes here and then easily start and stop them from the command line. You can even set them up in dependent order, so that when world starts, it'll then go ahead and start auth.