Hello,

Doing a fresh install on Ubuntu 22.10 / PHP 8.1.7 using osTicket v1.17.2
PHP modules installed include mysquli, gd, imap, xml, apcu, mbstring.
Wanted to confirm that PHP 8.1 is supported, True? Docs claim "PHP 8.x" so I assume 8.1 is now supported.

The 500 Error appears after submitting the install.php webform that has the basic info "System Settings", "Admin User". etc.

Error in apache2 log:

[Tue Nov 22 17:14:34.359547 2022] [php:error] [pid 15495] [client 10.10.100.126:26270] PHP Fatal error: Uncaught mysqli_sql_exception: Access denied for user 'root'@'localhost' in /var/www/html/support/include/mysqli.php:65\nStack trace:\n#0 /var/www/html/support/include/mysqli.php(65): mysqli->real_connect()\n#1 /var/www/html/support/setup/inc/class.installer.php(94): db_connect()\n#2 /var/www/html/support/setup/install.php(52): Installer->install()\n#3 {main}\n thrown in /var/www/html/support/include/mysqli.php on line 65, referer: http://10.10.100.122/support/setup/install.php

osticket database exists with no tables within.

Could someone point me in the right direction please?
Thanks!

    mfrlchris

    PHP 8.1 is supported yes. As for the error it looks like you setup your MySQL instance to not allow root login from localhost. You can look at the MySQL guides online on how to allow this. Or you could create a database user specific for the osticket database with full privileges to it and allow it to login from localhost.

    Cheers.

      Looks like that was the issue! Thank you very much!

      10 days later

      As a side note, I hope that instead of allowing root to log in that you created a less privileged account for access to the DB.

      Write a Reply...