Jump to content
TrinityCore

Recommended Posts


If you want to keep your databases, a lot.

 

Are you serious? I had a Hell of a time upgrading my MySQL DB on Linux. On my Windows box, I did it in 3 steps, no data loss.

 


no, i am a complete retard when it comes to this stuff

 

Well Murk425, since a developer isn't willing to help you or at least point you in the right direction.

The best thing to do is backup the DB first. Upgrading it on Windows is pretty straight forward, just be sure to use the same password and root user, if you change it during the upgrade process you will have problems.

 

Windows

1. Backup your DB first.

2. Shutdown MySQL service (if running)

3. Upgrade your Windows MySQL

4. Import the data (SQLs) back in.

 

Note:

For any Linux users out there struggling, I created a Repo because of the nightmare I had to go through... that will get any version of MySQL you have to 5.5+ using Remi.

Same basic steps by backing up the DB, upgrade, than "source"ing the data back in. PM me if you need assistance, its a very long tutorial.

Link to comment
Share on other sites

OpenSSL 1.0.1e 11 Feb 2013
ACE-6.2.0 comile from port FreeBSD 9.1
Lates git TrinityCore
 
# cmake ../ -DPREFIX=/home/wow/server  -DCMAKE_CXX_COMPILER=g++49 -DCMAKE_C_COMPILER=gcc49
 
-- The C compiler identification is GNU 4.9.0
-- The CXX compiler identification is GNU 4.9.0
-- Check for working C compiler: /usr/local/bin/gcc49
-- Check for working C compiler: /usr/local/bin/gcc49 -- works
-- Detecting C compiler ABI info
-- Detecting C compiler ABI info - done
-- Check for working CXX compiler: /usr/local/bin/g++49
-- Check for working CXX compiler: /usr/local/bin/g++49 -- works
-- Detecting CXX compiler ABI info
-- Detecting CXX compiler ABI info - done
-- Detected 64-bit platform
-- UNIX: Using default configuration directory
-- UNIX: Using default library directory
-- UNIX: Configuring uninstall target
-- UNIX: Created uninstall target
-- UNIX: Detected compiler: /usr/local/bin/gcc49
-- GCC: SFMT enabled, SSE2 flags forced
-- Found ACE library: /usr/local/lib/libACE.so
-- Found ACE headers: /usr/local/include
-- Found OpenSSL library: /usr/local/lib/libssl.so;/usr/local/lib/libcrypto.so
-- Found OpenSSL headers: /usr/local/include
-- Looking for include file pthread.h
-- Looking for include file pthread.h - found
-- Looking for pthread_create
-- Looking for pthread_create - not found
-- Looking for pthread_create in pthreads
-- Looking for pthread_create in pthreads - not found
-- Looking for pthread_create in pthread
-- Looking for pthread_create in pthread - found
-- Found Threads: TRUE  
-- Using mysql-config: /usr/local/bin/mysql_config
-- Found MySQL library: /usr/local/lib/mysql/libmysqlclient_r.so
-- Found MySQL headers: /usr/local/include/mysql
-- Found Readline library: /usr/lib/libreadline.so
-- Include dir is: /usr/include
-- Found ZLIB: /usr/lib/libz.so (found version "1.2.7") 
-- Found BZip2: /usr/lib/libbz2.so (found version "1.0.6") 
-- Looking for BZ2_bzCompressInit in /usr/lib/libbz2.so
-- Looking for BZ2_bzCompressInit in /usr/lib/libbz2.so - found
-- Found git binary : /usr/local/bin/git
 
* TrinityCore revision   : 1501e958767a+ 2013-08-31 00:03:35 +0200 (master branch)
* TrinityCore buildtype  : Release
 
* Install core to        : /home/wow/server
* Install libraries to   : /home/wow/server/lib
* Install configs to     : /home/wow/server/etc
 
* Build world/auth       : Yes (default)
* Build with scripts     : Yes (default)
* Build map/vmap tools   : No  (default)
* Build core w/PCH       : Yes (default)
* Build scripts w/PCH    : Yes (default)
* Show compile-warnings  : No  (default)
* Use coreside debug     : No  (default)
* Use GIT revision hash  : Yes
 
