no such table: proactive.proactive

Symptoms

• The following error is shown after Imunify360 installation:

  no such table: proactive.proactive

• Reinstalling Imunify360 does not help

Cause

The issue is caused by the fact that that Imunify360 can't access its' own database due to SELinux. If SELinux (Security-Enhanced Linux) is enabled on the server, it is required to install the Imunify360 SELinux policy module. The policy is shipped with Imunify360 package and is located in the file:

/opt/imunify360/venv/share/imunify360/imunify360.te

Please note that in older releases this template can be placed here, so please keep this in mind when executing the commands below:

/opt/alt/python38/share/imunify360/imunify360.te

Resolution

To resolve the error:

1. Apply the policies using the following commands:

   # checkmodule -M -m -o /var/imunify360/imunify360.mod /opt/imunify360/venv/share/imunify360/imunify360.te
   # semodule_package -o /var/imunify360/imunify360.pp -m /var/imunify360/imunify360.mod
   # semodule -i /var/imunify360/imunify360.pp

2. Restart Imunify 360 and proactive defense services:

   # systemctl restart imunify360
   # systemctl restart imunify360-php-daemon