dane
-
Posts
31 -
Joined
-
Last visited
-
Days Won
1
Posts posted by dane
-
-
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.
-
On 10/12/2018 at 10:00 AM, Billy said:
Well tried to use git bisect, didn't find anything.
So .pdumped characters, and rebuilt the databases, and am currently recompiling this morning to see if it happens again.
Did notice a lot of sql's in the pull this morning, so will see if this corrected it or not.
Nope. Damn, had fingers crossed too. LOL!
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.
-
6 hours ago, Billy said:
Anybody know what this might mean?
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.
-
5 hours ago, levani4321 said:
can you add me on discord ? its a custom veriosn trinitycore and its a problem for install ?
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
-
3 hours ago, Lost PMR said:
Its centos, yes its from git, everything is ok, iptable is ok too. Some people can connect from internet some people cannot connect ! they can auth & load characters...
I don't think anyone can help you without more information. I know I can't.
-
1 hour ago, Lost PMR said:
3.3.5a
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.
-
4 hours ago, levani4321 said:
plz someone help me
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 hours ago, levani4321 said:
Hello, I get this error on debian and I can't set it up, but it works properly on windows. Any suggestions ?
You might want to check this out:
"undefined reference to `pthread_create' "
-
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.
-
> 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.
-
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.
-
On 9/7/2018 at 7:44 AM, Aokromes said:
PS. start worldserver before authserver.
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.
-
I just open a terminal window, cd to the server directory, and enter "authserver & worldserver".
-
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.
-
On 8/17/2018 at 2:48 AM, Lost PMR said:
I test to disable firewall! unstuck ... but still not working ...
Are you saying that you have completely disabled all firewalls and still can't connect?
-
It sounds like you're running it on the wrong executable file.
-
It sounds like you ought to delete (or rename) your build folder, make a new one, and configure/compile based on the new setup.
-
I ran into a little issue after updating one of my gentoo machines' mariadb client/server. When I tried to run authserver, I got the error:
Used MySQL library version (6.1.11) does not match the version used to compile TrinityCore (5.7.16). Search on forum for .
After reading up on it, I double-checked my gentoo packages and recompiled trinity in a new build directory, but got the same issue. When I looked at the code and the mariadb headers, it was obvious that the MYSQL_VERSION_ID and LIBMYSQL_VERSION_ID macros were set to two different values (the latter was the one mysql_get_client_version() returned). A quick search suggested that they are expected to be the same. So, I changed the macro in the check in DatabaseWorkerPool.cpp to from MYSQL_VERSION_ID to LIBMYSQL_VERSION_ID, and everything appears to be working fine.
I suspect there's more to this, so I'm backing up my databases more than usual, and I plan on looking everything over thoroughly. I'm not sure if this is a mariadb thing, a gentoo thing, or (most likely) something I jumbled up, and I know that my software is far from common. I also took a look at github pull request 22031, but I don't feel qualified to comment there.
I thought I'd post this in case anyone has any thoughts, or another gentoo/mariadb user has the same issue. I've attached the little patch, just for fun.
-
1 hour ago, yeeswaney said:
On the tutorial at https://trinitycore.atlassian.net/wiki/spaces/tc/pages/10977340/Linux+Server+Setup/
I got absolutely lost as soon as I got to "Linux server setup" It asks for something called the WoW client and I can't seem to find a download for it on Blizzards website or anywhere else for that matter. plz halp
They're assuming you have a World of Warcraft client, either the current one for the master branch, or the 3.3.5 client for that branch. (The client is "the game" as most of us refer to it, as opposed to "the server".) It's illegal (in many jurisdictions) to distribute the client, since it belongs to the WoW people. You can get the current client from battle.net, of course -- it's free to play initially. The older client can be found as a bittorrent, or might be downloaded from one of the independent server operators. A search engine may help find it. Naturally, I don't advise you to break any laws you're subject to, despite the fact that many people have done so in the past.
-
2 hours ago, Kruel said:
Yeah still confused my self on how i would change the directories for config / data files
Look at oXL0C0Xo's post above. That flag changes the config directory. You'll also see it in the drop-down under the linux core installation. The cmake command ought to be roughly the same, so something like
cmake ..-G "Visual Studio 15 2017"-DCMAKE_INSTALL_PREFIX=[install dir]-DCONF_DIR=[config dir]-DTOOLS=1should get you a visual studio solution file which you use to compile (according to the tutorial). I -
3 hours ago, Kruel said:
And how would i be able to do this? only know the basics of cmake for compiling
Presumably, it works a lot like the linux version of the install. However, for more general information on using cmake in windows, you might look at this tutorial, which was the clearest answer I could find. (I haven't used windows in over a decade, so it seems very confusing to me.)
-
8 hours ago, Weirdfish03 said:
So I did what you suggested and I got the server up this time but when I tried to login it said 'Unable to Connect' now what?
When you reinstall the repack does it drop and reinitialize the databases? Does it replace the *.conf files? If not, you still haven't started from zero.
-
When you say you put everything back, did you keep a copy of the files exactly as they were originally? You might try comparing your configuration with the stock files on the github site to see if anything else changed. Are you sure your database server is running? Can you use the mysql command line tool or the windows equivalent to look at the tables?
I had a problem a lot like this recently, with authserver unable to connect. It turned out to be because I edited the mysql.cnf file to disable sql networking on the advice of a security guide. Needless to say, that didn't work out. However, if there's a firewall blocking your loopback connection, that would probably look the same. (Or if the sql server crashed at some point.)
-
19 hours ago, chovie23q said:
i, how do I check for a spell cast ?
When I wanted to do something on a spell cast, I did this, which would probably work, but may not be the best way.
Let's start a new project?
in Chillout Room
Posted
I agree. You should make a start on a new project. You'll probably get a lot more interest then.
However, if you're going to use the stable branch, which is pretty stable in my experience, are you really going to get that much advantage out of rust? (I've never used it.) If not, maybe you'd be better off trying to set up tests, etc. for the existing code.