Skip to content
Snippets Groups Projects
New look: Off

Download DB fails with 404

    • Closed Issue created by danielspeicher @danielspeicher

    Executing a live pull-sql results in:

    Find project ID from remote URL ...
Find pipeline trigger token ...
Trigger pipeline ...
{"message":"404 Not Found"} HTTP-Code:404
POST request to projects/508/trigger/pipeline did not succeed! Responds with code 404 instead of 201
 [success] Cache rebuild complete.

 // Import the split config configuration?: yes.                                                                        

 There are no changes to import.

    The global .env file, like described in ticket: #25 (closed):

    COMPOSER_DOWNGRADE=0
DOCKER4DRUPAL_LIVE_HOST_USERNAME=danielspeicher
DOCKER4DRUPAL_TRAEFIK_CERT=fullchain.pem
DOCKER4DRUPAL_TRAEFIK_DOMAIN=docker.localhost
DOCKER4DRUPAL_TRAEFIK_KEY=privkey.pem
DOCKER4DRUPAL_TRAEFIK_PORT=8000
DOCKER4DRUPAL_TRAEFIK_PORTAINER=0
DOCKER4DRUPAL_TRAEFIK_PORTS=8443
DOCKER4DRUPAL_TRAEFIK_USESSL=0
DORGFLOW=0
DRUPAL_LIVE=0
MAILHOG_HOST=smtp.freesmtpservers.com
MAILHOG_MECHANISM=NONE
MAILHOG_PASSWORD=
MAILHOG_PORT=25
MAILHOG_USERNAME=
PHP_DEBUG=0
PHP_VERSION=7.4
WEBSERVER_CONFIG_OVERWRITE=0
PHP_COVERAGE=0
GITLAB_URL=https://gitlab.lakedrops.com
GITLAB_PRIVATE_TOKEN=<token>

    The token is set, but I do not want to post it here. It is accessed correctly, see here:

    grafik

    The example is Mobimo Manegg. drush sa:

    '@default.behat':
  root: /var/www/html/web/
  uri: apache
'@default.dev':
  root: /var/www/html/web/
  uri: 'manegg.docker.localhost:8000'
'@default.live':
  root: /var/www/drupal/manegg/main/web
  uri: 'https://live.manegg.drupal.mobimo.lakedrops.com'
  host: drupal.mobimo.lakedrops.com
  user: danielspeicher
'@stage.current':
  root: /var/www/drupal/manegg/main/web
  uri: 'https://main.manegg.drupal.mobimo.lakedrops.com'
  host: drupal.mobimo.lakedrops.com
  user: danielspeicher
'@stage.test':
  root: /var/www/drupal/manegg/develop/web
  uri: 'https://test.manegg.drupal.mobimo.lakedrops.com'
  host: drupal.mobimo.lakedrops.com

    Designs

      Child items ...

      2. Activity

      • danielspeicher assigned to @jurgenhaas

        assigned to @jurgenhaas

      • jurgenhaas added Doing label

        added Doing label

      • jurgenhaas
        jurgenhaas @jurgenhaas ·
        Owner

        That looks all OK and should work. Note: Drush Aliases (drush sa) are not used for this new mechanism.

        What version of L3D is installed at your end?

        For further debugging, please edit the download file: nano /usr/local/bin/download and change in line 15 the DEBUG=no to DEBUG=yes. Then run a live pull-sql again and see what commands it executes when communicating with the GitLab API. That may help you finding out what's wrong.

        Note: this will grab the DB from live, but you probably want to grab it from the stage, then you need to call a current pull-sql.

      • jurgenhaas assigned to @danielspeicher and unassigned @jurgenhaas

        assigned to @danielspeicher and unassigned @jurgenhaas

      • danielspeicher
        danielspeicher @danielspeicher ·
        Author Owner

        L§D Version 2.5.5

      • danielspeicher
        danielspeicher @danielspeicher ·
        Author Owner

        With debug on:

        Find project ID from remote URL ...