-- SCRIPT PREPARATIONS
  -> Prepared: Spells
  -> Prepared: Commands
  -> Prepared: Examples
  -> Prepared: Custom
  -> Prepared: World
  -> Prepared: Outdoor PVP Zones
  -> Prepared: Eastern Kingdoms
  -> Prepared: Kalimdor
  -> Prepared: Outland
  -> Prepared: Northrend
  -> Prepared: Events
  -> Prepared: Pet
-- SCRIPT PREPARATION COMPLETE
 
-- Configuring done
-- Generating done
-- Build files have been written to: /root/TrinityCore/build
 
# make
 
Scanning dependencies of target shared
[  7%] Building CXX object src/server/shared/CMakeFiles/shared.dir/Configuration/Config.cpp.o
[  7%] Building CXX object src/server/shared/CMakeFiles/shared.dir/Cryptography/ARC4.cpp.o
[  7%] Building CXX object src/server/shared/CMakeFiles/shared.dir/Cryptography/HMACSHA1.cpp.o
[  7%] Building CXX object src/server/shared/CMakeFiles/shared.dir/Cryptography/SHA1.cpp.o
[  7%] Building CXX object src/server/shared/CMakeFiles/shared.dir/Cryptography/OpenSSLCrypto.cpp.o
/root/TrinityCore/src/server/shared/Cryptography/OpenSSLCrypto.cpp: In function 'void threadIdCallback(CRYPTO_THREADID*)':
/root/TrinityCore/src/server/shared/Cryptography/OpenSSLCrypto.cpp:36:54: error: invalid conversion from 'ACE_thread_t {aka pthread*}' to 'long unsigned int' [-fpermissive]
     CRYPTO_THREADID_set_numeric(id, ACE_Thread::self());
                                                      ^
In file included from /root/TrinityCore/src/server/shared/Cryptography/OpenSSLCrypto.cpp:19:0:
/usr/local/include/openssl/crypto.h:435:6: note: initializing argument 2 of 'void CRYPTO_THREADID_set_numeric(CRYPTO_THREADID*, long unsigned int)'
 void CRYPTO_THREADID_set_numeric(CRYPTO_THREADID *id, unsigned long val);
      ^
*** [src/server/shared/CMakeFiles/shared.dir/Cryptography/OpenSSLCrypto.cpp.o] Error code 1
 
Stop in /root/TrinityCore/build.
*** [src/server/shared/CMakeFiles/shared.dir/all] Error code 1
 
Stop in /root/TrinityCore/build.
*** [all] Error code 1
 
Stop in /root/TrinityCore/build.
 
Link to comment
Share on other sites

it's funny because you haven't been doing this long enough to realize that he either used a very old repack before, and continued to use the mysql that came with it when he decided to try a newer repack or self compile, or, what I meant was, like a repack user, he didn't properly follow the guide, or he would have known not to use an old mysql.

Link to comment
Share on other sites

it's funny because you haven't been doing this long enough to realize that he either used a very old repack before, and continued to use the mysql that came with it when he decided to try a newer repack or self compile, or, what I meant was, like a repack user, he didn't properly follow the guide, or he would have known not to use an old mysql.

Doing this long enough..?? doing what long enough? helping retards with retarded questions? ha-ha, that's a good one, I've been helping people since 2011 @ ac gay and trust me , most of the people there ask the same kind of questions just like this one, even worse.

He could've just installed a low version of MySQL, you could be right, I could be aswell.

Link to comment
Share on other sites

Let's stick to the facts here. OP is oblivious on how to proceed in order to get his server working because he either a) doesn't understand a word of English and could not understand the error message in the console even if his life depended on it, or b.) is too ignorant or uninitiating to consult MySQL package instructions or google for upgrade directions. These possible causes may have deeper rooted issues such as clinical retardism, lazy parenting or, indeed, sir was an avid repack user in the past. Please convince me why the fuck we should judge and not deal with the facts at face value - ignorance is bliss. This is a learning project after all, and we should not deprive one of the chance of learning because of his alledged past. If you feel the need to bash someone, fine. But base your conclusions on facts for which you have probable cause, and keep your witchhunt theories to yourself. 

 

Paradox has been here since TC was founded.

 

You know what's been here even before that? Cancer. I guess we should defend and worship cancer too.

 

