I am trying to build a docker container with Origam server 2025.5 using a connection to a PostgreSQL database. The standard variables used in the .env file fill the values of the DataConnectionString element for DatabaseType=mssql.
OrigamSettings__DatabaseHost={ip address of your db}
OrigamSettings__DatabasePort=1433
OrigamSettings__DatabaseUsername={your db user}
OrigamSettings__DatabasePassword={your db password}
OrigamSettings__DatabaseName={your db name}
When using it for DatabaseType=pgsql, I end up wit the following error, similar to Can't connect to PostgreSQL db from Architect. What should be the correct setup? Or is a custom build needed?
2025-05-30 14:02:47,648 [1] FATAL Microsoft.AspNetCore.Hosting.Diagnostics - Application startup exception
System.ArgumentException: Couldn't set data source (Parameter 'data source')
---> System.Collections.Generic.KeyNotFoundException: The given key was not present in the dictionary.
at Npgsql.NpgsqlConnectionStringBuilder.GeneratedSetter(String keyword, Object value)
at Npgsql.NpgsqlConnectionStringBuilder.set_Item(String keyword, Object value)
--- End of inner exception stack trace ---
at Npgsql.NpgsqlConnectionStringBuilder.set_Item(String keyword, Object value)
at System.Data.Common.DbConnectionStringBuilder.set_ConnectionString(String value)
at Npgsql.NpgsqlConnectionStringBuilder..ctor(String connectionString)
at Npgsql.NpgsqlConnection.SetupDataSource()
at Npgsql.NpgsqlConnection.set_ConnectionString(String value)
at Npgsql.NpgsqlConnection..ctor(String connectionString)
at Origam.DA.Service.PgSqlDataService.GetConnection(String connectionString) in D:\a\1\s\backend\Origam.DA.Service\PgSqlDataService.cs:line 66
at Origam.DA.Service.AbstractSqlDataService.DiagnoseConnection() in D:\a\1\s\backend\Origam.DA.Service\AbstractSqlDataService.cs:line 226
at Origam.OrigamEngine.OrigamEngine.ConnectRuntime(String configName, Boolean runRestartTimer, Boolean loadDeploymentScripts, IRuntimeServiceFactory customServiceFactory) in D:\a\1\s\backend\Origam.OrigamEngine\OrigamEngine.cs:line 133
at Origam.Server.OrigamUtils.ConnectOrigamRuntime(ILoggerFactory loggerFactory, Boolean reloadModelWhenFilesChangesDetected) in D:\a\1\s\backend\Origam.Server\OrigamUtils.cs:line 39
at Origam.Server.Startup.Configure(IApplicationBuilder app, IWebHostEnvironment env, ILoggerFactory loggerFactory) in D:\a\1\s\backend\Origam.Server\Startup.cs:line 388
at System.RuntimeMethodHandle.InvokeMethod(Object target, Void** arguments, Signature sig, Boolean isConstructor)
at System.Reflection.MethodBaseInvoker.InvokeDirectByRefWithFewArgs(Object obj, Span`1 copyOfArgs, BindingFlags invokeAttr)
at System.Reflection.MethodBaseInvoker.InvokeWithFewArgs(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture)
at Microsoft.AspNetCore.Hosting.ConfigureBuilder.Invoke(Object instance, IApplicationBuilder builder)
at Microsoft.AspNetCore.Hosting.ConventionBasedStartup.Configure(IApplicationBuilder app)
at Microsoft.AspNetCore.Hosting.WebHost.BuildApplication()