[DiscordArchive] it *seems* to me like the db-import container should be doing that on startup, but it might be that
[DiscordArchive] it *seems* to me like the db-import container should be doing that on startup, but it might be that
Original source
it *seems* to me like the db-import container should be doing that on startup, but it might be that it only does the initial data load and not modules/updates?
rektbyfaith
05-01-2023, 02:43 PM #1Archived author: KJack • Posted: 2023-05-01T14:43:07.404000+00:00
Original source
it *seems* to me like the db-import container should be doing that on startup, but it might be that it only does the initial data load and not modules/updates?
Original source
nice. I recommend adding PR for that to the playerbots repo
a little shell scripting can basically get you all of the way there as far as modules go
```bash
# auth
find modules -iname *.sql | grep "auth/" | xargs -I"{}" bash -c "mysql ... acore_auth < {}"
# world
find modules -name *.sql | grep "world/" | xargs -I"{}" bash -c "mysql ... acore_world < {}"
# char
find modules -name *.sql | grep "characters/" | xargs -I"{}" bash -c "mysql ... acore_characters < {}"
```
you can also copy the sql files to the appropriate `data/sql/custom/...` dir
rektbyfaith
05-01-2023, 02:45 PM #2Archived author: mynameismeat • Posted: 2023-05-01T14:45:31.690000+00:00
Original source
nice. I recommend adding PR for that to the playerbots repo
a little shell scripting can basically get you all of the way there as far as modules go
```bash
# auth
find modules -iname *.sql | grep "auth/" | xargs -I"{}" bash -c "mysql ... acore_auth < {}"
# world
find modules -name *.sql | grep "world/" | xargs -I"{}" bash -c "mysql ... acore_world < {}"
# char
find modules -name *.sql | grep "characters/" | xargs -I"{}" bash -c "mysql ... acore_characters < {}"
```
you can also copy the sql files to the appropriate `data/sql/custom/...` dir
Original source
Maybe alternatively add a mount for the `modules` to `/azerothcore/modules`? the current docker-compose doesnt do that
https://github.com/azerothcore/azerothco...#L194-L205
rektbyfaith
05-01-2023, 02:46 PM #3Archived author: mynameismeat • Posted: 2023-05-01T14:46:28.282000+00:00
Original source
Maybe alternatively add a mount for the `modules` to `/azerothcore/modules`? the current docker-compose doesnt do that
https://github.com/azerothcore/azerothco...#L194-L205
Original source
that's a good idea on both counts - let me work on it some today and I'll report what I find. maybe we can get this fixed for other people too if its not just my incompetence that's the problem.
rektbyfaith
05-01-2023, 02:47 PM #4Archived author: KJack • Posted: 2023-05-01T14:47:04.056000+00:00
Original source
that's a good idea on both counts - let me work on it some today and I'll report what I find. maybe we can get this fixed for other people too if its not just my incompetence that's the problem.
Original source
it'd be a line after 205 like
` - ./modules:/azerothcore/modules`
rektbyfaith
05-01-2023, 02:47 PM #5Archived author: mynameismeat • Posted: 2023-05-01T14:47:15.490000+00:00
Original source
it'd be a line after 205 like
` - ./modules:/azerothcore/modules`
Original source
> just my incompetence that's the problem
nah, as far as I can remember it doesn't work for me, I just kinda brute force it with the above
rektbyfaith
05-01-2023, 02:47 PM #6Archived author: mynameismeat • Posted: 2023-05-01T14:47:34.353000+00:00
Original source
> just my incompetence that's the problem
nah, as far as I can remember it doesn't work for me, I just kinda brute force it with the above
Original source
got it. let me see what i can figure out. that's a cool feature for admins that would be really nice if it actually worked.
rektbyfaith
05-01-2023, 02:48 PM #7Archived author: KJack • Posted: 2023-05-01T14:48:11.516000+00:00
Original source
got it. let me see what i can figure out. that's a cool feature for admins that would be really nice if it actually worked.
Original source
Parallels complicates things. I don't know how the networking works for that, unfortunately. The gist being you'll need to find out the IP address of the mysql server and how it relates to your client here.
IE, if docker (and mysql in docker) is running on macos and is properly port forwarded, and sqlpro is running in the windows VM, you might not be able to use 127.0.0.1 for access to mysql.
In this case (and any other case where windows is trying to access macos), you'll have to figure out the IP of macOS from windows
rektbyfaith
05-01-2023, 02:58 PM #8Archived author: mynameismeat • Posted: 2023-05-01T14:58:38.512000+00:00
Original source
Parallels complicates things. I don't know how the networking works for that, unfortunately. The gist being you'll need to find out the IP address of the mysql server and how it relates to your client here.
IE, if docker (and mysql in docker) is running on macos and is properly port forwarded, and sqlpro is running in the windows VM, you might not be able to use 127.0.0.1 for access to mysql.
In this case (and any other case where windows is trying to access macos), you'll have to figure out the IP of macOS from windows
Original source
heres the code for it
<https://github.com/azerothcore/azerothcore-wotlk/blob/590dcca82b9c6e5d5f49fb5f954b084a88070f84/src/server/database/Updater/UpdateFetcher.cpp#L163-L176>
looks like it requires `modules/mod-foo-bar/data/sql/db-world/foo-bar.sql`. That's probably a bug, since the official module template (skeleton-module) only defines `sql` instead of `data/sql`
<https://github.com/azerothcore/skeleton-module>
Thanks for making me think about this and do some digging. I'll probably submit a PR to fix this tonight or by the end of the week.
rektbyfaith
05-01-2023, 03:02 PM #9Archived author: mynameismeat • Posted: 2023-05-01T15:02:09.232000+00:00
Original source
heres the code for it
<https://github.com/azerothcore/azerothcore-wotlk/blob/590dcca82b9c6e5d5f49fb5f954b084a88070f84/src/server/database/Updater/UpdateFetcher.cpp#L163-L176>
looks like it requires `modules/mod-foo-bar/data/sql/db-world/foo-bar.sql`. That's probably a bug, since the official module template (skeleton-module) only defines `sql` instead of `data/sql`
<https://github.com/azerothcore/skeleton-module>
Thanks for making me think about this and do some digging. I'll probably submit a PR to fix this tonight or by the end of the week.
Original source
<:fucl:719913473139802194> im supposed to be working lol
rektbyfaith
05-01-2023, 03:02 PM #10Archived author: mynameismeat • Posted: 2023-05-01T15:02:43.116000+00:00
Original source
<:fucl:719913473139802194> im supposed to be working lol
1 Guest(s)
1 Guest(s)