[resolved] PHP version mismatch, trouble with email

barlau

I recently upgraded from 1.9 to 1.14 (latest version). Now when an email comes in, a ticket isn't created. I turned on "fetch on auto-cron" and that will kick it into working, but I have a cron job set up to run every 2 minutes that was working previously.

These are the steps I took:

Upgrade Debian 7.9 to 8
Upgrade Debian 8 to 9
Upgrade PHP 5.6 to 7.3
Upgrade osticket 1.9 to 1.14
The information pane in osticket shows I'm running PHP 5.6. From the cli, php -v returns that I'm running 7.3.

I tried to remove php5 and after that, nothing worked, so I assume that I did something wrong with the php7.3 install?
I'm not seeing much in the way of errors, but I'm also not sure if I'm looking at the right error logs (looking mostly in /var/log/messages, /var/log/syslog and /var/log/apache2/error.log and access.log. There was a note that there's a
post that has information about the location of log files, but the search was causing errors and I couldn't hunt it down.

This was set up originally by someone other than me and I'm soooo not a linux person, but am managing to google my way through most of it. This is the last bit that I can't figure out.

Thank you,
Laura.

ntozier

Did you restart the webserver [service] after installing the new version of PHP?

How are you telling Apache which version of PHP to use? (apache2/httpd conf via addhandler? or .htaccess? or some other way that i don't know)

barlau

I restarted the server several times, so it's probably not that.

And I have no idea about which version oh PHP Apache is using. I can't find an httpd.conf file on my system. I have several .htaccess files where ostickets is installed but they don't seem to give me a clear indication that a version of php is set.

Can I run "a2dismod php5" and "a2enmod php7.3" to disable the old and enable the new? Is it as easy as that?

barlau

Oh, also -- I ran the cron job from the cli and got an error -- I assume this is a symptom of my PHP issue...

root@ticket:/# /usr/bin/php /var/www/api/cron.php
PHP Fatal error: Uncaught Error: Call to undefined function mysqli_init() in /var/www/include/mysqli.php:28
Stack trace:
#0 /var/www/bootstrap.php(194): db_connect('localhost', 'osticket', 'passsword', Array)
#1 /var/www/main.inc.php(28): Bootstrap::connect()
#2 /var/www/api/api.inc.php(23): require_once('/var/www/main.i...')
#3 /var/www/api/cron.php(17): require('/var/www/api/ap...')
#4 {main}
thrown in /var/www/include/mysqli.php on line 28
root@ticket:/#

ntozier

barlau Uncaught Error: Call to undefined function mysqli_init() i

this means that the mysqli extension isn't installed/enabled on which ever version of php is being run by default at the command line.

Try
a2dismod php5

and then
a2enmod php7.0

and then restart apache.

barlau

I disabled php5 and enabled php7.3 and get the same results from the cli for the cron job.

And when I attempt to log in via the browser, I enter credentials, it says "Authentication Required" and won't load another page and is stuck on the login page. I had this issue initially and I needed to manually put the ldap plugin into the include/plugins directory but the auth-ldap.phar plugin is the updated one.

ntozier

cli most likely uses a different php.ini than the web, so chances are the extension isn't enabled for cli.

for the unable to log in part... you could create a file in the webroot (lets call it test.php) and in it put
<?php phpinfo(); ?>

Then browse to it. (your site/test.php)
This will tell you multiple things.

if the web site is running the correct version of php
where the php.ini is located
if the new php.ini has the ldap extension enabled.

barlau

I actually found a discussion with the info.php and implemented it -- noticed exactly what you said -- that ldap wasn't installed. Installed it and now running php7.3 and able to log in without any issues.

I also noticed some other php extensions that are different between the two php versions (I ran the phpinfo for both setups and am comparing). I'm going to install the rest of the missing extensions and then see where I'm left as far as the email not working goes. Thanks for your help so far, I appreciate it!

barlau

Thanks so much for your help! Everything is sorted out now.

So, my initial issue was twofold:

I didn't set up Apache to use the right version of php (use a2dismod php5 and then a2enmod php7.3)
I didn't install all of the necessary php extensions (which I gleaned from using the info.php trick above and then also using the osticket information panel to double-check my work once I was able to log in).

This has been a huge learning experience for me and I'm grateful to folks like you who take the time to point out things that should have been obvious.

ntozier

I'm glad to hear that you got things sorted out, and that we could assist. I'll mark this thread as resolved and close it. Please feel free to start a new thread if you have another question.