Hey Lawrence, sorry for the late response. Regarding settings.py: your project's settings.py take precedence over the default arches settings.py. *However*, in the docker version of Arches, a settings_local.py is also copied to your project folder. This settings_local.py should contain the postgres db settings that you set through the environment variables in your docker-compose.yml. It should already be imported by default in your settings.py. Notice these lines at the bottom of that file: try: from settings_local import * except ImportError: pass
When your project gets initialized (at first startup), that settings_local.py is copied to /web_root/<your project>/<your project>/settings_local.py. Here is the source for reference: https://github.com/archesproject/arches/blob/master/docker/settings_local.py With that setup, all you should have to do is set your db credentials in your docker-compose.yml: - PGUSERNAME=username@your-db-server If you still receive above errors, something else is up and we need to investigate :) By the way, which version of Arches are you using right now? Also, if you encounter any errors in the Docker Readme, especially in the 'Setting up your own Arches project' section, please let us know! :) https://github.com/archesproject/arches/tree/master/docker#setting-up-your-own-arches-project On Friday, 26 October 2018 05:43:11 UTC+2, Lawrence Goh wrote: > > Hi Vincent, > > I noticed another odd thing. When it does the import_graphs after > creating the database, it has this error. > > arches | FATAL: Invalid Username specified. Please check the > Username and retry connection. The Username should be in > <username@hostname> format. > arches | FATAL: Invalid Username specified. Please check the > Username and retry connection. The Username should be in > <username@hostname> format. > arches | Running: python manage.py packages -o > import_reference_data -s "arches/db/schemes/arches_concept_scheme.rdf" > > Any idea where in the code is going nuts? :) > > Thanks. > > Regards, > Lawrence > > > > On Fri, Oct 26, 2018 at 4:03 PM Lawrence Goh <[email protected] > <javascript:>> wrote: > >> Hi Vincent, >> >> Been digging further into the postgres libs. It seems the dsn and kwargs >> in them are getting values from the <project_name>'s settings.py which >> contains the default db credentials (postgres; postgis). Normally, I >> assumed it will get it from the arches' settings.py file. >> >> In case I am confusing :) When you browse the container, you would be >> landed into \web_root\arches. Back down, it would be ENV, arches, >> <project_name> folders. >> >> Probably I might need a new pull from arches again and work from there. >> I am unsure if my own is corrupted. >> >> Thanks. >> >> Regards, >> Lawrence >> >> >> On Thu, Oct 25, 2018 at 5:30 AM Vincent Meijer <[email protected] >> <javascript:>> wrote: >> >>> Ah I can see the image now (in email). Looks like a regular firewall >>> misconfiguration. >>> Can you show us your current settings? >>> >>> There is also the option 'Enforce SSL Connection' under 'SSL Settings' >>> in your Azure DB. Is this set to Disabled? >>> >>> And can you connect to it from your local machine if you whitelist your >>> ip in that same screen? >>> >>> >>> On Tuesday, 23 October 2018 23:45:06 UTC+2, Lawrence Goh wrote: >>>> >>>> Hi Vincent, >>>> >>>> Apologies for another set up question. Been going everywhere and sadly >>>> to nowhere. We have set up a Azure Database for Postgresql. We could get >>>> the docker compose to create the DB. But the arches container failed due >>>> to some weird network restriction. >>>> >>>> [image: image.png] >>>> >>>> I have added IPs to the firewall. Even having it being from 0.0.0.0 to >>>> 255.255.255.255. The "Allow access to Azure services" is on. >>>> >>>> Any ideas? >>>> >>>> Thanks. >>>> >>>> Regards, >>>> Lawrence >>>> >>>> On Fri, Oct 19, 2018 at 10:32 PM Vincent Meijer <[email protected]> >>>> wrote: >>>> >>>>> Yeah it's a weird choice from Microsoft to do things differently and >>>>> arches wasn't prepared for that @... >>>>> >>>>> >>>>> >>>>> On Fri, 19 Oct 2018, 11:23 larrygoh84, <[email protected]> wrote: >>>>> >>>>>> using 4.3.1. does this mean its a known issue? it doesn't handle the >>>>>> @ well? :) >>>>>> >>>>>> -------- Original message -------- >>>>>> From: Vincent Meijer <[email protected]> >>>>>> Date: 10/19/18 10:02 PM (GMT+12:00) >>>>>> To: Arches Project <[email protected]> >>>>>> Subject: Re: [Arches] Re: Hosting Arches on Azure as a Web App for >>>>>> Containers >>>>>> >>>>>> Which version of Arches are you using? >>>>>> I created a PR (for #4099) for this earlier, but it was after 4.3.1 >>>>>> was released. >>>>>> >>>>>> Until the next release you could use the master branch (there are >>>>>> docker images built for that in Docker Hub for every new push: >>>>>> https://hub.docker.com/r/archesproject/arches/tags/ ) >>>>>> >>>>>> However, if you want something more stable, you are also free to use >>>>>> my own arches base images: >>>>>> https://hub.docker.com/r/globaldigitalheritage/arches/tags/ >>>>>> The current tags in there are all based on Arches 4.3.1 and I push a >>>>>> new version every time I created some additional functionality / fixes >>>>>> for >>>>>> a PR, such as the one with '@' in Azure database names. >>>>>> >>>>>> Currently the latest I got is globaldigitalheritage/arches:4.3.1.11 >>>>>> >>>>>> >>>>>> I use these images as a base in my own Dockerfile >>>>>> (as described in step 7 of 'Setting up your own Arches project': >>>>>> https://github.com/archesproject/arches/blob/master/docker/Readme.md#setting-up-your-own-arches-project >>>>>> >>>>>> ) >>>>>> >>>>>> I recommend to follow these steps to create your own Arches project, >>>>>> rather than editing the core Arches app. >>>>>> >>>>>> Hope this helps! >>>>>> Vincent >>>>>> >>>>>> >>>>>> On Friday, 19 October 2018 05:14:57 UTC+2, Lawrence Goh wrote: >>>>>>> >>>>>>> Hi Vincent, >>>>>>> >>>>>>> Had you faced this issue before? We are now trying to connect to >>>>>>> Azure DB for Postgresql. The container log just freezes at Testing if >>>>>>> database server is up.. Is it senstive to the @? thanks. >>>>>>> >>>>>>> On Friday, October 19, 2018 at 3:03:47 PM UTC+13, Lawrence Goh wrote: >>>>>>>> >>>>>>>> Hi Vincent, >>>>>>>> >>>>>>>> Yups. Was poking around the codes yesterday and had a go with >>>>>>>> removing the staticfiles_storage and all went well :) >>>>>>>> >>>>>>>> Thanks. >>>>>>>> >>>>>>>> Regards, >>>>>>>> Lawrence >>>>>>>> >>>>>>>> On Thu, Oct 18, 2018 at 9:00 PM Vincent Meijer < >>>>>>>> [email protected]> wrote: >>>>>>>> >>>>>>>>> If I'm understanding you correctly, you want to serve static files >>>>>>>>> the 'standard' way (directly from the Arches app using Whitenoise) >>>>>>>>> and >>>>>>>>> serve uploaded files from Azure Blob Storage? >>>>>>>>> I do the same at the moment. For that, use: >>>>>>>>> DEFAULT_FILE_STORAGE='storages.backends.azure_storage.AzureStorage' >>>>>>>>> and >>>>>>>>> STATICFILES_STORAGE = >>>>>>>>> 'whitenoise.storage.CompressedStaticFilesStorage' >>>>>>>>> >>>>>>>>> (together with the other appropriate settings for Azure and >>>>>>>>> Whitenoise, that you probably already have). >>>>>>>>> >>>>>>>>> Does that make sense? >>>>>>>>> >>>>>>>>> >>>>>>>>> On Wednesday, 17 October 2018 23:04:35 UTC+2, Lawrence Goh wrote: >>>>>>>>>> >>>>>>>>>> Hi Vincent, >>>>>>>>>> >>>>>>>>>> Thanks for that link. Will need to figure to adapt it for Azure >>>>>>>>>> use. >>>>>>>>>> >>>>>>>>>> Besides that, I noticed it loads all the static files into the >>>>>>>>>> blob. Was thinking to have the static files be in the container. >>>>>>>>>> Only >>>>>>>>>> push the uploaded 'media files' into the blob. I guess it doesn't >>>>>>>>>> do that >>>>>>>>>> right? :) >>>>>>>>>> >>>>>>>>>> Thanks. >>>>>>>>>> >>>>>>>>>> Regards, >>>>>>>>>> Lawrence >>>>>>>>>> >>>>>>>>>> On Thu, Oct 18, 2018 at 2:12 AM Vincent Meijer < >>>>>>>>>> [email protected]> wrote: >>>>>>>>>> >>>>>>>>>>> The collectfast package looks promising: >>>>>>>>>>> https://stackoverflow.com/questions/16805232/faster-alternative-to-manage-py-collectstatic-w-s3boto-storage-backend-to-syn >>>>>>>>>>> >>>>>>>>>>> -- >>>>>>>>>>> -- To post, send email to [email protected]. To >>>>>>>>>>> unsubscribe, send email to [email protected]. >>>>>>>>>>> For more information, visit >>>>>>>>>>> https://groups.google.com/d/forum/archesproject?hl=en >>>>>>>>>>> --- >>>>>>>>>>> You received this message because you are subscribed to the >>>>>>>>>>> Google Groups "Arches Project" group. >>>>>>>>>>> To unsubscribe from this group and stop receiving emails from >>>>>>>>>>> it, send an email to [email protected]. >>>>>>>>>>> For more options, visit https://groups.google.com/d/optout. >>>>>>>>>>> >>>>>>>>>> -- >>>>>>>>> -- To post, send email to [email protected]. To >>>>>>>>> unsubscribe, send email to [email protected]. For >>>>>>>>> more information, visit >>>>>>>>> https://groups.google.com/d/forum/archesproject?hl=en >>>>>>>>> --- >>>>>>>>> You received this message because you are subscribed to the Google >>>>>>>>> Groups "Arches Project" group. >>>>>>>>> To unsubscribe from this group and stop receiving emails from it, >>>>>>>>> send an email to [email protected]. >>>>>>>>> For more options, visit https://groups.google.com/d/optout. >>>>>>>>> >>>>>>>> -- >>>>>> -- To post, send email to [email protected]. To >>>>>> unsubscribe, send email to [email protected]. For >>>>>> more information, visit >>>>>> https://groups.google.com/d/forum/archesproject?hl=en >>>>>> --- >>>>>> You received this message because you are subscribed to the Google >>>>>> Groups "Arches Project" group. >>>>>> To unsubscribe from this group and stop receiving emails from it, >>>>>> send an email to [email protected]. >>>>>> For more options, visit https://groups.google.com/d/optout. >>>>>> >>>>> -- >>> -- To post, send email to [email protected] <javascript:>. To >>> unsubscribe, send email to [email protected] >>> <javascript:>. For more information, visit >>> https://groups.google.com/d/forum/archesproject?hl=en >>> --- >>> You received this message because you are subscribed to the Google >>> Groups "Arches Project" group. >>> To unsubscribe from this group and stop receiving emails from it, send >>> an email to [email protected] <javascript:>. >>> For more options, visit https://groups.google.com/d/optout. >>> >> -- -- To post, send email to [email protected]. To unsubscribe, send email to [email protected]. For more information, visit https://groups.google.com/d/forum/archesproject?hl=en --- You received this message because you are subscribed to the Google Groups "Arches Project" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.
