error: could not find driver

[mc6650]

Hello

Sorry to post this a second time, but I need to gain access to the FusionPBX GUI. When I enter the IP address of my server (in a browser), I get the following error message: "error: could not find driver". I can SSH into fusionPBX, however I cannot gain access to the web administration. I'm hoping someone can help me out. Originally I was getting a php error message which has gone away after installing php 7.4. This all occured because I was trying to upgrade my server from Debian 10 to 11.

Thanks

 

[mc6650]

This is what I see in the browser

 

[hfoster]

If I had to guess, you might not have the php7.4-pgsql installed. Here's a dump of a vanilla Debian 11 install PHP packages:

php-common/stable,now 2:76 all [installed,automatic]
php-json/stable,now 2:7.4+76 all [installed,automatic]
php-pear/stable,now 1:1.10.12+submodules+notgz+20210212-1 all [installed,automatic]
php7.4-cli/stable-security,now 7.4.28-1+deb11u1 amd64 [installed]
php7.4-common/stable-security,now 7.4.28-1+deb11u1 amd64 [installed,automatic]
php7.4-curl/stable-security,now 7.4.28-1+deb11u1 amd64 [installed]
php7.4-dev/stable-security,now 7.4.28-1+deb11u1 amd64 [installed]
php7.4-fpm/stable-security,now 7.4.28-1+deb11u1 amd64 [installed]
php7.4-gd/stable-security,now 7.4.28-1+deb11u1 amd64 [installed]
php7.4-imap/stable-security,now 7.4.28-1+deb11u1 amd64 [installed]
php7.4-json/stable-security,now 7.4.28-1+deb11u1 amd64 [installed,automatic]
php7.4-mbstring/stable-security,now 7.4.28-1+deb11u1 amd64 [installed]
php7.4-odbc/stable-security,now 7.4.28-1+deb11u1 amd64 [installed]
php7.4-opcache/stable-security,now 7.4.28-1+deb11u1 amd64 [installed,automatic]
php7.4-pgsql/stable-security,now 7.4.28-1+deb11u1 amd64 [installed]
php7.4-readline/stable-security,now 7.4.28-1+deb11u1 amd64 [installed,automatic]
php7.4-sqlite3/stable-security,now 7.4.28-1+deb11u1 amd64 [installed]
php7.4-xml/stable-security,now 7.4.28-1+deb11u1 amd64 [installed]
php7.4/stable-security,now 7.4.28-1+deb11u1 all [installed]

If it's not that, there's probably some more clues in the log files:

/var/log/php7.4-fpm.log
/var/log/nginx/error.log

 

[mc6650]

Okay. Thanks for the update. I was trying to get another instance of this server working on another machine - with some good results - but not 100%. I will try your suggestions to see if I can get back into the administrators screen.

 

[mc6650]

Hello

It looks like there a bunch of php7.3 deinstalled and not replaced with the equivalent 7.4 version including 7.4 pgsql. I've done a sudo apt -y install php php-common, and still don't see the 7.4 pgsql. Please advise.

Here's the php packages I have

root@fusionpbx:/home/pbx2# dpkg --get-selections | grep -i php
php install
php-common install
php-fpm install
php7.3-cli deinstall
php7.3-common deinstall
php7.3-curl deinstall
php7.3-fpm deinstall
php7.3-gd deinstall
php7.3-imap deinstall
php7.3-json deinstall
php7.3-odbc deinstall
php7.3-opcache deinstall
php7.3-pgsql deinstall
php7.3-readline deinstall
php7.3-sqlite3 deinstall
php7.3-xml deinstall
php7.4 install
php7.4-cli install
php7.4-common install
php7.4-fpm install
php7.4-json install
php7.4-opcache install
php7.4-readline install

I managed to "cat" the error logs. Can you advise me if you see any issues here. Thanks

root@fusionpbx:/home/pbx2# cat /var/log/php7.4-fpm.log
[20-Mar-2022 00:00:04] NOTICE: error log file re-opened
[22-Mar-2022 20:54:10] NOTICE: Terminating ...
[22-Mar-2022 20:54:10] NOTICE: exiting, bye-bye!
[22-Mar-2022 20:55:25] NOTICE: fpm is running, pid 587
[22-Mar-2022 20:55:25] NOTICE: ready to handle connections
[22-Mar-2022 20:55:25] NOTICE: systemd monitor interval set to 10000ms
[23-Mar-2022 08:53:24] NOTICE: Terminating ...
[23-Mar-2022 08:53:24] NOTICE: exiting, bye-bye!
[23-Mar-2022 09:12:42] NOTICE: fpm is running, pid 606
[23-Mar-2022 09:12:42] NOTICE: ready to handle connections
[23-Mar-2022 09:12:42] NOTICE: systemd monitor interval set to 10000ms
[23-Mar-2022 09:17:45] NOTICE: Terminating ...
[23-Mar-2022 09:17:45] NOTICE: exiting, bye-bye!
[23-Mar-2022 09:19:01] NOTICE: fpm is running, pid 590
[23-Mar-2022 09:19:01] NOTICE: ready to handle connections
[23-Mar-2022 09:19:01] NOTICE: systemd monitor interval set to 10000ms

root@fusionpbx:/home/pbx2# cat /var/log/nginx/error.log
2022/03/23 09:12:39 [warn] 604#604: the "ssl" directive is deprecated, use the "listen ... ssl" directive instead in /etc/nginx/sites-enabled/fusionpbx:181
2022/03/23 09:12:55 [warn] 750#750: the "ssl" directive is deprecated, use the "listen ... ssl" directive instead in /etc/nginx/sites-enabled/fusionpbx:181
2022/03/23 09:18:47 [warn] 584#584: the "ssl" directive is deprecated, use the "listen ... ssl" directive instead in /etc/nginx/sites-enabled/fusionpbx:181
2022/03/23 09:19:02 [warn] 715#715: the "ssl" directive is deprecated, use the "listen ... ssl" directive instead in /etc/nginx/sites-enabled/fusionpbx:181
2022/03/23 09:21:46 [error] 718#718: *2 open() "/var/www/fusionpbx/favicon.ico" failed (2: No such file or directory), client: 192.168.2.52, server: fusionpbx, request: "GET /favicon.ico HTTP/1.1", host: "192.168.2.25", referrer: "https://192.168.2.25/"

 

[mc6650]

Hello

I've updated the php modules and can now get back into the admin GUI via a browser. Thank you very much for your help.

root@fusionpbx:/home/pbx2# dpkg --get-selections | grep -i php
\php install
php-common install
php-fpm install
php7.3-cli deinstall
php7.3-common deinstall
php7.3-curl deinstall
php7.3-fpm deinstall
php7.3-gd deinstall
php7.3-imap deinstall
php7.3-json deinstall
php7.3-odbc deinstall
php7.3-opcache deinstall
php7.3-pgsql deinstall
php7.3-readline deinstall
php7.3-sqlite3 deinstall
php7.3-xml deinstall
php7.4 install
php7.4-bcmath install
php7.4-cli install
php7.4-common install
php7.4-curl install
php7.4-fpm install
php7.4-gd install
php7.4-imap install
php7.4-json install
php7.4-mbstring install
php7.4-mysql install
php7.4-odbc install
php7.4-opcache install
php7.4-pgsql install
php7.4-readline install
php7.4-sqlite3 install
php7.4-xml install
php7.4-zip install