Shulou(Shulou.com)06/01 Report--

This article is about how to modify the configuration of the external database of O2OA. I think it is very practical, so I share it with you. I hope you can get something after reading this article. Let's take a look at it.

First, database preparation-Mysql database installation

Download and install database knowledge is not in the scope of this blog, please Baidu related technical articles to complete the installation of Mysql database. The recommended version is in Mysql5.7+.

For downloads of each version of Mysql, please see: https://blog.csdn.net/kerafan/article/details/78001849

For Mysql installation steps, please see: http://www.cnblogs.com/sshoub/p/4321640.html

Mysql modified database connections: https://blog.csdn.net/zhya910702/article/details/48372433 (it is recommended that the maximum number of connections be set to 1000)

II. O2OA configuration modification

1. Close the built-in database

Configuration file path: o2server/config/node_127.0.0.1.json

If you do not have this file, copy the node_127.0.0.1.json file from the directory o2server/config/sample/ to the o2server/config directory.

{

"enable": true

"port": null

"sslEnable": false

"logLevel": "info"

"isPrimaryCenter": true

"nodeAgentEnable": true

"application": {

"enable": true

"port": null

"sslEnable": false

"proxyHost":

"proxyPort": null

"forceRedeploy": true

"scanInterval": 5

"includes": []

"excludes": []

}

"web": {

"enable": true

"port": null

"sslEnable": false

"proxyHost":

"proxyPort": null

"forceRedeploy": true

}

"storage": {

"enable": true

"port": null

"sslEnable": false

"name":

}

"data": {# configuration related to the built-in database. You can modify the port and whether to enable it.

"enable": true, # modify the enable value to false

"tcpPort": null

"webPort": null

"includes": []

"excludes": []

}

"dumpData": {

"cron": "0 021 *?"

"size": 14

}

"dumpStorage": {

"cron": "0 021 *?"

"size": 14

}

}

2. Open and configure external database information

Configuration file path: o2server/config/externalDataSources.json

If you do not have this file, copy the externalDataSources.json file from the directory o2server/config/sample/ to the o2server/config directory.

The information of the file is shown below:

[

{

"url": "jdbc:db2://127.0.0.1:50000/X01"

"username": "db2admin"

"password": "password"

"includes": []

"excludes": []

"enable": false

}

]

Modify the url, username, password and enable information to the above Mysql related information, such as:

[

{

"url": "jdbc:mysql://127.0.0.1:3306/X01?characterEncoding=utf8&useSSL=false"

"username": "root"

"password": "12345678"

"includes": []

"excludes": []

"enable": true

}

]

The URL parameters are described as follows:

UseUnicode: whether to use Unicode character set. If the parameter characterEncoding is set to gb2312 or gbk, the value of this parameter must be set to true false 1.1g

CharacterEncoding: specifies the character encoding when useUnicode is set to true. For example, it can be set to gb2312 or gbk false 1.1g

AutoReconnect: do you want to reconnect automatically when the database connection is broken abnormally? False 1.1

AutoReconnectForPools: whether to use the reconnection policy for database connection pooling false 3.1.3

FailOverReadOnly: is the connection set to read-only after the automatic reconnection is successful? True 3.0.12

MaxReconnects: when autoReconnect is set to true, the number of retries of the connection is 31.1

InitialTimeout: the time interval between two reconnections (in seconds) when autoReconnect is set to true.

ConnectTimeout: the timeout (in milliseconds) when establishing a socket connection with the database server. 0 means never timeout, applicable to JDK 1.4 and later 0 3.0.1

SocketTimeout: the socket operation (read and write) timed out in milliseconds. 0 means never time out 0 3.0.1

After the settings are complete, restart o2server.

The above is how to modify the configuration of the external database of O2OA. The editor believes that there are some knowledge points that we may see or use in our daily work. I hope you can learn more from this article. For more details, please follow the industry information channel.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.