Overview
In FineReport 11.0, settings such as report configurations, data connections, permission settings, and widgets are saved to the corresponding configuration tables in FineDB.
This document summarizes the database tables used for storing platform-related settings and some configuration items that cannot be configured directly on the platform.
Most platform configuration items are stored in the FINE_CONF_ENTITY table in FineDB.
For details about other table structures, see FineDB Table Structure.
Directory Management
| Setting Item | Description | Database Table |
|---|---|---|
Platform Homepage | Default homepage and custom homepage | FINE_HOMEPAGE_EXPAND |
Platform Directory | Platform directory | FINE_AUTHORITY_OBJECT |
Frequently Used Settings and Help | Frequently used settings and help that appear when you click System Management without entering a specific subdirectory | JAR file |
User Management
For details about most user management settings, see the "User-Department Position-Role" section in FineDB Table Structure.
| Setting Item | Description | Database Table | Field ID | Field Value | Note |
|---|---|---|---|---|---|
User Synchronization Dataset | System Management > User Management > Synchronize User | FINE_CONF_ENTITY | UserDataSetConfig.dataSetName | User information table | Dataset name |
UserDataSetConfig.departmentColumn | -1 | Department column | |||
UserDataSetConfig.departmentIdColumn | -1 | Department ID column | |||
UserDataSetConfig.emailColumn | -1 | Email column | |||
UserDataSetConfig.mobileColumn | -1 | Mobile column | |||
UserDataSetConfig.passwordColumn | 2 | Password column | |||
UserDataSetConfig.postColumn | -1 | Position column | |||
UserDataSetConfig.postIdColumn | -1 | Position ID column | |||
UserDataSetConfig.rate | 43200 | Synchronization frequency | |||
UserDataSetConfig.realNameColumn | 1 | Name column | |||
UserDataSetConfig.roleColumn | -1 | Role column | |||
UserDataSetConfig.roleIdColumn | -1 | Role ID column | |||
UserDataSetConfig.turnOn | TRUE | Whether to enable the function | |||
UserDataSetConfig.userIdColumn | -1 | User ID column | |||
UserDataSetConfig.usernameColumn | 0 | Username column | |||
Built-in Authentication | System Management > User Management > Global Setting > Authentication Method > Built-in Authentication | / | / | / | There is no dedicated field for this configuration. After switching from the default built-in authentication to another authentication method, you can switch back by deleting the fields that correspond to that method. |
LDAP Authentication | System Management > User Management > Global Setting > Authentication Method > LDAP Authentication | FINE_CONF_ENTITY | FSConfig.passport.ldapUrl | URL | |
FSConfig.passport.ldapSearchBase | Search base | ||||
FSConfig.passport.retrieveLocAsBaseDN | true/false | Whether to exclude the search base as the base DN | |||
FSConfig.passport.authentication | Authentication method | ||||
FSConfig.passport.contextFactory | Context factory | ||||
FSConfig.passport.referral | Referral | ||||
FSConfig.passport.principalSuffix | Username suffix | ||||
FSConfig.passport.ldapSystemName | Administrator name | ||||
FSConfig.passport.ldapSystemPassword | Administrator name | ||||
HTTP Authentication | System Management > User Management > Global Setting > Authentication Method > HTTP Authentication | FINE_CONF_ENTITY | FSConfig.passport.publicKey | Public key | |
FSConfig.passport.url | Authentication address | ||||
Email Notification After Adding User | System Management > User Management > Global Setting > Email Notification After Adding User | FINE_CONF_ENTITY | UserRemindConfig.emailRemindAfterAddUser | true/false | |
Email Notification After Resetting Password | System Management > User Management > Global Setting > Email Notification After Resetting Password | FINE_CONF_ENTITY | UserRemindConfig.emailRemindAfterResetPassword | true/false |
Permission Management
For details about most permission management settings, see the "Permission-Directory" section in FineDB Table Structure.
| Setting Item | Description | Database Table | Field ID | Field Value |
|---|---|---|---|---|
Hierarchical Authorization | System Management > Permission Management > Global Setting > Hierarchical Authorization | FINE_CONF_ENTITY | FSConfig.authorizeAttr.gradeAuthority | true/false |
Directory Edit Permission | System Management > Permission Management > Global Setting > Directory Edit | FINE_CONF_ENTITY | FSConfig.authorizeAttr.editReportAuthority | true/false |
Data Connection Control | System Management > Permission Management > Global Setting > Data Connection Control | FINE_CONF_ENTITY | FSConfig.authorizeAttr.dataConnectionAuthority | true/false |
Appearance Configuration
| Setting Item | Description | Database Table | Field ID | Field Value | Note |
|---|---|---|---|---|---|
Login Method | System Management > Appearance Configuration > Login Page > Login Method | FINE_CONF_ENTITY | AppearanceConfig.loginType | 0 | 0 indicates the default login page plugin is used; 1 indicates a custom login page is configured. |
AppearanceConfig.loginUrl | Field that stores the login address for a custom login page | ||||
Login Title | System Management > Appearance Configuration > Login Page > Login Title | FINE_CONF_ENTITY | AppearanceConfig.loginTitle | ||
Login Logo | System Management > Appearance Configuration > Login Page > Login Logo | FINE_CONF_ENTITY | AppearanceConfig.loginLogoImgId | Cache ID generated after the logo is uploaded If you delete this row, the default login logo will be restored. | |
AppearanceConfig.loginLogoImgName | Logo file name, including the extension | ||||
AppearanceConfig.images.MapCachexxxxx | The cache timestamp in the field ID differs depending on the configured logo image. | ||||
Display Brand Info | System Management > Appearance Configuration > Login Page > Display Brand Info | FINE_CONF_ENTITY | AppearanceConfig.copyrightInfoDisplay | true/false | The default value is true. |
Login Theme Color | System Management > Appearance Configuration > Login Page > Login Theme Color | FINE_CONF_ENTITY | AppearanceConfig.loginColor | ||
Login Style | System Management > Appearance Configuration > Login Page > Login Style | FINE_CONF_ENTITY | AppearanceConfig.loginPageId | The field is available after a login style plugin is installed. Otherwise, only the default login style is displayed. | |
Background Image | System Management > Appearance Configuration > Login Page > Background Image | FINE_CONF_ENTITY | AppearanceConfig.loginImg | true/false | true indicates a custom background is used; false indicates the default background is used. |
AppearanceConfig.loginImgId | Cache ID generated after the background image is uploaded | ||||
AppearanceConfig.images.MapCachexxxxx | login_bg | The cache timestamp in the field ID differs depending on the configured background image. | |||
Platform Theme | System Management > Appearance Configuration > Platform Theme | FINE_CONF_ENTITY | AppearanceConfig.themeId | modern/classic | modern: flat style classic: classic style |
Platform Title | System Management > Appearance Configuration > Platform Style > Platform Title | FINE_CONF_ENTITY | AppearanceConfig.platformTitle | ||
Platform Logo | System Management > Appearance Configuration > Platform Style > Platform Logo | FINE_CONF_ENTITY | AppearanceConfig.logoImgId | Cache ID generated after the logo is uploaded | |
AppearanceConfig.logoImgName | Logo file name, including the extension | ||||
AppearanceConfig.images.MapCachexxxxx | The cache timestamp in the field ID differs depending on the configured logo image. | ||||
Color | System Management > Appearance Configuration > Platform Style > Color | FINE_CONF_ENTITY | AppearanceConfig.colorScheme | 0/1/2 | 0: light 1: dark 2: custom |
Frame Style > Top Heading Style | System Management > Appearance Configuration > Platform Style > Color > Custom > Top Heading Style | FINE_CONF_ENTITY | AppearanceConfig.headerType | 1/2 | 1: block-style background 2: integrated background |
Other colors in Frame Style | Other colors under System Management > Appearance Configuration > Platform Style > Color > Custom | FINE_CONF_ENTITY | AppearanceConfig.customColors | An array of six color values, ordered from top to bottom to match the color slots on the platform | |
Custom Directory Icon | System Management > Appearance Configuration > Directory Style > Directory Icon > Custom | FINE_CONF_ENTITY | AppearanceConfig.customEntryIcons | The value is an array. Its length equals the number of uploaded icons. | |
Custom Directory Cover | System Management > Appearance Configuration > Directory Style > Directory Cover > Custom | FINE_CONF_ENTITY | AppearanceConfig.customEntryCovers | The value is an array. Its length equals the number of uploaded icons. |
System Management
| Setting Item | Description | Database Table | Field ID | Field Value | Note |
|---|---|---|---|---|---|
Password | Resetting the super admin's password | FINE_CONF_ENTITY | SystemConfig.serverInit | success/fail | |
Login | System Management > System Setting > Login > Single Login Setting | FINE_CONF_ENTITY | FSConfig.loginConfig.singleLogin | true/false | |
FSConfig.loginConfig.singleLoginMode | 1/2 | 1 indicates the new login forces the existing session out. 2 indicates that the existing session blocks new logins. | |||
System Management > System Setting > Login > Last Login Prompt | FINE_CONF_ENTITY | FSConfig.loginConfig.showLastLoginInfo | true/false | ||
System Management > System Setting > Login > Login Timeout Setting | FINE_CONF_ENTITY | FSConfig.loginConfig.loginTimeout | The unit is ms. | ||
System Management > System Setting > Login > Password Policy Setting > Forgot Password | FINE_CONF_ENTITY | PasswordStrategyConfig.forgetPassword | true/false | The field does not exist by default. It appears after the function is enabled. | |
System Management > System Setting > Login > Password Policy Setting > Regular Password Update | FINE_CONF_ENTITY | PasswordStrategyConfig.passwordUpdateRegularly | true/false | The field does not exist by default. It appears after the function is enabled. | |
PasswordStrategyConfig.updateCycle | Password update cycle, in days | ||||
PasswordStrategyConfig.daysOfUpdateEarlyWarning | Number of days to remind users in advance, in days | ||||
System Management > System Setting > Login > Password Policy Setting > Password Strength Limit | FINE_CONF_ENTITY | PasswordStrategyConfig.passwordStrengthLimit | true/false | The field does not exist by default. It appears after the function is enabled. | |
PasswordStrategyConfig.passwordLength | Password length | ||||
PasswordStrategyConfig.includeNumbers | true/false | The field does not exist by default. It appears after the function is enabled. The field specifies whether numbers are required. The default value is true. | |||
PasswordStrategyConfig.includeLowercaseLetters | true/false | The field does not exist by default. It appears after the function is enabled. The field specifies whether lowercase letters are required. The default value is true. | |||
PasswordStrategyConfig.includeCapitalLetters | true/false | The field does not exist by default. It appears after the function is enabled. The field specifies whether uppercase letters are required. The default value is false. | |||
PasswordStrategyConfig.includeSymbol | true/false | The field does not exist by default. It appears after the function is enabled. The field specifies whether symbols are required. The default value is false. | |||
System Management > System Setting > Login > Password Policy Setting > Password Change Verification Method | FINE_CONF_ENTITY | PasswordStrategyConfig.emailVerificationAfterChangePassword | true/false | Whether to enable email verification | |
PasswordStrategyConfig.smsVerificationAfterChangePassword | true/false | Whether to enable SMS verification | |||
System Management > System Setting > Login > Login Authentication Setting | FINE_CONF_ENTITY | LoginVerificationConfig.sliderVerification | true/false | Whether to enable slider verification | |
LoginVerificationConfig.emailVerification | true/false | Whether to enable email verification (You need to configure the mailbox first.) | |||
LoginVerificationConfig.smsVerification | true/false | Whether to enable SMS verification (You need to configure the SMS platform first.) | |||
System Management > System Setting > Login > Login Lock | FINE_CONF_ENTITY | LoginLockConfig.lock | true/false | The default value is false. | |
LoginLockConfig.passwordErrorTimes | Allowed number of incorrect password attempts | ||||
LoginLockConfig.lockingTime | Lockout duration | ||||
LoginLockConfig.lockObject | username/ip | Lockout target | |||
LoginLockConfig.lockAdmin | true/false | Whether to lock the admin account | |||
General | System Management > System Setting > General > URL Management Center | FINE_CONF_ENTITY | CloudCenterConfig.online | true/false | |
System Management > System Setting > General > Gzip Compression | FINE_CONF_ENTITY | ServerPreferenceConfig.supportGzip | true/false | ||
System Management > System Setting > General > Servlet Path Name | FINE_CONF_ENTITY | ServerConfig.servletName | The value cannot be set to ReportServer. | ||
System Management > System Setting > General > Server Character Encoding | FINE_CONF_ENTITY | ServerConfig.serverCharset | The default value is UTF-8. | ||
/ | |||||
/ | |||||
System Management > System Setting > General > Week Start from | FINE_CONF_ENTITY | ServerPreferenceConfig.firstDayOfWeek | 0/1 | 0 indicates the week starts on Sunday. | |
System Management > System Setting > General > Use Resource Server | FINE_CONF_ENTITY | ServerPreferenceConfig.useResServer | true/false | Whether to enable the resource server | |
ServerPreferenceConfig.resServerPath | Server address | ||||
System Management > System Setting > General > WebSocket Setting | FINE_CONF_ENTITY | WebSocketConfig.usingProxy | true/false | Whether to use a proxy server | |
WebSocketConfig.requestPorts | WebSocket request port | ||||
WebSocketConfig.socketContext | WebSocket request path | ||||
System Management > System Setting > General > HTTPS Setting | FINE_CONF_ENTITY | WebSocketConfig.protocol | Server protocol | ||
WebSocketConfig.keyStore | SSL key path | ||||
WebSocketConfig.keyStorePassword | SSL key password | ||||
WebSocketConfig.keyStoreFormat | SSL certificate type | ||||
System Management > System Setting > Print > Zero Client Printing | FINE_CONF_ENTITY | PrintConfig.printSettingsAttrData.noClientPrintAttr.setMarginOnPrint | true/false | Whether to allow setting page margins for printing | |
System Management > System Setting > Print > Local Printing | FINE_CONF_ENTITY | PrintConfig.printSettingsAttrData.nativePrintAttr.showDialog | true/false | Whether to show the print setting window | |
Mailbox | System Management > System Setting > Mailbox | FINE_CONF_ENTITY | EmailServerConfig.mailHost | Email server | |
EmailServerConfig.encryption | Encryption method | ||||
EmailServerConfig.port | Port | ||||
EmailServerConfig.fromEmailAddress | Sender address | ||||
EmailServerConfig.password | Password | ||||
EmailServerConfig.user | Display name | ||||
SMS | System Management > System Setting > SMS | FINE_CONF_ENTITY | MarketConfig.smsOpen | true/false | Whether to use the SMS platform |
Task Schedule
For details about most scheduled task settings, see the "Task Schedule" section in FineDB Table Structure.
| Setting Item | Description | Database Table | Field ID | Field Value | Note |
|---|---|---|---|---|---|
| Running Failure Reminder | System Management > Task Schedule > Global Setting > SMS Reminder | FINE_CONF_ENTITY | ScheduleSettingConfig.smsChecked | true/false | |
| ScheduleSettingConfig.smsReceiver | Recipient's phone number | ||||
| System Management > Task Schedule > Global Setting > Platform Message | FINE_CONF_ENTITY | ScheduleSettingConfig.platformMessageChecked | true/false | ||
| ScheduleSettingConfig.platformMessageReceiver | Recipient | ||||
| System Management > Task Schedule > Global Setting > Email Notification | FINE_CONF_ENTITY | ScheduleSettingConfig.emailChecked | true/false | ||
| ScheduleSettingConfig.emailReceiver | Email address |
Mobile Platform
For details about most mobile platform settings, see the "Mobile Terminal" section in FineDB Table Structure.
| Setting Item | Description | Database Table | Field ID | Field Value | Note |
|---|---|---|---|---|---|
App Splash Screen | System Management > Mobile Platform > App Configuration > Animation Configuration | FINE_CONF_ENTITY | MobileConfig.phoneLaunchImgId | The field applies to mobile phones. To restore the default image after setting a custom image, delete this row. | |
MobileConfig.padLaunchImgId | The field applies to tablets. To restore the default image after setting a custom image, delete this row. | ||||
Device Binding | System Management > Mobile Platform > App Configuration > Device Binding | FINE_CONF_ENTITY | MobileConfig.mobileDeviceBinding | true/false | |
QR Code Configuration | System Management > Mobile Platform > App Configuration > Login Configuration | FINE_CONF_ENTITY | MobileConfig.qrcodeServerName | Server name | |
MobileConfig.qrcodeServerUrl | Server address | ||||
Theme | System Management > Mobile Platform > Theme | FINE_CONF_ENTITY | MobileConfig.activeTheme | You can select other themes if the theme plugin is installed. | |
Directory | System Management > Mobile Platform > Directory > Directory Structure | FINE_CONF_ENTITY | MobileConfig.entryStyleId | The field specifies the directory structure style. Additional options are available after mobile directory plugins are installed. | |
System Management > Mobile Platform > Directory > Banner | FINE_CONF_ENTITY | MobileConfig.banner.enabled | true/false | ||
System Management > Mobile Platform > Directory > Template | FINE_CONF_ENTITY | MobileConfig.template.enabled | true/false | ||
MobileConfig.template.name | Template name | ||||
MobileConfig.template.path | Template path | ||||
MobileConfig.template.position | top/bottom | Display position | |||
System Management > Mobile Platform > Directory > Directory Icon | FINE_CONF_ENTITY | MobileConfig.customIcons | The value is an array of references to custom uploaded icons. | ||
| Others | System Management > Mobile Platform > H5 Setting | FINE_CONF_ENTITY | Html5Config.isUsedJSBridge | true/false | Whether to use JSBridge |
Html5Config.jsLink | URL of the external JS file | ||||
Html5Config.cssLink | URL of the external CSS file |
Registration Management
| Setting Item | Description | Database Table | Field ID | Field Value | Note |
|---|---|---|---|---|---|
Registration | System Management > Registration Management | FINE_CONF_ENTITY | license.type | 0/1/2/3/4 | 0: local machine authentication 1: dongle authentication 2: private cloud authentication 3: online registration authentication 4: local container authentication |
license.serverAddress | Server address for private cloud authentication | ||||
license.appKey | Account name for online registration | ||||
license.appSecretKey | Account password for online registration |
Intelligent O&M
Load Management
| Setting Item | Description | Database Table | Field ID | Field Value | Note |
|---|---|---|---|---|---|
Memory Alert | System Management > Intelligent O&M > Load Management > Intelligent Alert | FINE_CONF_ENTITY | PrewarningConfig.warningOpen | true/false | |
PrewarningConfig.messageRemindOpen | true/false | Whether to enable SMS notification | |||
PrewarningConfig.phoneNumbers | Phone number | ||||
PrewarningConfig.platformMessageRemindOpen | true/false | Whether to enable platform message notification | |||
PrewarningConfig.platformMessageReceiver | Recipient | ||||
PrewarningConfig.mailRemindOpen | true/false | Whether to enable email notification | |||
PrewarningConfig.mailReceivers | Email addresses | ||||
Intelligent Release | System Management > Intelligent O&M > Load Management > Intelligent Release | FINE_CONF_ENTITY | IntelliReleaseConfig.memoryAlarmOpen | true/false | Whether to enable the intelligent release of memory occupied by reports |
IntelliReleaseConfig.message | Alert message | ||||
Template Limit | System Management > Intelligent O&M > Load Management > Template Limit > General Limit > Row Quantity Limit Per Dataset | FINE_CONF_ENTITY | TempRestrictionConfig.openRowControl | true/false | |
TempRestrictionConfig.maxDSRowCount | Maximum number of rows in a single dataset | ||||
TempRestrictionConfig.rowOverMsg | Message displayed when the limit is exceeded | ||||
System Management > Intelligent O&M > Load Management > Template Limit > General Limit > Cell Quantity Limit Per Template | FINE_CONF_ENTITY | CustomRestrictionConfig.openCellControl | true/false | ||
CustomRestrictionConfig.maxDSCellCount | Maximum number of cells in a single template | ||||
CustomRestrictionConfig.cellOverMsg | Message displayed when the limit is exceeded | ||||
System Management > Intelligent O&M > Load Management > Template Limit > General Limit > SQL Execution Period Limit | FINE_CONF_ENTITY | TempRestrictionConfig.openSQLTimeControl | true/false | ||
TempRestrictionConfig.maxSQLTime | Maximum SQL execution duration, in seconds | ||||
TempRestrictionConfig.sqlTimeOverMsg | Message displayed when the limit is exceeded | ||||
System Management > Intelligent O&M > Load Management > Template Limit > General Limit > Cell Limit During Excel Import | FINE_CONF_ENTITY | TempRestrictionConfig.openExcelImportCellCountControl | true/false | ||
TempRestrictionConfig.maxExcelImportCellCount | Maximum number of cells allowed in an imported Excel file | ||||
TempRestrictionConfig.excelImportCellCountOverMsg | Message displayed when the limit is exceeded | ||||
System Management > Intelligent O&M > Load Management > Template Limit > General Limit > Submitted Record Quantity Limit | FINE_CONF_ENTITY | TempRestrictionConfig.openCommitRowCountControl | true/false | ||
TempRestrictionConfig.openCartesianControl | true/false | Whether to allow data entry that produces a Cartesian product | |||
TempRestrictionConfig.maxCommitRowCount | Maximum number of submitted records during data entry | ||||
TempRestrictionConfig.commitRowCountOverMsg | Message displayed when the limit is exceeded | ||||
System Management > Intelligent O&M > Load Management > Template Limit > Limit Relaxation | FINE_CONF_ENTITY | RelaxationRestrictionConfig.relaxationTemps | The field value is an array of template names. Individual restrictions for specific templates mirror the general restrictions, but their field names are prefixed with RelaxationRestrictionConfig instead of TempRestrictionConfig. | ||
Crash prevention configuration | FINE_CONF_ENTITY | TempRestrictionConfig.maxDSColumnCount | If the message "The dataset contains too many columns. Reduce the number of fields to fewer than 100" is displayed, you can manually increase this parameter value. | ||
RelaxationRestrictionConfig.maxDSColumnCount | |||||
Lifecycle | System Management > Intelligent O&M > Load Management > Lifecycle | FINE_CONF_ENTITY | LifecycleConfig.lifeCycle | Sessions are cleaned up after x minutes of inactivity. |
Cluster Configuration
| Setting Item | Description | Database Table | Field ID | Field Value | Note |
|---|---|---|---|---|---|
Global Setting | System Management > Intelligent O&M > Cluster Configuration > Global Setting | FINE_CONF_ENTITY | ClusterExceptionWarningConfig.mailRemindOpen | true/false | Whether to enable email notification |
ClusterExceptionWarningConfig.mailReceivers | Email address | ||||
ClusterExceptionWarningConfig.messageRemindOpen | true/false | Whether to enable SMS notification | |||
ClusterExceptionWarningConfig.phoneNumbers | Recipient | ||||
ClusterExceptionWarningConfig.platformMessageRemindOpen | true/false | Whether to enable platform message notification | |||
ClusterExceptionWarningConfig.platformMessageReceiver | Platform message recipient | ||||
Cluster Configuration | System Management > Intelligent O&M > Cluster Configuration > Cluster Configuration | FINE_CONF_ENTITY | FineClusterConfig.params.protocol | TCP/UDP | |
Parameter Configuration | System Management > Intelligent O&M > Cluster Configuration > Parameter Configuration | FINE_CONF_ENTITY | RedisConfig.tableNamePrefix | Key prefix |
Backup & Restoration
| Setting Item | Description | Database Table | Field ID | Field Value | Note |
|---|---|---|---|---|---|
Global Setting | System Management > Intelligent O&M > Backup & Restoration > Global Setting | FINE_CONF_ENTITY | BackupConfig.backupPath | Backup path | |
BackupConfig.frequency | Backup frequency | ||||
BackupConfig.backupNumber | Maximum number of backups | ||||
BackupConfig.backupMemory | Maximum backup storage size | ||||
System Management > Intelligent O&M > Backup & Restoration | FINE_CONF_ENTITY | BackupConfig.moduleBackup | Modules to be backed up | ||
Platform Configuration | System Management > Intelligent O&M > Backup & Restoration > Platform Configuration | FINE_CONF_ENTITY | BackupConfig.moduleBackup.config.autoBackup | true/false | Whether to enable automatic backup |
BackupConfig.moduleBackup.config.moduleName | config | Module name | |||
Report Template | System Management > Intelligent O&M > Backup & Restoration > Report Template | FINE_CONF_ENTITY | BackupConfig.moduleBackup.reportlets.autoBackup | true/false | Whether to enable automatic backup |
BackupConfig.moduleBackup.reportlets.moduleName | reportlets | Module name | |||
JAR file | System Management > Intelligent O&M > Backup & Restoration > JAR Package | FINE_CONF_ENTITY | BackupConfig.moduleBackup.jar.autoBackup | true/false | Whether to enable automatic backup |
BackupConfig.moduleBackup.jar.moduleName | jar | Module name | |||
BackupConfig.moduleBackup.jar-cluster.autoBackup | true/false | Whether to enable automatic backup | |||
BackupConfig.moduleBackup.jar-cluster.moduleName | jar-cluster | Module name | |||
Plugin | System Management > Intelligent O&M > Backup & Restoration > Plugin | FINE_CONF_ENTITY | BackupConfig.moduleBackup.plugins.autoBackup | true/false | Whether to enable automatic backup |
BackupConfig.moduleBackup.plugins.moduleName | plugins | Module name | |||
Update and upgrade | System Management > Intelligent O&M > Backup & Restoration > Update/Upgrade | FINE_CONF_ENTITY | UpdatePushConfig.open | true/false | Whether to push updates automatically |
Platform Log
For details about most platform log settings, see FineDB Table Structure.
| Setting Item | Description | Database Table | Field ID | Field Value | Note |
|---|---|---|---|---|---|
Global Setting | System Management > Intelligent O&M > Platform Log > Global Setting | FINE_CONF_ENTITY | Log4jConfig.rootLevel | DEBUG/INFO/WARN/ERROR/FATAL | Log level |
LogCleanConfig.open | true/false | Whether to enable log cleanup | |||
System Management > Intelligent O&M > Platform Log > Global Setting > Auto Cleanup | FINE_CONF_ENTITY | LogCleanConfig.autoCleanTime | Auto-cleanup interval, in days | ||
LogCleanConfig.autoDataTime | Data retention period | ||||
System Management > Intelligent O&M > Platform Log > Global Setting > Manual Cleanup | FINE_CONF_ENTITY | LogCleanConfig.manualDataTime | Data retention period | ||
System Management > Intelligent O&M > Platform Log > Global Setting > Cleanup Warning | FINE_CONF_ENTITY | LogCleanConfig.cleanWarnStarted | true/false | Whether to enable cleanup warning | |
LogCleanConfig.triggerThreshold | Trigger condition | ||||
LogCleanConfig.smsChecked | true/false | Whether to enable SMS notification | |||
LogCleanConfig.smsReceiver | Recipient | ||||
LogCleanConfig.platformMessageChecked | true/false | Whether to enable platform message notification | |||
LogCleanConfig.platformMessageReceiver | An array of platform message recipients | ||||
LogCleanConfig.emailChecked | true/false | Whether to enable email notification | |||
LogCleanConfig.emailReceiver | Email address |
Cloud O&M
| Setting Item | Description | Database Table | Field ID | Note |
|---|---|---|---|---|
Cloud O&M | System Management > Intelligent O&M > Cloud O&M | FINE_CONF_ENTITY | MarketConfig.cloudOperationMaintenanceAppKey | App key |
MarketConfig.cloudOperationMaintenanceAppName | Project name | |||
MarketConfig.cloudOperationMaintenanceAppSecret | App secret | |||
MarketConfig.cloudOperationMaintenanceAutoUpload | Whether to enable auto upload | |||
MarketConfig.cloudOperationMaintenanceAvailable | Whether cloud O&M is available | |||
MarketConfig.cloudOperationMaintenanceId | App ID |
Data Connection
| Setting Item | Description | Database Table | Field ID | Field Value | Note |
|---|---|---|---|---|---|
Data Connection Permission Management | System Management > Data Connection > Data Connection Management | FINE_CONF_ENTITY | ConnectionConfig.connections | An array of all data connection names | |
ConnectionConfig.connections.XXX.url | Data connection URL | ||||
ConnectionConfig.connections.XXX.driver | Data connection driver | ||||
ConnectionConfig.connections.XXX.authentication.password | Data connection password | ||||
ConnectionConfig.connections.XXX.authentication.username | Data connection username | ||||
ConnectionConfig.connections.XXX.encryptPassword | true/false | Whether the password is encrypted. true indicates that the password is stored as ciphertext. | |||
ConnectionConfig.connections.XXX.schema | Data connection schema | ||||
ConnectionConfig.connections.XXX.creator | Platform user/designer | Creator of the data connection | |||
ConnectionConfig.connections.XXX.database | Database type | ||||
ConnectionConfig.connections.XXX.dbcpAttr.initialSize | Initial number of connections | ||||
ConnectionConfig.connections.XXX.dbcpAttr.maxActive | Maximum number of active connections | ||||
ConnectionConfig.connections.XXX.dbcpAttr.maxIdle | Maximum number of idle connections | ||||
ConnectionConfig.connections.XXX.dbcpAttr.maxWait | Maximum wait time, in milliseconds | ||||
ConnectionConfig.connections.XXX.dbcpAttr.minEvictableIdleTimeMillis | Minimum idle time before eviction, in milliseconds | ||||
ConnectionConfig.connections.XXX.dbcpAttr.minIdle | Minimum number of idle connections | ||||
ConnectionConfig.connections.XXX.dbcpAttr.numTestsPerEvictionRun | Number of idle connections to check per eviction run | ||||
ConnectionConfig.connections.XXX.dbcpAttr.testOnBorrow | true/false | Whether to validate the connection before borrowing | |||
ConnectionConfig.connections.XXX.dbcpAttr.testOnReturn | true/false | Whether to validate the connection before returning it | |||
ConnectionConfig.connections.XXX.dbcpAttr.testWhileIdle | true/false | Whether to validate idle connections during eviction runs | |||
ConnectionConfig.connections.XXX.dbcpAttr.timeBetweenEvictionRunsMillis | Sleep interval between eviction runs. Setting it to -1 disables sleep. | ||||
ConnectionConfig.connections.XXX.dbcpAttr.validationQuery | SQL validation query | ||||
ConnectionConfig.connections.XXX.newCharsetName | Encoding | ||||
ConnectionConfig.connections.XXX.originalCharsetName | Original encoding | ||||
Server Dataset | System Management > Data Connection > Server Dataset | FINE_CONF_ENTITY | TableDataConfig.tableDatas | An array of all server dataset names | |
System Management > Data Connection > Server Dataset > SQL Dataset | FINE_CONF_ENTITY | TableDataConfig.tableDatas.YYY.database.name | Data connection name | ||
TableDataConfig.tableDatas.YYY.maxMemRowCount | -1 | Maximum number of rows that can be kept in memory. The default value is -1, indicating that all rows are kept in memory. If caching to disk is configured, it takes the configured value. | |||
TableDataConfig.tableDatas.YYY.pageQuerySql | SQL pagination | ||||
TableDataConfig.tableDatas.YYY.parameters | Parameter | ||||
TableDataConfig.tableDatas.YYY.query | SQL query | ||||
TableDataConfig.tableDatas.YYY.share | true/false | Whether to enable dataset sharing | |||
System Management > Data Connection > Server Dataset > Tree Dataset | FINE_CONF_ENTITY | TableDataConfig.tableDatas.YYY.columnClassList | An array of column types | ||
TableDataConfig.tableDatas.YYY.columnNameList | An array of column names | ||||
System Management > Data Connection > Server Dataset > File Dataset | FINE_CONF_ENTITY | TableDataConfig.tableDatas.YYY.filePath | File path | ||
TableDataConfig.tableDatas.YYY.needColumnName | true/false | Whether to use the first row as column names |
Security Management
| Setting Item | Description | Database Table | Field ID | Field Value | Note |
|---|---|---|---|---|---|
Security | System Management > Security Management > Security | FINE_CONF_ENTITY | WebSecurityConfig.cacheControlEnabled | true/false | Whether to disable browser cache |
WebSecurityConfig.contentSecurityPolicyEnabled | true/false | Whether to enable CSP (Content Security Policy) | |||
WebSecurityConfig.contentTypeOptionsEnabled | true/false | Whether to enable content sniffing attack prevention | |||
WebSecurityConfig.fileVerificationEnabled | true/false | Whether to enable file upload verification | |||
WebSecurityConfig.frameOptionsEnabled | true/false | Whether to enable clickjacking attack prevention | |||
WebSecurityConfig.httpHeadersEnabled | true/false | Whether to enable HTTP security headers | |||
WebSecurityConfig.remoteEvaluateLimitEnabled | true/false | Whether to restrict script-invoked formulas | |||
WebSecurityConfig.securityCookie | true/false | Whether to enable secure cookie attributes. The function can only be enabled after HTTPS is configured for the project. | |||
WebSecurityConfig.xssProtectionEnabled | true/false | Whether to enable XSS attack prevention | |||
Access Control | System Management > Security Management > Access Control | FINE_CONF_ENTITY | WebSecurityConfig.rateLimitEnabled | true/false | Whether to enable rate limiting |
WebSecurityConfig.rateLimitUnitTime | Rate limiting time window, in seconds | ||||
WebSecurityConfig.rateLimitCount | Maximum number of accesses allowed within the time window | ||||
SQL Injection Prevention | System Management > Security Management > SQL Injection Prevention | FINE_CONF_ENTITY | PreventSqlInjConfig.useForbidWord | true/false | Whether to forbid special keywords |
PreventSqlInjConfig.useEscapeSpecialChar | true/false | Whether to escape special characters | |||
PreventSqlInjConfig.customSpecialCharList | Custom escape characters | ||||
PreventSqlInjConfig.selectedSpecialCharList | Selected escape characters | ||||
PreventSqlInjConfig.customForbidWordList | Custom forbidden keywords | ||||
PreventSqlInjConfig.selectedForbidWordList | Selected forbidden keywords | ||||
Watermark Setting | System Management > Security Management > Watermark Setting | FINE_CONF_ENTITY | WatermarkConfig.valid | true/false | Whether to enable watermark setting |
WatermarkConfig.watermarkData.textType | formula/username/ip/time | Watermark content type | |||
WatermarkConfig.watermarkData.text | Formula content, specified when the content type is formula | ||||
WatermarkConfig.watermarkData.color | Watermark color | ||||
WatermarkConfig.watermarkData.fontSize | Watermark font size | ||||
WatermarkConfig.watermarkData.horizontalGap | Horizontal watermark spacing | ||||
WatermarkConfig.watermarkData.verticalGap | Vertical watermark spacing |
Template Authentication
| Setting Item | Description | Database Table | Field ID | Field Value | Note |
|---|---|---|---|---|---|
Global setting | System Management > Template Authentication > Global Setting | FINE_CONF_ENTITY | TemplateAuthConfig.tempAuthOpen | true/false | Confirming the State of Template Authentication |
TemplateAuthConfig.tempAuthType | 0/1/2 | Template authentication method 0: authentication only with the username and password 1: authentication with the role permission 2: authentication with the digital signature | |||
TemplateAuthConfig.digitalAuthKey | Digital signature key | ||||
TemplateAuthConfig.configuredOnce | true/false | Whether template authentication has been enabled before |
Non-UI Setting Item
The following table lists properties that are recorded in the FINE_CONF_ENTITY table but cannot be configured on the platform.
| Field ID | Default Value | Description |
|---|---|---|
For JAR files dated between April 26, 2020 and June 20, 2020, use the field ID FSConfig.loginConfig.tokenFromCookie. FSConfig.loginConfig.tokenFromCookie For JAR files dated after June 20, 2020, use the field ID ServerConfig.tokenFromCookie. ServerConfig.tokenFromCookie | false | The parameter determines whether tokens can be retrieved from cookies. After this function is enabled, tokens can be retrieved from cookies during background validation, thereby resolving background SSO and cross-domain SSO failures that occur when HTTPOnly is enabled. |
WebSecurityConfig.xssProtectionHeader | 1; mode=block | Value of the X-XSS-Protection header for XSS attack prevention |
WebSecurityConfig.frameOptionsHeader | SAMEORIGIN | Value of the X-Frame-Options header for clickjacking attack prevention |
WebSecurityConfig.contentTypeOptionsHeader | nosniff | Value of the X-Content-Type-Options header for content sniffing attack prevention |
WebSecurityConfig.contentSecurityPolicyHeader | object-src 'self' | Value of the Content-Security-Policy header |
WebSecurityConfig.cacheControlHeader | no-cache | Value of the Cache-Control header for disabling browser cache |
WebSecurityConfig.cacheControlExpiresHeader | 0 | Value of the Expires header for cache control |
WebSecurityConfig.cacheControlPragmaHeader | no-cache | Value of the Pragma header for cache control |
WebSecurityConfig.hstsHeader | max-age=31536000; includeSubDomains | Value of the HSTS header Strict-Transport-Security |
BackupConfig.customValueLength | 65536 | Custom length for the Value field in the backup FINE_CONF_ENTITY table |
BackupConfig.customKeyLength | 1500 | Custom length for the ID field in the backup FINE_CONF_ENTITY table |
FSConfig.loginConfig.forceRedirectAfterLogin | false | Whether to force redirection after login. The function is disabled by default. |
SystemConfig.serverInit | "" | Whether the platform has been initialized. The value is success or fail. |
WebSocketConfig.port | [38888, 39888] | Port number |
WebSocketConfig.protocol | plain | For HTTPS servers, set the value to ssl. |
WebSocketConfig.keyStore | "" | File path (absolute path recommended). keyStore is typically used. Support for trustStore requires further verification. |
WebSocketConfig.keyStorePassword | "" | Password for the keystore |
WebSocketConfig.keyStoreFormat | JKS | The default value is JKS. For a PFX certificate, set it to PKCS12. |
WebSocketConfig.trustStore | "" | File path (absolute path recommended) |
WebSocketConfig.trustStorePassword | "" | Password for the truststore |
WebSocketConfig.trustStoreFormat | JKS | The default value is JKS. For a PFX certificate, set it to PKCS12. |
WebSocketConfig.socketContext | /socket.io | Used for modifying the WebSocket route |
ServerConfig.cookiePath | / | Cookie path. You should configure it when deploying the project. Otherwise, multiple cookies will be stored in the browser, and you must manually clear them to log in successfully. |
ScheduleSettingConfig.taskTimeout | 300000 | Scheduled task timeout, in milliseconds. The default value is 300000. |
SecurityConfig.frontSeed | Random 16-character string | Key used for front-end encryption. The initial value is a random 16-character string. You can modify it as needed. |
WebSecurityConfig.loginValidateStrict | false/true | Whether to restrict the use of the cross-origin login API and the CAS backend login API. If this parameter is set to true, these two APIs cannot be used. |
LoadConfig.minorTerribleThreshold | 0.09 | Threshold of extremely high load after a minor GC. If the ratio of objects promoted to the old generation to the size of the Eden space exceeds this threshold after a minor GC, the load is considered extremely high. |
LoadConfig.minorHighThreshold | 0.06 | Threshold of high load after a minor GC. If the ratio of objects promoted to the old generation to the size of the Eden space exceeds this threshold after a minor GC, the load is considered high. |
LoadConfig.minorMidThreshold | 0.03 | Threshold of medium load after a minor GC. If the ratio of objects promoted to the old generation to the size of the Eden space exceeds this threshold after a minor GC, the load is considered medium. |
LoadConfig.majorExtremeTerribleThreshold | 0.95 | Threshold of extreme load after a major GC. If the ratio of remaining objects in the old generation to the size of the old generation exceeds this threshold after a major GC, the load is considered extreme. |
LoadConfig.majorTerribleThreshold | 0.85 | Threshold of extremely high load after a major GC. If the ratio of remaining objects in the old generation to the size of the old generation exceeds this threshold after a major GC, the load is considered extremely high. |
LoadConfig.majorHighThreshold | 0.7 | Threshold of high load after a major GC. If the ratio of remaining objects in the old generation to the size of the old generation exceeds this threshold after a major GC, the load is considered high. |
IntelliReleaseConfig.highInterruptRate | 0.8 | During the first small-scale session termination, sessions whose cell count exceeds 80% of the template cell limit are terminated. |
IntelliReleaseConfig.highInterruptAgainRate | 0.6 | During the second small-scale session termination, sessions whose cell count exceeds 60% of the template cell limit are terminated. |
IntelliReleaseConfig.highKillRate | 0.1 | If the number of sessions terminated during the first small-scale termination is less than 10%, a second small-scale termination is performed. |
IntelliReleaseConfig.terribleInterruptRate | 0.6 | During the first large-scale session termination, sessions whose cell count exceeds 60% of the template cell limit are terminated. |
IntelliReleaseConfig.terribleInterruptAgainRate | 0.4 | During the second large-scale session termination, sessions whose cell count exceeds 40% of the template cell limit are terminated. |
IntelliReleaseConfig.terribleKillRate | 0.2 | If the number of sessions terminated during the first large-scale termination is less than 20%, a second large-scale termination is performed. |
IntelliReleaseConfig.waitInLineRate | 0.9 | Probability that this template waits in the queue when the system is under high load (90% by default) |
IntelliReleaseConfig.defaultCellCount | 1000000 | Default cell count (1,000,000) used during large or small-scale session terminations when the template cell limit is disabled |
IntelliReleaseConfig.releaseSessionInterval | 20 | If, within 20 seconds, the load after the current GC is less than or equal to that after the previous GC, no large- or small-scale session termination is performed. |
QuartzConfig.threadCount | 100 | Maximum number of threads in the scheduled task module (supported by FineReport released after August 16, 2019) |
QuartzConfig.maxConnections | 50 | Maximum number of connections in the scheduled task module (supported by FineReport released after August 16, 2019) |
ScheduleSettingConfig.timeoutRemind | true | Whether to enable monitoring log timeout reminders for scheduled tasks |
ClusterTimeMonitorConfig.sumCount | 3 | Total number of error analysis attempts in a single time error detection task for the cluster |
ClusterTimeMonitorConfig.permitCount | 1 | Minimum number of successful error analyses in a single time error detection task for the cluster |
ClusterTimeMonitorConfig.permitError | 10*1000 | Allowed time error value in a single detection task for the cluster, in milliseconds |
FileServerMonitorConfig.messageInterval | 1 | Notification frequency of FTP exceptions, in hours |
JarConsistenceConfig.messageInterval | 6 | Notification frequency of inconsistent JAR file exceptions, in hours |
RedisClusterMonitorConfig.messageInterval | 6 | Notification frequency of Redis node exceptions, in hours |
RedisConfig.maxConnection | 200 | Maximum number of instances in the Redis connection pool |
RedisConfig.expireStateRemoveInterval | 5*60*1000 | Interval for deleting expired keys on the state server, in milliseconds |
RedisConfig.database | 0 | Specified Redis database |
RedisClusterConfig.maxConnection | 200 | Maximum number of instances in the Redis cluster connection pool |
FineClusterConfig.params.encrypt | false | Whether to encrypt cluster communication. The function is disabled by default. |
RemoteConnectionConfig.enableWhitelistVerify | false | Whether to enable the IP allowlist for remote design |
RemoteConnectionConfig.ipWhiteList | The field specifies the allowed IP addresses when RemoteConnectionConfig.enableWhitelistVerify is set to true. | |
CasClientConfig.serverName | Custom ServerName for the CAS SSO plugin | |
CasClientConfig.ignoreUriPathMatchers | Custom allowed requests for the CAS SSO plugin Field value: Format: Enclose each request in [""]. Wildcards are allowed in the request path. Matching logic: allowlist Example: ["/webroot/decision/t*"] | |
CookieConfig.forceSameSite | false | When the value is set to true, the SameSite=None attribute is forcibly added to cookies. |
Other Configuration Information
| Configuration Information | Database Table | Help Document |
|---|---|---|
Basic server configuration information, including system management and server configurations | FINE_CONF_ENTITY | |
Predefined Chart Style | FINE_CONF_ENTITY | |
PhantomJS configurations, including port settings | FINE_CONF_ENTITY | |
During Excel import, data is matched by position regardless of the number of matched headers | fine_conf_entity |
Previous：FineDB Table Structure
