the Dockerfile has WORKDIR /musicbrainz-server, but it seems that when you execute a command it's from /, which I don't understand
2023-11-01 30541, 2023
bitmap
so I guess at least this should work: sudo docker-compose exec musicbrainz bash -c 'cd /musicbrainz-server; ./admin/BuildMaterializedTables --database=MAINTENANCE area_containment'
2023-11-01 30552, 2023
bitmap
if not then I'm out of ideas
2023-11-01 30556, 2023
jazzi has quit
2023-11-01 30537, 2023
jazzi joined the channel
2023-11-01 30538, 2023
jazzi
yeah i refreshed and still empty xd
2023-11-01 30504, 2023
jazzi
does it work from ur end? would u mind querying the child countries of iran for me and ill put them into my my script 1 by 1
2023-11-01 30508, 2023
bitmap
if you can figure out where the musicbrainz-server checkout is inside the container, that would help
2023-11-01 30519, 2023
bitmap
I don't have a running musicbrainz-docker instance atm
2023-11-01 30541, 2023
jazzi
how could i find the checkout? idk what a checkout is
2023-11-01 30521, 2023
bitmap
the git checkout
2023-11-01 30529, 2023
bitmap
is it not at /musicbrainz-server?
2023-11-01 30513, 2023
bitmap
there are 1019 child areas btw
2023-11-01 30505, 2023
jazzi
1019 haha uh oh
2023-11-01 30516, 2023
jazzi
so i did git branch on cd/musicbrainz-docker
2023-11-01 30520, 2023
jazzi
and it returned * master
2023-11-01 30524, 2023
jazzi
is that the checkout u needed?
2023-11-01 30537, 2023
bitmap
/musicbrainz-server not /musicbrainz-docker right?
2023-11-01 30514, 2023
jazzi
uhh on my side the directory is called musicbrainz-server :eyes:
fatal: not a git repository (or any of the parent directories): .git
2023-11-01 30551, 2023
jazzi
root@0c52e35228bc:/#
2023-11-01 30533, 2023
bitmap
yeah, you are in the root directory / right now, try this first: cd /musicbrainz-server
2023-11-01 30548, 2023
jazzi
root@0c52e35228bc:/# cd /musicbrainz-server
2023-11-01 30548, 2023
jazzi
bash: cd: /musicbrainz-server: No such file or directory
2023-11-01 30549, 2023
jazzi
root@0c52e35228bc:/#
2023-11-01 30511, 2023
bitmap
ok then I'm very confused because I thought that dir was hardcoded, yvanzo might be of more help
2023-11-01 30534, 2023
jazzi
there were two docker containers, one for musicbrainz-docker created on 5432 that i entered now, the other one on 6379 called musicbrainz-docker_redis_1
2023-11-01 30547, 2023
jazzi
im meant to enter the 5432 one correct? thats the one i did that line u just told me to do
2023-11-01 30509, 2023
bitmap
there should be one for musicbrainz, postgres, and redis iirc
2023-11-01 30519, 2023
bitmap
postgres runs on port 5432 so that's probably the postgres one
2023-11-01 30533, 2023
jazzi
ok good i tried it on that one
2023-11-01 30539, 2023
jazzi
wonder why its not working lol
2023-11-01 30542, 2023
bitmap
you want the musicbrainz one (might be named _web or something?)
2023-11-01 30511, 2023
jazzi
hmm ive only got 2 containers running not 3
2023-11-01 30522, 2023
bitmap
oh wait, you said you don't have the server earlier, didn't you. lol sorry
2023-11-01 30526, 2023
jazzi
the postgres and the redis one
2023-11-01 30532, 2023
jazzi
haha yeah i just did the local postgres installation
2023-11-01 30536, 2023
jazzi
is that why this wont work?
2023-11-01 30544, 2023
bitmap
yeah you need the musicbrainz container to run this script
2023-11-01 30503, 2023
jazzi
right ok is that tricky to setup from this point?
2023-11-01 30507, 2023
bitmap
I didn't realize you could run musicbrainz-docker with it (since it contains a bunch of maintenance scripts)
2023-11-01 30513, 2023
bitmap
without it*
2023-11-01 30543, 2023
bitmap
I guess you try a different join to get the contained areas but it will be slower
2023-11-01 30515, 2023
jazzi
im not too fussed about speed honestly haha i just need the data once
2023-11-01 30541, 2023
jazzi
is there some kind of other method to join up the children countries?
