Hello,

We have published release 45 and 46 in one shot. Starting release 45, your system requires php7 and some other tweaks in your PHP and MySQL configuration. We have updated system parameters to ensure what is coming in terms of features (larger db transactions to support a new UX, dashboards, etc) will work without issues.

Please read this post in detail and let us know if you need help with any of it.

Reviewing your PHP version and PHP modules

  • You need PHP 7>
  • You need two modules that your system might not have installed: php-intl, php-simplexml

In ubuntu you can check what modules are installed by searching by running the following commands. If the command returns empty, you need to install them.

ubuntu_phpmodules

In RH7, Centos, Etc using remi repos it should look like this:

rh7php

Another way to double check modules (this works on any linux with php) is by running the command php -m which tells you what modules php has  built in.

phpm

In Redhat, etc it looks more or less the same

php-mrf

As you can see in this install i have all i need. If you want to double check if PHP 7 is installed, you can look at the modules apache has loaded:

apache_mouldes

On Redhat and its affiliates…

rh7apache

Reviewing your php.ini settings

After you conquered PHP 7 and the two additional modules we need, you need make sure your PHP ini has the following settings:

  • max_execution_time is equal to or greater than 300 seconds
  • memory_limit is equal or greater than 2048M (this is a new requirement)
  • allow_url_fopen is enabled (this is a new requirement)

Every distribution has a different php ini file. In Ubuntu systems you need to edit the file /etc/php/7.0/apache2/php.ini (the version might be different in your system). In Redhat we seem to have one php.ini file for the whole thing located at /etc/php.ini

Don’t forget to restart apache to make this settings make effect.

Reviewing your MySQL / MariaDB settings

Make sure your MySQL / MariaDB settings have the following settings:

  • max_allowed_packet = “16777216”
  • innodb_lock_wait_timeout = “200” (this is new)
  • sql_mode = “”

You will need to find the mysql configuration find on your system, in Ubuntu typically is /etc/mysql/mysql.conf.d/mysqld.cnf and in Red Hat , in any case make sure you add these statements under the [mysqld] statement

sql_mode

Restart your MySQL / MariaDB engine after you updated the configuration.

Update ACL (if needed) and clear cache

  • System / Settings / Access Lists
  • System / Settings / Clear Cache

Review system health

Once you have adjusted the system as required by this guide you can go ahead and install release 45.

After the update is completed, go to System / Settings / Health Check and review everything is “OK”, you will notice new items.

system

If you have a “Not OK” read the description of what is needed (we have updated all instructions) and make the necessary adjustments. In the case of crons, the quickest way is to run them using the browser (just call the url on the browser). Remember the daily cron must run correctly for two days in order to get the “OK” status.

Starting release 45 updates will only be possible if all heath checks are “OK” – if you try an update and the system detects that something is “NOT OK” it wont let you install it.

Regards