Issues with Docker approach

[Guest]

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

[ben]

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.