Nextcloud iocage upgrade fail: Doctrine\DBAL\Exception: Failed to connect to the database: An exception occurred in the driver: SQLSTATE[HY000] [2002]

[twsps]

I am trying to update Nextcloud instance from Nextcloud 25 to Nextcloud 28 (or 26, 27 all tried) and stuck at not able to connect to the MariaDB, but checking along with `service mysql-server status` all shows it is running fine. Any idea how to resolve this?

Some system versions:
iocage version: 13.2-RELEASE-p9
mariadb106-client-10.6.16 Multithreaded SQL database (client)

mariadb106-server-10.6.16 Multithreaded SQL database (server)

The very original guide that I set up with: guide

Here is the log when trying to perform `occ upgrade`:

Code:

root@nextcloud_v2-1:/usr/local/www/apache24/data/nextcloud # sudo -u www php occ upgrade
An unhandled exception has been thrown:
Doctrine\DBAL\Exception: Failed to connect to the database: An exception occurred in the driver: SQLSTATE[HY000] [2002] No such file or directory in /usr/local/www/apache24/data/nextcloud/lib/private/DB/Connection.php:140
Stack trace:
#0 /usr/local/www/apache24/data/nextcloud/3rdparty/doctrine/dbal/src/Connection.php(1531): OC\DB\Connection->connect()
#1 /usr/local/www/apache24/data/nextcloud/3rdparty/doctrine/dbal/src/Connection.php(1029): Doctrine\DBAL\Connection->getWrappedConnection()
#2 /usr/local/www/apache24/data/nextcloud/lib/private/DB/Connection.php(262): Doctrine\DBAL\Connection->executeQuery()
#3 /usr/local/www/apache24/data/nextcloud/3rdparty/doctrine/dbal/src/Query/QueryBuilder.php(345): OC\DB\Connection->executeQuery()
#4 /usr/local/www/apache24/data/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php(280): Doctrine\DBAL\Query\QueryBuilder->execute()
#5 /usr/local/www/apache24/data/nextcloud/lib/private/AppConfig.php(421): OC\DB\QueryBuilder\QueryBuilder->execute()
#6 /usr/local/www/apache24/data/nextcloud/lib/private/AppConfig.php(187): OC\AppConfig->loadConfigValues()
#7 /usr/local/www/apache24/data/nextcloud/lib/private/AppConfig.php(377): OC\AppConfig->getApps()
#8 /usr/local/www/apache24/data/nextcloud/lib/private/legacy/OC_App.php(976): OC\AppConfig->getValues()
#9 /usr/local/www/apache24/data/nextcloud/lib/private/Server.php(735): OC_App::getAppVersions()
#10 /usr/local/www/apache24/data/nextcloud/lib/private/AppFramework/Utility/SimpleContainer.php(171): OC\Server->OC\{closure}()
#11 /usr/local/www/apache24/data/nextcloud/3rdparty/pimple/pimple/src/Pimple/Container.php(122): OC\AppFramework\Utility\SimpleContainer->OC\AppFramework\Utility\{closure}()
#12 /usr/local/www/apache24/data/nextcloud/lib/private/AppFramework/Utility/SimpleContainer.php(138): Pimple\Container->offsetGet()
#13 /usr/local/www/apache24/data/nextcloud/lib/private/ServerContainer.php(171): OC\AppFramework\Utility\SimpleContainer->query()
#14 /usr/local/www/apache24/data/nextcloud/lib/private/AppFramework/Utility/SimpleContainer.php(65): OC\ServerContainer->query()
#15 /usr/local/www/apache24/data/nextcloud/lib/private/AppFramework/Utility/SimpleContainer.php(193): OC\AppFramework\Utility\SimpleContainer->get()
#16 /usr/local/www/apache24/data/nextcloud/lib/private/AppFramework/Utility/SimpleContainer.php(171): OC\AppFramework\Utility\SimpleContainer->OC\AppFramework\Utility\{closure}()
#17 /usr/local/www/apache24/data/nextcloud/3rdparty/pimple/pimple/src/Pimple/Container.php(118): OC\AppFramework\Utility\SimpleContainer->OC\AppFramework\Utility\{closure}()
#18 /usr/local/www/apache24/data/nextcloud/lib/private/AppFramework/Utility/SimpleContainer.php(138): Pimple\Container->offsetGet()
#19 /usr/local/www/apache24/data/nextcloud/lib/private/ServerContainer.php(171): OC\AppFramework\Utility\SimpleContainer->query()
#20 /usr/local/www/apache24/data/nextcloud/lib/private/AppFramework/Utility/SimpleContainer.php(65): OC\ServerContainer->query()
#21 /usr/local/www/apache24/data/nextcloud/lib/private/Server.php(1116): OC\AppFramework\Utility\SimpleContainer->get()
#22 /usr/local/www/apache24/data/nextcloud/lib/private/AppFramework/Utility/SimpleContainer.php(171): OC\Server->OC\{closure}()
#23 /usr/local/www/apache24/data/nextcloud/3rdparty/pimple/pimple/src/Pimple/Container.php(122): OC\AppFramework\Utility\SimpleContainer->OC\AppFramework\Utility\{closure}()
#24 /usr/local/www/apache24/data/nextcloud/lib/private/AppFramework/Utility/SimpleContainer.php(138): Pimple\Container->offsetGet()
#25 /usr/local/www/apache24/data/nextcloud/lib/private/ServerContainer.php(171): OC\AppFramework\Utility\SimpleContainer->query()
#26 /usr/local/www/apache24/data/nextcloud/lib/private/AppFramework/Utility/SimpleContainer.php(65): OC\ServerContainer->query()
#27 /usr/local/www/apache24/data/nextcloud/lib/private/Server.php(2076): OC\AppFramework\Utility\SimpleContainer->get()
#28 /usr/local/www/apache24/data/nextcloud/lib/private/Files/View.php(120): OC\Server->getLockingProvider()
#29 /usr/local/www/apache24/data/nextcloud/lib/private/Server.php(469): OC\Files\View->__construct()
#30 /usr/local/www/apache24/data/nextcloud/lib/private/AppFramework/Utility/SimpleContainer.php(171): OC\Server->OC\{closure}()
#31 /usr/local/www/apache24/data/nextcloud/3rdparty/pimple/pimple/src/Pimple/Container.php(122): OC\AppFramework\Utility\SimpleContainer->OC\AppFramework\Utility\{closure}()
#32 /usr/local/www/apache24/data/nextcloud/lib/private/AppFramework/Utility/SimpleContainer.php(138): Pimple\Container->offsetGet()
#33 /usr/local/www/apache24/data/nextcloud/lib/private/ServerContainer.php(171): OC\AppFramework\Utility\SimpleContainer->query()
#34 /usr/local/www/apache24/data/nextcloud/lib/private/AppFramework/Utility/SimpleContainer.php(65): OC\ServerContainer->query()
#35 /usr/local/www/apache24/data/nextcloud/lib/private/Server.php(1478): OC\AppFramework\Utility\SimpleContainer->get()
#36 /usr/local/www/apache24/data/nextcloud/lib/base.php(629): OC\Server->boot()
#37 /usr/local/www/apache24/data/nextcloud/lib/base.php(1171): OC::init()
#38 /usr/local/www/apache24/data/nextcloud/console.php(48): require_once('/usr/local/www/...')
#39 /usr/local/www/apache24/data/nextcloud/occ(11): require_once('/usr/local/www/...')

 

[subnetspider]

What is the installed version of PHP in your jail?
And do you see any errors in the MariaDB logs?