Encrypted CN - in appsettings.json #7517

deltavision created 5 years ago

Hi,

when you have a tenant with a separate database - the connection string to the tenant database is stored encrypted in the host->tenant table.

Is it possible to use the same kind of encryption in the appsettings.json file?

And if possible - how to encrypt the CN ?

E.g.

Thanks

0

musa.demir created 5 years ago

Where do you want to store decrypted string?
0

deltavision created 5 years ago

Hi,

don't wish to store the decrypted CN string - just want to be able to create an encypted CN string (from normal CN)

And then ANZ load/connect should decrypt the encrypted string - to the "real" CN.
0

musa.demir created 5 years ago

As i know its not implemented. You can override IConnectionStringResolver. See: https://github.com/aspnetboilerplate/aspnetboilerplate/blob/dev/src/Abp.Zero.EntityFramework/Zero/EntityFramework/DbPerTenantConnectionStringResolver.cs

You can also create an issue on github.
0

deltavision created 5 years ago

Thank you - for input.

Closing the case.
0

leonkosak created 5 years ago

If connection string in appsettings.json would be encrypted for host database, how can system admin encrypt changed connection string and replace old one? For tenant it's simple, because C# logic makes encryption and decryption logic.
0

deltavision created 5 years ago

Hi,

you would need a tool / function to create the encrypted string from the "real" connection string

Have an answer to this question? Log in and write your answer.