sudden issue connecting to db

lankeeyankee

I am forced to use PHP 5.2.17 for now while we work on a site upgrade. OSTicket v 1.7.0 has been working perfectly for years until midnight UTC on Feb 28. Now, the pipe rejects all emails and in the error log I receive this:

Call to undefined function mysql_connect() in /ticket/include/mysql.php:26

My legacy site uses mysql_xxx functions everywhere and it works just fine with no errors thrown. The ticket system is under a subdirectory within the legacy site: public_html/mysite/admin/ticket/xxx

I am not sure why the ticket scripts are throwing this error, I can send emails from the ticket system and everything else is working, it's just piping no longer works.

I have not made any changes to the server, PHP, files, anything. It just suddenly stopped piping. Please let me know if further info is needed to help figure out the issue, I am unable to use our ticket system anymore.

ntozier

1.7.x has not been supported for a really long time (years).

It sounds like you do not have php-mysql installed. mysql_connect() is a PHP extension that was depreciated in PHP 5.5.0. The only time I ahve ever seen it not work is if it's not installed. On windows this is achieved by adding the extension in php.ini. On Linux this is achieved by installing the php-mysql package.

If you are running multiple versions of PHP on the same box it is possible that piping is using the wrong version as piping uses command line (cli) and usually php cli uses a separate php.ini file.

lankeeyankee

Thanks for the reply!! I know, I know, everything is very old. New main ecommerce site is actively being developed for PHP 7.3, but we're currently having to stick with PHP 5.2.17 and OSTicket 1.7.0.

I do have the extension installed, I have double checked again. And, like I said, my main ecommerce site uses a ton of mysql built-in functions without any errors. This is all on a dedicated remote server running CentOS 6 and Easy Apache 4.

I will double check PHP cli ini. I did not make any changes to anything which is what's the confusing thing.