Errors When Auto-Applying to Empty DBs

[shaboogity]

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!

 

Edited April 10, 2020 by shaboogity