Setup:
AlmaLinux 8 using NGINX web server
Database Server running MariaDB 10.x
PHP 8.x

Attempting to install osTicket v1.16.1
Checked that database is accessible from web server and that dbuser has correct permissions etc

Bring up installer page (after all positive checks of components)..
Fill in all correct info (triple checked) .. table prefix is cmp_, database is ticket_compliance that has been created on the database server and is accessible to the dbuser specified in the installation form.

Hit submit and receive an HTTP 500 error.

Check php-fpm logs:
[30-Apr-2022 22:09:26 UTC] PHP Fatal error: Uncaught mysqli_sql_exception: Table 'ticket_compliance.cmp_config' doesn't exist in /var/www/compliance/upload/include/mysqli.php:189
Stack trace:
#0 /var/www/compliance/upload/include/mysqli.php(189): mysqli->query()
#1 /var/www/compliance/upload/setup/inc/class.installer.php(106): db_query()
#2 /var/www/compliance/upload/setup/install.php(52): Installer->install()
#3 {main}
thrown in /var/www/compliance/upload/include/mysqli.php on line 189

When I put a print line in mysqli.php, I can see the script is trying to read data from the cmp_config table but there are no tables yet created in the database, which is obviously causing the script to fail:

"Select * from cmp_config limit 1"

The installer skipped the step of putting all the tables into the database and inserting some basic data.

How do I get this fixed?

    mudslide567

    osTicket only supports Apache/IIS out of the box. If you must use NGINX then you need to look at the many guides online or use the recipe from the official NGINX site (although I remember having to do further edits to that as well).

    Cheers.

      I have several instances running using the NGINX stack. I would be glad to share my configuration if anyone needs to do that.
      I will downgrade PHP to 8.0 and give it a try. Thanks!

      Write a Reply...