Jump to content

Search the Community

Showing results for tags ' mysql'.



More search options

  • Search By Tags

    Type tags separated by commas.
  • Search By Author

Content Type


Categories

  • Mangos Zero
    • Enhancement Requests (Zero)
    • Tasks (Zero)
  • Mangos One
    • Enhancement Requests (One)
    • Tasks (One)
  • Mangos Two
    • Enhancement Requests (Two)
    • Tasks (Two)
  • Mangos Three
    • Enhancement Requests (Three}
    • Tasks (Three)
  • Mangos Four
    • Enhancement Requests (Four)
    • Tasks (Four)
  • Mangos Five
    • Enhancement Requests (Five)
    • Tasks (Five)
  • Cross-Core
    • Bugs
    • Enhancement Requests
    • Tasks
    • Sub-Modules
    • Eluna
    • Linux
    • Windows
  • Others
    • Mangos VB
    • Third Party Software
    • Website
  • Bug Tracker Archives
    • Archived Reports (Zero)
    • Archived Tasks (Zero)
    • Archived Reports (One)
    • Archived Tasks (One)
    • Archived Reports (Two)
    • Archived Tasks (Two)
    • Archived Reports (Three)
    • Archived Reports (Five)

Categories

  • Development Roadmap
  • Documentation
    • Installation Guides
    • Playerbot AI
    • Standards And Practices
  • Tutorials
    • Advanced
    • Contributing to Mangos
    • Debugging
  • Reference Information
    • ClientFiles
    • Database Info
    • DBC Files
    • Other
    • Packet Info
    • Server Files
    • Server Components

Forums

  • MaNGOS Information
    • Announcements & Releases
  • Community Discussion Areas
    • Introduce Yourself
    • Community Cafe
    • Community Input
    • Community Projects
    • MaNGOS University
  • Community Help and Support
    • Peer to Peer Technical Support
    • Frequently Asked Questions
    • Resources
  • Development & Patch Submissions
    • Development
    • Patch Submissions
  • Eluna LUA Engine
    • Eluna Central
  • International Help & Support
    • International Boards
  • Archived
    • Main Archives
    • Archive of Pre-2012 Forum

Product Groups

There are no results to display.

Categories

  • Mangos Zero
  • Mangos One
  • Mangos Two
  • Mangos Three
  • Addons
    • Classic Addons
  • World Of Warcraft Patches
    • WoW Patches
    • The Burning Crusade Patches
    • Wrath of the Lich King
    • Client Tools Patchers

Blogs

  • getMaNGOS
  • DBC handling for mangos
  • The Road to Zero Release 21
  • Necrovoice's development blog.
  • What the Heck happened to Antz and MaNGOS in 2018 !!

Find results in...

Find results that contain...


Date Created

  • Start

    End


Last Updated

  • Start

    End


Filter by number of...

Joined

  • Start

    End


Group


Core


Skype


Discord


Website URL


AIM


ICQ


Yahoo


Jabber


About Me


Gender


Location


Interests

