Click or drag to resize

Config

Store all configuration of AskiaPortal and optionally of modules.

`Config` table.

Name

Type

Description

ModuleGuid

UNIQUEIDENTIFIER NOT NULL

Define for which module the config belongs to.

Key

NVARCHAR(50) NOT NULL

Key of the configuration.

The default AskiaPortal keys available through the enumerator AskiaPortalCmn.ConfigurationConfigKey are:

"DatabaseVersion"

Version of the current database format

"DatabaseState"

State of the database ('installing', 'installed', 'ready')

"ConfigTimestamp"

Timestamp of the last config update.

"InstanceGuid"

Identifier of the AskiaPortal instance

"InstanceData"

Encrypted information of the AskiaPortal instance

"InstanceUsage"

Encrypted information about the instance usage

"LicensesUsage"

Encrypted information about the current licenses usage

"AskiaLicenseUrl"

URL to reach the AskiaLicense server

"AskiaPortalRootUrl"

URL to reach the root of the AskiaPortal web application

"EncryptionKey"

Internal key to encrypt messages

"UserKeyTimeoutInHour"

Timeout of user key (encrypted string to activate account, reset password...)

"DefaultGroupId"

Id of the group to use when creating or register a new user

"DefaultUserProfileId"

Id of the user profile to use when creating or register a new user

"DefaultModuleGuid"

GUID of the module to use when creating or register a new user

"DefaultLanguageId"

Id of the language to use when creating a new user

"DefaultSmtpServerId"

Id of the SMTP server to use by default

"EmailSenderDisplayName"

Display name of the email sender

"EmailSenderAddress"

Address of the email sender (reply to)

"EmailDisplayNameFormat"

Display name format to send email, default:

{{User.FirstName}} {{User.LastName}}

"AllowSelfAccountRegistration"

"True" if the user is allowed to self register his account

"AllowSelfAccountActivation"

"True" if the user is allowed to self activate his account

"ActivateAccountEmailId"

Id of the email to activate an account

"ResetPasswordEmailId"

Id of the email to reset a password

"SessionTimeoutInMin"

Session timeout in minutes (<= 0 mean unlimited)

"MaxSessionLifeTimeInHour

Maximum life time of a session in hours (<= 0 mean unlimited)

"MinPasswordLength"

Minimum allowed password length

"PasswordChangedEmailId"

Id of the email to send after the modification of the user password

"PasswordResetFrequencyInMonth"

Period of time after which the user must change his password. Zero means that user would never be asked to do so.

"AllowedImagesExtensions"

List of allowed images extensions as a glob format (eg. *.png,*.jpg,*.jpeg)

"MaxImagesFileSizeInKb"

Maximum file size of images in kilobytes.

"AskiaPortalEventsDatabase"

Connection string of the AskiaPortalEvents Database.

"VerboseLog"

Defines the level of the log verbosity. If value is true than the logs includes also the Log.Debug entries.

"LogPath"

Defines the path to the logs.

"MessageBrokerHostName"

Defines the host name to the message broker (RabbitMQ).

"MessageBrokerUserName"

Defines the user name to connect on the message broker (RabbitMQ).

"MessageBrokerPassword"

Defines the user password to connect on the message broker (RabbitMQ).

"MessageBrokerVirtualHost"

Defines the virtual host to connect on the message broker (RabbitMQ).

"DatabaseState"

Defines the state of the database from (installing to ready).

Type

INT NOT NULL

Indicates the type of the value

  • 0 : String

  • 1 : Boolean

  • 2 : Integer

  • 3 : Double

  • 4 : GUID

  • 5 : EncryptedString

Reference

INT NOT NULL

Indicates which entity is referenced by the configuration key.

  • 0: None

  • 1: Language

  • 2: Group

  • 3: Module

  • 4: Email

  • 5: UserProfile

  • 6: Server

Value

NVARCHAR(MAX) NOT NULL

Value associated with the key.

Serialized as string

See Also