osTicket Core, v1.17-rc compatible with PHP 8.1 ??

Thakiyudheen

Hi, I am using OSTicketing 1.6 , Recently I installed Snipe It on a new server, and planning to upgrade and migrate OSTicketing to the new server. Is OSTicketing Core, v1.17-rc3 compatible with PHP 8.1 ? or how can I install it on the same server??

KevinTheJedi

Thakiyudheen

Not at this time however the next RC (RC4) will have this support.

Cheers.

Thakiyudheen

Is there any way to install current version in the same server??

ramrajone

Thakiyudheen
it depends on your server setup, If your server is set up with a virtual host, you can have multiple versions on the same server

KevinTheJedi

Thakiyudheen

Just wanted to update this thread and say the new RC4 now supports PHP 8.1.x.

Cheers.

ArthurBorsboom

Hi Kevin,

PHP 8.1 combined with osTicket v1.17-rc4 does not seem to work for me yet.

I have tried both a clean install (meaning no database) and upgrade (database v1.16), but both result in unexplained database error messages.

When I downgraded PHP and all related modules from 8.1.10 to 8.0.23 the installer started working.

Below are the error messages that I noticed in the logs.
Hopefully this helps to find the cause and a potential fix.

Without database - clean install

[Tue Sep 13 10:24:42.204355 2022] [proxy_fcgi:error] [pid 2929:tid 140609058739904] [client 62.210.125.124:0] AH01071: Got error 'PHP message: PHP Fatal error:  Uncaught mysqli_sql_exception: Table 'support.ost_config' doesn't exist in /home/support/public_html/upload/include/mysqli.php:189\nStack trace:\n#0 /home/support/public_html/upload/include/mysqli.php(189): mysqli->query()\n#1 /home/support/public_html/upload/setup/inc/class.installer.php(106): db_query()\n#2 /home/support/public_html/upload/setup/install.php(52): Installer->install()\n#3 {main}\n  thrown in /home/support/public_html/upload/include/mysqli.php on line 189', referer: https://supporttest.aramgroup.com/setup/install.php

With database - try to upgrade

[Tue Sep 13 09:53:49.885265 2022] [proxy_fcgi:error] [pid 2711:tid 140609109096128] [client 62.210.125.124:0] AH01071: Got error 'PHP message: PHP Fatal error:  Uncaught mysqli_sql_exception: Unknown column 'ostversion' in 'field list' in /home/support/public_html/upload/include/mysqli.php:189\nStack trace:\n#0 /home/support/public_html/upload/include/mysqli.php(189): mysqli->query('SELECT `ostvers...', 0)\n#1 /home/support/public_html/upload/include/class.config.php(1790): db_query('SELECT `ostvers...')\n#2 /home/support/public_html/upload/include/class.ostsession.php(44): OsticketConfig::getDBVersion()\n#3 /home/support/public_html/upload/include/class.ostsession.php(132): osTicketSession->__construct(86400, true)\n#4 /home/support/public_html/upload/include/class.osticket.php(65): osTicketSession::start(86400, true)\n#5 /home/support/public_html/upload/include/class.osticket.php(662): osTicket->__construct()\n#6 /home/support/public_html/upload/main.inc.php(33): osTicket::start()\n#7 /home/support/public_html/upload/client.inc.php(21): require_once('/home/support/p...')\n#8 /home/support/public_html/upload/index.php(16): require('/...'

Please let me know if I can help out somehow.

Best regards,
Arthur Borsboom.

KevinTheJedi

ArthurBorsboom

Hmmm I was unable to replicate this. Try the install again.

Cheers.

ArthurBorsboom

I have tried the install more than 20 times. It keeps returning to the same database errors. It might be environment related, but I can't get it to work. Once I downgrade the PHP stack to 8.0 it starts working.

Do you have a suggestion where to start analyzing?

ArthurBorsboom

Arch Linux - kernel 5.19.7
Apache 2.4.54
Using PHP-FPM

PHP packages v8.0

php80 8.0.23-1
php80-apcu 5.1.21-3
php80-fpm 8.0.23-1
php80-gd 8.0.23-1
php80-imagick 3.7.0-2
php80-imap 8.0.23-1
php80-intl 8.0.23-1
php80-mysql 8.0.23-1
php80-openssl 8.0.23-1
php80-pdo 8.0.23-1
php80-tidy 8.0.23-1

PHP packages v8.1

php 8.1.10-1
php-apcu 5.1.21-3
php-fpm 8.1.10-1
php-gd 8.1.10-1
php-imagick 3.7.0-2
php-imap 8.1.10-1
php-intl 8.1.10-1
php-tidy 8.1.10-1

ArthurBorsboom

When I undo a forced database version check, which was introduced in v1.17 everything seems to work, also with PHP v8.1.

/home/support/public_html/upload/include/class.ostsession.php - line 43

osTicket v1.16.3

if (!defined('MAJOR_VERSION') && OsticketConfig::getDBVersion())
    return session_start();

osTicket v1.17-rc4

if ((!defined('MAJOR_VERSION') || $checkdbversion && OsticketConfig::getDBVersion())
    return session_start();

It prevents the call to OsticketConfig::getDBVersion() which fails, since the column does not exist (pre v1.7).

Is this any help for further debugging?

ArthurBorsboom

Related (and without the $checkdbversion):

https://github.com/osTicket/osTicket/commit/43210e3f190a0c87ffbd2c253047c81d577455d0

Looking at the source code in github, I have the feeling the downloadable package osTicket-1.17-rc.zip contains an incorrect version of class.ostsession.php

ArthurBorsboom

Source of v1.17-rc4 release with the $checkdbversion boolean, which maybe shouldn't have been there?

https://github.com/osTicket/osTicket/releases/tag/v1.17-rc4

ArthurBorsboom

Hi Kevin,

Have you had the time to look at the source code in the v1.17-rc4 release regarding the class.ostsession.php file?

I am wondering if something went wrong in the code release.

KevinTheJedi

@ArthurBorsboom

It’s an RC of course there will be bugs.

Cheers.

ArthurBorsboom

Hi Kevin,

It was not reproach; neither did I try to give the idea I was surprised by possible bugs.

I just posted this info to improve the product. I am very happy with osTicket and all the work you guys do. The minimum I can do is helping out where i can. 🙂

Let me know, if I you need something (debugging info) or anything else I can help out with.
If not, good luck with the work towards the release.

Cheers.