Jump to content
TrinityCore

TechnicDragon

Plebs
  • Posts

    3
  • Joined

  • Last visited

TechnicDragon's Achievements

Newbie

Newbie (1/14)

0

Reputation

  1. Okay, got MySQL completely uninstalled and then reinstalled again. No errors. I have the user and password I made during the install. HeidiSQL finds the database and opens it. However, what I get does not include Auth, Characters, World, or Hotfixes. Here is what I get when I open HeidiSQL: I've gone through the instructions several times. There is nothing in there about either creating a database or adding the Loads that I downloaded for the database. oh, and when I try to run bnetserver.exe, this shows up in the log: TrinityCore rev. 3fceabfa1139 2015-09-29 00:11:26 +0200 (6.x branch) (Win32, Release) (bnetserver) <Ctrl-C> to stop. Using configuration file bnetserver.conf. Using SSL version: OpenSSL 1.0.2d 9 Jul 2015 (library: OpenSSL 1.0.2d 9 Jul 2015) Using Boost version: 1.59.0 Automatic database updates are disabled for all databases! Opening DatabasePool 'auth'. Asynchronous connections: 1, synchronous connections: 1. Could not connect to MySQL database at 127.0.0.1: Unknown database 'auth' DatabasePool Login NOT opened. There were errors opening the MySQL connections. Check your SQLDriverLogFile for specific errors. Read wiki at http://collab.kpsn.org/display/tc/TrinityCore+Home Unknown database 'auth' is the line that concerns me. It's not in HeidiSQL and bnetserver isn't finding it. I'll walk through the compilation again from the start, but I do not believe I'm wrong (again, I'm following the instructions http://collab.kpsn.org/display/tc/Installation+Guide).
  2. My apologies for my word choice, but I was using the repack as a sort of gauge, to see what my target final compilation should/could/might look like. I'm not attempting to distribute anything. Should I programmatically fix something that's not working, then I'm happy to share that, but that's all this is about, right? Problem: Okay, I uninstalled MySQL to run the installation again with screenshots. After the above step, I went back and removed Python from the list via custom install... The above step is exactly as it appeared when I got to it, like most, I left the settings as they were. The above screenshot is where I believe I messed up originally. I added a password, because without it, I couldn't continue. This time though, I also noticed the "Add User" button. I added a user... Then things really went sideways... The WindowsServiceName changed automatically to what you see below. I checked running services on my system. Even after uninstalling MySQL, it was still listed. It wasn't running, but it was listed. I think that's why this changed like it did. I pressed on... I clicked on Execute in the above screenshot and when it got down to "Applying security settings" it errored out. Here's the error log: Beginning configuration step: Stopping Server [if necessary] Ended configuration step: Stopping Server [if necessary] Beginning configuration step: Writing configuration file Ended configuration step: Writing configuration file Beginning configuration step: Updating firewall Adding firewall rule for MySQL56 on port 3306. Successfully added firewall rule. Ended configuration step: Updating firewall Beginning configuration step: Adjusting Windows service [if necessary] Attempting to grant Network Service require filesystem permissions. Granted permissions. Adding new service New service added Ended configuration step: Adjusting Windows service [if necessary] Beginning configuration step: Initializing Database [if necessary] Initialize is only compatible for 5.7.7 or above, no need for Initialize the Database Ended configuration step: Initializing Database [if necessary] Beginning configuration step: Starting Server Starting MySQL as a service Ended configuration step: Starting Server Beginning configuration step: Applying security settings Attempting to update security settings. Authentication to host 'localhost' for user 'root' using method 'mysql_native_password' failed with message: Access denied for user 'root'@'localhost' (using password: YES) Ended configuration step: Applying security settings It asks if I would like to try again. I click Yes, but it can't seem to shut down the server to apply the security settings. So, now i'm stuck again, only a step back from where I was before. I feel like I'm digging myself a nice deep hole that I'm not going to be able to get out of (short of formatting my hard drive!) Any suggestions?
  3. Before I get into this, I just want to state that I've been a programming hobbyist for over 15 years. I've simply never gotten into any project that required so many different programs to compile and run the final product. Call me a noob if you must. The title states the problem I am having. I've followed the instructions at http://collab.kpsn.org/display/tc/Installation+Guide to the letter, but when I got to the step to run bnetserver (on Server Setup), it gave me the following error log: TrinityCore rev. 3fceabfa1139 2015-09-29 00:11:26 +0200 (6.x branch) (Win32, Release) (bnetserver) <Ctrl-C> to stop. Using configuration file bnetserver.conf. Using SSL version: OpenSSL 1.0.2d 9 Jul 2015 (library: OpenSSL 1.0.2d 9 Jul 2015) Using Boost version: 1.59.0 Automatic database updates are disabled for all databases! Opening DatabasePool 'auth'. Asynchronous connections: 1, synchronous connections: 1. Could not connect to MySQL database at 127.0.0.1: Access denied for user 'root'@'localhost' (using password: YES) DatabasePool Login NOT opened. There were errors opening the MySQL connections. Check your SQLDriverLogFile for specific errors. Read wiki at http://collab.kpsn.org/display/tc/TrinityCore+HomeI'm running windows 7 32bit. I'm not sure what else to offer. I feel like there was something I've missed, but I've gone over the instructions about a dozen times. The one thing that bothers me is that when I downloaded the Trinity Repack and ran it, there was MySQLStarter.exe to run before bnetserver. Apparently, something else is supposed to take the place of that in the collab instructions. When I open HeidiSQL to look at the MySQL database, it doesn't look anything like the repack database. I know I either missed some step or messed something up regarding that, but for the life of me I cannot figure out what. ANY help would be appreciated. Going over the Database installation page again... Downloading the Database Download the latest database compilation from TrinityCore Downloads. Click the green Download button on top right next to right column. The file is in .7z format, so you will need an archive program like 7zip to unpack it. Important: There are multiple .sql files to choose from in the .7z archive. If this is your first time installing TrinityCore, you will ONLY need the file with "TDB_full" at the beginning. Installing The Trinity Databases 6.x Trinity needs 4 databases to run at 6.x branch - Auth, Characters, Hotfixes and World: auth - holds account data - usernames, passwords, GM access, realm information, etc. characters - holds character data - created characters, inventory, bank items, auction house, tickets, etc. world - holds game-experience content such as NPCs, quests, objects, etc. hotfixes - holds fixes not already added to the core or other official databases. The very next step is to open the worldserver.conf file, but it doesn't say what to do with the data files I got from the .7z file. I tried to run them in Heidisql, but that only led to errors and didn't change the database that currently running on my system. I'm pretty sure something needs to be done to add those files to the database, or to start a new database with those files somehow, but I'm lost as to what to do and the instructions don't say anything about it. Again, any help would be appreciated.
×
×
  • Create New...