curl --write-out \nHTTP-Code:%{http_code} -X GET -s -H Private-Token: glpat-9iRXiSUMqhFWJGz5yCkZ https://gitlab.lakedrops.com/api/v4/projects?search_namespaces=1&search=mobimo/portals/manegg
[{"id":508,"description":"https://www.zhil-manegg.ch - [Test-Stage](https://develop-manegg.maweb1.lakedrops.com)","name":"Manegg","name_with_namespace":"Mobimo / Portals / Manegg","path":"manegg","path_with_namespace":"mobimo/portals/manegg","created_at":"2021-03-15T10:20:34.338Z","default_branch":"main","tag_list":[],"topics":[],"ssh_url_to_repo":"git@gitlab.lakedrops.com:mobimo/portals/manegg.git","http_url_to_repo":"https://gitlab.lakedrops.com/mobimo/portals/manegg.git","web_url":"https://gitlab.lakedrops.com/mobimo/portals/manegg","readme_url":null,"avatar_url":null,"forks_count":0,"star_count":1,"last_activity_at":"2022-07-06T12:52:10.904Z","namespace":{"id":394,"name":"Portals","path":"portals","kind":"group","full_path":"mobimo/portals","parent_id":380,"avatar_url":null,"web_url":"https://gitlab.lakedrops.com/groups/mobimo/portals"},"container_registry_image_prefix":"registry.lakedrops.com/mobimo/portals/manegg","_links":{"self":"https://gitlab.lakedrops.com/api/v4/projects/508","issues":"https://gitlab.lakedrops.com/api/v4/projects/508/issues","merge_requests":"https://gitlab.lakedrops.com/api/v4/projects/508/merge_requests","repo_branches":"https://gitlab.lakedrops.com/api/v4/projects/508/repository/branches","labels":"https://gitlab.lakedrops.com/api/v4/projects/508/labels","events":"https://gitlab.lakedrops.com/api/v4/projects/508/events","members":"https://gitlab.lakedrops.com/api/v4/projects/508/members","cluster_agents":"https://gitlab.lakedrops.com/api/v4/projects/508/cluster_agents"},"packages_enabled":false,"empty_repo":false,"archived":false,"visibility":"private","resolve_outdated_diff_discussions":false,"container_expiration_policy":{"cadence":"1d","enabled":false,"keep_n":10,"older_than":"90d","name_regex":".*","name_regex_keep":null,"next_run_at":"2021-03-16T10:20:34.366Z"},"issues_enabled":true,"merge_requests_enabled":true,"wiki_enabled":false,"jobs_enabled":true,"snippets_enabled":false,"container_registry_enabled":false,"service_desk_enabled":true,"service_desk_address":"devop+mobimo-portals-manegg-508-issue-@gitlab.lakedrops.com","can_create_merge_request_in":true,"issues_access_level":"enabled","repository_access_level":"enabled","merge_requests_access_level":"enabled","forking_access_level":"disabled","wiki_access_level":"disabled","builds_access_level":"enabled","snippets_access_level":"disabled","pages_access_level":"private","operations_access_level":"disabled","analytics_access_level":"disabled","container_registry_access_level":"disabled","security_and_compliance_access_level":"disabled","emails_disabled":false,"shared_runners_enabled":true,"lfs_enabled":true,"creator_id":216,"import_url":null,"import_type":null,"import_status":"none","open_issues_count":19,"ci_default_git_depth":50,"ci_forward_deployment_enabled":true,"ci_job_token_scope_enabled":false,"ci_separated_caches":true,"public_jobs":true,"build_timeout":3600,"auto_cancel_pending_pipelines":"enabled","build_coverage_regex":null,"ci_config_path":"","shared_with_groups":[],"only_allow_merge_if_pipeline_succeeds":false,"allow_merge_on_skipped_pipeline":null,"restrict_user_defined_variables":false,"request_access_enabled":true,"only_allow_merge_if_all_discussions_are_resolved":false,"remove_source_branch_after_merge":true,"printing_merge_request_link_enabled":true,"merge_method":"merge","squash_option":"default_off","enforce_auth_checks_on_uploads":true,"suggestion_commit_message":null,"merge_commit_template":null,"squash_commit_template":null,"auto_devops_enabled":false,"auto_devops_deploy_strategy":"continuous","autoclose_referenced_issues":true,"repository_storage":"default","keep_latest_artifact":true,"runner_token_expiration_interval":null,"permissions":{"project_access":null,"group_access":null}}] HTTP-Code:200
Find pipeline trigger token ...
curl --write-out \nHTTP-Code:%{http_code} -X GET -s -H Private-Token: glpat-9iRXiSUMqhFWJGz5yCkZ https://gitlab.lakedrops.com/api/v4/projects/508/triggers
[{"id":42,"token":"9fb9","description":"Config Auto Export","created_at":"2021-04-27T06:59:55.263Z","updated_at":"2021-04-27T06:59:55.263Z","last_used":"2022-07-06T13:25:32.805Z","owner":{"id":2,"username":"jurgenhaas","name":"Jürgen Haas","state":"active","avatar_url":"https://gitlab.lakedrops.com/uploads/-/system/user/avatar/2/avatar.png","web_url":"https://gitlab.lakedrops.com/jurgenhaas"}}] HTTP-Code:200
Trigger pipeline ...
curl --write-out \nHTTP-Code:%{http_code} -X POST -s -H Private-Token: glpat-9iRXiSUMqhFWJGz5yCkZ https://gitlab.lakedrops.com/api/v4/projects/508/trigger/pipeline --data token=9fb9 --data ref=feature/phase3 --data variables[TRIGGERTASK]=CollectDatabase --data variables[TRIGGER_INPUT]=feature/phase3
{"message":"404 Not Found"} HTTP-Code:404
POST request to projects/508/trigger/pipeline did not succeed! Responds with code 404 instead of 201
 [success] Cache rebuild complete.

 // Import the split config configuration?: yes.                                                                        

 There are no changes to import.
      • jurgenhaas
        jurgenhaas @jurgenhaas ·
        Owner

        Oh, that's interesting. Lines 4-6 are causing an unexpected issue:

        Find pipeline trigger token ...
