Freepbx version 16 upgrade fails

ozarktech · September 11, 2024, 2:16am

I upgraded from 14 to 15 with no problem and restarted it and then tried to go from 15 to 16. The cli shows this.

~]# fwconsole ma upgradeal
Exception: SQLSTATE [HY000] [2002] No such file or directory: : SQLSTATE [HY000] [2002] No such file or directory in file /var/www/html/admin/libraries/utility. functions. php on line 120

Caused by
PDOException: SQLSTATE [HY000] [2002] No such file or directory in file /var/www/html/admin/libraries/BMO/Database. class.php on line 144
Stack trace:

Exception->() /var/www/html/admin/libraries/utility. functions.php:120
die_freepbx () /var/www/html/admin/libraries/BMO/Database.class.php:150
PDOException->() /var/www/html/admin/libraries/BMO/Database. class.php:144
PDO->_construct () /var/www/html/admin/libraries/BMO/Database. class.php:144
FreePBX\Database-> construct () /var/www/html/admin/libraries/BMO/FreePBX.class.php:77
FreePBX-> construct () /var/www/html/admin/bootstrap.php:144
require_once () /etc/freepbx.conf:11
B. include_once () /var/lib/asterisk/bin/fwconsole:12

I can’t access the web gui either, I get a This Page isn’t working. pbxfqdn is currently unable to handle this request. HTTP ERROR 500.

php -v shows PHP 7.4.16

What can I do to fix this?

ozarktech · September 11, 2024, 2:57am

I restarted it from cli and now when I try to run any commands I get this:

In RedisCache.php line 135:
Function Redis::delete () is deprecated

ozarktech · September 11, 2024, 3:16am

The web gui partly loads after restarting.

kgupta · September 11, 2024, 4:26am

Can you try to download/install the framework again ?

fwconsole ma downloadinstall framework --tag=stable

ozarktech · September 11, 2024, 11:54am

No success with that either.

ozarktech · September 11, 2024, 12:00pm

I tried to restore from 15 backup and get this.

