14768 2022-03-24 15:10:24 +0000 GitHub git protocol urls need to be scrubbed 2022-04-20 21:25:01 +0000 1 1 6 Yocto Project Subprojects Layer Index Layer Index Metadata unspecified x86 Multiple RESOLVED FIXED Medium+ normal 4.1 M1 1 tim.orling tim.orling konrad.scherer mhalstead randy.macleod apoorvsangal --- --- Don't know oldest_to_newest 92854 0 tim.orling 2022-03-24 15:10:24 +0000 Layers which have git protocol urls for GitHub need to switch to https. GitHub has blocked unauthenticated git protocol. https://github.blog/2021-09-01-improving-git-protocol-security-github/ 92892 1 randy.macleod 2022-03-31 14:36:05 +0000 Is this something that Michael can do in the database? 92917 2 konrad.scherer 2022-04-01 13:50:14 +0000 Yes from the Admin interface all the project url for each layers can be updated. Django does support custom commands and it should be possible to make a command that will iterate through the layers and update any github urls. 92967 3 tim.orling 2022-04-10 18:45:20 +0000 The following should fix it: UPDATE layerindex_layeritem SET layerindex_layeritem.vcs_url = REPLACE(layerindex_layeritem.vcs_url,'git://github.com', 'https://github.com') WHERE layerindex_layeritem.vcs_url LIKE "git://github.com%"; 92991 4 tim.orling 2022-04-11 22:04:39 +0000 After discussing with Paul, we do not want to do SQL directly. I'll need to refactor for 'manage.py shell' which I might have permissions to do (after testing on local instance). 93134 5 tim.orling 2022-04-20 17:36:36 +0000 Using manage.py shell: from django.db.models import Value from django.db.models.functions import Replace from layerindex.models import LayerItem layers = LayerItem.objects.all().filter(vcs_url__startswith='git://github.com') layers.update(vcs_url=Replace('vcs_url', Value('git://github.com'), Value('https://github.com'))) 93135 6 tim.orling 2022-04-20 21:25:01 +0000 To get to the shell: docker exec -it <layersapp> sh -c "/opt/layerindex/manage.py shell" Count before fix: 106