Welcome to the Inedo Forums! Check out the Forums Guide for help getting started.

If you are experiencing any issues with the forum software, please visit the Contact Form on our website and let us know!

Issues with Docker approach



  • Hi,

    Following this guide:
    https://inedo.com/support/kb/1100/getting-started-with-proget-for-linux

    The first time i run proget container i get:
    20. Add new ADUserDirectory.sql failed: 42601: syntax error at or near "IF"

    Then the container exits.

    Then I get this error in Postgres container:
    LOG: database system was shut down at 2017-11-07 14:00:01 UTC
    LOG: MultiXact member wraparound protections are now enabled
    LOG: database system is ready to accept connections
    LOG: autovacuum launcher started
    ERROR: syntax error at or near "IF" at character 1
    STATEMENT: IF NOT EXISTS(SELECT * FROM "UserDirectories" WHERE "UserDirectory_Id" = 4) THEN

        INSERT INTO "UserDirectories" ("UserDirectory_Id", "UserDirectory_Name", "UserDirectory_Configuration")
        VALUES (
            4,
            'Active Directory (New)',
            XML '<Inedo.Extensions.UserDirectories.ADUserDirectory Assembly="InedoCore"><Properties /></Inedo.Extensions.UserDirectories.ADUserDirectory>'
        )
    

    If proget is restarted, it seems to work, but another error in postgres container is logged:
    ERROR: function ChunkedUploads_GetUploads(@Feed_Id => integer, session_user_name => text) does not exist at character 15
    HINT: No function matches the given name and argument types. You might need to add explicit type casts.
    STATEMENT: SELECT * FROM "ChunkedUploads_GetUploads"("@Feed_Id" := $1,"session_user_name" := $2)

    But, it seems that it works after the second reboot.

    Hope this is useful for you.

    Tore

    Product: ProGet
    Version: 4.8.7


  • inedo-engineer

    Hello Tore,

    I've fixed the 'syntax error at or near "IF"' error for future versions of ProGet on Linux, but that specific change script failing should not cause any problems. If you want to use the new AD user directory, you can add it on /administration/security/manage-directories.

    I've filed the missing ChunkedUploads_* functions as PG-1142. They are missing from the Linux version of ProGet. I'll check to see if any other functions are missing.


Log in to reply
 

Inedo Website HomeSupport HomeCode of ConductForums GuideDocumentation