Navigation

    Inedo Community Forums

    Forums

    • Login
    • Search
    • Categories
    • Recent
    • Tags
    • Popular
    • Users
    • Groups
    1. Home
    2. thomas_3037
    T
    • Profile
    • Following
    • Followers
    • Topics
    • Posts
    • Best
    • Groups

    thomas_3037

    @thomas_3037

    0
    Reputation
    3
    Posts
    1
    Profile views
    0
    Followers
    0
    Following
    Joined Last Online

    thomas_3037 Follow

    Best posts made by thomas_3037

    This user hasn't posted anything yet.

    Latest posts made by thomas_3037

    • RE: proget 500 Internal server error when pushing to a proget docker feed

      I dump the schema from the Database. The Function looks nearly identical. Only the varchar sizes are different.

      CREATE FUNCTION public."DockerBlobs_CreateOrUpdateBlob"("@Feed_Id" integer, "@Blob_Digest" character varying, "@Blob_Size" bigint, "@MediaType_Name" character varying DEFAULT NULL::character varying, "@Cached_Indicator" boolean DEFAULT 
      NULL::boolean, "@Download_Count" integer DEFAULT NULL::integer, "@DockerBlob_Id" integer DEFAULT NULL::integer) RETURNS integer
          LANGUAGE plpgsql
          AS $$
      BEGIN
      
          SELECT "DockerBlob_Id"
            INTO "@DockerBlob_Id"
            FROM "DockerBlobs"
           WHERE ("Feed_Id" = "@Feed_Id" OR ("Feed_Id" IS NULL AND "@Feed_Id" IS NULL))
             AND "Blob_Digest" = "@Blob_Digest";
      
          WITH updated AS
          (
              UPDATE "DockerBlobs"
                 SET "Blob_Size" = "@Blob_Size",
                     "MediaType_Name" = COALESCE("@MediaType_Name", "MediaType_Name"),
                     "Cached_Indicator" = COALESCE("@Cached_Indicator", "Cached_Indicator")
               WHERE ("Feed_Id" = "@Feed_Id" OR ("Feed_Id" IS NULL AND "@Feed_Id" IS NULL)) 
                 AND "Blob_Digest" = "@Blob_Digest"
              RETURNING *
          )        
          INSERT INTO "DockerBlobs"
          (
              "Feed_Id",
              "Blob_Digest",
              "Download_Count",
              "Blob_Size",
              "MediaType_Name",
              "Cached_Indicator"
          )
          SELECT
              "@Feed_Id",
              "@Blob_Digest",
              COALESCE("@Download_Count", 0),
              "@Blob_Size",
              "@MediaType_Name",
              COALESCE("@Cached_Indicator", 'N')
          WHERE NOT EXISTS (SELECT * FROM updated)
          RETURNING "DockerBlob_Id" INTO "@DockerBlob_Id";
      
          RETURN "@DockerBlob_Id";
      
      END $$;
      

      and the table schema

      proget=# \d "DockerBlobs"
                                           Table "public.DockerBlobs"
             Column       |           Type           | Collation | Nullable |           Default            
      --------------------+--------------------------+-----------+----------+------------------------------
       Feed_Id            | integer                  |           |          | 
       Blob_Digest        | character varying(128)   |           | not null | 
       Download_Count     | integer                  |           | not null | 
       LastRequested_Date | timestamp with time zone |           |          | 
       Blob_Size          | bigint                   |           | not null | 
       Cached_Indicator   | boolean                  |           | not null | 
       MediaType_Name     | character varying(255)   |           |          | 
       DockerBlob_Id      | integer                  |           | not null | generated always as identity
       LastScan_Date      | timestamp with time zone |           |          | 
      Indexes:
          "PK__DockerBlobs" PRIMARY KEY, btree ("DockerBlob_Id")
          "IX__DockerBlobs__Blob_Digest" btree ("Blob_Digest")
          "UQ__DockerBlobs" UNIQUE CONSTRAINT, btree ("Feed_Id", "Blob_Digest")
      Foreign-key constraints:
          "FK__DockerBlobs__Feeds" FOREIGN KEY ("Feed_Id") REFERENCES "Feeds"("Feed_Id") ON DELETE CASCADE
      Referenced by:
          TABLE ""DockerImageLayers"" CONSTRAINT "FK__DockerBlobIndex__DockerBlobs" FOREIGN KEY ("DockerBlob_Id") REFERENCES "DockerBlobs"("DockerBlob_Id") ON DELETE CASCADE
          TABLE ""DockerBlobInfos"" CONSTRAINT "FK__DockerBlobInfos__DockerBlobs" FOREIGN KEY ("DockerBlob_Id") REFERENCES "DockerBlobs"("DockerBlob_Id") ON DELETE CASCADE
          TABLE ""DockerBlobPackages"" CONSTRAINT "FK__DockerBlobPackages__DockerBlobs" FOREIGN KEY ("DockerBlob_Id") REFERENCES "DockerBlobs"("DockerBlob_Id") ON DELETE CASCADE
          TABLE ""DockerImages"" CONSTRAINT "FK__DockerImages__DockerBlobs" FOREIGN KEY ("ContainerConfigBlob_Id") REFERENCES "DockerBlobs"("DockerBlob_Id") ON DELETE CASCADE
      
      posted in Support
      T
      thomas_3037
    • RE: proget 500 Internal server error when pushing to a proget docker feed

      Hey Fritz,

      a colleague find out that the parameter "--compression-format zstd:chunked" in the podman push command helped.

      You can also set this option globally.

      # cat ~/.config/containers/containers.conf 
      [engine]
      compression_format = "zstd:chunked"
      

      Its a workaround, but it helped.

      Thanks,
      Marc

      posted in Support
      T
      thomas_3037
    • Debian flat repository format

      Hi,

      has someone used a debian connector with a debian repository which is in flat repository format
      (described here https://wiki.debian.org/DebianRepository/Format#Flat_Repository_Format )

      I would too use a repository which came from opensuse build service (https://ftp.gwdg.de/pub/opensuse/repositories/home:/alvistack/Debian_12/). The feed always reported a 404 error.

      In the connector i configured ./ as distribution. On an debian server it worked.

      Thanks
      Marc

      posted in Support
      T
      thomas_3037