Jump to content
TrinityCore

shaboogity

Plebs
  • Posts

    1
  • Joined

  • Last visited

shaboogity's Achievements

Newbie

Newbie (1/14)

0

Reputation

  1. Good Afternoon. For the longest time, I've never been able to get the database updates to be applied using TC, I've always had to apply them manually. I'd like to do a bit of troubleshooting to get that working, but the logging doesn't really tell me what the problem is. Below is excerpt from worldserver during startup. 2020-04-10_12:37:04 INFO DatabasePool 'tlk_world_dev' opened successfully. 2 total connections running. 2020-04-10_12:37:04 DEBUG [0 ms] SQL: SHOW TABLES 2020-04-10_12:37:04 INFO Database Auth is empty, auto populating it... 2020-04-10_12:37:04 INFO >> Applying 'E:/_installs/TrinityCore/TrinityCore/sql/base/auth_database.sql'... 2020-04-10_12:37:04 FATAL Applying of file 'E:/_installs/TrinityCore/TrinityCore/sql/base/auth_database.sql' to database 'tlk_auth_dev' failed! If you are a user, please pull the latest revision from the repository. Also make sure you have not applied any of the databases with your sql client. You cannot use auto-update system and import sql files from TrinityCore repository with your sql client. If you are a developer, please fix your sql query. 2020-04-10_12:37:04 ERROR Could not populate the Login database, see log for details. 2020-04-10_12:37:04 INFO Closing down DatabasePool 'tlk_world_dev'. 2020-04-10_12:37:04 INFO Asynchronous connections on DatabasePool 'tlk_world_dev' terminated. Proceeding with synchronous connections. 2020-04-10_12:37:04 INFO All connections on DatabasePool 'tlk_world_dev' closed. 2020-04-10_12:37:04 INFO Closing down DatabasePool 'tlk_characters_dev'. 2020-04-10_12:37:04 INFO Asynchronous connections on DatabasePool 'tlk_characters_dev' terminated. Proceeding with synchronous connections. 2020-04-10_12:37:04 INFO All connections on DatabasePool 'tlk_characters_dev' closed. 2020-04-10_12:37:04 INFO Closing down DatabasePool 'tlk_auth_dev'. 2020-04-10_12:37:04 INFO Asynchronous connections on DatabasePool 'tlk_auth_dev' terminated. Proceeding with synchronous connections. 2020-04-10_12:37:04 INFO All connections on DatabasePool 'tlk_auth_dev' closed. It seems like it can connect to the SQL server, and it's using a SQL account that has been grated all rights globally. So I should have the same rights as root. Are there any options I can set to find out what part of the update process is failing? I currently have these set in the worldserver.conf file: Logger.sql.sql=1,Console DBErrors Logger.sql.updates=1,Console DBErrors Logger.sql.dev=1,Console DBErrors Logger.sql.driver=1,Console DBErrors If it matters, MySQL and TC are on two different hosts. This is also the 3.3.5 branch. Please let me know if you need additional information. Thanks!
×
×
  • Create New...