Project

General

Profile

Actions

Anomalie #5597

closed

Icinga cassé

Added by Christian P. Momon about 3 years ago. Updated about 3 years ago.

Status:
Fermé
Priority:
Élevée
Assignee:
Category:
Supervision
Target version:
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

20210909-icingabug.png (100 KB) 20210909-icingabug.png Christian P. Momon, 09/09/2021 09:45 PM
Actions #1

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;
Actions #2

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/

Actions #3

Updated by Quentin Gibeaux about 3 years ago

  • Status changed from Résolu to Fermé
Actions

Also available in: Atom PDF