Some configurations, data connections, permission settings, etc. in FineBI are saved to the corresponding configuration table of FineDB.
This article summarizes the storage location of platform-related settings, as well as the modification items that cannot be set directly on some platforms.
Most of the configuration items are stored in the FINE_CONF_ENTITY table in finedb.
For other table structures, please refer to: FineDB table structure
Classification
describe
storage table
Platform Home
Default home page, custom home page
FINE_HOMEPAGE_EXPAND
Platform catalog
FINE_AUTHORITY_OBJECT
Common settings and common help
Click on the management system, and do not enter the common settings and common help of specific subdirectories
JAR package
For most of the settings of "User Management", please refer to the User-Department Title-Role section in the FineDB table structure
field id
field value
Remark
User sync dataset
Management System - User Management - Synchronize Users
FINE_CONF_ENTITY
UserDataSetConfig.dataSetName
User Information Form
dataset name
UserDataSetConfig.departmentColumn
-1
Department column
UserDataSetConfig.departmentIdColumn
Department ID column
UserDataSetConfig.emailColumn
Mailbox column
UserDataSetConfig.mobileColumn
phone column
UserDataSetConfig.passwordColumn
2
password column
UserDataSetConfig.postColumn
Job column
UserDataSetConfig.postIdColumn
Job ID column
UserDataSetConfig.rate
43200
Sync frequency
UserDataSetConfig.realNameColumn
1
name column
UserDataSetConfig.roleColumn
role column
UserDataSetConfig.roleIdColumn
Character ID column
UserDataSetConfig.turnOn
TRUE
Whether to open
UserDataSetConfig.userIdColumn
User ID column
UserDataSetConfig.usernameColumn
0
Username column
Platform built-in authentication
Management system-user management-global configuration-authentication method-platform built-in authentication
/
There is no storage field. After the default built-in authentication is switched to other authentication methods, if you need to switch the built-in authentication, delete the fields corresponding to the other authentication methods.
ldap authentication
Management system - user management - global configuration - authentication method - ldap authentication
FSConfig.passport.ldapUrl
URL
FSConfig.passport.ldapSearchBase
search location
FSConfig.passport.retrieveLocAsBaseDN
ture/fasle
Do not use retrieval location as baseDN
FSConfig.passport.authentication
verification method
FSConfig.passport.contextFactory
connections
FSConfig.passport.referral
Referral
FSConfig.passport.principalSuffix
username suffix
FSConfig.passport.ldapSystemName
administrator name
FSConfig.passport.ldapSystemPassword
administrator password
http authentication
Management system - user management - global configuration - authentication method - http authentication
FSConfig.passport.publicKey
public key
FSConfig.passport.url
Authentication address
Email notification after adding user
Management system - user management - global configuration - email notification after adding users
UserRemindConfig.emailRemindAfterAddUser
true/false
Email notification after password reset
Management system - user management - global configuration - email notification after password reset
UserRemindConfig.emailRemindAfterResetPassword
4. Rights management
For most of the settings of "Permission Management", please refer to the section on permissions in the FineDB table structure - directory
Tiered authorization
Management System - Rights Management - Global Configuration - Hierarchical Authorization
FSConfig.authorizeAttr.gradeAuthority
Directory editing permissions
Management System - Rights Management - Global Configuration - Directory Editing Rights
FSConfig.authorizeAttr.editReportAuthority
data link control
Management System - Rights Management - Global Configuration - Data Link Control
FSConfig.authorizeAttr.dataConnectionAuthority
Login Method
Management System - Appearance Configuration - Login Method in Login Page
AppearanceConfig.loginType
0 means use the default login page to insert
Item 1 indicates that the login page is set
AppearanceConfig.loginUrl
When the login page is set
The storage location of the specific login address
login title
Management System - Appearance Configuration - Login Page - Login Title
AppearanceConfig.loginTitle
login logo
Management System - Appearance Configuration - Login Page - Login Logo
AppearanceConfig.loginLogoImgId
The cache id after the icon is uploaded
delete this line
The logon logo that has been set will be restored to the default effect.
AppearanceConfig.loginLogoImgName
Background image file name
with suffix
AppearanceConfig.images.MapCachexxxxx
Set a different background image
The cache timestamp after the field id is different
Show brand information
Management System - Appearance Configuration - Login Page - Display Brand Information
AppearanceConfig.copyrightInfoDisplay
Default true
Login theme color
Management System - Appearance Configuration - Login Page - Login Theme Color
AppearanceConfig.loginColor
login style
Management System - Appearance Configuration - Login Page - Login Style
AppearanceConfig.loginPageId
After installing the login style plugin also select
otherwise default
Background picture
Management System - Appearance Configuration - Login Page - Background Image
AppearanceConfig.loginImg
true/fasle
ture represents the back with custom settings
Scene false means use the default background image
AppearanceConfig.loginImgId
Cache id after image upload
login_bg
set different backgrounds
The cache timestamp after the graph field id is different
Platform Theme
Management System - Appearance Configuration - Platform Theme
AppearanceConfig.themeId
modern/classic
modern: flattening
classic: classic
Platform title
Management System - Appearance Configuration - Platform Style - Platform Title
AppearanceConfig.platformTitle
Platform logo
Management System - Appearance Configuration - Platform Style - Platform Logo
AppearanceConfig.logoImgId
AppearanceConfig.logoImgName
color matching
Management System - Appearance Configuration - Platform Style - Color Matching
AppearanceConfig.colorScheme
0/1/2
0 means light
Color 1 means dark
2 means custom
Frame Style - Top Header Row Style
Management system - appearance configuration - platform style - color matching - custom - top header line style
AppearanceConfig.headerType
1/2
1 means segmented back
Scene 2 represents the all-in-one background
Frame Style - Rest of Color
Management system - appearance configuration - platform style - color matching - customization - other colors
AppearanceConfig.customColors
Array, a total of 6 values, color from top to bottom
custom directory icon
Management System - Appearance Configuration - Directory Style - Directory Icon - Custom Directory Icon
AppearanceConfig.customEntryIcons
Array, custom uploaded several icons, that is, there are several values
custom cover icon
Management System - Appearance Configuration - Directory Style - Cover Icon - Custom Cover Icon
AppearanceConfig.customEntryCovers
Field ID
password
reset the supervisor password
SystemConfig.serverInit
Log in
Admin System - System Administration - Login - Single Sign-On Settings
FSConfig.loginConfig.singleLogin
FSConfig.loginConfig.singleLoginMode
1 means log in later, kick out and log in first
2 means that you have logged in and no further login is allowed
Management system - system management - login - last login information prompt
FSConfig.loginConfig.showLastLoginInfo
Management System - System Management - Login - Login Timeout Settings
FSConfig.loginConfig.loginTimeout
Unit ms
Management System - System Management - Login - Password Policy Settings - Forgot Password
PasswordStrategyConfig.forgetPassword
There is no such field initially, it will appear after opening
Management system - system management - login - password policy settings - password update regularly
PasswordStrategyConfig.passwordUpdateRegularly
PasswordStrategyConfig.updateCycle
Update cycle, unit d
PasswordStrategyConfig.daysOfUpdateEarlyWarning
Reminder x days in advance, unit d
Management System - System Management - Login - Password Policy Settings - Password Strength Settings
PasswordStrategyConfig.passwordStrengthLimit
PasswordStrategyConfig.passwordLength
password length
PasswordStrategyConfig.includeNumbers
Contains numbers, default true
PasswordStrategyConfig.includeLowercaseLetters
Contains lowercase letters, default true
PasswordStrategyConfig.includeCapitalLetters
Contains uppercase letters, default false
PasswordStrategyConfig.includeSymbol
Include symbols, default false
Management System - System Management - Login - Password Policy Settings - Modify Password Authentication Method
PasswordStrategyConfig.emailVerificationAfterChangePassword
Email verification
PasswordStrategyConfig.smsVerificationAfterChangePassword
SMS verification
Management system - system management - login - login verification settings
LoginVerificationConfig.sliderVerification
Slider validation
LoginVerificationConfig.emailVerification
Email verification (need to configure the email address first)
LoginVerificationConfig.smsVerification
SMS verification (need to configure the SMS platform first)
Management system - system management - login - login lock
LoginLockConfig.lock
Default false
LoginLockConfig.passwordErrorTimes
Number of wrong passwords
LoginLockConfig.lockingTime
lock time
LoginLockConfig.lockObject
username/ip
lock object
LoginLockConfig.lockAdmin
lock admin
conventional
Management System - System Management - General - Link to URL Center
CloudCenterConfig.online
Admin System - System Administration - General - Gzip Compression
ServerPreferenceConfig.supportGzip
Admin System - System Administration - General - Servletl Pathname
ServerConfig.servletName
Not allowed to be set to ReportServer
Management System - System Management - General - Server Side Character Encoding
ServerConfig.serverCharset
Default UTF-8
Management system - system management - general - network report root directory name
Management system-system management-general-report resource root directory name
Admin System - System Administration - General - Week starts at
ServerPreferenceConfig.firstDayOfWeek
0/1
0 means start on Sunday
Management System - System Administration - General - Resource Server
ServerPreferenceConfig.useResServer
Whether to enable resource server
ServerPreferenceConfig.resServerPath
resource server address
Management system - system management - general - websocket configuration
WebSocketConfig.usingProxy
whether to use a proxy server
WebSocketConfig.requestPorts
websocket request port
WebSocketConfig.socketContext
websocket request path
Admin System - System Administration - General - https settings
WebSocketConfig.protocol
server protocol
WebSocketConfig.keyStore
SSL key path
WebSocketConfig.keyStorePassword
SSL key password
WebSocketConfig.keyStoreFormat
Types of SSL Certificates
Print
Management System - System Management - Printing - Zero Client Printing
PrintConfig.printSettingsAttrData.noClientPrintAttr.setMarginOnPrint
Print margins can be set when printing
Management System - System Management - Printing - Local Software Printing
PrintConfig.printSettingsAttrData.nativePrintAttr.showDialog
Does printing require the print settings window
Mail
Management System - System Management - Mailbox
EmailServerConfig.mailHost
Mail Server
EmailServerConfig.encryption
Encryption
EmailServerConfig.port
port
EmailServerConfig.fromEmailAddress
sender address
EmailServerConfig.password
EmailServerConfig.user
display name
Short message
Management System - System Management - SMS
MarketConfig.smsOpen
Whether to use SMS platform
cache
Management system - system management - data set sharing - number
CacheConfig.dbConfig.maxElementsInMemory
Maximum number of shared datasets
Management system - system management - data set sharing - caching principle
CacheConfig.dbConfig.memoryStoreEvictionPolicy
LRU/LFU/FIFO
LRU: most recently used LFU: least frequently used FIFO: first in first out
Admin System - System Administration - Dataset Sharing - Maximum Idle Time
CacheConfig.dbConfig.timeToIdleSeconds
Management System - System Administration - Dataset Sharing - Maximum Time To Live
CacheConfig.dbConfig.timeToLiveSeconds
Management System - System Management - Template Cache Properties Settings - Always Reread Templates
CacheConfig.alwaysReloadTpl
For most of the configuration of "Timing Scheduling", please refer to the timing scheduling section in the FineDB table structure
Run failure reminder
Management System - User Management - Global Configuration - SMS Reminder
ScheduleSettingConfig.smsChecked
ScheduleSettingConfig.smsReceiver
receiver's address
Management System - User Management - Global Configuration - Platform Messages
ScheduleSettingConfig.platformMessageChecked
ScheduleSettingConfig.platformMessageReceiver
recipient user
Management System - User Management - Global Configuration - Email Alert
ScheduleSettingConfig.emailChecked
ScheduleSettingConfig.emailReceiver
email address
For most of the configuration of "Mobile Platform", please refer to the mobile section in the FineDB table structure
APP splash screen
Management system - mobile platform - APP splash screen
MobileConfig.phoneLaunchImgId
Mobile phone, if you want to return to the default after setting the custom picture, delete this row of data.
MobileConfig.padLaunchImgId
Tablet, if you want to return to the default after setting a custom picture, delete this row of data.
device binding
Management System - Mobile Platform - Device Binding
MobileConfig.mobileDeviceBinding
QR code configuration
Management System - Mobile Platform - QR Code Configuration
MobileConfig.qrcodeServerName
name of server
MobileConfig.qrcodeServerUrl
server address
theme
Management System - Mobile Platform - Themes
MobileConfig.activeTheme
If you have other theme plugins installed, you can choose
Table of contents
Management System - Mobile Platform - Directory - Directory Structure
MobileConfig.entryStyleId
Directory structure, if the mobile directory plug-in is installed, you can choose
Management System - Mobile Platform - Catalog - Banner
MobileConfig.banner.enabled
Management System - Mobile Platform - Catalog - Template
MobileConfig.template.enabled
MobileConfig.template.name
template name
MobileConfig.template.path
template path
MobileConfig.template.position
top/bottom
display location
Management system-mobile platform-directory-directory icon
MobileConfig.customIcons
Array to hold custom uploaded icons
other
Management System - Mobile Platform - Other - General Settings
MobileConfig.refreshable
Management system - mobile platform - other - h5 settings
Html5Config.isUsedJSBridge
Whether to use JSBridge
Html5Config.jsLink
Import the address of js
Html5Config.cssLink
Import the address of css
register
Management System - Registration Management
license.type
1/2/3/4
1. Local lic authentication
2. Private cloud certification
3. Public cloud certification
4, encryption lock authentication
license.serverAddress
Private cloud registration address
license.appKey
public cloud account
license.appSecretKey
public cloud password
memory warning
System management - intelligent operation and maintenance - memory management - intelligent early warning
PrewarningConfig.warningOpen
PrewarningConfig.messageRemindOpen
SMS notification
PrewarningConfig.phoneNumbers
Phone number
PrewarningConfig.platformMessageRemindOpen
Platform message reminder
PrewarningConfig.platformMessageReceiver
PrewarningConfig.mailRemindOpen
email alert
PrewarningConfig.mailReceivers
Smart release
System management - intelligent operation and maintenance - memory management - intelligent release
IntelliReleaseConfig.memoryAlarmOpen
Intelligent release of report memory
IntelliReleaseConfig.message
Alert prompt
Template restrictions
System Management-Intelligent Operation and Maintenance-Memory Management-Template Limit-General Limit-Single Dataset Row Limit
TempRestrictionConfig.openRowControl
TempRestrictionConfig.maxDSRowCount
Maximum number of rows in a single dataset
TempRestrictionConfig.rowOverMsg
beyond the prompt
System Management - Intelligent Operation and Maintenance - Memory Management - Template Restriction - General Restriction - Single Template Cell Placement
CustomRestrictionConfig.openCellControl
CustomRestrictionConfig.maxDSCellCount
Maximum number of cells in a single template
CustomRestrictionConfig.cellOverMsg
System Management - Intelligent Operation and Maintenance - Memory Management - Template Limit - General Limit - SQL Execution Time Limit
TempRestrictionConfig.openSQLTimeControl
TempRestrictionConfig.maxSQLTime
The maximum execution time of sql, in s
TempRestrictionConfig.sqlTimeOverMsg
System Management-Intelligent Operation and Maintenance-Memory Management-Template Limit-General Limit-Import Excel Cell Limit
TempRestrictionConfig.openExcelImportCellCountControl
TempRestrictionConfig.maxExcelImportCellCount
Import excel maximum number of cells
TempRestrictionConfig.excelImportCellCountOverMsg
System Management - Intelligent Operation and Maintenance - Memory Management - Template Limit - General Limit - Limit on the Number of Submitted Records
TempRestrictionConfig.openCommitRowCountControl
TempRestrictionConfig.openCartesianControl
Allow Cartesian product filling
TempRestrictionConfig.maxCommitRowCount
Fill in the maximum number of submitted records
TempRestrictionConfig.commitRowCountOverMsg
System Management - Intelligent Operation and Maintenance - Memory Management - Template Restriction - Individual Restrictions for Some Templates - Individually Restricted Templates
RelaxationRestrictionConfig.relaxationTemps
Arrays, template names The rest of the template individual restrictions are similar to the general restrictions , the difference is: the general restrictions are TempRestrictionConfig, and the department templates are individually restricted to RelaxationRestrictionConfig
The life cycle
System management - intelligent operation and maintenance - memory management - life cycle
LifecycleConfig.lifeCycle
Clean up sessions that have been inactive for more than x minutes
For most of the configuration, please refer to: Web Cluster Database Configurable Item Description Document
Global configuration
Management System - Intelligent Operation and Maintenance - Cluster Configuration - Global Configuration
ClusterExceptionWarningConfig.mailRemindOpen
ClusterExceptionWarningConfig.mailReceivers
ClusterExceptionWarningConfig.messageRemindOpen
ClusterExceptionWarningConfig.phoneNumbers
recipient
ClusterExceptionWarningConfig.platformMessageRemindOpen
ClusterExceptionWarningConfig.platformMessageReceiver
Cluster configuration
Management system - intelligent operation and maintenance - cluster configuration - cluster configuration
FineClusterConfig.params.protocol
TCP/UDP
parameter configuration
Management system - intelligent operation and maintenance - cluster configuration - parameter configuration
RedisConfig.tableNamePrefix
key prefix
Global Settings
Management system - intelligent operation and maintenance - backup and restore - global settings
BackupConfig.backupPath
backup path
BackupConfig.frequency
Backup frequency
BackupConfig.backupNumber
copies online
BackupConfig.backupMemory
Backup capacity
Management system - intelligent operation and maintenance - backup and restoration
BackupConfig.moduleBackup
Backed up components
Platform configuration
Management system - intelligent operation and maintenance - backup and restoration - platform configuration
BackupConfig.moduleBackup.config.autoBackup
Turn on automatic backup
BackupConfig.moduleBackup.config.moduleName
config
module name
report template
Management System - Intelligent Operation and Maintenance - Backup and Restore - Report Template
BackupConfig.moduleBackup.reportlets.autoBackup
BackupConfig.moduleBackup.reportlets.moduleName
reportlets
Management system - intelligent operation and maintenance - backup and restore - jar package
BackupConfig.moduleBackup.jar.autoBackup
BackupConfig.moduleBackup.jar.moduleName
jar
BackupConfig.moduleBackup.jar-cluster.autoBackup
BackupConfig.moduleBackup.jar-cluster.moduleName
jar-cluster
plugin
Management system - intelligent operation and maintenance - backup and restore - plug-in
BackupConfig.moduleBackup.plugins.autoBackup
BackupConfig.moduleBackup.plugins.moduleName
plugins
Update and upgrade
Management system - intelligent operation and maintenance - backup and restoration - update and upgrade
UpdatePushConfig.open
Push updates automatically
For most of the configuration of "Platform Log", please refer to the FineDB table structure
Management System - Intelligent Operation and Maintenance - Platform Log - Global Configuration
Log4jConfig.rootLevel
DEBUG/INFO/WARN/ERROR/FATAL
log level
LogCleanConfig.open
Enable log cleaning
Management system - intelligent operation and maintenance - platform log - global configuration - automatic cleaning
LogCleanConfig.autoCleanTime
Automatic cleaning every X, unit d
LogCleanConfig.autoDataTime
Keep nearly X amount of data
Management system - intelligent operation and maintenance - platform log - global configuration - manual cleaning
LogCleanConfig.manualDataTime
Management System-Intelligent Operation and Maintenance-Platform Log-Global Configuration-Cleanup Alert
LogCleanConfig.cleanWarnStarted
Turn on cleanup alerts
LogCleanConfig.triggerThreshold
Triggering conditions
LogCleanConfig.smsChecked
Turn on SMS alerts
LogCleanConfig.smsReceiver
LogCleanConfig.platformMessageChecked
Turn on platform messages
LogCleanConfig.platformMessageReceiver
array, platform recipients
LogCleanConfig.emailChecked
Turn on email alerts
LogCleanConfig.emailReceiver
Cloud operation and maintenance
Management system - intelligent operation and maintenance - cloud operation and maintenance
MarketConfig.cloudOperationMaintenanceAppKey
App ID
MarketConfig.cloudOperationMaintenanceAppName
Construction name
MarketConfig.cloudOperationMaintenanceAppSecret
application key
MarketConfig.cloudOperationMaintenanceAutoUpload
Enable automatic upload
MarketConfig.cloudOperationMaintenanceAvailable
Open cloud operation and maintenance
MarketConfig.cloudOperationMaintenanceId
Data connection management
Management System - Data Connection - Data Connection Management
ConnectionConfig.connections
array, all datalink names
ConnectionConfig.connections.XXX.url
data connection url
ConnectionConfig.connections.XXX.driver
data link driver
ConnectionConfig.connections.XXX.authentication.password
data connection password
ConnectionConfig.connections.XXX.authentication.username
data connection user
ConnectionConfig.connections.XXX.encryptPassword
Password plaintext or ciphertext, true means use ciphertext
ConnectionConfig.connections.XXX.schema
data connection mode
ConnectionConfig.connections.XXX.creator
Platform user/designer
data connection creator
ConnectionConfig.connections.XXX.database
database type
ConnectionConfig.connections.XXX.dbcpAttr.initialSize
Initialize the number of active 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 waiting time, in ms
ConnectionConfig.connections.XXX.dbcpAttr.minEvictableIdleTimeMillis
Keep idle minimum time value, in ms
ConnectionConfig.connections.XXX.dbcpAttr.minIdle
Minimum number of idle connections
ConnectionConfig.connections.XXX.dbcpAttr.numTestsPerEvictionRun
Number of idle connection recycling checks
ConnectionConfig.connections.XXX.dbcpAttr.testOnBorrow
Get pre-connect check
ConnectionConfig.connections.XXX.dbcpAttr.testOnReturn
Check before returning the connection
ConnectionConfig.connections.XXX.dbcpAttr.testWhileIdle
Enable idle collector check
ConnectionConfig.connections.XXX.dbcpAttr.timeBetweenEvictionRunsMillis
The idle collector sleep time, -1 means no sleep
ConnectionConfig.connections.XXX.dbcpAttr.validationQuery
sql validation query
ConnectionConfig.connections.XXX.newCharsetName
coding
ConnectionConfig.connections.XXX.originalCharsetName
original encoding
server dataset
Management System - Data Connection - Server Dataset
TableDataConfig.tableDatas
array, all server dataset names
Management system - data connection - server data set - sql data set
TableDataConfig.tableDatas.YYY.database.name
data connection name
TableDataConfig.tableDatas.YYY.maxMemRowCount
Maximum number of memory lines
, the default -1 so there is memory;
If the cache to disk is set, it is the specific setting value
TableDataConfig.tableDatas.YYY.pageQuerySql
paging sql
TableDataConfig.tableDatas.YYY.parameters
parameter
TableDataConfig.tableDatas.YYY.query
sql
TableDataConfig.tableDatas.YYY.share
Whether to enable shared dataset
Management System - Data Connections - Server Data Sets - Built-in Data Sets
TableDataConfig.tableDatas.YYY.columnClassList
array, type of column
TableDataConfig.tableDatas.YYY.columnNameList
array, column names
Management System - Data Connection - Server Data Set - File Data Set
TableDataConfig.tableDatas.YYY.filePath
file dataset path
TableDataConfig.tableDatas.YYY.needColumnName
Whether the first column contains the column name
Security
Management System - Security Management - Security Protection
WebSecurityConfig.cacheControlEnabled
Browser cache disabled
WebSecurityConfig.contentSecurityPolicyEnabled
CSP Content Security Policy
WebSecurityConfig.contentTypeOptionsEnabled
Content Sniffing Attack Protection
WebSecurityConfig.fileVerificationEnabled
File upload verification
WebSecurityConfig.frameOptionsEnabled
Clickjacking attack protection
WebSecurityConfig.httpHeadersEnabled
security Headers
WebSecurityConfig.remoteEvaluateLimitEnabled
Script call formula limit
WebSecurityConfig.securityCookie
Cookie enhancement, can only be opened if https is enabled
WebSecurityConfig.xssProtectionEnabled
xss attack protection
Access control
Management System - Security Management - Access Control
WebSecurityConfig.rateLimitEnabled
frequency limit
WebSecurityConfig.rateLimitUnitTime
within x seconds
WebSecurityConfig.rateLimitCount
Access allowed
SQL injection prevention
Management System - Security Management - SQL Injection Prevention
PreventSqlInjConfig.useForbidWord
Disable special keywords
PreventSqlInjConfig.useEscapeSpecialChar
escape character
PreventSqlInjConfig.customSpecialCharList
Custom added characters
PreventSqlInjConfig.selectedSpecialCharList
selected escape character
PreventSqlInjConfig.customForbidWordList
Custom added special keywords
PreventSqlInjConfig.selectedForbidWordList
Disabled special keywords
global watermark
Management System - Security Management - Global Watermark
WatermarkConfig.valid
Whether to enable global watermark
WatermarkConfig.watermarkData.textType
formula/username/ip/time
watermark content type
WatermarkConfig.watermarkData.text
When the watermark type is a formula, the specific formula content
WatermarkConfig.watermarkData.color
watermark color
WatermarkConfig.watermarkData.fontSize
watermark font size
WatermarkConfig.watermarkData.horizontalGap
Watermark Spacing - Landscape
WatermarkConfig.watermarkData.verticalGap
Watermark Spacing - Vertical
System Management - Template Authentication - Global Configuration
TemplateAuthConfig.tempAuthOpen
Whether to enable template authentication
TemplateAuthConfig.tempAuthType
0/1/2/3
Template Authentication Type
0, only authenticate username and password
1, role authorization authentication
2. Digital signature authentication
TemplateAuthConfig.digitalAuthKey
digital signature key
TemplateAuthConfig.configuredOnce
Have you ever turned on template authentication?
grouping
Data Preparation > Data List > Grouping
fine_conf_entity
GroupConfig.groupHolder.[groupId].initTime
Timestamp of group creation
GroupConfig.groupHolder.[groupId].groupName
group name
__no_group__ is ungrouped
GroupConfig.groupHolder.[groupId].packageId
The id array of the business package in the group
GroupConfig.groupHolder.[groupId].groupId
Array of grouped ids in grouping
GroupConfig.packageGroupMap.[packageId].[groupId]
The group ID corresponding to the service package ID
business package
Data Preparation > Data List > Business Package
DirectPackageConfStore.mapHolder.[packageId].createTime
Timestamp of service package creation
DirectPackageConfStore.mapHolder.[packageId].name
Business Package Name (Unicode)
DirectPackageConfStore.mapHolder.[packageId].packId
Business package ID
DirectPackageConfStore.mapHolder.[packageId].tableIds
Array of dataset IDs in the business package
DirectPackageConfStore.mapHolder.[packageId].userName
created user id
PackageTablesStore.mapHolder.[datasetid][packaegeId]
The service package ID corresponding to the dataset ID
15. Non-interface configuration items
There is no configuration interface for the foreground, but the attributes recorded in the fine_conf_entity table are shown in the following table:
key(id)
value (default)
illustrate
JAR package between 2020-04-26 to 2020-06-20:
FSConfig.loginConfig.tokenFromCookie
JAR package on 2020-06-20 and later:
ServerConfig.tokenFromCookie
false
After enabling, the token can be taken from the cookie when the background verification token is enabled, which solves the problem of background single point and cross-domain single sign-on failure under HttpOnly
WebSecurityConfig.xssProtectionHeader
1; mode=block
XSS attack protection Header X-XSS-Protection value
WebSecurityConfig.frameOptionsHeader
SAMEORIGIN
Clickjacking attack protection Header X-Frame-Options value
WebSecurityConfig.contentTypeOptionsHeader
nosniff
Content sniffing attack protection Header X-Content-Type-Options value
WebSecurityConfig.contentSecurityPolicyHeader
object-src 'self'
Value of CSP Content Security Policy Header Content-Security-Policy
WebSecurityConfig.cacheControlHeader
no-cache
Browser cache disables the value of Header Cache-Control
WebSecurityConfig.cacheControlExpiresHeader
Browser cache disables the value of Header Expires
WebSecurityConfig.cacheControlPragmaHeader
Browser cache disables the value of Header Pragma
WebSecurityConfig.hstsHeader
max-age=31536000; includeSubDomains
Value of HSTS Header Strict-Transport-Security
BackupConfig.customValueLength
65536
Backup conf table, customize value length
BackupConfig.customKeyLength
1500
Backup conf table, customize id length
FSConfig.loginConfig.forceRedirectAfterLogin
Forced jump after login, closed by default
""
Whether the platform is initialized successfully/fail
WebSocketConfig.port
[38888, 39888]
plain
If it is an https server, it needs to be set to ssl
The path where the file is stored (it is best to use an absolute path here), generally use keyStore, trustStore to be verified
The key used when applying
JKS
JKS is used by default (if it is a pfx certificate, change it to PKCS12)
WebSocketConfig.trustStore
File path (absolute path is best used here)
WebSocketConfig.trustStorePassword
Use the secret key when applying
WebSocketConfig.trustStoreFormat
/socket.io
Routing for modifying websockets
ServerConfig.cookiePath
Cookie path (It is best to configure it when deploying the project. Otherwise, the browser will store multiple cookies, and each user needs to manually clear the cookie to log in successfully.)
ScheduleSettingConfig.taskTimeout
300000
Scheduled tasks exceed the time, the default is 5 minutes
SecurityConfig.frontSeed
random 16-bit string
It is used to provide a secret key for front-end encryption. It is initially a random 16-bit string, which can be modified by yourself.
WebSecurityConfig.loginValidateStrict
false/true
It is used to restrict the use of cross-domain login interface and cas background login interface. If true is configured, these two interfaces cannot be used.
LoadConfig.minorTerribleThreshold
0.09
After minorGC, if the ratio of the rate of objects promoted to the old age to the EDEN area exceeds this value, it is considered an ultra-high load
LoadConfig.minorHighThreshold
0.06
After minorGC, the ratio of the rate of objects promoted to the old age to the EDEN area exceeds this value, which is considered a high load
LoadConfig.minorMidThreshold
0.03
After minorGC, the ratio of the rate of objects promoted to the old age to the EDEN area exceeds this value, which is considered a medium load
LoadConfig.majorExtremeTerribleThreshold
0.95
After majorGC, if the ratio of the size of the objects remaining in the old age to the size of the old age exceeds this value, it is considered a limit load.
LoadConfig.majorTerribleThreshold
0.85
After majorGC, if the ratio of the size of the objects remaining in the old age to the size of the old age exceeds this value, it is considered an ultra-high load.
LoadConfig.majorHighThreshold
0.7
After majorGC, if the ratio of the size of the objects remaining in the old age to the size of the old age exceeds this value, it is considered a high load.
IntelliReleaseConfig.highInterruptRate
0.8
When killing a session in a small area for the first time, when the number of session grids exceeds 80% of the template limit grid value, the session will be killed
IntelliReleaseConfig.highInterruptAgainRate
0.6
During the second small-scale kill session, the session will be killed when the number of sessions exceeds 60% of the template limit.
IntelliReleaseConfig.highKillRate
0.1
After the first small-scale killing session, the second small-scale killing session will be performed when the number of killed sessions is less than 10%
IntelliReleaseConfig.terribleInterruptRate
When the first large-scale kill session, the number of session grids exceeds 60% of the template limit grid value and is killed
IntelliReleaseConfig.terribleInterruptAgainRate
0.4
During the second large-scale kill session, the session will be killed when the number of sessions exceeds 40% of the template limit.
IntelliReleaseConfig.terribleKillRate
0.2
After the first mass killing session, the second mass killing session will be performed when the number of killed sessions is less than 20%
IntelliReleaseConfig.waitInLineRate
0.9
When the load is high, this template has a 90% probability of queuing
IntelliReleaseConfig.defaultCellCount
1000000
When the size range kills the session, if the template grid limit is turned off, the default grid number is 1_000_000
IntelliReleaseConfig.releaseSessionInterval
20
Within 20s, if the load state after this gc is lower than or equal to the last gc state, no large/small range killing session will be performed
WebSecurityConfig.fileInspectorType
After the file verification of security management is enabled, use this configuration file to upload the verification type
0-(Comprehensive, the suffix is not allowed in the whitelist, otherwise the header is checked) 1-(Whitelist, the suffix is in the whitelist and the header is matched) 2-(Blacklist, the suffix is not in the blacklist, it is released)
QuartzConfig.threadCount
100
The maximum number of threads of the timing scheduling module (supported in versions after August 16)
QuartzConfig.maxConnections
50
The maximum number of connections for the timing scheduling module (supported by versions after August 16)
ScheduleSettingConfig.timeoutRemind
true
Whether to enable the monitoring log timeout reminder for the scheduled task
ClusterTimeMonitorConfig.sumCount
3
The total number of attempts at error analysis in the cluster single time error detection task
ClusterTimeMonitorConfig.permitCount
In the cluster single time error detection task, the minimum number of successes in multiple error analysis
ClusterTimeMonitorConfig.permitError
10*1000
In the cluster single time error detection task, the allowable time error value, in ms
FileServerMonitorConfig.messageInterval
FTP exception message notification frequency, unit h
JarConsistenceConfig.messageInterval
6
Jar inconsistency exception message notification frequency, unit h
RedisClusterMonitorConfig.messageInterval
Redis node abnormal message notification frequency, unit h
RedisConfig.maxConnection
200
Redis connection pool maximum total number of instances
RedisConfig.expireStateRemoveInterval
5*60*1000
Status server expiration key deletion interval, in ms
RedisConfig.database
Redis specified database
RedisClusterConfig.maxConnection
Redis Cluster connection pool maximum total number of instances
FineClusterConfig.params.encrypt
Cluster communication encryption switch, the default is false
configuration information
Database Table
Documentation
Basic server configuration, save some information in the management platform and server configuration
Server basic configuration
Custom function settings
Custom function configuration
Control configuration, which saves the information of predefined controls and custom controls defined in control management
fine_conf_xmlentity
Global control configuration
Chart predefined styles
Chart predefined style configuration
Some ports and other configurations of phantomjs
phantomjs configuration
Excel import, data is matched based on location regardless of the number of matching headings
Does not match by title
In version 5.1.11, three new parameters are added, which can intercept the query of the spider engine, so as to avoid the continuous high concurrency causing the exhaustion of http threads and blocking non-spider queries.
Note: After the parameters shown in the table below are modified, it needs to be restarted to take effect.
id
value
DistributedOptimizationConfig.spiderConfig.spider_engine_queue_size_limit
Default is -1
meaning:
The queue size of the spider engine processing queries and waiting for the query. If the incoming query exceeds, it will wait for a period of time. If the timeout still does not enter the queue, it will be rejected and an error will be reported.
-1 means infinity, i.e. will not reject
suggested value:
200, that is, the spider processes or waits to process up to 200 queries
DistributedOptimizationConfig.spiderConfig.spider_engine_queue_try_wait
Default is 500
When the request cannot enter the waiting queue, spin for a period of time (unit: milliseconds), and try to enter continuously
The meaning of this parameter is to balance the experience of short query + high concurrency. If the Spider engine is busy due to a large number of short queries, setting this time to retry can reduce the probability of rejection
500, that is, a request will try to enter the queue continuously within 500 milliseconds, and an error will be reported if it is still rejected after the timeout
DistributedOptimizationConfig.spiderConfig.spider_engine_queue_refuse_msg
Default is: spider engine overload
When the request is finally rejected with an error, the displayed copy
User customizable
滑鼠選中內容，快速回饋問題
滑鼠選中存在疑惑的內容，即可快速回饋問題，我們將會跟進處理。
不再提示
10s後關閉
Submitted successfully
Network busy