To change the database password, stop PageSeeder and change it in your database engine, then replace the EncryptedPassword property with LoginPassword=[new password] and start PageSeeder. PageSeeder will encrypt the password and change the property back to EncryptedPassword.

If using MySQL JDBC Connector/J v8 or higher do not include?useSSL=false in the DBURL property as it is deprecated. This defaults to sslMode=PREFERRED, meaning it tries to connect with SSL, but will use non-SSL if it's not available.

For extra security on Connector/J v8, use SSL by adding ?sslMode=REQUIRED to the custom database URL on the Database settings page. This will usually work on Linux servers with OpenSSL (Windows and Linux without OpenSSL require extra configuration of MySQL).

* 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

On some CentOS systems, you might need to create a file /etc/systemd/system/mysqld.service.d/override.conf (or limits.conf) with the contents:

[Service] 
LimitNOFILE = 8192

After creating the file reload systemd with:

$ systemctl daemon-reload

and restart mysqld and pageseeder to enable the change:

$ systemctl restart mysqld
$ service pageseeder restart

To check that the limit has been increased enter the following to find the process ID number:

ps -ef | grep mysqld

and then enter:

cat /proc/[process ID]/limits | grep files

To see how many open files a process currently has enter:

lsof -p [process ID] | wc -l

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

If you find the Too many open files error in the PageSeeder logs you can also increase its limits using the same process but substituting pageseeder for mysqld.