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]> 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]> > 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]. 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.
