Jump to content

All Activity

This stream auto-updates     

  1. Yesterday
  2. Last week
  3. After a recent update in the 3.3.5 branch I get the following error when launching authserver: https://pastebin.com/EuHb2EY6 I think it may be related to getting rid of sha_pass_hash being replaced with salt.
  4. The only supported & developed version is TCPP. But I can't patch the original wow & wow64 exe & dll files by TCPP patcher. It's too bad that this fork uses the bnetserver authentication system and not the old way (authserver). so sad,
  5. Good Evening Uee, I am having the same problem you have been, and I hope that I might be able to replicate that solution. Could you tell me what you did, or else let me know where I can find the discussion?
  6. idk what you did, but if you have fresh cloned latest trinitycore and used TDB 335.20071 as base it don't must run those ancient updates.
  7. Isn't boost installed in the "C:/local/" directory by default?
  8. hello my people can help me I have a problem I use the last version which is rev64 These 2 problems I have as I request them, please help me first problem >> Applying update "2018_10_09_02_world_335.sql" '8CF69D6'... mysql: [Warning] Using a password on the command line interface can be insecure. ERROR 1366 (HY000) at line 20: Incorrect string value: '\xD0\xAF \xD0\xB6\xD0...' for column 'RewardText' at row 43226 second problem Applying of file 'C:/Users/Usuario/Desktop/TrinityCore-TDB335.20071/sql/old/3.3.5a/world/64_2019_03_19/2018_10_09_02_world_335.sql' to database 'world_2' 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 World database, see log for details. please my people help me with 2 problem I have when opening worldserver I get that
  9. i have macro findBoost, if i change the library search rules, nothing bad happens?
  10. https://ibb.co/H2b7X23 I cannot understand what the problem is. And I want to know the reason for this error, since I want to restore an old project that worked before reinstalling the operating system. Previously used boost 1_60_0-14.0. But after reinstalling the operating system and installing a latest Vstudio, VS gives an error that some boost libraries are no longer supported. This caused the installation of 1_72_0-14.0 and 1_72_0-14.2 : the result is the same and stopped on Cmake.
  11. It is not easy to help you with this little amount of information. What OS? (Probably Windows) It says it can not find your Visual Studio. Please check the requirements for the installation in the installation guide.
  12. Tengo problema cmake acavo instalar todo ahora me da ese error como lo soluciono alguna guía I have cmake problem I just installed everything now it gives me this error as I solve some guide
  13. This was a great read! I have to agree that these servers that spend all this time and money on developing working content, then die off in a few years and all that hard work is lost, is a crying shame.
  14. Most people who have a larger user base just run a Virtual Computer hosted in a cloud like service such as AWS or one of the many VPS style video game server hosting websites. Still very cool info.
  15. Earlier
  16. I rolled a docker container of 3.3.5 and have been testing it on various systems. I've been running a small private server for a few weeks (mostly for my wife and I), and I migrated the database to my docker instance so we could play on my test systems. I found that Linode's smallest node (1G ram, 1 core) is too small to even start the server on, but the next highest one (2G ram, 1 core) is perfectly adequate to run on, though @ 61% memory use. Not sure how it scales above 2 people, but that's worth watching if you want to open your server up to others. If you want to run a server at home, I spun an instance up on a tiny AMD T48E, thats a 2 core 1.4 GHz CPU with integrated "GPU" that comes bolted onto a mini-ITX board. I'm running Ubuntu 20.04 server edition, and 16 gigs of RAM (couldn't find less, sorry), and it's barely breaking a sweat. So all in all, you can get away with running TrinityCore on _really_ low spec hardware if you're aiming for a small server. Just some FYI if anyone's interested.
  17. Sounds familiar, I made these packages to get 'a feel' for making software packages in general (I know, they probably are not good enough to be included in Debian or any other OS, but they have been good enough for my personal stuff and at work). Build automation should be easy once you built the first docker image. You might want to check out Drone (https://drone.io) for a Docker integrated CI/CD solution. I use it to build some Docker images for my own personal systems.
  18. It's not natural at all. If you look through the table structure, you will see that the RealmId originates from worldserver.conf and carries through to the DB. RealmId must be unique per application instance - i.e. the database is effectively sharded / separate, based on the realmid. Furthermore, the app will be caching a lot of data and won't read unless it needs to. Otherwise it would be dreadfully slow. Hence, you need to fix your network setup and have a single realm working on both connections instead of looking for ways to have 2 realms act as 1. Migrating characters should be easy, since all you need to do is a global update on the realm id on all tables, given you will be abandoning the other realm.
  19. @Thulium Ah ok, that's what the database build script is for. I need to put more time into running the rest of your stuff, as it will likely take care of even more things I need. Thanks for the tips - explains the missing runtimes. I'm not sure how much energy/time I have for this either, I get the feeling there's a bit of a shortage of build people on TC. Fortunately this project overlaps nicely with my day job, so I just treat it as educational. Yes, hopefully with get around to size-optimizing the container, maybe even automating building it.
  20. So - I don't know if I did something wrong or what. Let me first describe the issue, and then describe my setup. 1. The problem When I learn a profession (have not tried all, but have tried tailoring, enchanting, mining and blacksmithing), the skill appears on the professions pane, and the skill becomes 0/0. Tailoring is impossible to level, as the initial 3 recipes (of greatest importance is Bolt of Linen Cloth) are missing. Mining is impossible to level, because mining doesn't grant any levels, and the pick shows red text indicating mining skill is missing. However, if I click on a mineral node, (copper - have not tried other minerals), it does mine! Have not tried to actually make something with blacksmithing and enchanting. 2. The setup My setup is fresh - I only started with Trinity Core yesterday, so it was a matter of following the instructions on the wiki page. I am running a debian 10 buster server. I followed the linux / debian instructions to download the latest code in the master branch from git, and then compile it, etc. I used the data files generated from the current version of World of Warcraft retail. I used the database files that were in the wiki... TDB830.20061 3. According to the issues board, there seems to be a similar sounding issue, but not identical to my symptoms - about tailoring at a much higher level than mine. https://github.com/TrinityCore/TrinityCore/issues/24026 It said that this was caused by the DB values being wrong. If that is so, I assume there's a disconnect between the DB script I used, and the code I am running (830 for the sql file; vs 837 being the latest code version). Is this what is causing my problem? How do we keep the DB and code in sync? And where can we get the older client from? 4. So after I posted this thread, I went digging into the DB. Lo and behold, I found that the values in character_skills table seem off, and aligned with what I was seeing on the screen. i.e. character_skills table contains the following entry (character level 8): 1, 186, 1, 40 According to Wowhead, mining is skill id 186, so this should be something like: 1, 186, 1, 75 or 1, 186, 1, 300 Furthermore, 186 doesn't exist in the table skill_tiers, which I assume is necessary to learn the correct profession, given the data of the other entries. So I think this confirms that TDB830.20061 is the issue. Line 5459 of TDB_full_world_830.20061_2020_06_17.sql - There's no skill 186 in this table, hence the skill is being treated as some combat skill (5 x char level). Now I'd like to ask where I can find an ERD of the db, so I can try to fix it myself. I'll contribute back once I have fixed it. Thanks in advance
  21. There is, check trinityserver-database3.3.5, it also has a small script that will setup a db server :-) I split that off on purpose, so it's possible to run multiple trinitycore instances sharing the same DB without lugging around multiple copies of the database. The build script does some magic to copy all the SQL files out of the github source of TC. Nice work! It's actually quite well suited to run in docker, all of the dependencies can be just folded in one neat little container, and (not sure if you can) should you statically link the binaries, you can probably even cut out most of the surrounding Debian OS. Oh, one last thing, the dependencies section in the build files is only build-time dependencies, you can't compile something that is an SQL client without the required header files ;-) runtime dependencies are in the DPKG definition at the bottom. Do note BTW that I will not port the packages to Debian 11 next year, as I no longer play WoW nor run a server myself!
  22. @Thulium I got 2) to work, in a slightly roundabout way. I built my own, but the install failed just like it failed with yours because dpkg couldn't find systemd. At least when I try to install it, if systemd is not present the install will outright fail, I don't know how to tell dpkg to ignore the post-setup. Docker containers by design don't allow systemd at all, I think there are ways to force it in but this is not how containers should work. BUT, I realized I could unpack a deb file, strip out the systemd config contents, repack, and install, and voila, it works. Next step is to try this with your builds so I don't have to run my own When I ran TC it failed with some missing dependencies (mariadb-dev for ex), and also there were no sql files in the package so the server couldn't self-scaffold. I'm guessing the scope of your builld is just the executables? I managed to fix these and ... I got my dockerized TC to work! Your build script was essential for me to figure out how to get here, I'm going to write up a guide and put it on github. My plan is to explain how to setup a server from scratch on a linux cloud box, I'd love to base it on the builds you're doing, so it's one less thing for people to have to do. I don't suppose these's a convenient 3.3.5 data dump out there that I can also point to so people don't have to extract?
  23. The setup_database.sh script is in _trinitycore-database3.3.5_ only, as the script relies on the SQL files also distributed using that package. But the database package is _not_ installed automatically, due to the fact that you might want to use a dedicated database server.
  24. You can still use it without systemd, the package places some stuff in /etc/systemd/system, which only does stuff as long as systemd is in your docker images :-) So you can do one of 3 things (the third is only for completeness sake, you should pick 1 or 2): 1. Add the package as-is to your docker, ignore the systemd config (it has no dependencies on systemd, so you can install it in an image without systemd) 2. Make your own build, be sure to copy the repo and remove the systemd stuff from trinity-server3.3.5.files/B_DEBIAN (this is the 'control' directory for dpkg). You can also see the things I do to start the server. 3. Run the containers privileged, systemd is weird that way... (don't actually do this)
  25. OK here is a background of what I am working with. I am hosting my own Trinity package on a virtual server '16 at work (don't judge me). I have 8050 and 3724 opened on our cisco firewall. I am using No-IP for DNS hosting. DNS is working fine. I can easily do a NSLookup and get reports back via inside seeing my server's Static and pinging outside ( to see my DNS set as my public IP. So I know DNS is working fine. I can access the private server fine outside my network with one 1 realm setup. Only way to access the "Server" inside my network is to setup a second realm in the database. So for explaining sake lets look at it like this: Realm 1 = Public access - Works fine Realm 2 = LAN access - Works fine but can't see anyone logged into Realm 1 and vice versa Now here is my issue. Is it possible to have both realms merged to where when I am sitting in my office playing I will be able to see my friend who is at it his house? Currently that is not the case, however what ever I do on the realm inside my network syncs to the public realm. Which is natural since it's the same database.
  26. Hey @Thulium First, thanks for this project, I'm running my first build of the server now (it still takes forever!) Second, I'm trying to get a docker image of TrinityCore going, and it would be a huge step forward if I could get a reliable package build of all the TrinityCore binaries. Unfortunately, the builds I'm getting from your package repo seem to rely on systemd to work, so I cannot run them inside a Docker container. So, now I'm trying to figure out how to build this project without systemd. The build tool you're using is new to me, and I can't find anything obvious in the build config in the trinitycore-recipes repo that includes systemd, other than the daemon restart command in postinst. Do you have any suggestions for how to remove systemd from the build? Thanks again
  1. Load more activity
  • Newsletter

    Want to keep up to date with all our latest news and information?
    Sign Up
  • Create New...