Found 25 results

  1. Hey folks! For nearly 2 days straight I'm only trying to get this WoW Server running, I can't believe I get stuck at ever step. My Problem is #6 of this Tutorial Whenever I execute any of those commands I end up with this: I've already resetted my password via "sudo dpkg-reconfigure mysql-server-5.5" (yes 5.5 is my version) - But still I receive this bug. :confused: I hope you can help me further, thanks in advance! P.S. What guide is correct? This one tells me to place mmap, map, vmap & dbc into home/mangos/data (which I don't even have) This one tell me to place mmap, map, vmap & dbc into home/mangos/server
  2. Hi downloaded this bundle (MangosOne_Develop21_Release_x32_Aug2015.zip), did the tutorial on how to setup but I get an error when runing realmd.exe that says: MySQL client library: 5.6.26 MySQL server ver: 5.6.23-log MySQL client library: 5.6.26 MySQL server ver: 5.6.23-log SQL: SELECT version, structure, content, description FROM db_version ORDER BY version DESC, st query ERROR: Table 'realmd.db_version' doesn't exist The table `db_version` in your [Realmd] database is missing or corrupt. [A] You have database Version: MaNGOS can not verify your database version or its existence! You need database Version: 21 Structure: 1 Content: 0 Description: revision_refactor Please verify your database location or your database integrity. The same goes for mangosd.exe MySQL client library: 5.6.26 MySQL server ver: 5.6.23-log MySQL client library: 5.6.26 MySQL server ver: 5.6.23-log SQL: SELECT version, structure, content, description FROM db_version ORDER BY version DESC, st query ERROR: Table 'realmd.db_version' doesn't exist The table `db_version` in your [Realmd] database is missing or corrupt. [A] You have database Version: MaNGOS can not verify your database version or its existence! You need database Version: 21 Structure: 1 Content: 0 Description: revision_refactor Please verify your database location or your database integrity. I have tried diffrent DB versions of mysql 5.7.x, 5.5.37 and 5.6.23 same problem. when I connect with db tool the table is there but not accessible the structure seems to be wrong all other tables are fine (not checked all but ...). I'v tried to use "git clone --recursive h t t p://github.com/mangoszero/database.git -b develop21" , but that db is to new, realmd and mangosd halts with wrong db version/structur/content error, if I manupulate the version table so realmd and mangosd thinks this db is 21/1/0 the realmd starts and mangosd goes as far as it regognize that creatures table contains 78 collums instaed of 70 then halts. any sugestions? Regards /arne
  3. Microsoft Windows [versão 10.0.10586] © 2015 Microsoft Corporation. Todos os direitos reservados. C:\Windows\system32>cd c:/mangos c:\MANGOS>mangosd.exe 21000 [world-daemon] <Ctrl-C> to stop. __ __ _ _ ___ ___ ___ | \/ |__ _| \| |/ __|/ _ \/ __| We Love the | |\/| / _` | .` | (_ | (_) \__ \ Burning Crusade |_| |_\__,_|_|\_|\___|\___/|___/ ___ For help and support please visit: / _ \ _ _ ___ Website: getMaNGOS | The home of MaNGOS - Home | (_) | ' \/ -_) Wiki: MaNGOS Wiki * GitHub \___/|_||_\___| Using configuration file mangosd.conf. OpenSSL 1.0.2d 9 Jul 2015 (Library: OpenSSL 1.0.2d 9 Jul 2015) Using ACE: 6.3.0 World Database total connections: 2 Connected to MySQL database [email protected]:3306/mangos MySQL client library: 5.6.26 MySQL server ver: 5.6.25-log AUTOCOMMIT SUCCESSFULLY SET TO 1 Connected to MySQL database [email protected]:3306/mangos MySQL client library: 5.6.26 MySQL server ver: 5.6.25-log AUTOCOMMIT SUCCESSFULLY SET TO 1 Character Database total connections: 2 Connected to MySQL database [email protected]:3306/characters MySQL client library: 5.6.26 MySQL server ver: 5.6.25-log AUTOCOMMIT SUCCESSFULLY SET TO 1 Connected to MySQL database [email protected]:3306/characters MySQL client library: 5.6.26 MySQL server ver: 5.6.25-log AUTOCOMMIT SUCCESSFULLY SET TO 1 Login Database total connections: 2 Connected to MySQL database [email protected]:3306/realmd MySQL client library: 5.6.26 MySQL server ver: 5.6.25-log AUTOCOMMIT SUCCESSFULLY SET TO 1 Connected to MySQL database [email protected]:3306/realmd MySQL client library: 5.6.26 MySQL server ver: 5.6.25-log AUTOCOMMIT SUCCESSFULLY SET TO 1 Realm running as realm ID 1 Using World DB: Version: 21, Structure: 1, Content: 0 Using DataDir ./ WORLD: VMap support included. LineOfSight:1, getHeight:1, indoorCheck:1 WORLD: VMap data directory is: ./vmaps WORLD: MMap pathfinding enabled Please check for the existence of map file './maps/0004331.map' Correct *.map files not found in path './maps' or *.vmtree/*.vmtile files in './vmaps'. Please place *.map and vmap files in appropriate directories or correct the DataDir value in the mangosd.conf file.
  4. Reinstalling Mangos after changing over my OS a couple of times. Having trouble with updating the database, specifically the Realm database. This is my feedback: [email protected]:/home/allen/database/Realm/Updates/Rel19# mysql -u root -p mangos < 20140607_Realm_Resync.sql Enter password: ERROR 1146 (42S02) at line 1: Table 'mangos.realmd_db_version' doesn't exist No idea what it's talking about. This is my output when I try to run either realmd or mangosd: SQL: SELECT required_20150420_warden_db_log FROM realmd_db_version LIMIT 1 query ERROR: Unknown column 'required_20150420_warden_db_log' in 'field list' The table `realmd_db_version` in your [REALMD] database indicates that this database is out of date! [A] You have: --> `20150409_Playerbot_and_Warden.sql` You need: --> `20150420_warden_db_log.sql` You must apply all updates after [A] to to use mangos with this database. These updates are included in the sql/updates folder. Please read the included [README] in sql/updates for instructions on updating. And this is my output when I try and rectify the situation: [email protected]:/home/allen/database/Realm/Updates/Rel21# mysql -u root -p mangos < 20150412_01_warden_db_log.sql Enter password: Status Required Version Found Version * UPDATE SKIPPED * required_20150409_Playerbot_and_Warden NULL [email protected]:/home/allen/database/Realm/Updates/Rel21# mysql -u root -p mangos < 20150409_Playerbot_and_Warden.sql Enter password: Status Required Version Found Version * UPDATE SKIPPED * required_20140607_Realm_Resync NULL I'm not the greatest with mysql, and I know some of the guys on here have helped me get it running well before. Just wondering if I could get a hand. Thanks.
  5. I'm running Centos 7, installed everything following the centos 7 wiki tutorial but replaced mangosthree with two. Server is updated to the latest version, so is database. Realmd works, but mangosd is giving me errors. [[email protected] bin]$ ./mangosd MaNGOS Two/ (* * Revision 12578 - *) for Linux_x64 (little-endian) [world-daemon] <Ctrl-C> to stop. __ __ _ _ ___ ___ ___ | \/ |__ _| \| |/ __|/ _ \/ __| | |\/| / _` | .` | (_ | (_) \__ \ |_| |_\__,_|_|\_|\___|\___/|___/ _____ For help and support please visit: |_ _|_ __ _____ Website: https://getmangos.eu | | \ V V / _ \ Wiki: http://github.com/mangoswiki |_| \_/\_/\___/ Using configuration file /opt/mangos/etc/mangosd.conf. OpenSSL 1.0.1e 11 Feb 2013 (Library: OpenSSL 1.0.1e-fips 11 Feb 2013) Using ACE: 5.8.3 World Database total connections: 2 Connected to MySQL database [email protected]:3306/mangos MySQL client library: 10.0.24-MariaDB MySQL server ver: 10.0.24-MariaDB AUTOCOMMIT SUCCESSFULLY SET TO 1 Connected to MySQL database [email protected]:3306/mangos MySQL client library: 10.0.24-MariaDB MySQL server ver: 10.0.24-MariaDB AUTOCOMMIT SUCCESSFULLY SET TO 1 Character Database total connections: 2 Connected to MySQL database [email protected]:3306/characters MySQL client library: 10.0.24-MariaDB MySQL server ver: 10.0.24-MariaDB AUTOCOMMIT SUCCESSFULLY SET TO 1 Connected to MySQL database [email protected]:3306/characters MySQL client library: 10.0.24-MariaDB MySQL server ver: 10.0.24-MariaDB AUTOCOMMIT SUCCESSFULLY SET TO 1 SQL: SELECT required_12546_01_characters_random_battleground FROM character_db_version LIMIT 1 query ERROR: Table 'characters.character_db_version' doesn't exist SQL: SELECT * FROM character_db_version LIMIT 1 query ERROR: Table 'characters.character_db_version' doesn't exist The table `character_db_version` in your [CHARACTER] database is missing or corrupt. MaNGOS can not find the version info needed to check that the db is up to date. This revision of mangos requires a database updated to: `12546_01_characters_random_battleground.sql` Reinstall your [CHARACTER] database with the included sql file in the sql folder. So I get this. Seems like i have to apply characters.sql. Mangosd still doesnt work. I decide to run the 01_characters_random_battleground.sql update, and I get this error [[email protected] characters]# mysql -u root -p mangos < 01_characters_random_battleground.sql Enter password: ERROR 1054 (42S22) at line 1: Unknown column 'required_12487_01_characters_characters' in 'character_db_versio n' Is there something I should do/shouldn't have done? Can I fix it?
  6. CMake Error at cmake/FindMySQL.cmake:75 (message): Could not find 32-bit MySQL headers or libraries! Please install the development libraries and headers. Call Stack (most recent call first): CMakeLists.txt:116 (find_package) Any idea what the issue is? I switched between 64-bit and 32-bit mysql
  7. This is with the most recent pull from git, encountered this when setting up a new server. Had set up a server a week or two ago and databases installed fine, same configs, same OS (windows), etc. Creating Character Database character0 ERROR 1064 (42000) at line 1: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '∩╗┐ /*!40101 SET @[email protected]@CHARACTER_SET_CLIENT */' at line 1 Creating Realm Database realmd ERROR 1064 (42000) at line 1: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '∩╗┐ /*!40101 SET @[email protected]@CHARACTER_SET_CLIENT */' at line 1 The World database creates fine. As far as I can tell the syntax looks ok in the actual files. Using MySQL server 5.6, happens in Win7/10/2008R2. Did a bit of troubleshooting, MySQL 5.5, 5.6, and 5.7 give the same error, editing the database full install file in notepad and attempting to remove any possible invisible characters also did not work. Also tried manually loading the database in HeidiSQL and got the same error @ line 1. Tried in a clean VM and got the same results. Following the temp compile guide a few threads down.
  8. I'm having troubles running mangoszero on the lastest develop21 release. When I run realmd, I'm getting: 21000 [realm-daemon] <Ctrl-C> to stop. Using configuration file ../etc/realmd.conf. Login Database total connections: 2 MySQL client library: 5.6.28 MySQL server ver: 5.6.28-0ubuntu0.15.10.1 MySQL client library: 5.6.28 MySQL server ver: 5.6.28-0ubuntu0.15.10.1 The table `db_version` indicates that your [Realmd] database does not match the expected version! [A] You have database Version: 21 Structure: 1 Content: 0 Description: revision_refactor [b] You need database Version: 21 Structure: 1 Content: 2 Description: dbdocs update You are missing content updates or you have content updates beyond the expected core version. It is recommended to run ALL database updates up to the required core version. These updates are included in the database/Realmd/Updates folder. Added realm id 1, name 'MaNGOS Zero Server #1' When I run mangosd, I'm getting: 21000 [world-daemon] <Ctrl-C> to stop. __ __ _ _ ___ ___ ___ | \/ |__ _| \| |/ __|/ _ \/ __| We Love | |\/| / _` | .` | (_ | (_) \__ \ Vanilla Wow |_| |_\__,_|_|\_|\___|\___/|___/ ____ For help and support please visit: /_ /___ _ _ ___ Website: https://getmangos.eu / // -_) '_/ _ \ Forum / Wiki: https://getmangos.eu /___\___|_| \___/ Using configuration file ../etc/mangosd.conf. OpenSSL 1.0.2d 9 Jul 2015 (Library: OpenSSL 1.0.2d 9 Jul 2015) Using ACE: 6.3.0 World Database total connections: 2 Connected to MySQL database [email protected]:3306/mangos MySQL client library: 5.6.28 MySQL server ver: 5.6.28-0ubuntu0.15.10.1 AUTOCOMMIT SUCCESSFULLY SET TO 1 Connected to MySQL database [email protected]:3306/mangos MySQL client library: 5.6.28 MySQL server ver: 5.6.28-0ubuntu0.15.10.1 AUTOCOMMIT SUCCESSFULLY SET TO 1 The table `db_version` indicates that your [World] database does not match the expected structure! [A] You have database Version: 21 Structure: 1 Content: 11 Description: Fix last startup errors [b] You need database Version: 21 Structure: 3 Content: 1 Description: Fix SoR paladin You must apply all updates after [A] to [b] to use MaNGOS with this database. These updates are included in the database/World/Updates folder. The server compiled without any troubles, but when I import the SQL I'm getting errors as well. I'm running lastest Ubuntu x32, I tried the importing scripts, but didn't work, so I dropped the databases, connected remotely via my windows machine and executed "InstallDatabases.bat" from "mangos/database" repo. How can I fix this?
  9. Hi, I've previously successfully installed Zero back in 2011, and thought I would start again with the nice shiny new Zero build. I'm having some problems. I'm in Windows 10, and I am following this wiki: https://www.getmangos.eu/wiki/Installation%20Guides/Windows/Installing-MaNGOS-on-Windows.md Installing MySQL with 5.6.26, I didn't get the option to either select a standard configuration or an option to "Include Bin Directory in Windows PATH" or an option to "Enable Root Access from remote machines". These options appear to exist for an earlier version of MySQL, but the dialog boxes no longer appear. So I installed MySQL without these options. This may or may not be causing my other issues. Re enabling from remote machines, I have read the online 5.6.26 documentation (for example MySQL :: MySQL 5.6 Reference Manual :: 2.10.4 Securing the Initial MySQL Accounts) and I can see there is supposed to an option to do this during installation, but I never saw it and I redid the installation 3 times with different custom options trying to locate it. I used the installer so that could be a reason for the apparently missing options. The GitHub downloads went without a hitch, thanks for using GitHub. The next bit I am a little stuck on is: cd database/_tools make_full_db.sh mysql -u root -p mangos < full_db.sql My directory is database/Tools, the shell program is there and is 1 Kb. I have assumed I run the shell file and type in the 3rd line, which I have tried and something flashes up and disappears really fast at the bottom of my screen. Assuming that was an error message, I have also tried [ "C:\Program Files\MySQL\MySQL Server 5.6\bin\MySQL" -u root -p mangos < full_db.sql] inside the shell and nothing appears to happen. So I'm not sure if I have completed this step. Like Thoor here (https://www.getmangos.eu/general-help-amp-support/10466-bin-folder.html) I don't have a bin folder and I can't find realmd.exe. Reading the dev comment from Foereaper, I skipped that part to come back to it later, to do the compile. And here is where I get stuck again. I'm using Visual Studio 2010. I should see mangosdVC100.sln in server\win but I don't. Instead, I see (examples for VS 2010 only, so there are three sets of these solution files): BuildEverything_vc100.sln BuildTools_VC100.sln map-extractor_VC100.sln MoveMapGen_VC100.sln vmap_assemblerVC100.sln vmapExtractor_VC100.sln There is also copyfiles.cmd in the folder. There is a file called mangosd.vcxproj in the VC100 subfolder. I would appreciate any help. I love vanilla WOW (probably showing my age there!) Thanks.
  10. I'm having a issue with Mangos One characters database I think. I followed Rel+21 guide and everything worked like a charm I executed realmd.exe and mangos.exe It loads perfectly, I start WoW, enter the realm, create a character and when I hit "create character" this error shows up: Tried everything, execute characters.sql DB again, install other version of mysql and nothing works.. Need help please.
  11. It says libmysql.dll is missing from my computer. I followed all the steps in the .21 guide. The only difference i noticed is my mysql did not give me the option to 5) Tick ‘Include Bin Directory in Windows PATH’. Im using mysql-installer-community-5.6.28.0 because i noticed u guys said not to use 5.7. Im compiling with vs 2013 also. used the tool to make all the stuff for VS to compile, that went fine, compile went fine, no errors. Edited the files mangosd.conf.dist and realmd.conf.dist. I know in the tutorial it said they should be named .conf not .conf.dist so i tried em both way, same problem. I followed the mysql install exactly as mentioned in the guide except it did not have an option to include bin directory in windows path and i know most of them that i have done in the past have. What do you recommend, restart from the beginning or? BTW im using x64 version, because thats what version my sql installed on my system, it didnt give me the choice for x32 Edit: I seemed to have forgotten this step Im doing it now, i assume ill have to delete all the souce code and stuff and re run the source code making tool and then recompile? Extracting Game Data 1) Click on “My computer” 2) Navigate to the following path: C:\MangosSource\server\bin 3) Copy all the files into your ‘Warcraft’ Folder (where Launcher.exe and WOW.exe are) 4) Run 'ExtractResources.sh' and follow the onscreen prompts, you should choose the option to extract everything. 5) Once it is complete, select the DBC, Maps and VMaps folders and move them to “C:\Mangos\data” 6) The “Buildings” folder can be deleted. How long does it usually take to extract the game data? Im on a 6600k at 4.4ghz on all 4 cores. Its been runnin for 30-45min atleast so far it seems to be repeating maps, but i honestly dont know if it is or if its just doing what it should do. Ok thats finished, the programs are running and i ran 1 sql update because the command prompt said to. It says I have content 1 and i need content 2, where do i get content 2 Ok you have to run all the world updates (note not all worked and aborted but now realm is running fine) Hope this helps others having problems like me
  12. Hi guys! After some hours spending getting the vanilla server running i get this error: >> Loaded 0 mangos strings. DB table `mangos_string` is empty. Can not continue. Have i missed a sql-script? I am running on Ubuntu server 14.04? greetings thehu Edit: Ok i forgot to mention, i know why it is empty, but i cant run: (always different errors) cd /home/mangos/database bash make_full_WorldDB.sh mysql -u root -p mangos < full_db.sql like said in the wiki. ----------------------------------------------------------------------- $ ./mangosd 21000 [world-daemon] <Ctrl-C> to stop. __ __ _ _ ___ ___ ___ | \/ |__ _| \| |/ __|/ _ \/ __| We Love | |\/| / _` | .` | (_ | (_) \__ \ Vanilla Wow |_| |_\__,_|_|\_|\___|\___/|___/ ____ For help and support please visit: /_ /___ _ _ ___ Website: https://getmangos.eu / // -_) '_/ _ \ Wiki: MaNGOS Wiki · GitHub /___\___|_| \___/ Using configuration file ../etc/mangosd.conf. OpenSSL 1.0.1f 6 Jan 2014 (Library: OpenSSL 1.0.1f 6 Jan 2014) Using ACE: 6.3.0 World Database total connections: 2 Connected to MySQL database [email protected]:3306/mangos MySQL client library: 5.5.43 MySQL server ver: 5.5.43-0ubuntu0.14.04.1 AUTOCOMMIT SUCCESSFULLY SET TO 1 Connected to MySQL database [email protected]:3306/mangos MySQL client library: 5.5.43 MySQL server ver: 5.5.43-0ubuntu0.14.04.1 AUTOCOMMIT SUCCESSFULLY SET TO 1 Character Database total connections: 2 Connected to MySQL database [email protected]:3306/characters MySQL client library: 5.5.43 MySQL server ver: 5.5.43-0ubuntu0.14.04.1 AUTOCOMMIT SUCCESSFULLY SET TO 1 Connected to MySQL database [email protected]:3306/characters MySQL client library: 5.5.43 MySQL server ver: 5.5.43-0ubuntu0.14.04.1 AUTOCOMMIT SUCCESSFULLY SET TO 1 Login Database total connections: 2 Connected to MySQL database [email protected]:3306/realmd MySQL client library: 5.5.43 MySQL server ver: 5.5.43-0ubuntu0.14.04.1 AUTOCOMMIT SUCCESSFULLY SET TO 1 Connected to MySQL database [email protected]:3306/realmd MySQL client library: 5.5.43 MySQL server ver: 5.5.43-0ubuntu0.14.04.1 AUTOCOMMIT SUCCESSFULLY SET TO 1 Realm running as realm ID 1 Using World DB: MaNGOSZero Database Rev 21000_17 Using creature EventAI: No EventAI or Scripts available Using DataDir /home/mangos/data/ WORLD: VMap support included. LineOfSight:1, getHeight:1, indoorCheck:1 WORLD: VMap data directory is: /home/mangos/data/vmaps WORLD: MMap pathfinding enabled Loading MaNGOS strings... Loading texts from mangos_string [**************************************************] 100% >> Loaded 0 mangos strings. DB table `mangos_string` is empty. Can not continue.
  13. Hello, I am trying to set up a MaNGOS Zero server. I am attempting to install MaNGOS Zero on a dedicated server box in my house (only used for hosting game servers). The machine is running Windows 7 Professional Service Pack 1 and is a fresh install as of June 2015. It is running dual Intel Xeon X5570 (4 cores 8 threads x 2 (8C 16T)) and 6GB of Kingston Hyper-X DDR3 1600 CAS 9. I remote into the server using windows Remote Desktop Protocol (RDP) from another machine using the same operating system. ----------------- Installed items: MySQL: mysql-5.5.46-winx64.msi SQLyog: SQLyog-12.0.9-0.x64Community.exe Git Bash: Git-2.6.3-64-bit.exe Cmake: cmake-3.3.0-win32-x86.exe OpenSSL: Win64OpenSSL-1_0_2d.exe Visual Studio 2013 redist x64: vcredist_x64.exe (installed first, didn't work with ExtractResources.sh) Visual Studio 2013 redist x86: vcredist_x86.exe (worked) Microsoft Visual Studio 2012 Express ----------------- I had a few problems I fixed during setup that I will detail below just in case someone else has the same problems: My MySQL install kept breaking and causing me to reinstall the application every restart. This was a simple problem caused by my desire to clean up the database. I was deleting the default data entries "performance_schema", "mysql" and "test". Deleting these files broke my install I stopped doing that after breaking it 2-3 times. "test" can be deleted without issue as far as I can tell. Those did not exist in a database from an older server I have running on my laptop so I thought I could delete them. Lesson learned. I could not get the ExtractResources.sh to work saying something about the other files erroring. I tried to run each sub file that it called. It would error out with somethingsomething 120.dll. After searching this DLL I discovered it was part of Visual Studio 2013 redist. However, I had already installed that and wondered why it wasn't working. I installed the 64bit version at first and then tried the 32bit version. The 32bit version worked. For whatever reason, after getting the ExtractResources.sh to run, it would blast through everything instantly stating it was finished. It created the correct folders, but they were empty. I don't remember how I fixed this, but I got it to run reliably and it spent many minutes extracting the files. It created about 2GB of output data. After all that, I was ready to run the server after compiling the server (more on this later). I ran realmd.exe and it gave me an error "libmysql.dll" missing or something. I was sure that mysql is installed and I can see the database in SQLyog. Googling came up with the answer of just copying that dll from my MySQL install folder to my windows folder would fix it. I copied it and it seemed to have worked. ----------------- Now, on to my current problem. Whenever I try to run mangosd.exe or realmd.exe, it will close instantly and I don't see an error log anywhere. Without an error log, I cant even begin to figure out the problem. I tried the files server files from MangosZero_PlayerBot_Develop21_Release_x32_August2015 and my own compiled server files from the repository (I even compiled twice into two different folders). All three attempts give the same issue of insta-crash with no logs.I would rather not have to re-install everything and start from scratch on x86. I used MaNGOS_EasyBuild.exe v1.5 I build it using "Rebuild Solution" in Visual Studio Express 2012. Here are images of what I see and what I selected before building: [ATTACH=CONFIG]268[/ATTACH] [ATTACH=CONFIG]269[/ATTACH] I copy the files from the bin/debug folder to my server install folder. I find it weird that it is in the "debug" mode when I selected "release" in EasyBuild with no "release" folder (not even an empty one). That is where I am at so far. If you have any more questions or answers for me, please let me know!
  14. Hallo, da mir doch die deutsche Sprache etwas mehr liegt als die Englische habe ich beschlossen hier zu fragen anstatt das DB-Subforum zu verwenden. Mein Vorhaben ist ein kleines Theorycrafting-Portal für meine Gilde und mich. Foglich brauche ich keinen Gameserver sondern nur eine Datenbank mit Items, Fähigkeiten und Assoziationen. Ich habe ein ARM-Board mit einem Debianderivat als Betriebssystem. Dieser Rechner hostet einen MySQL-Datenbank-Server mit einer MangosZero-DB. Zumindest hoffe ich das Die Struktur der Datenbank habe ich mir über folgende Commands auf der Shell generieren lassen. Das steht soweit auch in folgendem Guide: https://www.getmangos.eu/wiki.php cd /home/mangos/server/sql mysql -u root -p < create_mysql.sql mysql -u root -p realmd < realmd.sql mysql -u root -p characters < characters.sql mysql -u root -p mangos < mangos.sql Da die Datenbank dannach noch recht leer ist habe ich alle Files aus dem Zweiten von Git heruntergladenen Verzeichnis in die Datenbank übertragen. Hierfür verwendete ich ein PHP-Script, welches alle Files einliest und im Anschluss alle Querys der einzelnen Files mit dem oben bereits genannten Befehl in die Datenbank ausführt. Das Script sieht so aus: <?php $database="mangos"; // Database in which you want to include your files $user="root"; // Username of your DB-User $password="0000"; // Password of your DB-User $path="/opt/mangos/zero/database/_full_db/"; // Path of your .SQL-Files, which you want to include into a SQL-Database $command='mysql -u ' .$user .' --password="' .$password .'" ' .$database .' < ' .$path; $files=scandir($path); echo $files[1]; $array_size=count($files); for($i=2;$i<$array_size;$i++) { // start at 2 because of [0]=. and [1]=.. [2] is your 1st file $currentfile=$command .$files[$i]; echo "i=$i of $array_size exec($currentfile); "; exec($currentfile); } ?> Mein Problem ist nur, dass ich mit dem Aufbau der Datenbank Probleme habe, da es kaum bis keine Kommentare gibt und ich somit die Fremdschlüssel nicht so ganz eindeutig identifizieren kann. Konkret fehlt mir bspw. die ganzen Texte, der Items wie bspw bei Thunderfurry Trefferchance: Deckt Euren Gegner mit Blitzschlägen ein, die 300 Naturschaden verursachen und zu in der Nähe befindlichen Feinden weiterspringen. Jeder Sprung verringert den Naturwiderstand des Ziels um 25. Wirkt auf insgesamt Ziele. Euer Hauptziel wird außerdem von einem Wirbelsturm umgeben, welcher dessen Angriffstempo 10 Sek. lang um 20% verringert. edit: Folgende Site zum Aufbau der Datenbank habe ich gefunden aber die gesuchten Informationen konnte ich bis dato nicht herauslesen. https://github.com/cmangos/issues/wiki/mangosdb_struct Gruß luziel
  15. hi im trying to make a mongos zero server but i get error on Cmake its normal for me i allways get that.... http://puu.sh/jdsuT/02e4192067.png i have dnowled the *FULL version on MySQL and all other program i use VS2010 ultimate, but i can't even cmake the thing. i have open SSl 32 and 64 bits. idk know whats wrong thats what is so irirtatiing but well im not 100% on what you need i come for like a fresh install of windows.
  16. so i atempted to update the db after it complained its the qrong version and I get this 2015-05-30 00:49:57 20000 [world-daemon] 2015-05-30 00:49:57 <Ctrl-C> to stop. __ __ _ _ ___ ___ ___ | \/ |__ _| \| |/ __|/ _ \/ __| Wrath of the | |\/| / _` | .` | (_ | (_) \__ \ Lich King |_| |_\__,_|_|\_|\___|\___/|___/ _____ For help and support please visit: |_ _|_ __ _____ Website: https://getmangos.eu | | \ V V / _ \ Wiki: MaNGOS Wiki · GitHub |_| \_/\_/\___/ 2015-05-30 00:49:57 Using configuration file mangosd.conf. 2015-05-30 00:49:57 World Database total connections: 2 2015-05-30 00:49:57 MySQL client library: 5.6.24 2015-05-30 00:49:57 MySQL server ver: 5.6.24-log 2015-05-30 00:49:57 MySQL client library: 5.6.24 2015-05-30 00:49:57 MySQL server ver: 5.6.24-log 2015-05-30 00:49:57 ERROR:SQL: SELECT required_21000_01_Release21_initial FROM db_version LIMIT 1 2015-05-30 00:49:57 ERROR:query ERROR: Unknown column 'required_21000_01_Release21_initial' in 'field list' 2015-05-30 00:49:57 ERROR:The table `db_version` in your [WORLD] database indicates that this database is out of date! 2015-05-30 00:49:57 ERROR: 2015-05-30 00:49:57 ERROR: [A] You have: --> `21000_02_warden_checks.sql` 2015-05-30 00:49:57 ERROR: 2015-05-30 00:49:57 ERROR: You need: --> `21000_01_Release21_initial.sql` 2015-05-30 00:49:57 ERROR: 2015-05-30 00:49:57 ERROR:You must apply all updates after [A] to to use mangos with this database. 2015-05-30 00:49:57 ERROR:These updates are included in the sql/updates folder. 2015-05-30 00:49:57 ERROR:Please read the included [README] in sql/updates for instructions on updating. so it got me scratching my head, wy is it asking for a previous version, and if i redo it all and only go up to 21000_01 it wants the 02 witch is kinda screwed up Edit, would like to point out that I have downloaded the right repo and done everything nessery for it to work if, redo doing the db and doing one version lower yields a similar result only requesting the previous version before it as well
  17. Hi guys, I'm posting here because i'm not far from becoming crazy... It's been 3 days that i'm tring to build my server, and i'm stuck on this error ! I begun with a simple debian (wheezy 7.7) virtual machine (which i cloned once it was clean) to run my tests, and after i was right into the thing, that i compiled the server successfully, and checked everythink, I tried to run it all i've got is a beautifull segfault error at the begining of mangosd loading... But it's okay, i'm not giving up ! So i did a lot of research but nothing. The few results i've got are german, and all i understand in german is "ich habe nicht verstanden", which mean "i didn't understand" so it didn't help me so mutch. I also found a recent topic on zero but it was a rev problem, the guy took the 20 and it was solved, but i have been carefull and took the github so my sources are up to date. i thought i did something wrong, so i started it all over again and redownload all (i had some libraries problem with libmpq and ACE so i wanted to be sure) Exactly the same problem after compiling my core. So i started it all over again, on my physic server, the host of my VMs. Exactly the same problem again... the worse is that i could build game tools to extract map and vmap, and i ran it sucessfully... MaNGOS One/ (* * Revision 2057 - *) for Linux_x64 (little-endian) [world-daemon] <Ctrl-C> to stop. __ __ _ _ ___ ___ ___ | \/ |__ _| \| |/ __|/ _ \/ __| | |\/| / _` | .` | (_ | (_) \__ \ |_| |_\__,_|_|\_|\___|\___/|___/ ___ Visit our website for support: / _ \ _ _ ___ http: //getmangos.eu/ | (_) | ' \/ -_) \___/|_||_\___| We love t he Burning Crusade Using configuration file /home/mangos/servers/etc/mangosd.conf. OpenSSL 1.0.1e 11 Feb 2013 (Library: OpenSSL 1.0.1e 11 Feb 2013) Using ACE: 6.0.3 World Database total connections: 2 Connected to MySQL database [email protected]:3306/mangos MySQL client library: 5.5.40 MySQL server ver: 5.5.40-0+wheezy1 AUTOCOMMIT SUCCESSFULLY SET TO 1 Connected to MySQL database [email protected]:3306/mangos MySQL client library: 5.5.40 MySQL server ver: 5.5.40-0+wheezy1 AUTOCOMMIT SUCCESSFULLY SET TO 1 Character Database total connections: 2 Connected to MySQL database [email protected]:3306/characters MySQL client library: 5.5.40 MySQL server ver: 5.5.40-0+wheezy1 AUTOCOMMIT SUCCESSFULLY SET TO 1 Connected to MySQL database [email protected]:3306/characters MySQL client library: 5.5.40 MySQL server ver: 5.5.40-0+wheezy1 AUTOCOMMIT SUCCESSFULLY SET TO 1 Login Database total connections: 2 Connected to MySQL database [email protected]:3306/realmd MySQL client library: 5.5.40 MySQL server ver: 5.5.40-0+wheezy1 AUTOCOMMIT SUCCESSFULLY SET TO 1 Connected to MySQL database [email protected]:3306/realmd MySQL client library: 5.5.40 MySQL server ver: 5.5.40-0+wheezy1 AUTOCOMMIT SUCCESSFULLY SET TO 1 Realm running as realm ID 1 Using World DB: OneDatabase 1.0.0 for MaNGOSOne s1881+ and ScriptDevOne s2670+ Using creature EventAI: MaNGOSOne Artificial Creature Intelligence Database Using DataDir ./data/ WORLD: VMap support included. LineOfSight:0, getHeight:1, indoorCheck:1 WORLD: VMap data directory is: ./data/vmaps WORLD: mmap pathfinding disabled Loading MaNGOS strings... Loading texts from mangos_string [>> Loaded 845 MaNGOS strings from table mangos_string00% Initialize data stores... [[color=#ff0000]Erreur de segmentation[/color]*************** ] 74% [email protected]:/home/mangos/servers/bin# [color=#ff0000]Erreur de segmentation = segmentation fault[/color] [email protected]:/home/mangos/servers/bin# tail -5 /var/log/syslog Jan 9 16:34:01 /USR/SBIN/CRON[27757]: (root) CMD (/usr/local/rtm/bin/rtm 56 > /dev/null 2> /dev/null) Jan 9 16:35:01 /USR/SBIN/CRON[27836]: (root) CMD (/usr/local/rtm/bin/rtm 56 > /dev/null 2> /dev/null) Jan 9 16:36:01 /USR/SBIN/CRON[27914]: (root) CMD (/usr/local/rtm/bin/rtm 56 > /dev/null 2> dev/null) Jan 9 16:37:01 Aceyna /USR/SBIN/CRON[27992]: (root) CMD (/usr/local/rtm/bin/rtm 56 > /dev/null 2> /dev/null) Jan 9 16:37:11 kernel: [2922506.133593] mangosd[28036]: segfault at 0 ip 0000000000589ca8 sp 00007fff026994e0 error 6 in mangosd[400000+796000] I really spend time on research, and i don't know why i think i made a big mistake but i can't find when and where.... I use external ACE library, 6.0.3 from apt sources Here is the output of my compilation atached to the post. [ATTACH]171[/ATTACH] Please help me guys ! and don't hesitate to insult me if did something wrong other post : https://www.getmangos.eu/general-help-amp-support/10221-segfault-scripts.html Compiling.txt
  18. hi i just extracted the map files but then i start the server it says this: i know the dc is right and i extracted the maps by myself and i also tryed downlod one. 2015-02-03 16:18:28 20000 [world-daemon] 2015-02-03 16:18:28 <Ctrl-C> to stop. __ __ _ _ ___ ___ ___ | \/ |__ _| \| |/ __|/ _ \/ __| Wrath of the | |\/| / _` | .` | (_ | (_) \__ \ Lich King |_| |_\__,_|_|\_|\___|\___/|___/ _____ For help and support please visit: |_ _|_ __ _____ Website: https://getmangos.eu | | \ V V / _ \ Wiki: MaNGOS Wiki · GitHub |_| \_/\_/\___/ 2015-02-03 16:18:28 Using configuration file mangosd.conf. 2015-02-03 16:18:28 World Database total connections: 2 2015-02-03 16:18:29 MySQL client library: 5.5.37 2015-02-03 16:18:29 MySQL server ver: 5.6.22-log 2015-02-03 16:18:29 MySQL client library: 5.5.37 2015-02-03 16:18:29 MySQL server ver: 5.6.22-log 2015-02-03 16:18:29 Character Database total connections: 2 2015-02-03 16:18:29 MySQL client library: 5.5.37 2015-02-03 16:18:29 MySQL server ver: 5.6.22-log 2015-02-03 16:18:29 MySQL client library: 5.5.37 2015-02-03 16:18:29 MySQL server ver: 5.6.22-log 2015-02-03 16:18:29 Login Database total connections: 2 2015-02-03 16:18:29 MySQL client library: 5.5.37 2015-02-03 16:18:29 MySQL server ver: 5.6.22-log 2015-02-03 16:18:29 MySQL client library: 5.5.37 2015-02-03 16:18:29 MySQL server ver: 5.6.22-log 2015-02-03 16:18:29 Realm running as realm ID 3 2015-02-03 16:18:29 Using World DB: UDB 0.12.2 (407) for CMaNGOS 12735 with SD2 SQL for rev. 3041 2015-02-03 16:18:29 Using creature EventAI: ACID 3.3.5a (Wrath of the Lich King) for CMaNGOS-WOTLK (3.3.5a Client) 2015-02-03 16:18:29 Using DataDir ./maps/ 2015-02-03 16:18:29 WORLD: VMap support included. LineOfSight:1, getHeight:1, indoorCheck:1 2015-02-03 16:18:29 WORLD: VMap data directory is: ./maps/vmaps 2015-02-03 16:18:29 WORLD: mmap pathfinding enabled 2015-02-03 16:18:29 ERROR:VMap file './maps/vmaps/000.vmtree' is missing or point to wrong version vmap file, redo vmaps with latest vmap_assembler.exe program 2015-02-03 16:18:29 ERROR:Correct *.map files not found in path './maps/maps' or *.vmtree/*.vmtile files in './maps/vmaps'. Please place *.map and vmap files in appropriate directories or correct the DataDir value in the mangosd.conf file.
  19. The OS on which it occurred is windows and the branch which was used for the source is Rel20_Newbuild. I extracted all maps with ExtractResources.sh using Git Bash. Every configuration regarding the .conf file seems to be correct. The error itself is weird due to the fact it's regarding the specific 0004331.map (131 KB in size) and there are many maps before that one, meaning it's possible the file itself got corrupted upon extraction or something. Anyone has a working 0004331.map for windows OS? That would answer a lot of questions. Thanks in advance!
  20. just for the record i would like to clarify what SQL server MaNGOS supports. im building a new installation from scratch for a tutorial im writing and i would like to know if MaNGOS supports the MariaDB as this is written by the same guy that did MySQL i would think it does as the software base is practically the same, however the history of MySQL and MariaDB is pretty thick. i will continue to build my test environment in hopes that it does support the different back-end if any one has an answer id still love to hear it. I will post my findings when i figure it out
  21. What is this segmentation fault error? After loading c++ scripts mangosd stops loading
  22. Hallo, ich habe versucht die o.g. Mangos Version zu installieren, leider bekomme ich beim realm deamon einen fehler beim starten. 19000 [realm-daemon] <Ctrl-C> to stop. Using configuration file realmd.conf. Login Database total connections: 2 MySQL client library: 5.5.37 MySQL server ver: 5.1.72-community MySQL client library: 5.5.37 MySQL server ver: 5.1.72-community SQL: SELECT required_20140607_Realm_Resync FROM realmd_db_version LIMIT 1 query ERROR: Table 'man_realmd.realmd_db_version' doesn't exist SQL: SELECT * FROM realmd_db_version LIMIT 1 query ERROR: Table 'man_realmd.realmd_db_version' doesn't exist The table `realmd_db_version` in your [REALMD] database is missing or corrupt. MaNGOS can not find the version info needed to check that the db is up to date. This revision of mangos requires a database updated to: `20140607_Realm_Resync.sql` Reinstall your [REALMD] database with the included sql file in the sql folder. Wo finde ich die datenbanken für realmd, characters und scripts? Ich habe nochmal alles durchgelesen und nichts gefunden. :confused: Mit freundlichen Grüßen. PS: einen Ordner namens SQL gibt es nicht.
  23. I am using the precompiled mangos one server. I am running debian sid 64bit. # mysql --version mysql Ver 14.14 Distrib 5.5.39, for debian-linux-gnu (x86_64) using readline 6.3 https://www.getmangos.eu/mangos/file-554-mangos-server-0-18-0-rev2057-x32-september-2014-a-mangosone_2057_x32_sept2014-zip&v=39589924528516.63 I am setting up the databases using phpmyadmin and got an error importing mangos_full_db.sql. I got past needing to change limits in my php.ini file and seemingly successfully did the import, but I am getting the following error: ---- MySQL said: Documentation #1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SET @[email protected]@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_CO' at line 21 ---- Of course I would like to get some direction on how to fix this, or know how important it is. I am not well versed in sql databases, though I can learn. I am wondering if I should just be using a different version of mysql? I can set up a completely independent machine on which to do it if I need.
  24. Hi, can someone please help me, i am trying to get server running, i have one server running and that te server zero 1.12.1 but that has grouploot problems i want to multibox with 5 chars but i cant do quests because i cant loot with any of my chars........ive read that these problems were solved were can i find these?......... so now im trying to install mangos server one but i get this error .............. 2014-11-04 00:07:20 MaNGOS One/0.19.0 (* * Revision 19004 - *) for Win32 (little-endian) [world-daemon] 2014-11-04 00:07:20 <Ctrl-C> to stop. __ __ _ _ ___ ___ ___ | \/ |__ _| \| |/ __|/ _ \/ __| We Love the | |\/| / _` | .` | (_ | (_) \__ \ Burning Crusade |_| |_\__,_|_|\_|\___|\___/|___/ ___ For help and support please visit: / _ \ _ _ ___ Website: https://getmangos.eu | (_) | ' \/ -_) Wiki: MaNGOS Wiki · GitHub \___/|_||_\___| 2014-11-04 00:07:20 Using configuration file mangosd.conf. 2014-11-04 00:07:20 World Database total connections: 2 2014-11-04 00:07:20 MySQL client library: 5.5.37 2014-11-04 00:07:20 MySQL server ver: 5.0.27-community 2014-11-04 00:07:20 MySQL client library: 5.5.37 2014-11-04 00:07:20 MySQL server ver: 5.0.27-community 2014-11-04 00:07:20 ERROR:SQL: SELECT required_19004_creature_template_power FROM db_version LIMIT 1 2014-11-04 00:07:20 ERROR:query ERROR: Unknown column 'required_19004_creature_template_power' in 'field list' whats the problem here?................. and another question........ why doesnt anyone make an installer, would make installing allot better........... but i also want to say ur doing great work, sever works better then when i was using one of the first servers in 2008 or can someone upload a working server zero or one were the grouploot works thanx Marcel
  25. Hi, can someone please help me, i am trying to get server running, i have one server running and that te server zero 1.12.1 but that has grouploot problems i want to multibox with 5 chars but i cant do quests because i cant loot with any of my chars........ive read that these problems were solved were can i find these?......... so now im trying to install mangos server one but i get this error .............. 2014-11-04 00:07:20 MaNGOS One/0.19.0 (* * Revision 19004 - *) for Win32 (little-endian) [world-daemon] 2014-11-04 00:07:20 <Ctrl-C> to stop. __ __ _ _ ___ ___ ___ | \/ |__ _| \| |/ __|/ _ \/ __| We Love the | |\/| / _` | .` | (_ | (_) \__ \ Burning Crusade |_| |_\__,_|_|\_|\___|\___/|___/ ___ For help and support please visit: / _ \ _ _ ___ Website: https://getmangos.eu | (_) | ' \/ -_) Wiki: MaNGOS Wiki · GitHub \___/|_||_\___| 2014-11-04 00:07:20 Using configuration file mangosd.conf. 2014-11-04 00:07:20 World Database total connections: 2 2014-11-04 00:07:20 MySQL client library: 5.5.37 2014-11-04 00:07:20 MySQL server ver: 5.0.27-community 2014-11-04 00:07:20 MySQL client library: 5.5.37 2014-11-04 00:07:20 MySQL server ver: 5.0.27-community 2014-11-04 00:07:20 ERROR:SQL: SELECT required_19004_creature_template_power FROM db_version LIMIT 1 2014-11-04 00:07:20 ERROR:query ERROR: Unknown column 'required_19004_creature_template_power' in 'field list' whats the problem here?................. and another question........ why doesnt anyone make an installer, would make installing allot better........... but i also want to say ur doing great work, sever works better then when i was using one of the first servers in 2008 or can someone upload a working server zero or one were the grouploot works thanx Marcel

Contact Us

To contact us click here
You can also email us at [email protected]

Privacy Policy | Terms & Conditions

Repositories

The Link to the master list
of MaNGOS repositories:
Copyright © getMaNGOS. All rights Reserved.

This website is in no way associated with or endorsed by Blizzard Entertainment®
×
×
  • Create New...