[DiscordArchive] I'm just at a bit of a loss here. Not sure what I'm missing:
[DiscordArchive] I'm just at a bit of a loss here. Not sure what I'm missing:
Original source
I'm just at a bit of a loss here. Not sure what I'm missing:
```
MariaDB [(none)]> show grants for 'acore_testing'@'192.168.88.16';
+-----------------------------------------------------------------------------------------------------------------------------------+
| Grants for [email protected] |
+-----------------------------------------------------------------------------------------------------------------------------------+
| GRANT ALL PRIVILEGES ON *.* TO `acore_testing`@`192.168.88.16` IDENTIFIED BY PASSWORD '<password>' |
+-----------------------------------------------------------------------------------------------------------------------------------+
1 row in set (0.000 sec)
MariaDB [(none)]> show grants for 'acore_testing'@'localhost';
+-------------------------------------------------------------------------------------------------------------------------------+
| Grants for acore_testing@localhost |
+-------------------------------------------------------------------------------------------------------------------------------+
| GRANT ALL PRIVILEGES ON *.* TO `acore_testing`@`localhost` IDENTIFIED BY PASSWORD '<password>' |
+-------------------------------------------------------------------------------------------------------------------------------+
1 row in set (0.000 sec)
```
And my `worldserver.conf` config:
```
LoginDatabaseInfo = "192.168.88.48;3306;acore;acore;acore_auth"
WorldDatabaseInfo = "192.168.88.48;3306;acore_testing;acore_testing;acore_world_testing_realm"
CharacterDatabaseInfo = "192.168.88.48;3306;acore_testing;acore_testing;acore_characters_testing_realm"
```
And when I run `./worldserver`
```
Opening DatabasePool 'acore_auth'. Asynchronous connections: 2, synchronous connections: 2.
DatabasePool 'acore_auth' opened successfully. 4 total connections running.
Opening DatabasePool 'acore_characters_testing_realm'. Asynchronous connections: 4, synchronous connections: 8.
DatabasePool 'acore_characters_testing_realm' opened successfully. 12 total connections running.
Opening DatabasePool 'acore_world_testing_realm'. Asynchronous connections: 4, synchronous connections: 4.
DatabasePool 'acore_world_testing_realm' opened successfully. 8 total connections running.
Database Character is empty, auto populating it...
>> Applying 'pet_spell_cooldown.sql'...
ERROR 1045 (28000): Access denied for user 'acore_testing'@'192.168.88.16' (using password: YES)
Applying of file '/home/azc/azerothcore/data/sql/base/db_characters/pet_spell_cooldown.sql' to database 'acore_characters_testing_realm' 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 populate the Character database, see log for details.
```
I'm unsure why it's able to connect *and* determine the `Database Character is empty` but then fail to apply a SQL file?
rektbyfaith
03-14-2023, 08:30 AM #1Archived author: Michael Crilly • Posted: 2023-03-14T08:30:31.022000+00:00
Original source
I'm just at a bit of a loss here. Not sure what I'm missing:
```
MariaDB [(none)]> show grants for 'acore_testing'@'192.168.88.16';
+-----------------------------------------------------------------------------------------------------------------------------------+
| Grants for [email protected] |
+-----------------------------------------------------------------------------------------------------------------------------------+
| GRANT ALL PRIVILEGES ON *.* TO `acore_testing`@`192.168.88.16` IDENTIFIED BY PASSWORD '<password>' |
+-----------------------------------------------------------------------------------------------------------------------------------+
1 row in set (0.000 sec)
MariaDB [(none)]> show grants for 'acore_testing'@'localhost';
+-------------------------------------------------------------------------------------------------------------------------------+
| Grants for acore_testing@localhost |
+-------------------------------------------------------------------------------------------------------------------------------+
| GRANT ALL PRIVILEGES ON *.* TO `acore_testing`@`localhost` IDENTIFIED BY PASSWORD '<password>' |
+-------------------------------------------------------------------------------------------------------------------------------+
1 row in set (0.000 sec)
```
And my `worldserver.conf` config:
```
LoginDatabaseInfo = "192.168.88.48;3306;acore;acore;acore_auth"
WorldDatabaseInfo = "192.168.88.48;3306;acore_testing;acore_testing;acore_world_testing_realm"
CharacterDatabaseInfo = "192.168.88.48;3306;acore_testing;acore_testing;acore_characters_testing_realm"
```
And when I run `./worldserver`
```
Opening DatabasePool 'acore_auth'. Asynchronous connections: 2, synchronous connections: 2.
DatabasePool 'acore_auth' opened successfully. 4 total connections running.
Opening DatabasePool 'acore_characters_testing_realm'. Asynchronous connections: 4, synchronous connections: 8.
DatabasePool 'acore_characters_testing_realm' opened successfully. 12 total connections running.
Opening DatabasePool 'acore_world_testing_realm'. Asynchronous connections: 4, synchronous connections: 4.
DatabasePool 'acore_world_testing_realm' opened successfully. 8 total connections running.
Database Character is empty, auto populating it...
>> Applying 'pet_spell_cooldown.sql'...
ERROR 1045 (28000): Access denied for user 'acore_testing'@'192.168.88.16' (using password: YES)
Applying of file '/home/azc/azerothcore/data/sql/base/db_characters/pet_spell_cooldown.sql' to database 'acore_characters_testing_realm' 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 populate the Character database, see log for details.
```
I'm unsure why it's able to connect *and* determine the `Database Character is empty` but then fail to apply a SQL file?
Original source
One possible cause is, when a query yields errors.
rektbyfaith
03-14-2023, 08:32 AM #2Archived author: Honey • Posted: 2023-03-14T08:32:54.543000+00:00
Original source
One possible cause is, when a query yields errors.
Original source
True. Seems to be OK on my other server, though.
rektbyfaith
03-14-2023, 08:38 AM #3Archived author: Michael Crilly • Posted: 2023-03-14T08:38:27.453000+00:00
Original source
True. Seems to be OK on my other server, though.
Original source
Deffo some SQL updates in `master`, so I'll pull and recompile.
rektbyfaith
03-14-2023, 08:39 AM #4Archived author: Michael Crilly • Posted: 2023-03-14T08:39:02.789000+00:00
Original source
Deffo some SQL updates in `master`, so I'll pull and recompile.
Original source
Same issue with the latest code, <@595620700706832414>. This is the very first `.sql` file that is run against the database.
rektbyfaith
03-14-2023, 08:48 AM #5Archived author: Michael Crilly • Posted: 2023-03-14T08:48:06.732000+00:00
Original source
Same issue with the latest code, <@595620700706832414>. This is the very first `.sql` file that is run against the database.
Original source
Ah let me try something
rektbyfaith
03-14-2023, 08:50 AM #6Archived author: Michael Crilly • Posted: 2023-03-14T08:50:14.375000+00:00
Original source
Ah let me try something
1 Guest(s)
1 Guest(s)