Paradox, you need to stop getting your panties up in a bunch. They're soaking wet from menstrual blood and they're leaving a rotten stench within the community.

  • Upvote 3
Link to comment
Share on other sites

Let's stick to the facts here. OP is oblivious on how to proceed in order to get his server working because he either a) doesn't understand a word of English and could not understand the error message in the console even if his life depended on it, or b.) is too ignorant or uninitiating to consult MySQL package instructions or google for upgrade directions. These possible causes may have deeper rooted issues such as clinical retardism, lazy parenting or, indeed, sir was an avid repack user in the past. Please convince me why the fuck we should judge and not deal with the facts at face value - ignorance is bliss. This is a learning project after all, and we should not deprive one of the chance of learning because of his alledged past. If you feel the need to bash someone, fine. But base your conclusions on facts for which you have probable cause, and keep your witchhunt theories to yourself. 

 

 

You know what's been here even before that? Cancer. I guess we should defend and worship cancer too.

 

Paradox, you need to stop getting your panties up in a bunch. They're soaking wet from menstrual blood and they're leaving a rotten stench within the community.

 

sadly the best post in this topic

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

 Share

  • Recently Browsing   0 members

    No registered users viewing this page.


  • Similar Content

    • By xgamerninjax
      Hello all, first time posting here and it's really got me scratching my head.
      I've compiled everything on my own computer, and then transferred everything to a host computer so the server can stay live. The server was running fine for a month or so and then suddenly it just crashes when it hits "Loading C++ scripts", exiting saying "caught signal 22"
      I tried setting up the host computer from scratch and transferred everything over fresh and it's still happening for some reason. (Note, I can run the server perfectly on my personal pc where I compiled it.)
      Any help would be greatly appreciated, thanks!
      3d7e3a40e2b3+_worldserver.exe_[1-4_15-19-45].dmp 3d7e3a40e2b3+_worldserver.exe_[1-4_15-19-45].txt
    • By Deer_Hunter
      Hello all,
      I just updated from the latest Git 
      Trinity Core REV. ac6baa547376 + 2020-02-21  3.3.5 Branch.
      I'm getting this error after crash.
      Problem signature:
        Problem Event Name:    APPCRASH
        Application Name:    worldserver.exe
        Application Version:    0.0.0.0
        Application Timestamp:    5e50a462
        Fault Module Name:    StackHash_f12f
        Fault Module Version:    6.3.9600.19629
        Fault Module Timestamp:    5e2fdc0d
        Exception Code:    c0000374
        Exception Offset:    PCH_9E_FROM_ntdll+0x0000000000090D0A
        OS Version:    6.3.9600.2.0.0.272.7
        Locale ID:    1033
        Additional Information 1:    f12f
        Additional Information 2:    f12f0934d3e965f73c68e60f20f2cd40
        Additional Information 3:    7595
        Additional Information 4:    7595e4d8d703db9dcd3d2f6ea540e357
      the exception code says its a Heap error,  I'm not sure how to troubleshoot this.
      Thanks
    • By 939h
      Hi,

      The chat channel Lookup for group is not available when a player isn't in a city. I tried to modify the worldserver.conf file with:
      #
      #    Channel.RestrictedLfg
      #        Description: Restrict LookupForGroup channel to characters registered in the LFG tool.
      #        Default:     1 - (Enabled, Allow join to channel only if registered in LFG)
      #                     0 - (Disabled, Allow join to channel in any time)
      Channel.RestrictedLfg = 0

      I restarted the server but it didn't help.

      Thanks
    • By meeek
      Hey, I've been trying to compile from github the core from 6.2.3/6.2.4, I'm well aware its stopped developing. I cannot get it to configure properly in CMake, nor can I obviously build it.
       
      I'd be willing to pay for help and get this working and running. I want to develop my own server on my freetime as a learning project and for entertainment. I can't find any core for WoD, sadly.. Very hard, would appreciate any quick help
       
    • By Probie_Wan_Kenobi
      I believe everything I have done up to this point has been correct. When I go to launch worldserver.exe a console window opens up for a second and closes right away and nothing else seems to have happened. I skipped a head a little in the instructions to see what is left and step 5 seems skippable since I am running this only for this computer and step 6 has me launch to a log in screen which I can not get to. I tried going to the faq but the page was not loading properly so I am forced to post here.
×
×
  • Create New...