curl --write-out \nHTTP-Code:%{http_code} -X GET -s -H Private-Token: glpat-9iRXiSUMqhFWJGz5yCkZ https://gitlab.lakedrops.com/api/v4/projects/508/triggers
[{"id":42,"token":"9fb9","description":"Config Auto Export","created_at":"2021-04-27T06:59:55.263Z","updated_at":"2021-04-27T06:59:55.263Z","last_used":"2022-07-06T13:25:32.805Z","owner":{"id":2,"username":"jurgenhaas","name":"Jürgen Haas","state":"active","avatar_url":"https://gitlab.lakedrops.com/uploads/-/system/user/avatar/2/avatar.png","web_url":"https://gitlab.lakedrops.com/jurgenhaas"}}] HTTP-Code:200

        This is looking for the token in the project which will be used to trigger a pipeline in that project. This token is owned by myself and when I call that, I get a 30 character long token value. If the same is requested by another maintainer of the project, only the first 4 characters are returned. I'll go and see if and how this can be resolved.

      • jurgenhaas mentioned in commit docker/gitlab-drupal-ci@c293521f

        mentioned in commit docker/gitlab-drupal-ci@c293521f

      • jurgenhaas
        jurgenhaas @jurgenhaas ·
        Owner

        @danielspeicher this should now be solved with L3D v2.5.6

      • danielspeicher
        danielspeicher @danielspeicher ·
        Author Owner

        @jurgenhaas Works like a charm

      • danielspeicher closed

        closed

      Please register or sign in to reply