Jump to content


  • Content Count

  • Joined

  • Last visited

  • Days Won


dane last won the day on January 24

dane had the most liked content!

Community Reputation

3 Neutral

About dane

  • Rank
    Advanced Member

Recent Profile Visitors

The recent visitors block is disabled and is not being shown to other users.

  1. dane

    Importing old Database

    This sounds like it would be pretty easy to do in sql. Just use alter table to add the column you're missing -- no need to delete anything. Then import without dropping the table, skipping duplicates. I think it would be harder to do in a spreadsheet. If you're going from a repack to the official version, I'd hesitate to change any of the tables too much though. It kind of defeats the purpose.
  2. If bisect didn't fix it, that suggests that your database was the problem. When you say you rebuilt it, do you mean you started with an empty database? That would be my next step (after backing up the old database, naturally). If that worked, I'd try restoring the backup and deleting all the auction data. Note that you need to remove the auction items as well as the sell data. I've done this before, but forgot to take notes on the queries I used. If an empty database doesn't work, I'm stumped. I need to update my server and see if there are any problems.
  3. Well, you can see in server/game/Accounts/AccountMgr.cpp that it's caused by something calling AccountMgr::HasPermission without supplying an accountId. Since that file hasn't been changed in a while, it's an issue with the caller or your databases. I suspect that one of your accounts has somehow got a zero account id or some change to the databases is causing HasPermission to be called without a valid account, but that's just a guess. You might narrow the possibilities down by using git bisect (http://webchick.net/node/99) to figure out where the problem started. You could also do a web search and find this (possibly related?) problem which referred to auction house code: https://community.trinitycore.org/topic/11138-account-manager/ If the auction house is to blame, you might be able to fix it by clearing the auction data.
  4. dane

    Compile or cmake problems

    A custom version could be a problem. You should probably try the regular version first, and make sure it works. https://github.com/TrinityCore/TrinityCore/archive/3.3.5.zip
  5. I don't think anyone can help you without more information. I know I can't.
  6. Your screenshot shows the master branch under unix, so that's confusing. Maybe it would help if you describe your current setup. What operating system are you running? Did you get the source with git? (The answer should be yes.) Post the result of "uname -a", "git remote show origin" and "git branch -v". Are you running the client on the same machine as the server? What's in your realmlist.wtf? What do you get from sql when you run "select * from auth.realmlist;"? What do you get when you run "iptables -L" and "ip6tables -L" on both (linux) client and server machines? You might even link your Server.log and Auth.log, if that's not a problem.
  7. dane

    Compile or cmake problems

    Did you enter these commands, like the post said? declare -x CFLAGS="-m64 -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -O1 -g3 -ggdb3 -pipe -msse3 -fno-strength-reduce -fno-delete-null-pointer-checks -fno-strict-aliasing -frename-registers -rdynamic -fno-fast-math -lpthread" declare -x CXXFLAGS="-m64 -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -O1 -g3 -ggdb3 -pipe -msse3 -fno-strength-reduce -fno-delete-null-pointer-checks -fno-strict-aliasing -frename-registers -rdynamic -fno-fast-math -lpthread" cmake ../ -DCMAKE_BUILD_TYPE=None -DCMAKE_INSTALL_PREFIX=/your/installation/path If that doesn't compile, try deleting your build directory, then make it again and run your cmake commands in the new one. Ideally you should be using Debian stable on bare metal, not any version of Debian running under windows. Your openssl might be an issue, but I remember running 1.1, the last time I compiled on Debian, without any problems. If you want to be sure, download the older library ( https://packages.debian.org/jessie/openssl ), unpack it into your source directory, and use the following cmake parameters to point to it: -DOPENSSL_LIBRARIES=<path to OpenSSL library> -DOPENSSL_INCLUDE_DIR=<path to OpenSSL includes>
  8. dane

    Compile or cmake problems

    You might want to check this out: https://community.trinitycore.org/topic/13962-trouble-with-your-trinity-install-starting-login-readme-1st-faqs/?tab=comments#comment-47706 "undefined reference to `pthread_create' "
  9. dane

    Running into error building core

    Have you tried deleting your build directory and recompiling everything? If your compiler has changed at some point, the defaults regarding PIC and PIE may have changed, so part of the code is compiling one way and part another.
  10. > What does it mean to execute the following query? You'll probably want to read this. It tells you how to run a query file in mysql: https://dev.mysql.com/doc/refman/8.0/en/mysql.html I'm not familiar with the graphical clients, but the command line version should work the same in windows as it does in linux. Basically, you're using the "<" symbol to read the file into the mysql client. You may also need to specify the user name and password. >What files are they referring to? The two linked query files. You actually only need the 3.3.5 version, so it would have been clearer to say "one file". Edit the query file you download (if you want to), then run it with mysql, the way they do in the link above, to create the database user and the databases. >I put the TDB_world.sql file in the .../bin folder where worldserver.exe is. I ran it with heidiSQL and am not sure if that is all I was suppose to do? I'm assuming worldserver binary means worldserver.exe? Don't run the TDB*sql file. It's imported automatically when you run worldserver. Yes, executable files are binary files. I'm not sure where the 'yes' password is coming from. The database password(s) in the configuration files and the query file you use to create the databases must be the same. Note that you don't have to change them from the defaults. If you haven't run the query file yet, you haven't created the database user, so it would make sense that the program can't gain access.
  11. If you're cloning from the url in the drop-down, you'll always get all branches. Just use git to select the 3.3.5 branch. At a linux shell, it would be, "git checkout 3.3.5", as I recall. You could also clone a specific branch with, "git clone -b 3.3.5 https://github.com/TrinityCore/TrinityCore.git" Or you could just download the branch directly from https://github.com/TrinityCore/TrinityCore/archive/3.3.5.zip, unzip it, and go to town.
  12. Is this important? I've always done it the other way round with authserver redirected to /dev/null, but it's easy enough to change the script.
  13. I just open a terminal window, cd to the server directory, and enter "authserver & worldserver".
  14. dane

    Vanilla RAID balance

    I don't think there is. You can change the toughness of elites and bosses and disable the raid requirement for instances in general. To be more specific, you'd have to write a script and/or change the database values.
  15. Are you saying that you have completely disabled all firewalls and still can't connect?