Hello,
After minor upgrade of icingaweb2 we got migration ERRORS. Looks likes it is checking CREATE privilege which is for mariaDB but we are using postgreSQL where this type of privilege does not exist. Can you please check if you can confirm my theory and fix it or if you can help me resolve this ERROR.
Thank you.
Operating system:
Ubuntu 20.04.6 LTS
My icnga2 version:
Icinga Web 2 Version 2.12.0
Git commit 7cd79a5c7ff66a6a67ecd55875c214ba4b2c7db4
PHP Version 7.4.3-4ubuntu2.19
Git commit date 2023-09-21
Pending Migrations
Icinga Web 3
Show all
Loaded Libraries
icinga/icinga-php-thirdparty 0.12.0
icinga/icinga-php-library 0.13.0
Loaded Modules
doc 2.12.0 Configure
idoreports 0.9.1 Configure
ipl v0.5.0 Configure
monitoring 2.12.0 Configure
pdfexport 0.9.1 Configure
reactbundle 0.9.0 Configure
reporting 0.10.0 Configure
Using postgresql version 15.4-2.pgdg20.04+1 as database. In resources.ini I have for all databases:
type = “db”
db = “pgsql”
After upgrading bellow packages to up-gradable version migration ERROR occurred.
Upgrade:
icinga-l10n/icinga-focal 1.3.0-1+ubuntu20.04 amd64 [upgradable from: 1.2.0-1.focal]
icinga-php-library/icinga-focal 0.13.0-1+ubuntu20.04 all [upgradable from: 0.12.0-1+ubuntu20.04]
icinga-php-thirdparty/icinga-focal 0.12.0-1+ubuntu20.04 all [upgradable from: 0.11.0-2.focal]
icingacli/icinga-focal 2.12.0-1+ubuntu20.04 all [upgradable from: 2.11.4-1+ubuntu20.04]
icingaweb2-common/icinga-focal 2.12.0-1+ubuntu20.04 all [upgradable from: 2.11.4-1+ubuntu20.04]
icingaweb2/icinga-focal 2.12.0-1+ubuntu20.04 all [upgradable from: 2.11.4-1+ubuntu20.04]
php-icinga/icinga-focal 2.12.0-1+ubuntu20.04 all [upgradable from: 2.11.4-1+ubuntu20.04]
Migration ERROR:
"
SQLSTATE[22023]: Invalid parameter value: 7 ERROR: unrecognized privilege type: “CREATE”, query was: SELECT has_table_privilege(:user, :table, :privilege) AS table_privilege_granted
#0 /usr/share/icinga-php/vendor/vendor/shardj/zf1-future/library/Zend/Db/Statement.php(303): Zend_Db_Statement_Pdo->_execute()
#1 /usr/share/icinga-php/vendor/vendor/shardj/zf1-future/library/Zend/Db/Adapter/Abstract.php(480): Zend_Db_Statement->execute()
#2 /usr/share/icinga-php/vendor/vendor/shardj/zf1-future/library/Zend/Db/Adapter/Pdo/Abstract.php(265): Zend_Db_Adapter_Abstract->query()
#3 /usr/share/icingaweb2/modules/setup/library/Setup/Utils/DbTool.php(505): Zend_Db_Adapter_Pdo_Abstract->query()
#4 /usr/share/icingaweb2/modules/setup/library/Setup/Utils/DbTool.php(904): Icinga\Module\Setup\Utils\DbTool->query()
#5 /usr/share/icingaweb2/modules/setup/library/Setup/Utils/DbTool.php(568): Icinga\Module\Setup\Utils\DbTool->checkPgsqlPrivileges()
#6 /usr/share/php/Icinga/Application/MigrationManager.php(338): Icinga\Module\Setup\Utils\DbTool->checkPrivileges()
#7 /usr/share/php/Icinga/Application/MigrationManager.php(228): Icinga\Application\MigrationManager->checkRequiredPrivileges()
#8 /usr/share/icingaweb2/application/controllers/MigrationsController.php(58): Icinga\Application\MigrationManager->validateDatabasePrivileges()
#9 /usr/share/icinga-php/vendor/vendor/shardj/zf1-future/library/Zend/Controller/Action.php(516): Icinga\Controllers\MigrationsController->indexAction()
#10 /usr/share/php/Icinga/Web/Controller/Dispatcher.php(76): Zend_Controller_Action->dispatch()
#11 /usr/share/icinga-php/vendor/vendor/shardj/zf1-future/library/Zend/Controller/Front.php(954): Icinga\Web\Controller\Dispatcher->dispatch()
#12 /usr/share/php/Icinga/Application/Web.php(294): Zend_Controller_Front->dispatch()
#13 /usr/share/php/Icinga/Application/webrouter.php(105): Icinga\Application\Web->dispatch()
#14 /usr/share/icingaweb2/public/index.php(4): require_once(String)
#15 {main}
SQLSTATE[22023]: Invalid parameter value: 7 ERROR: unrecognized privilege type: “CREATE”
#0 /usr/share/icinga-php/vendor/vendor/shardj/zf1-future/library/Zend/Db/Statement/Pdo.php(228): PDOStatement->execute()
#1 /usr/share/icinga-php/vendor/vendor/shardj/zf1-future/library/Zend/Db/Statement.php(303): Zend_Db_Statement_Pdo->_execute()
#2 /usr/share/icinga-php/vendor/vendor/shardj/zf1-future/library/Zend/Db/Adapter/Abstract.php(480): Zend_Db_Statement->execute()
#3 /usr/share/icinga-php/vendor/vendor/shardj/zf1-future/library/Zend/Db/Adapter/Pdo/Abstract.php(265): Zend_Db_Adapter_Abstract->query()
#4 /usr/share/icingaweb2/modules/setup/library/Setup/Utils/DbTool.php(505): Zend_Db_Adapter_Pdo_Abstract->query()
#5 /usr/share/icingaweb2/modules/setup/library/Setup/Utils/DbTool.php(904): Icinga\Module\Setup\Utils\DbTool->query()
#6 /usr/share/icingaweb2/modules/setup/library/Setup/Utils/DbTool.php(568): Icinga\Module\Setup\Utils\DbTool->checkPgsqlPrivileges()
#7 /usr/share/php/Icinga/Application/MigrationManager.php(338): Icinga\Module\Setup\Utils\DbTool->checkPrivileges()
#8 /usr/share/php/Icinga/Application/MigrationManager.php(228): Icinga\Application\MigrationManager->checkRequiredPrivileges()
#9 /usr/share/icingaweb2/application/controllers/MigrationsController.php(58): Icinga\Application\MigrationManager->validateDatabasePrivileges()
#10 /usr/share/icinga-php/vendor/vendor/shardj/zf1-future/library/Zend/Controller/Action.php(516): Icinga\Controllers\MigrationsController->indexAction()
#11 /usr/share/php/Icinga/Web/Controller/Dispatcher.php(76): Zend_Controller_Action->dispatch()
#12 /usr/share/icinga-php/vendor/vendor/shardj/zf1-future/library/Zend/Controller/Front.php(954): Icinga\Web\Controller\Dispatcher->dispatch()
#13 /usr/share/php/Icinga/Application/Web.php(294): Zend_Controller_Front->dispatch()
#14 /usr/share/php/Icinga/Application/webrouter.php(105): Icinga\Application\Web->dispatch()
#15 /usr/share/icingaweb2/public/index.php(4): require_once(String)
#16 {main}
"
If you require more information I can provide.