-
Recently Browsing 0 members
No registered users viewing this page.
-
Similar Content
-
By shroom
Hi,
Following one recent commit officially adding MariaDB 10.4 support, I took this opportunity to update my database server (from MariaDB 10.1 to MariaDB 10.4) and compiled the game server with the corresponding libraries instead of MySQL 5.7.
Everything went fine and the server runs properly.
I had one tiny little issue though: I had to fill the MySQLExecutable variable in the conf file otherwise the worldserver executable wouldn't launch:
Didn't find any executable MySQL binary at '/Server/Release/bin/Release' or in path, correct the path in the *.conf ("MySQLExecutable").
I never had to fill this variable before and it was still working fine with this commit: https://github.com/TrinityCore/TrinityCore/commit/48c700347c91b1748427a8c5b09b8d4099c9a105
I'm running with this commit at the moment: https://github.com/TrinityCore/TrinityCore/commit/43d9ffd1bc127768882711a47d5e2bae92845d04
It's not that big of deal obviously, but the worldserver conf file states for this variable:
If the path is left empty, built-in path from cmake is used.
Alas, while being properly set in CMake, the path isn't used anymore.
Is this the new expected behavior or is this a bug?
-
By gldssgames
Hi, I am having problems with auto update (I find it very confusing to update each update manually), it seems that it only works in version deployed and not as autonomous.
I run mysql via Command Prompt has worked for me for a long time in projects ... I think it may be ... because I point the configuration file.
This sentence caught my attention: "failed! If you are a user" (phrase shown in the worldserver log) which I think may have to have permission
The mysql configuration file, Server log file and the bat pitcher in the form of text is attached, if no one accidentally runs.
The mysql configuration file and the bat mysql run in the form of text is attached, so no one accidentally runs.
I will continue to seek a solution, if I find I put here for others with the same problem.
Thank you for all!
Since I do not speak English, I translated using google, I'm sorry for that.
my.ini
mysql.bat.txt
Server.log
-
By SimonKaru
Hi!
I'm new to c++ programming and TC installation. I've been following all the directions and when I need to input the code "xcodebuild -target install -config Release" I get the following error message :
=== BUILD AGGREGATE TARGET install OF PROJECT TrinityCore WITH CONFIGURATION Debug ===
Check dependencies
PhaseScriptExecution CMake\ PostBuild\ Rules /Users/<username>/trinity/build/TrinityCore.build/Debug/install.build/Script-D663B11FF8DF4EC1A2D72E44.sh
cd /Users/<username>/trinity/repo
/bin/sh -c /Users/<username>/trinity/build/TrinityCore.build/Debug/install.build/Script-D663B11FF8DF4EC1A2D72E44.sh
/usr/local/Cellar/cmake/3.8.1/bin/cmake -DBUILD_TYPE=Debug -P cmake_install.cmake
-- Install configuration: "Debug"
-- Installing: /bin/bnetserver
CMake Error at src/server/bnetserver/cmake_install.cmake:32 (file):
file INSTALL cannot copy file
"/Users/<username>/trinity/build/src/server/bnetserver/Debug/bnetserver" to
"/bin/bnetserver".
Call Stack (most recent call first):
src/server/cmake_install.cmake:35 (include)
src/cmake_install.cmake:34 (include)
cmake_install.cmake:33 (include)
make: *** [install_buildpart_0] Error 1
Command /bin/sh failed with exit code 2
** BUILD FAILED **
The following build commands failed:
PhaseScriptExecution CMake\ PostBuild\ Rules /Users/<username>/trinity/build/TrinityCore.build/Debug/install.build/Script-D663B11FF8DF4EC1A2D72E44.sh
(1 failure)
I've tried everything I could think of :
Run the command with sudo from an admin account;
Run the command from an admin account;
Run the command from the root user;
paste the bnetserver file in the bin directory myself...
I've looked everywhere and nobody seems to have the same problem I encountered. Please help...
I have an iMac(20-inch, Early 2008) running OS X El Capitan version 10.11.6
Homebrew and all the core requirements are correctly installed counting as well the correct version of XCode.
-
By Pettson
Hi,
I just started messing about with TrinityCore (mostly out of nostalgia, and I thought it'd be a good learning experience), and for some reason, there's something going wrong every single time I try to get it working.
I've followed the guide to the letter, and I get to the point where the worldserver executable is importing/updating the MySQL database (I think).
The last message I get before the crash is (running a debug build, the "abort()" line is where the crash would otherwise happen):
Updating World database...
[1146] Table 'world.updates_include' doesn't exist
Your database structure is not up to date. Please make sure you've executed all queries in the sql/updates folders.
abort() has been called
There are no .txt files beyond the DBErrors.log and the Server.log (as follows):
TrinityCore rev. e4dfbb60fd85 2016-02-19 15:03:21 +0100 (3.3.5 branch) (Win32, Debug) (worldserver-daemon)
<Ctrl-C> to stop.
______ __
/\__ _\ __ __/\ \__
\/_/\ \/ _ __ /\_\ ___ /\_\ \, _\ __ __
\ \ \/\`'__\/\ \ /' _ `\/\ \ \ \/ /\ \/\ \
\ \ \ \ \/ \ \ \/\ \/\ \ \ \ \ \_\ \ \_\ \
\ \_\ \_\ \ \_\ \_\ \_\ \_\ \__\\/`____ \
\/_/\/_/ \/_/\/_/\/_/\/_/\/__/ `/___/> \
C O R E /\___/
http://TrinityCore.org \/__/
Using configuration file worldserver.conf.
Using SSL version: OpenSSL 1.0.2f 28 Jan 2016 (library: OpenSSL 1.0.2f 28 Jan 2016)
Using Boost version: 1.60.0
Database "auth" does not exist, do you want to create it? [yes (default) / no]:
Creating database "auth"...
mysql: [Warning] Using a password on the command line interface can be insecure.
Done.
Database "characters" does not exist, do you want to create it? [yes (default) / no]:
Creating database "characters"...
mysql: [Warning] Using a password on the command line interface can be insecure.
Done.
Database Auth is empty, auto populating it...
>> Applying 'E:/Prvsrv/Trinity2/sql/base/auth_database.sql'...
mysql: [Warning] Using a password on the command line interface can be insecure.
>> Done!
Database Character is empty, auto populating it...
>> Applying 'E:/Prvsrv/Trinity2/sql/base/characters_database.sql'...
mysql: [Warning] Using a password on the command line interface can be insecure.
>> Done!
Updating Auth database...
>> Reapplying update "2015_11_07_00_auth.sql" 'BAF9F6B' -> '0ACDD35' (it changed)...
mysql: [Warning] Using a password on the command line interface can be insecure.
>> Applied 1 query. Containing 2 new and 8 archived updates.
Updating Character database...
>> Reapplying update "2015_11_07_00_characters.sql" 'BAF9F6B' -> '0ACDD35' (it changed)...
mysql: [Warning] Using a password on the command line interface can be insecure.
>> Applied 1 query. Containing 2 new and 12 archived updates.
Updating World database...
I've tried running 5.7 and 5.6 of MySQL, and I've tried compiling both x64 and x86 versions (of course I've made sure to use x64 or x86 versions of all the other applications and libraries where applicable) and I get no error messages whatsoever up to that specific point. I've tried googling around a bit, and the only thing I've come across is to import the databases manually - but how do I do that from a single .sql file, that my MySQL wont open? (MySQL Workbench crashes and HeidiSQL wont recognize the file.)
How do I make sure the right stuff goes into the right databases (that aren't created before running the worldserver.exe)?
Used the CLI to create a test database - just for the heck of it - and managed to import the TDB_full_world_335.60_2015_11_07.sql contents into it. Is it just a matter of the file size, and if so, where do I set it so the MySQL server can handle it through the worldserver.exe application? (Isn't that using batches for the CLI as well?) My experience with MySQL is highly limited, and I apologize for that - I hope someone can give me a pointer or two! (Or five. ^^)
Applications used:
MS Visual Studio 14 (2015) Community Ed.
Boost 1.60.0 for MSVS 14 (x86 and x64, as applicable)
MySQL 5.7.11 (tried with 5.6 as well, both x86 and x64 versions - always correctly detected in CMake)
OpenSSL 1.0.2f (x86 and x64, as applicable - detection in CMake works perfectly)
ZeroMQ 4.0.4 (x86 and x64, as applicable)
CMake 3.4.3
TrinityCore repository cloned 2016-02-19 around 1100CET, should be after commit f2ab246?
Hope someone could help me out here, and I do apologize if I may have missed the solution somewhere else in the forums!
Thanks a bunch in advance!
/Chris
UPDATE: Managed to work around the issue, by importing the SQL dump via the MySQL CLI (I used the source command to import the TDB_ file into the 'world' database). Everything seems to be running fine after that, all the updates ran perfectly, the auth and world servers fire up, and I can connect with the 3.3.5a game client.
-
By DoxramosPS
I know that the proper syntax while creating a user account in php is to run the username and password as upper and sha1
sha1("USER:PASS")
But my question is more say you want to have a way to update the password? I tried with a standard query
UPDATE accounts SET sha_pass_hash = sha1("USERNAME:NEWPASS") WHERE username = :arg
:arg is just a general username placeholder, but when I run that command. it still takes the old login information. I know you can use the console to set the password, but I'm looking at ways to run it when the server is offline, Does anyone know why this doesn't work?
-
Recommended Posts