Skip to main content

 Configuration

Configuration manual for PageSeeder

Database properties

The database properties specify how PageSeeder connects to the database.

The values 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
DBDriverThe name of the class implementing the JDBC Driver interface
DBURLThe JDBC URL to access the database
HostNameThe name of the machine hosting the MySQL database server
LoginPasswordThe password to access the MySQL database – can only be used to reset the EncryptedPassword
EncryptedPasswordThe encrypted password to access the MySQL database
LoginNameThe login to access the MySQL database
DatabaseNameThe name of the MySQL database
DatabaseTypeThe type of database used
MaxConnectionsThe 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.

* If MaxConnections > 140 (and  <  990), it is recommended to add the following to /etc/my.cnf on Linux, 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 might require different configuration to increase the open file limit.

Implementation specific values

MySQL Connector/J

PropertyValue
DBDrivercom.mysql.jdbc.Driver
DBURLjdbc:mysql://[host]/[database]?useSSL\=false
DatabaseTypeMySQL

PostgeSQL driver

PropertyValue
DBDriverorg.postgresql.Driver
DBURL jdbc:postgresql://[host]/[database]
DatabaseTypePostgreSQL
Created on , last edited on