[DiscordArchive] Greetings, we moved from Debian to Ubuntu 22 fresh server. Installed it, and uploaded our databases
[DiscordArchive] Greetings, we moved from Debian to Ubuntu 22 fresh server. Installed it, and uploaded our databases
Original source
Greetings, we moved from Debian to Ubuntu 22 fresh server. Installed it, and uploaded our databases from backup, but somehow we have an error:
```DatabasePool 'acore_auth' opened successfully. 2 total connections running.
Updating Auth database...
>> Applying update "2023_04_23_00.sql" 'F853503'...
mysql: [ERROR] Failed to open required defaults file: /root/azeroth-server/temp/mysql_ac.conf
mysql: [ERROR] Fatal error in defaults handling. Program aborted!
Applying of file '/home/username/azerothcore/data/sql/archive/db_auth/9.x/2023_04_23_00.sql' to database 'acore_auth' 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 AzerothCore repository with your sql client. If you are a developer, please fix your sql query.
Could not update the Login database, see log for details.
Closing down DatabasePool 'acore_auth'.
Asynchronous connections on DatabasePool 'acore_auth' terminated. Proceeding with synchronous connections.
All connections on DatabasePool 'acore_auth' closed.
```
Why `authserver` can't apply mysql updates?
What I'm doing wrong?
rektbyfaith
05-04-2023, 10:33 PM #1Archived author: Nebo • Posted: 2023-05-04T22:33:02.859000+00:00
Original source
Greetings, we moved from Debian to Ubuntu 22 fresh server. Installed it, and uploaded our databases from backup, but somehow we have an error:
```DatabasePool 'acore_auth' opened successfully. 2 total connections running.
Updating Auth database...
>> Applying update "2023_04_23_00.sql" 'F853503'...
mysql: [ERROR] Failed to open required defaults file: /root/azeroth-server/temp/mysql_ac.conf
mysql: [ERROR] Fatal error in defaults handling. Program aborted!
Applying of file '/home/username/azerothcore/data/sql/archive/db_auth/9.x/2023_04_23_00.sql' to database 'acore_auth' 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 AzerothCore repository with your sql client. If you are a developer, please fix your sql query.
Could not update the Login database, see log for details.
Closing down DatabasePool 'acore_auth'.
Asynchronous connections on DatabasePool 'acore_auth' terminated. Proceeding with synchronous connections.
All connections on DatabasePool 'acore_auth' closed.
```
Why `authserver` can't apply mysql updates?
What I'm doing wrong?
Original source
It can't apply any updates because the mysql config isn't where it should be.
rektbyfaith
05-04-2023, 10:39 PM #2Archived author: Revision • Posted: 2023-05-04T22:39:51.150000+00:00
Original source
It can't apply any updates because the mysql config isn't where it should be.
Original source
you mean `/root/azeroth-server/temp/mysql_ac.conf` this file?
rektbyfaith
05-04-2023, 10:40 PM #3Archived author: Nebo • Posted: 2023-05-04T22:40:21.989000+00:00
Original source
you mean `/root/azeroth-server/temp/mysql_ac.conf` this file?
Original source
I guess so, I don't know what you're using to set all of this up.
rektbyfaith
05-04-2023, 10:49 PM #4Archived author: Revision • Posted: 2023-05-04T22:49:35.121000+00:00
Original source
I guess so, I don't know what you're using to set all of this up.
Original source
Alright, thank you very much. I'll try to redo it, and follow step-by-step instructions tomorrow, maybe I've installed MySQL in some *not correct* way, idk.
rektbyfaith
05-04-2023, 10:52 PM #5Archived author: Nebo • Posted: 2023-05-04T22:52:09.657000+00:00
Original source
Alright, thank you very much. I'll try to redo it, and follow step-by-step instructions tomorrow, maybe I've installed MySQL in some *not correct* way, idk.
Original source
I'm getting this same issue on a new install using git bash
rektbyfaith
05-07-2023, 06:21 AM #6Archived author: Redmay • Posted: 2023-05-07T06:21:01.766000+00:00
Original source
I'm getting this same issue on a new install using git bash
Original source
on windows
rektbyfaith
05-07-2023, 06:21 AM #7Archived author: Redmay • Posted: 2023-05-07T06:21:28.611000+00:00
Original source
on windows
1 Guest(s)
1 Guest(s)