Processing zulu
NOT Resetting zulu module data
Restoring from zulu [FreePBX\modules\Zulu\Restore]
Importing Advanced Settings from zulu
Unable to locate the FreePBX BMO Class ‘Zulu’A required module might be disabled or uninstalled. Recommended steps (run from the CLI): 1) fwconsole ma install zulu 2) fwconsole ma enable zulu on line 212 of file /var/www/html/admin/libraries/BMO/Self_Helper.class.php
#0 /var/www/html/admin/libraries/BMO/Self_Helper.class.php(106): FreePBX\Self_Helper->loadObject()
#1 /var/www/html/admin/libraries/BMO/Self_Helper.class.php(37): FreePBX\Self_Helper->autoLoad()
#2 /var/www/html/admin/modules/backup/RestoreBase.php(192): FreePBX\Self_Helper->__get()
#3 /var/www/html/admin/modules/backup/RestoreBase.php(71): FreePBX\modules\Backup\RestoreBase->importKVStore()
#4 /var/www/html/admin/modules/zulu/Restore.php(8): FreePBX\modules\Backup\RestoreBase->importAll()
#5 /var/www/html/admin/modules/backup/Handlers/Restore/Common.php(141): FreePBX\modules\Zulu\Restore->runRestore()
#6 /var/www/html/admin/modules/backup/Handlers/Restore/Common.php(129): FreePBX\modules\Backup\Handlers\Restore\Common->runRestore()
#7 /var/www/html/admin/modules/backup/Handlers/Restore/Multiple.php(71): FreePBX\modules\Backup\Handlers\Restore\Common->processModule()
#8 /var/www/html/admin/modules/backup/Console/Backup.class.php(338): FreePBX\modules\Backup\Handlers\Restore\Multiple->process()
#9 /var/www/html/admin/libraries/Composer/vendor/symfony/console/Command/Command.php(255): FreePBX\Console\Command\Backup->execute()
#10 /var/www/html/admin/libraries/Composer/vendor/symfony/console/Application.php(960): Symfony\Component\Console\Command\Command->run()
#11 /var/www/html/admin/libraries/Composer/vendor/symfony/console/Application.php(255): Symfony\Component\Console\Application->doRunCommand()
#12 /var/www/html/admin/libraries/Composer/vendor/symfony/console/Application.php(148): Symfony\Component\Console\Application->doRun()
13 /var/lib/asterisk/bin/fwconsole(163): Symfony\Component\Console\Application->run()
#14 {main}
Processing restapps
Resetting restapps module data
Updating tables restapps_settings, restapps_stats…Done
SQLSTATE[42S02]: Base table or view not found: 1146 Table ‘asterisk.userman_groups’ doesn’t exist on line 302 of file /var/www/html/admin/modules/userman/functions.inc/auth/Auth.php
#0 /var/www/html/admin/modules/userman/functions.inc/auth/Auth.php(302): PDOStatement->execute()
#1 /var/www/html/admin/modules/userman/Userman.class.php(1617): FreePBX\modules\Userman\Auth\Auth->getAllGroups()
#2 /var/www/html/admin/modules/restapps/Restapps.class.php(161): FreePBX\modules\Userman->getAllGroups()
#3 /var/www/html/admin/libraries/modulefunctions.class.php(2568): FreePBX\modules\Restapps->install()
#4 /var/www/html/admin/libraries/modulefunctions.class.php(2041): module_functions->_runscripts()
#5 /var/www/html/admin/modules/backup/Handlers/FreePBXModule.php(27): module_functions->install()
#6 /var/www/html/admin/modules/backup/Handlers/FreePBXModule.php(22): FreePBX\modules\Backup\Handlers\FreePBXModule->install()
#7 /var/www/html/admin/modules/backup/Models/Restore.php(56): FreePBX\modules\Backup\Handlers\FreePBXModule->reset()
#8 /var/www/html/admin/modules/backup/Handlers/Restore/Common.php(123): FreePBX\modules\Backup\Models\Restore->reset()
#9 /var/www/html/admin/modules/backup/Handlers/Restore/Multiple.php(71): FreePBX\modules\Backup\Handlers\Restore\Common->processModule()
#10 /var/www/html/admin/modules/backup/Console/Backup.class.php(338): FreePBX\modules\Backup\Handlers\Restore\Multiple->process()
#11 /var/www/html/admin/libraries/Composer/vendor/symfony/console/Command/Command.php(255): FreePBX\Console\Command\Backup->execute()
#12 /var/www/html/admin/libraries/Composer/vendor/symfony/console/Application.php(960): Symfony\Component\Console\Command\Command->run()
13 /var/www/html/admin/libraries/Composer/vendor/symfony/console/Application.php(255): Symfony\Component\Console\Application->doRunCommand()
#14 /var/www/html/admin/libraries/Composer/vendor/symfony/console/Application.php(148): Symfony\Component\Console\Application->doRun()
#15 /var/lib/asterisk/bin/fwconsole(163): Symfony\Component\Console\Application->run()
#16 {main}
Restore processing for modules are finished successfully
Reloading… DONE
sed: -e expression #1, char 38: unknown option to `s’

In Database.class.php line 247:

SQLSTATE[42S02]: Base table or view not found: 1146 Table 'asterisk.manager
’ doesn’t exist

Da_BFG · September 12, 2024, 3:41pm

Hi. I was in the same position with the freepbx 15 to 16 upgrade. Well I am afraid it doesn’t work. the reason is the upgrade script is wrote for PHP 5.6 and freepbx 16 is wrote for PHP 7.4.

So it is technically impossible to do. In my case I restored an img of freepbx 15 on a Raspberry pi 3b. Then built freepbx 16 on Debian Bullseye with Asterisk 16 on Raspberry Pi 4b with 4gb ram and a nvme stick. will add a link as soon as i finish writing it up on my site.

ozarktech · September 12, 2024, 3:56pm

I found the same issue here Cant install FreePBX because of deprecation notice
But I’m not seeing the bug report with the instructions to fix it?

ozarktech · September 13, 2024, 12:25pm

This freepbx was hosted on cyblerlynk. I decided it wasn’t worth wasting time on since we moved the customers to an Allworx system anyway. But I wanted to test upgrades again, so I reinstalled Freepbx15 from the KVM console, restored a backup and this time I was able to upgrade succesfully to 16. FWIW, this time I used the CLI instead of GUI.

system · October 14, 2024, 12:25pm

This topic was automatically closed 31 days after the last reply. New replies are no longer allowed.