Exception while importing certificate to postgres DB

[OlehKhitrin]

I'm trying to use postgres for certificates posession. When I import certificate, I receive a "System.InvalidOperationException".
Message: "@algorithms' must have its value set"
StackTrace:
at Npgsql.NpgsqlParameter.ResolveHandler(TypeHandlerRegistry registry)
at Npgsql.NpgsqlParameter.Bind(TypeHandlerRegistry registry)
at Npgsql.NpgsqlCommand.ValidateParameters()
at Npgsql.NpgsqlCommand.Execute(CommandBehavior behavior)
at Npgsql.NpgsqlCommand.ExecuteNonQueryInternal()
at Npgsql.NpgsqlCommand.ExecuteNonQuery()
at MimeKit.Cryptography.X509CertificateDatabase.Add(X509CertificateRecord record)
at MimeKit.Cryptography.DefaultSecureMimeContext.Import(X509Certificate certificate)
Does anybody know how to fix it?

[jstedfast]

MimeKit created the table to allow null values in the ALGORITHMS column, but apparently Postgres is a bit stricter than the other SQL-backends which work fine.

Could you grab the latest source code, compile it, and check that it works for you now?

If it does, I'll make a new nuget release this weekend (or as soon as I hear back from you that this fixes things).

[OlehKhitrin]

Hello, it didn't help. After your fix I started to receive an error "Parameter '@privatekey' must have its value set". I substituted string №411 in SqlCertificateDatabase with command.AddParameterWithValue(variable, value ?? DBNull.Value); It worked for me. 2017-03-09 15:40 GMT+02:00 Jeffrey Stedfast <notifications@github.com>:

…

MimeKit created the table to allow null values in the ALGORITHMS column, but apparently Postgres is a bit stricter than the other SQL-backends which work fine. Could you grab the latest source code, compile it, and check that it works for you now? If it does, I'll make a new nuget release this weekend (or as soon as I hear back from you that this fixes things). — You are receiving this because you authored the thread. Reply to this email directly, view it on GitHub <#286 (comment)>, or mute the thread <https://github.com/notifications/unsubscribe-auth/AQmYAkJ772o6dEM_3wPfiNkWlI1fF22Yks5rkAFZgaJpZM4MXwbj> .

[jstedfast]

Try that.

[OlehKhitrin]

Recent changes work good. Could you roll out a new version in nuget? 2017-03-09 19:54 GMT+02:00 Jeffrey Stedfast <notifications@github.com>:

…

Try that. — You are receiving this because you authored the thread. Reply to this email directly, view it on GitHub <#286 (comment)>, or mute the thread <https://github.com/notifications/unsubscribe-auth/AQmYAk77TWauWfYoalewBoDlRTzt0yvIks5rkDzvgaJpZM4MXwbj> .

[jstedfast]

I'll push out a new release this weekend. Thanks for verifying the fix!