Configuration

Configuration manual for PageSeeder

Database properties

The database properties specify how PageSeeder connects to the database.

The values will vary depending on the location of the database engine and the JDBC Driver used.

Servlet: DBMonitor can be used to check the health of the PageSeeder server and database connection.

Database properties

PropertyDescription

DBDriver

The name of the class implementing the JDBC Driver interface

DBURL

The JDBC URL to access the database.

HostName

The name of the machine hosting the MySQL database server.

LoginPassword

The password to access the MySQL database - can only be used to reset the EncryptedPassword.

EncryptedPassword

The encrypted password to access the MySQL database.

LoginName

The login to access the MySQL database.

DatabaseName

The name of the MySQL database.

DatabaseType

The type of database used.

MaxConnections

The maximum number of connections in the database pool* - default 100.

PageSeeder uses the same properties regardless of the driver implementation.

Use the JDBC URL to define driver specific parameters.

Note

* If MaxConnections > 140 (and  <  990) it is recommended to add the following to /etc/my.cnf on Linux just under [mysqld] and restart MySQL.

max_connections=1000
open_files_limit=8192

If using CentOS append these two lines to /etc/security/limits.conf

mysql hard nofile 8192
mysql soft nofile 8192

If using CentOS also create a file /etc/systemd/system/mysqld.service.d/limits.conf with the contents:

[Service] 
 LimitNOFILE = 8192

Finally reload systemd with:

systemctl daemon-reload

and restart mysqld and pageseeder to enable the change:

systemctl restart mysqld
service pageseeder restart

Other Linux servers may require different configuration to increase the open file limit.

Implementation specific values

MySQL Connector/J

Property

Value

DBDriver

com.mysql.jdbc.Driver

DBURL

jdbc:mysql://[host]/[database]?useSSL\=false

DatabaseType

MySQL

 Derby Driver

Property

Value

DBDriver

org.apache.derby.jdbc.EmbeddedDriver

DBURL

jdbc:derby:[database];create=true

DatabaseType

Derby

Created on , last edited on