Uncaught mysqli_sql_exception: No such file or directory... what do?

Chain-Devil

Hi, all.

I was trying to upgrade my copy of osTicket from 1.10 to the latest stable, 1.17.5 (figured I'd give the 1.18 branch a little more time before jumping to it), and, after a little bout trying to use the mv command to overwrite files, I switched to rsync, updated my database connection information, and was off to the races...

...except I'm just getting a white screen. Looking at the apache httpd logs, I see the following:

[php:error] [pid 22026] [client 192.168.1.21:35362] PHP Fatal error: Uncaught mysqli_sql_exception: No such file or directory in /var/www/html/osTicket/include/mysqli.php:69\nStack trace:\n#0 /var/www/html/osTicket/include/mysqli.php(69): mysqli->real_connect()\n#1 /var/www/html/osTicket/bootstrap.php(217): db_connect()\n#2 /var/www/html/osTicket/main.inc.php(28): Bootstrap::connect()\n#3 /var/www/html/osTicket/client.inc.php(21): require_once('...')\n#4 /var/www/html/osTicket/index.php(16): require('...')\n#5 {main}\n thrown in /var/www/html/osTicket/include/mysqli.php on line 69

For what it's worth, I HAVE checked out my include directory for the mysqli.php file. It's there:

# ls -laFh include/ | grep mysql
-rw-r--r--.  1 apache apache 9.6K Oct 25  2023 mysqli.php

Apache Version:

# httpd -v
Server version: Apache/2.4.6 (CentOS)
Server built:   May 30 2023 14:01:11

MariaDB Version:

# mariadb --version
mariadb: unknown option '--skip-name-resolve'
mariadb  Ver 15.1 Distrib 10.11.8-MariaDB, for Linux (x86_64) using readline 5.1

PHP Version:

# php -v
PHP 8.1.29 (cli) (built: Jun  5 2024 05:51:57) (NTS gcc x86_64)
Copyright (c) The PHP Group
Zend Engine v4.1.29, Copyright (c) Zend Technologies
    with Zend OPcache v8.1.29, Copyright (c), by Zend Technologies

KevinTheJedi

Chain-Devil

I wouldn't do rsync as it can leave old files in their place (unless you passed the --delete option). I would instead recommend copying your /path/to/osTicket/include/ost-config.php file somewhere safe, completely clearing out your osTicket directory (remove all existing osTicket files), moving all the files within the newly downloaded and unpacked upload/ folder to your osTicket directory, copy your ost-config.php file back to the include/ folder, restart the webserver (and PHP-FPM if you're running it), and retest.

Cheers.

Chain-Devil

KevinTheJedi

Wellp, sadly, neither passing the --delete option nor doing it the way you specified worked. 😐

Same error, same blank white screen. I could try re-exporting and re-importing the database? What is the recommended character set/"collation" for osTicket's database? I was using "utf8mb4_general_ci".

KevinTheJedi

Chain-Devil

Oh see if you have the mysqli extension installed and enabled for PHP 8.1 and check your config file to see if the db information is still correct.

Cheers.

Chain-Devil

KevinTheJedi

I have indeed checked my config file and verified the information in the config file is correct - even going as far as to delete the database and re-create it AND the user with the appropriate password.

And I do indeed have php-mysqli installed:

# php -m | grep mysql
mysqli
mysqlnd
pdo_mysq

Chain-Devil

I figured it out, sort of:

For some reason, setting the line define('DBHOST','localhost'); instead to define('DBHOST','127.0.0.1'); worked. I cannot for the life of me understand why, especially given that it didn't work with or WITHOUT the skip-name-resolve feature enabled in /etc/my.cnf.

Anyways. It's up and running now. Such frustrate. 😛

KevinTheJedi

Chain-Devil

You just jogged my memory. There was indeed an older thread in this forum where the same thing happened and the same fix was applied in the end. We couldn’t exactly figure out why but it’s something where PHP/MySQLi isn’t recognizing localhost for some reason. I’m sure there are explanations online somewhere but I couldn’t find a good one.

Either way, glad you resolved this!

Cheers.