Actions
Anomalie #5597
closedIcinga cassé
Start date:
09/09/2021
Due date:
% Done:
0%
Estimated time:
Description
En allant sur https://icinga.chapril.org/ on tombe sur une erreur :
SQLSTATE[42S02]: Base table or view not found: 1146 Table 'icingaweb2.icingaweb_rememberme' doesn't exist #0 /usr/share/icinga-php/ipl/vendor/ipl/sql/src/Connection.php(401): PDO->prepare(String) #1 /usr/share/icinga-php/ipl/vendor/ipl/sql/src/Connection.php(489): ipl\Sql\Connection->prepexec(String) #2 /usr/share/php/Icinga/Web/RememberMe.php(293): ipl\Sql\Connection->delete(String, Array) #3 /usr/share/php/Icinga/Web/RememberMe.php(84): Icinga\Web\RememberMe->remove(String) #4 /usr/share/icingaweb2/application/controllers/AuthenticationController.php(63): Icinga\Web\RememberMe::forget() #5 /usr/share/icingaweb2/library/vendor/Zend/Controller/Action.php(507): Icinga\Controllers\AuthenticationController->loginAction() #6 /usr/share/php/Icinga/Web/Controller/Dispatcher.php(76): Zend_Controller_Action->dispatch(String) #7 /usr/share/icingaweb2/library/vendor/Zend/Controller/Front.php(937): Icinga\Web\Controller\Dispatcher->dispatch(Object(Icinga\Web\Request), Object(Icinga\Web\Response)) #8 /usr/share/php/Icinga/Application/Web.php(304): Zend_Controller_Front->dispatch(Object(Icinga\Web\Request), Object(Icinga\Web\Response)) #9 /usr/share/php/Icinga/Application/webrouter.php(107): Icinga\Application\Web->dispatch() #10 /usr/share/icingaweb2/public/index.php(4): require_once(String) #11 {main}
Files
Updated by Romain H. about 3 years ago
J'ai exécuté les scripts d'upgrade du schéma dans :
- /usr/share/icingaweb2/etc/schema/mysql-upgrades/2.9.0.sql
- /usr/share/icingaweb2/etc/schema/mysql-upgrades/2.9.1.sql
# mysql use icingaweb2 CREATE TABLE `icingaweb_rememberme`( id int(10) unsigned NOT NULL AUTO_INCREMENT, username varchar(254) COLLATE utf8mb4_unicode_ci NOT NULL, passphrase varchar(256) NOT NULL, random_iv varchar(24) NOT NULL, http_user_agent text NOT NULL, expires_at timestamp NULL DEFAULT NULL, ctime timestamp NULL DEFAULT NULL, mtime timestamp NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (id) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin; ALTER TABLE `icingaweb_rememberme` MODIFY random_iv varchar(32) NOT NULL;
Updated by Christian P. Momon about 3 years ago
- Status changed from Nouveau to Résolu
- Assignee set to Romain H.
Je confirme que ça refonctionne bien. Bravo \o/
Updated by Quentin Gibeaux about 3 years ago
- Status changed from Résolu to Fermé
Actions